Projects ⇒ Bugs ⇒ #587: Memberlist Pagination not correct ⇒ CPG Dragonfly™ CMS
Bug #587 Memberlist Pagination not correct
Project: Dragonfly 9.0.3 -> 9.3 Category: Members List
Submitted: Thursday, July 14, 2005 (16:33:10) Modified: Tuesday, August 09, 2005 (07:07:53)
Status: Closed Assigned to:
PHP Version: Irrelevant HTTPD Server: Apache 2.0
Votes: 1
Vote results:
Avg. Score: 5.0 ± 0.0 Reproduced: 1 of 1 (100.0%)
Same PHP Version: 1 (100.0%) Same HTTPD Server: 0 (0.0%)

View/Vote Add Comment

by: SCROFT
Description:
------------
The Memberlist only shows active accounts... accounts that are not suspended. But the pagenation does not parse out the suspended users.

On my site I have 15 pages of users... but pagenation shows 28 pages.


To fix this... Change line 238 from...
$sql = "SELECT count(*) AS total FROM " . USERS_TABLE . " WHERE user_id <> " . ANONYMOUS;

to this...
$sql = "SELECT count(*) AS total FROM " . USERS_TABLE . " WHERE user_id <> " . ANONYMOUS . " AND user_level > '0'";

Reproduce code:
---------------
Suspend a lot of accounts(more than 25 accounts willl do)...
Go to members list...
Click on the last link of pagenation...
The page is blank.


Expected result:
----------------
Pagenation should only count accounts that are not suspended.
by: Phoenix
This bug has been fixed in the CVS.

Snapshots of the sources are packaged every 6 hours; this change
will be in the next snapshot. You can grab the snapshot at the
Downloads section.

Thank you for the report, and for helping us to make CPG-Nuke 9.0.3 -> 9.1 better.

Many thanks to SCROFT
User Info

Welcome Anonymous



(Register)
Community

Support for DragonflyCMS in a other languages:

Deutsch
Español