Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

carl_skerritt

Members
  • Content count

    4
  • Joined

  • Last visited

Profile Information

  • Real Name
    Carl Skerritt
  1. carl_skerritt

    Prize Draw Competition help

    Ben, also I think you will need to put your dates back to MM/DD/YYYY
  2. carl_skerritt

    Prize Draw Competition help

    Ben, sorry you are having problems. Firstly the 'TEXT_DISPLAY_NUMBER_OF_REFERRAL' error. Looks like I missed this entry out out of the language file. Add into "admin\includes\languages\english.php" the following entry. define('TEXT_DISPLAY_NUMBER_OF_REFERRALS', 'Displaying <b>%d</b> to <b>%d</b> (of <b>%d</b> sources)'); This should resolve that issue. I also have Paypal IPN, so your problem isn't due to that. I think I may have worked out the problem though. Have you changed your Order Statuses? The SQL code looks for order_status = 5. This in a standard osC install is the value of given to Completed orders. If you have changed your order statuses, your Completed status may not be 5. Another user had a similar issue, where his Completed Status has a value of 21 in his store. Can you check this. If this is the issue then change the value in the SQL statement at line 103 in the admin\stat_prize_draw.php Hope this is it. Carl
  3. carl_skerritt

    Prize Draw Competition help

    The add customer function should work. To add customers to the competition who have purchased from you during the competition period, you need to go into the Admin Prize Draw Report screen and Press the Add Customers button. This then goes off and queries the order table for all customers who have purchased from you between the dates of the competition. It then checks if their email address is already entered into the competition and then displays those who haven't entered in a list. You then need to confirm this list, by pressing the Confirm button and they are added to the competition. I checked this again today, when I recieved your mail, just to check the functionality. If this is not working for you. Check how you have the dates specified in the Configuration section. This start and end dates must be entered in US format MM-DD-YYYY. Also check that the test purchase you made is within the start & end dates specified for the competition. You must do the add customer bit before picking a winner and closing the competition. Hope this helps
  4. carl_skerritt

    [contribution] Star Product

    Hi, I had this 1054 problem. It is to do with a change in supported syntax in MySql 5. I fix it on my site, so thought I share the fix. Change Line 20 in the star_products.php to the following $star_products_query = tep_db_query("select substring(pd.products_description, 1, 598) as products_description, p.products_id, p.products_image, p.manufacturers_id, p.products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_tax_class_id, sp.product_id from ((" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_STAR_PRODUCT . " sp) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id) where p.products_id = pd.products_id and p.products_status = '1' and pd.products_description != '' and p.products_id=sp.product_id and pd.language_id = '" . $languages_id . "'"); that should fix it.
×