Actions
Bug #1343
closedRandom order resorting during pagination
Description
Files
Actions
Added by nant over 15 years ago. Updated about 15 years ago.
Description
Files
1343.patch (806 Bytes) 1343.patch | comprofiler.php | krileon, 09 February 2010 15:57 | |
1343_html.patch (797 Bytes) 1343_html.patch | comprofiler.html.php | krileon, 09 February 2010 15:57 |
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
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.
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.