[Gesior AAC] Support Page (fixed)

[Norix]

Hi
Since the support page doesnt work with TFS 0.3.4 i've edited it so it works again . Hope you like it:

   <?php
$list = $SQL->query('SELECT name,online,group_id,world_id FROM players WHERE players.group_id > 1 ORDER BY group_id DESC');
$groups = simplexml_load_file($config['site']['server_path'].'/data/XML/groups.xml') or die('<b>Could not load groups!</b>'); 
        foreach($groups->group as $g) 
            $groupList[(int)$g['id']] = $g['name']; 

$main_content .= '<center><h2>Support in game</h2></center>';
$main_content .= "<table border=0 cellspacing=1 cellpadding=4 width=100%>
    <tr bgcolor=\"".$config['site']['vdarkborder']."\">
    <td width=\"20%\"><font class=white><b>Group</b></font></td>
    <td width=\"45%\"><font class=white><b>Name</b></font></td>
    <td width=\"15%\"><font class=white><b>Status</b></font></td>
    <td width=\"20%\"><font class=white><b>World</b></font></td>";
foreach($list as $gm) {
    if($gm['online'] == 0)
        $player_list_status = '<font color="red">Offline</font>';
    else
        $player_list_status = '<font color="green">Online</font>';

$main_content .= '<tr bgcolor=\'#888888\'><td>' . $groupList[(int)$gm['group_id']] . '</td><td>'.$gm['name'].'</td><td>'.$player_list_status.'</td><td>'.$config['site']['worlds'][$gm['world_id']].'</td></tr>';
}

$main_content .= "</table>";
?>

Plz rep++

Your's ballack13

 

[Xenios]

Approved.

 

[slaw]

Its good, but still will be better if you'll parse groups.xml file, so you won't need to change everything 2 times.

 

[Victor]

$skills = $SQL->query('SELECT name,online,group_id,world_id FROM players WHERE players.group_id > 1 ORDER BY group_id DESC LIMIT '.$config['site']['highscores_limit']);

Change

LIMIT '.$config['site']['highscores_limit']);

on

';

 

[Norix]

As slawkens wished i modified the script so u dont need to change anything now hope its good now

<?php
$list = $SQL->query('SELECT name,online,group_id,world_id FROM players WHERE players.group_id > 1 ORDER BY group_id DESC');
$groups = simplexml_load_file($config['site']['server_path'].'/data/XML/groups.xml') or die('<b>Could not load groups!</b>'); 
        foreach($groups->group as $g) 
            $groupList[(int)$g['id']] = $g['name']; 

$main_content .= '<center><h2>Support in game</h2></center>';
$main_content .= "<table border=0 cellspacing=1 cellpadding=4 width=100%>
	<tr bgcolor=\"".$config['site']['vdarkborder']."\">
	<td width=\"20%\"><font class=white><b>Group</b></font></td>
	<td width=\"45%\"><font class=white><b>Name</b></font></td>
	<td width=\"15%\"><font class=white><b>Status</b></font></td>
	<td width=\"20%\"><font class=white><b>World</b></font></td>";
foreach($list as $gm) {
	if($gm['online'] == 0)
		$player_list_status = '<font color="red">Offline</font>';
	else
		$player_list_status = '<font color="green">Online</font>';

$main_content .= '<tr bgcolor=\'#888888\'><td>' . $groupList[(int)$gm['group_id']] . '</td><td>'.$gm['name'].'</td><td>'.$player_list_status.'</td><td>'.$config['site']['worlds'][$gm['world_id']].'</td></tr>';
}

$main_content .= "</table>";
?>

 

[TKO]

where do you add this?

 

[Norix]

Replace this code with the code in team.php

 

[TKO]

Thanks nice job!

 

[HeberPcL]

Very Nice!

Thanks!

Rep++

 

[Deaktiver]

kool!

rep++ ;o

 

[bivan]

I have this error :

Warning: simplexml_load_file() [function.simplexml-load-file]: I/O warning : failed to load external entity "file:///i changed the localization ; )//data/XML/groups.xml" in C:\xampp\htdocs\team.php on line 3
Could not load groups!

 

[bivan]

I dont have this file - groups.xml ; /

 

[Norix]

Then you dont have TFS 0.3.4 ...

 

[Ezzam]

Thx for the release. <3

 

[klekSu]

Thanks.

 

[djlucas15]

Thanks...

More not 100% for Tibia.com layout.

More, very Thanks

 

[Norix]

ehm what???? xd

 

[bivan]

Maybe djlucas15 want say to you make more php scripts for layouts ;D

 

[gnr]

Stylized ^^

<?php 
$skills = $SQL->query('SELECT name,online,group_id,world_id FROM players WHERE players.group_id > 1 ORDER BY group_id DESC'); 
$groups = simplexml_load_file($config['site']['server_path'].'/data/XML/groups.xml') or die('<b>Could not load groups!</b>');  
        foreach($groups->group as $g)  
            $groupList[(int)$g['id']] = $g['name'];  
 
$main_content .= '<center><h2>Support in game</h2></center>'; 
$main_content .= "<table border=0 cellspacing=1 cellpadding=4 width=100%> 
    <tr bgcolor=\"".$config['site']['vdarkborder']."\"> 
    <td width=\"20%\"><font class=white><b>Group</b></font></td> 
    <td width=\"45%\"><font class=white><b>Name</b></font></td> 
    <td width=\"15%\"><font class=white><b>Status</b></font></td> 
    <td width=\"20%\"><font class=white><b>World</b></font></td>";
$showed_players = 1;
foreach($skills as $gm) {
$showed_players++; 
    if(is_int($showed_players / 2)) 
        $bgcolor = $config['site']['darkborder']; 
    else 
        $bgcolor = $config['site']['lightborder'];
    if($gm['online'] == 0) 
        $player_list_status = '<font color="red"><b>Offline</b></font>'; 
    else 
        $player_list_status = '<font color="green"><b>Online</b></font>'; 
 
$main_content .= '<tr bgcolor='.$bgcolor.'><td>' . $groupList[(int)$gm['group_id']] . '</td><td>'.$gm['name'].'</td><td>'.$player_list_status.'</td><td>'.$config['site']['worlds'][$gm['world_id']].'</td></tr>'; 
} 
 
$main_content .= "</table>"; 
?>

 

[djlucas15]

Thx for all developed this, I have search this for good time.

Thanks and sorry for bad english!