" ; echo "" ; echo "" ; echo "
" alt="album review" title="album review"> " alt="album setcard" title="album setcard"> " alt="band setcard" title="band setcard"> " alt="biography" title="biography"> " alt="label setcard" title="label setcard"> " alt="downloads" title="downloads"> " alt="audio" title="audio">

Setcard

"; echo "$name
"; echo "\"$title\""; ?>
 
" ; echo "
" ; $t_alt=rawurldecode($title); $n_alt=rawurldecode($name); $link = "" ; $tag = "border=\"1\"" ; $pic = "$catno" ; $alt = "Artwork of $n_alt - $t_alt" ; if(picture($dir_cover,$pic,$alt,$link,$tag)) { echo $image; } echo "
" ; } /** BIOGRAPHY **/ if($select=="bio") { echo "" ; echo "" ; echo "" ; echo "" ; echo "
" ; $query = "SELECT bio FROM promo_artist WHERE artist='$artist'" ; $result = mysql_query($query) ; $num = mysql_numrows($result) ; $i=0; $bio = ereg_replace("\n","
",mysql_result($result,$i,"bio")) ; echo "

" ; echo $bio ; echo "

" ; echo "
" ; } /** BAND INFOS **/ if($select=="info") { echo "" ; echo "" ; echo "" ; echo "" ; echo "
" ; $query = "SELECT * FROM promo_artist WHERE artist=$artist" ; $result = mysql_query($query) ; $i=0; $address = ereg_replace("\n","
",mysql_result($result,$i,"address")) ; $lineup = ereg_replace("\n","
",mysql_result($result,$i,"lineup")) ; $web = mysql_result($result,$i,"web") ; $email = mysql_result($result,$i,"email") ; echo "

"; if($lineup!="") { echo "Line-Up:" ; echo "

$lineup
" ; } if($address!="") { echo "Band Contact:" ; echo "
$address
" ; } if($web!="") { echo "Website:" ; echo "
$web
" ; } if($email!="") { echo "Email:" ; echo "
$email
" ; } echo "

" ; } /** ALBUM INFO **/ if($select=="album") { echo "" ; echo "" ; echo "" ; echo "" ; echo "
" ; $query = "SELECT info FROM promo_products WHERE id='$catno'" ; $result = mysql_query($query) ; $num = mysql_numrows($result) ; $i=0; $info=ereg_replace("\n","
",mysql_result($result,$i,"info")) ; echo "

" ; echo $info ; echo "

" ; echo "
" ; } /** PRODUCT DETAILS **/ if($select=="product") { echo "" ; echo "" ; echo "" ; echo "
" ; $query1 = "SELECT * FROM promo_products, promo_label WHERE promo_products.id='$catno' AND promo_label.label=$label" ; $result1 = mysql_query($query1) ; $num = mysql_numrows($result1) ; $i=0; $orgdat = mysql_result($result1,$i,"release") ; $month = substr($orgdat,5,2) ; $year = substr($orgdat,0,4) ; $day = substr($orgdat,8,2) ; $release = date("jS of F Y",mktime(0,0,0,$month,$day,$year)); $l_name = mysql_result($result1,$i,"name") ; $code = mysql_result($result1,$i,"barcode") ; $format = mysql_result($result1,$i,"format") ; $l_cat = mysql_result($result1,$i,"labelcat") ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "
" ; echo "Title:" ; $t_alt = ereg_replace("\\\'","'",rawurldecode($title)); echo $t_alt."" ; $n_alt=rawurldecode($name); $link = "" ; $tag = "vspace=4 hspace=4 border=1" ; $pic = "$catno" ; $alt = "Artwork of $n_alt - $t_alt" ; if(picture($dir_cover,$pic,$alt,$link,$tag)) { echo $image ; } echo "
" ; echo "Format:" ; echo $format."
" ; echo "Release Date:" ; echo $release."
" ; echo "Label:" ; echo $l_name."
" ; echo "Order No.:" ; echo $code."
" ; echo "Cat.-No.:" ; echo $l_cat."
" ; echo "Tracklist:"; $query = "SELECT * FROM promo_tracks WHERE catno='$catno' ORDER BY trackno" ; $result = mysql_query($query) ; $num = mysql_numrows($result) ; $i=0; echo "" ; while($i<$num) { $no = mysql_result($result,$i,"trackno") ; $song = mysql_result($result,$i,"song") ; $length = mysql_result($result,$i,"length") ; $audio = mysql_result($result,$i,"audio") ; $no_url = rawurlencode($no) ; echo "" ; echo "" ; echo "" ; } else { echo "".$song."" ; } echo "" ; echo "" ; $i++; } echo "
" ; echo "".$no.". " ; if($audio==-1) { echo "".$song."" ; echo "".$length."
" ; echo "
" ; echo "
" ; } /** LABEL INFOS **/ if($select=="label") { $query = "SELECT * FROM promo_label WHERE label=$label" ; $result = mysql_query($query) ; $num = mysql_numrows($result) ; $i=0; $l_name = mysql_result($result,$i,"name") ; $address = ereg_replace("\n","
",mysql_result($result,$i,"address")) ; $phone = mysql_result($result,$i,"phone") ; $fax = mysql_result($result,$i,"fax") ; $web = mysql_result($result,$i,"web") ; $email = mysql_result($result,$i,"email") ; echo "" ; echo "" ; echo "" ; echo "" ; echo "
" ; $link = "" ; $tag = "" ; $pic = "label_".$label ; $alt = "$l_name" ; $dir = "images" ; if(picture($dir,$pic,$alt,$link,$tag)) { echo $image ; } echo "

$address

" ; if($phone!="") { echo "

phone ".$phone."
" ; } else { echo "

"; } if($fax!="") { echo "fax ".$fax."

" ; } else { echo "

" ; } if($web!="") { echo "web ".$web."
" ; } if($email!="") { echo "email ".$email."" ; } echo "

" ; echo "
" ; } /** DOWNLOADS **/ if($select=="download") { echo "" ; echo ""; echo ""; echo "" ; echo "" ; echo "" ; echo "" ; $i=1 ; $file = $catno."_$i.jpg" ; $exist = is_there($root,$dir_photo,$file) ; while ($exist==1) { echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; $i++; } echo "" ; echo "" ; echo "
"; echo "All images are JPGs/JEPGs in 300 dpi Hi-Resolution. Move your mouse over an image to see file size. " ; echo "Click on the right mouse button and choose \"Save link as\" for download." ; echo "
" ; $file = $catno."_hi.jpg" ; $exist = is_there($root,$dir_cover,$file) ; if ($exist==1) { $link = $dir_cover."/".$catno."_hi.jpg" ; $c_size = number_format((filesize("".$dir_cover."/".$catno."_hi.jpg")/1000),0); $c_size = "(".$c_size." KB)" ; } else { $link = "" ; $c_size = "not available" ; } $tag = "border=0" ; $pic = $catno."_lo" ; $alt = "Artwork ".$c_size ; if(picture($dir_cover,$pic,$alt,$link,$tag)) { echo $image ; } echo " " ; $file = $artist.".jpg" ; $exist = is_there($root,$dir_name,$file) ; if ($exist==1) { $n_size = number_format((filesize("".$dir_name."/".$artist.".jpg")/1000),0); $n_size = "(".$n_size." KB)" ; $link = $dir_name."/".$artist.".jpg" ; $tag = "border=0" ; $pic = $artist."_lo" ; $alt = "Bandlogo $n_size" ; if(picture($dir_name,$pic,$alt,$link,$tag)) { echo $image; } } else { echo " " ; } echo "
" ; $i=$i; $file = $catno."_$i.jpg" ; $exist = is_there($root,$dir_photo,$file) ; if($exist==1) { $p_size = number_format((filesize("".$dir_photo."/".$catno."_$i.jpg")/1000),0); $p_size = "(".$p_size." KB)" ; $link = $dir_photo."/".$file."" ; $tag = "border=0" ; $pic = $catno."_".$i."_lo" ; $alt = "Photo $i $p_size" ; if(picture($dir_photo,$pic,$alt,$link,$tag)) { echo $image ; } } else { echo " " ; } echo "" ; $i++; $file = $catno."_$i.jpg" ; $exist = is_there($root,$dir_photo,$file) ; if($exist==1) { $p_size = number_format((filesize("".$dir_photo."/".$catno."_$i.jpg")/1000),0); $p_size = "(".$p_size." KB)" ; $link = $dir_photo."/".$file."" ; $tag = "border=0" ; $pic = $catno."_".$i."_lo" ; $alt = "Photo $i $p_size" ; if(picture($dir_photo,$pic,$alt,$link,$tag)) { echo $image ; } } else { echo " " ; } echo "" ; $i++; $file = $catno."_$i.jpg" ; $exist = is_there($root,$dir_photo,$file) ; if($exist==1) { $p_size = number_format((filesize("".$dir_photo."/".$catno."_$i.jpg")/1000),0); $p_size = "(".$p_size." KB)" ; $link = $dir_photo."/".$file."" ; $tag = "border=0" ; $pic = $catno."_".$i."_lo" ; $alt = "Photo $i $p_size" ; if(picture($dir_photo,$pic,$alt,$link,$tag)) { echo $image ; } } else { echo " " ; } echo "
" ; } /** REAL AUDIO **/ if($select=="audio") { echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "
" ; echo "

" ; echo "You need the latest Real Audio Player. Otherwise you're not able to listen to this song. For more details read our help page." ; echo "

" ; $query = "SELECT * FROM promo_tracks WHERE catno='$catno' AND audio=\"-1\" ORDER BY trackno" ; $result = mysql_query($query) ; $num = mysql_numrows($result) ; $i=0; echo "" ; while($i<$num) { $no = mysql_result($result,$i,"trackno") ; $song = mysql_result($result,$i,"song") ; $length = mysql_result($result,$i,"length") ; $audio = mysql_result($result,$i,"audio") ; $no_url = rawurlencode($no) ; echo "" ; $check = file_exists("media/".$catno."_".$no.".ram") ; if($check==1) { echo "" ; echo "" ; } echo "" ; $i++; } echo "
" ; echo "".$song."" ; echo " ".$length."" ; echo "
" ; echo "

" ; echo "\"Click
" ; } ?>