From a7d1394c2e55ef99c9643338b073860a256c565f Mon Sep 17 00:00:00 2001 From: Blipi Date: Thu, 20 Dec 2012 05:39:35 +0100 Subject: 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 --- sql/updates/auth/2014_08_24_00_auth_rbac_ahbot.sql | 40 +++++++++++++++++++++ sql/updates/world/2014_08_24_00_world_ahbot.sql | 42 ++++++++++++++++++++++ 2 files changed, 82 insertions(+) create mode 100644 sql/updates/auth/2014_08_24_00_auth_rbac_ahbot.sql create mode 100644 sql/updates/world/2014_08_24_00_world_ahbot.sql (limited to 'sql') 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.'); -- cgit v1.2.3