diff options
| author | Nay <dnpd.dd@gmail.com> | 2012-11-19 01:00:47 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2012-11-19 01:00:47 +0000 |
| commit | 4294ccf95d9da1f3129c7caae30b1394a225d31f (patch) | |
| tree | c40a81ffaff50a5a4f720ffe958044e47096b1d7 /sql/old/3.3.2 | |
| parent | 1f9db80b69379f3abc4b2f8bb5dbc26ec971cc92 (diff) | |
Misc: Whitespace and tabs cleanup
Diffstat (limited to 'sql/old/3.3.2')
| -rw-r--r-- | sql/old/3.3.2/07394_world_spell_bonus_data.sql | 2 | ||||
| -rw-r--r-- | sql/old/3.3.2/07465_world_trinity_string.sql | 2 | ||||
| -rw-r--r-- | sql/old/3.3.2/07547_world_vehicle_accessory.sql | 6 | ||||
| -rw-r--r-- | sql/old/3.3.2/07604_characters_item_refund_instance.sql | 32 | ||||
| -rw-r--r-- | sql/old/3.3.2/07609_world_spell_proc_event.sql | 2 | ||||
| -rw-r--r-- | sql/old/3.3.2/07611_characters_item_refund_instance.sql | 2 | ||||
| -rw-r--r-- | sql/old/3.3.2/07721_world_script_texts.sql | 4 | ||||
| -rw-r--r-- | sql/old/3.3.2/07748_world_scriptname.sql | 2 | ||||
| -rw-r--r-- | sql/old/3.3.2/07760_world_spell_group_stack_rules.sql | 2 | ||||
| -rw-r--r-- | sql/old/3.3.2/07797_world_scriptname.sql | 2 |
10 files changed, 28 insertions, 28 deletions
diff --git a/sql/old/3.3.2/07394_world_spell_bonus_data.sql b/sql/old/3.3.2/07394_world_spell_bonus_data.sql index a6f7717201c..9d5cc434d6c 100644 --- a/sql/old/3.3.2/07394_world_spell_bonus_data.sql +++ b/sql/old/3.3.2/07394_world_spell_bonus_data.sql @@ -1,6 +1,6 @@ -- Some spell bonus data mostly for DK spells and trinket spells DELETE FROM `spell_bonus_data` WHERE `entry` IN (63544,54181,55078,55095,50536,52212,51460,48721,45477,54757,45055,60203,60488,45429); -INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES +INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES (63544, 0, -1, -1, -1, 'Priest - Empowered Renew'), (54181, 0, -1, -1, -1, 'Warlock - Fel Synergy'), (55078, 0, 0, -1, 0.06325, 'Death Knight - Blood Plague'), diff --git a/sql/old/3.3.2/07465_world_trinity_string.sql b/sql/old/3.3.2/07465_world_trinity_string.sql index 10ff8de31e7..3e7cb423144 100644 --- a/sql/old/3.3.2/07465_world_trinity_string.sql +++ b/sql/old/3.3.2/07465_world_trinity_string.sql @@ -1,5 +1,5 @@ DELETE FROM `trinity_string` WHERE `entry` IN (5024,5025,5026,5027); -INSERT INTO trinity_string (`entry`, `content_default`) VALUES +INSERT INTO trinity_string (`entry`, `content_default`) VALUES (5024, 'Entry: %u'), (5025, 'Type: %u'), (5026, 'DisplayID: %u'), diff --git a/sql/old/3.3.2/07547_world_vehicle_accessory.sql b/sql/old/3.3.2/07547_world_vehicle_accessory.sql index e929114ed0f..1137d2827aa 100644 --- a/sql/old/3.3.2/07547_world_vehicle_accessory.sql +++ b/sql/old/3.3.2/07547_world_vehicle_accessory.sql @@ -25,9 +25,9 @@ INSERT INTO `vehicle_accessory` (`entry`,`accessory_entry`,`seat_id`,`minion`,`d (33113,33114,2,1, 'Flame Leviathan'), (33113,33114,3,1, 'Flame Leviathan'), (33113,33139,7,1, 'Flame Leviathan'), -(33114,33142,1,1, 'Overload Control Device'), -(33114,33143,2,1, 'Leviathan Defense Turret'), -(33214,33218,1,1, 'Mechanolift 304-A'), +(33114,33142,1,1, 'Overload Control Device'), +(33114,33143,2,1, 'Leviathan Defense Turret'), +(33214,33218,1,1, 'Mechanolift 304-A'), (35637,34705,0,0, 'Marshal Jacob Alerius'' Mount'), (35633,34702,0,0, 'Ambrose Boltspark''s Mount'), (35768,34701,0,0, 'Colosos'' Mount'), diff --git a/sql/old/3.3.2/07604_characters_item_refund_instance.sql b/sql/old/3.3.2/07604_characters_item_refund_instance.sql index 810d2fa98b4..1b89c17f2e5 100644 --- a/sql/old/3.3.2/07604_characters_item_refund_instance.sql +++ b/sql/old/3.3.2/07604_characters_item_refund_instance.sql @@ -1,19 +1,19 @@ DROP TABLE IF EXISTS `item_refund_instance`; -CREATE TABLE `item_refund_instance` ( -`item_guid` int(11) unsigned NOT NULL COMMENT 'Item GUID', +CREATE TABLE `item_refund_instance` ( +`item_guid` int(11) unsigned NOT NULL COMMENT 'Item GUID', `player_guid` int(11) unsigned NOT NULL COMMENT 'Player GUID', -`paidMoney` int(11) unsigned NOT NULL DEFAULT '0', -`paidHonor` int(11) unsigned NOT NULL DEFAULT '0', -`paidArena` int(11) unsigned NOT NULL DEFAULT '0', -`paidItem_1` mediumint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'item_template.entry', -`paidItemCount_1` mediumint(6) unsigned NOT NULL DEFAULT '0', -`paidItem_2` mediumint(6) unsigned NOT NULL DEFAULT '0', -`paidItemCount_2` mediumint(6) unsigned NOT NULL DEFAULT '0', -`paidItem_3` mediumint(6) unsigned NOT NULL DEFAULT '0', -`paidItemCount_3` mediumint(6) unsigned NOT NULL DEFAULT '0', -`paidItem_4` mediumint(6) unsigned NOT NULL DEFAULT '0', -`paidItemCount_4` mediumint(6) unsigned NOT NULL DEFAULT '0', -`paidItem_5` mediumint(6) unsigned NOT NULL DEFAULT '0', -`paidItemCount_5` mediumint(6) unsigned NOT NULL DEFAULT '0', -PRIMARY KEY (`item_guid`, `player_guid`) +`paidMoney` int(11) unsigned NOT NULL DEFAULT '0', +`paidHonor` int(11) unsigned NOT NULL DEFAULT '0', +`paidArena` int(11) unsigned NOT NULL DEFAULT '0', +`paidItem_1` mediumint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'item_template.entry', +`paidItemCount_1` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItem_2` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItemCount_2` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItem_3` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItemCount_3` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItem_4` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItemCount_4` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItem_5` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItemCount_5` mediumint(6) unsigned NOT NULL DEFAULT '0', +PRIMARY KEY (`item_guid`, `player_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/sql/old/3.3.2/07609_world_spell_proc_event.sql b/sql/old/3.3.2/07609_world_spell_proc_event.sql index 2111d9b3f85..78e5377996d 100644 --- a/sql/old/3.3.2/07609_world_spell_proc_event.sql +++ b/sql/old/3.3.2/07609_world_spell_proc_event.sql @@ -1,4 +1,4 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (42370); INSERT INTO `spell_proc_event` -(`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) +(`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES ( 42370, 0x00, 11, 0x00000080, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Merciless Totem of the Third Wind diff --git a/sql/old/3.3.2/07611_characters_item_refund_instance.sql b/sql/old/3.3.2/07611_characters_item_refund_instance.sql index cd859a47ee0..86e397946ef 100644 --- a/sql/old/3.3.2/07611_characters_item_refund_instance.sql +++ b/sql/old/3.3.2/07611_characters_item_refund_instance.sql @@ -3,7 +3,7 @@ DROP COLUMN `paidHonor`, DROP COLUMN `paidArena`, DROP COLUMN `paidItem_1`, DROP COLUMN `paidItemCount_1`, -DROP COLUMN `paidItem_2`, +DROP COLUMN `paidItem_2`, DROP COLUMN `paidItemCount_2`, DROP COLUMN `paidItem_3`, DROP COLUMN `paidItemCount_3`, diff --git a/sql/old/3.3.2/07721_world_script_texts.sql b/sql/old/3.3.2/07721_world_script_texts.sql index 5b349bbb14f..ba3bdfc99c9 100644 --- a/sql/old/3.3.2/07721_world_script_texts.sql +++ b/sql/old/3.3.2/07721_world_script_texts.sql @@ -35,7 +35,7 @@ INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1` (26529,-1595029,'Get up! Me not done!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13432,1,0,0,'meathook SAY_SLAY_3'), (26529,-1595030,'New toys!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13429,1,0,0,'meathook SAY_SPAWN'), (26529,-1595031,'This... not fun...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13433,1,0,0,'meathook SAY_DEATH'), --- Salramm the Fleshcrafter +-- Salramm the Fleshcrafter (26530,-1595032,'Ah, the entertainment has arrived!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13472,1,0,0,'salramm SAY_AGGRO'), (26530,-1595033,'You are too late, champion of Lordaeron. The dead shall have their day.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13471,1,0,0,'salramm SAY_SPAWN'), (26530,-1595034,'The fun is just beginning!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13473,1,0,0,'salramm SAY_SLAY_1'), @@ -49,7 +49,7 @@ INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1` (26530,-1595042,'Your flesh betrays you.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13482,1,0,0,'salramm SAY_STEAL_FLESH_3'), (26530,-1595043,'Say hello to some friends of mine.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13476,1,0,0,'salramm SAY_SUMMON_GHOULS_1'), (26530,-1595044,'Come, citizen of Stratholme! Meet your saviors.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13477,1,0,0,'salramm SAY_SUMMON_GHOULS_2'), --- The Infinite Corruptor +-- The Infinite Corruptor -- Couldn't find the value from the audios for `sound` column, not added. (32273,-1595045,'How dare you interfere with our work here!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'infinite SAY_AGGRO'), (32273,-1595046,'My work here is finished!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'infinite SAY_FAIL'), diff --git a/sql/old/3.3.2/07748_world_scriptname.sql b/sql/old/3.3.2/07748_world_scriptname.sql index 55649c12668..4a7110cc24c 100644 --- a/sql/old/3.3.2/07748_world_scriptname.sql +++ b/sql/old/3.3.2/07748_world_scriptname.sql @@ -1,5 +1,5 @@ DELETE FROM `areatrigger_scripts` WHERE `entry` IN (5284,5285,5286,5287,4871,4872,4873,5108); -INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES +INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES (5284, 'at_aldurthar_gate'), (5285, 'at_aldurthar_gate'), (5286, 'at_aldurthar_gate'), diff --git a/sql/old/3.3.2/07760_world_spell_group_stack_rules.sql b/sql/old/3.3.2/07760_world_spell_group_stack_rules.sql index d5c38078e81..3ee3d5a4b4f 100644 --- a/sql/old/3.3.2/07760_world_spell_group_stack_rules.sql +++ b/sql/old/3.3.2/07760_world_spell_group_stack_rules.sql @@ -1,5 +1,5 @@ DELETE FROM `spell_group_stack_rules` WHERE `group_id` IN (1015,1016,1019,1022,1025,1029,1033,1036,1043,1048,1051,1054,1057,1059,1064,1068,1074,1079,1082,1085,1088,1090,1093,1096,1099,1103,1046); -INSERT INTO `spell_group_stack_rules` (`group_id`,`stack_rule`) VALUES +INSERT INTO `spell_group_stack_rules` (`group_id`,`stack_rule`) VALUES (1015,1), (1016,1), (1019,1), diff --git a/sql/old/3.3.2/07797_world_scriptname.sql b/sql/old/3.3.2/07797_world_scriptname.sql index a68aaa4f164..3c58563bc5d 100644 --- a/sql/old/3.3.2/07797_world_scriptname.sql +++ b/sql/old/3.3.2/07797_world_scriptname.sql @@ -1,3 +1,3 @@ -UPDATE `instance_template` SET `script`='instance_blackrock_spire' WHERE `map`=229; +UPDATE `instance_template` SET `script`='instance_blackrock_spire' WHERE `map`=229; UPDATE `creature_template` SET `ScriptName`='npc_rookey_whelp' WHERE `entry`=10161; UPDATE `gameobject_template` SET `ScriptName`='go_rookey_egg' WHERE `entry`=175124; |
