Файл: vsime.com/search/inc/act_index.php
Строк: 334
<?
ex_head();
if (isset($_POST['submited']) || isset($_GET['query'])) {
$query = NULL;
if (isset($_GET['query']))$query = esc(stripcslashes(hsc(search_str($_GET['query']))));
if (isset($_POST['query']))$query = esc(stripcslashes(hsc(search_str($_POST['query']))));
if (trim($query)) {
$count_founded_users = mysqli_result("SELECT COUNT(*) FROM `anketa` INNER JOIN `user` ON `anketa`.`id_user` = `user`.`id` WHERE `user`.`nick` LIKE '%".my_esc($query)."%' OR `anketa`.`name` LIKE '%".my_esc($query)."%' OR `anketa`.`o_sebe` LIKE '%".my_esc($query)."%'");
// посчитали найденных пользователей
$count_founded_comms = mysqli_result("SELECT COUNT(*) FROM `comm` WHERE `name` LIKE '%".my_esc($query)."%'");
// посчитали найденные сообщества
$count_founded_diaries = mysqli_result("SELECT COUNT(*) FROM `diary` WHERE `name` LIKE '%".my_esc($query)."%' OR `text` LIKE '%".my_esc($query)."%'");
// посчитали найденные записи в дневниках
$count_founded_topics = mysqli_result("SELECT COUNT(*) FROM `forum` WHERE (`name` LIKE '%".my_esc($query)."%' OR `msg` LIKE '%".my_esc($query)."%') AND `type` = 'topic' AND `id_comm` = '0'");
// посчитали найденные темы форума
// теперь ищем файлы
// сперва нужно понаходить нужныйе нам папки
// и так, ищем
$others_where = NULL;
$fz_dir_for_pictures = mysqli_fetch_array(mysqli_query($dbi, "SELECT * FROM `files_zone` WHERE `name` = 'Картинки' LIMIT 1"));
if (@$fz_dir_for_pictures['id']) {
$others_where .= " AND `counter` NOT LIKE '%/$fz_dir_for_pictures[id]/%'";
$count_founded_pictures = mysqli_result("SELECT COUNT(*) FROM `files_zone` WHERE `name` LIKE '%".my_esc($query)."%' AND `counter` LIKE '%/$fz_dir_for_pictures[id]/%' AND (`type` = 'file' OR `type` = 'foto')");
} else $count_founded_pictures = 0;
// картинки
$fz_dir_for_musics = mysqli_fetch_array(mysqli_query($dbi, "SELECT * FROM `files_zone` WHERE `name` = 'Музыка' LIMIT 1"));
if (@$fz_dir_for_musics['id']) {
$others_where .= " AND `counter` NOT LIKE '%/$fz_dir_for_musics[id]/%'";
$count_founded_musics = mysqli_result("SELECT COUNT(*) FROM `files_zone` WHERE `name` LIKE '%".my_esc($query)."%' AND `counter` LIKE '%/$fz_dir_for_musics[id]/%' AND (`type` = 'file' OR `type` = 'foto')");
} else $count_founded_musics = 0;
// музыка
$fz_dir_for_videos = mysqli_fetch_array(mysqli_query($dbi, "SELECT * FROM `files_zone` WHERE `name` = 'Видео' LIMIT 1"));
if (@$fz_dir_for_videos['id']) {
$others_where .= " AND `counter` NOT LIKE '%/$fz_dir_for_videos[id]/%'";
$count_founded_videos = mysqli_result("SELECT COUNT(*) FROM `files_zone` WHERE `name` LIKE '%".my_esc($query)."%' AND `counter` LIKE '%/$fz_dir_for_videos[id]/%' AND (`type` = 'file' OR `type` = 'foto')");
} else $count_founded_videos = 0;
// видео
$fz_dir_for_games = mysqli_fetch_array(mysqli_query($dbi, "SELECT * FROM `files_zone` WHERE `name` = 'Игры' LIMIT 1"));
if (@$fz_dir_for_games['id']) {
$others_where .= " AND `counter` NOT LIKE '%/$fz_dir_for_games[id]/%'";
$count_founded_games = mysqli_result("SELECT COUNT(*) FROM `files_zone` WHERE `name` LIKE '%".my_esc($query)."%' AND `counter` LIKE '%/$fz_dir_for_games[id]/%' AND (`type` = 'file' OR `type` = 'foto')");
} else $count_founded_games = 0;
// игры
$fz_dir_for_programs = mysqli_fetch_array(mysqli_query($dbi, "SELECT * FROM `files_zone` WHERE `name` = 'Программы' LIMIT 1"));
if (@$fz_dir_for_programs['id']) {
$others_where .= " AND `counter` NOT LIKE '%/$fz_dir_for_programs[id]/%'";
$count_founded_programs = mysqli_result("SELECT COUNT(*) FROM `files_zone` WHERE `name` LIKE '%".my_esc($query)."%' AND `counter` LIKE '%/$fz_dir_for_programs[id]/%' AND (`type` = 'file' OR `type` = 'foto')");
} else $count_founded_programs = 0;
// программы
$fz_dir_for_gifs = mysqli_fetch_array(mysqli_query($dbi, "SELECT * FROM `files_zone` WHERE `name` = 'Анимашки' LIMIT 1"));
if (@$fz_dir_for_gifs['id']) {
$others_where .= " AND `counter` NOT LIKE '%/$fz_dir_for_gifs[id]/%'";
$count_founded_gifs = mysqli_result("SELECT COUNT(*) FROM `files_zone` WHERE `name` LIKE '%".my_esc($query)."%' AND `counter` LIKE '%/$fz_dir_for_gifs[id]/%' AND (`type` = 'file' OR `type` = 'foto')");
} else $count_founded_gifs = 0;
// анимашки
$fz_dir_for_themes = mysqli_fetch_array(mysqli_query($dbi, "SELECT * FROM `files_zone` WHERE `name` = 'Темы' LIMIT 1"));
if (@$fz_dir_for_themes['id']) {
$others_where .= " AND `counter` NOT LIKE '%/$fz_dir_for_themes[id]/%'";
$count_founded_themes = mysqli_result("SELECT COUNT(*) FROM `files_zone` WHERE `name` LIKE '%".my_esc($query)."%' AND `counter` LIKE '%/$fz_dir_for_themes[id]/%' AND (`type` = 'file' OR `type` = 'foto')");
} else $count_founded_themes = 0;
// темы
$fz_dir_for_books = mysqli_fetch_array(mysqli_query($dbi, "SELECT * FROM `files_zone` WHERE `name` = 'Книги' LIMIT 1"));
if (@$fz_dir_for_books['id']) {
$others_where .= " AND `counter` NOT LIKE '%/$fz_dir_for_books[id]/%'";
$count_founded_books = mysqli_result("SELECT COUNT(*) FROM `files_zone` WHERE `name` LIKE '%".my_esc($query)."%' AND `counter` LIKE '%/$fz_dir_for_books[id]/%' AND (`type` = 'file' OR `type` = 'foto')");
} else $count_founded_books = 0;
// книги
$fz_dir_for_articles = mysqli_fetch_array(mysqli_query($dbi, "SELECT * FROM `files_zone` WHERE `name` = 'Статьи, документы' LIMIT 1"));
if (@$fz_dir_for_articles['id']) {
$others_where .= " AND `counter` NOT LIKE '%/$fz_dir_for_articles[id]/%'";
$count_founded_articles = mysqli_result("SELECT COUNT(*) FROM `files_zone` WHERE `name` LIKE '%".my_esc($query)."%' AND `counter` LIKE '%/$fz_dir_for_articles[id]/%' AND (`type` = 'file' OR `type` = 'foto')");
} else $count_founded_articles = 0;
// статьи, документы
$fz_dir_for_flashs = mysqli_fetch_array(mysqli_query($dbi, "SELECT * FROM `files_zone` WHERE `name` = 'Флэш' LIMIT 1"));
if (@$fz_dir_for_flashs['id']) {
$others_where .= " AND `counter` NOT LIKE '%/$fz_dir_for_flashs[id]/%'";
$count_founded_flashs = mysqli_result("SELECT COUNT(*) FROM `files_zone` WHERE `name` LIKE '%".my_esc($query)."%' AND `counter` LIKE '%/$fz_dir_for_flashs[id]/%' AND (`type` = 'file' OR `type` = 'foto')");
} else $count_founded_flashs = 0;
// флэш
$count_founded_others = mysqli_result("SELECT COUNT(*) FROM `files_zone` WHERE `name` LIKE '%".my_esc($query)."%' AND (`type` = 'file' OR `type` = 'foto')$others_where");
// все остальное
$count_founded_all = $count_founded_users + $count_founded_comms + $count_founded_diaries + $count_founded_topics + $count_founded_pictures + $count_founded_musics + $count_founded_videos + $count_founded_games + $count_founded_programs + $count_founded_gifs + $count_founded_themes + $count_founded_books + $count_founded_articles + $count_founded_flashs + $count_founded_others;
echo "<div class=list><form method='POST' action=''>n";
echo "<b>Поиск:</b> «".($query)."»<br />";
echo "<input type='text' style='width: 65%; margin: 0px; padding: 4px 0px; vertical-align: middle;line-height: 100%;border: 1px solid #ccc;' name='query' value='' />n";
echo "<input type='submit' name='submited' style='line-height: 19px; margin-top: 0;' value='Найти'/>n";
echo "</div>n";
echo "</form>n";
if ($count_founded_all) {
echo "<div class='list'>n";
if ($count_founded_users)echo imgsd('users.png')." <a href='?act=users&query=$query'>Пользователи</a> <span class='counter'>$count_founded_users</span><br />n";
if ($count_founded_comms)echo imgsd('comm.png')." <a href='?act=comms&query=$query'>Сообщества</a> <span class='counter'>$count_founded_comms</span><br />n";
if ($count_founded_diaries)echo imgsd('diary.png')." <a href='?act=diaries&query=$query'>Записи</a> <span class='counter'>$count_founded_diaries</span><br />n";
if ($count_founded_topics)echo imgsd('forum.png')." <a href='?act=topics&query=$query'>Обсуждения</a> <span class='counter'>$count_founded_topics</span><br />n";
if ($count_founded_pictures)echo imgsd('pictures.png')." <a href='?act=files&case=pictures&query=$query'>Картинки</a> <span class='counter'>$count_founded_pictures</span><br />n";
if ($count_founded_musics)echo imgsd('musics.png')." <a href='?act=files&case=musics&query=$query'>Музыка</a> <span class='counter'>$count_founded_musics</span><br />n";
if ($count_founded_videos)echo imgsd('videos.png')." <a href='?act=files&case=videos&query=$query'>Видео</a> <span class='counter'>$count_founded_videos</span><br />n";
if ($count_founded_games)echo imgsd('games.png')." <a href='?act=files&case=games&query=$query'>Игры</a> <span class='counter'>$count_founded_games</span><br />n";
if ($count_founded_programs)echo imgsd('programs.png')." <a href='?act=files&case=programs&query=$query'>Программы</a> <span class='counter'>$count_founded_programs</span><br />n";
if ($count_founded_gifs)echo imgsd('gifs.png')." <a href='?act=files&case=gifs&query=$query'>Анимашки</a> <span class='counter'>$count_founded_gifs</span><br />n";
if ($count_founded_themes)echo imgsd('themes.png')." <a href='?act=files&case=themes&query=$query'>Темы</a> <span class='counter'>$count_founded_themes</span><br />n";
if ($count_founded_books)echo imgsd('guestbook.png')." <a href='?act=files&case=books&query=$query'>Книги</a> <span class='counter'>$count_founded_books</span><br />n";
if ($count_founded_articles)echo imgsd('article.png')." <a href='?act=files&case=articles&query=$query'>Статьи, документы</a> <span class='counter'>$count_founded_articles</span><br />n";
if ($count_founded_flashs)echo imgsd('flashs.png')." <a href='?act=files&case=flashs&query=$query'>Флэш</a> <span class='counter'>$count_founded_flashs</span><br />n";
if ($count_founded_others)echo imgsd('tag.png')." <a href='?act=files&case=others&query=$query'>Прочее</a> <span class='counter'>$count_founded_others</span><br />n";
echo "</div>n";
} else {
list_empty("Поиск не дал результатов");
}
echo "<div class='foot'>n";
echo image_back()." <a href='?'>Назад</a>n";
echo "</div>n";
ex_foot();
}
}
echo "<div class=list><form method='POST' action=''>n";
echo "Что будем искать?<br />n";
echo "<input type='text' style='width: 65%; margin: 0px; padding: 4px 0px; vertical-align: middle;line-height: 100%;border: 1px solid #ccc;' name='query' value='' />n";
echo "<input type='submit' name='submited' style='line-height: 19px; margin-top: 0;' value='Найти'/>n";
echo "</div>n";
echo "</form>n";
echo "<div class='foot'>n";
if (isset($user))echo image_back()." <a href='$config[profile_page]'>Назад</a>n";
else echo image_back()." <a href='/'>Назад</a>n";
echo "</div>n";
ex_foot();
?>