Jump to content

Jack_mcs

Members
  • Content count

    30,133
  • Joined

  • Last visited

  • Days Won

    137

Everything posted by Jack_mcs

  1. Jack_mcs

    Database Optimizer

    This addon provides an easy method for keeping your database fit. All osCommerce shops require a MySQL database to function but little attention is ever given to it. Just ask yourself when was the last time you optimized your database? Unfortunately, this is a big mistake since MySQL is prone to developing problems. Some are fixed as the database runs but some are not and, over time, these grow and can severely effect your shops performance. This addon will automatically tune-up the database, speeding it up and correcting problems that many shop owners are not even aware of. Here are some of its features: Defragment the tables Optimize the keys Strip the customers tables of old data Strip the sessions table of old data Strip the user tracking table (if present) of old data Remove old credit card numbers
  2. Jack_mcs

    HoneyPot Captcha

    That's not anything to do with this addon. 2.3.4 isn't designed to work with 7.2. It would probably cause failures with just 7.0. You will find many others if you look for them.
  3. Jack_mcs

    Database Optimizer

    @ce7For the first one, at the location shown, change case TEXT_DO_OPTIMIZE: $config['optimize'] = DATABASE_OPTIMIZER_OPTIMIZE; $optionSelected = true; break; to case TEXT_DO_OPTIMIZE: $config['optimize'] = DATABASE_OPTIMIZER_PERIOD; $optionSelected = true; break; For the second one, change $mainDate = tep_db_fetch_array($query, MYSQL_ASSOC); to $mainDate = tep_db_fetch_array($query); For the third one, change case 'Opt C': continue; //skip customers with orders to case 'Opt C': continue 2; //skip customers with orders
  4. Jack_mcs

    HoneyPot Captcha

    A new version has been uploaded with these changes: Added the time to submit code to the form checker (non-create account) code. Added files, new and changed, for pre-2.3 shops. Added code to remove a blocked IP from the .htaccess file. Added 144 countries to the postal code check. Added an icon to the left column for Phoenix versions. Changed the code for the CheckCountryState function to ignore countries without states. Changed the code for the CheckPostalCode function to better handle the various options. Changed the code for the captcha font to use the full path since it failed on some servers. Changed code to be compatible with all versions of Phoenix. Fixed code for country-state check that caused it to always be active. Fixed the time to submit function to work correctly. Found by @dfr717. Fixed the postal code checking due to problems found by @pedros. Fixed the hidden field test so that it works correctly. Fixed code to prevent failures for some multi-named databases. Changes made but not in this version: Added the date created to the Account Check page in admin. Added an option to clear the log file in admin. Added an option to display the log for just the current month. Added an option to skip logging first-time accounts. Changed the order of the log file to show latest entries first. Changed the filtering for names in admin to be give better and faster results. Changed the code that prevents url's to check for url's without schemes, like example.com.
  5. Jack_mcs

    continue Shopping

    Maybe I don't understand what you are saying but the way I read it is that you want to be able to add one item to the cart, have it show a continue shopping button but make that button inactive. Is that correct?
  6. This is a new version of the Quantity Price Breaks addon. It is only for Frozen and Phoenix shops. If you have an older version, you will need to use a different, older, version of this addon. The purpose of this addon is to allow the price of a product to be controlled by how many items are purchased. So a quantity of 1 may cost $100, a quantity of 2, $60 and so on. It also provides for limiting the minimum number to ordered. Due to how the code works, there are a number of file changes needed. I've reduced them a great deal compared to previous versions of this addon but there's no way, currently, to get around some of the changes. So be sure to create a backup before installing.
  7. Jack_mcs

    Quantity Price Breaks

    Hi Nick. This is the support thread for my version of Quantity Price Breaks. There are others. This one is just meant for Frozen and Phoenix versions, though it may work in your shop. The PriceFormatter.php file in this version should work in your shop as a replacement. I think the PriceFormatterStore.php might also work but I'm not positive. So download this version and upload those two files to your shop. Be sure to back the existing files first. If they don't work, replace them with the originals and then just copy the code at the line that is failing (it should be different). One of those methods should fix the problem. This is the support thread for your version. That version was released in 2011 and php 7.2 was still a gleam in the developers eyes at that point so I'm not surprised there are issues.
  8. Jack_mcs

    Quantity Price Breaks

    The file you posted doesn't match either from this addon. Please post your question in the support thread for the addon you are using.
  9. Jack_mcs

    Quantity Price Breaks

    What version of php are you using? When are you seeing the error?
  10. Jack_mcs

    Full Category Link Path

    You could copy the tep_generate_category_path in admin/includes.functions/general/ to the shop side to do this. It returns an array but you could change that to a string. It depends on the version you are using but I think they all have this function.
  11. Jack_mcs

    Abandoned Cart Recovery

    You are correct. If you don't log in, the code doesn't have a way to get an email address for you.
  12. Jack_mcs

    Abandoned Cart Recovery

    @DonaRowe3443When a customer adds something to their cart and then leaves without completing the order, that is called an abandoned cart. The Recover Cart Sales addon allows you to see those abandoned carts in admin and to send an email to those customers, either manually or via a cron job. The message can be whatever you like but it mainly says, "Thank you for visiting our site. We see you didn't complete your order and would like to know why...." Many times, the customer will end up completing their order due to the personal attention. Since my previous post, I have released a version for Phoenix, though only for versions prior to 1.0.5.4.
  13. Jack_mcs

    Sitemap SEO

    This contribution fixes many of the deficiencies of the other sitemap contributions. It has been tested in MS2 and RC2 shops but should run in any variation of oscommerce. All settings are controlled via admin. It has the following following features. - Displays all pages and boxes - no missing links or text - Displays categories, with or without products - Displays manufacturers, with or without products - Links can be sorted - Links can be excluded - Links can be set to show for registered customers only - Sections of links can be sorted - Sections of links can be excluded - Sections of links can be set to show for registered customers only - All links have configurable anchor text - All links have configurable alternate display names - All sections of links can be placed anywhere on the sitemap page via admin - Supports Articles Manager Infopages Page Manager Jack
  14. Jack_mcs

    Sitemap SEO

    Thank you for posting the code. It was on my todo list so that saved me looking it up.
  15. Jack_mcs

    Header Tags SEO

    Those defines are in the language files. To fully remove, you have to reverse the steps you made when you installed it or restore the files from backup.
  16. Jack_mcs

    MATC_v2.3.4

    You're welcome. Moving to Phoenix is a good decision.
  17. Jack_mcs

    MATC_v2.3.4

    The installation of the addon will only work if you have a working shop. I assume you do but, if not, then a stock version would have to be installed. That will work but may not appear as your previous one did.
  18. The location may be valid but I wouldn't assume it is the correct one. For example, if someone clicks checkout or login, they will be shown a login dialog or a link to create account. So once the account is created, if the customer is redirected back to the login page it would be very confusing to them.
  19. Jack_mcs

    MATC_v2.3.4

    It's difficult to comment on it without knowing at least one of the errors. It has been a while since I installed the addon into a shop of your version (thanks for posting that by the way) but it does work. It is not uncommon for the instructions and/or included files to match what is in your shop since they are only valid for what the author of the addon used. Sometimes you have to play detective to try and figure out what change is needed. There are several MATC addons so you may want to try another. Just be sure, if possible, to use one that says it is for oscommerce 2.3.
  20. Jack_mcs

    Contact Form Abuse

    In includes/functions/honeypot.php, change this line tep_db_query("CREATE TABLE IF NOT EXISTS " . $db_table . " (ip_number INT( 64 ) UNSIGNED NOT NULL, to tep_db_query("CREATE TABLE IF NOT EXISTS `" . $db_table . "` (ip_number INT( 64 ) UNSIGNED NOT NULL, and this line if (! tep_db_query("show tables from " . DB_DATABASE . " like '" . $db_table . "'")) { to if (! tep_db_query("show tables from `" . DB_DATABASE . "` like '" . $db_table . "'")) {
  21. The code looks fine as long as you know $origin_href is valid. I think once someone adds something to their cart and then creates an account it means they are ready to checkout so redirecting them to checkout_shipping saves a step for them.
  22. Jack_mcs

    HoneyPot Captcha

    All that line changes is the name of the function to call. You can replace the entire line and it should be fine or just replace the words check_form with validateMyForm. But if the create account page loads initially, which it sounds like it does, that change would not cause the problem. Have you installed the module in admin? Also, you don't mention the other changes needed for that file so I suspect you might be using the wrong version for the installation. You should be using the instruction file named Install_Frozen_V234.txt. Also, and more importantly, since this is a new installation of oscommerce, you should not be using the version you are using. Scroll down on the Products page and download the Phoenix package. The one you are using is very outdated and has a numbers of problems.
  23. No. because the link is in the code. You need to change this line in create_account.php file tep_redirect(tep_href_link('create_account_success.php', '', 'SSL')); to $page = ($cart->count_contents() > 0 ? 'checkout_payment.php' : 'index.php'); tep_redirect(tep_href_link($page)); Or, you could duplicate the checkout_success module and have it handle the redirect. That will make it so no core files are changed but would cause an extra redirect.
  24. Jack_mcs

    Article Manager v1.0

    It's close to needing testing. When it reaches that point, I will make a package available for testing. Thank you for the offer.
  25. Jack_mcs

    HoneyPot Captcha

    Without knowing the version of your shop, it would be a waste of time to try to answer. Please always include the version of oscommerce you are using, for any question in these forums.
×