index.php

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

			if( $lastchar != $thischar ) { 
				if( $lastchar != '' ) {
					print("");
				}
			}
			
			// Print album Info 
		print("<table><tr><td><img src='".$album['album_photo']."' width='100' height='99' border='0' align='left' hspace='5' vspace='3'>\n");
			print("<b><a class=text href='".$this->thisfile."?action=album&id=".$album['album_id']."'>".$display."</a></b> ".(($album['date_diff']<14)?"":"")."<br><font size='2'>{$album['album_info']}</font></td></tr></table>\n");
			
			// Store character
			$lastchar = $thischar;
		} 
		print("");		
		
	}
	
	/********** 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("<title>".$genre['genre']."</title>");
		print("<table width='100%' cellspacing='1' cellpadding='1' bgcolor='#CBE9E9'> <tr><td width='100%' align='left' valign='top' bgcolor='#ECF2F2' background='template/images/background.jpg'><font face='arial' size='3'><b>".$genre['genre']." </b></font></td></tr></table>\n");
		 
		print("<div id='content'>"); 
		$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 ) {
				print("</tr></table><h4>".$thischar."</h4><table><tr>");
				if( $lastchar != '' ) {
					
				}
			}
			
			// Print album Info 
			
			if (++$counter == 1)
			{
				print("<table  width=100% align=center valign=top><tr>");
			}
				print("<td valign=top><a href='".$this->thisfile."?action=album&id=".$album['album_id']."'><img src='".$album['album_photo']."' width='15' height='12' border='0' align='left' hspace='5' vspace='1' ></a>");
			print("<a class=text href='".$this->thisfile."?action=album&id=".$album['album_id']."'>".$display."</a> ".(($album['date_diff']<14)?"":"")."</td><td>&nbsp;</td>");
			
			if ($counter == 2)
			{ 
				print("");
				
				$counter = 0;
			}
			
			// Store character
			$lastchar = $thischar;
		} 
		if (!($counter % 2))
		{
		print("");
		}
		print("</tr></table>");	
		
	}
	 
	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 Song' 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 Song' 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>Song:</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 Song' ></td></tr>\n");
			print("</table></form>\n");
		}
	
	}
	
	/********** Playlist Functions ***********/
	function launch($song_ids) {
		$time = time();
		if( $this->m3u_folder != "" ) {
			$filename = $this->m3u_folder."/".$time.".rpm";
			$m3u_url = $this->url."/".$this->m3u_folder."/".$time.".rpm";
		} else {
			$filename = $time.".rpm";
			$m3u_url = $this->url."/".$this->m3u_folder."/".$time.".rpm";
		}
		$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);
					$url = preg_replace("/".preg_replace("/\//","\/",$this->siteroot)."/",$this->url,$song['song_path']);
					if( preg_match("/http/",$url ) ) {
						fwrite($file,$url."\n") or die("Creating of m3u failed");
					}
				}
			}
			fclose($file);
			$filename = $m3u_url;
		} 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("<script>
   function createCookie(name,value,days) {
    if (days) {
     var date = new Date();
     date.setTime(date.getTime()+(days*24*60*60*1000));
     var expires = '; expires='+date.toGMTString();
    }
    else var expires = '';
    document.cookie = name+'='+value+expires+'; path=/';
   }
   function readCookie(name) {
    var nameEQ = name + '=';
    var ca = document.cookie.split(';');
     for(var i=0;i < ca.length;i++) {
     var c = ca[i];
     while (c.charAt(0)==' ') c = c.substring(1,c.length);
     if (c.indexOf(nameEQ) == 0) return c.substring(nameEQ.length,c.length);
    }
    return null;
   }
   function init(){
    if (readCookie('skin')!=null){
     setSkin(readCookie('skin'))
    }
   }
   function setSkin(skin){