From 1bb16035923b0675b0c239379cd5d64c8310f28b Mon Sep 17 00:00:00 2001
From: KingPin <none@none>
Date: Mon, 27 Oct 2008 09:57:53 -0500
Subject: [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
---
 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 ++++++
 7 files changed, 98 insertions(+)
 create mode 100644 sql/updates/r112_world_scripts.sql
 create mode 100644 sql/updates/r125_world_scripts.sql
 create mode 100644 sql/updates/r57_world_scripts.sql
 create mode 100644 sql/updates/r66_world_scripts.sql
 create mode 100644 sql/updates/r70_world_scripts.sql
 create mode 100644 sql/updates/r82_world_scripts.sql
 create mode 100644 sql/updates/r86_world_scripts.sql

(limited to 'sql/updates')

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
-- 
cgit v1.2.3