Attempt to Compare Nil with Number

[bmazoka]

.

Edited December 22, 2013 by Guest

[Castillo]

What does "nn" and "bb" return?

[bmazoka]

setElementFrozen(value, false) 
                    mysql:query_free("UPDATE characters SET jail='0' WHERE id = " .. dbid)  
                    mysql:query_free("UPDATE characters SET jailtime=NULL WHERE id = " .. dbid) 
                    outputChatBox("You are no longer in Jail!", value, 0, 255, 0) 

[Castillo]

No, I asked what does "nn" and "bb" return? what values?

[bmazoka]

.

Edited December 22, 2013 by Guest

[Castillo]

Add this to see what these two variables are returning:

outputChatBox ( "nn: ".. tostring ( nn ) ) 
outputChatBox ( "bb: ".. tostring ( bb ) ) 

[bmazoka]

.

Edited December 22, 2013 by Guest

[Castillo]

                local result2 = mysql:query_fetch_assoc( "SELECT `jailtime` FROM `characters` WHERE `id`=" .. mysql:escape_string(dbid) ) 
                local nn = tonumber(result2[1]["jailtime"]) 
                local currenttime = getRealTime() 
                local currenttimereal = ("%04d%02d%02d%02d%02d%02d"):format(currenttime.year+1900, currenttime.month + 1, currenttime.monthday, currenttime.hour,currenttime.minute, currenttime.second) 
                local bb = tonumber(currenttimereal) 
                if (nn) then 
                    setElementFrozen(value, false) 
                    mysql:query_free("UPDATE characters SET jail='0' WHERE id = " .. dbid) 
                    mysql:query_free("UPDATE characters SET jailtime=NULL WHERE id = " .. dbid) 
                    outputChatBox("You are no longer in Jail!", value, 0, 255, 0) 

Try it.

[bmazoka]

.

Edited December 22, 2013 by Guest

[Castillo]

local result2 = mysql:query_fetch_assoc( "SELECT `jailtime` FROM `characters` WHERE `id`=" .. mysql:escape_string(dbid) ) 
               outputChatBox ( "result2: ".. tostring ( result2 ) ) 
               outputChatBox ( "result2 jailtime: ".. tostring ( result2 [ "jailtime" ] ) ) 
                local nn = tonumber(result2["jailtime"]) 
                local currenttime = getRealTime() 
                local currenttimereal = ("%04d%02d%02d%02d%02d%02d"):format(currenttime.year+1900, currenttime.month + 1, currenttime.monthday, currenttime.hour,currenttime.minute, currenttime.second) 
                local bb = tonumber(currenttimereal) 
                if (nn) then 
                    setElementFrozen(value, false) 
                    mysql:query_free("UPDATE characters SET jail='0' WHERE id = " .. dbid) 
                    mysql:query_free("UPDATE characters SET jailtime=NULL WHERE id = " .. dbid) 
                    outputChatBox("You are no longer in Jail!", value, 0, 255, 0) 

Use that and see what it outputs.

[bmazoka]

.

Edited December 22, 2013 by Guest

[Castillo]

Well, there's your problem "2013-12-14 19:03:14" is not a number, is an string, if you use tonumber, it'll return nil.

[bmazoka]

.

Edited December 22, 2013 by Guest

[Castillo]

I guess you could use timestamps to do it.

[bmazoka]

Can you show me how I would do that? Thanks for all the help.

[Castillo]

Does "duration" contain the seconds? or what is the value of it?

[bmazoka]

Duration is done in hours.

It allows for logging while the player is offline

[Castillo]

Are you storing when the player was jailed?

[bmazoka]

It stores when the player will be released, for example /jail [iD of Player] [Number of Hours]

Should log 1 hour later from the current time if I put 1 hour as the "Number of Hours" then the script checks every 5 mins if the time to be released has passed.

At least thats what it is supposed to do..

[bmazoka]

I can show you the entire script if need be. Just let me know

[Castillo]

Use this for writing:

exports.logs:dbLog(thePlayer, 4, targetPlayer, "JAIL " .. duration) 
local r = getRealTime() 
local jailTime = ( r.timestamp + duration * 60 * 60 ) 
mysql:query_free("UPDATE characters SET jailtime='" ..jailTime.. "' WHERE id = " .. dbid) 

And this for loading:

local result2 = mysql:query_fetch_assoc( "SELECT `jailtime` FROM `characters` WHERE `id`=" .. mysql:escape_string(dbid) ) 
local nn = tonumber(result2["jailtime"]) 
local currenttime = getRealTime().timestamp 
local timeLeft = ( currenttime - nn ) 
if ( timeLeft <= 0 ) then 
    setElementFrozen(value, false) 
    mysql:query_free("UPDATE characters SET jail='0' WHERE id = " .. dbid) 
    mysql:query_free("UPDATE characters SET jailtime=NULL WHERE id = " .. dbid) 
    outputChatBox("You are no longer in Jail!", value, 0, 255, 0) 

Lemme know if it works.

[bmazoka]

Attempt to perform arithmetic on local 'nn'

Also the jailtime still comes up

result2: table: 1B85D638

result2 jailtime: 2013-12-15 23:27:05

[Castillo]

You must jail a player with the new writing method, else the data will obviously be the old one.

[bmazoka]

-snip -

Edited December 16, 2013 by Guest

[bmazoka]

Snip

Edited December 16, 2013 by Guest