Файл: love/index.php
Строк: 494
<?php
require '../lang_inc.php';
require '../sid.php';
require '../config.php';
$link = connect_db();
if (!empty($_SESSION['us'])) {
list($user, $id, $ps) = check_login($link);
whorm(0, 'love');
}
include '../head.php';
include '../navigator.php';
$do = (isset($_GET['do'])) ? $_GET['do'] : NULL;
switch($do) {
default:
echo $div_title . ''.$lang['Поиск пользователя'].'' . $div_end . $div_left;
unset($_SESSION['nikname']);
unset($_SESSION['ot']);
unset($_SESSION['do']);
unset($_SESSION['sex']);
unset($_SESSION['orient']);
unset($_SESSION['status']);
unset($_SESSION['target']);
unset($_SESSION['mycity']);
unset($_SESSION['foto']);
unset($_SESSION['onsite']);
if (isset($_GET['del'])) {
mysql_query("UPDATE `users` SET `s_city` = '' WHERE `id` = '$user[id]' LIMIT 1");
header('Location: index.php?lg='.$lg.'&' . $ref);
}
if ($lg == 'ru') {
$_citi = mysql_fetch_array(mysql_query("SELECT `city_name` FROM `geo_cities` WHERE `city_id` = '$user[s_city]'"));}
if ($lg == 'lv') {
$_citi = mysql_fetch_array(mysql_query("SELECT `city_name` FROM `geo_cities2` WHERE `city_id` = '$user[s_city]'"));}
if (!empty($user['s_city'])) {
$s_city = '<a href="index.php?do=city&lg='.$lg.'">' . $_citi[0] . '</a>
<a href="index.php?del&lg='.$lg.'"><img src="../ico/delete.gif" alt=""/></a>';
} else {
$s_city = '<b>'.$lang['Все города'].'</b>';
}
echo $div_menu . '
<a href="index.php?do=users&lg='.$lg.'">'.$lang['Знакомства'].'</a>
' . $div_end . '
<fieldset>
<FORM method="POST" action="index.php?do=result&lg='.$lg.'">
<label>'.$lang['Возраст'].':</label><br/>
'.$lang['От'].' <input type="text" name="ot" size="2" maxlength="2"/>
'.$lang['До'].' <input type="text" name="do" size="2" maxlength="2"/>
<br/>
<label>'.$lang['Пол'].':</label><br/>
<select name="sex">
<option value="0">'.$lang['Пол'].'</option>
<option value="2">'.$lang['Мужской'].'</option>
<option value="1">'.$lang['Женский'].'</option>
</select>
<br/>
<label>'.$lang['Ориентация'].':</label><br/>
<select name="orient">
<option value="0">'.$lang['Ориентация'].'</option>
<option value="1">'.$lang['Гетеро'].'</option>
<option value="2">'.$lang['Би'].'</option>
<option value="3">'.$lang['Гей/Лесби'].'</option>
</select>
<br/>
<label>'.$lang['Семейное положение'].':</label><br/>
<select name="status">
<option value="0">'.$lang['Семейное положение'].'</option>
<option value="1">'.$lang['Не женат/Не замужем'].'</option>
<option value="2">'.$lang['Есть подруга/Есть друг'].'</option>
<option value="3">'.$lang['Помолвлен/Помолвлена'].'</option>
<option value="4">'.$lang['Женат/Замужем'].'</option>
<option value="5">'.$lang['Всё сложно'].'</option>
<option value="6">'.$lang['В активном поиске'].'</option>
</select>
<br/>
<label>'.$lang['Цель знакомства'].':</label><br/>
<select name="target">
<option value="0">'.$lang['Цель знакомства'].'</option>
<option value="1">'.$lang['Дружба и общение'].'</option>
<option value="2">'.$lang['Переписка'].'</option>
<option value="3">'.$lang['Любовь, отношения'].'</option>
<option value="4">'.$lang['Регулярный секс вдвоем'].'</option>
<option value="5">'.$lang['Секс на один-два раза'].'</option>
<option value="6">'.$lang['Групповой секс'].'</option>
<option value="7">'.$lang['Виртуальный секс'].'</option>
<option value="8">'.$lang['Предлагаю интим за деньги'].'</option>
<option value="9">'.$lang['Ищу интим за деньги'].'</option>
<option value="10">'.$lang['Брак, создание семьи'].'</option>
<option value="11">'.$lang['Рождение, воспитание ребенка'].'</option>
<option value="12">'.$lang['Брак для вида'].'</option>
<option value="13">'.$lang['Совместная аренда жилья'].'</option>
<option value="14">'.$lang['Занятия спортом'].'</option>
</select>
<br/>
<label>'.$lang['Город'].':</label> ' . $s_city . ' (<a href="index.php?do=city&lg='.$lg.'">'.$lang['выбрать'].'</a>)
<br/>
<input type="checkbox" name="mycity" value="1"/> '.$lang['Свой город'].'
<br/>
<input type="checkbox" name="foto" value="1"/> '.$lang['С фотографией'].'
<br/>
<input type="checkbox" name="onsite" value="1"/> '.$lang['На сайте'].'
<br/>
<input type="submit" name="search" value="'.$lang['Найти'].'"/>
</FORM>
</fieldset>
<label>'.$lang['Простой поиск'].':</label><br/>
<FORM method="POST" action="index.php?do=view&lg='.$lg.'">
<input type="text" name="nikname"/>
<br/>
<label>'.$lang['В поиске можно указывать ник, id'].'</label><br/>
<input type="submit" name="gosearch" value="'.$lang['Найти'].'"/>
</FORM>';
echo $div_end;
break;
case result:
echo $div_title . ''.$lang['Результаты поиска'].'' . $div_end . $div_left . '
<img src="../ico/search.gif" alt=""/> <a href="index.php?lg='.$lg.'&'.$ref.'">'.$lang['Новый поиск'].'</a><br/>
' . $div_menu;
if (isset($_GET['new_all'])) {
$sql_sort = ' `id` DESC ';
echo '<b>'.$lang['Новые'].'</b> |
<a href="index.php?do=result&rating_all&lg='.$lg.'">'.$lang['По рейтингу'].'</a> |
<a href="index.php?do=result&last_all&lg='.$lg.'">'.$lang['Последние'].'</a>' . $div_end;
} elseif (isset($_GET['rating_all'])) {
$sql_sort = ' `ank_rating` + `rating` DESC ';
echo '<a href="index.php?do=result&new_all&lg='.$lg.'">'.$lang['Новые'].'</a> |
<b>'.$lang['По рейтингу'].'</b> |
<a href="index.php?do=result&last_all&lg='.$lg.'">'.$lang['Последние'].'</a>' . $div_end;
} elseif (isset($_GET['last_all'])) {
$sql_sort = ' `id` ASC ';
echo '<a href="index.php?do=result&new_all&lg='.$lg.'">'.$lang['Новые'].'</a> |
<a href="index.php?do=result&rating_all&lg='.$lg.'">'.$lang['По рейтингу'].'</a> |
<b>'.$lang['Последние'].'</b>' . $div_end;
} else {
$sql_sort = ' `onl` DESC ';
echo '<a href="index.php?do=result&new_all&lg='.$lg.'">'.$lang['Новые'].'</a> |
<a href="index.php?do=result&rating_all&lg='.$lg.'">'.$lang['По рейтингу'].'</a> |
<b>'.$lang['Последние'].'</b>' . $div_end;
}
if (isset($_POST['ot'])) $ot = my_int($_POST['ot']);
if (isset($_POST['do'])) $do = my_int($_POST['do']);
if (isset($_POST['sex'])) $sex = my_int($_POST['sex']);
if (isset($_POST['orient'])) $orient = my_int($_POST['orient']);
if (isset($_POST['status'])) $status = my_int($_POST['status']);
if (isset($_POST['target'])) $target = my_int($_POST['target']);
if (isset($_POST['mycity'])) $mycity = my_int($_POST['mycity']);
if (isset($_POST['foto'])) $foto = my_int($_POST['foto']);
if (isset($_POST['onsite'])) $onsite = my_int($_POST['onsite']);
if (isset($_SESSION['ot'])) $ot = my_int($_SESSION['ot']);
if (isset($_SESSION['do'])) $do = my_int($_SESSION['do']);
if (isset($_SESSION['sex'])) $sex = my_int($_SESSION['sex']);
if (isset($_SESSION['orient'])) $orient = my_int($_SESSION['orient']);
if (isset($_SESSION['status'])) $status = my_int($_SESSION['status']);
if (isset($_SESSION['target'])) $target = my_int($_SESSION['target']);
if (isset($_SESSION['mycity'])) $mycity = my_int($_SESSION['mycity']);
if (isset($_SESSION['foto'])) $foto = my_int($_SESSION['foto']);
if (isset($_SESSION['onsite'])) $onsite = my_int($_SESSION['onsite']);
$_SESSION['ot'] = $ot;
$_SESSION['do'] = $do;
$_SESSION['sex'] = $sex;
$_SESSION['orient'] = $orient;
$_SESSION['status'] = $status;
$_SESSION['target'] = $target;
$_SESSION['mycity'] = $mycity;
$_SESSION['foto'] = $foto;
$_SESSION['onsite'] = $onsite;
// выбор возраста ОТ
if ($ot != 0) {
$s_age_ot = '>= ' . $ot;
} else {
$s_age_ot = "LIKE '%'";
}
// выбор возраста ДО
if ($do != 0) {
$s_age_do = '<= ' . $do;
} else {
$s_age_do = "LIKE '%'";
}
// выбор пола
if ($sex == 1) {
$_sex = '= ' . 1;
} elseif ($sex == 2) {
$_sex = '= ' . 2;
} else {
$_sex = "LIKE '%'";
}
// выбор семейного положения
if ($sex == 1 && $status == 1) {
$_stat = "= '".$lang['Не замужем']."'";
} elseif ($sex == 1 && $status == 2) {
$_stat = "= '".$lang['Есть друг']."";
} elseif ($sex == 1 && $status == 3) {
$_stat = "= '".$lang['Помолвлена']."";
} elseif ($sex == 1 && $status == 4) {
$_stat = "= '".$lang['Замужем']."";
} elseif ($sex == 2 && $status == 1) {
$_stat = "= '".$lang['Не женат']."'";
} elseif ($sex == 2 && $status == 2) {
$_stat = "= '".$lang['Есть подруга']."'";
} elseif ($sex == 2 && $status == 3) {
$_stat = "= '".$lang['Помолвлен']."'";
} elseif ($sex == 2 && $status == 4) {
$_stat = "= '".$lang['Женат']."'";
} else {
$_stat = "LIKE '%'";
}
// выбор ориентации
if ($orient == 1) {
$_orient = "= '".$lang['Гетеро']."'";
} elseif ($orient == 2) {
$_orient = "= '".$lang['Би']."'";
} elseif ($orient == 3) {
$_orient = "= '".$lang['Гей/Лесби']."'";
} else {
$_orient = "LIKE '%'";
}
// выбор целей знакомства
if ($target == 1) {
$_target = "`tar_1` != '' AND";
} elseif ($target == 2) {
$_target = "`tar_2` != '' AND";
} elseif ($target == 3) {
$_target = "`tar_3` != '' AND";
} elseif ($target == 4) {
$_target = "`tar_4` != '' AND";
} elseif ($target == 5) {
$_target = "`tar_5` != '' AND";
} elseif ($target == 6) {
$_target = "`tar_6` != '' AND";
} elseif ($target == 7) {
$_target = "`tar_7` != '' AND";
} elseif ($target == 8) {
$_target = "`tar_8` != '' AND";
} elseif ($target == 9) {
$_target = "`tar_9` != '' AND";
} elseif ($target == 10) {
$_target = "`tar_10` != '' AND";
} elseif ($target == 11) {
$_target = "`tar_11` != '' AND";
} elseif ($target == 12) {
$_target = "`tar_12` != '' AND";
} elseif ($target == 13) {
$_target = "`tar_13` != '' AND";
} elseif ($target == 14) {
$_target = "`tar_14` != '' AND";
}
// выбор города
if ($mycity == 1 && $user['city'] == 0) {
$_citi = 0;
} elseif ($mycity == 1 && $user['city'] != 0) {
$_citi = '= ' . $user['city'];
} elseif ($mycity == 0 && $user['s_city'] != 0) {
$_citi = '= ' . $user['s_city'];
} else {
$_citi = "LIKE '%'";
}
// с фото или без
if ($foto == 1) {
$_foto = "`img` != ''";
} else {
$_foto = "`img` LIKE '%'";
}
// онлайн или офлайн
if ($onsite == 1) {
$_on = "`onl` + '200' > '" . time() . "'";
} else {
$_on = "`onl` LIKE '%'";
}
$look = mysql_result(mysql_query("SELECT COUNT(*) FROM `users`
WHERE
`age` {$s_age_ot} AND
`age` {$s_age_do} AND
`sex` {$_sex} AND
`sp_st` {$_stat} AND
`orient` {$_orient} AND
{$_target}
`city` {$_citi} AND
{$_foto} AND
{$_on}
"), 0);
$n = new navigator($look, 10, '?do=result&lg='.$lg.'&');
$res = mysql_query("SELECT * FROM `users` WHERE
`age` {$s_age_ot} AND
`age` {$s_age_do} AND
`sex` {$_sex} AND
`sp_st` {$_stat} AND
`orient` {$_orient} AND
{$_target}
`city` {$_citi} AND
{$_foto} AND
{$_on}
ORDER BY {$sql_sort} {$n->limit}");
$resIn = mysql_query("SELECT * FROM `liders` ORDER BY RAND() LIMIT 1");
////////////////////////////////////
if (mysql_num_rows($resIn) != false) {
$InRes = mysql_fetch_assoc($resIn);
$Status = (!empty($InRes['xstatus'])) ? '<br/><div class="q1"></div><div class="q2">' . smiles(bb_code($InRes['xstatus'])) . '</div>' : '';
echo $div_aut . us($InRes['user']) . $Status . '<br/>
<img src="../ico/lider.gif" alt=""/> <a href="../liders.php?lg='.$lg.'&'.$ref.'">'.$lang['Все лидеры'].'</a>' . $div_end;
}
////////////////////////////////////
if ($look != FALSE) {
$i = 0;
while($a = mysql_fetch_assoc($res)) {
$Status = (!empty($a['xstatus'])) ? '<br/><div class="q1"></div><div class="q2">' . smiles(bb_code($a['xstatus'])) . '</div>' : '';
echo ($i ++ % 2) ? $div_tworazdel : $div_razdel;
echo nikus($a['id']) . $Status . $div_end;
}
echo $n->navi();
} else {
echo ''.$lang['Поиск не дал результатов'].'!<br/>';
}
echo $div_end;
break;
case city:
echo $div_title . ''.$lang['Выбрать город'].'' . $div_end . $div_left;
if (isset($_GET['ok'])) {
$ok = my_int($_GET['ok']);
mysql_query("UPDATE `users` SET `s_city` = '$ok' WHERE `id` = '$user[id]' LIMIT 1");
header('Location: index.php?lg='.$lg.'&' . $ref);
}
if (isset($_GET['r'])) {
if ($lg == 'ru') {
$look = mysql_result(mysql_query("SELECT COUNT(*) FROM `geo_cities` WHERE `rid` = '" . (int)$_GET['r'] . "'"), 0);}
if ($lg == 'lv') {
$look = mysql_result(mysql_query("SELECT COUNT(*) FROM `geo_cities2` WHERE `rid` = '" . (int)$_GET['r'] . "'"), 0);}
$n = new navigator($look, 10, '?do=city&r='.(int)$_GET['r'].'&lg='.$lg.'&');
if ($lg == 'ru') {
$gorod = mysql_query("SELECT * FROM `geo_cities` WHERE `rid` = '" . (int)$_GET['r'] . "' ORDER BY `city_name` ASC {$n->limit}");}
if ($lg == 'lv') {
$gorod = mysql_query("SELECT * FROM `geo_cities2` WHERE `rid` = '" . (int)$_GET['r'] . "' ORDER BY `city_name` ASC {$n->limit}");}
$i = 0;
if ($look != FALSE) {
while($a = mysql_fetch_assoc($gorod)) {
echo ($i ++ % 2) ? $div_tworazdel : $div_razdel;
echo '<a href="index.php?do=city&ok='.$a['city_id'].'&lg='.$lg.'">' . $a['city_name'] . '</a>' . $div_end;
}
echo $n->navi();
} else {
echo ''.$lang['Городов нет'].'!<br/>';
}
}
elseif (isset($_GET['c'])) {
if ($lg == 'ru') {
$look = mysql_result(mysql_query("SELECT COUNT(*) FROM `geo_regions` WHERE `cid` = '" . (int)$_GET['c'] . "'"), 0);}
if ($lg == 'lv') {
$look = mysql_result(mysql_query("SELECT COUNT(*) FROM `geo_regions2` WHERE `cid` = '" . (int)$_GET['c'] . "'"), 0);}
$n = new navigator($look, 10, '?do=city&c='.(int)$_GET['c'].'&lg='.$lg.'&');
if ($lg == 'ru') {
$gorod = mysql_query("SELECT * FROM `geo_regions` WHERE `cid` = '" . (int)$_GET['c'] . "' ORDER BY `region_name` ASC {$n->limit}");}
if ($lg == 'lv') {
$gorod = mysql_query("SELECT * FROM `geo_regions2` WHERE `cid` = '" . (int)$_GET['c'] . "' ORDER BY `region_name` ASC {$n->limit}");}
$i = 0;
if ($look != FALSE) {
while($a = mysql_fetch_assoc($gorod)) {
echo ($i ++ % 2) ? $div_tworazdel : $div_razdel;
echo '<a href="index.php?do=city&r='.$a['region_id'].'&lg='.$lg.'">' . $a['region_name'] . '</a>' . $div_end;
}
echo $n->navi();
} else {
echo ''.$lang['Регионов нет'].'!<br/>';
}
} else {
if ($lg == 'ru') {
$look = mysql_result(mysql_query("SELECT COUNT(*) FROM `geo_countries`"), 0);}
if ($lg == 'lv') {
$look = mysql_result(mysql_query("SELECT COUNT(*) FROM `geo_countries2`"), 0);}
$n = new navigator($look, 10, '?do=city&lg='.$lg.'&');
if ($lg == 'ru') {
$gorod_1 = mysql_query("SELECT * FROM `geo_countries` WHERE `country_id` = '3159' OR `country_id` = '9908' ORDER BY `country_name` ASC {$n->limit}");}
if ($lg == 'lv') {
$gorod_1 = mysql_query("SELECT * FROM `geo_countries2` WHERE `country_id` = '3159' OR `country_id` = '9908' ORDER BY `country_name` ASC {$n->limit}");}
if ($lg == 'ru') {
$gorod_2 = mysql_query("SELECT * FROM `geo_countries` WHERE `country_id` != '3159' AND `country_id` != '9908' ORDER BY `country_name` ASC {$n->limit}");}
if ($lg == 'lv') {
$gorod_2 = mysql_query("SELECT * FROM `geo_countries2` WHERE `country_id` != '3159' AND `country_id` != '9908' ORDER BY `country_name` ASC {$n->limit}");}
$i = 0;
if ($look != FALSE) {
// Вывод России и Украины
while($a = mysql_fetch_assoc($gorod_1)) {
echo ($i ++ % 2) ? $div_tworazdel : $div_razdel;
echo $fl . '<a href="index.php?do=city&c='.$a['country_id'].'&lg='.$lg.'">' . $a['country_name'] . '</a>' . $div_end;
}
// Вывод остальных...
while($aa = mysql_fetch_assoc($gorod_2)) {
echo ($i ++ % 2) ? $div_tworazdel : $div_razdel;
echo $fl . '<a href="index.php?do=city&c='.$aa['country_id'].'&lg='.$lg.'">' . $aa['country_name'] . '</a>' . $div_end;
}
echo $n->navi();
} else {
echo ''.$lang['Стран нет'].'!<br/>';
}
}
echo $div_end;
break;
case users:
echo $div_title . ''.$lang['Знакомства'].'' . $div_end . $div_left . '
<img src="../ico/search.gif" alt=""/> <a href="index.php?lg='.$lg.'&'.$ref.'">'.$lang['Новый поиск'].'</a><br/>
' . $div_menu;
if (isset($_GET['new_all'])) {
$sql_sort = ' `id` DESC ';
echo '<b>'.$lang['Новые'].'</b> |
<a href="index.php?do=result&rating_all&lg='.$lg.'">'.$lang['По рейтингу'].'</a> |
<a href="index.php?do=result&last_all&lg='.$lg.'">'.$lang['Последние'].'</a>' . $div_end;
} elseif (isset($_GET['rating_all'])) {
$sql_sort = ' `ank_rating` + `rating` DESC ';
echo '<a href="index.php?do=result&new_all&lg='.$lg.'">'.$lang['Новые'].'</a> |
<b>'.$lang['По рейтингу'].'</b> |
<a href="index.php?do=result&last_all&lg='.$lg.'">'.$lang['Последние'].'</a>' . $div_end;
} elseif (isset($_GET['last_all'])) {
$sql_sort = ' `id` ASC ';
echo '<a href="index.php?do=result&new_all&lg='.$lg.'">'.$lang['Новые'].'</a> |
<a href="index.php?do=result&rating_all&lg='.$lg.'">'.$lang['По рейтингу'].'</a> |
<b>'.$lang['Последние'].'</b>' . $div_end;
} else {
$sql_sort = ' `id` ASC ';
echo '<a href="index.php?do=result&new_all&lg='.$lg.'">'.$lang['Новые'].'</a> |
<a href="index.php?do=result&rating_all&lg='.$lg.'">'.$lang['По рейтингу'].'</a> |
<b>'.$lang['Последние'].'</b>' . $div_end;
}
$look = mysql_result(mysql_query("SELECT COUNT(*) FROM `users`"), 0);
$n = new navigator($look, 10, '?do=users&lg='.$lg.'&');
$res = mysql_query("SELECT * FROM `liders` ORDER BY RAND() LIMIT 1");
$res_2 = mysql_query("SELECT `id`, `xstatus` FROM `users` ORDER BY {$sql_sort} {$n->limit}");
////////////////////////////////////
if (mysql_num_rows($res) != false) {
$InRes = mysql_fetch_assoc($res);
echo $div_aut . us($InRes['user']) . '<br/>
' . bb_code(smiles($InRes['text'])) . '<br/>
<img src="../ico/lider.gif" alt=""/> <a href="../liders.php?lg='.$lg.'&'.$ref.'">'.$lang['Все лидеры'].'</a>' . $div_end;
}
////////////////////////////////////
if ($look != FALSE) {
$i = 0;
while($a = mysql_fetch_assoc($res_2)) {
$Status = (!empty($a['xstatus'])) ? '<br/><div class="q1"></div><div class="q2">' . smiles(bb_code($a['xstatus'])) . '</div>' : '';
echo ($i ++ % 2) ? $div_tworazdel : $div_razdel;
echo nikus($a['id']) . $Status . $div_end;
}
echo $n->navi();
} else {
echo ''.$lang['Поиск не дал результатов'].'!<br/>';
}
echo $div_end;
break;
case view:
echo $div_title . ''.$lang['Знакомства'].'' . $div_end . $div_left . '
<img src="../ico/search.gif" alt=""/> <a href="index.php?lg='.$lg.'&'.$ref.'">'.$lang['Новый поиск'].'</a>' . $block;
if (isset($_SESSION['nikname'])) $nikname = trim(mysql_real_escape_string(check($_SESSION['nikname'])));
if (isset($_POST['nikname'])) $nikname = trim(mysql_real_escape_string(check($_POST['nikname'])));
$nikname = addcslashes($nikname, '_%');
$_SESSION['nikname'] = $nikname;
if (!ctype_digit($nikname)) {
$se = "`user` LIKE '%$nikname%'";
} else {
$nikname = my_int($nikname);
$se = "`id` = '$nikname'";
}
$look = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE $se"), 0);
$n = new navigator($look, 10, '?do=view&lg='.$lg.'&');
$view = mysql_query("SELECT * FROM `users` WHERE $se ORDER BY `id` DESC {$n->limit}");
if ($look != FALSE) {
$i = 0;
while($a = mysql_fetch_assoc($view)) {
echo ($i ++ % 2) ? $div_tworazdel : $div_razdel;
echo nik($a['id']) . $div_end;
}
echo $n->navi();
} else {
echo ''.$lang['Поиск не дал результатов'].'!<br/>';
}
echo $div_end;
break;
}
include '../foot.php';
?>