Latest News: (loading..)

All Activity

This stream auto-updates   

  1. Past hour
  2. Yours is a very difficult question to answer when only you know what you want a payment provider to do for you. Try speaking to your bank as they will have an option for you. Failing that lots of local searches on the internet to find a provider that you can afford as costs will vary wildly and will be dependant on sales totals. There are many modules for oscommerce for most of the main providers which all work. You have to decide which one to use. They are all relatively easy to set up in your store. Where they vary will be in their backend which is where you see all your transactions on their website. PayPal is by far the largest and most popular for smaller businesses but they do say that once you get to over 500 dollars in sales, then there are cheaper options out there. You can get to your money quickly, but be aware that they can close your account down with no warning.
  3. Today
  4. Good morning Jim, Like I said, I have try your Modular Navigation Bar (Bootstrap) with the Categories Modular Navigation Bar. But I have also try tried every Horizontal Categories Menu add-ons you have made. Really Nice. Thanks for your work. My prefered is : Modular Navigation Bar (Bootstrap) I keep this one... But the only problem I have with it, it's made the famous Deprecated error on PHP7 with my BS Edge. So I fixed the problems in the following files : includes\modules\navbar_modules\nb_categories.php includes\modules\navbar_modules\nb_categories_full.php All is working great without error anymore. Great add-on. Nice work.
  5. @Jack_mcs Thank you Jack for your answer... But which one is the less complicated and easy configuration to use with any bank ??
  6. @14steve14 Thanks Steve, the big minus for header tag is that it loads after the data is already processed and entered in the database: https://forums.oscommerce.com/topic/411212-sloppy-words-cleaner-header-tag-versus-hook/?do=findComment&comment=1757857 So my idea was now to use hook together with a custom group module "store" which I already use in several other add ons. It would allow to integrate an installation process which can add the few lines of additional code, (hook register and calls) in the related core files. On uninstall theses mods can be also auto removed. This is actually what is planned for the future 2.4 Apps to do. This "store" module can also hold all the configuration entries, exception arrays etc. rgds Rainer
  7. I must really find a few minutes to look into this again. Business has gone daft, which is not too bad I suppose.
  8. @raiwa I already use this addon, and it has saved countless hours in getting customer details and addresses almost 100% correctly formatted. Whether it would be better as a hook or header tag I have no real preference, but a header tag may be easier with all the core pages that the hook code would need adding to. Also having less core code changes may make upgrading the store easier in the future, unless it is possible to alter the core files required for a change automatically, which i very much doubt.
  9. In which case you are going to have to download all the official ones and find the files that match your version. Shouldn't take too long. If the site code was hacked, you need to clean the code and that could mean starting again. Most good hosts would keep a backup of the site for 30 days, so it may be possible to ask them. Someone also should have a saved known good backup of the site. If not they deserve all the hassle they get. You say that you cant migrate to a newer version, can I ask why that is.
  10. Bit more complicated since you have to account for product status. FIND EACH INSTANCE OF: $listing_sql = "select " . $select_column_list . " p.products_id, SUBSTRING_INDEX(pd.products_description, ' ', 20) as products_description, p.manufacturers_id, REPLACE EACH INSTANCE WITH: $listing_sql = "select " . $select_column_list . " p.products_id, SUBSTRING_INDEX(pd.products_description, ' ', 20) as products_description, p.products_status, p.manufacturers_id, THEN: if ( (!isset($_GET['sort'])) || (!preg_match('/^[1-8][ad]$/', $_GET['sort'])) || (substr($_GET['sort'], 0, 1) > sizeof($column_list)) ) { for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { if ($column_list[$i] == 'PRODUCT_LIST_PRICE') { $_GET['sort'] = $i+1 . 'd'; $listing_sql .= " order by p.products_status DESC, final_price DESC";
  11. Thanks for answers! It is not my site. File modified some months ago. There was an unauthorized modification of the code in the file. As a result, syntax errors occurred. Most likely it is the consequences of the virus. I have file categories.php with errors. in file /admin/includes/application_top.php says: $Id: application_top.php,v 1.2 2003/09/24 13:57:07 wilt Exp $ I can't migrate this site to last version. I want repair admin panel only. There is no version 1.2. Versions 1 and 1.1 have a different /admin_2k/categories.php file categories.php
  12. Just to remind: this topic is header tag versus hook for the new modularized version If you wish to see what the existing add-on already does, you are invited to download it and try: Sloppy Words Cleaner
  13. @Cary @Psytanium This is the contents of my SiteMapProducts.php sitemap (note the php extension, enter it exactly like that in Google Webmaster Tools). I am using USU5 and it works perfectly. <?php header('Content-type: application/xml'); include ('includes/application_top.php'); $products_query = tep_db_query("select products_id from products where products_status = '1' order by products_id DESC"); $output = '<?xml version="1.0" encoding="UTF-8"?>' . "\n"; $output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">' . "\n"; echo $output; ?> <?php while ($products = tep_db_fetch_array($products_query)) { $str = $products['products_id']; $exclude_list = array(); // add any product ids you wish to exclude with a comma separating each i.e. 12,28,36 if(!in_array($str, $exclude_list)) { ?> <url> <loc><?php echo tep_href_link('product_info.php', 'products_id=' . (int)$products['products_id'], 'NONSSL', false); ?></loc> </url> <?php } } ?> </urlset>
  14. @frankl, Forgot to mention: For Company names any spelling is allowed, so no filtering applies to the company field. Each entrance can be treated by different filter funtions.
  15. @frankl, Thanks for your suggestions. This add-on exists since years and has already included extended exception lists. // exceptions to standard case conversion if ($is_name) { $all_uppercase = ''; $all_lowercase = 'Or|And'; } else { // address abreviations and anything else $all_uppercase = 'Aly|Anx|Apt|Ave|Bch|Blvd|Bldg|Bp|bp|Bsmt|Byu|Ch|Cors|Cswy|Cr|Crk|Crt|Cts|Cv|Cvs|Est|Ests|Expy|Frnt|Fl|Frks|Fwy|Gdn|Gtwy|Hbr|Hbrs|Hts|Hwy|Ii|Iii|Iv|Jct|Jcts|Lk|Lks|Ln|Ldg|Mnt|Mnr|Mnrs|Msn|Mtwy|Mtn|Mtns|Ne|Nw|Pkwy|Pl|Pln|Plns|Ph|Po|Pob|P.o.b.|P.O.b.|p.O.b.|p.o.B.|p.O.B.|Rm|Rr|Se|Skwy|Smt|Sw|Sta|Ste|Sq|Ter|Tpke|Trpk|Trlr|Trl|Trwy|Vl|Vlg|Vlgs|Vly|Vlys|Vi|Vii|Viii|Xi|Xing|Xrd'; $all_lowercase = 'À|A|And|As|Am|An|Au|Aux|By|D|Da|De|Des|Del|Du|Der|Die|Das|En|Et|In|L|Le|La|Les|Of|Or|Ou|Sous|Sur|To|Von|Y'; } // exceptions for names and surnames if ($is_name) { $all_uppercase = ''; $all_lowercase = 'D|De La|Da|De Las|Del|De Los|Der|Van De|Van Der|Vit De|Von|Or|And|Y|En|De|La|Del|Do|Du|Am|An|Der|Die|Das'; } else { $all_uppercase = ''; $all_lowercase = 'A|And|As|By|In|Of|Or|To'; } $prefixes = "'|Mc|Mac|l'|L'"; $suffixes = "'S"; // replace target words $word = array ("Saint" => "St","Sainte" => "Ste","Saints" => "Sts", "Saintes" => "Stes"); return strtr($str,$word); To cover the allowed variation examples given by burt and you, I'll add now an array with terms which will not be altered by the filter function: $exception_terms = 'McDonald|MacDonald|Macdonald|Mcdonald|De Quincey|La Rochefoucauld'; I can't confirm the third case "Von Braun". The most famous reresentative is spelled "Wernher von Braun", there may be other examples, but as always, 100% is impossible, but most store owners will prefer to get 99.9% clean data and 0.1 % or less with these kind of errors. As already stated, all of these lists are in the old version hardcoded in the function file, but will now be editable in admin as configuration settings. So each store owner can adapt them to his local needs and language. I can say that I'm using this since many years on my wife's store, and after adding some spanish and german exceptions which were not included in the original add-on, we didn't have to correct any data since years. Other users reported the same. For on the fly javascript filtering: - it would be quite a long script and slow down page load - if a customer stops typing before he finished, and clicks out of the field, filter function would be triggered and he may get unexpected results and may get confused - if the correction is done on the fly, even they finished typing, they also may get confused and not understand what happened - create account is a sensitive process mostly done for checkout. I won't like to confuse any customer during this process - once they are registered and see their corrected data it's less problematic and they will understand it easier tks a lot for your time and suggestions rgds Rainer
  16. Don't forget d'Argent de Beauvoir du Plessix van Beethoven von Strohm then you have De Quincey Von Braun La Rochefoucauld and those are just surnames! You also have street names, names of cities, towns, and villages, even companies. What if they work at the company called nVidia? OK, I'm kind of teasing, but it's a bit of a minefield. Perhaps use javascript to capitalize words as customers are entering them in the input fields, and if it's not right they can change it?
  17. You should check your PHP error log for errors, but what I think is happening is that because you have Check SSL session ID set to true, when it goes from SSL registration page to the NONSSL success page osCommerce is kicking the user off. I got the message "The server reset the connection" when I clicked "Continue" on the registration page.
  18. Yesterday
  19. Thank you. https://sklep.roslinyakwariowe.pl I have created a test login: login: sklep@roslinyakwariowe.pl pass: rzN7d
  20. I advise that you not use old Addons that require changes to core code. Doing so will break future code changes such as the upgrade to 2.4 when it is released. You can use one of the modular Addons to add header tags. Better yet, take the header tags out of 2.3.4BS Edge or the 2.4 beta and use those. Regards Jim
  21. Hello @kymation, everyone I still have some issue with install Header Tags SEO addon by @Jack_mcs with Modular Product Page (Bootstrap) installed, Here is the code whats need to change in product_info.php : In products_info.php FIND: require(DIR_WS_INCLUDES . 'template_top.php'); ADD BENEATH: /*** Begin Header Tags SEO ***/ echo "<a name=\"\$header_tags_array['title']\"></a>"; /*** End Header Tags SEO ***/ FIND: $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_gtin from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$_GET['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$_GET['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); REPLACE WITH: /*** Begin Header Tags SEO ***/ $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_gtin, pd.products_head_sub_text from products p, products_description pd where p.products_status = '1' and p.products_id = '" . (int)$_GET['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); $product_info['products_name'] = $header_tags_array['title_alt']; /*** End Header Tags SEO ***/ tep_db_query("update products_description set products_viewed = products_viewed+1 where products_id = '" . (int)$_GET['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); FIND: <?php echo stripslashes($product_info['products_description']); ?> REPLACE WITH: <?php /*** Begin Header Tags SEO ***/ ?> <?php echo HTS_Highlight(stripslashes($product_info['products_description']), $header_tags_array['keywords']); ?> <?php /*** End Header Tags SEO ***/ ?> FIND: </div> </form> ADD ABOVE: <?php /*** Begin Header Tags SEO ***/ if (tep_not_null($product_info['products_head_sub_text'])) { echo '<div class="hts_sub_text" style="padding:10px 0;">' . $product_info['products_head_sub_text'] . '</div>'; } if (HEADER_TAGS_DISPLAY_CURRENTLY_VIEWING == 'true') { echo '<div id="hts_viewing">' .TEXT_VIEWING; $header_tags_array['title'] = (tep_not_null($header_tags_array['title']) ? $header_tags_array['title'] : $product_info['products_name']); echo '<a title="' . $header_tags_array['title'] . '" href="' . tep_href_link('product_info.php', 'products_id=' . $product_info['products_id'], 'NONSSL') . '"/# ' . $header_tags_array['title'] . '">' . $header_tags_array['title'] . '</a>'; echo '</div>'; } if (HEADER_TAGS_DISPLAY_SOCIAL_BOOKMARKS == 'true') { echo '<div style="float:right; margin-top:5px; margin-right:4px;">'; include('includes/modules/header_tags_social_bookmarks.php'); echo '</div>'; } /*** End Header Tags SEO ***/ ?> Can you please advice me Thank you Joe
  22. In Google Webmaster Tools I have many duplicates e.g. /product_info.php/targus-bag-tss588us-156-black-p-6437 /product_info.php?products_id=6437 is it because Google XML Sitemap is not compatible with SEO URLs 5 ??
  23. hi does encrypted payments have to be selected? i have set up api correctly but wondering if Encrypted payments should be selected to true?
  24. @t000 Oh, and as @Dan Cole mentioned, you are going to have to join tables in your query. More to learn If you don't feel that you can learn how to do this, you can always post in the commercial area of the forum and hire someone to do it for you. Malcolm
  25. Anyone get Google XML Sitemap to work with SEO URLs 5? XML links are not SEO URL formatted.
  26. @t000 Tom, will you always want to only exclude the Keyboard category, or will what you exclude change each time? As you know, the tep_count_products() function counts *all* products. function tep_count_products() { $products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " WHERE products_status = '1'"); $products = tep_db_fetch_array($products_query); return $products['total']; } If you wanted to exclude the Keyboard category, you would have to change the function to *something* like this: function tep_count_products() { $products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " WHERE products_status = '1' and Category ! Keyboards "); $products = tep_db_fetch_array($products_query); return $products['total']; } (No, that's not proper SQL code ... I'm just showing you *where* to adjust the query, not *how* to. You'll learn more about how to manage your own store by figuring it out yourself ) Two points: 1) You don't want to CHANGE the existing tep_count_products() function, you want to COPY and RENAME it (to something like tep_count_products_except_keyboards() ). Don't change the core code! 2) If you will be changing what you will be excluding each time, you could a) write a function for each category you might exclude (not too practical, especially if you may want to exclude more than one category, and/or you add new categories to your store often), or b) write a function that accepts a parameter with the category (or categories) you want to exclude. For example, you could write a function called tep_count_products_with_exceptions() , and would have to pass the name or number of the category (or categories) that you want to exclude. See what you can come up with. If you need more help, tell us what you have tried that worked or didn't work. HTH Malcolm
  27. Posting a URL might help someone help. Dan
  28. The US Post Office does not deliver mail on Sunday. However, Amazon has partnered with them, resulting in having the Post Office deliver Amazon's items on Sundays. I wonder what *that* cost Amazon?
  1. Load more activity