|
ECB SEO SHOP SOFTWARE - IMEDES SOFTWARE DOWNLOADS
*****************************************
* *
* INSTALLATION-GUIDE *
* *
*****************************************
* @package SuspendUser *
* (c) 2008 imedes.de *
* info@imedes.de *
* @compatible SP2.1 *
*****************************************
--------------
NEW FILES:
--------------
includes/functions/database.php
install.suspend_user.php
suspend.php
templates/xtc4/module/suspend.html
--------------
NEW DIRS:
--------------
imedes_library
includes/classes/adodb_full
--------------
CHANGED FILES:
--------------
admin/customers.php
admin/includes/application_top.php
admin/includes/functions/general.php
admin/includes/functions/sessions.php
checkout_shipping.php
includes/application_top.php
includes/filenames.php
includes/functions/sessions.php
lang/english/admin/customers.php
lang/english/english.php
lang/english/lang_english.conf
lang/german/admin/customers.php
lang/german/german.php
lang/german/lang_german.conf
-------------
INSTALLATION:
-------------
1. Die Datei install.suspend_user.php ausführen und danach löschen. Beispiel: http://www.IhreShopadresse.de/install.suspend_user.php
Damit werden die Datenbankerweiterungen vollzogen.
2. new_files und new_dirs kopieren.
3. changed_files kopieren, oder bei nicht standard-version folgende änderungen durchführen:
-admin/customers.php
---------------------------------------------------------------------------------------------------
finde folgendes:
$customers_statuses_array = xtc_get_customers_statuses();
und füge danach ein:
define('sec', 1);
include('../imedes_library/customers.setsflag.php');
---------------------------------------------------------------------------------------------------
finde folgendes:
$shipping_unallowed = xtc_db_prepare_input($_POST['shipping_unallowed']);
$password = xtc_db_prepare_input($_POST['entry_password']);
und füge danach ein:
$suspend_stat = xtc_db_prepare_input($_POST['customers_suspend']);
---------------------------------------------------------------------------------------------------
finde folgendes:
$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()');
und ersetze es mit:
$sql_data_array = array ('customers_firstname' => $customers_firstname, 'customers_cid' => $customers_cid, 'customers_suspend' => $suspend_stat, '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()');
---------------------------------------------------------------------------------------------------
finde folgendes:
$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']."'");
und ersetze es mit:
$customers_query = xtc_db_query("select c.payment_unallowed, c.customers_suspend, 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']."'");
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
finde folgendes:
$customers_query_raw = "select
c.customers_id,
c.customers_vat_id,
c.customers_vat_id_status,
c.customers_lastname,
c.customers_firstname,
und füge danach ein:
c.customers_suspend,
---------------------------------------------------------------------------------------------------
finde folgendes:
<tr>
<td class="main"><?php echo ENTRY_PAYMENT_UNALLOWED; ?></td>
und füge davor ein:
<tr>
<td class="main"><?php echo TABLE_HEADING_SUSPEND; ?>:</td>
<td class="main"><?php
if ($cInfo->customers_suspend == 1) {
echo '<input type="radio" name="customers_suspend" value="1" checked /> '.TEXT_ACCOUNT.' <input type="radio" name="customers_suspend" value="0" /> '.TEXT_GUEST;
} else {
echo '<input type="radio" name="customers_suspend" value="1" /> '.TEXT_ACCOUNT.' <input type="radio" name="customers_suspend" value="0" checked /> '.TEXT_GUEST;
}
?></td>
</tr>
---------------------------------------------------------------------------------------------------
finde folgendes:
<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACCOUNT_CREATED.xtc_sorting(FILENAME_CUSTOMERS,'date_account_created'); ?></td>
und füge danach ein:
<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_SUSPEND.xtc_sorting(FILENAME_CUSTOMERS,'customers_suspend'); ?> </td>
---------------------------------------------------------------------------------------------------
finde folgendes:
$sort = 'order by c.customers_firstname DESC';
break;
und füge danach ein:
case 'customers_suspend' :
$sort = 'order by c.customers_suspend';
break;
case 'customers_suspend-desc' :
$sort = 'order by c.customers_suspend DESC';
break;
---------------------------------------------------------------------------------------------------
finde folgendes:
<?php } ?>
<td class="dataTableContent" align="right"><?php echo xtc_date_short($info['date_account_created']); ?></td>
und füge danach ein:
<td class="dataTableContent" align="right"><?php
if ($customers['customers_suspend'] == '0') {
echo xtc_image(DIR_WS_IMAGES . 'icon_status_green.gif', IMAGE_ICON_STATUS_GREEN, 10, 10) . ' <a href="' . xtc_href_link(FILENAME_CUSTOMERS, xtc_get_all_get_params() . 'action=setsflag&flag=1&cID=' . $customers['customers_id']) . '">' . xtc_image(DIR_WS_IMAGES . 'icon_status_red_light.gif', IMAGE_ICON_STATUS_RED_LIGHT, 10, 10) . '</a>';
} else {
echo '<a href="' . xtc_href_link(FILENAME_CUSTOMERS, xtc_get_all_get_params() . 'action=setsflag&flag=0&cID=' . $customers['customers_id']) . '">' . xtc_image(DIR_WS_IMAGES . 'icon_status_green_light.gif', IMAGE_ICON_STATUS_GREEN_LIGHT, 10, 10) . '</a> ' . xtc_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_RED, 10, 10);
}
?></td>
---------------------------------------------------------------------------------------------------
finde folgendes:
$cs_name = $customer_status['customers_status_name'];
und füge danach ein:
$cs_suspend = $customer_status['customers_suspend'];
---------------------------------------------------------------------------------------------------
finde folgendes:
$contents[] = array ('text' => '<br />'.TEXT_INFO_NUMBER_OF_REVIEWS.' '.$cInfo->number_of_reviews);
und füge danach ein:
$contents[] = array ('text' => '<br />'.TABLE_HEADING_SUSPEND.': '.(($cs_suspend == '1') ? TEXT_SUSPEND_YES : TEXT_SUSPEND_NO));
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-admin/includes/application_top.php
---------------------------------------------------------------------------------------------------
Achtung!!!! Diese folgende Änderung ist nur notwendig, wenn Sie bisher noch KEINE Bibliothek von Imedes
erworben haben, welches unter einer Bezahllizenz steht. Falls Sie nicht sicher sind, dann schauen Sie
einfach in den Quellcode der entsprechenden Datei oder sprechen uns einfach an
finde folgendes:
require_once(DIR_FS_INC . 'xtc_db_connect.inc.php');
require_once(DIR_FS_INC . 'xtc_db_close.inc.php');
require_once(DIR_FS_INC . 'xtc_db_error.inc.php');
require_once(DIR_FS_INC . 'xtc_db_query.inc.php');
require_once(DIR_FS_INC . 'xtc_db_queryCached.inc.php');
require_once(DIR_FS_INC . 'xtc_db_perform.inc.php');
require_once(DIR_FS_INC . 'xtc_db_fetch_array.inc.php');
require_once(DIR_FS_INC . 'xtc_db_num_rows.inc.php');
require_once(DIR_FS_INC . 'xtc_db_data_seek.inc.php');
require_once(DIR_FS_INC . 'xtc_db_insert_id.inc.php');
require_once(DIR_FS_INC . 'xtc_db_free_result.inc.php');
require_once(DIR_FS_INC . 'xtc_db_fetch_fields.inc.php');
require_once(DIR_FS_INC . 'xtc_db_output.inc.php');
require_once(DIR_FS_INC . 'xtc_db_input.inc.php');
und ersetze es mit:
require_once('../'.DIR_WS_FUNCTIONS.'database.php');
// require_once(DIR_FS_INC . 'xtc_db_connect.inc.php');
// require_once(DIR_FS_INC . 'xtc_db_close.inc.php');
// require_once(DIR_FS_INC . 'xtc_db_error.inc.php');
// require_once(DIR_FS_INC . 'xtc_db_query.inc.php');
// require_once(DIR_FS_INC . 'xtc_db_queryCached.inc.php');
// require_once(DIR_FS_INC . 'xtc_db_perform.inc.php');
// require_once(DIR_FS_INC . 'xtc_db_fetch_array.inc.php');
// require_once(DIR_FS_INC . 'xtc_db_num_rows.inc.php');
// require_once(DIR_FS_INC . 'xtc_db_data_seek.inc.php');
// require_once(DIR_FS_INC . 'xtc_db_insert_id.inc.php');
// require_once(DIR_FS_INC . 'xtc_db_free_result.inc.php');
// require_once(DIR_FS_INC . 'xtc_db_fetch_fields.inc.php');
// require_once(DIR_FS_INC . 'xtc_db_output.inc.php');
// require_once(DIR_FS_INC . 'xtc_db_input.inc.php');
---------------------------------------------------------------------------------------------------
Achtung!!!! Diese folgende Änderung ist nur notwendig, wenn Sie bisher noch KEINE Bibliothek von Imedes
erworben haben, welches unter einer Bezahllizenz steht. Falls Sie nicht sicher sind, dann schauen Sie
einfach in den Quellcode der entsprechenden Datei oder sprechen uns einfach an
finde folgendes:
xtc_db_connect() or die('Unable to connect to database server!');
und ersetze es mit:
require_once (DIR_FS_CATALOG.'imedes_library/db_connect_alt_admin.php');
db_connect_alt() or die('Unable to connect to database server!');
global $ADODB_FETCH_MODE;
$ADODB_FETCH_MODE=ADODB_FETCH_ASSOC;
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-admin/includes/functions/general.php
---------------------------------------------------------------------------------------------------
finde folgendes:
$customer_status_query = xtc_db_query("select customers_status, member_flag, customers_status_name, customers_status_public, customers_status_image, customers_status_discount, customers_status_ot_discount_flag, customers_status_ot_discount, customers_status_graduated_prices FROM ".TABLE_CUSTOMERS." left join ".TABLE_CUSTOMERS_STATUS." on customers_status = customers_status_id where customers_id='".$customers_id."' and language_id = '".$_SESSION['languages_id']."'");
und ersetze es mit:
$customer_status_query = xtc_db_query("select customers_status, member_flag, customers_status_name, customers_status_public, customers_suspend, customers_status_image, customers_status_discount, customers_status_ot_discount_flag, customers_status_ot_discount, customers_status_graduated_prices FROM ".TABLE_CUSTOMERS." left join ".TABLE_CUSTOMERS_STATUS." on customers_status = customers_status_id where customers_id='".$customers_id."' and language_id = '".$_SESSION['languages_id']."'");
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-admin/includes/functions/sessions.php
---------------------------------------------------------------------------------------------------
Achtung!!!! Diese folgende Änderung ist nur notwendig, wenn Sie bisher noch KEINE Bibliothek von Imedes
erworben haben, welches unter einer Bezahllizenz steht. Falls Sie nicht sicher sind, dann schauen Sie
einfach in den Quellcode der entsprechenden Datei oder sprechen uns einfach an
finde folgendes:
function _sess_write($key, $val) {
global $SESS_LIFE;
und füge danach ein:
if(!is_object($db)){// Vermutlich wird das $db objekt gelöscht, bevor die Session geschrieben wird
global$db;
require_once (DIR_FS_CATALOG.'imedes_library/db_connect_alt_admin.php');
db_connect_alt() or die('Unable to connect to database server!');
$db->Execute("SET NAMES '".$_SESSION['language_charset']."'");
$db->Execute("SET CHARACTER_SET_CLIENT=".$_SESSION['language_charset']);
$db->Execute("SET CHARACTER_SET_RESULTS=".$_SESSION['language_charset']);
}
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-checkout_shipping.php
---------------------------------------------------------------------------------------------------
finde folgendes:
require (DIR_WS_CLASSES.'http_client.php');
und füge danach ein:
// check if customer is suspended
define('sec', 1);
include('imedes_library/suspend_check.php');
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-includes/application_top.php
---------------------------------------------------------------------------------------------------
Achtung!!!! Diese folgende Änderung ist nur notwendig, wenn Sie bisher noch KEINE Bibliothek von Imedes
erworben haben, welches unter einer Bezahllizenz steht. Falls Sie nicht sicher sind, dann schauen Sie
einfach in den Quellcode der entsprechenden Datei oder sprechen uns einfach an
finde folgendes:
require_once (DIR_FS_INC.'xtc_db_connect.inc.php');
require_once (DIR_FS_INC.'xtc_db_close.inc.php');
require_once (DIR_FS_INC.'xtc_db_error.inc.php');
require_once (DIR_FS_INC.'xtc_db_perform.inc.php');
require_once (DIR_FS_INC.'xtc_db_query.inc.php');
require_once (DIR_FS_INC.'xtc_db_queryCached.inc.php');
require_once (DIR_FS_INC.'xtc_db_fetch_array.inc.php');
require_once (DIR_FS_INC.'xtc_db_num_rows.inc.php');
require_once (DIR_FS_INC.'xtc_db_data_seek.inc.php');
require_once (DIR_FS_INC.'xtc_db_insert_id.inc.php');
require_once (DIR_FS_INC.'xtc_db_free_result.inc.php');
require_once (DIR_FS_INC.'xtc_db_fetch_fields.inc.php');
require_once (DIR_FS_INC.'xtc_db_output.inc.php');
require_once (DIR_FS_INC.'xtc_db_input.inc.php');
und ersetze es mit:
require_once(DIR_WS_FUNCTIONS.'database.php');
// require_once (DIR_FS_INC.'xtc_db_connect.inc.php');
// require_once (DIR_FS_INC.'xtc_db_close.inc.php');
// require_once (DIR_FS_INC.'xtc_db_error.inc.php');
// require_once (DIR_FS_INC.'xtc_db_perform.inc.php');
// require_once (DIR_FS_INC.'xtc_db_query.inc.php');
// require_once (DIR_FS_INC.'xtc_db_queryCached.inc.php');
// require_once (DIR_FS_INC.'xtc_db_fetch_array.inc.php');
// require_once (DIR_FS_INC.'xtc_db_num_rows.inc.php');
// require_once (DIR_FS_INC.'xtc_db_data_seek.inc.php');
// require_once (DIR_FS_INC.'xtc_db_insert_id.inc.php');
// require_once (DIR_FS_INC.'xtc_db_free_result.inc.php');
// require_once (DIR_FS_INC.'xtc_db_fetch_fields.inc.php');
// require_once (DIR_FS_INC.'xtc_db_output.inc.php');
// require_once (DIR_FS_INC.'xtc_db_input.inc.php');
---------------------------------------------------------------------------------------------------
Achtung!!!! Diese folgende Änderung ist nur notwendig, wenn Sie bisher noch KEINE Bibliothek von Imedes
erworben haben, welches unter einer Bezahllizenz steht. Falls Sie nicht sicher sind, dann schauen Sie
einfach in den Quellcode der entsprechenden Datei oder sprechen uns einfach an
finde folgendes:
xtc_db_connect() or die('Unable to connect to database server!');
und ersetze es mit:
require_once (DIR_FS_CATALOG.'imedes_library/db_connect_alt.php');
db_connect_alt() or die('Unable to connect to database server!');
global $ADODB_FETCH_MODE;
$ADODB_FETCH_MODE=ADODB_FETCH_ASSOC;
---------------------------------------------------------------------------------------------------
Achtung!!!! Diese folgende Änderung ist nur notwendig, wenn Sie bisher noch KEINE Bibliothek von Imedes
erworben haben, welches unter einer Bezahllizenz steht. Falls Sie nicht sicher sind, dann schauen Sie
einfach in den Quellcode der entsprechenden Datei oder sprechen uns einfach an
finde folgendes:
require (DIR_WS_LANGUAGES.$_SESSION['language'].'/'.$_SESSION['language'].'.php');
und füge danach ein:
$db->Execute("SET NAMES '".$_SESSION['language_charset']."'");
$db->Execute("SET CHARACTER_SET_CLIENT=".$_SESSION['language_charset']);
$db->Execute("SET CHARACTER_SET_RESULTS=".$_SESSION['language_charset']);
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-includes/filenames.php
---------------------------------------------------------------------------------------------------
finde folgendes:
define('FILENAME_BANNER', 'banners.php');
und füge danach ein:
define('FILENAME_SUSPEND', 'suspend.php');
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-includes/functions/sessions.php
---------------------------------------------------------------------------------------------------
Achtung!!!! Diese folgende Änderung ist nur notwendig, wenn Sie bisher noch KEINE Bibliothek von Imedes
erworben haben, welches unter einer Bezahllizenz steht. Falls Sie nicht sicher sind, dann schauen Sie
einfach in den Quellcode der entsprechenden Datei oder sprechen uns einfach an
finde folgendes:
function _sess_write($key, $val) {
global $SESS_LIFE;
und füge danach ein:
if(!is_object($db)){// Vermutlich wird das $db objekt gelöscht, bevor die Session geschrieben wird
global$db;
require_once (DIR_FS_CATALOG.'imedes_library/db_connect_alt.php');
db_connect_alt() or die('Unable to connect to database server!');
$db->Execute("SET NAMES '".$_SESSION['language_charset']."'");
$db->Execute("SET CHARACTER_SET_CLIENT=".$_SESSION['language_charset']);
$db->Execute("SET CHARACTER_SET_RESULTS=".$_SESSION['language_charset']);
}
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-lang/english/admin/customers.php
---------------------------------------------------------------------------------------------------
finde folgendes:
define('TABLE_HEADING_ACTION', 'Action');
und füge danach ein:
define('TABLE_HEADING_SUSPEND', 'Suspend Status');
define('TEXT_SUSPEND_YES', 'suspended');
define('TEXT_SUSPEND_NO', 'not suspended');
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-lang/english/english.php
---------------------------------------------------------------------------------------------------
finde folgendes:
define('NAVBAR_GV_SEND', 'Send Voucher');
und füge danach ein:
define('NAVBAR_TITLE_SUSPEND', 'Account suspended');
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-lang/english/lang_english.conf
---------------------------------------------------------------------------------------------------
füge am Ende ein:
[suspend]
heading_suspend = 'Account suspended'
text_suspend = 'Your account has been disabled for checkout. Please step in contact with us.'
text_contact = 'Contact us'
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-lang/german/admin/customers.php
---------------------------------------------------------------------------------------------------
finde folgendes:
define('TABLE_HEADING_ACTION', 'Aktion');
und füge danach ein:
define('TABLE_HEADING_SUSPEND', 'Sperr-Status');
define('TEXT_SUSPEND_YES', 'gesperrt');
define('TEXT_SUSPEND_NO', 'nicht gesperrt');
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-lang/german/german.php
---------------------------------------------------------------------------------------------------
finde folgendes:
define('NAVBAR_GV_SEND', 'Gutschein versenden');
und füge danach ein:
define('NAVBAR_TITLE_SUSPEND', 'Account gesperrt');
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-lang/german/lang_german.conf
---------------------------------------------------------------------------------------------------
füge am Ende ein:
[suspend]
heading_suspend = 'Account gesperrt'
text_suspend = 'Ihr Account wurde für Bestellungen deaktiviert. Bitte treten Sie in Kontakt mit uns.'
text_contact = 'Hier können Sie uns kontaktieren'
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
|