user_id = $user_id;
$this->poll_exists = FALSE;
if( $poll_id )
{
// GENERATE QUERY
$sql = "
SELECT
*
FROM
se_polls
WHERE
poll_id='{$poll_id}' AND approved=1
";
if( $user_id ) $sql .= " &&
poll_user_id='{$user_id}'
";
$sql .= "
LIMIT
1
";
$resource = $database->database_query($sql) or die($database->database_error()."
SQL: $sql");
if( $database->database_num_rows($resource) )
{
$this->poll_info = $database->database_fetch_assoc($resource);
$this->poll_exists = TRUE;
// GENERATE STATS
$this->poll_info['poll_options'] = unserialize($this->poll_info['poll_options']);
$this->poll_info['poll_answers'] = unserialize($this->poll_info['poll_answers']);
$this->poll_info['poll_voted'] = unserialize($this->poll_info['poll_voted']);
// GET IF THIS POLL CAN BE VOTED ON FOR THE CURRENT USER
if( !$user->user_exists || in_array($user->user_info['user_id'], $this->poll_info['poll_voted']) )
$this->poll_info['poll_viewonly'] = TRUE;
elseif( $this->poll_info['poll_closed'] )
$this->poll_info['poll_viewonly'] = TRUE;
else
$this->poll_info['poll_viewonly'] = FALSE;
// GET OWNER INFO
if( $user->user_exists && $this->poll_info['poll_user_id']==$user->user_info['user_id'] )
$this->poll_owner =& $user;
elseif( $owner->user_exists && $this->poll_info['poll_user_id']==$owner->user_info['user_id'] )
$this->poll_owner =& $owner;
else
$this->poll_owner = new se_user(array($this->poll_info['poll_user_id']));
}
}
}
function poll_create($poll_title, $poll_desc, $poll_options_raw, $poll_search, $poll_privacy, $poll_comments)
{
global $database, $user;
$poll_title = censor($poll_title);
$poll_desc = censor($poll_desc);
$poll_options_raw = array_map('censor', $poll_options_raw);
// GET PRIVACY SETTINGS
$level_poll_privacy = unserialize($user->level_info['level_poll_privacy']);
rsort($level_poll_privacy);
$level_poll_comments = unserialize($user->level_info['level_poll_comments']);
rsort($level_poll_comments);
// MAKE SURE SUBMITTED PRIVACY OPTIONS ARE ALLOWED, IF NOT, SET TO MOST PUBLIC
if( !in_array($poll_privacy, $level_poll_privacy) )
$poll_privacy = $level_poll_privacy[0];
if( !in_array($poll_comments, $level_poll_comments))
$poll_comments = $level_poll_comments[0];
// CHECK THAT SEARCH IS NOT BLANK
if( !$user->level_info['level_poll_search'] )
$poll_search = 1;
// GET START AND END DATES
$poll_datecreated = time();
$poll_options = array();
$poll_answers = array();
$poll_voted = array();
// Make options and answers
$poll_option_index = 0;
foreach( $poll_options_raw as $poll_option_label )
{
$poll_options[$poll_option_index] = $poll_option_label;
$poll_answers[$poll_option_index] = 0;
$poll_option_index++;
}
$poll_options = serialize($poll_options);
$poll_answers = serialize($poll_answers);
$poll_voted = serialize($poll_voted);
// GENERATE QUERY
$sql = "
INSERT INTO
se_polls
(
poll_user_id,
poll_datecreated,
poll_title,
poll_desc,
poll_options,
poll_answers,
poll_voted,
poll_search,
poll_privacy,
poll_comments
)
VALUES
(
'{$user->user_info['user_id']}',
'{$poll_datecreated}',
'".$database->database_real_escape_string($poll_title)."',
'".$database->database_real_escape_string($poll_desc)."',
'".$database->database_real_escape_string($poll_options)."',
'{$poll_answers}',
'{$poll_voted}',
'{$poll_search}',
'{$poll_privacy}',
'{$poll_comments}'
)
";
$resource = $database->database_query($sql) or die($database->database_error()." SQL: ".$sql);
wrapup("poll_created");
return (bool) $database->database_affected_rows($resource);
}
function poll_edit($poll_title, $poll_desc, $poll_search, $poll_privacy, $poll_comments)
{
global $user, $database;
$poll_title = censor($poll_title);
$poll_desc = censor($poll_desc);
// GET PRIVACY SETTINGS
$level_poll_privacy = unserialize($user->level_info['level_poll_privacy']);
rsort($level_poll_privacy);
$level_poll_comments = unserialize($user->level_info['level_poll_comments']);
rsort($level_poll_comments);
// MAKE SURE SUBMITTED PRIVACY OPTIONS ARE ALLOWED, IF NOT, SET TO MOST PUBLIC
if( !in_array($poll_privacy, $level_poll_privacy) )
$poll_privacy = $level_poll_privacy[0];
if( !in_array($poll_comments, $level_poll_comments))
$poll_comments = $level_poll_comments[0];
// CHECK THAT SEARCH IS NOT BLANK
if( !$user->level_info['level_poll_search'] )
$poll_search = 1;
$sql = "
UPDATE
se_polls
SET
poll_title='".$database->database_real_escape_string($poll_title)."',
poll_desc='".$database->database_real_escape_string($poll_desc)."',
poll_search='{$poll_search}',
poll_privacy='{$poll_privacy}',
poll_comments='{$poll_comments}'
WHERE
poll_id='{$this->poll_info['poll_id']}' &&
poll_user_id='{$this->user_id}'
LIMIT
1
";
$resource = $database->database_query($sql) or die($database->database_error()." SQL: ".$sql);
return (bool) $database->database_affected_rows($resource);
}
function poll_delete($poll_id)
{
global $database;
// CREATE DELETE QUERY
$sql = "DELETE FROM se_polls WHERE";
// SINGLE
if( is_numeric($poll_id) )
$sql .= " se_polls.poll_id='{$poll_id}'";
elseif( is_array($poll_id) )
$sql .= " se_polls.poll_id IN('".join("','", $poll_id)."')";
else
return FALSE;
// IF USER ID IS NOT EMPTY, ADD USER ID CLAUSE
if( $this->user_id )
$sql .= " && se_polls.poll_user_id='{$this->user_id}'";
// RUN QUERIES
$resource = $database->database_query($sql) or die($database->database_error()." SQL: ".$sql);
return (bool) $database->database_affected_rows($resource);
}
function poll_vote($vote_id)
{
global $database, $user, $actions, $owner;
$this->is_error = NULL;
// VALIDATION
if( !$user->user_exists )
$this->is_error = 2500091;
elseif( !$this->poll_exists )
$this->is_error = 2500090;
elseif( !$this->poll_info['poll_id'] )
$this->is_error = 2500090;
elseif( $this->poll_info['poll_closed'] )
$this->is_error = 2500094;
elseif( !isset($vote_id) || !isset($this->poll_info['poll_answers'][$vote_id]) )
$this->is_error = 2500092;
elseif( in_array($user->user_info['user_id'], $this->poll_info['poll_voted']) )
$this->is_error = 2500093;
if( $this->is_error ) return FALSE;
// UPDATE
$this->poll_info['poll_answers'][$vote_id]++;
$this->poll_info['poll_totalvotes']++;
$this->poll_info['poll_voted'][] = $user->user_info['user_id'];
$answer_string = serialize($this->poll_info['poll_answers']);
$voted_string = serialize($this->poll_info['poll_voted']);
// GENERATE QUERY
$sql = "
UPDATE
se_polls
SET
poll_answers='{$answer_string}',
poll_voted='{$voted_string}',
poll_totalvotes=poll_totalvotes+1
WHERE
poll_id='{$this->poll_info['poll_id']}'
LIMIT
1
";
$resource = $database->database_query($sql) or die($database->database_error()." SQL: ".$sql);
if( !$database->database_affected_rows($resource) ) return FALSE;
// INSERT ACTION
$poll_title = $this->poll_info['poll_title'];
if( strlen($poll_title)>100 )
$poll_title = substr($poll_title, 0, 97)."...";
$actions->actions_add($user, "votepoll", array(
$user->user_info['user_username'],
$user->user_displayname,
$this->poll_owner->user_info['user_username'],
$this->poll_info['poll_id'],
$poll_title
), Array(), 0, false, $object_owner, $this->poll_info["poll_id"], $object_privacy);
return TRUE;
}
function poll_update()
{
global $database;
if( !$this->poll_exists || !$this->poll_info['poll_id'] )
return FALSE;
// CREATE UPDATE QUERY
$sql = "
UPDATE
se_polls
SET
poll_dateupdated='".time()."'
WHERE
poll_id='{$this->poll_info['poll_id']}'
LIMIT
1
";
// RUN QUERIES
$resource = $database->database_query($sql) or die($database->database_error()." SQL: ".$sql);
return (bool) $database->database_affected_rows($resource);
}
function poll_toggle_closed($force_value=NULL)
{
global $database, $user;
if( !$this->poll_exists || !$this->poll_info['poll_id'] || $user->user_info['user_id']!=$this->poll_info['poll_user_id'] )
return FALSE;
$new_value = ( isset($force_value) ? $force_value : !($this->poll_info['poll_closed']) );
// CREATE UPDATE QUERY
$sql = "
UPDATE
se_polls
SET
poll_closed='{$new_value}'
WHERE
poll_id='{$this->poll_info['poll_id']}'
LIMIT
1
";
// RUN QUERIES
$resource = $database->database_query($sql) or die($database->database_error()." SQL: ".$sql);
return (bool) $database->database_affected_rows($resource);
}
function poll_view()
{
global $database;
if( !$this->poll_exists || !$this->poll_info['poll_id'] )
return FALSE;
// CREATE UPDATE QUERY
$sql = "
UPDATE
se_polls
SET
poll_views=poll_views+1
WHERE
poll_id='{$this->poll_info['poll_id']}'
LIMIT
1
";
// RUN QUERIES
$resource = $database->database_query($sql) or die($database->database_error()." SQL: ".$sql);
return (bool) $database->database_affected_rows($resource);
}
function poll_total_admin($where)
{
global $database;
// BEGIN ENTRY QUERY
$sql = "
SELECT
NULL
FROM
se_polls
";
// IF NO USER ID SPECIFIED, JOIN TO USER TABLE
if( !$this->user_id ) $sql .= "
LEFT JOIN
se_users
ON se_polls.poll_user_id=se_users.user_id
";
// ADD WHERE IF NECESSARY
$sql .= "
WHERE 1=1
";
// ENSURE USER ID IS NOT EMPTY
if( $this->user_id ) $sql .= " AND
poll_user_id='{$this->user_id}'
";
// INSERT AND IF NECESSARY
//if(!empty($where) && $this->user_id ) $sql .= " AND";
// ADD WHERE CLAUSE, IF NECESSARY
if( !empty($where) ) $sql .= " AND
$where
";
// GET AND RETURN TOTAL poll ENTRIES
$resource = $database->database_query($sql) or die($database->database_error()." SQL: ".$sql);
$poll_total = $database->database_num_rows($resource);
return $poll_total;
}
function poll_total($where)
{
global $database;
// BEGIN ENTRY QUERY
$sql = "
SELECT
NULL
FROM
se_polls
";
// IF NO USER ID SPECIFIED, JOIN TO USER TABLE
// if( !$this->user_id )
$sql .= "
LEFT JOIN
se_users
ON se_polls.poll_user_id=se_users.user_id
";
// ADD WHERE IF NECESSARY
$sql .= "
WHERE approved=1 AND se_users.user_enabled=1
";
// ENSURE USER ID IS NOT EMPTY
if( $this->user_id ) $sql .= " AND
poll_user_id='{$this->user_id}'
";
// INSERT AND IF NECESSARY
//if(!empty($where) && $this->user_id ) $sql .= " AND";
// ADD WHERE CLAUSE, IF NECESSARY
if( !empty($where) ) $sql .= " AND
$where
";
// GET AND RETURN TOTAL poll ENTRIES
$resource = $database->database_query($sql) or die($database->database_error()." SQL: ".$sql);
$poll_total = $database->database_num_rows($resource);
return $poll_total;
}
function poll_list_admin($start, $limit, $sort_by = "poll_id DESC", $where = "", $poll_details = 0)
{
global $database, $user;
// BEGIN QUERY
$sql = "
SELECT
se_polls.*,
se_polls.poll_totalcomments AS total_comments
";
// SELECT RELEVANT poll DETAILS IF NECESSARY
if($poll_details == 1) $sql .= ",
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
";
// CONTINUE QUERY
$sql .= "
FROM
se_polls
";
// CONTINUE QUERY IF NECESSARY
if($poll_details == 1) $sql .= "
LEFT JOIN
se_users
ON se_polls.poll_user_id=se_users.user_id
";
// ADD WHERE IF NECESSARY
$sql .= "
WHERE 1=1 AND se_users.user_enabled=1 AND se_users.user_enabled=1
";
// ENSURE USER ID IS NOT EMPTY
if($this->user_id != 0) $sql .= " AND
poll_user_id='{$this->user_id}'
";
// INSERT AND IF NECESSARY
//if($this->user_id != 0 & $where != "") $sql .= " AND";
// ADD WHERE CLAUSE, IF NECESSARY
if($where != "") $sql .= " AND
$where
";
// ADD ORDER, AND LIMIT CLAUSE
$sql .= "
ORDER BY
$sort_by
LIMIT
$start, $limit
";
// RUN QUERY
$resource = $database->database_query($sql) or die($database->database_error()." SQL: ".$sql);
// GET pollS INTO AN ARRAY
$poll_array = array();
while( $poll_info=$database->database_fetch_assoc($resource) )
{
// CREATE OBJECT FOR poll
$poll = new se_poll($poll_info['user_id']);
$poll->poll_exists = TRUE;
// CREATE OBJECT FOR poll CREATOR IF poll DETAILS
if( $poll_details )
{
$creator = new se_user();
$creator->user_exists = TRUE;
$creator->user_info['user_id'] = $poll_info['user_id'];
$creator->user_info['user_username'] = $poll_info['user_username'];
$creator->user_info['user_photo'] = $poll_info['user_photo'];
$creator->user_info['user_fname'] = $poll_info['user_fname'];
$creator->user_info['user_lname'] = $poll_info['user_lname'];
$creator->user_displayname();
$poll->poll_owner =& $creator;
unset($creator);
}
// TURN OPTIONS AND ANSWERS INTO ARRAYS, GET TOTAL VOTES
$poll_info['poll_options'] = unserialize($poll_info['poll_options']);
$poll_info['poll_answers'] = unserialize($poll_info['poll_answers']);
$poll_info['poll_voted'] = unserialize($poll_info['poll_voted']);
// GET IF THIS POLL HAS BEEN VOTED ON
if( !$user->user_exists || in_array($user->user_info['user_id'], $poll_info['poll_voted']) )
$poll_info['poll_viewonly'] = TRUE;
else
$poll_info['poll_viewonly'] = FALSE;
// PRIVACY
$poll_info['poll_privacy_lang'] = user_privacy_levels($poll_info['poll_privacy']);
SE_Language::_preload($poll_info['poll_privacy_lang']);
$poll->poll_info = $poll_info;
$poll_array[] = $poll;
}
// RETURN ARRAY
return $poll_array;
}
function poll_list($start, $limit, $sort_by = "pin DESC, poll_id DESC", $where = "", $poll_details = 0)
{
global $database, $user;
// BEGIN QUERY
$sql = "
SELECT
se_polls.*,
se_polls.poll_totalcomments AS total_comments
";
// SELECT RELEVANT poll DETAILS IF NECESSARY
if($poll_details == 1) $sql .= ",
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
";
// CONTINUE QUERY
$sql .= "
FROM
se_polls
";
// CONTINUE QUERY IF NECESSARY
if($poll_details == 1) $sql .= "
LEFT JOIN
se_users
ON se_polls.poll_user_id=se_users.user_id
";
// ADD WHERE IF NECESSARY
$sql .= "
WHERE approved=1
";
// ENSURE USER ID IS NOT EMPTY
if($this->user_id != 0) $sql .= " AND
poll_user_id='{$this->user_id}'
";
// INSERT AND IF NECESSARY
//if($this->user_id != 0 & $where != "") $sql .= " AND";
// ADD WHERE CLAUSE, IF NECESSARY
if($where != "") $sql .= " AND
$where
";
// ADD ORDER, AND LIMIT CLAUSE
$sql .= "
ORDER BY
$sort_by
LIMIT
$start, $limit
";
// RUN QUERY
$resource = $database->database_query($sql) or die($database->database_error()." SQL: ".$sql);
// GET pollS INTO AN ARRAY
$poll_array = array();
while( $poll_info=$database->database_fetch_assoc($resource) )
{
// CREATE OBJECT FOR poll
$poll = new se_poll($poll_info['user_id']);
$poll->poll_exists = TRUE;
// CREATE OBJECT FOR poll CREATOR IF poll DETAILS
if( $poll_details )
{
$creator = new se_user();
$creator->user_exists = TRUE;
$creator->user_info['user_id'] = $poll_info['user_id'];
$creator->user_info['user_username'] = $poll_info['user_username'];
$creator->user_info['user_photo'] = $poll_info['user_photo'];
$creator->user_info['user_fname'] = $poll_info['user_fname'];
$creator->user_info['user_lname'] = $poll_info['user_lname'];
$creator->user_displayname();
$poll->poll_owner =& $creator;
unset($creator);
}
// TURN OPTIONS AND ANSWERS INTO ARRAYS, GET TOTAL VOTES
$poll_info['poll_options'] = unserialize($poll_info['poll_options']);
$poll_info['poll_answers'] = unserialize($poll_info['poll_answers']);
$poll_info['poll_voted'] = unserialize($poll_info['poll_voted']);
// GET IF THIS POLL HAS BEEN VOTED ON
if( !$user->user_exists || in_array($user->user_info['user_id'], $poll_info['poll_voted']) )
$poll_info['poll_viewonly'] = TRUE;
else
$poll_info['poll_viewonly'] = FALSE;
// PRIVACY
$poll_info['poll_privacy_lang'] = user_privacy_levels($poll_info['poll_privacy']);
SE_Language::_preload($poll_info['poll_privacy_lang']);
$poll->poll_info = $poll_info;
$poll_array[] = $poll;
}
// RETURN ARRAY
return $poll_array;
}
function poll_list_home($start, $limit, $sort_by = "poll_id DESC", $where = "", $poll_details = 0)
{
global $database, $user;
// BEGIN QUERY
$sql = "
SELECT
se_polls.*,
se_polls.poll_totalcomments AS total_comments
";
// SELECT RELEVANT poll DETAILS IF NECESSARY
if($poll_details == 1) $sql .= ",
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
";
// CONTINUE QUERY
$sql .= "
FROM
se_polls
";
// CONTINUE QUERY IF NECESSARY
if($poll_details == 1) $sql .= "
LEFT JOIN
se_users
ON se_polls.poll_user_id=se_users.user_id
";
// ADD WHERE IF NECESSARY
$sql .= "
WHERE approved=1
";
// ENSURE USER ID IS NOT EMPTY
if($this->user_id != 0) $sql .= " AND
poll_user_id='{$this->user_id}'
";
// INSERT AND IF NECESSARY
//if($this->user_id != 0 & $where != "") $sql .= " AND";
// ADD WHERE CLAUSE, IF NECESSARY
if($where != "") $sql .= " AND
$where
";
// ADD ORDER, AND LIMIT CLAUSE
$sql .= "
GROUP BY poll_user_id
ORDER BY
$sort_by
LIMIT
$start, $limit
";
// RUN QUERY
$resource = $database->database_query($sql) or die($database->database_error()." SQL: ".$sql);
// GET pollS INTO AN ARRAY
$poll_array = array();
while( $poll_info=$database->database_fetch_assoc($resource) )
{
// CREATE OBJECT FOR poll
$poll = new se_poll($poll_info['user_id']);
$poll->poll_exists = TRUE;
// CREATE OBJECT FOR poll CREATOR IF poll DETAILS
if( $poll_details )
{
$creator = new se_user();
$creator->user_exists = TRUE;
$creator->user_info['user_id'] = $poll_info['user_id'];
$creator->user_info['user_username'] = $poll_info['user_username'];
$creator->user_info['user_photo'] = $poll_info['user_photo'];
$creator->user_info['user_fname'] = $poll_info['user_fname'];
$creator->user_info['user_lname'] = $poll_info['user_lname'];
$creator->user_displayname();
$poll->poll_owner =& $creator;
unset($creator);
}
// TURN OPTIONS AND ANSWERS INTO ARRAYS, GET TOTAL VOTES
$poll_info['poll_options'] = unserialize($poll_info['poll_options']);
$poll_info['poll_answers'] = unserialize($poll_info['poll_answers']);
$poll_info['poll_voted'] = unserialize($poll_info['poll_voted']);
// GET IF THIS POLL HAS BEEN VOTED ON
if( !$user->user_exists || in_array($user->user_info['user_id'], $poll_info['poll_voted']) )
$poll_info['poll_viewonly'] = TRUE;
else
$poll_info['poll_viewonly'] = FALSE;
// PRIVACY
$poll_info['poll_privacy_lang'] = user_privacy_levels($poll_info['poll_privacy']);
SE_Language::_preload($poll_info['poll_privacy_lang']);
$poll->poll_info = $poll_info;
$poll_array[] = $poll;
}
// RETURN ARRAY
return $poll_array;
}
}
?>