View file ä󿪫¬/modules/love/search_p.php

<?php
foreach (array('start', 'compress', 'sess', 'settings', 'db_connect', 'ipua', 'fnc', 'user') as $inc) {
    require_once "../../sys/inc/$inc.php";
}

$doc->Title('Поиск людей');
require_once H . 'sys/inc/thead.php';


#Навигация
echo "<div class='card-header'>";
echo "<a href='/' data-toggle='tooltip' data-placement='right' title='" . lang('На главную') . "'><i class='fa fa-home fa-lg'></i></a> <i class='fa fa-angle-right fa-fw'></i> ";
echo "<a href='/modules/love/'>" . lang('Знакомства') . "</a> <i class='fa fa-angle-right fa-fw'></i> поиск по параметрам";
echo "</div>";


if (isset($user) && $pdo->query(("SELECT COUNT(*) FROM `znakomstva` WHERE `id_user` = '$user[id]'"), 0)->fetchColumn()==0)
{
$pdo->query("INSERT INTO `znakomstva` (`id_user`) values('". intval($user['id']) ."')");
header("Location: ?");
}

$zn = $pdo->query("SELECT * FROM `znakomstva` WHERE `id_user` = '$user[id]' LIMIT 1")->fetch(PDO::FETCH_ASSOC);


if (isset($_POST['ok']))
{
if (isset($_POST['v_ot']) && is_numeric($_POST['v_ot']) && $_POST['v_ot']!=0 && $_POST['v_ot']!=NULL && $_POST['v_ot']<$_POST['v_do'] && $_POST['v_ot']!=$_POST['v_do'])
{
$v_ot=intval($_POST['v_ot']);
}else{
$err='Ошибка в поле "Возраст (От)"';
}
if (isset($_POST['v_do']) && is_numeric($_POST['v_do']) && $_POST['v_do']!=0 && $_POST['v_do']!=NULL && $_POST['v_do']>$_POST['v_ot'] && $_POST['v_do']!=$_POST['v_ot'])
{
$v_do=intval($_POST['v_do']);
}else{
$err='Ошибка в поле "Возраст (До)"';
}
if (!isset($err))
{
$pdo->query("UPDATE `znakomstva` SET `pol` = '".intval($_POST['pol'])."' WHERE `id_user` = '".$user['id']."' LIMIT 1");
$pdo->query("UPDATE `znakomstva` SET `on` = '".intval($_POST['on'])."' WHERE `id_user` = '".$user['id']."' LIMIT 1");
$pdo->query("UPDATE `znakomstva` SET `v_ot` = '".intval($_POST['v_ot'])."' WHERE `id_user` = '".$user['id']."' LIMIT 1");
$pdo->query("UPDATE `znakomstva` SET `v_do` = '".intval($_POST['v_do'])."' WHERE `id_user` = '".$user['id']."' LIMIT 1");
$pdo->query("UPDATE `znakomstva` SET `zn_cel` = '".intval($_POST['zn_cel'])."' WHERE `id_user` = '".$user['id']."' LIMIT 1");
$pdo->query("UPDATE `znakomstva` SET `country` = '".htmlspecialchars($_POST['country'])."' WHERE `id_user` = '".$user['id']."' LIMIT 1");
$pdo->query("UPDATE `znakomstva` SET `city` = '".htmlspecialchars($_POST['city'])."' WHERE `id_user` = '".$user['id']."' LIMIT 1");
header('Location: search_p.php?search');
}
}
err();


if (isset($_GET['search']))
{
$znak_ot=date("Y")-$zn['v_ot'];
$znak_do=date("Y")-$zn['v_do'];
if ($zn['pol']==0)
{
$pol="";
}
else if ($zn['pol']==1)
{
$pol="`sex` = '1' AND ";
}
else if ($zn['pol']==2)
{
$pol="`sex` = '2' AND ";
}


if ($zn['city']==null)
{
$city="";
}else{
$city="`city` = '".text($zn['city'])."' AND ";
}

if ($zn['country']==null)
{
$country="";
}else{
$country="`country` = '".text($zn['country'])."' AND ";
}

if ($zn['on']==0)
{
$on="";
}elseif ($zn['on']==1)
{
$on="`date_last` > '" . (time() - 1500) . "' AND ";
}

if ($zn['zn_cel']==0)
{
$cel="";
}
else if ($zn['zn_cel']==1)
{
$cel="`ank_goal_dating` = '1' AND ";
}
else if ($zn['zn_cel']==2)
{
$cel="`ank_goal_dating2` = '1' AND ";
}
else if ($zn['zn_cel']==3)
{
$cel="`ank_goal_dating3` = '1' AND ";
}
else if ($zn['zn_cel']==4)
{
$cel="`ank_goal_dating4` = '1' AND ";
}
else if ($zn['zn_cel']==5)
{
$cel="`ank_goal_dating7` = '1' AND ";
}
else if ($zn['zn_cel']==6)
{
$cel="`ank_goal_dating8` = '1' AND ";
}

$other="".$pol."".$cel."".$city."".$country."".$on."";







echo "<div class='fon-list'>";
$k_post=$pdo->query(("SELECT COUNT(*) FROM `user` WHERE $other `ank_g_r` > '0' AND `ank_g_r` < '".$znak_ot."' AND `ank_g_r` > '".$znak_do."' AND `ban_navsegda` = '0'"), 0)->fetchColumn();
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];

echo "<div class='list-group-item-komm' style='$padding_menu'>";
echo "<b>Найдено:</b> $k_post чел.";
echo "</div>";

if ($k_post==0)
{
echo "<div class='list-group-item-komm' style='$padding_menu'>";
echo "Нет результатов";
echo "</div>";
}

$q=$pdo->query("SELECT `id` FROM `user` WHERE $other`ank_g_r` > '0' AND `ank_g_r` < '".$znak_ot."' AND `ank_g_r` > '".$znak_do."' AND `ban_navsegda` = '0' ORDER BY `id` DESC LIMIT $start, $set[p_str]");
while ($post=$q->fetch(PDO::FETCH_ASSOC))
{
$ank7 = $pdo->query("SELECT * FROM `user` WHERE `id` = '". intval($post['id']) ."' LIMIT 1")->fetch(PDO::FETCH_ASSOC);

echo "<div class='list-group-item-komm'><table style='width: 100%;'><tr>";

if ($user['mobile_themes']==1){
echo "<td class='avatar_mail'>";
echo "<a href='/info.php?id=$ank7[id]'>";
avatar_mail($ank7['id']);
echo "</a>";
if ($ank7['date_last'] > (TIME - 1500)) {echo "<small><font color=green><b>Online</b></font></small>";}else{  
echo "<small><font color=gray>" . date::timek($ank7['date_last']) . "</font></small>"; }             
echo "</td>";
}

echo "<td class='null'>";
echo user($ank7['id']);            
echo "<br><br>";
 if ($ank7['ank_surname'] == NULL) {
echo "";
} else {
echo " <font color=#54585E><b>$ank7[ank_surname]</b></font> ";
}

        if ($ank7['ank_name'] == NULL) {
        } else {
            echo " <font color=#54585E><b>$ank7[ank_name]</b></font> <br>";
        }            
           
if ($ank7['ank_g_r'] == NULL) {

        } else {
            $ank7['ank_age'] = date("Y") - $ank7['ank_g_r'];
            if (date("n") < $ank7['ank_m_r']) {
                $ank7['ank_age'] = $ank7['ank_age'] - 1;
            } elseif (date("n") == $ank7['ank_m_r'] && date("j") < $ank7['ank_d_r']) {
                $ank7['ank_age'] = $ank7['ank_age'] - 1;
            }
            
            
   if ($ank7['ank_d_r']>=19 && $ank7['ank_m_r']==1){echo "<img src='/style/zadiak/11.gif' alt=''>";}
elseif ($ank7['ank_d_r']<=19 && $ank7['ank_m_r']==2){echo "<img src='/style/zadiak/11.gif' alt=''>";}
elseif ($ank7['ank_d_r']>=18 && $ank7['ank_m_r']==2){echo "<img src='/style/zadiak/12.gif' alt=''>";}
elseif ($ank7['ank_d_r']<=21 && $ank7['ank_m_r']==3){echo "<img src='/style/zadiak/12.gif' alt=''>";}
elseif ($ank7['ank_d_r']>=20 && $ank7['ank_m_r']==3){echo "<img src='/style/zadiak/1.gif' alt=''>";}
elseif ($ank7['ank_d_r']<=21 && $ank7['ank_m_r']==4){echo "<img src='/style/zadiak/1.gif' alt=''>";}
elseif ($ank7['ank_d_r']>=20 && $ank7['ank_m_r']==4){echo "<img src='/style/zadiak/2.gif' alt=''>";}
elseif ($ank7['ank_d_r']<=21 && $ank7['ank_m_r']==5){echo "<img src='/style/zadiak/2.gif' alt=''>";}
elseif ($ank7['ank_d_r']>=20 && $ank7['ank_m_r']==5){echo "<img src='/style/zadiak/3.gif' alt=''>";}
elseif ($ank7['ank_d_r']<=22 && $ank7['ank_m_r']==6){echo "<img src='/style/zadiak/3.gif' alt=''>";}
elseif ($ank7['ank_d_r']>=21 && $ank7['ank_m_r']==6){echo "<img src='/style/zadiak/4.gif' alt=''>";}
elseif ($ank7['ank_d_r']<=22 && $ank7['ank_m_r']==7){echo "<img src='/style/zadiak/4.gif' alt=''>";}
elseif ($ank7['ank_d_r']>=23 && $ank7['ank_m_r']==7){echo "<img src='/style/zadiak/5.gif' alt=''>";}
elseif ($ank7['ank_d_r']<=22 && $ank7['ank_m_r']==8){echo "<img src='/style/zadiak/5.gif' alt=''>";}
elseif ($ank7['ank_d_r']>=22 && $ank7['ank_m_r']==8){echo "<img src='/style/zadiak/6.gif' alt=''>";}
elseif ($ank7['ank_d_r']<=23 && $ank7['ank_m_r']==9){echo "<img src='/style/zadiak/6.gif' alt=''>";}
elseif ($ank7['ank_d_r']>=22 && $ank7['ank_m_r']==9){echo "<img src='/style/zadiak/7.gif' alt=''>";}
elseif ($ank7['ank_d_r']<=23 && $ank7['ank_m_r']==10){echo "<img src='/style/zadiak/7.gif' alt=''>";}
elseif ($ank7['ank_d_r']>=22 && $ank7['ank_m_r']==10){echo "<img src='/style/zadiak/8.gif' alt=''>";}
elseif ($ank7['ank_d_r']<=22 && $ank7['ank_m_r']==11){echo "<img src='/style/zadiak/8.gif' alt=''>";}
elseif ($ank7['ank_d_r']>=21 && $ank7['ank_m_r']==11){echo "<img src='/style/zadiak/9.gif' alt=''>";}
elseif ($ank7['ank_d_r']<=22 && $ank7['ank_m_r']==12){echo "<img src='/style/zadiak/9.gif' alt=''>";}
elseif ($ank7['ank_d_r']>=21 && $ank7['ank_m_r']==12){echo "<img src='/style/zadiak/10.gif' alt=''>";}
elseif ($ank7['ank_d_r']<=20 && $ank7['ank_m_r']==1){echo "<img src='/style/zadiak/10.gif' alt=''>";}
         
 echo " <font color=gray>" . sklon_text($ank7['ank_age'], array('год', 'года', 'лет')) . "</font> ";     
} 
echo " <br>";
 $flag=$pdo->query(("SELECT id FROM `country` WHERE `name` = '".$ank7['country']." ' LIMIT 1"))->fetch(PDO::FETCH_BOTH);


echo " <a href='/user/search.php?search=".toOutput($ank7['city'])."'><u>".($ank7['city']!=NULL ? text($ank7['city']) : '')."</u></a>";
echo "".($ank7['country']!=NULL? ', ':NULL)." ";
echo " <a href='/user/search.php?search=".toOutput($ank7['country'])."'><u>".($ank7['country']!=NULL? text($ank7['country']): '')."</u></a>";

if ($ank7['country'] > null){
echo " <img src='/style/country/".$flag['id'].".png' alt='*'>";   
}
echo "</td></tr></table>";




    
    
if ($ank7['welcome'] != NULL) {
echo "<div class='user__status user__status-message'>";
echo output_text($ank7['welcome']);
echo "</div>";
}



 

echo "<table style='width: 100%; text-align: center; margin-top: 10px;'><tr>";

if (IS_WEB == 0  && $user['mobile_themes']==1){
$br = '<br>';    
}else{
$br = null;    
}

if (isset($user) && $user['id'] != $ank7['id']) {
if (isset($user) && $pdo->query(("SELECT COUNT(*) FROM `friendsi` WHERE `user` = '$user[id]' AND `friendsi` = '$ank7[id]'"), 0)->fetchColumn() == 0) {
echo '<td class="fn-left2"><a style="display: inline-block; '.$padding_menu.'" href="/user/friends/add.php?id='.$ank7['id'].'"><font color=#6C91AF><i class="fa fa-user fa-fw"></i>'.$br.' <b>ДРУЖБА</b></font></a></td> ';
}else{
echo '<td class="fn-left2"><a style="display: inline-block; '.$padding_menu.'" href="/user/friends/"><font color=green><i class="fa fa-check fa-fw"></i>'.$br.' <b>ДРУЖБА</b></font></a></td> ';
}

if (isset($user) && $user['id'] != $ank7['id']) {
echo "<td class='fn-center2'><a style='display: inline-block; $padding_menu' href='/user/mail/messageList.php?contact=$ank7[id]'><font color=#6C91AF><i class='fa fa-envelope fa-fw'></i>$br <b>НАПИСАТЬ</b></font></a></td> ";
}


if (isset($user) && $pdo->query(("SELECT COUNT(*) FROM `friends` WHERE `user` = '$user[id]' AND `friends` = '$ank7[id]'"), 0)->fetchColumn() == 0) {
echo '<td class="fn-right2"><a style="display: inline-block; '.$padding_menu.'" href="/user/readers/add.php?id='.$ank7['id'].'"><font color=#6C91AF><i class="fa fa-feed fa-fw"></i>'.$br.' <b>ПОДПИСКА</b></font></a></td> ';
 } else {
echo '<td class="fn-right2"><a style="display: inline-block; '.$padding_menu.'" href="/user/readers/"><font color=green><i class="fa fa-check fa-fw"></i>'.$br.' <b>ПОДПИСКА</b></font></a></td> ';
}




}else{
echo "<span style='float:right;color: grey;'>" . lang('Это Вы') . "</span>";
}



echo "</tr></table></div>";
}    
echo "</div>";












if ($k_page>1)
{
str("search_p.php?search&amp;",$k_page,$page);
}


echo "<div class='fon-list2'>";

echo "<a href='search_p.php'><div class='list-group-item-komm' style='$padding_menu'>";
echo "<i class='fa fa-search fa-fw'></i> Новый поиск";
echo "</div></a>";

echo "<a href='index.php'><div class='list-group-item-komm' style='$padding_menu'>";
echo "<i class='fa fa-arrow-left fa-fw'></i> Назад в знакомства";
echo "</div></a>";

echo "<br></div>";

include_once '../../sys/inc/tfoot.php';
exit;



}





















echo "<div class='fon-list'>";
echo "<div class='list-group-item-komm'>";

echo "<form method='post' action='?".$passgen."'>";

echo "<b>Пол:</b> ";
echo "<select name='pol' class='form-control' style='width: 30%;'>";
echo "<option value='0' ".($zn['pol']==0?" selected='selected'":null).">Любой</option><br />";
echo "<option value='1' ".($zn['pol']==1?" selected='selected'":null).">Мужской</option><br />";
echo "<option value='2' ".($zn['pol']==2?" selected='selected'":null).">Женский</option><br />";
echo "</select><br />";


echo "<b>Возраст:</b><br> ";
echo "От <input type='text' value='".$zn['v_ot']."' placeholder='0' class='form-control' style='width: 20%;' name='v_ot' size='2' maxlength='2' /> ";
echo "До <input type='text' value='".$zn['v_do']."' placeholder='100' class='form-control' style='width: 20%;' name='v_do' size='2' maxlength='2' /><br />";

echo "<b>Страна:</b><br> ";
echo "<input value='".text($zn['country'])."' type='text' placeholder='Любая' class='form-control' style='width: 50%;' name='country' size='80' maxlength='80' /><br />";


echo "<b>Город:</b><br> ";
echo "<input value='".text($zn['city'])."' type='text'placeholder='Любой' class='form-control' style='width: 50%;' name='city' size='80' maxlength='80' /><br />";


echo "<b>Цель знакомства:</b> <br>";
echo "<select name='zn_cel' class='form-control' style='width: 50%;'>";
echo "<option value='0' ".($zn['zn_cel']==0?" selected='selected'":null).">Любая</option><br />";
echo "<option value='1' ".($zn['zn_cel']==1?" selected='selected'":null).">Дружба и общение</option><br />";
echo "<option value='2' ".($zn['zn_cel']==2?" selected='selected'":null).">Флирт, СМС-переписка</option><br />";
echo "<option value='3' ".($zn['zn_cel']==3?" selected='selected'":null).">Любовь, отношения</option><br />";
echo "<option value='4' ".($zn['zn_cel']==4?" selected='selected'":null).">Брак, создание семьи</option><br />";
echo "<option value='5' ".($zn['zn_cel']==5?" selected='selected'":null).">Ищу спонсора</option><br />";
echo "<option value='6' ".($zn['zn_cel']==6?" selected='selected'":null).">Стану спонсором</option><br />";
echo "</select><br />";

echo "<b>Показать:</b> <br>";
echo "<input name='on' type='radio' ".($zn['on']==0?' checked="checked"':null)." value='0' /> Всех <br>";
echo "<input name='on' type='radio' ".($zn['on']==1?' checked="checked"':null)." value='1' /> Сейчас на сайте <br><br>";


echo "<input name='ok' class='knopka' type='submit' value='Искать' />";
echo "</form>";
echo "</div>";
echo "</div>";

echo "<div class='fon-list2'>";
echo "<a href='index.php'><div class='list-group-item-komm' style='$padding_menu'>";
echo "<i class='fa fa-arrow-left fa-fw'></i> Назад в знакомства";
echo "</div></a><br></div>";
require_once H . 'sys/inc/tfoot.php';
?>