Files
Testing/include/functions_poll.php

755 lines
13 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?php
/* $Id: functions_poll.php 12 2009-01-11 06:04:12Z john $ */
//
// THIS FILE CONTAINS POLL-RELATED FUNCTIONS
//
// FUNCTIONS IN THIS CLASS:
// search_poll()
// deleteuser_poll()
// site_statistics_poll()
//
defined('SE_PAGE') or exit();
function tag_polls(){
global $database, $url, $results_per_page, $p, $search_text, $t, $search_objects, $results, $total_results;
// CONSTRUCT QUERY
$sql = "
SELECT
se_polls.poll_id,
se_polls.poll_title,
se_polls.poll_datecreated,
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
FROM
se_polls,
se_users,
se_levels
WHERE
se_polls.approved=1 &&
se_polls.poll_user_id=se_users.user_id &&
se_users.user_enabled=1 &&
se_users.user_level_id=se_levels.level_id &&
(
se_polls.poll_search='1' ||
se_levels.level_poll_search='0'
) &&
(
poll_title LIKE '%".$database->database_real_escape_string($search_text)."%' ||
poll_desc LIKE '%".$database->database_real_escape_string($search_text)."%' ||
poll_options LIKE '%".$database->database_real_escape_string($search_text)."%'
)
";
// GET TOTAL ENTRIES
$total_polls = $database->database_num_rows($database->database_query($sql.""));
// IF NOT TOTAL ONLY
//if( $t=="poll" )
{
// MAKE POLL PAGES
$start = ($p - 1) * $results_per_page;
$limit = $results_per_page + 1;
// SEARCH POLLS
$sql .= " ORDER BY se_polls.poll_id DESC LIMIT $start, $limit";
$resource = $database->database_query($sql) or die($database->database_error());
while( $poll_info=$database->database_fetch_assoc($resource) )
{
// CREATE AN OBJECT FOR AUTHOR
$profile = new se_user();
$profile->user_info['user_id'] = $poll_info['user_id'];
$profile->user_info['user_username'] = $poll_info['user_username'];
$profile->user_info['user_fname'] = $poll_info['user_fname'];
$profile->user_info['user_lname'] = $poll_info['user_lname'];
$profile->user_info['user_photo'] = $poll_info['user_photo'];
$profile->user_displayname();
$result_url = $url->url_create('poll', $poll_info['user_username'], $poll_info['poll_id']);
$result_name = 2500112;
$result_desc = 2500113;
// IF EMPTY TITLE
if( !trim($poll_info['poll_title']) ) { SE_Language::_preload(589); SE_Language::load(); $poll_info['poll_title'] = SE_Language::_get(589); }
$results[] = array(
'result_url' => $result_url,
'result_icon' => './images/icons/poll_poll48.gif',
'user_photo' => $profile->user_info['user_photo'],
'result_name' => $result_name,
'result_name_1' => $poll_info['poll_title'],
'time' => $poll_info['poll_datecreated'],
'result_desc' => $result_desc,
'result_desc_1' => $url->url_create('profile', $profile->user_info['user_username']),
'result_desc_2' => $profile->user_displayname,
'profile' => $profile,
'result_desc_3' => $poll_info['poll_desc'],
);
}
// SET TOTAL RESULTS
$total_results = $total_polls;
}
// SET ARRAY VALUES
SE_Language::_preload_multi(2500111, 2500112, 2500113);
if($total_polls > 200) { $total_polls = "200+"; }
$search_objects[] = array(
'search_type' => 'poll',
'search_lang' => 2500111,
'search_total' => $total_polls
);
}
// THIS FUNCTION IS RUN DURING THE SEARCH PROCESS TO SEARCH THROUGH POLLS
// INPUT: $search_text REPRESENTING THE STRING TO SEARCH FOR
// $total_only REPRESENTING 1/0 DEPENDING ON WHETHER OR NOT TO RETURN JUST THE TOTAL RESULTS
// $search_objects REPRESENTING AN ARRAY CONTAINING INFORMATION ABOUT THE POSSIBLE OBJECTS TO SEARCH
// $results REPRESENTING THE ARRAY OF SEARCH RESULTS
// $total_results REPRESENTING THE TOTAL SEARCH RESULTS
// OUTPUT:
function search_poll_new(){
global $database, $url, $results_per_page, $p, $search_text, $t, $search_objects, $results, $total_results;
// CONSTRUCT QUERY
$sql = "
SELECT
se_polls.poll_id,
se_polls.poll_title,
se_polls.poll_datecreated,
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
FROM
se_polls,
se_users,
se_levels
WHERE
se_polls.approved=1 &&
se_polls.poll_user_id=se_users.user_id &&
se_users.user_enabled=1 &&
se_users.user_level_id=se_levels.level_id &&
(
se_polls.poll_search='1' ||
se_levels.level_poll_search='0'
) &&
(
poll_title LIKE '%".$database->database_real_escape_string($search_text)."%' ||
poll_desc LIKE '%".$database->database_real_escape_string($search_text)."%' ||
poll_options LIKE '%".$database->database_real_escape_string($search_text)."%'
)
";
// GET TOTAL ENTRIES
$total_polls = $database->database_num_rows($database->database_query($sql.""));
// IF NOT TOTAL ONLY
//if( $t=="poll" )
{
// MAKE POLL PAGES
$start = ($p - 1) * $results_per_page;
$limit = $results_per_page + 1;
// SEARCH POLLS
$sql .= " ORDER BY se_polls.poll_id DESC LIMIT $start, $limit";
$resource = $database->database_query($sql) or die($database->database_error());
while( $poll_info=$database->database_fetch_assoc($resource) )
{
// CREATE AN OBJECT FOR AUTHOR
$profile = new se_user();
$profile->user_info['user_id'] = $poll_info['user_id'];
$profile->user_info['user_username'] = $poll_info['user_username'];
$profile->user_info['user_fname'] = $poll_info['user_fname'];
$profile->user_info['user_lname'] = $poll_info['user_lname'];
$profile->user_info['user_photo'] = $poll_info['user_photo'];
$profile->user_displayname();
$result_url = $url->url_create('poll', $poll_info['user_username'], $poll_info['poll_id']);
$result_name = 2500112;
$result_desc = 2500113;
// IF EMPTY TITLE
if( !trim($poll_info['poll_title']) ) { SE_Language::_preload(589); SE_Language::load(); $poll_info['poll_title'] = SE_Language::_get(589); }
$results[] = array(
'result_url' => $result_url,
'result_icon' => './images/icons/poll_poll48.gif',
'user_photo' => $profile->user_info['user_photo'],
'result_name' => $result_name,
'result_name_1' => $poll_info['poll_title'],
'time' => $poll_info['poll_datecreated'],
'result_desc' => $result_desc,
'result_desc_1' => $url->url_create('profile', $profile->user_info['user_username']),
'result_desc_2' => $profile->user_displayname,
'profile' => $profile,
'result_desc_3' => $poll_info['poll_desc'],
);
}
// SET TOTAL RESULTS
$total_results = $total_polls;
}
// SET ARRAY VALUES
SE_Language::_preload_multi(2500111, 2500112, 2500113);
if($total_polls > 200) { $total_polls = "200+"; }
$search_objects[] = array(
'search_type' => 'poll',
'search_lang' => 2500111,
'search_total' => $total_polls
);
}
function search_poll()
{
global $database, $url, $results_per_page, $p, $search_text, $t, $search_objects, $results, $total_results;
// CONSTRUCT QUERY
$sql = "
SELECT
se_polls.poll_id,
se_polls.poll_title,
se_polls.poll_datecreated,
se_users.user_id,
se_users.user_username,
se_users.user_photo,
se_users.user_fname,
se_users.user_lname
FROM
se_polls,
se_users,
se_levels
WHERE
se_polls.approved=1 &&
se_polls.poll_user_id=se_users.user_id &&
se_users.user_enabled=1 &&
se_users.user_level_id=se_levels.level_id &&
(
se_polls.poll_search='1' ||
se_levels.level_poll_search='0'
) &&
(
poll_title LIKE '%$search_text%' ||
poll_desc LIKE '%$search_text%' ||
poll_options LIKE '%$search_text%'
)
";
// GET TOTAL ENTRIES
$total_polls = $database->database_num_rows($database->database_query($sql." LIMIT 201"));
// IF NOT TOTAL ONLY
if( $t=="poll" )
{
// MAKE POLL PAGES
$start = ($p - 1) * $results_per_page;
$limit = $results_per_page + 1;
// SEARCH POLLS
$sql .= " ORDER BY se_polls.poll_id DESC LIMIT $start, $limit";
$resource = $database->database_query($sql) or die($database->database_error());
while( $poll_info=$database->database_fetch_assoc($resource) )
{
// CREATE AN OBJECT FOR AUTHOR
$profile = new se_user();
$profile->user_info['user_id'] = $poll_info['user_id'];
$profile->user_info['user_username'] = $poll_info['user_username'];
$profile->user_info['user_fname'] = $poll_info['user_fname'];
$profile->user_info['user_lname'] = $poll_info['user_lname'];
$profile->user_info['user_photo'] = $poll_info['user_photo'];
$profile->user_displayname();
$result_url = $url->url_create('poll', $poll_info['user_username'], $poll_info['poll_id']);
$result_name = 2500112;
$result_desc = 2500113;
// IF EMPTY TITLE
if( !trim($poll_info['poll_title']) ) { SE_Language::_preload(589); SE_Language::load(); $poll_info['poll_title'] = SE_Language::_get(589); }
$results[] = array(
'result_url' => $result_url,
'result_icon' => './images/icons/poll_poll48.gif',
'result_name' => $result_name,
'result_name_1' => $poll_info['poll_title'],
'time' => $poll_info['poll_datecreated'],
'result_desc' => $result_desc,
'result_desc_1' => $url->url_create('profile', $profile->user_info['user_username']),
'result_desc_2' => $profile->user_displayname,
'result_desc_3' => $poll_info['poll_desc'],
);
}
// SET TOTAL RESULTS
$total_results = $total_polls;
}
// SET ARRAY VALUES
SE_Language::_preload_multi(2500111, 2500112, 2500113);
if($total_polls > 200) { $total_polls = "200+"; }
$search_objects[] = array(
'search_type' => 'poll',
'search_lang' => 2500111,
'search_total' => $total_polls
);
}
// END search_poll() FUNCTION
// THIS FUNCTION IS RUN WHEN A USER IS DELETED
// INPUT: $user_id REPRESENTING THE USER ID OF THE USER BEING DELETED
// OUTPUT:
function deleteuser_poll($user_id)
{
global $database;
// DELETE poll ENTRIES AND COMMENTS
$database->database_query("DELETE FROM se_polls, se_pollcomments USING se_polls LEFT JOIN se_pollcomments ON se_polls.poll_id=se_pollcomments.pollcomment_poll_id WHERE se_polls.poll_user_id='$user_id'");
// DELETE COMMENTS POSTED BY USER
$database->database_query("DELETE FROM se_pollcomments WHERE pollcomment_authoruser_id='$user_id'");
}
// END deleteuser_poll() FUNCTION
// THIS FUNCTION IS RUN WHEN GENERATING SITE STATISTICS
// INPUT:
// OUTPUT:
function site_statistics_poll(&$args)
{
global $database;
$statistics =& $args['statistics'];
// NOTE: CACHING WILL BE HANDLED BY THE FUNCTION THAT CALLS THIS
$total = $database->database_fetch_assoc($database->database_query("SELECT COUNT(poll_id) AS total FROM se_polls"));
$statistics['polls'] = array(
'title' => 2500128,
'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 )
);
/*
$total = $database->database_fetch_assoc($database->database_query("SELECT COUNT(pollcomment_id) AS total FROM se_pollcomments"));
$statistics['pollcomments'] = array(
'title' => 2500129,
'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 )
);
$total = $database->database_fetch_assoc($database->database_query("SELECT SUM(poll_totalvotes) AS total FROM se_polls"));
$statistics['pollvotes'] = array(
'title' => 2500130,
'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 )
);
*/
}
// END site_statistics_poll() FUNCTION
?>