Jump to content

olsonsp4c

Members
  • Content count

    545
  • Joined

  • Last visited

Everything posted by olsonsp4c

  1. olsonsp4c

    Copy Category

    these are good ideas - I might could work on the duplicate portion and include sub categories; however, I think it best to be able to select subcategories... the problem comes when you have multiple levels of nested subcategories... Scott
  2. olsonsp4c

    osC reCaptcha

    It wasn't made for that addon; however, I'm sure it could be adapted with some work. I don't use it personally, but you are welcome to give it a stab and let me know your progress. There would be 2 ways to figure it out. 1. Look where the current Captcha is and just replace it with the proper reCaptcha code 2. Remove all Captcha code you can find and then look through the file and compare with other addon inserts to determine where to put the reCaptcha code Scott
  3. olsonsp4c

    Live Support phpOnline

    did STS have you install a javascript function for popups with the same function name? Scott
  4. olsonsp4c

    osC reCaptcha

    unfortunately, i don't know. you could search the reCaptcha forums or wiki to see - I did briefly and couldn't find anything conclusive on how to do it... Scott
  5. olsonsp4c

    Manufacturers Dropdown Anywhere

    It exactly duplicates the dropdown in the Manufacturers InfoBox; however, without the infobox, just the dropdown. Does this make sense? Scott
  6. olsonsp4c

    Live Support phpOnline

    Unfortunately, I'm not really adept at mysql... Have you verified that your info in the config file is identical to that in your includes/configure.php file? Scott
  7. olsonsp4c

    Ajax Domain Search

    Azer, I triple checked and there are no links to my website anywhere in the code. If you follow the instructions it explains how to make it link to your website. Scott
  8. olsonsp4c

    Ajax Domain Search

    Message me for my email address or email me through the interface. I need to know what is linking to my site - can you email me a screengrab? I thought I got rid of all the references to my website, bummer. Scott
  9. olsonsp4c

    [Contribution] - USPS Methods

    I got it too, pluse this after a personal request... "We are currently aware of issue that is affecting multiple products on usps.com, webtools and shipping assistant. The error is being worked on and a correction will be put into place as soon as possible. Unfortunately, we do not have a time table of when this problem will be fixed and apologize for any inconvenience this is causing you." Scptt
  10. olsonsp4c

    Store Mode (Open | Closed | Maintenance)

    If you want the email sent successful header message to be green instead of red, just change the following in index_maintenance.php Find this: $messageStack->add('maintenance', EMAIL_SUCCESS); REPLACE with this: $messageStack->add('maintenance', EMAIL_SUCCESS, 'success'); Thanks to Glen for the suggestion. Scott
  11. olsonsp4c

    osC reCaptcha

    osC reCaptcha v1.4.1 is out with some fixes I missed, but intended for v1.4 Scott
  12. olsonsp4c

    osC reCaptcha

    osC reCaptcha v1.4 is out: http://addons.oscommerce.com/info/6306 This is a major restructuring. Since v1.3 ---------- * Added reCaptcha box formatting options A (non-integrated color scheme and placement) and B (integrated color scheme and placement) * Added instructions to add SSL security to reCaptcha * Changed language define to main english file * Added multi-language functionality * Added database entries to secure reCaptcha keys for security purposes * Fixed Customer Testimonials missing line * Added update instructions * Added additional screenshot * Restructured instructions for changes Thanks to SteveDallas for his helpful suggestions and code Let me know if I missed anything! Scott
  13. olsonsp4c

    osC reCaptcha

    I will be releasing the v1.4 of osC reCaptcha tomorrow. Check here for the announcement. I want to especially thank Glen for his great ideas. All of them will be implemented in this version and there are a few small errors that are corrected in the instructions. This new version will drastically change how this is implemented, making it more secure, flexible, and more easily integrated into your store. Scott
  14. This is the code that populates the input boxes in admin/orders.php - look for "$order->info['xxxx_track_num'];" - it grabs the input from the db query: <!-- Package Tracking Plus BEGIN --> <tr> <td><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main"><b><?php echo TABLE_HEADING_USPS_TRACKING; ?></b></td> <td class="main"><?php echo tep_draw_textbox_field('usps_track_num', '40', '40', '', $order->info['usps_track_num']); ?></td> <td class="main"><a target="_blank" href="http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=<?php echo $order->info['usps_track_num']; ?>"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td> <td class="main"><?php echo tep_draw_textbox_field('usps_track_num2', '40', '40', '', $order->info['usps_track_num2']); ?></td> <td class="main"><a target="_blank" href="http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=<?php echo $order->info['usps_track_num2']; ?>"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td> </tr> <tr> <td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><b><?php echo TABLE_HEADING_UPS_TRACKING; ?></b></td> <td class="main"><?php echo tep_draw_textbox_field('ups_track_num', '40', '40', '', $order->info['ups_track_num']); ?></td> <td><a target="_blank" href="http://wwwapps.ups.com/etracking/tracking.cgi?InquiryNumber1=<?php echo $order->info['ups_track_num']; ?>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&TypeOfInquiryNumber=T&UPS_HTML_Version=3.0&IATA=us&Lang=en&submit=Track+Package"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td> <td class="main"><?php echo tep_draw_textbox_field('ups_track_num2', '40', '40', '', $order->info['ups_track_num2']); ?></td> <td><a target="_blank" href="http://wwwapps.ups.com/etracking/tracking.cgi?InquiryNumber1=<?php echo $order->info['ups_track_num2']; ?>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&TypeOfInquiryNumber=T&UPS_HTML_Version=3.0&IATA=us&Lang=en&submit=Track+Package"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td> </tr> <tr> <td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><b><?php echo TABLE_HEADING_FEDEX_TRACKING; ?></b></td> <td class="main"><?php echo tep_draw_textbox_field('fedex_track_num', '40', '40', '', $order->info['fedex_track_num']); ?></td> <td class="main"><a target="_blank" href="http://www.fedex.com/Tracking?tracknumbers=<?php echo $order->info['fedex_track_num']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td> <td class="main"><?php echo tep_draw_textbox_field('fedex_track_num2', '40', '40', '', $order->info['fedex_track_num2']); ?></td> <td class="main"><a target="_blank" href="http://www.fedex.com/Tracking?tracknumbers=<?php echo $order->info['fedex_track_num2']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td> </tr> <tr> <td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><b><?php echo TABLE_HEADING_DHL_TRACKING; ?></b></td> <td class="main"><?php echo tep_draw_textbox_field('dhl_track_num', '40', '40', '', $order->info['dhl_track_num']); ?></td> <td class="main"><a target="_blank" href="http://track.dhl-usa.com/atrknav.asp?ShipmentNumber=<?php echo $order->info['dhl_track_num']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td> <td class="main"><?php echo tep_draw_textbox_field('dhl_track_num2', '40', '40', '', $order->info['dhl_track_num2']); ?></td> <td class="main"><a target="_blank" href="http://track.dhl-usa.com/atrknav.asp?ShipmentNumber=<?php echo $order->info['dhl_track_num2']; ?>&action=track&language=english&cntry_code=us"><?php echo tep_image_button('button_track.gif', 'Track Package'); ?></a></td> </tr> <tr> <td colspan="5"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> </table></td> </tr> <!-- Package Tracking Plus END --> if this code is correct then you are missing the db query in admin/includes/classes/order.php $order_query = tep_db_query("select customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, usps_track_num, usps_track_num2, ups_track_num, ups_track_num2, fedex_track_num, fedex_track_num2, dhl_track_num, dhl_track_num2, currency, currency_value, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'"); or this in the same file: FIND this: $this->info = array('currency' => $order['currency'], 'currency_value' => $order['currency_value'], 'payment_method' => $order['payment_method'], 'cc_type' => $order['cc_type'], 'cc_owner' => $order['cc_owner'], 'cc_number' => $order['cc_number'], 'cc_expires' => $order['cc_expires'], 'date_purchased' => $order['date_purchased'], 'orders_status' => $order_status['orders_status_name'], 'last_modified' => $order['last_modified'], 'total' => strip_tags($order_total['text']), 'shipping_method' => ((substr($shipping_method['title'], -1) == ':') ? substr(strip_tags($shipping_method['title']), 0, -1) : strip_tags($shipping_method['title']))); INSERT this ABOVE the last line: //Package Tracking Plus BEGIN 'usps_track_num' => $order['usps_track_num'], 'usps_track_num2' => $order['usps_track_num2'], 'ups_track_num' => $order['ups_track_num'], 'ups_track_num2' => $order['ups_track_num2'], 'fedex_track_num' => $order['fedex_track_num'], 'fedex_track_num2' => $order['fedex_track_num2'], 'dhl_track_num' => $order['dhl_track_num'], 'dhl_track_num2' => $order['dhl_track_num2'], //Package Tracking Plus END MAKE sure that EVERY line EXCEPT the last one ends with a "," (comma) while the LAST line ends with ");" It would be safest to have your last line still be: 'shipping_method' => ((substr($shipping_method['title'], -1) == ':') ? substr(strip_tags($shipping_method['title']), 0, -1) : strip_tags($shipping_method['title']))); Scott
  15. olsonsp4c

    Customer Testimonials v1.0

    I don't know if this is possible easily, for sure it would take some serious hacking and I am not very familiar with either. I just installed a bunch of mods on CRE loaded for a client and it was a nightmare searching through the maze of code. Sorry I can't help... Scott
  16. olsonsp4c

    Live Support phpOnline

    Marios, i'm not familiar with that addon - my guess is that your going to have to mod the infobox to pull from the correct directory, the one specified in the install doc for additonal images, but it is just a guess. Scott
  17. olsonsp4c

    Live Support phpOnline

    well, unfortunately, i don't know because it works on my store. wish i knew how to fix it for you... Scott
  18. olsonsp4c

    Automatic Stock Notification

    Hello, there is not supposed to be any visible change in the catalog when stock is 0. When the stock is 0, this addon waits for you to change the stock to MORE than 0, then it notifies the customer that the product is in stock by email. It is all transparent. If you installed the mod that deletes the customer from the notification table, if you are that customer and you are logged in, the button on the product page will change from "Remove Notification" to a normal "Notification" button. Scott
  19. olsonsp4c

    Offical Google Checkout module for osCommerce Support Thread

    Think i found the error in response_handler.php - someone else verify please: Find this: for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { // Stock Update - Joao Correia if (STOCK_LIMITED == 'true') { 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 $products_attributes = @$order->products[$i]['attributes']; 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 { $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'] - $order->products[$i]['qty']; } 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']) . "'"); } } } Replace with this: for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { // Stock Update - Joao Correia if (STOCK_LIMITED == 'true') { 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 $products_attributes = @$order->products[$i]['attributes']; 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 { $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'] - $order->products[$i]['qty']; } 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']) . "'"); } } } } Scott
  20. It is Frankc... sorry I can't look at it right now, but I will post later today. Scott
  21. olsonsp4c

    Store Mode (Open | Closed | Maintenance)

    It is just VERY basic protection - it basically only checks for an @ sign and a .com, .net, .org, etc. extension... but every little bit of protection from bots helps! Scott
  22. Frank, it is most likely in admin/orders.php or in admin/includes/classes/order.php - double check your edits in these two files... Scott
  23. olsonsp4c

    Live Support phpOnline

    did you change the link in catalog/includes/boxes/live_support.php to: $phpOnline_base_url = "https://www.your_store.com/live_support"; Scott
  24. olsonsp4c

    Live Support phpOnline

    give me until Monday and I'll get back with you. Scott
  25. olsonsp4c

    Store Mode (Open | Closed | Maintenance)

    hi, i'll look into it and get back with you - might take a day or to, if you need, feel free to go into the index_maintenance.php page and remove the section that validates the email addresses and produces the error message, then it will work just fine. Scott
×