Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Creates custom vendor that sells Season 8 PvP items
- DELETE FROM creature_template WHERE entry=60000;
- INSERT 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, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, unit_flags2, 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, HoverHeight, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName, VerifiedBuild)
- VALUES (60000, 0, 0, 0, 0, 0, 23473, 0, 0, 0, "Shadow Assasin", "Season 8 PvP", "Bag", 0, 80, 80, 0, 35, 128, 1, 1.14286, 1, 0, 2000, 2000, 0, 2000, 1, 2000, 2000, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 2000, 2000, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'SmartAI', 0, 3, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, "", 1);
- -- Spawn data
- DELETE FROM creature WHERE guid=200000;
- 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 (200000, 60000, 0, 1, 1, 0, 0, 5801.116699, 584.745117, 660.089111, 0.570902, 310, 0, 0, 300000, 0, 0, 0, 0, 0);
- -- Season 8 Death Knight
- DELETE FROM npc_vendor WHERE entry=60000 AND item IN (51413, 51414, 51415, 51416, 51418);
- INSERT INTO npc_vendor VALUES (60000, 0, 51413, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 1, 51414, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 2, 51415, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 3, 51416, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 4, 51418, 0, 0, 0);
- -- Season 8 Druid(Healer)
- DELETE FROM npc_vendor WHERE entry=60000 AND item IN (51419, 51420, 51421, 51422, 51424);
- INSERT INTO npc_vendor VALUES (60000, 0, 51419, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 1, 51420, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 2, 51421, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 3, 51422, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 4, 51424, 0, 0, 0);
- -- Season 8 Druid(Meele DPS)
- DELETE FROM npc_vendor WHERE entry=60000 AND item IN (51425, 51426, 51427, 51428, 51430);
- INSERT INTO npc_vendor VALUES (60000, 5, 51425, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 6, 51426, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 7, 51427, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 8, 51428, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 9, 51430, 0, 0, 0);
- -- Season 8 Druid(Caster DPS)
- DELETE FROM npc_vendor WHERE entry=60000 AND item IN (51433, 51434, 51435, 51436, 51438);
- INSERT INTO npc_vendor VALUES (60000, 10, 51433, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 11, 51434, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 12, 51435, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 13, 51436, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 14, 51438, 0, 0, 0);
- -- Season 8 Hunter
- DELETE FROM npc_vendor WHERE entry=60000 AND item IN (51458, 51459, 51460, 51461, 51462);
- INSERT INTO npc_vendor VALUES (60000, 0, 51458, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 1, 51459, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 2, 51460, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 3, 51461, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 4, 51462, 0, 0, 0);
- -- Season 8 Mage
- DELETE FROM npc_vendor WHERE entry=60000 AND item IN (51463, 51464, 51465, 51466, 51467);
- INSERT INTO npc_vendor VALUES (60000, 0, 51463, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 1, 51464, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 2, 51465, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 3, 51466, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 4, 51467, 0, 0, 0);
- -- Season 8 Paladin(Healer)
- DELETE FROM npc_vendor WHERE entry=60000 AND item IN (51468, 51469, 51470, 51471, 51473);
- INSERT INTO npc_vendor VALUES (60000, 0, 51468, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 1, 51469, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 2, 51470, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 3, 51471, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 4, 51473, 0, 0, 0);
- -- Season 8 Paladin(Melee DPS)
- DELETE FROM npc_vendor WHERE entry=60000 AND item IN (51474, 51475, 51476, 51477, 51479);
- INSERT INTO npc_vendor VALUES (60000, 5, 51474, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 6, 51475, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 7, 51476, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 8, 51477, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 9, 51479, 0, 0, 0);
- -- Season 8 Priest(Healer)
- DELETE FROM npc_vendor WHERE entry=60000 AND item IN (51482, 51483, 51484, 51485, 51486);
- INSERT INTO npc_vendor VALUES (60000, 0, 51482, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 1, 51483, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 2, 51484, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 3, 51485, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 4, 51486, 0, 0, 0);
- -- Season 8 Priest(Caster DPS)
- DELETE FROM npc_vendor WHERE entry=60000 AND item IN (51487, 51488, 51489, 51490, 51491);
- INSERT INTO npc_vendor VALUES (60000, 5, 51487, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 6, 51488, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 7, 51489, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 8, 51490, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 9, 51491, 0, 0, 0);
- -- Season 8 Rogue
- DELETE FROM npc_vendor WHERE entry=60000 AND item IN (51492, 51493, 51494, 51495, 51496);
- INSERT INTO npc_vendor VALUES (60000, 0, 51492, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 1, 51493, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 2, 51494, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 3, 51495, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 4, 51496, 0, 0, 0);
- -- Season 8 Shaman(Healer)
- DELETE FROM npc_vendor WHERE entry=60000 AND item IN (51497, 51498, 51499, 51500, 51502);
- INSERT INTO npc_vendor VALUES (60000, 0, 51497, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 1, 51498, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 2, 51499, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 3, 51500, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 4, 51502, 0, 0, 0);
- -- Season 8 Shaman(Meele DPS)
- DELETE FROM npc_vendor WHERE entry=60000 AND item IN (51503, 51504, 51505, 51506, 51508);
- INSERT INTO npc_vendor VALUES (60000, 5, 51503, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 6, 51504, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 7, 51505, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 8, 51506, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 9, 51508, 0, 0, 0);
- -- Season 8 Shaman(Caster DPS)
- DELETE FROM npc_vendor WHERE entry=60000 AND item IN (51509, 51510, 51511, 51512, 51514);
- INSERT INTO npc_vendor VALUES (60000, 10, 51509, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 11, 51510, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 12, 51511, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 13, 51512, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 14, 51514, 0, 0, 0);
- -- Season 8 Warlock
- DELETE FROM npc_vendor WHERE entry=60000 AND item IN (51536, 51537, 51538, 51539, 51540);
- INSERT INTO npc_vendor VALUES (60000, 0, 51536, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 1, 51537, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 2, 51538, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 3, 51539, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 4, 51540, 0, 0, 0);
- -- Season 8 Warrior
- DELETE FROM npc_vendor WHERE entry=60000 AND item IN (51541, 51542, 51543, 51544, 51545);
- INSERT INTO npc_vendor VALUES (60000, 0, 51541, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 1, 51542, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 2, 51543, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 3, 51544, 0, 0, 0);
- INSERT INTO npc_vendor VALUES (60000, 4, 51545, 0, 0, 0);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement