'.$letter.' | '; } $letters = trim($letters); $letters = substr($letters, 0, -1); $alpha = $_GET['alpha']; if(!$alpha) { $alpha = '0-9'; } if($alpha) { if($alpha == '0-9') { $sql_artists = mysql_query("SELECT * FROM `artist` WHERE (ORD(LEFT(name,1)) < 65 OR ORD(LEFT(name,1)) > 90) AND (ORD(LEFT(name,1)) < 97 OR ORD(LEFT(name,1)) > 122)") or die(mysql_error()); $sql_albums = mysql_query("SELECT * FROM `album` WHERE (ORD(LEFT(album_name,1)) < 65 OR ORD(LEFT(album_name,1)) > 90) AND (ORD(LEFT(album_name,1)) < 97 OR ORD(LEFT(album_name,1)) > 122)") or die(mysql_error()); $sql_songs = mysql_query("SELECT * FROM `song` WHERE (ORD(LEFT(song_name,1)) < 65 OR ORD(LEFT(song_name,1)) > 90) AND (ORD(LEFT(song_name,1)) < 97 OR ORD(LEFT(song_name,1)) > 122)") or die(mysql_error()); } else { $sql_artists = mysql_query("SELECT * FROM `artist` WHERE LEFT(name,1) = '$alpha'") or die(mysql_error()); $sql_albums = mysql_query("SELECT * FROM `album` WHERE LEFT(album_name,1) = '$alpha'") or die(mysql_error()); $sql_songs = mysql_query("SELECT * FROM `song` WHERE LEFT(song_name,1) = '$alpha'") or die(mysql_error()); } } ?>

Artists

'; echo ''; echo ''; } else { while($row_artists = mysql_fetch_array($sql_artists)) { $artist = $row_artists['name']; $artist_id = $row_artists['id']; ///>>>>>>>>>mode=list ?>

No entries were found.
	Artist Page

Albums

'; echo ''; echo ''; } else { while($row_albums = mysql_fetch_array($sql_albums)) { $album = $row_albums['album_name']; $album_id = $row_albums['id']; ?>

No entries were found.
	Album Page

Songs

'; echo ''; echo ''; } else { while($row_songs = mysql_fetch_array($sql_songs)) { $song = $row_songs['song_name']; $song_id = $row_songs['id']; ?> username = $username; $this->mailextra = "From: ".$this->email."\r\n"; // Connect to the database $this->dbConnect(); //include($page_header); ?> popup_header); } else { @include($this->page_header); } // Determine Action switch( $action ) { case 'genre': $this->genre(); break; case 'lyrics': $this->lyrics(); break; case 'mailfriend': $this->mailfriend(); break; case 'top': $this->topx(); break; case 'rate': $this->rateSong(); break; case 'album': $this->Album(); break; case 'song': $this->song(); break; case 'playlist': $this->playlist(); break; case 'removefromplaylist': $this->removefromplaylist(); break; case 'viewplaylist': $this->viewPlaylist(); break; case 'viewallplaylists': $this->viewAllPlaylists(); break; case 'showallplaylists': $this->showAllPlaylists(); break; case 'showUsersplaylists': $this->showUsersPlaylists(); break; case 'artist': $this->artist(); break; case 'viewgallery': $this->viewgallery(); break; case 'search': $this->search(); break; case 'viewmailfriend': $this->viewmailfriend(); break; case 'addlyrics': $this->addlyrics(); break; case 'download': $this->download_songs(); break; case 'upolad_songs': $this->songupload(); break; case 'upload_artist': $this->upload_artist(); break; case 'upload_album': $this->upload_album(); break; case 'songlink': $this->songlink(); break; case 'adddownload': $this->AddDownload(); break; case 'viewallsongs': $this->viewallsongs(); break; default: $this->Album(); } if( $action == 'song' || $action == 'lyrics' || $action == 'playlist' || $action == 'rate' || $action == 'mailfriend' || $action == 'removefromplaylist' ) { @include(ROOT_DIR.$this->popup_footer); } else { @include($this->page_footer); } } /********** Database Functions **********/ function dbConnect() { $this->mysqlConn = mysql_connect( $this->mysqlHostname, $this->mysqlUsername, $this->mysqlPassword ) or die("Error: Unable to connect to MySQL server."); mysql_select_db( $this->mysqlDbName, $this->mysqlConn ) or die("Error: Unable to connect to MySQL database."); } /********** GUI Functions **********/ function sortby($action) { // Sort By print("

\n"); print("\n"); print("Sort by: \n"); print("

\n"); } function topButtons() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; // Top Buttons for displaying - Play selected, Play All, Select None buttons print("

\n"); } function bottomButtons() { global $session; global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; // Bottom Buttons for displaying - Play selected, Add to Playlist buttons print("

".(($session->logged_in)?" ":"")."

\n"); print(""); } function mysqlTable($resource,$headers,$base_url,$include_id) { $rowid = 0; $idcol = 0; // Resource is empty! if( !(mysql_num_rows($resource) > 0) ) { print("

No records found

"); exit; } // Get First Row for Fields $row = mysql_fetch_assoc($resource); // Print Fields print("

No entries were found.

\n"); print(" \n"); $count = 0; while ($field = current($row)) { $count++; if( key($row) == 'id' ) { $idcol = $count; } if( !(key($row) == 'id' && !$include_id) ) { print(" \n"); } next($row); } // Print Extra Headers while( $header = current($headers) ) { print(" \n"); next($headers); } print(" \n"); $id=0; do { print(" \n"); $count = 0; foreach( $row as $field ) { $count++; if( $count == $idcol ) { $id = $field; } if( !( $count == $idcol && !$include_id) ) { if( preg_match("/http:\/\//",$field ) ) { $field = "".$field.""; } print(" \n"); } } foreach( $headers as $field ) { print(" \n"); } print(" \n"); $rowid++; } while( $row = mysql_fetch_assoc($resource) ); print("

".preg_replace("/_/"," ",key($row))."	".key($headers)."
".$field."	[ X ]

\n"); } /********** Download Song Functions **********/ function AddDownload() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; //*** Collect Songid and id $songid = $HTTP_GET_VARS['songid']; $id = $HTTP_GET_VARS['id']; //*** select song path from song table for url $q_songpath = "SELECT song_path FROM song WHERE id = ".$songid ; $result_songpath = mysql_query($q_songpath) or die(mysql_error()); $row_songpath = mysql_fetch_assoc($result_songpath); //*** update url field with song path field $q_url = "UPDATE song SET url ='".$row_songpath['song_path']."' WHERE id = ".$songid; $result_url = mysql_query($q_url) or die(mysql_error()); $this->displayalbum($id); } /********** Song Functions **********/ function song() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $id = addslashes($HTTP_GET_VARS['id']); $array = addslashes($HTTP_GET_VARS['array']); if( $array == 'yes' ) { $id = split(",",$id); } /************************ Player Default Skin - Start ***********************************/ print(""); print("

"); /************************ Player Default Skin - End ***********************************/ $this->launch($id); } /********** Artist Functions **********/ function artist() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $id = ($HTTP_GET_VARS['id']); if( $id != '' ) { $this->displayArtist($id); } else { $this->listArtist(); } } function displayArtist( $id ) { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; global $session; $query = "SELECT * FROM artist WHERE id = '".$id."'"; $result = mysql_query($query) or die(mysql_error()); $artist = mysql_fetch_assoc($result); print("".$artist['name']." All Albums"); print("

".$artist['name']." : All Albums

\n"); print("\n"); print("

".$artist['name']."\n"); if( $artist['url'] != '' ) { print("
Website: Click here to visit\n"); } if( $artist['artist_info'] != '' ) { print("
Artist Info:
\n"); print($artist['artist_info']); } require("admin/conf.php"); if ($gallery_mode==1) { print("
Artist Gallery
\n"); } print("

"); $query = "SELECT * FROM `album` WHERE `artist_id` = '$id' ORDER BY album_name, album.album_photo, album.album_info"; $result = mysql_query($query) or die(mysql_error()); while ($row = mysql_fetch_assoc($result)) //

echo "
"; echo ''; print("\n\n"); } function listArtist() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $sortby = addslashes($HTTP_POST_VARS['sort']); $query = "SELECT id, name FROM artist"; $result = mysql_query($query) or die(mysql_error()); print("List of All Artists"); print("

{$row['album_name']}

{$row['album_info']}
".buy_link($row[id],"album")."
".calculate_price($row[id])."

List of All Artists

\n"); // number of items per column $columnTracks = 2; $artistCounter = 0; $columnBegin = TRUE; // loop printing out the information on the screen $lastchar = ''; while( $artist = mysql_fetch_assoc($result) ) { // get initial name character $thischar = $artist['name']{0}; if ($columnBegin == TRUE) { $columnBegin = FALSE; } if ($artistCounter == $columnTracks) { $artistCounter = 0; } // Check to see if different than last if( $lastchar != $thischar ) { print("

Alphabet : ".$thischar."

"); if( $lastchar != '' ) { } } // Print album Info if (++$counter == 1) { print("

"); } print(""); if ($counter == 2) { print(""); $counter = 0; } // Store character $lastchar = $thischar; } if (!($counter % 2)) { print(""); } print(""); } /********** Album Functions **********/ function album() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $id = addslashes($HTTP_GET_VARS['id']); if( $id != '' ) { $this->displayalbum($id); } else { $this->listalbums(); } } function displayalbum( $id ) { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; global $session; $id = $HTTP_GET_VARS['id']; $query = "SELECT TO_DAYS(now())-TO_DAYS(album.post_date)as date_diff, album.album_name, artist.name as artist_name, album.album_photo, album.album_info, artist.id as artist_id FROM album, artist WHERE album.id = '".$id."' AND album.artist_id = artist.id"; $result = mysql_query($query) or die(mysql_error()); $album = mysql_fetch_assoc($result); print("".$album['artist_name']." - ".$album['album_name'].""); print("

".$artist['name']."

".$album['artist_name']." - ".$album['album_name']."

\n"); print("\n"); print("\n"); print("

Artist: ".$album ['artist_name']."
\n"); print("Album: ".$album['album_name']." ".(($album['date_diff']<14)?"":"")."\n"); if( $album['album_info'] != '' ) { print("
Album Info:
\n"); print($album['album_info']); print("
"); echo calculate_price($album['id']); print("
"); echo buy_link($album['id'],"album"); } require("admin/conf.php"); if ($gallery_mode==1) { print("

Album Gallery

\n"); } print("

"); $query = "SELECT SUM(plays) as total_plays, AVG(rating/num_rating) as average_rating, id, song_name, lyrics_approved, lyric_id,url,counter FROM song WHERE album_id = '".$id."' GROUP BY id"; $result = mysql_query($query) or die(mysql_error()); print("

\n"); print("\n"); $this->topButtons(); $alternateColor = TRUE; $colorLight = "FBF7F8"; $colorDark = "FFFFFF"; while( $song = mysql_fetch_assoc($result)) { if ($alternateColor == TRUE) { print("

\n"); $alternateColor = FALSE; } else { print("

\n"); $alternateColor = TRUE; } $HTTP_SESSION_VARS["session_counter"] = 0; // //print("counter : ".$HTTP_SESSION_VARS["session_counter"]); print("\n"); //

\n"); print("

	".$song['song_name']."	".(($song['lyrics_approved']==1)?"":" ")."	".(($song['url']!='')?"":"")."	".buy_link($song['id'],"song")."
	Times Played ".$song['total_plays']." ".(($session->logged_in)?"Add to Playlist ":"").(($song['lyrics_approved']!=1)?" Add Lyrics":"").(($song['url'] == '' && $session->isAdmin())?" Add Download ":"")."

\n"); } $this->bottomButtons(); print("\n"); print("\n\n"); } function listalbums() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $sortby = addslashes($HTTP_POST_VARS['sort']); /** * Only list 5 newest albums if this is the homepage */ if (!$HTTP_GET_VARS) $query = "SELECT TO_DAYS(now())-TO_DAYS(album.post_date)as date_diff, album.album_name, artist.name as artist_name, album.album_photo, album.album_info, album.id as album_id, artist.id as artist_id FROM album, artist WHERE album.artist_id = artist.id ORDER BY album.post_date DESC LIMIT 5"; else $query = "SELECT TO_DAYS(now())-TO_DAYS(album.post_date)as date_diff, album.album_name, artist.name as artist_name, album.album_photo, album.album_info, album.id as album_id, artist.id as artist_id FROM album, artist WHERE album.artist_id = artist.id ORDER BY album.post_date DESC LIMIT 5"; $result = mysql_query($query) or die(mysql_error()); print("

5 Newest Albums

"); print("".PGTITLE.""); print("

\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(""); } } // Print album Info print("

\n"); //Buy Now print("".$display." ".(($album['date_diff']<14)?"":"")."
{$album['album_info']}
".buy_link($album[album_id],"album")."
".calculate_price($album[album_id])."

"); // Store character $lastchar = $thischar; } print("

"); } /********** Genre Functions **********/ function genre() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $genre = addslashes($HTTP_GET_VARS['id']); if( $genre != '' ) { $this->displayGenre($genre); } else { $this->listGenres(); } } function displayGenre( $id ) { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $sortby = addslashes($HTTP_POST_VARS['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("".$genre['genre'].""); print(" \n"); print("

"); $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("

".$genre['genre']."

Alphabet : ".$thischar."

"); if( $lastchar != '' ) { } } // Print album Info if (++$counter == 1) { print("

"); } print(""); if ($counter == 2) { print(""); $counter = 0; } // Store character $lastchar = $thischar; } if (!($counter % 2)) { print(""); } print(""); } function listGenres() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $query = "SELECT * FROM genre"; $result = mysql_query($query); print("

"); while( $genre = mysql_fetch_assoc($result) ) { print("".$genre['genre']."
"); } print("

"); } /********** Lyrics Functions **********/ function lyrics() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $song_id = addslashes($HTTP_GET_VARS['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("Lyrics - ".$row['song_name'].""); print("\n"); print("

"); print("".$display." ".(($album['date_diff']<14)?"":"")."

\n"); print("\n"); print("\n"); print("\n"); print("

".$row['song_name']."
Artist Name: ".$row['artist_name']."
Album Name: ".$row['album']."
Times Played ".$row['total_plays']."

\n"); print("\n"); print("

".$row['lyrics']."

\n"); } function addlyrics() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $song_id = addslashes($HTTP_GET_VARS['song']); $save = addslashes($HTTP_GET_VARS['save']); if( $save == 'yes' ) { $query = "INSERT INTO lyric (lyrics) VALUES ('".$HTTP_POST_VARS['lyrics']."')"; mysql_query($query) or die(mysql_error()); $query = "SELECT * FROM lyric WHERE lyrics = '".$HTTP_POST_VARS['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("

$query

"); mysql_query($query) or die(mysql_error()); print("

Lyrics will be approved shortly by administrator

"); } $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("

Add Lyrics

"); print("

\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); } /********** Rate Song Functions ***********/ function rateSong() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $song_id = addslashes($HTTP_GET_VARS['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( $HTTP_GET_VARS['save'] == 'yes' ) { $rating = $HTTP_POST_VARS['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("

Ratings for the song updated.

Thankyou for Rating this Song

\n"); print("

\n"); } else { print("Rate Song - ".$row['song_name'].""); print("\n"); print("

".$row['song_name']."
Artist Name: ".$row['artist_name']."
Album Name: ".$row['album_name']."
Times Played ".$row['total_plays']."
Type lyrics here

\n"); print("\n"); print("

Rate this Song

\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("

Song:	".$row['song_name']."
Artist:	".$row['artist_name']."
Album:	".$row['album_name']."
	Bad

	Average

	Excellent

\n"); } } /********** Song Player Functions ***********/ function launch($song_ids) { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $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 album.album_name AS album_name,album.album_photo, album.id AS album_id, artist.name AS artist_name,artist.id AS artist_id, song.song_name, song.id as song_id, song.song_path AS song_path FROM song, album, artist WHERE album.id = song.album_id AND artist.id = song.artist_id AND song.id = '".$id."'"; $result = mysql_query($query); $song = mysql_fetch_assoc($result); $query2 = "SELECT SUM(song.plays) as total_plays, AVG(song.rating/song.num_rating) as average_rating, song.id as song_id, song.lyric_id as lyric_id, song.lyrics_approved as lyrics, song.song_name as song_name, album.album_name as album_name, album.album_photo, artist.name AS artist_name, artist.id as artist_id, album.id as album_id FROM song, album, artist WHERE song.id = '".$id."' AND album.id = song.album_id AND artist.id = song.artist_id GROUP BY song.id ORDER BY song.song_name ASC"; $result2 = mysql_query($query2); $songR = mysql_fetch_assoc($result2); $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']); $rating = ((round($songR['average_rating'])<1)?'1':round($songR['average_rating'])); $url = $this->url."/audio/".$url.'?title="'.$song['album_photo'].'&&'.$rating.'|'.$song['song_id'].';'.$song['song_name'].'"&author="'.$song['artist_id'].'|'.$song['artist_name'].'"©right="'.$song['album_id'].'|'.$song['album_name'].'"';//'?title="'.$song['album_photo'].'&&'.$rating.'|'.$song['song_id'].';'.$song['song_name'].'"&author="'.$song['artist_name'].'"©right="'.$song['album_name'].'"'; if( preg_match("/http/",$url ) ) { fwrite($file,$url."\n") or die("Creating of m3u failed"); } } } fclose($file); $filename = $m3u_url; } else { if( $song_ids != "" ) { //$file = fopen($filename,'w'); $count++; $query = "SELECT album.album_name AS album_name,album.album_photo, album.id AS album_id, artist.name AS artist_name,artist.id AS artist_id, song.song_name, song.id as song_id, song.song_path AS song_path FROM song, album, artist WHERE album.id = song.album_id AND artist.id = song.artist_id AND song.id = '".$song_ids."'"; $result = mysql_query($query); $song = mysql_fetch_assoc($result); $query2 = "SELECT SUM(song.plays) as total_plays, AVG(song.rating/song.num_rating) as average_rating, song.id as song_id, song.lyric_id as lyric_id, song.lyrics_approved as lyrics, song.song_name as song_name, album.album_name as album_name, album.album_photo, artist.name AS artist_name, artist.id as artist_id, album.id as album_id FROM song, album, artist WHERE song.id = '".$song_ids."' AND album.id = song.album_id AND artist.id = song.artist_id GROUP BY song.id ORDER BY song.song_name ASC"; $result2 = mysql_query($query2); $songR = mysql_fetch_assoc($result2); $rating = ((round($songR['average_rating'])<1)?'1':round($songR['average_rating'])); $url = preg_replace("/".preg_replace("/\//","\/",$this->siteroot)."/",$this->url,$song['song_path']); $url = 'audio/'.$url. '?title="'.$song['album_photo'].'&&'.$rating.'|'.$song['song_id'].';'.$song['song_name'].'"&author="'.$song['artist_id'].'|'.$song['artist_name'].'"©right="'.$song['album_id'].'|'.$song['album_name'].'"'; /*if( preg_match("/http/",$url ) ) { fwrite($file,$url."\n") or die("Creating of m3u failed"); } fclose($file); */ $filename = $url; $query = "UPDATE song SET plays = plays + 1 WHERE id = '".$song_ids."'"; $result = mysql_query($query); } } /************************ Real Player Code Started ****************************/ if( $count != 0 ) { print(""); print(" "); print(""); print(""); print(""); print(""); print(" "); print(""); print(""); print("

"); print("

Ratings :

"); if($session->logged_in) print("

"); print("

Loading...

"); print(""); print("

"); print(""); print(""); } else { print("

Error: No files selected unable to launch player.

"); } /************************ Real Player Code Ended ****************************/ } /*******Playlist Functions*******/ function playlist() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; global $session; $song_id_raw = addslashes($HTTP_GET_VARS['id']); $song_id = split(",",addslashes($HTTP_GET_VARS['id'])); if( $HTTP_GET_VARS['save'] == 'yes' ) { if( $HTTP_GET_VARS['create'] == 'yes' ) { $query = "INSERT INTO playlist (username, playlist_name) VALUES ('".$session->username."','".addslashes($HTTP_POST_VARS['playlist_name'])."')"; mysql_query($query) or die(mysql_error()); $query = "SELECT * FROM playlist WHERE username = '".$session->username."' AND playlist_name = '".addslashes($HTTP_POST_VARS['playlist_name'])."'"; $result = mysql_query($query) or die(mysql_error()); $playlist = mysql_fetch_assoc($result); $playlist_id = $playlist['id']; } else { $playlist_id = addslashes($HTTP_POST_VARS['playlist_id']); } foreach( $song_id as $id ) { if( $id != '' ) { $query = "INSERT INTO playlistsong (song_id, playlist_id) VALUES ('".$id."','".$playlist_id."')"; mysql_query($query) or die(mysql_error()); } } print("\n"); print("

\n"); } else { print("\n"); print("

Thankyou for rating this Song

\n"); print("

Create and Save new playlist

\n"); print("\n"); print("\n"); print("

New Playlist Name:

\n"); $query = "SELECT * FROM playlist WHERE username = '".$session->username."' ORDER BY playlist_name ASC"; $result = mysql_query($query) or die(mysql_error()); if( mysql_num_rows($result)>0 ) { print("\n"); } } } function removefromplaylist() { global $session; global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $query = "SELECT username FROM playlist WHERE id=".addslashes($HTTP_GET_VARS['playlist']); $result = mysql_query($query) or die(mysql_error()); $row = mysql_fetch_assoc($result); if ($session->username === $row['username']) { $query = "DELETE FROM playlistsong WHERE playlist_id = ".addslashes($HTTP_GET_VARS['playlist'])." AND song_id = ".addslashes($HTTP_GET_VARS['id']); mysql_query($query) or die(mysql_error()); print("The Song has been removed from your playlist.
\n"); print("

\n"); } else { print("Sorry, you can only remove Songs from your own playlists.
\n"); print("

\n"); } } function viewAllPlaylists() { global $session; global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $query = "SELECT playlist.id as id, playlist.playlist_name, playlist.username FROM playlist, playlistsong WHERE playlist.id = playlistsong.playlist_id GROUP BY playlistsong.playlist_id ORDER BY playlist.playlist_name ASC"; $result = mysql_query($query) or die(mysql_error()); while( $row = mysql_fetch_assoc($result) ) { // get initial name character $thischar = $row['playlist_name']{0}; $user = $this->get_info($row['username']); // Check to see if different than last if( $lastchar != $thischar ) { print("

".strtoupper($thischar)."

\n"); if( $lastchar != '' ) { print("

\n"); } } // Print album Info print("".$row['playlist_name']." by ".$user['name']."
\n"); // Store character $lastchar = $thischar; } if( $session->username!="" ) { print("

".$session->username."'s Playlists

"); } else { print("

User Playlists

"); } $query = "SELECT * FROM playlist ".(($session->username!="")?"WHERE username = '".addslashes($session->username)."'":"")." ORDER BY username, playlist_name"; $result = mysql_query($query) or die(mysql_error()); $i = 0; $cur_id = -1; for( ; $row = mysql_fetch_assoc($result) ; $i++ ) { print("

".$session->username."

".$row['playlist_name']."

"); if( $i == 0 ) { print(""); } } function showUsersPlaylists() { global $session; global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; if( $HTTP_GET_VARS['username']!="" ) { print("

No playlists yet created.

Users Playlist

"); } else { print("

Users Playlist

"); } $query = "SELECT * FROM playlist ".(($HTTP_GET_VARS['username']!="")?"WHERE username = '".addslashes($HTTP_GET_VARS['username'])."'":"")." ORDER BY username, playlist_name"; $result = mysql_query($query) or die(mysql_error()); $i = 0; $cur_username = -1; for( ; $row = mysql_fetch_assoc($result) ; $i++ ) { if( $HTTP_GET_VARS['username']!="" ) { if( $i == 0 ) { print("

"); } } else if( $cur_username != $row['username'] ) { if( $i!=0) { print(""); } $cur_username = $row['username']; print(""); } print("

".$user['name']."

"); } print(""); if( $i == 0 ) { print("

".$row['playlist_name']."

"); } } function showAllPlaylists() { global $session; global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; if( $HTTP_GET_VARS['username']!="" ) { #$user = $this->get_info($session->username); print("

All Users Playlists

"); } else { print("

No playlists yet created.

All Users Playlist

\n"); } $u_query = "SELECT username FROM playlist GROUP BY username"; $u_result = mysql_query($u_query) or die(mysql_error()); while($u_row = mysql_fetch_assoc($u_result)) { echo "

".$u_row[username]."

"; print("

".$row['playlist_name']."

"); } print(""); } if( $i == 0 ) { print("

"); } } function viewPlaylist() { global $session; global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; #print("

View all user playlists.

"); $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; } if($playlistname) { $playlistname=$playlistname; } else { $playlistname="All"; } print("

No playlists yet created.

".$username." playlist - ".$playlistname."

\n"); print("

"); $query = "SELECT * FROM playlist WHERE username = '".$session->username."' ORDER BY playlist_name ASC"; $result = mysql_query($query) or die(mysql_error()); print("\n"); print("

"); if( $username != "" && $username != $session->username ) { $user = $this->get_info($username); print("\n"); } else { print(" "); } print("

\n"); if($session->username!="Guest") { print("\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("

\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("

\n"); if($total==0) { echo "Please select a playlist from dropdown."; } $this->topButtons(); print("\n"); $i = 1; while( $row = mysql_fetch_assoc($result) ) { print("\n"); print("\n"); print("\n"); print("\n"); } print("

$i	".$row['song_name']."	".(($row['lyrics']!=0)?"":" ")."
	Artist Name: ".$row['artist_name']."
	Album Name: ".$row['album_name']."
	Times Played ".$row['total_plays']." ".(($session->logged_in)?"Add to Playlist Remove ":"").(($row['lyrics']!=1)?" Add Lyrics":"")."

"); print("\n"); print("\n"); } /********** Mail Friend Functions **********/ function mailFriend() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $song_id = addslashes($HTTP_GET_VARS['song']); $album_id = addslashes($HTTP_GET_VARS['album']); $artist_id = addslashes($HTTP_GET_VARS['artist']); $genre_id = addslashes($HTTP_GET_VARS['genre']); global $session; if( $HTTP_GET_VARS['send'] == 'yes' ) { $send_to = addslashes($HTTP_POST_VARS['send_to']); $message = addslashes($HTTP_POST_VARS['message']); $href = addslashes($HTTP_POST_VARS['href']); $info = addslashes($HTTP_POST_VARS['info']); $email = addslashes($HTTP_POST_VARS['email']); $name = addslashes($HTTP_POST_VARS['name']); if( !$session->logged_in ) { $subject = addslashes("$name"); } 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); print("Email this Song"); $songtable = "

"); $this->bottomButtons(); print("

\n"; $songtable .= "\n"; $songtable .= "\n"; $songtable .= "

Mail this Song	".$row['song_name']."
Artist Name: ".$row['artist_name']."
Album Name: ".$row['album_name']."
Times Played ".$row['total_plays']."

\n"; $user = array(); if( $session->logged_in ) { //$user = $this->get_info(); } else { $user['email'] = $email; $user['name'] = $name; } /********** Email a Friend Template **********/ $query = "INSERT INTO mailfriend (username,sent_to,subject,message, song_id, album_id, artist_id, genre_id) VALUES ('".$HTTP_POST_VARS['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","

Hae Hi ".$user['name'].", The audio clip below was emailed to you from ".$user['name']." on our site ".$this->page_title.". Please be sure to visit our Huge audio archives. We hope you like it.

".$songtable."

Sender's message:
===================================================
".$HTTP_POST_VARS['message']."
===================================================
Click Here to Listen to it Now

Note: Sender's e-mail as entered on website.","MIME-Version: 1.0\r\nContent-type: text/html; charset=iso-8859-1\r\nFrom: ".$this->email."\r\n"); print("

Your Song Successfully sent.

"); } print(""); print("

\n"); print("\n"); print("

Mail this Song

\n"); if( !$session->logged_in ) { print("\n"); print("\n"); } else { print("\n"); print("\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("Email this Song"); print("

Your Name:
Your Email:

\n"); print("\n"); print("\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("\n"); print("\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("\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("\n"); $mail .= "index.php?action=genre&id=".$genre_id; $info = "the genre ".$row['genre_name']; } print("\n"); print("\n"); print("\n"); print("\n"); print("

Artist Name:	".$row['artist_name']."
Album Name:	".$row['album_name']."
Song Name:	".$row['song_name']."
Artist Name:	".$row['artist_name']."
Album Name:	".$row['album_name']."
Artist Name:	".$row['name']."
Genre Name:	".$row['genre_name']."
Email to:
Message:

\n"); } function viewmailfriend() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $start = $HTTP_GET_VARS['start']; if( $start == "" ) { $start = 0; } $query = "SELECT * FROM mailfriend, song WHERE mailfriend.song_id = song.id ORDER BY song.id DESC LIMIT ".$start.",10"; $result = mysql_query($query); $i = 1; while( $row = mysql_fetch_assoc($result) ) { $user = array(); if( $row['username'] ) { $query_u = "SELECT * FROM users WHERE username = '{$row['username']}'"; $result_u = mysql_query($query_u) or die(mysql_error()); $user = mysql_fetch_assoc($result_u); print("

Songs Sent - Emailed from our website

\n"); print(""); $i++; } if( $i == 1 ) { print("

".$user['username']." mailed ".$row['sent_to']."
"); } else { print("

Guest ".$row['subject']." mailed ".$row['sent_to']."
"); } print("Song : ".$row['song_name']."
Message : "); print($this->InsertLinks($row['message'])."

"); } else if ( $i == 11 ) { print(""); } } function InsertLinks ( $Text ) { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; // First match things beginning with http:// (or other protocols) $NotAnchor = '(?$0", $Text ); // Now match things beginning with www. $NotAnchor = '(?$0", $Result ); } /********** Top X Functions **********/ function topx() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $sortby = addslashes($HTTP_POST_VARS['sort']); $show = addslashes($HTTP_GET_VARS['show']); $type = addslashes($HTTP_GET_VARS['type']); //$type = $HTTP_GET_VARS['type']; $genre_id = addslashes($HTTP_GET_VARS['genre']); if( $type == '' ) { print("

Possible usage (replace number by show by any number doesn't just have to be 5)

"); print("

Top 5 Artists
".$this->thisfile."?action=top&show=5&type=Artists
"); print("Also can display specific by just saying genre id number ".$this->thisfile."?action=top&show=5&type=Artists&genre=1

"); print("

Top 5 Songs
".$this->thisfile."?action=top&show=5&type=Songs
"); print("Also can display specific by just saying genre id number ".$this->thisfile."?action=top&show=5&type=Songs&genre=1

"); print("

Top 5 Albums
".$this->thisfile."?action=top&show=5&type=albums
"); print("Also can display specific by just saying genre id number ".$this->thisfile."?action=top&show=5&type=albums&genre=1

"); print("

Top 5 Genres
".$this->thisfile."?action=top&show=5&type=Genres

"); return; } // Display Title print("Top Artists"); print("

Nobody has yet mailed a song.

.: View more

Top ".$show); if( $genre_id != '' ) { $query = "SELECT * FROM genre WHERE id ='".$genre_id."'"; $result = mysql_query($query); $genre = mysql_fetch_assoc($result); print(" Most Popular ".$type." in ".$genre['genre']."\n"); } else { print(" Most Popular ".$type."

\n"); } //$this->sortby("action=top&show=".$show."&genre=".$genre_id."&type=".$type); // Query if( $genre_id != "" ) { $where = "album.genre_id = '".$genre_id."' AND "; } if( $type == "albums" ) { $query = "SELECT album.id as album_id, SUM(song.plays) as total_plays, TO_DAYS(now())-TO_DAYS(album.post_date)as date_diff, COUNT(song.id) as total_songs, 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 FROM song, album, artist WHERE ".(($genre_id!="")?$where:"")."album.id = song.album_id AND artist.id = song.artist_id GROUP BY song.album_id ORDER BY Total_Plays DESC, album.album_name ASC"; } else if( $type == "Artists" ) { $query = "SELECT SUM(song.plays) as total_plays, COUNT(song.id) as total_songs, AVG(song.rating/song.num_rating) as average_rating, artist.id AS artist_id, artist.name as artist_name FROM song, artist, album WHERE ".(($genre_id!="")?$where:"")."album.id = song.album_id AND artist.id = song.artist_id GROUP BY song.artist_id ORDER BY Total_Plays DESC, artist.name ASC"; } else if( $type == "Songs" ) { $query = "SELECT SUM(song.plays) as total_plays, AVG(song.rating/song.num_rating) as average_rating, song.id as song_id, song.lyric_id as lyric_id, song.lyrics_approved as lyrics, song.song_name as song_name, album.album_name as album_name, artist.name AS artist_name, artist.id as artist_id, album.id as album_id FROM song, album, artist WHERE ".(($genre_id!="")?$where:"")."album.id = song.album_id AND artist.id = song.artist_id GROUP BY song.id ORDER BY Total_Plays DESC, song.song_name ASC"; } else if( $type == "Genres" ) { $query = "SELECT SUM(song.plays) as total_plays, COUNT(song.id) as total_songs, COUNT(album.id) as total_albums, genre.genre AS genre_name, genre.id as genre_id FROM song, album, genre WHERE ".(($genre_id!="")?$where:"")."genre.id = album.genre_id AND album.id = song.album_id GROUP BY album.genre_id ORDER BY Total_Plays DESC, genre.genre ASC"; } $result = mysql_query($query." LIMIT ".$show) or die(mysql_error()); print("

\n"); if( $type == "Songs" ) { $this->topButtons(); } print("\n"); for( $i = 1 ; $row = mysql_fetch_assoc($result) ; $i++ ) { if( $type == "Albums" ) { print("\n"); print("\n"); print("\n"); print("\n"); } else if( $type == "Artists" ) { print("\n"); print("\n"); print("\n"); } else if( $type == "Songs" ) { print("\n"); print("\n"); print("\n"); print("\n"); } else if( $type == "Genres" ) { print("\n"); print("\n"); print("\n"); } } print("

$i	".$row['album']." ".(($row['date_diff'] < 14)?"":"")."
	Artist: ".$row['artist_name']."
	Total Songs: ".$row['total_songs']."
	Total Plays: ".$row['total_plays']."
$i	".$row['artist_name']."
	Total Songs: ".$row['total_songs']."
	Total Plays: ".$row['total_plays']."
	$i	".$row['song_name']."	".(($row['lyrics']!=0)?"":" ")."
		Artist Name: ".$row['artist_name']."
		Album Name: ".$row['album_name']."
		Total Plays: ".$row['total_plays']." ".(($this->username!=0)?"Add to Playlist ":"").(($row['lyrics']!=1)?" Add Lyrics":"")."
$i	".$row['genre_name']."
	Total Songs: ".$row['total_songs']."
	Total Plays: ".$row['total_plays']."

\n"); } /********** Search Song **********/ function search() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $term = $HTTP_GET_VARS['term']; $in = $HTTP_GET_VARS['in']; $start = $HTTP_GET_VARS['start']; global $session; if ($HTTP_GET_VARS['term']) { /** * Log Search */ $query = "INSERT INTO searches VALUES ('','" . addslashes($HTTP_GET_VARS['term']) . "','" . addslashes($HTTP_GET_VARS['in']) . "','" . addslashes($session->username) . "')"; $result = mysql_query($query) or die(mysql_error()); /** Clean Up Old Searches */ $query = "DELETE FROM searches WHERE id <= " . (mysql_insert_id() - 5); $result = mysql_query($query) or die(mysql_error()); if($start == "" || !isset($start)) { $start = 0; } } print("

"); if( $type == "Songs" ) { $this->bottomButtons(); } print("

Recent Searches

"); print("

\n"); if( $in == '' || $term == '' ) { print(""); } function infoupload_Song($type) { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $id = addslashes($HTTP_GET_VARS['id']); print("

\n"); // Save Information? if( $HTTP_GET_VARS['save'] == 'yes' ) { $susername = $HTTP_SESSION_VARS["username"]; $suserid = $HTTP_SESSION_VARS["userid"]; if( $type == 'new' ) { $sfalg = 1; $susername = $HTTP_SESSION_VARS["username"]; $suserid = $HTTP_SESSION_VARS["userid"]; for($i=0;$i<5;$i++) { $str_upload = trim(basename($HTTP_POST_FILES["upload_song_path".$i]["name"])); $spath = trim($HTTP_POST_FILES["upload_song_path".$i]["name"]); if($HTTP_POST_VARS['song_name'.$i] != "") { $str_size = $HTTP_POST_FILES["upload_song_path".$i]["size"]; $str_user_id = $HTTP_SESSION_VARS["userid"]; //echo("
".$str_size); if($str_size < 20000000) { // check songname and filename alredy exist or not $str_0 = "select * from upload_song where song_name = '".addslashes(trim($HTTP_POST_VARS['song_name'.$i]))."'"; $result_0 = @mysql_query($str_0); $rows_0 = @mysql_num_rows($result_0); if($rows_0 == 0) { $str_1 = "select * from upload_song where song_path = '".$spath."'"; $result_1 = @mysql_query($str_1); $rows_1 = @mysql_num_rows($result_1); if($rows_1 == 0) { //********** Insert into Db ( upload_song table ) ****************** $query = "INSERT INTO upload_song ( song_name, artist_name, album_name, format_id, song_path ,user_name) VALUES "; $query .= "('".addslashes(trim($HTTP_POST_VARS['song_name'.$i]))."','".trim($HTTP_POST_VARS['artist_id'.$i])."','".trim($HTTP_POST_VARS['album_id'.$i])."','".trim($HTTP_POST_VARS['format_id'.$i])."','".$spath."','".$susername."')"; $rs = @mysql_query($query); //********** Upload Song ****************** $UPLOAD_PATH = AUDIO_DIR."/";//"audio/"; if(@is_uploaded_file($HTTP_POST_FILES["upload_song_path".$i]["tmp_name"])) { @move_uploaded_file($HTTP_POST_FILES["upload_song_path".$i]["tmp_name"],$UPLOAD_PATH.$str_upload); } //print("

".($i+1).") Upload the song successfully

"); $toggle = 1; $arr_song_name[] = addslashes(trim($HTTP_POST_VARS['song_name'.$i])); } else { $arr_song_name[] = "".addslashes(trim($HTTP_POST_VARS['song_name'.$i])) . "
Unable to uplaod the song.... Song with file already exists" ; /* $toggle = 10; // File Name Already exists break; // print("

".($i+1).") Unable to uplaod the song ........
Song with file name '".$spath."' already exists

");*/ } } else { $arr_song_name[] = "".addslashes(trim($HTTP_POST_VARS['song_name'.$i]))."
Unable to uplaod the song.... Song name already exists" ; } } else { $arr_song_name[] = "".addslashes(trim($HTTP_POST_VARS['song_name'.$i]))."
Unable to uplaod the song.... File Size Must be less than 20 Mb" ; } } } /************************************************************/ } else { $query = "UPDATE song SET song_name = '".addslashes($HTTP_POST_VARS['song_name'])."', artist_id = '".$HTTP_POST_VARS['artist_id']."', album_id='".$HTTP_POST_VARS['album_id']."', format_id='".$HTTP_POST_VARS['format_id']."', song_path='".addslashes($HTTP_POST_VARS['song_path'])."' WHERE id = '".$id."'"; } if($toggle == 1) { //print("

Success! We were able to upload the songs

"); } else { //print("

Warning! We were unable to upload the songs

"); } } // Determine Type of Form if( $type == 'new' ) { print("

"); } else { if( $in == 'song' ) { $query = "SELECT SUM(song.plays) as total_plays, AVG(song.rating/song.num_rating) as average_rating, song.id as song_id, song.lyric_id as lyric_id, song.lyrics_approved as lyrics, song.song_name as song_name, album.album_name as album_name, artist.name AS artist_name, artist.id as artist_id, album.id as album_id FROM song, album, artist WHERE album.id = song.album_id AND artist.id = song.artist_id AND song.song_name LIKE '%".$term."%' GROUP BY song.id ORDER BY Total_Plays DESC, song.song_name ASC LIMIT ".$start.",10"; } else if( $in == 'album' ) { $query = "SELECT album.id as album_id, TO_DAYS(now())-TO_DAYS(album.post_date)as date_diff, 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 FROM song, album, artist WHERE album.id = song.album_id AND artist.id = album.artist_id AND album.album_name LIKE '%".$term."%' GROUP BY song.album_id LIMIT ".$start.",10"; } else if( $in == 'artist' ) { $query = "SELECT SUM(song.plays) as total_plays, COUNT(song.id) as total_songs, AVG(song.rating/song.num_rating) as average_rating, artist.id AS artist_id, artist.name as artist_name FROM song, artist, album WHERE album.id = song.album_id AND artist.id = song.artist_id AND artist.name LIKE '%".$term."%' GROUP BY song.artist_id ORDER BY Total_Plays DESC, artist.name ASC LIMIT ".$start.",10"; } else { print("Error: Invalid search\n"); return; } $result = mysql_query($query) or die(mysql_error()); print("

\n"); if( $in == "song" ) { $this->topButtons(); } print("\n"); $i = 1; for( $i = 1 ; $row = mysql_fetch_assoc($result) ; $i++ ) { if( $in == "album" ) { print("\n"); print("\n"); print("\n"); print("\n"); } else if( $in == "artist" ) { print("\n"); print("\n"); print("\n"); } else if( $in == "song" ) { print("\n"); print("\n"); print("\n"); print("\n"); } } if( $i == 1 ) { print("\n"); } else if( $i == 11 ) { print("
\n"); } print("\n"); print("

$i	".$row['album']." ".(($row['date_diff'] < 14)?"":"")."
	Artist: ".$row['artist_name']."
	Total Songs: ".$row['total_songs']."
	Times Played ".$row['total_plays']."
$i	".$row['artist_name']."
	Total Songs: ".$row['total_songs']."
	Times Played ".$row['total_plays']."
	$i	".$row['song_name']."	".(($row['lyrics']!=0)?"":" ")."
		Artist Name: ".$row['artist_name']."
		Album Name: ".$row['album_name']."
		Times Played ".$row['total_plays']." ".(($this->username!=0)?"Add to Playlist ":"").(($row['lyrics']!=1)?" Add Lyrics":"")."
Your search returned no results. Please try again.

.: Next Page >> View more results:.

\n"); } print("\n"); print("\n"); } /********** Download Song **********/ function download_songs() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $sortby = addslashes($HTTP_POST_VARS['sort']); $show = addslashes($HTTP_GET_VARS['show']); $type = addslashes($HTTP_GET_VARS['type']); //$type = $HTTP_GET_VARS['type']; $genre_id = addslashes($HTTP_GET_VARS['genre']); print("

Download songs

\n"); // Query if( $genre_id != "" ) { $where = "album.genre_id = '".$genre_id."' AND "; } $query = "SELECT SUM(song.plays) as total_plays, AVG(song.rating/song.num_rating) as average_rating, song.id as song_id,song.counter as counter song.lyric_id as lyric_id, song.lyrics_approved as lyrics, song.song_name as song_name, album.album_name as album_name, artist.name AS artist_name, artist.id as artist_id, album.id as album_id FROM song, album, artist WHERE ".(($genre_id!="")?$where:"")."album.id = song.album_id AND artist.id = song.artist_id GROUP BY song.id ORDER BY Total_Plays DESC, song.song_name ASC"; //$result = mysql_query($query." LIMIT ".$show) or die(mysql_error()); $result = mysql_query($query) or die(mysql_error()); print("\n"); //if( $type == "Songs" ) { $this->topButtons(); } print("

"); if( $in == "song" ) { $this->bottomButtons(); } print("

\n"); for( $i = 1 ; $row = mysql_fetch_assoc($result) ; $i++ ) { print("\n"); print("\n"); print("\n"); print("\n"); } print("

$i	".$row['song_name']."	".(($row['lyrics']!=0)?"":" ")."
	Artist Name: ".$row['artist_name']."
	Album Name: ".$row['album_name']."
	Total Plays: ".$row['total_plays']." ".(($this->username!=0)?"Add to Playlist ":"").(($row['lyrics']!=1)?" Add Lyrics":"")."

\n"); //if( $type == "Songs" ) { $this->bottomButtons(); } print("\n"); } /********** Upload Song **********/ function songupload() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS; $page = $HTTP_GET_VARS['page']; switch( $page ) { case 'approve': $this->approveupload_Song(addslashes($HTTP_GET_VARS['id'])); break; case 'deny': $this->denyupload_Song(addslashes($HTTP_GET_VARS['id']));//infoupload_Song('deny'); break; default: // default new $this->infoupload_Song('new'); break; } //print("

Add Multiple Files

"); print("

Add Songs Download Link.

Upload Songs

\n"); print("you can upload 5 songs at once\n"); $song_name = ""; $artist_id = ""; $album_id = ""; $length_min = 0; $length_sec = 0; $format_id = ""; $song_path = $this->musicpath; } else { print("

Edit Song

\n"); $query = "SELECT * FROM song WHERE id = '".$id."'"; $row = mysql_fetch_assoc( mysql_query($query) ); $song_name = $row['song_name']; $artist_id = $row['artist_id']; $album_id = $row['album_id']; $length_min = floor($row['length']/60); $length_sec = $row['length']%60; $format_id = $row['format_id']; $song_path = $row['song_path']; } print( ""); // Form print("

\n"); //print("File size must be less than 20 Mb

"); print("\n"); for($vloop=0;$vloop<5;$vloop++) { print("\n"); print(""); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); /*print("\n");*/ print("\n"); print("\n"); print("

Song Name:
Artist Name:
Album Name:
Format:

Song Path:

\n"); print("\n"); } print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("

\n"); print("\n"); if($sfalg==1) { print(" Following songs uploaded successfully

"); print("

\n"); print("
\n"); print("\n"); print("

"); //print(""); for($j=0;$j"); } } } /********** Upload Songs Link **********/ function songlink() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS; $page = $HTTP_GET_VARS['page']; switch( $page ) { case 'approve': $this->approveupload_Song_link(addslashes($HTTP_GET_VARS['id'])); break; case 'deny': $this->denyupload_Song_link(addslashes($HTTP_GET_VARS['id']));//infoupload_Song('deny'); break; default: // default new $this->infoupload_Song_link('new'); break; } } function infoupload_Song_link($type) { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $id = addslashes($HTTP_GET_VARS['id']); print("

\n"); // Save Information? if( $HTTP_GET_VARS['save'] == 'yes' ) { $susername = $HTTP_SESSION_VARS["username"]; $suserid = $HTTP_SESSION_VARS["userid"]; if( $type == 'new' ) { for($i=0;$i<1;$i++) { $str_upload = trim($HTTP_POST_VARS["upload_song_path".$i]); $spath = $str_upload; if($HTTP_POST_VARS['song_name'.$i] != "") { // check songname and filename alredy exist or not $str_0 = "select * from upload_song where song_name = '".addslashes(trim($HTTP_POST_VARS['song_name'.$i]))."'"; $result_0 = @mysql_query($str_0); $rows_0 = @mysql_num_rows($result_0); if($rows_0 == 0) { $str_1 = "select * from upload_song where song_path = '".$spath."'"; $result_1 = @mysql_query($str_1); $rows_1 = @mysql_num_rows($result_1); if($rows_1 == 0) { //********** Insert into Db ( upload_song table ) ****************** $query = "INSERT INTO upload_song ( song_name, artist_name, album_name, format_id, song_path ,user_name) VALUES "; $query .= "('".addslashes(trim($HTTP_POST_VARS['song_name'.$i]))."','".trim($HTTP_POST_VARS['artist_id'.$i])."','".trim($HTTP_POST_VARS['album_id'.$i])."','".trim($HTTP_POST_VARS['format_id'.$i])."','".trim($spath)."','".trim($susername)."')"; $rs = @mysql_query($query); print("

Success ! We were able to upload the songs Link

"); } else { $toggle = 1; // File Name Already exists print("

We were unable to upload the songs Link ........
Song link with file name '".$spath."' already exists

"); } } else { $toggle = 2; // Song Name Already exists print("

We were unable to upload the songs Link ........
Song link with Song name '".addslashes(trim($HTTP_POST_VARS['song_name'.$i]))."' already exists

"); } } else { print("

Warning: We were unable to upload the songs Link

"); } } } else { $query = "UPDATE song SET song_name = '".addslashes($HTTP_POST_VARS['song_name'])."', artist_id = '".$HTTP_POST_VARS['artist_id']."', album_id='".$HTTP_POST_VARS['album_id']."', format_id='".$HTTP_POST_VARS['format_id']."', song_path='".addslashes($HTTP_POST_VARS['song_path'])."' WHERE id = '".$id."'"; } } // Determine Type of Form if( $type == 'new' ) { print("

Upload Song Link

\n"); $song_name = ""; $artist_id = ""; $album_id = ""; $length_min = 0; $length_sec = 0; $format_id = ""; $song_path = $this->musicpath; } else { print("

Edit Song

Song Name

".$arr_song_name[$j]."

\n"); for($vloop=0;$vloop<1;$vloop++) { print("\n"); print(""); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); //print("\n"); //print("\n"); print("\n"); print("\n"); print("\n"); } print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("\n"); print("

Song Name:
Artist Name:
Album Name:
Format:
Song Url:
\n"); print("
\n"); print("\n"); print("

\n"); print("

\n"); } function viewallsongs() { global $session; global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; print("

View All Songs

\n"); $u_query = "SELECT song_name,song_path FROM song order by user_name"; $u_result = @mysql_query($u_query); $numrows = @mysql_num_rows($u_result); while($u_row = mysql_fetch_array($u_result)) { $arr_song_name[] = $u_row['song_name']; $arr_song_path[] = $u_row['song_path']; } $next = $HTTP_GET_VARS["next"]; $count = 0; if($next=="") { $next=0; } $tot_no_record = $numrows; $g_limit = NO_OF_RECORDS_DISPLAY; for($loop=($next*$g_limit);$loop<(($next+1)*$g_limit) && $loop<$tot_no_record;$loop++) { $str_song_name = $arr_song_name[$loop]; print(""); } if( $next > 0) { $next--; print("Previous "); $next++; } if( $loop != $tot_no_record ) { $next++; print("Next"); } } function upload_album() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $page=$HTTP_GET_VARS['page']; switch( $page ) { case 'step': $this->upload_album_step2(); break; default: // default new $this->upload_album_general(); break; } } function upload_artist() { //$this->upload_artist_general; global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; if( $HTTP_GET_VARS['save'] == 'yes' ) { $str_upload = trim(basename($HTTP_POST_FILES["userfile"]["name"])); $UPLOAD_PATH = "artist_gallery/avaiting/"; if(@is_uploaded_file($HTTP_POST_FILES["userfile"]["tmp_name"])) { @move_uploaded_file($HTTP_POST_FILES["userfile"]["tmp_name"],$UPLOAD_PATH.$str_upload); $aid=$HTTP_POST_VARS['aid']; mysql_query("INSERT INTO avaiting_artist(id_artist, url) VALUES('$aid', 'artist_gallery/avaiting/$str_upload')"); //****************************** $filename="artist_gallery/avaiting/".$str_upload; $smallpath=substr($filename, 0, strpos($filename, strrchr($filename, "/"))); $twopart=substr($filename, strpos($filename, strrchr($filename, "/"))+1, strlen($filename)); $smallpath=$smallpath."/small-".$twopart; $it=substr($filename, strlen($filename)-3, strlen($filename)); if ($it=="jpg") { $img=ImageCreateFromJPEG($filename); $dstW=imagesx($img); $dstH=imagesy($img); $srcW=150; $srcH=150; $rimg=imagecreatetruecolor($srcW, $srcH); imagecopyresized($rimg, $img, 0, 0, 0, 0, $srcW, $srcH, $dstW, $dstH); imagejpeg($rimg, $smallpath); } if ($it=="gif") { $img=ImageCreateFromGIF($filename); $dstW=imagesx($img); $dstH=imagesy($img); $srcW=150; $srcH=150; $rimg=imagecreatetruecolor($srcW, $srcH); imagecopyresized($rimg, $img, 0, 0, 0, 0, $srcW, $srcH, $dstW, $dstH); imagegif($rimg, $smallpath); } //****************************** } } echo ("

".$str_song_name."

Upload new image to Artist gallery

\n"); print("

\n"); print("\n"); print(" \n"); print(" \n"); print(" Select artist:\n"); print(" \n"); print("

\n"); print(" Choose image file: \n"); print("
\n"); print(" \n"); print(" \n"); print(" \n"); print("\n"); } function upload_album_general() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; if( $HTTP_GET_VARS['save'] == 'yes' ) { $str_upload = trim(basename($HTTP_POST_FILES["userfile"]["name"])); $UPLOAD_PATH = "album_gallery/avaiting/"; if(@is_uploaded_file($HTTP_POST_FILES["userfile"]["tmp_name"])) { @move_uploaded_file($HTTP_POST_FILES["userfile"]["tmp_name"],$UPLOAD_PATH.$str_upload); $aid=$HTTP_POST_VARS['aid']; $albid=$HTTP_POST_VARS['albid']; mysql_query("INSERT INTO avaiting_album(id_artist, id_album, url) VALUES('$aid', '$albid', 'album_gallery/avaiting/$str_upload')"); //****************************** $filename="album_gallery/avaiting/".$str_upload; $smallpath=substr($filename, 0, strpos($filename, strrchr($filename, "/"))); $twopart=substr($filename, strpos($filename, strrchr($filename, "/"))+1, strlen($filename)); $smallpath=$smallpath."/small-".$twopart; $it=substr($filename, strlen($filename)-3, strlen($filename)); if ($it=="jpg") { $img=ImageCreateFromJPEG($filename); $dstW=imagesx($img); $dstH=imagesy($img); $srcW=150; $srcH=150; $rimg=imagecreatetruecolor($srcW, $srcH); imagecopyresized($rimg, $img, 0, 0, 0, 0, $srcW, $srcH, $dstW, $dstH); imagejpeg($rimg, $smallpath); } if ($it=="gif") { $img=ImageCreateFromGIF($filename); $dstW=imagesx($img); $dstH=imagesy($img); $srcW=150; $srcH=150; $rimg=imagecreatetruecolor($srcW, $srcH); imagecopyresized($rimg, $img, 0, 0, 0, 0, $srcW, $srcH, $dstW, $dstH); imagegif($rimg, $smallpath); } //****************************** } } echo ("

\n"); print(" \n"); print("

Upload new image to Album gallery

\n"); print("

\n"); print("\n"); print("\n"); print(" \n"); print(" \n"); print(" Please, select artist:

\n"); print(" \n"); print("
\n"); print(" \n"); print(" \n"); print("\n"); } function upload_album_step2() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $aid=$HTTP_GET_VARS['aid']; $sql_artist=mysql_query("SELECT name FROM artist WHERE id='$aid'"); $aname=mysql_fetch_row($sql_artist); $aname=$aname[0]; print("

\n"); print("\n"); print("\n"); print("\n"); print("

\n"); print(" \n"); print("

\n"); print(" \n"); print(" Step 2, Select any \"".$aname."\" album:

\n"); print(" \n"); print("
\n"); print(" Choose image file:
\n"); print("
\n"); print(" \n"); print(" \n"); print(" \n"); print("\n"); } function viewgallery() { global $HTTP_POST_VARS,$HTTP_GET_VARS,$HTTP_SERVER_VARS,$HTTP_SESSION_VARS,$HTTP_COOKIE_VARS,$HTTP_POST_FILES; $aid=$HTTP_GET_VARS['aid']; $type=$HTTP_GET_VARS['type']; $image=$HTTP_GET_VARS['image']; $page=$HTTP_GET_VARS['page']; if ($type=="artist") { $result=mysql_query("SELECT name FROM artist WHERE id='$aid'"); $artist_name=mysql_fetch_row($result); $artist_name=$artist_name[0]; print("

\n"); print(" \n"); print("

".$artist_name." Gallery

"; } } else { $result=mysql_query("SELECT artist_id FROM album WHERE id='$aid'"); $artist_id=mysql_fetch_row($result); $artist_id=$artist_id[0]; $result=mysql_query("SELECT name FROM artist WHERE id='$artist_id'"); $artist_name=mysql_fetch_row($result); $artist_name=$artist_name[0]; $result=mysql_query("SELECT album_name FROM album WHERE id='$aid'"); $album_name=mysql_fetch_row($result); $album_name=$album_name[0]; print("

\n"); $ii=0; $line=" No entries were found."; //***** $result=mysql_query("SELECT COUNT(url) FROM artist_gallery WHERE id_artist='$aid'"); $total_images=mysql_fetch_row($result); $total_images=$total_images[0]; if (!isset($page)) { $page=1; } $linep="Pages "; $bcd=bcdiv($total_images, 4); for ($i=1; $i<=$bcd+1; $i++) { if ($i<($bcd+1)) { if ($i==$page) { $linep=$linep." ".$i.","; } else { $linep=$linep." ".$i.","; } } else { if ($i==$page) { $linep=$linep." ".$i.""; } else { $linep=$linep." ".$i.""; } } } echo "".$linep."
"; $one_limit=(($page-1)*4); $two_limit=4; //***** $slq_artist_gallery=mysql_query("SELECT * FROM artist_gallery WHERE id_artist='$aid' LIMIT ".$one_limit.", ".$two_limit.""); while($gallery_row = mysql_fetch_array($slq_artist_gallery)) { $ii++; if ($ii==1) { $line=""; } $image_url=$gallery_row["url"]; $id=$gallery_row["id"]; $smallpath=substr($image_url, 0, strpos($image_url, strrchr($image_url, "/"))); $twopart=substr($image_url, strpos($image_url, strrchr($image_url, "/"))+1, strlen($image_url)); $smallpath=$smallpath."/small-".$twopart; $line=$line."

"; } echo "".$line.""; if (isset($image)) { $sql_image=mysql_query("SELECT url FROM artist_gallery WHERE id_artist='$aid' AND id='$image'"); $url=mysql_fetch_row($sql_image); $url=$url[0]; echo "
"; echo "

".$artist_name." \"".$album_name."\" Album Gallery

"; } } } } /***************************CART FUNCTIONS**********************************/ // Create Class $mymusic = new Music($HTTP_GET_VARS['action'], $session['username']); function buy_link($id,$type) { global $site_options,$dbDatabase, $db; if(!isset($site_options[store_active])) { //check wether store is active or not //mysql_select_db ($dbDatabase, $db) or die ("Could not select database."); //echo "SELECT * FROM config where name='STORE ACTIVE' and value='1'

BBBB"; $sql_songs = mysql_query("SELECT * FROM config where name='STORE ACTIVE' and value='1' ") or die(mysql_error()); $site_options[store_active]=mysql_num_rows($sql_songs); mysql_free_result($sql_songs); // }//if(!isset($site_options[store_active])) if(!$site_options[store_active]) return ; if($type=="album") { //print("Buy this Album"); return("Buy this Album"); } else { return("

"); } } function isstore_active() { global $site_options; if(!isset($site_options[store_active])) { //check wether store is active or not //mysql_select_db ($dbDatabase, $db) or die ("Could not select database."); //echo "SELECT * FROM config where name='STORE ACTIVE' and value='1'

BBBB"; $sql_songs = mysql_query("SELECT * FROM config where name='STORE ACTIVE' and value='1' ") or die(mysql_error()); $site_options[store_active]=mysql_num_rows($sql_songs); mysql_free_result($sql_songs); // }//if(!isset($site_options[store_active])) return $site_options[store_active]; }//function is_store_active() function chek_store() { $strqr="select value from config where name='STORE ACTIVE' "; $xstr=mysql_query($strqr) or die ("str".mysql_error()); $str=mysql_fetch_array($xstr); extract($str); return $value; } function calculate_price($id) { if(!isstore_active()) return; $val=chek_store(); if($val==1) { $dataqr="SELECT * FROM album WHERE id='$id'"; $xdata=mysql_query($dataqr) or die("data".mysql_error()); $data=mysql_fetch_array($xdata); $amt=$data[price]+$data[tax]; $price="Price :$".$amt. " "; return $price; }else{} } function jsfunction() {?>

\n"); $ii=0; $line=" No entries were found."; //***** $result=mysql_query("SELECT COUNT(url) FROM album_gallery WHERE id_album='$aid'"); $total_images=mysql_fetch_row($result); $total_images=$total_images[0]; if (!isset($page)) { $page=1; } $linep="Pages "; $bcd=bcdiv($total_images, 4); for ($i=1; $i<=$bcd+1; $i++) { if ($i<($bcd+1)) { if ($i==$page) { $linep=$linep." ".$i.","; } else { $linep=$linep." ".$i.","; } } else { if ($i==$page) { $linep=$linep." ".$i.""; } else { $linep=$linep." ".$i.""; } } } echo "".$linep."
"; $one_limit=(($page-1)*4); $two_limit=4; //***** $slq_artist_gallery=mysql_query("SELECT * FROM album_gallery WHERE id_album='$aid' LIMIT ".$one_limit.", ".$two_limit.""); while($gallery_row = mysql_fetch_array($slq_artist_gallery)) { $ii++; if ($ii==1) { $line=""; } $image_url=$gallery_row["url"]; $id=$gallery_row["id"]; $artist_id=$gallery_row["id_artist"]; $smallpath=substr($image_url, 0, strpos($image_url, strrchr($image_url, "/"))); $twopart=substr($image_url, strpos($image_url, strrchr($image_url, "/"))+1, strlen($image_url)); $smallpath=$smallpath."/small-".$twopart; $line=$line."

"; } echo "".$line.""; if (isset($image)) { $sql=mysql_query("SELECT artist_id FROM album WHERE id='$aid'"); $artist_id=mysql_fetch_row($sql); $artist_id=$artist_id[0]; $sql_image=mysql_query("SELECT url FROM album_gallery WHERE id_artist='$artist_id' AND id_album='$aid' AND id='$image'"); $url=mysql_fetch_row($sql_image); $url=$url[0]; $url=str_replace(" ", "%20", $url); echo "
"; echo "