ucast.upm.edu.my ~ Shell I

Editing file /var/www/seemore.php (0775)

<?php

///////////////////////////////////////////////////////////////////////////////////////
// PHPmotion                                                http://www.phpmotion.com //
///////////////////////////////////////////////////////////////////////////////////////
// License: You are not to sell or distribute this software without permission       //
// Main Author: Brian Shawa -  bshawa@gmail.com                                      //
// Help and support please visit http://www.phpmotion.com                            //
// Copyright reserved                                                                //
///////////////////////////////////////////////////////////////////////////////////////

include_once ("classes/config.php");

include_once ('classes/menu.php');
include_once ('classes/sessions.php');

$which_one = mysql_real_escape_string($_GET['load']);
$result_featured = array();

//**********************************************************
//
// Displaying the horizonatl rows type layout
//
//*********************************************************
//*********************************************************
$limit = mysql_real_escape_string($config["see_more_limits"]);//for small box views, page limit is set further down this script

//get featured videos ----------------------------
if ($which_one == "featured") {

$pagination = pagination("SELECT * FROM videos WHERE featured = 'yes' AND approved='yes' AND public_private = 'public' ORDER BY indexer DESC",
        $limit);
    $set_limit = $pagination[0]['set_limit'];
    $total_pages = $pagination[0]['total_pages'];
    $current_page = $pagination[0]['current_page'];
    $total_records = $pagination[0]['total_records'];
    $next_page = $pagination[0]['next_page'];//use in html navigation (src)
    $prev_page = $pagination[0]['prev_page'];//use in html navigation (src)
    $nl = $pagination[0]['nl'];//use in html navigation: next>>
    $pl = $pagination[0]['pl'];//use in html navigation: <<previous

$result_featured = array();
    $sql = "SELECT * FROM videos WHERE featured = 'yes' AND approved='yes' AND public_private = 'public' ORDER BY indexer DESC LIMIT $set_limit, $limit";
    $query = @mysql_query($sql);
    while ($result1 = @mysql_fetch_array($query)) {

//get comments inforation
        $video_id = mysql_real_escape_string($result1['indexer']);
        $sql2 = "SELECT * FROM videocomments WHERE video_id = $video_id";
        $query2 = @mysql_query($sql2);
        $comments_number = @mysql_num_rows($query2);
        $comments_array = array('comments' => $comments_number);
        $stars_array = stars_array($video_id);//call the stars function (results returned as array)
        //merge comments array and video array
        $result2 = @array_merge($result1, $comments_array, $stars_array);
        $result_featured[] = $result2;
    }
    $see_more_title = $config["featured"];
    ////////////////////////////////////////////
    //PAGINATION PLUS >> start  -- reusable code
    ////////////////////////////////////////////
    $url = 'seemore.php';//the url to be put in links - EDIT ME
    $additional_url_variable = '&load=featured';//add addtions information that goes in query string here , e.g. '&load=groups&friends=all' - EDIT ME

include_once ($include_base . '/classes/pagination.inc.php');
    //PAGINATION PLUS >> end

}

//------------------------------------------------

//get most views ---------------------------------
if ($which_one == "viewed") {

$pagination = pagination("SELECT * FROM videos WHERE approved='yes' AND public_private = 'public' ORDER BY number_of_views DESC",$limit);
    $set_limit = $pagination[0]['set_limit'];
    $total_pages = $pagination[0]['total_pages'];
    $current_page = $pagination[0]['current_page'];
    $total_records = $pagination[0]['total_records'];
    $next_page = $pagination[0]['next_page'];//use in html navigation (src)
    $prev_page = $pagination[0]['prev_page'];//use in html navigation (src)
    $nl = $pagination[0]['nl'];//use in html navigation: next>>
    $pl = $pagination[0]['pl'];//use in html navigation: <<previous

$result_featured = array();
    $sql = "SELECT * FROM videos WHERE approved='yes' AND public_private = 'public' ORDER BY number_of_views DESC LIMIT $set_limit, $limit";
    $query = @mysql_query($sql);
    while ($result1 = @mysql_fetch_array($query)) {

////////////////////////////////////////////
    //PAGINATION PLUS >> start  -- reusable code
    ////////////////////////////////////////////
    $url = 'seemore.php';//the url to be put in links - EDIT ME
    $additional_url_variable = '&load=viewed';//add addtions information that goes in query string here , e.g. '&load=groups&friends=all' - EDIT ME

include_once ($include_base . '/classes/pagination.inc.php');
    //PAGINATION PLUS >> end

}
//-----------------------------------------------------

//get most recent  -----------------------------------
if ($which_one == "recent") {

$pagination = pagination("SELECT * FROM videos WHERE approved='yes' AND public_private = 'public' ORDER BY indexer DESC",
        $limit);
    $set_limit = $pagination[0]['set_limit'];
    $total_pages = $pagination[0]['total_pages'];
    $current_page = $pagination[0]['current_page'];
    $total_records = $pagination[0]['total_records'];
    $next_page = $pagination[0]['next_page'];//use in html navigation (src)
    $prev_page = $pagination[0]['prev_page'];//use in html navigation (src)
    $nl = $pagination[0]['nl'];//use in html navigation: next>>
    $pl = $pagination[0]['pl'];//use in html navigation: <<previous

$result_featured = array();
    $sql = "SELECT * FROM videos WHERE approved='yes' AND public_private = 'public' ORDER BY indexer DESC LIMIT $set_limit, $limit";
    $query = @mysql_query($sql);
    while ($result1 = @mysql_fetch_array($query)) {

////////////////////////////////////////////
    //PAGINATION PLUS >> start  -- reusable code
    ////////////////////////////////////////////
    $url = 'seemore.php';//the url to be put in links - EDIT ME
    $additional_url_variable = '&load=recent';//add addtions information that goes in query string here , e.g. '&load=groups&friends=all' - EDIT ME

include_once ($include_base . '/classes/pagination.inc.php');
    //PAGINATION PLUS >> end
}
//------------------------------------------------------

//get most commented ------------------------------------
if ($which_one == "comments") {

//sort the final array by order of number of comments
    function arr_keys_multisort($arr, $my_key, $sort_type) {

foreach ($arr as $key => $row) {
            $arr_tmp[$key] = $row["$my_key"];

}

if ($sort_type == 'desc')
            @array_multisort($arr_tmp, SORT_DESC, $arr);
        else
            @array_multisort($arr_tmp, SORT_ASC, $arr);

return $arr;
    }

$result_featured = arr_keys_multisort($result_featured, 'comments', 'desc');
    $see_more_title = $config["most_comments"];
    ////////////////////////////////////////////
    //PAGINATION PLUS >> start  -- reusable code
    ////////////////////////////////////////////
    $url = 'seemore.php';//the url to be put in links - EDIT ME
    $additional_url_variable = '&load=comments';//add addtions information that goes in query string here , e.g. '&load=groups&friends=all' - EDIT ME

include_once ($include_base . '/classes/pagination.inc.php');
    //PAGINATION PLUS >> end

}
//----------------------------------------------------------

//**********************************************************
//
// Displaying the small box type layout
//
//*********************************************************
//*********************************************************

$limit = $config['seemore_limits_wide'];//lit for all the small box type layous calls

//see more group videos --------------------------------------
if ($which_one == "groupsvideos") {
    $group_id = mysql_real_escape_string($_GET['gid']);

//delete group videos
    if ($_GET['del'] == 'yes') {
        $delete_vid_id = mysql_real_escape_string($_GET['vid']);
        $proceed = true;

if ($group_id == "" || $_GET['vid'] == "") {
            $error_message = $config['general_error'];
            $blk_notification = 1;
            $message_type = $config["notification_error"];
            $proceed = false;
        }

//check if user is logged in
        if ($user_id == "") {
            $error_message = $config["must_login"];
            $blk_notification = 1;
            $message_type = $config["notification_error"];
            $proceed = false;
        }

//SECURITY\\ ensure that i am the onwer
        $sql = "SELECT * FROM videos WHERE user_id = $user_id AND indexer = $delete_vid_id AND approved = 'yes'";
        $query = mysql_query($sql);
        if (mysql_num_rows($query) == 0) {
            $error_message = $config['general_error'];
            $blk_notification = 1;
            $message_type = $config["notification_error"];
            $proceed = false;
        }

if ($proceed == true) {
            //delete video to group
            $sql = "DELETE FROM group_videos WHERE video_id = $delete_vid_id AND group_id = $group_id";
            @mysql_query($sql);
            $error_message = $config['video_has_been_removed'];
            $message_type = $config["notification_success"];
            $blk_notification = 1;
        }
    }
    //delete end

//get list of all group videos
    //Pagination
    $pagination = pagination("SELECT * FROM group_videos WHERE group_id = $group_id",
        $limit);
    $set_limit = $pagination[0]['set_limit'];
    $total_pages = $pagination[0]['total_pages'];
    $current_page = $pagination[0]['current_page'];
    $total_records = $pagination[0]['total_records'];
    $next_page = $pagination[0]['next_page'];//use in html navigation (src)
    $prev_page = $pagination[0]['prev_page'];//use in html navigation (src)
    $nl = $pagination[0]['nl'];//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 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;
    }

//check if I am group admin to load admin features
    $delete_group_video = "";//show option to delete on each listed video
    if ($user_id != "") {
        $sql = "SELECT * FROM group_membership WHERE group_id = $group_id AND member_id = $user_id AND group_admin = 'yes'";
        $query = @mysql_query($sql);
        $am_i_admin = @mysql_num_rows($query);
        if ($am_i_admin == 0) {
            $delete_group_video = "";//show option to delete on each listed video
        }
        else {
            $some_action_group = $config["delete_general"];//show option to delete on each listed video
        }
    }

//get group name
    //get each groups details
    $sql1 = "SELECT * FROM group_profile WHERE indexer = $group_id";
    $query1 = @mysql_query($sql1);
    $result1 = @mysql_fetch_array($query1);
    $group_name = $result1['group_name'];

//create name fro display on see more page
    $see_even_more_title = $config['seemore_group_videos'] . ' - ' . $group_name;
    $see_even_more_out_link = $base_url . '/group_home.php?gid=' . $group_id;

////////////////////////////////////////////
    //PAGINATION PLUS >> start  -- reusable code
    ////////////////////////////////////////////
    $url = 'seemore.php';//the url to be put in links - EDIT ME
    $additional_url_variable = "&load=groupsvideos&gid=$group_id";//additional string info here , e.g. '&load=groups&friends=all'

include_once ($include_base . '/classes/pagination.inc.php');
    //PAGINATION PLUS >> end

$template = "templates/main_1.htm";
    $inner_template1 = "templates/inner_see_even_more.htm";//middle of page
    $TBS = new clsTinyButStrong;
    $TBS->NoErr = true;// no more error message displayed.
    $TBS->LoadTemplate("$template");
    $TBS->MergeBlock('mp', $all_videos);
    $TBS->Render = TBS_OUTPUT;
    $TBS->Show();

@mysql_close();
    die();
}
//-----------------------------------------------------------------

//see more members own videos --------------------------------------
if ($which_one == "membersvid") {
    $member_id = mysql_escape_string($_GET['uid']);

// check if uid is in the requesting url
    if ($member_id == "") {
        @mysql_close();
        header("Location: " . "index.php");
        die();
    }

// check if uid in request url is same as logged in members user_id. If so load update profile
    // showing a green error that user must logout to view their own profile
    if ($member_id == $user_id) {
        @mysql_close();
        header("Location: " . "myaccount.php?code=103");
        die();
    }

// no longer used by default since V2 - start
    //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

// otherwise proceed to retrieve members details - starting with profile informaton
    $sql = "SELECT * FROM member_profile WHERE user_id = $member_id";
    $query = @mysql_query($sql);
    // if no member found redirect to home page with error code
    if (@mysql_num_rows($query) == 0) {
        @header("Location: " . "index.php?code=102");
        die();
    }
    else {
        $result = mysql_fetch_array($query);
        // get all values for display on members profile section
        $members_username = $result["user_name"];
        $year_of_birth = $result["year_of_birth"];
        $gender = $result["gender"];
        $relationship_satus = $result["relationship_status"];
        $about_me = $result["about_me"];
        $personal_website = $result["personal_website"];
        $home_town = $result["home_town"];
        $home_country = $result["home_country"];
        $current_country = $result["current_country"];
        $high_school = $result["high_school"];
        $college = $result["college"];
        $work_places = $result["work_places"];
        $interests = $result["interests"];
        $fav_movies = $result["fav_movies"];
        $fav_music = $result["fav_music"];
        $current_city = $result["current_city"];
    }

// get members picture
    // check friends picture
    $sql = "SELECT * FROM pictures WHERE user_id = $member_id";
    $result1 = @mysql_query($sql);
    if (@mysql_num_rows($result1) != 0) {
        $result1 = mysql_fetch_array($result1);
        $result1_existing_file = $result1['file_name'];
        $result1_approved = $result1['approved'];
        if ($result1_approved == "yes") {
            // show current picture
            $result1_mypicture = $config['site_base_url'] . '/pictures/' . $result1_existing_file;
        }
        else {
            // show place holder image  for image "awaiting approval"
            $result1_mypicture = $config['site_base_url'] . '/image_s/placeholder.gif';
        }
    }
    else {
        // show place holder for no image uploaded by user at all
        $result1_mypicture = $config['site_base_url'] . '/image_s/placeholder.gif';

}

// no longer used by default V2 end
    //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

//Pagination
    $pagination = pagination("SELECT * FROM videos WHERE user_id = $member_id AND approved = 'yes' AND public_private = 'public'",
        $limit);
    $set_limit = $pagination[0]['set_limit'];
    $total_pages = $pagination[0]['total_pages'];
    $current_page = $pagination[0]['current_page'];
    $total_records = $pagination[0]['total_records'];
    $next_page = $pagination[0]['next_page'];//use in html navigation (src)
    $prev_page = $pagination[0]['prev_page'];//use in html navigation (src)
    $nl = $pagination[0]['nl'];//use in html navigation: next>>
    $pl = $pagination[0]['pl'];//use in html navigation: <<previous

//Select video to play
    include_once ('video_selector.php');

//display members snaphot video thumbs (3 total)
    $result = array();
    $sql = "SELECT * FROM videos WHERE user_id = $member_id AND approved = 'yes' AND public_private = 'public' LIMIT $set_limit, $limit";
    $query = @mysql_query($sql);
    while ($result1 = @mysql_fetch_array($query)) {

//get rating for each vide
        $video_id = $result1['indexer'];
        $stars_array = array();
        $stars_array = stars_array($video_id);
        //merge comments array and video array
        $result2 = @array_merge($result1, $stars_array);

$result[] = $result2;
    }

//set condition for hidding certain blocks (e.g "no emails to list")
    if (empty($result)) {
        $show_v = 1;
    }
    else {
        $show_v = 2;
    }
    /*END*/

// display page
    // checking for any error codes
    $codes = $_GET['code'];
    $error_code = errorcodes($codes);
    if (!empty($error_code)) {
        $blk_notification = $error_code['error_display'];
        $message_type = $error_code['error_type'];
        $error_message = $error_code['error_message'];
    }

//create name fro display on see more page
    $see_even_more_title = $members_username . ' - ' . $config['word_videos'];
    $see_even_more_out_link = $base_url . '/memberprofile.php?uid=' . $member_id;

////////////////////////////////////////////
    //PAGINATION PLUS >> start  -- reusable code
    ////////////////////////////////////////////
    $url = 'seemore.php';//the url to be put in links - EDIT ME
    $additional_url_variable = "&load=membersvid&uid=$member_id";//add addtions information that goes in query string here , e.g. '&load=groups&friends=all' - EDIT ME

include_once ($include_base . '/classes/pagination.inc.php');
    //PAGINATION PLUS >> end

$template = "templates/main_1.htm";
    $inner_template1 = "templates/inner_see_even_more.htm";//middle of page
    $TBS = new clsTinyButStrong;
    $TBS->NoErr = true;// no more error message displayed.
    $TBS->LoadTemplate("$template");
    $TBS->MergeBlock('mp', $result);
    $TBS->Render = TBS_OUTPUT;
    $TBS->Show();

@mysql_close();
    die();
}
//-------------------------------------------------------------

//see members favorites --------------------------------------
if ($which_one == "membersfavs") {
    $member_id = mysql_real_escape_string($_GET['uid']);

// check if uid is in the requesting url
    if ($member_id == "") {
        @mysql_close();
        header("Location: " . "index.php");
        die();
    }

// otherwise proceed to retrieve members details - starting with profile informaton
    $sql = "SELECT * FROM member_profile WHERE user_id = $member_id";
    $query = @mysql_query($sql);
    // if no member found redirect to home page with error code
    if (@mysql_num_rows($query) == 0) {
        header("Location: " . "index.php?code=102");
        die();
    }
    else {
        $result = @mysql_fetch_array($query);
        // get all values for display on members profile section
        $members_username = $result["user_name"];
        $year_of_birth = $result["year_of_birth"];
        $gender = $result["gender"];
        $relationship_satus = $result["relationship_status"];
        $about_me = $result["about_me"];
        $personal_website = $result["personal_website"];
        $home_town = $result["home_town"];
        $home_country = $result["home_country"];
        $current_country = $result["current_country"];
        $high_school = $result["high_school"];
        $college = $result["college"];
        $work_places = $result["work_places"];
        $interests = $result["interests"];
        $fav_movies = $result["fav_movies"];
        $fav_music = $result["fav_music"];
        $current_city = $result["current_city"];
    }

}

//Pagination
    $pagination = pagination("SELECT * FROM favorites WHERE user_id = $member_id", $limit);
    $set_limit = $pagination[0]['set_limit'];
    $total_pages = $pagination[0]['total_pages'];
    $current_page = $pagination[0]['current_page'];
    $total_records = $pagination[0]['total_records'];
    $next_page = $pagination[0]['next_page'];//use in html navigation (src)
    $prev_page = $pagination[0]['prev_page'];//use in html navigation (src)
    $nl = $pagination[0]['nl'];//use in html navigation: next>>
    $pl = $pagination[0]['pl'];//use in html navigation: <<previous

//Select video to play
    include_once ('video_selector.php');

/*
    * NOlonger used since V2 - start >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    * display members snaphot video thumbs (3 total)
    */
    $result = array();
    $sql = "SELECT * FROM favorites WHERE user_id = $member_id LIMIT $set_limit, $limit";
    $query = @mysql_query($sql);
    if (@mysql_num_rows($query) == 0) {
        $show_v = 1;
    }
    else {
        while ($result_members_favorites = @mysql_fetch_array($query)) {
            $fav_id = mysql_real_escape_string($result_members_favorites['video_id']);

// get more details about video i.e titles etc
            $sql2 = "SELECT * FROM videos WHERE indexer = $fav_id ";
            $query2 = @mysql_query($sql2);
            $result_members_fav_videos = @mysql_fetch_array($query2);

//get rating for each vide
            $video_id = $result_members_fav_videos['indexer'];
            $stars_array = array();
            $stars_array = stars_array($video_id);

//merge comments array and video array
            $result2 = @array_merge($result_members_fav_videos, $stars_array);
            $result[] = $result2;
        }
    }
    //NOlonger used since V2 - end >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

//create name fro display on see more page
    $see_even_more_title = $members_username . ' - ' . $config['word_favorites'];
    $see_even_more_out_link = $base_url . '/memberprofile.php?uid=' . $member_id;

////////////////////////////////////////////
    //PAGINATION PLUS >> start  -- reusable code
    ////////////////////////////////////////////
    $url = 'seemore.php';//the url to be put in links - EDIT ME
    $additional_url_variable = "&load=membersfavs&uid=$member_id";//add addtions information that goes in query string here , e.g. '&load=groups&friends=all' - EDIT ME

include_once ($include_base . '/classes/pagination.inc.php');
    //PAGINATION PLUS >> end

$template = "templates/main_1.htm";
    $inner_template1 = "templates/inner_see_even_more.htm";//middle of page
    $TBS = new clsTinyButStrong;
    $TBS->NoErr = true;// no more error message displayed.
    $TBS->LoadTemplate("$template");
    $TBS->MergeBlock('mp', $result);
    $TBS->Render = TBS_OUTPUT;
    $TBS->Show();

@mysql_close();
    die();
}
//---------------------------------------------------------

//See my own favs --------------------------------------
if ($which_one == "myfavs") {
	//check if user logged in
include_once ('classes/login_check.php');
    $show_error = 0;//reset error display
    $delete_vid_id = mysql_real_escape_string($_GET['vid']);
    $some_action_myfavs = $config["delete_general"];//show option to delete on each listed video

// check if this is a delete action
    if ($delete_vid_id != "") {
        $sql = "SELECT * FROM favorites WHERE user_id = $user_id AND indexer_fav = '$delete_vid_id'";
        $resut = @mysql_query($sql);
        if (@mysql_num_rows($resut) == 0) {
            $error_message = $config["error_11"]; //The video could not be found;
            $message_type = $config["notification_error"];
            $show_error = 1;
        }
        else {
            $sql = "DELETE FROM favorites WHERE user_id = $user_id AND indexer_fav = $delete_vid_id";
            $resut = @mysql_query($sql);
            $error_message = $config["video_has_been_removed"];
            $message_type = $config["notification_success"];
            $show_error = 1;

}
    }

//----------------------------resuable video display code----------------------------

// Pagination
    $pagination = pagination("SELECT * FROM favorites WHERE user_id = $user_id AND video_status='active'",
        $limit);
    $set_limit = $pagination[0]['set_limit'];
    $total_pages = $pagination[0]['total_pages'];
    $current_page = $pagination[0]['current_page'];
    $total_records = $pagination[0]['total_records'];
    $next_page = $pagination[0]['next_page'];//use in html navigation (src)
    $prev_page = $pagination[0]['prev_page'];//use in html navigation (src)
    $nl = $pagination[0]['nl'];//use in html navigation: next>>
    $pl = $pagination[0]['pl'];//use in html navigation: <<previous

/*-----------------------------reusable favorites code -------------------------------
    display members snaphot video thumbs (3 total)*/
    $member_favorites = array();
    $sql = "SELECT * FROM favorites WHERE user_id = $user_id AND video_status='active' LIMIT $set_limit, $limit";
    $query = @mysql_query($sql);
    if (@mysql_num_rows($query) == 0) {
        $show_v = 1;
    }
    else {
while ($result_members_favorites = @mysql_fetch_array($query)) {
$fav_id = mysql_real_escape_string($result_members_favorites['video_id']);
 //get more details about video i.e titles etc
 $sql2 = "SELECT * FROM videos WHERE indexer = $fav_id";
 $query2 = @mysql_query($sql2);
 if (@mysql_num_rows($query2) != 0) {
     $stars_array = stars_array($fav_id);
     //merge video data with stars array
     $result_members_fav_videos2 = @mysql_fetch_array($query2);
     $merged_fav = @array_merge($result_members_favorites,
       $result_members_fav_videos2,$stars_array);
     $member_favorites[] = $merged_fav;
 }
}
    }

//create name fro display on see more page
    $see_even_more_title = $config['word_my'] . ' ' .$config['favorites_video'].' - '.$total_records;
    $see_even_more_out_link = "";

////////////////////////////////////////////
    //PAGINATION PLUS >> start  -- reusable code
    ////////////////////////////////////////////
    $url = 'seemore.php';//the url to be put in links - EDIT ME
    $additional_url_variable = "&load=myfavs";//add addtions information that goes in query string here , e.g. '&load=groups&friends=all' - EDIT ME

include_once ($include_base . '/classes/pagination.inc.php');
    //PAGINATION PLUS >> end

/*END*/
    // display page
    //$error_message = $error_message;
    $blk_notification = $show_error;//html table - error block
    $template = "templates/main_1.htm";
    $inner_template1 = "templates/inner_see_even_more.htm";//middle of page
    $TBS = new clsTinyButStrong;
    $TBS->NoErr = true;// no more error message displayed.
    $TBS->LoadTemplate("$template");
    $TBS->MergeBlock('mp', $member_favorites);
    $TBS->Render = TBS_OUTPUT;
    $TBS->Show();

@mysql_close();
    die();
}
//---------------------------------------------------------

//See m own favs --------------------------------------
if ($which_one == "myvids") {

//check if user logged in
include_once ('classes/login_check.php');
// check if this is a delete action
$show_error = 0;//reset error display
$delete_vid_id = mysql_real_escape_string($_GET['vid']);
$some_action_myvids = 1;//show option to delete on each listed video

if ($delete_vid_id != "") {
    $sql = "SELECT * FROM videos WHERE user_id = $user_id AND indexer = '$delete_vid_id' AND approved ='yes'";
    $resut = @mysql_query($sql);
    if (@mysql_num_rows($resut) == 0) {
            $error_message = $config["error_11"]; //The video could not be found;
            $error_type = $config["notification_error"];
            $show_error = 1;
    }
    else {

//delete video from all sections and mark ready for admin to permanantly delete
            $video_id = mysql_real_escape_string($_GET['vid']);

//update videos by member (deleted) [NOTE: actual videos will be deleted on "server maintanance", i.e. all marked as pendingdelete]
            $sql = "UPDATE videos SET approved ='pendingdelete' WHERE indexer = $video_id";
            @mysql_query($sql);

//delete group videos by $video_id (deleted)
            $sql = "DELETE FROM group_videos WHERE video_id = $video_id";
            @mysql_query($sql);

//update all users favorite videos by $video_id (deleted)
            $sql = "UPDATE favorites SET video_status ='deleted' WHERE video_id = $video_id";
            @mysql_query($sql);

//delete from favorites
            $sql = "DELETE FROM favorites WHERE WHERE video_id = $video_id";
            @mysql_query($sql);

//delete from flagging
            $sql = "DELETE FROM flagging WHERE video_id = $video_id";
            @mysql_query($sql);

//delete from videocomments
            $sql = "DELETE FROM videocomments WHERE video_id = $video_id";
            @mysql_query($sql);

//show success message
            $error_message = $config["video_has_been_removed"];
            $error_type = $config["notification_success"];
            $show_error = 1;

// TODO: insert action to physically delete files here and to create a "File deleted" clip etc?
    }
}

//----------------------------resuable video display code----------------------------

// Pagination
$pagination = pagination("SELECT * FROM videos WHERE user_id = $user_id AND approved = 'yes' ORDER BY indexer DESC",
    $limit);
$set_limit = $pagination[0]['set_limit'];
$total_pages = $pagination[0]['total_pages'];
$current_page = $pagination[0]['current_page'];
$total_records = $pagination[0]['total_records'];
$next_page = $pagination[0]['next_page'];//use in html navigation (src)
$prev_page = $pagination[0]['prev_page'];//use in html navigation (src)
$nl = $pagination[0]['nl'];//use in html navigation: next>>
$pl = $pagination[0]['pl'];//use in html navigation: <<previous

// display members video thumbs
$result = array();
$sql = "SELECT * FROM videos WHERE user_id = $user_id AND approved = 'yes' ORDER BY indexer DESC LIMIT $set_limit, $limit";
$query = @mysql_query($sql);
while ($result1 = @mysql_fetch_array($query)) {

$video_id = mysql_real_escape_string($result1['indexer']);
                //get video star rating
                $stars_array = stars_array($video_id);//call the stars function (results returned as array)
                //merge video data with stars array
                $mergedvids=array_merge($stars_array,$result1);
    $result[] = $mergedvids;
}
// set condition for hidding certain blocks (e.g "no emails to list")
if (empty($result)) {
    $show_v = 1;
}
else {
    $show_v = 2;
}

// check how many videos awaiting approval if so , display number.
$sql2 = "SELECT * FROM videos WHERE user_id = $user_id AND approved = 'pending'";
$result2 = @mysql_query($sql2);
$pending_videos = @mysql_num_rows($result2);
if ($pending_videos > 0) {
    $show_p = 1;
}

//create name fro display on see more page
    $see_even_more_title = $config['word_my'] . ' ' . $config['word_videos'].' - '.$total_records;
    $see_even_more_out_link = "";

////////////////////////////////////////////
    //PAGINATION PLUS >> start  -- reusable code
    ////////////////////////////////////////////
    $url = 'seemore.php';//the url to be put in links - EDIT ME
    $additional_url_variable = "&load=myvids";//add addtions information that goes in query string here , e.g. '&load=groups&friends=all' - EDIT ME

include_once ($include_base . '/classes/pagination.inc.php');
    //PAGINATION PLUS >> end

$blk_notification = $show_error;//html table - error block
    $template = "templates/main_1.htm";
    $inner_template1 = "templates/inner_see_even_more.htm";//middle of page
    $TBS = new clsTinyButStrong;
    $TBS->NoErr = true;// no more error message displayed.
    $TBS->LoadTemplate("$template");
    $TBS->MergeBlock('mp', $result);
    $TBS->Render = TBS_OUTPUT;
    $TBS->Show();

@mysql_close();
    die();
}
//---------------------------------------------------------

//show "no videos to show" empty arrays
if (empty($result_featured)) {
    $show_v = 1;
}
else {
    $show_v = 2;
}

//display results
$template = "templates/main_1.htm";
$inner_template1 = "templates/inner_see_more.htm";//middle of page
$TBS = new clsTinyButStrong;
$TBS->NoErr = true;// no more error message displayed.
$TBS->LoadTemplate("$template");
$TBS->MergeBlock('blkfeatured', $result_featured);
$TBS->Render = TBS_OUTPUT;
$TBS->Show();

@mysql_close();
die();