Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Prize Draw Competition help


Benjjj6

Recommended Posts

  • Replies 119
  • Created
  • Last Reply

Top Posters In This Topic

It's in catalog\includes\languages\english\competition.php around line 21

 

Mat

wow Mat thank you for the incredibly fast answer I appreciate it. On another note I have the prize draw on my main page but when someone clicks on it it comes up internal server error is this a host thing?

Link to comment
Share on other sites

wow Mat thank you for the incredibly fast answer I appreciate it. On another note I have the prize draw on my main page but when someone clicks on it it comes up internal server error is this a host thing?

 

Hi.

 

I have to admit I'm no expert in this, i just got to know this contribution because it cost me a bit of time to get it working :)

You do have a competition setup?

 

Otherwise it could be many different things...

1st stage would be to check each modification you did to make sure they're right.

In the past I've found a simple missing character in a language file can cause this error for example.

Another thing to check is your database to make sure the additions went in there properly.

I wouldn't think it's your server, if it can host osCommerce it can do the extra bit for the competitions..

 

Mat

Link to comment
Share on other sites

Hi.

 

I have to admit I'm no expert in this, i just got to know this contribution because it cost me a bit of time to get it working :)

You do have a competition setup?

 

Otherwise it could be many different things...

1st stage would be to check each modification you did to make sure they're right.

In the past I've found a simple missing character in a language file can cause this error for example.

Another thing to check is your database to make sure the additions went in there properly.

I wouldn't think it's your server, if it can host osCommerce it can do the extra bit for the competitions..

 

Mat

 

I did some research and it had to do with the permissions of the file and making them 755 that worked. But i have found I am having another problem in the admin section under reports i only have a capital A nothing else. I also can not set question options. thanks again Mat

Link to comment
Share on other sites

  • 3 weeks later...
I did some research and it had to do with the permissions of the file and making them 755 that worked. But i have found I am having another problem in the admin section under reports i only have a capital A nothing else. I also can not set question options. thanks again Mat

 

Had a go with installing thic contribution, but struggling a little bit now.

 

It works to a fashion but I cant provide any details on answers A, B or C, same goes for when you try and enter it says select a,b or C but theres nothing to select.

 

 

Can anyone please advise.

 

Thanks

Johnny

Getting better with mods but no programmer am I.

Link to comment
Share on other sites

Hi how would I change it to get radio buttons for the competitors selection?

 

As it looks better if you have the three radio options to select rather then entering the answer A, B or C in the little box currently provided.

 

Thanks

Johnny

Edited by johnnybebad

Getting better with mods but no programmer am I.

Link to comment
Share on other sites

Okay I have got me admin section so I can type individual values for A, B and C rather than type it in text in the question.

 

And it transfers the information to my database. more luck than skill.

 

However having trouble getting the A, B and C answers as radio buttons with the options at the side instead of being part of the question.

 

I can get them the options with radio buttons, but they Don't have A, B and C by there side.

 

The code I currently have been playing with is

 

<!-- <td class="main"><span class="main">Please indicate A, B, or C</span>  <input type="radio" name="entry_qualify_answer" CHECKED> <span class="inputRequirement">*</span></td>-->
			<td class="main" STYLE="padding:15px;"><b>A</b> <input type="radio" name="entry_qualify_answer" value="A"><?php echo tep_draw_input_field('configuration_value', COMPETITION_ANSWER_A); ?><br><input type="radio" name="entry_qualify_answer" value="B"><?php echo tep_draw_input_field('configuration_value', COMPETITION_ANSWER_B); ?><br>
<input type="radio" name="entry_qualify_answer" value="C"><?php echo tep_draw_input_field('configuration_value', COMPETITION_ANSWER_C); ?><br>

 

Can anyone tell me how to get this fully functional so I have :-

 

A radio button answer a

B radio button answer b

C radio button answer c

 

I think the submission will be just A, B or C as before rather than the full answer, so the only change is how its presented and selected for submission?

 

I have the radio buttons in place, the answers a, b and c in place, but just the A is showing and the next two boxes are no B and C showing, also the answers a, b and c are in a box where the values can be changed by anyone, which defeats the points of having fixed values.

 

Also have the original script that gives a box for you to enter the answer in which i want to get rid of altogether.

 

It may be easier to see looking at the code to start with.

 

Thanks

Edited by johnnybebad

Getting better with mods but no programmer am I.

Link to comment
Share on other sites

Okay I worked it out and its working.

 

I have added the information to prize draw contribution.

 

The files allow:-

 

1. Insert radio buttons for answers A, B and C

2. To update these values in admin when you setup the prize draw.

 

The only problem was I did not change the auto database configurer to update the configuration table with 3 new enteries (answer a, b and c)

 

 

Any problems give us a shout and I will do my best to help, would be nice if we had one of those calendars where you can select the date rather than type it in.

 

Thanks

Johnny

Getting better with mods but no programmer am I.

Link to comment
Share on other sites

I just installed this contribution (competition v1.2) and get the following error, It only happens when allow guest to enter is set to false.

 

Error:

1054 - Unknown column 'competition_code' in 'where clause'

 

select count(*) as total from customers where customers_email_address = '' and customers_id = '1' AND competition_code = '001'

 

[TEP STOP]

 

I have reinstalled it several times and tried to use the manual sql also. Have even tried on stock shop as well.

Any help is appreciated.

 

oscommerce-2.2ms2-060817

mysql 5

php5

Link to comment
Share on other sites

I just installed this contribution (competition v1.2) and get the following error, It only happens when allow guest to enter is set to false.

 

Error:

1054 - Unknown column 'competition_code' in 'where clause'

 

select count(*) as total from customers where customers_email_address = '' and customers_id = '1' AND competition_code = '001'

 

[TEP STOP]

 

I have reinstalled it several times and tried to use the manual sql also. Have even tried on stock shop as well.

Any help is appreciated.

 

oscommerce-2.2ms2-060817

mysql 5

php5

Getting better with mods but no programmer am I.

Link to comment
Share on other sites

Hi, I am sorting out my files for the upload to the contribrution. As i messed it up previously.

 

The mods I mod to the version 1.2 are below:-

 

1a). the stats_prize_draw.php in admin

 

Around line 133 after

 

tep_db_query("UPDATE `" . TABLE_CONFIGURATION . "` SET `configuration_value` = '" . tep_db_input($HTTP_GET_VARS

['products_id']) . "' WHERE `configuration_key` = 'PRIZE_ID' LIMIT 1;");

 

add:-

	tep_db_query("UPDATE `" . TABLE_CONFIGURATION . "` SET `configuration_value` = '" . tep_db_input($HTTP_GET_VARS

['answer_a']) 	  . "' WHERE `configuration_key` = 'COMPETITION_ANSWER_A' LIMIT 1;");
	tep_db_query("UPDATE `" . TABLE_CONFIGURATION . "` SET `configuration_value` = '" . tep_db_input

($HTTP_GET_VARS['answer_b']) 	  . "' WHERE `configuration_key` = 'COMPETITION_ANSWER_B' LIMIT 1;");
	tep_db_query("UPDATE `" . TABLE_CONFIGURATION . "` SET `configuration_value` = '" . tep_db_input

($HTTP_GET_VARS['answer_c']) 	  . "' WHERE `configuration_key` = 'COMPETITION_ANSWER_C' LIMIT 1;");

 

1b) Around line 380 after

 

echo '<tr><td class="main" width="15%">Question</td><td class="main" align="left">' . tep_draw_input_field('question', 

'type your question here','size="60", onclick=value=""') . ' </td></tr>';

 

add:-

echo '<tr><td class="main" width="15%">Question</td><td class="main" align="left">' . 

tep_draw_input_field('question', 'type your question here','size="60", onclick=value=""') . ' </td></tr>';
	echo '<tr><td class="main" width="15%">Answer A</td><td class="main" align="left">' . 

tep_draw_input_field('answer_a', 'type answer a here','size="30", onclick=value=""') . ' </td></tr>';
	echo '<tr><td class="main" width="15%">Answer B</td><td class="main" align="left">' . 

tep_draw_input_field('answer_b', 'type answer b here','size="30", onclick=value=""') . ' </td></tr>';
	echo '<tr><td class="main" width="15%">Answer C</td><td class="main" align="left">' . 

tep_draw_input_field('answer_c', 'type answer c here','size="30", onclick=value=""') . ' </td></tr>';
	echo '<tr><td class="main" width="15%">Answer</td><td class="main" align="left">' . 

tep_draw_pull_down_menu('answer', $answer_array,'size="1"') . ' </td></tr>';

 

 

 

 

 

2. swap the following code in catalog/competition.php (this gives radio button options with those previously entered in

 

admin)

 

 

Find the following:-

 

<td class="main"><?php echo '<span class="main">' . FORM_FIELD_QUALIFING_ANSWER . '</span>  ' . 

tep_draw_input_field('entry_qualify_answer','','size="1"') . ' <span class="inputRequirement">' . 

ENTRY_FIRST_NAME_TEXT . '</span>'; ?></td>

 

 

Replace with:-

 

<td class="main" STYLE="padding:15px;"><b>A</b> <input type="radio" name="entry_qualify_answer" value="A"><?php echo 

COMPETITION_ANSWER_A; ?><br><b>B</b> <input type="radio" name="entry_qualify_answer" value="B"><?php echo 

COMPETITION_ANSWER_B; ?><br><b>C</b> <input type="radio" name="entry_qualify_answer" value="C"><?php echo 

COMPETITION_ANSWER_C; ?><br>  </td><td>

 

 

 

3. Need to add to your shops database configuration table

 

 

configuration_title configuration_key configuration_group_id

 

Competition Answer A COMPETITION_ANSWER_A (number to be same as other competion entry information)

Competition Answer B COMPETITION_ANSWER_B (number to be same as other competion entry information)

Competition Answer C COMPETITION_ANSWER_C (number to be same as other competion entry information)

 

To find the number search in the configuration table for %like% competition under title, then look at the value in

 

configuration_group_id, when you insert the new entries use the same configuration_group_id.

 

 

4a.In catalog/includes/languages/english/competition.php

 

 

This replaces the win these goblets text,

 

 

Find;-

define('BOX_COMPETITION_INVITE','Click below for a chance to win these spectacular glass goblets<BR>');

 

replace with

 

define('BOX_COMPETITION_INVITE','Click below for a chance to win this great prize.<BR>');

 

 

4b) This automaically puts the end date of the competition

 

find:-

 

define('FORM_COMPETITION_DETAILS','Thank you for visting our site and taking the time to look around.<BR><BR>Before you 

leave, why not enter our free prize draw for a chance to win this fabulous prize.' .
					'<BR><BR>This prize draw will be running until the 25th May 2007.<BR><BR>The 

Winner will be notified by email after this date.<BR><BR><span class="smalltext">(terms & conditions apply)</span>');

 

 

and replace with ;-

 

 

 

define('FORM_COMPETITION_DETAILS','Thank you for visting our site and taking the time to look around.<BR><BR>Before you 

leave, why not enter our free prize draw for a chance to win this fabulous prize.' .
					'<BR><BR>This prize draw will be running until the  ' . tep_date_long

(COMPETITION_CLOSE_DATE) . '<BR><BR>The Winner will be notified by email after this date.<BR><BR><span 

class="smalltext">(terms & conditions apply)</span>');

 

Can somone please verify this coding, as I get it to work on my site but i am new to this so it would be great if someone else could check it out.

Getting better with mods but no programmer am I.

Link to comment
Share on other sites

Also after the update's i still getting:

 

1062 - Duplicate entry '[email protected]' for key 2

 

insert into contest (contestant_name, contestant_email, date_entered, validated, competition_code) values ('name name', '[email protected]', now(), 'N', '0001')

 

Still nobody who has the same problem solved?

 

regards,

Jan

Dreams can come true, if you help them a littlebit

Link to comment
Share on other sites

Also after the update's i still getting:

 

1062 - Duplicate entry '[email protected]' for key 2

 

insert into contest (contestant_name, contestant_email, date_entered, validated, competition_code) values ('name name', '[email protected]', now(), 'N', '0001')

 

Still nobody who has the same problem solved?

 

regards,

Jan

 

 

Hopefully have the answer later today on this one with some more mods

Getting better with mods but no programmer am I.

Link to comment
Share on other sites

Okay, I have the answer.

 

It appears theres a little bit of code missing.

 

 

catalog/competition.php

 

// Check if we have already entered
$check_email_query = tep_db_query("select count(*) as total from " . TABLE_CONTEST . " where contestant_email = '" . $referrals_data['customers_email_address'] . "' AND competition_code = '" . COMPETITION_CODE . "'");
$check_email = tep_db_fetch_array($check_email_query);
if ($check_email['total'] > 0) {
   $error = true; 
   $messageStack->add('competition', TEXT_ALREADY_ENTERED);

 

 

This should read

// Check if we have already entered
$check_email_query = tep_db_query("select count(*) as total from " . TABLE_CONTEST . " where contestant_email = '" . $referrals_data['customers_email_address'] . "' AND competition_code = '" . COMPETITION_CODE . "'");
$check_email = tep_db_fetch_array($check_email_query);
if ($check_email['total'] > 0) {
   $error = true; 
  if ($error == true && $show_invite == true) $messageStack->add('competition', TEXT_ALREADY_ENTERED);

 

please let me know how you get on, just tried it and it worked for me

Getting better with mods but no programmer am I.

Link to comment
Share on other sites

can someone verify this please it appears to be working.

 

in catalog/competition.php

 

find:-

 

if ($error == false && $show_invite == true) {
	 tep_db_query("insert into " . TABLE_CONTEST . " (contestant_name, contestant_email, date_entered, validated, competition_code) values ('" . tep_db_input($entry_name) . "', '" . tep_db_input($entry_email_address) . "', now(), '" . tep_db_input($validated) . "', '" . tep_db_input(COMPETITION_CODE) . "')");
   tep_redirect(tep_href_link(FILENAME_COMPETITION, 'action=success'));

 

replace with

 

if ($error == true && $show_invite == true) $messageStack->add('competition', TEXT_ALREADY_ENTERED);  
 } else {
  if ($error == false && $show_invite == true) {
	 tep_db_query("insert into " . TABLE_CONTEST . " (contestant_name, contestant_email, date_entered, validated, competition_code) values ('" . tep_db_input($entry_name) . "', '" . tep_db_input($entry_email_address) . "', now(), '" . tep_db_input($validated) . "', '" . tep_db_input(COMPETITION_CODE) . "')");
   tep_redirect(tep_href_link(FILENAME_COMPETITION, 'action=success'));

Getting better with mods but no programmer am I.

Link to comment
Share on other sites

Okay, the catalog competition file should read as follows:-

 

<?php
/*
 $Id: competition.php Exp $

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

 Copyright (c) 2007 osCommerce

 Released under the GNU General Public License

 Written by Carl Skerritt
*/

 require('includes/application_top.php');
 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_COMPETITION);

 $show_invite = false;

 // Check if we should display this page, incase someone accesses it directly.
 if (SHOW_COMPETITION == 'true') {
  $show_invite = true;


  // Check if we are a registered customer
  if (tep_session_is_registered('customer_id') && COMPETITION_ALLOW_CUSTOMERS == 'false') {
 $show_invite = false;
  }

  // Check if we are a guest
  if (!tep_session_is_registered('customer_id') && COMPETITION_ALLOW_GUESTS == 'false') {
 $show_invite = false;
  }

  // Check if within dates of competition 
  $start_date = COMPETITION_START_DATE;
  $close_date = COMPETITION_CLOSE_DATE;
  $now = date("Y-m-d");	

  if ($now >= $start_date && $now < $close_date) {
} else {
	$show_invite = false;
}
 }

 if ($show_invite == false) {
tep_redirect(tep_href_link(FILENAME_LOGIN));
 }



 // Retrieve {Prize details
 $competition_prize_query = tep_db_query("select p.products_id, p.products_price, p.products_image, pd.products_name, pd.products_description from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and p.products_id ='" . (int)PRIZE_ID . "' and pd.language_id = '" . (int)$languages_id . "' limit 1");
 if (tep_db_num_rows($competition_prize_query) >0) {
  $prizes = tep_db_fetch_array($competition_prize_query);
 }


 if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'process'))
 {
$error = false;

$entry_email_address = tep_db_prepare_input($HTTP_POST_VARS['entry_email_address']);
$entry_name = tep_db_prepare_input($HTTP_POST_VARS['entry_name']);
$entry_valid = tep_db_prepare_input($HTTP_POST_VARS['entry_qualify_answer']);


if (empty($entry_name)) {
  $error = true;
  $messageStack->add('competition', ERROR_TO_NAME);
}

if (!tep_validate_email($entry_email_address)) {
  $error = true;
  $messageStack->add('competition', ERROR_TO_ADDRESS);
}

  // Check if we have already entered
$check_email_query = tep_db_query("select count(*) as total from " . TABLE_CONTEST . " where contestant_email = '" . $entry_email_address . "' AND competition_code = '" . COMPETITION_CODE . "'");
$check_email = tep_db_fetch_array($check_email_query);
if ($check_email['total'] > 0) {
   $error = true;
   $messageStack->add('competition', TEXT_ALREADY_ENTERED);
}



  // If this is a members only competition, check that address entered matchs the one held on the account
  if (COMPETITION_ALLOW_CUSTOMERS == 'true' && COMPETITION_ALLOW_GUESTS == 'false') {
  $check_members_email_query = tep_db_query("select count(*) as total from " . TABLE_CUSTOMERS . " cu, contest ct where cu.customers_email_address = '" . tep_db_input($entry_email_address) . "' and cu.customers_id = '" . (int)$customer_id . "' AND ct.competition_code = '" . COMPETITION_CODE . "'");
  $check_members_email = tep_db_fetch_array($check_members_email_query);
  if ($check_members_email['total'] = 0) {
   $error = true;
	$messageStack->add('competition', ERROR_TO_MEMBERS_ADDRESS);
  }
}

  $validated = "Y";

if (COMPETITION_QUALIFY == 'true') {
if (empty($entry_valid)) {
	  $error = true;
	  $messageStack->add('competition', ERROR_TO_VALID);
	 } else 
	 {
	 // Check if question was answered
	 if (strtoupper($entry_valid{0}) == strtoupper(COMPETITION_ANSWER)) {
		 $validated = "Y";
		} else {
		 $validated = "N";
		}   
	 }
}

  if ($error == false && $show_invite == true) {
	 tep_db_query("insert into " . TABLE_CONTEST . " (contestant_name, contestant_email, date_entered, validated, competition_code) values ('" . tep_db_input($entry_name) . "', '" . tep_db_input($entry_email_address) . "', now(), '" . tep_db_input($validated) . "', '" . tep_db_input(COMPETITION_CODE) . "')");
   tep_redirect(tep_href_link(FILENAME_COMPETITION, 'action=success'));
  }

 } // end of Process

 $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_COMPETITION));
?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<style type="text/css">
TD.infoNotice, DIV.infoNotice {
	font-family: Verdana, Arial, sans-serif;
	font-size: 14px;
	font-weight: bold;
	color: #666666;
}
</style>

<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
 <tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top"><?php echo tep_draw_form('competition', tep_href_link(FILENAME_COMPETITION, 'action=process')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">
  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
	  <tr>
		<td class="pageHeading"><?php echo sprintf(HEADING_TITLE); ?></td>
	  </tr>
	</table></td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
<?php
 if ($messageStack->size('competition') > 0) {
?>
  <tr>
	<td><?php echo $messageStack->output('competition'); ?></td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>

<?php
 }
if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'success')) {
?>
  <tr>
	<td class="infoNotice" align="center"><?php echo TEXT_COMPETITION_ENTRY_SUCCESSFUL; ?></td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <tr>
	<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
	  <tr class="infoBoxContents">
		<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
		  <tr>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
			<td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
		  </tr>
		</table></td>
	  </tr>
	</table></td>
  </tr>
<?php
 } else {
?>
  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
	  <tr>
		<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
		  <tr>
			<td class="main"><b><?php echo FORM_TITLE_ENTRY_DETAILS; ?></b></td>
			<td class="inputRequirement" align="right"><?php echo FORM_REQUIRED_INFORMATION; ?></td>
		  </tr>
		</table></td>
	  </tr>
	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
	  <tr>
		<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
		  <tr>
			<td class="infoNotice" width=50% align="left" valign="top"><?php echo FORM_COMPETITION_DETAILS; ?></td>
			<td class="main" width=50% align="center" valign="top"><?php echo tep_image(DIR_WS_IMAGES . $prizes['products_image'], $prizes['products_name'], SMALL_IMAGE_WIDTH*2, SMALL_IMAGE_HEIGHT*2) . '<BR>' .
					  '<b>' . $prizes['products_name'] . '</B><BR>' . $prizes['products_description']; ?></td>
		  </tr>
		</table></td>
	  </tr>
	  <tr>
		<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
		  <tr class="infoBoxContents">
			<td><table border="0" cellspacing="0" cellpadding="2">
			  <tr>
				<td class="main"><?php echo FORM_FIELD_ENTRY_NAME; ?></td>
				<td class="main"><?php echo tep_draw_input_field('entry_name') . ' <span class="inputRequirement">' . ENTRY_FIRST_NAME_TEXT . '</span>'; ?></td>
			  </tr>
			  <tr>
				<td class="main"><?php echo FORM_FIELD_ENTRY_EMAIL; ?></td>
				<td class="main"><?php echo tep_draw_input_field('entry_email_address') . ' <span class="inputRequirement">' . ENTRY_EMAIL_ADDRESS_TEXT . '</span>'; ?></td>
			  </tr>
			</table></td>
		  </tr>
		</table></td>
	  </tr>
<?php
if (COMPETITION_QUALIFY == "true") {
?>
	<tr>
		   <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
			  <tr class="infoBoxContents">
			   <td><table border="0" cellspacing="0" cellpadding="2">
		  <tr>
			<td class="main" colspan="2"><?php echo FORM_FIELD_QUALIFING_QUESTION; ?></td>
		  </tr>
		  <tr>				  
					<td class="main" colspan="2"><b><?php echo COMPETITION_QUESTION; ?></b></td>
</tr>
<tr>
					<td class="main"><?php echo '<span class="main">' . FORM_FIELD_QUALIFING_ANSWER . '</span>  ' . tep_draw_input_field('entry_qualify_answer','','size="1"') . ' <span class="inputRequirement">' . ENTRY_FIRST_NAME_TEXT . '</span>'; ?></td>
		 </tr>
			  </table></td>
			 </tr>
			</table></td>
	</tr>
<?php
}
?>

	  <tr>
		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	  </tr>
	</table></td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <tr>
	<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
	  <tr class="infoBoxContents">
		<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
		  <tr>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
			<td><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT, '') . '">' . tep_image_button('button_back.gif', IMAGE_BUTTON_BACK) . '</a>'; ?></td>
			<td align="right"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?></td>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
		  </tr>
		</table></td>
	  </tr>
	</table></td>
  </tr>
<?php
}
?>  
</table></form></td>
<!-- body_text_eof //-->
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
</table></td>
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

?>

 

 

Please note this does not give the radio buttons. but it appears to stop the duplicate entry error.

Getting better with mods but no programmer am I.

Link to comment
Share on other sites

Hi,

 

thanks for your reaction.

i can't try it at the moment, but you here from asap.

 

regards,

Jan

 

 

Hi Jan,

 

I am learning and have had this working several times, but think it got over complicated because alterations i made in the file didnt filter through or had cache issues distorting the picture.

 

A good night sleep and another look cleared things up quickly, putting together the full package right now so it be great if you can confirm the changes work.

Getting better with mods but no programmer am I.

Link to comment
Share on other sites

added contribution V1.3.

 

 

This has all the files (I hope) tested it on my site from scratch build on OS 2.2 RC2a

 

Have included

Admin

1. Entry of dates using java calendar rather than having to type them in.

2. Entry values for Answers A, B and C rather than including in as part of question

3. E-mail sent to winner with auto filled store information

SHOP

1. Automatic end date of competition displayed

2. Radio buttons displayed to select answer rather than typing a value.

3. Duplicate entry error fixed

 

Any problems give us a shout, Merry Christmas and a Happy New Year

Getting better with mods but no programmer am I.

Link to comment
Share on other sites

Hi,

 

I have installed the new version but i can't see the java calendar.

it's not available.

 

any idea where it goes wrong?

 

regards,

Jan

Dreams can come true, if you help them a littlebit

Link to comment
Share on other sites

Hi,

 

I have installed the new version but i can't see the java calendar.

it's not available.

 

any idea where it goes wrong?

 

regards,

Jan

 

I have the answer, there were some letters written in capitel (i hope you understand my english) and that was wrong.

see edit code below:

 

<!-- header_eof //-->

<link rel="stylesheet" type="text/css" href="includes/javascript/spiffycal/spiffycal_v2_1.css">

<script language="JavaScript" src="includes/javascript/spiffycal/spiffycal_v2_1.js"></script>

<script language="javascript">

var dateAvailable = new ctlspiffycalendarBox("dateAvailable", "setupnew", "start_date","btnDate1","",scBTNMODE_CUSTOMBLUE);

var dateAvailableEnd = new ctlspiffycalendarBox("dateAvailableEnd", "setupnew", "end_date","btnDate2","",scBTNMODE_CUSTOMBLUE);

</script>

 

<!-- body //-->

 

And then it works for me, maybe somebody needs this solution also.

 

Thanks johnnybebad, and the others, for these great contri.

 

regards,

Jan

 

Merry Xmas and a Happy New Year!

Edited by jan64

Dreams can come true, if you help them a littlebit

Link to comment
Share on other sites

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

Edited by jan64

Dreams can come true, if you help them a littlebit

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...