Revise paste Ачивы/бонусы за пве ладдер 2023-2024

-- ПЕРСОНАЛЬНЫЙ РЕЙТИНГ:
update TBonuses set fcount = fcount + 7000 where f_account in (4730810);
update TBonuses set fcount = fcount + 4000 where f_account in (7195052, 1409240, 5851298, 4317043, 6397819);
update TBonuses set fcount = fcount + 2000 where f_account in (4306006, 7270915, 2039984, 3633716, 7392838, 7392845, 5174498, 6430640, 7290241, 3896648, 2808542, 7227304);
update TBonuses set fcount = fcount + 1000 where f_account in (213986, 6149753, 7394057, 6122353, 6934389, 7396730, 7294499, 5304712, 6837271, 6931419, 7076172, 7012355, 7387760, 6860737, 4155751, 6338316, 7354603, 6891715, 5823594, 7353886, 6260422);

--НАКСРАМАС 3 место:
update TBonuses set fcount = fcount + 2200 where f_account in (4301901, 6878482, 5383680, 2377549, 6909013, 6984848, 5900405, 2422081, 6846550, 6981327, 5213625, 7055913, 4155751, 7151855, 7116257, 2641072, 7210392, 7264135, 155719, 3366222, 5692610, 1452912, 6759053, 4700491, 4538880, 3932169, 5977994, 2999474, 6813244, 5220731, 6834785, 6122353, 5272621, 6245676, 2464567, 2744794, 6496274, 6788146, 5207533, 5211421, 6051794);

-- МНЗХ 1 место:
update TBonuses set fcount = fcount + 2000 where f_account in (221370, 319493, 1242235, 2405255, 4494733, 7244610, 3427457, 6122353, 4306006, 6549609, 5117628, 4691995, 6970334, 873847, 3242503, 6895842, 6575069, 4979340, 6797024, 6801148, 4387702, 2346536, 4071498, 822163, 7434850);

-- КЛЮЧИ 2-3места

-- Второе место:
update TBonuses set fcount = fcount + 2000 where f_account in (5045543, 6130382, 6299681, 7460001, 3283396, 6556133, 5167052, 1329699, 3988333, 5903498, 7169064);
update TBonuses set fcount = fcount + 4000 where f_account in (4378153);
update TBonuses set fcount = fcount + 6000 where f_account in (6780686);
update TBonuses set fcount = fcount + 6000 where f_account in (6758447);
update TBonuses set fcount = fcount + 8000 where f_account in (4342560);
update TBonuses set fcount = fcount + 10000 where f_account in (6549609);
update TBonuses set fcount = fcount + 12000 where f_account in (3461982, 2400513);

-- Третье место:
update TBonuses set fcount = fcount + 1600 where f_account in (2405255, 1675172, 2727401, 4700491, 4306006, 7075191);
update TBonuses set fcount = fcount + 4800 where f_account in (7106950);
update TBonuses set fcount = fcount + 6400 where f_account in (4251976);
update TBonuses set fcount = fcount + 9600 where f_account in (3988333);
update TBonuses set fcount = fcount + 11200 where f_account in (5167052, 1329699, 5903498);

-- ЦЛК/НАКС/САНВЕЛ
-- Выбрали бонусы вместо денег, либо не успели отправить реквизиты в установленный срок:

-- х5/х100/x1
update TBonuses set fcount = fcount + 19500 where f_account in (6895842, 6970334);
update TBonuses set fcount = fcount + 18460 where f_account in (4979340);
update TBonuses set fcount = fcount + 15600 where f_account in (4563742);
update TBonuses set fcount = fcount + 11700 where f_account in (5689731);
update TBonuses set fcount = fcount + 9100 where f_account in (6150901, 6798944);
update TBonuses set fcount = fcount + 8060 where f_account in (4301901, 7264135, 6878482, 2641072);
update TBonuses set fcount = fcount + 7800 where f_account in (6496653);
update TBonuses set fcount = fcount + 6500 where f_account in (5414356, 7460001, 3003369, 3896648, 2871988, 3529927, 4076072, 6223193, 7036719, 5178845, 6857584, 3981515);
update TBonuses set fcount = fcount + 5200 where f_account in (7136496, 6837271, 6999032, 7013026, 7320245, 6919338);
update TBonuses set fcount = fcount + 4290 where f_account in (6759053, 4700491, 1452912, 4538880, 5977994, 2999474, 6813244, 6834785, 6122353, 5272621, 6245676, 2464567, 2744794, 6496274, 6788146, 5207533, 5211421, 6051794, 3820038, 4542068, 6509997);
update TBonuses set fcount = fcount + 3900 where f_account in (6842955);
update TBonuses set fcount = fcount + 2860 where f_account in (3366222, 7210392, 7151855, 7055913, 6981327, 2422081, 6984848, 5383680, 2377549, 5692610);

-- ВЫДАЧА АЧИВ

-- x5 WOTLK
-- https://wowroad.info/?achievement=4576 (ЦЛК 1 место)
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (179394, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (442334, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (924975, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (2793862, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (3905845, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (4383266, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (4718729, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (5088120, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (5488925, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (5601212, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (5646977, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (5822644, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (5883609, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (6496746, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (6578371, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7025320, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7630107, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7878892, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7932950, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (8102358, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (8435662, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (8529997, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (8560403, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (8641626, 4576, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (9206601, 4576, 1728122400);

-- x100 WOTLK
-- https://wowroad.info/?achievement=1402 (НАКС 1 место)
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (5510312, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (6321685, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (6697162, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7478275, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7494220, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7810204, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (8519220, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (8541990, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (14375405, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (21150694, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (21433666, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (22796727, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (26214507, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (27997356, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28090267, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28324304, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28453929, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28665720, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28668297, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28707577, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28806052, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28841330, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28900260, 1402, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (29139677, 1402, 1728122400);

-- x100 WOTLK
-- https://wowroad.info/?achievement=431 (САНВЕЛ 1 место)
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (6321685, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (6470790, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (6697162, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7478275, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7494220, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (8541990, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (14375405, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (19719242, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (21433666, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (22817414, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (26214507, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (27606650, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (27997356, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28010975, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28090267, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28324304, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28453929, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28665720, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28668297, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28707577, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28808849, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28841330, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28900260, 431, 1728122400);
INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (29139677, 431, 1728122400);