Contest System [support thread]

[divaboutiques]

I tried to both the correct coding and the first coding still left a different error:

1. This is the new error I get for the admin display
1146 Table 'divabou_zc2.contest' doesn't exist
in:
[SELECT zen_contest .`date_entered`, COUNT(*) contestant_count FROM `contest` `contest` GROUP BY `contest`.`date_entered` ORDER BY `contest`.`date_entered` DESC limit 10]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


2. This is what I did for my photo to show with the code you left

Link to contest Page
$content .='<a href="'.zen_href_link("contest").'">Enter Our Contest</a><br />';
// Uncomment the below line and change image name and location to meet your needs.
// $content .='<a href="http://divaboutiques.com/store/index.php?main_page=contest'.zen_href_link("contest").'"><img src="images/FN90302RD.jpg" alt="Our Contest" border="0" title="ENTER TO WIN - Our contest gives away one prize to the winning contestent."/></a>';
$content .= '</div>';

I don't know if I added the image photo in the wrong area, but when I uploaded the file I received this error on my front page.

Parse error: syntax error, unexpected T_STRING in /home/divabou/public_html/store/includes/templates/diva/sideboxes/tpl_contest_sidebox.php on line 16

[divaboutiques]

Okay so I went back in to play around with the code to see if I placed the image somewhere wrong. I chenged it to this:

// Link to contest Page
$content .='<a href="'.zen_href_link("contest").'">Enter Our Contest</a><br />';
// Uncomment the below line and change image name and location to meet your needs.
// $content .='<a href="'.zen_href_link("contest").'"><img src="/store/images/FN90302RD.jpg" alt="Our Contest" border="0" title="ENTER TO WIN - Our contest gives away one prize to the winning contestent."/></a>';
  $content .= '</div>'; 

This error went away:

Parse error: syntax error, unexpected T_STRING in /home/divabou/public_html/store/includes/templates/diva/sideboxes/tpl_contest_sidebox.php on line 16 

But the image is still not showing up in the contest sidebox????

[skipwater]

I tried to both the correct coding and the first coding still left a different error:

1. This is the new error I get for the admin display
1146 Table 'divabou_zc2.contest' doesn't exist
in:
[SELECT zen_contest .`date_entered`, COUNT(*) contestant_count FROM `contest` `contest` GROUP BY `contest`.`date_entered` ORDER BY `contest`.`date_entered` DESC limit 10]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


2. This is what I did for my photo to show with the code you left

Link to contest Page
$content .='<a href="'.zen_href_link("contest").'">Enter Our Contest</a><br />';
// Uncomment the below line and change image name and location to meet your needs.
// $content .='<a href="http://divaboutiques.com/store/index.php?main_page=contest'.zen_href_link("contest").'"><img src="images/FN90302RD.jpg" alt="Our Contest" border="0" title="ENTER TO WIN - Our contest gives away one prize to the winning contestent."/></a>';
$content .= '</div>';

I don't know if I added the image photo in the wrong area, but when I uploaded the file I received this error on my front page.

Parse error: syntax error, unexpected T_STRING in /home/divabou/public_html/store/includes/templates/diva/sideboxes/tpl_contest_sidebox.php on line 16

I am assuming that the contest systems is working.
and there is a contest table in your data base.

1. This should fix your admin stat error

$contest_query = "SELECT `divabou_zc2.contest`.`date_entered`, COUNT(*) contestant_count FROM `contest` `contest` GROUP BY `contest`.`date_entered` ORDER BY `contest`.`date_entered` DESC limit 10"; 

2. need to uncomment line so remove the two //

$content .='<a href="'.zen_href_link("contest").'"><img src="/store/images/FN90302RD.jpg" alt="Our Contest" border="0" title="ENTER TO WIN - Our contest gives away one prize to the winning contestent."/></a>'; 

[divaboutiques]

I am assuming that the contest systems is working.
and there is a contest table in your data base.

1. This should fix your admin stat error

PHP Code:

$contest_query = "SELECT `divabou_zc2.contest`.`date_entered`, COUNT(*) contestant_count FROM `contest` `contest` GROUP BY `contest`.`date_entered` ORDER BY `contest`.`date_entered` DESC limit 10";

2. need to uncomment line so remove the two //

PHP Code:

$content .='<a href="'.zen_href_link("contest").'"><img src="/store/images/FN90302RD.jpg" alt="Our Contest" border="0" title="ENTER TO WIN - Our contest gives away one prize to the winning contestent."/></a>';

1. I'm getting this error now

1146 Table 'divabou_zc2.contest' doesn't exist
in:
[SELECT `divabou_zc2.contest`.`date_entered`, COUNT(*) contestant_count FROM `contest` `contest` GROUP BY `contest`.`date_entered` ORDER BY `contest`.`date_entered` DESC limit 10]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

2. Your suggestion worked and now the picture is showing, but it is showing very BIGGGGGGGG, how can I scale down the picture to fit the box now?

[skipwater]

2. Your suggestion worked and now the picture is showing, but it is showing very BIGGGGGGGG, how can I scale down the picture to fit the box now?

You must add width and height or resize the image.
This example is 100px X 100px:

$content .='<a href="'.zen_href_link("contest").'"><img src="/store/images/FN90302RD.jpg" width="100" height="100" alt="Our Contest" border="0" title="ENTER TO WIN - Our contest gives away one prize to the winning contestent."/></a>'; 

[skipwater]

As for item 1. I was sleeping on that one here should be the right code.

$contest_query = "SELECT `date_entered`, COUNT(*) contestant_count FROM " .TABLE_CONTEST. " GROUP BY `date_entered` ORDER BY `date_entered` DESC limit 10"; 

[divaboutiques]

Thank you
Thank you
Thank you
It worked!

[sonjamichelle]

Using:

Zen Cart 1.3.8a
Database Patch Level: 1.3.8
v1.3.8 [2009-03-10 15:49:55] (Fresh Installation)
Server OS: Linux 2.6.18-92.1.10.el5PAE
Database: MySQL 5.0.67.d7-ourdelta-log
Server Date: 03/15/2009 00:04:42
Database Date: 03/15/2009 00:04:42
Server Up Time: 00:04:42 up 10 days, 8:01, 0 users, load average: 2.35, 3.07, 2.52
HTTP Server: Apache
PHP Version: 5.2.8 (Zend: 2.2.0)
PHP Memory Limit: 64M
PHP Safe Mode: Off
PHP File Uploads: On
Max Size: 8M
POST Max Size: 8M
Database Data Size: 1,590 kB
Database Index Size: 909 kB


http://www.hillcountrytactical.com/catalog

When I try to enter the contest I get the following error.

1054 Unknown column 'contest_code' in 'where clause'
in:
[select count(*) as total from customers where customers_email_address = 'sonjamichelle######################' and customers_id = '0' AND contest_code = '25']

The "contest" table exists with columns:

id
contestant_name
contestant_email
contestant_ip_address
date_entered
validated
contest_code
OMIT


Searching the net, this error seems to stem from changes with "join" from ver 4 to ver 5.

I am NOT a SQL person so I don't even know where to begin to deug this.


One other problem I noticed is that when I goto the contest report screen and choose to add customers who purchased during the contest period, I see no customers to add.

[skipwater]

sonjamichelle

Open this file /includes/templates/YOUR_TEMPLATE/templates/tpl_contest_default.php
and find around line 96

$check_members_email_query = "select count(*) as total from " . TABLE_CUSTOMERS . " where customers_email_address = '" . zen_db_input($entry_email_address) . "' and customers_id = '" . (int)$customer_id . "' AND contest_code = '" . CONTEST_CODE . "'"; 

Replace with this

$check_members_email_query = "select count(*) as total from " . TABLE_CUSTOMERS . " where customers_email_address = '" . zen_db_input($entry_email_address) . "' and customers_id = '" . (int)$customer_id . "'"; 

Add Customers Button
There is no list created prior to the adding of customers to a contest.
If you wish to pick customers from a list, this can only happen after adding them to the contest. Then you can go through the list and delete the unwanted ones.

This patch and others will be added to the version 1.4 update.

[sonjamichelle]

Re: Patch

Worked like a charm!! Thank you very much!!

RE: Add Customers Button

On the adding of customers, when you goto the admin section from reports/contest prize entries, there's a add customers button. Clicking that button yields;

Contest Prize Entries
Add Entries for Existing Customers

Add entries for customers who have brought products during the contest period.

Contest Dates 03/10/2009 - 03/17/2009 Entrants Name Email Address

By the text of this page it makes me think that it will pull data on customers who made purchases and list them. I can then add them to the current contest from here based on the fact they made a purchase during the contest dates.

Did I misunderstand the purpose of this particular page?

The word in red; is that a typo?

Oh, just a possible bug heads up, nothing major. But if you choose not to use a qualifying question, the submit button disappears.

Again, thanks for the quick patch!!!!