/**
*
* Displays a poll
*
*/
public function get_poll($topicID = 0, $showLink = false, $template = 'prosilver')
{
global $db, $user, $auth, $config, $phpEx, $wpUnited, $phpbbForum;
static $pollHasGenerated = false;
$fStateChanged = $phpbbForum->foreground();
if (!$pollHasGenerated) {
$user->add_lang('viewtopic');
$pollHasGenerated = true;
}
$display = false;
$ajax = false;
$inboundVote = array();
// Is this an AJAX request?
if ($topicID == 0) {
$topicID = (int) request_var('pollid', 0);
$template = (string) request_var('polltemplate', 'prosilver');
$inboundVote = request_var('vote_id', array('' => 0));
$display = (int) request_var('display', 0) == 1;
$ajax = (int) request_var('ajax', 0) == 1;
$showLink = (int) request_var('showlink', 0) == 1;
}
if (!$topicID) {
return '';
}
// Or was this form submitted without JS? If so, which poll was it for? (Unlike in phpBB, there could be more than one)
if (!$ajax) {
// submitted:
if (isset($_POST['update']) && isset($_POST['vote_id'])) {
$pollID = (int) request_var('pollid', 0);
if ($pollID == $topicID) {
$inboundVote = request_var('vote_id', array('' => 0));
// the same poll block could be on the page multiple times. We only want to register the vote once.
unset($_POST['update']);
unset($_POST['vote_id']);
}
}
// view results link:
if (isset($_GET['wpupolldisp'])) {
$pollID = (int) request_var('pollid', 0);
if ($pollID == $topicID) {
$display = 1;
}
}
}
if (trim($template) == '') {
$template = 'prosilver';
}
$currURL = wpu_get_curr_page_link();
$pollMarkup = '';
$actionMsg = '';
$sql = '
SELECT t.topic_id, t.topic_title, t.topic_status, t.poll_title, t.poll_start, t.poll_length,
t.poll_max_options, t.poll_last_vote, t.poll_vote_change,
p.bbcode_bitfield, p.bbcode_uid,
t.forum_id, u.user_id, f.forum_name, f.forum_status, u.username, u.user_colour, u.user_type
FROM ' . TOPICS_TABLE . ' AS t, ' . USERS_TABLE . ' AS u, ' . FORUMS_TABLE . ' AS f, ' . POSTS_TABLE . ' AS p
WHERE t.topic_poster = u.user_id
AND t.forum_id = f.forum_id
AND t.topic_id = ' . (int) $topicID . '
AND p.post_id = t.topic_first_post_id';
if (!($result = $db->sql_query($sql))) {
$phpbbForum->restore_state($fStateChanged);
wp_die(__('Could not access the database.', 'wp-united'));
}
$topicData = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
if (!$topicData['poll_start'] || !$auth->acl_get('f_read', $topicData['forum_id'])) {
$phpbbForum->restore_state($fStateChanged);
return $pollMarkup;
}
$pollOptions = array();
$sql = '
SELECT *
FROM ' . POLL_OPTIONS_TABLE . '
WHERE topic_id = ' . (int) $topicID;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$pollOptions[] = $row;
}
$db->sql_freeresult($result);
$currVotedID = array();
if ($user->data['is_registered']) {
$sql = '
SELECT poll_option_id
FROM ' . POLL_VOTES_TABLE . '
WHERE topic_id = ' . (int) $topicID . '
AND vote_user_id = ' . $user->data['user_id'];
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$currVotedID[] = $row['poll_option_id'];
}
$db->sql_freeresult($result);
} else {
// Cookie based guest tracking ...
if (isset($_COOKIE[$config['cookie_name'] . '_poll_' . $topicID])) {
$currVotedID = explode(',', $_COOKIE[$config['cookie_name'] . '_poll_' . $topicID]);
$currVotedID = array_map('intval', $currVotedID);
}
}
// Can not vote at all if no vote permission
$userCanVote = $auth->acl_get('f_vote', $topicData['forum_id']) && ($topicData['poll_length'] != 0 && $topicData['poll_start'] + $topicData['poll_length'] > time() || $topicData['poll_length'] == 0) && $topicData['topic_status'] != ITEM_LOCKED && $topicData['forum_status'] != ITEM_LOCKED && (!sizeof($currVotedID) || $auth->acl_get('f_votechg', $topicData['forum_id']) && $topicData['poll_vote_change']) ? true : false;
$displayResults = !$userCanVote || $userCanVote && sizeof($currVotedID) || $display ? true : false;
if (sizeof($inboundVote) && $userCanVote) {
// ******** register vote here ********
if (sizeof($inboundVote) > $topicData['poll_max_options'] || in_array(VOTE_CONVERTED, $currVotedID)) {
if (!sizeof($inboundVote)) {
$actionMsg = $user->lang['NO_VOTE_OPTION'];
} else {
if (sizeof($inboundVote) > $topicData['poll_max_options']) {
$actionMsg = $user->lang['TOO_MANY_VOTE_OPTIONS'];
} else {
if (in_array(VOTE_CONVERTED, $currVotedID)) {
$actionMsg = $user->lang['VOTE_CONVERTED'];
}
}
}
} else {
foreach ($inboundVote as $option) {
if (in_array($option, $currVotedID)) {
continue;
}
$sql = '
UPDATE ' . POLL_OPTIONS_TABLE . '
SET poll_option_total = poll_option_total + 1
WHERE poll_option_id = ' . (int) $option . '
AND topic_id = ' . (int) $topicID;
$db->sql_query($sql);
if ($user->data['is_registered']) {
$sql_ary = array('topic_id' => (int) $topicID, 'poll_option_id' => (int) $option, 'vote_user_id' => (int) $user->data['user_id'], 'vote_user_ip' => (string) $user->ip);
$sql = 'INSERT INTO ' . POLL_VOTES_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
$db->sql_query($sql);
}
}
foreach ($currVotedID as $option) {
if (!in_array($option, $inboundVote)) {
$sql = '
UPDATE ' . POLL_OPTIONS_TABLE . '
SET poll_option_total = poll_option_total - 1
WHERE poll_option_id = ' . (int) $option . '
AND topic_id = ' . (int) $topicID;
$db->sql_query($sql);
if ($user->data['is_registered']) {
$sql = '
DELETE FROM ' . POLL_VOTES_TABLE . '
WHERE topic_id = ' . (int) $topicID . '
AND poll_option_id = ' . (int) $option . '
AND vote_user_id = ' . (int) $user->data['user_id'];
$db->sql_query($sql);
}
}
}
if ($user->data['user_id'] == ANONYMOUS && !$user->data['is_bot']) {
$user->set_cookie('poll_' . $topicID, implode(',', $inboundVote), time() + 31536000);
}
$sql = '
UPDATE ' . TOPICS_TABLE . '
SET poll_last_vote = ' . time() . "\n\t\t\t\t\tWHERE topic_id = {$topicID}";
$db->sql_query($sql);
$actionMsg = $user->lang['VOTE_SUBMITTED'] . '<br />';
// Reload vote state:
$pollOptions = array();
$sql = '
SELECT *
FROM ' . POLL_OPTIONS_TABLE . '
WHERE topic_id = ' . (int) $topicID;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$pollOptions[] = $row;
}
$db->sql_freeresult($result);
$currVotedID = $inboundVote;
$userCanVote = $auth->acl_get('f_votechg', $topicData['forum_id']) && $topicData['poll_vote_change'];
$displayResults = true;
}
// ***** end of vote registration ******
}
$pollTotal = 0;
foreach ($pollOptions as $pollOption) {
$pollTotal += $pollOption['poll_option_total'];
}
$pollBBCode = false;
if ($topicData['bbcode_bitfield']) {
require_once $wpUnited->get_setting('phpbb_path') . 'includes/functions_posting.' . $phpEx;
require_once $wpUnited->get_setting('phpbb_path') . 'includes/bbcode.' . $phpEx;
$pollBBCode = new bbcode();
}
for ($i = 0, $size = sizeof($pollOptions); $i < $size; $i++) {
$pollOptions[$i]['poll_option_text'] = censor_text($pollOptions[$i]['poll_option_text']);
if ($pollBBCode !== false) {
$pollBBCode->bbcode_second_pass($pollOptions[$i]['poll_option_text'], $topicData['bbcode_uid'], $topicData['bbcode_bitfield']);
}
$pollOptions[$i]['poll_option_text'] = bbcode_nl2br($pollOptions[$i]['poll_option_text']);
$pollOptions[$i]['poll_option_text'] = $phpbbForum->parse_phpbb_text_for_smilies($pollOptions[$i]['poll_option_text']);
}
$topicData['poll_title'] = $phpbbForum->censor($topicData['poll_title']);
if ($pollBBCode !== false) {
$pollBBCode->bbcode_second_pass($topicData['poll_title'], $topicData['bbcode_uid'], $topicData['bbcode_bitfield']);
}
$topicData['poll_title'] = bbcode_nl2br($topicData['poll_title']);
$topicData['poll_title'] = $phpbbForum->parse_phpbb_text_for_smilies($topicData['poll_title']);
unset($pollBBCode);
$pollEnd = $topicData['poll_length'] + $topicData['poll_start'];
$pollLength = $topicData['poll_length'] ? sprintf($user->lang[$pollEnd > time() ? 'POLL_RUN_TILL' : 'POLL_ENDED_AT'], $user->format_date($pollEnd)) : '';
$topicLink = $phpbbForum->seo ? "topic{$topicID}.html" : "viewtopic.{$phpEx}?t={$topicID}";
$pTemplate = new template();
$pTemplate->set_custom_template($wpUnited->get_plugin_path() . 'extras/quickpoll/templates/', 'wpupoll');
$pTemplate->set_filenames(array('poll' => "{$template}.html"));
$pTemplate->assign_vars(array('POLL_QUESTION' => $topicData['poll_title'], 'TOTAL_VOTES' => $pollTotal, 'POLL_LEFT_CAP_IMG' => str_replace($wpUnited->get_setting('phpbb_path'), $phpbbForum->get_board_url(), $user->img('poll_left')), 'POLL_RIGHT_CAP_IMG' => str_replace($wpUnited->get_setting('phpbb_path'), $phpbbForum->get_board_url(), $user->img('poll_right')), 'POLL_ID' => $topicID, 'L_MAX_VOTES' => $topicData['poll_max_options'] == 1 ? $user->lang['MAX_OPTION_SELECT'] : sprintf($user->lang['MAX_OPTIONS_SELECT'], $topicData['poll_max_options']), 'L_POLL_LENGTH' => $actionMsg . $pollLength, 'POLL_TEMPLATE' => $template, 'S_CAN_VOTE' => $userCanVote, 'S_DISPLAY_RESULTS' => $displayResults, 'S_SHOW_LINK' => $showLink, 'U_TOPIC_LINK' => $phpbbForum->get_board_url() . $topicLink, 'L_TOPIC_LINK' => __('View poll in forum', 'wp-united'), 'S_IS_MULTI_CHOICE' => $topicData['poll_max_options'] > 1 ? true : false, 'S_POLL_ACTION' => $currURL, 'U_VIEW_RESULTS' => !strstr($currURL, '?') ? $currURL . '?wpupolldisp=1' : $currURL . '&wpupolldisp=1'));
foreach ($pollOptions as $pollOption) {
$optionPct = $pollTotal > 0 ? $pollOption['poll_option_total'] / $pollTotal : 0;
$optionPctTxt = sprintf("%.1d%%", round($optionPct * 100));
$pTemplate->assign_block_vars('poll_option', array('POLL_OPTION_ID' => $pollOption['poll_option_id'], 'POLL_OPTION_CAPTION' => $pollOption['poll_option_text'], 'POLL_OPTION_RESULT' => $pollOption['poll_option_total'], 'POLL_OPTION_PERCENT' => $optionPctTxt, 'POLL_OPTION_PCT' => round($optionPct * 100), 'POLL_OPTION_IMG' => str_replace($wpUnited->get_setting('phpbb_path'), $phpbbForum->get_board_url(), $user->img('poll_center', $optionPctTxt, round($optionPct * 250))), 'POLL_OPTION_VOTED' => in_array($pollOption['poll_option_id'], $currVotedID) ? true : false));
}
ob_start();
$pTemplate->display('poll');
$pollMarkup = ob_get_contents();
unset($pTemplate);
ob_end_clean();
$phpbbForum->restore_state($fStateChanged);
if ($ajax) {
wpu_ajax_header();
echo '<wpupoll>';
echo '<newnonce>' . wp_create_nonce('wpu-poll-submit') . '</newnonce>';
echo '<pollid>' . $topicID . '</pollid>';
echo '<markup><![CDATA[' . base64_encode($pollMarkup) . ']]></markup>';
echo '</wpupoll>';
exit;
}
return $pollMarkup;
}
function wpu_reload_page_if_no_post()
{
global $phpbbForum;
// don't reloads if something has been POSTed to phpBB or WordPress.
$fStateChanged = $phpbbForum->foreground();
$hasPostVars = sizeof($_POST);
$phpbbForum->restore_state($fStateChanged);
if ($hasPostVars || sizeof($_POST)) {
return false;
}
$currPage = wpu_get_curr_page_link();
// prevent infinite reloads
if (stristr($currPage, 'wpureload=1') !== false) {
return false;
}
$currPage .= stristr($currPage, '?') !== false ? '&wpureload=1' : '?wpureload=1';
// OK, let's do it... Reload one way or another.
if (!headers_sent()) {
header('Location: ' . $currPage, true, 302);
exit;
} else {
echo '<script type="text/javascript">';
echo 'window.location.href="' . $currPage . '";';
echo '</script>';
echo '<noscript>';
echo '<meta http-equiv="refresh" content="0;url=' . $currPage . '" />';
echo '</noscript>';
exit;
}
}
