Contest System [support thread]

[sunflowertami]

YIPEE!!! that did it! Thanks!!!

sunflowertami and HeathenMagic

Here is the fix for your cherry_zen template and I have test on others and seems to work on all.
Replace this file with the zip attached here. Or you can just edit as below.
/includes/languages/english/html_includes/YOUR_TEMPLATE /define_contestend.php

<!-- bof define_contestend -->  
<div class='centerColumn' id='contest'>
<h1 id='contest-heading'><?php echo HEADING_TITLE; ?></h1>
	<div id='contest-content' class='content'>

	<table border="0" width="100%" cellspacing="10" cellpadding="10">
		<tr>
			<td class="pageHeading"" width=100% align="center" valign="top">
			<font size="5"><strong>CONTEST HAS ENDED</strong></font><br/>
			</td>
		</tr>
		<tr>
			<td class="main" align="center">
			<p class="biggerText"> <strong>There Will be a NEW contest soon please check back.</strong></p>
			</td>
		</tr>
	</table>

<!-- eof define_contestend DO NOT close with the two div -->

[chefouvi]

Hi SkipWater,
Thanks for a great Mod.
I just have a question.
I have admin profiles installed so it is denying me to run the install-sql-contest-v1.3.php file.
Could you please give me the sql statements to run so that I can run them through Phpadmin or zencart sql patch installer?

I'd really appreciate it.

Thanks for such great work.

Chefouvi

[skipwater]

Hi SkipWater,
Thanks for a great Mod.
I just have a question.
I have admin profiles installed so it is denying me to run the install-sql-contest-v1.3.php file.
Could you please give me the sql statements to run so that I can run them through Phpadmin or zencart sql patch installer?

I'd really appreciate it.

Thanks for such great work.

Chefouvi

After reading kuroi's Admin Profiles Support Thread it seems all you have to do is give yourself permission to run the file. http://www.zen-cart.com/forum/showpo...&postcount=673

You will also have to give yourself permission to run the admin side of Contest System.

Skip

[beadfaery]

Hi,
I've just installed this mod and am very excited to get it up and running.
I've gone wrong somewhere though
I've uploaded all the files.....but there is nothing in my Admin-config

Dumb question....but......
I assume I need to install an sql into the 'install SQL patches' area in my admin.....but where is this sql patch in the mod?

[beadfaery]

OK....have been trying to figure this out for hours now

what do you mean by "run the install-sql-contest-v1.3.php file." ???
How and where do I do this

This is driving me crazy .....I know when I get the answer it's going to be obvious LOL!

[lankeeyankee]

OK....have been trying to figure this out for hours now

what do you mean by "run the install-sql-contest-v1.3.php file." ???
How and where do I do this

This is driving me crazy .....I know when I get the answer it's going to be obvious LOL!

you need open that file in your browser, so go to your_domain.com/admin(or whatever your admin is called)/install-sql-contest-v1.3.php. Once it's done you just need to click the back button to get back to the admin panel and you will see the 2 menus, 1 in configuration and one in reports.

[beadfaery]

you need open that file in your browser, so go to your_domain.com/admin(or whatever your admin is called)/install-sql-contest-v1.3.php. Once it's done you just need to click the back button to get back to the admin panel and you will see the 2 menus, 1 in configuration and one in reports.

Thank you, thank you, THANK YOU

Now I have one more problem still....when I click on 'Contest Prize Entries' in Reports, I get an error page (500 Internal Server Error) that says:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.


any idea what's wrong?

[beadfaery]

It's OK
I've worked it all out and it's up and running

Thanks again for such a fantastic mod!!

[divaboutiques]

Itrying to figure out 2 problems I'm having:

1st. I am getting an error on the Contestants Entries that is showing in the admin panel

This is the error
1146 Table 'divabou_zc2.contest' doesn't exist
in:
[SELECT `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.

2nd. I would like to know how to add the picture of the item I am giving away in the "Enter to win" side box?

[skipwater]

Itrying to figure out 2 problems I'm having:

1st. I am getting an error on the Contestants Entries that is showing in the admin panel

This is the error
1146 Table 'divabou_zc2.contest' doesn't exist
in:
[SELECT `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.

2nd. I would like to know how to add the picture of the item I am giving away in the "Enter to win" side box?

Item 1.
Change old line to new line.

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

Item 2.
Locate /includes/templates/YOUR_TEMPLATE/sideboxes/tpl_contest_sidebox.php
and add/replace lines as shown below. This is going to hard code the image so every time you change your prize you will need to change this image. I will most likely add this to a update.

// 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="images/click_to_enter_contest.gif" alt="Our Contest" border="0" title="ENTER TO WIN - Our contest gives away one prize to the winning contestent."/></a>';
  $content .= '</div>'; 

As an added option you can place a link shown below to any definepage on your site.

<?php echo '<a href="'.zen_href_link("contest").'"><img src="images/click_to_enter_contest.gif" alt="Our Contest" border="0" title="ENTER TO WIN - Our contest gives away one prize to the winning contestent."/></a>';?>

Skip