[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, 0 insertions, 98 deletions

diff --git a/src/bindings/scripts/sql/Updates/r112_trinity.sql b/src/bindings/scripts/sql/Updates/r112_trinity.sql
deleted file mode 100644
index 2d2412c395b..00000000000
--- a/src/bindings/scripts/sql/Updates/r112_trinity.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/src/bindings/scripts/sql/Updates/r125_trinity.sql b/src/bindings/scripts/sql/Updates/r125_trinity.sql
deleted file mode 100644
index 946d50f3939..00000000000
--- a/src/bindings/scripts/sql/Updates/r125_trinity.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/src/bindings/scripts/sql/Updates/r57_trinity.sql b/src/bindings/scripts/sql/Updates/r57_trinity.sql
deleted file mode 100644
index b7f61b9edae..00000000000
--- a/src/bindings/scripts/sql/Updates/r57_trinity.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/src/bindings/scripts/sql/Updates/r66_trinity.sql b/src/bindings/scripts/sql/Updates/r66_trinity.sql
deleted file mode 100644
index c19fbe65b0a..00000000000
--- a/src/bindings/scripts/sql/Updates/r66_trinity.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/src/bindings/scripts/sql/Updates/r70_trinity.sql b/src/bindings/scripts/sql/Updates/r70_trinity.sql
deleted file mode 100644
index 1bbf737c59c..00000000000
--- a/src/bindings/scripts/sql/Updates/r70_trinity.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/src/bindings/scripts/sql/Updates/r82_trinity.sql b/src/bindings/scripts/sql/Updates/r82_trinity.sql
deleted file mode 100644
index acdfdd06a6f..00000000000
--- a/src/bindings/scripts/sql/Updates/r82_trinity.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/src/bindings/scripts/sql/Updates/r86_trinity.sql b/src/bindings/scripts/sql/Updates/r86_trinity.sql
deleted file mode 100644
index 8b1f96c1564..00000000000
--- a/src/bindings/scripts/sql/Updates/r86_trinity.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