Skip to content

Instantly share code, notes, and snippets.

@FALL1N1
FALL1N1 / gist:5687487
Created May 31, 2013 19:43
Premium Accounts
From e722a50c6de3c4bd3c0663630e56af18ad82eb70 Mon Sep 17 00:00:00 2001
From: Neket007 <neket007wow@gmail.com>
Date: Sun, 23 Sep 2012 21:59:49 +1000
Subject: [PATCH] =?UTF-8?q?=D0=94=D0=BE=D0=BF=D0=BE=D0=BB=D0=BD=D0=B8=D1=82=D0?=
=?UTF-8?q?=B5=D0=BB=D1=8C=D0=BD=D0=BE:=20=D0=98=D0=BC=D0=BF=D0=BB=D0=B5=D0=BC?=
=?UTF-8?q?=D0=B5=D0=BD=D1=82=D0=B0=D1=86=D0=B8=D1=8F=20=D1=81=D0=B8=D1=81=D1?=
=?UTF-8?q?=82=D0=B5=D0=BC=D1=8B=20Vip=20=D0=B0=D0=BA=D0=BA=D0=B0=D1=83=D0=BD?=
=?UTF-8?q?=D1=82=D0=BE=D0=B2?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
From: Updated by: Toba and Baeumchen (maddin)
Fixed Error by : SymbolixDEV!
Date: Mon, 29 Apr 2013 04:37:58 +0300
Gunship Battle
---
src/server/scripts/Northrend/CMakeLists.txt | 1 +
1 file changed, 1 insertion(+)
diff --git a/src/server/scripts/Northrend/CMakeLists.txt b/src/server/scripts/Northrend/CMakeLists.txt
@FALL1N1
FALL1N1 / gist:3953046
Created October 25, 2012 14:53
[SAI] The Lost Spirits
DELETE FROM creature_ai_scripts WHERE creature_id IN (25321,25322);
DELETE FROM creature_ai_texts WHERE entry IN (-899,-898,-900,-901);
SET @ENTRY:=25321;
UPDATE creature_template SET AIName= 'SmartAI' WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@ENTRY;
DELETE FROM smart_scripts WHERE source_type=9 AND entryorguid=@ENTRY*100;
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
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,22,1,0,0,0,0,0,0,0,0,0,0,0,0,0,'On spawn set phase 1'),
(@ENTRY,0,1,0,8,1,100,0,45504,0,0,0,80,@ENTRY*100,0,0,0,0,0,1,0,0,0,0,0,0,0, 'On spell hit run script'),
(@ENTRY*100,9,0,0,0,0,100,0,0,0,0,0,22,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 'set phase 0'),
@FALL1N1
FALL1N1 / gist:3952851
Created October 25, 2012 14:28
Missing Quartermaster @ The Argent Crusade
SET @GUID :=124442;
DELETE FROM `creature` WHERE `guid` = @GUID;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(@GUID, 30431, 571, 1, 1, 27020, 0, 6266.74, -44.569, 421.498, 3.83972, 300, 0, 0, 23310, 11982, 0, 0, 0, 0);
@FALL1N1
FALL1N1 / gist:3943417
Created October 24, 2012 02:49
The Battle for Valhalas Fix (Completed all quests)
SET @NPC_GEIRRVIF := 31135;
SET @QUEST_FALLENHEROES := 13214;
SET @NPC_ELDRETH_13214 := 31195;
SET @NPC_GENESS_13214 := 31193;
SET @NPC_JHADRAS_13214 := 31191;
SET @NPC_MASUD_13214 := 31192;
SET @NPC_RITH_13214 := 31196;
SET @NPC_TALLA_13214 := 31194;
SET @NPC_KILLTRIG_13214 := 820011;
SET @QUEST_KDARKMASTER := 13215;
@FALL1N1
FALL1N1 / gist:3943081
Created October 24, 2012 01:05
Transport System @ Gunship
diff --git a/src/server/game/Entities/Transport/Transport.cpp b/src/server/game/Entities/Transport/Transport.cpp
index f3b2d51..142f81b 100644
--- a/src/server/game/Entities/Transport/Transport.cpp
+++ b/src/server/game/Entities/Transport/Transport.cpp
@@ -25,6 +25,7 @@
#include "WorldPacket.h"
#include "DBCStores.h"
#include "World.h"
+#include "Vehicle.h"
#include "GameObjectAI.h"
@FALL1N1
FALL1N1 / gist:3943067
Created October 24, 2012 00:59
some random quest fixes
-- Fix quest "Ride to Taunka'le Village" [QUEST]
UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `Id`=11888;
-- Fix quest "Tails Up"
SET @ENTRY := 29327;
SET @QUEST := 13549;
SET @GOSSIP := 54000;
SET @SPELL_RAKE := 54668;
SET @SPELL_BLOWGUN := 62105;
SET @SPELL_SLEEP := 42386;
@FALL1N1
FALL1N1 / gist:3942964
Created October 24, 2012 00:26
Valduran the Stormborn (12984)
SET @VALDURAN := 29368;
# eventai
DELETE FROM `creature_ai_scripts` WHERE `creature_id` = @VALDURAN;
INSERT INTO `creature_ai_scripts` VALUES
(2936801, @VALDURAN, 1, 0, 100, 0, 0, 0, 0, 0, 21, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 0, 'Valduran the Stormborn - Prevent Combat Movement and Set Phase to 0 on Spawn'),
(2936802, @VALDURAN, 4, 0, 100, 0, 0, 0, 0, 0, 11, 56326, 1, 0, 23, 1, 0, 0, 0, 0, 0, 0, 'Valduran the Stormborn - Cast Lightning Bolt and Set Phase 1 on Aggro'),
(2936803, @VALDURAN, 9, 13, 100, 1, 0, 40, 3400, 4800, 11, 56326, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Valduran the Stormborn - Cast Lightning Bolt (Phase 1)'),
(2936804, @VALDURAN, 3, 13, 100, 0, 7, 0, 0, 0, 21, 1, 0, 0, 23, 1, 0, 0, 0, 0, 0, 0, 'Valduran the Stormborn - Start Combat Movement and Set Phase 2 when Mana is at 7% (Phase 1)'),
(2936805, @VALDURAN, 9, 13, 100, 0, 35, 80, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Valduran the Stormborn - Start Combat Movement at 35 Yards (Phase 1)'),
(2936806, @VALDURAN, 9, 13, 100, 0, 5, 15, 0, 0, 21, 0,
SET @NPC_SIGRID := 30086;
SET @MENUID_SIGRID := 9870;
SET @NPC_EFREM := 30081;
SET @MENUID_EFREM := 9869;
SET @NPC_ONUZUN := 30180;
SET @MENUID_ONUZUN := 9878;
SET @NPC_TINKY := 30162;
SET @MENUID_TINKY := 9875;
UPDATE `creature_template` SET `npcflag`=1,`unit_flags`=33024,`AIName`='SmartAI' WHERE `entry` IN (@NPC_SIGRID,@NPC_EFREM,@NPC_ONUZUN,@NPC_TINKY);
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` IN (@NPC_SIGRID,@NPC_EFREM,@NPC_ONUZUN,@NPC_TINKY);
SET @NPC := 23219;
DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@NPC;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@NPC;
DELETE FROM `smart_scripts` WHERE (`entryorguid`=@NPC 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
(@NPC,0,1,0,25,0,100,1,0,530,0,0,11,32942,2,0,0,0,0,1,0,0,0,0,0,0,0,'Blackwind Warp Chaser - Respawn - Cast Phasing Invisibility'),
(@NPC,0,2,0,4,0,100,0,0,0,0,0,28,32942,0,0,0,0,0,1,0,0,0,0,0,0,0,'Blackwind Warp Chaser - Aggro - Remove Phasing Invisibility'),
(@NPC,0,3,0,0,0,100,0,3000,6000,4000,7000,11,32739,0,0,0,0,0,5,0,0,0,0,0,0,0,'Blackwind Warp Chaser - Combat - Ca