Latest News: (loading..)


  • Content count

  • Joined

  • Last visited

About mijman2

Profile Information

  1. I like leapfrog, but the new version has made it stopped working on my website. I have gone over all the instructions three times! >_< It looks like nothing is being recorded in the database - and I have checked and reconfirmed the part in footer.php... Site: Any suggestions?
  2. To Everyone: Your welcome! I am just so releaved that I finally found a solution that worked so seamlessly. It took me forever to find one that actaully worked as advertised. Amir is amazing! To redrum: Sorry I didnt get back to you sooner (I was supposed to get emails but apparently the board didnt send me one!) The advantage to not requiring cUrl is that it allows people who dont have cUrl installed by their webhost to still use this script! Ya, nothing to complicated. -Steve (sorry for the spelling... no spell check in these forums!)
  3. This is rather greedy... osCommerce is based on the willingness of others to share their information and code with others. You are using free code to power your shop, hundreds and thousands of hours have gone into the coding of osCommerce. It is powered through contributions and donation of peoples time. You should be listing your implementation of Google Checkout as a contribution, not trying to get people to buy it. To me, that is just a wrong way to abuse open source. -Steve
  4. Hello! Download Googiespell -,4200 Googiespell Multilanguage Spell Check Script adds a spell check to your orders.php page where you communicate with your customers. It will check your spelling and make you look like a professional! Please post any questions you have here and I will try to help you the best I can. I will try to release updates along with the updates released by ATG ( - creator of source code that powers googiespell) Hope you enjoy this script!
  5. Hi. I've had this installed on my site working great for a while. Then i had to edit my oscommerce because my host turned register globals to off. So, now IPN isn't working. I tried to update it to the latest version but it seems that the file has corrputed because when I go and look at the overwrite and run ms2.2 and compare it to my site, the files in the overwrite and run are all truncated after about 8 letters. So, 2 questions: 1) Can someone post the latest (working) version of IPN again because the most recent version is corrupted. 2) Is this compatible with Registered globals off in php.ini?
  6. In your product_info.php is the code which calls the attributes. It is a dynamic query that gets the current product_id number. In the part in products_info.php, change the part where it is getting the product_id number (it will most likely look something like tep_db_query("stuff goes here... WHERE products_id=."$product_id."); Change the WHERE products_id=."$product_id." to WHERE products_id= '0'. Then go into your databases and change the universal set of attributes' products_id number (I dont know what the column is called) to 0. This should work.
  7. Your next best bet is to look in newsdesk.php. If you see an if statement in there that has something to do with what page you are on than you may try commenting it out.
  8. Is there an if statement in your column file?
  9. Not a problem! This is a wonderfully usefull contribution! -Im wondering what the before and after install - parse times for pages are. It doesnt seem like it takes too long for pages to load however.
  10. BIG Typo in Directions For New Installs Found Step 5. Download the latest binary version of GeoIP.dat from and upload it to your /catalog/admin/includes folder SHOULD BE Step 5. Download the latest binary version of GeoIP.dat from and upload it to your /catalog/includes folder
  11. Hi Everyone. I am developing the second version of my store and am thinking about implementing this system. My only concern is that it will slow down the users page load times which is something I am not willing to do (we want the best user expierence possible!) So... Is it possible for someone to tell me how much parse time this code adds to pages on the user side of their site? Thanks so much! -Steve
  12. OMG That code looks amazing! I unfortunatly have a full online running store so I cant afford bugs... Please keep us updated on how this comes along! Again I am very impressed! :thumbsup:
  13. I am using paypalipn 2.6a i believe... Take out the part where it subtracts stock in the catalog/includes/modules/payment/paypal/catalog/ Then in the catalog/includes/modules/payment/paypal/catalog/ Change line 119 (and delete the lines below it until the "//------insert customer choosen option to order-------" to the following... for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { // Stock Update - Joao Correia if (STOCK_LIMITED == 'true') { $products_attributes = $order->products[$i]['attributes']; if (DOWNLOAD_ENABLED == 'true') { $stock_query_raw = "SELECT products_quantity, pad.products_attributes_filename FROM " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCTS_ATTRIBUTES . " pa ON p.products_id=pa.products_id LEFT JOIN " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad ON pa.products_attributes_id=pad.products_attributes_id WHERE p.products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"; // Will work with only one option for downloadable products // otherwise, we have to build the query dynamically with a loop if (is_array($products_attributes)) { $stock_query_raw .= " AND pa.options_id = '" . $products_attributes[0]['option_id'] . "' AND pa.options_values_id = '" . $products_attributes[0]['value_id'] . "'"; } $stock_query = tep_db_query($stock_query_raw); } else { if (is_array($products_attributes)) { $products_stock_attributes_array = array(); For($k = 0, $n3 = sizeof($products_attributes); $k < $n3; $k++) { if ($products_attributes[$k]['special'] == 0) { $products_stock_attributes_array[] = $products_attributes[$k]['option_id'] . "-" . $products_attributes[$k]['value_id']; } } asort($products_stock_attributes_array); reset($products_stock_attributes_array); $products_stock_attributes = implode(",", $products_stock_attributes_array); $attributes_stock_query = tep_db_query("select products_stock_quantity from " . TABLE_PRODUCTS_STOCK . " where products_stock_attributes = '$products_stock_attributes' AND products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); if (tep_db_num_rows($attributes_stock_query) > 0) { $attributes_stock_values = tep_db_fetch_array($attributes_stock_query); $attributes_stock_left = $attributes_stock_values['products_stock_quantity'] - $order->products[$i]['qty']; if ($attributes_stock_left < 1) { tep_db_query("update " . TABLE_PRODUCTS_STOCK . " set products_stock_quantity = '0' where products_stock_attributes = '$products_stock_attributes' AND products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); $actual_stock_bought = $attributes_stock_values['products_stock_quantity']; } else { tep_db_query("update " . TABLE_PRODUCTS_STOCK . " set products_stock_quantity = '" . $attributes_stock_left . "' where products_stock_attributes = '$products_stock_attributes' AND products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); $actual_stock_bought = $order->products[$i]['qty']; } } else { $actual_stock_bought = $order->products[$i]['qty']; } } else { $actual_stock_bought = $order->products[$i]['qty']; } $stock_query = tep_db_query("select products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); } if (tep_db_num_rows($stock_query) > 0) { $stock_values = tep_db_fetch_array($stock_query); // do not decrement quantities if products_attributes_filename exists if ((DOWNLOAD_ENABLED != 'true') || (!$stock_values['products_attributes_filename'])) { $stock_left = $stock_values['products_quantity'] - $actual_stock_bought; } else { $stock_left = $stock_values['products_quantity']; } tep_db_query("update " . TABLE_PRODUCTS . " set products_quantity = '" . $stock_left . "' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); if (($stock_left < 1) && (STOCK_ALLOW_CHECKOUT == 'false')) { tep_db_query("update " . TABLE_PRODUCTS . " set products_status = '0' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); } } } $sql_data_array = array('orders_id' => (int)$this->orders_id, 'products_id' => tep_get_prid($order->products[$i]['id']), 'products_model' => $order->products[$i]['model'], 'products_name' => $order->products[$i]['name'], 'products_price' => $order->products[$i]['price'], 'final_price' => $order->products[$i]['final_price'], 'products_tax' => $order->products[$i]['tax'], 'products_quantity' => $order->products[$i]['qty']); tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array); $order_products_id = tep_db_insert_id();
  14. great job! Now if we could figure out how to fix that small bug!
  15. It is included with the attribute starting on version 2.3 i believe Go to the product stock page and then click on the link below that says product attribute inventory!