query ( 'SELECT client, COUNT(client) ilosc FROM list_ots GROUP BY client order by ilosc desc limit 1' ); $clients1 = $clients -> fetch_assoc (); $mtype = $mysqli -> query ( 'SELECT type, COUNT(type) ilosc FROM list_ots GROUP BY client order by ilosc desc limit 1' ); $mtype1 = $mtype -> fetch_assoc (); $allonline = $mysqli -> query ( 'SELECT SUM(players) as suma FROM list_ots' ); $allonline1 = $allonline -> fetch_assoc (); $allsonline= $mysqli -> query ( 'SELECT *, COUNT(*) ilosc FROM list_ots where status=1' ); $allsonline1 = $allsonline -> fetch_assoc (); $alls= $mysqli -> query ( 'SELECT *, COUNT(*) ilosc FROM list_ots' ); $alls1 = $alls -> fetch_assoc (); $regacc= $mysqli -> query ( 'SELECT *, COUNT(*) ilosc FROM list_acc' ); $regacc1 = $regacc -> fetch_assoc (); $rec= $mysqli -> query ( 'SELECT *, MAX(rec) ilosc FROM list_ots' ); $rec1 = $rec -> fetch_assoc (); $SearchQuery = $mysqli -> query ( 'SELECT * FROM list_ots where feat = 1 AND status = 1 ORDER BY RAND() LIMIT 1' ); if ( $SearchQuery -> num_rows == 1) { $Row = $SearchQuery -> fetch_assoc(); $ColorStatus = 'green'; $Status = 'Online'; $PlayersCount = $Row['players']. '(' .$Row['rec']. ')/' .$Row['maxplayers']; echo '

'.$box0a.'

' .$Row['name']. '
Status: ' .$Status. '
Uptime:' .$Row['uptimepc']. '%
IP:' .$Row['ip']. '
Port:' .$Row['port']. '
Players:' .$PlayersCount. '
Exp:x' .$Row['exp']. '
Client:' .$Row['client']. '
Type:' .$Row['type']. '
Country:' .$Row['country']. '

'.$box0b.'

'.$box1.''.$allonline1['suma'].'
'.$box2.''.$allsonline1['ilosc'].'
'.$box3.''.$alls1['ilosc'].'
'.$box4.''.$regacc1['ilosc'].'
'.$box5.''.$clients1['client'].'
'.$box6.''.$mtype1['type'].'
'.$box7.''.$rec1['ilosc'].'('.$rec1['name'].')
'; }else { echo '

'.$box0b.'

'.$box1.''.$allonline1['suma'].'
'.$box2.''.$allsonline1['ilosc'].'
'.$box3.''.$alls1['ilosc'].'
'.$box4.''.$regacc1['ilosc'].'
'.$box5.''.$clients1['client'].'
'.$box6.''.$mtype1['type'].'
'.$box7.''.$rec1['ilosc'].'('.$rec1['name'].')
'; } ?>
STATUSUptimeOTS nameIPPlayersEXPClientTypeCountry
Online100%feba.mine.nufeba.mine.nu589 (1042) /1000x07.1PVPPoland
Online20.79%averyz.comaveryz.com264 (292) /500x07.1PVPPoland
[1]