Schau mal hier, vielleicht hilft das....
Anleitung zur Erstellung eines Extrafeldes bei den Kunden Daten.
betroffene Dateien:
shop/create_account.php
shop/account_edit.php
shop/admin/customers.php
shop/admin/create_account.php
shop/lang/german/german.php
shop/lang/german/lang_german.conf
shop/lang/german/admin/german.php
shop/templates/deintemplate/module/create_account.html
shop/templates/deintemplate/module/account_edit.html
######################################################
1. SQL Befehl per PhPMyAdmin ausführen:
ALTER TABLE ADD VARCHAR( 32 ) DEFAULT NULL AFTER ;
Die Länge des Feldes ist hier beschränkt auf 32 Zeichen VARCHAR( 32 )
######################################################
2. Dateien ändern
######################################################
Datei:
shop\admin\create_account.php
suche ca. Zeile 46:
$customers_fax = xtc_db_prepare_input($_POST['customers_fax']);
füge danach ein:
$customers_neu = xtc_db_prepare_input($_POST['customers_neu']);
suche ca. Zeile 271:
$sql_data_array = array ('customers_status' => $customers_status_c, 'customers_cid' => $customers_cid, 'customers_vat_id' => $customers_vat_id, 'customers_vat_id_status' => $customers_vat_id_status, 'customers_firstname' => $customers_firstname, 'customers_lastname' => $customers_lastname, 'customers_email_address' => $customers_email_address, 'customers_telephone' => $customers_telephone, 'customers_fax' => $customers_fax, 'payment_unallowed' => $payment_unallowed, 'shipping_unallowed' => $shipping_unallowed, 'customers_password' => xtc_encrypt_password
($customers_password),'customers_date_added' => 'now()','customers_last_modified' => 'now()');
ändern zu:
$sql_data_array = array ('customers_status' => $customers_status_c, 'customers_cid' => $customers_cid, 'customers_vat_id' => $customers_vat_id, 'customers_vat_id_status' => $customers_vat_id_status, 'customers_firstname' => $customers_firstname, 'customers_lastname' => $customers_lastname, 'customers_email_address' => $customers_email_address, 'customers_telephone' => $customers_telephone, 'customers_fax' => $customers_fax, 'customers_neu' => $customers_neu, 'payment_unallowed' => $payment_unallowed, 'shipping_unallowed' => $shipping_unallowed, 'customers_password' => xtc_encrypt_password
($customers_password),'customers_date_added' => 'now()','customers_last_modified' => 'now()');
suche ca. Zeile 693:
<tr>
<td class="main"><?php echo ENTRY_FAX_NUMBER; ?></td>
<td class="main"><?php echo xtc_draw_input_field('customers_fax'); ?></td>
</tr>
danach einfügen:
<tr>
<td class="main"><?php echo ENTRY_NEU_NUMBER; ?></td>
<td class="main"><?php echo xtc_draw_input_field('customers_neu'); ?></td>
</tr>
######################################################
Datei:
shop\admin\customers.php
suche ca. Zeile 118:
$customers_fax = xtc_db_prepare_input($_POST['customers_fax']);
danach einfügen:
$customers_neu = xtc_db_prepare_input($_POST['customers_neu']);
suche ca. Zeile 280:
$sql_data_array = array ('customers_firstname' => $customers_firstname, 'customers_cid' => $customers_cid, 'customers_vat_id' => $customers_vat_id, 'customers_vat_id_status' => $customers_vat_id_status, 'customers_lastname' => $customers_lastname, 'customers_email_address' => $customers_email_address, 'customers_telephone' => $customers_telephone, 'customers_fax' => $customers_fax, 'payment_unallowed' => $payment_unallowed, 'shipping_unallowed' => $shipping_unallowed, 'customers_newsletter' => $customers_newsletter,'customers_last_modified' => 'now()');
ändern zu:
$sql_data_array = array ('customers_firstname' => $customers_firstname, 'customers_cid' => $customers_cid, 'customers_vat_id' => $customers_vat_id, 'customers_vat_id_status' => $customers_vat_id_status, 'customers_lastname' => $customers_lastname, 'customers_email_address' => $customers_email_address, 'customers_telephone' => $customers_telephone, 'customers_fax' => $customers_fax, 'customers_neu' => $customers_neu, 'payment_unallowed' => $payment_unallowed, 'shipping_unallowed' => $shipping_unallowed, 'customers_newsletter' => $customers_newsletter,'customers_last_modified' => 'now()');
suche ca. Zeile 353:
$customers_query = xtc_db_query("select c.customers_id,c.customers_cid, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from ".TABLE_CUSTOMERS." c left join ".TABLE_ADDRESS_BOOK." a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '".$_GET['cID']."'");
ändern zu:
$customers_query = xtc_db_query("select c.customers_id,c.customers_cid, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_neu, c.customers_newsletter, c.customers_default_address_id from ".TABLE_CUSTOMERS." c left join ".TABLE_ADDRESS_BOOK." a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '".$_GET['cID']."'");
suche ca. Zeile 488:
$customers_query = xtc_db_query("select c.payment_unallowed, c.shipping_unallowed, c.customers_gender, c.customers_vat_id, c.customers_status, c.member_flag, c.customers_firstname,c.customers_cid, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from ".TABLE_CUSTOMERS." c left join ".TABLE_ADDRESS_BOOK." a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '".$_GET['cID']."'");
ändern zu:
$customers_query = xtc_db_query("select c.payment_unallowed, c.shipping_unallowed, c.customers_gender, c.customers_vat_id, c.customers_status, c.member_flag, c.customers_firstname,c.customers_cid, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_neu, c.customers_newsletter, c.customers_default_address_id from ".TABLE_CUSTOMERS." c left join ".TABLE_ADDRESS_BOOK." a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '".$_GET['cID']."'");
suche ca. Zeile 836:
echo xtc_draw_input_field('customers_fax', $cInfo->customers_fax, 'maxlength="32"');
}
?></td>
</tr>
danach einfügen:
<tr>
<td class="main"><?php echo ENTRY_NEU_NUMBER; ?></td>
<td class="main"><?php
if ($processed == true) {
echo $cInfo->customers_neu.xtc_draw_hidden_field('customers_neu');
} else {
echo xtc_draw_input_field('customers_neu', $cInfo->customers_neu, 'maxlength="32"');
}
?></td>
</tr>
######################################################
Datei:
shop\lang\german\admin\german.php
suche ca. Zeile 241:
define('ENTRY_FAX_NUMBER', 'Telefaxnummer:');
danach einfügen:
define('ENTRY_NEU_NUMBER', 'Eingabe:');
######################################################
Datei:
shop\lang\german\german.php
suche ca.Zeile 128:
define('ENTRY_FAX_NUMBER_TEXT', '');
danach einfügen:
define('ENTRY_NEU_NUMBER_TEXT', '');
######################################################
Datei:
shop\lang\german\lang_german.conf
suche ca. Zeile 183:
text_fax = 'Telefaxnummer:'
danach einfügen:
text_neu = 'Eingabe:'
suche ca. Zeile 244:
text_fax = 'Telefaxnummer:'
danach einfügen:
text_neu = 'Eingabe:'
######################################################
Datei:
shop\templates\xtc4\module\account_edit.html
(hier könnt ihr es an eigener stelle einbinden, dies ist nur ein Vorschlag!)
suche ca. Zeile 66:
<tr>
<td class="main">{#text_fax#}</td>
<td class="inputRequirement">{$INPUT_FAX}</td>
</tr>
danach einfügen:
<tr>
<td class="main">{#text_neu#}</td>
<td class="inputRequirement">{$INPUT_NEU}</td>
</tr>
######################################################
Datei:
shop\templates\xtc4\module\create_account.html
(hier könnt ihr es an eigener stelle einbinden, dies ist nur ein Vorschlag!)
suche ca. Zeile 134:
<tr>
<td class="main">{#text_fax#}</td>
<td class="inputRequirement">{$INPUT_FAX}</td>
</tr>
danach einfügen:
<tr>
<td class="main">{#text_neu#}</td>
<td class="inputRequirement">{$INPUT_NEU}</td>
</tr>
######################################################
Datei:
shop\account_edit.php
suche ca. Zeile 48:
$fax = xtc_db_prepare_input($_POST['fax']);
danach einfügen:
$neu = xtc_db_prepare_input($_POST['neu']);
suche ca. Zeile 113:
$sql_data_array = array ('customers_vat_id' => $vat, 'customers_vat_id_status' => $customers_vat_id_status, 'customers_status' => $customers_status, 'customers_firstname' => $firstname, 'customers_lastname' => $lastname, 'customers_email_address' => $email_address, 'customers_telephone' => $telephone, 'customers_fax' => $fax,'customers_last_modified' => 'now()');
ändern zu:
$sql_data_array = array ('customers_vat_id' => $vat, 'customers_vat_id_status' => $customers_vat_id_status, 'customers_status' => $customers_status, 'customers_firstname' => $firstname, 'customers_lastname' => $lastname, 'customers_email_address' => $email_address, 'customers_telephone' => $telephone, 'customers_fax' => $fax, 'customers_neu' => $neu,'customers_last_modified' => 'now()');
suche ca. Zeile 129:
$account_query = xtc_db_query("select customers_gender, customers_cid, customers_vat_id, customers_vat_id_status, customers_firstname, customers_lastname, customers_dob, customers_email_address, customers_telephone, customers_fax from ".TABLE_CUSTOMERS." where customers_id = '".(int) $_SESSION['customer_id']."'");
ändern zu:
$account_query = xtc_db_query("select customers_gender, customers_cid, customers_vat_id, customers_vat_id_status, customers_firstname, customers_lastname, customers_dob, customers_email_address, customers_telephone, customers_fax, customers_neu from ".TABLE_CUSTOMERS." where customers_id = '".(int) $_SESSION['customer_id']."'");
suche ca. Zeile 168:
$smarty->assign('INPUT_FAX', xtc_draw_input_fieldNote
(array ('name' => 'fax', 'text' => ' '. (xtc_not_null
(ENTRY_FAX_NUMBER_TEXT
) ?
'<span class="inputRequirement">'.ENTRY_FAX_NUMBER_TEXT
.'</span>' : '')), $account['customers_fax']));
danach einfügen:
$smarty->assign('INPUT_NEU', xtc_draw_input_fieldNote
(array ('name' => 'neu', 'text' => ' '. (xtc_not_null
(ENTRY_NEU_NUMBER_TEXT
) ?
'<span class="inputRequirement">'.ENTRY_NEU_NUMBER_TEXT
.'</span>' : '')), $account['customers_neu']));
######################################################
Datei:
shop\create_account.php
suche ca. Zeile 75:
$fax = xtc_db_prepare_input($_POST['fax']);
danach einfügen:
$neu = xtc_db_prepare_input($_POST['neu']);
suche ca. Zeile 219:
$sql_data_array = array ('customers_vat_id' => $vat, 'customers_vat_id_status' => $customers_vat_id_status, 'customers_status' => $customers_status, 'customers_firstname' => $firstname, 'customers_lastname' => $lastname, 'customers_email_address' => $email_address, 'customers_telephone' => $telephone, 'customers_fax' => $fax, 'customers_newsletter' => $newsletter, 'customers_password' => xtc_encrypt_password
($password),'customers_date_added' => 'now()','customers_last_modified' => 'now()');
ändern zu:
$sql_data_array = array ('customers_vat_id' => $vat, 'customers_vat_id_status' => $customers_vat_id_status, 'customers_status' => $customers_status, 'customers_firstname' => $firstname, 'customers_lastname' => $lastname, 'customers_email_address' => $email_address, 'customers_telephone' => $telephone, 'customers_fax' => $fax, 'customers_neu' => $neu, 'customers_newsletter' => $newsletter, 'customers_password' => xtc_encrypt_password
($password),'customers_date_added' => 'now()','customers_last_modified' => 'now()');
suche ca. Zeile 446:
$smarty->assign('INPUT_FAX', xtc_draw_input_fieldNote
(array ('name' => 'fax', 'text' => ' '. (xtc_not_null
(ENTRY_FAX_NUMBER_TEXT
) ?
'<span class="inputRequirement">'.ENTRY_FAX_NUMBER_TEXT
.'</span>' : ''))));
danach einfügen:
$smarty->assign('INPUT_NEU', xtc_draw_input_fieldNote
(array ('name' => 'neu', 'text' => ' '. (xtc_not_null
(ENTRY_NEU_NUMBER_TEXT
) ?
'<span class="inputRequirement">'.ENTRY_NEU_NUMBER_TEXT
.'</span>' : ''))));
######################################################
So, das war es.
(Falls bei Gastkonten dies auch benötigt wird muß noch die create_account_guest bearbeitet werden.)