set('load', $loader); // Config $config = new Config(); $registry -> set('config', $config); // Database $db = new DB(DB_DRIVER, UPLOAD_DB_HOSTNAME, UPLOAD_DB_USERNAME, UPLOAD_DB_PASSWORD, UPLOAD_DB_DATABASE); $registry -> set('db', $db); $db->query("SET NAMES cp1251"); //if(!$add_link) $add_link = '?from=yandex'; $sDateNow = date('Y-m-d H:i'); $xml = ' Prof.ru ÎÎÎ "ÃÐÈÔÔ" http://www.prof.ru/ '; $sTradeItems = $db->query(" SELECT TG.NAME AS GROUP_NAME, TP.NAME AS PRODUCT_NAME, TP.PRODUCT_ID AS PRODUCT_ID, TPRICES.PRICE AS PRICE, TM.NAME AS MANUFACTURER_NAME, TI.* FROM TRADE_GROUPS TG, TRADE_PRODUCTS TP, TRADE_PRODUCT_ITEMS TPI, TRADE_ITEMS TI LEFT JOIN TRADE_MANUFACTURER TM ON TI.MANUFACTURER = TM.ID, TRADE_PRICES TPRICES WHERE TG.GROUP_ID=TP.GROUP_ID AND TG.GROUP_ID<>10647 AND TPI.PRODUCT_ID=TP.PRODUCT_ID AND TPI.ITEM_ID=TI.ITEM_ID AND TI.YM=1 AND /*TI.COUNT_POS > 0 AND*/ TPRICES.ITEM_ID=TI.ITEM_ID AND TPRICES.GROUP_ID=1 ORDER BY GROUP_NAME, PRODUCT_NAME, NAME, TPI.SORT_NO, PRICE "); $i = 0; $j = 0; $GROUP_NAME = ""; $PRODUCT_NAME = ""; $xml1 = "\n"; $xml2 = "\n"; foreach ($sTradeItems->rows as $row) { if ($aItemIds[$row['ITEM_ID']] > 0) { continue; } else { $aItemIds[$row['ITEM_ID']] = $row['ITEM_ID']; $prices = $db->query( "SELECT GROUP_ID, PRICE ". "FROM TRADE_PRICES ". "WHERE ITEM_ID='$row[ITEM_ID]' AND GROUP_ID>1"); } /* if (is_array($aItem[$row['NAME']])) { print_r($row); print_r($aItem[$row['NAME']]); echo "\n\n\n\n\n\n"; } else { $aItem[$row['NAME']] = $row; } */ if ($GROUP_NAME != $row["GROUP_NAME"]) { $i++; $j = $i; $GROUP_NAME = $row["GROUP_NAME"]; $xml1 .= ' '.$row["GROUP_NAME"].' '; } if ($PRODUCT_NAME != $row["PRODUCT_NAME"]) { $i++; $PRODUCT_NAME = $row["PRODUCT_NAME"]; $xml1 .= ' '.$row["PRODUCT_NAME"].' '; } $xml2 .= ' http://'.$_SERVER['HTTP_HOST'].'/'.seo($row["NAME"]).' '.$row["PRICE"].''."\n"; /* if(count($prices) > 0) { foreach($prices as $p) { $price_type = ''; switch($p['GROUP_ID']) { case '2': $price_type = 'lowoptprice';break; case '3': $price_type = 'optprice';break; } if($price_type!='') $xml2 .= " <$price_type>$p[PRICE]\n"; } }*/ $xml2 .= ' RUR '.$i.''.($row['IMAGE'] ? ' http://'.$_SERVER['HTTP_HOST'].'/image/data/catalog/'.$row['IMAGE'].'.jpg' : '').' true '.htmlspecialchars($row["NAME"]).($row['MANUFACTURER_NAME'] && strpos(' '.$row["NAME"], $row["MANUFACTURER_NAME"]) < 1 ? ', "'.$row['MANUFACTURER_NAME'].'"' : '').''.(trim($row["NOTE"]) ? ' '.htmlspecialchars($row["NOTE"]).'' : '').' 1000 '; } $xml1 .= "\n\n"; $xml2 .= "\n"; $xml .= $xml1.$xml2.' '; /*$fp = fopen("result.xml", "w"); fwrite($fp, $xml);*/ echo $xml; function seo($string) { $string = html_entity_decode($string); $string = mb_strtolower($string, 'windows-1251'); $string = str_replace(array('?','!','.',',',':',';','*','(',')','{','}','[',']','%','#','¹','@','$','^','-','+','/','\\','=','|','"','\'','à','á','â','ã','ä','å','¸','ç','è','é','ê','ë','ì','í','î','ï','ð','ñ','ò','ó','ô','õ','ú','û','ý',' ','æ','ö','÷','ø','ù','ü','þ','ÿ'), array('-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','a','b','v','g','d','e','e','z','i','y','k','l','m','n','o','p','r','s','t','u','f','h','j','i','e','-','zh','ts','ch','sh','shch','','yu','ya'), $string); $string = preg_replace('/[^a-z0-9-]/', '', $string); $string = trim($string, '-'); $prev_st = NULL; do { $prev_st = $string; $string = preg_replace('/-[a-z]-/', '-', $string); } while($string != $prev_st); $string = preg_replace('/-{2,}/', '-', $string); return $string; } ?>