Файл: data/rukzak0.dat.php
Строк: 123
<?
print '<div class="spiski"><div class="zagolovok">Рюкзак</div><div class="line"></div><ul>';
if (isset($_POST['formselect1']))
{
include "./phpfile/alhimik.php" ;
exitt($row, $opredelenie) ;
}
if(isset($_POST['stroka']))
{$search=$_POST['stroka'];
$search = substr($search, 0, 25);
print"<li>Поиск:</li>";
$query = "SELECT * FROM rukzak WHERE nazvanie LIKE '%".mysql_real_escape_string($search). "%'
and name='" . mysql_real_escape_string($opredelenie) .
"' AND odeto='0' ";
/////////////////////////////////////////////////////
$sql = mysql_query($query) ;
$n = mysql_num_rows($sql) ;
if ($n == 0)
{
print "<div class="style_mess_no">Ни чего не найдено!</div>" ;
exitt($row, $opredelenie) ;
}
$ii = 0 ;
print "<form name=form1 action=88.php?go=rukzak method=post>" ;
while ($row = mysql_fetch_assoc($sql))
{
$ii++ ;
if ($row['odeto'] !== '1')
{
echo "
<li> <input class=x_radio type=radio name=sex value=" . htmlspecialchars($row['idrukzak']) . " >" .
htmlspecialchars($row['nazvanie']) . " <a href=88.php?go=info&info=" .
htmlspecialchars($row['idrukzak']) . ">[info]</a>
</li>" ;
}
}
print "<div class="chat_conteiner">
<select class=x_option name=formselect1 size=1>
<option value=odet>Одеть</option>
<option value=del>Выбросить</option>
<option value=ver>Переместить</option>
</select></p>
<input type=submit class=select value=ok>
</form></div>" ;
exitt($row,$opredelenie);
/////////////////////////////////////////////////////////////////
;}else{
$queryl0 = "SELECT*
FROM `rukzak` where `name`='" . mysql_real_escape_string($opredelenie) .
"' AND `odeto`='0'" ;
$sqll0 = mysql_query($queryl0) or die(mysql_error()) ;
$num_rows = mysql_num_rows($sqll0) ;
$ru = $row['lvl'] + 99+$pers_info['rukzak'] ;
print "<li>В вашем рюкзаке $num_rows вещей из $ru возможных!<br>Ваши вещи:</li>" ;
$nums = 42 ;
if (isset($_GET['page']))
{
htmlspecialchars($_GET['page']) ;
$page = intval($_GET['page']) ;
}
else
{
$page = 1 ;
}
$query = "SELECT COUNT(*) AS `counter`
FROM `rukzak` where `name`='" . mysql_real_escape_string($opredelenie) .
"' AND `odeto`='0'" ;
$sql = mysql_query($query) or die(mysql_error()) ;
$row = mysql_fetch_assoc($sql) ;
$elements = $row['counter'] ;
$pages = ceil($elements / $nums) ;
if ($page < 1)
{
$page = 1 ;
} elseif ($page > $pages)
{
$page = $pages ;
}
$start = ($page - 1) * $nums ;
$ku="";
if(isset($_GET['kup'])){
$mk=mysql_real_escape_string($_GET['kup']);
$ku="and `chit`='$mk'";}
// когда у нас в таблице нет записей
if ($start < 0) $start = 0 ;
$query = "SELECT *
FROM `rukzak`WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"' AND `odeto`='0' $ku ORDER BY `time` DESC
LIMIT " . mysql_real_escape_string($start) . ", " .
mysql_real_escape_string($nums) . "" ;
$sql = mysql_query($query) or die(mysql_error()) ;
$n = mysql_num_rows($sql) ;
if ($n == 0)
{
print "<div class="style_mess_no">Ваш рюкзак пуст!</div>" ;
exitt($row, $opredelenie) ;
}
$ii = 0 ;
print "<form name=form1 action=88.php?go=rukzak method=post>" ;
while ($row = mysql_fetch_assoc($sql))
{
$ii++ ;
if ($row['odeto'] !== '1')
{
echo "
<li><input class=x_radio type=radio name=sex value=" . htmlspecialchars($row['idrukzak']) . " >" .
htmlspecialchars($row['nazvanie']) . " <a href=88.php?go=info&info=" .
htmlspecialchars($row['idrukzak']) . ">[info]</a>
</li>" ;
}
}
print "<div class="chat_conteiner">
<select class=x_option name=formselect1 size=1>
<option value=odet>Одеть</option>
<option value=ver>Переместить</option>
<option value=otkr>Открыть</option>
</select></p>
<input type=submit class=select value=ok>
</form></div>" ;
echo'<li>';
// далее нам надо прицепить листалку
$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)
{
print ' <a href="?go=rukzak&page=1">начало</a> ... <a href="?go=rukzak&page=' . ($page -
1) . '"><сюда</a> ' ;
}
for ($i = $left_neighbour; $i <= $right_neighbour; $i++)
{
if ($i != $page)
{
print ' <a href="?go=rukzak&page=' . $i . '">' . $i . '</a> ' ;
}
else
{
// выбранная страница
print ' <b>' . $i . '</b> ' ;
}
}
if ($page < $pages)
{
print ' <a href="?go=rukzak&page=' . ($page + 1) .
'">туда></a> ... <a href="?go=rukzak&page=' . $pages . '">конец</a> ' ;
}
echo'</li>';
$QUERY_STRING=$_SERVER['QUERY_STRING'];
print "<div class="chat_conteiner"><a href=88.php?" . $QUERY_STRING ."&kup=or>Оружие</a>|
<a href=88.php?" . $QUERY_STRING ."&kup=dos>Доспехи</a>|
<a href=88.php?" . $QUERY_STRING ."&kup=shit>Щиты</a>|
<a href=88.php?" . $QUERY_STRING ."&kup=sapogi>Сапоги</a>|
<a href=88.php?" . $QUERY_STRING ."&kup=shapka>Шапки</a>|
<a href=88.php?" . $QUERY_STRING ."&kup=plash>Плащи</a>|
<a href=88.php?" . $QUERY_STRING ."&kup=perchi>Перчатки</a>|
<a href=88.php?" . $QUERY_STRING ."&kup=el>Эли</a>|
<a href=88.php?" . $QUERY_STRING ."&kup=trava>Трава</a>|
<a href=88.php?" . $QUERY_STRING ."&kup=metal>Руда</a>|
<a href=88.php?" . $QUERY_STRING ."&kup=kolco>Кольца</a>|
<a href=88.php?" . $QUERY_STRING ."&kup=braslet>Браслеты</a>|
<a href=88.php?" . $QUERY_STRING ."&kup=amulet>Амулеты</a>|
<a href=88.php?" . $QUERY_STRING ."&kup=chasi>Часы</a>|
<a href=88.php?" . $QUERY_STRING ."&kup=sh>Шкуры</a>|
<a href=88.php?" . $QUERY_STRING ."&kup=gem>Гемы</a>|
<a href=88.php?" . $QUERY_STRING ."&kup=ruda>Рудная порода</a>|
<a href=88.php?" . $QUERY_STRING ."&kup=kard>Куски карт</a>|
</div>";
echo'<br><div class="chat_conteiner"><li>Поиск</li><form action=88.php?go=rukzak&poisk name="some" method=post>
<input type=text class=x_textsmall name="stroka"><br>
<input type=submit class=select value=Поиск>
</form></div>';
exitt($row,$opredelenie);
;}
?>