Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Sign in to follow this  
Benjjj6

Prize Draw Competition help

Recommended Posts

I was a little to fast, a small problem occurs. See image below:

 

prizeraw-fault.gif

 

The questions and the answer is filled in but the answers aren't showing in the prizedraw page.

and that one is a real problem for me.

 

So if somebody knows what goes wrong, please help me.

 

regards,

Jan

 

21.20u. The answers (3) are not written to the DB :(

only the Competition Question and competition Answer

Edited by jan64

Dreams can come true, if you help them a littlebit

Share this post


Link to post
Share on other sites
21.20u. The answers (3) are not written to the DB :(

only the Competition Question and competition Answer

 

These entries are required to be added manually to your configuration file.

 

INSERT INTO `database name`.`configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (NULL, 'Competition Answer A', 'COMPETITION_ANSWER_A', '', '', 'XXX', NULL, NULL, '', NULL, NULL), (NULL, 'Competition Answer B', 'COMPETITION_ANSWER_B', '', '', 'XXX', NULL, NULL, '', NULL, NULL),(NULL, 'Competition Answer C', 'COMPETITION_ANSWER_C', '', '', '', 'XXX', NULL, '', NULL, NULL);

 

 

Database name needs replacing with the name of the database you are using for your shop.

XXX should be replaced with the same configuartion id as the other entries for the competion have. This should ressolve your display issue once inserted.

Using the SQL in php my admin enter the code and select go, your database name if you do not know it, can be found in php my admin.

 

 

I thought there was a mention of these values requiring entering into your database but I didnt know how to update the auto file. If you use the above code.

 

You have the java calender ?


Getting better with mods but no programmer am I.

Share this post


Link to post
Share on other sites

Hi Jan,

 

 

I guess you are saying you have the java calender now and that the reason why it did not display before is due to some of the code is lower case and some upper case.

 

The code in the admin/stats_prizedraw file is correct I believe and it should be a straight swap, file for file.

Same as the catalog/competition.php

 

then theres just the database entry of the 3 new options.

 

Let us know if you have any problems.

 

Thanks

Johnny


Getting better with mods but no programmer am I.

Share this post


Link to post
Share on other sites

Hi John,

 

Thanks for the help!

 

The java calender problem was a known issue for another contri in the dutch forum a while ago.

i remembred that and saw that it was the same in the prizedraw script. so that solved it for me.

 

I try to run the SQL and you hear from me.

 

Regards.

Jan

Edited by jan64

Dreams can come true, if you help them a littlebit

Share this post


Link to post
Share on other sites
These entries are required to be added manually to your configuration file.

 

INSERT INTO `database name`.`configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (NULL, 'Competition Answer A', 'COMPETITION_ANSWER_A', '', '', 'XXX', NULL, NULL, '', NULL, NULL), (NULL, 'Competition Answer B', 'COMPETITION_ANSWER_B', '', '', 'XXX', NULL, NULL, '', NULL, NULL),(NULL, 'Competition Answer C', 'COMPETITION_ANSWER_C', '', '', '', 'XXX', NULL, '', NULL, NULL);

 

 

Database name needs replacing with the name of the database you are using for your shop.

XXX should be replaced with the same configuartion id as the other entries for the competion have. This should ressolve your display issue once inserted.

Using the SQL in php my admin enter the code and select go, your database name if you do not know it, can be found in php my admin.

 

 

I thought there was a mention of these values requiring entering into your database but I didnt know how to update the auto file. If you use the above code.

 

 

You have the java calender ?

 

 

maybe stupid question, but what do you mean by: "XXX should be replaced with the same configuartion id as the other entries for the competion have" where can i find those id?


Dreams can come true, if you help them a littlebit

Share this post


Link to post
Share on other sites
maybe stupid question, but what do you mean by: "XXX should be replaced with the same configuartion id as the other entries for the competion have" where can i find those id?

 

Whoops configuration_group_id rather than configuration_id (configuration_id should all be different)

 

If you go to your configuration table in your database, Use search, in the title use search %like% enter competition in the text box and go or its ducth equivalent.

 

You should find all the entries for the competition mod, all of these should have the same configuration_group_id in my case ion the last install it was 16, so I would have replaced all the XXX by 16, but if you have lots of mods it could will be any number much higher than this.


Getting better with mods but no programmer am I.

Share this post


Link to post
Share on other sites

Mine ID was much higher 748, but that did it, it works.

But the admin looks like this, is that correct?

there is no answer "C" or is it not showing because its the answer?

 

prizedraw1.gif

Edited by jan64

Dreams can come true, if you help them a littlebit

Share this post


Link to post
Share on other sites
Mine ID was much higher 748, but that did it, it works.

But the admin looks like this, is that correct?

there is no answer "C" or is it not showing because its the answer?

 

prizedraw1.gif

 

 

You should have Answer A, Answer B and Answer C showing. I have column counted and worked out the problem.

 

If you go the configuration table, find answer C, and enter 748 in the configuartion_group_id column and remove the 748 in the sort column, it will be displayed properly.

 

The XXX was in the wrong place for Answer C sorry, the code should read as follows:-

 

INSERT INTO `database name`.`configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (NULL, 'Competition Answer A', 'COMPETITION_ANSWER_A', '', '', 'XXX', NULL, NULL, '', NULL, NULL), (NULL, 'Competition Answer B', 'COMPETITION_ANSWER_B', '', '', 'XXX', NULL, NULL, '', NULL, NULL),(NULL, 'Competition Answer C', 'COMPETITION_ANSWER_C', '', '', 'XXX', NULL, NULL, '', NULL, NULL);

Edited by johnnybebad

Getting better with mods but no programmer am I.

Share this post


Link to post
Share on other sites

John,

 

Thank you verry much for your help, it works!

 

I test the contri totaly asap.

a quick test showed that the problem with the double emailadress is solved, it generated an sql error by me at the time and now you get a message that you can use the emailadress once. verry nice.

 

one question, the "qualifying question" whats the purpose of that?

when i disabled that option you only have to fill in your emailadress.

in other words you fill in your emailadress is thats all to make a change on the price. did i understand it correct?

 

i translate the contri for you in duch, i hope that to do this year, and upload it.

 

Happy Holidays!

 

Jan

Edited by jan64

Dreams can come true, if you help them a littlebit

Share this post


Link to post
Share on other sites
John,

 

Thank you verry much for your help, it works!

 

I test the contri totaly asap.

a quick test showed that the problem with the double emailadress is solved, it generated an sql error by me at the time and now you get a message that you can use the emailadress once. verry nice.

 

one question, the "qualifying question" whats the purpose of that?

when i disabled that option you only have to fill in your emailadress.

in other words you fill in your emailadress is thats all to make a change on the price. did i understand it correct?

 

i translate the contri for you in duch, i hope that to do this year, and upload it.

 

Happy Holidays!

 

Jan

 

The idea of a qualifying question, is to get the customer to validate there entry, by answering a simply question and this may make it harder for automate submissions to be made, although not so sure it makes it so difficult for auto submissions though.

 

Otherwise you may get a lot of names and/ or email addresses being submitted that are bogus.

 

In admin you can select a winner of your draw, by selecting yes to validate, so the customer would have had to get the question correct to be drawn out of the hat so to speak.

 

Now if like me you want to generate traffic, and pages viewed you can use the question to get the potential customer to look for something hidden on your site and theres a clue in the question where to find the answer.

 

If someone guesses the answer they have a 33.3% chance of getting it right as it stands, unless you introduce more options, and thats easy enough by extending the code to D, E, F through to Z if your mad enough to have 26 options, just have to make the extra additions to the two files, and insert the extra rows in the configuration table.

 

Glad it works okay for you.

 

Johnny


Getting better with mods but no programmer am I.

Share this post


Link to post
Share on other sites

Goodmorning,

 

 

Best wishes everybody for 2009!

 

Jonh, i have a question, Prize draw is working perfect.

but one thing i don't understand, what is the difference between validated and non validated?

 

regards.

Jan


Dreams can come true, if you help them a littlebit

Share this post


Link to post
Share on other sites
Goodmorning,

 

 

Best wishes everybody for 2009!

 

Jonh, i have a question, Prize draw is working perfect.

but one thing i don't understand, what is the difference between validated and non validated?

 

regards.

Jan

Jan, in it simpliesty terms.

 

A validated entry, requires the entrant to answer a question correctly

A non validated entry requires them to answer the question but it does not matter if the answer it correctly or not.

If you do not have a validatation question switched on, the entrants need to submit there name and e-mail address only.


Getting better with mods but no programmer am I.

Share this post


Link to post
Share on other sites

I have version 1.2 installed and am running into the duplicate email error like previously posted. I was going to go to the new version but the i dont see any instructions on upgrading to different versions. Can someone tell me what I need to change etc in the new version if you were running the previous version. Thanks! Michelle

eta- I changed the catalog/competition file but then it just kicks you to a login screen

Edited by plazman65

Share this post


Link to post
Share on other sites

Hi Michelle,

 

sorry about the instructions, to upgrade from V1.2

 

Download the new contribution.

 

replace these files

1. stats_prize_draw.php in admin

2. competition.php in the catalog directory (this is the directory os commerce is installed in).

 

with those in the contribution.

 

go into php my admin, go to sql, copy and paste the code and select go:-

 

INSERT INTO `database name`.`configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (NULL, 'Competition Answer A', 'COMPETITION_ANSWER_A', '', '', 'XXX', NULL, NULL, '', NULL, NULL), (NULL, 'Competition Answer B', 'COMPETITION_ANSWER_B', '', '', 'XXX', NULL, NULL, '', NULL, NULL),(NULL, 'Competition Answer C', 'COMPETITION_ANSWER_C', '', '', 'XXX', NULL, NULL, '', NULL, NULL);

 

That should be ready to go any problems let us know

 

Johnny


Getting better with mods but no programmer am I.

Share this post


Link to post
Share on other sites
I have version 1.2 installed and am running into the duplicate email error like previously posted. I was going to go to the new version but the i dont see any instructions on upgrading to different versions. Can someone tell me what I need to change etc in the new version if you were running the previous version. Thanks! Michelle

eta- I changed the catalog/competition file but then it just kicks you to a login screen

 

Hi I have just downloaded the contribution and checked, the instructions are are in the file prize draw v1.3 install, just scroll down and down until you get to the upgrade section, got a lot of empty space in the file.

 

The instructions in my previous post are the same, except I have given you code for you to update the database rather than to enter the fields manually, which should make things easier.

 

You must have version 1.2 installed first for it to work as there are only two files to swap and an extra database entry.


Getting better with mods but no programmer am I.

Share this post


Link to post
Share on other sites
Guest

ok i have installed this but whether i have allow guest or allow enterants it just keeps going to login screen even when people are logged in...any ideas?

Share this post


Link to post
Share on other sites
Guest

ok ignore my comment above being directed to login screen i swaped the competition.php file to one of the earlier zip files. Jonnybebads first contribution to be exact.

Share this post


Link to post
Share on other sites
Jan, in it simpliesty terms.

 

A validated entry, requires the entrant to answer a question correctly

A non validated entry requires them to answer the question but it does not matter if the answer it correctly or not.

If you do not have a validatation question switched on, the entrants need to submit there name and e-mail address only.

 

Sorry for my late reaction, but better now than never.

Ok i understand it. everything works fine.

 

Reagrds,

Jan


Dreams can come true, if you help them a littlebit

Share this post


Link to post
Share on other sites

Okay people wondered if you can help me.

 

A few days ago I was asked about the terms and conditions popup window, as in the contest file.

 

Having had a look at it I have got the popup to work okay.

 

However I am having trouble with a few things and getting them automated , these are:-

 

1. Prize details in the terms and conditions as all threee items, and as for a) and c) individually

a) prize title/name

B) prize description

c) prize value

 

2. The locations in applicable law, and disputes (STORE_LOCATION and STORE_PROVINCE_STATE posssibly due to mods I dont have?) this is not overly important as I would remove/ change this for my own country and most will do the same, there are several sections that need to be changed to make it appropriate for your own country.

 

if anyone can help with these, and as a prioity section I would be more than gratefull, the code i have so far is as follows.

 

catalog/includes/languages/english/popup_competition.php

<?php
/*
 $Id: popup_competition.php,v 1.0 2002/11/19 01:48:08 dgw_ Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2002 osCommerce

 Released under the GNU General Public License
*/

define('HEADING_TITLE', 'Official Contest Rules & Regulations');

define('TEXT_CLOSE_WINDOW', 'Close Window');
/*  NOTE THIS IS FROM ORIGINAL FILE AND NOT REQUIRED
define('STORE_NAME', '' . STORE_NAME);			   [b]already defined[/b]
define('STORE_NAME_ADDRESS', '' . STORE_NAME_ADDRESS); [b]already defined[/b]
define('STORE_WEB_ADDRESS', 'http://' . STORE_WEB_ADDRESS); [b]haves used a define[/b]
define('STORE_LOCATION', STORE_PROVINCE_STATE . ', ' . STORE_COUNTRY); [b]havent looked at yet[/b]
*/

define('TEXT_INFORMATION', '
<p><font face="Arial, Helvetica, sans-serif" size="1"><b><u>PRIZES </b></u></font></p>
<p><font face="Arial, Helvetica, sans-serif" size="1"> Prize Description: This is a description of a great prize. Maybe a trip of a lifetime or a one of a kind watchamacallit or a rare thingamabobby. Maybe just a run of the mill hat or T-shirt. But its FREE  
Contest Rules No Purchase Necessary To Enter 
United States Residents Only 
VOID WHERE PROHIBITED

1. The Test Prize 1 promotion is sponsored by, 
This ' . STORE_NAME . '
' . STORE_WEB_ADDRESS . '</font></p> 

<p><font face="Arial, Helvetica, sans-serif" size="1"><b><u>PRIVACY </b></u></font></p>
<p><font face="Arial, Helvetica, sans-serif" size="1">1. One winner of ' . STORE_NAME . ' will be selected by random, drawn from all eligible entries received. Odds of winning depend on the number of entries received. The Contest is offered only in the United States. Void where prohibited.</font></p> 

<p><font face="Arial, Helvetica, sans-serif" size="1">2. The Test Prize 1 starts on ' . tep_date_long(COMPETITION_START_DATE) . ' and the deadline for entries is at ' . tep_date_long(COMPETITION_CLOSE_DATE) . '. Mail in entries must be delivered by ' . tep_date_long(COMPETITION_CLOSE_DATE) . '  to be 
valid. ' . STORE_NAME . ' is not responsible for late, lost, misdirected, or mislabeled postcards</font></p>

<p><font face="Arial, Helvetica, sans-serif" size="1">3. The Contest is open only to legal residents of the 50 United States and the District of Columbia%%Restrictions%% Employees, officers and directors of Sponsor and Promoters (including but not limited to ' . STORE_NAME . '), their respective related companies and agents, as well as the immediate family (defined as parents, spouse, children, siblings and grandparents) and household members of each such employee, officer and director are not eligible to enter. By participating, entrant agrees to abide by these Official Rules and the decisions of the Sponsor, which are final and binding in all respects.</font></p> 

<p><font face="Arial, Helvetica, sans-serif" size="1">4. Entries are limited to the following methods. Online through the form at this site. Alternate entry is by mailing, in a standard envelope, a 4x6 inch index card with your NAME, ADDRESS, CITY, STATE, ZIP CODE, PHONE NUMBER, and AGE printed in block letters to 

' . STORE_NAME . ',' . STORE_NAME_ADDRESS . '
All entries must be received by ' . tep_date_long(COMPETITION_CLOSE_DATE) . ' to be valid. Illegible entried will be considered void. All entries become the exclusive property of the Sponsor, and none will be acknowledged or returned. Proof of sending will not be deemed to be proof of receipt by Sponsor.</font></p> 

<p><font face="Arial, Helvetica, sans-serif" size="1">5. On or about ' . tep_date_long(COMPETITION_CLOSE_DATE) . ', Sponsor will randomly select one (1) winner from among all entrants. Entrant selected must comply with all terms and conditions of these Official Rules, and winning is contingent upon fulfilling all requirements. The potential winner will be notified by email within three (3) days of the drawing with a request for their address. The potential winner must respond within three (3) days. Within three (3) days from receipt of winners address%%Release%%</font></p> 

<p><font face="Arial, Helvetica, sans-serif" size="1">6. The Test Prize 1 has a retail value of 2.00 
This is a description of a great prize. Maybe a trip of a lifetime or a one of a kind watchamacallit or a rare thingamabobby. Maybe just a run of the mill hat or T-shirt. But its FREE 
No substitution, assignment or transfer of prize permitted. Winner is solely responsible for any and all applicable fees and taxes associated with prize receipt and use. Winners of prizes or awards in excess of $600.00 will receive a tax form MISC-1099 to declare their winnings for tax purposes.</font></p> 

<p><font face="Arial, Helvetica, sans-serif" size="1">7. Except where prohibited, participation in the Test Prize 1 Contest constitutes winner\'s consent to Sponsor\'s use of winner\'s name, likeness, voice, opinions, hometown and state for promotional purposes in any media without further payment or consideration.</font></p> 

<p><font face="Arial, Helvetica, sans-serif" size="1">8. Sponsor reserves the right to cancel or modify the Contest if fraud, technical failures or any other factor beyond Sponsor\'s reasonable control impairs the integrity of the Contest, as determined by Sponsor in its sole discretion. In such event, Sponsor reserves the right to award the prize at random from among the eligible entries received up to the time of the impairment. Sponsor reserves the right in its sole discretion to disqualify any individual it finds to be tampering with the entry process or the operation of the Contest or to be acting in violation of these Official Rules or in an unsportsmanlike or disruptive manner. Any attempt by any person to deliberately damage Sponsor\'s or any Promoter\'s Web site or undermine the legitimate operation of this Contest may be a violation of criminal and civil laws and, should such an attempt be made, Sponsor and Promoters reserve the right to seek damages from any such person to the fullest extent permitted by law. Sponsor\'s failure to enforce any term of these Official Rules shall not constitute a waiver of that provision.</font></p> 

<p><font face="Arial, Helvetica, sans-serif" size="1">9. Entrant agrees that: (1) any and all disputes, claims, and causes of action arising out of or connected with this Contest or any prizes awarded shall be resolved individually, without resort to any form of class action, and exclusively by appropriate MI State Court located closest to Chesterfield, New Baltimore, MI; (2) any and all claims, judgments and awards shall be limited to actual out-of-pocket costs incurred, including costs associated with entering this Contest but in no event attorneys\' fees; and (3) under no circumstances will entrant be permitted to obtain awards for and entrant hereby waives all rights to claim punitive, incidental and consequential damages and any other damages, other than for actual out- of-pocket expenses, and any and all rights to have damages multiplied or otherwise increased. SOME JURISDICTIONS DO NOT ALLOW THE LIMITATION OR EXCLUSION OF LIABILITY FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES, SO THE ABOVE MAY NOT APPLY TO YOU. All issues and questions concerning the construction, validity, interpretation and enforceability of these Official Rules, or the rights and obligations of the entrant, Sponsor and Promoter in connection with the Contest, shall be governed by, and construed in accordance with, the laws of the State of MI, without giving effect to any choice of law or conflict of law rules (whether of the State of MI or any other jurisdiction), which would cause the application of the laws of any jurisdiction other than the State of MI. All federal, state and local laws and regulations apply. Entrant agrees to receive at least one (1) email newsletter to the email address supplied by the entry process after which the entrant may opt-out, afterwhich the Name and address stored in the newsletter database will be deleted.</font></p> 

<p><font face="Arial, Helvetica, sans-serif" size="1">For the name, city and state/province of the winner and/or a set of Official Rules send a self addressed, stamped envelope to ' . STORE_NAME_ADDRESS . ' . Requests must be received no later than 30 days after contest deadline.</font></p>

<p><font face="Arial, Helvetica, sans-serif" size="1">All content included on 
 this site, such as text, graphics, logos, button icons, images, audio clips, 
 digital downloads, data compilations, and software, is the property of ' . STORE_NAME . ' 
 or its content suppliers and protected by Canadian and international copyright 
 laws. The compilation of all content on this site is the exclusive property 
 of ' . STORE_NAME . ', with copyright authorship for this collection by <a href="' . STORE_WEB_ADDRESS . '" target="_blank"><b>' . STORE_NAME . '</b></a>, and protected by Canadian and international copyright laws. 
 The software application provider and author for "osCommerce", is 
 used under the GNU GENERAL PUBLIC LICENSE and all original authorship and credit 
 for osCommerce remains the intellectual rights of www.oscommerce.com.</font></p>


<p><font face="Arial, Helvetica, sans-serif" size="1"><b><u>APPLICABLE LAW </b></u></font></p>
<p><font face="Arial, Helvetica, sans-serif" size="1">By visiting ' . STORE_NAME . ', 
 you agree that the Canadian laws of the province of ' . STORE_PROVINCE_STATE . ', without regard to principles 
 of conflict of laws, will govern these Conditions of Use and any dispute of 
 any sort that might arise between you and ' . STORE_NAME . ' or its associates. </font></p>
<p><font face="Arial, Helvetica, sans-serif" size="1"><b><u>DISPUTES</b></u></font></p>
<p><font face="Arial, Helvetica, sans-serif" size="1">Any dispute relating in 
 any way to your visit to ' . STORE_NAME . ' or to products you purchase through ' . STORE_NAME . ' shall be submitted to confidential arbitration in ' . STORE_LOCATION . ', except that, 
 to the extent you have in any manner violated or threatened to violate ' . STORE_NAME . 's 
 intellectual property rights, ' . STORE_NAME . ' may seek injunctive or other appropriate 
 relief in any provincial court in the province of ' . STORE_PROVINCE_STATE . ', and you consent 
 to exclusive jurisdiction and venue in such courts. Arbitration under this agreement 
 shall be conducted under the rules then prevailing of the AMIC - Arbitration and Mediation Institute of ' . STORE_COUNTRY . '. The arbitrators award shall be binding and may be entered as a 
 judgment in any court of competent jurisdiction. To the fullest extent permitted 
 by applicable law, no arbitration under this Agreement shall be joined to an 
 arbitration involving any other party subject to this Agreement, whether through 
 class arbitration proceedings or otherwise. </font></p>

<p><font face="Arial, Helvetica, sans-serif" size="1"><b><u>QUESTIONS:</b></u></font></p>
<p><font face="Arial, Helvetica, sans-serif" size="1">Questions regarding our 
 Conditions of Usage, Privacy Policy, or other policy related material can be 
 directed to our support staff by clicking on the "Contact Us" link 
 in the side menu. Or you can email us at: <b><a href="mailto: ' . STORE_OWNER_EMAIL_ADDRESS . '">' . STORE_OWNER_EMAIL_ADDRESS . '</a></b></font></p>
');
?>

 

 

catalog/popup_competition.php

 

<?php
/*
 $Id: popup_competition,v 1.0 2003/06/05 23:26:23 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

 $navigation->remove_current_page();

 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_POPUP_COMPETITION);
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<title> <?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>

<body marginwidth="10" marginheight="10" topmargin="10" bottommargin="10" leftmargin="10" rightmargin="10">
<br>

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
  <tr>
	<td><table border="0" align="center" width="85%" cellspacing="0" cellpadding="0">
	 <br>
	  <tr>
		<td class="pageHeading" valign="top"><img src="images/store_logo.png" alt="<?php echo STORE_NAME; ?>"></td>
		<td class="smallText" align="right" valign="top"><?php echo '[ <a href="java script:window.close()"><b>' . TEXT_CLOSE_WINDOW . '</b></a> ] '; ?></td>
	  </tr>
	</table></td>
  </tr>

  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>	  

 <tr>
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
  <tr>
	<td><table border="0" align="center" width="85%" cellspacing="0" cellpadding="0">
	<br>
	  <tr>
		<td class="main" valign="top"><font color="#0000FF"><small><b><?php echo HEADING_TITLE; ?><small></b></font></td>
		<td class="pageHeading" align="right"></td>
	  </tr>			

	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
	  <tr>
		<td class="main"><?php echo TEXT_INFORMATION; ?></td>
	  </tr>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
	</table></td>
  </tr>

  <tr>
	<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
	  <tr>
		<td><table border="0" align="center" width="85%" cellspacing="0" cellpadding="0">
		<br>
		  <tr>
			<td class="pageHeading" valign="top"></td>
			<td class="smallText" align="right" valign="top"><?php echo '[ <a href="java script:window.close()"><b>' . TEXT_CLOSE_WINDOW . '</b></a> ] '; ?><br><br><br></td>
		  </tr>
		</table></td>
	  </tr>	  

</body>
</html>

<?php require('includes/application_bottom.php'); ?>

 

 

it looks like this as it stands.

 

 

[ Close Window ]

 

 

 

 

Official Contest Rules & Regulations

 

 

 

PRIZES

Prize Description: This is a description of a great prize. Maybe a trip of a lifetime or a one of a kind watchamacallit or a rare thingamabobby. Maybe just a run of the mill hat or T-shirt. But its FREE Contest Rules No Purchase Necessary To Enter United States Residents Only VOID WHERE PROHIBITED 1. The Test Prize 1 promotion is sponsored by, This shop1 http://yourwebsite.com

PRIVACY

1. One winner of shop1 will be selected by random, drawn from all eligible entries received. Odds of winning depend on the number of entries received. The Contest is offered only in the United States. Void where prohibited.

2. The Test Prize 1 starts on Wednesday 28 January, 2009 and the deadline for entries is at Thursday 29 January, 2009. Mail in entries must be delivered by Thursday 29 January, 2009 to be valid. shop1 is not responsible for late, lost, misdirected, or mislabeled postcards

3. The Contest is open only to legal residents of the 50 United States and the District of Columbia%%Restrictions%% Employees, officers and directors of Sponsor and Promoters (including but not limited to shop1), their respective related companies and agents, as well as the immediate family (defined as parents, spouse, children, siblings and grandparents) and household members of each such employee, officer and director are not eligible to enter. By participating, entrant agrees to abide by these Official Rules and the decisions of the Sponsor, which are final and binding in all respects.

4. Entries are limited to the following methods. Online through the form at this site. Alternate entry is by mailing, in a standard envelope, a 4x6 inch index card with your NAME, ADDRESS, CITY, STATE, ZIP CODE, PHONE NUMBER, and AGE printed in block letters to shop1,Store Name Address Country Phone All entries must be received by Thursday 29 January, 2009 to be valid. Illegible entried will be considered void. All entries become the exclusive property of the Sponsor, and none will be acknowledged or returned. Proof of sending will not be deemed to be proof of receipt by Sponsor.

5. On or about Thursday 29 January, 2009, Sponsor will randomly select one (1) winner from among all entrants. Entrant selected must comply with all terms and conditions of these Official Rules, and winning is contingent upon fulfilling all requirements. The potential winner will be notified by email within three (3) days of the drawing with a request for their address. The potential winner must respond within three (3) days. Within three (3) days from receipt of winners address%%Release%%

6. The Test Prize 1 has a retail value of 2.00 This is a description of a great prize. Maybe a trip of a lifetime or a one of a kind watchamacallit or a rare thingamabobby. Maybe just a run of the mill hat or T-shirt. But its FREE No substitution, assignment or transfer of prize permitted. Winner is solely responsible for any and all applicable fees and taxes associated with prize receipt and use. Winners of prizes or awards in excess of $600.00 will receive a tax form MISC-1099 to declare their winnings for tax purposes.

7. Except where prohibited, participation in the Test Prize 1 Contest constitutes winner's consent to Sponsor's use of winner's name, likeness, voice, opinions, hometown and state for promotional purposes in any media without further payment or consideration.

8. Sponsor reserves the right to cancel or modify the Contest if fraud, technical failures or any other factor beyond Sponsor's reasonable control impairs the integrity of the Contest, as determined by Sponsor in its sole discretion. In such event, Sponsor reserves the right to award the prize at random from among the eligible entries received up to the time of the impairment. Sponsor reserves the right in its sole discretion to disqualify any individual it finds to be tampering with the entry process or the operation of the Contest or to be acting in violation of these Official Rules or in an unsportsmanlike or disruptive manner. Any attempt by any person to deliberately damage Sponsor's or any Promoter's Web site or undermine the legitimate operation of this Contest may be a violation of criminal and civil laws and, should such an attempt be made, Sponsor and Promoters reserve the right to seek damages from any such person to the fullest extent permitted by law. Sponsor's failure to enforce any term of these Official Rules shall not constitute a waiver of that provision.

9. Entrant agrees that: (1) any and all disputes, claims, and causes of action arising out of or connected with this Contest or any prizes awarded shall be resolved individually, without resort to any form of class action, and exclusively by appropriate MI State Court located closest to Chesterfield, New Baltimore, MI; (2) any and all claims, judgments and awards shall be limited to actual out-of-pocket costs incurred, including costs associated with entering this Contest but in no event attorneys' fees; and (3) under no circumstances will entrant be permitted to obtain awards for and entrant hereby waives all rights to claim punitive, incidental and consequential damages and any other damages, other than for actual out- of-pocket expenses, and any and all rights to have damages multiplied or otherwise increased. SOME JURISDICTIONS DO NOT ALLOW THE LIMITATION OR EXCLUSION OF LIABILITY FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES, SO THE ABOVE MAY NOT APPLY TO YOU. All issues and questions concerning the construction, validity, interpretation and enforceability of these Official Rules, or the rights and obligations of the entrant, Sponsor and Promoter in connection with the Contest, shall be governed by, and construed in accordance with, the laws of the State of MI, without giving effect to any choice of law or conflict of law rules (whether of the State of MI or any other jurisdiction), which would cause the application of the laws of any jurisdiction other than the State of MI. All federal, state and local laws and regulations apply. Entrant agrees to receive at least one (1) email newsletter to the email address supplied by the entry process after which the entrant may opt-out, afterwhich the Name and address stored in the newsletter database will be deleted.

For the name, city and state/province of the winner and/or a set of Official Rules send a self addressed, stamped envelope to Store Name Address Country Phone . Requests must be received no later than 30 days after contest deadline.

All content included on this site, such as text, graphics, logos, button icons, images, audio clips, digital downloads, data compilations, and software, is the property of shop1 or its content suppliers and protected by Canadian and international copyright laws. The compilation of all content on this site is the exclusive property of shop1, with copyright authorship for this collection by shop1, and protected by Canadian and international copyright laws. The software application provider and author for "osCommerce", is used under the GNU GENERAL PUBLIC LICENSE and all original authorship and credit for osCommerce remains the intellectual rights of www.oscommerce.com.

APPLICABLE LAW

By visiting shop1, you agree that the Canadian laws of the province of STORE_PROVINCE_STATE, without regard to principles of conflict of laws, will govern these Conditions of Use and any dispute of any sort that might arise between you and shop1 or its associates.

DISPUTES

Any dispute relating in any way to your visit to shop1 or to products you purchase through shop1 shall be submitted to confidential arbitration in STORE_LOCATION, except that, to the extent you have in any manner violated or threatened to violate shop1s intellectual property rights, shop1 may seek injunctive or other appropriate relief in any provincial court in the province of STORE_PROVINCE_STATE, and you consent to exclusive jurisdiction and venue in such courts. Arbitration under this agreement shall be conducted under the rules then prevailing of the AMIC - Arbitration and Mediation Institute of 223. The arbitrators award shall be binding and may be entered as a judgment in any court of competent jurisdiction. To the fullest extent permitted by applicable law, no arbitration under this Agreement shall be joined to an arbitration involving any other party subject to this Agreement, whether through class arbitration proceedings or otherwise.

QUESTIONS:

Questions regarding our Conditions of Usage, Privacy Policy, or other policy related material can be directed to our support staff by clicking on the "Contact Us" link in the side menu. Or you can email us at: sales@yourwebsite.com

 

 

 

 

 

[ Close Window ]


Getting better with mods but no programmer am I.

Share this post


Link to post
Share on other sites

I am code stupid and tried doing this install. Here is what I get when I log in to admin/reports/prizedraw Can someone tell me what I did wrong?

 

Prize Draw Entries

1146 - Table 'skateboa_store.contest' doesn't exist

 

SELECT competition_code, COUNT(competition_code) AS num_entries from contest group by competition_code ASC

 

[TEP STOP]

 

________________________________________________________________________________

___________________________-

 

Also on mainpage my info box for prize draw has disappeared. I know I am going to have to reinstall this program again but don't know if I should reinstall first before my other mods or last???

 

My other mods are:

 

template for gray site

shop by brand

black buttons

and specials on front page.

 

Because I am code stupid I really need to install these in the easiest manner. I really don't want to modify index.php and then replace it with another mods.

 

Thanks for the help.

Share this post


Link to post
Share on other sites
Guest

what ver # are you using? did you run the installer?

Share this post


Link to post
Share on other sites

Okay, sounds like you do not have the database installed.

 

copy the code below and paste it into a new file names as prizedatabase.php into your catalog directory (the directory your shop is installed into)

 

then in the internet broswer catalog/prizedatabase.php and this should install your database in full for the competition.

 

You do not need to reinstall all your files for this mod just yet, it appears your competition has either expired, or you are missing a competition.php file from catalog/includes/boxes

 

I would check in your admin section first in reports to see if you have an active competition and if not then start a new test one valid for the same day to the day after you are setting it up, if there are no options in admin then you should check to see what files you do or dont have first installed, if you have all the competition files installed then you need to go through and edit specific files as stated in the instructions to get the competition up and running again.

 

 

 

 

<?php

	include("includes/application_top.php");

// Check if contest table already exists

$check_query = "show tables from " . DB_DATABASE . " like 'contest'";
$check_result = tep_db_query ($check_query);
  if (tep_db_num_rows($check_result) < 1)
{
// Create contest table
	$insert_query = "CREATE TABLE `contest` (
			  `id` DOUBLE NOT NULL AUTO_INCREMENT PRIMARY KEY,
			  `contestant_name` varchar(64) NOT NULL default '',
			  `contestant_email` varchar(96) NOT NULL default '',
			  `date_entered` date NOT NULL default '0000-00-00',
			  `validated` char(1) NOT NULL default '0',
			  `competition_code` varchar(10) NOT NULL default '',
			  `OMIT` varchar(1) NOT NULL default '',
			  UNIQUE KEY `contestant_email` (`contestant_email`,`competition_code`));";

			@$insert_result = tep_db_query($insert_query);
			if ($insert_result) echo 'New `Contest` Database Table Successfully Created.  ver 1.1 schema.<BR>';
			else { echo 'There was a problem in trying to create the database. You may need to do this manually using the following SQL code: <br>' . $insert_query; }

} else {
// alter table to v1.1

	$insert_query  = "ALTER TABLE `contest` ADD `OMIT` VARCHAR(1) NOT NULL;";

	@$insert_result = tep_db_query($insert_query);
			if ($insert_result) echo 'Altered `Contest` Database Table Successfully, to ver 1.1 schema.<BR>';
			else { echo 'There was a problem in trying to alter the database. You may need to do this manually using the following SQL code: <br>' . $insert_query; }

	$insert_query  = " ALTER TABLE `contest` ADD `id` DOUBLE NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;";

	@$insert_result = tep_db_query($insert_query);
			if ($insert_result) echo 'Altered `Contest` Database Table Successfully, to ver 1.1 schema.<BR>';
			else { echo 'There was a problem in trying to alter the database. You may need to do this manually using the following SQL code: <br>' . $insert_query; }



}


// Create new Configuration Category
$check_query = "SELECT `configuration_group_id` FROM `configuration_group` WHERE `configuration_group_title` = 'Competitions';";
$check_result = tep_db_query ($check_query);
  if (tep_db_num_rows($check_result) < 1)
{
   $insert_query1 = "INSERT INTO `configuration_group` VALUES (NULL, 'Competitions', 'Competiton Administraton', 20, 1);";
		 $insert_result1 = tep_db_query($insert_query1);
		 if ($insert_result1) echo 'Created New Configuration Group<br>';			 


} else {
	echo 'Configuration Group `Competition` already exists';
}

// Get the id of the new configuration category
   $insert_query2 = "SELECT `configuration_group_id` FROM `configuration_group` WHERE `configuration_group_title` = 'Competitions';";
		 $insert_result2 = tep_db_query($insert_query2);
		 $categoryid = tep_db_fetch_array($insert_result2); 
		 if ($insert_result2) echo 'Competition `Configuration_Group ID` = ' . $categoryid['configuration_group_id'] . '<br>'; 



// Create new Configuration Options

$check_query = "SELECT * FROM `configuration` WHERE `configuration_key` = 'COMPETITION_QUALIFY';";
$check_result = tep_db_query ($check_query);
  if (tep_db_num_rows($check_result) < 1)
{
// Insert configuration options
   $insert_query3 = "INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Display a qualifing question to enter competition', 'COMPETITION_QUALIFY', 'true', 'Displays the qualifing question and only allows entry upon its completion', '" . $categoryid['configuration_group_id'] . "', 8, '2007-04-06 22:01:43', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); ";
		 $insert_result3 = tep_db_query($insert_query3);
		 if ($insert_result3) echo 'Created New Configuration Object : `COMPETITION_QUALIFY`<br>';			 
}


$check_query = "SELECT * FROM `configuration` WHERE `configuration_key` = 'COMPETITION_ANSWER';";
$check_result = tep_db_query ($check_query);
  if (tep_db_num_rows($check_result) < 1)
{
   $insert_query3 = "INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Competition Answer', 'COMPETITION_ANSWER', 'B', 'Set the correct answer to your question', '" . $categoryid['configuration_group_id'] . "', 10, '2007-04-06 19:59:45', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''A'', ''B'',''C''),'); ";
		 $insert_result3 = tep_db_query($insert_query3);
		 if ($insert_result3) echo 'Created New Configuration Object : `COMPETITION_ANSWER`<br>';			 
}


$check_query = "SELECT * FROM `configuration` WHERE `configuration_key` = 'COMPETITION_QUESTION';";
$check_result = tep_db_query ($check_query);
  if (tep_db_num_rows($check_result) < 1)
{
   $insert_query3 = "INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Competition Question', 'COMPETITION_QUESTION', '*** type your qualifing question here', 'Enter in the question text that will be displayed', '" . $categoryid['configuration_group_id'] . "', 9, '2007-04-06 21:50:50', '0000-00-00 00:00:00', NULL, NULL); ";
		 $insert_result3 = tep_db_query($insert_query3);
		 if ($insert_result3) echo 'Created New Configuration Object : `COMPETITION_QUESTION` <br>';			 

}

$check_query = "SELECT * FROM `configuration` WHERE `configuration_key` = 'COMPETITION_CODE';";
$check_result = tep_db_query ($check_query);
  if (tep_db_num_rows($check_result) < 1)
{
   $insert_query3 = "INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Competition Reference Code', 'COMPETITION_CODE', '001', 'Enter a unique code for this competition.  Change this code each time you run a different competition.', '" . $categoryid['configuration_group_id'] . "', 7, NULL, '0000-00-00 00:00:00', NULL, ''); ";
		 $insert_result3 = tep_db_query($insert_query3);
		 if ($insert_result3) echo 'Created New Configuration Object : `COMPETITION_CODE`<br>';			 
}

$check_query = "SELECT * FROM `configuration` WHERE `configuration_key` = 'COMPETITION_ALLOW_CUSTOMERS';";
$check_result = tep_db_query ($check_query);
  if (tep_db_num_rows($check_result) < 1)
{
   $insert_query3 = "INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Allow customers to enter competition', 'COMPETITION_ALLOW_CUSTOMERS', 'true', 'Allow registered customers to enter the competition', '" . $categoryid['configuration_group_id'] . "', 6, '2007-04-06 01:10:42', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); ";
		 $insert_result3 = tep_db_query($insert_query3);
		 if ($insert_result3) echo 'Created New Configuration Object : `COMPETITION_ALLOW_CUSTOMERS`<br>';			 
}

$check_query = "SELECT * FROM `configuration` WHERE `configuration_key` = 'COMPETITION_ALLOW_GUESTS';";
$check_result = tep_db_query ($check_query);
  if (tep_db_num_rows($check_result) < 1)
{
   $insert_query3 = "INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Allow guest to enter competition', 'COMPETITION_ALLOW_GUESTS', 'true', 'Allow guest visitors to enter the competition', '" . $categoryid['configuration_group_id'] . "', 5, '2007-04-06 21:50:08', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); ";
		 $insert_result3 = tep_db_query($insert_query3);
		 if ($insert_result3) echo 'Created New Configuration Object : `COMPETITION_ALLOW_GUESTS`<br>';			 
}

$check_query = "SELECT * FROM `configuration` WHERE `configuration_key` = 'COMPETITION_CLOSE_DATE';";
$check_result = tep_db_query ($check_query);
  if (tep_db_num_rows($check_result) < 1)
{
   $insert_query3 = "INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Competition Close Date', 'COMPETITION_CLOSE_DATE', '04/30/2007', 'The close date of the competition (mm/dd/yyyy)', '" . $categoryid['configuration_group_id'] . "', 4, '2007-04-06 14:38:39', '0000-00-00 00:00:00', NULL, NULL); ";
		 $insert_result3 = tep_db_query($insert_query3);
		 if ($insert_result3) echo 'Created New Configuration Object : `COMPETITION_CLOSE_DATE`<br>';			 
}

$check_query = "SELECT * FROM `configuration` WHERE `configuration_key` = 'COMPETITION_START_DATE';";
$check_result = tep_db_query ($check_query);
  if (tep_db_num_rows($check_result) < 1)
{
   $insert_query3 = "INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Competition Start Date', 'COMPETITION_START_DATE', '04/06/2007', 'The start date of the competiton (mm/dd/yyyy)', '" . $categoryid['configuration_group_id'] . "', 3, '2007-04-06 14:37:39', '0000-00-00 00:00:00', NULL, NULL); ";
		 $insert_result3 = tep_db_query($insert_query3);
		 if ($insert_result3) echo 'Created New Configuration Object : `COMPETITION_START_DATE`<br>';			 
}

$check_query = "SELECT * FROM `configuration` WHERE `configuration_key` = 'PRIZE_ID';";
$check_result = tep_db_query ($check_query);
  if (tep_db_num_rows($check_result) < 1)
{
   $insert_query3 = "INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Prize', 'PRIZE_ID', '76', 'The ID of the product that is being offered as a prize', '" . $categoryid['configuration_group_id'] . "', 2, NULL, '0000-00-00 00:00:00', NULL, NULL); ";
		 $insert_result3 = tep_db_query($insert_query3);
		 if ($insert_result3) echo 'Created New Configuration Object : `PRIZE_ID`<br>';			 
}

$check_query = "SELECT * FROM `configuration` WHERE `configuration_key` = 'SHOW_COMPETITION';";
$check_result = tep_db_query ($check_query);
  if (tep_db_num_rows($check_result) < 1)
{
   $insert_query3 = "INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Show competition invitation', 'SHOW_COMPETITION', 'true', 'Displays the competition invitation box', '" . $categoryid['configuration_group_id'] . "', 1, '2007-04-06 22:15:35', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); ";
		 $insert_result3 = tep_db_query($insert_query3);
		 if ($insert_result3) echo 'Created New Configuration Object : `SHOW_COMPETITION`<br>';			 

}
$check_query = "SELECT * FROM `configuration` WHERE `configuration_key` = 'COMPETITION_ANSWER_A';";
$check_result = tep_db_query ($check_query);
  if (tep_db_num_rows($check_result) < 1)
{
$insert_query3 = "INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Competition Answer A', 'COMPETITION_ANSWER_A', 'A', 'Competition Answer A', '" . $categoryid['configuration_group_id'] . "', 20, '2007-04-06 22:15:35', '0000-00-00 00:00:00', NULL, NULL); ";
$insert_result3 = tep_db_query($insert_query3);
   $insert_query3 = "INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Competition Answer B', 'COMPETITION_ANSWER_B', 'B', 'Competition Answer B', '" . $categoryid['configuration_group_id'] . "', 21, '2007-04-06 22:15:35', '0000-00-00 00:00:00', NULL, NULL); ";
$insert_result3 = tep_db_query($insert_query3);
   $insert_query3 = "INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Competition Answer C', 'COMPETITION_ANSWER_C', 'C', 'Competition Answer C', '" . $categoryid['configuration_group_id'] . "', 22, '2007-04-06 22:15:35', '0000-00-00 00:00:00', NULL, NULL); ";
$insert_result3 = tep_db_query($insert_query3);
if ($insert_result3) echo 'Created New Configuration Object : `COMPETITION_ANSWER_A,B,C`<br>';	
}

echo 'Finished!';
?>

 

 

Thanks

 

Johnny


Getting better with mods but no programmer am I.

Share this post


Link to post
Share on other sites
Guest

Hi all,

 

I have the below problem with this contri:

 

In admin, I have in the column "configuration" the "competitions" page, where I can alter the details of a competition.

Now if I understand correctly, I should also see some page "prise draw" (?) in the "Reports" section in admin, however, I don't have this page, Hence I cannot see or edit who entered the competitions.

 

Can any one help me on this pls?

 

Many thanks!

Best regards

 

Small Craft

Share this post


Link to post
Share on other sites
Guest

You should see

 

Prize Draw Entries

 

if not then go thru the instructions once again.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×