Файл: www-1/bag.php
Строк: 62
<?php
define('cms', 1);
require_once 'core.php';
if ($user)
{
Error_Reporting(E_ALL & ~E_NOTICE);
$u = mysql_fetch_array(mysql_query("SELECT `login`,`weapon`,`head`,`legs`,`body` FROM `users` WHERE `id` = '".$user."'"));
echo '<div class="menu">Сумка</div>';
echo '<div class="pt">';
switch ($_GET['a'])
{
default:
$all_w = mysql_result(mysql_query("SELECT count(*) FROM `bag` WHERE `type` = '1' AND `user` = '$user'"),0);
echo '<a href="/weapon.the-elder-scrolls">Оружее</a> ('.$all_w.')<br />';
$all_a = mysql_result(mysql_query("SELECT count(*) FROM `bag` WHERE `type` > 1 AND `type` <= 4 AND `user` = '$user'"),0);
echo '<a href="/armor_in_bag.the-elder-scrolls">Доспехи</a> ('.$all_a.')<br />';
$all_q = mysql_result(mysql_query("SELECT count(*) FROM `bag` WHERE `type` = '5' AND `user` = '$user'"),0);
echo '<a href="">Квестовые предметы</a> ('.$all_q.')<br />';
$all_o = mysql_result(mysql_query("SELECT count(*) FROM `bag` WHERE `type` = '6' AND `user` = '$user'"),0);
echo '<a href="">Предметы</a> ('.$all_o.')<br />';
break;
case 'armor_in_bag':
$all_a = mysql_result(mysql_query("SELECT count(*) FROM `bag` WHERE `type` >= 2 AND `type` <= 4 AND `user` = '$user'"),0);
if ($all_a > 0)
{
if (isset($_GET['get']))
{
$get_on = abs(round($_GET['get']));
$armor_get = mysql_fetch_array(mysql_query("SELECT `title`,`type` FROM `armor` WHERE `id` = '".$get_on."'"));
if (empty($armor_get)) header('Location: /bag.the-elder-scrolls');
else {
$id_to_dell = mysql_fetch_array(mysql_query("SELECT `id` FROM `bag` WHERE `user` = '".$user."' AND `type` >= 2 AND `type` <= 4 AND `num` = '".addslashes($_GET['get'])."'"));
if (!empty($id_to_dell))
{
if ($armor_get['type'] == 'body') $type = 4;
if ($armor_get['type'] == 'head') $type = 2;
if ($armor_get['type'] == 'legs') $type = 3;
if ($u[$armor_get['type']] == '0')
{
mysql_query("UPDATE `users` SET ".$armor_get['type']." = '".$get_on."' WHERE `id` = '$user'");
mysql_query("DELETE FROM `bag` WHERE `id` = '".$id_to_dell['id']."'");
echo 'Вы взяли одели на себя '.$armor_get['title'].' <br />';
} else echo 'На вас уже есть броня, снимите её для начала.';
} else echo 'В вашей сумке нет этой вещи<br />';
}
echo ' <br />';
}
$sql_armor = mysql_query("SELECT * FROM `bag` WHERE `type` >= 2 AND `type` <= 4 AND `user` = '$user'");
while ($a = mysql_fetch_assoc($sql_armor))
{
$title = mysql_fetch_array(mysql_query("SELECT `title`,`type` FROM `armor` WHERE `id` = '".$a['num']."'"));
echo '<a href="/a/'.$a['num'].'.the-elder-scrolls.armors">'.$title['title'].'</a><br />';
if ($u[$title['type']] == 0) echo '<a href="/armor_in_bag/'.$a['num'].'.the-elder-scrolls.armor_out"><font color="green">Одеть</font></a>';
echo '<div class="lin"></div>';
}
} else echo 'В вашем рюкзаке нет брони<br />';
echo '<br /><a href="/bag.the-elder-scrolls">Назад</a>';
break;
case 'weapon':
$all_w = mysql_result(mysql_query("SELECT count(*) FROM `bag` WHERE `type` = '1' AND `user` = '$user'"),0);
if ($all_w > 0)
{
if (isset($_GET['get_on']))
{
$get_on = abs(round($_GET['get_on']));
$weapon_get = mysql_fetch_array(mysql_query("SELECT `title` FROM `weapon` WHERE `id` = '".$get_on."'"));
if (empty($weapon_get)) header('Location: /bag.the-elder-scrolls');
else {
$id_to_dell = mysql_fetch_array(mysql_query("SELECT `id` FROM `bag` WHERE `user` = '".$user."' AND `type` = '1' AND `num` = '".addslashes($_GET['get_on'])."'"));
if (!empty($id_to_dell))
{
mysql_query("UPDATE `users` SET `weapon` = '".$get_on."' WHERE `id` = '$user'");
mysql_query("DELETE FROM `bag` WHERE `id` = '".$id_to_dell['id']."'");
echo 'Вы взяли оружее у руки ('.$weapon_get['title'].')<br />';
} else echo 'В вашей сумке нет этой вещи<br />';
}
}
$sql_weapon = mysql_query("SELECT * FROM `bag` WHERE `type` = '1' AND `user` = '$user'");
while ($w = mysql_fetch_assoc($sql_weapon))
{
$title = mysql_fetch_array(mysql_query("SELECT `title` FROM `weapon` WHERE `id` = '".$w['num']."'"));
echo '<a href="/w/'.$w['num'].'.the-elder-scrolls">'.$title['title'].'</a><br />';
if ($u['weapon'] == 0) echo '<a href="/weapon/'.$w['num'].'.the-elder-scrolls.weapons"><font color="green">В руки</font></a>';
echo '<div class="lin"></div>';
}
} else echo 'В вашем рюкзаке нет оружия<br />';
echo '<br /><a href="/bag.the-elder-scrolls">Назад</a>';
break;
}
echo '</div>';
}
else
{
header('Location: ./index.php');
}
include './include/foot.php';
?>