[3.2.2a]vendoři----->profese

jakub129 · February 3, 2010

Cus schaním vendory co bi prodavaly itemy potrebne na profese (LW,BS,ENG ....)např. šutry látky atd jestli jste nekdy hrly na deffendru fun tak taky....

Edited February 3, 2010 by jakub129

Wladass · February 3, 2010

Supplies Vendors 3.2.2a

Obsahuje:

Alchemy Supplies

Blacksmithing Supplies

Enchanting Supplies

Engineering Supplies

Inscription Supplies

Jewelcrafting Supplies

Leatherworking Supplies

Mining Supplies

Skinning Supplies

Tailoring Supplies

Download:

DOWNLOAD NOW!

Cloth Vendor 3.2.2a

Obsahuje:

Veškeré látky,bolty,silky.

Download:

DOWNLOAD NOW!

Metal Vendor 3.2.2a

Obsahuje:

Vešketé kameny,bary a stony.

Download:

DOWNLOAD NOW!

Herb Vendor 3.2.2a

Obsahuje:

Veškeré kytky

Download:

DOWNLOAD NOW!

Glyph Vendor 3.2.2a

Obsahuje:

Veškeré glyphy.

Download:

DOWNLOAD NOW!

Pattern Vendor 3.2.2a

Obsahuje:

Veškeré svitky na Jewelcrafting

Download:

DOWNLOAD NOW!

Enchanting Vendor 3.2.2a

Obsahuje:

Veškeré esence,dusty,rody a shardy potřebné pro enchanting.

Download:

DOWNLOAD NOW!

Vše je děláno bez zadání entry NPC, stačí nahradit XXX za entry vendora a je to

Pro začátečníky : Nemusíte ručně přepisovat XXX stačí CTRL+H a nahradit všechny XXX na npc entry

Mělo by to fungovat i na 3.3.0

Samozřejmě se může stát že některé itemy bude vendor dávat zadarmo, cenu lze upravit v item_template ve sloupečku BuyPrice.

Edited February 4, 2010 by Wladass

STONERSVK · February 3, 2010

hm prave si mi usetril praci diky +1 samo

jakub129 · February 3, 2010

hle ten supplies vendor my hazy eror nevite cim to je obrazek v přiloze

Wladass · February 3, 2010

Dej tam INSERT IGNORE INTO místo INSERT INTO

Jsou tam některé itemy dvakrát, nekontroloval sem to..

Edited February 3, 2010 by Wladass

Cäsh · February 3, 2010

Místo INSERT INTO bych používal spíš REPLACE INTO V případě, že by už pod tím byly v DB data tak je to nahradí

Wladass · February 3, 2010

Pokud se jedná o duplikatni příkaz tak ti REPLACE INTO vyhodí error jako INSERT INTO :sleeping:

ZechY · February 3, 2010

Já souhlasím s Cäsh(co), mě to tedy vždy šlo, když se mi objevil tenhle error. Tak jsem zaměnil INSERT INTO za REPLACE INTO a šlo to v pohodě

Wladass · February 3, 2010

Ano REPLACE INTO se používá pokud ty záznamy v db už jsou,ale ne když v querry jsou dva stejné záznamy... Podívej se na popis toho erroru :whistling:

Cäsh · February 3, 2010

Já to myslel všeobecně Nemyslel jsem to přímo k tomu erroru Na to už jsi odpověď napsal

Wladass · February 3, 2010

Pokud je to nový vendor což jsem předpokládal tak replace není potřeba..

Edited February 4, 2010 by Wladass

Wladass · February 4, 2010

[changes]

Přidán:

Glyph Vendor.

Pattern Vendor.

Enchanting Vendor

[/changes]

Edited February 4, 2010 by Wladass

jakub129 · February 8, 2010

cus hle stahnul jsem si vendory z ac-web.org a hazeji my chybu

Error Code: 1136 - Column count doesn't match value count at row 1

Query:
REPLACE INTO `creature_template` VALUES (900065, 0, 0, 0, 0, 0, 8841, 0, 8841, 0, 'Alchemy Vendor', 'RealFun', '', 99, 99, 100000, 100000, 10000, 10000, 500000, 35, 35, 129, 1, 1.2, 0, 3000, 5000, 0, 0, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 20, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '')

tady jsou pls řeknete my nekdo kde je chyba

http://uploaded.to/file/9u8zer

Wladass · February 8, 2010

Nesedí ti počet sloupečků v definici a v tvé db. Když už stahuješ takovýhle ptákoviny musíš na svojí db,nebo si to pak upravit.

Edit: Jako když jsem vidět ten tvůj soubor a viděl jsem :

REPLACE INTO `creature_template` VALUES
(`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`,`scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName` )
VALUES
(900068, 0, 0, 0, 0, 0, 8841, 0, 8841, 0, 'Engeneering Vendor', 'RealFun', '', 99, 99, 100000, 100000, 10000, 10000, 500000, 35, 35, 129, 1, 1.2, 0, 3000, 5000, 0, 0, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 20, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '') ;

Tak jsem se celkem posmál, zajímalo by mě jakej šikula to dělal Je tam hodně těhle ptákovin, tak si to uprav tak jak to má být

Tohle je taky pěkný :

DELETE FROM npc_vendor WHERE entry BETWEEN 900095 and 900095;
DELETE FROM creature_template WHERE entry BETWEEN 900095 and 900095;

Edited February 8, 2010 by Wladass

jakub129 · February 8, 2010

no ten šikula jsem ja :lol: :whistling: trosku jsem si stim hral , sem začátečník , mohl bysi my to pls opravit neo alespon řict jak na to dik

tohle uz tam bylo :

DELETE FROM npc_vendor WHERE entry BETWEEN 900095 and 900095;
DELETE FROM creature_template WHERE entry BETWEEN 900095 and 900095;

Edited February 8, 2010 by jakub129

Wladass · February 8, 2010

Aha takže kod :

REPLACE INTO `creature_template` VALUES  (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`,`scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName` )  VALUES  (900068, 0, 0, 0, 0, 0, 8841, 0, 8841, 0, 'Engeneering Vendor', 'RealFun', '', 99, 99, 100000, 100000, 10000, 10000, 500000, 35, 35, 129, 1, 1.2, 0, 3000, 5000, 0, 0, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 20, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '') ;

Nahraď kódem :

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`,`scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName` )  VALUES  (900068, 0, 0, 0, 0, 0, 8841, 0, 8841, 0, 'Engeneering Vendor', 'RealFun', '', 99, 99, 100000, 100000, 10000, 10000, 500000, 35, 35, 129, 1, 1.2, 0, 3000, 5000, 0, 0, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 20, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '') ;

A kódy typu:

DELETE FROM npc_vendor WHERE entry BETWEEN 900095 and 900095; 
DELETE FROM creature_template WHERE entry BETWEEN 900095 and 900095;

(Navíc by ti to ani nic nesmazalo jen 900095 je špatně syntax.)

Nemusíš dávat když používáš plnění tabulky pomocí replace. Kdyby jsi používal Insert jako většina developerů tak by se Delete dávalo před Insert takto :

DELETE FROM creature_template WHERE entry=900095;
INSERT INTO `creature_template`  (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`,`scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName` )  VALUES  (900095, 0, 0, 0, 0, 0, 8841, 0, 8841, 0, 'Recipe Vendor', 'RealFun', '', 99, 99, 100000, 100000, 10000, 10000, 500000, 35, 35, 129, 1, 1.2, 0, 3000, 5000, 0, 0, 1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 20, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '') ;

Edited February 8, 2010 by Wladass

Kropotkin · March 8, 2010

Přihodim sem pár upravených vendorů odemně, ať je to po kupě, u někteří se musí ještě rozhodit na dva, kvůli hodně itemům, ale to by neměl být problém.

Schválně nepoužívám delete a replace, pokud to někomu vadí, tak si to pře(při)pište

Kdyby se vyskytly nějaké chyby, tak mě napište opravim.

/*TAILORING*/

INSERT INTO creature_template(entry, modelid1, name, subname, minlevel, maxlevel, faction_A, faction_H, npcflag, health_mod) VALUES ('800009', '26376', 'Tailoring', 'Vendor', '55', '55', '35', '35', '128', '1');

INSERT INTO npc_vendor VALUES ('800009','47556','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','45087','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','43102','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','42253','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','41595','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','41594','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','41593','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','41520','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','41511','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','41510','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','38426','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','38425','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','36934','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','36930','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','36925','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','36922','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','36919','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','36908','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','36784','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','36783','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','34664','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','34054','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','34052','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','33470','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','32428','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','30183','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','24272','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','24271','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','23112','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','22794','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','22450','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','22446','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','22445','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','21882','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','21881','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','21877','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','21844','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','21842','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','21840','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','19726','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','18240','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','14341','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','14044','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','13926','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','13468','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','12811','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','12809','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','12808','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','12803','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','12662','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','12364','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','11176','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','11137','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','10290','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','10286','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','10285','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','10026','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','9210','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','8343','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','7971','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','7082','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','7078','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','7076','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','7072','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','7071','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','6371','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','6261','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','6260','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','6048','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','5500','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','5498','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','4342','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','4341','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','4340','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','4339','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','4337','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','4305','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','4291','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','3864','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','3824','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','3383','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','3182','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','2996','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','2605','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','2604','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','2325','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','2324','0','0','0');

INSERT INTO npc_vendor VALUES ('800009','2320','0','0','0');

/*SKINNING*/

INSERT INTO creature_template(entry, modelid1, name, subname, minlevel, maxlevel, faction_A, faction_H, npcflag, health_mod) VALUES ('800017', '22121', 'Skinning', 'Vendor', '55', '55', '35', '35', '128', '1');

INSERT INTO npc_vendor VALUES ('800017','7005','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','40893','0','0','0');

/*MINING*/

INSERT INTO creature_template(entry, modelid1, name, subname, minlevel, maxlevel, faction_A, faction_H, npcflag, health_mod) VALUES ('800016', '24289', 'Mining', 'Vendor', '55', '55', '35', '35', '128', '1');

INSERT INTO npc_vendor VALUES ('800016','41163','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','37663','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','36916','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','36913','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','36912','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','36910','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','36909','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','35128','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','23573','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','23449','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','23447','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','23446','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','23427','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','23426','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','23425','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','23424','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','18567','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','18562','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','11176','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','10620','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','7911','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','3859','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','3858','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','2841','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','2776','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','2775','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','2772','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','2771','0','0','0');

INSERT INTO npc_vendor VALUES ('800016','2770','0','0','0');

/*LEATHERWORKING*/

INSERT INTO creature_template(entry, modelid1, name, subname, minlevel, maxlevel, faction_A, faction_H, npcflag, health_mod) VALUES ('800013', '24208', 'Leatherworking', 'Vendor', '55', '55', '35', '35', '128', '1');

INSERT INTO npc_vendor VALUES ('800013','47556','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','45087','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','44128','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','43102','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','38561','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','38558','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','38557','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','38425','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','34664','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','34057','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','34055','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','33568','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','33567','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','32428','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','30183','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','29548','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','29547','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','29539','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','25708','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','25707','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','25700','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','25699','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','25649','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','23793','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','22450','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','22448','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','22445','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','21844','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','20501','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','20500','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','20498','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','20381','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','19726','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','18512','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','18240','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','17056','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','15419','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','15417','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','15415','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','15414','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','15412','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','15410','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','15409','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','14341','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','14044','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','12809','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','12803','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','12607','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','10285','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','8951','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','8949','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','8343','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','8172','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','8171','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','8169','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','8167','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','8154','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','8151','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','7971','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','7392','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','7387','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','7287','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','7286','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','7082','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','7081','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','7078','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','7076','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','7075','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','7071','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','6471','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','6470','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','5966','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','5785','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','5784','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','5637','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','5633','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','5500','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','5498','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','5373','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','5082','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','4461','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','4342','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','4340','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','4337','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','4305','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','4291','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','4289','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','4255','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','4246','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','4243','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','4236','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','4235','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','4233','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','4232','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','4231','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','4096','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','3864','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','3824','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','3390','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','3389','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','3383','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','3356','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','3182','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','2934','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','2605','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','2604','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','2459','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','2457','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','2325','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','2324','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','2320','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','1206','0','0','0');

INSERT INTO npc_vendor VALUES ('800013','783','0','0','0');

/*JEWELCRAFTING*/

INSERT INTO creature_template(entry, modelid1, name, subname, minlevel, maxlevel, faction_A, faction_H, npcflag, health_mod) VALUES ('800011', '28698', 'Jewelcrafting', 'Vendor', '55', '55', '35', '35', '128', '1');

INSERT INTO npc_vendor VALUES ('800011','43102','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','42225','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','41334','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','41266','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','41163','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','36934','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','36933','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','36931','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','36930','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','36928','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','36927','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','36925','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','36924','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','36922','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','36921','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','36920','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','36919','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','36918','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','36917','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','36784','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','36783','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','35128','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','34664','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','34054','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','34052','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','32249','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','32231','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','32230','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','32229','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','32228','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','32227','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','31079','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','27860','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','25868','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','25867','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','24479','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','24478','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','24243','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','23573','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','23449','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','23447','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','23446','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','23441','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','23440','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','23439','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','23438','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','23437','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','23436','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','23117','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','23112','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','23107','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','23079','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','23077','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','21929','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','21752','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','20963','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','20817','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','20816','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','18335','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','12938','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','12808','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','12803','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','12799','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','12662','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','12365','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','12364','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','11178','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','11137','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','11083','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','10286','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','8151','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','7971','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','7912','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','7909','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','7082','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','7081','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','7078','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','7076','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','7075','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','6149','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','5637','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','5498','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','3864','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','3824','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','3391','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','2841','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','2838','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','2836','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','2835','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','1705','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','1210','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','1206','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','818','0','0','0');

INSERT INTO npc_vendor VALUES ('800011','774','0','0','0');

/*INSCRIPTION*/

INSERT INTO creature_template(entry, modelid1, name, subname, minlevel, maxlevel, faction_A, faction_H, npcflag, health_mod) VALUES ('800014', '28152', 'Inscription', 'Vendor', '55', '55', '35', '35', '128', '1');

INSERT INTO npc_vendor VALUES ('800014','43127','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43126','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43125','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43124','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43123','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43122','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43121','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43120','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43119','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43118','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43117','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43116','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43115','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43109','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43108','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43107','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43106','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43105','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43104','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43103','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','43102','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','39774','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','39502','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','39501','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','39469','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','39354','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','39343','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','39342','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','39341','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','39340','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','39339','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','39338','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','39334','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','39151','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','37101','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','27503','0','0','0');

INSERT INTO npc_vendor VALUES ('800014','10648','0','0','0');

/*ENGINEERING*/

INSERT INTO creature_template(entry, modelid1, name, subname, minlevel, maxlevel, faction_A, faction_H, npcflag, health_mod) VALUES ('800017', '24295', 'Engineering', 'Vendor', '55', '55', '35', '35', '128', '1');

INSERT INTO npc_vendor VALUES ('800017','44501','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','44500','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','44499','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','44128','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','43102','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','42546','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','41163','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','41146','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','40769','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','40533','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','39690','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','39684','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','39683','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','38425','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','37663','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','36933','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','36930','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','36927','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','36924','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','36921','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','36920','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','36918','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','36916','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','36913','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','35128','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','34249','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','34113','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','34052','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','33568','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','33470','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','32495','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','32494','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','32480','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','32479','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','32478','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','32476','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','32475','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','32474','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','32473','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','32472','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','32461','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','32423','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','24272','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','24271','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23826','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23793','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23787','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23786','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23785','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23783','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23782','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23781','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23573','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23449','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23446','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23441','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23440','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23439','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23438','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23437','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23436','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23112','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23079','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','23077','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','22832','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','22829','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','22449','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','22448','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','22445','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','21929','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','21877','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','21840','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','20816','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','19726','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','18631','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','18232','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','17202','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','17020','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','15992','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','13467','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','12808','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','12803','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','12799','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','12365','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','12364','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','11291','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','10648','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','10647','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','10592','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','10586','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','10577','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','10576','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','10560','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','10558','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','10546','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','10543','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','10507','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','10505','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','10502','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','10500','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','10286','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','10285','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','10026','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','9060','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','8151','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','7912','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','7909','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','7387','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','7191','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','7082','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','7078','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','7076','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','7075','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','7005','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','6530','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','6260','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','5956','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4470','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4407','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4404','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4402','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4400','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4399','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4387','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4385','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4382','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4377','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4368','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4364','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4361','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4359','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4357','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4342','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4339','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','4337','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','3864','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','3859','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','2901','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','2880','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','2841','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','2838','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','2836','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','2835','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','2605','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','2604','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','1705','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','1210','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','1206','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','818','0','0','0');

INSERT INTO npc_vendor VALUES ('800017','774','0','0','0');

/*ENCHANTING*/

INSERT INTO creature_template(entry, modelid1, name, subname, minlevel, maxlevel, faction_A, faction_H, npcflag, health_mod) VALUES ('800012', '25635', 'Enchanting', 'Vendor', '55', '55', '35', '35', '128', '1');

INSERT INTO npc_vendor VALUES ('800012','44958','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','41745','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','41163','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','37663','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','36918','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','34057','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','34056','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','34055','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','34054','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','34052','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','25845','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','25844','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','25843','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','23427','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','22824','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','22794','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','22792','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','22791','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','22463','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','22462','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','22461','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','22450','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','22449','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','22448','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','22447','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','22446','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','22445','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','17035','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','17034','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','16207','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','16206','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','16204','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','14343','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','13926','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','13467','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','13446','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','13444','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','12811','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','12808','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','12803','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','11291','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','11178','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','11177','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','11176','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','11175','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','11145','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','11144','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','11139','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','11138','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','11137','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','11135','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','11134','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','11130','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','11128','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','11084','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','11083','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','11082','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','10998','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','10978','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','10940','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','10939','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','10938','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','9224','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','8925','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','8838','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','7971','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','7909','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','7392','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','7082','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','7081','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','7078','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','7076','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','7075','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','6371','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','6370','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','6339','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','6338','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','6218','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','6217','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','6048','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','5637','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','5500','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','4470','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','3819','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','3372','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','3371','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','3356','0','0','0');

INSERT INTO npc_vendor VALUES ('800012','2772','0','0','0');

/*BLACKSMITHING*/

INSERT INTO creature_template(entry, modelid1, name, subname, minlevel, maxlevel, faction_A, faction_H, npcflag, health_mod) VALUES ('800010', ' 24284', 'Blacksmithing', 'Vendor', '55', '55', '35', '35', '128', '1');

INSERT INTO npc_vendor VALUES ('800010','47556','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','45087','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','43102','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','41745','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','41355','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','41245','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','41163','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','37663','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','36925','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','36916','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','36913','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','35128','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','34664','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','34054','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','32428','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','30183','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','28484','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','28483','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','28441','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','28440','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','28438','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','28437','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','28435','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','28434','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','28432','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','28431','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','28429','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','28428','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','28426','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','28425','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','27503','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','25845','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','25844','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','25843','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','23793','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','23573','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','23564','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','23563','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','23449','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','23447','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','23446','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','22831','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','22824','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','22450','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','22449','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','22445','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','22203','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','22202','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','21877','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','19774','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','19726','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','16206','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','15417','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','13510','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','12811','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','12809','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','12808','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','12803','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','12799','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','12662','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','12365','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','12364','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','11144','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','11128','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','9060','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','7971','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','7912','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','7909','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','7081','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','7078','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','7076','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','7075','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','7071','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','6338','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','5966','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','5637','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','5635','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','5500','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','5498','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','4255','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','3864','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','3859','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','3824','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','3478','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','3470','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','3466','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','3391','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','2880','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','2841','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','2838','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','2836','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','2835','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','2605','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','2459','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','1705','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','1210','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','1206','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','818','0','0','0');

INSERT INTO npc_vendor VALUES ('800010','774','0','0','0');

EDIT: jsou na patch 3.3.2

Edited March 10, 2010 by Kropotkin

jakub129 · March 9, 2010

hle a na jakej sou patch ty tvoje

Sign In

Announcements

Pravidlo pro postování v TTT

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

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

Používání spoilerů

[3.2.2a]vendoři----->profese

Recommended Posts

jakub129 0

Share this post

Link to post

Share on other sites

Wladass 1216

Share this post

Link to post

Share on other sites

STONERSVK 899

Share this post

Link to post

Share on other sites

jakub129 0

Share this post

Link to post

Share on other sites

Wladass 1216

Share this post

Link to post

Share on other sites

Cäsh 193

Share this post

Link to post

Share on other sites

Wladass 1216

Share this post

Link to post

Share on other sites

ZechY 253

Share this post

Link to post

Share on other sites

Wladass 1216

Share this post

Link to post

Share on other sites

Cäsh 193

Share this post

Link to post

Share on other sites

Wladass 1216

Share this post

Link to post

Share on other sites

Wladass 1216

Share this post

Link to post

Share on other sites

jakub129 0

Share this post

Link to post

Share on other sites

Wladass 1216

Share this post

Link to post

Share on other sites

jakub129 0

Share this post

Link to post

Share on other sites

Wladass 1216

Share this post

Link to post

Share on other sites

Kropotkin 1

Share this post

Link to post

Share on other sites

jakub129 0

Share this post

Link to post

Share on other sites