From bbd5c8fd403408297f094c1634e0a28b5312902c Mon Sep 17 00:00:00 2001
From: KingPin <none@none>
Date: Mon, 27 Oct 2008 13:23:14 -0500
Subject: [svn] * Properly name Updates for scripts.

--HG--
branch : trunk
---
 sql/updates/112_world_scripts.sql  |  2 ++
 sql/updates/125_world_scripts.sql  |  5 +++++
 sql/updates/57_world_scripts.sql   | 39 ++++++++++++++++++++++++++++++++++++++
 sql/updates/66_world_scripts.sql   | 18 ++++++++++++++++++
 sql/updates/70_world_scripts.sql   | 27 ++++++++++++++++++++++++++
 sql/updates/82_world_scripts.sql   |  1 +
 sql/updates/86_world_scripts.sql   |  6 ++++++
 sql/updates/r112_world_scripts.sql |  2 --
 sql/updates/r125_world_scripts.sql |  5 -----
 sql/updates/r57_world_scripts.sql  | 39 --------------------------------------
 sql/updates/r66_world_scripts.sql  | 18 ------------------
 sql/updates/r70_world_scripts.sql  | 27 --------------------------
 sql/updates/r82_world_scripts.sql  |  1 -
 sql/updates/r86_world_scripts.sql  |  6 ------
 14 files changed, 98 insertions(+), 98 deletions(-)
 create mode 100644 sql/updates/112_world_scripts.sql
 create mode 100644 sql/updates/125_world_scripts.sql
 create mode 100644 sql/updates/57_world_scripts.sql
 create mode 100644 sql/updates/66_world_scripts.sql
 create mode 100644 sql/updates/70_world_scripts.sql
 create mode 100644 sql/updates/82_world_scripts.sql
 create mode 100644 sql/updates/86_world_scripts.sql
 delete mode 100644 sql/updates/r112_world_scripts.sql
 delete mode 100644 sql/updates/r125_world_scripts.sql
 delete mode 100644 sql/updates/r57_world_scripts.sql
 delete mode 100644 sql/updates/r66_world_scripts.sql
 delete mode 100644 sql/updates/r70_world_scripts.sql
 delete mode 100644 sql/updates/r82_world_scripts.sql
 delete mode 100644 sql/updates/r86_world_scripts.sql

(limited to 'sql')

diff --git a/sql/updates/112_world_scripts.sql b/sql/updates/112_world_scripts.sql
new file mode 100644
index 00000000000..2d2412c395b
--- /dev/null
+++ b/sql/updates/112_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/125_world_scripts.sql b/sql/updates/125_world_scripts.sql
new file mode 100644
index 00000000000..2d250a538f9
--- /dev/null
+++ b/sql/updates/125_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/57_world_scripts.sql b/sql/updates/57_world_scripts.sql
new file mode 100644
index 00000000000..b7f61b9edae
--- /dev/null
+++ b/sql/updates/57_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/66_world_scripts.sql b/sql/updates/66_world_scripts.sql
new file mode 100644
index 00000000000..c19fbe65b0a
--- /dev/null
+++ b/sql/updates/66_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/70_world_scripts.sql b/sql/updates/70_world_scripts.sql
new file mode 100644
index 00000000000..1bbf737c59c
--- /dev/null
+++ b/sql/updates/70_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/82_world_scripts.sql b/sql/updates/82_world_scripts.sql
new file mode 100644
index 00000000000..acdfdd06a6f
--- /dev/null
+++ b/sql/updates/82_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/86_world_scripts.sql b/sql/updates/86_world_scripts.sql
new file mode 100644
index 00000000000..8b1f96c1564
--- /dev/null
+++ b/sql/updates/86_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
diff --git a/sql/updates/r112_world_scripts.sql b/sql/updates/r112_world_scripts.sql
deleted file mode 100644
index 2d2412c395b..00000000000
--- a/sql/updates/r112_world_scripts.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-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
deleted file mode 100644
index 2d250a538f9..00000000000
--- a/sql/updates/r125_world_scripts.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-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
deleted file mode 100644
index b7f61b9edae..00000000000
--- a/sql/updates/r57_world_scripts.sql
+++ /dev/null
@@ -1,39 +0,0 @@
-/*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
deleted file mode 100644
index c19fbe65b0a..00000000000
--- a/sql/updates/r66_world_scripts.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-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
deleted file mode 100644
index 1bbf737c59c..00000000000
--- a/sql/updates/r70_world_scripts.sql
+++ /dev/null
@@ -1,27 +0,0 @@
-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
deleted file mode 100644
index acdfdd06a6f..00000000000
--- a/sql/updates/r82_world_scripts.sql
+++ /dev/null
@@ -1 +0,0 @@
-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
deleted file mode 100644
index 8b1f96c1564..00000000000
--- a/sql/updates/r86_world_scripts.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-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
-- 
cgit v1.2.3