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)) {