function do_xml()
{
$_str = $_str_temp = '';
// коннектимся
f_mysql_connect();
// выбираем
$result = mysql_db_query($GLOBALS["dbname"], "SELECT * FROM news where status=1 order by id desc limit " . ___findpole("select zna from config where id=9", 'zna'));
// формируем все новости
$name_file = '/rss/all.xml';
for ($i = 0; $i < mysql_numrows($result); $i++) {
$find = mysql_fetch_array($result);
// елементы для замены
$mass_element_for_parsing = array("%zag%", "%link%", "%text%", "%date%");
// заменяеміе значения
$mass_result_for_parsing = array($find['zag'], MAIN_PATH . "/news/idnews/" . $find['id'] . '/type/' . $find['type'], strip_tags(htmlspecialchars(substr($find['text'], 0, 150))), $find['date']);
// парсим данные
$_str_temp = parsing_tpl($name_file, $mass_element_for_parsing, $mass_result_for_parsing, $_str_temp);
}
// основной шаблон
$name_file = '/rss/template.xml';
// елементы для замены
$mass_element_for_parsing = array("%zag%", "%www%", "%tegs%");
// заменяеміе значения
$mass_result_for_parsing = array(iconv('CP1251', 'UTF-8', 'Новости'), iconv('CP1251', 'UTF-8', ADRESS_SITE), iconv('CP1251', 'UTF-8', $_str_temp));
// парсим данные
$_str = parsing_tpl($name_file, $mass_element_for_parsing, $mass_result_for_parsing, $_str);
write_keh(HOST . '/rss/ru.xml', $_str);
}
// get limit
$limit = pager::pager_limit(brand::get_count(), CATALOG_AT_PAGE);
// сортировка
$_sort = catalog::get_sort_at_page();
// фильтрация
$_filter = brand::get_filter();
// строим запрос
$_sql = 'SELECT catalog.*, brand.pole as brand_name
FROM catalog, brand
WHERE catalog.brand=brand.id and catalog.status=1 and brand.status=1 ' . $_filter . '
ORDER BY ' . $_sort . '
LIMIT ' . $limit;
// выполняем запрос + при необходимости выводим сам запрос
$result = mysql::query($_sql, 0);
// наименование бренда
$_brand = ___findpole('select pole from brand where id=' . $id, 'pole');
if ($result) {
$_str .= system::show_tpl(array('result' => $result, '_brand' => $_brand), 'frontend/catalog/brand/list.php');
} else {
$_str .= 'У данного бренда товары отсутствуют.';
}
} else {
// выводим все бренды
// get limit
$limit = pager::pager_limit(brand::get_count(), mysql::query_findpole('select zna from config where id=47', 'zna'));
// строим запрос
$_sql = 'SELECT
brand.*,
count(catalog.id) as count
FROM
brand
function get_h1()
{
global $zag_radel;
global $dbname;
// ищем в table ACTION сам action и если он есть то выхватываем имя раздела
//$_res=findpole_universal_full($_GET['action'],"content","action",1,"return");
$_res = ___findpole('select content.h1_' . $_GET['lang'] . ' from content where action="' . $_GET['action'] . '"', 'h1_' . $_GET['lang']);
//echo "----_res-----".$_res."<br>";
if (!$_res) {
if (isset($_GET['grupa']) and intval($_GET['grupa']) > 0) {
// строим запрос
$_sql = 'SELECT * FROM catalog_tree where id=' . $_GET['grupa'];
// выполняем запрос + при необходимости выводим сам запрос
$result = mysql::query_one($_sql, 0);
if ($result) {
$_res = $result->h1;
} else {
$_res = 'Такого товара нет!';
}
//echo "----_res-----".$_res."<br>";
} else {
if (isset($_GET['goods']) and $_GET['action'] == "catalog" and intval($_GET['goods']) > 0) {
// строим запрос
$_sql = 'SELECT * FROM catalog where id=' . intval($_GET['goods']) . ' and status=1';
// выполняем запрос + при необходимости выводим сам запрос
$result = mysql::query_one($_sql, 0);
if ($result) {
$_res = $result->name;
} else {
$_res = 'Такого товара нет!';
}
} else {
if (isset($_GET['action'])) {
if ($_GET['action'] == 'news') {
if (!isset($_GET['url'])) {
if (TYPE_NEWS == 0 or !isset($_GET['type'])) {
// нашли поля
$_arr = ___findarray('select h1, title from ceo where id=1');
} else {
// нашли поля
switch ($_GET['type']) {
case 1:
$_idd = 6;
break;
case 2:
$_idd = 7;
break;
default:
$_idd = 1;
break;
}
// нашли поля
$_arr = ___findarray('select h1, title from ceo where id=' . $_idd);
}
if ($_arr['h1'] != '') {
$_res = $_arr['h1'];
} else {
$_res = $_arr['title'];
}
} else {
$_res = ___findpole('select zag from news where url="' . $_GET['url'] . '"', 'zag');
}
} else {
if ($_GET['action'] == 'gallery') {
if (!isset($_GET['url'])) {
$_arr = ___findarray('select h1, title from ceo where id=2');
if ($_arr['h1'] != '') {
$_res = $_arr['h1'];
} else {
$_res = $_arr['title'];
}
if (isset($_GET['id'])) {
$_res .= ', ' . ___findpole('select pole from gallery_grupa where id=' . $_GET['id'], 'pole');
}
} else {
$_res = ___findpole('select pole from gallery_grupa where url="' . $_GET['url'] . '"', 'pole');
}
} else {
if ($_GET['action'] == 'search') {
$_arr = ___findarray('select h1, title from ceo where id=13');
if ($_arr['h1'] != '') {
$_res = $_arr['h1'];
} else {
$_res = $_arr['title'];
}
} else {
if ($_GET['action'] == 'voting') {
$_arr = ___findarray('select h1, title from ceo where id=12');
if ($_arr['h1'] != '') {
$_res = $_arr['h1'];
if (isset($_GET['arhiv'])) {
$_res = 'Архив голосований';
}
} else {
$_res = $_arr['title'];
}
} else {
if ($_GET['action'] == 'catalog') {
$_arr = ___findarray('select h1, title from ceo where id=3');
if ($_arr['h1'] != '') {
$_res = $_arr['h1'];
} else {
$_res = $_arr['title'];
}
} else {
if ($_GET['action'] == 'brand') {
$_arr = ___findarray('select h1, title from ceo where id=9');
if ($_arr['h1'] != '') {
$_res = $_arr['h1'];
} else {
$_res = $_arr['title'];
}
} else {
if ($_GET['action'] == 'basket') {
$_arr = ___findarray('select h1, title from ceo where id=10');
if ($_arr['h1'] != '') {
$_res = $_arr['h1'];
} else {
$_res = $_arr['title'];
}
} else {
if ($_GET['action'] == 'mycabinet') {
$_arr = ___findarray('select h1, title from ceo where id=11');
if ($_arr['h1'] != '') {
$_res = $_arr['h1'];
} else {
$_res = $_arr['title'];
}
} else {
if ($_GET['action'] == 'filter') {
// имя текущего раздела
$_res = filter::get_name_curent_filter();
} else {
if ($_GET['action'] == 'registration') {
$_arr = ___findarray('select h1, title from ceo where id=8');
if ($_arr['h1'] != '') {
$_res = $_arr['h1'];
} else {
$_res = $_arr['title'];
}
} else {
/*
* костыль для 3 новостей
*/
if (isset($_GET['type']) and $_GET['type'] == 1) {
$_res = $zag_radel['news1'];
} else {
if (isset($_GET['type']) and $_GET['type'] == 2) {
$_res = $zag_radel['news2'];
}
}
}
}
}
}
}
}
}
}
}
}
} else {
$_res = $zag_radel['main'];
}
}
}
}
return $_res;
}
