Contest System [support thread]

[countrycharm]

Hi skipwater Theirs one more thing and then I will leave you alone. When a person who has not sign up yet tick the side-box enter the contest, it take them to this page, but when they register or log in it take them to the home page again instead of taking them to the form to fill out to enter.I think it should take them to the form to fill out. Just my opinion. Thank you again in advance.

You must be registered
and logged in to enter.

Please Log In / register and try again.

[skipwater]

What you are requesting is not the way ZC works but you could modify /includes/modules/pages/contest/header_php.php file as DrByte shows in this thread.
http://www.zen-cart.com/forum/showpo...23&postcount=7

That should do the trick.

Skip

[countrycharm]

What you are requesting is not the way ZC works but you could modify /includes/modules/pages/contest/header_php.php file as DrByte shows in this thread.
http://www.zen-cart.com/forum/showpo...23&postcount=7

That should do the trick.

Skip

Thank you I will try that. I do know Return Authorization Request add on works that way. Thats why I was asking. Thanks again.

[chowdhryrc]

Hi there
I am trying to install the mod but facing a particular problem
I have installed mod admin profile
which is preventing me to run install-sql-contest-v1.6,php. it does not save this file into permission system as there is no page for admin with this file.

what is the alternate

is there any sql patch available to run this file directly?

please help

rajesh

[skipwater]

Hi there
I am trying to install the mod but facing a particular problem
I have installed mod admin profile
which is preventing me to run install-sql-contest-v1.6,php. it does not save this file into permission system as there is no page for admin with this file.

what is the alternate

is there any sql patch available to run this file directly?

please help

rajesh

You can place this file any where within the site tree and load the file in your browser to run it. BUT you must delete it once you have run the script for security reasons.
An example would be:

www.mysite.com/temp/install-sql-contest-v1.6.php

Skip

[countrycharm]

Hi skipwater I have another question for you. In admin/reports/contest_Prize_Entries when you pull that up you are suppose to be able to Add entries for customers who have purchased products during the contest period. When I tick add customer it doesn't show any Entrants Name or email address. It has the confirm, and cancel buttons but that's all. Am I doing something wrong or is their a bug. Thank You in advance.

[skipwater]

Hi skipwater I have another question for you. In admin/reports/contest_Prize_Entries when you pull that up you are suppose to be able to Add entries for customers who have purchased products during the contest period. When I tick add customer it doesn't show any Entrants Name or email address. It has the confirm, and cancel buttons but that's all. Am I doing something wrong or is their a bug. Thank You in advance.

There are requirements that need to be meet to have a list of Add Entries for Existing Customers.

1. The customer had to have purchased something between the start and ending date of the contest.

2. If 1 above is meet but the customer entered there self they will not show in the list. Because they would already be in the contest.

Skip

[countrycharm]

There are requirements that need to be meet to have a list of Add Entries for Existing Customers.

1. The customer had to have purchased something between the start and ending date of the contest.

2. If 1 above is meet but the customer entered there self they will not show in the list. Because they would already be in the contest.

Skip

As many sales I have had recently I just don't understand why no one has entered the contest. That is why I was asking. I thought I was doing something wrong. Thanks for the help.

[DivaVocals]

Mod Version: 1.6.2
Zen Cart Version: 1.3.8a

FYI.. None of the defined pages appeared in the Define Pages Editor until I copied them to the includes/languages/english/html_includes folder too. So now the define pages for this mod are stored in two locations as follows:

• includes/languages/english/html_includes
• includes/languages/english/html_includes/YOUR_TEMPLATE

I wanted to share this in case anyone else was having the same issue I was. This is pretty a cool module.. Now that I've got it all working I have one issue and I need some help with a change I'm trying to make...

Issue:
Add Entries for Existing Customers does not add customers to the contest. My test contest dates are 01/01/2009 - 12/31/2009, and there are sales during this period. Yet when I click the "Add Customers" button, no customers are added. Is there a fix for this??

Change:
I am trying to get the contest entry form to fill out the customer information (name and e-mail address) when a customer is logged in. I took a look at the contact us form to see how it was done there.. Based on this, in the includes/modules/pages/contest/header_php.php around line 18 I added the following:

    // auto complete when logged in
    if($_SESSION['customer_id']) {
      $sql = "SELECT customers_id, customers_firstname, customers_lastname, customers_password, customers_email_address, customers_default_address_id 
              FROM " . TABLE_CUSTOMERS . " 
              WHERE customers_id = :customersID";
      
      $sql = $db->bindVars($sql, ':customersID', $_SESSION['customer_id'], 'integer');
      $check_customer = $db->Execute($sql);
      $customer_email= $check_customer->fields['customers_email_address'];
      $customer_name= $check_customer->fields['customers_firstname'] . ' ' . $check_customer->fields['customers_lastname'];
    } else {
      $customer_email = NOT_LOGGED_IN_TEXT;
      $customer_name = NOT_LOGGED_IN_TEXT;
    }

// default email and name if customer is logged in
if($_SESSION['customer_id']) {
  $sql = "SELECT customers_id, customers_firstname, customers_lastname, customers_password, customers_email_address, customers_default_address_id 
          FROM " . TABLE_CUSTOMERS . " 
          WHERE customers_id = :customersID";
  
  $sql = $db->bindVars($sql, ':customersID', $_SESSION['customer_id'], 'integer');
  $check_customer = $db->Execute($sql);
  $email= $check_customer->fields['customers_email_address'];
  $name= $check_customer->fields['customers_firstname'] . ' ' . $check_customer->fields['customers_lastname'];
} 

This gets the name in the name field, but not the e-mail address.. I am a bit over my head here, and could use a hand.. What do I need to add, subtract, multiply or divide to get me the rest of the way there..

[DivaVocals]

Figured it out..It was a SMALL change needed in the:
includes/templates/custom_template/templates/tpl_contest_default.php file to make it all work.

So altogether now..

If you want the contest form to fill in the name and e-mail address for users who are logged in make the following change in the:
includes/templates/custom_template/templates/tpl_contest_default.php file:
Around line 212 find the following code and make the change highlighted in red (add this to this file):

<label class="inputLabel" for="email-address"><?php echo FORM_FIELD_ENTRY_EMAIL; ?></label>
<?php echo zen_draw_input_field('entry_email_address', $email, ($error ? $_POST['entry_email_address'] : $entry_email_address), ' size="40" id="email-address"') . '<span class="alert">' . ENTRY_REQUIRED_SYMBOL . '</span>'; ?>
<br class="clearBoth" /><br />

Then in the includes/modules/pages/contest/header_php.php around line 18, make the changes outlined below.

The form will now automatically fill in the name and address for customers who are logged in.. I thought this was a nice edition to the customer validation code added by BEAZLEYBUB.

Hope others find this useful..

Now I only need to resolve my one remaining issue:
Issue:
Add Entries for Existing Customers does not add customers to the contest. My test contest dates are 01/01/2009 - 12/31/2009, and there are sales during this period. Yet when I click the "Add Customers" button, no customers are added. Is there a fix for this??

Mod Version: 1.6.2
Zen Cart Version: 1.3.8a

FYI.. None of the defined pages appeared in the Define Pages Editor until I copied them to the includes/languages/english/html_includes folder too. So now the define pages for this mod are stored in two locations as follows:

• includes/languages/english/html_includes
• includes/languages/english/html_includes/YOUR_TEMPLATE

I wanted to share this in case anyone else was having the same issue I was. This is pretty a cool module.. Now that I've got it all working I have one issue and I need some help with a change I'm trying to make...

Issue:
Add Entries for Existing Customers does not add customers to the contest. My test contest dates are 01/01/2009 - 12/31/2009, and there are sales during this period. Yet when I click the "Add Customers" button, no customers are added. Is there a fix for this??

Change:
I am trying to get the contest entry form to fill out the customer information (name and e-mail address) when a customer is logged in. I took a look at the contact us form to see how it was done there.. Based on this, in the includes/modules/pages/contest/header_php.php around line 18 I added the following:

    // auto complete when logged in
    if($_SESSION['customer_id']) {
      $sql = "SELECT customers_id, customers_firstname, customers_lastname, customers_password, customers_email_address, customers_default_address_id 
              FROM " . TABLE_CUSTOMERS . " 
              WHERE customers_id = :customersID";
      
      $sql = $db->bindVars($sql, ':customersID', $_SESSION['customer_id'], 'integer');
      $check_customer = $db->Execute($sql);
      $customer_email= $check_customer->fields['customers_email_address'];
      $customer_name= $check_customer->fields['customers_firstname'] . ' ' . $check_customer->fields['customers_lastname'];
    } else {
      $customer_email = NOT_LOGGED_IN_TEXT;
      $customer_name = NOT_LOGGED_IN_TEXT;
    }

// default email and name if customer is logged in
if($_SESSION['customer_id']) {
  $sql = "SELECT customers_id, customers_firstname, customers_lastname, customers_password, customers_email_address, customers_default_address_id 
          FROM " . TABLE_CUSTOMERS . " 
          WHERE customers_id = :customersID";
  
  $sql = $db->bindVars($sql, ':customersID', $_SESSION['customer_id'], 'integer');
  $check_customer = $db->Execute($sql);
  $email= $check_customer->fields['customers_email_address'];
  $name= $check_customer->fields['customers_firstname'] . ' ' . $check_customer->fields['customers_lastname'];
} 

This gets the name in the name field, but not the e-mail address.. I am a bit over my head here, and could use a hand.. What do I need to add, subtract, multiply or divide to get me the rest of the way there..