aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/r112_world_scripts.sql2
-rw-r--r--sql/updates/r125_world_scripts.sql5
-rw-r--r--sql/updates/r57_world_scripts.sql39
-rw-r--r--sql/updates/r66_world_scripts.sql18
-rw-r--r--sql/updates/r70_world_scripts.sql27
-rw-r--r--sql/updates/r82_world_scripts.sql1
-rw-r--r--sql/updates/r86_world_scripts.sql6
7 files changed, 98 insertions, 0 deletions
diff --git a/sql/updates/r112_world_scripts.sql b/sql/updates/r112_world_scripts.sql
new file mode 100644
index 00000000000..2d2412c395b
--- /dev/null
+++ b/sql/updates/r112_world_scripts.sql
@@ -0,0 +1,2 @@
+UPDATE `item_template` SET `ScriptName`='item_arcane_charges' WHERE `entry`='34475';
+UPDATE gameobject_template SET faction = 14 WHERE entry = 185134; \ No newline at end of file
diff --git a/sql/updates/r125_world_scripts.sql b/sql/updates/r125_world_scripts.sql
new file mode 100644
index 00000000000..2d250a538f9
--- /dev/null
+++ b/sql/updates/r125_world_scripts.sql
@@ -0,0 +1,5 @@
+update creature_template set speed='0.01', scriptname='mob_toxic_sporebat' WHERE entry=22140;
+update creature_template SET scriptname='npc_overlord_morghor' WHERE entry=23139;
+update creature_template SET scriptname='npc_lord_illidan_stormrage' WHERE entry=22083;
+update creature_template SET scriptname='npc_yarzill_the_merc' WHERE entry=23141;
+update quest_template SET StartScript=0 WHERE entry=11108; \ No newline at end of file
diff --git a/sql/updates/r57_world_scripts.sql b/sql/updates/r57_world_scripts.sql
new file mode 100644
index 00000000000..b7f61b9edae
--- /dev/null
+++ b/sql/updates/r57_world_scripts.sql
@@ -0,0 +1,39 @@
+/*sql for zulaman*/
+UPDATE `creature_template` SET `ScriptName` = 'boss_nalorakk' WHERE `entry` = 23576;
+UPDATE `creature_template` SET `flags_extra` = 33 WHERE `entry` = 23576; /*no crush*/
+
+UPDATE `creature_template` set `ScriptName` = 'boss_akilzon' where entry = 23574;
+UPDATE `creature_template` set `ScriptName` = 'mob_akilzon_eagle' where `entry`=24858; /*default is event ai*/
+
+UPDATE `creature_template` SET `ScriptName` = 'boss_halazzi' WHERE `entry` = '23577';
+UPDATE `creature_template` SET `ScriptName` = 'mob_halazzi_lynx' WHERE `entry` = '24143';
+UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` = '24224'; /*totem default `spell1` = '43301' should be in DB*/
+
+UPDATE `creature_template` SET `ScriptName` = 'boss_janalai' WHERE `entry` = '23578';
+UPDATE `creature_template` SET `ScriptName` = 'mob_janalai_hatcher' WHERE `entry` = '23818';
+UPDATE `creature_template` SET `ScriptName` = 'mob_janalai_hatchling' WHERE `entry` = '23598';
+UPDATE `creature_template` SET `ScriptName` = 'mob_janalai_egg' WHERE `entry` = '23817';
+UPDATE `creature_template` SET `ScriptName` = 'mob_janalai_firebomb' WHERE `entry` = '23920';
+
+UPDATE `creature_template` SET `ScriptName` = 'boss_hexlord_malacrass' WHERE `entry` =24239;
+UPDATE `creature_template` SET `ScriptName` = 'boss_alyson_antille' WHERE `entry` =24240;
+UPDATE `creature_template` SET `ScriptName` = 'boss_thurg' WHERE `entry` =24241;
+UPDATE `creature_template` SET `ScriptName` = 'boss_slither' WHERE `entry` =24242;
+UPDATE `creature_template` SET `ScriptName` = 'boss_lord_raadan' WHERE `entry` =24243;
+UPDATE `creature_template` SET `ScriptName` = 'boss_gazakroth' WHERE `entry` =24244;
+UPDATE `creature_template` SET `ScriptName` = 'boss_fenstalker' WHERE `entry` =24245;
+UPDATE `creature_template` SET `ScriptName` = 'boss_darkheart' WHERE `entry` =24246;
+UPDATE `creature_template` SET `ScriptName` = 'boss_koragg' WHERE `entry` =24247;
+UPDATE `creature` SET `position_x` = '117.8827',`position_y` = '921.2795',`position_z` = '33.8883',`orientation` = '1.5696' WHERE `id` = '24239' LIMIT 1;
+UPDATE `creature_template` SET `faction_A` = '1890', `faction_H` = '1890' WHERE `entry` in ('24240', '24241', '24242', '24243', '24244', '24245', '24246', '24247');
+
+UPDATE `creature_template` SET `ScriptName` = 'boss_zuljin' WHERE `entry` =23863;
+UPDATE `creature_template` SET `ScriptName` = 'do_nothing' WHERE `entry` = '24187';
+UPDATE `creature_template` SET `ScriptName` = 'mob_zuljin_vortex' WHERE `entry` = '24136';
+UPDATE `creature_template` SET `minlevel` = '73', `maxlevel` = '73' WHERE `entry` IN (24187, 24136);
+DELETE FROM `spell_proc_event` WHERE `entry` = 43983;
+INSERT INTO `spell_proc_event` VALUES ('43983', '0', '0', '0', '0', '0', '16384', '0', '0');
+DELETE FROM `spell_script_target` WHERE `entry` = 42577;
+INSERT INTO `spell_script_target` VALUES ('42577', '1', '24136');
+
+UPDATE `creature_template` SET `ScriptName` = 'npc_zulaman_hostage' WHERE `entry` IN (23790, 23999, 24024, 24001); \ No newline at end of file
diff --git a/sql/updates/r66_world_scripts.sql b/sql/updates/r66_world_scripts.sql
new file mode 100644
index 00000000000..c19fbe65b0a
--- /dev/null
+++ b/sql/updates/r66_world_scripts.sql
@@ -0,0 +1,18 @@
+update instance_template set script = 'instance_sunwell_plateau' where map = 580;
+UPDATE creature_template SET ScriptName = 'boss_brutallus' WHERE entry = 24882;
+UPDATE `creature_template` SET `ScriptName` = 'boss_felmyst' WHERE `entry` = 25038;
+UPDATE `creature_template` SET `ScriptName` = 'mob_felmyst_vapor' WHERE `entry` = 25265;
+UPDATE `creature_template` SET `ScriptName` = 'mob_felmyst_trail' WHERE `entry` = 25267;
+update creature_template set scriptname = 'boss_sacrolash' where entry = 25165;
+update creature_template set scriptname = 'boss_alythess' where entry = 25166;
+update creature_template set scriptname = 'mob_shadow_image' where entry = 25214;
+REPLACE INTO `gameobject_template` VALUES (187366, 6, 4251, 'Blaze', '', 14, 0, 1, 0, 73, 2, 45246, 0, 1, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
+UPDATE creature_template SET faction_H = 14, faction_A = 14, minlevel = 73, maxlevel = 73,rank = 3, flags = 33554434, flag1 = 0 WHERE entry = 25214;
+UPDATE `creature_template` SET `minlevel` = '70', `maxlevel` = '70',`faction_A` = '14', `faction_H` = '14' WHERE `entry` in (25265,25267,25268);
+UPDATE `creature_template` SET `mindmg` = '1500', `maxdmg` = '2500', `minhealth` = '40000', `maxhealth` = '40000', `baseattacktime` = '2000' WHERE `entry` = 25268;
+DELETE FROM `spell_script_target` WHERE `entry` in (44885,45388,45389,46350,45714);
+INSERT INTO `spell_script_target` VALUES ('45388', '1', '25038');
+INSERT INTO `spell_script_target` VALUES ('45389', '1', '25265');
+INSERT INTO `spell_script_target` VALUES ('44885', '1', '25160');
+INSERT INTO `spell_script_target` VALUES ('46350', '1', '25160');
+INSERT INTO `spell_script_target` VALUES ('45714', '1', '25038'); \ No newline at end of file
diff --git a/sql/updates/r70_world_scripts.sql b/sql/updates/r70_world_scripts.sql
new file mode 100644
index 00000000000..1bbf737c59c
--- /dev/null
+++ b/sql/updates/r70_world_scripts.sql
@@ -0,0 +1,27 @@
+UPDATE `creature_template` SET
+`minlevel` = '60',
+`maxlevel` = '60',
+`minhealth` = '6900',
+`maxhealth` = '7200',
+`minmana` = '9476',
+`maxmana` = '9736',
+`armor` = '4000',
+`speed` = '1.7',
+`rank` = '1',
+`mindmg` = '600',
+`maxdmg` = '1500',
+`attackpower` = '1200',
+`family` = '16',
+`minrangedmg` = '0',
+`maxrangedmg` = '0',
+`rangedattackpower` = '0',
+`resistance1` = '15',
+`resistance2` = '15',
+`resistance3` = '15',
+`resistance4` = '15',
+`resistance5` = '15',
+`resistance6` = '15',
+`ScriptName` = 'npc_kservant' WHERE `entry` = '19685';
+
+DELETE FROM `quest_start_scripts` WHERE `id`='10211';
+UPDATE `quest_template` SET `StartScript`='0' WHERE entry=10211; \ No newline at end of file
diff --git a/sql/updates/r82_world_scripts.sql b/sql/updates/r82_world_scripts.sql
new file mode 100644
index 00000000000..acdfdd06a6f
--- /dev/null
+++ b/sql/updates/r82_world_scripts.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `ScriptName` = 'npc_twiggy_flathead' WHERE `entry` =6248; \ No newline at end of file
diff --git a/sql/updates/r86_world_scripts.sql b/sql/updates/r86_world_scripts.sql
new file mode 100644
index 00000000000..8b1f96c1564
--- /dev/null
+++ b/sql/updates/r86_world_scripts.sql
@@ -0,0 +1,6 @@
+update `creature_template` set `ScriptName`='boss_alar' where `entry`='19514';
+update `creature_template` set `ScriptName`='mob_ember_of_alar' where `entry`='19551';
+update `creature_template` set `ScriptName`='mob_flame_patch_alar' where `entry`='20602';
+
+update gameobject_template set scriptname = "go_manticron_cube" where entry = 181713;
+update creature_template set scriptname = "mob_abyssal" where entry = 17454; \ No newline at end of file