function tslink_update_groups($mybb_uid)
{
if (!isset($messages)) {
$messages = [];
}
$messages[] = 'In the following part we gonna update the user his groups on the TS server.';
require __DIR__ . '/config.php';
// Connect to the database.
$ConnectDB = new mysqli($hostname, $username, $password, $database);
// check connection
if ($ConnectDB->connect_errno) {
die($ConnectDB->connect_error);
}
// Get the member from the mybb database.
$getit = "SELECT * FROM {$table} WHERE uid = '{$mybb_uid}' LIMIT 1";
$messages['getit_query'] = $getit;
$rows = $ConnectDB->query($getit);
$row = $rows->fetch_array(MYSQLI_ASSOC);
$messages['found_member'] = 'User ID: ' . $row['uid'] . ' Username: '******'username'];
// Get the memberstatus from the user.
$memberstatus = $row['memberstatus'];
$messages['memberstatus'] = $memberstatus;
// Let's determine which servergroup to use according to the status of the user.
if ($memberstatus == '2') {
$ServerGroupID_ToAdd = $ts3_sgid_vip_member;
} elseif ($memberstatus == '1') {
$ServerGroupID_ToAdd = $ts3_sgid_don_member;
} else {
$ServerGroupID_ToAdd = $ts3_sgid_member;
}
$messages['ServerGroupID_ToAdd'] = $ServerGroupID_ToAdd;
// Get the user's unique id's from the mybb database
$get_ts_uids = 'SELECT * FROM ' . TABLE_PREFIX . "tslink_uids WHERE uid = '{$mybb_uid}' ";
$messages['get_ts_uids_query'] = $get_ts_uids;
$ts_unique_ids = $ConnectDB->query($get_ts_uids);
foreach ($ts_unique_ids as $ts_unique_id) {
$messages['registered_ts_db_entries'][] = 'TS UID: ' . $ts_unique_id['ts_uid'] . ' TS CLDBID: ' . $ts_unique_id['ts_cldbid'];
}
$messages['groups_wont_be_removed'] = implode(',', $ts3_sgid_dont_remove);
// Build a new ts3admin object.
$ts3 = new ts3admin($ts3_server, $ts3_query_port);
// Connect to the TS server.
if ($ts3->getElement('success', $ts3->connect())) {
$messages['ts_connection'] = 'Successful';
// Login to the TS server.
if ($ts3->getElement('success', $ts3->login($ts3_username, $ts3_password))) {
$messages['ts3_login'] = '******';
// Select virtual server.
if ($ts3->getElement('success', $ts3->selectServer($ts3_server_port))) {
$messages['ts3_virtual_server_select'] = 'Successful';
// Set displayed name in TS to given
$ts3->setName($ts3_nickname);
foreach ($ts_unique_ids as $ts_unique_id) {
// First lets remove all groups the user is member of.
// First get all servergroups the user is member of.
$ClientServerGroups = $ts3->servergroupsbyclientid($ts_unique_id['ts_cldbid']);
$csg = [];
$c = 0;
if (is_array($ClientServerGroups['data'])) {
foreach ($ClientServerGroups['data'] as $ClientServerGroup) {
$messages['found_groups']['CLDBID_' . $ts_unique_id['ts_cldbid']][] = 'sgid: ' . $ClientServerGroup['sgid'] . ' Name: ' . $ClientServerGroup['name'];
}
}
// For every servergroup found, remove it.
if (is_array($ClientServerGroups['data'])) {
foreach ($ClientServerGroups['data'] as $Client_ServerGroup) {
$csg[] = $Client_ServerGroup['sgid'];
}
}
foreach ($csg as $ClientServerGroupID) {
// Except for the servergroups we don't want to have removed.
if (!in_array($ClientServerGroupID, $ts3_sgid_dont_remove)) {
try {
$messages['SGID_' . $ClientServerGroupID]['removing_from'][] = 'CLDBID: ' . $ts_unique_id['ts_cldbid'];
$removeResults = $ts3->serverGroupDeleteClient($ClientServerGroupID, $ts_unique_id['ts_cldbid']);
if ($removeResults['success']) {
$messages['SGID_' . $ClientServerGroupID]['removing_from_result']['CLDBID_' . $ts_unique_id['ts_cldbid']] = 'Succes.';
} else {
$messages['SGID_' . $ClientServerGroupID]['removing_from_result']['CLDBID_' . $ts_unique_id['ts_cldbid']] = $removeResults['errors'];
}
} catch (Exception $e) {
// Catches the error(s) if any. But don't do anything with it.
}
}
}
$c++;
try {
// Add the user to the servergroup.
$messages['SGID_' . $ServerGroupID_ToAdd]['adding_to'][] = 'CLDBID: ' . $ts_unique_id['ts_cldbid'];
$serverGroupAddClientResults = $ts3->serverGroupAddClient($ServerGroupID_ToAdd, $ts_unique_id['ts_cldbid']);
if ($serverGroupAddClientResults['success']) {
$messages['SGID_' . $ServerGroupID_ToAdd]['adding_to_result']['CLDBID_' . $ts_unique_id['ts_cldbid']] = 'Succes.';
} else {
$messages['SGID_' . $ServerGroupID_ToAdd]['adding_to_result']['CLDBID_' . $ts_unique_id['ts_cldbid']] = $serverGroupAddClientResults['errors'];
}
//$messages[$ServerGroupID_ToAdd]['adding_to_result'][] = $serverGroupAddClientResults;
} catch (Exception $e) {
// Catches the error(s) if any. But don't do anything with it.
}
}
} else {
echo '<p>Could not select the virtual server.</p> <p>Please check the TS server port in the config!</p> <p>Also make sure this (UDP) port is open in the outgoing firewall!</p>';
$messages['ts3_virtual_server_select'] = 'Could not select the virtual server.';
}
} else {
echo '<p>Could not login to the TS server.</p> <p>Please check the username and password in the config!</p>';
$messages['ts3_login'] = '******';
}
} else {
echo '<p>Connection to the TS server could not be established.</p> <p>Please check the TS server and TS server query port in the config!</p> <p>Also make sure this (TCP) port is open in the outgoing firewall!</p>';
$messages['ts3_connect'] = 'Connection to the TS server could not be established.';
}
if (count($ts3->getDebugLog()) > 0) {
$messages['ts3_add_remove_debuglog'] = $ts3->getDebugLog();
}
// Close connection
$ConnectDB->close();
return $messages;
}
