Jump to content

  • Announcements

    • Xmat

      Pravidlo pro postování v TTT

      Do sekce Tipy, triky, tutoriály nepatří žádné dotazy.   Postujte sem vaše návody, tipy a různé další věci jež uznáte za vhodné sdělit zdejšímu osazenstvu, ale veškeré dotazy směřujte do sekce Všeobecná diskuse.
    • Replik

      Seznam návodů a důležitých témat v této sekci

      Pro lepší přehlednost jsem vytvořil tento seznam, který vás, méně zkušené, lépe provede touto sekcí. Věřím, že zde najdete, co hledáte. Vypsané jsou návody, které jsou oficiálně uznané jako návody. Běžné diskuze, které neposkytují postupy a rady zvěřejněny nejsou.   Instalace vlastního MaNGOS Serveru Díky těmto návodům budete (měli by jste být) schopni vytvořit a následně spustit váš vlastní server. Nastavení je pro verze s i bez datadisku.   Instalace MaNGOS Serveru (bez datadisku TBC) - Autor Benny Instalace MaNGOS Serveru (s datadiskem TBC) - Autor Malfik Instalace MaNGOS Serveru v prostředí Linux - Autor charlie Instalace MaNGOS Serveru v prostředí Linux - Autor kupkoid   Chyby a jejich řešení při přihlašování k serveru - Autor Cybe   Zálohování uživatelských dat   Dávkový soubor (BAT soubor) pro vytvoření SQL záloh - Autor Replik   Kompilování - tvoření vlastních release (revizí)   Tvorba kompilací pro Win32 (MangoScript) - Autor bLuma   Ostatní - těžko zařaditelné, ale neznamená to, že nejsou dobré   VIP Systém - Autor charlie Tvorba Webových stránek pro MaNGOS - Autor zahuba Tvorba teleportačních NPC (MangoScript) - Autor Replik Registrační web (původně předělaná SPORA) Funkční pro Antrix i MaNGOS - Autor Replik Nastavení a spuštění Minimanager pro MaNGOS - Autor BlackMartin Nastavení MaNGOS Website - Autor Artorius   Samozřejmě jsou zde i jiné návody, ale tyto jsou nejvíce používané, proto věřím, že vám budou nápomocné. Tuto sekci budeme upravovat podle potřeby. Pokud by jste něco nenašli nebo si nevěděli rady, hledejte na fóru a teprve potom založte vlastní topik. Pokud nějaký autor vytvoří kvalitní návod a chtěl by ho zveřejnit i v tomto seznamu, doporučuji, aby mi napsal zprávu skrze PM.   Díky a přeji hezký den na WoWResource   Replik
    • Aristo

      Příspěvky tam, kde nemají co dělat

      Dodržujte zákaz přispívání do topiků s repaky pokud si to zakladatelé nepřejí!! Opakované psaní příspěvků bude trestáno warnem.
    • Aristo

      Používání spoilerů

      Poslední dobou má většina uživatelů fora zvláštní nutkání postovat extrémně dlouhé texty nebo kódy, které zabírají v nejedenom případu i 80% obsahu celé stránky a hodně tak zvedají nepřehlednost v topiku. Chtěl bych všechny uživatele požádat, aby při postování citací, jakýchkoliv kódů, errorů, atp... delších než 30 řádků používali funkci spoileru.   Funkci vyvoláte příkazem [spoiler] text [/spoiler]   Ukázka:  
Sign in to follow this  
Followers 0
Dafo

Full Vendors For MaNGOS

By Dafo, in MaNGOS

Recommended Posts

Dafo    0

Dafo
Posted (edited)

Vsetkých Vendorov najdes tu

2.2.3

http://filebeam.com/d5a377394c39919df5209efa19ce675b

2.3.0

http://filebeam.com/ad243f2e2be1731cf446c3b1ade5fbde

Dungeon 1 Vendor

Dungeon 2 Vendor

Dungeon 3 Vendor

Raid Tier 1 Vendor

Raid Tier 2 Vendor

Raid Tier 3 Vendor

Raid Tier 4 Vendor

Raid Tier 5 Vendor

Raid Tier 6 Vendor

Wrist Vendor

Waist Vendor

Feet Vendor

Shield Vendor

Weapons Level 50+ Vendor

Weapons Level 60+ Vendor

Weapons Level 65+ Vendor

Weapons Level 100+ Vendor

Necklace Vendor

Rings Vendor

Trinket Vendor

Cloak Vendor

Miscellaneous Armor Vendor

Off-Hands Vendor

Mount I Vendor

Mount II Vendor

Keys Vendor

Container Vendor

A dalsie ..

Edited by Dafo

Share this post

Link to post
Share on other sites

radim1    0

radim1
Posted (edited)
Muzes nejak upresnit, o jake vendory se jedna ?

 

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500000, 15511, 15511, "Dungeon 1 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500001, 15511, 15511, "Dungeon 2 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500002, 15511, 15511, "Dungeon 3 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500003, 15511, 15511, "Raid Tier 1 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500004, 15511, 15511, "Raid Tier 2 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500005, 15511, 15511, "Raid Tier 3 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500006, 15511, 15511, "Raid Tier 4 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500007, 15511, 15511, "Raid Tier 5 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500008, 15511, 15511, "Raid Tier 6 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500009, 15511, 15511, "Wrist Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500010, 15511, 15511, "Waist Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500011, 15511, 15511, "Feet Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500012, 15511, 15511, "Shield Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500015, 15511, 15511, "Weapons Level 50+ Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500016, 15511, 15511, "Weapons Level 60+ Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500017, 15511, 15511, "Weapons Level 65+ Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500018, 15511, 15511, "Weapons Level 75+ Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500019, 15511, 15511, "Weapons Level 100+ Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500020, 15511, 15511, "Necklace Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500021, 15511, 15511, "Rings Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500022, 15511, 15511, "Trinket Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500023, 15511, 15511, "Cloak Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500026, 15511, 15511, "Miscellaneous Armor Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500028, 15511, 15511, "Off-Hands Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500029, 15511, 15511, "Libram/Idol/Totem Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500030, 15511, 15511, "Arena Season 1 / 1 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500031, 15511, 15511, "Arena Season 1 / 2 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500032, 15511, 15511, "Arena Season 1 / 3 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500033, 15511, 15511, "Arena Season 2 / 1 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500034, 15511, 15511, "Arena Season 2 / 2 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500035, 15511, 15511, "Arena Season 2 / 3 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500042, 15511, 15511, "Mount I Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500043, 15511, 15511, "Mount II Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500045, 15511, 15511, "Container Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500048, 15511, 15511, "Keys Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");
INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500051, 7175, 7175, "Leather Vendor A-F", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500052, 11689, 11689, "Leather Vendor G-R", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500053, 15300, 15300, "Leather Vendor S-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500054, 7175, 7175, "Tailor Vendor A-G", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500055, 11689, 11689, "Tailor Vendor H-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500056, 7175, 7175, "Engineer Vendor A-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500057, 7175, 7175, "Blacksmith Vendor A-F", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500058, 11689, 11689, "Blacksmith Vendor G-R", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500059, 15300, 15300, "Blacksmith Vendor S-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500060, 7175, 7175, "Cooking Vendor A-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500061, 11689, 11689, "Alchemy Vendor A-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500062, 7175, 7175, "Enchant Vendor 1", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500063, 11689, 11689, "Enchant Vendor 2", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500064, 7175, 7175, "Jeweler Vendor A-K", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500065, 15300, 15300, "Jeweler Vendor L-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500066, 7340, 7340, "Reagent / Leather Vendor 1", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500067, 11388, 11388, "Reagent / Leather Vendor 2", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500068, 7340, 7340, "Reagent / Tailor Vendor 1", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500069, 11388, 11388, "Reagent / Tailor Vendor 2", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500070, 7340, 7340, "Reagent / Engineer Vendor 1", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500071, 11388, 11388, "Reagent / Engineer Vendor 2", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500072, 7340, 7340, "Reagent / Blacksmith Vendor 1", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500073, 11388, 11388, "Reagent / Blacksmith Vendor 2", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500074, 7340, 7340, "Reagent / Cooking Vendor", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500075, 11388, 11388, "Reagent / Alchemy Vendor", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500076, 7340, 7340, "Reagent / Enchant Vendor", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500077, 11388, 11388, "Reagent / Jeweler Vendor", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500078, 7340, 7340, "Reagent / Miscellaneous Vendor", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

 

sry za spam :P

Edited by bLuma
celý výpis není nutný -> codebox

Share this post

Link to post
Share on other sites

charlie    13

charlie
Posted
sry za spam :P

 

Ne ze bych si neumel otevrit .sql soubor a vyrozumet z toho, ze se jedna o Tier, Dungeon, Arena , keys atd.. venodry, ale neskodilo by Info pro ostatni a kratky popis.. a take nadpis full neni na miste.

Share this post

Link to post
Share on other sites

radim1    0

radim1
Posted (edited)
Ne ze bych si neumel otevrit .sql soubor a vyrozumet z toho, ze se jedna o Tier, Dungeon, Arena , keys atd.. venodry, ale neskodilo by Info pro ostatni a kratky popis.. a take nadpis full neni na miste.

Tak ok pokud někdo někdy hrál na severu Gears of Warcraft (nechci dělat reklamu takže žádnej link ) vlastně je to fun server běžíci na antrixu ve kterém killneš jedno NPC a pak se portneš pomocí NPC v základní lokaci do lokace kde je hafo vendoru.

Jinak ten full není opravdu ten pravý název ale ve vendorech jsou všechny raid sety nejlepší itemky na lvl 60-70 a je možno na místě naskillovat 375 skill u všech profesí díky vendorum na itemy do profesí.

 

Tak toto obnáší:

Vendory všech D i T setů

Ostatní věci na sebe od lvl 60 včetně libramu,relicu,apod.

Možnost jednoduchého skillování profesí

 

Takže kdyby někdo chtěl parádní Fun DB tak vřele doporučuju ať si executne do DB tento balík :-) :P

 

KAŽDOPÁDNĚ VENDOŘI NEMAJÍ VŠECHNY ITEMY

 

Edit já celou dobu mluvím o DB a přitom to jsou jen vendoři

Už opraveno

Edited by radim1

Share this post

Link to post
Share on other sites

Method-man    1

Method-man
Posted (edited)

omagat ... vendori na vsechny noobovsky itemy ... FUN servery suxs

 

edit: bla bla bla ja wim ze kazdyho nebavi expit ... mg ... tak at wow nehraje kdyz nema rad expeni a normalni schaneni itemu ... :sleeping:

Edited by Method-man

Share this post

Link to post
Share on other sites

Kropotkin    1

Kropotkin
Posted
omagat ... vendori na vsechny noobovsky itemy ... FUN servery suxs

 

edit: bla bla bla ja wim ze kazdyho nebavi expit ... mg ... tak at wow nehraje kdyz nema rad expeni a normalni schaneni itemu ... :sleeping:

nechapu o co ti jde, ja sem hral tri roky na ofiku a proste levlit me uz fakt nebavi, nechci zase ztravit dny, nekdy i tejdny levlenim a pak shanenim equipu, z toho sem uz vyrost a to jeste tuplem ne na neofiku, kdyz nevim kdy ten server skonci, proste fun servery ftw, super na odreagovani

 

jinac s tema aukcema sem to uz vyresil :P

Share this post

Link to post
Share on other sites

dadus666    0

dadus666
Posted (edited)
Vendory Su upraveny na Verziu 2.2.3 a na 2.3.0

nekdo poradi jak ich do hry addnem?..a kam skopcim presne sql?..uprawene?

 

Edited by dadus666

Share this post

Link to post
Share on other sites

Ghostrider    0

Ghostrider
Posted 
INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500000, 15511, 15511, "Dungeon 1 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500001, 15511, 15511, "Dungeon 2 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500002, 15511, 15511, "Dungeon 3 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500003, 15511, 15511, "Raid Tier 1 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500004, 15511, 15511, "Raid Tier 2 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500005, 15511, 15511, "Raid Tier 3 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500006, 15511, 15511, "Raid Tier 4 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500007, 15511, 15511, "Raid Tier 5 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500008, 15511, 15511, "Raid Tier 6 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500009, 15511, 15511, "Wrist Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500010, 15511, 15511, "Waist Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500011, 15511, 15511, "Feet Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500012, 15511, 15511, "Shield Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500015, 15511, 15511, "Weapons Level 50+ Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500016, 15511, 15511, "Weapons Level 60+ Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500017, 15511, 15511, "Weapons Level 65+ Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500018, 15511, 15511, "Weapons Level 75+ Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500019, 15511, 15511, "Weapons Level 100+ Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500020, 15511, 15511, "Necklace Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500021, 15511, 15511, "Rings Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500022, 15511, 15511, "Trinket Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500023, 15511, 15511, "Cloak Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500026, 15511, 15511, "Miscellaneous Armor Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500028, 15511, 15511, "Off-Hands Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500029, 15511, 15511, "Libram/Idol/Totem Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500030, 15511, 15511, "Arena Season 1 / 1 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500031, 15511, 15511, "Arena Season 1 / 2 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500032, 15511, 15511, "Arena Season 1 / 3 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500033, 15511, 15511, "Arena Season 2 / 1 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500034, 15511, 15511, "Arena Season 2 / 2 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500035, 15511, 15511, "Arena Season 2 / 3 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500042, 15511, 15511, "Mount I Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500043, 15511, 15511, "Mount II Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500045, 15511, 15511, "Container Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500048, 15511, 15511, "Keys Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");
INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500051, 7175, 7175, "Leather Vendor A-F", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500052, 11689, 11689, "Leather Vendor G-R", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500053, 15300, 15300, "Leather Vendor S-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500054, 7175, 7175, "Tailor Vendor A-G", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500055, 11689, 11689, "Tailor Vendor H-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500056, 7175, 7175, "Engineer Vendor A-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500057, 7175, 7175, "Blacksmith Vendor A-F", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500058, 11689, 11689, "Blacksmith Vendor G-R", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500059, 15300, 15300, "Blacksmith Vendor S-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500060, 7175, 7175, "Cooking Vendor A-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500061, 11689, 11689, "Alchemy Vendor A-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500062, 7175, 7175, "Enchant Vendor 1", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500063, 11689, 11689, "Enchant Vendor 2", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500064, 7175, 7175, "Jeweler Vendor A-K", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500065, 15300, 15300, "Jeweler Vendor L-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500066, 7340, 7340, "Reagent / Leather Vendor 1", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500067, 11388, 11388, "Reagent / Leather Vendor 2", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500068, 7340, 7340, "Reagent / Tailor Vendor 1", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500069, 11388, 11388, "Reagent / Tailor Vendor 2", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500070, 7340, 7340, "Reagent / Engineer Vendor 1", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500071, 11388, 11388, "Reagent / Engineer Vendor 2", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500072, 7340, 7340, "Reagent / Blacksmith Vendor 1", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500073, 11388, 11388, "Reagent / Blacksmith Vendor 2", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500074, 7340, 7340, "Reagent / Cooking Vendor", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500075, 11388, 11388, "Reagent / Alchemy Vendor", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500076, 7340, 7340, "Reagent / Enchant Vendor", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500077, 11388, 11388, "Reagent / Jeweler Vendor", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500078, 7340, 7340, "Reagent / Miscellaneous Vendor", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

 

sry za spam :P

 

 

 

Dikes já pořád nevěděl jak na to, opravdu si mi hodně poradil. Snad už to půjde a doufám, že někdy bude na mém serveru více lidí než 5 :):whistling:

Share this post

Link to post
Share on other sites

Ghostrider    0

Ghostrider
Posted

:sleeping:

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500000, 15511, 15511, "Dungeon 1 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500001, 15511, 15511, "Dungeon 2 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500002, 15511, 15511, "Dungeon 3 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500003, 15511, 15511, "Raid Tier 1 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500004, 15511, 15511, "Raid Tier 2 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500005, 15511, 15511, "Raid Tier 3 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500006, 15511, 15511, "Raid Tier 4 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500007, 15511, 15511, "Raid Tier 5 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500008, 15511, 15511, "Raid Tier 6 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500009, 15511, 15511, "Wrist Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500010, 15511, 15511, "Waist Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500011, 15511, 15511, "Feet Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500012, 15511, 15511, "Shield Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500015, 15511, 15511, "Weapons Level 50+ Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500016, 15511, 15511, "Weapons Level 60+ Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500017, 15511, 15511, "Weapons Level 65+ Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500018, 15511, 15511, "Weapons Level 75+ Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500019, 15511, 15511, "Weapons Level 100+ Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500020, 15511, 15511, "Necklace Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500021, 15511, 15511, "Rings Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500022, 15511, 15511, "Trinket Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500023, 15511, 15511, "Cloak Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500026, 15511, 15511, "Miscellaneous Armor Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500028, 15511, 15511, "Off-Hands Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500029, 15511, 15511, "Libram/Idol/Totem Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500030, 15511, 15511, "Arena Season 1 / 1 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500031, 15511, 15511, "Arena Season 1 / 2 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500032, 15511, 15511, "Arena Season 1 / 3 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500033, 15511, 15511, "Arena Season 2 / 1 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500034, 15511, 15511, "Arena Season 2 / 2 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500035, 15511, 15511, "Arena Season 2 / 3 Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500042, 15511, 15511, "Mount I Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500043, 15511, 15511, "Mount II Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500045, 15511, 15511, "Container Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500048, 15511, 15511, "Keys Vendor", "Server Vendors", 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 16388, 1.15, 1, 10000, 10000, 0, 10000, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, "", 0, 3, 0, 1, 0, "");
INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500051, 7175, 7175, "Leather Vendor A-F", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500052, 11689, 11689, "Leather Vendor G-R", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500053, 15300, 15300, "Leather Vendor S-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500054, 7175, 7175, "Tailor Vendor A-G", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500055, 11689, 11689, "Tailor Vendor H-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500056, 7175, 7175, "Engineer Vendor A-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500057, 7175, 7175, "Blacksmith Vendor A-F", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500058, 11689, 11689, "Blacksmith Vendor G-R", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500059, 15300, 15300, "Blacksmith Vendor S-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500060, 7175, 7175, "Cooking Vendor A-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500061, 11689, 11689, "Alchemy Vendor A-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500062, 7175, 7175, "Enchant Vendor 1", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500063, 11689, 11689, "Enchant Vendor 2", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500064, 7175, 7175, "Jeweler Vendor A-K", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500065, 15300, 15300, "Jeweler Vendor L-Z", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500066, 7340, 7340, "Reagent / Leather Vendor 1", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500067, 11388, 11388, "Reagent / Leather Vendor 2", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500068, 7340, 7340, "Reagent / Tailor Vendor 1", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500069, 11388, 11388, "Reagent / Tailor Vendor 2", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500070, 7340, 7340, "Reagent / Engineer Vendor 1", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500071, 11388, 11388, "Reagent / Engineer Vendor 2", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500072, 7340, 7340, "Reagent / Blacksmith Vendor 1", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500073, 11388, 11388, "Reagent / Blacksmith Vendor 2", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500074, 7340, 7340, "Reagent / Cooking Vendor", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500075, 11388, 11388, "Reagent / Alchemy Vendor", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500076, 7340, 7340, "Reagent / Enchant Vendor", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500077, 11388, 11388, "Reagent / Jeweler Vendor", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

INSERT INTO creature_template
 (entry, modelid_A, modelid_H, name, subname, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, RegenHealth, equipment_id, ScriptName)
VALUES
 (500078, 7340, 7340, "Reagent / Miscellaneous Vendor", "Server Vendors", 81, 81, 100000, 100000, 50000, 60000, 1, 474, 474, 16388, 1.15, 1, 624, 871, 0, 100, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 0, 138936390, 4890, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 51400, "", 0, 3, 0, 1, 0, "");

 

sry za spam :P

 

 

Sry ze otravuju, ale od toho to forko je abych se ptal a tak sem se chtel zeptat, jak ty Full vendory rozfakat protoze kdyz je vlozim k sobe na server tak to jsou prosti blood elf guardi s nazvem jako je Tier 1, Tier 2 atd. ale nic neprodavaji pouze kecaji, a to me celkem ste.... dikes m za odpoved

 

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0
Go To Topic Listing MaNGOS
×