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

Sections

Clan Information

Statistics Summary
Clan:	*HS*
Home Page:
Activity:		60.50%
Members:	2 active members (10 total)
Avg. Member Points:	1,006
Total Kills:	2
Total Deaths:	1
Avg. Kills:	1
Kills per Death:	2.00
Kills per Minute:	0.00
Total Connection Time:	0d 13:34:34h
Avg. Connection Time:	0d 06:47:17h
Favorite Server:*	[ft] THE FOOT CLAN \| 100 tick \| HLStatsX \| bots until 3v3
Favorite Map:*	dod_6_june_1944_rc1
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	*[HS] Bubba_Ho-Tep*	1,012		0d 06:02:21h	2		100.00%	1	2.00
2	[HS]Kappy	1,000		0d 07:32:13h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Capture Blocked	1 times	6

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Allies	10 times		26.32%
2	Axis	9 times		23.68%

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(26 = 0, 1, 26) * 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=4
			AND (hidden <>'1' OR hidden IS NULL)
			AND hlstats_Roles.game = 'dods'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc