111 lines
2.0 KiB
PHP
111 lines
2.0 KiB
PHP
|
|
<?php
|
||
|
|
|
||
|
|
/* $Id: home.php 8 2009-01-11 06:02:53Z john $ */
|
||
|
|
|
||
|
|
$includepoll=true;
|
||
|
|
|
||
|
|
include "header-ajax.php";
|
||
|
|
|
||
|
|
$page = 'latestpolls';
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
// Polls
|
||
|
|
|
||
|
|
$p=1;
|
||
|
|
|
||
|
|
$s = "poll_datecreated DESC";
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
$userid=7653;
|
||
|
|
|
||
|
|
$v = 0;
|
||
|
|
|
||
|
|
$where = "CASE
|
||
|
|
|
||
|
|
WHEN se_polls.poll_user_id='{$userid}'
|
||
|
|
|
||
|
|
THEN TRUE
|
||
|
|
|
||
|
|
WHEN ((se_polls.poll_privacy & @SE_PRIVACY_REGISTERED) AND '{$user->user_exists}'<>0)
|
||
|
|
|
||
|
|
THEN TRUE
|
||
|
|
|
||
|
|
WHEN ((se_polls.poll_privacy & @SE_PRIVACY_ANONYMOUS) AND '{$user->user_exists}'=0)
|
||
|
|
|
||
|
|
THEN TRUE
|
||
|
|
|
||
|
|
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='{$userid}' AND friend_status='1' LIMIT 1))
|
||
|
|
|
||
|
|
THEN TRUE
|
||
|
|
"./*
|
||
|
|
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))
|
||
|
|
|
||
|
|
THEN TRUE
|
||
|
|
*/"
|
||
|
|
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='{$userid}' LIMIT 1))
|
||
|
|
|
||
|
|
THEN TRUE
|
||
|
|
|
||
|
|
ELSE FALSE
|
||
|
|
|
||
|
|
END AND se_polls.approved=1";
|
||
|
|
|
||
|
|
$poll = new se_poll();
|
||
|
|
|
||
|
|
// GET TOTAL pollS
|
||
|
|
|
||
|
|
$total_polls = $poll->poll_total($where);
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
// MAKE ENTRY PAGES
|
||
|
|
|
||
|
|
$polls_per_page = 4;
|
||
|
|
|
||
|
|
$page_vars = make_page($total_polls, $polls_per_page, $p);
|
||
|
|
|
||
|
|
// GET poll ARRAY
|
||
|
|
|
||
|
|
$poll_array = $poll->poll_list_home($page_vars[0], $polls_per_page, $s, $where, TRUE);
|
||
|
|
|
||
|
|
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
|
||
|
|
|
||
|
|
{
|
||
|
|
|
||
|
|
if(($page_vars[1]+10)==$x)
|
||
|
|
|
||
|
|
{break;}
|
||
|
|
|
||
|
|
$for[$y]=$x;
|
||
|
|
|
||
|
|
$y++;
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
$smarty->assign('for', $for);
|
||
|
|
|
||
|
|
// ASSIGN SMARTY VARIABLES AND DISPLAY pollS PAGE
|
||
|
|
|
||
|
|
$smarty->assign('polls', $poll_array);
|
||
|
|
|
||
|
|
$smarty->assign('total_polls', $total_polls);
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
if(count($poll_array)>0){
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
include "footer-save.php";
|
||
|
|
|
||
|
|
}?>
|
||
|
|
|