Timeline

properties['id']."') UNION ALL (SELECT null as postid, likes.id as likeid, likes.time as postdate FROM likes, posts WHERE posts.user='".$viewUser->properties['id']."' AND posts.id=likes.postid) ORDER BY posted DESC LIMIT 0,20"; $timeline=mysqli_query($dbh,$timelineQ); if(mysqli_num_rows($timeline)==0){ echo("

This user hasn't shared any tracks yet.

"); }else{ $timelinePost=new post(); $postUser=new user(); echo("

"); if($timelineItem['postid']!=null){ echo(""); $timelinePost->fetch($timelineItem['postid']); if($timelinePost->properties['user']!=$user->properties['id']){ $postUser->fetch($timelinePost->properties['user']); echo("
".$postUser->properties['username']." shared a track : "); }elseif($timelinePost->properties['live']==0) echo("
Saved draft : "); else echo("
"); if($timelinePost->properties['image']!=""){ echo(""); } echo($timelinePost->properties['artistname']." : ".$timelinePost->properties['tracktitle']); if($timelinePost->properties['heading']!="") echo(" - ".$timelinePost->properties['heading'].""); echo("
".date("d/m/Y H:i",$timelinePost->properties['postdate'])); echo("
"); echo(""); }elseif($timelineItem['likeid']!=null){ $likeQ=mysqli_query($dbh,"SELECT user.username, likes.* FROM likes, user WHERE user.id=likes.userid AND likes.id='".$timelineItem['likeid']."'"); $timelineLike=mysqli_fetch_array($likeQ); echo("".$timelineLike['username']." liked one of ".$viewUser->properties['username']." posts."); } echo("

"); } ?>