$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";