static function unformat_array($array)
{
while (list($key, $value) = each($array)) {
if (is_array($array[$key])) {
$array[$key] = String::unformat_array($array[$key]);
} else {
$array[$key] = String::unformat($array[$key]);
}
}
return $array;
}
$smarty->assign("message", $message);
$template = 'guestbook.a_edit_message.html';
$template_mode = 'single';
break;
case $action == 'edit_msg' && isset($_GET['id']):
$id = $_GET['id'];
$navigation[] = array("url" => BASE_URL . "/admin/?mod=guestbook", "title" => '–едактировать сообщение');
$guestbook = $db->get_single("SELECT * FROM fw_guestbook WHERE id='{$id}'");
$guestbook = String::unformat_array($guestbook);
$smarty->assign("guestbook", $guestbook);
$smarty->assign("mode", "edit");
$template = 'guestbook.a_edit.html';
break;
default:
if (isset($_GET['page'])) {
$page = $_GET['page'];
} else {
$page = 1;
}
$result = $db->query("SELECT COUNT(*) FROM fw_guestbook");
$pager = Common::pager($result, GB_MESSAGES_PER_PAGE, $page);
$smarty->assign("total_pages", $pager['total_pages']);
$smarty->assign("current_page", $pager['current_page']);
$smarty->assign("pages", $pager['pages']);
$guestbook_list = $db->get_all("SELECT * FROM fw_guestbook ORDER BY insert_date DESC LIMIT " . $pager['limit']);
$guestbook_list = String::unformat_array($guestbook_list);
if (count($guestbook_list) > 0) {
$smarty->assign("guestbook_list", $guestbook_list);
}
break;
}
$page_found = true;
$profile = $db->get_single("SELECT *,(SELECT COUNT(*) FROM fw_orders WHERE user=u.id) AS orders FROM fw_users u WHERE u.id='" . $_SESSION['fw_user']['id'] . "'");
$profile = String::unformat_array($profile, 'front');
$orders_list = $db->get_all("SELECT a.id,a.user,a.insert_date,a.status,\n\t\t\t\t\t\t\t\t\tb.product_id,b.order_id,b.product_count,\n\t\t\t\t\t\t\t\t\tc.name,c.small_description,c.price,c.article FROM fw_products\n\t\t\t\t\t\t\t\t\tas c INNER JOIN (fw_orders as a INNER JOIN fw_orders_products as b\n\t\t\t\t\t\t\t\t\tON b.order_id=a.id) ON c.id=b.product_id\n\t\t\t\t\t\t\t\t\tWHERE a.user='******'fw_user']['id'] . "'");
$search = array("'<FONT[^>]*?>'", "'</FONT>'", "'<font[^>]*?>'", "'</font>'");
$replace = new Replace();
if (count($orders_list)) {
foreach ($orders_list as $key => $val) {
$price = $orders_list[$key]['price'];
$orders_list[$key]['price'] = number_format($orders_list[$key]['price'] * $cur_admin['kurs'] / $cur_site['kurs'], 2);
$orders_list[$key]['price2'] = number_format($price * $cur_admin['kurs'] / $cur_site2['kurs'], 2);
$orders_list[$key]['small_description'] = $replace->getReplace($search, "", $orders_list[$key]['small_description']);
}
}
if (count($orders_list) > 0) {
$orders_list = String::unformat_array($orders_list, 'front');
$smarty->assign("orders_list", $orders_list);
}
$template = 'cabinet_orders.html';
break;
default:
$userId = $check_auth = Common::check_auth_shop('user');
$user = $users->get_user($userId);
if (count($url) == 1) {
$page_found = true;
}
$orders = $shop->getUserOrders($userId);
$smarty->assign("profile", $user);
$smarty->assign("orders", $orders);
$main = $smarty->fetch($templates_path . '/cabinet_main_new.html');
$smarty->assign("main", $main);
$main_template = BASE_PATH . '/templates/404.html';
//$navigation[]=array("url"=>"/","title"=>"пїЅпїЅпїЅпїЅпїЅпїЅ 404. пїЅпїЅпїЅпїЅпїЅпїЅпїЅпїЅ пїЅпїЅ пїЅпїЅпїЅпїЅпїЅпїЅпїЅ");
}
$temp = '';
//print_r($navigation);
for ($i = 0; $i < count($navigation); $i++) {
$_SESSION['nav'][$i] = $navigation[$i]['title'];
$temp .= $navigation[$i]['url'] . "/";
$navigation[$i]['url'] = $temp;
}
//костыль
if (count($navigation) > 1) {
unset($navigation[count($navigation) - 1]);
}
//print_r($navigation);
$navigation = String::unformat_array($navigation, 'front');
$smarty->assign("navigation", $navigation);
$smarty->assign("base_url", BASE_URL);
$smarty->assign("template", $template);
if (isset($css)) {
$smarty->assign("css", $css);
}
if (isset($js)) {
$smarty->assign("js", $js);
}
$smarty->assign("db_connections", $_SESSION['db_connections']);
$smarty->assign("pgt", $pgt);
if (isset($page) or $set_pages_url) {
$current_url = implode("/", $current_url_pages);
$current_url = preg_replace("/&sort=([a-z]+)/i", "", $current_url);
$current_url = preg_replace("/&order=([a-z]+)/i", "", $current_url);
case $action == 'edit_post':
$id = $_GET['post_id'];
$post = $db->get_single("SELECT text,id,author,parent,\n\t\t\t\t\t\t\t\t\t\t\t\t\t(SELECT title FROM fw_forum_threads WHERE id=p.parent) AS title,\n\t\t\t\t\t\t\t\t\t\t\t\t\t(SELECT id FROM fw_forum_threads WHERE id=p.parent) AS thread_id,\n\t\t\t\t\t\t\t\t\t\t\t\t\t(SELECT parent FROM fw_forum_threads WHERE id=p.parent) AS thread_parent\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM fw_forum_posts p WHERE p.id='{$id}'");
if ($_SESSION['fw_user']['id'] != $post['author']) {
Common::check_priv("{$priv}");
} else {
$smarty->assign("no_move", true);
}
if ($_GET['is_thread'] == 'yes') {
$smarty->assign("is_thread", 'yes');
$forums_list = Common::get_nodes_list($forums_list);
unset($forums_list[0]);
$smarty->assign("forums_list", $forums_list);
}
$post['text'] = add_forum_tags($post['text']);
$post = String::unformat_array($post);
$smarty->assign("post", $post);
$template = 'forum.a_edit_post.html';
$template_mode = 'single';
break;
case $action == 'create_new_thread':
$id = $_GET['post_id'];
$smarty->assign("forums_list", Common::get_nodes_list($forums_list));
$smarty->assign("post_id", $id);
$template = 'forum.a_create_thread.html';
$template_mode = 'single';
break;
case $action == 'move_post' && isset($_GET['forum_id']):
$id = $_GET['post_id'];
$forum_id = $_GET['forum_id'];
if (isset($_GET['page']) && $_GET['page'] != '') {
case $action == 'add':
$navigation[] = array("url" => BASE_URL . "/admin/?mod=otr&action=add", "title" => 'ƒобавить решение');
$smarty->assign("mode", "add");
$template = 'otr.a_edit.html';
break;
case $action == 'edit' && isset($_GET['id']):
$id = $_GET['id'];
$navigation[] = array("url" => BASE_URL . "/admin/?mod=otr", "title" => '–едактировать решение');
$otr = $db->get_single("SELECT * FROM fw_otr WHERE id='{$id}'");
$otr = String::unformat_array($otr);
$smarty->assign("otr", $otr);
$smarty->assign("mode", "edit");
$template = 'otr.a_edit.html';
break;
default:
if (isset($_GET['page'])) {
$page = $_GET['page'];
} else {
$page = 1;
}
$result = $db->query("SELECT COUNT(*) FROM fw_otr");
$pager = Common::pager($result, OTR_PER_PAGE, $page);
$smarty->assign("total_pages", $pager['total_pages']);
$smarty->assign("current_page", $pager['current_page']);
$smarty->assign("pages", $pager['pages']);
$otr_list = $db->get_all("SELECT * FROM fw_otr ORDER BY title ASC LIMIT " . $pager['limit']);
$otr_list = String::unformat_array($otr_list);
if (count($otr_list) > 0) {
$smarty->assign("otr_list", $otr_list);
}
}
unset($url[$n]);
unset($current_url_pages[count($current_url_pages) - 1]);
$n = count($url) - 1;
$smarty->assign("type", $type);
} else {
unset($type);
}
if (isset($type) && $type == 'all') {
unset($type);
}
$cur_site = $db->get_single("SELECT kurs,znak FROM fw_currency WHERE id=" . CURRENCY_SITE);
$cur_site = String::unformat_array($cur_site);
$cur_site2 = $db->get_single("SELECT kurs,znak FROM fw_currency WHERE id=" . CURRENCY_SITE2);
$cur_site2 = String::unformat_array($cur_site2);
$cur_admin = $db->get_single("SELECT kurs,znak FROM fw_currency WHERE id=" . CURRENCY_ADMIN);
$cur_admin = String::unformat_array($cur_admin);
$smarty->assign("currency_site", $cur_site);
$smarty->assign("currency_site2", $cur_site2);
$shop = new Shop($db);
/*-----------------РАЗЛИЧНЫЕ ДЕЙСТВИЯ-----------------*/
if (isset($_POST['submit_rating'])) {
$id = $_POST['id'];
$comment = String::secure_user_input($_POST['nm_text']);
$comment = Common::strip_forum_tags($comment);
$author = $_SESSION['fw_user']['id'];
if ($comment != '') {
$db->query("INSERT INTO fw_products_comments(product_id,author,text,insert_date) VALUES('{$id}','{$author}','{$comment}','" . time() . "')");
}
if (isset($_POST['rating'])) {
$rating = $_POST['rating'];
$check_rating = explode(",", $_COOKIE['fw_rating']);
<?php
$cur_site = $db->get_single("SELECT kurs,znak FROM fw_currency WHERE id=" . CURRENCY_SITE);
$cur_site = String::unformat_array($cur_site);
$smarty->assign("currency_site", $cur_site);
$cur_admin = $db->get_single("SELECT kurs,znak FROM fw_currency WHERE id=" . CURRENCY_ADMIN);
$cur_admin = String::unformat_array($cur_admin);
$count_cat = $db->get_single("SELECT COUNT(*) AS count FROM fw_tree");
$count_documents = $db->get_single("SELECT COUNT(*) AS count FROM fw_tree WHERE module='page'");
$count_users = $db->get_single("SELECT COUNT(*) AS count FROM fw_users");
$last_orders = $db->get_all("SELECT a.id,a.user,\n\t\t\t\t\t\t\t a.insert_date as order_date,\n\t\t\t\t\t\t\t (SELECT login FROM fw_users as b WHERE b.id=a.user) as user_name,\n\t\t\t\t\t\t\t (SELECT SUM((SELECT price FROM fw_products WHERE id=c.product_id) * c.product_count) \n\t\t\t\t\t\t\t FROM fw_orders_products as c WHERE c.order_id=a.id) as total_summ \n\t\t\t\t\t\t\t FROM fw_orders as a ORDER BY a.insert_date LIMIT 0,5");
$last_orders = String::unformat_array($last_orders);
if (count($last_orders) > 0) {
for ($i = 0; $i < count($last_orders); $i++) {
$last_orders[$i]['total_summ'] = number_format($last_orders[$i]['total_summ'] * $cur_admin['kurs'] / $cur_site['kurs'], 2);
}
}
$last_faq = $db->get_all("SELECT a.id,a.author, a.insert_date as insert_date,a.message FROM fw_guestbook as a ORDER BY insert_date LIMIT 0,5");
$last_faq = String::unformat_array($last_faq);
$forum_enabled = $db->get_single("SELECT id FROM fw_modules WHERE name='forum'");
if (strlen(trim($forum_enabled['id'])) > 0) {
$last_forum = $db->get_all("SELECT a.id, a.parent, a.author, a.publish_date, a.publish_date as date, a.text, b.id as thread_id, b.parent, b.title,\n\t\t\t\t\t\t\tc.url, c.name\n\t\t\t\t\t\t\tFROM fw_forum_posts as a INNER JOIN (fw_forum_threads as b INNER JOIN fw_forums as c ON b.parent=c.id) ON a.parent=b.id WHERE a.status='1' ORDER BY a.publish_date LIMIT 0,5");
$last_forum = String::unformat_array($last_forum);
$smarty->assign("last_forum", $last_forum);
}
$smarty->assign("last_orders", $last_orders);
$smarty->assign("last_faq", $last_faq);
$smarty->assign("count_cat", $count_cat['count']);
$smarty->assign("count_documents", $count_documents['count']);
$smarty->assign("count_users", $count_users['count']);
case $action == 'add':
$navigation[] = array("url" => BASE_URL . "/admin/?mod=questions&action=add", "title" => 'ƒобавить вопрос');
$smarty->assign("mode", "add");
$template = 'questions.a_edit.html';
break;
case $action == 'edit' && isset($_GET['id']):
$id = $_GET['id'];
$navigation[] = array("url" => BASE_URL . "/admin/?mod=questions", "title" => '–едактировать вопрос');
$questions = $db->get_single("SELECT * FROM fw_questions WHERE id='{$id}'");
$questions = String::unformat_array($questions);
$smarty->assign("questions", $questions);
$smarty->assign("mode", "edit");
$template = 'questions.a_edit.html';
break;
default:
if (isset($_GET['page'])) {
$page = $_GET['page'];
} else {
$page = 1;
}
$result = $db->query("SELECT COUNT(*) FROM fw_questions");
$pager = Common::pager($result, 10, $page);
$smarty->assign("total_pages", $pager['total_pages']);
$smarty->assign("current_page", $pager['current_page']);
$smarty->assign("pages", $pager['pages']);
$questions_list = $db->get_all("SELECT *, (SELECT count(id) FROM fw_answers WHERE question_id=fw_questions.id) as count_answers FROM fw_questions ORDER BY id DESC LIMIT " . $pager['limit']);
$questions_list = String::unformat_array($questions_list);
if (count($questions_list) > 0) {
$smarty->assign("questions_list", $questions_list);
}
}
}
if (isset($_GET['cat'])) {
if (isset($_SESSION['fw_product_added']) && $_SESSION['fw_product_added'] == '1') {
$_SESSION['fw_product_added'] = '0';
$smarty->assign("product_added", '1');
}
if (isset($_GET['page'])) {
$page = $_GET['page'];
} else {
$page = 1;
}
$result = $db->query("SELECT COUNT(*) FROM fw_products");
$pager = Common::pager($result, PRODUCTS_PER_PAGE, $page);
$cat = $_GET['cat'];
$products_list = $db->get_all("SELECT * FROM fw_products WHERE parent='{$cat}' AND status='1' LIMIT " . $pager['limit']);
$products_list = String::unformat_array($products_list);
$smarty->assign("products_list", $products_list);
$smarty->assign("cat", $cat);
$smarty->assign("total_pages", $pager['total_pages']);
$smarty->assign("current_page", $pager['current_page']);
$smarty->assign("pages", $pager['pages']);
} else {
$smarty->assign("cat_list", $cat_list);
}
$template = 'mini_catalogue.html';
$template_mode = 'single';
break;
case $action == 'delete_additional_product' && isset($_GET['id']) & isset($_GET['from']):
$id = $_GET['id'];
$from = $_GET['from'];
$product = $db->get_single("SELECT additional_products FROM fw_products WHERE id='{$from}'");
if (isset($_GET['parent'])) {
$parent = intval($_GET['parent']);
$smarty->assign("parent", $parent);
$template = "tree.a_edit_document.html";
$smarty->assign("mode", "add");
$nodes_list = Common::get_nodes_list($nodes_list, 'page');
unset($nodes_list[0]);
$smarty->assign("nodes_list", $nodes_list);
}
break;
case $action == 'edit_document':
$navigation[] = array("url" => BASE_URL . "/admin/?mod=tree&action=edit_document", "title" => 'Редактировать документ');
if (isset($_GET['id'])) {
$id = intval($_GET['id']);
$result = $db->get_single("SELECT * FROM fw_documents WHERE id='" . $id . "'");
if (count($result) > 0) {
$template = "tree.a_edit_document.html";
$smarty->assign("parent", $result['parent']);
$smarty->assign("mode", "edit");
$smarty->assign("document", $result);
$nodes_list = Common::get_nodes_list($nodes_list, 'page');
unset($nodes_list[0]);
$smarty->assign("nodes_list", $nodes_list);
}
}
break;
default:
$content = $db->get_all("\n SELECT\n *,\n (SELECT COUNT(id) FROM fw_documents WHERE parent=t.id) as documents\n FROM fw_tree t\n ORDER BY t.param_left ASC\n ");
$content = String::unformat_array($content);
$smarty->assign("content", Common::get_nodes_list($content));
}
case $action == 'edit' && isset($_GET['id']):
$id = $_GET['id'];
$navigation[] = array("url" => BASE_URL . "/admin/?mod=news", "title" => 'Редактировать новость');
$news = $db->get_single("SELECT * FROM fw_news WHERE id='{$id}'");
$news = String::unformat_array($news);
$smarty->assign("news", $news);
$smarty->assign("mode", "edit");
$template = 'news.a_edit.html';
break;
default:
if (isset($_GET['page'])) {
$page = $_GET['page'];
} else {
$page = 1;
}
if (isset($_GET['year']) && intval($_GET['year']) > 0) {
$cond = " WHERE YEAR(FROM_UNIXTIME(publish_date))='" . $_GET['year'] . "' ";
} else {
$cond = "";
}
$result = $db->query("SELECT COUNT(*) FROM fw_news {$cond}");
$pager = Common::pager($result, NEWS_PER_PAGE, $page);
$smarty->assign("total_pages", $pager['total_pages']);
$smarty->assign("current_page", $pager['current_page']);
$smarty->assign("pages", $pager['pages']);
$news_list = $db->get_all("SELECT * FROM fw_news {$cond} ORDER BY publish_date DESC LIMIT " . $pager['limit']);
$news_list = String::unformat_array($news_list);
if (count($news_list) > 0) {
$smarty->assign("news_list", $news_list);
}
}
$smarty->assign("current_page", $pager['current_page']);
$smarty->assign("pages", $pager['pages']);
$smarty->assign("total_photos", count($photos_list));
$smarty->assign("photos_list", String::unformat_array($photos_list, 'front'));
$smarty->assign("album_id", $album_id);
$mode = 'album';
} else {
if (isset($_GET['page']) && $_GET['page'] != '') {
$page = $_GET['page'];
} else {
$page = 1;
}
$result = $db->query("SELECT COUNT(*) FROM fw_photoalbums");
$pager = Common::pager($result, ALBUMS_PER_PAGE, $page);
$albums_list = $db->get_all("SELECT *,(SELECT COUNT(*) FROM fw_photoalbum_images WHERE parent=a.id) AS photos FROM fw_photoalbums a LIMIT " . $pager['limit']);
$albums_list = String::unformat_array($albums_list);
$cl = Common::get_nodes_list($cat_list);
for ($i = 0; $i < count($albums_list); $i++) {
for ($k = 0; $k < count($cl); $k++) {
if ($albums_list[$i]['parent'] == $cl[$k]['id']) {
$albums_list[$i]['cat_title'] = $cl[$k]['full_title'];
break;
}
}
}
$smarty->assign("total_pages", $pager['total_pages']);
$smarty->assign("cat_list", $cl);
$smarty->assign("current_page", $pager['current_page']);
$smarty->assign("pages", $pager['pages']);
$smarty->assign("albums_list", $albums_list);
$mode = 'albums_list';
$navigation[] = array("url" => BASE_URL . "/admin/?mod=subscribe&action=templates", "title" => 'Шаблоны писем');
$smarty->assign("templates_list", $db->get_all("SELECT id,name FROM fw_subscribe_templates"));
$template = 'subscribe.a_templates.html';
break;
case $action == 'add_template':
$navigation[] = array("url" => BASE_URL . "/admin/?mod=subscribe&action=templates", "title" => 'Шаблоны писем');
$navigation[] = array("url" => BASE_URL . "/admin/?mod=subscribe&action=add_template", "title" => 'Добавить шаблон');
$smarty->assign("mode", "add");
$template = 'subscribe.a_edit_template.html';
break;
case $action == 'edit_template':
$navigation[] = array("url" => BASE_URL . "/admin/?mod=subscribe&action=templates", "title" => 'Шаблоны писем');
$navigation[] = array("url" => BASE_URL . "/admin/?mod=subscribe&action=edit_template", "title" => 'Редактировать шаблон');
$id = $_GET['id'];
$t = $db->get_single("SELECT * FROM fw_subscribe_templates WHERE id='{$id}'");
$smarty->assign("t", String::unformat_array($t));
$smarty->assign("mode", "edit");
$template = 'subscribe.a_edit_template.html';
break;
case $action == 'users':
$navigation[] = array("url" => BASE_URL . "/admin/?mod=subscribe&action=users", "title" => 'Подписчики');
if (isset($_GET['page'])) {
$page = $_GET['page'];
} else {
$page = 1;
}
$result = $db->query("SELECT COUNT(*) FROM fw_subscribe_list");
$pager = Common::pager($result, 50, $page);
$smarty->assign("total_pages", $pager['total_pages']);
$smarty->assign("current_page", $pager['current_page']);
$smarty->assign("pages", $pager['pages']);
$navigation[] = array("url" => BASE_URL . "/admin/?mod=shop&action=currency", "title" => 'Курсы валют');
$cur_list = $db->get_all("SELECT * FROM fw_currency");
$cur_list = String::unformat_array($cur_list);
$smarty->assign("cur_list", $cur_list);
$template = 'shop.a_cur_list.html';
break;
case $action == 'add_cur':
$navigation[] = array("url" => BASE_URL . "/admin/?mod=shop", "title" => 'Курс валют');
$smarty->assign("mode", "add");
$template = 'shop.a_cur_edit.html';
break;
case $action == 'edit_cur' && isset($_GET['id']):
$navigation[] = array("url" => BASE_URL . "/admin/?mod=shop", "title" => 'Редактирование валюты');
$id = $_GET['id'];
$cur = $db->get_single("SELECT * FROM fw_currency WHERE id='{$id}'");
$cur = String::unformat_array($cur);
$smarty->assign("mode", "edit");
$smarty->assign("cur", $cur);
$template = 'shop.a_cur_edit.html';
break;
default:
$count_cat = $db->get_single("SELECT COUNT(*) AS count FROM fw_catalogue");
$count_products = $db->get_single("SELECT COUNT(*) AS count FROM fw_products");
$count_orders = $db->get_single("SELECT COUNT(*) AS count FROM fw_orders");
$total_price = $db->get_single("SELECT SUM(total_price) AS total FROM fw_orders");
if ($total_price['total'] == '') {
$total_price = '0.00';
} else {
$total_price = $total_price['total'];
}
$smarty->assign("count_cat", $count_cat['count']);
$all_forums = Common::get_nodes_list($all_forums);
for ($i = 0; $i < sizeof($pre_threads); $i++) {
foreach ($all_forums as $k => $v) {
if ($v['id'] == $pre_threads[$i]['parent']) {
$pre_threads[$i]['full_url'] = $v['full_url'] . 'thread_' . $pre_threads[$i]['id'];
}
}
}
$smarty->assign("pre_threads", $pre_threads);
$template = 'premoderation.html';
break;
case count($url) == 3 && $url[$n - 1] == 'info' && preg_match("/^[0-9]*\$/", $url[$n]):
$navigation[] = array("url" => 'info', "title" => 'Информация о пользователе');
$id = $url[$n];
$info = $db->get_single("SELECT * FROM fw_users WHERE id='{$id}'");
$info = String::unformat_array($info);
$smarty->assign("info", $info);
$pp = $db->get_all("SELECT th.* FROM fw_forum_posts AS po LEFT JOIN fw_forum_threads AS th ON po.parent=th.id AND th.status='1' AND po.status='1' WHERE th.parent='10' AND po.author='" . $info['id'] . "' AND po.publish_date=(SELECT publish_date FROM fw_forum_posts WHERE parent=po.parent AND status='1' ORDER BY publish_date LIMIT 1)");
$all_forums = Common::get_nodes_list($all_forums);
for ($i = 0; $i < sizeof($pp); $i++) {
foreach ($all_forums as $k => $v) {
if ($v['id'] == $pp[$i]['parent']) {
$pp[$i]['full_url'] = $v['full_url'] . 'thread_' . $pp[$i]['id'];
}
}
}
$smarty->assign("pp", $pp);
$page_found = true;
$template = 'user_info.html';
break;
case count($url) == 4 && $url[$n - 2] == 'info' && $url[$n] == 'albums' && preg_match("/^[0-9]*\$/", $url[$n - 1]):
$dumper = new dumper();
if (isset($_POST['file']) && $_POST['file'] != '') {
$dumper->restore($_POST['file']);
}
$smarty->assign("file_date", $dumper->file_date);
$smarty->assign("q_number", $dumper->q_number);
$smarty->assign("t_number", $dumper->t_number);
$smarty->assign("r_number", $dumper->r_number);
$smarty->assign("action", "restore");
}
if ($_SESSION['fw_user']['priv'] == '0') {
foreach (glob(BASE_PATH . "/backup/" . DB_NAME . "_*.*") as $filename) {
$filename = explode("/", $filename);
$files_list[] = $filename[count($filename) - 1];
}
if (isset($files_list)) {
$smarty->assign("files_list", $files_list);
}
}
$smarty->assign("db_name", DB_NAME);
$template = 'edit_conf.a_backup.html';
break;
default:
$navigation[] = array("url" => BASE_URL . "/admin/?mod=edit_conf", "title" => 'Редактировать настройки');
$conf_list = $db->get_all("SELECT * FROM fw_conf where `section` = 'shop' and `conf_key` in ('MAIL_FROM', 'SEND_ORDER_TO') ORDER BY section,name");
$conf_list = String::unformat_array($conf_list);
$cur_list = $db->get_all("SELECT * FROM fw_currency WHERE status=1");
$cur_list = String::unformat_array($cur_list);
$smarty->assign("conf_list", $conf_list);
$smarty->assign("cur_list", $cur_list);
}
setcookie('fw_rating', $cookie_content, time() + 315360000, '/', '');
}
}
$location = @$_SERVER['HTTP_REFERER'];
header("Location: {$location}");
}
/*--------------------ÎÒÎÁÐÀÆÅÍÈÅ---------------------*/
//Common::dumper($_SESSION['fw_basket']);
if (!isset($_SESSION['fw_basket'])) {
$_SESSION['fw_basket'] = array();
}
switch (TRUE) {
case preg_match("/^([0-9]+)\$/", $url[$n]) && $url[$n - 1] == 'edit_url':
$item = $db->get_single("SELECT * FROM fw_ferms_urls WHERE id='" . $url[$n] . "'");
if (count($item) > 0) {
$item = String::unformat_array($item);
}
$smarty->assign("item", $item);
$smarty->assign("mode", "edit");
$item = $db->get_single("SELECT name FROM fw_ferms WHERE id='" . $item['ferm_id'] . "'");
$smarty->assign("ferm_name", $item['name']);
$page_found = true;
$template = 'ferms.f_url_add.html';
break;
case preg_match("/^([0-9]+)\$/", $url[$n]) && $url[$n - 1] == 'del_url':
$db->query("DELETE FROM fw_ferms_urls WHERE id='" . $url[$n] . "'");
$location = $_SERVER['HTTP_REFERER'];
header("Location: {$location}");
die;
break;
case preg_match("/^([0-9]+)\$/", $url[$n]) && $url[$n - 1] == 'add_url':
if (trim($firms[$i]['site']) != "") {
$val .= "Сайт: <a target=_blank href='" . $firms[$i]['site'] . "'>" . $firms[$i]['site'] . "</a><br>";
}
$val .= "</td></tr>";
$val .= "</table>";
}
} else {
$val = "Фирмы для данного метро не загружены";
}
$_RESULT = array("status" => $status, "val" => $val, "val2" => $val2);
$switch_off_smarty = true;
echo "<b>REQUEST_URI:</b> " . $_SERVER['REQUEST_URI'] . "<br>";
echo "<b>Loader used:</b> " . $JsHttpRequest->LOADER;
break;
default:
$reg_list = String::unformat_array($cl);
$moskow = $db->get_single("SELECT * FROM fw_citys WHERE name='Москва'");
if ($moskow['id'] > 0) {
$i = count($reg_list);
$reg_list[$i]['id'] = 'moskow';
$reg_list[$i]['name'] = $moskow['name'];
}
unset($url[0]);
for ($j = count($reg_list) - 1; $j = 0; $j--) {
$floor[] = $reg_list[$j];
}
$smarty->assign("reg_list", $reg_list);
$smarty->assign("regions", 1);
$smarty->assign("base_url", BASE_URL);
$template = 'regions.f_main.html';
$page_found = true;
<?php
require_once 'http://' . $_SERVER['HTTP_HOST'] . "/lib/class.db.php";
require_once 'http://' . $_SERVER['HTTP_HOST'] . "/lib/JsHttpRequest/Php.php";
require_once 'http://' . $_SERVER['HTTP_HOST'] . '/conf/globals.php';
$db = new db(DB_NAME, DB_HOST, DB_USER, DB_PASS);
switch ($_REQUEST["action"]) {
case "get_citys":
$val = "";
$status = 1;
$firms = $db->get_all("SELECT * FROM fw_firms WHERE status=1 ORDER BY name");
/*if (count($products)>0){
$val = "<select onChange=void(sel(this,'http://".$_SERVER['HTTP_HOST']."')); name=product style='width : 222px;'><option selected>выберите товар";
}
else{ $val = "<select name=product style='width : 222px;' disabled><option selected>товары не найдены"; }
for($i=0; $i<count($products);$i++){ $val .= "<option value='". $products[$i]['name'] ."'>". $products[$i]['name'] ."</option>"; }
$val .= "</select>";*/
$firms = String::unformat_array($firms);
$val = count($firms);
$JsHttpRequest =& new Subsys_JsHttpRequest_Php("windows-1251");
$_RESULT = array("status" => $status, "val" => $val);
$switch_off_smarty = true;
break;
}
//$db->close_connect();
$photo = new Photoalbum();
$cat_content['text'] = $photo->pregReplace($cat_content['text'], BASE_PATH, PHOTOS_FOLDER, PHOTOS_PER_PAGE_SUP);
$table = new Table();
$cat_content['text'] = $table->pregReplace($cat_content['text'], BASE_PATH);
$form = new Form();
$cat_content['text'] = $form->pregReplace($cat_content['text'], BASE_PATH);
$text = $cat_content['text'];
$smarty->assign("text", $text);
$result = $db->query("SELECT COUNT(*) FROM fw_products WHERE parent='" . $cat_content['id'] . "' {$where} {$order}");
$pager = Common::pager($result, PRODUCTS_PER_PAGE_FRONT, $page);
$smarty->assign("total_pages", $pager['total_pages']);
$smarty->assign("current_page", $pager['current_page']);
$smarty->assign("pages", $pager['pages']);
$products_list = $db->get_all("\n\t\t\t\tSELECT *,\n\t\t\t\t\t\t(SELECT id FROM fw_products_images i WHERE i.parent=p.id ORDER BY sort_order ASC LIMIT 1) AS image,\n\t\t\t\t\t\t(SELECT ext FROM fw_products_images WHERE parent=p.id ORDER BY insert_date DESC LIMIT 1) AS ext,\n\t\t\t\t\t\t(SELECT name FROM fw_products_types WHERE id=p.product_type LIMIT 0,1) AS type_name,\n\t\t\t\t\t\t(SELECT id FROM fw_products_types WHERE id=p.product_type LIMIT 0,1) AS type_id,\n\t\t\t\t\t\t(SELECT\n\t\t\t\t\t\t\tGROUP_CONCAT(CONCAT_WS('||#||',\n\t\t\t\t\t\t\t\tcp.id,\n\t\t\t\t\t\t\t\tcp.name,\n\t\t\t\t\t\t\t\tcp.type,\n\t\t\t\t\t\t\t\tcp.elements,\n\t\t\t\t\t\t\t\tcp.status,\n\t\t\t\t\t\t\t\t(SELECT value FROM fw_products_properties AS pp WHERE pp.product_id = p.id AND pp.property_id = cr.property_id LIMIT 1)\n\t\t\t\t\t\t\t) ORDER BY cr.sort_order SEPARATOR '##|##')\n\t\t\t\t\t\tFROM fw_catalogue_relations AS cr\n\t\t\t\t\t\tLEFT JOIN fw_catalogue_properties AS cp ON cp.id=cr.property_id\n\t\t\t\t\t\tWHERE cr.cat_id = p.parent) as properties\n\t\t\t\t\tFROM fw_products AS p\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tp.parent='" . $cat_content['id'] . "'\n\t\t\t\t\t\tAND\n\t\t\t\t\t\tp.status='1' {$where}\n\t\t\t\t\t\t{$order} LIMIT " . $pager['limit']);
$rel = $db->get_all("SELECT * FROM fw_cats_types_relations as a INNER JOIN fw_products_types as b ON a.type_id=b.id WHERE a.cat_id=" . $cat_content['id'] . " ORDER BY b.name");
$rel = String::unformat_array($rel);
$smarty->assign("rel", $rel);
foreach ($products_list as $v => $key) {
$tmp = explode("##|##", $key['properties']);
$products_list[$v]['properties'] = array();
foreach ($tmp as $val => $k) {
if (substr_count($k, "||#||") > 0) {
$tmp2 = explode("||#||", $k);
$products_list[$v]['properties'][] = $tmp2;
if (substr_count($products_list[$v]['properties'][$val][3], "\n") > 0) {
$products_list[$v]['properties'][$val][3] = explode("\n", $products_list[$v]['properties'][$val][3]);
}
}
}
// }
}
case $action == 'add':
$navigation[] = array("url" => BASE_URL . "/admin/?mod=polls&action=add", "title" => 'ƒобавить опрос');
$smarty->assign("mode", "add");
$template = 'polls.a_edit_poll.html';
break;
case $action == 'edit' && isset($_GET['id']):
$navigation[] = array("url" => BASE_URL . "/admin/?mod=polls&action=edit", "title" => '–едактировать опрос');
$id = $_GET['id'];
$poll = $db->get_single("SELECT * FROM fw_polls WHERE id='{$id}'");
$answers = $db->get_all("SELECT * FROM fw_polls_answers WHERE parent='{$id}' ORDER BY sort_order");
$poll['answers'] = $answers;
$poll = String::unformat_array($poll);
$smarty->assign("poll", $poll);
$smarty->assign("mode", "edit");
$template = 'polls.a_edit_poll.html';
break;
default:
if (isset($_GET['page'])) {
$page = $_GET['page'];
} else {
$page = 1;
}
$result = $db->query("SELECT COUNT(*) FROM fw_polls");
$pager = Common::pager($result, POLLS_PER_PAGE, $page);
$smarty->assign("total_pages", $pager['total_pages']);
$smarty->assign("current_page", $pager['current_page']);
$smarty->assign("pages", $pager['pages']);
$polls_list = $db->get_all("SELECT * FROM fw_polls ORDER BY publish_date DESC LIMIT " . $pager['limit']);
$polls_list = String::unformat_array($polls_list);
$smarty->assign("polls_list", $polls_list);
}
