Файл: item.php
Строк: 654
<?php
include ("niz/head.php");
include ("db_bse/bssest.php");
$g=mysql_query("SELECT * FROM `turaga_pers` WHERE `nick`='$nick' AND `pass`='$pass' LIMIT 1");
if(mysql_num_rows($g)==1){
include ("niz/verh.php");
switch($_GET[mod]){
default:
$weapon = mysql_result(mysql_query("SELECT COUNT(*) FROM turaga_item WHERE usr='$nick' and tip='weapon' and `image`='not'"),0);
$golova = mysql_result(mysql_query("SELECT COUNT(*) FROM turaga_item WHERE usr='$nick' and tip='golova' and `image`='not'"),0);
$shit = mysql_result(mysql_query("SELECT COUNT(*) FROM turaga_item WHERE usr='$nick' and tip='shit' and `image`='not'"),0);
$ruki = mysql_result(mysql_query("SELECT COUNT(*) FROM turaga_item WHERE usr='$nick' and tip='ryka' and `image`='not'"),0);
$nogi = mysql_result(mysql_query("SELECT COUNT(*) FROM turaga_item WHERE usr='$nick' and tip='nogi' and `image`='not'"),0);
$body = mysql_result(mysql_query("SELECT COUNT(*) FROM turaga_item WHERE usr='$nick' and tip='body' and `image`='not'"),0);
echo "<img src="pictures/icons/verhays.gif"> <a href="item.php?mod=item&o=weapon">Оружие</a> ($weapon)<br/>";
echo "<img src="pictures/icons/verhays.gif"> <a href="item.php?mod=itemgolova&o=golova">Маска</a> ($golova)<br/>";
echo "<img src="pictures/icons/verhays.gif"> <a href="item.php?mod=itemshit&o=shit">Щиты</a> ($shit)<br/>";
echo "<img src="pictures/icons/verhays.gif"> <a href="item.php?mod=itemruki&o=ryka">Перчатки</a> ($ruki)<br/>";
echo "<img src="pictures/icons/verhays.gif"> <a href="item.php?mod=itemnogi&o=nogi">Ботинки</a> ($nogi)<br/>";
echo "<img src="pictures/icons/verhays.gif"> <a href="item.php?mod=itembody&o=body">Шмотки</a> ($body)<br/>";
$elexir = mysql_result(mysql_query("SELECT COUNT(*) FROM turaga_res WHERE usr='$nick' and tip='elexir'"),0);
echo "<img src='/pictures/icons/elixir.png' alt='*'/><a href='/elik.php'> Эликсиры</a> ($elexir)<br>";
break;
case 'itemgolova':
if($_GET[o]!=golova){
echo'Ошибка!';
include ("niz/niz.php");
exit;
}
if(empty($startan)) $startan = 0;
$startan=intval($startan);
if($startan<0) $startan=0; $num_msgs_an=5;
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='$_GET[o]' and `image`='not' ORDER by `id` DESC LIMIT $startan,$num_msgs_an");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto>=1){
While($mag = mysql_fetch_array($req))
{
$w=explode("*",$mag[name]);
echo" <a href="item.php?mod=info&id=$mag[id]">[?]</a>
[<a href="inv_ok.php?tip=$_GET[o]&id=$mag[id]">$mag[name]</a>] [<a href="item.php?mod=dels&id=$mag[id]">Уничтожить</a>]<br/>";
}
$q = mysql_query("SELECT COUNT(`usr`) FROM `turaga_item` WHERE usr = '$nick' and `tip`='$_GET[o]'");
$kol = mysql_result($q, 0);
echo "- - -<br/>";
if($startan!= 0) $page2left = ' <a href= item.php?mod=itemgolova&o=golova&startan='. ($startan - 5) .'&page='.($page-1).'>'. ($page - 1) .'</a> | ';
if(empty($page)){$page=1;}
if($kol > $startan + 5) $page2right = ' | <a href= item.php?mod=itemgolova&o=golova&startan='. ($startan + 5) .'&page='. ($page+1) .'>'. ($page + 1) .'</a>';
echo $page2left.'<b>('.$page.')</b>'.$page1right.$page2right.'<br/>';
if ($startan != 0) {echo '<a href="item.php?mod=itemgolova&o=golova&startan='.($startan - 5).'&page='.($page-1).'">Назад</a> ';}
if ($kol > $startan + 5) {echo ' <a href="item.php?mod=itemgolova&o=golova&startan='.($startan + 5).'&page='.($page+1).'">Далее</a>';}
}else{
echo 'Нет вещей!';
}
break;
case 'item':
if($_GET[o]!=weapon){
echo'Ошибка!';
include ("niz/niz.php");
exit;
}
if(empty($startan)) $startan = 0;
$startan=intval($startan);
if($startan<0) $startan=0; $num_msgs_an=5;
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='$_GET[o]' and `image`='not' ORDER by `id` DESC LIMIT $startan,$num_msgs_an");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto>=1){
While($mag = mysql_fetch_array($req))
{
$w=explode("*",$mag[name]);
echo" <a href="item.php?mod=info&id=$mag[id]">[?]</a>
[<a href="inv_ok.php?tip=$_GET[o]&id=$mag[id]">$mag[name]</a>] [<a href="item.php?mod=dels&id=$mag[id]">Уничтожить</a>]<br/>";
}
$q = mysql_query("SELECT COUNT(`usr`) FROM `turaga_item` WHERE usr = '$nick' and `tip`='$_GET[o]'");
$kol = mysql_result($q, 0);
echo "- - -<br/>";
if($startan!= 0) $page2left = ' <a href= item.php?mod=item&o=weapon&startan='. ($startan - 5) .'&page='.($page-1).'>'. ($page - 1) .'</a> | ';
if(empty($page)){$page=1;}
if($kol > $startan + 5) $page2right = ' | <a href= item.php?mod=item&o=weapon&startan='. ($startan + 5) .'&page='. ($page+1) .'>'. ($page + 1) .'</a>';
echo $page2left.'<b>('.$page.')</b>'.$page1right.$page2right.'<br/>';
if ($startan != 0) {echo '<a href="item.php?mod=item&o=weapon&startan='.($startan - 5).'&page='.($page-1).'">Назад</a> ';}
if ($kol > $startan + 5) {echo ' <a href="item.php?mod=item&o=weapon&startan='.($startan + 5).'&page='.($page+1).'">Далее</a>';}
}else{
echo 'Нет вещей!';
}
break;
case 'itemshit':
if($_GET[o]!=shit){
echo'Ошибка!';
include ("niz/niz.php");
exit;
}
if(empty($startan)) $startan = 0;
$startan=intval($startan);
if($startan<0) $startan=0; $num_msgs_an=5;
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='$_GET[o]' and `image`='not' ORDER by `id` DESC LIMIT $startan,$num_msgs_an");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto>=1){
While($mag = mysql_fetch_array($req))
{
$w=explode("*",$mag[name]);
echo" <a href="item.php?mod=info&id=$mag[id]">[?]</a>
[<a href="inv_ok.php?tip=$_GET[o]&id=$mag[id]">$mag[name]</a>] [<a href="item.php?mod=dels&id=$mag[id]">Уничтожить</a>]<br/>";
}
$q = mysql_query("SELECT COUNT(`usr`) FROM `turaga_item` WHERE usr = '$nick' and `tip`='$_GET[o]'");
$kol = mysql_result($q, 0);
echo "- - -<br/>";
if($startan!= 0) $page2left = ' <a href= item.php?mod=itemshit&o=weapon&startan='. ($startan - 5) .'&page='.($page-1).'>'. ($page - 1) .'</a> | ';
if(empty($page)){$page=1;}
if($kol > $startan + 5) $page2right = ' | <a href= item.php?mod=itemshit&o=shit&startan='. ($startan + 5) .'&page='. ($page+1) .'>'. ($page + 1) .'</a>';
echo $page2left.'<b>('.$page.')</b>'.$page1right.$page2right.'<br/>';
if ($startan != 0) {echo '<a href="item.php?mod=itemshit&o=shit&startan='.($startan - 5).'&page='.($page-1).'">Назад</a> ';}
if ($kol > $startan + 5) {echo ' <a href="item.php?mod=itemshit&o=shit&startan='.($startan + 5).'&page='.($page+1).'">Далее</a>';}
}else{
echo 'Нет вещей!';
}
break;
case 'itemruki':
if($_GET[o]!=ryka){
echo'Ошибка!';
include ("niz/niz.php");
exit;
}
if(empty($startan)) $startan = 0;
$startan=intval($startan);
if($startan<0) $startan=0; $num_msgs_an=5;
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='$_GET[o]' and `image`='not' ORDER by `id` DESC LIMIT $startan,$num_msgs_an");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto>=1){
While($mag = mysql_fetch_array($req))
{
$w=explode("*",$mag[name]);
echo" <a href="item.php?mod=info&id=$mag[id]">[?]</a>
[<a href="inv_ok.php?tip=$_GET[o]&id=$mag[id]">$mag[name]</a>] [<a href="item.php?mod=dels&id=$mag[id]">Уничтожить</a>]<br/>";
}
$q = mysql_query("SELECT COUNT(`usr`) FROM `turaga_item` WHERE usr = '$nick' and `tip`='$_GET[o]'");
$kol = mysql_result($q, 0);
echo "- - -<br/>";
if($startan!= 0) $page2left = ' <a href= item.php?mod=itemruki&o=ryka&startan='. ($startan - 5) .'&page='.($page-1).'>'. ($page - 1) .'</a> | ';
if(empty($page)){$page=1;}
if($kol > $startan + 5) $page2right = ' | <a href= item.php?mod=itemruki&o=ryka&startan='. ($startan + 5) .'&page='. ($page+1) .'>'. ($page + 1) .'</a>';
echo $page2left.'<b>('.$page.')</b>'.$page1right.$page2right.'<br/>';
if ($startan != 0) {echo '<a href="item.php?mod=itemruki&o=ryka&startan='.($startan - 5).'&page='.($page-1).'">Назад</a> ';}
if ($kol > $startan + 5) {echo ' <a href="item.php?mod=itemruki&o=ryka&startan='.($startan + 5).'&page='.($page+1).'">Далее</a>';}
}else{
echo 'Нет вещей!';
}
break;
case 'itemnogi':
if($_GET[o]!=nogi){
echo'Ошибка!';
include ("niz/niz.php");
exit;
}
if(empty($startan)) $startan = 0;
$startan=intval($startan);
if($startan<0) $startan=0; $num_msgs_an=5;
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='$_GET[o]' and `image`='not' ORDER by `id` DESC LIMIT $startan,$num_msgs_an");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto>=1){
While($mag = mysql_fetch_array($req))
{
$w=explode("*",$mag[name]);
echo" <a href="item.php?mod=info&id=$mag[id]">[?]</a>
[<a href="inv_ok.php?tip=$_GET[o]&id=$mag[id]">$mag[name]</a>] [<a href="item.php?mod=dels&id=$mag[id]">Уничтожить</a>]<br/>";
}
$q = mysql_query("SELECT COUNT(`usr`) FROM `turaga_item` WHERE usr = '$nick' and `tip`='$_GET[o]'");
$kol = mysql_result($q, 0);
echo "- - -<br/>";
if($startan!= 0) $page2left = ' <a href= item.php?mod=itemnogi&o=nogi&startan='. ($startan - 5) .'&page='.($page-1).'>'. ($page - 1) .'</a> | ';
if(empty($page)){$page=1;}
if($kol > $startan + 5) $page2right = ' | <a href= item.php?mod=itemnogi&o=nogi&startan='. ($startan + 5) .'&page='. ($page+1) .'>'. ($page + 1) .'</a>';
echo $page2left.'<b>('.$page.')</b>'.$page1right.$page2right.'<br/>';
if ($startan != 0) {echo '<a href="item.php?mod=itemnogi&o=nogi&startan='.($startan - 5).'&page='.($page-1).'">Назад</a> ';}
if ($kol > $startan + 5) {echo ' <a href="item.php?mod=itemnogi&o=nogi&startan='.($startan + 5).'&page='.($page+1).'">Далее</a>';}
}else{
echo 'Нет вещей!';
}
break;
case 'itembody':
if($_GET[o]!=body){
echo'Ошибка!';
include ("niz/niz.php");
exit;
}
if(empty($startan)) $startan = 0;
$startan=intval($startan);
if($startan<0) $startan=0; $num_msgs_an=5;
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='$_GET[o]' and `image`='not' ORDER by `id` DESC LIMIT $startan,$num_msgs_an");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto>=1){
While($mag = mysql_fetch_array($req))
{
$w=explode("*",$mag[name]);
echo" <a href="item.php?mod=info&id=$mag[id]">[?]</a>
[<a href="inv_ok.php?tip=$_GET[o]&id=$mag[id]">$mag[name]</a>] [<a href="item.php?mod=dels&id=$mag[id]">Уничтожить</a>]<br/>";
}
$q = mysql_query("SELECT COUNT(`usr`) FROM `turaga_item` WHERE usr = '$nick' and `tip`='$_GET[o]'");
$kol = mysql_result($q, 0);
echo "- - -<br/>";
if($startan!= 0) $page2left = ' <a href= item.php?mod=itembody&o=body&startan='. ($startan - 5) .'&page='.($page-1).'>'. ($page - 1) .'</a> | ';
if(empty($page)){$page=1;}
if($kol > $startan + 5) $page2right = ' | <a href= item.php?mod=itembody&o=body&startan='. ($startan + 5) .'&page='. ($page+1) .'>'. ($page + 1) .'</a>';
echo $page2left.'<b>('.$page.')</b>'.$page1right.$page2right.'<br/>';
if ($startan != 0) {echo '<a href="item.php?mod=itembody&o=body&startan='.($startan - 5).'&page='.($page-1).'">Назад</a> ';}
if ($kol > $startan + 5) {echo ' <a href="item.php?mod=itembody&o=body&startan='.($startan + 5).'&page='.($page+1).'">Далее</a>';}
}else{
echo 'Нет вещей!';
}
break;
case 'dels':
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `image`='not' and `id`='".mysql_real_escape_string($_GET['id'])."'");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto==1){
$item = mysql_fetch_array($req);
echo "Вы уверены что хотите уничтожить <b>$item[name]</b>?<br>";
echo" <a href="item.php?mod=dels2&id=".mysql_real_escape_string($_GET[id])."" method="post"> Да</a>/<a href="item.php?"> Нет</a>";
}
break;
case 'dels2':
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `image` = 'not' and `usr` = '$nick' and `id`='".mysql_real_escape_string($_GET['id'])."'");
$avto=mysql_num_rows($req);
if($avto==0){
echo'У вас нет данной вещи.';
echo "<br><br>» <a href="item.php?"> Вернуться</a>";
include ("niz/niz.php");
exit;
}
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `image`='not' and `id`='".mysql_real_escape_string($_GET['id'])."'");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto==1){
$item = mysql_fetch_array($req);
mysql_query("DELETE FROM `turaga_item` WHERE `usr` = '$nick' and `id`='".mysql_real_escape_string($_GET['id'])."' ");
echo "Вещь <b>$item[name]</b> уничтожена!</a>";
echo "<br><br>» <a href="item.php?"> Вернуться</a>";
}
break;
case 'info':
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `id`='".mysql_real_escape_string($_GET['id'])."'");
$avto=mysql_num_rows($req);
if($avto==0){
echo'Ошибка!';
include ("niz/niz.php");
exit;
}
$mag = mysql_fetch_array($req);
echo"<b>$mag[name]</b><br/>";
$w=explode("*",$mag[name]);
echo"<img src="pictures/inventar/$w[0].gif" height=32 width=32><br/>";
echo"Атака любым оружием: <font color='IndianRed1'>+$mag[atak]</font><br/>";
echo"Увеличивает макс. здоровье: <font color='IndianRed1'>+$mag[hp]</font><br/>";
echo"<font color='IndianRed1'>Требования уровня мастерства:</font><br/>";
echo"Петя Верстак: <font color='IndianRed1'>$mag[petya]</font> <img src='/pictures/icons/crisha.gif' alt='*'/><br/>
Яша в поле дым: <font color='IndianRed1'>$mag[yasha]</font> <img src='/pictures/icons/crisha.gif' alt='*'/><br/>
Нинка золотая ручка: <font color='IndianRed1'>$mag[nina]</font> <img src='/pictures/icons/crisha.gif' alt='*'/>
";
echo '<div class="bts"></div>';
echo "<img src="pictures/icons/zon.png"> <a href="item.php?mod=splaw&id=$mag[id]">Сплавить на </a>($udacha <img src='/pictures/icons/siga.gif' alt='*'/>)";
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
break;
case 'splaw':
$req = mysql_query("SELECT `name`,`atak` FROM `turaga_item` WHERE `image` = 'not' and `usr` = '$nick' and `id`='".mysql_real_escape_string($_GET['id'])."'");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto=="0"){
echo'Ошибка!';
include ("niz/niz.php");
exit;
}
$item = mysql_fetch_array($req);
echo "Вы уверены что хотите cплавить <b>$item[name]</b> на ($udacha <img src='/pictures/icons/siga.gif' alt='*'/>)?<br>";
echo" <a href="item.php?mod=splaw2&id=".mysql_real_escape_string($_GET[id])."" method="post"> Да</a>/<a href="item.php?"> Нет</a>";
break;
case 'splaw2':
$req = mysql_query("SELECT `name`,`atak` FROM `turaga_item` WHERE `image` = 'not' and `usr` = '$nick' and `id`='".mysql_real_escape_string($_GET['id'])."'");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto=="0"){
echo'Ошибка!';
include ("niz/niz.php");
exit;
}
$item = mysql_fetch_array($req);
mysql_query("UPDATE `turaga_pers` SET `siga`= `siga`+ '$udacha' WHERE `nick`='$nick'");
echo "Вещь: <b>$item[name]</b> сплавлена на ($udacha <img src='/pictures/icons/siga.gif' alt='*'/>)</a>";
mysql_query("DELETE FROM `turaga_item` WHERE `usr` = '$nick' and `id`='".mysql_real_escape_string($_GET['id'])."' ");
echo "<br><br>» <a href="item.php?"> Вернуться</a>";
break;
case 'weapon':
if(empty($_GET[id])){
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='weapon' and `image`='yes'");
}else{
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='weapon' and `image`='yes' and `id`='".mysql_real_escape_string($_GET['id'])."'");
}
$avto=mysql_num_rows($req);
if($avto==0){
header ("Location: item.php?mod=ekip");
include ("niz/niz.php");
exit;
}
$mag = mysql_fetch_array($req);
$numax=$ataka-$mag[atak];
$nem=$hp2s-$mag[hp];
mysql_query("UPDATE `turaga_pers` SET
`ataka` = '$numax',
`hp2s` = '$nem'
WHERE nick = '$nick'");
if(empty($_GET[id])){
mysql_query("UPDATE turaga_item SET image = 'not' WHERE `usr` = '$nick' and `tip`='weapon' and `image`='yes'");
}else{
mysql_query("UPDATE turaga_item SET image = 'not' WHERE `usr` = '$nick' and `tip`='weapon' and `image`='yes' and `id`='".mysql_real_escape_string($_GET['id'])."'");
}
header ("Location: item.php?mod=ekip");
break;
case 'golova':
if(empty($_GET[id])){
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='golova' and `image`='yes'");
}else{
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='golova' and `image`='yes' and `id`='".mysql_real_escape_string($_GET['id'])."'");
}
$avto=mysql_num_rows($req);
if($avto==0){
header ("Location: item.php?mod=ekip");
include ("niz/niz.php");
exit;
}
$mag = mysql_fetch_array($req);
$numax=$ataka-$mag[atak];
$nem=$hp2s-$mag[hp];
mysql_query("UPDATE `turaga_pers` SET
`ataka` = '$numax',
`hp2s` = '$nem'
WHERE nick = '$nick'");
if(empty($_GET[id])){
mysql_query("UPDATE turaga_item SET image = 'not' WHERE `usr` = '$nick' and `tip`='golova' and `image`='yes'");
}else{
mysql_query("UPDATE turaga_item SET image = 'not' WHERE `usr` = '$nick' and `tip`='golova' and `image`='yes' and `id`='".mysql_real_escape_string($_GET['id'])."'");
}
header ("Location: item.php?mod=ekip");
break;
case 'shit':
if(empty($_GET[id])){
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='shit' and `image`='yes'");
}else{
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='shit' and `image`='yes' and `id`='".mysql_real_escape_string($_GET['id'])."'");
}
$avto=mysql_num_rows($req);
if($avto==0){
header ("Location: item.php?mod=ekip");
include ("niz/niz.php");
exit;
}
$mag = mysql_fetch_array($req);
$numax=$ataka-$mag[atak];
$nem=$hp2s-$mag[hp];
mysql_query("UPDATE `turaga_pers` SET
`ataka` = '$numax',
`hp2s` = '$nem'
WHERE nick = '$nick'");
if(empty($_GET[id])){
mysql_query("UPDATE turaga_item SET image = 'not' WHERE `usr` = '$nick' and `tip`='shit' and `image`='yes'");
}else{
mysql_query("UPDATE turaga_item SET image = 'not' WHERE `usr` = '$nick' and `tip`='shit' and `image`='yes' and `id`='".mysql_real_escape_string($_GET['id'])."'");
}
header ("Location: item.php?mod=ekip");
break;
case 'ryka':
if(empty($_GET[id])){
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='ryka' and `image`='yes'");
}else{
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='ryka' and `image`='yes' and `id`='".mysql_real_escape_string($_GET['id'])."'");
}
$avto=mysql_num_rows($req);
if($avto==0){
header ("Location: item.php?mod=ekip");
include ("niz/niz.php");
exit;
}
$mag = mysql_fetch_array($req);
$numax=$ataka-$mag[atak];
$nem=$hp2s-$mag[hp];
mysql_query("UPDATE `turaga_pers` SET
`ataka` = '$numax',
`hp2s` = '$nem'
WHERE nick = '$nick'");
if(empty($_GET[id])){
mysql_query("UPDATE turaga_item SET image = 'not' WHERE `usr` = '$nick' and `tip`='ryka' and `image`='yes'");
}else{
mysql_query("UPDATE turaga_item SET image = 'not' WHERE `usr` = '$nick' and `tip`='ryka' and `image`='yes' and `id`='".mysql_real_escape_string($_GET['id'])."'");
}
header ("Location: item.php?mod=ekip");
break;
case 'boot':
if(empty($_GET[id])){
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='nogi' and `image`='yes'");
}else{
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='nogi' and `image`='yes' and `id`='".mysql_real_escape_string($_GET['id'])."'");
}
$avto=mysql_num_rows($req);
if($avto==0){
header ("Location: item.php?mod=ekip");
include ("niz/niz.php");
exit;
}
$mag = mysql_fetch_array($req);
$numax=$ataka-$mag[atak];
$nem=$hp2s-$mag[hp];
mysql_query("UPDATE `turaga_pers` SET
`ataka` = '$numax',
`hp2s` = '$nem'
WHERE nick = '$nick'");
if(empty($_GET[id])){
mysql_query("UPDATE turaga_item SET image = 'not' WHERE `usr` = '$nick' and `tip`='nogi' and `image`='yes'");
}else{
mysql_query("UPDATE turaga_item SET image = 'not' WHERE `usr` = '$nick' and `tip`='nogi' and `image`='yes' and `id`='".mysql_real_escape_string($_GET['id'])."'");
}
header ("Location: item.php?mod=ekip");
break;
case 'body':
if(empty($_GET[id])){
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='body' and `image`='yes'");
}else{
$req = mysql_query("SELECT * FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='body' and `image`='yes' and `id`='".mysql_real_escape_string($_GET['id'])."'");
}
$avto=mysql_num_rows($req);
if($avto==0){
header ("Location: item.php?mod=ekip");
include ("niz/niz.php");
exit;
}
$mag = mysql_fetch_array($req);
$numax=$ataka-$mag[atak];
$nem=$hp2s-$mag[hp];
mysql_query("UPDATE `turaga_pers` SET
`ataka` = '$numax',
`hp2s` = '$nem'
WHERE nick = '$nick'");
if(empty($_GET[id])){
mysql_query("UPDATE turaga_item SET image = 'not' WHERE `usr` = '$nick' and `tip`='body' and `image`='yes'");
}else{
mysql_query("UPDATE turaga_item SET image = 'not' WHERE `usr` = '$nick' and `tip`='body' and `image`='yes' and `id`='".mysql_real_escape_string($_GET['id'])."'");
}
header ("Location: item.php?mod=ekip");
break;
case 'ekip':
$req = mysql_query("SELECT id,name FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='golova' and `image`='yes'");
$avto=mysql_num_rows($req);
if($avto==0){
echo"<img src="pictures/pusto/no.jpg" height=32 width=32> Маска: <u>не одето</u>";
}else{
$mag = mysql_fetch_array($req);
$w=explode("*",$mag[name]);
echo"<img src="pictures/inventar/$w[0].gif" height=32 width=32> <a href="item.php?mod=golova">$mag[name]</a>";
}
$req = mysql_query("SELECT id,name FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='weapon' and `image`='yes'");
$avto=mysql_num_rows($req);
if($avto==0){
echo"<br><img src="pictures/pusto/no.jpg" height=32 width=32> Оружие: <u>не одето</u>";
}else{
$mag = mysql_fetch_array($req);
$w=explode("*",$mag[name]);
echo"<br/> <img src="pictures/inventar/$w[0].gif" height=32 width=32> <a href="item.php?mod=weapon">$mag[name]</a>";
}
$req = mysql_query("SELECT id,name FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='shit' and `image`='yes'");
$avto=mysql_num_rows($req);
if($avto==0){
echo"<br><img src="pictures/pusto/no.jpg" height=32 width=32> Щит: <u>не одето</u>";
}else{
$mag = mysql_fetch_array($req);
$w=explode("*",$mag[name]);
echo"<br/> <img src="pictures/inventar/$w[0].gif" height=32 width=32> <a href="item.php?mod=shit">$mag[name]</a>";
}
$req = mysql_query("SELECT id,name FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='ryka' and `image`='yes'");
$avto=mysql_num_rows($req);
if($avto==0){
echo"<br><img src="pictures/pusto/no.jpg" height=32 width=32> Перчатки: <u>не одето</u>";
}else{
$mag = mysql_fetch_array($req);
$w=explode("*",$mag[name]);
echo"<br/> <img src="pictures/inventar/$w[0].gif" height=32 width=32> <a href="item.php?mod=ryka">$mag[name]</a>";
}
$req = mysql_query("SELECT id,name FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='nogi' and `image`='yes'");
$avto=mysql_num_rows($req);
if($avto==0){
echo"<br><img src="pictures/pusto/no.jpg" height=32 width=32> Ботинки: <u>не одето</u>";
}else{
$mag = mysql_fetch_array($req);
$w=explode("*",$mag[name]);
echo"<br/> <img src="pictures/inventar/$w[0].gif" height=32 width=32> <a href="item.php?mod=boot">$mag[name]</a>";
}
$req = mysql_query("SELECT id,name FROM `turaga_item` WHERE `usr` = '$nick' and `tip`='body' and `image`='yes'");
$avto=mysql_num_rows($req);
if($avto==0){
echo"<br><img src="pictures/pusto/no.jpg" height=32 width=32> Доспехи: <u>не одето</u>";
}else{
$mag = mysql_fetch_array($req);
$w=explode("*",$mag[name]);
echo"<br/> <img src="pictures/inventar/$w[0].gif" height=32 width=32> <a href="item.php?mod=body">$mag[name]</a>";
}
}
}else{
echo "Пройдите авторизацию!";
echo "<hr><a href="index.php">На главную</a>";
}
include ("niz/niz.php");
?>