function page_news_list() { page_header("{~НОВОСТИ}"); $news = db_fetch_objects(db_query("SELECT * FROM news ORDER BY weight DESC")); $o = ""; foreach ($news as $r) { obj_trans($r); $GLOBALS['news'] = $r; $o .= template("news_list"); } return $o; }
function page_search($search = "") { mb_internal_encoding("UTF-8"); $s = $search; if (!$s) { $s = form_post("s"); } $o = ""; if ($s) { $rr = db_fetch_objects(db_query("SELECT * FROM pages WHERE content_search like '%%%s%%' LIMIT 10", $s)); if (count($rr) == 0) { $o .= "Под запрос <strong>{$s}</strong> не подходит ни одна страница."; } else { foreach ($rr as $r) { $r->content = fld_trans(strip_for_search($r->content)); $r->content_search = fld_trans($r->content_search); $p = 0; if (mb_strpos($r->content_search, mb_strtolower($s)) !== FALSE) { $p = mb_strpos($r->content_search, mb_strtolower($s), 0); $r->content = mb_substr($r->content, 0, $p) . "<strong>" . mb_substr($r->content, $p, mb_strlen($s)) . "</strong>" . mb_substr($r->content, $p + mb_strlen($s), mb_strlen($r->content)); } $start = $p - 200; if ($start < 0) { $start = 0; } $r->span = mb_substr($r->content, $start, 400); $r->url = translit(fld_trans($r->short, "ru")); $r->short = fld_trans($r->short); $GLOBALS['r'] = $r; $o .= template("search"); } } } $o .= "<div style='padding-top:20px'><a href=search/google&s=" . urlencode($s) . ">Использовать google поиск по сайту</a></div>"; return $o; }
function menu_items($parent_id) { $items = db_fetch_objects(db_query("SELECT * FROM menu WHERE parent_id=%d ORDER BY weight", $parent_id)); return $items; }
function db_objects_get($table, $where_and_limit) { return db_fetch_objects(db_query("SELECT * FROM {$table} WHERE {$where_and_limit}")); }
function catalog_menu() { $items = db_fetch_objects(db_query("SELECT id,title FROM catalog WHERE parent_id=0 ORDER BY weight")); $o = ""; global $lang_dir; foreach ($items as $item) { $url = to_url(fld_trans($item->title, "eng")); $item->title = fld_trans($item->title); $o .= "<div class='menuItemDiv level1'><div class=title><a href={$lang_dir}catalog/{$url}>{$item->title}</a></div>"; $sub_items = db_fetch_objects(db_query("SELECT id,title FROM catalog WHERE parent_id={$item->id} ORDER BY weight")); $o .= "<div class=subMenu>"; foreach ($sub_items as $sub) { $sub_url = to_url(fld_trans($sub->title, "eng")); $sub->title = fld_trans($sub->title); $o .= "<div class='menuItemDiv level2'><div class=title><a href={$lang_dir}catalog/{$url}/{$sub_url}>{$sub->title}</a></div></div>"; } $o .= "</div>"; $o .= "</div>"; } return $o; }
function page_report($daysago = 0) { $midnight = @mktime(0, 0, 0, date('n'), @date('j') - $daysago); $rr = db_fetch_objects(db_query("SELECT * FROM log WHERE time_time>{$midnight}")); table_start(6); $state = 0; $total = 0; foreach ($rr as $r) { $next = db_result(db_query("SELECT time_time FROM log WHERE id>{$r->id} ORDER BY id LIMIT 1")); if (!$next) { $next = time(); } $span = round(($next - $r->time_time) / (60 * 60), 2); if ($r->active_check) { table_add("<input class=active_check type=checkbox>"); } else { table_add(""); } table_add(@date("H:i:s", $r->time_time)); table_add($r->memo); table_add($span, " class=span "); $mins = 60 * $span; table_add("hour ({$mins} min)"); $h = $span * 200; if ($r->active_check) { $bg = "#0f0"; } else { $bg = "#ddd"; } table_add("<div style='height:{$h}px;background:{$bg};'> </div>"); if ($r->active_check) { $total += $span; } } $o = table(); $total_min = 60 * $total; $o .= "total: {$total} ({$total_min} min)<br>"; $o .= "checked total: <span id=checked_total></span>"; return $o; }
function menu_id_by_title_trans($title, $parent_id = -1) { if ($parent_id == -1) { $menu = db_fetch_objects(db_query("SELECT id, title FROM menu")); } else { $menu = db_fetch_objects(db_query("SELECT id, title FROM menu WHERE parent_id=%d", $parent_id)); } foreach ($menu as $m) { if (translit(fld_trans($m->title)) == $title) { $GLOBALS['menu__active'] = $m; $GLOBALS['menu__active_item__title_full'] = $m->title; return $m->id; } } return false; }
function page_id_by_title($title, $lang = "rus") { $pages = db_fetch_objects(db_query("SELECT id,short FROM pages")); foreach ($pages as $page) { if (fld_trans($page->short, $lang) == $title) { return $page->id; } } return 0; }