4){$offset=1;} if($varhour > 8){$offset=0;} if($varhour > 12){$offset=2;} $offset=0; $sql="SELECT `se_polls`.`poll_id`, `se_polls`.`poll_user_id`, `se_polls`.`poll_datecreated`, `se_polls`.`poll_title`, `se_polls`.`poll_desc`, `se_polls`.`poll_options`, `se_polls`.`poll_answers`, `se_polls`.`poll_voted`, `se_polls`.`poll_privacy`, `se_polls`.`poll_comments`, `se_polls`.`poll_closed`, `se_polls`.`poll_totalvotes`, `se_polls`.`poll_views`, `se_polls`.`poll_totalcomments`, `se_users`.`user_id`, `se_users`.`user_username`, `se_users`.`user_displayname`, `se_users`.`user_blocklist` FROM `se_polls` Right Outer Join `se_users` ON `se_users`.`user_id` = `se_polls`.`poll_user_id` WHERE `se_polls`.`poll_datecreated` > UNIX_TIMESTAMP()-(60*60*94) AND `se_polls`.`poll_totalvotes` > 0 AND `se_users`.`user_wh_privacy` = 'N' AND `se_users`.`user_enabled` = 1 ORDER BY `se_polls`.`poll_totalvotes` DESC LIMIT 6 OFFSET ".$offset; $result=$database->database_query($sql) or $em.=$database->database_error(); while ($row = $database->database_fetch_assoc($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; 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;} $ptitle=strip_tags(html_entity_decode($row["poll_title"])); $htmlfreecontent = strip_tags(html_entity_decode($row["poll_desc"])); $htmlfreecontent=utf8_encode(html_entity_decode($htmlfreecontent)); $psdesc = myTruncate($htmlfreecontent, 200); $tv=$row["poll_totalvotes"]; $pa = unserialize($row['poll_answers']); $pv = unserialize($row['poll_options']); $puser=$row["user_username"]; $pid=$row["poll_id"]; $mostvotes=0; $mv=-1; for ($i = 0; $i < count($pa); ++$i) { if($pa[$i] > $mostvotes) { $mv = $i; $mostvotes=$pa[$i]; } } break; } $ma=$pa[$mv]; $maq=$pv[$mv]; $arr = array ('error'=>$em,'ptitle'=>$ptitle, 'pdesc'=>$psdesc, 'ma'=> $ma, 'maq' => $maq, 'tv' => $tv, 'puser' => $puser, 'pid' => $pid); echo json_encode($arr); exit(); ?>