diff options
| author | Drahy <none@none> | 2009-07-27 08:06:13 +0200 |
|---|---|---|
| committer | Drahy <none@none> | 2009-07-27 08:06:13 +0200 |
| commit | 67250953ba4e17b6b2e2dbc90448f8607a351387 (patch) | |
| tree | d9a51a8494dcf6cb95749190b787cfc1fcb9eeef /sql/updates | |
| parent | afd5658de56d471f0e364f19ed13cccc84175d39 (diff) | |
* Continuing cleaning sql
* Used trinity sql coding style
* Now complete
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/4542_8191_world_spell_affect.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4544_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4547_world_scripts.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4549_world_script.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4572_script_texts.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4572_world_script.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4577_world_scripts.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4583_world_command.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4594_world_scripts.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4597_world_command.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4598_world_spell_bonus_data.sql | 2 |
11 files changed, 11 insertions, 11 deletions
diff --git a/sql/updates/4542_8191_world_spell_affect.sql b/sql/updates/4542_8191_world_spell_affect.sql index 74e28a00b59..646c9c3dc00 100644 --- a/sql/updates/4542_8191_world_spell_affect.sql +++ b/sql/updates/4542_8191_world_spell_affect.sql @@ -1,3 +1,3 @@ -- ALTER TABLE db_version CHANGE COLUMN required_8190_01_mangos_creature_template required_8191_01_mangos_spell_affect bit; -DROP TABLE IF EXISTS `spell_affect`; +DROP TABLE IF EXISTS `spell_affect`;
\ No newline at end of file diff --git a/sql/updates/4544_world.sql b/sql/updates/4544_world.sql index 90f7e193f15..ab92495e48b 100644 --- a/sql/updates/4544_world.sql +++ b/sql/updates/4544_world.sql @@ -1,3 +1,3 @@ UPDATE `creature_template` SET `ScriptName`='npc_sinkhole_kill_credit' WHERE (`entry`='26248') or (`entry`='26249'); UPDATE `item_template` SET `ScriptName`='item_incendiary_explosives' WHERE (`entry`='35704'); -UPDATE `creature_template` SET `flags_extra`='2' WHERE (`entry`='26250'); +UPDATE `creature_template` SET `flags_extra`='2' WHERE (`entry`='26250');
\ No newline at end of file diff --git a/sql/updates/4547_world_scripts.sql b/sql/updates/4547_world_scripts.sql index 82f682e482e..39be645d833 100644 --- a/sql/updates/4547_world_scripts.sql +++ b/sql/updates/4547_world_scripts.sql @@ -2,4 +2,4 @@ UPDATE `creature_template` SET `ScriptName`='npc_captured_rageclaw' WHERE (`entr UPDATE `creature_template` SET `ScriptName`='npc_drakuru_shackles' WHERE (`entry`='29700'); DELETE FROM `spell_script_target` WHERE `entry` IN (55083,55223,59951,59952); -INSERT INTO `spell_script_target` VALUES (55083, 1, 29700),(55223, 1, 29686),(59951, 1, 29686),(59952, 1, 29686); +INSERT INTO `spell_script_target` VALUES (55083, 1, 29700),(55223, 1, 29686),(59951, 1, 29686),(59952, 1, 29686);
\ No newline at end of file diff --git a/sql/updates/4549_world_script.sql b/sql/updates/4549_world_script.sql index b020a560cec..ba567eb4343 100644 --- a/sql/updates/4549_world_script.sql +++ b/sql/updates/4549_world_script.sql @@ -1,4 +1,4 @@ UPDATE `creature_template` SET `ScriptName`='npc_khunok_the_behemoth' WHERE (`entry`='25862'); -- DB CONTENT -- -UPDATE `quest_template` SET `SrcSpell`='46232' WHERE (`entry`='11878'); +UPDATE `quest_template` SET `SrcSpell`='46232' WHERE (`entry`='11878');
\ No newline at end of file diff --git a/sql/updates/4572_script_texts.sql b/sql/updates/4572_script_texts.sql index d9c4a644c92..e594d05401c 100644 --- a/sql/updates/4572_script_texts.sql +++ b/sql/updates/4572_script_texts.sql @@ -46,4 +46,4 @@ INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content (-1615040,'Unlike, I have many talents.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,14138,1,0,0,'vesperon SAY_VESPERON_SPECIAL_2'), (-1615041,'A Vesperon Disciple appears in the Twilight!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,0,5,0,0,'shadron WHISPER_VESPERON_DICIPLE'), -(-1615042,'%s begins to open a Twilight Portal!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,0,5,0,0,'sartharion drake WHISPER_OPEN_PORTAL'); +(-1615042,'%s begins to open a Twilight Portal!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,0,5,0,0,'sartharion drake WHISPER_OPEN_PORTAL');
\ No newline at end of file diff --git a/sql/updates/4572_world_script.sql b/sql/updates/4572_world_script.sql index f34a407ab17..314d0929de8 100644 --- a/sql/updates/4572_world_script.sql +++ b/sql/updates/4572_world_script.sql @@ -1 +1 @@ -UPDATE instance_template SET script='instance_obsidian_sanctum' WHERE map=615; +UPDATE instance_template SET script='instance_obsidian_sanctum' WHERE map=615;
\ No newline at end of file diff --git a/sql/updates/4577_world_scripts.sql b/sql/updates/4577_world_scripts.sql index 930ebec424a..e73aaea3438 100644 --- a/sql/updates/4577_world_scripts.sql +++ b/sql/updates/4577_world_scripts.sql @@ -7,4 +7,4 @@ UPDATE creature_template SET ScriptName='mob_twilight_whelp' WHERE entry IN (308 UPDATE creature_template SET ScriptName='mob_acolyte_of_shadron' WHERE entry=31218; UPDATE creature_template SET ScriptName='mob_acolyte_of_vesperon' WHERE entry=31219; -UPDATE gameobject_template SET ScriptName='go_resonite_cask' WHERE entry=178145; +UPDATE gameobject_template SET ScriptName='go_resonite_cask' WHERE entry=178145;
\ No newline at end of file diff --git a/sql/updates/4583_world_command.sql b/sql/updates/4583_world_command.sql index 6c5bc49f013..52e3b40eb59 100644 --- a/sql/updates/4583_world_command.sql +++ b/sql/updates/4583_world_command.sql @@ -1 +1 @@ -DELETE FROM `command` WHERE `name` = 'reload spell_affect'; +DELETE FROM `command` WHERE `name` = 'reload spell_affect';
\ No newline at end of file diff --git a/sql/updates/4594_world_scripts.sql b/sql/updates/4594_world_scripts.sql index ebdcb7f761f..ac1056590bb 100644 --- a/sql/updates/4594_world_scripts.sql +++ b/sql/updates/4594_world_scripts.sql @@ -1,3 +1,3 @@ UPDATE `item_template` SET `ScriptName`='item_dart_gun' WHERE `entry`=44222; -UPDATE `creature_template` SET `ScriptName`='npc_kalecgos' WHERE `entry` IN (24844, 24848); +UPDATE `creature_template` SET `ScriptName`='npc_kalecgos' WHERE `entry` IN (24844, 24848);
\ No newline at end of file diff --git a/sql/updates/4597_world_command.sql b/sql/updates/4597_world_command.sql index 374cbb2c632..26096dd3143 100644 --- a/sql/updates/4597_world_command.sql +++ b/sql/updates/4597_world_command.sql @@ -1,4 +1,4 @@ DELETE FROM `command` WHERE `name` IN ('reload creature_linked_respawn', 'npc setlink'); INSERT INTO `command` (`name`,`security`,`help`) VALUES ('reload creature_linked_respawn',2,'Syntax: .reload creature_linked_respawn\r\nReload creature_linked_respawn table.'), -('npc setlink',2,'Syntax: .npc setlink $creatureGUID\r\n\r\nLinks respawn of selected creature to the condition that $creatureGUID defined is alive.'); +('npc setlink',2,'Syntax: .npc setlink $creatureGUID\r\n\r\nLinks respawn of selected creature to the condition that $creatureGUID defined is alive.');
\ No newline at end of file diff --git a/sql/updates/4598_world_spell_bonus_data.sql b/sql/updates/4598_world_spell_bonus_data.sql index 0127e88b5a7..da3da6315a7 100644 --- a/sql/updates/4598_world_spell_bonus_data.sql +++ b/sql/updates/4598_world_spell_bonus_data.sql @@ -1 +1 @@ -DELETE FROM `spell_bonus_data` WHERE `entry` = 53600; +DELETE FROM `spell_bonus_data` WHERE `entry` = 53600;
\ No newline at end of file |