Change your phpbb forums stats to match phpnuke.

Hire Us!Download Video (0)Comments

As many of you know the stats in the phpbb forums only show those related to phpbb and not for the entire phpnuke site(fig 1). In this tutorial I will show you how to get the correct stats displayed inside your forums.

fig1.

Files to edit:
includes/page_header.php

Steps :
Open includes/page_header.php and find the following line of codes.

$template->assign_vars(array(

Above that line we are going to place the codes to get the phpnuke stats.

//WS STATS MOD
global $prefix, $user_prefix, $db;
//GET COUNT ONLINE
$guest_N = $db->sql_numrows($db->sql_query("SELECT uname FROM ".$prefix."_session WHERE guest=\'1\'"));
$member_N = $db->sql_numrows($db->sql_query("SELECT uname FROM ".$prefix."_session WHERE guest=\'0\'"));

$l_g_user = $lang[\'Guest_user_total\'];
$l_users = $lang[\'Online_user_total\'];
$l_r_user = $lang[\'Reg_user_total\'];
$Total_N = $guest_N + $member_N;
$l_online_u = sprintf($l_users, $Total_N);
$l_online_u .= sprintf($l_r_user, $member_N);
$l_online_u .= sprintf($l_g_user, $guest_N);
//GET TOTAL MEMB ONLINE
$resultM = $db->sql_query("SELECT uname, guest FROM $prefix"._session." WHERE guest=\'0\'");
$Monline = $db->sql_numrows($resultM);
$membonline = $lang[\'Registered_users\'];

while ($session = $db->sql_fetchrow($resultM)) {
    if (isset($session["guest"]) and $session["guest"] == 0) {
        if ($i < 10) {
            $membonline .= " <A HREF=\"modules.php?name=Your_Account&op=userinfo&username=$session[uname]\">$session[uname]</a><br>\n";
        } else {
            $membonline .= " <A HREF=\"modules.php?name=Your_Account&op=userinfo&username=$session[uname]\">$session[uname]</a><br>\n";
        }
        $membonline .= ($i != $membonline ? "  " : "");
       
    }
}

I have taken the total online, members online, guests online and users online from phpnuke tables. This should give a more accurate account of who exactly is online.
Next we will change what is outputted to the template file. Scroll down a few lines and find the following

Replace the two lines with the following :

That's it! Enjoy and please Back Up as usual before making any major changes.

Hire Us!Download Video (0)Comments

Related Tutorials

Change your phpbb forums stats to match phpnuke.