Multiple errors in tfs 0.3.6 console

[Jabbawock]

So I downloaded a data pack that should be using tfs 0.3.6 and I changed the temple position to its correct one. And now I have this error in my console



[Error - CreatureScript Interface]
data/creaturescripts/scripts/vipcheck.lua:OnLogin

Description: data/lib/004-database.lua:60: [Result: [getDataInt] Result not set!
Stack traceback:
[C]: In function 'error'
data/lib/004-database.lua:60: in function 'getDataInt'
data/lib/050-function.lua:724: in function 'getPlayerVipDays'
data/creaturescripts/scripts/vipcheck.lua:3: in function <data/creaturescripts/scripts/vipcheck.lua:2>

I dont know much but im guessing something is wrong in my lib folder... and creature scripts

ALSO I cant log in on account manager it loads the character list but never logs on. then when i abort it says account manager has been logged out.

I have little knowledge on these types of errors so If you can help me I might be willing to pay somehow, I really just want to log on and check the
server out.

Few more errors like this one aswell

mysql_real_query<>: SELECT * FROM z_ots_communication WHERE 'type' = 'Login'; - MYSQL ERROR: Table 'tfs.z_ots_communication; doesn't exist
<1146>

mysql_real_query<>: SELECT * FROM 'Vipdays' From 'accounts' WHERE 'id' = 1 LIMIT 1 MYSQL ERROR: Unknown column 'Vipdays' in 'field list' <1054>

Much respect to anyone who will actually help me solve this.

 

[miquelito97]

Yes, because you are wrong in vip system, u need to put a good script.

 

[miquelito97]

give me your vip system

 

[Sweddy]

Do this in phpmyadmin

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

Add this lines in functions.lua at the top

--- 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

in login.lua

registerCreatureEvent(cid, "VipCheck")

ALSO I cant log in on account manager it loads the character list but never logs on. then when i abort it says account manager has been logged out.

Open ports 7171,7172 and 80

 

[Ns Sparkz]

I need Help !!! Someoen Help me plz Am Opening My Server,And i got a Website But How Could i edit It and How could i connect it To my Ot plz Help!!

 

[Sweddy]

Look in Tutorials Section in "Basic"

 

[Jabbawock]

Ok i will try your method sweddy

 

[Jabbawock]

I keep getting errors now a new one... ALOT

[Error - GlobalEvent Interface] 
[25/08/2011 14:39:17] data/globalevents/scripts/vipEffect.lua:onThink
[25/08/2011 14:39:17] Description: 
[25/08/2011 14:39:17] data/globalevents/scripts/vipEffect.lua:2: attempt to call global 'getOnlinePlayers' (a nil value)
[25/08/2011 14:39:17] stack traceback:
[25/08/2011 14:39:17] 	data/globalevents/scripts/vipEffect.lua:2: in function <data/globalevents/scripts/vipEffect.lua:1>
[25/08/2011 14:39:17] [Error - GlobalEvents::think] Couldn't execute event: vipEffect

I also get action error interace, global event interface and many more errors

 

[Jabbawock]

Ok Close this thread this has been solved

 

[Sweddy]

How did you solve it?, did you replace the function.lua file?