Ejemplo n.º 1
0
function ts3_co()
{
    global $ts3_selected, $ts3_host;
    $ts3_host = TeamSpeak3::factory("serverquery://213.246.55.19:10011/?nickname=MOGG");
    $ts3_host->serverSelect(1);
    return $ts3_selected = $ts3_host->serverGetSelected();
    //$ts3_myid = $ts3_host->whoamiGet('client_id') ;
    //$ts3_defaultchan = $ts3_host->whoamiGet('client_channel_id') ;
}
Ejemplo n.º 2
0
function get_avatars($ts3, $mysqlcon, $lang, $dbname, $slowmode, $jobid, $timezone)
{
    $starttime = microtime(true);
    $sqlmsg = '';
    $sqlerr = 0;
    $count = 0;
    try {
        usleep($slowmode);
        $tsfilelist = $ts3->channelFileList($cid = "0", $cpw = "", $path = "/");
    } catch (Exception $e) {
        if ($e->getCode() != 1281) {
            echo DateTime::createFromFormat('U.u', number_format(microtime(true), 6, '.', ''))->setTimeZone(new DateTimeZone($timezone))->format("Y-m-d H:i:s.u "), "get_avatars 1:", $e->getCode(), ': ', "Error by getting Avatarlist: ", $e->getMessage(), "\n";
            $sqlmsg .= $e->getCode() . ': ' . "Error by getting Avatarlist: " . $e->getMessage();
            $sqlerr++;
        }
    }
    $fsfilelist = opendir(substr(__DIR__, 0, -4) . 'avatars/');
    while (false !== ($fsfile = readdir($fsfilelist))) {
        if ($fsfile != '.' && $fsfile != '..') {
            $fsfilelistarray[$fsfile] = filemtime(substr(__DIR__, 0, -4) . 'avatars/' . $fsfile);
        }
    }
    if (isset($tsfilelist)) {
        foreach ($tsfilelist as $tsfile) {
            $fullfilename = '/' . $tsfile['name'];
            $uuidasbase16 = substr($tsfile['name'], 7);
            if (!isset($fsfilelistarray[$uuidasbase16 . '.png']) || $tsfile['datetime'] > $fsfilelistarray[$uuidasbase16 . '.png']) {
                if (substr($tsfile['name'], 0, 7) == 'avatar_') {
                    try {
                        usleep($slowmode);
                        $avatar = $ts3->transferInitDownload($clientftfid = "5", $cid = "0", $name = $fullfilename, $cpw = "", $seekpos = 0);
                        $transfer = TeamSpeak3::factory("filetransfer://" . $avatar["host"] . ":" . $avatar["port"]);
                        $tsfile = $transfer->download($avatar["ftkey"], $avatar["size"]);
                        $avatarfilepath = substr(__DIR__, 0, -4) . 'avatars/' . $uuidasbase16 . '.png';
                        echo DateTime::createFromFormat('U.u', number_format(microtime(true), 6, '.', ''))->setTimeZone(new DateTimeZone($timezone))->format("Y-m-d H:i:s.u "), "Download avatar: ", $fullfilename, "\n";
                        file_put_contents($avatarfilepath, $tsfile);
                        $count++;
                    } catch (Exception $e) {
                        echo DateTime::createFromFormat('U.u', number_format(microtime(true), 6, '.', ''))->setTimeZone(new DateTimeZone($timezone))->format("Y-m-d H:i:s.u "), "get_avatars 2:", $e->getCode(), ': ', "Error by download Avatar: ", $e->getMessage(), "\n";
                        $sqlmsg .= $e->getCode() . ': ' . "Error by download Avatar: " . $e->getMessage();
                        $sqlerr++;
                    }
                }
            }
        }
    }
    $buildtime = microtime(true) - $starttime;
    if ($sqlerr == 0) {
        if ($mysqlcon->exec("UPDATE {$dbname}.job_log SET status='0', runtime='{$buildtime}' WHERE id='{$jobid}'") === false) {
            echo DateTime::createFromFormat('U.u', number_format(microtime(true), 6, '.', ''))->setTimeZone(new DateTimeZone($timezone))->format("Y-m-d H:i:s.u "), "get_avatars 3:", print_r($mysqlcon->errorInfo()), "\n";
        }
    } else {
        if ($mysqlcon->exec("UPDATE {$dbname}.job_log SET status='1', err_msg='{$sqlmsg}', runtime='{$buildtime}' WHERE id='{$jobid}'") === false) {
            echo DateTime::createFromFormat('U.u', number_format(microtime(true), 6, '.', ''))->setTimeZone(new DateTimeZone($timezone))->format("Y-m-d H:i:s.u "), "get_avatars 4:", print_r($mysqlcon->errorInfo()), "\n";
        }
    }
}
Ejemplo n.º 3
0
 function __construct()
 {
     try {
         // $this->cfg = Tools::getConfig('tsconfig_dev');
         $this->cfg = Tools::getConfig('tsconfig');
         $this->ts3 = TeamSpeak3::factory("serverquery://{$this->cfg['user']}:{$this->cfg['pass']}@{$this->cfg['host']}:{$this->cfg['qPort']}/?server_port={$this->cfg['sPort']}&nickname={$this->cfg['nick']}");
     } catch (Exception $e) {
         Tools::Log('error', 'Error', array($e));
     }
 }
Ejemplo n.º 4
0
 /**
  * @param integer $port
  * @param string $user
  * @param string $pass
  */
 public function __construct($host, $port, $user, $pass, $timeout = 1)
 {
     $this->user = $user;
     $this->pass = $pass;
     try {
         $uri = 'serverquery://' . $host . ':' . $port;
         $uri .= '?timeout=' . $timeout . '&use_offline_as_virtual=1#no_query_clients';
         $this->query = \TeamSpeak3::factory($uri);
         $this->online = true;
     } catch (\TeamSpeak3_Transport_Exception $e) {
         $this->online = false;
     }
 }
Ejemplo n.º 5
0
function ts3connect()
{
    require_once 'libraries/TeamSpeak3/TeamSpeak3.php';
    if (strlen(QUERYDISPLAYNAME) < 3) {
        $extension = "";
    } else {
        $extension = '&nickname=' . urlencode(QUERYDISPLAYNAME);
    }
    try {
        $ts3 = TeamSpeak3::factory('serverquery://' . QUERYUSER . ':' . QUERYPASS . '@' . IP . ':' . QUERYPORT . '?server_port=' . SERVERPORT . $extension);
    } catch (TeamSpeak3_Exception $e) {
        return $e;
    }
    return $ts3;
}
Ejemplo n.º 6
0
Archivo: exec.php Proyecto: twyK/CPTBot
 function connect($ip, $qport, $port, $name, $pass, $display = "CPTBot")
 {
     $e = false;
     $server = null;
     try {
         $server = TeamSpeak3::factory("serverquery://{$name}:{$pass}@{$ip}:{$qport}/?nickname={$display}&server_port={$port}");
     } catch (Exception $exc) {
         $e = true;
     }
     if ($e) {
         say("Couldn't reach Server {$ip}.");
         return null;
     } else {
         return new Server($server);
     }
 }
Ejemplo n.º 7
0
 public static function getData(JRegistry $params, stdClass $module)
 {
     if (!$params->get('server_host') || !$params->get('server_port') || !$params->get('query_port') || !$params->get('query_login') || !$params->get('query_password')) {
         return JText::_('MOD_TEAMSPEAK3_BASIC_CONFIGURATION_MISSING');
     }
     $cache = JFactory::getCache('teamspeak3', 'output');
     $cache->setCaching(1);
     $cache->setLifeTime($params->get('cache_time', 5));
     $query = array();
     $query['server_port'] = $params->get('server_port');
     $query['timeout'] = $params->get('connection_timeout', 10);
     if ($params->get('no_query_clients', 1)) {
         $query['no_query_clients'] = 1;
     }
     $query = http_build_query($query);
     $url = 'serverquery://' . $params->get('query_login') . ':' . $params->get('query_password') . '@' . $params->get('server_host') . ':' . $params->get('query_port') . '/?' . $query;
     $key = md5($url);
     if (!($data = $cache->get($key))) {
         try {
             $ts3 = TeamSpeak3::factory($url);
             $html = new TeamSpeak3_Viewer_Html_Joomla($params);
             $html->loadCacheIcons();
             $data = new stdClass();
             $data->infos = $ts3->getInfo(true, true);
             $data->infos['caching_timestamp'] = JFactory::getDate('now', 'UTC')->toSql();
             if ($params->get('channel_id')) {
                 try {
                     $channel = $ts3->channelGetById($params->get('channel_id'));
                 } catch (TeamSpeak3_Exception $e) {
                     return $e->getMessage() . ' (' . $e->getCode() . ')';
                 }
                 $data->viewer = $channel->getViewer($html);
             } else {
                 $data->viewer = $ts3->getViewer($html);
             }
             $html->storeCacheIcons();
             $data->title = $html->getModuleTitle();
             $cache->store($data, $key);
         } catch (TeamSpeak3_Exception $e) {
             return $e->getMessage() . ' (' . $e->getCode() . ')';
         }
     }
     if ($params->get('module_title')) {
         $module->title = $data->title;
     }
     return $data;
 }
Ejemplo n.º 8
0
function checkConnection($ip, $qport, $sport, $user, $pass, $nick)
{
    require_once 'libraries/TeamSpeak3/TeamSpeak3.php';
    if (strlen($nick) < 3) {
        $extension = '';
    } else {
        $extension = '&nickname=' . urlencode($nick);
    }
    try {
        $ts3 = TeamSpeak3::factory('serverquery://' . $user . ':' . $pass . '@' . $ip . ':' . $qport . '?server_port=' . $sport . $extension);
        $ts3->clientList();
        $ts3->getInfo();
    } catch (TeamSpeak3_Exception $e) {
        return '<b>TS3 Error:</b> ' . $e->getMessage();
    }
    return true;
}
Ejemplo n.º 9
0
 function online_users()
 {
     if ($this->modSettings["tea_ts_warnm"] == 0 && $this->modSettings["tea_ts_kickm"] == 0) {
         return;
     }
     require_once $this->sourcedir . '/TS3_Class/TeamSpeak3.php';
     $tslv = TeamSpeak3::LIB_VERSION;
     TeamSpeak3::init();
     try {
         $ts3 = TeamSpeak3::factory("serverquery://" . $this->modSettings["tea_ts_username"] . ":" . $this->modSettings["tea_ts_password"] . "@" . $this->modSettings["tea_ts_host"] . ":" . $this->modSettings["tea_ts_qport"] . "/?server_port=" . $this->modSettings["tea_ts_port"] . "&blocking=0");
         $clist = $ts3->clientList();
         foreach ($clist as $c) {
             if ($c->client_type == 0) {
                 $clid = (string) $c->client_unique_identifier;
                 $cnick = (string) $c->client_nickname;
                 $smf = $this->smcFunc['db_query']('', "SELECT id, tsid, dbid, name, warnstart, lastwarn FROM {db_prefix}tea_ts_users WHERE tsid = '" . $clid . "'");
                 $smf = $this->tea->select($smf);
                 if (!empty($smf)) {
                     $warned = FALSE;
                     $kick = FALSE;
                     $time = time() - $this->modSettings["tea_ts_warnm"] * 60;
                     if ($smf[0][5] < $time) {
                         $char = $smf[0][3];
                         //	$chars = $this -> tea -> get_all_chars($smf[0][0]);
                         $name = $this->format_ts_name($smf[0][0], $char);
                         //	$aid = NULL;
                         if (!empty($name)) {
                             //		foreach($chars as $i => $ch)
                             //		{
                             //			if($ch[0] == $char)
                             //				$aid = $i;
                             //		}
                             if ($name != $cnick) {
                                 if ($this->modSettings["tea_ts_kickm"] != 0 && $smf[0][4] != 0 && $smf[0][4] < time() - $this->modSettings["tea_ts_kickm"] * 60) {
                                     $c->kick(TeamSpeak3::KICK_SERVER, 'Incorrect Nickname, Expecting: ' . $name);
                                     $this->smcFunc['db_query']('', "UPDATE {db_prefix}tea_ts_users SET lastwarn = 0, warnstart = 0 WHERE tsid = '" . $clid . "'");
                                 } elseif ($this->modSettings["tea_ts_warnm"] != 0) {
                                     $c->poke('Incorrect Nickname, Expecting: ' . $name);
                                     $warned = TRUE;
                                 }
                             } else {
                                 $this->smcFunc['db_query']('', "UPDATE {db_prefix}tea_ts_users SET lastwarn = 0, warnstart = 0 WHERE tsid = '" . $clid . "'");
                             }
                         } else {
                             $c->message('Error Unable to Find Character');
                             $warned = TRUE;
                         }
                     }
                     if ($warned) {
                         $sql = '';
                         if ($smf[0][4] == 0) {
                             $sql = ', warnstart = ' . time();
                         }
                         $this->smcFunc['db_query']('', "UPDATE {db_prefix}tea_ts_users SET lastwarn = " . time() . $sql . " WHERE tsid = '" . $clid . "'");
                     }
                 } else {
                     $c->message('Error: SMF Account not Found, Please Register on Forum and use Temars EVE API mod to link Teamspeak to forum');
                 }
             }
         }
     } catch (Exception $e) {
         die($e->getMessage());
         $_SESSION['tea_ts_error'][] = $e->getMessage();
     }
 }
Ejemplo n.º 10
0
 /**
  * Uploads a given icon file content to the server and returns the ID of the icon.
  *
  * @param  string $data
  * @return integer
  */
 public function iconUpload($data)
 {
     $crc = crc32($data);
     $size = strlen($data);
     $upload = $this->transferInitUpload(rand(0x0, 0xffff), 0, "/icon_" . $crc, $size);
     $transfer = TeamSpeak3::factory("filetransfer://" . $upload["host"] . ":" . $upload["port"]);
     $transfer->upload($upload["ftkey"], $upload["seekpos"], $data);
     return $crc;
 }
    $extension_openssl_text = $extension_openssl ? "Yes" : "No";
    $extension_simplexml = function_exists('simplexml_load_string');
    $extension_simplexml_color = $extension_simplexml ? "green" : "red";
    $extension_simplexml_text = $extension_simplexml ? "Yes" : "No";
    $mod_automod = version_compare($config['automod_version'], '1.0.2', '>=') ? true : false;
    $mod_automod_color = $mod_automod ? "green" : "red";
    $mod_automod_text = $mod_automod ? "Yes" : "No";
    // TeamSpeak stuff
    try {
        $nickname = "TeamSpeakDebugGuy";
        $testMessage = "Awesome, TeamSpeak integration is working!";
        $errorCode = 0;
        $errorMsg = "No errors found!";
        $teamspeak_UID_color = !empty($user->data['eveapi_ts']) ? "green" : "red";
        $teamspeak_UID_text = !empty($user->data['eveapi_ts']) ? $user->data['eveapi_ts'] : "Unknown";
        $ts3_VirtualServer = TeamSpeak3::factory("serverquery://" . $config["eveapi_ts_username"] . ":" . $config["eveapi_ts_password"] . "@" . $config["eveapi_ts_ip"] . ":" . $config["eveapi_ts_port_query"] . "/?server_port=" . $config["eveapi_ts_port_server"] . "&nickname=" . $nickname);
        $ts3_VirtualServer->clientGetByUid($user->data['eveapi_ts'])->poke($testMessage);
    } catch (Exception $e) {
        $errorCode = $e->getCode();
        $errorMsg = $e->getMessage();
    }
    $error_color = $errorCode == 0 ? "green" : "red";
    ?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" xml:lang="en-gb" lang="en-gb">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <meta http-equiv="Content-Style-Type" content="text/css">
    <meta http-equiv="Content-Language" content="en-gb">
    
Ejemplo n.º 12
0
<?php

// load framework files
require_once "libraries/TeamSpeak3/TeamSpeak3.php";
// connect to local server, authenticate and spawn an object for the virtual server on port 9987
$ts3_VirtualServer = TeamSpeak3::factory("serverquery://*****:*****@ts3.fatalaggressionboss.com:10011/?server_port=9987");
// build and display HTML treeview using custom image paths (remote icons will be embedded using data URI sheme)
#echo $ts3_VirtualServer->getViewer(new TeamSpeak3_Viewer_Html("images/icons/", "images/flags/", "data:image"));
echo $ts3_VirtualServer->getViewer(new TeamSpeak3_Viewer_Html());
Ejemplo n.º 13
0
 * along with this program. If not, see <http://www.gnu.org/licenses/>
 */
header("Content-type: text/xml; charset=utf-8");
// Errors destroy the xmlvalidity
//error_reporting(0);
require_once "include/app.config.php";
require_once "../include/calladmin_helpers.php";
require_once "include/TeamSpeak3/TeamSpeak3.php";
$helpers = new CallAdmin_Helpers();
// Key set and no key given or key is wrong
if (!isset($_GET['key']) || !$helpers->keyToServerKeys($access_keys, $_GET['key'])) {
    $helpers->printXmlError("APP_AUTH_FAILURE", "CallAdmin_Ts3");
}
$ts3 = new TeamSpeak3();
try {
    $ts3_VirtualServer = TeamSpeak3::factory("serverquery://" . $user . ":" . $password . "@" . $host . ":" . $queryport . "/?server_port=" . $port);
    $count = 0;
    $uid = "";
    //$name = "";
    foreach ($ts3_VirtualServer->clientList() as $ts3_Client) {
        $uid = (string) $ts3_Client['client_unique_identifier'];
        //$name = (string)$ts3_Client['client_nickname'];
        // Is listed as admin, add him to the count
        if (in_array($uid, $access_keys[$_GET['key']])) {
            $count++;
        }
    }
} catch (TeamSpeak3_Adapter_ServerQuery_Exception $e) {
    // Nope
    $helpers->printXmlError($e->getMessage(), "CallAdmin_Ts3");
}
Ejemplo n.º 14
0
<?php

try {
    require_once "../libraries/TeamSpeak3/TeamSpeak3.php";
    include '../data/config.php';
    echo "Conectando al servidor TeamSpeak</br>";
    $connect = "serverquery://" . $USER_QUERY . ":" . $PASS_QUERY . "@" . $HOST_QUERY . ":" . $PORT_QUERY . "/?server_port=" . $SERVER_PORT . "";
    $ts3_VirtualServer = TeamSpeak3::factory($connect);
    // Conseguimos array con los grupos
    $server_groups = $ts3_VirtualServer->serverGroupList();
    $servergroups = array();
    foreach ($server_groups as $group) {
        if ($group->type != 1) {
            continue;
        }
        if (in_array($group["sortid"], $SID_GROUP)) {
            $servergroups[] = array('name' => (string) $group, 'id' => $group->sgid, 'type' => $group->type, 'icon' => $group->iconDownload());
        }
    }
    echo "Iniciando Descarga de iconos...</br>";
    // Iteramos por grupo para guardar a archivo
    foreach ($servergroups as $group) {
        // ya estaba descargada la wea xD
        file_put_contents("./icons/" . $group['id'] . ".png", $group['icon']);
        echo "Archivo iconos/icons/" . $group['id'] . ".png" . " Creado para el grupo " . $group['name'] . "<br>";
    }
} catch (Exception $e) {
    if ($DEBUG == True) {
        //print_r($e);
        echo "[DEBUG] Ha ocurrido un error inesperado <br>";
        echo "[DEBUG] Mensaje de error DEBUG: " . $e->getMessage() . "<br>";
Ejemplo n.º 15
0
 /**
  * Downloads and returns the clients avatar file content.
  *
  * @return TeamSpeak3_Helper_String
  */
 public function avatarDownload()
 {
     if ($this["client_flag_avatar"] == 0) {
         return;
     }
     $download = $this->getParent()->transferInitDownload($this->getId(), 0, $this->avatarGetName());
     $transfer = TeamSpeak3::factory("filetransfer://" . $this->getParent()->getAdapterHost() . ":" . $download["port"]);
     return $transfer->download($download["ftkey"], $download["size"]);
 }
Ejemplo n.º 16
0
require 'app/Infos.php';
require 'app/Keys.php';
require 'inc/db.php';
if (!isset($_SESSION['auth'])) {
    header('Location: login.php');
    exit;
}
$verify = new \App\Verify($cnx);
$verify->checkIndex($_SESSION['auth']['pseudo']);
$infos = new \App\Infos($cnx);
$port = $infos->getPort($_SESSION['auth']['pseudo']);
try {
    /* 
      CHANGE THIS LINE WITH YOUR TS3 QUERY INFOS
    */
    $ts3_VirtualServer = TeamSpeak3::factory("serverquery://*****:*****@127.0.0.1:10011/?server_port=" . $port);
} catch (Exception $e) {
    $_SESSION['flash']['danger'] = "Error your TS3 server is offline please contact admin to solve this error";
    $offline = true;
    header('Location: offline.php');
    exit;
}
$keys = new \App\Keys($ts3_VirtualServer);
$map = $ts3_VirtualServer->getViewer(new TeamSpeak3_Viewer_Html("images/viewer/", "images/countryflags/", "data:image"));
if (isset($_GET) && !empty($_GET['key'])) {
    $keys->generate($_GET['key']);
}
?>
 
  <body class="hold-transition skin-red layout-boxed">
    <div class="wrapper">
Ejemplo n.º 17
0
    function main($id, $mode)
    {
        global $config, $db, $user, $auth, $template, $phpbb_root_path, $phpEx;
        $submit = !empty($_POST['submit']) ? true : false;
        $error = $data = array();
        $s_hidden_fields = '';
        $user->add_lang('mods/info_acp_eveapi');
        switch ($mode) {
            case 'register_account':
                $this->tpl_name = 'ucp_eveapi_account';
                $this->page_title = 'UCP_EVEAPI_ACCOUNT';
                $data = array('username' => utf8_normalize_nfc(request_var('username', $user->data['username'], true)), 'eveapi_keyid' => request_var('eveapi_keyid', $user->data['eveapi_keyid'], true), 'eveapi_vcode' => request_var('eveapi_vcode', $user->data['eveapi_vcode'], true));
                if ($submit) {
                    $check_ary = array('eveapi_keyid' => array(array('string', false, 1, 15)), 'eveapi_vcode' => array(array('string', false, 64, 64)));
                    if ($auth->acl_get('u_chgname') && $config['allow_namechange']) {
                        $check_ary['username'] = array(array('string', false, $config['min_name_chars'], $config['max_name_chars']), array('username'));
                    }
                    $error = validate_data($data, $check_ary);
                    if (!sizeof($error) && $config['eveapi_validation']) {
                        if (!$auth->acl_get('u_chgname') || !$config['allow_namechange']) {
                            $data['username'] = $user->data['username'];
                        }
                        $eveapi_teamSpeakGroups = array();
                        $characterInfo = eveapi_checkThisCharacter($data['eveapi_keyid'], $data['eveapi_vcode'], $data['username']);
                        if (empty($characterInfo["error"])) {
                            if (!empty($characterInfo["forumGroups"]) || empty($characterInfo["forumGroups"]) && $config['eveapi_nonmember']) {
                                $eveapi_forumGroups = $characterInfo["forumGroups"];
                                $eveapi_teamSpeakGroups = $characterInfo["TSGroups"];
                                $extraGroups = eveapi_setForumGroups($user->data['user_id'], $eveapi_forumGroups, $data['username']);
                                if ($config['eveapi_jabber_masterswitch']) {
                                    if ($config['eveapi_ejabber_switch']) {
                                        eveapi_setJabberAccess($user->data['user_id'], $characterInfo['jabber'], $extraGroups['jabber'], $data['username']);
                                    }
                                    if ($config['eveapi_openfire_switch']) {
                                        eveapi_setOpenFireAccess($user->data['user_id'], $characterInfo['openfire'], $extraGroups['openfire'], $data['username']);
                                    }
                                }
                            } else {
                                $error[] = 'This character is not permitted to have an account on this forum.';
                            }
                        } else {
                            $error = array_merge($error, $characterInfo["error"]);
                        }
                    }
                    $sql_ary = array('user_character_id' => isset($characterInfo["info"]["characterId"]) ? (int) $characterInfo["info"]["characterId"] : 0, 'username' => $auth->acl_get('u_chgname') && $config['allow_namechange'] ? $data['username'] : $user->data['username'], 'username_clean' => $auth->acl_get('u_chgname') && $config['allow_namechange'] ? utf8_clean_string($data['username']) : $user->data['username_clean'], 'eveapi_keyid' => $data['eveapi_keyid'], 'eveapi_vcode' => $data['eveapi_vcode']);
                    if ($auth->acl_get('u_chgname') && $config['allow_namechange'] && $data['username'] != $user->data['username']) {
                        add_log('user', $user->data['user_id'], 'LOG_USER_UPDATE_NAME', $user->data['username'], $data['username']);
                    }
                    if ($data['eveapi_keyid'] != $user->data['eveapi_keyid'] || $data['eveapi_vcode'] != $user->data['eveapi_vcode']) {
                        add_log('user', $user->data['user_id'], 'User has updated his/her EVE API information.', $user->data['username'], $data['eveapi_keyid'] . " -> " . $data['eveapi_vcode']);
                    }
                    $message = 'EVEAPI_UPDATED';
                    if (sizeof($sql_ary)) {
                        $sql = 'UPDATE ' . USERS_TABLE . '
							SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
							WHERE user_id = ' . $user->data['user_id'];
                        $db->sql_query($sql);
                    }
                }
                $template->assign_vars(array('ERROR' => sizeof($error) ? implode('<br />', $error) : '', 'USERNAME' => $data['username'], 'EVEAPI_KEYID' => $data['eveapi_keyid'], 'EVEAPI_VCODE' => $data['eveapi_vcode'], 'EVEAPI_ACCESSMASK' => eveapi_getAccessMask(), 'L_USERNAME_EXPLAIN' => sprintf($user->lang[$config['allow_name_chars'] . '_EXPLAIN'], $config['min_name_chars'], $config['max_name_chars']), 'L_TITLE' => $user->lang['UCP_EVEAPI_ACCOUNT'], 'S_EVEAPI_VALIDATE' => $config['eveapi_validation'] ? true : false, 'S_CHANGE_USERNAME' => $config['allow_namechange'] && $auth->acl_get('u_chgname') ? true : false));
                break;
            case 'register_jabber':
                $this->tpl_name = 'ucp_eveapi_jabber';
                $this->page_title = 'UCP_EVEAPI_JABBER';
                if (!$config['eveapi_openfire_switch'] && !$config['eveapi_jabber_masterswitch'] || empty($user->data["eveapi_keyid"]) || empty($user->data["eveapi_vcode"])) {
                    $template->assign_vars(array('L_TITLE' => $user->lang['UCP_EVEAPI_JABBER'], 'L_DISABLED' => $user->lang['EVEAPI_JABBER_DISABLED']));
                    break;
                }
                if ($submit) {
                    $characterInfo = eveapi_checkThisCharacter($user->data['eveapi_keyid'], $user->data['eveapi_vcode'], $user->data['username']);
                    if (empty($characterInfo["error"]) && (!empty($characterInfo["forumGroups"]) || empty($characterInfo["forumGroups"]) && $config['eveapi_nonmember'])) {
                        $eveapi_forumGroups = $characterInfo["forumGroups"];
                        $extraGroups = eveapi_setForumGroups($user->data['user_id'], $eveapi_forumGroups, $user->data['username']);
                        $password = eveapi_randomString(8);
                        $result = eveapi_setOpenFireAccess($user->data['user_id'], $characterInfo['openfire'], $extraGroups['openfire'], $user->data['username'], $password);
                        if ($result) {
                            $user->data['user_jabber_password'] = $password;
                        } else {
                            $error[] = $user->lang['JABBER_REGISTRATION_FAILED'];
                        }
                    }
                }
                $clean_username = str_replace(array(" ", "'"), array("_", "_"), $user->data['username']);
                $template->assign_vars(array('ERROR' => sizeof($error) ? implode('<br />', $error) : '', 'JABBER_USERNAME' => $clean_username, 'JABBER_PASSWORD' => $user->data['user_jabber_password'], 'JABBER_HOST' => 'almostawesome.org', 'L_TITLE' => $user->lang['UCP_EVEAPI_JABBER'], 'L_JABBER' => $user->lang['EVEAPI_JABBER_REGISTER'], 'L_JABBER_EXPLAIN' => $user->lang['EVEAPI_JABBER_EXPLAIN'], 'L_JABBER_USERNAME' => $user->lang['EVEAPI_JABBER_USERNAME'], 'L_JABBER_PASSWORD' => $user->lang['EVEAPI_JABBER_PASSWORD'], 'L_JABBER_HOST' => $user->lang['EVEAPI_JABBER_HOST'], 'L_CHANGE_REGISTER' => empty($user->data['user_jabber_password']) ? $user->lang['REGISTER'] : $user->lang['EVEAPI_JABBER_CHANGE_PASSWORD']));
                break;
            case 'register_ts':
                $this->tpl_name = 'ucp_eveapi_ts';
                $this->page_title = 'UCP_EVEAPI_TS';
                if (!$config['eveapi_ts_masterswitch']) {
                    $template->assign_vars(array('L_TITLE' => $user->lang['UCP_EVEAPI_TS'], 'L_DISABLED' => $user->lang['EVEAPI_TEAMSPEAK_DISABLED']));
                    break;
                }
                if ($submit) {
                    try {
                        $nickname = $config['eveapi_ts_nickname'];
                        if (eveapi_validateMixedalphanumeric($nickname) != 1) {
                            $nickname = "Cyerus";
                        }
                        $ts3_VirtualServer = TeamSpeak3::factory("serverquery://" . $config["eveapi_ts_username"] . ":" . $config["eveapi_ts_password"] . "@" . $config["eveapi_ts_ip"] . ":" . $config["eveapi_ts_port_query"] . "/?server_port=" . $config["eveapi_ts_port_server"] . "&nickname=" . $nickname);
                    } catch (Exception $e) {
                        $error[] = $user->lang['TEAMSPEAK_CONNECTION_FAILED'];
                    }
                    $eveapi_ts = eveapi_getTeamSpeakUID($user->data['username'], $ts3_VirtualServer);
                    if (empty($eveapi_ts)) {
                        $error[] = $user->lang['TEAMSPEAK_USERNAME_NOT_FOUND'];
                    } else {
                        if (empty($user->data["eveapi_keyid"]) || empty($user->data["eveapi_vcode"])) {
                            $error[] = $user->lang['TEAMSPEAK_NO_API'];
                        } else {
                            $sql_ary = array('eveapi_ts' => $eveapi_ts);
                            $eveapi_teamSpeakGroups = array();
                            $characterInfo = eveapi_checkThisCharacter($user->data['eveapi_keyid'], $user->data['eveapi_vcode'], $user->data['username']);
                            if (empty($characterInfo["error"]) && (!empty($characterInfo["forumGroups"]) || empty($characterInfo["forumGroups"]) && $config['eveapi_nonmember'])) {
                                $eveapi_forumGroups = $characterInfo["forumGroups"];
                                $eveapi_teamSpeakGroups = $characterInfo["TSGroups"];
                                $extraGroups = eveapi_setForumGroups($user->data['user_id'], $eveapi_forumGroups, $user->data['username']);
                                if ($eveapi_ts != $user->data['eveapi_ts'] && !empty($user->data['eveapi_ts'])) {
                                    eveapi_setTeamSpeakGroups($user->data['eveapi_ts'], array(), $user->data['username']);
                                }
                                if ($eveapi_ts != "") {
                                    $TSverify = eveapi_setTeamSpeakGroups($eveapi_ts, $eveapi_teamSpeakGroups, $user->data['username'], $ts3_VirtualServer, $extraGroups["TS"]);
                                    if ($TSverify !== true) {
                                        $error[] = $TSverify;
                                        $sql_ary['eveapi_ts'] = $eveapi_ts = "";
                                    }
                                }
                                $user->data['eveapi_ts'] = $eveapi_ts;
                            }
                            $sql = 'UPDATE ' . USERS_TABLE . '
  							SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
  							WHERE user_id = ' . $user->data['user_id'];
                            $db->sql_query($sql);
                        }
                    }
                }
                $username = $user->data['username'];
                if (strlen($username) > 30) {
                    $username = substr($username, 0, 30);
                }
                $template->assign_vars(array('ERROR' => sizeof($error) ? implode('<br />', $error) : '', 'USERNAME' => $username, 'EVEAPI_TS' => empty($user->data['eveapi_ts']) ? $user->lang['EVEAPI_TEAMSPEAK_UID_EMPTY'] : $user->data['eveapi_ts'], 'L_TITLE' => $user->lang['UCP_EVEAPI_TS'], 'L_TEAMSPEAK' => $user->lang['EVEAPI_TEAMSPEAK_REGISTER'], 'L_TEAMSPEAK_EXPLAIN' => $user->lang['EVEAPI_TEAMSPEAK_EXPLAIN'], 'L_TEAMSPEAK_USERNAME' => $user->lang['EVEAPI_TEAMSPEAK_USERNAME'], 'L_TEAMSPEAK_UID' => $user->lang['EVEAPI_TEAMSPEAK_UID']));
                break;
        }
        $template->assign_vars(array('S_HIDDEN_FIELDS' => $s_hidden_fields, 'S_UCP_ACTION' => $this->u_action));
    }
<?php

require_once "TeamSpeak3.php";
include 'config.php';
error_reporting(0);
$ChannelName = $_POST['name'];
$idUnica = $_POST['idts'];
if (!$ChannelName || !$idUnica) {
    echo "El nombre del channel y la ID unica tienen que estar";
    exit;
}
$ts3_VirtualServer = TeamSpeak3::factory("serverquery://" . $UserAdmin . ":" . $PWQuery . "@" . $IP_TS . ":" . $PuertoQuery . "/?server_port=" . $PuertoTS . "");
$ListaDeChannels = $ts3_VirtualServer->request("channellist")->toString();
if (strpos($ListaDeChannels, $ChannelName)) {
    echo "El nombre del channel esta en uso, utiliza otro";
    exit;
}
$clID = $ts3_VirtualServer->clientGetByUid($idUnica);
$top_cid = $ts3_VirtualServer->channelCreate(array("channel_name" => $ChannelName, "channel_codec" => TeamSpeak3::CODEC_SPEEX_WIDEBAND, "channel_flag_permanent" => TRUE));
$clID = $ts3_VirtualServer->clientGetByUid($idUnica);
$infoCliente = $ts3_VirtualServer->execute("clientgetnamefromuid", array("cluid" => $idUnica))->toList();
$cldbid = strval($infoCliente['cldbid']);
$ts3_VirtualServer->execute("clientmove", array("clid" => $clID, "cid" => $top_cid));
$ts3_VirtualServer->execute("setclientchannelgroup", array("cldbid" => $cldbid, "cid" => $top_cid, "cgid" => '5'));
echo "El channel se creo correctamente.";
Ejemplo n.º 19
0
<?php

$starttime = microtime(true);
require_once 'config.php';
require_once 'lang.php';
require_once 'ts3_lib/TeamSpeak3.php';
try {
    $ts3_ServerInstance = TeamSpeak3::factory("serverquery://" . $cfg["user"] . ":" . $cfg["pass"] . "@" . $cfg["host"] . ":" . $cfg["query"] . "/");
    $ts3_VirtualServer = TeamSpeak3::factory("serverquery://" . $cfg["user"] . ":" . $cfg["pass"] . "@" . $cfg["host"] . ":" . $cfg["query"] . "/?server_port=" . $cfg["voice"]);
    require_once 'mysql_connect.php';
    try {
        $ts3_VirtualServer->selfUpdate(array('client_nickname' => $queryname));
    } catch (Exception $e) {
        try {
            $ts3_VirtualServer->selfUpdate(array('client_nickname' => $queryname2));
        } catch (Exception $e) {
            echo $lang['error'] . $e->getCode() . ': ' . $e->getMessage();
        }
    }
    $todaydate = time();
    $icontime = $todaydate - $warntime;
    $tschanarr = $ts3_VirtualServer->channelList();
    foreach ($tschanarr as $channel) {
        $tscid[] = $channel['cid'];
    }
    if ($deleteicons == 1) {
        echo $lang['hldelicon'] . PHP_EOL;
        $count = 0;
        foreach ($tschanarr as $channel) {
            $channelid = $channel['cid'];
            $checkicon = $ts3_VirtualServer->channelPermList($channelid, $permsid = FALSE);
Ejemplo n.º 20
0
										 
								\==========================================/
*/
require_once "libraries/TeamSpeak3/TeamSpeak3.php";
try {
    // هنا الاتصال بالسيرفر وكذا عرفت
    $config = array();
    $config['teamspeakip'] = 'localhost';
    $config['QueryName'] = 'serveradmin';
    $config['QueryPass'] = '';
    $config['QueryPort'] = '';
    $config['PortServer'] = '';
    $config['GroupIDAdmin'] = '';
    $config['GroupIDactivated'] = '';
    $config['GroupIDnotactivated'] = '';
    $ts3_VirtualServer = TeamSpeak3::factory("serverquery://" . $config['QueryName'] . ":" . $config['QueryPass'] . "@" . $config['teamspeakip'] . ":" . $config['QueryPort'] . "/?server_port=" . $config['PortServer'] . "");
    // التعرف التلقائي
    foreach ($ts3_VirtualServer->clientList() as $cl) {
        if ($cl->getProperty('connection_client_ip') == $_SERVER['REMOTE_ADDR']) {
            header('Content-Type: image/png');
            // هذه نستعملها للتجارب في المتصفح نصيحة شيلها :)
            header('refresh: 3; url=');
            // نهاية الي تشيلة
            $_SESSION['ggids'] = explode(",", $cl["client_servergroups"]);
            if (in_array($config['GroupIDnotactivated'], $_SESSION['ggids'])) {
                $image_file = 'banner_notactivated.png';
            } else {
                if (in_array($config['GroupIDactivated'], $_SESSION['ggids'])) {
                    $image_file = 'banner_activated.png';
                } else {
                    if (in_array($config['GroupIDAdmin'], $_SESSION['ggids'])) {
Ejemplo n.º 21
0
 public function cron()
 {
     if (!function_exists('user_delete')) {
         include $phpbb_root_path . 'includes/functions_user.' . $phpEx;
     }
     $cronlog = new Logging();
     //cronlog("Starting");
     // This script will take a while.  We should disable max_execution_time.
     @ini_set('max_execution_time', 900);
     if ($config['eveapi_validation']) {
         // *******************************************************************
         // ** STANDINGS START ************************************************
         // *******************************************************************
         $characterID = 0;
         $standingsCharacterAPI = array();
         if ($config['eveapi_s_masterswitch'] && $config['eveapi_s_character'] && $config['eveapi_s_charactername'] != "") {
             $standingsCharacterAPI = eveapi_getStandingsCharacterAPI();
             $pheal = new \Pheal\Pheal($standingsCharacterAPI['keyID'], $standingsCharacterAPI['vCode']);
             try {
                 $result = $pheal->accountScope->APIKeyInfo();
                 if ($result->key->accessMask & 16 && ($result->key->type == "Character" || $result->key->type == "Account")) {
                     foreach ($result->key->characters as $character) {
                         if (strtolower($character->characterName) == strtolower($standingsCharacterAPI['characterName'])) {
                             $characterID = $character->characterID;
                             $characterName = $character->characterName;
                         }
                     }
                 } else {
                     cronlog("Wrong accessMask", "Standings Character -> " . $standingsCharacterAPI['characterName']);
                 }
             } catch (\Pheal\Exceptions\PhealHTTPException $e) {
                 // HTTP error
                 cronlog('EVE API HTTP error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
             } catch (\Pheal\Exceptions\PhealAPIException $e) {
                 // API error
                 cronlog('EVE API Key error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
             } catch (\Pheal\Exceptions\PhealConnectionException $e) {
                 // Connection error
                 cronlog('EVE API Connection error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
             } catch (\Pheal\Exceptions\PhealException $e) {
                 // Any other error, in other words "Unknown error"
                 cronlog('EVE API Generic error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
             } catch (Exception $e) {
                 // Any other error, in other words "Unknown error"
                 cronlog('EVE API Generic error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
             }
             if ($characterID > 0) {
                 try {
                     $result = $pheal->charScope->contactList(array("characterID" => $characterID));
                     //cronlog("Removing old Character-level standings");
                     $db->sql_query('DELETE FROM ' . TBL_EVEAPI_STANDINGS . ' WHERE standingsType = ' . EVEAPI_STANDINGSTYPE_CHARACTER);
                     foreach ($result->contactList as $contact) {
                         if ($contact->contactID < 10000000) {
                             continue;
                         }
                         // Filter out NPCs (agents)
                         if ($contact->standing != -10 && $contact->standing != -5 && $contact->standing != 0 && $contact->standing != 5 && $contact->standing != 10) {
                             continue;
                         }
                         $sql = 'INSERT INTO ' . TBL_EVEAPI_STANDINGS . ' ' . $db->sql_build_array('INSERT', array("standingsName" => $contact->contactName, "standingsAmount" => $contact->standing, "standingsType" => EVEAPI_STANDINGSTYPE_CHARACTER));
                         $db->sql_query($sql);
                     }
                     //cronlog("New Character-level standings successfully imported!", "Standings Character -> " . $standingsCharacterAPI['characterName']);
                 } catch (\Pheal\Exceptions\PhealHTTPException $e) {
                     // HTTP error
                     cronlog('EVE API HTTP error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
                 } catch (\Pheal\Exceptions\PhealAPIException $e) {
                     // API error
                     cronlog('EVE API Key error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
                 } catch (\Pheal\Exceptions\PhealConnectionException $e) {
                     // Connection error
                     cronlog('EVE API Connection error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
                 } catch (\Pheal\Exceptions\PhealException $e) {
                     // Any other error, in other words "Unknown error"
                     cronlog('EVE API Generic error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
                 } catch (Exception $e) {
                     // Any other error, in other words "Unknown error"
                     cronlog('EVE API Generic error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
                 }
             }
         }
         $characterID = 0;
         if ($config['eveapi_s_masterswitch'] && ($config['eveapi_s_corporation'] || $config['eveapi_s_alliance']) && $config['eveapi_s_charactername'] != "" && $config['eveapi_s_corp_keyid'] > 0 && $config['eveapi_s_corp_vcode'] != "") {
             if (empty($standingsCharacterAPI)) {
                 $standingsCharacterAPI = eveapi_getStandingsCharacterAPI();
             }
             $pheal = new \Pheal\Pheal($config['eveapi_s_corp_keyid'], $config['eveapi_s_corp_vcode']);
             $characterID = 0;
             try {
                 $result = $pheal->accountScope->APIKeyInfo();
                 if ($result->key->accessMask & 16 && $result->key->type == "Corporation" && strtolower($result->key->characters[0]->characterName) == strtolower($standingsCharacterAPI['characterName'])) {
                     $characterID = $result->key->characters[0]->characterID;
                 } else {
                     cronlog("Wrong accessMask", "Standings Character -> " . $standingsCharacterAPI['characterName']);
                 }
             } catch (\Pheal\Exceptions\PhealHTTPException $e) {
                 // HTTP error
                 cronlog('EVE API HTTP error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
             } catch (\Pheal\Exceptions\PhealAPIException $e) {
                 // API error
                 cronlog('EVE API Key error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
             } catch (\Pheal\Exceptions\PhealConnectionException $e) {
                 // Connection error
                 cronlog('EVE API Connection error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
             } catch (\Pheal\Exceptions\PhealException $e) {
                 // Any other error, in other words "Unknown error"
                 cronlog('EVE API Generic error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
             } catch (Exception $e) {
                 // Any other error, in other words "Unknown error"
                 cronlog('EVE API Generic error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
             }
             if ($characterID > 0) {
                 try {
                     $result = $pheal->corpScope->contactList();
                     //cronlog("Removing old Corporation-level standings");
                     $db->sql_query('DELETE FROM ' . TBL_EVEAPI_STANDINGS . ' WHERE standingsType = ' . EVEAPI_STANDINGSTYPE_CORPORATION);
                     if ($config['eveapi_s_corporation']) {
                         foreach ($result->corporateContactList as $contact) {
                             if ($contact->standing != -10 && $contact->standing != -5 && $contact->standing != 0 && $contact->standing != 5 && $contact->standing != 10) {
                                 continue;
                             }
                             $sql = 'INSERT INTO ' . TBL_EVEAPI_STANDINGS . ' ' . $db->sql_build_array('INSERT', array("standingsName" => $contact->contactName, "standingsAmount" => $contact->standing, "standingsType" => EVEAPI_STANDINGSTYPE_CORPORATION));
                             $db->sql_query($sql);
                         }
                         //cronlog("New Corporation-level standings successfully imported!", "Standings Character -> " . $standingsCharacterAPI['characterName']);
                     }
                     //cronlog("Removing old Alliance-level standings");
                     $db->sql_query('DELETE FROM ' . TBL_EVEAPI_STANDINGS . ' WHERE standingsType = ' . EVEAPI_STANDINGSTYPE_ALLIANCE);
                     if ($config['eveapi_s_alliance']) {
                         foreach ($result->allianceContactList as $contact) {
                             if ($contact->standing != -10 && $contact->standing != -5 && $contact->standing != 0 && $contact->standing != 5 && $contact->standing != 10) {
                                 continue;
                             }
                             $sql = 'INSERT INTO ' . TBL_EVEAPI_STANDINGS . ' ' . $db->sql_build_array('INSERT', array("standingsName" => $contact->contactName, "standingsAmount" => $contact->standing, "standingsType" => EVEAPI_STANDINGSTYPE_ALLIANCE));
                             $db->sql_query($sql);
                         }
                         //cronlog("New Alliance-level standings successfully imported!", "Standings Character -> " . $standingsCharacterAPI['characterName']);
                     }
                 } catch (\Pheal\Exceptions\PhealHTTPException $e) {
                     // HTTP error
                     cronlog('EVE API HTTP error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
                 } catch (\Pheal\Exceptions\PhealAPIException $e) {
                     // API error
                     cronlog('EVE API Key error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
                 } catch (\Pheal\Exceptions\PhealConnectionException $e) {
                     // Connection error
                     cronlog('EVE API Connection error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
                 } catch (\Pheal\Exceptions\PhealException $e) {
                     // Any other error, in other words "Unknown error"
                     cronlog('EVE API Generic error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
                 } catch (Exception $e) {
                     // Any other error, in other words "Unknown error"
                     cronlog('EVE API Generic error: ' . $e->getCode() . ' -> ' . $e->getMessage(), "Standings Character -> " . $standingsCharacterAPI['characterName']);
                 }
             }
         }
         // *******************************************************************
         // ** STANDINGS END **************************************************
         // *******************************************************************
         // Get rid of old Jabber access
         //cronlog("Clearing ejabberd accesslist");
         $sql = 'DELETE FROM eveapi_jabber WHERE userID > 0 ';
         $db->sql_query($sql);
         // *******************************************************************
         // ** ACTUAL CRONJOB START *******************************************
         // *******************************************************************
         if ($config['eveapi_ts_masterswitch']) {
             $nickname = $config['eveapi_ts_nickname'];
             if (eveapi_validateMixedalphanumeric($nickname) != 1) {
                 $nickname = "Cyerus";
             }
             try {
                 $ts3_VirtualServer = TeamSpeak3::factory("serverquery://" . $config["eveapi_ts_username"] . ":" . $config["eveapi_ts_password"] . "@" . $config["eveapi_ts_ip"] . ":" . $config["eveapi_ts_port_query"] . "/?server_port=" . $config["eveapi_ts_port_server"] . "&nickname=" . $nickname);
             } catch (TeamSpeak3_Exception $e) {
                 cronlog('TeamSpeak error: ' . $e->getCode() . ' -> ' . $e->getMessage());
                 $ts3_VirtualServer = false;
             }
         }
         if ($config['eveapi_ts_masterswitch'] && $ts3_VirtualServer || $config['eveapi_jabber_masterswitch']) {
             $sql = 'SELECT user_id, username, eveapi_keyid, eveapi_vcode, eveapi_ts
             FROM ' . USERS_TABLE . '
             WHERE user_type = 0
             ORDER BY username';
             $result = $db->sql_query($sql);
             while ($row = $db->sql_fetchrow($result)) {
                 if (!empty($row["eveapi_keyid"]) && !empty($row["eveapi_vcode"])) {
                     try {
                         $characterInfo = eveapi_checkThisCharacter($row['eveapi_keyid'], $row['eveapi_vcode'], $row['username']);
                         if (empty($characterInfo["error"])) {
                             $eveapi_forumGroups = array();
                             $eveapi_TSGroups = array();
                             $sql = "UPDATE " . USERS_TABLE . "\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tSET user_character_id = '" . (int) $characterInfo["info"]["characterId"] . "'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE user_id = " . (int) $row['user_id'];
                             $db->sql_query($sql);
                             if (!empty($characterInfo["forumGroups"]) || empty($characterInfo["forumGroups"]) && $config['eveapi_nonmember']) {
                                 $eveapi_forumGroups = $characterInfo["forumGroups"];
                                 $eveapi_TSGroups = $characterInfo["TSGroups"];
                                 $extraGroups = eveapi_setForumGroups($row['user_id'], $eveapi_forumGroups, $row['username']);
                                 if ($config['eveapi_ts_masterswitch'] && !empty($row['eveapi_ts'])) {
                                     eveapi_setTeamSpeakGroups($row['eveapi_ts'], $eveapi_TSGroups, $row['username'], $ts3_VirtualServer, $extraGroups["TS"]);
                                 }
                                 if ($config['eveapi_jabber_masterswitch']) {
                                     if ($config['eveapi_ejabber_switch']) {
                                         eveapi_setJabberAccess($row['user_id'], $characterInfo['jabber'], $extraGroups['jabber'], $row['username']);
                                     }
                                     if ($config['eveapi_openfire_switch']) {
                                         eveapi_setOpenFireAccess($row['user_id'], $characterInfo['openfire'], $extraGroups['openfire'], $row['username']);
                                     }
                                 }
                             } else {
                                 // no valid forumgroups found, probably meaning the user isn't part of any entity and should be disabled
                                 eveapi_disableForumAccount($row['user_id'], $row['username'], $row['eveapi_ts'], INACTIVE_EVEAPI_NONMEMBER, $ts3_VirtualServer);
                             }
                         } else {
                             // error reported by eveapi_checkThisCharacter(), now use $characterInfo["disable"] to determine whether or not to disable.
                             if ($characterInfo["disable"]) {
                                 eveapi_disableForumAccount($row['user_id'], $row['username'], $row['eveapi_ts'], INACTIVE_EVEAPI_INVALID, $ts3_VirtualServer);
                             }
                         }
                     } catch (\Pheal\Exceptions\PhealHTTPException $e) {
                         // HTTP error
                         cronlog('EVE API HTTP error: ' . $e->getCode() . ' -> ' . $e->getMessage(), $row['username']);
                     } catch (\Pheal\Exceptions\PhealAPIException $e) {
                         // API error
                         cronlog('EVE API Key error: ' . $e->getCode() . ' -> ' . $e->getMessage(), $row['username']);
                     } catch (\Pheal\Exceptions\PhealConnectionException $e) {
                         // Connection error
                         cronlog('EVE API Connection error: ' . $e->getCode() . ' -> ' . $e->getMessage(), $row['username']);
                     } catch (\Pheal\Exceptions\PhealException $e) {
                         // Any other error, in other words "Unknown error"
                         cronlog('EVE API Generic error: ' . $e->getCode() . ' -> ' . $e->getMessage(), $row['username']);
                     } catch (Exception $e) {
                         // Any other error, in other words "Unknown error"
                         cronlog('EVE API Generic error: ' . $e->getCode() . ' -> ' . $e->getMessage(), $row['username']);
                     }
                 } else {
                     // Disable user, no valid API information found!
                     eveapi_disableForumAccount($row['user_id'], $row['username'], $row['eveapi_ts'], INACTIVE_EVEAPI_INVALID, $ts3_VirtualServer);
                 }
             }
             $db->sql_freeresult($result);
         } else {
             cronlog("Quiting the cronjob, as no connection to the TeamSpeak 3 server could be made while TeamSpeak 3 Integration is enabled.");
         }
         // *******************************************************************
         // ** ACTUAL CRONJOB END *********************************************
         // *******************************************************************
     }
     cronlog("Finished Successfully");
 }
Ejemplo n.º 22
0
<?php

session_start();
$starttime = microtime(true);
require_once '../other/config.php';
require_once '../ts3_lib/TeamSpeak3.php';
require_once '../lang.php';
require_once '../other/session.php';
if (!isset($_SESSION['tsuid']) && !isset($_SESSION['tserror'])) {
    try {
        $ts3 = TeamSpeak3::factory("serverquery://" . $ts['user'] . ":" . $ts['pass'] . "@" . $ts['host'] . ":" . $ts['query'] . "/?server_port=" . $ts['voice']);
        if (strlen($queryname) > 27) {
            $queryname = substr($queryname, 0, -3) . '_st';
        } else {
            $queryname = $queryname . '_st';
        }
        if (strlen($queryname2) > 26) {
            $queryname2 = substr($queryname2, 0, -4) . '_st2';
        } else {
            $queryname2 = $queryname2 . '_st2';
        }
        if ($slowmode == 1) {
            sleep(1);
        }
        try {
            $ts3->selfUpdate(array('client_nickname' => $queryname));
        } catch (Exception $e) {
            if ($slowmode == 1) {
                sleep(1);
            }
            try {
Ejemplo n.º 23
0
<?php
$nickdoboot = rand(0, 99);
$espaco = rand(0, 99999);
//error_reporting(E_ALL);
//ini_set('display_errors', 1);
require_once("libraries/TeamSpeak3/TeamSpeak3.php");
if($_COOKIE["config90909982930461"]==""){
$ts3_VirtualServer = TeamSpeak3::factory("serverquery://*****:*****@XXXX:XXXX/?server_port=9987&nickname=www.CLANPUTOS.com_Canal$nickdoboot");
$grupo_do_ca = 89;

$nome_canal        = $_POST['canal'];
$pass_canal        = $_POST['senha'];



$top_cid = $ts3_VirtualServer->channelCreate(array(
	"channel_name"          => "[cspacer]$nome_canal",
	"channel_topic" 			=> "ESSE CANAL SERÁ APAGADO SE FICAR INATIVO POR MAIS DE 10 DIAS",
	"channel_codec"          => TeamSpeak3::CODEC_SPEEX_ULTRAWIDEBAND,
	"channel_codec_quality"  => 0x08,
	"channel_flag_permanent" => TRUE,
	"channel_password" => "$pass_canal",
	"channel_flag_maxclients_unlimited" => 0,
	"channel_order"          => 4400,
));

$sub_cid = $ts3_VirtualServer->channelCreate(array(
	"channel_name" => "Sala 1",
	"channel_topic" => "ESSE CANAL SERÁ APAGADO SE FICAR INATIVO POR MAIS DE 10 DIAS",
	"channel_codec"          => TeamSpeak3::CODEC_SPEEX_ULTRAWIDEBAND,
	"channel_flag_permanent" => TRUE,
Ejemplo n.º 24
0
        // Disabled
        $twitter = '';
    } else {
        // Enabled
        $twitter = '<a class="twitter-timeline" data-dnt="true" href="' . htmlspecialchars($twitter_url[0]->value) . '"  data-widget-id="' . htmlspecialchars($twitter_feed_query[0]->value) . '">Tweets</a><script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],p=/^http:/.test(d.location)?\'http\':\'https\';if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=p+"://platform.twitter.com/widgets.js";fjs.parentNode.insertBefore(js,fjs);}}(document,"script","twitter-wjs");</script>';
    }
}
$smarty->assign('TWITTER_FEED', $twitter);
// Voice server module
$viewer = '';
if (isset($voice_server_enabled) && $voice_server_enabled == 'teamspeak') {
    // Teamspeak module
    require_once 'core/includes/TeamSpeak3/TeamSpeak3.php';
    try {
        // connect to local server, authenticate and spawn an object for the virtual server on a defined port
        $ts3_VirtualServer = TeamSpeak3::factory('serverquery://' . $voice_server_username . ':' . $voice_server_password . '@' . $voice_server_ip . ':' . $voice_server_port . '/?server_port=' . $voice_virtual_server_port . '&nickname=Query');
        // build and display HTML treeview using custom image paths (remote icons will be embedded using data URI sheme)
        $viewer = $ts3_VirtualServer->getViewer(new TeamSpeak3_Viewer_Html("core/assets/img/ts3/viewer/", "core/assets/img/ts3/flags/", "data:image"));
    } catch (Exception $e) {
        $viewer = '<div class="alert alert-warning">' . $e->getMessage() . '</div>';
    }
}
$smarty->assign('VOICE_VIEWER_TITLE', 'TeamSpeak');
$smarty->assign('VOICE_VIEWER', $viewer);
$smarty->display('styles/templates/' . $template . '/index.tpl');
// Footer
require 'core/includes/template/footer.php';
$smarty->display('styles/templates/' . $template . '/footer.tpl');
// Scripts
require 'core/includes/template/scripts.php';
?>
Ejemplo n.º 25
0
 /**
  * Downloads and returns the channel groups icon file content.
  *
  * @return TeamSpeak3_Helper_String
  */
 public function iconDownload()
 {
     if ($this->iconIsLocal("iconid") || $this["iconid"] == 0) {
         return;
     }
     $download = $this->getParent()->transferInitDownload(rand(0x0, 0xffff), 0, $this->iconGetName("iconid"));
     $transfer = TeamSpeak3::factory("filetransfer://" . $download["host"] . ":" . $download["port"]);
     return $transfer->download($download["ftkey"], $download["size"]);
 }
Ejemplo n.º 26
0
 }
 $tsfilelist = $ts3->channelFileList($cid = "0", $cpw = "", $path = "/");
 $fsfilelist = opendir(substr(dirname(__FILE__), 0, -4) . 'other/avatars/');
 while (false !== ($fsfile = readdir($fsfilelist))) {
     if ($fsfile != '.' && $fsfile != '..') {
         $fsfilelistarray[$fsfile] = filemtime(substr(dirname(__FILE__), 0, -4) . 'other/avatars/' . $fsfile);
     }
 }
 foreach ($tsfilelist as $tsfile) {
     $fullfilename = '/' . $tsfile['name'];
     $uuidasbase16 = substr($tsfile['name'], 7);
     if (!isset($fsfilelistarray[$uuidasbase16]) || $tsfile['datetime'] > $fsfilelistarray[$uuidasbase16]) {
         if (substr($tsfile['name'], 0, 7) == 'avatar_') {
             try {
                 $avatar = $ts3->transferInitDownload($clientftfid = "5", $cid = "0", $name = $fullfilename, $cpw = "", $seekpos = 0);
                 $transfer = TeamSpeak3::factory("filetransfer://" . $avatar["host"] . ":" . $avatar["port"]);
                 $tsfile = $transfer->download($avatar["ftkey"], $avatar["size"]);
                 $avatarfilepath = substr(dirname(__FILE__), 0, -4) . 'other/avatars/' . $uuidasbase16;
                 echo 'Download avatar: ', $fullfilename, '<br>';
                 file_put_contents($avatarfilepath, $tsfile);
                 $count++;
             } catch (Exception $e) {
                 echo $lang['error'] . $e->getCode() . ': ' . $e->getMessage();
                 $sqlerr++;
             }
         }
     }
 }
 if ($count == 0) {
     echo 'Nothing to do.. All avatars already downloaded and are up to date<br>';
 }
Ejemplo n.º 27
0
 /**
  * Returns the HTML img tags which can be used to display the various icons for a
  * TeamSpeak_Node_Client object.
  *
  * @return string
  */
 protected function getSuffixIconClient()
 {
     $html = "";
     if ($this->currObj["client_is_priority_speaker"]) {
         $html .= $this->getImage("client_priority.png", "Priority Speaker");
     }
     if ($this->currObj["client_is_channel_commander"]) {
         $html .= $this->getImage("client_cc.png", "Channel Commander");
     }
     if ($this->currObj["client_is_talker"]) {
         $html .= $this->getImage("client_talker.png", "Talk Power granted");
     } elseif ($cntp = $this->currObj->getParent()->channelGetById($this->currObj["cid"])->channel_needed_talk_power) {
         if ($cntp > $this->currObj["client_talk_power"]) {
             $html .= $this->getImage("client_mic_muted.png", "Insufficient Talk Power");
         }
     }
     foreach ($this->currObj->memberOf() as $group) {
         if (!$group["iconid"]) {
             continue;
         }
         $type = $group instanceof TeamSpeak3_Node_Servergroup ? "Server Group" : "Channel Group";
         if (!$group->iconIsLocal("iconid") && $this->ftclient) {
             if (!isset($this->cacheIcon[$group["iconid"]])) {
                 $download = $group->getParent()->transferInitDownload(rand(0x0, 0xffff), 0, $group->iconGetName("iconid"));
                 if ($this->ftclient == "data:image") {
                     $download = TeamSpeak3::factory("filetransfer://" . $download["host"] . ":" . $download["port"])->download($download["ftkey"], $download["size"]);
                 }
                 $this->cacheIcon[$group["iconid"]] = $download;
             } else {
                 $download = $this->cacheIcon[$group["iconid"]];
             }
             if ($this->ftclient == "data:image") {
                 $html .= $this->getImage("data:" . TeamSpeak3_Helper_Convert::imageMimeType($download) . ";base64," . base64_encode($download), $group . " [" . $type . "]", null, FALSE);
             } else {
                 $html .= $this->getImage($this->ftclient . "?ftdata=" . base64_encode(serialize($download)), $group . " [" . $type . "]", null, FALSE);
             }
         } elseif (in_array($group["iconid"], $this->cachedIcons)) {
             $html .= $this->getImage("group_icon_" . $group["iconid"] . ".png", $group . " [" . $type . "]");
         }
     }
     if ($this->currObj["client_icon_id"]) {
         if (!$this->currObj->iconIsLocal("client_icon_id") && $this->ftclient) {
             if (!isset($this->cacheIcon[$this->currObj["client_icon_id"]])) {
                 $download = $this->currObj->getParent()->transferInitDownload(rand(0x0, 0xffff), 0, $this->currObj->iconGetName("client_icon_id"));
                 if ($this->ftclient == "data:image") {
                     $download = TeamSpeak3::factory("filetransfer://" . $download["host"] . ":" . $download["port"])->download($download["ftkey"], $download["size"]);
                 }
                 $this->cacheIcon[$this->currObj["client_icon_id"]] = $download;
             } else {
                 $download = $this->cacheIcon[$this->currObj["client_icon_id"]];
             }
             if ($this->ftclient == "data:image") {
                 $html .= $this->getImage("data:" . TeamSpeak3_Helper_Convert::imageMimeType($download) . ";base64," . base64_encode($download), "Client Icon", null, FALSE);
             } else {
                 $html .= $this->getImage($this->ftclient . "?ftdata=" . base64_encode(serialize($download)), "Client Icon", null, FALSE);
             }
         } elseif (in_array($this->currObj["client_icon_id"], $this->cachedIcons)) {
             $html .= $this->getImage("group_icon_" . $this->currObj["client_icon_id"] . ".png", "Client Icon");
         }
     }
     return $html;
 }
Ejemplo n.º 28
0
<?php

//init
require_once "libraries/ts3init.php";
$servers = $db->selectList($tbl . "_servers", "ID,name,address,usr,pw,query", "true", "ID");
$boxservers = array();
$vserverindex = -1;
foreach ($servers as $server_data) {
    try {
        $ts3_ServerInstance = TeamSpeak3::factory("serverquery://" . $server_data["usr"] . ":" . $server_data["pw"] . "@" . $server_data["address"] . ":" . $server_data["query"] . "/?use_offline_as_virtual=1");
        $servers_settings = $db->selectList($tbl . "_server_box", "`vserverid`,`join`", "`serverid`=" . $server_data["ID"] . " and `show`=1", "`vserverid`");
        foreach ($ts3_ServerInstance as $ts3_VirtualServer) {
            try {
                $try = $ts3_VirtualServer["virtualserver_name"];
                foreach ($servers_settings as $settings) {
                    if ($ts3_VirtualServer["virtualserver_id"] == $settings["vserverid"]) {
                        $vserverindex += 1;
                        $boxservers[$vserverindex] = array();
                        $boxservers[$vserverindex]["name"] = $ts3_VirtualServer["virtualserver_name"];
                        $boxservers[$vserverindex]["maxusers"] = $ts3_VirtualServer["virtualserver_maxclients"];
                        $boxservers[$vserverindex]["usersonline"] = $ts3_VirtualServer["virtualserver_clientsonline"];
                        $boxservers[$vserverindex]["join"] = $settings["join"];
                        $boxservers[$vserverindex]["joinlink"] = "ts3server://" . $server_data["address"] . ":" . $ts3_VirtualServer["virtualserver_port"];
                    }
                }
            } catch (Exception $e) {
            }
        }
    } catch (Exception $e) {
    }
}
/**
 * Sets character's TeamSpeak permissions
 */
function eveapi_setTeamSpeakGroups($tsUserUid, $tsGroupsNew, $characterName = "---", $ts3_VirtualServer = false, $extraTSgroups = array())
{
    global $db, $config;
    $tsGroups = array();
    if (!is_array($tsGroupsNew)) {
        $tsGroupsNew = array();
    }
    if (!empty($extraTSgroups)) {
        $tsGroupsNew = array_merge($tsGroupsNew, $extraTSgroups);
        if (!empty($tsGroupsNew)) {
            $tsGroupsNew = array_unique($tsGroupsNew);
        }
    }
    try {
        $nickname = $config['eveapi_ts_nickname'];
        if (eveapi_validateMixedalphanumeric($nickname) != 1) {
            $nickname = "Cyerus";
        }
        if (!$ts3_VirtualServer) {
            $ts3_VirtualServer = TeamSpeak3::factory("serverquery://" . $config["eveapi_ts_username"] . ":" . $config["eveapi_ts_password"] . "@" . $config["eveapi_ts_ip"] . ":" . $config["eveapi_ts_port_query"] . "/?server_port=" . $config["eveapi_ts_port_server"] . "&nickname=" . $nickname);
        }
        $tsClientDbId = $ts3_VirtualServer->clientFindDb($tsUserUid, true);
        foreach ($tsClientDbId as $tsCurrentDbId) {
            $tsClientGroups = $ts3_VirtualServer->clientGetServerGroupsByDbid($tsCurrentDbId);
            foreach ($tsClientGroups as $tsCurrentClientGroup) {
                $tsGroups[] = $tsCurrentClientGroup["sgid"];
            }
            foreach ($tsGroups as $currentTSGroup) {
                if (!in_array($currentTSGroup, $tsGroupsNew)) {
                    if ($currentTSGroup == 0) {
                        continue;
                    }
                    if ($currentTSGroup == $config['eveapi_ts_admin_tsgroup'] && $config['eveapi_ts_admin_switch']) {
                        continue;
                    }
                    $cont = false;
                    for ($i = 1; $i <= $config['eveapi_special_ts']; $i++) {
                        if (!isset($config['eveapi_ts_special_' . $i . '_tsgroup'])) {
                            continue;
                        }
                        if ($currentTSGroup == $config['eveapi_ts_special_' . $i . '_tsgroup'] && $config['eveapi_ts_special_' . $i . '_switch']) {
                            $cont = true;
                        }
                    }
                    if (!$cont) {
                        $groupInfo = $ts3_VirtualServer->serverGroupGetById($currentTSGroup);
                        if (!$groupInfo->savedb) {
                            continue;
                        }
                        cronlog("Removing user from TeamSpeak group -> " . $groupInfo->name, $characterName);
                        $ts3_VirtualServer->serverGroupClientDel($currentTSGroup, $tsCurrentDbId);
                    }
                }
            }
            foreach ($tsGroupsNew as $currentTSGroup) {
                if ($currentTSGroup == 0) {
                    continue;
                }
                $groupInfo = $ts3_VirtualServer->serverGroupGetById($currentTSGroup);
                if (!$groupInfo->savedb) {
                    continue;
                }
                if (!in_array($currentTSGroup, $tsGroups)) {
                    cronlog("Adding user to TeamSpeak group -> " . $groupInfo->name, $characterName);
                    $ts3_VirtualServer->serverGroupClientAdd($currentTSGroup, $tsCurrentDbId);
                } else {
                    cronlog("User already part of TeamSpeak group -> " . $groupInfo->name, $characterName);
                }
            }
        }
    } catch (Exception $e) {
        return $e->getCode() . " -> " . $e->getMessage();
    }
    return true;
}
Ejemplo n.º 30
0
    function main($id, $mode)
    {
        global $config, $db, $user, $auth, $template, $cache;
        global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix, $file_uploads;
        global $phpbb_dispatcher, $request;
        global $phpbb_container;
        $user->add_lang(array('posting', 'ucp', 'acp/users'));
        $this->tpl_name = 'acp_users';
        $error = array();
        $username = utf8_normalize_nfc(request_var('username', '', true));
        $user_id = request_var('u', 0);
        $submit = isset($_POST['update']) && !isset($_POST['cancel']) ? true : false;
        $form_name = 'omni/eveapi/user';
        add_form_key($form_name);
        // Show user selection mask
        if (!$username && !$user_id) {
            $this->page_title = 'SELECT_USER';
            $template->assign_vars(array('U_ACTION' => $this->u_action, 'ANONYMOUS_USER_ID' => ANONYMOUS, 'S_SELECT_USER' => true, 'U_FIND_USERNAME' => append_sid("{$phpbb_root_path}memberlist.{$phpEx}", 'mode=searchuser&amp;form=select_user&amp;field=username&amp;select_single=true')));
            return;
        }
        if (!$user_id) {
            $sql = 'SELECT user_id
																				FROM ' . USERS_TABLE . "\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'";
            $result = $db->sql_query($sql);
            $user_id = (int) $db->sql_fetchfield('user_id');
            $db->sql_freeresult($result);
            if (!$user_id) {
                trigger_error($user->lang['NO_USER'] . adm_back_link($this->u_action), E_USER_WARNING);
            }
        }
        // Generate content for all modes
        $sql = 'SELECT u.*, s.*
																FROM ' . USERS_TABLE . ' u
																	LEFT JOIN ' . SESSIONS_TABLE . ' s ON (s.session_user_id = u.user_id)
																WHERE u.user_id = ' . $user_id . '
																ORDER BY s.session_time DESC';
        $result = $db->sql_query_limit($sql, 1);
        $user_row = $db->sql_fetchrow($result);
        $db->sql_freeresult($result);
        if (!$user_row) {
            trigger_error($user->lang['NO_USER'] . adm_back_link($this->u_action), E_USER_WARNING);
        }
        // Generate overall "header" for user admin
        $s_form_options = '';
        // Build modes dropdown list
        $sql = 'SELECT module_mode, module_auth
												FROM ' . MODULES_TABLE . "\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE module_basename = 'acp_eveapi_user'\n\t\t\t\t\t\t\t\t\t\t\t\t\tAND module_enabled = 1\n\t\t\t\t\t\t\t\t\t\t\t\t\tAND module_class = 'acp'\n\t\t\t\t\t\t\t\t\t\t\t\tORDER BY left_id, module_mode";
        $result = $db->sql_query($sql);
        $dropdown_modes = array();
        while ($row = $db->sql_fetchrow($result)) {
            if (!$this->p_master->module_auth_self($row['module_auth'])) {
                continue;
            }
            $dropdown_modes[$row['module_mode']] = true;
        }
        $db->sql_freeresult($result);
        foreach ($dropdown_modes as $module_mode => $null) {
            $selected = $mode == $module_mode ? ' selected="selected"' : '';
            $s_form_options .= '<option value="' . $module_mode . '"' . $selected . '>' . $user->lang['ACP_USER_' . strtoupper($module_mode)] . '</option>';
        }
        $template->assign_vars(array('U_BACK' => $this->u_action, 'U_MODE_SELECT' => append_sid("{$phpbb_admin_path}index.{$phpEx}", "i={$id}&amp;u={$user_id}"), 'U_ACTION' => $this->u_action . '&amp;u=' . $user_id, 'S_FORM_OPTIONS' => $s_form_options, 'MANAGED_USERNAME' => $user_row['username']));
        // Prevent normal users/admins change/view founders if they are not a founder by themselves
        if ($user->data['user_type'] != USER_FOUNDER && $user_row['user_type'] == USER_FOUNDER) {
            trigger_error($user->lang['NOT_MANAGE_FOUNDER'] . adm_back_link($this->u_action), E_USER_WARNING);
        }
        $this->page_title = $user_row['username'] . ' :: ' . $user->lang('ACP_USER_' . strtoupper($mode));
        switch ($mode) {
            case 'eveapi_account':
                include $phpbb_root_path . 'includes/functions_user.' . $phpEx;
                $user->add_lang('mods/info_acp_eveapi');
                $data = array('username' => utf8_normalize_nfc(request_var('user', $user_row['username'], true)), 'eveapi_keyid' => request_var('eveapi_keyid', $user_row['eveapi_keyid'], true), 'eveapi_vcode' => request_var('eveapi_vcode', $user_row['eveapi_vcode'], true));
                if ($submit) {
                    $check_ary = array('eveapi_keyid' => array(array('string', false, 1, 15)), 'eveapi_vcode' => array(array('string', false, 64, 64)));
                    $check_ary['username'] = array(array('string', false, $config['min_name_chars'], $config['max_name_chars']), array('username'));
                    $error = validate_data($data, $check_ary);
                    if (!sizeof($error) && $config['eveapi_validation']) {
                        $eveapi_teamSpeakGroups = array();
                        $characterInfo = eveapi_checkThisCharacter($data['eveapi_keyid'], $data['eveapi_vcode'], $data['username']);
                        if (empty($characterInfo["error"])) {
                            if (!empty($characterInfo["forumGroups"]) || empty($characterInfo["forumGroups"]) && $config['eveapi_nonmember']) {
                                $eveapi_forumGroups = $characterInfo["forumGroups"];
                                $eveapi_teamSpeakGroups = $characterInfo["TSGroups"];
                                $extraGroups = eveapi_setForumGroups($user->data['user_id'], $eveapi_forumGroups, $data['username']);
                                if ($config['eveapi_jabber_masterswitch']) {
                                    if ($config['eveapi_ejabber_switch']) {
                                        eveapi_setJabberAccess($user_row['user_id'], $characterInfo['jabber'], $extraGroups['jabber'], $data['username']);
                                    }
                                    if ($config['eveapi_openfire_switch']) {
                                        eveapi_setOpenFireAccess($user_row['user_id'], $characterInfo['openfire'], $extraGroups['openfire'], $data['username']);
                                    }
                                }
                            } else {
                                $error[] = 'This character is not permitted to have an account on this forum.';
                            }
                        } else {
                            $error = array_merge($error, $characterInfo["error"]);
                        }
                    }
                    $sql_ary = array('user_character_id' => isset($characterInfo["info"]["characterId"]) ? (int) $characterInfo["info"]["characterId"] : 0, 'username' => $data['username'], 'username_clean' => utf8_clean_string($data['username']), 'eveapi_keyid' => $data['eveapi_keyid'], 'eveapi_vcode' => $data['eveapi_vcode']);
                    if ($data['username'] != $user_row['username']) {
                        add_log('user', $user_row['user_id'], 'LOG_USER_UPDATE_NAME', $user_row['username'], $data['username']);
                    }
                    if ($data['eveapi_keyid'] != $user_row['eveapi_keyid'] || $data['eveapi_vcode'] != $user_row['eveapi_vcode']) {
                        add_log('user', $user_row['user_id'], 'User has updated his/her EVE API information.', $user_row['username'], $data['eveapi_keyid'] . " -> " . $data['eveapi_vcode']);
                    }
                    $message = 'EVEAPI_UPDATED';
                    if (sizeof($sql_ary)) {
                        $sql = 'UPDATE ' . USERS_TABLE . '
																																SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
																																WHERE user_id = ' . $user_row['user_id'];
                        $db->sql_query($sql);
                        add_log('admin', 'LOG_USER_USER_UPDATE', $data['username']);
                    }
                }
                $inactive_reason = '';
                if ($user_row['user_type'] == USER_INACTIVE) {
                    $inactive_reason = $user->lang['INACTIVE_REASON_UNKNOWN'];
                    switch ($user_row['user_inactive_reason']) {
                        case INACTIVE_REGISTER:
                            $inactive_reason = $user->lang['INACTIVE_REASON_REGISTER'];
                            break;
                        case INACTIVE_PROFILE:
                            $inactive_reason = $user->lang['INACTIVE_REASON_PROFILE'];
                            break;
                        case INACTIVE_MANUAL:
                            $inactive_reason = $user->lang['INACTIVE_REASON_MANUAL'];
                            break;
                        case INACTIVE_REMIND:
                            $inactive_reason = $user->lang['INACTIVE_REASON_REMIND'];
                            break;
                        case INACTIVE_EVEAPI_INVALID:
                            $inactive_reason = $user->lang['EVEAPI_INVALID_API_KEY'];
                            break;
                        case INACTIVE_EVEAPI_NONMEMBER:
                            $inactive_reason = $user->lang['EVEAPI_NOT_ALLOWED_ACCOUNT'];
                            break;
                    }
                }
                $template->assign_vars(array('S_EVEAPI_REGISTER' => true, 'USER' => $data['username'], 'EVEAPI_KEYID' => $data['eveapi_keyid'], 'EVEAPI_VCODE' => $data['eveapi_vcode'], 'EVEAPI_ACCESSMASK' => eveapi_getAccessMask(), 'L_NAME_CHARS_EXPLAIN' => $user->lang($config['allow_name_chars'] . '_EXPLAIN', $user->lang('CHARACTERS', (int) $config['min_name_chars']), $user->lang('CHARACTERS', (int) $config['max_name_chars'])), 'L_EVEAPI_ACCOUNT' => $user->lang['UCP_EVEAPI_ACCOUNT'], 'S_USER_INACTIVE' => $user_row['user_type'] == USER_INACTIVE ? true : false, 'USER_INACTIVE_REASON' => $inactive_reason));
                break;
            case 'eveapi_jabber':
                $user->add_lang('mods/info_acp_eveapi');
                if ($submit) {
                    $characterInfo = eveapi_checkThisCharacter($user_row['eveapi_keyid'], $user_row['eveapi_vcode'], $user_row['username']);
                    if (empty($characterInfo["error"]) && (!empty($characterInfo["forumGroups"]) || empty($characterInfo["forumGroups"]) && $config['eveapi_nonmember'])) {
                        $eveapi_forumGroups = $characterInfo["forumGroups"];
                        $extraGroups = eveapi_setForumGroups($user_row['user_id'], $eveapi_forumGroups, $user_row['username']);
                        $password = eveapi_randomString(8);
                        $result = eveapi_setOpenFireAccess($user_row['user_id'], $characterInfo['openfire'], $extraGroups['openfire'], $user_row['username'], $password);
                        if ($result) {
                            $user_row['user_jabber_password'] = $password;
                        } else {
                            $error[] = $user->lang['JABBER_REGISTRATION_FAILED'];
                        }
                    }
                }
                $clean_username = str_replace(array(" ", "'"), array("_", "_"), $user_row['username']);
                $template->assign_vars(array('S_EVEAPI_JABBER' => true, 'JABBER_USERNAME' => $clean_username, 'JABBER_PASSWORD' => $user_row['user_jabber_password'], 'JABBER_HOST' => $config['eveapi_jabber_hostname'], 'L_EVEAPI_JABBER' => $user->lang['UCP_EVEAPI_JABBER'], 'L_JABBER' => $user->lang['EVEAPI_JABBER_REGISTER'], 'L_JABBER_EXPLAIN' => $user->lang['EVEAPI_JABBER_EXPLAIN'], 'L_JABBER_USERNAME' => $user->lang['EVEAPI_JABBER_USERNAME'], 'L_JABBER_PASSWORD' => $user->lang['EVEAPI_JABBER_PASSWORD'], 'L_JABBER_HOST' => $user->lang['EVEAPI_JABBER_HOST']));
                break;
            case 'eveapi_ts':
                $user->add_lang('mods/info_acp_eveapi');
                if ($submit) {
                    try {
                        $nickname = $config['eveapi_ts_nickname'];
                        if (eveapi_validateMixedalphanumeric($nickname) != 1) {
                            $nickname = "phpBBbot";
                        }
                        $ts3_VirtualServer = TeamSpeak3::factory("serverquery://" . $config["eveapi_ts_username"] . ":" . $config["eveapi_ts_password"] . "@" . $config["eveapi_ts_ip"] . ":" . $config["eveapi_ts_port_query"] . "/?server_port=" . $config["eveapi_ts_port_server"] . "&nickname=" . $nickname);
                    } catch (Exception $e) {
                        $error[] = $user->lang['TEAMSPEAK_CONNECTION_FAILED'];
                    }
                    $eveapi_ts = eveapi_getTeamSpeakUID($user_row['username'], $ts3_VirtualServer);
                    if (empty($eveapi_ts)) {
                        $error[] = $user->lang['TEAMSPEAK_USERNAME_NOT_FOUND'];
                    } else {
                        if (empty($user_row["eveapi_keyid"]) || empty($user_row["eveapi_vcode"])) {
                            $error[] = $user->lang['TEAMSPEAK_NO_API'];
                        } else {
                            $sql_ary = array('eveapi_ts' => $eveapi_ts);
                            $eveapi_teamSpeakGroups = array();
                            $characterInfo = eveapi_checkThisCharacter($user_row['eveapi_keyid'], $user_row['eveapi_vcode'], $user_row['username']);
                            if (empty($characterInfo["error"]) && (!empty($characterInfo["forumGroups"]) || empty($characterInfo["forumGroups"]) && $config['eveapi_nonmember'])) {
                                $eveapi_forumGroups = $characterInfo["forumGroups"];
                                $eveapi_teamSpeakGroups = $characterInfo["TSGroups"];
                                $extraGroups = eveapi_setForumGroups($user_row['user_id'], $eveapi_forumGroups, $user_row['username']);
                                if ($eveapi_ts != $user_row['eveapi_ts'] && !empty($user_row['eveapi_ts'])) {
                                    eveapi_setTeamSpeakGroups($user_row['eveapi_ts'], array(), $user_row['username']);
                                }
                                if ($eveapi_ts != "") {
                                    $TSverify = eveapi_setTeamSpeakGroups($eveapi_ts, $eveapi_teamSpeakGroups, $user_row['username'], $ts3_VirtualServer, $extraGroups["TS"]);
                                    if ($TSverify !== true) {
                                        $error[] = $TSverify;
                                        $sql_ary['eveapi_ts'] = $eveapi_ts = "";
                                    }
                                }
                                $user_row['eveapi_ts'] = $eveapi_ts;
                            }
                            $sql = 'UPDATE ' . USERS_TABLE . '
																																				SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
																																				WHERE user_id = ' . $user_row['user_id'];
                            $db->sql_query($sql);
                        }
                    }
                }
                $username = $user_row['username'];
                if (strlen($username) > 30) {
                    $username = substr($username, 0, 30);
                }
                $template->assign_vars(array('S_EVEAPI_TS' => true, 'USERNAME' => $username, 'EVEAPI_TS' => empty($user_row['eveapi_ts']) ? $user->lang['EVEAPI_TEAMSPEAK_UID_EMPTY'] : $user_row['eveapi_ts'], 'L_EVEAPI_TS' => $user->lang['UCP_EVEAPI_TS'], 'L_TEAMSPEAK' => $user->lang['EVEAPI_TEAMSPEAK_REGISTER'], 'L_TEAMSPEAK_EXPLAIN' => $user->lang['EVEAPI_TEAMSPEAK_EXPLAIN'], 'L_TEAMSPEAK_USERNAME' => $user->lang['EVEAPI_TEAMSPEAK_USERNAME'], 'L_TEAMSPEAK_UID' => $user->lang['EVEAPI_TEAMSPEAK_UID']));
                break;
        }
        // Assign general variables
        $template->assign_vars(array('S_ERROR' => sizeof($error) ? true : false, 'ERROR_MSG' => sizeof($error) ? implode('<br />', $error) : ''));
    }