aboutsummaryrefslogtreecommitdiff
path: root/sql/old/3.3.2
diff options
context:
space:
mode:
authorNay <dnpd.dd@gmail.com>2012-11-19 01:00:47 +0000
committerNay <dnpd.dd@gmail.com>2012-11-19 01:00:47 +0000
commit4294ccf95d9da1f3129c7caae30b1394a225d31f (patch)
treec40a81ffaff50a5a4f720ffe958044e47096b1d7 /sql/old/3.3.2
parent1f9db80b69379f3abc4b2f8bb5dbc26ec971cc92 (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.sql2
-rw-r--r--sql/old/3.3.2/07465_world_trinity_string.sql2
-rw-r--r--sql/old/3.3.2/07547_world_vehicle_accessory.sql6
-rw-r--r--sql/old/3.3.2/07604_characters_item_refund_instance.sql32
-rw-r--r--sql/old/3.3.2/07609_world_spell_proc_event.sql2
-rw-r--r--sql/old/3.3.2/07611_characters_item_refund_instance.sql2
-rw-r--r--sql/old/3.3.2/07721_world_script_texts.sql4
-rw-r--r--sql/old/3.3.2/07748_world_scriptname.sql2
-rw-r--r--sql/old/3.3.2/07760_world_spell_group_stack_rules.sql2
-rw-r--r--sql/old/3.3.2/07797_world_scriptname.sql2
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;