need two var's.. simple question..

[andewy3k]

I need the two variables, not sure if that's what I can reefer to them as.

Its for my forum statistics panel.

Last Registered User
Top Poster

thanks ahead of time

[Kirk Y]

There's already a variable for the Latest User.

Latest User:

$newusername = $vbulletin->userstats['newusername'];

Top Poster: [sql]$topposter = $db->query_first("
SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts
FROM " . TABLE_PREFIX . "user
WHERE posts > 0
ORDER BY posts DESC LIMIT 1");[/sql]

Use $topposter[username], $topposter[userid], $topposter[usergroupid], or $topposter[posts] as variables.

[andewy3k]

thanks, so do I paste these right in the template? No right?

Is it possible to just use $newusername and $topposter[username] without that code?

no huh?

some help needed

[Kirk Y]

Depending on what page you're trying to display these on, you can use Plugins.

[andewy3k]

FORUMHOME template

maybe in the future FORUMDISPLAY and SHOWTHREAD

let me know how it can be done for FORUMHOME, and if it can for the other two templates.

thanks ahead of time.

[Kirk Y]

Create a New Plugin using Hook Location "forumhome_start". Fill it with this:

$topposter = $db->query_first("
SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts
FROM " . TABLE_PREFIX . "user
WHERE posts > 0
ORDER BY posts DESC LIMIT 1");

$newusername = $vbulletin->userstats['newusername'];

[andewy3k]

works great! THANK YOU! I used $topposter[username] and $newusername

so if I want to use this plugin on another template I just change the hook location, correct?

Thanks again..

[Kirk Y]

Right, or you can make another hook using the same contents, but change the location. Forumdisplay is (I believe) forumdisplay_start and Showthread is (Again, I believe) showthread_start.