TalkAction Simple VIP Commands.

ALTER TABLE `accounts` ADD `premium_points` INT( 11 ) NOT NULL DEFAULT '0';

function getAccountPoints(cid)
    local Info = db.getResult("SELECT `premium_points` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. " LIMIT 1")
        if Info:getID() ~= LUA_ERROR then
        local Points= Info:getDataInt("premium_points")
        Info:free()
        return Points
    end
     return LUA_ERROR
end

function doRemovePoints(cid, points)
    local dif = getAccountPoints(cid) - points
    if dif >= 0 then
        db.executeQuery("UPDATE `accounts` SET `premium_points` = `premium_points` - " .. points .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
        return TRUE
    end
    return FALSE
end

<talkaction words="!buy" script="buy.lua"/>

CONFIG = {
    ["vipscroll"] = {points = 3, itemadd = 7722, countadd = 1},
    ["addonscroll"] = {points = 2, itemadd = 7726, countadd = 1},
    ["expscroll"] = {points = 4, itemadd = 1951, countadd = 1},
    ["mlscroll"] = {points = 4,itemadd= 1953, countadd = 1},
    ["crystalcoin"] = {points = 2, itemadd = 2160, countadd = 100}
}

function onSay(cid, words, param)
   if(param == "") then
		doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Command requires param.")
		return TRUE
	end
    local donor = CONFIG[string.lower(param)]
   if doRemovePoints(cid, donor.points) == TRUE then
        doPlayerAddItem(cid, donor.itemadd, donor.countadd)
        doPlayerSendTextMessage(cid, TALKTYPE_BROADCAST, "Thank You for Donating! Here you got: x" .. donor.countadd .. " " .. getItemNameById(donor.itemadd) .. ", Have Fun!")
        doSendMagicEffect(getPlayerPosition(cid), CONST_ME_BATS) 
    else
        doPlayerSendTextMessage(cid, TALKTYPE_BROADCAST, "You don\'t have enough donor points! Please, visit our site for more information.")
        doSendMagicEffect(getPlayerPosition(cid), CONST_ME_POFF)
   end
        return TRUE
   end

ALTER TABLE `players` ADD `premium_points` INT( 11 ) NOT NULL DEFAULT '0';