Location: PHPKode > projects > PHPmotion Media Sharing CMS > videoplaylist.php
<?php

///////////////////////////////////////////////////////////////////////////////////////
// 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                                                                //
///////////////////////////////////////////////////////////////////////////////////////

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

//////////////////////////////
//check if user is logged in
//////////////////////////////

if ($user_id == ""){
echo '<p align="center"><font color="#FF4242" face="Arial" size="2"><b>'.$config["must_login"].'</b></font>';
die();
}



$blk_notification = '';//reset	notifications
$show_create_new = 1 ;//show create new list
$show_main_list_actions = 1;//show list tables etc (only if user has a created list, else hide)

///////////////////////////////
//Check if member has playlists
///////////////////////////////

function ShortenText($text) {
$chars = 60; //maximum to show
if (strlen($text) > $chars){
$dot_dot = '...';
}else{
$dot_dot = '';
}
$text = $text." ";
$text = substr($text,0,$chars);
$text = substr($text,0,strrpos($text,' '));
$text = $text.$dot_dot;
return $text;
}


$sql = "SELECT * FROM video_playlist WHERE user_id = $user_id ORDER BY list_name ASC";
if (@mysql_num_rows(mysql_query($sql)) == 0) {
    $show_main_list_actions = '';//show list menu / actions
    $show_main_list_table = '';//do now show list table
    $blk_notification = 1;
    $message_type = $config['word_notice'];
    $error_message = $config['Playlists_none'];
}
else {
    //create pull down menu for list
    $query = mysql_query($sql);
    while ($result = mysql_fetch_array($query)) {
      	$shortened_name = ShortenText($result['list_name']);
        $pulldown_list = $pulldown_list.'<option value="'.$result['list_id'].'">'.$shortened_name.
            '</option>';
    }
}

//////////////////////
//Create new play list
//////////////////////
if ($_POST['submitted_new_list'] == 'yes') {
    $blk_notification = 0;//rest

    $list_name = @mysql_real_escape_string($_POST['list_name']);

    //check if  list name is empty
    if ($list_name == '') {
        $blk_notification = 1;
        $message_type = $config["notification_error"];
        $error_message = $config["fill_all_fields"];
        tbs_render_page(1,1);//options: mysql_close and die()
    }

    //check if I already have list with exact same name
    $sql = "SELECT * FROM video_playlist WHERE user_id = $user_id AND list_name = '$list_name'";
    if (@mysql_num_rows(mysql_query($sql)) > 0) {
        $blk_notification = 1;
        $message_type = $config["notification_error"];
        $error_message = $config['Playlists_duplicate'];
        tbs_render_page(1,1);//options: mysql_close and die()
    }

    //create new list
    $sql = "INSERT INTO video_playlist (list_name, user_id) VALUES ('$list_name', $user_id)";
    @mysql_query($sql);

    //check if created ok
    $sql = "SELECT * FROM video_playlist WHERE user_id = $user_id AND list_name = '$list_name'";
    if (@mysql_num_rows(mysql_query($sql)) == 0) {
        $blk_notification = 1;
        $message_type = $config["notification_error"];
        $error_message = $config["error_26"];
        tbs_render_page(1,1);//options: mysql_close and die()
    }
    else {
        $blk_notification = 1;
        $message_type = $config["notification_success"];
        $error_message = $config["error_25"];//success
        $show_main_list_actions = 1;

        //get updated pull down list
        $pulldown_list ="";
        $sql = "SELECT * FROM video_playlist WHERE user_id = $user_id ORDER BY list_name ASC";
        $query = mysql_query($sql);
    while ($result = mysql_fetch_array($query)) {
      	$shortened_name = ShortenText($result['list_name']);
        $pulldown_list = $pulldown_list.'<option value="'.$result['list_id'].'">'.$shortened_name.
            '</option>';
    }

        tbs_render_page(1,1);//options: mysql_close and die()
    }
}

//////////////////////////////
//POST ACTIONS ON PLAY LISTS
//////////////////////////////
if ($_POST['submitted_playlist_action'] == 'yes') {
$playlists_id = mysql_real_escape_string($_POST['my_playlists']);



//Delete List and also videos from lists table
///////////////////////////////////////////////
if ($_POST['selected_box'] == 'delete'){

$sql = "DELETE FROM video_playlist WHERE list_id = $playlists_id AND user_id  = $user_id";
@mysql_query($sql);

$sql = "DELETE FROM video_playlist_lists WHERE list_id = $playlists_id AND user_id  = $user_id";
@mysql_query($sql);

        $blk_notification = 1;
        $message_type = $config["notification_success"];
        $error_message = $config["error_25"];//success
        $show_main_list_actions = 1;

                //get updated pull down list
                $pulldown_list ="";
        $sql = "SELECT * FROM video_playlist WHERE user_id = $user_id ORDER BY list_name ASC";
        $query = mysql_query($sql);
    while ($result = mysql_fetch_array($query)) {
      	$shortened_name = ShortenText($result['list_name']);
        $pulldown_list = $pulldown_list.'<option value="'.$result['list_id'].'">'.$shortened_name.
            '</option>';
    }
}




//display all videos
////////////////////
if ($_POST['selected_box'] == 'show' || $_POST['selected_box'] == 'delete'){ //this just shows results on list
$show_main_list_table = 1;
$result =array();
$sql = "SELECT * FROM video_playlist_lists WHERE list_id = $playlists_id AND user_id  = $user_id";
$query = @mysql_query($sql);
while ($result1 = @mysql_fetch_array($query)){

$play_list_video_id = $result1['video_id'];

//get video details
$sql2 = "SELECT * FROM videos WHERE indexer = $play_list_video_id";
$query2 = mysql_query($sql2);
$results2 = mysql_fetch_array($query2);

//join the 2 arrays

$merged_array = array_merge($results2, $result1);

$result[] = $merged_array;
}


//get list title
$sql = "SELECT * FROM video_playlist WHERE list_id = $playlists_id";
$query = mysql_query($sql);
$result3 = mysql_fetch_array($query);
$shortened_name = ShortenText($result3['list_name']);

//set condition for hidding (position, delete from list) to <tr>
if (empty($result)){
$show = 2;
}else{
$show = 1;
}



//show header of table with list name
$show_title = 1;

if ($_POST['selected_box'] == 'delete'){ //do not show anything if action was delete a list
	$show_title = '';
	$show = '';
	}

//show results
tbs_render_page2(1,1,$result); //options: mysql_close and die()
}




/////////////////////////////////////////////////
//show play list (as generated by myplaylist.php)
/////////////////////////////////////////////////
if ($_POST['selected_box'] == 'play'){

//check if list has videos
$sql = "SELECT * FROM video_playlist_lists WHERE list_id = $playlists_id AND user_id  = $user_id";
$query = @mysql_query($sql);
if(mysql_num_rows($query) < 0){

	//show nothing found
	$show = 2;
	$show_player = '';
	}else{

//load player table
$count_videos = mysql_num_rows($query);
$show_player = 1;
$show = '';
$show_title = 2;
$show_create_new = '';

		}


	}


}





//////////////////////////////
//GET ACTIONS ON PLAY LISTS
//////////////////////////////

if ($_GET['act']=='del' && $_GET['vid'] != "" && $_GET['id'] != ""){


$playlists_id = mysql_real_escape_string($_GET['id']);
$del_vid = mysql_real_escape_string($_GET['vid']);

//Delete Video >>
$sql = "DELETE FROM video_playlist_lists WHERE list_id = $playlists_id AND video_id = $del_vid AND user_id = $user_id";
@mysql_query($sql);
        $blk_notification = 1;
        $message_type = $config["notification_success"];
        $error_message = $config["error_25"];//success
        $show_main_list_actions = 1;
//del video end<<


$show_main_list_table = 1;
$result =array();
$sql = "SELECT * FROM video_playlist_lists WHERE list_id = $playlists_id AND user_id  = $user_id";
$query = @mysql_query($sql);
while ($result1 = @mysql_fetch_array($query)){

$play_list_video_id = $result1['video_id'];

//get video details
$sql2 = "SELECT * FROM videos WHERE indexer = $play_list_video_id";
$query2 = mysql_query($sql2);
$results2 = mysql_fetch_array($query2);

//join the 2 arrays

$merged_array = array_merge($results2, $result1);

$result[] = $merged_array;
}

//set condition for hidding (position, delete from list) to <tr>
if (empty($result)){
$show = 2;
}else{
$show = 1;
}

//show header of table with list name
$show_title = 1;

//show results
tbs_render_page2(1,1,$result); //options: mysql_close and die()
}

//////////////////
//Load default page
//////////////////

//show default page
tbs_render_page(1,1);//options: mysql_close and die()

////////////////////////////
//TBS PAGE DISPLAY FUNCTIONS
////////////////////////////

function tbs_render_page($closemysql,$die) {
	global $user_theme;

    	$template = "themes/$user_theme/templates/inner_playlist_main.htm";//middle of page
    	$TBS = new clsTinyButStrong;
    	$TBS->NoErr = true;// no more error message displayed.
    	$TBS->LoadTemplate("$template");
    	$TBS->Render = TBS_OUTPUT;
    	$TBS->Show();

    	//close mysql?
    	if ($closemysql == 1) @mysql_close();

    	//die() ?
    	if ($die == 1) die();
}


function tbs_render_page2($closemysql,$die,$result) {
	global $user_theme;

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

	//close mysql?
    	if ($closemysql == 1) @mysql_close();

    	//die()
    	if ($die == 1) die();
}


?>
Return current item: PHPmotion Media Sharing CMS