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; }