db

type Config struct {
	SteamAPIKey  string
	DefaultPage  string
	SQLHost      string
	SQLUser      string
	SQLPass      string
	SQLPort      int
	SQLDBName    string
	SQLDebugMode bool
	HOST         string
	Cookie       string
}

type DBdatas struct {
	Host string
	User string
	Pass string
	Db   string
	Port int
	Gorm *gorm.DB
}

type GameServerData struct {
	ID           int    `gorm:"primary_key;column:id;AUTO_INCREMENT;NOT NULL" json:"id"`
	UserID       int    `gorm:"column:user_id;DEFAULT NULL" json:"user_id"`
	InUse        bool   `gorm:"column:in_use;DEFAULT NULL" json:"in_use"`
	IPString     string `gorm:"column:ip_string;DEFAULT NULL" json:"ip_string"`
	Port         int    `gorm:"column:port;DEFAULT NULL" json:"port"`
	RconPassword string `gorm:"column:rcon_password;DEFAULT NULL" json:"rcon_password"`
	DisplayName  string `gorm:"column:display_name;DEFAULT NULL" json:"display_name"`
	PublicServer bool   `gorm:"column:public_server;DEFAULT NULL" json:"public_server"`
}

type MapStatsData struct {
	ID         int           `gorm:"primary_key" gorm:"column:id"`
	MatchID    int           `gorm:"column:match_id" gorm:"ForeignKey:match_id"`
	MapNumber  int           `gorm:"column:map_number"`
	MapName    string        `gorm:"column:map_name"`
	StartTime  sql.NullTime  `gorm:"column:start_time"`
	EndTime    sql.NullTime  `gorm:"column:end_time"`
	Winner     sql.NullInt32 `gorm:"column:winner"`
	Team1Score int           `gorm:"column:team1_score"`
	Team2Score int           `gorm:"column:team2_score"`

	User UserData `gorm:"ASSOCIATION_FOREIGNKEY:user_id"`
}

type MatchConfig struct {
	MatchID              string `json:"matchid"` // NOT int
	Scrim                bool   `json:"scrim,omitempty"`
	MatchTitle           string `json:"match_title,omitempty"`
	PlayersPerTeam       int    `json:"players_per_team,omitempty"`
	MinPlayersToReady    int    `json:"min_players_to_ready,omitempty"`
	MinSPectatorsToReady int    `json:"min_spectators_to_ready,omitempty"`
	SkipVeto             bool   `json:"skip_veto,omitempty"`
	// bo2_series and maps_to_win are deprecated on get5 plugin side. Use num_maps insted
	// Bo2Series 			   bool   `json:"bo2_series"`
	// MapsToWin 			   int    `json:"maps_to_win"`
	NumMaps                    int    `json:"num_maps,omitempty"`
	VetoFirst                  string `json:"veto_first,omitempty"` // team1 || team2
	SideType                   string `json:"side_type,omitempty"`  // standard and ?
	FavoredTeamPercentageText  string `json:"favored_percentage_text,omitempty"`
	FavoredTeamPercentageTeam1 int    `json:"favored_percentage_team1,omitempty"`
	Spectators                 struct {
		Name    string   `json:"name"`
		Players []string `json:"players"`
	} `json:"spectators"`
	Team1 struct {
		Flag    string   `json:"flag"`
		Name    string   `json:"name"`
		Tag     string   `json:"tag"`
		Players []string `json:"players"`
	} `json:"team1"`
	Team2 struct {
		Flag    string   `json:"flag"`
		Name    string   `json:"name"`
		Tag     string   `json:"tag"`
		Players []string `json:"players"`
	} `json:"team2"`

	Maplist  []string `json:"maplist"`
	MapSides []string `json:"map_sides"`

	Cvars map[string]string `json:"cvars"`
}

type MatchData struct {
	ID              int           `gorm:"primary_key;column:id" json:"id"`
	UserID          int           `gorm:"column:user_id" json:"user_id"`
	ServerID        int           `gorm:"column:server_id" json:"server_id"`
	Team1ID         int           `gorm:"column:team1_id" json:"team1_id"`
	Team2ID         int           `gorm:"column:team2_id" json:"team2_id"`
	Winner          sql.NullInt32 `gorm:"column:winner" json:"winner"`
	Cancelled       bool          `gorm:"column:cancelled" json:"cancelled"`
	StartTime       sql.NullTime  `gorm:"column:start_time" json:"start_time"`
	EndTime         sql.NullTime  `gorm:"column:end_time" json:"end_time"`
	MaxMaps         int           `gorm:"column:max_maps" json:"max_maps"`
	Title           string        `gorm:"column:title" json:"title"`
	SkipVeto        bool          `gorm:"column:skip_veto" json:"skip_veto"`
	APIKey          string        `gorm:"column:api_key" json:"-"`
	VetoMapPool     string        `gorm:"column:veto_mappool" json:"-"`
	VetoMapPoolJSON []string      `gorm:"-" json:"veto_mappool"`
	Team1Score      int           `gorm:"column:team1_score" json:"team1_score"`
	Team2Score      int           `gorm:"column:team2_score" json:"team2_score"`
	Team1String     string        `gorm:"column:team1_string" json:"team1_string"`
	Team2String     string        `gorm:"column:team2_string" json:"team2_string"`
	Forfeit         bool          `gorm:"column:forfeit" json:"forfeit"`
	PluginVersion   string        `gorm:"column:plugin_version" json:"-"`

	MapStats []MapStatsData `gorm:"ForeignKey:MatchID" json:"-"`
	Server   GameServerData `json:"-"`
}

type MatchPageData struct {
	LoggedIn    bool
	AdminAccess bool
	Match       MatchData
}

type MatchesPageData struct {
	LoggedIn   bool
	UserName   string
	UserID     int
	Matches    []MatchData
	AllMatches bool
	MyMatches  bool
	Owner      UserData
}

type MetricsData struct {
	RegisteredUsers    int `json:"users"`
	SavedTeams         int `json:"saved_teams"`
	MatchesCreated     int `json:"matches_created"`
	CompletedMatches   int `json:"completed_matches"`
	ServersAdded       int `json:"servers_added"`
	MapsWithStatsSaved int `json:"maps_with_stats"`
	UniquePlayers      int `json:"unique_players"`
}

type MetricsDataPage struct {
	LoggedIn bool
	Data     MetricsData
}

type MyserversPageData struct {
	Servers  []GameServerData
	LoggedIn bool
}

type PlayerStatsData struct {
	ID               int    `gorm:"primary_key;column:id"`
	MatchID          int    `gorm:"column:match_id"`
	MapID            int    `gorm:"column:map_id"`
	TeamID           int    `gorm:"column:team_id"`
	SteamID          string `gorm:"column:steam_id;unique"`
	Name             string `gorm:"column:name"`
	Kills            int    `gorm:"column:kills"`
	Deaths           int    `gorm:"column:deaths"`
	Roundsplayed     int    `gorm:"column:roundsplayed"`
	Assists          int    `gorm:"column:assists"`
	FlashbangAssists int    `gorm:"column:flashbang_assists"`
	Teamkills        int    `gorm:"column:teamkills"`
	Suicides         int    `gorm:"column:suicides"`
	HeadshotKills    int    `gorm:"column:headshot_kills"`
	Damage           int    `gorm:"column:damage"`
	BombPlants       int    `gorm:"column:bomb_plants"`
	BombDefuses      int    `gorm:"column:bomb_defuses"`
	V1               int    `gorm:"column:v1"`
	V2               int    `gorm:"column:v2"`
	V3               int    `gorm:"column:v3"`
	V4               int    `gorm:"column:v4"`
	V5               int    `gorm:"column:v5"`
	K1               int    `gorm:"column:k1"`
	K2               int    `gorm:"column:k2"`
	K3               int    `gorm:"column:k3"`
	K4               int    `gorm:"column:k4"`
	K5               int    `gorm:"column:k5"`
	FirstdeathCT     int    `gorm:"column:firstdeath_Ct"`
	FirstdeathT      int    `gorm:"column:firstdeath_t"`
	FirstkillCT      int    `gorm:"column:firstkill_ct"`
	FirstkillT       int    `gorm:"column:firstkill_t"`

	User UserData `gorm:"ASSOCIATION_FOREIGNKEY:user_id"`
}

type TeamCreatePageData struct {
	LoggedIn bool
	Edit     bool
	Content  interface{} // should be template
}

type TeamData struct {
	ID          int               `gorm:"primary_key;column:id" json:"id"`
	UserID      int               `gorm:"column:user_id" json:"user_id"`
	Name        string            `gorm:"column:name" json:"name"`
	Tag         string            `gorm:"column:tag" json:"tag"`
	Flag        string            `gorm:"column:flag" json:"flag"`
	Logo        string            `gorm:"column:logo" json:"logo"`
	AuthsPickle []byte            `gorm:"column:auths" json:"-"`
	Auths       []string          `gorm:"-" json:"auths"` // converts pickle []byte to []string
	Players     []PlayerStatsData `gorm:"-" json:"-"`
	PublicTeam  bool              `gorm:"column:public_team" json:"public_team"`
}

type TeamPageData struct {
	LoggedIn   bool
	IsYourTeam bool
	User       UserData
	Team       TeamData
}

type TeamsPageData struct {
	LoggedIn   bool
	User       UserData
	IsYourTeam bool
	Teams      []TeamData
}

type UserData struct {
	ID      int    `gorm:"primary_key;column:id;AUTO_INCREMENT"`
	SteamID string `gorm:"column:steam_id;unique"`
	Name    string `gorm:"column:name"`
	Admin   bool   `gorm:"column:admin"`

	Servers []*GameServerData `gorm:"ForeignKey:UserID"`
	Teams   []*TeamData       `gorm:"ForeignKey:UserID"`
	Matches []*MatchData      `gorm:"ForeignKey:UserID"`
}

type UserMaxResources struct {
	Servers uint16
	Teams   uint16
	Matches uint16
}

type UserPageData struct {
	LoggedIn bool
	User     UserData
}