From 3d6f3011f7d2b87c5dfa0238774441e48c093443 Mon Sep 17 00:00:00 2001 From: DarkRabbit 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 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 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