<?php
include_once "common.php";
if (LoggedIn() === true) {
$ownerid = GetUserIdByName(GetUserName());
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>3pm - Home</title>
<script type="text/javascript">
function CallParentSetTrackToPlay( divObj ) {
var trackKey = divObj.getAttribute( 'data-keycode' );
var trackId = divObj.getAttribute( 'data-trackid' );
var trackTitle = divObj.getAttribute( 'data-title' );
var trackArtist = divObj.getAttribute( 'data-artist' );
var trackAlbum = divObj.getAttribute( 'data-album' );
parent.SetTrackToPlay( trackKey, trackTitle, trackArtist, trackAlbum, trackId );
}
function ClearSelection() {
if(document.selection && document.selection.empty) {
document.selection.empty();
} else if(window.getSelection) {
var sel = window.getSelection();
sel.removeAllRanges();
}
}
document.onclick = parent.CloseUserMenu;
</script>
<link type="text/css" rel="stylesheet" href="style.css">
<?php
include_once "common.php";
if (LoggedIn() === true) {
$userid = GetUserIdByName($_SESSION['user']);
if (isset($_POST['submit'])) {
// If submitted....
$playlistname = mysql_real_escape_string(stripslashes($_POST['playlistname']));
$numberofsongs = (int) mysql_real_escape_string(stripslashes($_POST['playlistname']));
if ($_POST['playlistselect'] == "-1") {
// If -1, then INSERT.
$sql = "INSERT INTO `playlists` ( `userId`, `createDate`, `updateDate`, `name`, `adds` ) " . "VALUES ( {$userId}, NOW(), NOW(), '{$playlistname}', 0 ); ";
mysql_query($sql);
// Get the newly inserted playlist id.
$sql = "SELECT id FROM `playlists` WHERE `userid` = {$userId} AND `name` = '{$playlistname}'; ";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$playlistid = $row['id'];
break;
}
// Insert all song IDs into the 'playlistitems' table.
for ($i = 0; $i < $numberofsongs; $i++) {
$songid = mysql_real_escape_string(stripslashes($_POST['songid' . $i]));
if ($songid != "") {
$sql = "INSERT INTO `playlistitems` ( `playlistid`, `trackid`, `sort` ) " . "VALUES ( {$playlistid}, {$songid}, {$i} ); ";
// for now, sort in the order the songs are fed in.
}
}
echo "Playlist saved. <a href='#' onclick='window.parent.TogglePopupBg();' title='Click here to close this window.'>Close this window.</a>";
exit;
} else {
