vb.org Archive - Whos Online Titles

Prerequisite: [HowTo] Add Custom Pages to WOL

If you have spent any time adding your custom scripts to show up as valid locations, you have probably wondered how to get the title of the blog entry, download, help ticket, store item, etc...

For my example, I'll base it on my project I was working on which was a blog system. Assuming the user views viewblog.php?userid=1, we can access the userid value of 1 using the 'values' element of $userinfo. The values element contains all the $_GET info of the user that was viewing.

PHP Code:


		
			
else if ($filename == 'viewblog.php')

{

    $userinfo['activity'] = 'blog_view';

    if ($userinfo['values']['userid'])

    {

        global $blogUserids;

        $blogUserids .= ',' . $userinfo['values']['userid'];

        $userinfo['activity'] = 'blog_view';

    }

}

This adds to the list of userids that need the title queried for.

The next step is to retrieve those titles that we need, and to do this we use the "online_ids_titles" hook.

PHP Code:


		
			
global $blogUserids, $wol_blogUserids;

if ($blogUserids)

{

    $blogUseridQuery = $vbulletin->db->query_read("

        SELECT userid, title

        FROM " . TABLE_PREFIX . "blog_settings

        WHERE userid IN (0$blogUserids)

    ");

    $wol_blogUserids = array();

    while ($blogUser = $vbulletin->db->fetch_array($blogUseridQuery))

    {

        $wol_blogUserids[$blogUser['userid']] = $blogUser['title'];

    }

}

It is crucial that you give $blogUserids and $wol_blogUserids global scope here, because we are currently inside a function! The above code only functions if $blogUserids is true (contains value) so it will not function if no users are currently viewing any blogs. Each row from the database will be stored in an array associating the ID with the Title so we can easily access it later.

The final step is to show the data... in my plugin in the "online_location_unknown" hook, I have a switch for $userinfo['activity'] (which is defined above), so I can assign the text and newly retrieved title of the blog.

PHP Code:


		
			
switch ($userinfo['activity'])

{

// ...

    case 'blog_view':

        global $wol_blogUserids;



        $blogUserid =& $userinfo['values']['userid'];

        $blogTitle =& $wol_blogUserids[$blogUserid];

        $userinfo['action'] = 'Viewing Blog';

        $userinfo['where'] = '<a href="viewblog.php?' . $vbulletin->session->vars['sessionurl'] . "userid=$blogUserid\">$blogTitle</a>";

        $handled = true;

        break;



// ...

}

Again, we need to give global scope (this time to $wol_blogUserids), so that we can access the title of the blog. I assign $blogUserid and $blogTitle the values we want to use in the link, just because it makes writing the string easier and takes up less horizontal space. $userinfo['action'] is the main action that displays, and $userinfo['where'] is the extra optional bit of information that is displayed to the side or below.

To make any use of this, you will have to heavily modify it to work with your table structure and vb extension, but this should give you enough of an idea how to do it to be at least somewhat successfull.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01245 seconds Memory Usage 1,733KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: