Файл: html/functions/wesh_kupit.php
Строк: 66
<?php
function shop_buy($id_shop, $odet) {
//пишем айди предмета
global $mc;
global $user;
if (isset($user)) {
if ($eqall = $mc->query("SELECT * FROM `userbag` WHERE `id_user`='" . $user['id'] . "' AND `id_punct`>'0' AND `id_punct`<'10' ")->fetch_all(MYSQLI_ASSOC)) {
$eqcount = count($eqall);
} else {
$eqcount = 0;
}
//смотрим на новую вещь
$infoshop1 = $mc->query("SELECT * FROM `shop` WHERE `id`='$id_shop'")->fetch_array(MYSQLI_ASSOC);
if ($odet == 'y') {
///есть ли одетое?
$dresssnyat = $mc->query("SELECT *,COUNT(1) 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']);
}
}
}
//дата истечения в unix
if ($infoshop1['time_s'] > 0) {
$time_the_lapse = $infoshop1['time_s'] + time();
} else {
$time_the_lapse = 0;
}
//если рюкзак больше или равен лимиту
if ($eqcount >= $user['max_bag_count']) {
} else {
if ($odet == 'y' || $infoshop1['id_punct'] == 11) {
//одеваем новое
$mc->query("INSERT INTO `userbag`("
. "`id_user`,"
. " `id_shop`,"
. " `id_punct`,"
. " `dress`,"
. " `iznos`,"
. " `time_end`,"
. " `id_quests`,"
. " `koll`,"
. " `max_hc`,"
. " `stil`,"
. " `BattleFlag`"
. ") VALUES ("
. "'" . $user['id'] . "',"
. "'" . $infoshop1['id'] . "',"
. "'" . $infoshop1['id_punct'] . "',"
. "'1',"
. "'" . $infoshop1['iznos'] . "',"
. "'$time_the_lapse',"
. "'" . $infoshop1['id_quests'] . "',"
. "'" . $infoshop1['koll'] . "',"
. "'" . $infoshop1['max_hc'] . "',"
. "'" . $infoshop1['stil'] . "',"
. "'" . $infoshop1['BattleFlag'] . "'"
. ")");
//пересчитаем статы
health_rechange();
} else {
//покупаем но не одеваем
$mc->query("INSERT INTO `userbag`("
. "`id_user`,"
. " `id_shop`,"
. " `id_punct`,"
. " `dress`,"
. " `iznos`,"
. " `time_end`,"
. " `id_quests`,"
. " `koll`,"
. " `max_hc`,"
. " `stil`,"
. " `BattleFlag`"
. ") VALUES ("
. "'" . $user['id'] . "',"
. "'" . $infoshop1['id'] . "',"
. "'" . $infoshop1['id_punct'] . "',"
. "'0',"
. "'" . $infoshop1['iznos'] . "',"
. "'$time_the_lapse',"
. "'" . $infoshop1['id_quests'] . "',"
. "'" . $infoshop1['koll'] . "',"
. "'" . $infoshop1['max_hc'] . "',"
. "'" . $infoshop1['stil'] . "',"
. "'" . $infoshop1['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'] . "'");
}
}
?>