|
 ECB SEO SHOP SOFTWARE - IMEDES SOFTWARE DOWNLOADS
*****************************************
* *
* INSTALLATION-GUIDE *
* *
*****************************************
* @package istockalert (basic) *
* @compatible SP2.1 *
*****************************************
--------------
NEW FILES:
--------------
inc/xtc_get_products_stock_n_stockalert.php
includes/functions/database.php
includes/modules/istockalert.php
templates/xtc4/mail/german/istockalert_mail.txt
templates/xtc4/mail/german/istockalert_mail.html
templates/xtc4/mail/english/istockalert_mail.txt
templates/xtc4/mail/english/istockalert_mail.html
--------------
NEW DIRS:
--------------
imedes_library
includes/classes/adodb_full
--------------
CHANGED FILES:
--------------
admin/includes/application_top.php
admin/includes/classes/categories.php
admin/includes/functions/sessions.php
admin/includes/modules/new_product.php
checkout_process.php
includes/application_top.php
includes/functions/sessions.php
lang/german/german.php
lang/german/admin/categories.php
lang/german/admin/configuration.php
lang/english/admin/new_attributes.php
-------------
INSTALLATION:
-------------
1. Datenkbankerweiterungen durchführen
ALTER TABLE `products` ADD `products_stockalert` INT( 4 ) DEFAULT '0' NOT NULL ;
INSERT INTO `configuration` ( `configuration_id` , `configuration_key` , `configuration_value` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
VALUES (
'', 'ISTOCKALERT_ACTIVE', 'true', '9', '10', NULL , '0000-00-00 00:00:00', NULL , 'xtc_cfg_select_option(array(''true'', ''false''),'
);
INSERT INTO `configuration` ( `configuration_id` , `configuration_key` , `configuration_value` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
VALUES (
'', 'ISTOCKALERT_EMAIL', 'nobody@example.com', '9', '11', NULL , '0000-00-00 00:00:00', NULL , NULL
);
INSERT INTO `configuration` ( `configuration_id` , `configuration_key` , `configuration_value` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
VALUES (
'', 'ISTOCKALERT_STOCKALERT_STD', '5', '9', '12', NULL , '0000-00-00 00:00:00', NULL , NULL
);
2. new_files und new_dirs kopieren.
3. changed_files kopieren, oder bei nicht standard-version folgende änderungen durchführen:
-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/classes/categories.php
---------------------------------------------------------------------------------------------------
Suche folgende Codestelle und füge markierte Zeile ein. (Originalcode ist unübersichtlich formatiert, vorher
umformatieren)
$sql_data_array = array ('products_quantity' => xtc_db_prepare_input($products_data['products_quantity']),
/* istockalert */ 'products_stockalert' => xtc_db_prepare_input($products_data['products_stockalert']), // istockalert
'products_model' => xtc_db_prepare_input($products_data['products_model']),
'products_ean' => xtc_db_prepare_input($products_data['products_ean']),
'products_price' => xtc_db_prepare_input($products_data['products_price']),
'products_sort' => xtc_db_prepare_input($products_data['products_sort']),
'products_shippingtime' => xtc_db_prepare_input($products_data['shipping_status']),
'products_discount_allowed' => xtc_db_prepare_input($products_data['products_discount_allowed']),
'products_date_available' => $products_date_available,
'products_weight' => xtc_db_prepare_input($products_data['products_weight']),
'products_status' => $products_status,
'products_startpage' => xtc_db_prepare_input($products_data['products_startpage']),
'products_startpage_sort' => xtc_db_prepare_input($products_data['products_startpage_sort']),
'products_tax_class_id' => xtc_db_prepare_input($products_data['products_tax_class_id']),
'product_template' => xtc_db_prepare_input($products_data['info_template']),
'options_template' => xtc_db_prepare_input($products_data['options_template']),
'manufacturers_id' => xtc_db_prepare_input($products_data['manufacturers_id']),
'products_fsk18' => xtc_db_prepare_input($products_data['fsk18']),
'products_vpe_value' => xtc_db_prepare_input($products_data['products_vpe_value']),
'products_vpe_status' => xtc_db_prepare_input($products_data['products_vpe_status']),
'products_vpe' => xtc_db_prepare_input($products_data['products_vpe'])
);
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-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']);
}
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
admin/includes/modules/new_product.php
---------------------------------------------------------------------------------------------------
finde folgendes:
<tr>
<td><span class="main"><?php echo TEXT_PRODUCTS_SORT; ?> <?php echo xtc_draw_input_field('products_sort', $pInfo->products_sort,'size=3'); ?></span></td>
<td><span class="main"><?php echo TEXT_PRODUCTS_QUANTITY; ?> <?php echo xtc_draw_input_field('products_quantity', $pInfo->products_quantity,'size=5'); ?></span></td>
</tr>
Füge danach ein:
<!-- istockalert beginn -->
<tr>
<td> </td>
<td><span class="main"><?php echo TEXT_PRODUCTS_STOCKALERT; ?> <?php echo xtc_draw_input_field('products_stockalert', $pInfo->products_stockalert,'size=5'); ?></span></td>
</tr>
<!-- istockalert end -->
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
checkout_process.php
---------------------------------------------------------------------------------------------------
finde folgendes:
require_once (DIR_FS_INC.'changedatain.inc.php');
Füge danach ein:
require_once (DIR_WS_INCLUDES.'modules/istockalert.php'); // istockalert
$alert_products = istockalert_alert_products();
---------------------------------------------------------------------------------------------------
finde folgendes:
include ('send_order.php');
Füge danach ein:
include ('istockalert_sendmail.php'); // istockalert
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-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:
// include the language translations
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/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/german/german.php
---------------------------------------------------------------------------------------------------
finde folgendes:
?>
Füge davor ein:
// istockalert
define('ISTOCKALERT_MAIL_SUBJECT','Lagerwarnung, Bestellung {$oid}');
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
lang/german/admin/categories.php
--------------------------------
Finde:
define('TEXT_PRODUCTS_QUANTITY', 'Artikelanzahl:');
Füge danach ein:
define('TEXT_PRODUCTS_STOCKALERT', 'Lagerwarnung:'); // istockalert
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
lang/german/admin/configuration.php
---------------------------------------------------------------------------------------------------
finde folgendes:
?>
Füge davor ein:
// istockalert begin
define('ISTOCKALERT_ACTIVE_TITLE' , '[istockalert] Lagerwarnung');
define('ISTOCKALERT_ACTIVE_DESC' , 'Lagerwarnung aktiviert/deaktiviert?');
define('ISTOCKALERT_EMAIL_TITLE' , '[istockalert] Lagerwarnung an E-Mail');
define('ISTOCKALERT_EMAIL_DESC' , 'Ab welche E-Mail Adresse soll die Warnung gehen?');
define('ISTOCKALERT_STOCKALERT_STD_TITLE' , '[istockalert] Lagerbestand Minimum Standardwert');
define('ISTOCKALERT_STOCKALERT_STD_DESC' , 'Wenn kein Wert angegeben ist für Lagerbestand Minimum wird dieser Wert herangezogen.');
// istockalert end
---------------------------------------------------------------------------------------------------
lang/german/admin/new_attributes.php
------------------------------------
finde folgendes:
?>
Füge davor ein:
define('ATTR_STOCK_ALERT','Stock- alert'); // istockalert
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
| 
