From a7d1394c2e55ef99c9643338b073860a256c565f Mon Sep 17 00:00:00 2001
From: Blipi <gpascualg93@gmail.com>
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 ++++++++++++++++++++++
 1 file changed, 40 insertions(+)
 create mode 100644 sql/updates/auth/2014_08_24_00_auth_rbac_ahbot.sql

(limited to 'sql/updates/auth')

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);
-- 
cgit v1.2.3