Файл: wapxl.ru/search.php
Строк: 195
<?php
require 'shaxty.php';
require_once 'shaxty/simple_html_dom.php';
$align = 'left';
$title = 'Белый каталог лучших мобильных wap сайтов';
include_once ('shaxty/head.php');
if (isset($_REQUEST['search']))$search=func::checkin($_REQUEST['search']);
else if (isset($_SESSION['search']))$search=func::checkin($_SESSION['search']);
$_SESSION['search']=$search;
$search = preg_replace("/[^wx7F-xFFs]/", " ", $search);
$search= func::checkin(func::rus_utf_tolower($search));
//if ($search!=NULL)
//{
if (!empty($search)) {
$count_ssearch = core:: $db -> querySingle("SELECT count(*) FROM `search` WHERE `search` = '".$search."';");
if($count_ssearch==0){
$dbi = core::$db -> prepare("INSERT INTO `search` SET `search`=?");
$dbi -> execute($search);
}else{
$dbi = core::$db -> prepare("UPDATE `search` SET `kolvo`=`kolvo`+1 WHERE `search`=? LIMIT 1");
$dbi -> execute($search);
}
$searchs = str_replace(" ", "%", $search);
$sql = 'and `url` LIKE "%'.$searchs.'%" or `name` LIKE "%'.$searchs.'%" or `key` LIKE "%'.$searchs.'%" or `abaut` LIKE "%'.$searchs.'%" or `keywords` LIKE "%'.$searchs.'%" or `description` LIKE "%'.$searchs.'%"';
// получаем кол во участников
$count_sites = core:: $db -> querySingle("SELECT count(*) FROM `sites` WHERE `time_add` != '0' ".$sql.";");
// Если не нашлось ничего у нас, ищем в яндексе, нельзя терять потенциальных посетителей
if($count_sites==0){
echo '<div class="col-md-8 col-sm-12 col-xs-12"><div class="panel panel-default">';
echo '<div class="panel-heading"> <b>По вашему запросу нашлось:</b></div>
<div class="panel-body">';
$i=0;
$data = file_get_html('https://yandex.com/search/xml?user=shaxty&key=03.100334990:d51a18138958b2185f5ee6ceb48c0cb6&l10n=en&filter=none&query='.urlencode($search).'&groupby=attr%3Dd.mode%3Ddeep.groups-on-page%3D10.docs-in-group%3D3&page=1');
$rekl = 0;
if($data->innertext!='' and count($data->find('url'))){
foreach($data->find('url') as $a){
$t = $data->find("title", $i); // title из яндекса
//echo $t->plaintext.'<br />';
$e = $data->find("passages", $i); // описание из яндекса
//echo $e->plaintext.'<br />';
$d = $data->find("domain", $i); // описание из яндекса
//echo $d->plaintext.'<br />';
if(is_integer($i / 6) and $rekl==0){
$rekl++;
echo '<div class="hidden-sm hidden-xs" style="margin-left: 15px;margin-right: 15px;">
<script type="text/javascript">
var begun_auto_pad = 430694658;
var begun_block_id = 432061316;
</script>
<script src="http://autocontext.begun.ru/autocontext2.js" type="text/javascript"></script>
</div>';
echo '<div class="hidden-lg hidden-md">
<script type="text/javascript">
var begun_auto_pad = 430694658;
var begun_block_id = 433223064;
</script>
<script src="http://autocontext.begun.ru/autocontext2.js" type="text/javascript"></script>
</div>';
}
echo '
<div class="panel panel-default">';
echo '
<div class="panel-body"><table> <tbody><tr><td style = "width: 98%;"> <p> <b><a href="'.$a->plaintext.'"> ' . (isset($t->plaintext) && $t->plaintext!='нет' ? '<b>'.$t->plaintext.'</b>' : '<b>'.$d->plaintext.'</b>') . '</a></b> </p>http://'.$d->plaintext.' ' . (isset($e->plaintext) && $e->plaintext!='нет' ? '<br/><i class="fa fa-comment-o" style = "color:#8C8C8C;"></i> '.$e->plaintext.'' : '') . '
</td>
<td style = "width: 5px;">';
echo '</td> </tr> </tbody> </table></div>
</div>
';
$i++;
}
}
}else{
$k_page=func::k_page($count_sites,$max);
$page=func::page($k_page);
$start=$max*$page-$max;
$sort = func::checkin($_REQUEST['sort']);
if(empty($sort)) $sort = 'reit_desc';
if($sort=='reit_desc')$sorts = 'ORDER BY `prosmotr` DESC, `vote` DESC';
else if($sort=='reit_asc')$sorts = 'ORDER BY `prosmotr` ASC, `vote` ASC';
else if($sort=='news_desc')$sorts = 'ORDER BY `time_add` DESC';
else if($sort=='news_asc')$sorts = 'ORDER BY `time_add` ASC';
else if($sort=='rand')$sorts = 'ORDER BY RAND()';
echo '<div class="col-md-8 col-sm-12 col-xs-12"><div class="panel panel-default">';
echo '<div class="panel-heading"> По вашему запросу нашлось <b>'.$count_sites.' сайтов</b>
';
echo ' <div class="btn-group" style="float:right;top: -5px;"> ';
echo ' <button type="button" class="btn btn-primary btn-sm dropdown-toggle" data-toggle="dropdown"> ';
if($sort=='reit_desc')echo ' <b>Популярные</b> <i class="fa fa-caret-down"></i> ';
else if($sort=='reit_asc')echo ' <b>Популярные</b> <i class="fa fa-caret-up"></i> ';
else if($sort=='news_desc')echo ' <b>Новые</b> <i class="fa fa-caret-down"></i>';
else if($sort=='news_asc')echo ' <b>Новые</b> <i class="fa fa-caret-up"></i>';
else if($sort=='rand')echo ' <b>Случайные</b> <i class="fa fa-random">';
echo ' </i></button> ';
echo ' <ul class="dropdown-menu" role="menu"> ';
echo ' <li><a href="?sort=reit_desc">Популярные <i class="fa fa-caret-down"></i></a></li> ';
echo ' <li><a href="?sort=reit_asc">Популярные <i class="fa fa-caret-up"></i></a></li> ';
echo ' <li class="divider"></li>';
echo ' <li><a href="?sort=news_desc">Новые <i class="fa fa-caret-down"></i></a></li>';
echo ' <li><a href="?sort=news_asc">Новые <i class="fa fa-caret-up"></i></a></li>';
echo ' <li class="divider"></li>';
echo ' <li><a href="?sort=rand">Случайные <i class="fa fa-random"></i></a>';
echo ' </li>';
echo ' </ul>';
echo ' </div>';
echo '
</div>
<div class="panel-body">';
$r = core:: $db -> query("SELECT * FROM `sites` WHERE `time_add` != '0' ".$sql." group by `url` ".$sorts." LIMIT $start,$max;");
$top_place = $start;
$rekl = 0;
while ($row= $r -> fetch()) {
// Определение места в каталоге
$top_place++;
if(is_integer($top_place / 6) and $rekl==0){
$rekl++;
echo '<div class="hidden-sm hidden-xs" style="margin-left: 15px;margin-right: 15px;">
<script type="text/javascript">
var begun_auto_pad = 430694658;
var begun_block_id = 432061316;
</script>
<script src="http://autocontext.begun.ru/autocontext2.js" type="text/javascript"></script>
</div>';
echo '<div class="hidden-lg hidden-md">
<script type="text/javascript">
var begun_auto_pad = 430694658;
var begun_block_id = 433223064;
</script>
<script src="http://autocontext.begun.ru/autocontext2.js" type="text/javascript"></script>
</div>';
}
echo '
<div class="panel panel-default">';
if ($row['web']==1)$web = '<i class="fa fa-laptop" style = "color:#8C8C8C;font-size: 18px;"></i>';
else if ($row['web']==0)$web = '<i class="fa fa-mobile" style = "color:#8C8C8C;font-size: 18px;"></i>';
else $web = '';
echo '
<div class="panel-body"><table> <tbody><tr><td style = "width: 98%;"> <p> <b><a href="/cat/'.$row['url'].'"> '.$web.' ' . (isset($row['name']) && $row['name']!='нет' ? '<b>'.$row['name'].'</b>' : '<b>'.$row['url'].'</b>') . '</a></b> </p>http://'.$row['url'].' ' . (isset($row['abaut']) && $row['abaut']!='нет' ? '<br/><i class="fa fa-comment-o" style = "color:#8C8C8C;"></i> '.$row['abaut'].'' : '') . '
</td>
<td style = "width: 5px;">';
$hears = explode("|",$_COOKIE['heartsites']);
if(in_array($row['id'] ,$hears) === false)
{
?><span id="post-ratings-<? echo $row['id']; ?>" class="post-ratings" data-nonce="1fa42eff78"><i class="fa fa-heart-o" id="rating_<? echo $row['id']; ?>_1" title="Добавить в избранное" onmouseover="current_rating(<? echo $row['id']; ?>, 1, 'Добавить в избранное');" onmouseout="ratings_off(3.6, 4, 0);" onclick="rate_post();" onkeypress="rate_post();" style="cursor: pointer; border: 0px;" ></i></span><?
}else{
?><span id="post-ratings-<? echo $row['id']; ?>" class="post-ratings" data-nonce="1fa42eff78"><i style="color:#FF0000" class="fa fa-heart" id="rating_<? echo $row['id']; ?>_2" title="Добавить в избранное" onmouseover="current_rating(<? echo $row['id']; ?>, 2, 'Добавить в избранное');" onmouseout="ratings_off(3.6, 4, 0);" onclick="rate_post();" onkeypress="rate_post();" style="cursor: pointer; border: 0px;" ></i></span><?
}
echo '</td> </tr> </tbody> </table></div>
<div class="panel-footer">
<i class="glyphicon glyphicon-calendar" style = "color:#8C8C8C;"></i> '.func::times($row['time_add']).' | <i class="glyphicon glyphicon-eye-open" style = "color:#8C8C8C;"></i> '.$row['prosmotr'].' | <i class="fa fa-google" style = "color:#8C8C8C;"></i> PR:'.$row['google_pr'].' | <i class="fa fa-yahoo" style = "color:#8C8C8C;"></i> ТИЦ:'.$row['yandex_cy'].'
</div></div>
';
}
if($sort!='reit_desc'){
if ($k_page>1)func::pagination('?sort='.$sort.'&',$k_page,$page); // Вывод страниц
}else{
if ($k_page>1)func::pagination('?',$k_page,$page); // Вывод страниц
}
}
}else header('Location: /index.php');
echo '</div></div>';
include_once ('shaxty/foot.php');
?>