function update_shopinfo_xml() { global $spalten; if (!file_exists(DIR_FS_SHOPINFO_XML) || filesize(DIR_FS_SHOPINFO_XML) == 0) { echo '<p class="ok">OK, die Shopdatei wurde noch nicht angelegt und muss folglich auch nicht angepasst werden.</p>' . "\n"; return true; } echo '<p>Lade Shopdatei: <code>' . DIR_FS_SHOPINFO_XML . '</code>' . "\n"; $tree = new XML_Tree(DIR_FS_SHOPINFO_XML, '1.0" encoding="ISO-8859-1'); #$tree->useCdataSections(); $root =& $tree->getTreeFromFile(); if (PEAR::isError($root)) { echo '<p class="error">Fehler beim Parsen der Shopdatei:<br>' . "\n"; echo $root->toString() . "</p>\n"; return false; } $name_parts = explode(':', $root->name); if (sizeof($name_parts) > 1) { $namespace = $name_parts[0] . ':'; } else { $namespace = ''; } $requests =& $tree->getNodeAt($namespace . 'Shop/Requests'); if (PEAR::isError($requests)) { #echo '<p>Warnung: Zugriff auf Produktdaten in der Shopdatei nicht gefunden.</p>'."\n"; // Request-Tag nach dem Url-Tag einfügen $pos = -1; for ($i = 0; $i < count($root->children); ++$i) { if ($root->children[$i]->name == 'Url') { $pos = $i + 1; } } $requests = new XML_Tree_Node('Requests'); $res =& $root->insertChild(null, $pos, $requests); if (PEAR::isError($res)) { echo '<p class="error">Das Requests-Tag konnte nicht in die shopinfo.xml eingefügt werden:<br>' . "\n"; echo $res->toString() . "</p>\n"; return false; } } $offlineRequest =& $tree->getNodeAt($namespace . 'Shop/Requests/OfflineRequest'); if (PEAR::isError($offlineRequest)) { #echo '<p>Warnung: Produktdatei-Angaben in der Shopdatei nicht gefunden.</p>'."\n"; $offlineRequest =& offlineRequest($requests); echo '<p class="ok">OK, Produktdatei-Angaben ergänzt.</p>' . "\n"; } else { $header =& $tree->getNodeAt($namespace . 'Shop/Requests/OfflineRequest/Format/Tabular/CSV/Header'); if (PEAR::isError($header)) { echo '<p class="error">Das Kopfzeilen-Tag in der Shopdatei nicht gefunden:<br>' . "\n"; echo $header->toString() . "</p>\n"; return false; } $old_titel = $header->content; // Funktion getContent gibt es nicht. #echo 'old_titel: '.htmlspecialchars($old_titel)."\n\n"; $corrected = false; if ($header->getAttribute('columns') != count($spalten)) { $header->setAttribute('columns', count($spalten)); $corrected = true; } $mappings =& $tree->getNodeAt($namespace . 'Shop/Requests/OfflineRequest/Format/Tabular/Mappings'); if (PEAR::isError($mappings)) { echo '<p class="error">Das Mappings-Tag in der Shopdatei nicht gefunden:<br>' . "\n"; echo $mappings->toString() . "</p>\n"; return false; } foreach ($mappings->children as $idx => $child) { if (count($child->attributes) > 0) { if ($child->getAttribute('columnName') != $spalten[$child->getAttribute('column') - 1]) { #echo $idx.': '.$child->getAttribute('columnName').' => '; $mappings->children[$idx]->setAttribute('columnName', $spalten[$child->getAttribute('column') - 1]); #echo $mappings->children[$idx]->getAttribute('columnName')."<br>\n"; $corrected = true; } } } if (defined('DEFAULT_QUOTE')) { $titel = DEFAULT_QUOTE . implode(DEFAULT_QUOTE . DEFAULT_DELIMITER . DEFAULT_QUOTE, $spalten) . DEFAULT_QUOTE; } else { $titel = implode(DEFAULT_DELIMITER, $spalten); } #echo 'titel: '.htmlspecialchars($titel)."\n\n"; if ($old_titel != $titel) { $header->setContent($titel); } $special =& $tree->getNodeAt($namespace . 'Shop/Requests/OfflineRequest/Format/Tabular/CSV/SpecialCharacters'); if (PEAR::isError($special)) { echo '<p class="error">Das Sonderzeichen-Tag in der Shopdatei nicht gefunden:<br>' . "\n"; echo $special->toString() . "</p>\n"; return false; } $old_escape = $special->getAttribute('escaped'); $old_quote = $special->getAttribute('quoted'); $old_lineend = $special->getAttribute('lineend'); $old_delimiter = $special->getAttribute('delimiter'); if (defined('DEFAULT_ESCAPE')) { $special->setAttribute('escaped', DEFAULT_ESCAPE); } else { $special->unsetAttribute('escaped'); } if (defined('DEFAULT_QUOTE')) { $special->setAttribute('quoted', DEFAULT_QUOTE); } else { $special->unsetAttribute('quoted'); } if (defined('DEFAULT_LINEEND')) { $special->setAttribute('lineend', DEFAULT_LINEEND == "\n" ? '\\n' : (DEFAULT_LINEEND == "\r" ? '\\r' : '\\r\\n')); } else { $special->unsetAttribute('lineend'); } if (defined('DEFAULT_DELIMITER')) { $special->setAttribute('delimiter', DEFAULT_DELIMITER == "\t" ? '[tab]' : DEFAULT_DELIMITER); } else { $special->unsetAttribute('delimiter'); } $new_escape = $special->getAttribute('escaped'); $new_quote = $special->getAttribute('quoted'); $new_lineend = $special->getAttribute('lineend'); $new_delimiter = $special->getAttribute('delimiter'); if (!$corrected && $old_titel == $titel && $new_escape == $old_escape && $new_quote == $old_quote && $new_lineend == $old_lineend && $new_delimiter == $old_delimiter) { echo '<p class="ok">OK, die Shopdatei wurde bereits aktualisiert.</p>' . "\n"; return true; } if ($old_titel != $titel) { echo '<p class="ok">OK, Kopfzeile aktualisiert.</p>' . "\n"; } if ($corrected) { echo '<p class="ok">OK, Spaltennamen aktualisiert.</p>' . "\n"; } if ($new_escape != $old_escape) { echo '<p class="ok">OK, Escape-Zeichen aktualisiert.</p>' . "\n"; } if ($new_quote != $old_quote) { echo '<p class="ok">OK, Zeichenkettenbegrenzer aktualisiert.</p>' . "\n"; } if ($new_lineend != $old_lineend) { echo '<p class="ok">OK, Zeilenendezeichen aktualisiert.</p>' . "\n"; } if ($new_delimiter != $old_delimiter) { echo '<p class="ok">OK, Trennzeichenzeichen aktualisiert.</p>' . "\n"; } } #echo '<pre>'.(htmlspecialchars($tree->get())).'</pre>'."\n"; if (!is_writable(DIR_FS_SHOPINFO_XML)) { echo '<p class="error">Die Shopdatei kann nicht geschrieben werden:<br>' . DIR_FS_SHOPINFO_XML . "</p>\n"; return false; } if (!($handle = @fopen(DIR_FS_SHOPINFO_XML, 'wb'))) { echo '<p class="error">Die Shopdatei kann nicht zum Schreiben geöffnet werden:<br>' . DIR_FS_SHOPINFO_XML . "</p>\n"; return false; } flock($handle, LOCK_EX); if (!@fwrite($handle, $tree->get())) { echo '<p class="error">Fehler beim Schreiben der Shopdatei:<br>' . DIR_FS_SHOPINFO_XML . "</p>\n"; return false; } flock($handle, LOCK_UN); @fclose($handle); // wenn hier etwas schief geht, ignorieren #$tree->free(); echo '<p class="ok">OK, die Shopdatei wurde aktualisiert.<br>' . DIR_FS_SHOPINFO_XML . '</p>' . "\n"; return true; }
function generate_shopinfo() { global $languages_id, $language_code, $currency, $currency_rate; // Alle Includes hier, wegen der Pfadangabe. Reihenfolge ist relevant! require ELMAR_PATH . 'tools/pear.php'; require ELMAR_PATH . 'tools/node.php'; require ELMAR_PATH . 'tools/parser.php'; require ELMAR_PATH . 'tools/tree.php'; $attributes = '1.0" encoding="ISO-8859-1'; $tree = new XML_Tree(NULL, $attributes); if (ELMAR_NEW_SHOPINFO_XML) { $XMLarray = array('xmlns' => 'http://elektronischer-markt.de/schema/shopinfo-2.0', 'xmlns:c' => 'http://elektronischer-markt.de/schema/categories-2.0', 'xmlns:xsi' => 'http://www.w3.org/2001/XMLSchema-instance', 'xsi:schemaLocation' => 'http://elektronischer-markt.de/schema/shopinfo-2.0 ' . ELMAR_SCHEMA_BASE_URL . 'shopinfo-2.0.xsd', 'version' => '2.0'); $root =& $tree->addRoot('Shop', NULL, $XMLarray); } else { $XMLarray = array('xmlns:osp' => 'http://elektronischer-markt.de/schema', 'xmlns:xsi' => 'http://www.w3.org/2001/XMLSchema-instance', 'xsi:schemaLocation' => 'http://elektronischer-markt.de/schema ' . ELMAR_SCHEMA_BASE_URL . 'shop.xsd'); $root =& $tree->addRoot('osp:Shop', NULL, $XMLarray); } $common =& $root->addChild("Common"); $xml_version =& $common->addChild("Version", ELMAR_NEW_SHOPINFO_XML ? '2.0' : '1.1'); $xml_language =& $common->addChild("Language", $language_code); $xml_currency =& $common->addChild("Currency", $currency); if (ELMAR_NEW_SHOPINFO_XML) { $xml_generator =& $common->addChild('Generator', 'Elm@r-Modul osCommerce/' . MODUL_VERSION . '.' . MODUL_SUBVERSION . ' (http://projekt.wifo.uni-mannheim.de/elmar/nav/osCommerce)'); } $name =& $root->addChild("Name", shopNameOrHost()); $shopUrl = ELMAR_SHOP_ROOT_DIR; //tep_href_link('index.php', '', 'NONSSL', false); $url =& $root->addChild("Url", $shopUrl); $requests =& $root->addChild("Requests"); // Die Parameter fuer die Echtzeitanfrage, siehe elmar_request.php $requestUrl = ELMAR_SHOP_ROOT_DIR . 'elmar_request.php'; // Url zur Echtzeitabfrage $onlineRequest =& $requests->addChild("OnlineRequest", Null, array("method" => "GET POST TRACE")); $processor =& $onlineRequest->addChild("Processor", $requestUrl); $paramBrand =& $onlineRequest->addChild("ParamBrand", 'p_brand'); $paramProduct =& $onlineRequest->addChild("ParamProduct", 'p_product'); $paramDescription =& $onlineRequest->addChild("ParamDescription", 'p_desc'); if (defined('ELMAR_PRODUCTS_EAN_FIELD')) { $paramEan =& $onlineRequest->addChild("ParamID", 'p_ean', array("type" => "EAN")); } if (defined('ELMAR_PRODUCTS_ISBN_FIELD')) { $paramIsbn =& $onlineRequest->addChild("ParamID", 'p_isbn', array("type" => "ISBN")); } if (ELMAR_NEW_SHOPINFO_XML) { $paramId =& $onlineRequest->addChild("ParamID", 'p_id', array("type" => "ID")); } $paramQuickSearch =& $onlineRequest->addChild("ParamQuickSearch", 'p_qs'); $paramPriceBounds =& $onlineRequest->addChild("ParamPriceBounds"); $lowerPrice =& $paramPriceBounds->addChild("LowerPrice", 'p_low'); $upperPrice =& $paramPriceBounds->addChild("UpperPrice", 'p_high'); $paramSize =& $onlineRequest->addChild("ParamSize", 'p_size'); $paramIP =& $onlineRequest->addChild("ParamIP", 'p_ip'); $offlineRequest =& offlineRequest($requests); if (ELMAR_NEW_SHOPINFO_XML) { $affiliateRequest =& $requests->addChild('AffiliateRequest', NULL, array('method' => 'GET POST TRACE')); $processor =& $affiliateRequest->addChild('Processor', ELMAR_SHOP_ROOT_DIR . 'elmar_affiliate.php'); $paramName =& $affiliateRequest->addChild('ParamName', 'name'); } /* $interface = & $root->addChild("Interface"); $positionLimit = & $interface->addChild("PositionLimit"); */ if (defined('STORE_LOGO') && file_exists(DIR_FS_CATALOG . DIR_WS_IMAGES . STORE_LOGO)) { $logo =& $root->addChild("Logo", IMAGE_PATH . STORE_LOGO); } /* $address = & $root->addChild("Adress"); $company= & $address->addChild("Company"); $street = & $address->addChild("Street"); $city = & $address->addChild("City"); */ if (emailOk()) { $contact =& $root->addChild("Contact"); $publicMailAddress =& $contact->addChild("PublicMailAddress", STORE_OWNER_EMAIL_ADDRESS); $privateMailAddress =& $contact->addChild("PrivateMailAddress", STORE_OWNER_EMAIL_ADDRESS); } /* $orderPhone = & $contact->addChild("OrderPhone"); $number= & $orderPhone->addChild("Number"); $costPerMinute= & $orderPhone->addChild("CostPerMinute"); $orderFax= & $contact->addChild("OrderFax"); $number = & $orderFax->addChild("Number"); $costPerMinute= & $orderFax->addChild("CostPerMinute"); $hotline = & $contact->addChild("Hotline"); */ $prodSum = productAnz(); $categories =& $root->addChild("Categories"); if ($prodSum > 0) { $totalProductCount =& $categories->addChild("TotalProductCount", $prodSum); } $ns = ELMAR_NEW_SHOPINFO_XML ? 'c:' : ''; $attrib = ELMAR_NEW_SHOPINFO_XML ? array('lang' => $language_code) : NULL; $mapOther = $language_code == 'de' ? 'Sonstiges' : 'Other'; // Die Produktkategorien der ersten Ebene schreiben. Durch "group by" Doppelte herauswerfen. $categories_query = tep_db_query('select c.categories_id, cd.categories_name from ' . TABLE_CATEGORIES . ' c left join ' . TABLE_CATEGORIES_DESCRIPTION . ' cd using(categories_id) where c.parent_id=0 and cd.language_id=' . (int) $languages_id . ' group by cd.categories_name'); if (tep_db_num_rows($categories_query)) { while ($category = tep_db_fetch_array($categories_query)) { $categories_name = trim($category['categories_name']); if ($categories_name != '') { $item =& $categories->addChild("Item", NULL, $attrib); $name =& $item->addChild($ns . "Name", $categories_name); if (function_exists('tep_count_products_in_category') && ($cpic = tep_count_products_in_category($category['categories_id']))) { $productCount =& $item->addChild($ns . "ProductCount", $cpic); } $mapping =& $item->addChild($ns . "Mapping", KategorieAnpassen($category['categories_name'], $mapOther)); } } } else { $item =& $categories->addChild("Item", NULL, $attrib); $name =& $item->addChild($ns . "Name", $mapOther); if ($prodSum > 0) { $productCount =& $item->addChild($ns . "ProductCount", $prodSum); } $mapping =& $item->addChild($ns . "Mapping", $mapOther); } $lastschriftverfahren = defined('MODULE_PAYMENT_BANKTRANSFER_STATUS') && MODULE_PAYMENT_BANKTRANSFER_STATUS == 'True' ? true : false; $nachnahme = defined('MODULE_PAYMENT_COD_STATUS') && MODULE_PAYMENT_COD_STATUS == 'True' ? true : false; $paypal = defined('MODULE_PAYMENT_PAYPAL_STATUS') && MODULE_PAYMENT_PAYPAL_STATUS == 'True' ? true : false; $rechnung = defined('MODULE_PAYMENT_INVOICE_STATUS') && MODULE_PAYMENT_INVOICE_STATUS == 'True' ? true : false; $vorkasse = defined('MODULE_PAYMENT_MONEYORDER_STATUS') && MODULE_PAYMENT_MONEYORDER_STATUS == 'True' ? true : false; #$barzahlung = (defined('MODULE_PAYMENT_CASH_STATUS') && (MODULE_PAYMENT_CASH_STATUS == 'True')) ? true : false; #e-cash (elektronisches Zahlungsmittel); money transfer (Ueberweisung); cheque (Scheck) if ($nachnahme || $paypal || $lastschriftverfahren || $rechnung || $vorkasse) { $payment =& $root->addChild("Payment"); if ($nachnahme) { $item =& $payment->addChild("Item"); $name =& $item->addChild("Name", 'on delivery'); // Nachnahme //$surcharge = & $item->addChild("Surcharge"); //$maxSurcharge = & $item->addChild("MaxSurcharge"); //$relativeSurcharge = & $item->addChild("RelativeSurcharge"); } if ($paypal) { $item =& $payment->addChild("Item"); $name =& $item->addChild("Name", 'paypal'); // PayPal } if ($lastschriftverfahren) { $item =& $payment->addChild("Item"); $name =& $item->addChild("Name", 'debit'); // Bankeinzug/Lastschrift } if ($rechnung) { $item =& $payment->addChild("Item"); $name =& $item->addChild("Name", 'invoice'); // Rechnung } if ($vorkasse) { $item =& $payment->addChild("Item"); $name =& $item->addChild("Name", 'pre-payment'); // Vorauszahlung } } $free_shipping = defined('MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING') && MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING == 'true' ? true : false; $shipping_flat_status = defined('MODULE_SHIPPING_FLAT_STATUS') && MODULE_SHIPPING_FLAT_STATUS == 'True' ? true : false; if ($free_shipping || $shipping_flat_status) { $forwardExpenses =& $root->addChild("ForwardExpenses"); if ($shipping_flat_status) { if (DISPLAY_PRICE_WITH_TAX == 'true') { $shipping_flat_cost = tep_add_tax(MODULE_SHIPPING_FLAT_COST, tep_get_tax_rate(MODULE_SHIPPING_FLAT_TAX_CLASS, STORE_COUNTRY, MODULE_SHIPPING_FLAT_ZONE)); } else { $shipping_flat_cost = MODULE_SHIPPING_FLAT_COST; } $flatRate =& $forwardExpenses->addChild("FlatRate", number_format($shipping_flat_cost * $currency_rate, 2)); } if ($free_shipping) { $upperBound =& $forwardExpenses->addChild("UpperBound", number_format(MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER * $currency_rate, 2)); } } /* $features = & $root->addChild("Features"); $installment = & $features->addChild("Installment"); $orderTracking = & $features->addChild("OrderTracking"); $deliverTracking = & $features->addChild("DeliverTRacking"); $installationAssistance = & $features->addChild("InstallationAssistance"); $repairService = & $features->addChild("RepairService"); $careAfterPurchase = & $features->addChild("CareAfterPurchase"); $giftService = & $features->addChild("GiftService"); */ $technology =& $root->addChild("Technology"); if (ENABLE_SSL) { $ssl =& $technology->addChild("SSL"); } $search =& $technology->addChild("Search"); // $set = & $technology->addChild("SET"); if (defined('FILENAME_CONDITIONS')) { $termAndConditions =& $root->addChild("TermsAndConditions"); $url =& $termAndConditions->addChild("Url", tep_href_link(FILENAME_CONDITIONS, '', 'NONSSL', false)); // $return = & $termAndConditions->addChild("Return"); } /* $specialDiscount = & $root->addChild("SpecialDiscount"); $description = & $specialDiscount->addChild("Description"); $url = & $specialDiscount->addChild("Url"); $certifications= & $root->addChild("Certifications"); $item = & $certifications->addChild("Item"); $self_Discription = & $root->addChild("Self-Discription"); */ $content = $tree->get(); $content = str_replace(''', '\'', $content); // ersetzen von ' $content = str_replace('|', '|', $content); // ersetzen von | return $content; }