Project

General

Profile

Actions
Copy link

Bug #1343

closed

Random order resorting during pagination

Added by nant about 15 years ago. Updated almost 15 years ago.

Status:
Closed
Priority:
Normal
Assignee:
beat
Target version:
CB 1.2.2
Start date:
10 December 2009
Due date:
% Done:

100%

Estimated time:
2:00 h

Description

Files

Download all 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
Actions
Copy link
 #1

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

Actions
Copy link Download all files
 #2

Updated by krileon almost 15 years ago

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.

Actions
Copy link
 #3

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.

Actions
Copy link

Also available in: Atom PDF