<?php

$game = @fsockopen($server, $portgame, $errno, $errstr, $timeout);
$login = @fsockopen($server, $portlogin, $errno, $errstr, $timeout);

$connect = mysql_connect("$dbhost", "$dbuser", "$dbpassword");
mysql_select_db($gs);
mysql_query("SET NAMES 'utf8'");
$query = "SELECT count(*) FROM `players` WHERE `online`=1";
$result = mysql_query($query);

$rs = mysql_fetch_array($result);
$rscount = $rs[0];
if ($rscount >= 0) {$playersonline = "<font color=white>" .$rscount. "</font>";}
if ($rscount >= 100) {$playersonline = "<font color=yellow>" .$rscount. "</font>";}
if ($rscount >= 200) {$playersonline = "<font color=orange>" .$rscount. "</font>";}
if ($rscount >= 300) {$playersonline = "<font color=red>" .$rscount. "</font>";}
if ($rscount >= 400) {$playersonline = "<font color=magenta>" .$rscount. "</font>";}


$query_gm = "SELECT players.name FROM players INNER JOIN $ls.account_data ON players.account_id = $ls.account_data.id WHERE $ls.account_data.access_level >  '0' AND players.online = '1'";
$result_gm = mysql_query($query_gm);
$gmonline = "";
while ($count = mysql_fetch_array($result_gm)) {
$gmonline .= $count['name']." ";
}
if ($gmonline == "") {$gmonline.="No hay GMs conectados";}


$result = mysql_query("SELECT count(*) FROM $ls.account_data") or die(mysql_error());
$accounts_amt = mysql_result($result, 0, 0);
$result = mysql_query("SELECT count(*) FROM players") or die(mysql_error());
$players_amt = mysql_result($result, 0, 0);
$result = mysql_query("SELECT count(*) FROM legions") or die(mysql_error());
$legions_amt = mysql_result($result, 0, 0);
$result = mysql_query("SELECT count(*) FROM $ls.account_data WHERE access_level > 0") or die(mysql_error());
$gm_amt = mysql_result($result, 0, 0);
$loginname = $_SESSION['login_name'];
$userinfoquery ="SELECT * FROM $ls.account_data WHERE $ls.account_data.name = '$loginname'";
$userinfo = mysql_query($userinfoquery) or die(mysql_error());
$userinfoQA = mysql_fetch_array($userinfo);
if($userinfoQA['activated'] == 1){
	$active = "<font color='green'>Activada</font>";
}
else{
	$active = "<font color='red'>Desactivada</font>";
}

if($userinfoQA['access_level'] == 0){
	$tipo = "Jugador";
}
else if($userinfoQA['access_level'] == 1){
	$tipo = "Support";
}
else if($userinfoQA['access_level'] == 2){
	$tipo = "Events";
}
else if($userinfoQA['access_level'] == 3){
	$tipo = "GM";
}
else if($userinfoQA['access_level'] == 4){
	$tipo = "HeadGM";
}
else if($userinfoQA['access_level'] == 5){
	$tipo = "Admin";
}
else{
	$tipo = "Jugador";
}

if($userinfoQA['membership'] == 0){
	$subs = "Ninguna";
}
else if($userinfoQA['membership'] == 1){
	$subs = "Premium";
}
else if($userinfoQA['membership'] == 2){
	$subs = "VIP";
}
else{
	$subs = "Ninguna";
}


//LISTADO DE PERSONAJES DE LA CUENTA DEL USUARIO
//capturar id de cuenta:
$idCuenta = $userinfoQA['id'];
$selectPJQ= "SELECT * FROM $gs.players WHERE account_id=$idCuenta";
$selectPJ = mysql_query($selectPJQ);
mysql_close($connect);