db; $objCatalogs = $setup->setupClass("Catalogs"); function escapeLoc($loc){ $patterns = array(); $patterns[0] = '/&/'; $patterns[1] = '/\'/'; $patterns[2] = '/"/'; $patterns[3] = '/>/'; $patterns[4] = '/'; print""; print"ExtremStyle.ua - èíòåðíåò ìàãàçèí"; print"ExtremStyle"; print"http://extremstyle.ua/"; print''; print''; print''; print''; $res = $db->getAll("select * from catalogs_rubrics where is_xml=?",array(0),DB_FETCHMODE_ASSOC); //print_r($res); $rubrics = array(); print""; foreach($res as $row){ $rubrics[] = $row['id']; print"".$row['name'].""; } print""; print""; foreach($rubrics as $rub){ $res = $db->getAll("select p.*,r.translit as rubric_translit,r.is_xml2,b.name as brend,r.list_name from catalogs_products p LEFT JOIN catalogs_rubrics r ON r.id=p.rubric_id LEFT JOIN catalogs_brends b ON b.id=p.brend_id where p.rubric_id=? and p.count_modifications>0",array($rub),DB_FETCHMODE_ASSOC); foreach($res as $row){ print''; print"http://extremstyle.ua/" . htmlspecialchars(escapeLoc($row['rubric_translit'])) . "-catalogs/" . htmlspecialchars(escapeLoc($row['translit'])) . "-" . $row['id'] . "/"; print"" . $row['cine'] . ""; print"UAH"; print"" . $row['rubric_id'] . ""; print"http://extremstyle.ua/uploaded/pic/catalogs/products/" . $row['pic'] . ""; print"false"; $row['ph1'] = $objCatalogs->getFilterPh1($row['id']); print"" . htmlspecialchars(escapeLoc($row['ph1'])) .' '. htmlspecialchars(escapeLoc($row['list_name'])) .' '. htmlspecialchars(escapeLoc($row['brend'])) .' '. htmlspecialchars(escapeLoc($row['name'])) . ""; print"" . htmlspecialchars(nohtml(stripcslashes($row['text']))) . ""; print""; }} print""; print""; print""; ?>