'Newest Member' frozen!!

[Samson]

I am useing the Forum Stats plugin and my subdreamer intergrates with vb3 and it says "welcome to member 'name' " and there have been almost 100 more people that have registered since then. I don't know what the problem is, it has never done this before.

[Ziad]

Upon looking into this I found something a bit odd. Many of your newer members have older join dates than your older members. This could be a vBulletin 3 bug.

For example this member:
http://forums.euroadrenaline.com/member.php?u=18
has the Join Date: 06-17-2004

Yet this newer member:
http://forums.euroadrenaline.com/member.php?u=100 (u=userid is greater than 18)
has the Join Date: 06-16-2004

The forum stats plugin displays the latest visitor by joindate, in this situation you could fix it by displaying the latest visitor by userid.

Find and open this file:
subdreamer/plugins/p19_forum_stats/forum_stats.php

On line 72 find this code:


$newest = $DB->query_first("SELECT userid, username FROM " . $tableprefix . "user ORDER BY joindate DESC");


Replace that code with this:



$newest = $DB->query_first("SELECT userid, username FROM " . $tableprefix . "user ORDER BY userid DESC");

[Samson]

Awesome, great thinking on your part :)

I just fixed that up.

[silvrhand]

setup NTP on your server so that the time doesn't drift.