$s = "poll_datecreated DESC";
}
if ($v != "0" && $v != "1") {
$v = 0;
}
// SET WHERE CLAUSE
$where = "CASE\r\n\t WHEN se_polls.poll_user_id='{$user->user_info['user_id']}'\r\n\t THEN TRUE\r\n\t WHEN ((se_polls.poll_privacy & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0)\r\n\t THEN TRUE\r\n\t WHEN ((se_polls.poll_privacy & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0)\r\n\t THEN TRUE\r\n\t WHEN ((se_polls.poll_privacy & @SE_PRIVACY_FRIEND) AND (SELECT TRUE FROM se_friends WHERE friend_user_id1=se_polls.poll_user_id AND friend_user_id2='{$user->user_info['user_id']}' AND friend_status='1' LIMIT 1))\r\n\t THEN TRUE\r\n\t WHEN ((se_polls.poll_privacy & @SE_PRIVACY_SUBNET) AND '{$user->user_exists}'<>0 AND (SELECT TRUE FROM se_users WHERE user_id=se_polls.poll_user_id AND user_subnet_id='{$user->user_info['user_subnet_id']}' LIMIT 1))\r\n\t THEN TRUE\r\n\t WHEN ((se_polls.poll_privacy & @SE_PRIVACY_FRIEND2) AND (SELECT TRUE FROM se_friends AS friends_primary LEFT JOIN se_users ON friends_primary.friend_user_id1=se_users.user_id LEFT JOIN se_friends AS friends_secondary ON friends_primary.friend_user_id2=friends_secondary.friend_user_id1 WHERE friends_primary.friend_user_id1=se_polls.poll_user_id AND friends_secondary.friend_user_id2='{$user->user_info['user_id']}' AND se_users.user_subnet_id='{$user->user_info['user_subnet_id']}' LIMIT 1))\r\n\t THEN TRUE\r\n\t ELSE FALSE\r\n\tEND";
// ONLY MY FRIENDS' POLLS
if ($v == "1" && $user->user_exists) {
// SET WHERE CLAUSE
$where .= " && (\r\n SELECT\r\n TRUE\r\n FROM\r\n se_friends\r\n WHERE\r\n friend_user_id1='{$user->user_info['user_id']}' &&\r\n friend_user_id2=se_polls.poll_user_id &&\r\n friend_status=1\r\n )\r\n ";
}
// CREATE poll OBJECT
$poll = new se_poll();
// GET TOTAL pollS
$total_polls = $poll->poll_total($where);
// MAKE ENTRY PAGES
$polls_per_page = 10;
$page_vars = make_page($total_polls, $polls_per_page, $p);
// GET poll ARRAY
$poll_array = $poll->poll_list($page_vars[0], $polls_per_page, $s, $where, TRUE);
// ASSIGN SMARTY VARIABLES AND DISPLAY pollS PAGE
$smarty->assign('polls', $poll_array);
$smarty->assign('total_polls', $total_polls);
$smarty->assign('p', $page_vars[1]);
$smarty->assign('maxpage', $page_vars[2]);
$smarty->assign('p_start', $page_vars[0] + 1);
$smarty->assign('p_end', $page_vars[0] + count($poll_array));
$smarty->assign('s', $s);
$smarty->assign('v', $v);
include "footer.php";
if ($search != "") {
$where = "(poll_title LIKE '%{$search}%' OR poll_desc LIKE '%{$search}%' OR poll_options LIKE '%{$search}%')";
} else {
$where = "";
}
// CREATE POLL OBJECT
$entries_per_page = $user->level_info['level_poll_entries'];
$poll = new se_poll($user->user_info['user_id']);
// DELETE NECESSARY ENTRIES
$start = ($p - 1) * $entries_per_page;
if ($task == "delete") {
$poll->polls_delete($start, $entries_per_page, $sort, $where);
}
// GET TOTAL ENTRIES
$total_polls = $poll->poll_total($where);
// MAKE ENTRY PAGES
$page_vars = make_page($total_polls, $entries_per_page, $p);
// GET ENTRY ARRAY
$polls = $poll->poll_list($page_vars[0], $entries_per_page, $sort, $where);
$smarty->assign('polls', $polls);
$smarty->assign('s', $s);
$smarty->assign('d', $d);
$smarty->assign('t', $t);
$smarty->assign('c', $c);
$smarty->assign('search', $search);
$smarty->assign('total_polls', $total_polls);
$smarty->assign('p', $page_vars[1]);
$smarty->assign('maxpage', $page_vars[2]);
$smarty->assign('p_start', $page_vars[0] + 1);
$smarty->assign('p_end', $page_vars[0] + count($polls));
include "footer.php";
if ($user->user_exists && 4 & (int) $user->level_info['level_poll_allow']) {
$plugin_vars['menu_user'] = array('file' => 'user_poll.php', 'icon' => 'poll_poll16.gif', 'title' => 2500005);
}
// SET PROFILE MENU VARS
if (4 & (int) $owner->level_info['level_poll_allow'] && $page == "profile") {
// START poll
$poll = new se_poll($owner->user_info['user_id']);
$entries_per_page = 5;
$sort = "poll_datecreated DESC";
// GET PRIVACY LEVEL AND SET WHERE
$privacy_max = $owner->user_privacy_max($user);
$where = "(poll_privacy & {$privacy_max})";
// GET TOTAL ENTRIES
$total_polls = $poll->poll_total($where);
// GET ENTRY ARRAY
$polls = $poll->poll_list(0, $entries_per_page, $sort, $where);
// ASSIGN ENTRIES SMARY VARIABLE
$smarty->assign('polls', $polls);
$smarty->assign('total_polls', $total_polls);
// SET PROFILE MENU VARS
$plugin_vars['menu_profile_side'] = NULL;
if ($total_polls) {
$plugin_vars['menu_profile_tab'] = array('file' => 'profile_poll.tpl', 'title' => 2500005, 'name' => 'poll');
}
}
// Use template hooks
if (is_a($smarty, 'SESmarty')) {
$plugin_vars['uses_tpl_hooks'] = TRUE;
if (!empty($plugin_vars['menu_main'])) {
$smarty->assign_hook('menu_main', $plugin_vars['menu_main']);
}
include "footer.php";
}
// ENSURE POLLS ARE ENABLED FOR THIS USER
if (4 & ~(int) $owner->level_info['level_poll_allow']) {
header("Location: " . $url->url_create('profile', $owner->user_info['user_username']));
exit;
}
// SET PRIVACY LEVEL AND WHERE CLAUSE
$privacy_max = $owner->user_privacy_max($user);
$where = "(poll_privacy & {$privacy_max})";
// CREATE POLL OBJECT
$entries_per_page = $owner->level_info['level_poll_entries'];
$poll = new se_poll($owner->user_info['user_id']);
// GET TOTAL ENTRIES
$total_polls = $poll->poll_total($where);
// MAKE ENTRY PAGES
$page_vars = make_page($total_polls, $entries_per_page, $p);
// GET ENTRY ARRAY
$polls = $poll->poll_list($page_vars[0], $entries_per_page, "poll_id DESC", $where);
$smarty->assign('polls', $polls);
$smarty->assign('s', $s);
$smarty->assign('d', $d);
$smarty->assign('t', $t);
$smarty->assign('c', $c);
$smarty->assign('search', $search);
$smarty->assign('total_polls', $total_polls);
$smarty->assign('p', $page_vars[1]);
$smarty->assign('maxpage', $page_vars[2]);
$smarty->assign('p_start', $page_vars[0] + 1);
$smarty->assign('p_end', $page_vars[0] + count($polls));
include "footer.php";
