* * 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; } } }