Файл: html/functions/wesh_odet.php
Строк: 49
<?php
function wesh_odet($id) {
//пишем айди предмета
global $mc;
global $user;
if (isset($user)) {
//смотрим на новую вещь
$infoshop1 = $mc->query("SELECT * FROM `userbag` WHERE `id`='$id'")->fetch_array(MYSQLI_ASSOC);
$infoshop2 = $mc->query("SELECT * FROM `shop` WHERE `id`='" . $infoshop1['id_shop'] . "'")->fetch_array(MYSQLI_ASSOC);
///есть ли одетое?
$dresssnyat = $mc->query("SELECT COUNT(1),`id`,`id_user`,`id_punct`,`id_shop`,`dress` FROM `userbag` WHERE `id_user`='" . $user['id'] . "' AND `dress`='1' AND `id_punct`='" . $infoshop1['id_punct'] . "'")->fetch_array(MYSQLI_ASSOC);
if ($infoshop1['id_punct'] == 11) {
//если бонусы то ничего не снимаем
} else if ($infoshop1['id_punct'] == 9) {
if ($dresssnyat['COUNT(1)'] > 6) {
//если одето элуксиры , то снимаем
shop_snyat($dresssnyat['id']);
}
} else if ($infoshop1['id_punct'] == 8) {
if ($dresssnyat['COUNT(1)'] > 1) {
//если одето кольца, то снимаем
shop_snyat($dresssnyat['id']);
}
} else {
if ($dresssnyat['COUNT(1)'] > 0) {
//если одето, то снимаем
shop_snyat($dresssnyat['id']);
}
}
if ($infoshop2['level'] <= $user['level']) {
//одеваем новое
$dresssnyatreid = $mc->query("SELECT * FROM `userbag` WHERE `userbag`.`id` = '$id' AND `id_user` = '" . $user['id'] . "'")->fetch_array(MYSQLI_ASSOC);
$mc->query("DELETE FROM `userbag` WHERE `userbag`.`id` = '$id' AND `id_user` = '" . $user['id'] . "'");
$mc->query("INSERT INTO `userbag`("
. "`id_user`,"
. " `id_shop`,"
. " `id_punct`,"
. " `dress`,"
. " `iznos`,"
. " `id_quests`,"
. " `koll`,"
. " `max_hc`,"
. " `time_end`,"
. " `stil`,"
. " `BattleFlag`"
. ") VALUES ("
. "'" . $dresssnyatreid['id_user'] . "',"
. "'" . $dresssnyatreid['id_shop'] . "',"
. "'" . $dresssnyatreid['id_punct'] . "',"
. "'1',"
. "'" . $dresssnyatreid['iznos'] . "',"
. "'" . $dresssnyatreid['id_quests'] . "',"
. "'" . $dresssnyatreid['koll'] . "',"
. "'" . $dresssnyatreid['max_hc'] . "',"
. "'" . $dresssnyatreid['time_end'] . "',"
. "'" . $dresssnyatreid['stil'] . "',"
. "'" . $dresssnyatreid['BattleFlag'] . "'"
. ")");
//"", "Урон", "Уворот", "Броня", "Элита"
$arr = $mc->query("SELECT `stil` FROM `userbag` WHERE `id_user` = '" . $user['id'] . "' && `id_punct` < '10' && `dress` ='1' GROUP BY `stil` ASC")->fetch_all(MYSQLI_ASSOC);
if (count($arr) == 2) {
$stil = $arr[1]['stil'];
} elseif (count($arr) == 1 && $arr[0]['stil'] != 0) {
$stil = $arr[0]['stil'];
} elseif (count($arr) < 2) {
$stil = 0;
} else {
$stil = 5;
}
$mc->query("UPDATE `users` SET `stil`='$stil' WHERE `id` = '" . $user['id'] . "'");
}
//пересчитаем статы
health_rechange();
}
}
?>