[QUEST]Cold Hearted

-- PARTIAL fix for the quest http://www.wowhead.com/quest=12856 "Cold Hearted" 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`,`user_type`) VALUES (29708,55028,12856,1,12856,1,0,0,0); -- Summon Freed Proto Drake. UPDATE `creature_template` SET `spell1` = '55046' WHERE `entry`=29709; -- Spells Free Proto Drake UPDATE `creature_template` SET `VehicleId`= '0' WHERE `entry` =29708; -- Clear vehicleid from Captive Proto Drakes, the real mount is Free Proto Drake UPDATE `creature_template` SET `unit_flags` = '256' WHERE `entry`=29639; -- Set unitflags to Brunnhildar Prisoner, so the frost giants can't kill them while frozen [/sql]

Whit this fix the drake is working and has got the right spell. spell seems working and the script wich controls he quest works. it can now be completed

Only one problem: the drake can’t fly (wrong VehicleId?). ive tried to use VehicleId = 156 (like the DK frostbrood) without results.

The quest now works, is only needed something to make the drake fly…

[CODE]-- Template updates for creature 29708 (Captive Proto-Drake)
UPDATE creature_template SET speed_run=1.4285714285714,vehicleid=198 WHERE entry=29708; – Captive Proto-Drake
– Model data 26739 (creature 29708 (Captive Proto-Drake))
UPDATE creature_model_info SET bounding_radius=0.39,combat_reach=6.5,gender=0 WHERE modelid=26739;
– Captive Proto-Drake – Addon data for creature 29708 (Captive Proto-Drake)
DELETE FROM creature_template_addon WHERE entry=29708;
INSERT INTO creature_template_addon (entry,mount,bytes1,bytes2,emote,auras) VALUES
(29708,0,50331648,1,0, NULL); – Captive Proto-Drake

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,user_type) VALUES
(29708,55028,12856,1,12856,1,0,0,0); – Summon Freed Proto Drake.[/sql]

[sql]-- Template updates for creature 29709 (Freed Proto-Drake)
UPDATE creature_template SET spell1=55046,faction_A=35,faction_H=35,unit_flags=unit_flags|8,speed_run=4.2857142857143,vehicleid=194 WHERE entry=29709; – Freed Proto-Drake
– Model data 26710 (creature 29709 (Freed Proto-Drake))
UPDATE creature_model_info SET bounding_radius=0.3,combat_reach=5,gender=0 WHERE modelid=26710; – Freed Proto-Drake
– Addon data for creature 29709 (Freed Proto-Drake)
DELETE FROM creature_template_addon WHERE entry=29709;
INSERT INTO creature_template_addon (entry,mount,bytes1,bytes2,emote,auras) VALUES
(29709,0,50331648,1,0, NULL); – Freed Proto-Drake
[/CODE]

Seems ok, i’ll try your code

and just one more query…

UPDATE `creature_template` SET `unit_flags` = '256' WHERE `entry`=29639; -- Set unitflags to Brunnhildar Prisoner, so the frost giants can't kill them while frozen

EDIT: Sorry, but this query is wrong

UPDATE `creature_template` SET `speed_run`=1.4285714285714,`vehicleid`=198 WHERE `entry`=29708; -- Captive Proto-Drake -- Model data 26739 (creature 29708 (Captive Proto-Drake))[/sql]
This drake is NOT the vehicle, and should have VehicleID=0.

The other code probably is ok, but pointless and unuseful, since these values are alredy on default in the database. and also using your code, the drake is still not flying.

The right, working and useful SQL so is:

[sql]-- PARTIAL fix for the quest http://www.wowhead.com/quest=12856 “Cold Hearted”
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,user_type) VALUES
(29708,55028,12856,1,12856,1,0,0,0); – Summon Freed Proto Drake.
UPDATE creature_template SET spell1 = ‘55046’ WHERE entry=29709; – Spells Free Proto Drake
UPDATE creature_template SET VehicleId= ‘0’ WHERE entry =29708; – Clear vehicleid from Captive Proto Drakes, the real mount is Free Proto Drake
UPDATE creature_template SET unit_flags = ‘256’ WHERE entry=29639; – Set unitflags to Brunnhildar Prisoner, so the frost giants can’t kill them while frozen
I’ve also updated the first post

Please, do not tell me if it’s right or wrong. What I posted is what retail sends to the client. Do not hack it.

That’s not hacking. the creature wich must be used as vehicle is “Free Proto Drake”, while “Captive Proto Drake” is a normal npc, and should use a spell to summon the right drake (vehicle).

This is written on wowhead, you can also see it on youtube… the real vehicle is “Free Proto Drake”.

So… the other drake can’t have a vheicleid, or the player will mount it instead of activating the spell setted on “npc_spellclick_spells”

So why you say that i hacked the code?

Ok, right, i simply used wowhead and a bit of logic while you have taken it from retrail (doesn’t matter how you have done this), but at least my code is working!

So, if you have some modification to make my query more blizzlike it’s ok, but it should at least offer a way to solve the problem… not simply post some code and saying “that’s an hack”. this forum is made to help each other to develop, isn’t it?

I don’t think the “Developers” word under your nickname means that only you are allowed to help, or i’m wrong?

And now we just need a way to make the drke fly.

This topic isn’t closed. Anyone is free to post. So far only me wanted to try to help.

Because it is working does not mean that it is working right.

And sorry, we are not the kind of community (core & db) that will accept anything.

Because it is working today, doesn’t mean that it will work tomorrow. If it would be a proper fix, more chances that tomorrow will still be working.

“UPDATE creature_template SET VehicleId= ‘0’” and “UPDATE creature_template SET unit_flags = ‘256’”

is a hack because that is not what happens on retail.

Yes, it’s a bit weird that both have vehicleids. There is a logical reason, I’m sure. I would have to research a bit more.

Relax man /emoticons/default_tongue.png I found 29805 mounted upon 29708, probably for some visual stuff. Fix below

DELETE FROM `vehicle_accessory` WHERE `entry`=29708;
INSERT INTO `vehicle_accessory` (`entry`,`accessory_entry`,`seat_id`,`minion`,`description`) VALUES
(29708,29805,0,1, 'Captive Proto Drake and Beam Bunny');
[/SQL]

npc 29805 is casting spell 55244 on npc 30442

When 55046 is casted, npc 29639 will cast 55048 on self, then 55074 on npc 29709. After that 55047 is casted by npc 29639 on self.

[code]
Target Flags: DestinationLocation
Target GUID: Full: 0x00000000 Flags: None Type: NoEntry1 Entry: 0 Low: 0
Position: X: 7235.977 Y: -2779.61 Z: 776.5421 (same as the proto drake probably)
[/code]
Also:

[SQL]
UPDATE `creature_template` SET `unit_flags` = '256' WHERE `entry`=29639; -- Set unitflags to Brunnhildar Prisoner, so the frost giants can't kill them while frozen
[/SQL]
Is a hack awell, i suggest doing this instead:

[SQL]
UPDATE `creature_template` SET `flags_extra`=`flags_extra`|2 WHERE `entry`=29639;
[/SQL]

i confirm the quest as having the same problem mention here. Am with iperdido on the logic of the quest. The npc_click events have change today i think so maybe this can influence in this quest also and the one call going bearback.

My nickname is “iperpido”, but nevermind…

for the quest “Going Bearback” i’ve already made a working and not-hacky fix, which is only waiting approval → http://www.trinitycore.org/f/index.php?/topic/1374-questgoing-bearback/

works !

Now we only need a way to make the drake fly…

Yes, inperpido script is working up to the drake trying to fly.

Check inhabittype

Adding inhabittype fixed the drake’s flying, once you gather the brunhildars and leave dun niffelem the drake will automatically start his pathing back to the village. now the only problem is fix the credit for rescuing the brunhildars, the quest asks for NPC 29734 wich sounds like a dummy npc for quest credit.

Edit: i’m blind, its giving the credits…

So is it working correctly all the way or something missing?

Hi! Thanks for your help, with your fix and the fix : http://pastebin.com/tnuXY2Hm by niyo…I finally repair the quest! This is the final sql:

Db rev: TDB_full_335.11.46_2012_02_13 with some updates.

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,user_type) VALUES (29708,55028,12856,1,12856,1,0,0,0); – Para que al “subirse al captured proto-drake, se transforme en el montable Free proto-drake

UPDATE creature_template SET spell1 = ‘55046’ WHERE entry=29709; – Spells Free Proto Drake

UPDATE creature_template SET InhabitType = ‘4’ WHERE creature_template.entry =29709;

DELETE FROM creature_template_addon WHERE entry=29709;

INSERT INTO creature_template_addon (entry, path_id, mount, bytes1, bytes2, emote, auras) VALUES (‘29709’, ‘0’, ‘0’, ’ 50331648’, ‘1’, ‘0’, ‘61307’);

UPDATE creature_template SET speed_walk = ‘1’,speed_run = ‘1’ WHERE creature_template.entry =29709;

UPDATE creature_template SET flags_extra=flags_extra|2 WHERE entry=29639;

I hope help you =)

ps: Sorry, I don’t write english very well '^^

This works for me (with newest Core+DB):

SET @MOUNT := 29709; -- Freed Proto-Drake SET @SPELL := 55028; SET @SPELL2 := 55046; SET @AURA := 61307; SET @ENTRY := 29639; -- Captive Brunhildar DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=@MOUNT; INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`cast_flags`,`user_type`) VALUES (@MOUNT,@SPELL,1,0); -- Mounts Player to new-summond Drake UPDATE `creature_template` SET `spell1`=@SPELL2 WHERE `entry`=@MOUNT; -- Spells Free Proto Drake UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=@MOUNT; DELETE FROM `creature_template_addon` WHERE `entry`=@MOUNT; INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES (@MOUNT, 0, 0, 50331648, 1, 0, @AURA); UPDATE `creature_template` SET `speed_walk`=1,`speed_run`=1 WHERE `entry`=@MOUNT; UPDATE `creature_template` SET `flags_extra`=`flags_extra`|2 WHERE `entry`=@ENTRY; [/SQL]

Just updated your statement so it fits in the new table-sctructure /emoticons/default_wink.png