Lua Player Check error

[luhfe]

Good evening, how do I search the database to return a column value !?
Example:
I want to check if the value of the VipC column (located in Accounts) of the player that is logging (Onlogin) is at 4, and then modifies it to 6.

 

[samco]

Select vipc from accounts where id = loggedinaccountid

Throug lua you can get player:getAccount or similar...

 

[luhfe]

Even return a nil valor... im on it like 5hours ago x.x

 

[samco]

Would you mind to post your engine and your code?

 

[luhfe]

Creaturescript i want make a check system to a 3 days vip free... becouse i try every1 in forums and dont work to me so i think in
some like that

Function OnLogin(player)

If player:(field in database  - players.onlinetime) < 1 and player:(field in database - accounts.VipC) ~=1 then
player:addVipdays(days)
player: CHANGE(field in database - accounts.VipC) to 1 -- (thats i'll use to check in next login to do not dup bonus days)
player: MSG informative
else
player:msg informative
end

=\