92 lines
2.9 KiB
PHP
92 lines
2.9 KiB
PHP
<?php header('Content-type: application/json');
|
|
if ( !defined('PATHTOINCLUDES') ) define('PATHTOINCLUDES', $_SERVER["DOCUMENT_ROOT"] . '/');
|
|
include_once(PATHTOINCLUDES."bebop/regular.php");
|
|
function myTruncate($string, $limit, $break=".", $pad="...")
|
|
{
|
|
// return with no change if string is shorter than $limit
|
|
if(strlen($string) <= $limit) return $string;
|
|
|
|
// is $break present between $limit and the end of the string?
|
|
if(false !== ($breakpoint = strpos($string, $break, $limit))) {
|
|
if($breakpoint < strlen($string) - 1) {
|
|
$string = substr($string, 0, $breakpoint) . $pad;
|
|
}
|
|
}
|
|
|
|
return $string;
|
|
}
|
|
date_default_timezone_set('UTC'); // don't know
|
|
$em="";
|
|
$offset=0;
|
|
$varhour = date('H');
|
|
if($varhour > 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();
|
|
|
|
?>
|