Hall of Fame

[korobert]

Hello!

How can i change on chanel page: video order?

Thanks Robert

[Marius P.]

Hi,
tpl/{your theme}/channels.php

Code Select Expand

$vq = "select ".$options.", ".DB_PREFIX."users.name as owner FROM ".DB_PREFIX."videos LEFT JOIN ".DB_PREFIX."users ON ".DB_PREFIX."videos.user_id = ".DB_PREFIX."users.id WHERE ".DB_PREFIX."videos.category in (SELECT cat_id from ".DB_PREFIX."channels where cat_id = '".$channel->cat_id."' or child_of = '".$channel->cat_id."' ) and ".DB_PREFIX."videos.pub > 0 ORDER BY ".DB_PREFIX."videos.id DESC ".this_offset(4);

notice the

Code Select Expand

ORDER BY ".DB_PREFIX."videos.id DESC

[korobert]

SUPER !!!!!!!!!!!!

Thanks

[Marius P.]

With pleasure!