AAC Team Page Gesior

[Larb]

i make this change on team page but dont see groups
how to make something like this > http://2.1m.yt/4ScLULZ.png

my page >> http://prnt.sc/e78yf0

<?php
if(!defined('INITIALIZED'))
    exit;

$list = $SQL->query('SELECT `name` FROM `players` WHERE `account_id` IN (SELECT `id` FROM `accounts` WHERE `type` = 2 or `group_id` > 2) ORDER BY `players`.`name` DESC');

$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=\"65%\"><font class=white><b>Name</b></font></td>
    <td width=\"15%\"><font class=white><b>Status</b></font></td>";
foreach($list as $i => $supporter)
{
    if(!Player::isPlayerOnline($supporter['id']))
        $player_list_status = '<font color="red">Offline</font>';
    else
        $player_list_status = '<font color="green">Online</font>';
    $bgcolor = (($i++ % 2 == 1) ?  $config['site']['darkborder'] : $config['site']['lightborder']);
    $main_content .= '<tr bgcolor="'.$bgcolor.'"><td>' . htmlspecialchars(Website::getGroupName($supporter['group_id'])) . '</td><td><a href="?subtopic=characters&name='.urlencode($supporter['name']).'">'.htmlspecialchars($supporter['name']).'</a></td><td>'.$player_list_status.'</td></tr>';
}

$main_content .= "</table>";

 

[imkingran]

Change your query to include group_id and change how it orders to players.group_id instead of players.name:

$list = $SQL->query('SELECT `name`, `group_id` FROM `players` WHERE `account_id` IN (SELECT `id` FROM `accounts` WHERE `type` = 2 or `group_id` > 2) ORDER BY `players`.`group_id` DESC');

 

[Larb]

now show groups but... http://prnt.sc/e7mwr9
Crumble is tutor =x

 

[imkingran]

now show groups but... http://prnt.sc/e7mwr9
Crumble is tutor =x

What's his group ID tho?

 

[Larb]

Its for player group ID

    <group id="1" name="player" flags="0" access="0" maxdepotitems="0" maxvipentries="0" />
    <group id="2" name="tutor" flags="16777216" access="1" maxdepotitems="0" maxvipentries="200" />
    <group id="3" name="sennior tutor" flags="29360128" access="1" maxdepotitems="0" maxvipentries="200" />
    <group id="4" name="gamemaster" flags="66567897594" access="1" maxdepotitems="0" maxvipentries="200" />
    <group id="5" name="God" flags="135291445242" access="1" maxdepotitems="0" maxvipentries="200" />

For account type

ACCOUNT_TYPE_NORMAL = 1,
    ACCOUNT_TYPE_TUTOR = 2,
    ACCOUNT_TYPE_SENIORTUTOR = 3,
    ACCOUNT_TYPE_GAMEMASTER = 4,
    ACCOUNT_TYPE_GOD = 5

 

[imkingran]

Try this one:

$list = $SQL->query('SELECT `name`, `group_id` FROM `players` WHERE `group_id` > 1 ORDER BY `players`.`group_id` DESC');