Example #1
0
    list($complect_id, $item_id) = mysql_fetch_array(myquery("SELECT complect_id,item_id FROM game_items_complect WHERE id={$id}"));
    $item_name = mysqlresult(myquery("SELECT name FROM game_items_factsheet WHERE id=" . $item_id . ""), 0, 0);
    $complect_name = mysqlresult(myquery("SELECT name FROM game_items_factsheet WHERE id=" . $complect_id . ""), 0, 0);
    myquery("DELETE FROM game_items_complect WHERE id={$id}");
    $da = getdate();
    $log = myquery("INSERT INTO game_log_adm (adm,dei,cur_time,day,month,year) \n\t VALUES (\n\t '" . $char['name'] . "',\n\t 'Для предмета: <b>" . $item_name . "</b> удалил из комплекта " . $complect_name . ": предмет <b>" . $item_name . "</b>',\n\t '" . time() . "',\n\t '" . $da['mday'] . "',\n\t '" . $da['mon'] . "',\n\t '" . $da['year'] . "')") or die(mysql_error());
    $response = 'ok';
}
// При изменении состава комплекта пересчитать всех игроков.
if (isset($_GET['save']) or isset($_GET['delete'])) {
    $complect_id = (int) $_GET['read'];
    // Снимаем комплект со всех, у кого он был одет.
    $res = myquery("SELECT `id`,`user_id` FROM `game_items` WHERE `priznak`=0 AND `used`=22 AND `item_id` = {$complect_id}");
    while ($list = mysql_fetch_array($res)) {
        $item = new Item($list['id']);
        $item->setChar($list['user_id']);
        $item->down();
    }
    $complect_fact = mysql_fetch_assoc(myquery("SELECT * FROM game_items_factsheet WHERE id={$complect_id}"));
    $complect_fact['weight'] = (double) $complect_fact['weight'];
    $sel_check = myquery("SELECT item_id FROM game_items_complect WHERE complect_id={$complect_id}");
    // Игроки у которых можеь быть одета новая версия комплекта
    $res = myquery("SELECT DISTINCT `user_id` FROM `game_items` WHERE `priznak`=0 AND `used`!=0 AND `item_id` IN (SELECT DISTINCT `item_id` FROM `game_items_complect` WHERE `complect_id` = {$complect_id});");
    while ($list = mysql_fetch_array($res)) {
        //Требования к этому комплекту выполненны?
        $check_user_id = $list['user_id'];
        $est_complect = 0;
        $kol_item_in_complect = 0;
        $kol_item_complect_used = 0;
        mysql_data_seek($sel_check, 0);
        while (list($item_ch_id) = mysql_fetch_array($sel_check)) {