Bug #1343
closed
Random order resorting during pagination
Description
Files
Updated by krileon almost 15 years ago
RAND in admin.comprofiler.html.php on lines 284, 287, and 318 need to contain a unique identifier on a list by list basis to ensure the same "randomized" is used when changing pages; RAND. Possible solution to use listid? or randomly generated then session stored?
MYSQL Reference Manual: http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_rand
Session stored method example: http://nyrodev.info/index.php/2008/03/18/189-php-mysql-how-to-paged-with-a-random-order
Updated by krileon almost 15 years ago
- File 1343.patch 1343.patch added
- File 1343_html.patch 1343_html.patch added
- Assignee set to beat
- Target version set to CB 1.2.2
- % Done changed from 0 to 80
Added ability to generate up to 4 digit random number to be used as RAND identifier. Identifier is added to paging links to keep paging consistent, but is not added to form. Performing a search will re-randomize keeping randomization.. random. This prevents duplicates from appearing when changing pages, which would prevent users from ever seeing all users on the list.
Updated by beat almost 15 years ago
- Status changed from New to Closed
- % Done changed from 80 to 100
- Estimated time set to 2:00 h
Applied in r883 in the sense that principle slightly differently in html to not duplicate code, and also taking in account limitstart to not refetch the rand param.