70022 AND `se_blogentries`.`blogentry_privacy` = 31 AND `se_users`.`user_wh_privacy` = 'N' AND `se_blogentries`.`blogentry_user_id` <> 70695 AND `se_users`.`user_enabled` = 1 ORDER BY `se_blogentries`.`blogentry_date` DESC, `se_blogentries`.`blogentry_comments` DESC, `se_blogentries`.`blogentry_views` DESC LIMIT 8"; $result=$database->database_query($sql) or $em.= $database->database_error(); //echo error_reporting(); while ($row = $database->database_fetch_assoc($result)) { $blocklist = explode(",", $row["user_blocklist"]); if(!isset($_GET["uid"])){$_GET["uid"]=-1;} if(!isset($_GET["ubl"])){$_GET["ubl"]="";} $key = array_search($_GET["uid"], $blocklist);//array search will only evaluate to false or not false; if($key!==false){continue;} $viewerbl=explode(",", $_GET["ubl"]); $vkey = array_search($row["user_id"], $viewerbl);//array search will only evaluate to false or not false; if($vkey!==false){continue;} $weirdnumber = (((int)($row["blogentry_user_id"]/1000))*1000)+1000; $bimage="/uploads_user/".$weirdnumber."/".$row["blogentry_user_id"]."/".$row["user_photo"]; $chkbimage=$_SERVER["DOCUMENT_ROOT"].$bimage; if(!is_file($chkbimage)) { $bimage="/images/nophoto.png"; } echo $chkbimage; $buname=$row["user_username"]; $bid=$row["blogentry_id"]; $btitle=strip_tags(html_entity_decode($row["blogentry_title"])); $htmlfreecontent = strip_tags(html_entity_decode($row["blogentry_body"])); $htmlfreecontent = str_replace(' ','',$htmlfreecontent); $bsdesc = myTruncate($htmlfreecontent, 70); $bviews=$row["blogentry_views"]; $bcomments=$row["blogentry_totalcomments"]; break; } $bsdesc=""; $arr = array ('error'=>$em, 'uimg'=>$bimage, 'uname'=>$buname, 'bid'=>$bid, 'btitle'=>$btitle, 'bdesc'=> $bsdesc, 'bviews'=>$bviews, 'bcom' => $bcomments); echo json_encode($arr); ?>