Файл: database/migrations/v50_10_5_manual_schedule_reset.sql
Строк: 34
-- v50.10.5: одноразовая очистка
незавершённых старых заявок.
DELETE m FROM
`undying_v60_member` m INNER JOIN `undying_v60_event` e ON
e.`id`=m.`event_id` WHERE e.`state` IN ('waiting','running');
DELETE m FROM
`altar_v60_member` m INNER JOIN `altar_v60_event` e ON e.`id`=m.`event_id`
WHERE e.`state` IN ('waiting','running');
UPDATE `undying_v60_event` SET
`state`='finished',`finished_at`=UNIX_TIMESTAMP() WHERE `state` IN
('waiting','running');
UPDATE `altar_v60_event` SET
`state`='finished',`finished_at`=UNIX_TIMESTAMP() WHERE `state` IN
('waiting','running');
INSERT INTO `game_meta` (`meta_key`,`meta_value`)
VALUES ('v5105_manual_schedule_reset','1') ON DUPLICATE KEY UPDATE
`meta_value`='1';