From 3d6f3011f7d2b87c5dfa0238774441e48c093443 Mon Sep 17 00:00:00 2001
From: DarkRabbit <none@none>
Date: Thu, 26 Feb 2009 19:54:28 +0100
Subject: *added Zul'aman hostage SQL update in world_scripts_full - by EIFEL

--HG--
branch : trunk
---
 sql/world_scripts_full.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'sql/world_scripts_full.sql')

diff --git a/sql/world_scripts_full.sql b/sql/world_scripts_full.sql
index 2070bf3bdfa..8e4c3a41e06 100644
--- a/sql/world_scripts_full.sql
+++ b/sql/world_scripts_full.sql
@@ -954,6 +954,7 @@ UPDATE `creature_template` SET `ScriptName` = 'boss_koragg' WHERE `entry` =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 `ScriptName` = 'npc_zulaman_hostage' WHERE `entry` IN (23790, 23999, 24024, 24001);
 
 /* ZUL'FARRAK */
 UPDATE `creature_template` SET `ScriptName`='npc_sergeant_bly' WHERE `entry`=7604;
-- 
cgit v1.2.3


From f65974c2810b7574bc50caf8f3c591af6c4d345d Mon Sep 17 00:00:00 2001
From: Drahy <none@none>
Date: Thu, 26 Feb 2009 20:38:06 +0100
Subject: * Added trinity sql coding style * A lot of cleaning - renamed 1508
 => 1525

--HG--
branch : trunk
---
 sql/updates/1508_world_scripts .sql                |  2 -
 sql/updates/1525_world_scripts.sql                 |  2 +
 ...1_mangos_7324_01_characters_character_spell.sql | 13 +++++
 ...31_mangos_7324_02_characters_character_aura.sql | 13 +++++
 sql/updates/1555_mangos_7331_01_world_command.sql  | 65 ++++++++++++++++++++++
 sql/updates/1559_world.sql                         |  4 +-
 sql/updates/1570_world.sql                         |  2 +-
 sql/updates/7324_01_characters_character_spell.sql | 13 -----
 sql/updates/7324_02_characters_character_aura.sql  | 13 -----
 sql/updates/7331_01_mangos_command.sql             | 65 ----------------------
 sql/updates/CMakeLists.txt                         |  6 ++
 sql/world_scripts_full.sql                         |  1 +
 12 files changed, 102 insertions(+), 97 deletions(-)
 delete mode 100644 sql/updates/1508_world_scripts .sql
 create mode 100644 sql/updates/1525_world_scripts.sql
 create mode 100644 sql/updates/1531_mangos_7324_01_characters_character_spell.sql
 create mode 100644 sql/updates/1531_mangos_7324_02_characters_character_aura.sql
 create mode 100644 sql/updates/1555_mangos_7331_01_world_command.sql
 delete mode 100644 sql/updates/7324_01_characters_character_spell.sql
 delete mode 100644 sql/updates/7324_02_characters_character_aura.sql
 delete mode 100644 sql/updates/7331_01_mangos_command.sql

(limited to 'sql/world_scripts_full.sql')

diff --git a/sql/updates/1508_world_scripts .sql b/sql/updates/1508_world_scripts .sql
deleted file mode 100644
index 0e479fe78f5..00000000000
--- a/sql/updates/1508_world_scripts .sql	
+++ /dev/null
@@ -1,2 +0,0 @@
--- Script for Yrykul Skeleton - Prince Keleseth Event
-update creature_template set scriptname = 'mob_vrykul_skeleton' where entry = 23970;
\ No newline at end of file
diff --git a/sql/updates/1525_world_scripts.sql b/sql/updates/1525_world_scripts.sql
new file mode 100644
index 00000000000..3eb373009da
--- /dev/null
+++ b/sql/updates/1525_world_scripts.sql
@@ -0,0 +1,2 @@
+-- Script for Yrykul Skeleton - Prince Keleseth Event
+UPDATE `creature_template` SET `ScriptName`='mob_vrykul_skeleton' WHERE `entry`=23970;
\ No newline at end of file
diff --git a/sql/updates/1531_mangos_7324_01_characters_character_spell.sql b/sql/updates/1531_mangos_7324_01_characters_character_spell.sql
new file mode 100644
index 00000000000..10c4317b457
--- /dev/null
+++ b/sql/updates/1531_mangos_7324_01_characters_character_spell.sql
@@ -0,0 +1,13 @@
+/*ALTER TABLE character_db_version CHANGE COLUMN required_7314_01_characters_guild_rank required_7324_01_characters_character_spell bit;*/
+
+/* remove some deleted spells or ranks from characters */
+/* Mana Tap no longer Blood Elf Racial */
+DELETE FROM `character_spell` WHERE `spell` = '28734';
+/* Hamstring is only one rank now, need to delete these zzOLDRank spells */
+DELETE FROM `character_spell` WHERE `spell` IN ('7373', '7372', '25212');
+/* Intercept is only one rank now, need to delete these zzOLDRank spells */
+DELETE FROM `character_spell` WHERE `spell` IN ('20616', '20617', '25272', '25275');
+/* Overpower is only one rank now, need to delete these zzOLDRank spells */
+DELETE FROM `character_spell` WHERE `spell` IN ('7887', '11584', '11585');
+/* Shield Bash is only one rank now, need to delete these zzOLDRank spells */
+DELETE FROM `character_spell` WHERE `spell` IN ('1671', '1672', '29704');
\ No newline at end of file
diff --git a/sql/updates/1531_mangos_7324_02_characters_character_aura.sql b/sql/updates/1531_mangos_7324_02_characters_character_aura.sql
new file mode 100644
index 00000000000..fd7e405f966
--- /dev/null
+++ b/sql/updates/1531_mangos_7324_02_characters_character_aura.sql
@@ -0,0 +1,13 @@
+/*ALTER TABLE character_db_version CHANGE COLUMN required_7324_01_characters_character_spell required_7324_02_characters_character_aura bit;*/
+
+/* remove some deleted spells or ranks from characters auras */
+/* Mana Tap no longer Blood Elf Racial */
+DELETE FROM `character_aura` WHERE `spell` = '28734';
+/* Hamstring is only one rank now, need to delete these zzOLDRank spells */
+DELETE FROM `character_aura` WHERE `spell` IN ('7373', '7372', '25212');
+/* Intercept is only one rank now, need to delete these zzOLDRank spells */
+DELETE FROM `character_aura` WHERE `spell` IN ('20616', '20617', '25272', '25275');
+/* Overpower is only one rank now, need to delete these zzOLDRank spells */
+DELETE FROM `character_aura` WHERE `spell` IN ('7887', '11584', '11585');
+/* Shield Bash is only one rank now, need to delete these zzOLDRank spells */
+DELETE FROM `character_aura` WHERE `spell` IN ('1671', '1672', '29704');
\ No newline at end of file
diff --git a/sql/updates/1555_mangos_7331_01_world_command.sql b/sql/updates/1555_mangos_7331_01_world_command.sql
new file mode 100644
index 00000000000..b85942b71a9
--- /dev/null
+++ b/sql/updates/1555_mangos_7331_01_world_command.sql
@@ -0,0 +1,65 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7312_01_mangos_mangos_string required_7331_01_mangos_command bit;*/
+
+DELETE FROM `command` WHERE `name` = 'account set addon';
+DELETE FROM `command` WHERE `name` = 'ban account';
+DELETE FROM `command` WHERE `name` = 'ban character';
+DELETE FROM `command` WHERE `name` = 'ban ip';
+DELETE FROM `command` WHERE `name` = 'baninfo account';
+DELETE FROM `command` WHERE `name` = 'baninfo character';
+DELETE FROM `command` WHERE `name` = 'baninfo ip';
+DELETE FROM `command` WHERE `name` = 'banlist account';
+DELETE FROM `command` WHERE `name` = 'banlist character';
+DELETE FROM `command` WHERE `name` = 'banlist ip';
+DELETE FROM `command` WHERE `name` = 'gm fly';
+/* next command deleted even in case it has been already corrected (trailing space) */
+DELETE FROM `command` WHERE `name` = 'gobject near ';
+DELETE FROM `command` WHERE `name` = 'gobject near';
+
+DELETE FROM `command` WHERE `name` = 'lookup player account';
+DELETE FROM `command` WHERE `name` = 'lookup player ip';
+DELETE FROM `command` WHERE `name` = 'lookup player email';
+DELETE FROM `command` WHERE `name` = 'modify money';
+DELETE FROM `command` WHERE `name` = 'modify mount';
+DELETE FROM `command` WHERE `name` = 'modify speed';
+DELETE FROM `command` WHERE `name` = 'modify titles';
+DELETE FROM `command` WHERE `name` = 'pdump write';
+DELETE FROM `command` WHERE `name` = 'pdump load';
+DELETE FROM `command` WHERE `name` = 'reset honor';
+DELETE FROM `command` WHERE `name` = 'reset level';
+DELETE FROM `command` WHERE `name` = 'reset spells';
+DELETE FROM `command` WHERE `name` = 'reset stats';
+DELETE FROM `command` WHERE `name` = 'reset talents';
+DELETE FROM `command` WHERE `name` = 'unban account';
+DELETE FROM `command` WHERE `name` = 'unban character';
+DELETE FROM `command` WHERE `name` = 'unban ip';
+
+INSERT INTO `command` VALUES
+('account set addon',3,'Syntax: .account set addon [$account] #addon\r\n\r\nSet user (possible targeted) expansion addon level allowed. Addon values: 0 - normal, 1 - tbc, 2 - wotlk.'),
+('ban account',3,'Syntax: .ban account $Name $bantime $reason\r\nBan account kick player.\r\n$bantime: negative value leads to permban, otherwise use a timestring like \"4d20h3s\".'),
+('ban character',3,'Syntax: .ban character $Name $bantime $reason\r\nBan account and kick player.\r\n$bantime: negative value leads to permban, otherwise use a timestring like \"4d20h3s\".'),
+('ban ip',3,'Syntax: .ban ip $Ip $bantime $reason\r\nBan IP.\r\n$bantime: negative value leads to permban, otherwise use a timestring like \"4d20h3s\".'),
+('baninfo account',3,'Syntax: .baninfo account\r\nWatch full information about a specific ban.'),
+('baninfo character',3,'Syntax: .baninfo character\r\nWatch full information about a specific ban.'),
+('baninfo ip',3,'Syntax: .baninfo ip\r\nWatch full information about a specific ban.'),
+('banlist account',3,'Syntax: .banlist account [$Name]\r\nSearches the banlist for a account name pattern or show full list account bans.'),
+('banlist character',3,'Syntax: .banlist character $Name\r\nSearches the banlist for a character name pattern. Pattern required.'),
+('banlist ip',3,'Syntax: .banlist ip [$Ip]\r\nSearches the banlist for a IP pattern or show full list of IP bans.'),
+('gm fly',3,'Syntax: .gm fly [on/off]\r\nEnable/disable gm fly mode.'),
+('gobject near',3,'Syntax: .gobject near  [#distance]\r\n\r\nOutput gameobjects at distance #distance from player. Output gameobject guids and coordinates sorted by distance from character. If #distance not provided use 10 as default value.'),
+('lookup player account',2,'Syntax: .lookup player account $account ($limit) \r\n\r\n Searchs players, which account username is $account with optional parametr $limit of results.'),
+('lookup player ip',2,'Syntax: .lookup player ip $ip ($limit) \r\n\r\n Searchs players, which account ast_ip is $ip with optional parametr $limit of results.'),
+('lookup player email',2,'Syntax: .lookup player email $email ($limit) \r\n\r\n Searchs players, which account email is $email with optional parametr $limit of results.'),
+('modify money',1,'Syntax: .modify money #money\r\n.money #money\r\n\r\nAdd or remove money to the selected player. If no player is selected, modify your money.\r\n\r\n #gold can be negative to remove money.'),
+('modify mount',1,'Syntax: .modify mount #id #speed\r\nDisplay selected player as mounted at #id creature and set speed to #speed value.'),
+('modify speed',1,'Syntax: .modify speed #rate\r\n.speed #rate\r\n\r\nModify the running speed of the selected player to \"normal base run speed\"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 10.'),
+('modify titles',1,'Syntax: .modify titles #mask\r\n\r\nAllows user to use all titles from #mask.\r\n\r\n #mask=0 disables the title-choose-field'),
+('pdump write',3,'Syntax: .pdump write $filename $playerNameOrGUID\r\nWrite character dump with name/guid $playerNameOrGUID to file $filename.'),
+('pdump load',3,'Syntax: .pdump load $filename $account [$newname] [$newguid]\r\nLoad character dump from dump file into character list of $account with saved or $newname, with saved (or first free) or $newguid guid.'),
+('reset honor',3,'Syntax: .reset honor [Playername]\r\n  Reset all honor data for targeted character.'),
+('reset level',3,'Syntax: .reset level [Playername]\r\n  Reset level to 1 including reset stats and talents.  Equipped items with greater level requirement can be lost.'),
+('reset spells',3,'Syntax: .reset spells [Playername]\r\n  Removes all non-original spells from spellbook.\r\n. Playername can be name of offline character.'),
+('reset stats',3,'Syntax: .reset stats [Playername]\r\n  Resets(recalculate) all stats of the targeted player to their original VALUESat current level.'),
+('reset talents',3,'Syntax: .reset talents [Playername]\r\n  Removes all talents of the targeted player. Playername can be name of offline character.'),
+('unban account',3,'Syntax: .unban account $Name\r\nUnban accounts for account name pattern.'),
+('unban character',3,'Syntax: .unban character $Name\r\nUnban accounts for character name pattern.'),
+('unban ip',3,'Syntax : .unban ip $Ip\r\nUnban accounts for IP pattern.');
\ No newline at end of file
diff --git a/sql/updates/1559_world.sql b/sql/updates/1559_world.sql
index eea06da956d..4421d36e95c 100644
--- a/sql/updates/1559_world.sql
+++ b/sql/updates/1559_world.sql
@@ -8,6 +8,4 @@ INSERT INTO `spell_proc_event` VALUES (47549, 0x00, 6, 0x00000000, 0x00000200, 0
 DELETE FROM `spell_proc_event` WHERE `entry` IN (47551);
 INSERT INTO `spell_proc_event` VALUES (47551, 0x00, 6, 0x00000000, 0x00000200, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0);
 DELETE FROM `spell_proc_event` WHERE `entry` IN (47552);
-INSERT INTO `spell_proc_event` VALUES (47552, 0x00, 6, 0x00000000, 0x00000200, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0);
-
-
+INSERT INTO `spell_proc_event` VALUES (47552, 0x00, 6, 0x00000000, 0x00000200, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0);
\ No newline at end of file
diff --git a/sql/updates/1570_world.sql b/sql/updates/1570_world.sql
index 8c4f15fb3e2..4c84b54194e 100644
--- a/sql/updates/1570_world.sql
+++ b/sql/updates/1570_world.sql
@@ -1,3 +1,3 @@
 -- Bloodsurge
 DELETE FROM `spell_proc_event` WHERE `entry` IN (46915);
-INSERT INTO `spell_proc_event` VALUES (46915, 0x00, 6, 0x00000040, 0x00000404, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0);
+INSERT INTO `spell_proc_event` VALUES (46915, 0x00, 6, 0x00000040, 0x00000404, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0);
\ No newline at end of file
diff --git a/sql/updates/7324_01_characters_character_spell.sql b/sql/updates/7324_01_characters_character_spell.sql
deleted file mode 100644
index d4917ec4814..00000000000
--- a/sql/updates/7324_01_characters_character_spell.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-ALTER TABLE character_db_version CHANGE COLUMN required_7314_01_characters_guild_rank required_7324_01_characters_character_spell bit;
-
-/* remove some deleted spells or ranks from characters */
-/* Mana Tap no longer Blood Elf Racial */
-DELETE FROM `character_spell` WHERE `spell` = '28734';
-/* Hamstring is only one rank now, need to delete these zzOLDRank spells */
-DELETE FROM `character_spell` WHERE `spell` IN ('7373', '7372', '25212');
-/* Intercept is only one rank now, need to delete these zzOLDRank spells */
-DELETE FROM `character_spell` WHERE `spell` IN ('20616', '20617', '25272', '25275');
-/* Overpower is only one rank now, need to delete these zzOLDRank spells */
-DELETE FROM `character_spell` WHERE `spell` IN ('7887', '11584', '11585');
-/* Shield Bash is only one rank now, need to delete these zzOLDRank spells */
-DELETE FROM `character_spell` WHERE `spell` IN ('1671', '1672', '29704');
diff --git a/sql/updates/7324_02_characters_character_aura.sql b/sql/updates/7324_02_characters_character_aura.sql
deleted file mode 100644
index c9379d25788..00000000000
--- a/sql/updates/7324_02_characters_character_aura.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-ALTER TABLE character_db_version CHANGE COLUMN required_7324_01_characters_character_spell required_7324_02_characters_character_aura bit;
-
-/* remove some deleted spells or ranks from characters auras */
-/* Mana Tap no longer Blood Elf Racial */
-DELETE FROM `character_aura` WHERE `spell` = '28734';
-/* Hamstring is only one rank now, need to delete these zzOLDRank spells */
-DELETE FROM `character_aura` WHERE `spell` IN ('7373', '7372', '25212');
-/* Intercept is only one rank now, need to delete these zzOLDRank spells */
-DELETE FROM `character_aura` WHERE `spell` IN ('20616', '20617', '25272', '25275');
-/* Overpower is only one rank now, need to delete these zzOLDRank spells */
-DELETE FROM `character_aura` WHERE `spell` IN ('7887', '11584', '11585');
-/* Shield Bash is only one rank now, need to delete these zzOLDRank spells */
-DELETE FROM `character_aura` WHERE `spell` IN ('1671', '1672', '29704');
diff --git a/sql/updates/7331_01_mangos_command.sql b/sql/updates/7331_01_mangos_command.sql
deleted file mode 100644
index 4a3b2733158..00000000000
--- a/sql/updates/7331_01_mangos_command.sql
+++ /dev/null
@@ -1,65 +0,0 @@
-ALTER TABLE db_version CHANGE COLUMN required_7312_01_mangos_mangos_string required_7331_01_mangos_command bit;
-
-DELETE FROM `command` WHERE `name` = 'account set addon';
-DELETE FROM `command` WHERE `name` = 'ban account';
-DELETE FROM `command` WHERE `name` = 'ban character';
-DELETE FROM `command` WHERE `name` = 'ban ip';
-DELETE FROM `command` WHERE `name` = 'baninfo account';
-DELETE FROM `command` WHERE `name` = 'baninfo character';
-DELETE FROM `command` WHERE `name` = 'baninfo ip';
-DELETE FROM `command` WHERE `name` = 'banlist account';
-DELETE FROM `command` WHERE `name` = 'banlist character';
-DELETE FROM `command` WHERE `name` = 'banlist ip';
-DELETE FROM `command` WHERE `name` = 'gm fly';
-/* next command deleted even in case it has been already corrected (trailing space) */
-DELETE FROM `command` WHERE `name` = 'gobject near ';
-DELETE FROM `command` WHERE `name` = 'gobject near';
-
-DELETE FROM `command` WHERE `name` = 'lookup player account';
-DELETE FROM `command` WHERE `name` = 'lookup player ip';
-DELETE FROM `command` WHERE `name` = 'lookup player email';
-DELETE FROM `command` WHERE `name` = 'modify money';
-DELETE FROM `command` WHERE `name` = 'modify mount';
-DELETE FROM `command` WHERE `name` = 'modify speed';
-DELETE FROM `command` WHERE `name` = 'modify titles';
-DELETE FROM `command` WHERE `name` = 'pdump write';
-DELETE FROM `command` WHERE `name` = 'pdump load';
-DELETE FROM `command` WHERE `name` = 'reset honor';
-DELETE FROM `command` WHERE `name` = 'reset level';
-DELETE FROM `command` WHERE `name` = 'reset spells';
-DELETE FROM `command` WHERE `name` = 'reset stats';
-DELETE FROM `command` WHERE `name` = 'reset talents';
-DELETE FROM `command` WHERE `name` = 'unban account';
-DELETE FROM `command` WHERE `name` = 'unban character';
-DELETE FROM `command` WHERE `name` = 'unban ip';
-
-INSERT INTO `command` VALUES
-('account set addon',3,'Syntax: .account set addon [$account] #addon\r\n\r\nSet user (possible targeted) expansion addon level allowed. Addon values: 0 - normal, 1 - tbc, 2 - wotlk.'),
-('ban account',3,'Syntax: .ban account $Name $bantime $reason\r\nBan account kick player.\r\n$bantime: negative value leads to permban, otherwise use a timestring like \"4d20h3s\".'),
-('ban character',3,'Syntax: .ban character $Name $bantime $reason\r\nBan account and kick player.\r\n$bantime: negative value leads to permban, otherwise use a timestring like \"4d20h3s\".'),
-('ban ip',3,'Syntax: .ban ip $Ip $bantime $reason\r\nBan IP.\r\n$bantime: negative value leads to permban, otherwise use a timestring like \"4d20h3s\".'),
-('baninfo account',3,'Syntax: .baninfo account\r\nWatch full information about a specific ban.'),
-('baninfo character',3,'Syntax: .baninfo character\r\nWatch full information about a specific ban.'),
-('baninfo ip',3,'Syntax: .baninfo ip\r\nWatch full information about a specific ban.'),
-('banlist account',3,'Syntax: .banlist account [$Name]\r\nSearches the banlist for a account name pattern or show full list account bans.'),
-('banlist character',3,'Syntax: .banlist character $Name\r\nSearches the banlist for a character name pattern. Pattern required.'),
-('banlist ip',3,'Syntax: .banlist ip [$Ip]\r\nSearches the banlist for a IP pattern or show full list of IP bans.'),
-('gm fly',3,'Syntax: .gm fly [on/off]\r\nEnable/disable gm fly mode.'),
-('gobject near',3,'Syntax: .gobject near  [#distance]\r\n\r\nOutput gameobjects at distance #distance from player. Output gameobject guids and coordinates sorted by distance from character. If #distance not provided use 10 as default value.'),
-('lookup player account',2,'Syntax: .lookup player account $account ($limit) \r\n\r\n Searchs players, which account username is $account with optional parametr $limit of results.'),
-('lookup player ip',2,'Syntax: .lookup player ip $ip ($limit) \r\n\r\n Searchs players, which account ast_ip is $ip with optional parametr $limit of results.'),
-('lookup player email',2,'Syntax: .lookup player email $email ($limit) \r\n\r\n Searchs players, which account email is $email with optional parametr $limit of results.'),
-('modify money',1,'Syntax: .modify money #money\r\n.money #money\r\n\r\nAdd or remove money to the selected player. If no player is selected, modify your money.\r\n\r\n #gold can be negative to remove money.'),
-('modify mount',1,'Syntax: .modify mount #id #speed\r\nDisplay selected player as mounted at #id creature and set speed to #speed value.'),
-('modify speed',1,'Syntax: .modify speed #rate\r\n.speed #rate\r\n\r\nModify the running speed of the selected player to \"normal base run speed\"*rate. If no player is selected, modify your speed.\r\n\r\n #rate may range from 0.1 to 10.'),
-('modify titles',1,'Syntax: .modify titles #mask\r\n\r\nAllows user to use all titles from #mask.\r\n\r\n #mask=0 disables the title-choose-field'),
-('pdump write',3,'Syntax: .pdump write $filename $playerNameOrGUID\r\nWrite character dump with name/guid $playerNameOrGUID to file $filename.'),
-('pdump load',3,'Syntax: .pdump load $filename $account [$newname] [$newguid]\r\nLoad character dump from dump file into character list of $account with saved or $newname, with saved (or first free) or $newguid guid.'),
-('reset honor',3,'Syntax: .reset honor [Playername]\r\n  Reset all honor data for targeted character.'),
-('reset level',3,'Syntax: .reset level [Playername]\r\n  Reset level to 1 including reset stats and talents.  Equipped items with greater level requirement can be lost.'),
-('reset spells',3,'Syntax: .reset spells [Playername]\r\n  Removes all non-original spells from spellbook.\r\n. Playername can be name of offline character.'),
-('reset stats',3,'Syntax: .reset stats [Playername]\r\n  Resets(recalculate) all stats of the targeted player to their original VALUESat current level.'),
-('reset talents',3,'Syntax: .reset talents [Playername]\r\n  Removes all talents of the targeted player. Playername can be name of offline character.'),
-('unban account',3,'Syntax: .unban account $Name\r\nUnban accounts for account name pattern.'),
-('unban character',3,'Syntax: .unban character $Name\r\nUnban accounts for character name pattern.'),
-('unban ip',3,'Syntax : .unban ip $Ip\r\nUnban accounts for IP pattern.');
\ No newline at end of file
diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt
index f54e3161cf5..2b6de8c5c4e 100644
--- a/sql/updates/CMakeLists.txt
+++ b/sql/updates/CMakeLists.txt
@@ -43,5 +43,11 @@ INSTALL(FILES
 1484_mangos_7307_01_characters_arena_team_member.sql
 1495_mangos_7312_01_world_trinity_string.sql
 1497_mangos_7314_01_characters_guild_rank.sql
+1525_world_scripts.sql
+1531_mangos_7324_01_characters_character_spell.sql
+1531_mangos_7324_02_characters_character_aura.sql
+1555_mangos_7331_01_world_command.sql
 1558_world_spell_linked_spell.sql
+1559_world.sql
+1570_world.sql
 DESTINATION share/trinity/sql/updates)
\ No newline at end of file
diff --git a/sql/world_scripts_full.sql b/sql/world_scripts_full.sql
index 8e4c3a41e06..b6f08889a17 100644
--- a/sql/world_scripts_full.sql
+++ b/sql/world_scripts_full.sql
@@ -905,6 +905,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_parqual_fintallas' WHERE `entry
 UPDATE `creature_template` SET `scriptname` = 'boss_keleseth' WHERE `entry` = '23953';
 UPDATE `creature_template` SET `scriptname` = 'mob_frost_tomb' WHERE `entry` = '23965';
 UPDATE `instance_template` SET `script`='instance_utgarde_keep' WHERE `map`= '574';
+UPDATE `creature_template` SET `ScriptName`='mob_vrykul_skeleton' WHERE `entry`=23970;
 
 /* WAILING CAVERNS */
 
-- 
cgit v1.2.3


From 2f0beef0ddc805b586ba9b6ccda01891a73fba64 Mon Sep 17 00:00:00 2001
From: DarkRabbit <none@none>
Date: Thu, 26 Feb 2009 23:55:46 +0100
Subject: *Added missing scripts in world_scripts_full.sql - by Xlybriem

--HG--
branch : trunk
---
 sql/world_scripts_full.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'sql/world_scripts_full.sql')

diff --git a/sql/world_scripts_full.sql b/sql/world_scripts_full.sql
index b6f08889a17..0601dc6d0f1 100644
--- a/sql/world_scripts_full.sql
+++ b/sql/world_scripts_full.sql
@@ -313,6 +313,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_saat' WHERE `entry`=20201;
 /* THE UNDERBOG */
 UPDATE `creature_template` SET `ScriptName`='mob_underbog_mushroom' WHERE `entry`=17990;
 UPDATE `creature_template` SET `ScriptName`='boss_hungarfen' WHERE `entry`=17770;
+UPDATE `creature_template` SET `ScriptName`='boss_the_black_stalker' WHERE `entry`='17882';
 
 /* THE STEAMVAULT */
 UPDATE `instance_template` SET `script`='instance_steam_vault' WHERE `map`=545;
@@ -330,6 +331,7 @@ UPDATE `creature_template` SET `ScriptName`='mob_toxic_sporebat' WHERE `entry`=2
 /* Leotheras the Blind event */
 UPDATE `creature_template` SET `ScriptName`='boss_leotheras_the_blind' WHERE `entry`=21215;
 UPDATE `creature_template` SET `ScriptName`='boss_leotheras_the_blind_demonform' WHERE `entry`=21845;
+UPDATE `creature_template` SET `ScriptName`='mob_greyheart_spellbinder' WHERE `entry` = '21806';
 /* Fathom-lord Karathress event */
 UPDATE `creature_template` SET `ScriptName`='boss_fathomlord_karathress' WHERE `entry`=21214;
 UPDATE `creature_template` SET `ScriptName`='boss_fathomguard_sharkkis' WHERE `entry`=21966;
-- 
cgit v1.2.3

