/** * List all steam users in the database * * Used in the following: * ControllerAdmin\Steam.php * * @return array */ public function getSteamUsers() { $rVal = array(); $db = XenForo_Application::get('db'); $results = $db->fetchAll("SELECT u.provider_key, p.user_id, p.username \n FROM xf_user_external_auth u, xf_user p \n WHERE u.user_id = p.user_id \n AND u.provider = 'steam' \n ORDER BY p.username;"); foreach ($results as $row) { $rVal[] = array('id' => Steam_Helper_Steam::convertIdToString($row['provider_key']), 'id64' => $row['provider_key'], 'username' => $row['username'], 'user_id' => $row['user_id']); } return $rVal; }