Core/AHBot: Implemented AHBot based on MaNGOS code

Warning: CMake must be rerun

Apply if you have crashes

Rewrite Seller prices, add random properties and implement some suggestions on price calculations

Core/AHBot: Update to latest suggestions

Fix SQLs after merge, split the AH bot to spearate headers and cpps, fix the config default values

Remove case 8 from GetBuyModifier. It was not correct

Fix Gray Grey GRAY typos

Change message config name

Fix non pch build

Fix switch ident, also earlier removed whitespace. Add missing include for non pch build

Fix possible crash: if (forplayer || GetOwnerGUID()) changed to if (forplayer)

Apply Nayd.diff - Code style fixes

Fix leftovers from nayd

Correct SQL transaction and change one SQL query to C++ instead

Make loot items distinct

2 files changed, 82 insertions, 0 deletions

diff --git a/sql/updates/auth/2014_08_24_00_auth_rbac_ahbot.sql b/sql/updates/auth/2014_08_24_00_auth_rbac_ahbot.sql
new file mode 100644
index 00000000000..7de587dc19f
--- /dev/null
+++ b/sql/updates/auth/2014_08_24_00_auth_rbac_ahbot.sql
@@ -0,0 +1,40 @@
+SET @id = 778;
+
+-- Add new permissions
+DELETE FROM `rbac_permissions` WHERE `id` BETWEEN @id AND @id+15;
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(@id,    'Command: ahbot'),
+(@id+1,  'Command: ahbot items'),
+(@id+2,  'Command: ahbot items gray'),
+(@id+3,  'Command: ahbot items white'),
+(@id+4,  'Command: ahbot items green'),
+(@id+5,  'Command: ahbot items blue'),
+(@id+6,  'Command: ahbot items purple'),
+(@id+7,  'Command: ahbot items orange'),
+(@id+8,  'Command: ahbot items yellow'),
+(@id+9,  'Command: ahbot ratio'),
+(@id+10, 'Command: ahbot ratio alliance'),
+(@id+11, 'Command: ahbot ratio horde'),
+(@id+12, 'Command: ahbot ratio neutral'),
+(@id+13, 'Command: ahbot rebuild'),
+(@id+14, 'Command: ahbot reload'),
+(@id+15, 'Command: ahbot status');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId` BETWEEN @id AND @id+15;
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
+(192, @id),
+(192, @id+1),
+(192, @id+2),
+(192, @id+3),
+(192, @id+4),
+(192, @id+5),
+(192, @id+6),
+(192, @id+7),
+(192, @id+8),
+(192, @id+9),
+(192, @id+10),
+(192, @id+11),
+(192, @id+12),
+(192, @id+13),
+(192, @id+14),
+(192, @id+15);
diff --git a/sql/updates/world/2014_08_24_00_world_ahbot.sql b/sql/updates/world/2014_08_24_00_world_ahbot.sql
new file mode 100644
index 00000000000..9a5eab9f393
--- /dev/null
+++ b/sql/updates/world/2014_08_24_00_world_ahbot.sql
@@ -0,0 +1,42 @@
+SET @id = 778;
+
+DELETE FROM `command` WHERE `name` LIKE 'ahbot%';
+INSERT INTO `command` (`name`, `permission`, `help`) VALUES
+('ahbot items',          @id+1,  'Syntax: .ahbot items $GrayItems $WhiteItems $GreenItems $BlueItems $PurpleItems $OrangeItems $YellowItems\r\n\r\nSet amount of each items color be selled on auction.'),
+('ahbot items gray',     @id+2,  'Syntax: .ahbot items gray $GrayItems\r\n\r\nSet amount of Gray color items be selled on auction.'),
+('ahbot items white',    @id+3,  'Syntax: .ahbot items white $WhiteItems\r\n\r\nSet amount of White color items be selled on auction.'),
+('ahbot items green',    @id+4,  'Syntax: .ahbot items green $GreenItems\r\n\r\nSet amount of Green color items be selled on auction.'),
+('ahbot items blue',     @id+5,  'Syntax: .ahbot items blue $BlueItems\r\n\r\nSet amount of Blue color items be selled on auction.'),
+('ahbot items purple',   @id+6,  'Syntax: .ahbot items purple $PurpleItems\r\n\r\nSet amount of Purple color items be selled on auction.'),
+('ahbot items orange',   @id+7,  'Syntax: .ahbot items orange $OrangeItems\r\n\r\nSet amount of Orange color items be selled on auction.'),
+('ahbot items yellow',   @id+8,  'Syntax: .ahbot items yellow $YellowItems\r\n\r\nSet amount of Yellow color items be selled on auction.'),
+('ahbot ratio',          @id+9,  'Syntax: .ahbot ratio $allianceratio $horderatio $neutralratio\r\n\r\nSet ratio of items in 3 auctions house.'),
+('ahbot ratio alliance', @id+10, 'Syntax: .ahbot ratio alliance $allianceratio\r\n\r\nSet ratio of items in alliance auction house.'),
+('ahbot ratio horde',    @id+11, 'Syntax: .ahbot ratio horde $horderatio\r\n\r\nSet ratio of items in horde auction house.'),
+('ahbot ratio neutral',  @id+12, 'Syntax: .ahbot ratio neutral $neutralratio\r\n\r\nSet ratio of items in $neutral auction house.'),
+('ahbot rebuild',        @id+13, 'Syntax: .ahbot rebuild [all]\r\n\r\nExpire all actual auction of ahbot except bided by player. Binded auctions included to expire if "all" option used. Ahbot re-fill auctions base at current settings then.'),
+('ahbot reload',         @id+14, 'Syntax: .ahbot reload\r\n\r\nReload AHBot settings from configuration file.'),
+('ahbot status',         @id+15, 'Syntax: .ahbot status [all]\r\n\r\nShow current ahbot state data in short form, and with "all" with details.');
+
+DELETE FROM `trinity_string` WHERE `entry` BETWEEN 1157 AND 1176;
+INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES
+(1157, 'All config are reloaded from configuration file.'),
+(1158, '=========================================================='),
+(1159, '|--------------------------------------------------------|'),
+(1160, '|            | Alliance |  Horde   | Neutral  |  Total   |'),
+(1161, '          Alliance/Horde/Neutral/Total'),
+(1162, '| %-10s | %8u | %8u | %8u | %8u |'),
+(1163, '%-10s = %6u / %6u / %6u / %6u'),
+(1164, 'Count'),
+(1165, 'Item Ratio'),
+(1166, '|            | Alliance |   Horde  | Neutral  |  Amount  |'),
+(1167, '          Alliance/Horde/Neutral/Amount'),
+(1168, 'Gray'),
+(1169, 'White'),
+(1170, 'Green'),
+(1171, 'Blue'),
+(1172, 'Purple'),
+(1173, 'Orange'),
+(1174, 'Yellow'),
+(1175, 'Amount of %s items is set to %u.'),
+(1176, 'Items ratio for %s is set to %u.');