Top 10 submissions statistics not ordered

Category: IPS Tracker - Download Manager (for IP.Board)
Viewed: 28 times

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 )
							)		);