<?session_start();?>
<!DOCTYPE html PUBLIC "-//WAPFORUM//DTD XHTML Mobile 1.0//EN" "http://www.wapforum.org/DTD/xhtml-mobile10.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ru">
<head><meta http-equiv='content-type' content='application/xhtml+xml; charset=windows-1251'/>
<link rel="shortcut icon" href="ico1.ico" type="image/x-icon" />
<title>Инвентарь</title>
<link rel="stylesheet" href="styleN.css" type="text/css" />
</head>
<body>
<div class="inf">
<?
$d=date("H:i");
$p = $_GET['p'];
$key = $_GET['key'];
$no = $_GET['no'];
$to = $_GET['to'];
$NICK = $_GET['NICK'];
$pass = $_GET['pass'];
$menu = $_GET['menu'];
$use = $_GET['use'];
$c = $_GET['c'];
$u = $_GET['u'];
$sc = $_GET['sc'];
$d = $_GET['d'];
$p = @intval($_GET['p']);
$idT = $_GET['idT'];
$desc = $_GET['desc'];
$del = $_GET['del'];
$slot = $_GET['slot'];
$drp = $_GET['drp'];
$s=$_GET['s'];
//айпи игроков
$ip = $_SERVER['REMOTE_ADDR'];
$t = time();
include("db.php");
$db->openDB();
$vremya = time();
$nnick=mysql_query("SELECT * FROM users WHERE NICK=\"$_SESSION[s]\"");
$nnick2=mysql_fetch_assoc($nnick);
if($vremya-$nnick2[gametime]>600){
echo"</div>";
include ("accaunt.php");
$AC->ACCAUNT();//Проверка Аккаунта
}
@include('effects.php');
$inv = mysql_query("SET NAMES cp1251");
$inv=mysql_query("SELECT * FROM inv WHERE ID_USERS=\"$_SESSION[s]\" AND IL_NO='0' AND ID_IL=\"$idT\"");
while($inv2=mysql_fetch_assoc($inv)){
if($inv2[IL_MIN_PROCH]<1 AND $menu == '1' AND $use!= 'i.arrow' AND !isset($drp) AND !isset($slot) ){
echo"<div class=\"top\" style=\"text-align:center\"><a href=\"inv.php\">
<b>
<font color=\"#FFE7BA\">в инвентарь</font></a>
</div>
<div class=\"main\">"."<div class=\"menu\" style=\"border:1px dotted\"><li><a href=\"inv.php\"><img src=\"img/inv.png\" width=\"24\" height=\"24\"> в инвентарь</a></li></div><center><font color=\"#A23232\">невозможно одеть сломанную вещь!</font></center>"."";
include("footer.php");
die;}}
$items = mysql_query("SET NAMES cp1251");
$items=mysql_query("SELECT * FROM inv WHERE ID_USERS='$_SESSION[s]' AND IL_VREME=\"0\"");
$items2 = mysql_query("SET NAMES cp1251");
$items2=mysql_query("SELECT * FROM inv WHERE ID_USERS='$_SESSION[s]' AND IL_NO=\"0\" AND NEVE!='1'");
$items_ves = mysql_query("SET NAMES cp1251");
$items_ves=mysql_query("SELECT * FROM users WHERE NICK='$_SESSION[s]'");
$items_count_ss = mysql_query("SET NAMES cp1251");
$items_count_ss=mysql_query("SELECT * FROM inv WHERE ID_USERS='$_SESSION[s]' AND IL_NO=\"0\"");
$items_count_sss=mysql_num_rows($items_count_ss);
$c_items=mysql_num_rows($items2);
$items_ves2 = mysql_fetch_assoc($items_ves);
// Переменная хранит число сообщений выводимых на станице
$num = 10;
// Извлекаем из URL текущую страницу
$page = $_GET['page'];
// Определяем общее число сообщений в базе данных
$result = mysql_query("SELECT COUNT(*) FROM inv WHERE ID_USERS=\"$_SESSION[s]\" AND IL_NO=\"0\"");
$posts = mysql_result($result, 0);
// Находим общее число страниц
$total = intval(($posts - 1) / $num) + 1;
// Определяем начало сообщений для текущей страницы
$page = intval($page);
// Если значение $page меньше единицы или отрицательно
// переходим на первую страницу
// А если слишком большое, то переходим на последнюю
if(empty($page) or $page < 0) $page = 1;
if($page > $total) $page = $total;
// Вычисляем начиная к какого номера
// следует выводить сообщения
$start = $page * $num - $num;
// Выбираем $num сообщений начиная с номера $start
$result = mysql_query("SET NAMES cp1251");
$result = mysql_query("SELECT * FROM inv WHERE ID_USERS=\"$_SESSION[s]\" AND IL_NO=\"0\" LIMIT $start, $num");
// В цикле переносим результаты запроса в массив $postrow
while ( $postrow[] = mysql_fetch_array($result))
?>
<style type="text/css">
body,td,th {
color: #000000;
}
</style>
</head>
<body>
<table width="450" height="182" align="center">
<tr>
<td width="348" height="34" align="center" bgcolor="#a23232"><b><font color="#FFE7BA">Инвентарь</font></b>
</td>
</tr>
<tr>
<td width="348" height="20" align="left" valign="top" bgcolor="#FFE7BA">
<div class="menu">
<li><a href="game.php"><b><font color="#a23232"><img src="img/attck.png" /> В игру</font></b></a></li></div>
</td>
</tr>
<tr>
<td width="348" height="20" bgcolor="#FFE7BA" align="left">
<div class="menu"><li><a href="pers.php"><b><font color="#a23232"><img src="img/grup.png" /> Персонаж</font></b></a></li></div>
</td>
</tr>
<tr>
<td width="348" height="20" bgcolor="#FFE7BA" align="left">
<div class="menu"><li><a href="equip.php"><b><font color="#a23232"><img src="img/helm.png" /> Снаряжение</font></b></a></li></div>
</td>
</tr>
<tr>
<td width="348" height="20" bgcolor="#a23232" align="Center"><b><font color="#FFE7BA">Предметы <?echo" <font color=\"#FFE7BA\"> ($c_items/$items_ves2[MAX_VES])";?>
</font></b>
</td>
</tr>
<tr>
<td width="348" height="10" align="center" valign="middle" bgcolor="#FFE7BA">
<font color="#a23232"><B>
<a href="pr">Все</a>|
<a href="pr">оружие</a>|
<a href="pr">Бижутерия</a>|
<a href="pr">Броня</a>|
<a href="pr">Зелья</a>|
<a href="pr">Расходное</a>
</font></B></td></tr>
<tr>
<td width="348" height="31" align="left" valign="middle" bgcolor="#FFE7BA">
<?
$trsm = time();
$inv_msg = mysql_query("SELECT * FROM inv_msg WHERE NICK=\"$_SESSION[s]\"");
$inv_msg2 = mysql_fetch_assoc($inv_msg);
if($inv_msg2[TIME]-$trsm>0){echo "
<div style=\"border 2px dotted;background:#a23232\">
<center>
<b>
<font color=\"#FFE7BA\">
$inv_msg2[TEXT]
</font>
</b>
</center></div>
</div>
";
$delinvm = mysql_query("DELETE FROM inv_msg WHERE NICK=\"$_SESSION[s]\"");
}
if(isset($drp)){
$del_it=mysql_query("SELECT * FROM inv WHERE ID_IL=\"$idT\"");
if(mysql_num_rows($del_it)>0){echo "
<div style=\"border 2px dotted;background:#a23232\">
<center>
<b>
<font color=\"#FFE7BA\">
вы действительно хотите уничтожить этот предмет?
</font>
</b>
</center></div>
<div class=\"menu\">
<li><a href=\"inv.php?drp=$aItems[IL_KEY]&idT=$idT&del=1\"><img src=\"img/success.png\" width=\"18\" height=\"18\"> ДА</a></li>
<li><a href=\"inv.php\"><img src=\"img/bad.png\" width=\"18\" height=\"18\"> НЕТ</a></li>
</div>
</div>
";
if($del==1){
while($del_it2=mysql_fetch_assoc($del_it)){
echo'<br/><font color="red">предмет '.$del_it2[IL_NAME].' уничтожен</font>';
$delITm=mysql_query("DELETE FROM inv WHERE ID_IL=\"$idT\" AND ID_USERS=\"$_SESSION[s]\"");}
//если предмета больше 1 ,то просим ввести количество
print('<SCRIPT>location.href="inv.php";</SCRIPT>');
}}
}
$ItemsName=$aItems['IL_NAME'];
$ItemsNo=$aItems['IL_NO'];
$src=$aItems['SRC'];
//если кол-во предметов равно 0 ,то удаляем вещь из инвентаря
$delete_items=mysql_query("DELETE FROM inv WHERE IL_COUNT='0'");
//$items23=mysql_query("SELECT * FROM inv WHERE ID_USERS='$_SESSION[s]'");
//$count_items=mysql_num_rows($items23[IL_COUNT]);echo $count_items;echo $NICK;
?>
<?
for($i = 0; $i < $num; $i++)
{
echo"";
$resc = mysql_num_rows($result);
if($i<$resc){
$io = $postrow[$i]['ID_IL'];
$src = $postrow[$i]['IL_IMAGE'];
echo "<div style=\"border:1px dotted\"><div class=\"menu\"><li><a href=\"inv.php?p=0&idT=$io&page=$page\"><img src=\"$src\" width=\"42\" height=\"42\" alt=\"+\">
<b><font color=\"#a23232\">".$postrow[$i]['IL_NAME'].' ('.$postrow[$i]['IL_COUNT']." шт.)</a> </div></font></b>";
if($ItemsNo==0){
$odev = mysql_query("SELECT * FROM inv WHERE ID_USERS=\"$_SESSION[s]\" AND ID_IL=\"$idT\" LIMIT 1");
while($odev2 = mysql_fetch_assoc($odev)){
if($p == 0 AND $idT == $io){
if($odev2[IL_ALL_CLASS] == 'armor' OR $odev2[IL_ALL_CLASS] == 'weapon' OR $odev2[IL_SUBCLASS] == 'streli' AND $i<$resc){echo"
<div style=\"padding:5px\"><b>
<a href=\"inv.php?menu=1&use=$odev2[IL_KEY]&c=$odev2[IL_CLASS]&u=$odev2[IL_ALL_CLASS]&sc=$odev2[IL_SUBCLASS]&p=$p&idT=$odev2[ID_IL]&page=$page\">ОДЕТЬ</a>
| <a href=\"game.php?li=$odev2[IL_KEY]&idT=$odev2[ID_IL]&page=$page\">ИНФО</a> |
<a href=\"inv.php?drp&idT=$odev2[ID_IL]&page=$page\">ВЫБРОСИТЬ</a></b></div>";}
if($odev2[IL_ALL_CLASS] != 'armor' OR $odev2[IL_ALL_CLASS] != 'weapon' OR $odev2[IL_SUBCLASS] != 'streli' AND $i<$resc){echo"
<div style=\"padding:5px\"><b>
<a href=\"game.php?li=$odev2[IL_KEY]&idT=$odev2[ID_IL]&page=$page\">ИНФО</a> |
<a href=\"inv.php?drp&idT=$odev2[ID_IL]&page=$page\">ВЫБРОСИТЬ</a></b></div>";}
}
}
echo"</div>";
}
}
if(mysql_num_rows($result)<1 AND $i<1){echo"<div style=\"background:#a23232;height:30px;padding-bottom:0px\">
<center><b><font color=\"#FFE7BA\"><div style=\"padding:6px\">У вас нет не одного предмета</div></font></b></center></div>";}
}
?>
</b></font>
</td>
</tr>
<tr>
<td width="348" height="10" align="center" valign="middle" bgcolor="#FFE7BA">
<b><font color="#a23232">
<?
// Проверяем нужны ли стрелки назад
if ($page != 1) $pervpage = '<a href= ./inv.php?page=1><<</a>
<a href= ./inv.php?page='. ($page - 1) .'><</a> ';
// Проверяем нужны ли стрелки вперед
if ($page != $total) $nextpage = ' <a href= ./inv.php?page='. ($page + 1) .'>></a>
<a href= ./inv.php?page=' .$total. '>>></a>';
// Находим две ближайшие станицы с обоих краев, если они есть
if($page - 2 > 0) $page2left = ' <a href= ./inv.php?page='. ($page - 2) .'>'. ($page - 2) .'</a> | ';
if($page - 1 > 0) $page1left = '<a href= ./inv.php?page='. ($page - 1) .'>'. ($page - 1) .'</a> | ';
if($page + 2 <= $total) $page2right = ' | <a href= ./inv.php?page='. ($page + 2) .'>'. ($page + 2) .'</a>';
if($page + 1 <= $total) $page1right = ' | <a href= ./inv.php?page='. ($page + 1) .'>'. ($page + 1) .'</a>';
// Вывод меню
echo $pervpage.$page2left.$page1left.'<b>'.$page.'</b>'.$page1right.$page2right.$nextpage;
?>
</font></b></td></tr>
<tr><td width="348" height="31" align="left" valign="middle" bgcolor="#FFE7BA"
<?
include("footer.php");
@include("refresh.php");
?>
</td></tr>
</table>
<?
if($u=='weapon' AND isset($u))
{
#лучник
#жрец
#ассасин
#страж
#воин
#маг
#рыцарь тьмы
#некромант
$weapon_lvl = mysql_query("SET NAMES cp1251");
$weapon_lvl=mysql_query("SELECT * FROM users,inv WHERE ID_USERS='$_SESSION[s]' AND ID_IL='$idT'");
while(@$weapon_lvl2=mysql_fetch_assoc($weapon_lvl)){
//include("skills/parametrs2.php");
$weaponsC=mysql_query("SELECT * FROM inv WHERE IL_NO='1' AND ID_USERS='$_SESSION[s]'");
//если оружие такого типа уже одета то пишем что оружие данного типа уже одето :=)
$counts_equip = mysql_query("SET NAMES cp1251");
$counts_equip_weapons=mysql_query("SELECT * FROM inv WHERE ID_USERS='$_SESSION[s]' AND IL_NO=1");
$counts_equip=mysql_num_rows($counts_equip_weapons);
//баг при одевании вещей
$counts_equip_weapons2=mysql_fetch_assoc($counts_equip_weapons);
$usersD = mysql_query("SET NAMES cp1251");
$usersD=mysql_query("SELECT * FROM users WHERE NICK='$_SESSION[s]'");
$usersD2=mysql_fetch_assoc($usersD);
$DMGmin=$usersD2[DAMAGEmin]-$counts_equip_weapons2[IL_MIN_DMG];
$DMGmax=$usersD2[DAMAGEmax]-$counts_equip_weapons2[IL_MAX_DMG];
$weapon_DMG=mysql_query("SELECT * FROM inv WHERE ID_USERS='$_SESSION[s]' AND ID_IL='$idT'");
$weapon_DMG2=mysql_fetch_assoc($weapon_DMG);
$DMGmin2=round($weapon_DMG2[IL_MIN_DMG]+round($usersD2[SKILL_DEX]/5));
$DMGmax2=round($weapon_DMG2[IL_MAX_DMG]+round($usersD2[SKILL_DEX]/5));
$DMGmin3=round($weapon_DMG2[IL_MIN_DMG]+round($usersD2[SKILL_STR]/5));
$DMGmax4=round($weapon_DMG2[IL_MAX_DMG]+round($usersD2[SKILL_STR]/5));
$DMGmin5=round($weapon_DMG2[IL_MAGD_MIN]+round($usersD2[SKILL_INT]/5));
$DMGmax6=round($weapon_DMG2[IL_MAGD_MAX]+round($usersD2[SKILL_INT]/5));
if($usersD2[LVL_USERS]<$weapon_DMG2[IL_LVL]){
$uspr = mysql_query("SELECT * FROM users WHERE NICK=\"$_SESSION[s]\"");
$uspr2 = mysql_fetch_assoc($uspr);
$tism = time()+222;
$insms = mysql_query("INSERT INTO inv_msg (NICK,TEXT,TIME) VALUES ('$_SESSION[s]','Ваш уровень слишком мал чтобы носить это!','$tism')");
print('<SCRIPT>location.href="inv.php";</SCRIPT>');
die;}
if($weapon_DMG2[IL_STR]>$usersD2[SKILL_STR] OR $weapon_DMG2[IL_DEX]>$usersD2[SKILL_DEX] OR $weapon_DMG2[IL_INT]>$usersD2[SKILL_INT]){
if($weapon_DMG2[IL_STR]>$usersD2[SKILL_STR]){echo"<center><div class=\"main title\">не хватает силы!</div></center><br/>";}
if($weapon_DMG2[IL_DEX]>$usersD2[SKILL_DEX]){echo"<center><div class=\"main title\">не хватает ловкости!</div></center><br/>";}
if($weapon_DMG2[IL_INT]>$usersD2[SKILL_INT]){echo"<center><div class=\"main title\">не хватает интеллекта!</div></center>";}
die;}
//echo $DMGmin2.$DMGmax2;die;
//$usersD2=mysql_fetch_assoc($usersD)
$weapon_pr=mysql_query("SELECT * FROM inv WHERE IL_NO='1' AND IL_ALL_CLASS=\"weapon\" AND ID_USERS=\"$_SESSION[s]\"");
if($c!='legs' AND $c!='sapogi' AND $c!='naruchi' AND $c!='armor' AND $c!='plechi' AND $c!='helmet' AND $c!='shield' AND $c!='amulet' AND $c!='ring' AND $c!='braslet')
{
if(mysql_num_rows($weapon_pr)<1 ){
include("skills/bow.php");//точность для лука
include("skills/posox.php");//точность для посоха
include("skills/swords.php");//точность для меча
include("skills/use.php");}
print('<SCRIPT>location.href="inv.php";</SCRIPT>');
}
}
if($counts_equip>0 AND $counts_equip<2){
$db->openDB();
$pr_weapon = mysql_query("SET NAMES cp1251");
$pr_weapon=mysql_query("SELECT * FROM inv WHERE ID_IL=\"$idT\"");
while($pr_weapon2=mysql_fetch_assoc($pr_weapon))
{
$pr_weapon3 = mysql_query("SET NAMES cp1251");
$pr_weapon3=mysql_query("SELECT * FROM users WHERE NICK=\"$_SESSION[s]\"");
while($pr_weapon4=mysql_fetch_assoc($pr_weapon3))
{
if($pr_weapon2[IL_LVL]>$pr_weapon4[LVL_USERS]){echo"уровень слишком низок чтобы носить это!";die;}
}
}
//$weapon_query_o=mysql_query("UPDATE inv SET IL_NO='0' WHERE IL_NO=1");
//$weapon_query_o=mysql_query("UPDATE inv SET IL_NO='1' WHERE IL_KEY='$use' AND ID_IL=\"$idT\"");
print('<SCRIPT>location.href="inv.php";</SCRIPT>');
}
//создаем запрос на одевание оружия
//$db->openDB();
//$weapon_lvl=mysql_query("SELECT * FROM users,inv WHERE NICK='$_SESSION[s]' AND IL_KEY='$use'");
//while($weapon_lvl2=mysql_fetch_assoc($weapon_lvl)){
//if($weapon_lvl2[LVL_USERS]<$weapon_lvl2[IL_LVL]){echo"<div style='border:2px dotted;border-color:red;'>
//ваш уровень слишком низок чтобы носить это!";die;}
//else
//$dmgmin=$weapon_lvl[DAMAGEmin]+$weapon_lvl[MIN_DMG];
// $dmgmax=$weapon_lvl[DAMAGEmax]+$weapon_lvl[MAX_DMG];
//include("skills/str2.php");
//}
}
//одевание вещей
if($c=='helmet')
{
//создаем запрос на одевание шлема
$counts_equip_helmet=mysql_query("SELECT * FROM inv WHERE IL_CLASS='helmet' AND ID_USERS='$_SESSION[s]' AND IL_NO=1");
//переодеваем шлем снимаем старый,одеваем новый
if(mysql_num_rows($counts_equip_helmet)>0){
$counts_equip_helmet21=mysql_fetch_assoc($counts_equip_helmet);
$usDEF=mysql_query("SELECT * FROM users WHERE NICK=\"$_SESSION[s]\"");
$usDEF2=mysql_fetch_assoc($usDEF);
$defIT=mysql_query("SELECT * FROM inv WHERE ID_IL=\"$idT\" AND IL_CLASS='helmet' AND ID_USERS='$_SESSION[s]'");
$defIT2=mysql_fetch_assoc($defIT);
if(mysql_num_rows($counts_equip_helmet)>0){$pluDEF=$usDEF2[DEFENCE]-$counts_equip_helmet21[IL_DEF]+$defIT2[IL_DEF];}
$allDEF=$usDEF2[DEFENCE]-$defIT2[IL_DEF];
$counts_equip_helmet99=mysql_query("UPDATE users SET DEFENCE=\"$allDEF\" WHERE NICK=\"$_SESSION[s]\"");
if(mysql_num_rows($counts_equip_helmet)>0){$counts_equip_helmet33=mysql_query("UPDATE users SET DEFENCE=\"$pluDEF\" WHERE NICK=\"$_SESSION[s]\"");}
if(mysql_num_rows($defIT)>0){$counts_equip_helmet2=mysql_query("UPDATE inv SET IL_NO=\"0\" WHERE IL_CLASS='helmet' AND IL_NO=1 AND ID_USERS='$_SESSION[s]'");}
$counts_equip_helmet3=mysql_query("UPDATE inv SET IL_NO=\"1\" WHERE ID_IL=\"$idT\" AND IL_CLASS='helmet' AND ID_USERS='$_SESSION[s]'");
}
$DEF=mysql_query("SELECT * FROM inv WHERE ID_IL=\"$idT\" AND IL_KEY='$use'");
while($DEF2=mysql_fetch_assoc($DEF)){
$DDEF=$DEF2[IL_DEF];
}
$users=mysql_query("SELECT * FROM users WHERE NICK=\"$_SESSION[s]\"");
$users2=mysql_fetch_assoc($users);
$DEF_H=$users2[DEFENCE]+$DDEF;
$defITg=mysql_query("SELECT * FROM inv WHERE ID_IL=\"$idT\" AND IL_CLASS='helmet' AND IL_NO='1' AND ID_USERS='$_SESSION[s]'");
if(mysql_num_rows($defITg)<1){
$helmet_DEF=mysql_query("UPDATE users SET DEFENCE=\"$DEF_H\" WHERE NICK=\"$_SESSION[s]\"");
}
$helmet_query_o=mysql_query("UPDATE inv SET IL_NO='1' WHERE ID_IL=\"$idT\" AND IL_KEY='$use'");
print('<SCRIPT>location.href="inv.php";</SCRIPT>');
}
if($c=='amulet')
{
//создаем запрос на одевание амулета
$amulet_query_o=mysql_query("UPDATE inv SET IL_NO='1' WHERE IL_KEY='$use'");
print('<SCRIPT>location.href="inv.php";</SCRIPT>');
}
if($c=='armor')
{
//создаем запрос на одевание доспеха
$counts_equip_armor=mysql_query("SELECT * FROM inv WHERE IL_CLASS='armor' AND ID_USERS='$_SESSION[s]' AND IL_NO=1");
//переодеваем доспех снимаем старый,одеваем новый
if(mysql_num_rows($counts_equip_armor)>0){
$counts_equip_armor21=mysql_fetch_assoc($counts_equip_armor);
$usDEF=mysql_query("SELECT * FROM users WHERE NICK=\"$_SESSION[s]\"");
$usDEF2=mysql_fetch_assoc($usDEF);
$defIT=mysql_query("SELECT * FROM inv WHERE ID_IL=\"$idT\" AND IL_CLASS='armor' AND ID_USERS='$_SESSION[s]'");
$defIT2=mysql_fetch_assoc($defIT);
if(mysql_num_rows($counts_equip_armor)>0){$pluDEF=$usDEF2[DEFENCE]-$counts_equip_armor21[IL_DEF]+$defIT2[IL_DEF];}
$allDEF=$usDEF2[DEFENCE]-$defIT2[IL_DEF];
$counts_equip_armor99=mysql_query("UPDATE users SET DEFENCE=\"$allDEF\" WHERE NICK=\"$_SESSION[s]\"");
if(mysql_num_rows($counts_equip_armor)>0){$counts_equip_armor33=mysql_query("UPDATE users SET DEFENCE=\"$pluDEF\" WHERE NICK=\"$_SESSION[s]\"");}
if(mysql_num_rows($defIT)>0){$counts_equip_helmet2=mysql_query("UPDATE inv SET IL_NO=\"0\" WHERE IL_CLASS='armor' AND IL_NO=1 AND ID_USERS='$_SESSION[s]'");}
$counts_equip_armor3=mysql_query("UPDATE inv SET IL_NO=\"1\" WHERE ID_IL=\"$idT\" AND IL_CLASS='armor' AND ID_USERS='$_SESSION[s]'");
}
$DEF=mysql_query("SELECT * FROM inv WHERE ID_IL=\"$idT\" AND IL_KEY='$use'");
while($DEF2=mysql_fetch_assoc($DEF)){
$DDEF=$DEF2[IL_DEF];
}
$users=mysql_query("SELECT * FROM users WHERE NICK=\"$_SESSION[s]\"");
$users2=mysql_fetch_assoc($users);
$DEF_H=$users2[DEFENCE]+$DDEF;
$defITg=mysql_query("SELECT * FROM inv WHERE ID_IL=\"$idT\" AND IL_CLASS='armor' AND IL_NO='1' AND ID_USERS='$_SESSION[s]'");
if(mysql_num_rows($defITg)<1){$armor_DEF=mysql_query("UPDATE users SET DEFENCE=\"$DEF_H\" WHERE NICK=\"$_SESSION[s]\"");}
$armor_query_o=mysql_query("UPDATE inv SET IL_NO='1' WHERE ID_IL=\"$idT\" AND IL_KEY='$use'");
print('<SCRIPT>location.href="inv.php";</SCRIPT>');
}
if($c=='naruchi')
{
//создаем запрос на одевание наручи
$counts_equip_naruchi=mysql_query("SELECT * FROM inv WHERE IL_CLASS='naruchi' AND ID_USERS='$_SESSION[s]' AND IL_NO=1");
//переодеваем шлем снимаем старый,одеваем новый
if(mysql_num_rows($counts_equip_naruchi)>0){
$counts_equip_naruchi21=mysql_fetch_assoc($counts_equip_naruchi);
$usDEF=mysql_query("SELECT * FROM users WHERE NICK=\"$_SESSION[s]\"");
$usDEF2=mysql_fetch_assoc($usDEF);
$defIT=mysql_query("SELECT * FROM inv WHERE ID_IL=\"$idT\" AND IL_CLASS='naruchi' AND ID_USERS='$_SESSION[s]'");
$defIT2=mysql_fetch_assoc($defIT);
if(mysql_num_rows($counts_equip_naruchi)>0){$pluDEF=$usDEF2[DEFENCE]-$counts_equip_naruchi21[IL_DEF]+$defIT2[IL_DEF];}
$allDEF=$usDEF2[DEFENCE]-$defIT2[IL_DEF];
$counts_equip_naruchi99=mysql_query("UPDATE users SET DEFENCE=\"$allDEF\" WHERE NICK=\"$_SESSION[s]\"");
if(mysql_num_rows($counts_equip_naruchi)>0){$counts_equip_naruchit33=mysql_query("UPDATE users SET DEFENCE=\"$pluDEF\" WHERE NICK=\"$_SESSION[s]\"");}
if(mysql_num_rows($defIT)>0){$counts_equip_naruchi2=mysql_query("UPDATE inv SET IL_NO=\"0\" WHERE IL_CLASS='naruchi' AND IL_NO=1 AND ID_USERS='$_SESSION[s]'");}
$counts_equip_naruchi3=mysql_query("UPDATE inv SET IL_NO=\"1\" WHERE ID_IL=\"$idT\" AND IL_CLASS='naruchi' AND ID_USERS='$_SESSION[s]'");
}
$DEF=mysql_query("SELECT * FROM inv WHERE ID_IL=\"$idT\" AND IL_KEY='$use'");
while($DEF2=mysql_fetch_assoc($DEF)){
$DDEF=$DEF2[IL_DEF];
}
$users=mysql_query("SELECT * FROM users WHERE NICK=\"$_SESSION[s]\"");
$users2=mysql_fetch_assoc($users);
$DEF_H2=$users2[DEFENCE]+$DDEF;
$defITg=mysql_query("SELECT * FROM inv WHERE ID_IL=\"$idT\" AND IL_CLASS='naruchi' AND IL_NO='1' AND ID_USERS='$_SESSION[s]'");
if(mysql_num_rows($defITg)<1){$naruchi_DEF=mysql_query("UPDATE users SET DEFENCE=\"$DEF_H2\" WHERE NICK=\"$_SESSION[s]\"");
$naruchi_query_o=mysql_query("UPDATE inv SET IL_NO='1' WHERE ID_IL=\"$idT\" AND IL_KEY='$use'");}
print('<SCRIPT>location.href="inv.php";</SCRIPT>');
}
if($c=='legs')
{
//создаем запрос на одевание поножи
$counts_equip_legs=mysql_query("SELECT * FROM inv WHERE IL_CLASS='legs' AND ID_USERS='$_SESSION[s]' AND IL_NO=1");
//переодеваем шлем снимаем старый,одеваем новый
if(mysql_num_rows($counts_equip_legs)>0){
$counts_equip_legs21=mysql_fetch_assoc($counts_equip_legs);
$usDEF=mysql_query("SELECT * FROM users WHERE NICK=\"$_SESSION[s]\"");
$usDEF2=mysql_fetch_assoc($usDEF);
$defIT=mysql_query("SELECT * FROM inv WHERE ID_IL=\"$idT\" AND IL_CLASS='legs' AND ID_USERS='$_SESSION[s]'");
$defIT2=mysql_fetch_assoc($defIT);
if(mysql_num_rows($counts_equip_legs)>0){$pluDEF=$usDEF2[DEFENCE]-$counts_equip_legs21[IL_DEF]+$defIT2[IL_DEF];}
$allDEF=$usDEF2[DEFENCE]-$defIT2[IL_DEF];
$counts_equip_legs99=mysql_query("UPDATE users SET DEFENCE=\"$allDEF\" WHERE NICK=\"$_SESSION[s]\"");
if(mysql_num_rows($counts_equip_legs)>0){$counts_equip_legs33=mysql_query("UPDATE users SET DEFENCE=\"$pluDEF\" WHERE NICK=\"$_SESSION[s]\"");}
if(mysql_num_rows($defIT)>0){$counts_equip_legs2=mysql_query("UPDATE inv SET IL_NO=\"0\" WHERE IL_CLASS='legs' AND IL_NO=1 AND ID_USERS='$_SESSION[s]'");}
$counts_equip_legs3=mysql_query("UPDATE inv SET IL_NO=\"1\" WHERE ID_IL=\"$idT\" AND IL_CLASS='legs' AND ID_USERS='$_SESSION[s]'");
}
$DEF=mysql_query("SELECT * FROM inv WHERE ID_IL=\"$idT\" AND IL_KEY='$use'");
while($DEF2=mysql_fetch_assoc($DEF)){
$DDEF=$DEF2[IL_DEF];
}
$users=mysql_query("SELECT * FROM users WHERE NICK=\"$_SESSION[s]\"");
$users2=mysql_fetch_assoc($users);
$DEF_H=$users2[DEFENCE]+$DDEF;
$defITg=mysql_query("SELECT * FROM inv WHERE ID_IL=\"$idT\" AND IL_CLASS='legs' AND IL_NO='1' AND ID_USERS='$_SESSION[s]'");
if(mysql_num_rows($defITg)<1){$legs_DEF=mysql_query("UPDATE users SET DEFENCE=\"$DEF_H\" WHERE NICK=\"$_SESSION[s]\"");}
$legs_query_o=mysql_query("UPDATE inv SET IL_NO='1' WHERE ID_IL=\"$idT\" AND IL_KEY='$use'");
print('<SCRIPT>location.href="inv.php";</SCRIPT>');
}
if($c=='sapogi')
{
//создаем запрос на одевание сапоги
$counts_equip_sapogi=mysql_query("SELECT * FROM inv WHERE IL_CLASS='sapogi' AND ID_USERS='$_SESSION[s]' AND IL_NO=1");
//переодеваем шлем снимаем старый,одеваем новый
if(mysql_num_rows($counts_equip_sapogi)>0){
$counts_equip_sapogi21=mysql_fetch_assoc($counts_equip_sapogi);
$usDEF=mysql_query("SELECT * FROM users WHERE NICK=\"$_SESSION[s]\"");
$usDEF2=mysql_fetch_assoc($usDEF);
$defIT=mysql_query("SELECT * FROM inv WHERE ID_IL=\"$idT\" AND IL_CLASS='sapogi' AND ID_USERS='$_SESSION[s]'");
$defIT2=mysql_fetch_assoc($defIT);
if(mysql_num_rows($counts_equip_sapogi)>0){$pluDEF=$usDEF2[DEFENCE]-$counts_equip_sapogi21[IL_DEF]+$defIT2[IL_DEF];}
$allDEF=$usDEF2[DEFENCE]-$defIT2[IL_DEF];
$counts_equip_sapogi99=mysql_query("UPDATE users SET DEFENCE=\"$allDEF\" WHERE NICK=\"$_SESSION[s]\"");
if(mysql_num_rows($counts_equip_sapogi)>0){$counts_equip_sapogi33=mysql_query("UPDATE users SET DEFENCE=\"$pluDEF\" WHERE NICK=\"$_SESSION[s]\"");}
if(mysql_num_rows($defIT)>0){$counts_equip_sapogi2=mysql_query("UPDATE inv SET IL_NO=\"0\" WHERE IL_CLASS='sapogi' AND IL_NO=1 AND ID_USERS='$_SESSION[s]'");}
$counts_equip_sapogi3=mysql_query("UPDATE inv SET IL_NO=\"1\" WHERE ID_IL=\"$idT\" AND IL_CLASS='sapogi' AND ID_USERS='$_SESSION[s]'");
}
$DEF=mysql_query("SELECT * FROM inv WHERE ID_IL=\"$idT\" AND IL_KEY='$use'");
while($DEF2=mysql_fetch_assoc($DEF)){
$DDEF=$DEF2[IL_DEF];
}
$users=mysql_query("SELECT * FROM users WHERE NICK=\"$_SESSION[s]\"");
$users2=mysql_fetch_assoc($users);
$DEF_H=$users2[DEFENCE]+$DDEF;
$defITg=mysql_query("SELECT * FROM inv WHERE ID_IL=\"$idT\" AND IL_CLASS='sapogi' AND IL_NO='1' AND ID_USERS='$_SESSION[s]'");
if(mysql_num_rows($defITg)<1){
$sapogi_DEF=mysql_query("UPDATE users SET DEFENCE=\"$DEF_H\" WHERE NICK=\"$_SESSION[s]\"");
$sapogi_query_o=mysql_query("UPDATE inv SET IL_NO='1' WHERE ID_IL=\"$idT\" AND IL_KEY='$use'");
}
print('<SCRIPT>location.href="inv.php";</SCRIPT>');
}
if($c=='ringl')
{
//создаем запрос на одевание кольцо
$ring_query_o=mysql_query("UPDATE inv SET IL_NO='1' WHERE IL_KEY='$use'");
print('<SCRIPT>location.href="inv.php";</SCRIPT>');
}
if($c=='ringr')
{
//создаем запрос на одевание кольцо
$ring_query_o=mysql_query("UPDATE inv SET IL_NO='1' WHERE IL_KEY='$use'");
print('<SCRIPT>location.href="inv.php";</SCRIPT>');
}
if($c=='shield')
{
$uspr = mysql_query("SELECT * FROM users WHERE NICK=\"$_SESSION[s]\"");
$uspr2 = mysql_fetch_assoc($uspr);
if($uspr2[class_pers] != 4){
$tism = time()+2;
$insms = mysql_query("INSERT INTO inv_msg (NICK,TEXT,TIME) VALUES ('$_SESSION[s]','данная вещь не подходит вам по классу!','$tism')");
print('<SCRIPT>location.href="inv.php";</SCRIPT>');die;
}
//создаем запрос на одевание щита
$ring_query_o=mysql_query("UPDATE inv SET IL_NO='1' WHERE IL_KEY='$use'");
print('<SCRIPT>location.href="inv.php";</SCRIPT>');
}
if($c=='rasxodnoe')
{
//создаем запрос на одевание кольцо
$ring_query_o=mysql_query("UPDATE inv SET IL_NO='1' WHERE IL_KEY='$use'");
print('<SCRIPT>location.href="inv.php";</SCRIPT>');
}
if($c=='sumka')
{
$usersD = mysql_query("SET NAMES cp1251");
$usersD=mysql_query("SELECT * FROM users WHERE NICK='$_SESSION[s]'");
$usersD2=mysql_fetch_assoc($usersD);
$weapon_DMG=mysql_query("SELECT * FROM inv WHERE ID_USERS='$_SESSION[s]' AND ID_IL='$idT'");
$weapon_DMG2=mysql_fetch_assoc($weapon_DMG);
if($usersD2[LVL_USERS]<30){echo"<font color=\"red\">ваш уровень слишком мал чтобы носить это</font>";die;}
if($weapon_DMG2[IL_STR]>$usersD2[SKILL_STR] OR $weapon_DMG2[IL_DEX]>$usersD2[SKILL_DEX] OR $weapon_DMG2[IL_INT]>$usersD2[SKILL_INT]){
if($weapon_DMG2[IL_STR]>$usersD2[SKILL_STR]){echo"<center><font color=\"red\">не хватает силы!</font></center>";}
if($weapon_DMG2[IL_DEX]>$usersD2[SKILL_DEX]){echo"<font color=\"red\">не хватает ловкости!</font><br/>";}
if($weapon_DMG2[IL_INT]>$usersD2[SKILL_INT]){echo"<font color=\"red\">не хватает интеллекта!</font>";}
die;}
//создаем запрос на одевание кольцо
$sum1=mysql_query("SELECT * FROM inv WHERE IL_CLASS=\"sumka\" AND ID_USERS=\"$_SESSION[s]\"");
$sum2=mysql_fetch_assoc($sum1);
$VES=15+$sum2[BONUS_VES];
$maxVES=mysql_query("UPDATE users SET MAX_VES=\"$VES\" WHERE NICK=\"$_SESSION[s]\"");
$sumka=mysql_query("UPDATE inv SET IL_NO='1' WHERE IL_KEY='$use'");
print('<SCRIPT>location.href="inv.php";</SCRIPT>');
}
if($c=='braslet')
{
//создаем запрос на одевание браслет
$braslet_query_o=mysql_query("UPDATE inv SET IL_NO='1' WHERE IL_KEY='$use'");
print('<SCRIPT>location.href="inv.php";</SCRIPT>');
}
include_once("LVL_table.php");
@include("refresh.php");
$pr = mysql_query("SET NAMES cp1251");
$pr = mysql_query("SELECT * FROM inv WHERE ID_USERS=\"$_SESSION[s]\" AND IL_NO=\"1\"");
$prC=mysql_num_rows($pr);
if($prC==0){@include_once("LVL_table.php");}
?>
</body>
</html>