Код:
REPLACE INTO `creature_template` (`entry`, `heroic_entry`, `unk1`, `unk2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `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`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (789013, 0, 0, 0, 27557, 27557, 27557, 27557, 'New Items', 'by BIBUS', '', 75, 80, 150000, 151000, 0, 0, 9730, 35, 35, 128, 1, 1, 0, 300, 560, 0, 370, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '');
DELETE FROM `npc_vendor` WHERE (`entry`=789013);
INSERT INTO `npc_vendor` (entry, item, maxcount, incrtime, ExtendedCost) VALUES
(789013, 45086, 0, 0, 0),
(789013, 45106, 0, 0, 0),
(789013, 45110, 0, 0, 0),
(789013, 45112, 0, 0, 0),
(789013, 45113, 0, 0, 0),
(789013, 45114, 0, 0, 0),
(789013, 45116, 0, 0, 0),
(789013, 45132, 0, 0, 0),
(789013, 45133, 0, 0, 0),
(789013, 45137, 0, 0, 0),
(789013, 45138, 0, 0, 0),
(789013, 45142, 0, 0, 0),
(789013, 45144, 0, 0, 0),
(789013, 45147, 0, 0, 0),
(789013, 45148, 0, 0, 0),
(789013, 45157, 0, 0, 0),
(789013, 45158, 0, 0, 0),
(789013, 45165, 0, 0, 0),
(789013, 45168, 0, 0, 0),
(789013, 45169, 0, 0, 0),
(789013, 45170, 0, 0, 0),
(789013, 45193, 0, 0, 0),
(789013, 45224, 0, 0, 0),
(789013, 45234, 0, 0, 0),
(789013, 45235, 0, 0, 0),
(789013, 45236, 0, 0, 0),
(789013, 45242, 0, 0, 0),
(789013, 45243, 0, 0, 0),
(789013, 45246, 0, 0, 0),
(789013, 45255, 0, 0, 0),
(789013, 45257, 0, 0, 0),
(789013, 45261, 0, 0, 0),
(789013, 45262, 0, 0, 0),
(789013, 45263, 0, 0, 0),
(789013, 45266, 0, 0, 0),
(789013, 45270, 0, 0, 0),
(789013, 45284, 0, 0, 0),
(789013, 45285, 0, 0, 0),
(789013, 45286, 0, 0, 0),
(789013, 45292, 0, 0, 0),
(789013, 45296, 0, 0, 0),
(789013, 45297, 0, 0, 0),
(789013, 45303, 0, 0, 0),
(789013, 45308, 0, 0, 0),
(789013, 45313, 0, 0, 0),
(789013, 45314, 0, 0, 0),
(789013, 45315, 0, 0, 0),
(789013, 45318, 0, 0, 0),
(789013, 45319, 0, 0, 0),
(789013, 45322, 0, 0, 0),
(789013, 45326, 0, 0, 0),
(789013, 45327, 0, 0, 0),
(789013, 45330, 0, 0, 0),
(789013, 45418, 0, 0, 0),
(789013, 45436, 0, 0, 0),
(789013, 45437, 0, 0, 0),
(789013, 45438, 0, 0, 0),
(789013, 45442, 0, 0, 0),
(789013, 45443, 0, 0, 0),
(789013, 45447, 0, 0, 0),
(789013, 45456, 0, 0, 0),
(789013, 45457, 0, 0, 0),
(789013, 45459, 0, 0, 0),
(789013, 45461, 0, 0, 0),
(789013, 45466, 0, 0, 0),
(789013, 45469, 0, 0, 0),
(789013, 45470, 0, 0, 0),
(789013, 45471, 0, 0, 0),
(789013, 45480, 0, 0, 0),
(789013, 45485, 0, 0, 0),
(789013, 45486, 0, 0, 0),
(789013, 45489, 0, 0, 0),
(789013, 45490, 0, 0, 0),
(789013, 45493, 0, 0, 0),
(789013, 45496, 0, 0, 0),
(789013, 45498, 0, 0, 0),
(789013, 45510, 0, 0, 0),
(789013, 45511, 0, 0, 0),
(789013, 45516, 0, 0, 0),
(789013, 45518, 0, 0, 0),
(789013, 45521, 0, 0, 0),
(789013, 45522, 0, 0, 0),
(789013, 45525, 0, 0, 0),
(789013, 45527, 0, 0, 0),
(789013, 45529, 0, 0, 0),
(789013, 45535, 0, 0, 0),
(789013, 45570, 0, 0, 0),
(789013, 45605, 0, 0, 0),
(789013, 45607, 0, 0, 0),
(789013, 45612, 0, 0, 0),
(789013, 45613, 0, 0, 0),
(789013, 45675, 0, 0, 0),
(789013, 45682, 0, 0, 0),
(789013, 45696, 0, 0, 0),
(789013, 45699, 0, 0, 0),
(789013, 45702, 0, 0, 0),
(789013, 45703, 0, 0, 0),
(789013, 45704, 0, 0, 0),
(789013, 45707, 0, 0, 0),
(789013, 45866, 0, 0, 0),
(789013, 45872, 0, 0, 0),
(789013, 45873, 0, 0, 0),
(789013, 45874, 0, 0, 0),
(789013, 45877, 0, 0, 0),
(789013, 45887, 0, 0, 0),
(789013, 45929, 0, 0, 0),
(789013, 45931, 0, 0, 0),
(789013, 45933, 0, 0, 0),
(789013, 45948, 0, 0, 0),
(789013, 45973, 0, 0, 0),
(789013, 46008, 0, 0, 0),
(789013, 46010, 0, 0, 0),
(789013, 46014, 0, 0, 0),
(789013, 46015, 0, 0, 0),
(789013, 46018, 0, 0, 0),
(789013, 46021, 0, 0, 0),
(789013, 46022, 0, 0, 0),
(789013, 46032, 0, 0, 0),
(789013, 46096, 0, 0, 0),