UBB.Developers Forums UBB.threads 7 Development How Do I? Remove Status from online.php

Need some assistance.

Is there a way to remove "Status" and replace it with "Post Number" on the Who's Online page?

Thanks,

Bobby

Sure

Open online.php and change this:
$query = "
SELECT t1.O_Username, t1.O_Last, t1.O_What,t1.O_Extra,t1.O_Read,t2.U_Status,t2.U_Visible,t2.U_Extra1,t2.U_Title,t2.U_Color,t2.U_OnlineFormat,t2.U_Number
FROM {$config['tbprefix']}Online AS t1,
{$config['tbprefix']}Users AS t2
WHERE t1.O_Username = t2.U_Username
ORDER BY t1.O_Last DESC
";

to this:

$query = "
SELECT t1.O_Username, t1.O_Last, t1.O_What,t1.O_Extra,t1.O_Read,t2.U_TotalPosts,t2.U_Visible,t2.U_Extra1,t2.U_Title,t2.U_Color,t2.U_OnlineFormat,t2.U_Number
FROM {$config['tbprefix']}Online AS t1,
{$config['tbprefix']}Users AS t2
WHERE t1.O_Username = t2.U_Username
ORDER BY t1.O_Last DESC
";

then this:
while (list($Username,$Last,$RealWhat,$Extra,$Read,$Status,$Visible,$ICQ,$Title,$Color,$OnlineFormat,$Uid) = $dbh -> fetch_array($reged) ) {

to this
while (list($Username,$Last,$RealWhat,$Extra,$Read,$TotalPosts,$Visible,$ICQ,$Title,$Color,$OnlineFormat,$Uid) = $dbh -> fetch_array($reged) ) {

then remove this (or comment it)
if ($Status == "Administrator") { $Status = $ubbt_lang['USER_ADMIN']; }
if ($Status == "Moderator") { $Status = $ubbt_lang['USER_MOD']; }
if ($Status == "User") { $Status = $ubbt_lang['USER_USER']; }

Then change this:
$regrow[$x]['icqindicator'] = $icqindicator;
$regrow[$x]['Status'] = $Status;

to this
$regrow[$x]['icqindicator'] = $icqindicator;
$regrow[$x]['TotalPosts'] = $TotalPosts;

Finished on this file.

Open online.tmpl file and change this:
<td class="tdheader" width="12%">
{$ubbt_lang['USER_STATUS']}
</td>

to this
<td class="tdheader" width="12%">
Total Posts
</td>

and finally this
<td valign="top" class="{$regrow[$i]['color']}">
{$regrow[$i]['Status']}
</td>

to this
<td valign="top" class="{$regrow[$i]['color']}">
{$regrow[$i]['TotalPosts']}
</td>


I haven't tested this but it should work. Make sure you backup your original files first before any alterations.

Gee, is that all?!

Not alot at all really. I was about to answer this post earlier. I went to my test site and was making the necessary changes to make sure I was right and came back to post it and Nikos had already wrote it out.

What he wrote above is correct and does work.

what i did was add the "A" and "M" flags in the username column and replace the status column with a "User Links" column, with graphical links to send private message, their yahoo! profile, their homepage, email, etc.

http://www.elazulspad.com/ep/online.php?Cat=

THANKS !!!

Works like a charm