mail.php

个人主页音乐程序 个人主页音乐程序 个人主页音乐程序 个人主页音乐程序 个人主页音乐程序

		print("<div id='content'>\n\n");
		
		$lastchar = '';
		while( $album = mysql_fetch_assoc($result) )
		{
			// get initial name character
			if( $sortby == 'album' ) {
				$thischar = $album['album_name']{0};
				$display = $album['album_name']." - ".$album['artist_name'];
			} else {
				$thischar = $album['artist_name']{0};
				$display = $album['artist_name']." - ".$album['album_name'];
			}
			
			// Check to see if different than last
			if( $lastchar != $thischar ) { 
				if( $lastchar != '' ) {
					print("</p>\n<p>\n");
				}
			}
			
			// Print Main page 
			print("<title>Musicbox : For Professional Music/personals/fans Website </title>");
		print("<table width='100%' align=center><tr><td align=center><a href='register.php'><img src='template/images/welcome.gif' width='300' height='454' alt='Register Now and Login' border='0'></a>\n");
			print("</td></tr></table>\n");
			
			// Store character
			$lastchar = $thischar;
		} 
		print("<br><br>");		
		
	}
	
	/********** Genre Functions **********/
	
	function genre() {
	
		$genre = addslashes($_GET['id']);
	
		if( $genre != '' ) {
			$this->displayGenre($genre);
		} else {
			$this->listGenres();
		}
	
	}
	
	function displayGenre( $id )
	{
		$sortby = addslashes($_POST['sort']);

		if( $id == 'all' ) {
			$query = "SELECT * FROM genre WHERE 1";
		} else {
			$query = "SELECT * FROM genre WHERE id = '".$id."'";
		}
		$result = mysql_query($query);
		$genre = mysql_fetch_assoc($result);
	
		$query = "SELECT TO_DAYS(now())-TO_DAYS(album.post_date)as date_diff, album.id as album_id, album.album_name, album.album_photo, artist.name as artist_name FROM album, artist WHERE ".(($id!='all')?"album.genre_id = '".$id."' AND ":"")."album.artist_id = artist.id ORDER BY ".(($sortby=='album')?'album.album_name':'artist.name')." ASC";
		$result = mysql_query($query) or die(mysql_error());
		
		// Genre
		print("<div id='title'><h1>".$genre['genre_name']."</h1></div>\n");
		
		$this->sortby("action=genre&id=".$id);
		
		print("<div id='content'>\n\n");
		$lastchar = '';
		while( $album = mysql_fetch_assoc($result) )
		{
			// get initial name character
			if( $sortby == 'album' ) {
				$thischar = $album['album_name']{0};
				$display = $album['album_name']." - ".$album['artist_name'];
			} else {
				$thischar = $album['artist_name']{0};
				$display = $album['artist_name']." - ".$album['album_name'];
			}
			
			// Check to see if different than last
			if( $lastchar != $thischar ) { 
				if( $lastchar != '' ) {
					print("\n\n");
				}
			}
			
			// Print album Info 
		print("<table><tr><td><a  href='".$this->thisfile."?action=album&id=".$album['album_id']."'><img src='".$album['album_photo']."' width='70' height='35' border='0' align='left' hspace='1' vspace='1'></a></td>\n");
			print("<td><a  href='".$this->thisfile."?action=album&id=".$album['album_id']."'>".$display."</a> ".(($album['date_diff']<14)?" ":"")."</td></tr></table><br><br>\n");
			
			// Store character
			$lastchar = $thischar;
		}
		print("<br><br>");
	}
	
	function listGenres() {
	
		$query = "SELECT * FROM genre";
		$result = mysql_query($query);
		
		print("<div id='content'>");
		while( $genre = mysql_fetch_assoc($result) )
		{
			print("<a href='".$this->thisfile."?action=genre&id=".$genre['id']."'>".$genre['genre']."</a><br>");		
		}
		print("</div>");		
		
	}
	
	/********** Lyrics Functions **********/
	function lyrics() {
	
		$song_id = addslashes($_GET['song']);
	
		$query = "SELECT SUM(song.plays) as total_plays, AVG(song.rating/song.num_rating) as average_rating, album.album_name as album, album.id as album_id, artist.id as artist_id, artist.name AS artist_name, lyric.lyrics, song.song_name, song.id as song_id FROM song, album, artist, lyric WHERE album.id = song.album_id AND artist.id = song.artist_id AND lyric.id = song.lyric_id AND lyric.id = '".$song_id."' GROUP BY song.id";
		$result = mysql_query($query) or die(mysql_error());
		$row = mysql_fetch_assoc($result);

		print("<form name='listing' action='".$this->thisfile."?action=launch' method='post'>\n");
		print("<table cellspacing='1' cellpadding='4' border: 0px;'>\n");
		print("<tr><td><a  href='javascript:playSong(".$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:mailFriend(0,0,".$row['song_id'].",0);'><img src='images/mail.gif' alt='Email this Track' border='0'></a></td></tr>\n");
		print("<tr><td colspan='2'><span style='font-weight:bold;'>Artist Name:</span> <a href='".$this->thisfile."?action=artist&id=".$row['artist_id']."' target='_blank'>".$row['artist_name']."</a></td></tr>\n");
		print("<tr><td colspan='2'><span style='font-weight:bold;'>Album Name:</span> <a href='".$this->thisfile."?action=album&id=".$row['album_id']."' target='_blank'>".$row['album']."</a></td></tr>\n");
		print("<tr><td colspan='2'><span>Times Played</span> ".$row['total_plays']."</td></tr>\n");
		print("<tr><td colspan='2'>".$row['lyrics']."</td></tr>\n");
		print("</table></form>\n");
	

	}
	
	function addlyrics() {
	
		$song_id = addslashes($_GET['song']);
		$save = addslashes($_GET['save']);
		if( $save == 'yes' ) {
			$query = "INSERT INTO lyric (lyrics) VALUES ('".$_POST['lyrics']."')";
			mysql_query($query) or die(mysql_error());
			
			$query = "SELECT * FROM lyric WHERE  lyrics = '".$_POST['lyrics']."'";
			$result = mysql_query($query) or die(mysql_error());
			$lyrics = mysql_fetch_assoc($result);
			
			$query = "UPDATE song SET lyric_id = '".$lyrics['id']."' WHERE id = '".$song_id."'";
			#print("<p>$query</p>");
			mysql_query($query) or die(mysql_error());
			
			print("<p>Lyrics added succesfully.</p>");		
		}
	
		$query = "SELECT SUM(song.plays) as total_plays, AVG(song.rating/song.num_rating) as average_rating, album.album_name, album.id as album_id, artist.id as artist_id, artist.name AS artist_name, song.song_name, song.id as song_id FROM song, album, artist WHERE album.id = song.album_id AND artist.id = song.artist_id AND song.id = '".$song_id."' GROUP BY song.id";
		$result = mysql_query($query) or die(mysql_error());
		$row = mysql_fetch_assoc($result);
	
		print("<form name='listing' action='".$this->thisfile."?action=addlyrics&song=".$row['song_id']."&save=yes' method='post'>\n");
		print("<table cellspacing='1' cellpadding='4' border: 0px;'>\n");
		print("<tr><td><a  href='javascript:playSong(".$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:mailFriend(0,0,".$row['song_id'].",0);'><img src='images/mail.gif' alt='Email this Track' border='0'></a></td></tr>\n");
		print("<tr><td colspan='2'><span style='font-weight:bold;'>Artist Name:</span> <a href='".$this->thisfile."?action=artist&id=".$row['artist_id']."' target='_blank'>".$row['artist_name']."</a></td></tr>\n");
		print("<tr><td colspan='2'><span style='font-weight:bold;'>Album Name:</span> <a href='".$this->thisfile."?action=album&id=".$row['album_id']."' target='_blank'>".$row['album_name']."</a></td></tr>\n");
		print("<tr><td colspan='2'><span>Times Played</span> ".$row['total_plays']."</td></tr>\n");
		print("<tr><td colspan='2'><textarea name='lyrics' rows='5' cols='40'>Type lyrics here</textarea></td></tr>\n");
		print("<tr><td colspan='2'><input name='submit' type='submit' value='Submit' ></td></tr>\n");
		print("</table></form>\n");
	
	}
	
	/********** Rate Song Functions ***********/
	function rateSong() {
	
		$song_id = addslashes($_GET['song']);
		
		$query = "SELECT song.rating, song.num_rating, album.album_name as album_name, album.id as album_id, artist.id as artist_id, artist.name AS artist_name, song.song_name, song.id as song_id FROM song, album, artist WHERE album.id = song.album_id AND artist.id = song.artist_id AND song.id = '".$song_id."'";
		$result = mysql_query($query) or die(mysql_error());
		$row = mysql_fetch_assoc($result);
		
		if( $_GET['save'] == 'yes' ) {
		
			$rating = $_POST['rating'] + $row['rating'];
			$num_rating = $row['num_rating']+1;
			
			$query = "UPDATE song SET rating = '".$rating."', num_rating = '".$num_rating."' WHERE id = '".$row['song_id']."'";
			mysql_query($query);
			print("<title>Rate this Song</title>");
			print("<p style='text-align: center'>Ratings for the song updated.<br><br>Thankyou for Rating this Song</p>\n");
			print("<p style='text-align: center'><input type='button' onClick='window.close()' value='Close Window' ></p>\n");		
		} else {

			print("<form name='form' action='".$this->thisfile."?action=rate&song=".$row['song_id']."&save=yes' method='post'>\n");
			print("<table style='width: 100%; border: 0px;'>\n");
			print("<tr><td colspan='2'><b>Rate this Song</b></td></tr>\n");
			print("<tr><td>Track:</td><td>".$row['song_name']."</td></tr>\n");
			print("<tr><td>Artist:</td><td>".$row['artist_name']."</td></tr>\n");
			print("<tr><td>Album:</td><td>".$row['album_name']."</td></tr>\n");
			print("<tr><td style='text-align:right'><input type='radio' name='rating' value='1'></td><td><img src='images/1_s.gif' alt='1 star'> Bad</td></tr>\n");
			print("<tr><td style='text-align:right'><input type='radio' name='rating' value='2'></td><td><img src='images/2_s.gif' alt='2 stars'></td></tr>\n");
			print("<tr><td style='text-align:right'><input type='radio' name='rating' value='3'></td><td><img src='images/3_s.gif' alt='3 stars'> Average</td></tr>\n");
			print("<tr><td style='text-align:right'><input type='radio' name='rating' value='4'></td><td><img src='images/4_s.gif' alt='4 stars'> </td></tr>\n");
			print("<tr><td style='text-align:right'><input type='radio' name='rating' value='5'></td><td><img src='images/5_s.gif' alt='5 stars'> Excellent</td></tr>\n");
			print("<tr><td colspan='2' style='text-align:center'><input name='submit' type='submit' value='Rate Track' ></td></tr>\n");
			print("</table></form>\n");
		}
	
	}
	
	/********** Playlist Functions ***********/
	function launch($song_ids) {
		$filename = $this->m3u_folder."/".time().".m3u";
		
		$count = 0;
				
		if( is_array($song_ids) ) {
			$file = fopen($filename,'w');
			foreach( $song_ids as $id ) {
				if( $id != "" ) {
					$count++;
					$query = "SELECT * FROM song WHERE id = '".$id."'";
					$result = mysql_query($query);
					$song = mysql_fetch_assoc($result);
					$query = "UPDATE song SET plays = plays + 1 WHERE id = '".$id."'";
					$result = mysql_query($query);
					fwrite($file,preg_replace("/".preg_replace("/\//","\/",$this->siteroot)."/",$this->url,$song['song_path'])."\n") or die("Creating of m3u failed");
				}
			}
			fclose($file);
		} else {
			if( $song_ids != "" ) {
				$count++;
				$query = "SELECT * FROM song WHERE id = '".$song_ids."'";
				$result = mysql_query($query);
				$song = mysql_fetch_assoc($result);
				$query = "UPDATE song SET plays = plays + 1 WHERE id = '".$song_ids."'";
				$result = mysql_query($query);
				$filename = preg_replace("/".preg_replace("/\//","\/",$this->siteroot)."/",$this->url,$song['song_path']);
			}
		}

		if( $count != 0 ) {
			print("<img src='player/images/null.gif' alt='' onLoad=\"javascript:launchPlayer2('".$filename."');\">");
		} else {
			print("Error: No files selected uanble to launch player.</p>");
		}
	}
	
	
	function playlist() {
	
		global $session;
		$song_id_raw = addslashes($_GET['id']);
		$song_id = split(",",addslashes($_GET['id']));
			
		if( $_GET['save'] == 'yes' ) {
		
			if( $_GET['create'] == 'yes' ) {
				$query = "INSERT INTO playlist (username, playlist_name) VALUES ('".$session->username."','".addslashes($_POST['playlist_name'])."')";
				mysql_query($query) or die(mysql_error());
				
				$query = "SELECT * FROM playlist WHERE username = '".$session->username."' AND playlist_name = '".addslashes($_POST['playlist_name'])."'";
				$result = mysql_query($query) or die(mysql_error());
				$playlist = mysql_fetch_assoc($result);
				$playlist_id = $playlist['id'];
			} else {