Recalculate player information from logs and create new versions of commands to query the information stored in a database with UUIDs. - [x] database schema - [x] fixplayerinfo log parsing script - [x] temporary UUID assignment for old players with no currently known uuid - [x] run fixplayerinfo script over *all* the logs commands - [x] /firstseen - [x] /lastseen - [x] /timeplayed - [x] /getrep, /reputation - [x] /rep (including /badrep) - done by @AlphaAlex115 - [x] /repstats - [x] /friend - [x] /unfriend - [x] /friends - [x] /friendsonline - [x] /deathinfo - [x] /reportin (firstseen setting, username changes, sessions) - [x] /reportout (lastseen, timeplayed setting, sessions) - [x] /logdeath - [x] /whois - done by @techkid6 and @AlphaAlex115 - [x] /history (previous username info) scripts (some may just need their use of other scripts updated): - [x] check_hours_and_announce - [x] cleanuptimeonline (now named cleanupsessions) - [x] get_correctname - [x] get_ingamename - [ ] getlastplayercount - [ ] getmaxplayers - [ ] getminplayers - [x] get_name_from_db - [x] get_name_from_mojang_uuid - [x] get_name_from_uuid - [ ] getplayercounts - [ ] get_prism_events_from_player - [ ] getuniqueplayers - [x] get_uuid_at - [x] get_uuid_from_db - [x] get_uuid_from_mojang - [ ] get_uuids_from_mojang - [x] get_uuid - [x] identify_for_irc - [x] identify_ip - [x] minecraftstart cgi-bin scripts: - [x] getcorrectname - [x] getfirstseen - [x] getfirstseen_unix - [x] getlastseen - [x] getlastseen_unix - [ ] getplayerfriendgraph.sh ? - [x] getplayerinfo - [x] getplayerinfo_uuid - [x] gettimeonline - [x] gettimeonline_uuid - [x] getuniquevisitors.sh - [x] getuniqueyesterday.sh Things to do when switching over (while server is down): - [x] run fixplayerinfo script over any new logs since the last use - [x] update `exec.conf` to set command aliases to new scripts - [x] update cron to use any new versions of scripts - [x] move old command scripts to `obsoletescripts` - [x] add new /logdeath to CommandOn and remove /logdeath use from McObot - [x] update symbolic links in `/var/www/minecraftonline/cgi-bin/` to point to new scripts - [x] move/remove old cgi-bin scripts - [x] update any references to scripts with new names (such as in other scripts/commands)