From dcd0b835aacde9197f9c71aea772927f23895212 Mon Sep 17 00:00:00 2001 From: Drahy Date: Sun, 5 Apr 2009 16:18:32 +0200 Subject: * Fixed typos in latest commit --HG-- branch : trunk --- sql/updates/2339_world.sql | 2 +- sql/updates/2343_world.sql | 2 +- sql/updates/2346_world.sql | 2 +- sql/updates/2412_characters.sql | 2 +- sql/updates/2412_world.sql | 2 ++ sql/updates/2412_world.sql.txt | 2 -- 6 files changed, 6 insertions(+), 6 deletions(-) create mode 100644 sql/updates/2412_world.sql delete mode 100644 sql/updates/2412_world.sql.txt (limited to 'sql') diff --git a/sql/updates/2339_world.sql b/sql/updates/2339_world.sql index 106de7326fb..4b7f08394c2 100644 --- a/sql/updates/2339_world.sql +++ b/sql/updates/2339_world.sql @@ -13,4 +13,4 @@ INSERT INTO `command`(`name`,`security`,`help`) VALUES ('ahbotoption maxstack', '3', '.Syntax: .ahbotoption maxstack $ahMapID $color $value Set maximum stacks for single item in auction. if set to 0 then item_template.stackable value will be considered $color: grey, white, green, blue, purple, orange, yellow.'), ('ahbotoption buyerprice', '3', '.Syntax: .ahbotoption buyerprice $ahMapID $color $value Set rate for which Ahbot will be allowed to buy an item. 1=item_template.sellprice, 2=2*item_template.sellprice... $color: grey, white, green, blue, purple, orange, yellow.'), ('ahbotoption bidinterval', '3', '.Syntax: .ahbotoption bidinterval $ahMapID $parameter Set number of minutes between bids'), -('ahbotoption bidsperinterval', '3', '.Syntax: .ahbotoption bidsperinterval $ahMapID $parameter Set number of bids to be made per cycle.'); +('ahbotoption bidsperinterval', '3', '.Syntax: .ahbotoption bidsperinterval $ahMapID $parameter Set number of bids to be made per cycle.'); \ No newline at end of file diff --git a/sql/updates/2343_world.sql b/sql/updates/2343_world.sql index 4b2b5e68953..091ceb847e0 100644 --- a/sql/updates/2343_world.sql +++ b/sql/updates/2343_world.sql @@ -14,4 +14,4 @@ INSERT INTO `command`(`name`,`security`,`help`) VALUES ('ahbotoptions maxstack', '3', '.Syntax: .ahbotoptions maxstack $ahMapID $color $value Set maximum stacks for single item in auction. if set to 0 then item_template.stackable value will be considered $color: grey, white, green, blue, purple, orange, yellow.'), ('ahbotoptions buyerprice', '3', '.Syntax: .ahbotoptions buyerprice $ahMapID $color $value Set rate for which Ahbot will be allowed to buy an item. 1=item_template.sellprice, 2=2*item_template.sellprice... $color: grey, white, green, blue, purple, orange, yellow.'), ('ahbotoptions bidinterval', '3', '.Syntax: .ahbotoptions bidinterval $ahMapID $parameter Set number of minutes between bids'), -('ahbotoptions bidsperinterval', '3', '.Syntax: .ahbotoptions bidsperinterval $ahMapID $parameter Set number of bids to be made per cycle.'); +('ahbotoptions bidsperinterval', '3', '.Syntax: .ahbotoptions bidsperinterval $ahMapID $parameter Set number of bids to be made per cycle.'); \ No newline at end of file diff --git a/sql/updates/2346_world.sql b/sql/updates/2346_world.sql index f3cb07b6604..9bbe8d96d9a 100644 --- a/sql/updates/2346_world.sql +++ b/sql/updates/2346_world.sql @@ -1,2 +1,2 @@ DELETE FROM `command` WHERE `name` LIKE "ahbotoption %"; -DELETE FROM `command` WHERE `name` LIKE "ahbotoptions %"; +DELETE FROM `command` WHERE `name` LIKE "ahbotoptions %"; \ No newline at end of file diff --git a/sql/updates/2412_characters.sql b/sql/updates/2412_characters.sql index 22b5a751e71..e1f44c58ae3 100644 --- a/sql/updates/2412_characters.sql +++ b/sql/updates/2412_characters.sql @@ -6,5 +6,5 @@ DELETE FROM `character_aura` WHERE 'effect_index'>'1'; DELETE FROM `pet_aura` WHERE 'effect_index'>'1'; ALTER TABLE `pet_aura` CHANGE `effect_index` `effect_mask` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE `pet_aura` CHANGE `amount` `amount0` INT( 11 ) NOT NULL DEFAULT '0'; - ALTER TABLE 'pet_aura` ADD `amount1` INT( 11 ) NOT NULL DEFAULT '0' AFTER `amount0`; + ALTER TABLE `pet_aura` ADD `amount1` INT( 11 ) NOT NULL DEFAULT '0' AFTER `amount0`; ALTER TABLE `pet_aura` ADD `amount2` INT( 11 ) NOT NULL DEFAULT '0' AFTER `amount1`; \ No newline at end of file diff --git a/sql/updates/2412_world.sql b/sql/updates/2412_world.sql new file mode 100644 index 00000000000..c31c22b3d72 --- /dev/null +++ b/sql/updates/2412_world.sql @@ -0,0 +1,2 @@ +UPDATE `trinity_string` SET `content_default` = 'id: %d effmask: %d charges: %d stack: %d slot %d duration: %d maxduration: %d' WHERE `entry` =468; +UPDATE `trinity_string` SET `content_default` = 'id: %d eff: %d amount: %d' WHERE `trinity_string`.`entry` =470; \ No newline at end of file diff --git a/sql/updates/2412_world.sql.txt b/sql/updates/2412_world.sql.txt deleted file mode 100644 index c31c22b3d72..00000000000 --- a/sql/updates/2412_world.sql.txt +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `trinity_string` SET `content_default` = 'id: %d effmask: %d charges: %d stack: %d slot %d duration: %d maxduration: %d' WHERE `entry` =468; -UPDATE `trinity_string` SET `content_default` = 'id: %d eff: %d amount: %d' WHERE `trinity_string`.`entry` =470; \ No newline at end of file -- cgit v1.2.3