Jump to content
Sign in to follow this  
LoOneTx

Registry Redux - Occasion Form Not Show Type Of Occasions

Recommended Posts

Hello friends.

 

I install Registry Redux Contribution but in link REGISTY (to create a registry) have a form with:

 

Registry Details

Co-Registrant First Name:

Co-Registrant Last Name:

Occasion Date: (eg. 05/21/1970) required

Occasion: Select Event required

 

 

But in Occasion (Select Event) not have events for selection.

In BD the events are correctly. What the problem?

 

Wait for a help.

Thank you!

Share this post


Link to post
Share on other sites
Guest
Hello friends.

 

I install Registry Redux Contribution but in link REGISTY (to create a registry) have a form with:

 

Registry Details

Co-Registrant First Name:

Co-Registrant Last Name:

Occasion Date: (eg. 05/21/1970) required

Occasion: Select Event required

 

 

But in Occasion (Select Event) not have events for selection.

In BD the events are correctly. What the problem?

 

Wait for a help.

Thank you!

The events are stored in the database. Did you install the SQL?

Share this post


Link to post
Share on other sites
The events are stored in the database. Did you install the SQL?

 

I am having the same problem - I did run the mysql changes.

Thank you,

Allison

Share this post


Link to post
Share on other sites

Just so you know - what was going on was that the install instructions i was using skipped the part where you define functions in /includes/functions.php. The following code was missing:

 

//start gift registry

////

// Function to return all inmate facilities

function tep_get_registry_occasions($pull_down_default_value = true) {

global $languages_id;

if($pull_down_default_value) {

$occassion_array = array(array('id' => '', 'text' => PULL_DOWN_DEFAULT_REGISTRY));

}else{

$occassion_array = array();

}

$occassion_query_string = "select registry_occasion_id, registry_occasion_name from " . TABLE_REGISTRY_OCCASION . " WHERE language_id = '" . $languages_id . "' order by registry_occasion_name";

$occassion_query = tep_db_query($occassion_query_string);

while ($occassion_values = tep_db_fetch_array($occassion_query)) {

$occassion_array[] = array('id' => $occassion_values['registry_occasion_id'],

'text' => $occassion_values['registry_occasion_name']);

}

 

return $occassion_array;

}

 

////

// Function to return all inmate facilities

function tep_get_registry_occasion_name($occasion_id) {

global $languages_id;

$occassion_query_string = "select registry_occasion_name from " . TABLE_REGISTRY_OCCASION . " WHERE language_id = '" . $languages_id . "' AND registry_occasion_id = '" . $occasion_id . "'";

$occassion_query = tep_db_query($occassion_query_string);

$occassion_value = tep_db_fetch_array($occassion_query);

 

return $occassion_value['registry_occasion_name'];

}

 

////

// Function to return name and email address from the registry owner

function tep_get_registry_email_info($registry_owner_id) {

$registry_owner_query_string = "select customers_firstname, customers_lastname, customers_email_address from " . TABLE_CUSTOMERS . " WHERE customers_id = '" . $registry_owner_id . "'";

$registry_owner_query = tep_db_query($registry_owner_query_string);

$registry_owner_value = tep_db_fetch_array($registry_owner_query);

 

return $registry_owner_value;

}

 

function tep_get_registry_customers_id($reg_id){

$registry_customers_id_query_string = "select customers_id from " . TABLE_REGISTRY_PRODUCTS . " WHERE registry_id = '" . $reg_id . "'";

$registry_customers_id_query = tep_db_query($registry_customers_id_query_string);

$registry_customers_id_value = tep_db_fetch_array($registry_customers_id_query);

 

return (int)$registry_customers_id_value['customers_id'];

}

 

function tep_get_registry_owners($reg_id){

 

$registry_owners_query_string = "select c.customers_firstname, c.customers_lastname, r.co_registrant_first_name, r.co_registrant_last_name from " . TABLE_CUSTOMERS . " c, " . TABLE_REGISTRY . " r where r.customers_id = c.customers_id AND r.registry_id = '" . $reg_id . "'";

$registry_owners_query = tep_db_query($registry_owners_query_string);

$registry_owners_value = tep_db_fetch_array($registry_owners_query);

 

return $registry_owners_value;

}

 

function tep_get_default_address($customers_id){

$registry_default_address_id_string = "select c.customers_default_address_id from " . TABLE_CUSTOMERS . " c where c.customers_id = '" . $customers_id . "'";

$registry_default_address_id_query = tep_db_query($registry_default_address_id_string);

$registry_default_address_id_value = tep_db_fetch_array($registry_default_address_id_query);

 

return $registry_default_address_id_value['customers_default_address_id'];

}

//end gift registry

 

 

 

best!

Allison

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  

×