Garde Anti-JcJ

Voila mon premier Garde Anti-PVP merci de me faire part de vos problème :

[code=sql]DELETE FROM `creature_template` WHERE (`entry`=20485);
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 (20485, 0, 0, 0, 0, 0, 11375, 11377, 11376, 0, 'Garde Anti-PVP', '', '', 0, 70, 70, 16960, 16960, 0, 0, 6740, 1806, 1806, 0, 1, 1.14286, 1, 1, 390, 585, 0, 146, 2, 3000, 3000, 1, 32768, 0, 0, 0, 0, 0, 0, 312, 468, 117, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12024, 0, 0, 0, 0, 0, 0, '', 0, 3, 2, 1, 0, 0, 0, 0, 0, 0, 0, 144, 1, 3003, 1, 0, '');[/code]

avant d'implanter le patch n'oublier surtout pas de supprimer le PNj ayant l'id 20484 dans votre DB ...

ID : 20484

Petite erreur c'est pas 20484 mais 20485 et il est pas nécessaire de le supprimer puisque on a un DELETE FROM au départ

Je trouve un peu 'idiot' de supprimer le garde de la zone 52 non ? Pourquoi ne pas tout simplement créer un nouveau pnj avec une ID de 1 000 000 par exemple ?

Ou sinon tu commences par REPLACE sa donne donc

Code :

REPLACE 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 (20485, 0, 0, 0, 0, 0, 11375, 11377, 11376, 0, 'Garde Anti-PVP', '', '', 0, 70, 70, 16960, 16960, 0, 0, 6740, 1806, 1806, 0, 1, 1.14286, 1, 1, 390, 585, 0, 146, 2, 3000, 3000, 1, 32768, 0, 0, 0, 0, 0, 0, 312, 468, 117, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12024, 0, 0, 0, 0, 0, 0, '', 0, 3, 2, 1, 0, 0, 0, 0, 0, 0, 0, 144, 1, 3003, 1, 0, '');

Ce qui te permet de ne pas avoir

Code :

DELETE INTO

Ensuite sa serait mieux de mettre les screens du garde anti-PvP
Voilà
Merci mais je prend pas j'en ai déjà assez

Si erreur de modelid ( UDB ) :

Code :

DELETE FROM `creature_template` WHERE (`entry`=20485);
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `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 (20485, 0, 0, 0, 0, 0, 11375, 11377, 11376, 0, 'Garde Anti-PVP', '', '', 0, 70, 70, 16960, 16960, 0, 0, 6740, 1806, 1806, 0, 1, 1.14286, 1, 1, 390, 585, 0, 146, 2, 3000, 3000, 1, 32768, 0, 0, 0, 0, 0, 0, 312, 468, 117, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12024, 0, 0, 0, 0, 0, 0, '', 0, 3, 2, 1, 0, 0, 0, 0, 0, 0, 0, 144, 1, 3003, 1, 0, '');