Add a punishment lookup command

**videogamesm12** · Nov 5th 2020

I created this suggestion on the ProBoards forum 9 months ago at https://totalfreedom.boards.ne…punishment-lookup-command. Despite how it consisted entirely of vouches, was silently closed and nothing was actually implemented. I have created this suggestion again to ask for this to be implemented.

One could argue that you could just use the HTTPD server to scan through the entire punishment log, but this requires you to direct your attention away from monitoring the server to skim through a large text file. Not only that, the more the file size of the punishments.yml increases, the more slowly and resource intensive the task of skimming through it becomes.

What do you think?

Telesphoreo · Nov 5th 2020

I worked on this but it ended up not being possible due to technical limitations with YAML. Plex will use JSON for this and it should be much easier to implement

elmon · Nov 5th 2020

Vouch.

**lyicx** · Nov 6th 2020

big vouch, you can tell my passion for a suggestion because i've used an adverb and i had a conversation about this the other day

**wild1145** · Nov 6th 2020

I have no idea why we don't already have this? And aren't punishments stored in the TFM DB? So it should just be an SQL query and displaying it in a nice way?

Xen · Nov 6th 2020

Vouch.

@Telesphoreo#468 Has it been agreed upon that Plex will replace TotalFreedomMod?

**videogamesm12** · Nov 6th 2020

@wild1145#517 Punishments are stored in a separate YML file from the SQL DB.

DragonSlayer2189 · Nov 7th 2020

xfiles already made a parser that can then recall selected information from the ban list with python back when i was still doing my ia report, so ill ask if he still has the code for that

zekurt · Nov 7th 2020

vouch also yml is cringe

**wild1145** · Nov 7th 2020

@videogamesm12#519 I'm 99% sure there's a table for it in the db... If we're not using it I really have no idea why...

Telesphoreo · Nov 7th 2020

@wild1145#557 there is not

**wild1145** · Nov 7th 2020

@Telesphoreo#558 What am I think of then because there's 4 tables in the DB??

Also, if we moved to a DB why didn't this move, this feels like a pretty obvious thing to have moved.

**videogamesm12** · Nov 7th 2020

@wild1145#559 I suspect the reason we didn't move it was because when we moved the admin and ban lists to the SQL DB, we didn't implement a way to lookup admins and bans via the HTTPD server. Because the punishment list (at the moment) can only be looked up using the HTTPD server, we didn't move it.

Telesphoreo · Nov 8th 2020

@wild1145#559 there's 3: admins, players, and bans. i don't know as i didn't implement SQL in TFM

**wild1145** · Nov 8th 2020

@videogamesm12#566 Oh that's even worse... Having things in SQL make it easy to query and have on an actual nice looking website. God Damnit. Fine.

But yeah, I still vouch apologies for the slight tangent here to get to the bottom of things.

xfilez · Nov 9th 2020

literally created an account just for this.

So, I actually didn't have access to the database for this a couple of months back, so I literally created a parser which went through the punishment logs and added it all to the database. Then, I have a separate python file which can literally traverse that database and supply useful information. If anyone's interested, let me know. Probably a better idea to contact me over discord.

DragonSlayer2189 · Nov 9th 2020

@xfilez#628 please send me this, thank you

**wild1145** · Nov 14th 2020

Approved.

If it needs some additional work to transform the punishment logs into the DB then so be it, but happy for this to be implemented, at least if we can get it in to a format that we can query we can build on that if we so desire in the future.

**wild1145** · Nov 30th 2020

FS-13 raised to sort this out.

Add a punishment lookup command

wild1145 Jul 17th 2022

wild1145 Jul 17th 2022

Participate now!

Share

Tags

Users Viewing This Thread