CB

Overview
Activity
Roadmap
Issues
Gantt
Calendar
Wiki
Files

Custom queries

CB 1.2.2 new items
CB 1.2.3 closed issues
CB 1.3 closed tasks
CB 1.3.1 closed tasks
CB 1.4.0 closed tasks
CB 1.7 closed tasks
CB 1.7.1 closed tasks
CB 1.8.0 closed tasks
CB 1.8.1 closed tasks
CB 1.9 closed tasks
CB 1.9.1 closed tasks
CB 2.0 New features
CB 2.0 Resolved Bugs
CB 2.0.1 Resolved tasks
CB 2.0.10 Resolved tasks
CB 2.0.11 Resolved tasks
CB 2.0.12 Resolved tasks
CB 2.0.13 Resolved tasks
CB 2.0.14 Resolved tasks
CB 2.0.15 Resolved tasks
CB 2.0.2 Resolved tasks
CB 2.0.3 Resolved tasks
CB 2.0.4 Resolved tasks
CB 2.0.5 Resolved tasks
CB 2.0.6 Resolved tasks
CB 2.0.7 Resolved tasks
CB 2.0.8 Resolved tasks
CB 2.0.9 Resolved tasks
CB 2.1 Resolved tasks
CB 2.1.1 Resolved tasks
CB 2.1.2 Resolved tasks
CB 2.1.3 Resolved tasks
CB 2.1.4 Resolved tasks
CB 2.1.5 Resolved tasks
CB 2.1.6 Resolved tasks
CB 2.2 Resolved tasks
CB 2.2.1 Resolved tasks
CB 2.3 Resolved tasks
CB 2.4 Resolved tasks
CB 2.4.1 Resolved tasks
CB 2.4.2 Resolved tasks
CB 2.4.3 Resolved tasks
CB 2.4.4 Resolved tasks
CB 2.4.5 Resolved tasks
CB 2.4.6 Resolved tasks
CB 2.4.7 Resolved tasks
CB 2.5 Resolved tasks
CB 2.6 Resolved tasks
CB 2.6.1 Resolved tasks
CB 2.6.2 Resolved tasks
CB 2.6.3 Resolved tasks
CB 2.6.4 Resolved tasks
CB 2.7 Resolved tasks
CB 2.7.1 Resolved tasks
CB 2.7.2 Resolved tasks
CB 2.7.3 Resolved tasks
CB 2.7.3 Resolved tasks
CB 2.7.4 Resolved tasks
CB 2.8 Resolved tasks
CB 2.8.1 Resolved tasks
CB 2.8.2 Resolved tasks
CB 2.9.0 Resolved tasks
CB 2.9.1 Resolved tasks
CB 2.9.2 Resolved tasks
CB 2.9.3 Resolved tasks
CB 2.9.4 Resolved tasks
CB 2.9.4 Tasks left
CB 3.0 Tasks left

Actions

Copy link

Bug #1343

closed

Random order resorting during pagination

Added by nant almost 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

As described here:

http://www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,view/id,118696/catid,77/

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

History
Notes
Property changes

Actions

Copy link

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

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.

Actions

Copy link

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