use
ALTER TABLE items ADD isIllegal BOOLEAN NOT NULL DEFAULT FALSE
2 Likes
it works , thanks 
1 Like
Hi @Kyominii thank you so much with your help over past few days with the whole ES changes, i was just wondering about jailing command with this script if it is possible to get one?
sorry my bad :3 thank you
Jailing is all I have left before I open my server 
Think it maybe in login.lua
-- Function to update player money every 60 seconds.
local function savePlayerMoney()
SetTimeout(60000, function()
TriggerEvent("es:getPlayers", function(users)
for k,v in pairs(users)do
MySQL:executeQuery("UPDATE users SET `money`='@value' WHERE identifier = '@identifier'",
{['@value'] = v.money, ['@identifier'] = v.identifier})
end
end)
savePlayerMoney()
end)
end
savePlayerMoney()
It’s seems it updates after you log off and sets db to 0?
I’m lua noob so don’t quote me on it just the way it seems to me.
Hi Kyominii, can you share a files just with cfx_serveur, police with modification and sql empty?
i have many error ><’
@Craven456 Soon for jail system
@Malaras try to find the event which is trigger when a user disconnect and remove the setmoney 0
@Galnoc Check OP, there’s all you want
Hello,
I’m facing an strange issue, sometimes the blue circle disapear and I can’t be a policeman anymore, is someone facing this issue too?
Negative , the script flawlessly for me . I hope you’ll fix your problem .
@Kyominii yes but when i didn’t found the sql for essentialmod en freeroam? can you upload your full essentialmod?
@Kyominii Amazing work love it! ive tryed it and it works perfect, i was woundering if it is possible to add a “go back” function “backspace” in the meny for the police like “close” in the diffrent tabs i go in to like citizen and so on. also i would love to see if the Jail system could be hooked cuz the jail rioght now dont work. and also is it possible to add a pic over it? i could help maybe?
something like this but better this is just to show 
Salut les copains, Salut @Kyominii,
J’ai lu pas mal des commentaires, presque tous, et j’ai finalement toujours pas réussi à faire fonctionner ce script.
La commande /copadd ne donne aucun résultats…
- Quand je n’ai pas les permissions, j’ai un message “vous n’avez pas les permissions”.
- J’ai tous les packages requis,
- J’ai une ancienne version d’essentialmode car la 3 est incompatible,
- J’ai deux trois bases en LUA et beaucoup plus en ALGORITHMIQUE,
- J’ai fais la réinstallation 4 fois,
- La base de donnée est niquelle
- La console génère des erreurs à chaque fois que je tape la commande
Pourriez-vous m’aider ? Je suis dispo sur discord/team viewer ou tout simplement à l’écoute.
Hey Boys, Hey @Kyominii,
I have read all the dialogs but still have a problem:
The /copadd command does nothing…
- When I haven’t the permission, I have a message saying “You haven’t the permission to do that”
- I have all required packages
- I have an older version than essentialmode 3.
- That’s the fourth time that I retry the complete installation
- The database is so pretty nice organised
- The console generate some error when typing /copadd
Could you help me? I’m on discord / team viewer or simply at stand.
Thanks You All buddies
Could you help me to make mine work ? :s
Pourrais-tu m’aider afin de faire fonctionner le mien ? :s
We are just waiting on a police drag script, we scripted a jail system in ourselves its nothing great but will do until the great kyominii releases one and will use that.
1 Like
You admin well can you kick or do any other admin command?
Yep chief, I’ve tried
i would recommend you delete it and redo it from the start u have to many errors to know exactly whats wrong with the code dude. you have to many problems in hooking the MYSQL noting is in the database follow the step-by-step install and redo it
I’m gonna try it, thanks dude
Same here…
Meme chose ici.