Patchs utiles pour les serveurs JcJ

(29-06-2010 15:03) Mamba [0]

Bonjour à tous et à toutes !

Vous trouverez sur mon sujet des différents vendeurs qui vous seront utiles lors de vos projets du genre serveur pvp ou encore fun.

Pour le moment il n'y a pas encore de script, je vous les fournirais un peu plus tard dans la journée, en effet ce sont des anciens patch que je viens de retrouver lors de mon aventure en tant que Développeur sur plusieurs serveurs wow.

Libre à vous de les modifier par la suite.

Il n'y aura que des patch en SQL !

Infos supplémentaire : Tout mes patchs ne fonctionnerons peut-être pas avec votre DB à cause du Speed : Ma DB n'acceptai pas le champs "Speed", je l'ai donc remplacé par 2 autres champs : `speed_walk`, `speed_run` Clin

!

Patchs :

Patch PNJ Vendeur : Brassard, ceinture et botte (T7)
Patch PNJ Vendeur : Gemmes
Patch PNJ Vendeur : Glyphes

(30-06-2010 18:36) Raxoras [1]

En attente Hihi

(30-06-2010 21:34) Mamba [0]

Premier Patch SQL :

Patch PNJ Vendeur : Brassard, ceinture et botte (T7)

Code :

INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES(800001, 0, 0, 0, 0, 0, 28213, 0, 28213, 0, 'Autre', 'Ceintures . brassards . bottes', '', 0, 80, 80, 10000, 10000, 10000, 10000, 0, 35, 35, 130, 1, 1, 1, 0, 0, 0, 0, 0, 1, 2000, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, '', 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '');

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39278, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40738, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 43584, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40742, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39196, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40750, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40269, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40270, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40246, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39273, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39236, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39189, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40748, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40409, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40367, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39215, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39234, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40749, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40237, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 43592, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40243, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 41391, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40747, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 41392, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 43588, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39307, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39235, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37696, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40332, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37240, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40330, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40274, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37788, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39467, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39195, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40734, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40306, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37620, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39729, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37170, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39701, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37194, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39735, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40695, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40200, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39279, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37407, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40205, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40693, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40260, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40692, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40694, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 43594, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39251, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40275, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39759, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37241, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37171, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40278, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39308, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37855, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40241, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40317, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40327, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37670, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40263, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40697, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37408, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39379, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39345, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40272, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 43587, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39254, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40688, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 43591, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40301, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40691, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40341, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37361, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40741, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39247, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40743, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40746, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39190, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39216, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39216, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37643, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40271, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39721, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37242, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39734, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39762, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40737, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39764, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40325, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39722, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39252, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40209, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40338, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39390, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39765, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37884, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40323, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39731, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40751, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 43585, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40519, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40186, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37668, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40324, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40198, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39702, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40739, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40282, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 37853, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39283, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40735, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40733, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40259, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40689, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39298, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39706, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40745, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39369, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40297, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 43996, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40187, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 43996, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40187, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40320, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39717, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 39139, 0, 0, 0);

INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES (800001, 40206, 0, 0, 0);

(01-07-2010 12:25)

Gafda [0]

Merci !

(01-07-2010 13:36) Mamba [0]

Petits problèmes pour le moment, j'ajouterais les autres sois ce soir ou demain Clin

Édition :
Deuxième Patch SQL :

Patch PNJ Vendeur : Gemmes

Code :

DELETE FROM creature_template WHERE entry BETWEEN '200010' AND '200016';

DELETE FROM npc_vendor WHERE entry BETWEEN '200010' AND '200016';

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200010, 0, 0, 0, 29118, 0, 29118, 0, 'Vendeur de gemmes rouge', '', '', 80, 80, 20000, 20000, 0, 0, 50000, 35, 35, 128, 1, 1.7, 3, 3500, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `npc_vendor` VALUES ('200010', '40118', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200010', '40112', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200010', '40117', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200010', '40116', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200010', '40113', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200010', '40111', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200010', '40115', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200010', '40114', '0', '0', '0');

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200011, 0, 0, 0, 29118, 0, 29118, 0, 'Vendeur de gemmes bleu', '', '', 80, 80, 20000, 20000, 0, 0, 50000, 35, 35, 128, 1, 1.7, 3, 3500, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `npc_vendor` VALUES ('200011', '40120', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200011', '40122', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200011', '40121', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200011', '40119', '0', '0', '0');

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200012, 0, 0, 0, 29118, 0, 29118, 0, 'Vendeur de gemmes jaune', '', '', 80, 80, 20000, 20000, 0, 0, 50000, 35, 35, 128, 1, 1.7, 3, 3500, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `npc_vendor` VALUES ('200012', '40126', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200012', '40123', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200012', '40124', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200012', '40127', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200012', '40128', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200012', '40125', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200012', '44066', '0', '0', '0');

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200013, 0, 0, 0, 29118, 0, 29118, 0, 'Vendeur de gemmes verte', '', '', 80, 80, 20000, 20000, 0, 0, 50000, 35, 35, 128, 1, 1.7, 3, 3500, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `npc_vendor` VALUES ('200013', '40175', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40169', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40179', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40182', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40171', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40174', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40181', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40170', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40165', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40177', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40167', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40164', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40178', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40180', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40172', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40176', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40168', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40173', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200013', '40166', '0', '0', '0');

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200014, 0, 0, 0, 29118, 0, 29118, 0, 'Vendeur de gemmes Orange', '', '', 80, 80, 20000, 20000, 0, 0, 50000, 35, 35, 128, 1, 1.7, 3, 3500, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `npc_vendor` VALUES ('200014', '40150', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40162', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40157', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40146', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40143', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40160', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40142', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40148', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40151', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40147', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40156', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40163', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40145', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40161', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40159', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40154', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40158', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40152', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40149', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40153', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40155', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200014', '40144', '0', '0', '0');

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200015, 0, 0, 0, 29118, 0, 29118, 0, 'Vendeur De Gemmes Violette', '', '', 80, 80, 20000, 20000, 0, 0, 50000, 35, 35, 128, 1, 1.7, 3, 3500, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `npc_vendor` VALUES ('200015', '40136', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200015', '40130', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200015', '40139', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200015', '40141', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200015', '40137', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200015', '40132', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200015', '40135', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200015', '40133', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200015', '40138', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200015', '40134', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200015', '40129', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200015', '40140', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200015', '40131', '0', '0', '0');

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200016, 0, 0, 0, 29118, 0, 29118, 0, 'Vendeur de meta-gemmes', '', '', 80, 80, 20000, 20000, 0, 0, 50000, 35, 35, 128, 1, 1.7, 3, 3500, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `npc_vendor` VALUES ('200016', '44088', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '44089', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '44087', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '44081', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '44076', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '44078', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '44084', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41266', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41335', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41333', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41285', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41307', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41339', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41400', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41379', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '44082', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41375', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41378', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41377', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41376', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41380', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41396', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41401', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41397', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41389', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41398', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41382', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41381', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41395', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200016', '41385', '0', '0', '0');

Édition :
Troisième Patch SQL :

Patch PNJ Vendeur : Glyphes

Code :

DELETE FROM creature_template WHERE entry BETWEEN '200017' AND '200026';

DELETE FROM npc_vendor WHERE entry BETWEEN '200017' AND '200026';

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200017, 0, 0, 0, 27153, 0, 27153, 0, 'vendeur de Glyphes', 'Chaman', '', 80, 80, 20000, 20000, 0, 0, 50000, 35, 25, 128, 1, 1, 3, 3500, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `npc_vendor` VALUES ('200017', '41542', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41532', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41527', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41536', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41531', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41547', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41526', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '43386', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41537', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41518', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41540', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41539', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41524', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '43725', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41552', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41541', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '43388', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '43381', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '43344', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41517', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41529', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41538', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41533', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41530', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41534', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '41535', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '43385', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200017', '44923', '0', '0', '0');

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200018, 0, 0, 0, 27153, 0, 27153, 0, 'vendeur de Glyphes', 'Chasseur', '', 80, 80, 20000, 20000, 0, 0, 50000, 35, 25, 128, 1, 1, 3, 3500, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `npc_vendor` VALUES ('200018', '42899', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42901', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42909', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42900', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42915', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '43356', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42902', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42904', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42903', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '43351', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42910', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '43350', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '43354', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '43355', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42907', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42912', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42913', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42908', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42906', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42905', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42917', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '43338', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42916', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42914', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42898', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42911', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200018', '42897', '0', '0', '0');

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200019, 0, 0, 0, 27153, 0, 27153, 0, 'vendeur de Glyphes', 'Chevalier de la Mort', '', 80, 80, 20000, 20000, 0, 0, 50000, 35, 25, 128, 1, 1, 3, 3500, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `npc_vendor` VALUES ('200019', '43547', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43553', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43671', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43536', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43533', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43539', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43537', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43825', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43544', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43535', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43543', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43827', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43548', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43826', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43551', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43550', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43534', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43549', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43542', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43672', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43541', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43673', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43545', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43554', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43538', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43552', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '43546', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200019', '44432', '0', '0', '0');

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200020, 0, 0, 0, 27153, 0, 27153, 0, 'vendeur de Glyphes', 'Druide', '', 80, 80, 20000, 20000, 0, 0, 50000, 35, 25, 128, 1, 1, 3, 3500, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `npc_vendor` VALUES ('200020', '40923', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40919', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40908', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40920', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '43674', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40922', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40902', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40916', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40915', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '43316', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40903', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40899', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40901', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40921', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40900', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40897', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40906', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40913', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40896', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40912', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40909', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '43331', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '43334', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40924', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '40914', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '43332', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '43335', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '44928', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200020', '44922', '0', '0', '0');

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200021, 0, 0, 0, 27153, 0, 27153, 0, 'vendeur de Glyphes', 'Demoniste', '', 80, 80, 20000, 20000, 0, 0, 50000, 35, 25, 128, 1, 1, 3, 3500, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `npc_vendor` VALUES ('20002', '42472', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '43393', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42464', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42453', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42468', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42461', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42460', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42454', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42455', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42466', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '43390', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42459', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42463', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '43391', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42456', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '43392', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42473', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42458', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42470', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42462', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '43389', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42469', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42471', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42467', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42457', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '43394', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200021', '42465', '0', '0', '0');

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200022, 0, 0, 0, 27153, 0, 27153, 0, 'vendeur de Glyphes', 'Guerrier', '', 80, 80, 20000, 20000, 0, 0, 50000, 35, 25, 128, 1, 1, 3, 3500, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `npc_vendor` VALUES ('200022', '43428', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43414', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43416', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43419', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43431', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43395', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43425', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43417', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43397', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43413', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43399', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43398', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43415', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43426', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43427', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43418', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43421', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43422', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43430', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43423', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43429', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43396', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43412', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43432', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43424', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43400', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200022', '43420', '0', '0', '0');

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200023, 0, 0, 0, 27153, 0, 27153, 0, 'vendeur de Glyphes', 'Mage', '', 80, 80, 20000, 20000, 0, 0, 50000, 35, 25, 128, 1, 1, 3, 3500, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `npc_vendor` VALUES ('200023', '43359', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42743', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42751', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42749', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42742', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42754', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42738', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42734', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '43339', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42748', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42744', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42739', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42747', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '43364', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42753', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '43357', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '43360', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42750', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '44684', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42745', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42752', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42741', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42736', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42735', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42740', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42737', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '42746', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '43361', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '44920', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200023', '43362', '0', '0', '0');

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200024, 0, 0, 0, 27153, 0, 27153, 0, 'vendeur de Glyphes', 'paladin', '', 80, 80, 20000, 20000, 0, 0, 50000, 35, 25, 128, 1, 1, 3, 3500, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `npc_vendor` VALUES ('200024', '41105', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '41103', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '41096', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '43367', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '41098', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '43340', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '43366', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '43365', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '41099', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '41107', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '41100', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '43368', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '41108', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '41092', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '41106', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '41097', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '41095', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '41104', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '41102', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '41094', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '41110', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '43868', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '41109', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '43867', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '43869', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '43369', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200024', '41101', '0', '0', '0');

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200025, 0, 0, 0, 27153, 0, 27153, 0, 'vendeur de Glyphes', 'Pretre', '', 80, 80, 20000, 20000, 0, 0, 50000, 35, 25, 128, 1, 1, 3, 3500, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `npc_vendor` VALUES ('200025', '42412', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '43373', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42417', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42407', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '43374', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42398', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42396', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42416', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42405', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42410', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42397', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42404', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42402', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42406', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42399', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '43342', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '43370', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42415', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42414', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42408', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42401', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42409', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '43372', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42403', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42411', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '43371', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200025', '42400', '0', '0', '0');

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200026, 0, 0, 0, 27153, 0, 27153, 0, 'vendeur de Glyphes', 'Voleur', '', 80, 80, 20000, 20000, 0, 0, 50000, 35, 25, 128, 1, 1, 3, 3500, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

REPLACE INTO `npc_vendor` VALUES ('200026', '42970', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42972', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42956', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42960', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42961', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42955', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42962', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42967', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '43378', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '43377', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42973', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42957', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '43380', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '43376', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42963', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '43379', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42965', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42964', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42959', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42958', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42954', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42968', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42969', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42974', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42966', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '42971', '0', '0', '0');

REPLACE INTO `npc_vendor` VALUES ('200026', '43343', '0', '0', '0');

(02-07-2010 00:09) Raxoras [1]

Petite erreur dans ton sql

Code :

REPLACE INTO `npc_vendor` VALUES ('20002', '42472', '0', '0', '0');

c'est :

Code :

REPLACE INTO `npc_vendor` VALUES ('200021', '42472', '0', '0', '0');

(02-07-2010 11:49) Mamba [0]

Ah oui un petit oublie, merci de l'avoir précisé pour les autres Clin