aboutsummaryrefslogtreecommitdiff
path: root/sql/old/3.2.2a
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.2.2a
parent1f9db80b69379f3abc4b2f8bb5dbc26ec971cc92 (diff)
Misc: Whitespace and tabs cleanup
Diffstat (limited to 'sql/old/3.2.2a')
-rw-r--r--sql/old/3.2.2a/06589_world_battleground_template.sql4
-rw-r--r--sql/old/3.2.2a/06665_world_creature_classlevelstats.sql2
-rw-r--r--sql/old/3.2.2a/06710_world_command.sql2
-rw-r--r--sql/old/3.2.2a/06710_world_trinity_string.sql2
-rw-r--r--sql/old/3.2.2a/06751_world_creature_classlevelstats.sql2
-rw-r--r--sql/old/3.2.2a/06859_world_script_texts.sql2
-rw-r--r--sql/old/3.2.2a/06932_characters_character_aura.sql2
-rw-r--r--sql/old/3.2.2a/06964_world_creature_classlevelstats.sql4
-rw-r--r--sql/old/3.2.2a/07040_world_spell_linked_spell.sql2
9 files changed, 11 insertions, 11 deletions
diff --git a/sql/old/3.2.2a/06589_world_battleground_template.sql b/sql/old/3.2.2a/06589_world_battleground_template.sql
index e636898f200..e0c5e69ec1d 100644
--- a/sql/old/3.2.2a/06589_world_battleground_template.sql
+++ b/sql/old/3.2.2a/06589_world_battleground_template.sql
@@ -1,4 +1,4 @@
-INSERT INTO `battleground_template` ( `id` , `MinPlayersPerTeam` , `MaxPlayersPerTeam` , `MinLvl` , `MaxLvl` , `AllianceStartLoc` , `AllianceStartO` , `HordeStartLoc` , `HordeStartO` )
+INSERT INTO `battleground_template` ( `id` , `MinPlayersPerTeam` , `MaxPlayersPerTeam` , `MinLvl` , `MaxLvl` , `AllianceStartLoc` , `AllianceStartO` , `HordeStartLoc` , `HordeStartO` )
VALUES ( 30, 20, 40, 71, 80, 1485, 0, 1486, 0 ) ;
-INSERT INTO `battleground_template` ( `id` , `MinPlayersPerTeam` , `MaxPlayersPerTeam` , `MinLvl` , `MaxLvl` , `AllianceStartLoc` , `AllianceStartO` , `HordeStartLoc` , `HordeStartO` )
+INSERT INTO `battleground_template` ( `id` , `MinPlayersPerTeam` , `MaxPlayersPerTeam` , `MinLvl` , `MaxLvl` , `AllianceStartLoc` , `AllianceStartO` , `HordeStartLoc` , `HordeStartO` )
VALUES ( 32, 0, 40, 0, 80, 0, 0, 0, 0 ) ;
diff --git a/sql/old/3.2.2a/06665_world_creature_classlevelstats.sql b/sql/old/3.2.2a/06665_world_creature_classlevelstats.sql
index 7d10467a1d4..39645bdbc5e 100644
--- a/sql/old/3.2.2a/06665_world_creature_classlevelstats.sql
+++ b/sql/old/3.2.2a/06665_world_creature_classlevelstats.sql
@@ -148,7 +148,7 @@ INSERT INTO `creature_classlevelstats` (`exp`,`class`,`level`,`basehp`,`basemana
(0,2,20,433,490),
(0,2,21,464,510),
(0,2,22,498,544),
-(0,2,23,533,581),
+(0,2,23,533,581),
(0,2,24,571,618),
(0,2,25,610,655),
(0,2,26,651,693),
diff --git a/sql/old/3.2.2a/06710_world_command.sql b/sql/old/3.2.2a/06710_world_command.sql
index cd489316cc0..40eb82f1146 100644
--- a/sql/old/3.2.2a/06710_world_command.sql
+++ b/sql/old/3.2.2a/06710_world_command.sql
@@ -1,3 +1,3 @@
-UPDATE command
+UPDATE command
SET help = 'Syntax: .account set gmlevel [$account] #level [#realmid]\r\n\r\nSet the security level for targeted player (can\'t be used at self) or for account $name to a level of #level on the realm #realmID.\r\n\r\n#level may range from 0 to 3.\r\n\r\n#reamID may be -1 for all realms.'
WHERE name = 'account set gmlevel';
diff --git a/sql/old/3.2.2a/06710_world_trinity_string.sql b/sql/old/3.2.2a/06710_world_trinity_string.sql
index 6fac607e13b..743c67168e5 100644
--- a/sql/old/3.2.2a/06710_world_trinity_string.sql
+++ b/sql/old/3.2.2a/06710_world_trinity_string.sql
@@ -1,3 +1,3 @@
DELETE FROM `trinity_string` WHERE `entry`=11001;
-INSERT INTO trinity_string (`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`) VALUES
+INSERT INTO trinity_string (`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`) VALUES
(11001, 'You have not chosen -1 or the current realmID that you are on.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
diff --git a/sql/old/3.2.2a/06751_world_creature_classlevelstats.sql b/sql/old/3.2.2a/06751_world_creature_classlevelstats.sql
index 97ec2dcd6c4..dbc53bb019e 100644
--- a/sql/old/3.2.2a/06751_world_creature_classlevelstats.sql
+++ b/sql/old/3.2.2a/06751_world_creature_classlevelstats.sql
@@ -137,7 +137,7 @@ INSERT INTO `creature_classlevelstats` (`exp`,`class`,`level`,`basehp`,`basemana
(0,2,20,433,490),
(0,2,21,464,510),
(0,2,22,498,544),
-(0,2,23,533,581),
+(0,2,23,533,581),
(0,2,24,571,618),
(0,2,25,610,655),
(0,2,26,651,693),
diff --git a/sql/old/3.2.2a/06859_world_script_texts.sql b/sql/old/3.2.2a/06859_world_script_texts.sql
index 2029fb79915..becafab3006 100644
--- a/sql/old/3.2.2a/06859_world_script_texts.sql
+++ b/sql/old/3.2.2a/06859_world_script_texts.sql
@@ -1,5 +1,5 @@
DELETE FROM `script_texts` WHERE `npc_entry` IN (25504, 25589);
-INSERT INTO `script_texts` (`npc_entry`, `entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
+INSERT INTO `script_texts` (`npc_entry`, `entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
(25504, -1750040, 'My father''s aura is quite strong, he cannot be far. Could you be a doll and fight off the monsters wandering throught the mist?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'npc_mootoo_the_younger'),
(25504, -1750041, 'Watch out for the monsters!Which way should we go first? Let''s try this way...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'npc_mootoo_the_younger'),
(25504, -1750042, 'What could this be?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'npc_mootoo_the_younger'),
diff --git a/sql/old/3.2.2a/06932_characters_character_aura.sql b/sql/old/3.2.2a/06932_characters_character_aura.sql
index 0629d89ffa8..74333daaf82 100644
--- a/sql/old/3.2.2a/06932_characters_character_aura.sql
+++ b/sql/old/3.2.2a/06932_characters_character_aura.sql
@@ -1,4 +1,4 @@
-ALTER TABLE `character_aura`
+ALTER TABLE `character_aura`
ADD COLUMN `base_amount0` INT(11) NOT NULL DEFAULT '0' AFTER `amount2`,
ADD COLUMN `base_amount1` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount0`,
ADD COLUMN `base_amount2` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount1`,
diff --git a/sql/old/3.2.2a/06964_world_creature_classlevelstats.sql b/sql/old/3.2.2a/06964_world_creature_classlevelstats.sql
index 328019077e4..18e05926538 100644
--- a/sql/old/3.2.2a/06964_world_creature_classlevelstats.sql
+++ b/sql/old/3.2.2a/06964_world_creature_classlevelstats.sql
@@ -7,8 +7,8 @@ CREATE TABLE `creature_classlevelstats` (
`level` tinyint(1) NOT NULL,
`class` tinyint(1) NOT NULL,
`basehp0` smallint(2) NOT NULL,
- `basehp1` smallint(2) NOT NULL,
- `basehp2` smallint(2) NOT NULL,
+ `basehp1` smallint(2) NOT NULL,
+ `basehp2` smallint(2) NOT NULL,
`basemana` smallint(2) NOT NULL,
`basearmor` smallint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/old/3.2.2a/07040_world_spell_linked_spell.sql b/sql/old/3.2.2a/07040_world_spell_linked_spell.sql
index 1c857f08963..e0ceddd76c2 100644
--- a/sql/old/3.2.2a/07040_world_spell_linked_spell.sql
+++ b/sql/old/3.2.2a/07040_world_spell_linked_spell.sql
@@ -1,4 +1,4 @@
-- cast s66747 (Totem of the Earthen Ring) after completing q14100 or q14111 (Relic of the Earthen Ring)
DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=66744 AND `spell_effect`=66747;
-INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES
+INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES
(66744,66747,0, 'totem of the earthen ring');