Introduction Instructions Templates Database
Run Calculation Display Mandatory Optional Player Data Message Centre Logfile Substitutions Developer Help
Go f1 Score Weights Real Names Template Variable Config Clan Config Avatar Editing Message Centre Game Type Debug Settings Help
Exit Skill Weights Images Output Config Alias Editing Real Name Editing Message Centre Formats Map Export Template About
Award Editing Server Config Drop List Editing Personal Picture Class
Website Config Banned Speech Editing Clan Role Team
External Database Xfire Weapon
Website Ammo
Miscellaneous 1 Weapon And Ammo
Miscellaneous 2 Location
Action

Database

StatsGen writes all it's calculation results into an internal SQLITE3 database. It uses many tables which relate to each other in various ways. The below diagrams show you a list of the tables and their relationship to each other. You can click on any of the tables to see it's description. The pictures look initially confusing but there are 4 basic tables, players, playerinround, rounds, kills. Rounds have players in the rounds, players in rounds make kills. All the rest of the tables expand on this basic information.
playerinround player rounds killdata teamlossdata streakdata gametype map team weapon class location teamwindata
player playerdataavatars playerdataclanrole playerdataxfire playerdatawebsite playerdatamisc1 playerdatamisc2 playerdatapicture playerdatarealname servers servervariables playerinround speechdata rounds
rounds awardpoints actiondata roundvariables gametype map speechdata awarddefinition action streakdata player clan
player killtotalweapons killtotalclasses killtotalgametypes killtotallocations killtotalmaps killtotalteams weapon class gametype location map team

Table List

View List

action
actiondata
ammo
awarddefinition
awardpoints
clan
class
gametype
killdata
killtotalclasses
killtotalgametypes
killtotallocations
killtotalmaps
killtotalteams
killtotalweapons
location
map
miscellaneous
player
playerdataavatars
playerdataclanrole
playerdatamisc1
playerdatamisc2
playerdatapicture
playerdatarealname
playerdatawebsite
playerdataxfire
playerinround
rounds
roundvariables
servers
servervariables
speechdata
streakdata
team
teamlossdata
teamwindata
weapon
view_actiondata
view_awardpoints
view_killdata
view_player
view_playerinround
view_rounds
view_teamwindata
view_teamlossdata
view_killtotalclasses
view_killtotalgametypes
view_killtotallocations
view_killtotalmaps
view_killtotalteams
view_killtotalweapons