The command in game is not working, i dont know the reason and i dont see errors but the records in database isnt deleted so something goes wrong, i prefer admin only not everyone should see the report from somone
Did you got any errrors in your console while you use the rdelete command?
update will get released in a few hours so only admins can see the reports 
no thats the point, i dont see errors but i think after server restart, the script forget records in database. so its not deleting old records
wait, did you know the refresh function of HeidiSQL? because it will get deleted, but you can’t see that live. You need to refresh your databank first. Also when you call the reports with /rlist and you tried the rdelete command before, are there any reports that came up?
And if this does not solve your problem, make sure that your database is correctly setted up. this can only be an error with your database. My resource does not delete the reports after restarting the server.
And if it does still not work, you can use the txt function, which you can enable in the config.lua. Than your reports will get saved into the log.txt file in your resource folder.
Scenario:
Somebody does /report
I check report /rlist
I want to delete report /rdelete
All fine!
Somebody does /report
I check report /rlist
Server restart
I check /rlist
I want to delete /rdelete
Reports not deleted
ok couldn’t reproduce that…
some steps that can be done to fix that:
- delete the table: advanced_reportsystem in your database
than execute the sql file in the advanced_reportsystem again.
restart your server after that and retry it. - reinstall the resource: advanced_reportsystem with database included and retry.
if it does still not work, dm me (private message on FiveM message , by clicking on my profile picture)
Update 1.2.0
update includes:
- only admins can see your reports.
- changed the permissions system. this way you don’t need to register a user to the admin group to use the admin commands.
update can be installed from the GitHub page
DONT USE THIS SCRIPT!!!
I had this script installed with 1.2.0 and server lag so many hitch warnings, i try the fix the problem for 8 hours didnt know which script was causing it… today i found the problem it was this scirpt so please fix it, and the problem start after 15/16 players in server
It is impossible that this script causes all these lags.
Of course it will take a little amount of ram of the players PC, but just to write “DONT USE THIS SCRIPT!!!” is absolutely no solution and for sure not the truth.
This script only uses RegisterCommand and calls the sended reports to your database and calls them after using another RegisterCommand back to the client.
It uses no “bad” functions and is not a problem in my scripting knowledge.
If your really having these decent lags than you should think about to change your plattform where you’ve bought a server
Thanks I’m out.
ok hitch warnings are definately a problem with the connection of your server.
(This script uses your databank, which needs to be connected and calls values from it, if this is too much for your server, then I have no more words to say.)
don’t forget that there will be hitch warnings at any time, they wont get away for just deinstalling one resource.
what could fix your problem:
comment out the complete client.lua, since this isn’t even needed in the moment.
or just download the newest version.
Update 1.2.1
Listen, i have more that 160 scripts and i have 12 core cpu 32 gb ram on my server! there was no problem on my server before i did the update of this script and then the hitch warnings started, when i stopped this script the hitch warning was gone… so there is a problem in this script!
aaaand if it is the update as you said
then just comment out the stuff located in client.lua.
otherwise I have no idea why this script should decrease the connection from your server.
I tried 1.2.1, when i start the script the hitch timing started so there is a problem
I will use the first version that one has no problem
yeah do that, but just to say it again, I use the script since I’ve released it and I got no problems with hitch warnings. have a nice day.
do you have full server? the problem start when there is more then 15 people in the server
no, not at all but it doesn’t make any sence to me that it is a different how many people on the server. I mean it does not call something from each player, it has no loops, it doesn’t run in the background if noone uses it… So I have really no idea why this is happening to you. If I got it fixed someday, I will mention you for reporting this. 
anyway have a nice day and thanks for reporting this even if it seems to be not fixable…
Please use elseif and and, there is no point in all of these if conditions here.
right, but I do not think that this can cause the problem. I will update it today.
I wasn’t referring to any ‘problem’, that’s just horrible practice and looks ugly as hell.
yeah sorry… 
If I take down this topic at some day, I am very sorry for all who wants to download it, but everything has his reasons…