Buff Command + SQL

--[[
                         ▒█▀▀▀ █▀▄▀█ █░░█ ▒█▀▀▀█ █▀▀ █▀▀█ ▀█░█▀ █▀▀ █▀▀█
                         ▒█▀▀▀ █░▀░█ █░░█ ░▀▀▀▄▄ █▀▀ █▄▄▀ ░█▄█░ █▀▀ █▄▄▀
                         ▒█▄▄▄ ▀░░░▀ ░▀▀▀ ▒█▄▄▄█ ▀▀▀ ▀░▀▀ ░░▀░░ ▀▀▀ ▀░▀▀

                                  ██████╗ ██████╗ ██████╗ ███████╗
                                 ██╔════╝██╔═══██╗██╔══██╗██╔════╝
                                 ██║     ██║   ██║██████╔╝█████╗
                                 ██║     ██║   ██║██╔══██╗██╔══╝
                                 ╚██████╗╚██████╔╝██║  ██║███████╗
                                  ╚═════╝ ╚═════╝ ╚═╝  ╚═╝╚══════╝

                            EmuServers WoW Creado por Kusanagy Azakura*
 Ejecute el SQL En Auth /  puedes cambiar los ID de los buffos a tu gusto desde la tabla.

 /*
Navicat MySQL Data Transfer
Source Host     : localhost:3306
Source Database : auth
Target Host     : localhost:3306
Target Database : auth
Date: 1/31/2017 2:51:43 AM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for Custom_Buff
-- ----------------------------
DROP TABLE IF EXISTS `Custom_Buff`;
CREATE TABLE `Custom_Buff` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of buff_vip
-- ----------------------------
INSERT INTO `Custom_Buff` VALUES ('1', '15366');
INSERT INTO `Custom_Buff` VALUES ('2', '16609');
INSERT INTO `Custom_Buff` VALUES ('3', '48162');
INSERT INTO `Custom_Buff` VALUES ('4', '48074');
INSERT INTO `Custom_Buff` VALUES ('5', '48170');
INSERT INTO `Custom_Buff` VALUES ('6', '43223');
INSERT INTO `Custom_Buff` VALUES ('7', '36880');
INSERT INTO `Custom_Buff` VALUES ('8', '467');
INSERT INTO `Custom_Buff` VALUES ('9', '69994');
INSERT INTO `Custom_Buff` VALUES ('10', '33081');
INSERT INTO `Custom_Buff` VALUES ('11', '24705');
INSERT INTO `Custom_Buff` VALUES ('12', '26035');
INSERT INTO `Custom_Buff` VALUES ('13', '48469');

--]]

local function BuffOnChat(event, player, msg, _, lang)
    if (msg == "#buff") then  -- Use #buff
        local result = AuthDBQuery("SELECT id,Entry FROM Custom_Buff")
        repeat
        local id = result:GetString(0);
        local Entry = result:GetUInt32(1);
            player:AddAura(Entry, player)
        until not result:NextRow()
    player:SendBroadcastMessage("You have buffed, enjoy!")
    end
end

RegisterPlayerEvent(18, BuffOnChat)