/////////////////////////////////////////////////////////////////////////////////////// // PHPmotion http://www.phpmotion.com // /////////////////////////////////////////////////////////////////////////////////////// // License: You are not to sell or distribute this software without permission // // Help and support please visit http://www.phpmotion.com // // Copyright reserved // /////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////// // extra config / display vars // /////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////// // all categories for sucker-menu $sucker_menu = ''; $show_empty = $config['show_categories_if_empty']; $sql = "SELECT channel_name, channel_name_seo, channel_id FROM channels ORDER BY channel_name ASC"; $query = @mysql_query($sql); while ($result = @mysql_fetch_array($query)) { $channel_name_seo = $result['channel_name_seo']; $channel_name = $result['channel_name']; $channel_id = $result['channel_id']; $sql_v = "SELECT indexer FROM videos WHERE channel_id = '$channel_id' AND approved = 'yes' $sql_public_private ORDER BY indexer DESC"; $query_v = @mysql_query($sql_v); $result_v = @mysql_fetch_array($query_v); $count_videos = @mysql_num_rows($query_v); // dont push array if empty and show is turned off if ( $show_empty == 'yes' ) { if ( $count_videos == '' ) { $count_videos = 0; $sucker_menu .= '