Jump to content


  • Content count

  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
  • Gender
  1. redrum

    Removing fake customers

    One thing I noticed that might not be that easy to see is when you have fake customers in your database, the spam bots asking for new password. So when you have secured the site its a good idea is to remove all the fake customers or secure password_forgotten.php
  2. redrum

    Removing fake customers

    Ok, sorry my bad then For information, I tried to just implant my suggested code for now, and it seemes to work.
  3. redrum

    Removing fake customers

    I only did a quick check at Honeypot, and it looks like you only use javascript to check the hidden field. Perhaps you should add something like my suggestion above.
  4. redrum

    Removing fake customers

    To prevent bots you might be able to add something like this in the create_account.php $bot = tep_db_prepare_input($HTTP_POST_VARS['bot']); if( isset( $bot ) AND $bot != '' ) { $error = true; $messageStack->add('create_account', 'Youre probably not a human'); } And add the input fields <div style="display:none;"> <?php echo tep_draw_input_field('bot'); ?> </div>
  5. redrum

    QTPro BS

    Thank you so much for your quick and informative reply, @raiwa Yes that makes sense, I had my suspicions about something like that when I continued to look at it after my post. If I want to find the lost product IDs I guess I should write some kind of query to locate them. But for now I will keep it as it is. It shouldn't do any harm and my time is limited right now. Thanks again :)
  6. redrum

    QTPro BS

    When I go to admin/qtprodoctor.php I get the following message: "In the database we currently have 3 trash rows" There is no further information, and I have fixed all the products that had a faulty stock. I looked into the code for admin/includes/functions/qtpro_functions.php and find the functions for the Trash-Tools (around line 460). But I couldn't figure out what the functions qtpro_stock_row_is_trash() and qtpro_number_of_trash_stock_rows() actually checks. I did a quick query in phpmyadmin to find for duplicats in the table PRODUCT_STOCKS: SELECT products_id, products_stock_attributes, COUNT(*) FROM products_stock GROUP BY products_id, products_stock_attributes HAVING COUNT(*) > 1 But the results was zero. So what and where does the functions qtpro_stock_row_is_trash() and qtpro_number_of_trash_stock_rows() checks?
  7. redrum

    Recover Cart Sales

    Regarding how long time after the visit the email should be sent; How can I change it to look back for a specific amount of hours, instead of days?
  8. Where is "V2.1 - bugfixes, enhancements" available for download?
  9. redrum

    Quantity Price Breaks

    I have some issues with Quantity Price Breaks for Separate Pricing Per Customer. I cant get the discounted price to be displayed unless I add two pcs of the same product (the total number of items must of course meet the criteria I have set up in the discount table). But if I go to shopping_cart.php and hit the Update Cart-button then the correct price with the discount is shown. I have set up a price table as follows; 1-4 pcs: $39 5+ pcs: $33 And then assign the products to the same discount category. This scenario work: Adding: 2 pcs of Product-A, 2 pcs of Product-B and 2 pcs of Product-C. or Adding: 3 pcs of Product-A and 2 pcs of Product-B. This scenario don't work: Adding: 2 pcs of Product-A, 1 pcs of Product-B, 1 pcs of Product-C, 1 pcs of Product-D or Adding: 4 pcs of Product-A, 1 pcs of Product-B, 1 pcs of Product-C, 1 pcs of Product-D or Adding: 4 pcs of Product-A and 1 pcs of Product-B I have spent some time trying to fix this but havent been able to find a solution. What could be wrong and where should I looking, does anyone have an idea?
  10. will it work with osCommerce 2.2-MS2?
  11. redrum

    Stocktaking Cost 0.3 problem.

    Does anyone have any idea of why the name of the categories disappear after this update, and how to solve that?
  12. redrum

    ULTIMATE Seo Urls 5 - by FWR Media

    Well, this contribution keeps confusing me. I noticed that the settings in admin was changed; Cache system was chaned from "file" to "sqlite" uri format was changed from "rewrite" to "standard" So the settings was reverted to default. I thougth it was very odd, but just changed it back. A few hours later it was back to default again. I then checked the database tables for usu5 and noticed that the time for date_added was just recently. So for some reason usu5 reinstalls for me. help, anyone?
  13. redrum

    ULTIMATE Seo Urls 5 - by FWR Media

    Did you find a solution for this? I hope I dont speak to mylelf here. After changing from "sqlite" to "file", the only error message in the log that I have received during 40 hrs is PHP Fatal error: Call to a member function store() on a non-object in /xxx/includes/modules/ultimate_seo_urls5/main/usu5.php on line 78 it occured 42 times during a period of 1,5 minute. I searched this thread and found that some other have had the same problem, but I couldnt find any soultion for it. The closest thing I found was the qoute above. I find it confusing that this contribution generate so many error massage for me, as faar as I know Robert is a skilled programmer.
  14. redrum

    ULTIMATE Seo Urls 5 - by FWR Media

    I have some more errors in my log since the last post and one of them is new. Here it is: PHP Warning: SQLiteDatabase::query() [<a href='sqlitedatabase.query'>sqlitedatabase.query</a>]: database disk image is malformed in /xxx/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 136 I have switched "cache system" in admin from "sqlite" to "file". So lets see how that turns out. Another question. As for the different cache systems, which is the best, next best, and so on? Thanks, Fredrik
  15. redrum

    ULTIMATE Seo Urls 5 - by FWR Media

    I have switched from Chemos SEO URLs to this one by FWR Media I first received this error in my logs PHP Warning: SQLiteDatabase::query() [<a href='sqlitedatabase.query'>sqlitedatabase.query</a>]: column cache_name is not unique in /xxx/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 130 I then updated sqlite.php from http://forums.oscommerce.com/topic/336702-ultimate-seo-urls-5-by-fwr-media/page__st__2920#entry1573002 and reset USU5 Cache from admin Then after a couple of minutes these error messages appeared in the logs PHP Warning: SQLiteDatabase::query() [<a href='sqlitedatabase.query'>sqlitedatabase.query</a>]: column cache_name is not unique in /xxx/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 136 PHP Warning: SQLiteDatabase::query() [<a href='sqlitedatabase.query'>sqlitedatabase.query</a>]: unable to open database file in /xxx/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 136 These error messages have occured 5 times during 4 hours. The folder includes/modules/ultimate_seo_urls5/cache_system/sqlite have the rights 777 I use Ultimate Seo Urls 5 PRO ( r205 ) at http://addons.oscommerce.com/info/6768 PHP Version: 5.2.17 OSC Version: 2.2 rc2a Any idea how to fix there errors?