Quote:
Originally Posted by Oo Alias oO
Trying to figure out how to handle group community bans.
I can get the group information fine (users in their etc), and I could technically add bans to the database from there... However that only works for players at the time of adding, and still bans people who are no longer in the group if they leave.
I could store the group information too, and then for each user check whether they're in the group... However that means for each user connecting to the server, I'd have to query the steam servers rather than just the local database.
Any suggestions?
|
I made this some times ago.
Here is how I did it:
- A simple MySQL database table storing a list of banned groups. The table just had an index, and the group ID (groupID64 form).
- PHP script taking a steam ID (steamID64 form) as a parameter. Printing nothing if the user does not belong to any banned group, printing the group name in the other case.
- A plugin querying the PHP script when a client connects, kicking him if he's a member of a banned group.
If you want the PHP script, here it is:
PHP Code:
<?php
$db_host = "127.0.0.1";
$db_user = "user";
$db_password = "password";
$db_name = "database";
$db_table = "groupbans";
function findMemberInPage(&$url, $uid) {
$xml = simplexml_load_file($url);
if ($xml === FALSE || !property_exists($xml, "members"))
return (FALSE);
$members = (array)$xml->members;
if (!array_key_exists("steamID64", $members) || !is_array($members['steamID64']))
return (FALSE);
if (in_array($_GET['uid'], $members['steamID64']) !== FALSE)
return ($xml->groupDetails->groupName);
if (property_exists($xml, "nextPageLink"))
$url = $xml->nextPageLink;
return (FALSE);
}
error_reporting(0);
header("Content-Type: text/plain");
if (empty($_GET['uid']))
exit;
$database = new PDO('mysql:host='.$db_host.';dbname='.$db_name, $db_user, $db_password);
$query = $database->query("SELECT `groupid` FROM `".$db_table."`;");
while (($result = $query->fetch())) {
$groupName = FALSE;
$url = "http://steamcommunity.com/gid/".$result['groupid']."/memberslistxml/?xml=1&p=1";
while ($url !== FALSE) {
$groupName = findMemberInPage($url, $_GET['uid']);
if ($groupName !== FALSE)
break;
}
if ($groupName !== FALSE) {
echo $groupName;
break;
}
}
$query->closeCursor();
$database = null;
?>
This script currently does not support memberlist pagination, then on huge groups only 1000 players are considered.
I don't have the plugin anymore, but it's not a really big deal, you just need to convert the client's steamid to steamid64, use curl (or whatever) to query the PHP script (with the id as the 'uid' URL parameter) and fetch the result. If result if blank, do nothing. If not, you kick the client (and optionnaly use the group name in the kick reason).
PS: You could do everything from the PHP script directly in the plugin.
EDIT: I included a version which supports multiple pages. There are 0 optimizations, so it can be slow.
Since the steam ids seems to be returned in ascending order, an optimization to start with would be not to fetch pages in numerical order, but rather compare id values from the middle-page (would divide execution time by 2, no?).
Linear Mode
