Video Infusion PRO

Quote

I'm still using v3.2.0 with PF 7.02.07 waiting for PF9 final release before messing with it and all the transition headaches that will follow. In the meantime, is there a way to choose sort/list options of videos like, say by post date? If not by admin option, is there any guidance on how I would change it in the code?
- by batbaru1

Quote

$result = dbquery("SELECT v.*, vc.*, u.user_id, u.user_name, SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes FROM " . DB_VIDEO . " v
LEFT JOIN " . DB_VIDEO_CAT . " vc ON v.cat_id=vc.cat_id
LEFT JOIN " . DB_USERS . " u ON u.user_id=v.uid
LEFT JOIN " . DB_RATINGS . " tr ON tr.rating_item_id = v.id AND tr.rating_type='V'
WHERE " . groupaccess('vc.cat_access' . " AND v.cat_id = '" . $_GET['cat_id'] . "' GROUP BY v.name ASC LIMIT " . $_GET['rowstart'] . ",{$maxi}";