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.2.2a | |
| parent | 1f9db80b69379f3abc4b2f8bb5dbc26ec971cc92 (diff) | |
Misc: Whitespace and tabs cleanup
Diffstat (limited to 'sql/old/3.2.2a')
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'); |
