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_array($result)) { $blocklist = explode(",", $row["user_blocklist"]); if(!isset($_GET["uid"])){$_GET["uid"]=-1;} $key = array_search($_GET["uid"], $blocklist);//array search will only evaluate to false or not false; $_GET["ubl"]=""; 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"; } $buname=$row["user_username"]; $bid=$row["blogentry_id"]; $btitle=$row["blogentry_title"]; //echo $btitle; //$btitle=htmlentities($btitle); //echo $btitle; //$btitle="Ten signs you\’re totally addicted to masturbation"; $btitle=htmlentities($btitle, ENT_QUOTES, 'UTF-8'); //$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=""; if($btitle==""){$btitle="Read Blog";} $arr = array ('error'=>$em, 'uimg'=>$bimage, 'uname'=>$buname, 'bid'=>$bid, 'btitle'=>$btitle, 'bdesc'=> $bsdesc, 'bviews'=>$bviews, 'bcom' => $bcomments); echo json_encode($arr); ?>