//Рассчитаем требуемый уровень игрока
list($level) = mysql_fetch_array(myquery("SELECT max(oclevel) FROM game_users_complects_items guci JOIN game_items_factsheet gif ON guci.item_id=gif.id WHERE guci.complect_id='" . $complect . "'"));
//Рассчитаем харки игрока без вещей и изменим статус комплекта
list($str, $pie, $ntl, $vit, $dex, $spd, $lucky) = mysql_fetch_array(myquery("SELECT SUM(dstr) as str, SUM(dpie) as pie, SUM(dntl) as ntl, SUM(dvit) as vit, SUM(ddex) as dex, SUM(dspd) as spd, SUM(dlucky) as lucky FROM game_items gi JOIN game_items_factsheet gis ON gi.item_id=gis.id WHERE gi.user_id='" . $char['user_id'] . "' AND gi.used>0 AND gi.priznak=0"));
myquery("UPDATE game_users_complects SET clevel='" . $level . "', str='" . ($char['STR'] - $str) . "', ntl='" . ($char['NTL'] - $ntl) . "', pie='" . ($char['PIE'] - $pie) . "', \n\t\t\tvit='" . ($char['VIT'] - $vit) . "', dex='" . ($char['DEX'] - $dex) . "', spd='" . ($char['SPD'] - $spd) . "', lucky='" . ($char['lucky'] - $lucky) . "', status=1 \n\t\t\tWHERE id='" . $complect . "' ");
echo 'Комплект успешно запомнен!';
} else {
echo 'На Вас ничего не одето!';
}
} else {
echo 'Вы не запоминали никакой комплект!';
}
QuoteTable('close');
} elseif (isset($_GET['up_complect'])) {
$Item = new Item();
$result = $Item->all_down($char['user_id']);
QuoteTable('open');
//Проверка на характеристики
$check_compl = myquery("SELECT * FROM game_users_complects WHERE id='" . $_GET['up_complect'] . "' AND user_id='" . $char['user_id'] . "'");
if (mysql_num_rows($check_compl) == 1) {
$compl = mysql_fetch_array($check_compl);
if ($char['clevel'] < $compl['clevel']) {
echo 'Ваш уровень меньше, чем нужно!';
} else {
$char1 = mysql_fetch_array(myquery("SELECT STR, NTL, PIE, VIT, DEX, SPD, lucky FROM view_active_users WHERE user_id='" . $char['user_id'] . "'"));
if ($char1['STR'] < $compl['str'] or $char1['NTL'] < $compl['ntl'] or $char1['PIE'] < $compl['pie'] or $char1['VIT'] < $compl['vit'] or $char1['DEX'] < $compl['dex'] or $char1['SPD'] < $compl['spd'] or $char1['lucky'] < $compl['lucky']) {
echo 'Ваши начальные характеристики меньше, чем нужно!';
} else {
//Проверка на предметы
$check_items = myquery("SELECT gif.name, (v1.kol - ifnull(v2.kol, 0)) as kol FROM \n\t\t\t\t(SELECT item_id, count(item_id) as kol FROM game_users_complects_items WHERE complect_id='" . $compl['id'] . "' GROUP BY item_id) as v1\n\t\t\t\tJOIN game_items_factsheet gif ON v1.item_id = gif.id\n\t\t\t\tLEFT JOIN (SELECT item_id, count(item_id) as kol FROM game_items WHERE user_id='" . $char['user_id'] . "' AND priznak=0 AND item_uselife>0 AND ref_id=0 GROUP BY item_id) as v2 \n\t\t\t\tON (v1.item_id=v2.item_id) WHERE v1.kol>v2.kol OR v2.kol IS NULL");
if (mysql_num_rows($check_items) > 0) {
echo 'Владельцам возвращено ' . $i . ' предметов!';
}
} else {
echo '<form action="admin.php?opt=main&option=functadm&kleymo&user" method="post">
Имя игрока: <input name="name" type="text" size="25" id="keyword" onkeyup="handleKeyUp(event)">
<div style="display:none;" id="scroll"><div id="suggest"></div></div>
<br/><input name="submit" type="submit" value="Вернуть клеймёные вещи игрока">
</form></div><script>init();</script>';
}
} elseif (isset($_GET['itemsdown'])) {
echo '<h3>Снять все предметы с игрока</h3>';
if (isset($_GET['user'])) {
$name = $_POST['name'];
list($id) = mysql_fetch_array(myquery("SELECT user_id FROM game_users WHERE name='" . $name . "' Union SELECT user_id FROM game_users_archive WHERE name='" . $name . "'"));
$Item = new Item();
$result = $Item->all_down($id);
if ($result == 1) {
echo 'С игрока сняты все вещи!';
} else {
echo 'С игрока нечего снимать!';
}
} else {
echo '
<script type="text/javascript">
var getFunctionsUrl = "suggest/suggest.php?keyword=";
var startSearch = 3;
</script><?
<link href="suggest/suggest.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="suggest/suggest.js"></script>
<form action="admin.php?opt=main&option=functadm&itemsdown&user" method="post">
Имя игрока:<input id="keyword" name="name" type="text" size="20" onkeyup="handleKeyUp(event)"><div style="display:none;" id="scroll"><div id="suggest"></div></div>
