Contest System [support thread]

[joyjoy]

Well one of the ways that I am encouraging feedback is to allow an extra entry for feedback left for purchases so I was hoping that I could add the extra entry in admin...if I enter it through the store front it'll come back as already entered.

Thank you.

[joyjoy]

One more question I had...is there a way to set up your contests in advance? I run the drawing monthly from the 1st through the end of the month. But each contest is exclusive to the contest settings...I was hoping to set it up for each month so it would be a smooth transition when the current contest ends.

Any ideas or am I stuck doing the manual reconfigure each month? I don't mind the set up I just don't want people losing out if it's not done immediately...since entries cannot be input manually. This kind of ties in to my other inquiry too i guess.

Thank you.

[skipwater]

Well one of the ways that I am encouraging feedback is to allow an extra entry for feedback left for purchases so I was hoping that I could add the extra entry in admin...if I enter it through the store front it'll come back as already entered.

Thank you.

One more question I had...is there a way to set up your contests in advance? I run the drawing monthly from the 1st through the end of the month. But each contest is exclusive to the contest settings...I was hoping to set it up for each month so it would be a smooth transition when the current contest ends.

Any ideas or am I stuck doing the manual reconfigure each month? I don't mind the set up I just don't want people losing out if it's not done immediately...since entries cannot be input manually. This kind of ties in to my other inquiry too i guess.

Thank you.

These are two good ideas but for now there is no built in options for these.

I will look into adding something along these lines to the mod in the future.

Skip

[TinMan780]

Skip,

Is there an easy way to add another column to include City/State on the contestwinners page?

[skipwater]

Skip,

Is there an easy way to add another column to include City/State on the contestwinners page?

Find file /includes/languages/english/html_includes/YOUR_TEMPLATE/define_contestwinner.php
Make it look like this.

<!-- bof define_contestwinner-->
<center>
<table width="90%" border="0">
  <tr>
    <td class="productListing-rowheading">Winners Name</td>
    <td class="productListing-rowheading">City State</td>
    <td class="productListing-rowheading">Contest Date</td>
    <td class="productListing-rowheading">Prize</td>
  </tr>
  <tr>
    <td>Skip Water</td>
    <td>City State</td>
    <td>10/30/2008</td>
    <td>$25.00 Gift Card</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>
</center>
<!-- eof define_contestwinner -->

[TinMan780]

That works perfectly! Thanks so very much Skip

[bookwise]

I have just tried to install the contest mod on a fresh install of Zen Cart v1.3.9h running on MySQL 5.1.56 and 5.2.16 (Zend: 2.2.0)

When I tried to run the install-sql-contest-v1.6.4.php in Zen Cart admin I got the following error

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'in:
[ 11.06.08 To run place this file in your admin folder and then point your browser to it http://www.yoursite.com/admin/instal...est-v1.6.4.php Added contestant_ip_address field 11/20/2008 Added DB PREFIX 01.31.09 Added CONTEST_DATE_DISPLAY_FORMAT 09/09/09 Added CONTEST_REVIEWS_REQUIRED 11.19.2010 */ require('includes/application_top.php');]
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.

I am wondering if I have misunderstood the instructions with respect to the install-sql-contest-v1.6.4.php file. Please help by clarifying what I need to do to make this mod work. Thank you for your time

[TinMan780]

http://www.yoursite.com/install-sql-contest-v1.6.4.php
installs the sql

[bookwise]

Tried what you suggested Tinman and just get a broken link even though the file is definitely in the admin/includes folder

How would I manually add to the database?

[skipwater]

I have just tried to install the contest mod on a fresh install of Zen Cart v1.3.9h running on MySQL 5.1.56 and 5.2.16 (Zend: 2.2.0)

When I tried to run the install-sql-contest-v1.6.4.php in Zen Cart admin I got the following error

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'in:
[ 11.06.08 To run place this file in your admin folder and then point your browser to it http://www.yoursite.com/admin/instal...est-v1.6.4.php Added contestant_ip_address field 11/20/2008 Added DB PREFIX 01.31.09 Added CONTEST_DATE_DISPLAY_FORMAT 09/09/09 Added CONTEST_REVIEWS_REQUIRED 11.19.2010 */ require('includes/application_top.php');]
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.

I am wondering if I have misunderstood the instructions with respect to the install-sql-contest-v1.6.4.php file. Please help by clarifying what I need to do to make this mod work. Thank you for your time

bookwise

That error should not be. That is comment information within the php file.

Try this log in into you ZC admin.
Once logged in change your url to

http://www.yoursite.com/your_admin/install-sql-contest-v1.6.4.php

That should run install-sql-contest-v1.6.4.php

Skip