Mini Mods - Friends online at the bottom of the screen

This is something I made for my site, so people could quickly see who of their friends is online. Feel free to re-write the code, because this code is not perfect: I am not a real programmer, and used some of the vBulletin code (what a shame!).

Install:

Create new plug-in:

Product : vBulletin
Hook Location : process_templates_complete
Title : Friends Online
Execution Order : 5

PHP Code:

if (!$vbulletin->userinfo['userid'])
    {
    }
else
{
$datecut = TIMENOW - $vbulletin->options['cookietimeout'];  

    $buddys = $vbulletin->db->query_read("  
        SELECT  
        user.username, user.userid, user.lastactivity  
        FROM " . TABLE_PREFIX . "userlist AS userlist  
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = userlist.relationid)  
        WHERE userlist.userid = {$vbulletin->userinfo['userid']} AND userlist.relationid = user.userid AND type = 'buddy' AND user.lastactivity > $datecut  
        ORDER BY username ASC  
    ");  
    $output = '';  


    while ($buddy = $vbulletin->db->fetch_array($buddys))  
    {      
            $output .= ' <a href="member.php?' . $buddy['userid'] . '"><font color=blue><b>' . $buddy['username'] . '</b></font></a> ';  
    } 
if ($output != '')
    {
    $output = '<font color=black>Friends online:</font>' . $output;
    
$template_hook['navtab_end'] .= '  

<style type="text/css">  
#bottom {   
position: fixed;  
z-index:10000!important;
bottom: 0px;  
text-align: right; 
background-color: #eeeeee; 
}  
</style>  
<div id="bottom" class="blockhead">  

';  

$template_hook['navtab_end'] .= $output;  
$template_hook['navtab_end'] .= '  

</div>  

';
}
} 


[GamerPerfection]

Originally Posted by Sicilian

Can some please explain how exactly this is installed please.

Follow the instructions in the first post. Can't get any simpler than that.

[bulldog51981]

How can I add a comma to separated users in the list instead of just one after another?

[stationar]

The username design is in this part of the code:

PHP Code:

<a href="member.php?' . $buddy['userid'] . '"><font color=blue><b>' . $buddy['username'] . '</b></font></a> '; 


Put comma before </b>. This comma will stay after each name (even after the last one)

[bulldog51981]

Thank you! Worked like a charm!

[Sicilian]

Thanks working a treat.

It would be great if members had the option to enable and disable as they pleased. Could this option be added?

[stationar]

That would take a professional programmer and a product to create. (add fields to database, etc.) I won't be able to do it. I am just playing with the code.

[bulldog51981]

I am going to add an image to my "blockhead" stylevar for my forum display but when I do this it also carry's over to the background of the list and it is no longer white since the div id is calling from it. Is there anyway to override this to keep the background white?

[stationar]

You can try any other class: popupmenu, for example.

[Sicilian]

I've found that with this enabled, accessing the forum using an Ipad or iphone, the friends online widget scrolls up when your scroll upwards. It dont stay fixed at the bottom as it should.

[Sicilian]

Some info here http://blog.mspace.fm/2009/10/01/iph...osition-fixed/

I'm not a coder so not sure how to fix this, anyone any ideas?