//use in html navigation: next>>
$pl = $pagination[0]['pl'];
//use in html navigation: <<previous
//get all videos
$all_videos = array();
$sql10 = "SELECT * FROM group_videos WHERE group_id = {$group_id} AND video_status='active' LIMIT {$set_limit}, {$limit}";
$query10 = @mysql_query($sql10);
while ($result10 = @mysql_fetch_array($query10)) {
//collect each videos details
$each_video = mysql_real_escape_string($result10['video_id']);
$sql11 = "SELECT * FROM videos WHERE indexer = {$each_video} AND approved = 'yes'";
$query11 = @mysql_query($sql11);
$result11 = @mysql_fetch_array($query11);
if (!empty($result11)) {
//get video star rating
$stars_array = stars_array($each_video);
//call the stars function (results returned as array)
//merge video data with stars array
$all_videos[] = array_merge($stars_array, $result11);
}
}
//set condition for hidding certain blocks (more videos)
if (empty($all_videos)) {
$show_v = 1;
} else {
$show_v = 2;
}
//get group comments
$limit2 = $config["comment_page_limits"];
$pagination2 = pagination("SELECT * FROM group_comments WHERE group_id = {$group_id} ORDER BY indexer DESC", $limit2);
$set_limit2 = $pagination2[0]['set_limit'];
}
$query = @mysql_query($sql);
while ($result_videos = @mysql_fetch_array($query)) {
$change_date = dateTimeDiff($result_videos['date_uploaded']);
$result_videos['date_uploaded'] = $change_date;
$uploaded_by = mysql_real_escape_string($result_videos['user_id']);
$video_length = mysql_real_escape_string($result_videos['video_length']);
$video_id = mysql_real_escape_string($result_videos['indexer']);
// get comments inforation IF NEEDED IN TEMPLATE
$sql2 = "SELECT indexer FROM videocomments WHERE video_id = {$video_id}";
$query2 = @mysql_query($sql2);
$comments_number = @mysql_num_rows($query2);
$comments_array = array('comments' => $comments_number);
// get video rating stars
$stars_array = array();
$stars_array = stars_array($video_id);
// get video uploaded by username
$sql_user = "******";
$uploaded_by = @mysql_query($sql_user);
$by_result = @mysql_fetch_array($uploaded_by);
$uploaded_by_username = $by_result['user_name'];
$uploaded_by_array = array('uploaded_by' => $uploaded_by_username);
// strip off the the video duration hours if null => 00:00:00
$video_length_hours = substr($video_length, 0, 2);
if ($video_length_hours == '00') {
$result_videos['video_length'] = substr($video_length, 3, 5);
}
// merge comments array and video array
$result_all_videos = @array_merge($result_videos, $comments_array, $stars_array, $uploaded_by_array);
$browse_videos[] = $result_all_videos;
}
if ($set_limit == 0) {
$results_show = 1;
}
if ($total_records == 0) {
$results_show = 0;
}
define($get_type, true);
while ($result1 = @mysql_fetch_array($query)) {
$media_id = mysql_real_escape_string($result1['indexer']);
$sql2 = "SELECT indexer FROM {$media_comments} WHERE {$row_id} = {$media_id}";
$query2 = @mysql_query($sql2);
$comments_number = @mysql_num_rows($query2);
$comments_array = array('comments' => $comments_number);
$id = $media_id;
if ($get_type == 'videos') {
$stars_array = stars_array($media_id);
} else {
include 'stars_include.php';
$stars_array = array('star1' => $star1, 'star2' => $star2, 'star3' => $star3, 'star4' => $star4, 'star5' => $star5);
}
// we need dynamic media image query
$result_image = $get_type;
switch ($result_image) {
case 'audios':
$pic_sql = "SELECT album_picture FROM audio_albums WHERE album_id = '{$media_id}' LIMIT 1";
$album_pic_result = @mysql_query($pic_sql);
$row = mysql_fetch_array($album_pic_result);
$album_pic_result = $row['album_picture'];
if ($album_pic_result != "") {
$album_pic = 'addons/audio/images/album_images/' . $album_pic_result;
} else {
