Forum Home Enhancements - Newest 5 Members

Newest 5 Members
3.6 ONLY
Brought to you by the vB Nova Team

What it does
It adds a line to the Site statisitcs which lists the newest 5 members:

Newest 5 Members: user 1, user 2, user 3, user 4, user 5.

Install
Import the attached xml file into the PLUGIN section of your acp NOT product and then open up the template FORUMHOME FIND:

You must first be a registered member to view any code.

Add after:

You must first be a registered member to view any code.

Enjoy

[Slyfox]

Installed, but when I view the forum I get a DB error ?

[Nick R]

Whats the error?

EDIT: i have a pretty good idea hold on

[Slyfox]

Database error in vBulletin 3.6.0:

Invalid SQL:

SELECT userid, username FROM user ORDER BY joindate DESC LIMIT 5;

MySQL Error : Table 'nsherida_vb.user' doesn't exist
Error Number : 1146
Date : Sunday, August 20th 2006 @ 06:35:14 PM
Script : http://www.theuglybuggers.com/forum/index.php
Referrer : http://www.theuglybuggers.com/forum/...ex.php?do=head
IP Address : xxx.xxx.xxx.xxx
Username : Slyfox
Classname : vb_database

EDIT**

My users table is nsherida_vb.vb_users

[Nick R]

try it now, just updated main post attachment.

[Slyfox]

Installed, but its only showing one new member...

[Nick R]

Fixed now

[Slyfox]

Awesome!

EXACTLY what I wanted. Thanks for your time!

[G_man]

Sweet.... I didn't like both lines, so just remarked out the other and added yours rogersnm. Works a trick.

Cheers!

[ahmed-samara]

nice thanks