[Quête] Brisons la glace

http://fr.wowhead.com/quest=12856

[code=sql]UPDATE `creature_template` SET `unit_flags` = '256' WHERE `entry`=29639;
UPDATE `creature_template` SET `speed_run`=1.4285714285714,`vehicleid`=198 WHERE `entry`=29708;
DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=29708;
INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`quest_start`,`quest_start_active`,`​quest_end`,`cast_flags`,`aura_required`,`aura_forbidden`,`us​er_type`) VALUES
(29708,55028,12856,1,12856,1,0,0,0);
UPDATE `creature_template` SET `spell1` = '55046' WHERE `entry`=29709;
UPDATE `creature_template` SET `VehicleId`= '0' WHERE `entry` =29708;
UPDATE `creature_template` SET `unit_flags` = '256' WHERE `entry`=29639;

DELETE FROM `vehicle_template_accessory` WHERE `entry`=29708;
INSERT INTO `vehicle_template_accessory` (`entry`,`accessory_entry`,`seat_id`,`minion`,`description`)​ VALUES
(29708,29805,0,1, 'Captive Proto Drake and Beam Bunny');
UPDATE `creature_template` SET `flags_extra`=`flags_extra`|2 WHERE `entry`=29639;

UPDATE `creature_template` SET `spell2`='53112' WHERE (`entry`='29709')[/code]

Des fixes son de trinity
Le fixe spell 53112 est un Spell hack qui permet de faire voler la monture.

Erreur : Pas de table `vehicle_template_accessory`

mais : `vehicle_accessory`

Et quelques erreurs de syntaxe...

parce que ta db n'est pas à jour par rapport à trinity

maintenant c'est vehicle_template_accessory

car j'ai tester ma requête et j'ai eut aucun problème