{"action":"created","issue":{"url":"https://api.github.com/repos/AdKats/AdKats/issues/785","labels_url":"https://api.github.com/repos/AdKats/AdKats/issues/785/labels{/name}","comments_url":"https://api.github.com/repos/AdKats/AdKats/issues/785/comments","events_url":"https://api.github.com/repos/AdKats/AdKats/issues/785/events","html_url":"https://github.com/AdKats/AdKats/issues/785","id":94034567,"number":785,"title":"Small issue: special players","user":{"login":"ChaT0n","id":13076710,"avatar_url":"https://avatars.githubusercontent.com/u/13076710?v=3","gravatar_id":"","url":"https://api.github.com/users/ChaT0n","html_url":"https://github.com/ChaT0n","followers_url":"https://api.github.com/users/ChaT0n/followers","following_url":"https://api.github.com/users/ChaT0n/following{/other_user}","gists_url":"https://api.github.com/users/ChaT0n/gists{/gist_id}","starred_url":"https://api.github.com/users/ChaT0n/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ChaT0n/subscriptions","organizations_url":"https://api.github.com/users/ChaT0n/orgs","repos_url":"https://api.github.com/users/ChaT0n/repos","events_url":"https://api.github.com/users/ChaT0n/events{/privacy}","received_events_url":"https://api.github.com/users/ChaT0n/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-07-09T12:24:56Z","updated_at":"2015-07-09T14:21:26Z","closed_at":null,"body":"In the special players info, the game played by the special palyers doesn't show up.\r\nIn the table \"adkats_specialplayers\" the \"player_game\" is empty, while if we search in the table \"tbl_playerdata\" we can find the \"gameid\" for the same eaguid.\r\n\r\nCan you fix it so we can use this info in the bfadmincp ?\r\n\r\nThank you"},"comment":{"url":"https://api.github.com/repos/AdKats/AdKats/issues/comments/119999138","html_url":"https://github.com/AdKats/AdKats/issues/785#issuecomment-119999138","issue_url":"https://api.github.com/repos/AdKats/AdKats/issues/785","id":119999138,"user":{"login":"ColColonCleaner","id":1903507,"avatar_url":"https://avatars.githubusercontent.com/u/1903507?v=3","gravatar_id":"","url":"https://api.github.com/users/ColColonCleaner","html_url":"https://github.com/ColColonCleaner","followers_url":"https://api.github.com/users/ColColonCleaner/followers","following_url":"https://api.github.com/users/ColColonCleaner/following{/other_user}","gists_url":"https://api.github.com/users/ColColonCleaner/gists{/gist_id}","starred_url":"https://api.github.com/users/ColColonCleaner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ColColonCleaner/subscriptions","organizations_url":"https://api.github.com/users/ColColonCleaner/orgs","repos_url":"https://api.github.com/users/ColColonCleaner/repos","events_url":"https://api.github.com/users/ColColonCleaner/events{/privacy}","received_events_url":"https://api.github.com/users/ColColonCleaner/received_events","type":"User","site_admin":false},"created_at":"2015-07-09T14:21:26Z","updated_at":"2015-07-09T14:21:26Z","body":"You seem to misunderstand what Game ID in that table does. Game ID there does not identify players, it restricts that listing.\r\n\r\nFor example, if someone uses an EA GUID in the player_identifier, EA GUIDs are not unique to a game so if you want that listing to only apply on game 1 servers, put 1 in the game column. The same goes for server ID, if you only want that listing to apply to a specific server, specify a server ID.\r\n\r\nIf you want to find all special players for a certain game only, left join on the playerdata table matching player_id to PlayerID, and only take those from the GameID you want.\r\n\r\nKeep in mind, player IDs are already unique by game.\r\n\r\nThis is explained in the docs: https://github.com/AdKats/AdKats#special-player-lists"}}