";
echo "| | ";
echo " ";
if ($row[pic_nice]>"") echo " ')\" onmouseout=\"UnTip()\">";
echo "![\"$row[ReleaseName]\"](\"showpic.php?id=".$row["id_r"]."\") ";
if ($row[pic_nice]>"") echo "";
echo " ";
echo "";
echo "";
echo " | ";
echo "";
echo "";
echo $row["ReleaseName"];
echo "";
echo " | ";
echo " ";
echo "";
echo " | ";
echo "";
echo "";
echo $row["ReleaseInfo"];
echo "";
echo " | ";
echo " ";
echo "| | ";
echo "";
echo " | ";
echo "";
echo "";
echo "Releasedate: ".$row["ReleaseDate"];
echo "";
echo " | ";
echo " ";
echo "";
echo " | ";
echo "";
echo "";
$tracks=mysql_fetch_array(mysql_query("select count(track) as tz from release_daten where id_r = '$row[id_r]'" ));
if ($row["Compilation"] == 0) {
echo "Tracks: ".$tracks["tz"];
}
echo "";
echo " | ";
echo " ";
echo "";
echo " | ";
echo "";
echo "";
$geserg=mysql_query("select Laenge from tracks t, release_daten r where r.kuenstler='miab' and r.id_r='$row[id_r]' and r.kuenstler = t.kuenstler and r.id_d = t.id_d");
$gesamt = 0;
while ($res = mysql_fetch_array($geserg)) {
$gesamt = $gesamt + TimeToSec($res["Laenge"]);
}
if ($gesamt > 0 ) {
$gesamt = SecToTime($gesamt);
if ($row["Compilation"] == 0) {
echo "Total play time: ".$gesamt;
}
}
echo "";
echo " | ";
echo " ";
echo " ";
echo " | ";
echo " | ";
echo "";
echo "";
echo "";
echo " | ";
echo "";
echo "";
echo "Onlinestores | ";
$onlinestores=mysql_query("select id_r, region,link_nr,LinkName,link from release_links rl where rl.id_r='$row[id_r]' order by rl.link_nr");
while ($rowliste=mysql_fetch_array($onlinestores))
{
echo " ";
echo "| ";
if ($row["Compilation"] == 0 ) {
if(isset($rowliste["region"])) echo $rowliste["region"];
echo " | ";
}
echo "";
echo "";
echo " "."".$rowliste["LinkName"]."";
echo " | ";
echo "";
echo "";
$checklyrics=mysql_fetch_array(mysql_query("select t.Lyrics,t.DemoLink,d.Nr from tracks t, release_daten d where t.id_d='$rowliste[id_d]' and d.id_d = t.id_d and d.id_r='$row[id_r]' "));
if ($checklyrics["Lyrics"] > "") {
echo " |Lyrics";
}
else if ($checklyrics["Lyrics"] == "" and $row["Compilation"] == 0 ) {
$checklyrics=mysql_fetch_array(mysql_query("select t.Lyrics,t.DemoLink,d.Nr from tracks t,tracks tt, release_daten d WHERE d.id_r = '$row[id_r]' and t.id_d = tt.RemixVon and tt.id_d = '$rowliste[id_d]' "));
if ($checklyrics["Lyrics"] > "") {
echo " |Lyrics";
}
}
echo " | ";
echo "";
echo "";
if ($checklyrics["DemoLink"] > "" and $checklyrics["Nr"] != 0) {
echo " |Demo";
}
else if ($checklyrics["DemoLink"] > "" and $checklyrics["Nr"] == 0) {
// echo " |Tracklist";
echo " |Tracklist";
}
echo " | ";
}
echo " ";
echo " | ";
echo "
";
echo "