Browse

Artist : ".$val.""; ?>

Track : ".$val.""; ?>

User : ".$val.""; ?>

0){ $artistsQuery.=" artist IN ("; $count=0; while($artist = mysqli_fetch_array($artists)){ if($count>0) $artistsQuery.=", "; $artistsQuery.=$artist['id']; $count++; } $artistsQuery.=")"; }else{ $aristsQuery = "-1"; } } $disctypesQuery=""; if(isset($_GET['disctype']) && $_GET['disctype']!=""){ $disctypesQuery = " posttype = '".$_GET['disctype']."' "; } $tracksQuery=""; if(isset($_GET['track']) && $_GET['track']!=""){ $track = mysqli_escape_string($dbh,$_GET['track']); $tracks = mysqli_query($dbh,"SELECT id FROM track WHERE title LIKE '%".$track."%' OR title LIKE '".$track."%' OR title LIKE '%".$track."'"); if(mysqli_num_rows($tracks) > 0){ $tracksQuery.=" track IN ("; $count=0; while($track = mysqli_fetch_array($tracks)){ if($count>0) $tracksQuery.=", "; $tracksQuery.=$track['id']; $count++; } $tracksQuery.=")"; }else{ $tracksQuery = "-1"; } } $usersQuery=""; if(isset($_GET['user']) && $_GET['user']!=""){ $user = mysqli_escape_string($dbh,$_GET['user']); $users = mysqli_query($dbh,"SELECT id FROM user WHERE name LIKE '%".$user."%' OR name LIKE '".$user."%' OR name LIKE '%".$user."' OR username LIKE '%".$user."%' OR username LIKE '".$user."%' OR username LIKE '%".$user."'"); if(mysqli_num_rows($users) > 0){ $usersQuery.=" user IN ("; $count=0; while($user = mysqli_fetch_array($users)){ if($count>0) $usersQuery.=", "; $usersQuery.=$user['id']; $count++; } $usersQuery.=")"; }else{ $usersQuery = "-1"; } } $start=0; $perpage=10; if(isset($_GET['page']) && $_GET['page']>0){ $start=($_GET['page']-1)*$perpage; } $end=$start+$perpage; if($artistsQuery == '-1' || $tracksQuery == '-1' || $usersQuery == '-1'){ $timelineQ=null; }else{ $timelineQ="SELECT posts.id as postid, null as likeid, postdate AS posted FROM posts WHERE live='1'"; if($artistsQuery!="") $timelineQ.=" AND ".$artistsQuery; if($tracksQuery!="") $timelineQ.=" AND ".$tracksQuery; if($usersQuery!="") $timelineQ.=" AND ".$usersQuery; if($disctypesQuery!="") $timelineQ.=" AND ".$disctypesQuery; $timelineQ.=" ORDER BY posted DESC LIMIT ".$start.",".($end+1).""; //go to end +1 for paging check, save running more queries } if($timelineQ!==null) $timeline=mysqli_query($dbh,$timelineQ); if($timelineQ == null || mysqli_num_rows($timeline)==0){ echo("

No tracks to display.

"); }else{ $timelinePost=new post(); $postUser=new user(); echo("
"); //query string $querystring=""; if(isset($_GET['artist'])){ if($querystring=="") $querystring.="?artist=".$_GET['artist']; else $querystring.="&artist=".$_GET['artist']; } if(isset($_GET['track'])){ if($querystring=="") $querystring.="?track=".$_GET['track']; else $querystring.="&track=".$_GET['track']; } if(isset($_GET['user'])){ if($querystring=="") $querystring.="?user=".$_GET['user']; else $querystring.="&user=".$_GET['user']; } //check for total posts if($nextpage==1){ if(isset($_GET['page'])){ if($querystring=="") $querystring.="?page=".($_GET['page']+1); else $querystring.="&page=".($_GET['page']+1); }else{ if($querystring=="") $querystring.="?page=2"; else $querystring.="&page=2"; } echo("View more"); } if(isset($_GET['page']) && $_GET['page']>1){ if($querystring=="") $querystring.="?page=".($_GET['page']-1); else $querystring.="&page=".($_GET['page']-1); echo("Previous"); } echo("
"); } ?>