gesior, Help with total members/avg lvl code at guilds

[Linken93]

Hello!

I need some help with this code for showing total members and avg lvls when looking at guilds. Currently it's just showing 0..

                        $guild_id = (int)$_GET['guild'];
    $guildMembers = $SQL->query( 'SELECT COUNT(`gr`.`id`) AS `total` FROM `players` AS `p` LEFT JOIN `guild_ranks` AS `gr` ON `gr`.`id` = `p`.`rank_id` WHERE `gr`.`guild_id` = '.$guild_id )->fetch( );        
            $main_content .= '</TD><TD><TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0><center>[B][COLOR="#FF0000"]'.$guildMembers['total'].'[/COLOR][/B]</center></TABLE>
            ';
            $sumav = $SQL->query ('SELECT SUM(`level`) as `level_sum`,AVG(`level`) as `level_avg` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.')  ')->fetch();
            $main_content .= '</TD><TD><TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0><center>[B][COLOR="#FF0000"]'.round($sumav['level_avg'].'[/COLOR][/B]</center></TABLE>
            </TD></TR>';

Thanks in advance!!

Rep++ for the one who helps x)

 

[Herpicus]

$g = $SQL->query('SELECT COUNT(gr.id) AS t FROM players AS p INNER JOIN guild_ranks AS gr ON gr.id = p.rank_id WHERE guild_id = '.$guild_id)->fetch();
$main_content .= '</TD><TD><TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0><center>'.$g['t'].'</center></TABLE>';


$s = $SQL->query('SELECT SUM(level) as level_sum, AVG(level) as level_avg FROM players WHERE rank_id IN (SELECT id FROM guild_ranks WHERE guild_id='.$guild_id.')')->fetch();
$main_content .= '</TD><TD><TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0><center>'.round($s['level_avg']).'</center></TABLE></TD></TR>';

Should work, didn't test

 

[Linken93]

$g = $SQL->query('SELECT COUNT(gr.id) AS t FROM players AS p INNER JOIN guild_ranks AS gr ON gr.id = p.rank_id WHERE guild_id = '.$guild_id)->fetch();
$main_content .= '</TD><TD><TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0><center>'.$g['t'].'</center></TABLE>';


$s = $SQL->query('SELECT SUM(level) as level_sum, AVG(level) as level_avg FROM players WHERE rank_id IN (SELECT id FROM guild_ranks WHERE guild_id='.$guild_id.')')->fetch();
$main_content .= '</TD><TD><TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0><center>'.round($s['level_avg']).'</center></TABLE></TD></TR>';

Should work, didn't test

I'll test it later when I'm home. I'll rep you anyway even if it doesn't work!

 

[Herpicus]

I'll test it later when I'm home. I'll rep you anyway even if it doesn't work!

Hah, no problem, it should work but if it doesn't just leave another comment and I will take a look at it

 

[Linken93]

Hah, no problem, it should work but if it doesn't just leave another comment and I will take a look at it

Just tried it but it still showing 0 at both hmm

 

[Linken93]

Bump