Great contrib! Found an error in the install instructions.
I was getting a dup entry error. Was as a result of running the same db "insert into" query twice.
in the install instructions it said. (create_account.php section)
Loof for: (around line 221)
tep_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array);
$address_id = tep_db_insert_id();
tep_db_query("update " . TABLE_CUSTOMERS . " set customers_default_address_id = '" . (int)$address_id . "' where customers_id = '" . (int)$customer_id . "'");
Add below:
//rmh referral start
tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, customers_info_source_id) values ('" . (int)$customer_id . "', '0', now(), '". (int)$source . "')");
if ($source == '9999') {
tep_db_perform(TABLE_SOURCES_OTHER, array('customers_id' => (int)$customer_id, 'sources_other_name' => tep_db_input($source_other)));
}
//rmh referral end
you should replace that line, not add code under it? So I believe that it should have been stated as such
Loof for: (around line 221)
tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('" . (int)$customer_id . "', '0', now())");
AND REPLACE WITH
//rmh referral start
tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, customers_info_source_id) values ('" . (int)$customer_id . "', '0', now(), '". (int)$source . "')");
if ($source == '9999') {
tep_db_perform(TABLE_SOURCES_OTHER, array('customers_id' => (int)$customer_id, 'sources_other_name' => tep_db_input($source_other)));
}
//rmh referral end
customers_info_id, customers_info_number_of_logons, customers_info_date_account_created was in 2 back to back queries. This could just be as a result of other contribs and having over written this file... I haven't checked a clean install of MS2.2.
I am fairly new to LAMP, so If mistaken Please correct me... other wise, I hope this helps any one else.
