| Код | <?
$clan = $_POST['s_clan']; $clans_search = $_POST['clans_search']; $nick = $_POST['s_nick']; $s_clan = array(); $clan_tmp = explode(',', $clan); foreach($clan_tmp as $cl) $s_clan[] = "'".trim($cl)."'"; $s_nick = array(); $nick_tmp = explode(',', $nick); foreach($nick_tmp as $nk) $s_nick[] = "'".trim($nk)."'";
echo "<table width=100%><tr>"; echo "<form method='post' action='/?do=locator'>"; echo "<tr class=pole1><td>ник:<input class=pole1 name=s_nick value='$nick'></td></tr>"; echo "<tr class=pole1><td> клану: <select name=clans_search class=clans_search>"; echo "<option value='1'"; if($clan==1){echo " selected";} echo ">любой</option>"; $res_clans=$db->query("select distinct clan from main where clan<>'' and clan<>'0' order by clan"); while ($clans=$db->get_row($res_clans)) { $clans = $clans['clan']; echo "<option value='$clans'"; if($clans==$clan){echo " selected";} echo ">$clans</option>"; } echo "<tr class=pole1><td>Несколько кланов*:<input class=pole1 name=s_clan value='$clan'></td></tr>"; echo "<tr class=pole1><td><b>Профессия</b><select class=pole1 name=prof> <option value=''>Выберите проффесию</option> <option value='88' ".(($prof =='88') ? 'selected' : '').">Без проффесии</option> <option value='1' ".(($prof == 1) ? 'selected' : '').">Корсар</option> <option value='2' ".(($prof == 2) ? 'selected' : '').">Сталкер</option> <option value='3' ".(($prof == 3) ? 'selected' : '').">Старатель</option> <option value='4' ".(($prof == 4) ? 'selected' : '').">Инженер</option> <option value='5' ".(($prof == 5) ? 'selected' : '').">Наемник</option> <option value='6' ".(($prof == 6) ? 'selected' : '').">Торговец</option> <option value='7' ".(($prof == 7) ? 'selected' : '').">Полицейский.Патрульный</option> <option value='8' ".(($prof == 8) ? 'selected' : '').">Полицейский.Штурмовик</option> <option value='9' ".(($prof == 9) ? 'selected' : '').">Полицейский.Специалист</option> <option value='10' ".(($prof == 10) ? 'selected' : '').">Журналист</option> <option value='11' ".(($prof == 11) ? 'selected' : '').">Чиновник</option> <option value='12' ".(($prof == 12) ? 'selected' : '').">Псионик</option> <option value='13' ".(($prof == 13) ? 'selected' : '').">Каторжник</option> <option value='14' ".(($prof == 14) ? 'selected' : '').">Пси-кинетик</option> <option value='15' ".(($prof == 15) ? 'selected' : '').">Пси-медиум</option> <option value='16' ".(($prof == 16) ? 'selected' : '').">Пси-лидер</option> <option value='26' ".(($prof == 26) ? 'selected' : '').">Грузовой робот</option> <option value='27' ".(($prof == 27) ? 'selected' : '').">Десантный робот</option> <option value='28' ".(($prof == 28) ? 'selected' : '').">Боевой робот</option> <option value='30' ".(($prof == 30) ? 'selected' : '').">Дилер</option> </select> </td></tr>"; echo "<tr><td colspan=2><input type=submit value='Применить' class=pole1></form></td>"; echo "</tr></table>"; echo "<table width='100%' border='0' cellspacing='0' cellpadding='0' >"; echo "<tbody><tr><td><b>Ник</b></td><td><b>Локация</b></td><td><b>Время</b></td><td><b>Профа</b></td></tr>"; echo "SELECT * from main where clan IN (". implode(',', $s_clan) .") OR nik IN (". implode(',', $s_nick) .") OR clan='$clans_search'"; $GoNext = "?do=locator&num_page=rrrec$filter"; if($_GET['page'] > 0 and $_GET['page'] <= 1000){ $page= $_GET['page'];}else{$page= 1;} $nums = 100; $start = ($page + 1) * $nums - $nums * 2; $result = $db->query("SELECT * from main where clan IN (". implode(',', $s_clan) .") OR nik IN (". implode(',', $s_nick) .") OR clan='$clans_search' LIMIT $start, $nums"); while ($row = $db->get_row($result)) { $nik=nick_bl2($row['nik'],$row['clan'],$row['level'],$row['prof'],$row['rang']); $profa = $row['prof']; $profa=str_replace("i2","Сталкер",$profa); $profa=str_replace("i3","Старатель",$profa); $location = $row['location']; $location=str_replace("Oasis","Оазис",$location); $time = $row['time']; if(time() - $time < 5) { $time = "<font color=green><b>Сейчас.</b></font>"; } elseif((time() - $time) < 60) { $time = "<font color=green><b>".(time() - $time)." секунд(ы) назад.</b></font>"; } elseif((time() - $line['time']) >= 60 and (time() - $time) < 900) { $time = "<font color=green><b>".ceil((time() - $time)/60)." минут(ы) назад.</b></font>"; } elseif(date("d", $time) == date("d", time())) { $time = "Сегодня в ".date("G:i:s", $time); } else { $time = date("d.m.Y G:i:s", $time); } echo "<tr><td>$nik</td><td>$time</td><td>$location</td><td>$profa</td></tr> "; } echo '</table>'; $query= "SELECT COUNT(*) from main where clan IN (". implode(',', $s_clan) .") OR nik IN (". implode(',', $s_nick) .") OR clan='$clans_search'"; $rez = $db->query($query);// посылаем запрос базе данных $kol = $db->get_row($rez); $elements = $kol['COUNT(*)']; $pages = ceil($elements/$nums); if ($page < 1) { $page = 1; } elseif ($page > $pages) { $page = $pages; } //$pages = 4; $neighbours = 6; $left_neighbour = $page - $neighbours; if ($left_neighbour < 1) $left_neighbour = 1; $right_neighbour = $page + $neighbours; if ($right_neighbour > $pages) $right_neighbour = $pages; if ($page > 1) { $nav.= ' <a href="?do=locator&page=1">начало</a> ... <a href="?do=locator&page=' . ($page-1) . '"><сюда</a> '; } for ($i=$left_neighbour; $i<=$right_neighbour; $i++) { if ($i != $page) { $nav.= ' <a href="?do=locator&page=' . $i . '">' . $i . '</a> '; } else { // выбранная страница $nav.= ' <b>' . $i . '</b> '; } } if ($page < $pages) { $nav.= ' <a href="?do=locator&page=' . ($page+1) . '">туда></a> ... <a href="?do=locator&page=' . $pages . '">конец</a> '; } echo $nav; ?>
|
почему то не сохраняют Post запросы когда переходишь на 2 страницу,подскажите в чем может быть проблема? |