[svn] * Moved scripts sqls updates to main sql updates folder.

* Fixed makefile to use proper foldername.
* rXXX_world_scripts.sql will be the format for script sql updates, execute these into your world DB.

--HG--
branch : trunk

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