298 lines
6.8 KiB
PHP
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);
|
|
|
|
|
|
}
|
|
|
|
|
|
}}
|
|
?>
|