Solved ReMaking FlamingVets

[Gertjan300]

Dear Otland Members,

Just wanted to get an old server back. Cleared Lots and lots of errors, And im still remaping lots of things but i need a little bit of help on one error.

Error:

[18/05/2019 21:34:00] Account Manager has logged in.
[18/05/2019 21:34:00] mysql_real_query(): SELECT vipdays FROM accounts WHERE id = 1 LIMIT 1 - MYSQL ERROR: Unknown column 'vipdays' in 'field list' (1054)

[18/05/2019 21:34:00] [Error - CreatureScript Interface]
[18/05/2019 21:34:00] data/creaturescripts/scripts/templeteleport.lua:eek:nLogin
[18/05/2019 21:34:00] Description:
[18/05/2019 21:34:00] data/lib/004-database.lua:60: [Result:getDataInt] Result not set!
[18/05/2019 21:34:00] stack traceback:
[18/05/2019 21:34:00] [C]: in function 'error'
[18/05/2019 21:34:00] data/lib/004-database.lua:60: in function 'getDataInt'
[18/05/2019 21:34:00] data/lib/150-VIP.lua:5: in function 'getPlayerVipDays'
[18/05/2019 21:34:00] data/creaturescripts/scripts/templeteleport.lua:2: in function <data/creaturescripts/scripts/templeteleport.lua:1>
[18/05/2019 21:34:00] mysql_real_query(): SELECT vipdays FROM accounts WHERE id = 1 LIMIT 1 - MYSQL ERROR: Unknown column 'vipdays' in 'field list' (1054)

Templeteleport.lua:

function onLogin(cid)
    if getPlayerVipDays(cid) > 0 then
        setPlayerStorageValue(cid, 20500, 1)
    elseif getPlayerVipDays(cid) == 0 and getPlayerStorageValue(cid, 20500) == 1 then
        doTeleportThing(cid, getPlayerMasterPos(cid))      
        setPlayerStorageValue(cid, 20500, -1)
    end
    return true
end

Kind Regards
Gertjan300

 

[Dantez]

Execute this sql query

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

Found here:

The best VIP system ever! [Action/Movevent/Globalevent]

[TFS 0.3/0.4] The best VIP system ever! [Action/Movevent/Globalevent] Hello. First of all If you're going to post it somewhere else, I dont want you to take credits because its 100% mine. Well I'll explain the system.. Most of the vip system use a globalevent to remove 1 day vip every 24 hours...

otland.net