include ("../includedb2.php"); $q = "select count(*) as t from soundtags"; $res = mysql_query($q); $row = mysql_fetch_assoc($res); $t = $row['t']; $q = "select count(*) as c from sounds"; $res = mysql_query($q); $row = mysql_fetch_assoc($res); $s = $row['c']; if (isset($_GET['soundoffset'])) { $soundoffset = $_GET['soundoffset']; } else { $soundoffset = 0; } if (isset($_GET['random'])) { $offset = floor(rand(0,($s-1) )); $q = "select * from sounds limit 1 offset ".$offset; $res = mysql_query($q); $row = mysql_fetch_assoc($res); $uri = $row['uri']; $sound = $row['id']; $played = $row['played']; $q = "select * from soundtagged where average >= 50 and soundid = ".$sound." order by average,moment desc limit 1"; $res = mysql_query($q); if ($row = mysql_fetch_assoc($res) ) { $tagid = $row['tagid']; } else { $tagid = floor(rand(1,$t)); } $q = "select count(*) as sc from soundtagged where average >= 50 and tagid = ".$tagid; $res = mysql_query($q); $row = mysql_fetch_assoc($res); $sc = $row['sc']; } else if (isset($_GET['tagid'])) { $tagid = $_GET['tagid']; $q = "select count(*) as sc from soundtagged where average >= 50 and tagid = ".$tagid; $res = mysql_query($q); $row = mysql_fetch_assoc($res); $sc = $row['sc']; if (isset($_GET['soundoffset'])) { // reeds gezet: $soundoffset = $_GET['soundoffset']; $soundoffset++; if ($soundoffset > ($sc-1)) { $soundoffset = 0; } } else { $soundoffset = 0; } if ($sc > 0) { $q = "select * from soundtagged where average >= 50 and tagid = ".$tagid." order by average desc, moment desc limit 1 offset ".$soundoffset; // echo $q; $res = mysql_query($q); $row = mysql_fetch_assoc($res); $sound = $row['soundid']; $q = "select * from sounds where id =".$sound; $res = mysql_query($q); $row = mysql_fetch_assoc($res); } else { // niks gevonden, toch random zoeken: $offset = floor(rand(0,($s-1) )); $q = "select * from sounds limit 1 offset ".$offset; $res = mysql_query($q); $row = mysql_fetch_assoc($res); $sound = $row['id']; } $desc = $row['description']; $played = $row['played']; $uri = $row['uri']; } $played++; $q = "update sounds set played = ".$played." where id = ".$sound; mysql_query($q); ?>