View Single Post
HiDeath
Senior Member
Join Date: Aug 2018
Location: Tunisia
Old 05-23-2019 , 21:42   Re: GeoLiteCity.dat NOT FOUND problem
Reply With Quote #8

I did the update successfully , but i still get more erros , when i click on players tab :
Code:
Server Error: (1054) Unknown column 'hlstats_Players.mmrank' in 'field list'
Last SQL Query:
				SELECT
					SQL_CALC_FOUND_ROWS
					hlstats_Players.playerId,
					hlstats_Players.connection_time,
                                        unhex(replace(hex(hlstats_Players.lastName), 'E280AE', '')) as lastName,
					hlstats_Players.flag,
					hlstats_Players.country,
					hlstats_Players.skill,
					hlstats_Players.mmrank,
					hlstats_Players.kills,
					hlstats_Players.deaths,
					hlstats_Players.last_skill_change,
					ROUND(hlstats_Players.kills/(IF(hlstats_Players.deaths=0, 1, hlstats_Players.deaths)), 2) AS kpd,
					hlstats_Players.headshots,
					ROUND(hlstats_Players.headshots/(IF(hlstats_Players.kills=0, 1, hlstats_Players.kills)), 2) AS hpk,
					IFNULL(ROUND((hlstats_Players.hits / hlstats_Players.shots * 100), 1), 0) AS acc,
					activity
				FROM
					hlstats_Players
				WHERE
					hlstats_Players.game = 'cstrike'
					AND hlstats_Players.hideranking = 0
					AND hlstats_Players.kills >= 1
				ORDER BY
					skill desc,
					kpd desc,
					hlstats_Players.lastName ASC
				LIMIT
					0,
					50
Can i keep the old web verions with the current database / daemon , i really like it better

Last edited by HiDeath; 05-23-2019 at 21:46.
HiDeath is offline