db; function escapeLoc($loc){ $patterns = array(); $patterns[0] = '/&/'; $patterns[1] = '/\'/'; $patterns[2] = '/"/'; $patterns[3] = '/>/'; $patterns[4] = '/'; print""; print"" . date("Y-m-d h:m") . ""; print"ExtremStyle"; print""; print""; $res = $db->getAll("select * from catalogs_rubrics where is_xml2=?",array(1),DB_FETCHMODE_ASSOC); //print_r($res); $rubrics = array(); print""; foreach($res as $row){ $rubrics[] = $row['id']; print""; print"" . $row['id'] . ""; print"" . $row['parent_id'] . ""; print"" . $row['name'] . ""; print""; } print""; print""; foreach($rubrics as $rub){ $res = $db->getAll("select p.*,r.translit as rubric_translit,b.name as brend 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"" . $row['id'] . ""; print"" . $row['rubric_id'] . ""; print"0" . $row['id'] . ""; print""; print"" . htmlspecialchars(escapeLoc($row['brend'])) . ""; print"" . htmlspecialchars(escapeLoc($row['name'])) . ""; print"" . htmlspecialchars(nohtml(stripcslashes($row['text']))) . ""; print"http://extremstyle.ua/" . htmlspecialchars(escapeLoc($row['rubric_translit'])) . "-catalogs/" . htmlspecialchars(escapeLoc($row['translit'])) . "-" . $row['id'] . "/"; print"http://extremstyle.ua/uploaded/pic/catalogs/products/" . $row['pic'] . ""; print"" . $row['cine'] . ""; print""; print"Íà ñêëàäå"; print""; $res_m = $db->getAll("select * from catalogs_modifications where active=1 and product_id=?",array($row['id']),DB_FETCHMODE_ASSOC); foreach($res_m as $row_m){ print''.$row_m['size'].''; print''.$row_m['color'].''; print''; print''; print''; print''; print''; print''; print''; } print""; }} print""; print""; ?>