Jump to content
Latest News: (loading..)

RobC1962

Members
  • Content count

    43
  • Joined

  • Last visited

Profile Information

  • Real Name
    Rob Clements
  1. RobC1962

    Auto Update Currencies

    Hoping someone can help. I have been out of oscommerce and php too many years and really have lagged behind the times. I have a friend running a 2.3.4 that was running this contrib, but only realised today errors in updating currencies as it was not updatred by the folks looking after it now! PHP Version: 5.3.29 (Zend: 2.3.0) Database: MySQL 5.5.54-cll I have done the fixes on github to the relevant files - the manual update button on the currencies page works fine via the fixer server and have uploaded the latest version of this contrib so he can control it via his admin panel and I also tried it via crontab. However, it is throwing up an error: "Fatal error: Call to undefined function tep_db_fetch_array() in /home/xxxxxxxx/public_html/backend/auto_update_currencies.php on line 36" and for the life of me I cannot remember how to fix it. Any help very much appreciated as always, as I am unable to spend much time on this as I have just undergone hand surgery and it is killing me!
  2. RobC1962

    Who's Online Enhancement 1.4

    Hi All, For anyone having problems with the 'Last URL' showing as /images/infoBoxHeading2_td.gif (or anything to do with images) rather than showing the product being viewed, the fix is simple. Basically, the problem is caused by Who's Online Enhancement is looking for an image does not exist. Simply add the image where required and the contrib will show the Last URL correctly.
  3. RobC1962

    Who's Online Enhancement 1.4

    The ipinfo database is back online - enhanced whois all functioning fine now :)
  4. RobC1962

    Who's Online Enhancement 1.4

    The quickest way would be to backup and copy to local folder your 'enhanced whois online' whois_online.php file and then simply replace it with the standard copy from your osCommerce source files. The problem with ipinfodb should only be temporary and they have posted on Twitter and FaceBook the following: "Sorry everyone for the inconvenience. Our data center is having some technical issues at the moment and they are working as fast as they can to get our servers up again. In the meantime, please be patient and we will update everyone again as soon as there is any progress."
  5. RobC1962

    Who's Online Enhancement 1.4

    This error is due to the IP lookup database site being offline at present.
  6. RobC1962

    Automatically send data feed to Froogle

    Hi Jack, Many many thanks for such a rapid reply - good on you Sir! They have not said the comma will not be acceptable any more, but I think this may shed a bit of light on where they are coming from: - 'Some of the category names contain a comma (,) character. As this is used to separate the product types when there is more than one, you should place each category in double quotes. For example: "Food, Beverages & Tobacco > Food Items > Grain, Rice & Cereals" or for multiple types: "Electronics > Audio > Audio Accessories > MP3 Player Accessories","Health & Beauty > Healthcare > Biometric Monitors > Pedometers" Overall I think things are tending to get over complicated with Google, but hey ho! They call the shots and we must comply :) Many thanks again Jack. Rob.
  7. RobC1962

    Automatically send data feed to Froogle

    Hi Jack, I have been conversing with Google about getting an exemption for many of our products, as they have no UPI's etc and have noticed this little bit of info in the email ... 'Additionally, regarding the product_type attribute, please know that if you already have a system of categorisation for your items, you may use those categories. Also, any separator such as > or / may be used.' This is due to the taxonomy they use for 'categorising' products, and at present seemingly is not a 'requirement' but no doubt will be shortly I suspect. In our product_type field of the feed, the separator has always been a comma (,) and I would like to know if it is possible to change that to the required > or / ? I have had a looksee again at your splendid feeder, which has provided Sterling service over the past two years and cannot see where the separator is generated for the feed ... any help would be greatly appreciated. Thanks in advance, Rob.
  8. Hey nice work - We have added it without any problems at all to our store this evening - and have to say it is very versatile. Ideal :D We use Social Runner and I will work on including the relevant snippets of Social Runner coding to it to make it even more versatile. If you wish to have the adapted code, I will forward on to you once fully tested. Thanks for a great contrib.
  9. RobC1962

    [Contribution] oscThumb

    Have been happily using this contrib for a long time now, but just this week GoogleBot has been generating crawl errors due the the image filename encryption. How can the file encryption be turned off? I have set it to 'off' in the admin side, but all images are still remaining encrypted. Any help will be gratefully appreciated. Thanks, Rob.
  10. RobC1962

    RMA Returns error for 2.2 MS2

    Has anyone using this contrib noticed what happens to the coding on the pages when 'view source' is used on the browser? It drastically changes the header info - mine before was : - <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>normal site info here</title> <meta name="Description" content="normal description here." > <meta name="Keywords" content="normal keywords here" > <meta name="googlebot" content="normal intended info here" > to this once contrib installed: - <? /* $id author Puddled Internet - http://www.puddled.co.uk email support@puddled.co.uk osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Released under the GNU General Public License */ function tep_create_rma_value($length, $type = 'digits') { if ( ($type != 'mixed') && ($type != 'chars') && ($type != 'digits')) return false; $rand_value = ''; while (strlen($rand_value)<$length) { if ($type == 'digits') { $char = tep_rand(0,9); } else { $char = chr(tep_rand(0,255)); } if ($type == 'mixed') { if (eregi('^[a-z0-9]$', $char)) $rand_value .= $char; } elseif ($type == 'chars') { if (eregi('^[a-z]$', $char)) $rand_value .= $char; } else if ($type == 'digits') { if (ereg('^[0-9]$', $char)) $rand_value .= $char; } } return $rand_value; } ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> Anyone have any thoughts on this? Personally, I am unimpressed and have removed the contrib forthwith and will not be using it again.
  11. RobC1962

    Simple Price Break Contribution

    Back again - problem solved for putting the Simple Price Break table into a standard headed box, like those in the left and right columns... Code below for those that wish to do the same. Replacement code for instructions Step 4 in 'catalog/product_info.php' : - // Simple Price Break if (tep_not_null($product_info['products_discount'])) { if( isset($product_info['products_discount']) && strlen($product_info['products_discount'])>2 ) { $first = true; $last = false; $tab_aff = array(); echo '<tr><td><table><tr><td>'; $info_box_contents = array(); $info_box_contents[] = array('text' => BOX_HEADING_DISCOUNT ); new infoBoxHeading($info_box_contents, true, true); $info_box_contents = array(); $info_box_contents[] = array(); if( $tranche = explode( ',', $product_info['products_discount'] ) ) { $index = 0; foreach( $tranche as $cle => $trn ) if( $qty_px = explode( ':', $trn ) ) { $tab_aff[$index][0] = $qty_px[0]; $tab_aff[$index][1] = $qty_px[1]; $index++; } $new_price = tep_get_products_special_price($product_info['products_id']); for( $i=0; $i<$index; $i++) { if( $new_price > $tab_aff[$i][1] || $new_price==0 ) $products_price = $currencies->display_price($tab_aff[$i][1], tep_get_tax_rate($product_info['products_tax_class_id'])); else $products_price = '<s>' . $currencies->display_price($tab_aff[$i][1], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; if( $i==0 ) { if ( $new_price ) $products_price_1 = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; else $products_price_1 = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); $info_box_contents[] = array('align' => 'left', 'text' => sprintf( TEXT_QTY_PRIX_FIRST, $tab_aff[$i][0]-1 ) . '</td><td class="boxText">' . $products_price_1 ); if( isset($tab_aff[$i+1][0]) ) $info_box_contents[] = array('align' => 'left', 'text' => sprintf( TEXT_QTY_PRIX, $tab_aff[$i][0], $tab_aff[$i+1][0]-1 ) . '</td><td class="boxText">' . $products_price ); else $info_box_contents[] = array('align' => 'left', 'text' => sprintf( TEXT_QTY_PRIX_LAST, $tab_aff[$i][0] ) . '</td><td class="boxText">' . $products_price ); } elseif ( $i == ($index-1) ) $info_box_contents[] = array('align' => 'left', 'text' => sprintf( TEXT_QTY_PRIX_LAST, $tab_aff[$i][0] ) . '</td><td class="boxText">' . $products_price ); else $info_box_contents[] = array('align' => 'left', 'text' => sprintf( TEXT_QTY_PRIX, $tab_aff[$i][0], $tab_aff[$i+1][0]-1 ) . '</td><td class="boxText">' . $products_price ); } } new infoBox($info_box_contents); echo '</td></tr></table></td></tr>'; } ?> </td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } // Simple Price Break Code for Step 6 in "catalog/includes/languages/english/product_info.php" : - Replace define('TEXT_HEAD_REDUC_QTY', 'Prices per Quantity');" with: - define('BOX_HEADING_DISCOUNT', 'Quantity Discounts'); where = 'Quantity Discounts' you can use your own wording to suit.
  12. RobC1962

    Simple Price Break Contribution

    Hi All, I have got this contrib to work perfectly (discounted prices and checkout amounts are all fine) and have managed to place it in a box on the page with the matching 'header bar' as on the rest of our site boxes. However, the box title is repeated in the box itself, where the discount schedule is visible. I have fiddled around with the code and cannot get the text to go. I can get it so the title text is gone from both places, but not from just the box itself. Frustrating! Any help would be much appreciated. Incidentally, I used Ver.1.1b as a basis, and some coding from the newer versions (Vanilla newer versions did not work at all, or had several problems on our modded site) All the best, Rob C.
  13. RobC1962

    Royal Mail URL's

    same here - all working again. I did check out the RM site yesterday to do a 'manual' check of one I knew had been delivered and the return was unable to find the item. May have been an 'off day' or two on there. I Dunno.
  14. RobC1962

    Support thread for Storing Shipped Orders

    Ah - it is in a txt file on my desktop still! if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) { $keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search'])); $search = "where o.orders_status != 3 and o.orders_status != 106 and o.orders_status != 111 and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' and o.customers_name like '%" . $keywords . "%' "; } else { $search = "where o.orders_status != 3 and o.orders_status != 106 and o.orders_status != 111 and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' "; } if (isset($HTTP_GET_VARS['cID'])) { // search on order id $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']); // $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' . order by ". $db_orderby . " " . $sort ; $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by orders_id DESC"; } elseif (isset($HTTP_GET_VARS['status']) && is_numeric($HTTP_GET_VARS['status']) && ($HTTP_GET_VARS['status'] > 0)) { // search on status of order $status = tep_db_prepare_input($HTTP_GET_VARS['status']); $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status != 3 and s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by ". $db_orderby . " " . $sort ; } else { Change your status numbers as required. (Mine are the 3, 106 and 111)
  15. RobC1962

    Support thread for Storing Shipped Orders

    yes - I have done this and have 4 order 'status' pages in my admin area - I did the mods a long time ago but will check the code tomorrow and pass it on to you. I recall it was very simple indeed to accomplish. Would do it tonight for you, but its been a long long long day ....
×