[ANY] Clientprefs Cleaner (Cookies Purge)
 

I believe it was requested for several times, so I decided to realize that for everyone because I am also interested in that.

This is simple as its called - plugin purges clientprefs database by removing player 'cookies', which has not been updated for long time.
It also refreshes cookies timestamp every time player connects, so cookies will not be removed accidentally (at least after once it purged).

There's only one ConVar: sm_cookies_removedays - Removes cookies which hasn't been updated for X days.
By default it removes cookies after 30 days of player inactivity.

Also don't forget to save current clientprefs database if you really care about cookies. :)

Servers with this plugin

Download plugin
Browse source code

Re: [ANY] Clientprefs Cleaner (Cookies Purge)
 

Purge Everything!

This is gonna be userful stuff
- Thanks

Re: [ANY] Clientprefs Cleaner (Cookies Purge)
 

Thank god. I fucked up my clientprefs file trying to wipe it with Notepad++. Had to replace it with a fresh copy. This will be very useful to me in the future.

Re: [ANY] Clientprefs Cleaner (Cookies Purge)
 

Is there a real advantage to cleaning them out?

Re: [ANY] Clientprefs Cleaner (Cookies Purge)
 

...not exactly. Depens plugins, what use clientprefs to store players settings (or else information).

Re: [ANY] Clientprefs Cleaner (Cookies Purge)
 

If you maintain your mysql database... Souldnt ever need to clean it.
Sqlite.. Okay mabye?

Re: [ANY] Clientprefs Cleaner (Cookies Purge)
 

Doesn't seem to do anything. Its running but it didn't change the size of my prefs file 1 bit.

Re: [ANY] Clientprefs Cleaner (Cookies Purge)
 

It's actually purging database, you can look at this through SQLite Database Browser.
I have no idea why its dont change size of clientprefs database, but does it makes sense? It's only a few kilobytes :P

Re: [ANY] Clientprefs Cleaner (Cookies Purge)
 

That could be a problem, I have a very active MvM server that's open to the public/matchmaking, and the clientprefs-sqlite.sq3 has easily grown to over 18mb. Perhaps executing the VACUUM command in a query would be a good idea when purging. http://www.sqlite.org/lang_vacuum.html

Re: [ANY] Clientprefs Cleaner (Cookies Purge)
 

SQLite isn't designed to have multiple connections open to a file, this could easily corrupt the database (and I'm surprised it doesn't error anyway).