imperialbt statistics code

it53lv · #1 26th June 2011, 17:11

i think this is messed up

Code:

echo "
<div class=\"maintitle_base\"><div class=\"header_left\"><div class=\"header_right\">
<h3 class=\"maintitle\"> Our Statistics</h3>
</div></div></div>
<div class=\"border2\"> 
<div id=\"board_statistics\" class=\"statistics stats_container\"> 
    
        <div id=\"stats\"> 
            <h2> Statistics</h2> 
            <dl> ";
echo "<dt>Torrents</dt><dd>".$tottorrent."</dd>\n"; 
echo "<dt>We have shared </dt><dd>".mksize($totshare)."</dd>\n";
echo "<dt>Seeders</dt><dd>".$totseeders."</dd>\n";
echo "<dt>Leechers</dt><dd>".$totleechers."</dd>\n";
echo "<dt>Members</dt><dd>".$totuser."</dd>\n";
        echo "
            </dl> 
        </div> 
    
    <div id=\"active_users\" class=\"stats_list\"> 
            <h2>";
$legend = '<b>'; 
$sqlev = "SELECT name, color FROM ".$db_prefix."_levels"; 
$reslev = $db->sql_query($sqlev); 
        while ($rowlev = $db->sql_fetchrow($reslev)) { 
        $legend .='<a href="memberslist.php?mode=group&g='.$rowlev['name'].'" style="color: '.$rowlev['color'].'; font-weight: bold;">'.$rowlev['name'].'</a> '; 
} 
$legend .= '</b>'; 
$db->sql_freeresult($reslev); 
$sql = "SELECT O.id AS id, O.page AS page, UNIX_TIMESTAMP(O.logged_in) AS logged_in, IF(U.name IS NULL, U.username, U.name) as name, U.donator AS donator, U.warned AS warned, U.can_do as can_do, U.level AS level, U.Show_online AS Show_online, U.uploaded as uploaded, U.downloaded AS downloaded FROM ".$db_prefix."_online_users O LEFT JOIN ".$db_prefix."_users U ON O.id = U.id WHERE UNIX_TIMESTAMP(NOW()-U.lastlogin) < 1800 AND U.Show_online = true;"; 
$res = $db->sql_query($sql); 
$tot = $db->sql_numrows($res); 
$i = 1; 
$simple = "\n<p>"; 
$user_now = $db->sql_numrows($res); 
if ($user_now == 0) $simple .= _btnouseronline; 
else { 
        while ($row = $db->sql_fetchrow($res)) { 
        //if($row[id] == $user->id)break; 
        if($row["donator"] == 'true')$donator = true; 
        else 
        $donator = false; 
                $simple .= "<a href=\"user.php?op=profile&id=".$row["id"]."\"><font color=\"".getusercolor($row["can_do"])."\">"; 
                $simple .= htmlspecialchars($row["name"])."</font></a>"; 
                if ($row["level"] == "premium") $simple .= pic("icon_premium.gif",'','premium'); 
                elseif ($row["level"] == "moderator") $simple .= pic("icon_moderator.gif",'','moderator'); 
                elseif ($row["level"] == "admin") $simple .= pic("icon_admin.gif",'','admin'); 
    if($donator) $simple .= '<img src="images/donator.gif" height="16" width="16" title="donator" alt="donator" />'; 
     if($row["warned"] == "1") $simple .= '<img src="images/warning.gif" title="warned" alt="warned" />'; 
                if ($i < $tot) $simple .= ", "; 
                $i++; 
 
        } 
        $simple .= ""; 
} 
$db->sql_freeresult($res);
        echo"$simple";
echo "<br /> $user_now active user(s) <span>(in past 5 minutes)</span><br /> 
                <span class=\"desc\">$legend</span> 
            </h2> 
        </div>
</div></div>";

joeroberts · #2 26th June 2011, 17:13

where is the query for stats? did you change it?

it53lv · #3 26th June 2011, 17:15

yes i taked out a lot
query thing starts AFTER

Code:

echo "
<div class=\"maintitle_base\"><div class=\"header_left\"><div class=\"header_right\">
<h3 class=\"maintitle\"> Our Statistics</h3>
</div></div></div>
<div class=\"border2\"> 
<div id=\"board_statistics\" class=\"statistics stats_container\"> 
    
        <div id=\"stats\"> 
            <h2> Statistics</h2> 
            <dl> ";
echo "<dt>Torrents</dt><dd>".$tottorrent."</dd>\n"; 
echo "<dt>We have shared </dt><dd>".mksize($totshare)."</dd>\n";
echo "<dt>Seeders</dt><dd>".$totseeders."</dd>\n";
echo "<dt>Leechers</dt><dd>".$totleechers."</dd>\n";
echo "<dt>Members</dt><dd>".$totuser."</dd>\n";
        echo "
            </dl> 
        </div> 
    
    <div id=\"active_users\" class=\"stats_list\"> 
            <h2>";

joeroberts · #4 26th June 2011, 17:17

I still need to see the complete code if Im to help improve it.

it53lv · #5 26th June 2011, 17:49

all the code is in my first post there is noting else for this block
everything else in index.php is basicly the same as original only some blocks are comented out
old statistics function is removed

basicly that's all there is changed in index.php

joeroberts · #6 26th June 2011, 18:56

Quote:

Originally Posted by it53lv

all the code is in my first post there is noting else for this block
everything else in index.php is basicly the same as original only some blocks are comented out
old statistics function is removed

basicly that's all there is changed in index.php

that's why it's not working you removed the part that gets the information
I well look at it l8r as I got stuff going on here rite now.

it53lv · #7 26th June 2011, 19:03

ok it's not realy important at this point so no wories

joeroberts · #8 27th June 2011, 00:52

try this

PHP Code:


			
echo "
<div class=\"maintitle_base\"><div class=\"header_left\"><div class=\"header_right\">
<h3 class=\"maintitle\"> Our Statistics</h3>
</div></div></div>
<div class=\"border2\"> 
<div id=\"board_statistics\" class=\"statistics stats_container\"> 
    
        <div id=\"stats\"> 
            <h2> Statistics</h2> 
            <dl> ";
        //Total Torrents and their size
        $sql = "SELECT COUNT(id), SUM(size) FROM ".$db_prefix."_torrents;";
        $res = $db->sql_query($sql);
        list ($tottorrent, $totshare) = $db->sql_fetchrow($res);
        $db->sql_freeresult($res);
echo "<dt>"._btindex_totaltorrents."</dt><dd>".$tottorrent."</dd>\n"; 
echo "<dt>"._btindex_totalshare."</dt><dd>".mksize($totshare)."</dd>\n";
        //Total seeders and total leechers
        $sql = "SELECT COUNT(id) FROM ".$db_prefix."_peers GROUP BY seeder ORDER BY seeder ASC;";
        $res = $db->sql_query($sql);
        list ($totseeders) = $db->sql_fetchrow($res);
        list ($totleechers) = $db->sql_fetchrow($res);
        $db->sql_freeresult($res);
echo "<dt>"._btindex_totalseeders."</dt><dd>".$totseeders."</dd>\n";
echo "<dt>"._btindex_totalleechers."</dt><dd>".$totleechers."</dd>\n";
        //Total users
        $sql = "SELECT COUNT(id) FROM ".$db_prefix."_users;";
        $res = $db->sql_query($sql);
        list ($totuser) = $db->sql_fetchrow($res);
        $db->sql_freeresult($res);
echo "<dt>"._btindex_totalregister."</dt><dd>".$totuser."</dd>\n";
        echo "
            </dl> 
        </div> 
    
    <div id=\"active_users\" class=\"stats_list\"> 
            <h2>";
$legend = '<b>'; 
$sqlev = "SELECT name, color FROM ".$db_prefix."_levels"; 
$reslev = $db->sql_query($sqlev); 
        while ($rowlev = $db->sql_fetchrow($reslev)) { 
        $legend .='<a href="memberslist.php?mode=group&g='.$rowlev['name'].'" style="color: '.$rowlev['color'].'; font-weight: bold;">'.$rowlev['name'].'</a> '; 
} 
$legend .= '</b>'; 
$db->sql_freeresult($reslev); 
$sql = "SELECT O.id AS id, O.page AS page, UNIX_TIMESTAMP(O.logged_in) AS logged_in, IF(U.name IS NULL, U.username, U.name) as name, U.donator AS donator, U.warned AS warned, U.can_do as can_do, U.level AS level, U.Show_online AS Show_online, U.uploaded as uploaded, U.downloaded AS downloaded FROM ".$db_prefix."_online_users O LEFT JOIN ".$db_prefix."_users U ON O.id = U.id WHERE UNIX_TIMESTAMP(NOW()-U.lastlogin) < 1800 AND U.Show_online = true;"; 
$res = $db->sql_query($sql); 
$tot = $db->sql_numrows($res); 
$i = 1; 
$simple = "\n<p>"; 
$user_now = $db->sql_numrows($res); 
if ($user_now == 0) $simple .= _btnouseronline; 
else { 
        while ($row = $db->sql_fetchrow($res)) { 
        //if($row[id] == $user->id)break; 
        if($row["donator"] == 'true')$donator = true; 
        else 
        $donator = false; 
                $simple .= "<a href=\"user.php?op=profile&id=".$row["id"]."\"><font color=\"".getusercolor($row["can_do"])."\">"; 
                $simple .= htmlspecialchars($row["name"])."</font></a>"; 
                if ($row["level"] == "premium") $simple .= pic("icon_premium.gif",'','premium'); 
                elseif ($row["level"] == "moderator") $simple .= pic("icon_moderator.gif",'','moderator'); 
                elseif ($row["level"] == "admin") $simple .= pic("icon_admin.gif",'','admin'); 
    if($donator) $simple .= '<img src="images/donator.gif" height="16" width="16" title="donator" alt="donator" />'; 
     if($row["warned"] == "1") $simple .= '<img src="images/warning.gif" title="warned" alt="warned" />'; 
                if ($i < $tot) $simple .= ", "; 
                $i++; 
 
        } 
        $simple .= ""; 
} 
$db->sql_freeresult($res);
        echo"$simple";
echo "<br /> $user_now active user(s) <span>(in past 5 minutes)</span><br /> 
                <span class=\"desc\">$legend</span> 
            </h2> 
        </div>
</div></div>";

it53lv · #9 27th June 2011, 00:54

perfect :bubble:

CanonSems · #10 28th October 2011, 15:47

all the code is in my first post there is noting else for this block
everything else in index.php is basicly the same as original only some blocks are comented out