Skip to content

Instantly share code, notes, and snippets.

View FALL1N1's full-sized avatar

FALL1N1

101 followers · 6 following
View GitHub Profile
@FALL1N1
FALL1N1 / gist:3800398
Created September 28, 2012 15:03
-- forgotten peasant sai
SET @PEASANT := 27226;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY_PEASANT AND `id` IN (0, 1); --incorrect id's
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@PEASANT;
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_PEASANT, 0, 0, 1, 62, 0, 100, 0, 9541, 0, 0, 0, 33, 27472, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, ''),
(@ENTRY_PEASANT, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, '');
-- forgotten rifleman sai
@FALL1N1
FALL1N1 / gist:3840848
Created October 5, 2012 16:30
SET @Frostweaver := 19579;
SET @Hatless := 19545;
SET @Credit := 19550;
SET @Event := 12610;
UPDATE `quest_template` SET `RequiredSpellCast1`=0 WHERE `Id`=10307;
DELETE FROM `event_scripts` WHERE `id`=@Event;
INSERT INTO `event_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`x`,`y`,`z`,`o`) VALUES
(@Event,0,10,@Frostweaver,25000,2203.629883,2413.392090,109.257515,3.961037);
UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`= @Hatless;
DELETE FROM `creature_ai_scripts` WHERE creature_id = @Hatless;
@FALL1N1
FALL1N1 / gist:3840635
Created October 5, 2012 15:49
UPDATE `creature_template` SET ainame='SmartAI' WHERE `entry`= 35116;
UPDATE `creature_template` SET ainame='SmartAI' WHERE `entry`= 35127;
DELETE FROM `creature_text` WHERE `entry`=35116;
INSERT INTO `creature_text` VALUES
(35116,0,0, 'What do you think you\'re doing? ',12,0,0,1,0,0, ''),
(35116,1,0, 'You\'re too late to stop our plan.',12,0,0,1,0,0, ''),
(35116,2,0, 'See to it that I\'m not followed.',12,0,0,1,0,0, '');
DELETE FROM `creature_text` WHERE `entry`=35127;
INSERT INTO `creature_text` VALUES
(35127,0,0, 'Gladly',12,0,1,0,0,0, '');
@FALL1N1
FALL1N1 / gist:3841165
Created October 5, 2012 17:27
music box, sylvana
SET @LAMENTER := 39048;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@LAMENTER;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@LAMENTER 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
(@LAMENTER, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 4, 15095, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '');
@FALL1N1
FALL1N1 / gist:3846482
Created October 6, 2012 23:21
UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `Id`=13110;
SET @ENTRY := 26048;
UPDATE `creature_template` SET `npcflag`=`npcflag`&~16777216,`AIName`= 'SmartAI',`ScriptName`='' WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,81,16777216,0,0,0,0,0,1,0,0,0,0,0,0,0,'Storm Totem - On spawn - set npcflag'),
(@ENTRY,0,1,2,72,0,100,0,1001,0,0,0,12,26045,2,300000,0,0,0,8,0,0,0,3403.829,4133.074,18.13754,5.759586,'Storm Totem - On Spellclick - Spawn Storm Tempest'),
(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,81,0,0,0,0,0,0,1,
@FALL1N1
FALL1N1 / gist:3846460
Created October 6, 2012 23:09
SET @ENTRY := 26048;
UPDATE `creature_template` SET `npcflag`=`npcflag`&~16777216,`AIName`= 'SmartAI',`ScriptName`='' WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,81,16777216,0,0,0,0,0,1,0,0,0,0,0,0,0,'Storm Totem - On spawn - set npcflag'),
(@ENTRY,0,1,2,72,0,100,0,1001,0,0,0,12,26045,2,300000,0,0,0,8,0,0,0,3403.829,4133.074,18.13754,5.759586,'Storm Totem - On Spellclick - Spawn Storm Tempest'),
(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,81,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Storm Totem - On spawn - remove npcflag');
SET @
@FALL1N1
FALL1N1 / gist:3846479
Created October 6, 2012 23:19
SET @Reanimated_Crusader := 30202;
SET @CreditSpell := 57808;
SET @HolyWater := 57806;
UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=@Reanimated_Crusader;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@Reanimated_Crusader;
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
(@Reanimated_Crusader,0,0,1,8,0,100,1,@HolyWater,0,0,0,11,@CreditSpell,0,0,0,0,0,7,0,0,0,0,0,0,0,'Reanimated Crusader - On hit by spell Holy Water - cast Freed Crusader Soul'),
(@Reanimated_Crusader,0,1,0,61,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Reanimated Crusader - link - force despawn'),
(@Reanimated_Crusader,0,2,0,0,0,10
@FALL1N1
FALL1N1 / gist:3846355
Created October 6, 2012 22:15
SET @ENTRY := 8479;
SET @QUEST := 3453;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
UPDATE `quest_template` SET `StartScript`=0,`CompleteScript`=0 WHERE `entry`=@QUEST;
DELETE FROM `quest_start_scripts` WHERE `id`=@QUEST;
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@ENTRY,@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,19,0,100,0,@QUEST,0,0,0,80,@ENTRY*100,0,2,0,0,0,1,0,0,0,0,0,0,0,"Kalaran Windblade - On Quest Accept - Run Script"),
(@ENTRY*100,9,0,0,0,0,100,0,10000,10000,0,0,11,12511,0,0,0,0,0,1,0,0,0,0,0,0,0,"Kalaran Windblade - On Script - Cast Torch Combine"),
(@ENTRY*100,9
@FALL1N1
FALL1N1 / gist:3846402
Created October 6, 2012 22:43
SET @MAIDEN := 33220;
SET @FROG := 33224;
SET @FROG_BAD := 33211;
SET @SPELL_TRANSFORM := 62550;
SET @SPELL_SWORD := 62554;
SET @SPELL_KISS := 62536;
SET @SPELL_FROG_LOVE := 62537;
SET @SPELL_WARTS := 62581;
SET @SPELL_BALM := 62574;
SET @GUID := 1022683;
@FALL1N1
FALL1N1 / gist:3846442
Created October 6, 2012 23:01
@SET @SPELL := 45474;
SET @GUARD := 25342;
SET @WORKER := 25343;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` IN (@GUARD,@WORKER) AND `id` IN (2,3);
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`) VALUES
(@GUARD,0,2,3,8,0,100,0,@SPELL,0,0,0,33,@GUARD,0,0,0,0,0,7,0,0,0,0,0,0,0),
(@GUARD,0,3,0,61,0,100,0,0,0,0,0,41,500,0,0,0,0,0,1,0,0,0,0,0,0,0),
(@WORKER,0,2,3,8,0,100,0,@SPELL,0,0,0,33,@GUARD,0,0,0,0,0,7,0,0,0,0,0,0,0),
(@WORKER,0,3,0,61,0,100,0,0,0,0,0,41,500,0,0,0,0,0,1,0,0,0,0,0,0,0);
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=@SPELL AND `ConditionTypeOrReference`=36;@