massacre at light's point

Can ya’ll make the change for this in the repo? I did a full re-install of trinity and noticed that when you do this quest you turn into a horse.

I made the necessary changes to put it back to a cart, but can this be something that ya’ll add permanently?

Easy to fix: just set the modelid1 to 25703 and the rest to “0”, problem fixed ^^ (that was the fix I applied to my DB).

Thanks

–Thirand

Ya’ll didn’t make a good post!

Try again /emoticons/default_tongue.png

ok… understand.

Thanks for the clarification.

I post my problem here.

In the old (deleted) forum, or in tracker, there was a fix for a developer (don’t remember who right now) who added waypoints to the gryphon option in the cannon.

He “fixed” waypoints indeed, but there is something broken (heavily broken).

When you use that option, that gryphon comes, but it does NOT take you, it takes the cannon instead!!!

If that developer reads this, please, take a look at your fix, since the cannon seems not to respawn, and can be dangerous, because you can leave ships without cannons, and thus, render this quest unfinishable.

Hi /emoticons/default_smile.png Sorry I can’t, i lost the fix after the website crashed (didnt store it on my hard drive). Probably needs to be rewritten if you cant post the sai+waypoints here?

Since that fix was included in UP36, I deleted my local copy /emoticons/default_sad.png

@kaelima: I think I found it!

Fortunatelly you didn’t delete old googlecode repository, and it seems to be there.

Is this snipe what you fixed?

-- Massacre At Light's Point SET @N_Gryphon := 28864; -- Update creature template for gryphon UPDATE `creature_template` SET `InhabitType`=5,`spell1`=0,`speed_run`=1.289683,`flags_extra`=`flags_extra`|2,`AIName`='SmartAI' WHERE `entry`=@N_Gryphon; UPDATE `creature_template` SET `speed_run`=2.571429,`speed_walk`=2.4 WHERE `entry`=29488; -- Move aura from creature_addon to template_addon DELETE FROM `creature_addon` WHERE `guid` IN (128581,128582,128738); DELETE FROM `creature_template_addon` WHERE `entry` IN (25462,28765); INSERT INTO `creature_template_addon` (`entry`,`bytes2`,`auras`) VALUES (25462,1, '53274 0'), (28765,1, '53274 0'); -- Some creatures that should aggro UPDATE `creature_template` SET `flags_extra`=`flags_extra`|2 WHERE `entry` IN (25462,28605,28607,28606); -- Wrong movement UPDATE `creature` SET `spawndist`=0,`MovementType`=0 WHERE `id` IN (28627,28643,29239); -- Enter smartscript for Scarlet Gryphon DELETE FROM `smart_scripts` WHERE `entryorguid`=@N_Gryphon AND `source_type`=0; INSERT INTO `smart_scripts`(`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES (@N_Gryphon,0,1,0,25,0,100,0,0,0,0,0,11,43775,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Cast flight spell on spawn'), (@N_Gryphon,0,2,0,25,0,100,0,0,0,0,0,53,1,@N_Gryphon,0,0,0,0,1,0,0,0,0,0,0,0, 'Start waypath on spawn'), (@N_Gryphon,0,3,0,40,0,100,0,6,@N_Gryphon,0,0,28,46598,0,0,0,0,0,23,0,0,0,0,0,0,0, 'Remove Ride Vehicle aura on owner'), (@N_Gryphon,0,4,0,40,0,100,0,6,@N_Gryphon,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Despawn on waypoint 7'); -- Waypoints DELETE FROM `waypoints` WHERE `entry`=@N_Gryphon; INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES (@N_Gryphon,1,2191.454,-6131.876,48.42883, ''), (@N_Gryphon,2,2220.663,-6030.991,70.01215, ''), (@N_Gryphon,3,2281.503,-5955.75,131.79, ''), (@N_Gryphon,4,2306.983,-5872.798,177.6512, ''), (@N_Gryphon,5,2347.977,-5736.882,167.929, ''), (@N_Gryphon,6,2360.925,-5710.754,155.4011, 'Despawn');[/sql]

Oh yes, lol! Didn’t think it made it to an UP. Thank you /emoticons/default_smile.png

Script WAS working when i tested it myself, however we’ve seen some vehicles changes now that can have fucked it up, npc_spellclick_spell seems to be wrong, so try this:

DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=28864;
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
(28864,46598,0,0,0,1,0,0,0);  -- Scourge Gryphon
[/SQL]

Oh! Thanks for your rapid response!

I’ll test a bit later when I arrive home (I triggered my own security and banned my friend’s home ip from ssh! ouch! LOL).

By the way, returning to first post argument, if that wdb field can not be changed, what could be the solution? SAI script to change modelid at runtime in order not to appear as a horse?

About the mine cart:

A hack gone wrong, always choosing the horse model /emoticons/default_tongue.png

diff --git a/src/server/scripts/EasternKingdoms/ScarletEnclave/chapter1.cpp b/src/server/scripts/EasternKingdoms/ScarletEnclave/chapter1.cpp
index e263d8f..add8ae1 100644
--- a/src/server/scripts/EasternKingdoms/ScarletEnclave/chapter1.cpp
+++ b/src/server/scripts/EasternKingdoms/ScarletEnclave/chapter1.cpp
@@ -887,7 +887,7 @@ public:
         npc_scarlet_miner_cartAI(Creature *c) : PassiveAI(c), minerGUID(0)
         {
             me->SetFlag(UNIT_FIELD_FLAGS, UNIT_FLAG_OOC_NOT_ATTACKABLE);
-            me->SetDisplayId(me->GetCreatureInfo()->Modelid2); // Modelid1 is a horse.
+            me->SetDisplayId(me->GetCreatureInfo()->Modelid1); // Modelid2 is a horse.
         }

         uint64 minerGUID;

[/CODE]

Can you commit to test?

Anyway, I commited changed locally to test it.

I’ll be back at reporting while I create a new DK from beginning and retest all, but one thing is sure. Yesterday I created one, and couldn’t complete the last quest /emoticons/default_sad.png

I reported it, can you take a look, since this issue seems a regression, because it was working in the past: http://www.trinitycore.org/t/trinitycore/ticket/889

TESTED:

All OK

Edit Reason: Too late testing has some diasvantages. All was OK, and I said other thing /emoticons/default_smile.png

I made a post about a compilation of ScarletEnclave problems: Scarlet Enclave Problem Compilation in order not to have this post overpopulated

I think this thread can be closed to favor the other one containing global problems of Scarlet Enclave.

Just a quick question here, but do these little fixes like this get incorporated into the pulls from github, or does everybody have to go through here looking for them and fixing it themselves? The only reason I’m asking is, I’m having this problem now, and the last post concerning this issue on here is dated 07 March 2011.