|
ECB SEO SHOP SOFTWARE - IMEDES SOFTWARE DOWNLOADS
*****************************************
* *
* INSTALLATION-GUIDE *
* *
*****************************************
* @package Google Gadget *
* (C) 2008 Imedes.de *
* info@imedes.de *
* @compatible SP2.1 *
*****************************************
--------------
NEW FILES:
--------------
admin/google_gadget.php
gadget.php
gadget_bestseller.php
gadget_products_new.php
gadget_specials.php
includes/functions/database.php
install.google_gadget.php
lang/english/admin/google_gadget.php
lang/german/admin/google_gadget.php
templates/xtc4/img/add.gif
templates/xtc4/module/google_gadget.html
--------------
NEW DIRS:
--------------
imedes_library
includes/classes/adodb_full
--------------
CHANGED FILES:
--------------
admin/categories.php
admin/includes/application_top.php
admin/includes/classes/categories.php
admin/includes/column_left.php
admin/includes/functions/sessions.php
admin/includes/modules/categories_view.php
includes/application_top.php
includes/functions/sessions.php
lang/english/admin/categories.php
lang/english/admin/configuration.php
lang/english/admin/english.php
lang/english/lang_english.conf
lang/german/admin/categories.php
lang/german/admin/configuration.php
lang/german/admin/german.php
lang/german/lang_german.conf
templates/xtc4/source/boxes/content.php
-------------
INSTALLATION:
-------------
1. Die Datei "install.google_gadget.php" auf den Server in das Shop-Hauptverzeichnis kopieren und ausführen und danach löschen
2. new_files kopieren.
3. changed_files kopieren, oder bei nicht standard-version folgende änderungen durchführen:
-admin/categories.php
---------------------------------------------------------------------------------------------------
finde folgendes:
}
break;
//EOB setpflag
und füge danach ein:
case 'setgflag' :
if (($_GET['flag'] == '0') || ($_GET['flag'] == '1')) {
if ($_GET['pID']) {
$catfunc->set_google_gadget_status($_GET['pID'], $_GET['flag']);
}
}
xtc_redirect(xtc_href_link(FILENAME_CATEGORIES, 'cPath='.$_GET['cPath'].'&cID='.$_GET['cID']));
break;
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-admin/includes/application_top.php
---------------------------------------------------------------------------------------------------
finde folgendes:
define('FILENAME_XSELL_GROUPS','cross_sell_groups.php');
und füge danach ein:
define('FILENAME_GOOGLE_GADGET','google_gadget.php');
---------------------------------------------------------------------------------------------------
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');
---------------------------------------------------------------------------------------------------
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
---------------------------------------------------------------------------------------------------
finde folgendes:
// Sets a product active on startpage
function set_product_startpage($products_id, $status) {
if ($status == '1') {
und füge davor ein:
// ----------------------------------------------------------------------------------------------------- //
// Sets the status of a product
function set_google_gadget_status($products_id, $status) {
if ($status == '1') {
return xtc_db_query("update ".TABLE_PRODUCTS." set google_gadget = '1', products_last_modified = now() where products_id = '".$products_id."'");
}
elseif ($status == '0') {
return xtc_db_query("update ".TABLE_PRODUCTS." set google_gadget = '0', products_last_modified = now() where products_id = '".$products_id."'");
} else {
return -1;
}
}
// ----------------------------------------------------------------------------------------------------- //
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-admin/includes/column_left.php
---------------------------------------------------------------------------------------------------
finde folgendes:
if (($_SESSION['customers_status']['customers_status_id'] == '0') && ($admin_access['products_expected'] == '1')) echo '<a href="' . xtc_href_link(FILENAME_PRODUCTS_EXPECTED, '', 'NONSSL') . '" class="menuBoxContentLink"> -' . BOX_PRODUCTS_EXPECTED . '</a><br>';
und füge danach ein:
if (($_SESSION['customers_status']['customers_status_id'] == '0') && ($admin_access['categories'] == '1')) echo '<a href="' . xtc_href_link(FILENAME_GOOGLE_GADGET, '', 'NONSSL') . '" class="menuBoxContentLink"> -' . BOX_CONFIGURATION_444 . '</a><br>';
---------------------------------------------------------------------------------------------------
finde folgendes:
if (($_SESSION['customers_status']['customers_status_id'] == '0') && ($admin_access['cross_sell_groups'] == '1')) echo '<a href="' . xtc_href_link(FILENAME_XSELL_GROUPS, '', 'NONSSL') . '" class="menuBoxContentLink"> -' . BOX_ORDERS_XSELL_GROUP . '</a><br>';
und füge danach ein:
if (($_SESSION['customers_status']['customers_status_id'] == '0') && ($admin_access['configuration'] == '1')) echo '<a href="' . xtc_href_link(FILENAME_CONFIGURATION, 'gID=444', 'NONSSL') . '" class="menuBoxContentLink"> -' . BOX_CONFIGURATION_444 . '</a><br>';
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-admin/includes/functions/sessions.php
---------------------------------------------------------------------------------------------------
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/categories_view.php
---------------------------------------------------------------------------------------------------
finde folgendes:
$catsort = 'c.categories_status DESC';
$prodsort = 'p.products_status DESC';
break;
und füge danach ein:
case 'ggadget' :
$catsort = 'c.sort_order ASC'; //default
$prodsort = 'p.google_gadet ASC';
break;
case 'ggadget-desc' :
$catsort = 'c.sort_order DESC'; //default
$prodsort = 'p.google_gadet DESC';
break;
---------------------------------------------------------------------------------------------------
finde folgendes:
<td class="dataTableHeadingContent" align="center" width="7%">
<?php echo TABLE_HEADING_STARTPAGE.xtc_sorting(FILENAME_CATEGORIES,'startpage'); ?>
</td>
und füge danach ein:
<td class="dataTableHeadingContent" align="center" width="7%">
<?php echo TABLE_HEADING_GOOGLE_GADGET.xtc_sorting(FILENAME_CATEGORIES,'ggadget'); ?>
</td>
---------------------------------------------------------------------------------------------------
finde folgendes:
<td class="categories_view_data">--</td>
<td class="categories_view_data">--</td>
<td class="categories_view_data">--</td>
und füge danach ein:
<td class="categories_view_data">--</td>
---------------------------------------------------------------------------------------------------
finde folgendes:
p.products_date_available,
p.products_status,
p.products_startpage,
und füge danach ein:
p.google_gadget,
---------------------------------------------------------------------------------------------------
finde folgendes:
p.products_date_available,
p.products_status,
p.products_startpage,
und füge danach ein:
p.google_gadget,
---------------------------------------------------------------------------------------------------
finde folgendes:
//show price
echo $currencies->format($products['products_price']);
?>
und füge davor ein:
if ($products['google_gadget'] == '1') {
echo xtc_image(DIR_WS_IMAGES . 'icon_status_green.gif', IMAGE_ICON_STATUS_GREEN, 10, 10) . ' <a href="' . xtc_href_link(FILENAME_CATEGORIES, xtc_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'action=setgflag&flag=0&pID=' . $products['products_id'] . '&cPath=' . $cPath) . '">' . 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_CATEGORIES, xtc_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'action=setgflag&flag=1&pID=' . $products['products_id'] . '&cPath=' . $cPath) . '">' . 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>
<td class="categories_view_data">
<?php
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-includes/application_top.php
---------------------------------------------------------------------------------------------------
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');
---------------------------------------------------------------------------------------------------
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;
---------------------------------------------------------------------------------------------------
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/functions/sessions.php
---------------------------------------------------------------------------------------------------
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/categories.php
---------------------------------------------------------------------------------------------------
finde folgendes:
define('TABLE_HEADING_EDIT','Edit');
und füge danach ein:
define('TABLE_HEADING_GOOGLE_GADGET','Google Gadget');
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-lang/english/admin/configuration.php
---------------------------------------------------------------------------------------------------
finde folgendes:
?>
und füge davor ein:
// GOOGLE GADGET
define('GOOGLE_GADGET_DEFAULT_TAB_TITLE','Standard tab');
define('GOOGLE_GADGET_DEFAULT_TAB_DESC','Which tab should be shown by default?');
define('GOOGLE_GADGET_HOW_MANY_TITLE','How many products?');
define('GOOGLE_GADGET_HOW_MANY_DESC','How many products should be shown per tab?');
define('GOOGLE_GADGET_THUMBNAIL_TITLE','Thumbnail URL');
define('GOOGLE_GADGET_THUMBNAIL_DESC','Please enter an URL to your thumbnail picture, that should be shown in the google directory. The graphic should have a size of 160x120 pixels.');
define('GOOGLE_GADGET_SCREENSHOT_TITLE','Screenshot URL');
define('GOOGLE_GADGET_SCREENSHOT_DESC','Please enter an URL to your screenshot picture, that should be shown in the google directory. The graphic should have a width of 280 pixels.');
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-lang/english/admin/english.php
---------------------------------------------------------------------------------------------------
finde folgendes:
define('BOX_CONFIGURATION_22', 'Search-Options');
und füge danach ein:
define('BOX_CONFIGURATION_444', 'Google Gadget');
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-lang/english/lang_english.conf
---------------------------------------------------------------------------------------------------
finde folgendes:
[new_products]
und füge danach ein:
text_details = 'Details...'
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-lang/german/admin/categories.php
---------------------------------------------------------------------------------------------------
finde folgendes:
define('TABLE_HEADING_EDIT','Edit');
und füge danach ein:
define('TABLE_HEADING_GOOGLE_GADGET','Google Gadget');
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-lang/german/admin/configuration.php
---------------------------------------------------------------------------------------------------
finde folgendes:
?>
und füge davor ein:
// GOOGLE GADGET
define('GOOGLE_GADGET_DEFAULT_TAB_TITLE','Standart Registerkarte');
define('GOOGLE_GADGET_DEFAULT_TAB_DESC','Welche Registerkarte soll standardmäßig angezeigt werden?');
define('GOOGLE_GADGET_HOW_MANY_TITLE','Anzahl an Artikeln');
define('GOOGLE_GADGET_HOW_MANY_DESC','Wie viele Artikel sollen pro Registerkarte maximal angezeigt werden?');
define('GOOGLE_GADGET_THUMBNAIL_TITLE','Thumbnail URL');
define('GOOGLE_GADGET_THUMBNAIL_DESC','Bitte geben Sie hier die URL zu Ihrem Thumbnail-Bild ein, das im Google Verzeichnis angezeigt werden soll. Die Grafik muss eine Größe von 160x120 Pixeln haben.');
define('GOOGLE_GADGET_SCREENSHOT_TITLE','Screenshot URL');
define('GOOGLE_GADGET_SCREENSHOT_DESC','Bitte geben Sie hier die URL zu der Screenshot-Grafik ein, die im Google Verzeichnis angezeigt werden soll. Die Grafik muss eine Breite von 280 Pixeln haben.');
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-lang/german/admin/german.php
---------------------------------------------------------------------------------------------------
finde folgendes:
define('BOX_CONFIGURATION_22', 'Such-Optionen');
und füge danach ein:
define('BOX_CONFIGURATION_444', 'Google Gadget');
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-lang/german/lang_german.conf
---------------------------------------------------------------------------------------------------
finde folgendes:
[new_products]
und füge danach ein:
text_details = 'Details...'
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
-templates/xtc4/source/boxes/content.php
---------------------------------------------------------------------------------------------------
finde folgendes:
$content_string .= '<img src="templates/'.CURRENT_TEMPLATE.'/img/icon_arrow.jpg" alt="" /> <a href="'.xtc_href_link(FILENAME_CONTENT, 'coID='.$content_data['content_group'].$SEF_parameter).'">'.$content_data['content_title'].'</a><br />';
}
und füge danach ein:
if ($_SESSION['languages_id'] == 2) {
$domain = 'de';
} else {
$domain = 'com';
}
$content_string .= '<a href="http://www.google.'.$domain.'/ig/adde?moduleurl='.HTTP_SERVER.DIR_WS_CATALOG.'gadget.php" target="_blank"><img src="templates/'.CURRENT_TEMPLATE.'/img/add.gif" width="104" height="17" border="0" alt="Add to Google"></a>';
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
|