execRequete("SELECT * FROM texts WHERE id='39'"); $texte=$bd->ligneSuivante($texte); if (date("m")>10) $datlimit=date("Y")."-".(date("m")-1)."-".date("d"); else $datlimit=date("Y")."-0".(date("m")-1)."-".date("d"); ?>
execRequete("SELECT * FROM music, musiccat, artists WHERE ( idartist=id OR (idartist='0' AND id='1')) AND dwnld='y' AND musiccat = musiccatid ORDER BY musiccatrank, musicdat DESC"); //verander dwnld naar 'y' in database 'music' wanneer capaciteit ok is while($list=$bd->ligneSuivante($listmusic)) { if ($list['musiccat'] != $prevcat) echo "

".$list['musiccattitle']."

"; echo "

"; if ($list['musicdat'] > $datlimit) echo "LATEST "; echo "".$list['musicname'].""; if ($list['idartist']=='0') echo " (".$list['musicdat'].")-(".$list['otherartist'].")-(".$list['mb']." MB)"; else echo " (".$list['musicdat'].")-(".$list['artistname'].")-(".$list['mb']." MB)"; $prevcat=$list['musiccat']; } }*/ echo "

LOS NINOS mixes

"; $listmusic=$bd->execRequete("SELECT * FROM music WHERE visible_losninos='y' AND visible_archive = 'n' ORDER BY musicid DESC"); while($list=$bd->ligneSuivante($listmusic)) { echo "

"; if ($list['musicdat'] > $datlimit) { echo "NEW
"; } echo "".$list['musicartist']." - ".$list['musicname'].""; echo "

Download"; if ($list['musicmb']!=0) { echo " (".$list['musicmb']."MB)"; } echo "

Online since: ".$list['musicdat']; echo "
Duration: ".$list['duration']; } echo "

FINGERSPITZENGEFUHL mixes

"; $listmusic=$bd->execRequete("SELECT * FROM music WHERE visible_finger = 'y' AND visible_archive = 'n' ORDER BY musicid DESC"); while($list=$bd->ligneSuivante($listmusic)) { echo "

"; if ($list['musicdat'] > $datlimit) { echo "NEW
"; } echo "".$list['musicartist']." - ".$list['musicname'].""; echo "

Download"; if ($list['musicmb']!=0) { echo " (".$list['musicmb']."MB)"; } echo "

Online since: ".$list['musicdat']; echo "
Duration: ".$list['duration']; } echo "

VICUNA mixes

"; $listmusic=$bd->execRequete("SELECT * FROM music WHERE visible_vicuna = 'y' AND visible_archive = 'n' ORDER BY musicid DESC"); while($list=$bd->ligneSuivante($listmusic)) { echo "

"; if ($list['musicdat'] > $datlimit) { echo "NEW
"; } echo "".$list['musicartist']." - ".$list['musicname'].""; echo "

Download"; if ($list['musicmb']!=0) { echo " (".$list['musicmb']."MB)"; } echo "

Online since: ".$list['musicdat']; echo "
Duration: ".$list['duration']; } echo "

ARCHIVE mixes

"; $listmusic=$bd->execRequete("SELECT * FROM music WHERE visible_archive = 'y' AND visible_losninos = 'n' AND visible_finger = 'n' AND visible_vicuna = 'n' ORDER BY musicid DESC"); while($list=$bd->ligneSuivante($listmusic)) { echo "

"; /* if ($list['musicdat'] > $datlimit) { echo "NEW
"; } */ echo "".$list['musicartist']." - ".$list['musicname'].""; echo "

Download"; if ($list['musicmb']!=0) { echo " (".$list['musicmb']."MB)"; } echo "

Online since: ".$list['musicdat']; echo "
Duration: ".$list['duration']; } } ?>

Mixes/tracks now online"; $liste=$bd->execRequete("SELECT SUM(musicmb) as totalmb FROM music WHERE (visible_losninos='y' OR visible_finger = 'y' OR visible_vicuna = 'y' OR visible_archive ='y')"); while ($listd=$bd->ligneSuivante($liste)) { echo "

Total amount online: ".$listd['totalmb']." Mb

"; } $liste=$bd->execRequete("SELECT musicartist, musicname, musicmb, musicdat FROM music WHERE (visible_losninos='y' OR visible_finger = 'y' OR visible_vicuna = 'y' OR visible_archive ='y') ORDER BY musicdat DESC"); while ($list=$bd->ligneSuivante($liste)) { echo "

"; if ($list['musicdat'] > $datlimit) { echo "NEW  "; } echo $list['musicartist']."
     ".$list['musicname']." (".$list['musicmb']."Mb)

"; } ?>