Trying to fix this bug:<br />http://www.ubbcentral.com/boards/showflat.php/Cat/0/Number/39688<br /><br />Is there a way in MySQL to Order the results retreived from the the Boards table by the sort order of the Categories table? They are related by the category number which is on both tables.

OK, found a solution.<br />As an example for the postlist jump menu:<br /><br />In ubbt.inc.php<br />in function jump_box<br /><br />Find<br /><br /> $query = "<br /> SELECT Bo_Number,Bo_Title,Bo_Keyword,Bo_Cat,Bo_CatName,Bo_Sorter<br /> FROM {$config['tbprefix']}Boards<br /> WHERE Bo_Active='1'<br /> $groupquery<br /> $thiscat<br /> ORDER BY Bo_Cat,Bo_Sorter<br /><br />Replace with<br /><br /> $query = "<br /> SELECT t1.Bo_Number,t1.Bo_Title,t1.Bo_Keyword,t1.Bo_Cat,t1.Bo_CatName,t1.Bo_Sorter<br /> FROM {$config['tbprefix']}Boards AS t1<br /> LEFT JOIN {$config['tbprefix']}Category AS t2 ON t1.Bo_Cat = t2.Cat_Entry<br /> WHERE Bo_Active='1'<br /> $groupquery<br /> $thiscat<br /> ORDER BY t2.Cat_Number ,t1.Bo_Sorter