View file mag/art.php

<?php

echo '<div class="menu_razd">Артефакты</div>';


//////////////////////////////Протектор/////////////////////////////////////////
$o=@mysql_query("SELECT `id` FROM `shopp` WHERE user='$ank[nick]' &&  kateg='1'");
echo "<span class=\"status\">Протектор :</span><br/> ";
$qwq = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='1'");
$ss = mysql_fetch_array($qwq);
$page = intval(@$_GET['page']);
$start = intval(@$_GET['start']);
$onpage = 1;
$all = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM shopp WHERE user='$ank[nick]' &&  kateg='1'"));
$all = $all[0];
$pages = ceil($all/$onpage);
if(!$pages) $pages = 1;
if($page>$pages or
$page<=0) $page=1;
if($start>$all or $start<=0) $start = 0;
if($page) $start = ($page - 1) * $onpage; else $start = 0;
$res = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='1' ORDER BY id LIMIT $start,$onpage");
$rows = mysql_fetch_array($res);
if (mysql_affected_rows() != 0)
{
do
{
echo ''.htmlspecialchars(trim($rows['text'])).'<br/>';
}
while($rows = mysql_fetch_array($res));
}else{
echo "пусто<br/>";
}


//////////////////////////////Доспехи/////////////////////////////////////////
$o=@mysql_query("SELECT `id` FROM `shopp` WHERE user='$ank[nick]' &&  kateg='2'");
echo "<span class=\"status\">Доспехи :</span><br/> ";
$qwq = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='2'");
$ss = mysql_fetch_array($qwq);
$page = intval(@$_GET['page']);
$start = intval(@$_GET['start']);
$onpage = 1;
$all = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM shopp WHERE user='$ank[nick]' &&  kateg='2'"));
$all = $all[0];
$pages = ceil($all/$onpage);
if(!$pages) $pages = 1;
if($page>$pages or
$page<=0) $page=1;
if($start>$all or $start<=0) $start = 0;
if($page) $start = ($page - 1) * $onpage; else $start = 0;
$res = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='2' ORDER BY id LIMIT $start,$onpage");
$rows = mysql_fetch_array($res);
if (mysql_affected_rows() != 0)
{
do
{
echo ''.htmlspecialchars(trim($rows['text'])).'<br/>';
}
while($rows = mysql_fetch_array($res));
}else{
echo "пусто<br/>";
}


//////////////////////////////Плащ/////////////////////////////////////////
$o=@mysql_query("SELECT `id` FROM `shopp` WHERE user='$ank[nick]' &&  kateg='3'");
echo "<span class=\"status\">Плащ :</span><br/> ";
$qwq = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='3'");
$ss = mysql_fetch_array($qwq);
$page = intval(@$_GET['page']);
$start = intval(@$_GET['start']);
$onpage = 1;
$all = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM shopp WHERE user='$ank[nick]' &&  kateg='3'"));
$all = $all[0];
$pages = ceil($all/$onpage);
if(!$pages) $pages = 1;
if($page>$pages or
$page<=0) $page=1;
if($start>$all or $start<=0) $start = 0;
if($page) $start = ($page - 1) * $onpage; else $start = 0;
$res = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='3' ORDER BY id LIMIT $start,$onpage");
$rows = mysql_fetch_array($res);
if (mysql_affected_rows() != 0)
{
do
{
echo ''.htmlspecialchars(trim($rows['text'])).'<br/>';
}
while($rows = mysql_fetch_array($res));
}else{
echo "пусто<br/>";
}


//////////////////////////////Оружие1/////////////////////////////////////////
$o=@mysql_query("SELECT `id` FROM `shopp` WHERE user='$ank[nick]' &&  kateg='4'");
echo "<span class=\"status\">Оружие1 :</span><br/> ";
$qwq = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='4'");
$ss = mysql_fetch_array($qwq);
$page = intval(@$_GET['page']);
$start = intval(@$_GET['start']);
$onpage = 1;
$all = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM shopp WHERE user='$ank[nick]' &&  kateg='4'"));
$all = $all[0];
$pages = ceil($all/$onpage);
if(!$pages) $pages = 1;
if($page>$pages or $page<=0) $page=1;
if($start>$all or $start<=0) $start = 0;
if($page) $start = ($page - 1) * $onpage; else $start = 0;
$res = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='4' ORDER BY id LIMIT $start,$onpage");
$rows = mysql_fetch_array($res);
if (mysql_affected_rows() != 0)
{
do
{
echo ''.htmlspecialchars(trim($rows['text'])).'<br/>';
}
while($rows = mysql_fetch_array($res));
}else{
echo "пусто<br/>";
}


//////////////////////////////Оружие2/////////////////////////////////////////
$o=@mysql_query("SELECT `id` FROM `shopp` WHERE user='$ank[nick]' &&  kateg='5'");
echo "<span class=\"status\">Оружие2 :</span><br/> ";
$qwq = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='5'");
$ss = mysql_fetch_array($qwq);
$page = intval(@$_GET['page']);
$start = intval(@$_GET['start']);
$onpage = 1;
$all = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM shopp WHERE user='$ank[nick]' &&  kateg='5'"));
$all = $all[0];
$pages = ceil($all/$onpage);
if(!$pages) $pages = 1;
if($page>$pages or
$page<=0) $page=1;
if($start>$all or $start<=0) $start = 0;
if($page) $start = ($page - 1) * $onpage; else $start = 0;
$res = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='5' ORDER BY id LIMIT $start,$onpage");
$rows = mysql_fetch_array($res);
if (mysql_affected_rows() != 0)
{
do
{
echo ''.htmlspecialchars(trim($rows['text'])).'<br/>';
}
while($rows = mysql_fetch_array($res));
}else{
echo "пусто<br/>";
}


//////////////////////////////Аксесуар1/////////////////////////////////////////
$o=@mysql_query("SELECT `id` FROM `shopp` WHERE user='$ank[nick]' &&  kateg='6'");
echo "<span class=\"status\">Аксесуар1 :</span><br/> ";
$qwq = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='6'");
$ss = mysql_fetch_array($qwq);
$page = intval(@$_GET['page']);
$start = intval(@$_GET['start']);
$onpage = 1;
$all = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM shopp WHERE user='$ank[nick]' &&  kateg='6'"));
$all = $all[0];
$pages = ceil($all/$onpage);
if(!$pages) $pages = 1;
if($page>$pages or
$page<=0) $page=1;
if($start>$all or $start<=0) $start = 0;
if($page) $start = ($page - 1) * $onpage; else $start = 0;
$res = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='6' ORDER BY id LIMIT $start,$onpage");
$rows = mysql_fetch_array($res);
if (mysql_affected_rows() != 0)
{
do
{
echo ''.htmlspecialchars(trim($rows['text'])).'<br/>';
}
while($rows = mysql_fetch_array($res));
}else{
echo "пусто<br/>";
}


//////////////////////////////Аксесуар2/////////////////////////////////////////
$o=@mysql_query("SELECT `id` FROM `shopp` WHERE user='$ank[nick]' &&  kateg='7'");
echo "<span class=\"status\">Аксесуар2 :</span><br/> ";
$qwq = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='7'");
$ss = mysql_fetch_array($qwq);
$page = intval(@$_GET['page']);
$start = intval(@$_GET['start']);
$onpage = 1;
$all = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM shopp WHERE user='$ank[nick]' &&  kateg='7'"));
$all = $all[0];
$pages = ceil($all/$onpage);
if(!$pages) $pages = 1;
if($page>$pages or
$page<=0) $page=1;
if($start>$all or $start<=0) $start = 0;
if($page) $start = ($page - 1) * $onpage; else $start = 0;
$res = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='7' ORDER BY id LIMIT $start,$onpage");
$rows = mysql_fetch_array($res);
if (mysql_affected_rows() != 0)
{
do
{
echo ''.htmlspecialchars(trim($rows['text'])).'<br/>';
}
while($rows = mysql_fetch_array($res));
}else{
echo "пусто<br/>";
}


//////////////////////////////Амулет/////////////////////////////////////////
$o=@mysql_query("SELECT `id` FROM `shopp` WHERE user='$ank[nick]' &&  kateg='8'");
echo "<span class=\"status\">Амулет :</span><br/> ";
$qwq = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='8'");
$ss = mysql_fetch_array($qwq);
$page = intval(@$_GET['page']);
$start = intval(@$_GET['start']);
$onpage = 1;
$all = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM shopp WHERE user='$ank[nick]' &&  kateg='8'"));
$all = $all[0];
$pages = ceil($all/$onpage);
if(!$pages) $pages = 1;
if($page>$pages or
$page<=0) $page=1;
if($start>$all or $start<=0) $start = 0;
if($page) $start = ($page - 1) * $onpage; else $start = 0;
$res = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='8' ORDER BY id LIMIT $start,$onpage");
$rows = mysql_fetch_array($res);
if (mysql_affected_rows() != 0)
{
do
{
echo ''.htmlspecialchars(trim($rows['text'])).'<br/>';
}
while($rows = mysql_fetch_array($res));
}else{
echo "пусто<br/>";
}


//////////////////////////////Свиток/////////////////////////////////////////
$o=@mysql_query("SELECT `id` FROM `shopp` WHERE user='$ank[nick]' &&  kateg='9'");
echo "<span class=\"status\">Свиток :</span><br/> ";
$qwq = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='9'");
$ss = mysql_fetch_array($qwq);
$page = intval(@$_GET['page']);
$start = intval(@$_GET['start']);
$onpage = 1;
$all = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM shopp WHERE user='$ank[nick]' &&  kateg='9'"));
$all = $all[0];
$pages = ceil($all/$onpage);
if(!$pages) $pages = 1;
if($page>$pages or
$page<=0) $page=1;
if($start>$all or $start<=0) $start = 0;
if($page) $start = ($page - 1) * $onpage; else $start = 0;
$res = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='9' ORDER BY id LIMIT $start,$onpage");
$rows = mysql_fetch_array($res);
if (mysql_affected_rows() != 0)
{
do
{
echo ''.htmlspecialchars(trim($rows['text'])).'<br/>';
}
while($rows = mysql_fetch_array($res));
}else{
echo "пусто<br/>";
}


//////////////////////////////Печать/////////////////////////////////////////
$o=@mysql_query("SELECT `id` FROM `shopp` WHERE user='$ank[nick]' &&  kateg='10'");
echo "<span class=\"status\">Печать :</span><br/> ";
$qwq = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='10'");
$ss = mysql_fetch_array($qwq);
$page = intval(@$_GET['page']);
$start = intval(@$_GET['start']);
$onpage = 1;
$all = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM shopp WHERE user='$ank[nick]' &&  kateg='10'"));
$all = $all[0];
$pages = ceil($all/$onpage);
if(!$pages) $pages = 1;
if($page>$pages or
$page<=0) $page=1;
if($start>$all or $start<=0) $start = 0;
if($page) $start = ($page - 1) * $onpage; else $start = 0;
$res = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='10' ORDER BY id LIMIT $start,$onpage");
$rows = mysql_fetch_array($res);
if (mysql_affected_rows() != 0)
{
do
{
echo ''.htmlspecialchars(trim($rows['text'])).'<br/>';
}
while($rows = mysql_fetch_array($res));
}else{
echo "пусто<br/>";
}
//////////////////////////////Одежда/////////////////////////////////////////
$o=@mysql_query("SELECT `id` FROM `shopp` WHERE user='$ank[nick]' &&  kateg='11'");
echo "<span class=\"status\">Одежда :</span><br/> ";
$qwq = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='11'");
$ss = mysql_fetch_array($qwq);
$page = intval(@$_GET['page']);
$start = intval(@$_GET['start']);
$onpage = 1;
$all = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM shopp WHERE user='$ank[nick]' &&  kateg='11'"));
$all = $all[0];
$pages = ceil($all/$onpage);
if(!$pages) $pages = 1;
if($page>$pages or
$page<=0) $page=1;
if($start>$all or $start<=0) $start = 0;
if($page) $start = ($page - 1) * $onpage; else $start = 0;
$res = mysql_query("SELECT * FROM shopp WHERE user='$ank[nick]' &&  kateg='11' ORDER BY id LIMIT $start,$onpage");
$rows = mysql_fetch_array($res);
if (mysql_affected_rows() != 0)
{
do
{
echo ''.htmlspecialchars(trim($rows['text'])).'<br/>';
}
while($rows = mysql_fetch_array($res));
}else{
echo "пусто<br/>";
}
?>