Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Issue information

Issue ID
#024831
Status
Fixed
Version
2.2.2
Fixed in
2.0.4
Severity
0 - None Assigned

Issue Confirmations

Yes (0)No (0)

0

Top 10 submissions statistics not ordered

Posted by Martin A. on 15 August 2010 - 07:45 PM

They are ordered by submissions, but the query itself is ordered by the index file_submitter.

//-----------------------------------------
		// Top 10 submitters
		//-----------------------------------------
		
		$this->DB->build( array(
									'select'	=> 'COUNT(file_id) as submissions, MAX(file_id) as last_id, file_submitter',
									'from'		=> 'downloads_files',
									'group'		=> 'file_submitter',
									'limit'		=> array( 10 )
							)		);

Should be

//-----------------------------------------
		// Top 10 submitters
		//-----------------------------------------
		
		$this->DB->build( array(
									'select'	=> 'COUNT(file_id) as submissions, MAX(file_id) as last_id, file_submitter',
									'from'		=> 'downloads_files',
									'group'		=> 'file_submitter',
									'order'		=> 'submissions DESC',
									'limit'		=> array( 10 )
							)		);

Back to top

bfarber

Aug 16 2010 09:41 AM

Updating status to: Confirmed - Admin CP General

Not verified

Back to top

Martin A.

Aug 16 2010 08:14 PM

Just to add some more clarifying information. The query is ordered by the member ID. So if you have 11 members on your board, and all of them have submissions, the 11th member will not be included no matter how many submissions him/her has.