Jail for time

[MarxVen]

Hi. On the gamemode mta paradise I would do prison time. I would like to do in the database the "jail" (table: characters).

When the policeman enters a command /jail nickname time value in the database is changed to (for example) 30 (minutes).

Function setTimer every minute changed to the value of the one below (if a player would be in the interior of the prison.). And when was the value to 0 to automatically moved him out of prison.

function jailForTime ( thePlayer ) 
if ( getElementInterior(thePlayer) == 150 and getElementDimension(thePlayer) == 5000) then -- numbers is random 
    exports.sql:query_free( "UPDATE characters SET jail=jail-1 WHERE characterName = " .. getPlayerName( thePlayer ) ) 
end 
     
end 
setTimer ( jailForTime, 60000, 0 ) 

It will help someone to do it? I can throw into prison.

Sorry for bad english.

[Renkon]

#1. Shouldn't you use elementData and then save everything by querying when player disconnects or something?. Everything would be muuuch more easier in that way. And then saving if he disconnects, into the databas.

[MarxVen]

If he disconnect it would still be in jail, and will be based on the last saved data (accuracy = 1 minute).

I could use what you wrote. But the little I know of the lua. I will not do it alone.

[MarxVen]

Someone help me to do this on the mysql?

[Scooby]

another way would be to just save the player/account name to a table of jailed players along with the jail

duration in mins then on reconnect check their name to see if it exists, if it does, rejail them.

then u just have a function looped every 1min decreasing the jailed players mins left and releasing those

who's time is up. this would save the need for mysql and be a lot quicker to make.

of course, if u stop the script, the names are lost, so i guess it depends on what u really need.