Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by mijman2

  1. I haven't been active on this site for a long time as you can tell - I hope you've figured out what to do about this problem - if not just pm me back and i can help you out.

  2. Hi Simolingerie.

    I haven't been active on this site for a long time as you can tell - I hope you've figured out what to do about this problem - if not just pm me back and i can help you out.

  3. 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: www.ipodxtras.com Any suggestions?
  4. Hello! Download Googiespell - http://www.oscommerce.com/community/contributions,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 (http://amix.dk/projects/GoogieSpell - creator of source code that powers googiespell) Hope you enjoy this script!
  5. 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!)
  6. mijman2

    GBuy... who is working on a Mod?

    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
  7. mijman2

    [Contribution]Paypal IPN - Devosc

    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?
  8. 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.
  9. mijman2

    NewsDesk v1.48 Support

    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.
  10. mijman2

    NewsDesk v1.48 Support

    Is there an if statement in your column file?
  11. 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.
  12. 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
  13. 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
  14. 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:
  15. I am using paypalipn 2.6a i believe... Take out the part where it subtracts stock in the catalog/includes/modules/payment/paypal/catalog/checkout_update.inc Then in the catalog/includes/modules/payment/paypal/catalog/checkout_proccess.inc.php 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();
  16. great job! Now if we could figure out how to fix that small bug!
  17. 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!
  18. You guys are amazing... I have been waiting forever for this type of improvement and dedication.. My site is live, so unfortunatly I will have to wait till the updated version with -Out of Stock- Working completely (customers complain too much ;) ) -Steve
  19. stabby can you post your site please?
  20. It doesnt work... Just tried it... It doesnt subtract stock per attribute...
  21. update products set products_quantity= where products_id=157 There is something that your MySQL cant handel... I guess.... I didnt see attributes working for your 2x attributes (size and color)
  22. What i meant by more than one option is like Color -red -black Size -S -M -L I want to know if stock will display correctly here...
  23. Your shop has a few flaws... It shows that telephone number is not required but when trying to make an account you must input a telephone number at least 0 characters long... This must be an error... Try putting the value as "-1" (in case it uses a greater than function" Can you please set up a product with 2 attibutes and try to set stock values? This is what 3.0 is supposed to do that 2.3 could not.... Thanks, Steve
  24. Can you please post your website so we an see please? That is an SQL error did you run the SQL script in phpmyAdmin? I think it is buggy in 3.0 .... Might just want to go through manually and see what name corresponds with what option...
  25. mijman2

    [Contribution]Paypal IPN - Devosc

    I have gotten an older version of paypal IPN and QTPro working together if anyone is interested... PM me...