📄 index.php
字号:
}
}
function viewPlaylist() {
global $session;
#print("<p style='text-align:center'><a href='".$this->url."/".$this->file."index.php?action=showallplaylists'>View all user playlists.</a></p>");
$id = addslashes($_REQUEST['id']);
$current_playlist = addslashes($_REQUEST['id']);
if($_REQUEST['username'])
{
$username = addslashes($_REQUEST['username']);
}
else
{
$username = addslashes($session->username);
}
if( $current_playlist != "" ) {
$query = "SELECT username FROM playlist WHERE id = '".$current_playlist."'";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($result);
$username = $session->username;
}
print("<div id='content'>\n");
$query = "SELECT * FROM playlist WHERE username = '".$session->username."' ORDER BY playlist_name ASC";
$result = mysql_query($query) or die(mysql_error());
print("<table><tr><td>");
if( $username != "" && $username != $session->username ) {
$user = $this->get_info($username);
print("<form action='".$this->thisfile."?action=viewplaylist&username=".$username."' name='sort' method='post'>\n");
print($user['name']."'s playlists: <select name='id' onChange='javascript:document.sort.submit();'>\n");
print("<option value=''>-----</option>\n");
while( $playlist = mysql_fetch_assoc($result) )
{
if($current_playlist == "") { $current_playlist = $playlist['id']; }
print("<option value='".$playlist['id']."'".(($id==$playlist['id'])?" SELECTED":"").">".$playlist['playlist_name']."</option>\n");
if($id==$playlist['id']||$current_playlist==$playlist['id']) {
$playlistname=$playlist['playlist_name'];
}
}
print("</select></form>\n");
} else {
print(" ");
}
print("</td>\n");
print("<td style='text-align: right;'>\n");
if($session->username!="Guest") {
print("<form action='".$this->thisfile."?action=viewplaylist' name='mysort' method='post'>\n");
print("Your playlists: <select name='id' onChange='javascript:document.mysort.submit();'>\n");
$query = "SELECT * FROM playlist WHERE username = '".$session->username."' ORDER BY playlist_name ASC";
$result = mysql_query($query) or die(mysql_error());
print("<option value='' ".($session->username!=$username?"SELECTED":"").">-----</option>\n");
$i=0;
while($playlist = mysql_fetch_assoc($result) )
{
if($current_playlist == "") { $current_playlist = $playlist['id']; }
print("<option value='".$playlist['id']."'".(($id==$playlist['id'])?" SELECTED":"").">".$playlist['playlist_name']."</option>\n");
if($id==$playlist['id']) {
$playlistname=$playlist['playlist_name'];
}
$i++;
}
print("</select></form>\n");
} else {
$query = "SELECT playlist_name FROM playlist where id='".$id."'";
$result = mysql_query($query) or die(mysql_error());
$playlist = mysql_fetch_assoc($result);
$playlistname=$playlist['playlist_name'];
}
print("</td></tr></table>\n");
// List Songs
$query = "SELECT SUM(song.plays) as total_plays, AVG(song.rating/song.num_rating) as average_rating, song.song_name, song.id as song_id, song.lyric_id as lyric_id, artist.id as artist_id, album.id as album_id, album.album_name as album_name, song.lyrics_approved as lyrics, artist.name as artist_name FROM playlistsong, song, album, artist WHERE playlistsong.playlist_id='".$id."' AND playlistsong.song_id = song.id AND song.album_id = album.id AND song.artist_id = artist.id GROUP BY playlistsong.id";
$result = mysql_query($query) or die(mysql_error());
$total=mysql_num_rows($result);
if($playlistname)
{
$playlistname=$playlistname;
}
else
{
$playlistname="All";
}
if($_REQUEST['username'])
{
$username = addslashes($_REQUEST['username']);
}
else
{
$username = addslashes($session->username);
}
print("<form name='listing' action='".$this->thisfile."?action=launch' method='post'>\n");
print("<h1>".$username." playlist - ".$playlistname."</h1>\n");
if($total==0)
{
echo "Please select a playlist from dropdown.";
}
$this->topButtons();
print("<table border='0' cellspacing='1' cellpadding='4'>\n");
$i = 1;
while( $row = mysql_fetch_assoc($result) )
{
print("<tr><td style='width:20px; text-align:center'><input type='checkbox' name='song_id' value='".$row['song_id']."' /></td><td style='font-weight:bold; width:20px; text-align:center'>$i</span></td><td><a href='javascript:playSong(".$row['song_id'].")'>".$row['song_name']."</a> <a href='javascript:rateSong(".$row['song_id'].");'><img src='images/".((round($row['average_rating'])<1)?'1':round($row['average_rating']))."_s.gif' alt='".round($row['average_rating'],2)."' border='0'></td><td><a href='javascript:showLyrics(".$row['lyric_id'].");'>".(($row['lyrics']!=0)?"<img src='images/lyrics_txt.gif' alt='Lyrics' border='0'>":" ")."</a></td><td style='text-align: right;' ><a href='javascript:mailFriend(0,0,".$row['song_id'].",0)'><img src='images/mail.gif' alt='Email this Song' border='0'></a></td></tr>\n");
print("<tr><td colspan='2'> </td><td colspan='3'><span style='font-weight:bold;'>Artist Name:</span> <a href='".$this->thisfile."?action=artist&id=".$row['artist_id']."'>".$row['artist_name']."</a></td></tr>\n");
print("<tr><td colspan='2'> </td><td colspan='3'><span style='font-weight:bold;'>Album Name:</span> <a href='".$this->thisfile."?action=album&id=".$row['album_id']."'>".$row['album_name']."</a></td></tr>\n");
print("<tr><td colspan='2'> </td><td colspan='3'><span>Times Played</span> ".$row['total_plays']." ".(($session->logged_in)?"<a href='javascript:addToPlaylist(".$row['song_id'].")'><font color='#CD238F'>Add to Playlist</font></a> <a href='javascript:removeFromPlaylist(".$row['song_id'].",".$id.")'><font color='#CD238F'>Remove</font></a> ":"").(($row['lyrics']!=1)?" <a href='".$this->thisfile."?action=addlyrics&song=".$row['song_id']."'><font color='#9A17C5'>Add Lyrics</font></a>":"")."</td></tr>\n");
}
print("</table>\n");
$this->bottomButtons();
print("</form>\n");
print("</div>\n");
}
/********** Mail Friend Functions **********/
function mailFriend() {
$song_id = addslashes($_GET['song']);
$album_id = addslashes($_GET['album']);
$artist_id = addslashes($_GET['artist']);
$genre_id = addslashes($_GET['genre']);
global $session;
if( $_GET['send'] == 'yes' ) {
$send_to = addslashes($_POST['send_to']);
$message = addslashes($_POST['message']);
$href = addslashes($_POST['href']);
$info = addslashes($_POST['info']);
$email = addslashes($_POST['email']);
$name = addslashes($_POST['name']);
if( !$session->logged_in ) {
$subject = addslashes("<a href='mailto:$email'>$name</a>");
} else {
$subject = "";
}
$query = "SELECT SUM(song.plays) as total_plays, AVG(song.rating/song.num_rating) as average_rating, album.album_photo, song.song_name, album.album_name, artist.name as artist_name, album.id as album_id, artist.id as artist_id FROM song, album, artist WHERE song.album_id = album.id AND song.artist_id = artist.id AND song.id = '".$song_id."' GROUP BY song.id";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($result);
$songtable = "<table><tr><td>Mail this Song </td><td><a href='".$href."'>".$row['song_name']."</a> <img src='".$this->url."/images/".((round($row['average_rating'])<1)?'1':round($row['average_rating']))."_s.gif' alt='".round($row['average_rating'],2)."' border='0'></td><td rowspan='4'><img src='".$row['album_photo']."'></td></tr>\n";
$songtable .= "<tr><td><span style='font-weight:bold;'>Artist Name:</span> <a href='".$this->url."/".$this->thisfile."?action=artist&id=".$row['artist_id']."'>".$row['artist_name']."</a></td></tr>\n";
$songtable .= "<tr><td><span style='font-weight:bold;'>Album Name:</span> <a href='".$this->url."/".$this->thisfile."?action=album&id=".$row['album_id']."'>".$row['album_name']."</a></td></tr>\n";
$songtable .= "<tr><td><span style='font-weight:bold;'>Times Played</span> ".$row['total_plays']."</td></tr></table>\n";
$user = array();
if( $session->logged_in ) {
//$user = $this->get_info();
} else {
$user['email'] = $email;
$user['name'] = $name;
}
$query = "INSERT INTO mailfriend (username,sent_to,subject,message, song_id, album_id, artist_id, genre_id) VALUES ('".$_POST['name']."','".$send_to."','".$subject."','".$message."','".$song_id."','".$album_id."','".$artist_id."','".$genre_id."');";
mysql_query($query) or die(mysql_error());
mail($send_to,"Listen to it Now","<html><body><link rel='stylesheet' href='template/css/theme.css' type='text/css'> </head><p><CENTER>
<table width='478'>
<tr>
<td bgcolor='#FDF1FB' background='template/images/top.jpg' align=right></td>
</tr>
<tr>
<td bgcolor='#FDF1FB' background='template/images/top.jpg' align=left><img src='template/images/logo.jpg' width='290' height='60' alt='' border='0'></td>
</tr>
<tr>
<td bgcolor='#FDF1FB' background='template/images/top.jpg' align=left></td>
</tr>
</table>
<table width='478' background='template/images/searchbg.gif'>
<tr>
<td align=left><form action='index.php?action=search' method='get'>
<strong>Search:</strong> <input type=radio name='in' value='artist'> Artist</option><input type=radio name='in' value='album' > Album</option> <input type=radio name='in' value='song' checked> Song</option> <input type='textbox' name='term' class='input2'> <input type='hidden' name='action' value='search'>
<input type='hidden' name='start' value='0'><input type='button' value='Search' class='useme'>
</select></td>
</tr> </form>
</table>
<table width='478' border='0' cellspacing='0' cellpadding='2' bgcolor='#FDF1FB'> <tr> <td colspan='3'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>Hae Hi <a href='mailto:".$user['email']."'>".$user['name']."</a>, <br> The audio clip below was emailed to you from <font face='Verdana, Arial, Helvetica, sans-serif' size='2'><a href='mailto:".$user['email']."'>".$user['name']."</a></font> on our site . Please be sure to visit our Huge audio archives. We hope you like it.</font></td> </tr> <tr> <td colspan='3'> </td> </tr> <tr> <tr> <td width='274'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><p>".$songtable."</p></font></td> </tr> <tr> <tr> <td colspan='3'> </td> </tr> <tr> <td colspan=3><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><b>Sender's message:</b></font></td> </tr> <tr> <td colspan='3'><br><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>===================================================</font></td> </tr> <tr> <td colspan='3'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><p>".$_POST['message']."</p></font></td> </tr> <tr> <td colspan='3'><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>===================================================</font></td> </tr> <tr> <td colspan='3' align='center'><br><font face='Verdana, Arial' size='6'><a target=_blank href='".$href."'><b>Click Here to Listen to it Now</b></a></td> </tr> <tr> <td colspan='3'> </td> </tr> <tr> </table> </td> </tr> <tr> <td> </td> </tr></table><br><font face='Verdana, Arial' size='1'>Note: Sender's e-mail as entered on website.</font></CENTER></body></html></center>","MIME-Version: 1.0\r\nContent-type: text/html; charset=iso-8859-1\r\nFrom: ".$this->email."\r\n");
print("<p align=center>Your Song Successfully sent.</p>");
}
print("<SCRIPT>
function validateForm(form) {
if (form.name.value == '') {
alert('Name Field is Empty.');
form.name.focus( );
return false;
}
if (form.email.value == '') {
alert('Email Field is Empty.');
form.email.focus( );
return false;
}
if (form.send_to.value == '') {
alert('Email Field is empty.');
form.send_to.focus( );
return false;
}
if (form.message.value == '') {
alert('Message Field is empty.');
form.message.focus( );
return false;
}
}
</SCRIPT>");
print("<form name='listing' action='".$this->thisfile."?action=mailfriend&send=yes&song=".$song_id."&album=".$album_id."&artist=".$artist_id."&genre=".$genre_id."' method='post' onSubmit='return validateForm(this)'>\n");
print("<table style='width: 100%; border: 0px;'>\n");
if( !$session->logged_in ) {
print("<tr><td><span style='font-weight:bold;'>Your name:</span></td><td><input type='text' name='name' value='" . $session->username . "'></td></tr>\n");
print("<tr><td><span style='font-weight:bold;'>Your email:</span></td><td><input type='text' name='email' value='" . $session->email . "'></td></tr>\n");
} else {
print("<input type='hidden' name='name' value='" . $session->username . "'>\n");
print("<input type='hidden' name='email' value='" . $session->userinfo['email'] . "'>\n");
}
$mail = $this->url."/";
$info = "";
if( $song_id != 0 ) {
$query = "SELECT song.song_name, album.album_name, artist.name as artist_name FROM song, album, artist WHERE song.album_id = album.id AND song.artist_id = artist.id AND song.id = '".$song_id."'";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
print("<tr><td>Mail this Song</td></tr>\n");
print("<tr><td><span style='font-weight:bold;'>Artist Name:</span></td><td>".$row['artist_name']."</td></tr>\n");
print("<tr><td><span style='font-weight:bold;'>Album Name:</span></td><td>".$row['album_name']."</td></tr>\n");
print("<tr><td><span style='font-weight:bold;'>Song Name:</span></td><td>".$row['song_name']."</td></tr>\n");
$mail .= "mail.php?action=song&id=".$song_id;
$info = "the song ".$row['song_name']." by ".$row['artist_name'];
} else if( $album_id != 0 ) {
$query = "SELECT album.album_name, artist.name as artist_name FROM album, artist WHERE album.artist_id = artist.id AND album.id = '".$album_id."'";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($result);
print("<tr><td><span style='font-weight:bold;'>Artist Name:</span></td><td>".$row['artist_name']."</td></tr>\n");
print("<tr><td><span style='font-weight:bold;'>Album Name:</span></td><td>".$row['album_name']."</td></tr>\n");
$mail .= "index.php?action=album&id=".$album_id;
$info = "the album ".$row['album_name']." by ".$row['artist_name'];
} else if( $artist_id != 0 ) {
$query = "SELECT * FROM artist WHERE artist.id = '".$artist_id."'";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
print("<tr><td><span style='font-weight:bold;'>Artist Name:</span></td><td>".$row['name']."</td></tr>\n");
$mail .= "index.php?action=artist&id=".$artist_id;
$info = "the artist ".$row['artist_name'];
} else if( $genre_id != 0 ) {
$query = "SELECT genre.genre as genre_name FROM genre WHERE genre.id = '".$genre_id."'";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
print("<tr><td><span style='font-weight:bold;'>Genre Name:</span></td><td>".$row['genre_name']."</td></tr>\n");
$mail .= "index.php?action=genre&id=".$genre_id;
$info = "the genre ".$row['genre_name'];
}
print("<tr><td><span style='font-weight:bold;'>Email to:</span></td><td><input name='send_to' type='textbox' value='' ></td></tr>\n");
print("<tr><td><span style='font-weight:bold;'>Message:</span></td><td> </td></tr>\n");
print("<tr><td colspan='2'><textarea name='message'></textarea><input type='hidden' name='href' value='".$mail."'><input type='hidden' name='info' value='".$info."'></td></tr>\n");
print("<tr><td colspan='2'><input name='submit' type='submit' value='Send it Now'></td></tr>\n")⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -