[Release] vrp_punishmentslog

Robbster · May 17, 2019, 9:15pm

Do you run an RP server where you have dish out tens of bans/warnings/kicks a day? Do you use some crappy google sheets! No more, this is the perfect automatic ingame solution for you. It’ll save your staff team so much time.

I originally made this live on stream and some loser decided to copy it line by line so I’ve decided to release it to the public.

How it works: Past warnings,kicks & bans of players are stored and players can see their punishment history. Admins can also see the punishment log of other players.

Instructions on how to install are on the github: FiveM-Scripts/vrp_punishments at master · rubbertoe98/FiveM-Scripts · GitHub

How to use:

F10 to open up the warning sytem
/showwarnings [user_id] to show someone’s punishment log
/warn to give a warning
Kicks & Bans are automatically added to someones punishment log when you ban/kick them through your phone

Screenshot:

(vRP v1)

Dootar · May 17, 2019, 11:21pm

Nice script! I wish it was for VRP 1…

Robbster · May 17, 2019, 11:26pm

It is for vRP “1”

SSgt_Andrews · May 17, 2019, 11:38pm

Any plans to make this a standalone? It looks amazing!

Robbster · May 17, 2019, 11:58pm

Probably not as it needs to be integrated into some banning system but it wouldn’t be hard to convert.

Dootar · May 18, 2019, 12:14am

Looks like VRP V2 since it need “GHMattiMySQL”

github.com

rubbertoe98/FiveM-Scripts/blob/master/vrp_punishments/sv_warningsystem.lua#L52


    end
	CancelEvent()
end)


--print("start:"..dump(testdate).."end")
-- testTime = 1561845600000
-- testTime = testTime / 1000
-- print(os.date('%Y-%m-%d', testTime))
	
function getCMGWarnings(user_id,source) 
	cmgwarningstables = exports['GHMattiMySQL']:QueryResult("SELECT * FROM cmg_warnings WHERE user_id = @uid", {uid = user_id})
	print("Triggering CMG:showWarningsOfUser")
	--print(dump(cmgwarningstables))
	for warningID,warningTable in pairs(cmgwarningstables) do
		--print(warningTable["warning_date"])
		date = warningTable["warning_date"]
		--print("date1:" .. tostring(date))
		newdate = tonumber(date) / 1000
		--print("date3:" .. tostring(newdate))
		newdate = os.date('%Y-%m-%d', newdate)
		--print("date4:" .. tostring(newdate))

Gonna test it…

Robbster · May 18, 2019, 12:21am

Ah, nah its not vRP2, I just use GHMattiMySQL as personal prefrence.

Dootar · May 18, 2019, 12:27am

So for getting it to work with normal vrp_mysql i need to change it?

Robbster · May 18, 2019, 12:31am

If you don’t want to use GHMattiMySQL yes, but there’s no real reason to convert. vrp_mysql sucks

CakeArmy_Max · May 18, 2019, 1:58am

Or just use FAP (fivem admin panel) which uses a web gui.

KreX_69 · May 23, 2019, 9:55pm

Would you make it with mysql-async ?

Robbster · May 23, 2019, 10:10pm

No sorry I don’t like mysql-async, it would not be hard to convert yourself if you wanted mysql-async.

KreX_69 · May 23, 2019, 10:13pm

allright

CsGJoKeR · May 31, 2019, 11:24pm

How would i make this work with the Zaphosting Database? mysql database

hamad_unrealsecurity · July 16, 2019, 6:47pm

how can i solve this any help

Sending heartbeat to live-internal.fivem.net:30110
Error resuming coroutine: citizen:/scripting/lua/scheduler.lua:712: No such export QueryResult in resource GHMattiMySQL
stack traceback:
        [C]: in function 'error'
        citizen:/scripting/lua/scheduler.lua:712: in metamethod '__index'
        @vrp/modules/sv_warningsystem.lua:52: in function 'getCMGWarnings'
        @vrp/modules/sv_warningsystem.lua:74: in upvalue 'handler'
        citizen:/scripting/lua/scheduler.lua:169: in function <citizen:/scripting/lua/scheduler.lua:168>

Robbster · July 16, 2019, 7:06pm

You’ve got to install GHMattiMySQL
https://github.com/GHMatti/FiveM-MySQL

hamad_unrealsecurity · July 16, 2019, 7:17pm

but i have it

Lodberg · July 16, 2019, 7:31pm

You did an amazing work here, I´ve been looking for this ever since starting my server.
I hope in the future it would be possible to make an ESX version aswell, I would deffenetly download it instantly. Keep up the good work mate!

Robbster · July 16, 2019, 8:02pm

@hamad_unrealsecurity Make sure it is started before vRP in server.cfg

hamad_unrealsecurity · July 16, 2019, 8:13pm

okay i will try this thanks <3