<?
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';
include_once '../sys/inc/icons.php'; // Иконки главного меню
$set['title']='Поиск';
include_once '../sys/inc/thead.php';
include_once 'functions.php';


title();

if(!empty($_GET['words']))
					
					{
					$count_vse=0;
					
						$words=filter($_GET['words']);
						$word=preg_split('/([\ \+\-\_\#])/', $words, 0, PREG_SPLIT_NO_EMPTY);
						if(count($word)<1)unset($word);
						
						if(isset($_GET['check']))
								{
								$check=filter($_GET['check']);
								if($check=='da')$check=TRUE;
								}
											
						
										
						
						//////Поиск людей
						$zapros="SELECT * FROM `user` WHERE `nick` LIKE '%".$word[0]."%' OR `ank_city` LIKE '%".$word[0]."%'  OR `ank_o_sebe` LIKE '%".$word[0]."%'";
						$zapros.=" OR `nick` LIKE '%".strtolower($word[0])."' OR `ank_city` LIKE '%".strtolower($word[0])."%'  OR `ank_o_sebe` LIKE '%".strtolower($word[0])."%'";
						$zapros.=" OR `nick` LIKE '%".rasklad($word[0])."' OR `ank_city` LIKE '%".rasklad($word[0])."%'  OR `ank_o_sebe` LIKE '%".rasklad($word[0])."%'";
						$zapros.=" OR `nick` LIKE '%".trans($word[0])."' OR `ank_city` LIKE '%".trans($word[0])."%'  OR `ank_o_sebe` LIKE '%".trans($word[0])."%'";
						$zapros.=" OR `nick` LIKE '%".retrans($word[0])."' OR `ank_city` LIKE '%".retrans($word[0])."%'  OR `ank_o_sebe` LIKE '%".retrans($word[0])."%'";
						if(count($word)>1)
									{
										for($i=1;$i<=count($word)-1;$i++)
										{

												$zapros.=" OR `nick` LIKE '%".$word[$i]."' OR `ank_city` LIKE '%".$word[$i]."%'  OR `ank_o_sebe` LIKE '%".$word[$i]."%'";
												$zapros.=" OR `nick` LIKE '%".strtolower($word[$i])."' OR `ank_city` LIKE '%".strtolower($word[$i])."%'  OR `ank_o_sebe` LIKE '%".strtolower($word[$i])."%'";
												$zapros.=" OR `nick` LIKE '%".rasklad($word[$i])."' OR `ank_city` LIKE '%".rasklad($word[$i])."%'  OR `ank_o_sebe` LIKE '%".rasklad($word[$i])."%'";
												$zapros.=" OR `nick` LIKE '%".trans($word[$i])."' OR `ank_city` LIKE '%".trans($word[$i])."%'  OR `ank_o_sebe` LIKE '%".trans($word[$i])."%'";
												$zapros.=" OR `nick` LIKE '%".retrans($word[$i])."' OR `ank_city` LIKE '%".retrans($word[$i])."%'  OR `ank_o_sebe` LIKE '%".retrans($word[$i])."%'";
												}
									}

						$count_user=mysql_num_rows(mysql_query($zapros));
						$count_vse+=$count_user;						
						
						if(isset($_GET['people']))
								{
								include_once 'modules/people.php';
								die();
								}
						
						
						
						/////Поиск галерей
						$zapros="SELECT * FROM `gallery` WHERE (`name` LIKE '%".$word[0]."%'  OR `opis` LIKE '%".$word[0]."%'";
						$zapros.=" OR `name` LIKE '%".strtolower($word[0])."' OR `opis` LIKE '%".strtolower($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".rasklad($word[0])."' OR `opis` LIKE '%".rasklad($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".trans($word[0])."' OR `opis` LIKE '%".trans($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".retrans($word[0])."' OR `opis` LIKE '%".retrans($word[0])."%'";
						if(count($word)>1)
									{
										for($i=1;$i<=count($word)-1;$i++)
										{

												$zapros.=" OR `name` LIKE '%".$word[$i]."' OR `opis` LIKE '%".$word[$i]."%'";
												$zapros.=" OR `name` LIKE '%".strtolower($word[$i])."' OR `opis` LIKE '%".strtolower($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".rasklad($word[$i])."' OR `opis` LIKE '%".rasklad($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".trans($word[$i])."' OR `opis` LIKE '%".trans($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".retrans($word[$i])."' OR `opis` LIKE '%".retrans($word[$i])."%'";
												}
									}
						$zapros.=") AND `privat` = '0'";
						$count_album=mysql_num_rows(mysql_query($zapros));
						$count_vse+=$count_album;
								
								if(isset($_GET['album']))
										{
										include_once 'modules/album.php';
										die();
										}
										
						/////Поиск фото
						$zapros="SELECT * FROM `gallery_foto` WHERE (`name` LIKE '%".$word[0]."%'  OR `opis` LIKE '%".$word[0]."%'";
						$zapros.=" OR `name` LIKE '%".strtolower($word[0])."' OR `opis` LIKE '%".strtolower($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".rasklad($word[0])."' OR `opis` LIKE '%".rasklad($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".trans($word[0])."' OR `opis` LIKE '%".trans($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".retrans($word[0])."' OR `opis` LIKE '%".retrans($word[0])."%'";
						if(count($word)>1)
									{
										for($i=1;$i<=count($word)-1;$i++)
										{

												$zapros.=" OR `name` LIKE '%".$word[$i]."' OR `opis` LIKE '%".$word[$i]."%'";
												$zapros.=" OR `name` LIKE '%".strtolower($word[$i])."' OR `opis` LIKE '%".strtolower($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".rasklad($word[$i])."' OR `opis` LIKE '%".rasklad($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".trans($word[$i])."' OR `opis` LIKE '%".trans($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".retrans($word[$i])."' OR `opis` LIKE '%".retrans($word[$i])."%'";
												}
									}
						$zapros.=") AND (`pass` IS NULL OR pass = '') ".(isset($check) && $check===TRUE?" AND `metka` = '0' ":NULL);
						$count_foto=mysql_num_rows(mysql_query($zapros));
						$count_vse+=$count_foto;							
						
								if(isset($_GET['foto']))
								{
								include_once 'modules/foto.php';
								die();
								}
						
						
						
						/////Поиск изображений
						$zapros="SELECT * FROM `obmennik_files` WHERE `type` LIKE '%image%' AND `ras` != 'gif' AND ( `name` LIKE '%".$word[0]."%'  OR `opis` LIKE '%".$word[0]."%'";
						$zapros.=" OR `name` LIKE '%".strtolower($word[0])."' OR `opis` LIKE '%".strtolower($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".rasklad($word[0])."' OR `opis` LIKE '%".rasklad($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".trans($word[0])."' OR `opis` LIKE '%".trans($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".retrans($word[0])."' OR `opis` LIKE '%".retrans($word[0])."%'";
						if(count($word)>1)
									{
										for($i=1;$i<=count($word)-1;$i++)
										{

												$zapros.=" OR `name` LIKE '%".$word[$i]."' OR `opis` LIKE '%".$word[$i]."%'";
												$zapros.=" OR `name` LIKE '%".strtolower($word[$i])."' OR `opis` LIKE '%".strtolower($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".rasklad($word[$i])."' OR `opis` LIKE '%".rasklad($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".trans($word[$i])."' OR `opis` LIKE '%".trans($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".retrans($word[$i])."' OR `opis` LIKE '%".retrans($word[$i])."%'";
												}
									}
						$zapros.=') '.(isset($check) && $check===TRUE?" AND `metka` = '0' ":NULL);
						$count_image=mysql_num_rows(mysql_query($zapros));
						$count_vse+=$count_image;						
								
								if(isset($_GET['image']))
								{
								include_once 'modules/image.php';
								die();
								}
														
						/////Поиск анимаций
						$zapros="SELECT * FROM `obmennik_files` WHERE `type` LIKE '%image%' AND `ras` = 'gif' AND ( `name` LIKE '%".$word[0]."%'  OR `opis` LIKE '%".$word[0]."%'";
						$zapros.=" OR `name` LIKE '%".strtolower($word[0])."' OR `opis` LIKE '%".strtolower($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".rasklad($word[0])."' OR `opis` LIKE '%".rasklad($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".trans($word[0])."' OR `opis` LIKE '%".trans($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".retrans($word[0])."' OR `opis` LIKE '%".retrans($word[0])."%'";
						if(count($word)>1)
									{
										for($i=1;$i<=count($word)-1;$i++)
										{

												$zapros.=" OR `name` LIKE '%".$word[$i]."' OR `opis` LIKE '%".$word[$i]."%'";
												$zapros.=" OR `name` LIKE '%".strtolower($word[$i])."' OR `opis` LIKE '%".strtolower($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".rasklad($word[$i])."' OR `opis` LIKE '%".rasklad($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".trans($word[$i])."' OR `opis` LIKE '%".trans($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".retrans($word[$i])."' OR `opis` LIKE '%".retrans($word[$i])."%'";
												}
									}
						$zapros.=') '.(isset($check) && $check===TRUE?" AND `metka` = '0' ":NULL);
						$count_anim=mysql_num_rows(mysql_query($zapros));
						$count_vse+=$count_anim;
								
								if(isset($_GET['anim']))
								{
								include_once 'modules/anim.php';
								die();
								}

						/////Поиск видео
						$zapros="SELECT * FROM `obmennik_files` WHERE `type` LIKE '%video%' AND ( `name` LIKE '%".$word[0]."%'  OR `opis` LIKE '%".$word[0]."%'";
						$zapros.=" OR `name` LIKE '%".strtolower($word[0])."' OR `opis` LIKE '%".strtolower($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".rasklad($word[0])."' OR `opis` LIKE '%".rasklad($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".trans($word[0])."' OR `opis` LIKE '%".trans($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".retrans($word[0])."' OR `opis` LIKE '%".retrans($word[0])."%'";
						if(count($word)>1)
									{
										for($i=1;$i<=count($word)-1;$i++)
										{

												$zapros.=" OR `name` LIKE '%".$word[$i]."' OR `opis` LIKE '%".$word[$i]."%'";
												$zapros.=" OR `name` LIKE '%".strtolower($word[$i])."' OR `opis` LIKE '%".strtolower($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".rasklad($word[$i])."' OR `opis` LIKE '%".rasklad($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".trans($word[$i])."' OR `opis` LIKE '%".trans($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".retrans($word[$i])."' OR `opis` LIKE '%".retrans($word[$i])."%'";
												}
									}
						$zapros.=') '.(isset($check) && $check===TRUE?" AND `metka` = '0' ":NULL);
						$count_video=mysql_num_rows(mysql_query($zapros));
						$count_vse+=$count_video;
							

							if(isset($_GET['video']))
								{
								include_once 'modules/video.php';
								die();
								}						

						/////Поиск музыки
						$zapros="SELECT * FROM `obmennik_files` WHERE `type` LIKE '%audio%' AND ( `name` LIKE '%".$word[0]."%'  OR `opis` LIKE '%".$word[0]."%'";
						$zapros.=" OR `name` LIKE '%".strtolower($word[0])."' OR `opis` LIKE '%".strtolower($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".rasklad($word[0])."' OR `opis` LIKE '%".rasklad($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".trans($word[0])."' OR `opis` LIKE '%".trans($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".retrans($word[0])."' OR `opis` LIKE '%".retrans($word[0])."%'";
						if(count($word)>1)
									{
										for($i=1;$i<=count($word)-1;$i++)
										{

												$zapros.=" OR `name` LIKE '%".$word[$i]."' OR `opis` LIKE '%".$word[$i]."%'";
												$zapros.=" OR `name` LIKE '%".strtolower($word[$i])."' OR `opis` LIKE '%".strtolower($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".rasklad($word[$i])."' OR `opis` LIKE '%".rasklad($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".trans($word[$i])."' OR `opis` LIKE '%".trans($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".retrans($word[$i])."' OR `opis` LIKE '%".retrans($word[$i])."%'";
												}
									}
						$zapros.=') '.(isset($check) && $check===TRUE?" AND `metka` = '0' ":NULL);
						$count_audio=mysql_num_rows(mysql_query($zapros));
						$count_vse+=$count_audio;
							
							
							if(isset($_GET['audio']))
								{
								include_once 'modules/audio.php';
								die();
								}	
								
						/////Поиск игр и приложений
						$zapros="SELECT * FROM `obmennik_files` WHERE `type` LIKE '%application%' AND (`ras` = 'jar' OR `ras` = 'jad' OR `ras` = 'sis' OR `ras` = 'apk' OR `ras` = 'ipa')
						AND ( `name` LIKE '%".$word[0]."%'  OR `opis` LIKE '%".$word[0]."%'";
						$zapros.=" OR `name` LIKE '%".strtolower($word[0])."' OR `opis` LIKE '%".strtolower($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".rasklad($word[0])."' OR `opis` LIKE '%".rasklad($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".trans($word[0])."' OR `opis` LIKE '%".trans($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".retrans($word[0])."' OR `opis` LIKE '%".retrans($word[0])."%'";
						if(count($word)>1)
									{
										for($i=1;$i<=count($word)-1;$i++)
										{

												$zapros.=" OR `name` LIKE '%".$word[$i]."' OR `opis` LIKE '%".$word[$i]."%'";
												$zapros.=" OR `name` LIKE '%".strtolower($word[$i])."' OR `opis` LIKE '%".strtolower($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".rasklad($word[$i])."' OR `opis` LIKE '%".rasklad($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".trans($word[$i])."' OR `opis` LIKE '%".trans($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".retrans($word[$i])."' OR `opis` LIKE '%".retrans($word[$i])."%'";
												}
									}
						$zapros.=') '.(isset($check) && $check===TRUE?" AND `metka` = '0' ":NULL);
						$count_apk=mysql_num_rows(mysql_query($zapros));
						$count_vse+=$count_apk;						
						
							if(isset($_GET['app']))
								{
								include_once 'modules/app.php';
								die();
								}		
								
						/////Поиск флеш
						$zapros="SELECT * FROM `obmennik_files` WHERE (`ras` = 'flv' OR `ras` = 'swf' OR `ras` = 'nth')
						AND ( `name` LIKE '%".$word[0]."%'  OR `opis` LIKE '%".$word[0]."%'";
						$zapros.=" OR `name` LIKE '%".strtolower($word[0])."' OR `opis` LIKE '%".strtolower($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".rasklad($word[0])."' OR `opis` LIKE '%".rasklad($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".trans($word[0])."' OR `opis` LIKE '%".trans($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".retrans($word[0])."' OR `opis` LIKE '%".retrans($word[0])."%'";
						if(count($word)>1)
									{
										for($i=1;$i<=count($word)-1;$i++)
										{

												$zapros.=" OR `name` LIKE '%".$word[$i]."' OR `opis` LIKE '%".$word[$i]."%'";
												$zapros.=" OR `name` LIKE '%".strtolower($word[$i])."' OR `opis` LIKE '%".strtolower($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".rasklad($word[$i])."' OR `opis` LIKE '%".rasklad($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".trans($word[$i])."' OR `opis` LIKE '%".trans($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".retrans($word[$i])."' OR `opis` LIKE '%".retrans($word[$i])."%'";
												}
									}
						$zapros.=') '.(isset($check) && $check===TRUE?" AND `metka` = '0' ":NULL);
						$count_flash=mysql_num_rows(mysql_query($zapros));
						$count_vse+=$count_flash;
							
							if(isset($_GET['flash']))
								{
								include_once 'modules/flash.php';
								die();
								}	
								
						/////Поиск книг
						$zapros="SELECT * FROM `obmennik_files` WHERE (`ras` = 'doc' OR `ras` = 'txt' OR `ras` = 'pdf' OR `ras` = 'pptx' OR `ras` = 'docx'  OR `ras` = 'fb2' OR `ras` = 'epub' OR `ras` = 'rtf')
						AND ( `name` LIKE '%".$word[0]."%'  OR `opis` LIKE '%".$word[0]."%'";
						$zapros.=" OR `name` LIKE '%".strtolower($word[0])."' OR `opis` LIKE '%".strtolower($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".rasklad($word[0])."' OR `opis` LIKE '%".rasklad($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".trans($word[0])."' OR `opis` LIKE '%".trans($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".retrans($word[0])."' OR `opis` LIKE '%".retrans($word[0])."%'";
						if(count($word)>1)
									{
										for($i=1;$i<=count($word)-1;$i++)
										{

												$zapros.=" OR `name` LIKE '%".$word[$i]."' OR `opis` LIKE '%".$word[$i]."%'";
												$zapros.=" OR `name` LIKE '%".strtolower($word[$i])."' OR `opis` LIKE '%".strtolower($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".rasklad($word[$i])."' OR `opis` LIKE '%".rasklad($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".trans($word[$i])."' OR `opis` LIKE '%".trans($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".retrans($word[$i])."' OR `opis` LIKE '%".retrans($word[$i])."%'";
												}
									}
						$zapros.=') '.(isset($check) && $check===TRUE?" AND `metka` = '0' ":NULL);
						$count_book=mysql_num_rows(mysql_query($zapros));
						$count_vse+=$count_book;
							
							if(isset($_GET['book']))
								{
								include_once 'modules/book.php';
								die();
								}							
						/////Поиск по дневникам
						$zapros="SELECT * FROM `notes` WHERE `name` LIKE '%".$word[0]."%'  OR `msg` LIKE '%".$word[0]."%'";
						$zapros.=" OR `name` LIKE '%".strtolower($word[0])."' OR `msg` LIKE '%".strtolower($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".rasklad($word[0])."' OR `msg` LIKE '%".rasklad($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".trans($word[0])."' OR `msg` LIKE '%".trans($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".retrans($word[0])."' OR `msg` LIKE '%".retrans($word[0])."%'";
						if(count($word)>1)
									{
										for($i=1;$i<=count($word)-1;$i++)
										{

												$zapros.=" OR `name` LIKE '%".$word[$i]."' OR `msg` LIKE '%".$word[$i]."%'";
												$zapros.=" OR `name` LIKE '%".strtolower($word[$i])."' OR `msg` LIKE '%".strtolower($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".rasklad($word[$i])."' OR `msg` LIKE '%".rasklad($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".trans($word[$i])."' OR `msg` LIKE '%".trans($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".retrans($word[$i])."' OR `msg` LIKE '%".retrans($word[$i])."%'";
												}
									}
						
						$count_diary=mysql_num_rows(mysql_query($zapros));
						$count_vse+=$count_diary;						
							
							if(isset($_GET['diary']))
								{
								include_once 'modules/diary.php';
								die();
								}							
						
						
						/////Поиск по форуму
						$zapros="SELECT * FROM `forum_t` WHERE `name` LIKE '%".$word[0]."%'  OR `text` LIKE '%".$word[0]."%'";
						$zapros.=" OR `name` LIKE '%".strtolower($word[0])."' OR `text` LIKE '%".strtolower($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".rasklad($word[0])."' OR `text` LIKE '%".rasklad($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".trans($word[0])."' OR `text` LIKE '%".trans($word[0])."%'";
						$zapros.=" OR `name` LIKE '%".retrans($word[0])."' OR `text` LIKE '%".retrans($word[0])."%'";
						if(count($word)>1)
									{
										for($i=1;$i<=count($word)-1;$i++)
										{

												$zapros.=" OR `name` LIKE '%".$word[$i]."' OR `text` LIKE '%".$word[$i]."%'";
												$zapros.=" OR `name` LIKE '%".strtolower($word[$i])."' OR `text` LIKE '%".strtolower($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".rasklad($word[$i])."' OR `text` LIKE '%".rasklad($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".trans($word[$i])."' OR `text` LIKE '%".trans($word[$i])."%'";
												$zapros.=" OR `name` LIKE '%".retrans($word[$i])."' OR `text` LIKE '%".retrans($word[$i])."%'";
												}
									}
						
						$count_forum=mysql_num_rows(mysql_query($zapros));
						
						$count_vse+=$count_forum;						
								
								if(isset($_GET['forum']))
								{
								include_once 'modules/forum.php';
								die();
								}	
						/////Поиск по новостям
						$zapros="SELECT * FROM `news` WHERE `msg` LIKE '%".$word[0]."%'  OR `title` LIKE '%".$word[0]."%'";
						$zapros.=" OR `msg` LIKE '%".strtolower($word[0])."' OR `title` LIKE '%".strtolower($word[0])."%'";
						$zapros.=" OR `msg` LIKE '%".rasklad($word[0])."' OR `title` LIKE '%".rasklad($word[0])."%'";
						$zapros.=" OR `msg` LIKE '%".trans($word[0])."' OR `title` LIKE '%".trans($word[0])."%'";
						$zapros.=" OR `msg` LIKE '%".retrans($word[0])."' OR `title` LIKE '%".retrans($word[0])."%'";
						if(count($word)>1)
									{
										for($i=1;$i<=count($word)-1;$i++)
										{

												$zapros.=" OR `msg` LIKE '%".$word[$i]."' OR `title` LIKE '%".$word[$i]."%'";
												$zapros.=" OR `msg` LIKE '%".strtolower($word[$i])."' OR `title` LIKE '%".strtolower($word[$i])."%'";
												$zapros.=" OR `msg` LIKE '%".rasklad($word[$i])."' OR `title` LIKE '%".rasklad($word[$i])."%'";
												$zapros.=" OR `msg` LIKE '%".trans($word[$i])."' OR `title` LIKE '%".trans($word[$i])."%'";
												$zapros.=" OR `msg` LIKE '%".retrans($word[$i])."' OR `title` LIKE '%".retrans($word[$i])."%'";
												}
									}
						
						$count_news=mysql_num_rows(mysql_query($zapros));
						
						$count_vse+=$count_news;
						
								if(isset($_GET['news']))
								{
								include_once 'modules/news.php';
								die();
								}		
								
						//Записываем запросы или увеличиваем счетчик
						$query=mysql_query("SELECT * FROM `search` WHERE `text` = '".$words."' LIMIT 1");
						$count_zaprosov=mysql_num_rows($query);
							
							if($count_zaprosov>0)
							{
							$search=mysql_fetch_array($query);
							mysql_query("UPDATE `search` SET `count` = `count` + '1' WHERE `id` = '".$search['id']."' LIMIT 1");
							}
								else
									{
									mysql_query("INSERT INTO `search` SET ".(isset($user)?"`user` = '".$user['id']."' ,":NULL)." `text` = '".$words."' , `count` = '1'");
									}
						}

////Форма поиска
echo'<div class="main_menu" style="text-align:center;">Поиск по сайту<br>
	 <form method="GET" action="/search/">
	 <table style="width:100%" border="0" cellspacing="0" cellpadding="0"><tr>
	 <td style="width:"70%">
	 <input style="padding:8px;display:block;width:100%;border-radius:5px 0px 0px 5px;border:1px solid #BEBEBE" type="text" name="words" value="'.(isset($words)?stripcslashes($words):NULL).'">
	 </td>
	 <td style="width:"10%">
	 <input accesskey="enter" style="opacity:1;moz-opacity:1;filter: alpha(opacity=100) black;cursor:pointer;cursor: hand; padding:8px 15px 8px 15px;background-color:#000000;background: transparent url(/search.png) no-repeat right 35% center;border:0;display:block;width:100%;border-radius:0px 5px 5px 0px;border-left:0px solid #BEBEBE;border-top:1px solid #BEBEBE;border-bottom:1px solid #BEBEBE;border-right:1px solid #BEBEBE" type="submit" value=""></td>
	 </tr></table>
	 <div style="text-align:left"><input type="checkbox" name="check" value="da" '.(isset($check) && $check===TRUE?'checked':NULL).'>Не показывать файлы 18+</div>
	</form>
</div>';

if(isset($count_vse))
		{
		if($count_vse<1)
				{
					echo'<div class="mess" style="text-align:center;">Ничего не найдено.</div>';
				}		
			
			else
			{
					echo'<div class="main_menu" style="text-align:center;">'.(isset($words)?'Результаты по запросу <b>'.stripcslashes($words).'</b>
					<br>'.(preg_match('/[a-z0-9_]/i',$words)?'<span style="font-size:11px;color:#4b7122">Система определила,что запрос на латиннице и дополнила результаты по запросам <b>'.rasklad($words).'</b> и <b>'.retrans($words).'</b></span>':NULL).'
					':'Введите запрос').'</div>';
				
				//Люди
				if($count_user>0)echo'<div class="main_menu"><img src="/style/icons/druzya.png" alt="*"><a href="/search/?words='.str_replace(' ','+',$_GET['words']).(isset($check) && $check===TRUE?'&check=da':NULL).'&people">Люди</a> ('.$count_user.')</div>';
				//Фото
				if($count_album>0)echo'<div class="main_menu"><img src="/search/img/label.png" alt="*"><a href="/search/?words='.$_GET['words'].(isset($check) && $check===TRUE?'&check=da':NULL).'&album">Альбомы</a> ('.$count_album.')</div>';
				//Фото
				if($count_foto>0)echo'<div class="main_menu"><img src="/search/img/label.png" alt="*"><a href="/search/?words='.$_GET['words'].(isset($check) && $check===TRUE?'&check=da':NULL).'&foto">Фотографии</a> ('.$count_foto.')</div>';
				//Картинки
				if($count_image>0)echo'<div class="main_menu"><img src="/search/img/label.png" alt="*"><a href="/search/?words='.$_GET['words'].(isset($check) && $check===TRUE?'&check=da':NULL).'&image">Картинки</a> ('.$count_image.')</div>';	
				//Анимации
				if($count_anim>0)echo'<div class="main_menu"><img src="/search/img/icon_img_gif.gif" alt="*"><a href="/search/?words='.$_GET['words'].(isset($check) && $check===TRUE?'&check=da':NULL).'&anim">Анимации (GIF)</a> ('.$count_anim.')</div>';
				//Видео
				if($count_video>0)echo'<div class="main_menu"><img src="/search/img/icon_video.gif" alt="jpg"><a href="/search/?words='.$_GET['words'].(isset($check) && $check===TRUE?'&check=da':NULL).'&video">Видео</a> ('.$count_video.')</div>';	
				//Музыка
				if($count_audio>0)echo'<div class="main_menu"><img src="/search/img/file_mp3.gif" alt="jpg"><a href="/search/?words='.$_GET['words'].(isset($check) && $check===TRUE?'&check=da':NULL).'&audio">Музыка</a> ('.$count_audio.')</div>';
				//Приложения
				if($count_apk>0)echo'<div class="main_menu"><img src="/search/img/SharedZone.gif" alt="jpg"><a href="/search/?words='.$_GET['words'].(isset($check) && $check===TRUE?'&check=da':NULL).'&app">Игры и приложения</a> ('.$count_apk.')</div>';
				//Flash
				if($count_flash>0)echo'<div class="main_menu"><img src="/search/img/SharedZone.gif" alt="jpg"><a href="/search/?words='.$_GET['words'].(isset($check) && $check===TRUE?'&check=da':NULL).'&flash">Флеш (Flash)</a> ('.$count_flash.')</div>';				
				//Книги
				if($count_book>0)echo'<div class="main_menu"><img src="/search/img/books.png" alt="jpg"><a href="/search/?words='.$_GET['words'].(isset($check) && $check===TRUE?'&check=da':NULL).'&book">Книги и статьи</a> ('.$count_book.')</div>';
				//Дневники				
				if($count_diary>0)echo'<div class="main_menu"><img src="/search/img/books.png" alt="jpg"><a href="/search/?words='.$_GET['words'].(isset($check) && $check===TRUE?'&check=da':NULL).'&diary">Дневники</a> ('.$count_diary.')</div>';
				//Темы форум				
				if($count_forum>0)echo'<div class="main_menu"><img src="/search/img/Forum.gif" alt="jpg"><a href="/search/?words='.$_GET['words'].(isset($check) && $check===TRUE?'&check=da':NULL).'&forum">Форум</a> ('.$count_forum.')</div>';				
				//Новости				
				if($count_news>0)echo'<div class="main_menu"><img src="/style/icons/news.png" alt="jpg"><a href="/search/?words='.$_GET['words'].(isset($check) && $check===TRUE?'&check=da':NULL).'&news">Новости</a> ('.$count_news.')</div>';				
				
				echo'<div class="mess" style="text-align:center">Всего найдено '.$count_vse.' соответствий</div>';
				}
		
		}

if(empty($_GET['words']) || $count_vse<1)
					{
					//Популярные запросы
						$query=mysql_query("SELECT * FROM `search` ORDER BY `count` DESC LIMIT 5");
						$count_zaprosov=mysql_num_rows($query);
							
								if($count_zaprosov>0)
								{
								echo'<div class="nav1" style="text-align:center">Популярные запросы</div>';
								
								while($search=mysql_fetch_array($query))
									{
									echo'<div class="main_menu"><img src="/search/img/label.png" alt="jpg"><a href="/search/?words='.$search['text'].'">'.$search['text'].'</a> ('.$search['count'].' раз)</div>';	
									}
								
								}						
							
							///Мои поиски
							if(isset($user))
							{
							$query=mysql_query("SELECT * FROM `search` WHERE `user` = '".$user['id']."' ORDER BY `id` DESC LIMIT 5");
							$count_zaprosov=mysql_num_rows($query);
								
								if($count_zaprosov>0)
								{
								echo'<div class="nav1" style="text-align:center">История вашего поиска</div>';
								
								while($search=mysql_fetch_array($query))
									{
									echo'<div class="main_menu"><img src="/search/img/label.png" alt="jpg"><a href="/search/?words='.$search['text'].'">'.$search['text'].'</a> ('.$search['count'].' раз)</div>';	
									}
								
								}
							
							}
							}

include_once '../sys/inc/tfoot.php';
?>