Файл: data/odegda.dat.php
Строк: 260
<?
$query = "SELECT * FROM `table1` WHERE `name`='$opredelenie'";
$sql1 = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($sql1);
/**
* @author wistis
* @copyright 2011
*/
if ((isset($_POST['naz'])) && (isset($_GET['nazv'])))
{ print '<div class="spiski"><div class="zagolovok">Снять</div><div class="line"></div><ul>';
$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'] ;
if ($ru <= $num_rows)
{
print"<div class="style_mess_no">Вы не можете продолжать освободите рюкзак!!</div>" ;
exitt($row, $opredelenie) ;
}
$sss = $_GET['nazv'] ;
include "./dvig/odet.php" ;
$Odet = new Odet ;
$mmm = $_GET['nazv'] ;
//////////////////////////////////////////
$queryo = "SELECT * FROM `rukzak` WHERE `idrukzak`='" . mysql_real_escape_string($mmm) .
"'AND `odeto`='1' and `name`='" . mysql_real_escape_string($opredelenie) . "'" ;
$sqlo = mysql_query($queryo) or die(mysql_error()) ;
$k = mysql_num_rows($sqlo) ;
if ($k == 0)
{
print "<div class="style_mess_no">Ошибка! запроса!</div>" ;
exitt($row,$opredelenie);
} ///проверка есть ли такая вешь в рюкзаке у человека если нет то выход
$rowo = mysql_fetch_assoc($sqlo) ;
if ($rowo['chit'] == 'or')
{
if($rowo['ruka']==0){
$vtable = 'orugie' ;
}
if($rowo['ruka']==1){
$vtable = 'shit' ;
}
}
if ($rowo['chit'] == 'dos')
{
$vtable = 'brohja' ;
}
if ($rowo['chit'] == 'shit')
{
$vtable = 'shit' ;
}
if ($rowo['chit'] == 'shapka')
{
$vtable = 'shlem' ;
}
if ($rowo['chit'] == 'sapogi')
{
$vtable = 'sapogi' ;
}
if ($rowo['chit'] == 'perchi')
{
$vtable = 'rukavici' ;
}
if ($rowo['chit'] == 'plash')
{
$vtable = 'plash' ;
;
}
if ($rowo['chit'] == 'kolco')
{
$vtable = 'slot4' ;
;
}
if ($rowo['chit'] == 'amulet')
{
$vtable = 'slot2' ;
;
}
if ($rowo['chit'] == 'braslet')
{
$vtable = 'slot3' ;
;
}
if ($rowo['chit'] == 'chasi')
{
$vtable = 'slot5' ;
;
}
if (($rowo['chit'] == 'gem') || ($rowo['chit'] == 'metal') || ($rowo['chit'] ==
'sh')||($rowo['chit'] == 'sfera'))
{
$vtable = 'slot1' ;
}
mysql_query("UPDATE `table1` SET `" . mysql_real_escape_string($vtable) . "`=
'0' where`name`='" . mysql_real_escape_string($opredelenie) . "'
LIMIT 1 ;") or die(mysql_error()) ;
$Odet->snimaem($mmm, $opredelenie, $row) ;
print "<div class="style_mess_yes">Вы сняли " . $rowo['nazvanie'] . "</div>";
mysql_query("update `rukzak` set `odeto`='787' where `idrukzak`='".$_GET['nazv']."' and `day`>0 and `day`<'".time()."' and `odeto`!='787' and `name`='$opredelenie'");
$za = mysql_query("select*from `rukzak` where `day`>0 and `day`<'".time()."' and `odeto`!='787' and `name`='$opredelenie'") or (die
(mysql_error()));
if(mysql_num_rows($za)==0){
mysql_query("update `table1` set `snat`=0 where `name`='$opredelenie'") or (die
(mysql_error()));
exitt($row,$opredelenie);}
}
//////////////////////////////////////////////
//////////////////////////////////////////
///////////////////////////////////////
////////////////////////////////////////
if (isset($_GET['naz']))
{print '<div class="spiski"><div class="zagolovok">Снять</div><div class="line"></div><ul>';
$naz = mysql_real_escape_string($_GET['naz']) ;
$query = "SELECT * FROM `rukzak` WHERE `idrukzak`='" . mysql_real_escape_string($naz) .
"' AND `odeto`='1' and `name`='" . mysql_real_escape_string($opredelenie) . "'" ;
$sql = mysql_query($query) or die(mysql_error()) ;
$k = mysql_num_rows($sql) ;
if ($k == 0)
{
print "<div class="style_mess_no">Ошибка запроса!</div>" ;
exitt($row, $opredelenie) ;
} ///проверка есть ли такая вешь в рюкзаке у человека если нет то выход
$row1 = mysql_fetch_assoc($sql) ;
///////////////////////////////////////////////////////////////////////////////////////////////////////
print "<div class="chat_conteiner">Название: " . htmlspecialchars($row1['nazvanie']) . "<br>
Тип: " . $row1['rus_tip'] . "<br>
Параметры:+" . htmlspecialchars($row1['try']) . " " . $row1['rus_par'] . " <br>
Создатель:" . htmlspecialchars($row1['sozdatel']) . "<br>
Уровень: " . htmlspecialchars($row1['lvl']) . " " ;
if ($row1['vstavlen'] == 1)
{
print "<br>Заряжен :" . htmlspecialchars($row1['gemnaz']) . " <br>
+ " . htmlspecialchars($row1['par']) . " " . htmlspecialchars($row1['rus_tip_par']) .
"<br>
Ювелир:" . htmlspecialchars($row1['master']) . " " ;
}
print "<form name=form1 action=88.php?go=odegda&nazv=" . htmlspecialchars($naz) .
" method=post><li><input class=select name=naz type=submit value=Снять></li></form></div>" ;
exitt($row, $opredelenie) ;
}
$sn1='';
$sn2='';
$sn3='';
$sn4='';
$sn5='';
$sn6='';
$sn7='';
$nm = $row['orugie'] ;
$query1p = "SELECT * FROM `rukzak` WHERE `idrukzak`='" .
mysql_real_escape_string($nm) . "' " ;
$sql1p = mysql_query($query1p) or die(mysql_error()) ;
$row1p = mysql_fetch_assoc($sql1p) ;if(($row1p['day']<=time())&&($row1p['day']>0)){$sn1='<font color=red>*</font>';}
$nm1 = $row['brohja'] ;
$query0p = "SELECT * FROM `rukzak` WHERE `idrukzak`='" .
mysql_real_escape_string($nm1) . "' " ;
$sql0p = mysql_query($query0p) or die(mysql_error()) ;
$row0p = mysql_fetch_assoc($sql0p) ;if(($row0p['day']<=time())&&($row0p['day']>0)){$sn2='<font color=red>*</font>';}
$nm2 = $row['shit'] ;
$query2p = "SELECT * FROM `rukzak` WHERE `idrukzak`='" .
mysql_real_escape_string($nm2) . "' " ;
$sql2p = mysql_query($query2p) or die(mysql_error()) ;
$row2p = mysql_fetch_assoc($sql2p) ;if(($row2p['day']<=time())&&($row2p['day']>0)){$sn3='<font color=red>*</font>';}
///////////////////
$n = $row['rukavici'] ;
$q = "SELECT * FROM `rukzak` WHERE `idrukzak`='" . mysql_real_escape_string($n) .
"' and `odeto`='1' and `name`='$opredelenie' limit 1" ;
$s = mysql_query($q) or die(mysql_error()) ;
$r = mysql_fetch_assoc($s) ;if(($r['day']<=time())&&($r['day']>0)){$sn4='<font color=red>*</font>';}
///////////////////
$n1 = $row['sapogi'] ;
$q = "SELECT * FROM `rukzak` WHERE `idrukzak`='" . mysql_real_escape_string($n1) .
"' and `odeto`='1' and `name`='$opredelenie' limit 1" ;
$s = mysql_query($q) or die(mysql_error()) ;
$r1 = mysql_fetch_assoc($s) ;if(($r1['day']<=time())&&($r1['day']>0)){$sn5='<font color=red>*</font>';}
///////////////////
$n2 = $row['shlem'] ;
$q = "SELECT * FROM `rukzak` WHERE `idrukzak`='" . mysql_real_escape_string($n2) .
"' and `odeto`='1' and `name`='$opredelenie' limit 1" ;
$s = mysql_query($q) or die(mysql_error()) ;
$r11 = mysql_fetch_assoc($s) ; if(($r11['day']<=time())&&($r11['day']>0)){$sn6='<font color=red>*</font>';}
$n3 = $row['plash'] ;
$q = "SELECT * FROM `rukzak` WHERE `idrukzak`='" . mysql_real_escape_string($n3) .
"' and `odeto`='1' and `name`='$opredelenie' limit 1" ;
$s = mysql_query($q) or die(mysql_error()) ;
$r111 = mysql_fetch_assoc($s) ;if(($r111['day']<=time())&&($r111['day']>0)){$sn7='<font color=red>*</font>';}
$n4 = $row['slot1'] ;
$q = "SELECT * FROM `rukzak` WHERE `idrukzak`='" . mysql_real_escape_string($n4) .
"' and `odeto`='1' and `name`='$opredelenie' limit 1" ;
$s = mysql_query($q) or die(mysql_error()) ;
$r1111 = mysql_fetch_assoc($s) ;
/////////////////////////////////////////////////////////////////////////
$n5 = $row['slot2'] ;
$q = "SELECT * FROM `rukzak` WHERE `idrukzak`='" . mysql_real_escape_string($n5) .
"' and `odeto`='1' and `name`='$opredelenie' limit 1" ;
$s = mysql_query($q) or die(mysql_error()) ;
$r11115 = mysql_fetch_assoc($s) ;
///////////
$n6 = $row['slot3'] ;
$q = "SELECT * FROM `rukzak` WHERE `idrukzak`='" . mysql_real_escape_string($n6) .
"' and `odeto`='1' and `name`='$opredelenie' limit 1" ;
$s = mysql_query($q) or die(mysql_error()) ;
$r11116 = mysql_fetch_assoc($s) ;
///////
$n7 = $row['slot4'] ;
$q = "SELECT * FROM `rukzak` WHERE `idrukzak`='" . mysql_real_escape_string($n7) .
"' and `odeto`='1' and `name`='$opredelenie' limit 1" ;
$s = mysql_query($q) or die(mysql_error()) ;
$r11117 = mysql_fetch_assoc($s) ;//
////////
$n8 = $row['slot5'] ;
$q = "SELECT * FROM `rukzak` WHERE `idrukzak`='" . mysql_real_escape_string($n8) .
"' and `odeto`='1' and `name`='$opredelenie' limit 1" ;
$s = mysql_query($q) or die(mysql_error()) ;
$r11118 = mysql_fetch_assoc($s) ;
///////////
print '<div class="spiski"><div class="zagolovok">Снаряжение</div><div class="line"></div><ul>';
print "
<li>Оружие: - <a href=88.php?go=odegda&naz=" . htmlspecialchars($nm) . "> " .
htmlspecialchars($row1p['nazvanie']) . "</a>$sn1</li>
<li>Броня: - <a href=88.php?go=odegda&naz=" . htmlspecialchars($nm1) . "> " .
htmlspecialchars($row0p['nazvanie']) . "</a>$sn2</li>
<li> Щит: - <a href=88.php?go=odegda&naz=" . htmlspecialchars($nm2) . "> " .
htmlspecialchars($row2p['nazvanie']) . "</a>$sn3</li>
<li>Сапоги: <a href=88.php?go=odegda&naz=" . htmlspecialchars($n1) . ">" .
htmlspecialchars($r1['nazvanie']) . "</a>$sn5</li>
<li> Шлем: <a href=88.php?go=odegda&naz=" . htmlspecialchars($n2) . ">" .
htmlspecialchars($r11['nazvanie']) . "</a>$sn6</li>
<li> Рукавицы:<a href=88.php?go=odegda&naz=" . htmlspecialchars($n) . ">" .
htmlspecialchars($r['nazvanie']) . "</a>$sn4</li>
<li>Плащ: <a href=88.php?go=odegda&naz=" . htmlspecialchars($n3) . ">" .
htmlspecialchars($r111['nazvanie']) . "</a>$sn7</li>
<li> Слот 1:<a href=88.php?go=odegda&naz=" . htmlspecialchars($n4) . ">" .
htmlspecialchars($r1111['nazvanie']) . "</a></li>" ;
print " <li><strong> Амулет</strong>:<a href=88.php?go=odegda&naz=" . htmlspecialchars($n5) . ">" . htmlspecialchars($r11115['nazvanie']) . "</a></li>
<li> <strong>Браслет</strong>:<a href=88.php?go=odegda&naz=" . htmlspecialchars($n6) . "> " . htmlspecialchars($r11116['nazvanie']) . "</a></li>
<li><strong>Кольцо</strong>:<a href=88.php?go=odegda&naz=" . htmlspecialchars($n7) . ">" . htmlspecialchars($r11117['nazvanie']) . "</a></li>
<li> <strong>Часы</strong>: <a href=88.php?go=odegda&naz=" . htmlspecialchars($n8) . ">" . htmlspecialchars($r11118['nazvanie']) . "</a></li>
<li>Вещи помеченные <font color=red>*</font> следует снять, у них закончился срок действия!
";
exitt($row, $opredelenie) ;