Windows Console & phpmyadmin error help me out fellows

[batte5511]

Just check the pic and you see a nightmare, know how to fix? feel free to try and help me!

 

[president vankk]

@wtf
for me is possible.

@topic

ALTER TABLE `accounts` ADD
`vipdays` int(11) NOT NULL DEFAULT 0;

go to data/lib/function.lua

--- Vip functions by Kekox
function getPlayerVipDays(cid)
    local Info = db.getResult("SELECT `vipdays` FROM `accounts` WHERE `id` = " .. getPlayerAccountId(cid) .. " LIMIT 1")
        if Info:getID() ~= LUA_ERROR then
        local days= Info:getDataInt("vipdays")
        Info:free()
        return days
    end
     return LUA_ERROR
end
 
function doAddVipDays(cid, days)
    db.executeQuery("UPDATE `accounts` SET `vipdays` = `vipdays` + " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end
 
function doRemoveVipDays(cid, days)
    db.executeQuery("UPDATE `accounts` SET `vipdays` = `vipdays` - " .. days .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
end

add this line in data/creaturescript/login.lua

registerCreatureEvent(cid, "VipCheck")

data/creaturescript/scripts create a new file and name it vipcheck.lua

--- Script by Kekox
function onLogin(cid)
         if getPlayerVipDays(cid) >= 1 then
            doPlayerSendTextMessage(cid, 19, "You have ".. getPlayerVipDays(cid) .." vip days left.")
         end
         return true
end

if u have problem:
http://otland.net/f163/best-vip-system-ever-action-movevent-globalevent-71638/

 

[WTF.Error]

create vip_time table too.

 

[president vankk]

ALTER TABLE `accounts` ADD `vip_time` INT( 15 ) NOT NULL