Germany
The tool you need is a SQLite browser: http://sourceforge.net/projects/sqlitebrowser/
- stop the wcs mod (es_unload wcs)
- BACKUP your es_wcsdata.sqldb
- open it with SQLite browser
- go to execute SQL, paste in the code
- save the file and upload on server, reload mod
Here is how you can find old players: (gives you the number) 14 days
SELECT COUNT(*) FROM WCSusers A WHERE strftime('%s','now')-14*24*3600 >= (SELECT xp FROM WCSusers B WHERE race = "_wcs_" and A.id = B.id) and race != "_wcs_"
Or delete all players being that long not playing: (14 days)
DELETE FROM WCSusers WHERE id IN (SELECT id FROM WCSusers A WHERE strftime('%s','now')-14*24*3600 >= (SELECT xp FROM WCSusers B WHERE race = "_wcs_" and A.id = B.id) and race != "_wcs_")
Hope this helps to keep your userDB smaller
Logged
United States
