Files
Testing/js/whatshot/get_member_polls.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

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();
?>