<?
include_once '../../sys/inc/start.php';
include_once '../../sys/inc/compress.php';
include_once '../../sys/inc/sess.php';
include_once '../../sys/inc/home.php';
include_once '../../sys/inc/settings.php';
include_once '../../sys/inc/db_connect.php';
include_once '../../sys/inc/ipua.php';
include_once '../../sys/inc/fnc.php';
include_once '../../sys/inc/user.php';

$set['title']='Поиск мошенника'; // заголовок страницы
include_once '../../sys/inc/thead.php';
title();
aut();


echo "<div class=\"post\">\nВведите WMID, ICQ или НИК мошенника</div>\n";
echo "<form method=\"post\" action=\"search.php\">";
echo "<input type=\"text\" name=\"usearch\" maxlength=\"16\" value=\"\" />\n";

echo '<select size="1" name="where">
    <option value="nick" selected>Ник</option>
    <option value="icq">ICQ</option>
    <option value="wmid">WMID</option>
   </select>';

echo "<input type=\"submit\" value=\"Найти\" />";
echo "</form>\n";


if (isset($_POST['where']))
$where=mysql_escape_string($_POST['where']);
else
$where=NULL;

if (isset($_POST['usearch']))
$usearch=mysql_escape_string($_POST['usearch']);
else
$usearch=NULL;

if (isset($_POST['where']) && isset($_POST['usearch']))
{

//---------------записи-----------------------//


$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `swindlers`  WHERE `".$where."` like '%".$usearch."%'"),0);



$q=mysql_query("SELECT * FROM `swindlers` WHERE `".$where."` like '%".$usearch."%' ORDER BY `id`");

echo "<table class='post'>\n";
if ($k_post==0)
{
echo "   <tr>\n";
echo "  <td class='p_t'>\n";
echo "Не найдено\n";
echo "  </td>\n";
echo "   </tr>\n";
}
while ($post = mysql_fetch_assoc($q))
{
echo "   <tr>\n";
echo "  <td class='p_t'>\n";

echo "Мошенник - <b>" . output_text($post['nick']) . "</b> <br />\n";
echo "Обвинитель - <b>" . output_text($post['nick_looser']) . "</b> <br />\n";
echo "Дата добавления - (" . vremja($post['time']) . ")<br />";
echo "&rarr; <a href='list.php?id=$post[id]'>Подробнее..</a> \n";
$k_n= mysql_result(mysql_query("SELECT COUNT(*) FROM `swindlers` WHERE `id` = $post[id] AND `time` > '".(time()-86400)."'",$db), 0);
if ($k_n!=0)echo " <font color='green'>[new]</font>";
echo "  </td>\n";
echo "   </tr>\n";
}
echo "</table>\n";


}





if (isset($user)){
echo "<div class='foot'>\n";
echo "&raquo;<a href='add.php'>Добавить мошенника</a><br />\n";
echo "</div>\n";
}
echo "<div class='foot'>\n";
echo "&laquo;<a href='index.php'>Категории</a><br />\n";
echo "</div>\n";
include_once '../../sys/inc/tfoot.php';

//---------------------------------------------//

?>