Продавец комплектов арены 7 сезона [sql]

Приведу пример sql запроса для торговца комплектами арены 7 сезона для всех классов (ID предметов выбирали модераторы):

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200107, 0, 0, 0, 0, 0, 224, 224, 224, 224, 'Продавец А7', 'Выдача акционных вещей', '', 0, 85, 85, 1, 2007, 2007, 128, 1, 2, 999, 999, 0, 999, 1, 0, 0, 2, 4160, 8, 0, 0, 0, 0, 0, 0, 0, 0, 7, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 23000, 23000, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '');

/* Устанавливаем торговца в Даларане на Площадке Краса */
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(200107, 200107, 571, 1, 1, 0, 0, 5824.9, 502.309, 657.354, 4.45535, 300, 0, 0, 11500, 23000, 0, 0, 0, 0);

DELETE FROM `npc_vendor` WHERE (`entry`=200107);
INSERT INTO `npc_vendor` (entry, item, maxcount, incrtime, ExtendedCost) VALUES
/* created by ixnfo.com */
/* а7 воин */
(200107, 40790, 0, 0, 0),
(200107, 40810, 0, 0, 0),
(200107, 40829, 0, 0, 0),
(200107, 40850, 0, 0, 0),
(200107, 40870, 0, 0, 0),
/* a7 друид (интелект) */
(200107, 41276, 0, 0, 0),
(200107, 41288, 0, 0, 0),
(200107, 41299, 0, 0, 0),
(200107, 41311, 0, 0, 0),
(200107, 41322, 0, 0, 0),
/* a7 друид (ловкость) */
(200107, 41662, 0, 0, 0),
(200107, 41668, 0, 0, 0),
(200107, 41679, 0, 0, 0),
(200107, 41716, 0, 0, 0),
(200107, 41774, 0, 0, 0),
/* a7 жрец "Одеяние неумолимого гладиатора" */
(200107, 41916, 0, 0, 0),
(200107, 41922, 0, 0, 0),
(200107, 41928, 0, 0, 0),
(200107, 41935, 0, 0, 0),
(200107, 41941, 0, 0, 0),
/* a7 жрец "Убор неумолимого гладиатора" */
(200107, 41855, 0, 0, 0),
(200107, 41860, 0, 0, 0),
(200107, 41865, 0, 0, 0),
(200107, 41870, 0, 0, 0),
(200107, 41875, 0, 0, 0),
/* a7 маг */
(200107, 41947, 0, 0, 0),
(200107, 41954, 0, 0, 0),
(200107, 41960, 0, 0, 0),
(200107, 41966, 0, 0, 0),
(200107, 41972, 0, 0, 0),
/* a7 охотник */
(200107, 41088, 0, 0, 0),
(200107, 41144, 0, 0, 0),
(200107, 41158, 0, 0, 0),
(200107, 41206, 0, 0, 0),
(200107, 41218, 0, 0, 0),
/* a7 паладин (сила) */
(200107, 40792, 0, 0, 0),
(200107, 40812, 0, 0, 0),
(200107, 40831, 0, 0, 0),
(200107, 40852, 0, 0, 0),
(200107, 40872, 0, 0, 0),
/* a7 паладин (интелект) */
(200107, 40910, 0, 0, 0),
(200107, 40928, 0, 0, 0),
(200107, 40934, 0, 0, 0),
(200107, 40940, 0, 0, 0),
(200107, 40964, 0, 0, 0),
/* a7 разбойник */
(200107, 41651, 0, 0, 0),
(200107, 41656, 0, 0, 0),
(200107, 41673, 0, 0, 0),
(200107, 41684, 0, 0, 0),
(200107, 41768, 0, 0, 0),
/* a7 рыцарь смерти */
(200107, 40791, 0, 0, 0),
(200107, 40811, 0, 0, 0),
(200107, 40830, 0, 0, 0),
(200107, 40851, 0, 0, 0),
(200107, 40871, 0, 0, 0),
/* a7 чернокнижник */
(200107, 41994, 0, 0, 0),
(200107, 41999, 0, 0, 0),
(200107, 42006, 0, 0, 0),
(200107, 42012, 0, 0, 0),
(200107, 42018, 0, 0, 0),
/* a7 шаман (ловкость) */
(200107, 41082, 0, 0, 0),
(200107, 41138, 0, 0, 0),
(200107, 41152, 0, 0, 0),
(200107, 41200, 0, 0, 0),
(200107, 41212, 0, 0, 0),
/* a7 шаман (интелект) */
(200107, 40995, 0, 0, 0),
(200107, 41008, 0, 0, 0),
(200107, 41020, 0, 0, 0),
(200107, 41034, 0, 0, 0),
(200107, 41045, 0, 0, 0),
/* а7 оружие */
(200107, 42354, 0, 0, 0),
(200107, 42483, 0, 0, 0),
(200107, 42504, 0, 0, 0),
(200107, 42515, 0, 0, 0),
(200107, 42521, 0, 0, 0),
(200107, 42527, 0, 0, 0),
(200107, 42533, 0, 0, 0),
(200107, 42539, 0, 0, 0),
(200107, 42561, 0, 0, 0),
(200107, 42566, 0, 0, 0),
(200107, 42572, 0, 0, 0),
(200107, 48402, 0, 0, 0),
(200107, 48404, 0, 0, 0),
(200107, 48406, 0, 0, 0),
(200107, 48408, 0, 0, 0),
(200107, 48410, 0, 0, 0),
(200107, 48412, 0, 0, 0),
(200107, 48414, 0, 0, 0),
(200107, 48420, 0, 0, 0),
(200107, 48422, 0, 0, 0),
(200107, 48424, 0, 0, 0),
(200107, 48426, 0, 0, 0),
(200107, 48428, 0, 0, 0),
(200107, 48432, 0, 0, 0),
(200107, 48435, 0, 0, 0),
(200107, 48438, 0, 0, 0),
(200107, 48440, 0, 0, 0),
(200107, 48442, 0, 0, 0),
(200107, 48444, 0, 0, 0),
(200107, 48507, 0, 0, 0),
(200107, 48509, 0, 0, 0),
(200107, 48511, 0, 0, 0),
(200107, 48513, 0, 0, 0),
(200107, 48515, 0, 0, 0),
(200107, 48517, 0, 0, 0),
(200107, 48519, 0, 0, 0),
(200107, 48521, 0, 0, 0),
(200107, 48523, 0, 0, 0),
(200107, 49185, 0, 0, 0),
(200107, 49187, 0, 0, 0),
(200107, 49191, 0, 0, 0);
При использовании материалов, активная ссылка на сайт ixnfo.com обязательна.

Добавить комментарий