Jump to content

René H4

Members
  • Content count

    676
  • Joined

  • Last visited

  • Days Won

    4

Reputation Activity

  1. Thanks
    René H4 got a reaction from ralgiere in easy Populate : error MySql 1064   
    Like @raiwa says : "Otherwise you can post in the commercial support section to find a developer to fix this for you."
    Do you understand what is said here?
  2. Like
    René H4 got a reaction from fiodh in Fake accounts   
    Would it not be a simple solution to rename create_account.php to something else?
    I know, all the files that call create_account.php should be changed also.
    But if this a real problem, and you will be running your shop for 5-6 years or so, this could be a solution.
  3. Like
    René H4 reacted to valquiria23 in Support thread for Bootstrap V4 Oscommerce Administration v2.3.4.1 CE   
    I think it would be great to make a package (called frozen 2 or as you like) that has the new admin of @shetch and the Frozen version with its bug fixes so that new users can download them in one place.
    What the community lacks are periodic updates to show that the software is alive.
    I do not know if this is the best place to post it, but the work of @shetchis fantastic, it's the cooler in oscommerce for a long time and it would be great to integrate it into the Frozen package.
    What do you think?
    Best regards.
    Valqui
  4. Haha
    René H4 reacted to raiwa in Unusual shipping requirements   
    Jack, @Jack_mcs, the post is from 2006! 😉
    Never mind, happened to me too.
  5. Like
    René H4 got a reaction from videod in Fake accounts   
    SPOT ON! 
    I think this will work for me also.
    It looks like an easy fix, which (up to now) will stop all my fake account creations.....
     
  6. Thanks
    René H4 reacted to John W in Fake accounts   
    I've had a few of these in the last month with some different names, but they enter Google for company and google for company tax id each time.  I know not company tax id isn't stock code, but I added this to block spammers and I can add more to it if I need.  Most regular customers don't enter a tax id, but only spammers enter google for it.  I also have it send me an email to notify me it's happened so I can track it.
    //Added to block spammers if (strtolower($company_tax_id) == 'google') { $error = true; $messageStack->add('create_account', "You have triggered spamming prevention rules. If you info is correct and you are not a spammer please contact us or try again."); $spam_email_text = "Spammer Alert: " . $firstname . " " . $lastname . "Using company name: " . $company . " with tax id: " . $company_tax_id . " triggered spam alert."; tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, 'Spammer Alert:', $spam_email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } //END Added to block spammers  
  7. Like
    René H4 got a reaction from simplebaby in Recover Cart Sales   
    I found this on a French site, it worked for me:
     
     
    Patch for stats_recover_cart_sales.php
     
    REPLACE:

    $orders_query_raw = "select o.customers_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value 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 . ' OR o.customers_email_address like "' . $crec['customers_email_address'] .'" OR o.customers_name like "' . $crec['customers_firstname'] . ' ' . $crec['customers_lastname'] . '") and o.orders_status > ' . RCS_PENDING_SALE_STATUS . ' and s.orders_status_id = o.orders_status and o.date_purchased >= "' . $inrec['dateadded'] . '" and ot.class = "ot_total"';
    BY:
     
     

    $orders_query_raw = "select o.orders_id, o.customers_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value 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 . ' OR o.customers_email_address like "' . $crec['customers_email_address'] .'" OR o.customers_name like "' . $crec['customers_firstname'] . ' ' . $crec['customers_lastname'] . '") and orders_status NOT IN (' . implode(unserialize(RCS_PENDING_SALE_STATUS), ',') . ') and s.orders_status_id = o.orders_status and o.date_purchased >= "' . $inrec['dateadded'] . '" and ot.class = "ot_total"';
  8. Like
    René H4 reacted to Benjjj6 in Fancier Invoice & Packingslip v1.0   
    hi,
     
    on my invoice.php, packing_slip.php and print_my_invoice.php pages I have at the top:
     
     
    How can I edit this?
×