diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/3535_TC1_1509_world_scripts.sql (renamed from sql/updates/TC1_1509_world_scripts.sql) | 4 | ||||
| -rw-r--r-- | sql/updates/3576_world_spell_script_target.sql | 2 | ||||
| -rw-r--r-- | sql/updates/3577_world_spell_target_position.sql | 2 | ||||
| -rw-r--r-- | sql/updates/3587_mangos_7893_01_world_command.sql (renamed from sql/updates/7893_01_mangos_command.sql) | 9 | ||||
| -rw-r--r-- | sql/updates/3592_world_spell_(dk).sql | 9 | ||||
| -rw-r--r-- | sql/updates/3593_world_spellclick_(dk).sql | 3 | ||||
| -rw-r--r-- | sql/updates/3596_world_scripts.sql | 2 |
7 files changed, 12 insertions, 19 deletions
diff --git a/sql/updates/TC1_1509_world_scripts.sql b/sql/updates/3535_TC1_1509_world_scripts.sql index d2adb3fb644..91b84c2b5ff 100644 --- a/sql/updates/TC1_1509_world_scripts.sql +++ b/sql/updates/3535_TC1_1509_world_scripts.sql @@ -1,2 +1,2 @@ -UPDATE `gameobject_template` SET `ScriptName` = 'kalecgos_teleporter' WHERE `entry` = 187055; -UPDATE `creature_template` SET `ScriptName` = 'boss_kalecgos_kj' WHERE `entry` = 25319; +UPDATE `gameobject_template` SET `ScriptName` = 'kalecgos_teleporter' WHERE `entry`=187055; +UPDATE `creature_template` SET `ScriptName` = 'boss_kalecgos_kj' WHERE `entry`=25319;
\ No newline at end of file diff --git a/sql/updates/3576_world_spell_script_target.sql b/sql/updates/3576_world_spell_script_target.sql index 37d786bc129..f895c41b802 100644 --- a/sql/updates/3576_world_spell_script_target.sql +++ b/sql/updates/3576_world_spell_script_target.sql @@ -5,4 +5,4 @@ INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (54699,1,0), (54725,1,0), (54744,1,0), -(54746,1,0); +(54746,1,0);
\ No newline at end of file diff --git a/sql/updates/3577_world_spell_target_position.sql b/sql/updates/3577_world_spell_target_position.sql index 35190cdaca0..d61f079d291 100644 --- a/sql/updates/3577_world_spell_target_position.sql +++ b/sql/updates/3577_world_spell_target_position.sql @@ -2,4 +2,4 @@ DELETE FROM `spell_target_position` WHERE `id` IN (54744,54746); INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES (54744, 0, 2418.67, -5621.41, 420.644, 3.89597), -(54746, 0, 2402.15, -5633.74, 377.021, 3.65249); +(54746, 0, 2402.15, -5633.74, 377.021, 3.65249);
\ No newline at end of file diff --git a/sql/updates/7893_01_mangos_command.sql b/sql/updates/3587_mangos_7893_01_world_command.sql index 8b21a405ee4..2009ca5d903 100644 --- a/sql/updates/7893_01_mangos_command.sql +++ b/sql/updates/3587_mangos_7893_01_world_command.sql @@ -1,10 +1,7 @@ -ALTER TABLE db_version CHANGE COLUMN required_7886_01_mangos_petcreateinfo_spell required_7893_01_mangos_command bit; - -DELETE FROM `command` WHERE `name` IN ( - 'guild create','guild delete','guild invite' -); +/*ALTER TABLE db_version CHANGE COLUMN required_7886_01_mangos_petcreateinfo_spell required_7893_01_mangos_command bit;*/ +DELETE FROM `command` WHERE `name` IN ('guild create','guild delete','guild invite'); INSERT INTO `command` VALUES ('guild create',2,'Syntax: .guild create [$GuildLeaderName] "$GuildName"\r\n\r\nCreate a guild named $GuildName with the player $GuildLeaderName (or selected) as leader. Guild name must in quotes.'), ('guild invite',2,'Syntax: .guild invite [$CharacterName] "$GuildName"\r\n\r\nAdd player $CharacterName (or selected) into a guild $GuildName. Guild name must in quotes.'), -('guild delete',2,'Syntax: .guild delete "$GuildName"\r\n\r\nDelete guild $GuildName. Guild name must in quotes.'); +('guild delete',2,'Syntax: .guild delete "$GuildName"\r\n\r\nDelete guild $GuildName. Guild name must in quotes.');
\ No newline at end of file diff --git a/sql/updates/3592_world_spell_(dk).sql b/sql/updates/3592_world_spell_(dk).sql index 394350b9745..4f7c4e294ac 100644 --- a/sql/updates/3592_world_spell_(dk).sql +++ b/sql/updates/3592_world_spell_(dk).sql @@ -1,11 +1,8 @@ -update creature_template set spell5=51890 where entry = 28511; -- Eye of Acherus flight - -DELETE FROM `spell_script_target` WHERE entry IN -(51859); +DELETE FROM `spell_script_target` WHERE entry IN (51859); INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (51859, 1, 28525), -- siphon of archerus (51859, 1, 28542), (51859, 1, 28543), (51859, 1, 28544); - -update creature_template set minlevel=50,maxlevel=52,minhealth=2215,maxhealth=2317,faction_A=2084,faction_H=2084,mindmg=50,maxdmg=50 where entry=28528; -- ghoul +UPDATE `creature_template` SET `spell5`=51890 WHERE `entry`=28511; -- Eye of Acherus flight +UPDATE `creature_template` SET `minlevel`=50,`maxlevel`=52,`minhealth`=2215,`maxhealth`=2317,`faction_A`=2084,`faction_H`=2084,`mindmg`=50,`maxdmg`=50 WHERE `entry`=28528; -- ghoul
\ No newline at end of file diff --git a/sql/updates/3593_world_spellclick_(dk).sql b/sql/updates/3593_world_spellclick_(dk).sql index 5c31fcf65a3..c0550f03c60 100644 --- a/sql/updates/3593_world_spellclick_(dk).sql +++ b/sql/updates/3593_world_spellclick_(dk).sql @@ -1,5 +1,4 @@ DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN ('29501', '29488'); INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES ('29488', '54568', '12670', '1', '3'), -('29501', '54575', '12670', '1', '3'); - +('29501', '54575', '12670', '1', '3');
\ No newline at end of file diff --git a/sql/updates/3596_world_scripts.sql b/sql/updates/3596_world_scripts.sql index 14eafdb22db..5b1174b1437 100644 --- a/sql/updates/3596_world_scripts.sql +++ b/sql/updates/3596_world_scripts.sql @@ -1 +1 @@ -UPDATE `creature_template` SET `ScriptName`='npc_death_knight_initiate' WHERE `entry`=28406; +UPDATE `creature_template` SET `ScriptName`='npc_death_knight_initiate' WHERE `entry`=28406;
\ No newline at end of file |