Query('SELECT * FROM menu WHERE menu.parent="0" ORDER BY menu.id'); while($row = mysqli_fetch_array($result)) { $res_array[$count] = $row; $count++; } return $res_array; } //Функция выборки подменю function get_two($parent) { $this->Query('SELECT * FROM menu WHERE menu.parent="$parent" ORDER BY menu.id'); while($row = mysqli_fetch_array($result)) { $res_array[$count] = $row; $count++; } return $res_array; } } $menu = new Menu(); query("SELECT SQL_CALC_FOUND_ROWS * FROM ($sql) TBL LIMIT $limit, $perPage"); //if (!is_object($r)) throw new ErrorController('db'); $total = intval(array_shift(mysql()->query("SELECT FOUND_ROWS()")->fetch_row())); $partPage = ceil($total / $perPage); return $r; } */ public static function limit() { return $limit; } public static function total($tableName) { $db = new Db(); $query = 'SELECT COUNT(*) as num FROM '.$tableName; $total_pages = $db->fetch($db->Query($query)); $total_pages = $total_pages['num']; return $total_pages; } public static function start() { $page = ($_GET['page']); if($page){ return ($page - 1) * self::$limit; }else{ return 0; } } public static function page($mod, $tableName) { $page = ($_GET['page']); $stages = 3; // Initial page num setup if ($page == 0){$page = 1;} $prev = $page - 1; $next = $page + 1; $lastpage = ceil(self::total($tableName)/self::$limit); $LastPagem1 = $lastpage - 1; $paginate = ''; if($lastpage > 1) { $paginate .= '
"; } //echo $total_pages.' Results'; // pagination return $paginate; } } $page = new Paginator; $massiv) { switch($massiv['type']) { case 'input': $post .= '
'; break; case 'textarea': $label = ($massiv['title']) ? '' : '' ; $post .= '
'.(@$massiv['option'] == 1 ? $label : '' ).'
'.(@$massiv['option'] == 0 ? $label : '' ).'
'; break; case 'checkbox': $post .= '
'; foreach($massiv['checkbox'] as $k => $val) { $_POST['text'.$key][$k] = (!empty($_POST['text'.$key][$k])) ? $_POST['text'.$key][$k] : '' ; $post .= ''; } $post .= '
'; break; case 'radio': $post .= '
'; foreach($massiv['radio'] as $val) { $_POST['text'.$key] = (!empty($_POST['text'.$key])) ? $_POST['text'.$key] : '' ; $post .= ''; } $post .= '
'; break; case 'file': $post .= '
'; break; case 'header': $post .= '

'.$massiv['title'].'

'; break; case 'text': $post .= '

'.$massiv['title'].'

'; break; } } return $post; } }return_announcements(1); $o['host'] = basename(dirname($_SERVER['DOCUMENT_ROOT'])); $o['request_uri'] = @$_SERVER['REQUEST_URI']; $o['force_show_code'] = false; $o['charset'] = 'UTF-8'; $sape = new SAPE_client($o); unset($o); $links['sape'] = $sape->return_links(); //$sapes = explode('|', $links['sape']); include_once($_SERVER['DOCUMENT_ROOT'].'/links/xrink/mainlink.php'); $o = array ( 'CODE_TYPE' => 'l', 'USERNAME' => 'FC98D77459DE51E6C199E3BF585A5B4F', 'charset' => 'utf', 'test' => 'false', ); $client_lnk = new MLClient($o); $links['mainlink'] = $client_lnk->build_links(); define('LINKFEED_USER', '5a34c7e998fb2d81c56a4133eb4e08ba052bcb83'); require_once($_SERVER['DOCUMENT_ROOT'].'/links/'.LINKFEED_USER.'/linkfeed.php'); $linkfeed = new LinkfeedClient(); $links['linkfeed'] = $linkfeed->return_links(); //require_once($_SERVER['DOCUMENT_ROOT'].'/links/setlinks_c30b3/slsimple.php'); ?> Справочник'; $content .= ''; $ar = $db->getAll('select * from s_stati_category order by category_name'); if (!empty($ar)) { array_filter($ar); foreach ($ar as $key => $massiv) { $content .= ''; } } $content .= '
'.$massiv['category_name'].'
'; break; case 'category': $ar = $db->getAll('select * from s_stati_category where category_alias=?s', $_GET['alias']); foreach($ar as $key => $massiv) { if ($massiv['category_alias'] == $_GET['alias']) { $title = $massiv['category_name']; $catid = $massiv['category_id']; $GLOBALS['breadcrumbs'][] = 'Статьи'; $breadcrumbs[] = $massiv['category_name']; $content .= '

'.$massiv['category_name'].'

'; if(strpos($massiv['category_description'], '
') === false) { $content .= shop::content_regex($massiv['category_description']); } else { $text = explode('
', $massiv['category_description']); $content .= $text[0]; } } } $content .= ''; $sql = $db->Query('select * from s_stati where category_id=?i order by title', $catid); while ($ar = $db->fetch($sql)) { $content .= ''; } $content .= '
'.$ar['title'].'
'; $content .= ((!empty($text[1])) ? $text[1] : '' ) ; break; case 'konservirovanie': $result = $db->query('SELECT * FROM s_stati_category ORDER BY parent_id, list_order, category_name'); while($massiv = $db->fetch($result)) { $catall[$massiv['category_id']] = $massiv; } $cat = $db->getRow('select * from s_stati_category where category_alias=?s', $_GET['alias']); $catid = $cat['category_id']; $title = $cat['category_name']; $GLOBALS['breadcrumbs'][] = 'Статьи'; if (!empty($cat['parent_id'])) { $parents = $cat['parent_id']; while ($parents <> 0) { $breadcrumbs_parents[] = ''.$catall[$parents]['category_name'].''; $parents = $catall[$parents]['parent_id']; } $breadcrumbs_parents = array_reverse($breadcrumbs_parents); $GLOBALS['breadcrumbs'] = array_merge($GLOBALS['breadcrumbs'], $breadcrumbs_parents); } $GLOBALS['breadcrumbs'][] = $cat['category_name']; $content = '

'.$cat['category_name'].'

'; $ar = $db->getAll('select * from s_stati_category where parent_id=?s', $cat['category_id']); if (!empty($ar)) { array_filter($ar); $content .= ''; foreach ($ar as $key => $massiv) { $content .= ''; } $content .= '
'.$massiv['category_name'].'
'; } $content .= '
'; $ar = $db->getAll('select * from s_stati_category where category_alias=?s', $_GET['alias']); foreach($ar as $key => $massiv) { if ($massiv['category_alias'] == $_GET['alias']) { if(strpos($massiv['category_description'], '
') === false) { $content .= (!empty($massiv['category_description'])) ? shop::content_regex($massiv['category_description']) : ''; } else { $text = explode('
', $massiv['category_description']); $content .= $text[0]; } } } $content .= ''; $sql = $db->Query('select * from s_stati where category_id=?i order by title_short', $catid); while ($ar = $db->fetch($sql)) { $content .= ''; } $content .= '
'.$ar['title'].'
'; $content .= ((!empty($text[1])) ? $text[1] : '' ) ; $content .= '
'; break; case 'view': $result = $db->query('SELECT * FROM s_stati_category ORDER BY parent_id, list_order, category_name'); while($massiv = $db->fetch($result)) { $catall[$massiv['category_id']] = $massiv; } $sql = $db->Query('select * from s_stati where alias=?s', $_GET['alias']); while ($ar = $db->fetch($sql)) { $breadcrumbs[] = 'Статьи'; $parents = $ar['category_id']; while ($parents <> 0) { $breadcrumbs_parents[] = ''.$catall[$parents]['category_name'].''; $parents = $catall[$parents]['parent_id']; } $breadcrumbs_parents = array_reverse($breadcrumbs_parents); $GLOBALS['breadcrumbs'] = array_merge($GLOBALS['breadcrumbs'], $breadcrumbs_parents); $title = $ar['title']; $breadcrumbs[] = Dir::cutStr($ar['title'], 150); //$ar['body'] = $dir->links_index($ar['body'], $links['sape']); $ar['body'] = shop::content_regex($ar['body']); $ar['body'] = $sape_context->replace_in_text_segment($ar['body']); $text = explode('
', $ar['body']); $content .= '

'.$ar['title'].'

'; //(!$ar['short_text']) ? $content .= $ar['full_text'] : $content .= $ar['short_text']; if (Dir::cntglob(ROOT.'/files/'.$_GET['mod'].'/'.$ar['id'].'/*.*') == 1) { $content .= $text[0]. ((!empty($text[1])) ? $text[1] : '' ) ; } elseif (Dir::cntglob(ROOT.'/files/'.$_GET['mod'].'/'.$ar['id'].'/*.*') == 0) { $content .= $text[0]. ((!empty($text[1])) ? $text[1] : '' ) ; } else { $content .= $text[0].'
'. ((!empty($text[1])) ? $text[1] : '' ) ; } $content .= '
'; } break; } //$content .= '
';
*/ ?>
'') { echo '
'.$l.'
'; } } ?> '/') { //$links['sape'] = $sape->return_links(); if (empty($GLOBALS['links_on'])) { if (strstr($links['sape'], 'href')!==FALSE) echo '
'.$links['sape'].'
'; } if (strstr($links['sape_article'], 'href')!==FALSE) echo '
'.$links['sape_article'].'
'; if (strstr($links['mainlink'], 'href')!==FALSE) echo '
'.$links['mainlink'].'
'; //if (strstr($links['linkfeed'], 'href')!==FALSE) //echo '
'.$links['linkfeed'].'
'; } else { if (empty($GLOBALS['links_on'])) { if (strstr($links['sape'], 'href')!==FALSE) echo '
'.$links['sape'].'
'; } if (strstr($links['sape_article'], 'href')!==FALSE) echo '
'.$links['sape_article'].'
'; if (strstr($links['mainlink'], 'href')!==FALSE) echo '
'.$links['mainlink'].'
'; //if (strstr($links['linkfeed'], 'href')!==FALSE) //echo '
'.$links['linkfeed'].'
'; }*/ ?>

Рецепты

GetAll('select * from s_stati where category_id=2 order by rand() limit 0,30'); $x = 0; $data = $db->GetAll('select * from s_stati as a, s_stati_category as b where a.category_id=b.category_id && b.parent_id<>0 order by id desc limit 0,30'); $x = 0; foreach ($data as $massiv) { $x++; if (($x == 1) || ($x == 16)) { echo '
'; } } ?>

'basket') { ?>
banka-mkad.ru +7 (925) 187-5888, +7 (926) 376-4777
Оформить заказ
Корзина: