Last user to register bug...
January 6th, 2009
What file is that code go into?
forum/index.php
Find on Line 90:
$getnewestusers=$DB_site->query_first("SELECT username,userid FROM user WHERE userid=$numbermembers");
That's the one you need to change, to which-ever version above you want :)
Katherine
$query = "select * from user order by userid desc limit 1";
in replacement to the SQL query that john suggested.
John
Let's have a look at my table "user":
I have entries for users with the id:
1 exists
2 to 5 doesn't exist
6 exists
7 to 24 doesn't exist
25 to 419 exists
The last member owns the userid 442 !
vB shows in the forumhome as last member the data of member 421 instead of 442 .... i think cause it simply counts the amount of entries in the table "user" and adds the name and link of the my member 421 (the real amount of members) instead of the last entry in the table ....
How could i fix this?
Should vB offers something like "Renumber members" in the controlpanel?
Hope that made sense:)
$getnewestusers=$DB_site->query_first("SELECT username,userid FROM user ORDER BY joindate DESC LIMIT 1");
John
#If you have any other info about this subject , Please add it free.# |
