Jump to content

noppie

Members
  • Content count

    306
  • Joined

  • Last visited

Everything posted by noppie

  1. noppie

    Create PayPal Recurring Script

    I also want to use thiis for web hosting and such noppie I did as instructied and still get this errorError Detected The link you have used to enter the PayPal system is invalid. Please review the link and try again. https://www.paypal.com/cgi-bin/webscr?cmd=_...ypal_notify.php I am sure I added everything right.. and I tested the paypal_notify.php and it worked. here is my checkout_paypalipn.php
  2. noppie

    Create PayPal Recurring Script

    Error Detected The link you have used to enter the PayPal system is invalid. Please review the link and try again. I got this error above when test this script. for the llink above. this is the link never mind I know the problem
  3. noppie

    Create PayPal Recurring Script

    hello is there something different I need to run this under ms2.2 I don't see any updates on http://www.oscommerce.com/community/contri...ns,2020/page,16 am I missing something? noppie
  4. well JanZ, you did help me.. I was missing the catalog/includes/functions/password_funcs.php and if it wasn't for you I wouldn't have known so thank you so much.. you did it. noppie
  5. noppie

    Create PayPal Recurring Script

    I have one question.. did you install the family products contrubution??? and do i have to have all my products reccuring?
  6. noppie

    Create PayPal Recurring Script

    I can help test it.
  7. noppie

    Automatically send data feed to Froogle

    <?php // Start TIMER // ----------- $stimer = explode( ' ', microtime() ); $stimer = $stimer[1] + $stimer[0]; // ----------- $OutFile = "../feeds/xxxxx.txt"; //"CHANGEME-full-path-to-file-with-777-dir-and-file-permissions.fr-outfile.txt"; $destination_file = "peace.txt"; //"CHANGEME-filename-to-upload-to-froogle.txt"; $source_file = $OutFile; $imageURL = 'http://rainbowstop.com/peacem/images/'; $productURL = 'http://rainbowstop.com/peacem/product_info.php?products_id='; $already_sent = array(); $home = "localhost"; $user="xxxxxx"; $pass="xxx"; $base="rxxxxx"; $ftp_server = "hedwig.google.com"; $ftp_user_name = "xxxxxxx"; $ftp_user_pass = "xxxxxxxxxxl"; $ftp_directory = ""; // leave blank for froogle $taxRate = 0; //default = 0 (e.g. for 17.5% tax use "$taxRate = 17.5;") $taxCalc = ($taxRate/100) + 1; //Do not edit $convertCur = false; //default = false $curType = "USD"; // Converts Currency to any defined currency (eg. USD, EUR, GBP) if($convertCur) { $productURL = "http://rainbowstop.com/peacem/product_info.php?currency=" . $curType . "&products_id="; //where CURTYPE is your currency type (eg. USD, EUR, GBP) } //START Advance Optional Values //(0=False 1=True) (optional_sec must be enabled to use any options) $optional_sec = 0; $instock = 0; $shipping = 0; $lowestShipping = "4.95"; //this is not binary. $brand = 0; $upc = 0; //Not supported by default osC $manufacturer_id = 0; //Not supported by default osC $product_type = 0; $currency = 0; $default_currency = "USD"; //this is not binary. $feed_language = 0; $default_feed_language = "en"; //this is not binary. $ship_to = 0; $default_ship_to = "ALL"; //this is not binary, not supported by default osC for individual products. $ship_from = 0; $default_ship_from = "USD"; //this is not binary, not supported by default osC for individual products. //END of Advance Optional Values if (!($link=mysql_connect($home,$user,$pass))) { echo "Error when connecting itself to the data base"; exit(); } if (!mysql_select_db( $base , $link )) { echo "Error the data base does not exist"; exit(); } $sql = " SELECT concat( '" . $productURL . "' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * " . $taxCalc . ",2) AS price, CONCAT( '" . $imageURL . "' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM peacem_categories, categories_description, peacem_products, products_description, products_to_categories left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id ORDER BY products.products_id ASC "; $catInfo = " SELECT categories.categories_id AS curCatID, categories.parent_id AS parentCatID, categories_description.categories_name AS catName FROM peacem_categories, peacem_categories_description WHERE categories.categories_id = categories_description.categories_id "; function findCat($curID, $catTempPar, $catTempDes, $catIndex) { if( (isset($catTempPar[$curID])) && ($catTempPar[$curID] != 0) ) { if(isset($catIndex[$catTempPar[$curID]])) { $temp=$catIndex[$catTempPar[$curID]]; } else { $catIndex = findCat($catTempPar[$curID], $catTempPar, $catTempDes, $catIndex); $temp = $catIndex[$catTempPar[$curID]]; } } if( (isset($catTempPar[$curID])) && (isset($catTempDes[$curID])) && ($catTempPar[$curID] == 0) ) { $catIndex[$curID] = $catTempDes[$curID]; } else { $catIndex[$curID] = $temp . " > " . $catTempDes[$curID]; } return $catIndex; } $catIndex = array(); $catTempDes = array(); $catTempPar = array(); $processCat = mysql_query( $catInfo )or die( $FunctionName . ": SQL error " . mysql_error() . "| catInfo = " . htmlentities($catInfo) ); while ( $catRow = mysql_fetch_object( $processCat ) ) { $catKey = $catRow->curCatID; $catName = $catRow->catName; $catParID = $catRow->parentCatID; if($catName != "") { $catTempDes[$catKey]=$catName; $catTempPar[$catKey]=$catParID; } } foreach($catTempDes as $curID=>$des) //don't need the $des { $catIndex = findCat($curID, $catTempPar, $catTempDes, $catIndex); } $_strip_search = array( "![\t ]+$|^[\t ]+!m", // remove leading/trailing space chars '%[\r\n]+%m'); // remove CRs and newlines $_strip_replace = array( '', ''); $_cleaner_array = array(">" => "> ", "®" => "", "?" => "", "™" => "", "(tm)" => ""); if ( file_exists( $OutFile ) ) unlink( $OutFile ); $output = "product_url \t name \t description \t price \t image_url \t category \t offer_id"; //create optional section if($optional_sec == 1) { if($instock == 1) $output .= "\t instock "; if($shipping == 1) $output .= "\t shipping "; if($brand == 1) $output .= "\t brand "; if($upc == 1) $output .= "\t upc "; if($manufacturer_id == 1) $output .= "\t manufacturer_id "; if($product_type == 1) $output .= "\t product_type "; if($currency == 1) $output .= "\t currency "; if($feed_language == 1) $output .= "\t language "; if($ship_to == 1) $output .= "\t ship_to "; if($ship_from == 1) $output .= "\t ship_from "; } $output .= "\n"; $result=mysql_query( $sql )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql = " . htmlentities($sql) ); //Currency Information if($convertCur) { $sql3 = " SELECT currencies.value AS curUSD FROM currencies WHERE currencies.code = '$curType' "; $result3=mysql_query( $sql3 )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql3 = " . htmlentities($sql3) ); $row3 = mysql_fetch_object( $result3 ); } $loop_counter = 0; while( $row = mysql_fetch_object( $result ) ) { if (isset($already_sent[$row->id])) continue; // if we've sent this one, skip the rest of the while loop if( $row->prodStatus == 1 || ($optional_sec == 1 && $instock == 1) ) { if($convertCur) { $row->price = ereg_replace("[^.0-9]", "", $row->price); $row->price = $row->price * $row3->curUSD; $row->price = number_format($row->price, 2, '.', ','); } $output .= $row->product_url . "\t" . preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->name, $_cleaner_array) ) ) . "\t" . preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->description, $_cleaner_array) ) ) . "\t" . $row->price . "\t" . $row->image_url . "\t" . $catIndex[$row->prodCatID] . "\t" . $row->id; //optional values section if($optional_sec == 1) { if($instock == 1) { if($row->prodStatus == 1) { $prodStatusOut = "Y"; } else { $prodStatusOut = "N"; } $output .= " \t " . $prodStatusOut; } if($shipping == 1) $output .= " \t " . $lowestShipping; if($brand == 1) $output .= " \t " . $row->mfgName; if($upc == 1) $output .= " \t " . "Not Supported"; if($manufacturer_id == 1) $output .= " \t " . "Not Supported"; if($product_type == 1) { $catNameTemp = strtolower($catName); if($catNameTemp == "books") $productTypeOut = "book"; else if($catNameTemp == "music") $productTypeOut = "music"; else if($catNameTemp == "videos") $productTypeOut = "video"; else $productTypeOut = "other"; $output .= " \t " . $productTypeOut; } if($currency == 1) $output .= " \t " . $default_currency; if($feed_language == 1) $output .= " \t " . $default_feed_language; if($ship_to == 1) $output .= " \t " . $default_ship_to; if($ship_from == 1) $output .= " \t " . $default_ship_from; } $output .= " \n"; } $already_sent[$row->id] = 1; $loop_counter++; if ($loop_counter>750) { $fp = fopen( $OutFile , "a" ); $fout = fwrite( $fp , $output ); fclose( $fp ); $loop_counter = 0; $output = ""; } } $fp = fopen( $OutFile , "a" ); $fout = fwrite( $fp , $output ); fclose( $fp ); echo "File completed: <a href=\"" . $OutFile . "\" target=\"_blank\">" . $destination_file . "</a><br>\n"; chmod($OutFile, 0777); //Start FTP to Froogle function ftp_file( $ftpservername, $ftpusername, $ftppassword, $ftpsourcefile, $ftpdirectory, $ftpdestinationfile ) { // set up basic connection $conn_id = ftp_connect($ftpservername); if ( $conn_id == false ) { echo "FTP open connection failed to $ftpservername <BR>\n"; return false; } // login with username and password $login_result = ftp_login($conn_id, $ftpusername, $ftppassword); // check connection if ((!$conn_id) || (!$login_result)) { echo "FTP connection has failed!<BR>\n"; echo "Attempted to connect to " . $ftpservername . " for user " . $ftpusername . "<BR>\n"; return false; } else { echo "Connected to " . $ftpservername . ", for user " . $ftpusername . "<BR>\n"; } if ( strlen( $ftpdirectory ) > 0 ) { if (ftp_chdir($conn_id, $ftpdirectory )) { echo "Current directory is now: " . ftp_pwd($conn_id) . "<BR>\n"; } else { echo "Couldn't change directory on $ftpservername<BR>\n"; return false; } } ftp_pasv ( $conn_id, true ); // upload the file $upload = ftp_put( $conn_id, $ftpdestinationfile, $ftpsourcefile, FTP_ASCII ); // check upload status if (!$upload) { echo "$ftpservername: FTP upload has failed!<BR>\n"; return false; } else { echo "Uploaded " . $ftpsourcefile . " to " . $ftpservername . " as " . $ftpdestinationfile . "<BR>\n"; } // close the FTP stream ftp_close($conn_id); return true; } ftp_file( $ftp_server, $ftp_user_name, $ftp_user_pass, $source_file, $ftp_directory, $destination_file); //End FTP to Froogle // End TIMER // --------- $etimer = explode( ' ', microtime() ); $etimer = $etimer[1] + $etimer[0]; echo '<p style="margin:auto; text-align:center">'; printf( "Script timer: <b>%f</b> seconds.", ($etimer-$stimer) ); echo '</p>'; // --------- ?> the above is my froogle file.. and I know it seems i posted twice or more. but i really need help.. and I think I am getting somewhere but can't seem to go farther. all my table have prefixes for this store. and the prefix for this one is peacem and I get this error when I run the froogle in admin please please help I want to go to washington DC and need to sell some items so I can go. thank you in advance. noppie
  8. I saw a cool tshirt contribution and when I went to download it it was gone.. can anyone tell me where to find it. thank you noppie
  9. oh I see.. now I know why it was removed.. thank you verymuch jumping_rabbit
  10. noppie

    Automatically send data feed to Froogle

    I understand this the categories froogle is trying to call is not categories but peacem_categories. where do I change it. I get the error about.. that is why I am asking Thank you noppie
  11. noppie

    [Contribution]Paypal IPN - Devosc

    Ok my problem is this i set up the paypay Ipn and when i go to in the admin side under customers and click on PayPal IPN I get I seaarched througj here and couldn't find the answer thank you. I am wondering can i have this contribution in two different storess for the same paypal account? is that the problem naomi
  12. noppie

    Automatically send data feed to Froogle

    I got froogle data feed to work on one of my stores but I am having problems with a different one.. and I didn't know how to search for the answer. I have a store where the database name are like peacem_categories instead of categories peacem_products instead of products etc..... and I don't understand enoght of the calling the databate table to change it in the froogle.php $catInfo = " SELECT categories.categories_id AS curCatID, categories.parent_id AS parentCatID, categories_description.categories_name AS catName FROM categories, categories_description WHERE categories.categories_id = categories_description.categories_id Thank you very much noppie
  13. I got froogle data feed to work on one of my stores but I am having problems with a different one.. and I didn't know how to search for the answer. I have a store where the database name are like peacem_categories instead of categories peacem_products instead of products etc..... and I don't understand enoght of the calling the databate talble to change it in the froogle.php $sql = " SELECT concat( '" . $productURL . "' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * " . $taxCalc . ",2) AS price, CONCAT( '" . $imageURL . "' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM categories, categories_description, products, products_description, products_to_categories left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id ORDER BY products.products_id ASC "; $catInfo = " SELECT categories.categories_id AS curCatID, categories.parent_id AS parentCatID, categories_description.categories_name AS catName FROM categories, categories_description WHERE categories.categories_id = categories_description.categories_id Thank you very much noppie
  14. noppie

    Contrib Installer

    All downloads are gone.
  15. noppie

    Multi-Stores Multiple Shops Support

    has anyone got froogle working with different stores.. I have it working with the main store.. so i had to make sure every thing in all my stores is in the main store. and one had luck seperating it. noppie
  16. noppie

    Multi-Stores Multiple Shops Support

    to fix the error above. you have to get to your database and look for the table languages_to_stores there are two fieild there one is language_id and for english it is (1) and the next field is store_id you have to make sure that the store Id matches the store you just added. if you added a store then deleted it and re-added it then the language_to_stores may not have been changed. I just had that problem and searched this forum and couldn't find the answer so I started troubleshoot and figured it out and thought I would share what I learned. and mis-spelled words sorry it is really late. good night and I hope I help someone else noppie
  17. noppie

    [Contrib] Make An Offer

    The site I had listed is the wrong one.. the store i have this is http://ellemercantile.com and I have mulit-shop installed so what I am going to do is take a standard admin/categies.php and add you updates then I will add the multi-shtop add on.. that could be the problem/// I won't be able to do this until monday thank you for your quick response. noppie
  18. noppie

    [Contrib] Make An Offer

    I just added this and nothing shows up on the customer side.. no button and I followed the directions very carefully I don't know what other information you need to help me thank you noppie
  19. noppie

    Multi-Stores Multiple Shops Support

    Ok make sure that your first configuration table is the default one. on store two is where you need to change the name. you can call something like configuration_02 or what ever you want. I have a clothing store for first store and book store for second store and my second configuration is called configuration_books I may have spelled configuration wrong but You should get the idea.. I was confused on this also noppie
  20. noppie

    Multi-Stores Multiple Shops Support

    boy do I feel stupid, I figured out what is wrong it is the dhml menu I am using.. it goes and reads and picks up all the categories.. I should have realized that.. now I have to figure something out. noppie
  21. noppie

    Multi-Stores Multiple Shops Support

    OK I read this whole post and found one thing and tryed it and it didn't work I have my main store ellemercantile.. selling clothes and patches ok now I have a second store and I am selling hosting. in my clothing store my hosting categoires are showing up. (in the correct categories are showing up in the hosting store) and I under where you select categories and pick store I have pick the correct store. and no clothes categories are showing up in the hosting store I check the database_tables.php configuration and that is correct. my configuration.php is correct.. and the configuration in the under the the admin configuartion where it says "multi-stores" I have that all correct. Ok I read that I need to make Distributors for each store and I did that. ONe called clothes and one called host. I added the hosting I even make a seperate admin with distributor for each store at no avail I don't know what else to do. Please help. noppie default store is http://ellemercantile.com hosting is http://ellehosting.com
  22. noppie

    Multi-Stores Multiple Shops Support

    the other two stores I did when I updated the logo in the stores admin it showed up in the stores catalog side. http://ellemercantile.com and http://ellehosting.com both of those logo where set up in the admin side. under stores. naomi
  23. noppie

    Multi-Stores Multiple Shops Support

    I have three stores set up.. and I got the logo to show up in one store but not the other store I try to add it through admin and I get Error Error: Destination does not exist. and I udated the configuration file.. and the database files.. and just don't know what else.. I check the storeid in contifuration.. is there somewhere I am not looking. thank you naomi ellemercantile.com the store I am working on is books4u2.com thank you naomi
  24. noppie

    Multi-Stores Multiple Shops Support

    I am wondering this too.. I need more time in my admin before it shuts me down. thank you Naomi
×