points sql

#чистим базу:

DELETE FROM `creature_currency` WHERE `creature_id` IN (
49654,
49624,
49538,
49642,
39666,
39680,
39699,
39701,
39706,
39625,
40177,
40319,
40484,
48337,
48702,
48784,
48822,
48941,
48936,
48940,
48943,
48944,
49709,
49710,
49708,
49711,
49712,
41378,
41442,
41570,
42180,
43296,
49974,
49583,
51101,
49050,
47774,
49980,
49584,
51102,
49051,
47775,
49986,
49585,
51103,
49051,
47776,
44600,
45992,
46209,
49897,
46210,
49898,
46211,
49899);

#очки справедливости

#в обычном режиме по 30очков с каждого босса грим батола, толвира и чертогов созидания
#в героическом режиме по 70 очков с каждого босса

#5ппл инсты

#каменные недра

#героик

#корбор
#камнешкур
#озрук
#азил
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49654, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49624, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49538, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49642, 395, 7000);

#пещеры черной горы

#героик

#ромогг
#корла
#карш
#красавица
#повелитель
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (39666, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (39680, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (39699, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (39701, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (39706, 395, 7000);

#грим батол

#обычка

#умбрис
#тронг
#драгх
#эрудакс
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (39625, 395, 3000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (40177, 395, 3000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (40319, 395, 3000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (40484, 395, 3000);

#героик

#умбрис
#тронг
#драгх
#эрудакс
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (48337, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (48702, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (48784, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (48822, 395, 7000);

#мертвые копи

#героик

#врагорез
#глубток
#хеликс
#адмирал
#пирожок
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (48941, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (48936, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (48940, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (48943, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (48944, 395, 7000);

#крепость темного клыка

#героик

#силверлейн
#спрингвейл
#эшбери
#вальден
#годфри
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49709, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49710, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49708, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49711, 395, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49712, 395, 7000);



#очки доблести

#в 10ппл режиме по 70очков с каждого босса
#в 25ппл режиме по 140очков с каждого босса

#твердыня крыла тьмы

#малориак
#атрамед
#магмарь
#токситрон
#химерон

#10обычка

INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (41378, 396, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (41442, 396, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (41570, 396, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (42180, 396, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (43296, 396, 7000);

#25обычка

INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49974, 396, 14000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49583, 396, 14000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (51101, 396, 14000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49050, 396, 14000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (47774, 396, 14000);

#10героик

INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49980, 396, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49584, 396, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (51102, 396, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49051, 396, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (47775, 396, 7000);

#25героик

INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49986, 396, 14000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49585, 396, 14000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (51103, 396, 14000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49051, 396, 14000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (47776, 396, 14000);

#сумеречный бастион

#халфий
#валиона

#10обычка

INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (44600, 396, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (45992, 396, 7000);

#25обычка

INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (46209, 396, 14000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49897, 396, 14000);

#10героик

INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (46210, 396, 7000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49898, 396, 7000);

#25героик

INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (46211, 396, 14000);
INSERT INTO `creature_currency` (`creature_id`, `CurrencyId1`, `CurrencyCount1`)
VALUES (49899, 396, 14000);