Contest System [support thread]

[pdiamond]

Great, that worked perfect.. Thanks

[mipavluk]

Hi! I have installed admin profiles mod... and can't execute the file

install-sql-contest-v1.6.php

because said me:
Sorry, your security clearance does not allow you to access this resource.

and when I try to allow me see that page... don't save the page... so... my question is... there isn't another way?

I mean... I can execute the file from

Tools/Install SQL patches?

or from PHPMyAdmin??

thanks in advance...

Marta

[skipwater]

Hi! I have installed admin profiles mod... and can't execute the file

install-sql-contest-v1.6.php

because said me:
Sorry, your security clearance does not allow you to access this resource.

and when I try to allow me see that page... don't save the page... so... my question is... there isn't another way?

I mean... I can execute the file from

Tools/Install SQL patches?

or from PHPMyAdmin??

thanks in advance...

Marta

You can move install-sql-contest-v1.6.php to your stores root folder and then run it from there. BUT when it has completed the install YOU MUST remove/delete it from your root folder.

That should be a work around for admin profiles mod.

Skip

[mipavluk]

yeah!
thanks!!!

[bzachau]

Hello I wanted to know if it is possible to allow people to enter in the contest every 24hrs until the contest ends for more chances of winning? Is there something I have to change in the script?

Any suggestions would be great.

This script is working great so far.

[skipwater]

Hello I wanted to know if it is possible to allow people to enter in the contest every 24hrs until the contest ends for more chances of winning? Is there something I have to change in the script?

Any suggestions would be great.

This script is working great so far.

Find this file
/includes/templates/YOUR_TEMPLATE/templates/tpl_contest_default.php.

// Check if we have already entered
$check_email_query = "select count(*) as total from " . TABLE_CONTEST . " where contestant_email = '" . $entry_email_address . "' AND contest_code = '" . CONTEST_CODE . "'";
$check_email = $db->Execute($check_email_query);
	if ($check_email->fields['total'] > 0) {
	$error = true;
	$messageStack->add('contest', TEXT_ALREADY_ENTERED);
				}

And comment it out:

// Check if we have already entered
/*
$check_email_query = "select count(*) as total from " . TABLE_CONTEST . " where contestant_email = '" . $entry_email_address . "' AND contest_code = '" . CONTEST_CODE . "'";
$check_email = $db->Execute($check_email_query);
	if ($check_email->fields['total'] > 0) {
	$error = true;
	$messageStack->add('contest', TEXT_ALREADY_ENTERED);
	}
*/

[Coffinwear]

Is there a way on the contest page to NOT have the product description showing? I have a dropdown box in my description (men's/women's) and it's showing on the contest page. If it's selected, it takes people away from the page.

[Coffinwear]

I also have another small issue. I can't seem to find where to change the size of the image on the contest page. A little help here please.

[skipwater]

Is there a way on the contest page to NOT have the product description showing? I have a dropdown box in my description (men's/women's) and it's showing on the contest page. If it's selected, it takes people away from the page.

Find this file
/includes/templates/YOUR_TEMPLATE/templates/tpl_contest_default.php.

You will find this code around line 174

echo 'The PRIZE is <b>'. $contest_prize->fields['products_name'].'</b><br/>' . $contest_prize->fields['products_description'];

Change to

echo 'The PRIZE is <b>'. $contest_prize->fields['products_name'].'</b><br/>';

Skip

[Coffinwear]

Thanks Skip. That was exactly what I was looking for. Is there a way to change the image size?