Skip to content

Latest commit

 

History

History
56 lines (50 loc) · 2.91 KB

README.md

File metadata and controls

56 lines (50 loc) · 2.91 KB

Player Record

Save information about players in each connection

  • Save AccountID, name and IP in each connection
  • Save AccountID, name and IP in a name change
  • If the AccountID, name and IP are the same as a previous save, only the date will be updated
  • Useful admin commands to view info about players giving an AccountID, name or IP

Info Commands

Command Description
sm_playerinfo Shows names, all types of SteamID and IPs seen with a given SteamID of any type, IP or name
sm_nameinfo Shows names, all types of SteamID and IPs seen with a given name
sm_ipinfo Shows names, all types of SteamID and IPs of all players who have joined from the given IP
sm_steamid2info Shows last name, all types of SteamID and last seen IP explicitly searching with a SteamID2
sm_steamid3info Shows last name, all types of SteamID and last seen IP explicitly searching with a SteamID3
sm_steamid64info Shows last name, all types of SteamID and last seen IP explicitly searching with a SteamID64

History Commands

Command Description
sm_playerall Shows a history of all names, all types of SteamID and all IPs of a given SteamID, IP or name
sm_namenames Shows a history of all names that a player had searching with one of his names
sm_steamid2names Shows a history of all names a player had searching with a SteamID2
sm_steamid3names Shows a history of all names a player had searching with a SteamID3
sm_steamid64names Shows a history of all names a player had searching with a SteamID64
sm_nameips Shows a history of all IPs connected with the given name
sm_steamid2ips Shows a history of all IPs from where a SteamID2 was connected
sm_steamid3ips Shows a history of all IPs from where a SteamID3 was connected
sm_steamid64ips Shows a history of all IPs from where a SteamID64 was connected
sm_ipall Shows a history of all types of SteamID and their respective names seen on an IP

Cvars

Cvar Description
db_playerrecord_printchat Set whether the command response should be seen in the chat
db_playerrecord_printonsole Set whether the command response should be seen in the client console
db_playerrecord_printserver Set whether the command response should be seen in the server console

How to install

  • Install MySQL with sudo apt-get install mysql-server
  • Create a user and a database, make sure it's remotely accessible
  • Run this command on MySQL SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
  • Add this on databases.cfg, located in addons/sourcemod/configs (edit the values with *)
"PlayerRecord"
	{
		"driver"			"mysql"
		"host"				"database_host*"
		"database"			"database_name*"
		"user"				"mysql_user*"
		"pass"				"user_password*"
	}
  • Put db_player_record.smx in your plugins folder and make sure it's always loaded