[ft] THE FOOT CLAN - Day of Defeat: Source - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	\=
Home Page:
Activity:		96.00%
Members:	1 active members (1 total)
Avg. Member Points:	1,002
Total Kills:	1
Total Deaths:	0
Avg. Kills:	1
Kills per Death:	-
Kills per Minute:	0.00
Total Connection Time:	2d 01:15:02h
Avg. Connection Time:	2d 01:15:02h
Favorite Server:*	[ft] THE FOOT CLAN \| 100 tick \| HLStatsX \| bots until 3v3
Favorite Map:*	dod_convoy_b20
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	\=/ککID\=/ Rusty Hammer	1,002		2d 01:15:02h	1		100.00%	0	1.00

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Allies	30 times		31.58%
2	Axis	20 times		21.05%

ERROR

Database Error

Server Address: localhost
Server Username: thefootclan

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'thefootclan.hlstats_Frags_as_res.killsTotal' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Last SQL Query:

		SELECT
			IFNULL(hlstats_Roles.name, hlstats_Events_ChangeRole.role) AS name,
			IFNULL(hlstats_Roles.code, hlstats_Events_ChangeRole.role) AS code,
			COUNT(hlstats_Events_ChangeRole.id) AS rolecount,
			ROUND(COUNT(hlstats_Events_ChangeRole.id) / IF(52 = 0, 1, 52) * 100, 2) AS percent,
			killsTotal,
			deathsTotal,
			ROUND(killsTotal/if(deathsTotal=0,1,deathsTotal), 2) AS kpd
		FROM
			hlstats_Events_ChangeRole
		LEFT JOIN
			hlstats_Roles
		ON
			hlstats_Events_ChangeRole.role = hlstats_Roles.code
		LEFT JOIN
			hlstats_Servers
		ON
			hlstats_Servers.serverId = hlstats_Events_ChangeRole.serverId
		LEFT JOIN
			hlstats_Frags_as_res
		ON
			hlstats_Frags_as_res.role = hlstats_Events_ChangeRole.role
		LEFT JOIN
			hlstats_Players
		ON
			hlstats_Players.playerId = hlstats_Events_ChangeRole.playerId
		WHERE
			hlstats_Servers.game='dods'
			AND hlstats_Players.clan=114
			AND (hidden <>'1' OR hidden IS NULL)
			AND hlstats_Roles.game = 'dods'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc