Pagination

Fillip H. said:

This has now been fixed.
The problem was the fact that the pagination generation didn't take into account banned users, but the actual list did.

You've banned like 150 people, haven't you xD


Oh, and also: If you got a database error email about "user.userid" something, that was my fault, sorry

Click to expand...

Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT COUNT(userid) AS totalusers
FROM dhv_user
LEFT JOIN dhv_usergroup AS usergroup ON (usergroup.usergroupid = user.usergroupid)
WHERE (usergroup.genericoptions & 32);

MySQL Error : Unknown column 'user.usergroupid' in 'on clause'
Error Number : 1054
Request Date : Tuesday, March 2nd 2010 @ 06:11:53 AM
Error Date : Tuesday, March 2nd 2010 @ 06:11:53 AM
Script : http://www.darkhandofvalor.com/vbac...20&sortorder=desc&sorttype=avgpercent&page=44
Referrer : http://www.dragonbyte-tech.com/showthread.php?p=217
IP Address : XXXXXXXXXXX
Username : TempUser
Classname : vB_Database
MySQL Version :

Click to expand...

Invalid SQL:

SELECT userid,

FROM dhv_user AS user
ORDER BY userid;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM dhv_user AS user
ORDER BY userid' at line 3
Error Number : 1064
Request Date : Tuesday, March 2nd 2010 @ 12:13:25 AM
Error Date : Tuesday, March 2nd 2010 @ 12:13:26 AM
Script : http://www.darkhandofvalor.com/cron.php?rand=1267510405
Referrer : http://www.darkhandofvalor.com/forum.php
IP Address : XXXXXXXXXXXX
Username : Unregistered
Classname : vB_Database
MySQL Version :

Click to expand...