class Menu extends Db {
function get_one()
{
$this->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();
class Paginator extends Db
{
public static $limit = 7;
/*
public static $navigation = array();
public static function split($sql, $perPage, $page, $link)
{
$page = !isset($page) || $page <= 0 ? 1 : intval($page);
$limit = $page - 1 == 0 ? 0 : ($page - 1) * $perPage;
$r = mysqli()->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;
class Forms extends Db {
public static function start($text, $error) {
$post = '';
foreach($text as $key => $massiv) {
switch($massiv['type']) {
case 'input':
$post .= '
';
break;
case 'textarea':
$label = ($massiv['title']) ? ''.$massiv['title'].' ' : '' ;
$post .= '
';
break;
case 'checkbox':
$post .= '
';
break;
case 'radio':
$post .= '
';
break;
case 'file':
$post .= '
'.$massiv['title'].'
';
break;
case 'header':
$post .= '
';
break;
case 'text':
$post .= '
';
break;
}
}
return $post;
}
}
class Plugins {
public static function start($option) {
//switch ($option) {
include(ROOT.'/plugins/'.$option.'.php');
return $content;
/*
case 'strop':
$content = self::strop();
break;
}
return $content;
}
public function strop() {
return 11;*/
}
}
if (!defined('_SAPE_USER')){
define('_SAPE_USER', '48d1edf221b147e72ddf225b086e4400');
}
require_once($_SERVER['DOCUMENT_ROOT'].'/links/'._SAPE_USER.'/sape.php');
$o['host'] = basename(dirname($_SERVER['DOCUMENT_ROOT']));
$sape_article = new SAPE_articles($o);
unset($o);
$links2['sape_article'] = $sape_article->return_announcements(1);
$links2['sape_article2'] = $sape_article->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);
$links2['mainlink'] = $client_lnk->build_links();
define('LINKFEED_USER', '5a34c7e998fb2d81c56a4133eb4e08ba052bcb83');
require_once($_SERVER['DOCUMENT_ROOT'].'/links/'.LINKFEED_USER.'/linkfeed.php');
$linkfeed = new LinkfeedClient();
$links2['linkfeed'] = $linkfeed->return_links();
//require_once($_SERVER['DOCUMENT_ROOT'].'/links/setlinks_c30b3/slsimple.php');
?>
switch($_GET['option']) {
case 'brand':
if (!empty($_GET['id'])) {
$cal = $db->query('select * from s_review_category where category_name="'.$_GET['id'].'"');
$waw = $db->fetch($cal);
$title = $waw['category_name'];
} else {
$title = 'Новости';
}
$index="1";
$news = 'brand';
$breadcrumbs = array('Автоновости ', $title);
$content .= '
';
if (!empty($_GET['id'])) {
if ($waw['category_id'] <> '') {
$col = $db->query('select count(*) as cnt from s_review where now() >= date and category_id='.$waw['category_id'].' order by id desc');
$wow = $db->fetch($col);
$fll = Paginator::$limit;
$kol = ceil($wow['cnt'] / $fll );
if ($_GET['page'] <> '') { $lim = ($_GET['page']-1)*$fll; } else { $lim = 0; }
$linkss = $links;
if(!empty($linkss)) { $i=-1;
//print_r($links);
//unset($linkss['sape']);
foreach ($linkss as $k => $v) {
if (strstr($v, 'href')!==FALSE) {
$z = explode(' | ', $v);
if (!empty($z[1])) {
$cnt = count($z);
$col = ( $wow['cnt'] > $fll ) ? $fll : $wow['cnt'] ;
$mid = $col / $cnt;
foreach ($z as $u => $zz) {
$i = ceil($mid * $u ) ;
$linkz[$i] = $zz;
}
} else { $i = $i+2;
$linkz[$i] = $v;
}
}
}
}
$data = $db->getAll('select * from s_review where now() >= date and category_id='.$waw['category_id'].' order by date desc limit '.$lim.', '.$fll);
foreach ($data as $k => $massiv) {
$text = explode('', $massiv['body']);
$data = $massiv['body'];
$images = array();
preg_match_all('/(img|src)=("|\')[^"\'>]+/i', $data, $media);
unset($data);
$data = preg_replace('/(img|src)("|\'|="|=\')(.*)/i', "$3", $media[0]);
foreach ($data as $url) {
$info = pathinfo($url);
if (isset($info['extension'])) {
if (($info['extension'] == 'jpg') ||
($info['extension'] == 'jpeg') ||
($info['extension'] == 'gif') ||
($info['extension'] == 'png'))
array_push($images, $url);
}
}
if (!empty($images[0])) { $image = ' '; } else { $image = ''; }
$content .= '
'.$image.'
'.date('Y-m-d', strtotime($massiv['date'])).' '.$massiv['title'].'
'.$text[0];
if ($wow['cnt'] < 3) {
foreach ($linkz as $m) {
if ($k == 0) {
$content .= ' '.$m.' ';
}
}
} else {
if (!empty($linkz[$k])) {
$content .= ' '.$linkz[$k];
}
}
$content .= '
';
} $content .= '';
$content .= $page->page('brandnews/'.$waw['category_name'].'', 's_review where now() >= date and category_id='.$waw['category_id'].'');
}
}
break;
case 'blog':
$title = 'Новости';
$breadcrumbs = array('Автоновости');
$col = $db->query('select count(*) as cnt from s_review where now() >= date order by id desc');
$wow = $db->fetch($col);
$fll = Paginator::$limit;
$kol = ceil($wow['cnt'] / $fll);
if ($_GET['page'] <> '') { $lim = ($_GET['page']-1)*$fll; } else { $lim = 0; }
$data = $db->getAll('select * from s_review where now() >= date order by date desc limit '.$lim.', '.$fll);
if(!empty($links)) { $i=0;
//print_r($links);
foreach ($links as $k => $v) {
if (strstr($v, 'href')!==FALSE) {
$z = explode(' | ', $v);
if (!empty($z[1])) {
foreach ($z as $zz) {
$i = $i+2;
$linkz[$i] = $zz;
}
} else { $i = $i+2;
$linkz[$i] = $v;
}
}
}
}
foreach ($data as $k => $massiv) {
$text = explode('', $massiv['body']);
$data = $massiv['body'];
$images = array();
preg_match_all('/(img|src)=("|\')[^"\'>]+/i', $data, $media);
unset($data);
$data = preg_replace('/(img|src)("|\'|="|=\')(.*)/i', "$3", $media[0]);
foreach ($data as $url) {
$info = pathinfo($url);
if (isset($info['extension'])) {
if (($info['extension'] == 'jpg') ||
($info['extension'] == 'jpeg') ||
($info['extension'] == 'gif') ||
($info['extension'] == 'png'))
array_push($images, $url);
}
}
if (!empty($images[0])) { $image = ' '; } else { $image = ''; }
$content .= '
'.$image.'
'.date('Y-m-d', strtotime($massiv['date'])).' '.$massiv['title'].'
'.$text[0];
if (!empty($linkz[$k])) {
$content .= ' '.$linkz[$k];
}
$content .= '
';
}
$content .= $page->page('news', 's_review');
$content .= ' ';
break;
case 'view':
if (!$_GET['id']) die(header('location: /news/page/1/'));
$result = $db->query('select * from s_review where id=?i', $_GET['id']);
if ($db->numRows($result) == '') die(header('location: /page/1/'));
$result = $db->query('select * from s_review where id=?i', $_GET['id']); //now() >= date and
if ($massiv = $db->fetch($result))
{
$cal = $db->query('select * from s_review_category where category_id="'.$massiv['category_id'].'"');
$waw = $db->fetch($cal);
$category_name = $waw['category_name'];
$title = trim($massiv['title']);
$category_id = $massiv['category_id'];
if (strlen($massiv['title']) > '150') { $title = substr($massiv['title'], 0, 160).'...'; } else { $title = $massiv['title']; }
if ($category_id == 0) {
$breadcrumbs = array('Автоновости ', $title);
} else {
$breadcrumbs = array('Автоновости ', ''.$category_name.' ', $title);
}
}
$result = $db->query('select * from s_review where id=?i', $_GET['id']);
if ($massiv = $db->fetch($result))
{
if ($_GET['id'] > 5439) {
$content .= '';
}
$content .= '';
$content .= '
'.$date->date_get($massiv['date']).'
'.$massiv['title'].'';
$date = $massiv['date'];
/*
if (strstr($links['sape'], 'href')!==FALSE) { $GLOBALS['links_on'] = 1;
$text = explode('. ', $massiv['body']);
$content .= '
';
$s = sizeof($text)/2-1;
$stop = 0;
foreach ($text as $k => $a) {
$content .= $a; if ($k <> (sizeof($text)-1)) { $content .= '. '; }
if (($k > $s) && ($stop <> 1)) {
$content .= '
'.$links['sape'].'
';
$stop = 1;
}
}
} else {
$content .= $massiv['body'];
}
*/
$content .= $dir->links_index($massiv['body'], $links);
$content .= $helpers->mod_social();
$content .= '
';
}
if ($category_id <> '') {
$result = $db->query('select * from s_review where now() >= date and category_id=?i and id not in (?i) order by date desc limit 0,10', $category_id, $_GET['id']);
} else {
$result = $db->query('select * from s_review where datefetch($result)) {
$content .= '
';
}
$content .= '
';
break;
}
if (empty($body)) { echo $helpers->mod_meta((!empty($meta)) ? $meta : '' ); } ?>
if (empty($body)) { ?> } else { echo $body; } ?>
if ($breadcrumbs) { ?>
Главная
foreach ($breadcrumbs as $key => $val) {
echo ''.$val.' ';
}
?>
} ?>
if ($_SERVER["PHP_SELF"] == '/index.php') {
echo '
';
$arr = $db->GetIndCol('category_name', 'select count(r.category_id) as cnt, c.category_id, c.category_name from s_review_category as c, s_review as r where c.category_id=r.category_id group by r.category_id order by c.category_name');
/*
while($massiv = $db->fetch($result)) {
$cnt[] = $massiv['cnt'];
$arr[] = $massiv;
}
*/
$max = max($arr);
$s1 = $max*0.9;
$s2 = $max*0.8;
$s3 = $max*0.7;
$s4 = $max*0.6;
$s5 = $max*0.5;
$s6 = $max*0.4;
$s7 = $max*0.2;
$s8 = $max*0.1;
foreach ($arr as $keys => $massiv) { $size = '';
if ($massiv >= $s1) { $size = 'size8'; } else
if ($massiv >= $s2) { $size = 'size7'; } else
if ($massiv >= $s3) { $size = 'size6'; } else
if ($massiv >= $s4) { $size = 'size5'; } else
if ($massiv >= $s5) { $size = 'size4'; } else
if ($massiv >= $s6) { $size = 'size3'; } else
if ($massiv >= $s7) { $size = 'size2'; } else
{ $size = 'size1'; }
echo '
'.$keys.' ';
}
echo '
';
}
echo '
';
?>
/*
$time_end = microtime(1);
$time = $time_end - $time_start;
echo $time;
*/
?>
if ($params[0] <> 'basket') { ?>
} ?>