Files
Testing/music_playlist.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

298 lines
6.8 KiB
PHP

<?php
/* $Id: music_ajax.php 42 2009-01-29 04:55:14Z john $ */
global $database, $user, $owner;
$task = ( !empty($_POST['task']) ? $_POST['task'] : ( !empty($_GET['task']) ? $_GET['task'] : "playlist" ) );
$user_id = $owner->user_info["user_id"];
$music_id = ( !empty($_POST['music_id']) ? $_POST['music_id'] : ( !empty($_GET['music_id']) ? $_GET['music_id'] : NULL ) );
$music_order = ( !empty($_POST['music_order']) ? $_POST['music_order'] : ( !empty($_GET['music_order']) ? $_GET['music_order'] : NULL ) );
$music_title = ( !empty($_POST['music_title']) ? $_POST['music_title'] : ( !empty($_GET['music_title']) ? $_GET['music_title'] : NULL ) );
// GENERATE PLAYLIST
if( $task=="playlist" || !$task )
{
?>
<ul id="playlists" style="display:none;">
<?php
// GET MUSIC
{
// GENERATE QUERY
$sql = "
SELECT
";
// SELECT FIELDS
if( $select )
$sql .= " $select ";
else
$sql .= " se_music.* ";
if( !$user_id && !$select ) $sql .= ",
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
";
$sql .= "
FROM
se_music
";
if( !$user_id ) $sql .= "
LEFT JOIN
se_users
ON se_users.user_id=se_music.music_user_id
WHERE se_users.user_enabled='1'
";
if( $user_id ) $sql .= "
WHERE
se_music.music_user_id='{$user_id}' AND playlist=1
";
/*if( !$this->user_id ){$sql .= " AND
se_users.user_enabled='1'
";}
*/
if( $user_id && $where )
$sql .= " && ";
elseif( $where )
$sql .= " && ";
if( $where )
$sql .= " $where ";
// CUSTOM
if( $music_order )
$sql .= " ORDER BY $sort_by ";
// IF USER ID AND WHERE UNSET, ASSUME PROFILE
elseif( !$music_order && $user_id )
$sql .= " ORDER BY se_music.music_track_num ASC";
// OTHERWISE ASSUME SEARCH
else
$sql .= " ORDER BY se_music.music_id ASC";
//echo $sql;
$resource = $database->database_query($sql);// or die($database->database_error()." <b>SQL was: </b>$sql");
if( $database->database_num_rows($resource)>0){
?>
<li data-source="mixedPlaylist" data-playlist-name="Bate Audio Tracks" data-thumbnail-path="">
<p class="fwduvp-categories-title"><span class="fwduvp-header">Title: </span><span class="fwduvp-title">Bate Audio Tracks123</span></p>
<p class="fwduvp-categories-type"><span class="fwduvp-header">Type: </span>HTML</p>
<p class="fwduvp-categories-description"><span class="fwduvp-header">Description: </span>Bate Audio Tracks</p>
</li>
<?php }
// GENERATE QUERY
$sql = "
SELECT
";
// SELECT FIELDS
if( $select )
$sql .= " $select ";
else
$sql .= " se_music.* ";
if( !$user_id && !$select ) $sql .= ",
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
";
$sql .= "
FROM
se_music
";
if( !$user_id ) $sql .= "
LEFT JOIN
se_users
ON se_users.user_id=se_music.music_user_id
WHERE se_users.user_enabled='1'
";
if( $user_id ) $sql .= "
WHERE
se_music.music_user_id='{$user_id}' AND playlist=2
";
/*if( !$this->user_id ){$sql .= " AND
se_users.user_enabled='1'
";}
*/
if( $user_id && $where )
$sql .= " && ";
elseif( $where )
$sql .= " && ";
if( $where )
$sql .= " $where ";
// CUSTOM
if( $music_order )
$sql .= " ORDER BY $sort_by ";
// IF USER ID AND WHERE UNSET, ASSUME PROFILE
elseif( !$music_order && $user_id )
$sql .= " ORDER BY se_music.music_track_num ASC";
// OTHERWISE ASSUME SEARCH
else
$sql .= " ORDER BY se_music.music_id ASC";
//echo $sql;
$resource1 = $database->database_query($sql);// or die($database->database_error()." <b>SQL was: </b>$sql");
if( $database->database_num_rows($resource1)>0){
?>
<li data-source="musicPlaylist" data-playlist-name="Music" data-thumbnail-path="">
<p class="fwduvp-categories-title"><span class="fwduvp-header">Title: </span><span class="fwduvp-title">Music</span></p>
<p class="fwduvp-categories-type"><span class="fwduvp-header">Type: </span>HTML</p>
<p class="fwduvp-categories-description"><span class="fwduvp-header">Description: </span>Music Playlist</p>
</li>
<?php }?>
</ul>
<?php
// GET MUSIC
{
if( $database->database_num_rows($resource)>0){
?>
<ul id="mixedPlaylist" style="display:none;"><?php
$music_array = array();
while( $musiclist=$database->database_fetch_array($resource) )
{
if( $musiclist['music_filesize'] )
$musiclist['music_filesize'] = round(($musiclist['music_filesize'] / 1024) / 1024, 2);
?>
<li data-thumb-source="" data-video-source="[{source:'<?php
echo get_userdir($user_id)."".$musiclist['music_id'].".".$musiclist['music_ext'];?>', label:''}]" data-start-at-video="0" data-downloadable="no">
<div data-video-short-description="">
<div>
<p class="fwduvp-thumbnail-title"><?php echo $musiclist["music_title"];?></p>
<p class="fwduvp-thumbnail-description"></p>
</div>
</div>
<div data-video-long-description="">
<div>
<p class="fwduvp-video-title"><?php echo $musiclist["music_title"];?></p>
<p class="fwduvp-video-main-description"></p>
</div>
</div>
</li>
<?php
$music_array[] = $musiclist;
}
?></ul><?php }
//var_dump($music_array);
}
{
if( $database->database_num_rows($resource1)>0){
?><ul id="musicPlaylist" style="display:none;"><?php
$music_array = array();
while( $musiclist=$database->database_fetch_array($resource1) )
{
if( $musiclist['music_filesize'] )
$musiclist['music_filesize'] = round(($musiclist['music_filesize'] / 1024) / 1024, 2);
?>
<li data-thumb-source="" data-video-source="[{source:'<?php
echo get_userdir($user_id)."".$musiclist['music_id'].".".$musiclist['music_ext'];?>', label:''}]" data-start-at-video="0" data-downloadable="no">
<div data-video-short-description="">
<div>
<p class="fwduvp-thumbnail-title"><?php echo $musiclist["music_title"];?></p>
<p class="fwduvp-thumbnail-description"></p>
</div>
</div>
<div data-video-long-description="">
<div>
<p class="fwduvp-video-title"><?php echo $musiclist["music_title"];?></p>
<p class="fwduvp-video-main-description"></p>
</div>
</div>
</li>
<?php
$music_array[] = $musiclist;
}
?></ul><?php
}
//var_dump($music_array);
}
}}
?>