*
* Es gelten die Nutzungs- und Lizenzhinweise unter http://www.jtl-software.de/eazysales.php
*
* @author JTL-Software <*****@*****.**>
* @copyright 2006, JTL-Software
* @link http://jtl-software.de/eazysales.php
* @version v1.0 / 16.06.06
*/
define('OOS_VALID_MOD', 'yes');
require 'syncinclude.php';
$return = 3;
if (auth()) {
if (intval($_POST['action']) == 1 && intval($_POST['KeyEigenschaft'])) {
$Eigenschaft->kEigenschaft = intval($_POST["KeyEigenschaft"]);
$Eigenschaft->kArtikel = intval($_POST['KeyArtikel']);
$Eigenschaft->cName = realEscape($_POST["Name"]);
//hole products_id
$products_id = getFremdArtikel($Eigenschaft->kArtikel);
if ($products_id > 0) {
//hole einstellungen
$eazysales_einstellungenstable = $oostable['eazysales_einstellungen'];
$cur_query = xtc_db_query("SELECT languages_id FROM {$eazysales_einstellungenstable}");
$einstellungen = mysql_fetch_object($cur_query);
//hol products_options_id
$products_optionstable = $oostable['products_options'];
$cur_query = xtc_db_query("SELECT products_options_id\n FROM {$products_optionstable}\n WHERE language_id=" . $einstellungen->languages_id . "\n AND products_options_name=\"{$Eigenschaft->cName}\"");
$options_id = mysql_fetch_object($cur_query);
if (!$options_id->products_options_id) {
//erstelle eigenschaft
//hole max PK
$products_optionstable = $oostable['products_options'];
function attributBearbeiten($Attribut)
{
if ($Attribut->content && $Attribut->products_id > 0) {
//hole einstellungen
$eazysales_einstellungenstable = $oostable['eazysales_einstellungen'];
$query = "SELECT currencies_id, languages_id, mappingEndkunde, mappingHaendlerkunde, shopURL,\n tax_class_id, tax_zone_id, tax_priority, shipping_status_id, versandMwst,\n cat_listing_template, cat_category_template, cat_sorting, cat_sorting2,\n prod_product_template, prod_options_template, StatusAbgeholt, StatusVersendet\n FROM {$eazysales_einstellungenstable}";
$einstellungen = $dbconn->Execute($query);
switch (strtolower($Attribut->name)) {
case 'reihung':
xtc_db_query("UPDATE products SET products_sort=" . intval($Attribut->content) . " WHERE products_id=" . $Attribut->products_id);
break;
case 'reihung startseite':
xtc_db_query("UPDATE products SET products_startpage_sort=" . intval($Attribut->content) . " WHERE products_id=" . $Attribut->products_id);
break;
case 'suchbegriffe':
xtc_db_query("UPDATE products_description SET products_keywords=\"" . realEscape($Attribut->content) . "\" WHERE language_id=" . $einstellungen->languages_id . " AND products_id=" . $Attribut->products_id);
break;
case 'meta title':
xtc_db_query("UPDATE products_description SET products_meta_title=\"" . realEscape($Attribut->content) . "\" WHERE language_id=" . $einstellungen->languages_id . " AND products_id=" . $Attribut->products_id);
break;
case 'meta description':
xtc_db_query("UPDATE products_description SET products_meta_description=\"" . realEscape($Attribut->content) . "\" WHERE language_id=" . $einstellungen->languages_id . " AND products_id=" . $Attribut->products_id);
break;
case 'meta keywords':
xtc_db_query("UPDATE products_description SET products_meta_keywords=\"" . realEscape($Attribut->content) . "\" WHERE language_id=" . $einstellungen->languages_id . " AND products_id=" . $Attribut->products_id);
break;
case 'herstellerlink':
xtc_db_query("UPDATE products_description SET products_url=\"" . realEscape($Attribut->content) . "\" WHERE language_id=" . $einstellungen->languages_id . " AND products_id=" . $Attribut->products_id);
break;
case 'lieferstatus':
$shipping_id = 0;
//gibt es schon so einen shipping status?
$cur_query = xtc_db_query("SELECT shipping_status_id FROM shipping_status WHERE language_id=" . $einstellungen->languages_id . " AND shipping_status_name=\"" . realEscape($Attribut->content) . "\"");
$shipping_status_id_arr = mysql_fetch_row($cur_query);
if ($shipping_status_id_arr[0] > 0) {
$shipping_id = $shipping_status_id_arr[0];
} else {
//fge neuen Shippingstatus ein
$cur_query = xtc_db_query("SELECT max(shipping_status_id) FROM shipping_status");
$max_shipping_status_id_arr = mysql_fetch_row($cur_query);
$shipping_id = $max_shipping_status_id_arr[0] + 1;
xtc_db_query("INSERT INTO shipping_status (shipping_status_id, language_id, shipping_status_name) VALUES ({$shipping_id}, {$einstellungen->languages_id}, \"{$Attribut->content}\")");
}
xtc_db_query("UPDATE products SET products_shippingtime=" . $shipping_id . " WHERE products_id=" . $Attribut->products_id);
break;
case 'fsk 18':
if ($Attribut->content == "ja") {
xtc_db_query("UPDATE products SET products_fsk18=1 WHERE products_id=" . $Attribut->products_id);
}
break;
case 'vpe wert':
xtc_db_query("UPDATE products SET products_vpe_value=" . floatval($Attribut->content) . " WHERE products_id=" . $Attribut->products_id);
break;
case 'vpe anzeigen':
if ($Attribut->content == "ja") {
xtc_db_query("UPDATE products SET products_vpe_status=1 WHERE products_id=" . $Attribut->products_id);
} elseif ($Attribut->content == "nein") {
xtc_db_query("UPDATE products SET products_vpe_status=0 WHERE products_id=" . $Attribut->products_id);
}
break;
}
}
}
