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`
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');
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`
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');