Menu
▾
▴
[Devil-linux-commit] web/poll/include class_input2db.php,1.1.1.1,1.2 class_mysql.php,1.1.1.1,1.2 class_pgfx.php,1.1.1.1,1.2 class_pgsql.php,1.1.1.1,1.2 class_plist.php,1.1.1.1,1.2 class_poll.php,1.1.1.1,1.2 class_session.php,1.1.1.1,1.2 class_template.php,1.1.1.1,1.2
|
From: Heiko Z. <smi...@us...> - 2004-09-18 16:00:51
|
Update of /cvsroot/devil-linux/web/poll/include In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv20723/poll/include Modified Files: class_input2db.php class_mysql.php class_pgfx.php class_pgsql.php class_plist.php class_poll.php class_session.php class_template.php Log Message: updated advanced poll to v2.03 didn't go through the dos2unix hassle this time, it seems to work just fine Index: class_plist.php =================================================================== RCS file: /cvsroot/devil-linux/web/poll/include/class_plist.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- class_plist.php 2 Jun 2004 13:05:52 -0000 1.1.1.1 +++ class_plist.php 18 Sep 2004 16:00:41 -0000 1.2 @@ -1,120 +1,120 @@ -<?php -/** - * ---------------------------------------------- - * Advanced Poll 2.0.3 (PHP/MySQL) - * Copyright (c)2001 Chi Kien Uong - * URL: http://www.proxy2.de - * ---------------------------------------------- - */ - -class plist extends pollcomment { - - var $poll_list_html; - var $plist_data; - var $list_index; - var $list_page_html; - var $poll_records; - - function plist() { - global $HTTP_GET_VARS, $HTTP_POST_VARS; - $this->poll_list_html = array(); - $this->plist_data = array(); - $this->list_page_html = ''; - $this->poll_records = ''; - $this->list_index = (isset($HTTP_GET_VARS['l_page'])) ? trim($HTTP_GET_VARS['l_page']) : 0; - $this->list_index = (isset($HTTP_POST_VARS['l_page'])) ? trim($HTTP_POST_VARS['l_page']) : $this->list_index; - if (empty($this->list_index) || $this->list_index<0) { - $this->list_index = 0; - } - $this->pollcomment(); - } - - function get_poll_list() { - if (sizeof($this->plist_data)<1) { - $record = ($this->poll_records>0) ? $this->poll_records : $this->pollvars['polls_pp']; - $this->db->query("SELECT * FROM ".$this->tbl['poll_index']." WHERE (status < '2') ORDER BY poll_id DESC LIMIT ".$this->list_index.",$record"); - $total_polls = $this->db->num_rows($this->db->result); - if ($total_polls>0) { - for ($i=0; $i<$record; $i++) { - if ($this->db->fetch_array($this->db->result)) { - $poll_id_arr[] = $this->db->record['poll_id']; - $question_arr[] = $this->db->record['question']; - $timestamp_arr[] = $this->db->record['timestamp']; - $exp_time_arr[] = $this->db->record['exp_time']; - $expire_arr[] = $this->db->record['expire']; - $comments_arr[] = $this->db->record['comments']; - } else { - break; - } - } - $this->plist_data['poll_id'] = $poll_id_arr; - $this->plist_data['question'] = $question_arr; - $this->plist_data['timestamp'] = $timestamp_arr; - $this->plist_data['exp_time'] = $exp_time_arr; - $this->plist_data['expire'] = $expire_arr; - $this->plist_data['comments'] = $comments_arr; - } else { - $this->plist_data = array(); - } - } - return $this->plist_data; - } - - function view_poll_list() { - global $HTTP_SERVER_VARS; - $PHP_SELF = $HTTP_SERVER_VARS['PHP_SELF']; - if (!isset($this->poll_list_html[$this->comment_tpl])) { - $row = $this->db->fetch_array($this->db->query("SELECT template FROM ".$this->tbl['poll_tpl']." WHERE (title = '".$this->comment_tpl."' and tplset_id='0')")); - $row['template'] = ereg_replace("\"", "\\\"", $row['template']); - $list_html = ''; - if (sizeof($this->plist_data<1)) { - $this->get_poll_list(); - } - if (sizeof($this->plist_data>0)) { - for ($i=0;$i<sizeof($this->plist_data['poll_id']);$i++) { - $data['timestamp'] = date($this->date_format,$this->plist_data['timestamp'][$i]+$this->pollvars['time_offset']*3600); - $data['exp_time'] = date($this->date_format,$this->plist_data['exp_time'][$i]+$this->pollvars['time_offset']*3600); - $data['poll_id'] = $this->plist_data['poll_id'][$i]; - $data['question'] = $this->plist_data['question'][$i]; - $data['comments'] = $this->plist_data['comments'][$i]; - $data['expire'] = $this->plist_data['expire'][$i]; - eval("\$list_html .= \"$row[template]\";"); - } - $this->poll_list_html[$this->comment_tpl] = $list_html; - } else { - $this->poll_list_html[$this->comment_tpl] = ''; - } - } - return $this->poll_list_html[$this->comment_tpl]; - } - - function set_polls_per_page($records) { - if (is_integer($records) && $records>0) { - $this->poll_records = $records; - return true; - } else { - return false; - } - } - - function get_total_polls() { - $this->db->fetch_array($this->db->query("SELECT COUNT(*) AS total FROM ".$this->tbl['poll_index']." WHERE (status < '2')")); - return $this->db->record["total"]; - } - - function get_list_pages($max_pages=10, $separate=" | ") { - if (empty($this->list_page_html)) { - $record = ($this->poll_records>0) ? $this->poll_records : $this->pollvars['polls_pp']; - $total_polls = $this->get_total_polls(); - if ($total_polls>0) { - $this->list_page_html = $this->get_pages($total_polls, $this->list_index, $record, "l_page", $max_pages, $separate); - } else { - $this->list_page_html = ''; - } - } - return $this->list_page_html; - } - -} - +<?php +/** + * ---------------------------------------------- + * Advanced Poll 2.0.3 (PHP/MySQL) + * Copyright (c)2001 Chi Kien Uong + * URL: http://www.proxy2.de + * ---------------------------------------------- + */ + +class plist extends pollcomment { + + var $poll_list_html; + var $plist_data; + var $list_index; + var $list_page_html; + var $poll_records; + + function plist() { + global $HTTP_GET_VARS, $HTTP_POST_VARS; + $this->poll_list_html = array(); + $this->plist_data = array(); + $this->list_page_html = ''; + $this->poll_records = ''; + $this->list_index = (isset($HTTP_GET_VARS['l_page'])) ? trim($HTTP_GET_VARS['l_page']) : 0; + $this->list_index = (isset($HTTP_POST_VARS['l_page'])) ? trim($HTTP_POST_VARS['l_page']) : $this->list_index; + if (empty($this->list_index) || $this->list_index<0) { + $this->list_index = 0; + } + $this->pollcomment(); + } + + function get_poll_list() { + if (sizeof($this->plist_data)<1) { + $record = ($this->poll_records>0) ? $this->poll_records : $this->pollvars['polls_pp']; + $this->db->query("SELECT * FROM ".$this->tbl['poll_index']." WHERE (status < '2') ORDER BY poll_id DESC LIMIT ".$this->list_index.",$record"); + $total_polls = $this->db->num_rows($this->db->result); + if ($total_polls>0) { + for ($i=0; $i<$record; $i++) { + if ($this->db->fetch_array($this->db->result)) { + $poll_id_arr[] = $this->db->record['poll_id']; + $question_arr[] = $this->db->record['question']; + $timestamp_arr[] = $this->db->record['timestamp']; + $exp_time_arr[] = $this->db->record['exp_time']; + $expire_arr[] = $this->db->record['expire']; + $comments_arr[] = $this->db->record['comments']; + } else { + break; + } + } + $this->plist_data['poll_id'] = $poll_id_arr; + $this->plist_data['question'] = $question_arr; + $this->plist_data['timestamp'] = $timestamp_arr; + $this->plist_data['exp_time'] = $exp_time_arr; + $this->plist_data['expire'] = $expire_arr; + $this->plist_data['comments'] = $comments_arr; + } else { + $this->plist_data = array(); + } + } + return $this->plist_data; + } + + function view_poll_list() { + global $HTTP_SERVER_VARS; + $PHP_SELF = $HTTP_SERVER_VARS['PHP_SELF']; + if (!isset($this->poll_list_html[$this->comment_tpl])) { + $row = $this->db->fetch_array($this->db->query("SELECT template FROM ".$this->tbl['poll_tpl']." WHERE (title = '".$this->comment_tpl."' and tplset_id='0')")); + $row['template'] = ereg_replace("\"", "\\\"", $row['template']); + $list_html = ''; + if (sizeof($this->plist_data<1)) { + $this->get_poll_list(); + } + if (sizeof($this->plist_data>0)) { + for ($i=0;$i<sizeof($this->plist_data['poll_id']);$i++) { + $data['timestamp'] = date($this->date_format,$this->plist_data['timestamp'][$i]+$this->pollvars['time_offset']*3600); + $data['exp_time'] = date($this->date_format,$this->plist_data['exp_time'][$i]+$this->pollvars['time_offset']*3600); + $data['poll_id'] = $this->plist_data['poll_id'][$i]; + $data['question'] = $this->plist_data['question'][$i]; + $data['comments'] = $this->plist_data['comments'][$i]; + $data['expire'] = $this->plist_data['expire'][$i]; + eval("\$list_html .= \"$row[template]\";"); + } + $this->poll_list_html[$this->comment_tpl] = $list_html; + } else { + $this->poll_list_html[$this->comment_tpl] = ''; + } + } + return $this->poll_list_html[$this->comment_tpl]; + } + + function set_polls_per_page($records) { + if (is_integer($records) && $records>0) { + $this->poll_records = $records; + return true; + } else { + return false; + } + } + + function get_total_polls() { + $this->db->fetch_array($this->db->query("SELECT COUNT(*) AS total FROM ".$this->tbl['poll_index']." WHERE (status < '2')")); + return $this->db->record["total"]; + } + + function get_list_pages($max_pages=10, $separate=" | ") { + if (empty($this->list_page_html)) { + $record = ($this->poll_records>0) ? $this->poll_records : $this->pollvars['polls_pp']; + $total_polls = $this->get_total_polls(); + if ($total_polls>0) { + $this->list_page_html = $this->get_pages($total_polls, $this->list_index, $record, "l_page", $max_pages, $separate); + } else { + $this->list_page_html = ''; + } + } + return $this->list_page_html; + } + +} + ?> \ No newline at end of file Index: class_mysql.php =================================================================== RCS file: /cvsroot/devil-linux/web/poll/include/class_mysql.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- class_mysql.php 2 Jun 2004 13:05:52 -0000 1.1.1.1 +++ class_mysql.php 18 Sep 2004 16:00:41 -0000 1.2 @@ -1,101 +1,101 @@ -<?php -/** - * ---------------------------------------------- - * Advanced Poll 2.0.3 (PHP/MySQL) - * Copyright (c)2001 Chi Kien Uong - * URL: http://www.proxy2.de - * ---------------------------------------------- - */ - -class polldb_sql { - - var $conn_id; - var $result; - var $record; - var $db; - var $port; - var $query_count; - - function polldb_sql() { - global $POLLDB; - $this->query_count=0; - $this->db = $POLLDB; - if(ereg(":",$this->db['host'])) { - list($host,$port) = explode(":",$this->db['host']); - $this->port = $port; - } else { - $this->port = 3306; - } - } - - function connect() { - $this->conn_id = mysql_connect($this->db['host'].":".$this->port,$this->db['user'],$this->db['pass']); - if ($this->conn_id == 0) { - $this->sql_error("Connection Error"); - } - if (!mysql_select_db($this->db['dbName'], $this->conn_id)) { - $this->sql_error("Database Error"); - } - return $this->conn_id; - } - - function query($query_string) { - $this->result = mysql_query($query_string,$this->conn_id); - $this->query_count++; - if (!$this->result) { - $this->sql_error("Query Error"); - } - return $this->result; - } - - function fetch_array($query_id) { - $this->record = mysql_fetch_array($query_id,MYSQL_ASSOC); - return $this->record; - } - - function num_rows($query_id) { - return ($query_id) ? mysql_num_rows($query_id) : 0; - } - - function num_fields($query_id) { - return ($query_id) ? mysql_num_fields($query_id) : 0; - } - - function free_result($query_id) { - return mysql_free_result($query_id); - } - - function affected_rows() { - return mysql_affected_rows($this->conn_id); - } - - function close_db() { - if($this->conn_id) { - return mysql_close($this->conn_id); - } else { - return false; - } - } - - function sql_error($message) { - $description = mysql_error(); - $number = mysql_errno(); - $error ="MySQL Error : $message\n"; - $error.="Error Number: $number $description\n"; - $error.="Date : ".date("D, F j, Y H:i:s")."\n"; - $error.="IP : ".getenv("REMOTE_ADDR")."\n"; - $error.="Browser : ".getenv("HTTP_USER_AGENT")."\n"; - $error.="Referer : ".getenv("HTTP_REFERER")."\n"; - $error.="PHP Version : ".PHP_VERSION."\n"; - $error.="OS : ".PHP_OS."\n"; - $error.="Server : ".getenv("SERVER_SOFTWARE")."\n"; - $error.="Server Name : ".getenv("SERVER_NAME")."\n"; - $error.="Script Name : ".getenv("SCRIPT_NAME")."\n"; - echo "<b><font size=4 face=Arial>$message</font></b><hr>"; - echo "<pre>$error</pre>"; - exit(); - } - -} - +<?php +/** + * ---------------------------------------------- + * Advanced Poll 2.0.3 (PHP/MySQL) + * Copyright (c)2001 Chi Kien Uong + * URL: http://www.proxy2.de + * ---------------------------------------------- + */ + +class polldb_sql { + + var $conn_id; + var $result; + var $record; + var $db; + var $port; + var $query_count; + + function polldb_sql() { + global $POLLDB; + $this->query_count=0; + $this->db = $POLLDB; + if(ereg(":",$this->db['host'])) { + list($host,$port) = explode(":",$this->db['host']); + $this->port = $port; + } else { + $this->port = 3306; + } + } + + function connect() { + $this->conn_id = mysql_connect($this->db['host'].":".$this->port,$this->db['user'],$this->db['pass']); + if ($this->conn_id == 0) { + $this->sql_error("Connection Error"); + } + if (!mysql_select_db($this->db['dbName'], $this->conn_id)) { + $this->sql_error("Database Error"); + } + return $this->conn_id; + } + + function query($query_string) { + $this->result = mysql_query($query_string,$this->conn_id); + $this->query_count++; + if (!$this->result) { + $this->sql_error("Query Error"); + } + return $this->result; + } + + function fetch_array($query_id) { + $this->record = mysql_fetch_array($query_id,MYSQL_ASSOC); + return $this->record; + } + + function num_rows($query_id) { + return ($query_id) ? mysql_num_rows($query_id) : 0; + } + + function num_fields($query_id) { + return ($query_id) ? mysql_num_fields($query_id) : 0; + } + + function free_result($query_id) { + return mysql_free_result($query_id); + } + + function affected_rows() { + return mysql_affected_rows($this->conn_id); + } + + function close_db() { + if($this->conn_id) { + return mysql_close($this->conn_id); + } else { + return false; + } + } + + function sql_error($message) { + $description = mysql_error(); + $number = mysql_errno(); + $error ="MySQL Error : $message\n"; + $error.="Error Number: $number $description\n"; + $error.="Date : ".date("D, F j, Y H:i:s")."\n"; + $error.="IP : ".getenv("REMOTE_ADDR")."\n"; + $error.="Browser : ".getenv("HTTP_USER_AGENT")."\n"; + $error.="Referer : ".getenv("HTTP_REFERER")."\n"; + $error.="PHP Version : ".PHP_VERSION."\n"; + $error.="OS : ".PHP_OS."\n"; + $error.="Server : ".getenv("SERVER_SOFTWARE")."\n"; + $error.="Server Name : ".getenv("SERVER_NAME")."\n"; + $error.="Script Name : ".getenv("SCRIPT_NAME")."\n"; + echo "<b><font size=4 face=Arial>$message</font></b><hr>"; + echo "<pre>$error</pre>"; + exit(); + } + +} + ?> \ No newline at end of file Index: class_pgsql.php =================================================================== RCS file: /cvsroot/devil-linux/web/poll/include/class_pgsql.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- class_pgsql.php 2 Jun 2004 13:05:52 -0000 1.1.1.1 +++ class_pgsql.php 18 Sep 2004 16:00:41 -0000 1.2 @@ -1,124 +1,124 @@ -<?php -/** - * ---------------------------------------------- - * Advanced Poll 2.0.3 (PHP/MySQL) - * Copyright (c)2001 Chi Kien Uong - * URL: http://www.proxy2.de - * ---------------------------------------------- - */ - -class polldb_sql { - - var $conn_id; - var $result; - var $record; - var $db; - var $row; - var $end_row; - var $port; - - function polldb_sql() { - global $POLLDB; - $this->db = $POLLDB; - $this->row = array(); - $this->end_row = array(); - if(ereg(":",$this->db['host'])) { - list($host,$port) = explode(":",$this->db['host']); - $this->port = $port; - } else { - $this->port = 5432; - } - } - - function connect() { - $pg_connect_str = ""; - if($this->db['user']) { - $pg_connect_str .= "user=".$this->db['user']." "; - } - if($this->db['pass']) { - $pg_connect_str .= "password=".$this->db['pass']." "; - } - if($this->db['host'] != "localhost") { - $pg_connect_str .= "host=".$this->db['host']." "; - } - $pg_connect_str .= "port=$this->port "; - $pg_connect_str .= "dbname=".$this->db['dbName']." "; - $this->conn_id = pg_connect($pg_connect_str); - if (!$this->conn_id) { - $this->sql_error("Connection Error"); - } - return $this->conn_id; - } - - function query($query_strg) { - $query_strg = eregi_replace("limit ([0-9]+),([ 0-9]+)", "limit \\2, \\1", $query_strg); - $this->result = pg_exec($this->conn_id,$query_strg); - if (!$this->result) { - $this->sql_error("Query Error"); - } - return $this->result; - } - - function fetch_array($query_id) { - if (!isset($this->row[$query_id])) { - $this->row[$query_id] = 0; - $this->end_row[$query_id] = $this->num_rows($query_id); - } - if ($this->end_row[$query_id] > $this->row[$query_id]) { - $this->record = pg_fetch_array($query_id,$this->row[$query_id],PGSQL_ASSOC); - $this->row[$query_id] ++; - return $this->record; - } else { - unset($this->row[$query_id]); - $this->record = false; - return $this->record; - } - } - - function num_rows($query_id) { - return ($query_id) ? pg_NumRows($query_id) : 0; - } - - function num_fields($query_id) { - return ($query_id) ? pg_NumFields($query_id) : 0; - } - - function free_result($query_id) { - return pg_FreeResult($query_id); - } - - function affected_rows($query_id='') { - if (empty($query_id)) { - $query_id = $this->result; - } - return pg_cmdTuples($query_id); - } - - function close_db() { - if($this->conn_id) { - return pg_close($this->conn_id); - } else { - return false; - } - } - - function sql_error($message) { - $description = pg_errormessage(); - $error ="MySQL Error : $message\n"; - $error.="Message : $description\n"; - $error.="Date : ".date("D, F j, Y H:i:s")."\n"; - $error.="IP : ".getenv("REMOTE_ADDR")."\n"; - $error.="Browser : ".getenv("HTTP_USER_AGENT")."\n"; - $error.="Referer : ".getenv("HTTP_REFERER")."\n"; - $error.="PHP Version : ".PHP_VERSION."\n"; - $error.="OS : ".PHP_OS."\n"; - $error.="Server : ".getenv("SERVER_SOFTWARE")."\n"; - $error.="Server Name : ".getenv("SERVER_NAME")."\n"; - echo "<b><font size=4 face=Arial>$message</font></b><hr>"; - echo "<pre>$error</pre>"; - exit(); - } - -} - +<?php +/** + * ---------------------------------------------- + * Advanced Poll 2.0.3 (PHP/MySQL) + * Copyright (c)2001 Chi Kien Uong + * URL: http://www.proxy2.de + * ---------------------------------------------- + */ + +class polldb_sql { + + var $conn_id; + var $result; + var $record; + var $db; + var $row; + var $end_row; + var $port; + + function polldb_sql() { + global $POLLDB; + $this->db = $POLLDB; + $this->row = array(); + $this->end_row = array(); + if(ereg(":",$this->db['host'])) { + list($host,$port) = explode(":",$this->db['host']); + $this->port = $port; + } else { + $this->port = 5432; + } + } + + function connect() { + $pg_connect_str = ""; + if($this->db['user']) { + $pg_connect_str .= "user=".$this->db['user']." "; + } + if($this->db['pass']) { + $pg_connect_str .= "password=".$this->db['pass']." "; + } + if($this->db['host'] != "localhost") { + $pg_connect_str .= "host=".$this->db['host']." "; + } + $pg_connect_str .= "port=$this->port "; + $pg_connect_str .= "dbname=".$this->db['dbName']." "; + $this->conn_id = pg_connect($pg_connect_str); + if (!$this->conn_id) { + $this->sql_error("Connection Error"); + } + return $this->conn_id; + } + + function query($query_strg) { + $query_strg = eregi_replace("limit ([0-9]+),([ 0-9]+)", "limit \\2, \\1", $query_strg); + $this->result = pg_exec($this->conn_id,$query_strg); + if (!$this->result) { + $this->sql_error("Query Error"); + } + return $this->result; + } + + function fetch_array($query_id) { + if (!isset($this->row[$query_id])) { + $this->row[$query_id] = 0; + $this->end_row[$query_id] = $this->num_rows($query_id); + } + if ($this->end_row[$query_id] > $this->row[$query_id]) { + $this->record = pg_fetch_array($query_id,$this->row[$query_id],PGSQL_ASSOC); + $this->row[$query_id] ++; + return $this->record; + } else { + unset($this->row[$query_id]); + $this->record = false; + return $this->record; + } + } + + function num_rows($query_id) { + return ($query_id) ? pg_NumRows($query_id) : 0; + } + + function num_fields($query_id) { + return ($query_id) ? pg_NumFields($query_id) : 0; + } + + function free_result($query_id) { + return pg_FreeResult($query_id); + } + + function affected_rows($query_id='') { + if (empty($query_id)) { + $query_id = $this->result; + } + return pg_cmdTuples($query_id); + } + + function close_db() { + if($this->conn_id) { + return pg_close($this->conn_id); + } else { + return false; + } + } + + function sql_error($message) { + $description = pg_errormessage(); + $error ="MySQL Error : $message\n"; + $error.="Message : $description\n"; + $error.="Date : ".date("D, F j, Y H:i:s")."\n"; + $error.="IP : ".getenv("REMOTE_ADDR")."\n"; + $error.="Browser : ".getenv("HTTP_USER_AGENT")."\n"; + $error.="Referer : ".getenv("HTTP_REFERER")."\n"; + $error.="PHP Version : ".PHP_VERSION."\n"; + $error.="OS : ".PHP_OS."\n"; + $error.="Server : ".getenv("SERVER_SOFTWARE")."\n"; + $error.="Server Name : ".getenv("SERVER_NAME")."\n"; + echo "<b><font size=4 face=Arial>$message</font></b><hr>"; + echo "<pre>$error</pre>"; + exit(); + } + +} + ?> \ No newline at end of file Index: class_poll.php =================================================================== RCS file: /cvsroot/devil-linux/web/poll/include/class_poll.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- class_poll.php 2 Jun 2004 13:05:52 -0000 1.1.1.1 +++ class_poll.php 18 Sep 2004 16:00:41 -0000 1.2 @@ -1,365 +1,365 @@ -<?php -/** - * ---------------------------------------------- - * Advanced Poll 2.0.3 (PHP/MySQL) - * Copyright (c)2001 Chi Kien Uong - * URL: http://www.proxy2.de - * ---------------------------------------------- - */ - -class poll { - - var $db; - var $tbl; - var $pollvars; - var $poll_view_html; - var $poll_result_html; - var $options; - var $options_text; - var $poll_question; - var $form_forward; - var $template_set; - var $ip; - - function poll() { - global $POLLTBL, $CLASS, $HTTP_SERVER_VARS; - $this->tbl = $POLLTBL; - $this->poll_view_html = array(); - $this->poll_result_html = array(); - $this->options = array(); - $this->options_text = array(); - $this->poll_question = array(); - $this->form_forward = ''; - $this->template_set = ''; - - if (isset($HTTP_SERVER_VARS['HTTP_X_FORWARDED_FOR']) && eregi("^[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}$",$HTTP_SERVER_VARS['HTTP_X_FORWARDED_FOR'])) { - $this->ip = $HTTP_SERVER_VARS['HTTP_X_FORWARDED_FOR']; - } else { - $this->ip = getenv("REMOTE_ADDR"); - } - $this->db = $CLASS["db"]; - $this->pollvars = $this->db->fetch_array($this->db->query("SELECT * FROM ".$this->tbl['poll_config'])); - $this->template_set = "default"; - $this->form_forward = basename($HTTP_SERVER_VARS['PHP_SELF']); - if ($this->pollvars['result_order'] == "asc") { - $this->pollvars['result_order'] = "ORDER BY votes ASC"; - } elseif ($this->pollvars['result_order'] == "desc") { - $this->pollvars['result_order'] = "ORDER BY votes DESC"; - } else { - $this->pollvars['result_order'] = ''; - } - } - - function set_template_set($template_set='') { - if (!empty($template_set)) { - $this->db->fetch_array($this->db->query("SELECT * FROM ".$this->tbl['poll_tplset']." WHERE tplset_name='$template_set'")); - if ($this->db->record) { - $this->template_set = $template_set; - } else { - $this->template_set = "default"; - } - } else { - $this->template_set = "default"; - } - return $this->template_set; - } - - function set_display_order($order='') { - switch ($order) { - case "asc": - $this->pollvars['result_order'] = "ORDER BY votes ASC"; - break; - case "desc": - $this->pollvars['result_order'] = "ORDER BY votes DESC"; - break; - default: - $this->pollvars['result_order'] = ""; - return false; - } - return true; - } - - function set_display_result($result='') { - switch ($result) { - case "votes": - $this->pollvars['type'] = "votes"; - break; - case "percent": - $this->pollvars['type'] = "percent"; - break; - default: - return false; - } - return true; - } - - function set_max_bar_length($max_bar_length='') { - if ($max_bar_length && $max_bar_length>0) { - $this->pollvars['img_length'] = $max_bar_length; - return true; - } else { - return false; - } - } - - function set_max_bar_height($max_bar_height='') { - if ($max_bar_height && $max_bar_height>0) { - $this->pollvars['img_height'] = $max_bar_height; - return true; - } else { - return false; - } - } - - function get_poll_tpl($tpl) { - $this->db->fetch_array($this->db->query("SELECT x.*, y.* from ".$this->tbl['poll_tplset']." x, ".$this->tbl['poll_tpl']." y where x.tplset_name='$this->template_set' and x.tplset_id=y.tplset_id AND y.title='$tpl'")); - if ($this->db->record['template']) { - $this->db->record['template'] = ereg_replace("\"", "\\\"", $this->db->record['template']); - return $this->db->record['template']; - } else { - return false; - } - } - - function get_poll_data($poll_id) { - if (!isset($this->options[$poll_id])) { - $this->db->query("SELECT SUM(votes) as total FROM ".$this->tbl['poll_data']." WHERE (poll_id = '$poll_id')"); - $this->db->fetch_array($this->db->result); - $this->options[$poll_id]['total'] = $this->db->record['total']; - $this->db->query("SELECT * FROM ".$this->tbl['poll_data']." WHERE (poll_id = '$poll_id') ".$this->pollvars['result_order']); - while ($this->db->fetch_array($this->db->result)) { - $option_id_arr[] = $this->db->record['option_id']; - $option_text_arr[] = $this->db->record['option_text']; - $option_votes_arr[] = $this->db->record['votes']; - $option_color_arr[] = $this->db->record['color']; - } - $this->options[$poll_id]['option_id'] = $option_id_arr; - $this->options[$poll_id]['option_text'] = $option_text_arr; - $this->options[$poll_id]['votes'] = $option_votes_arr; - $this->options[$poll_id]['color'] = $option_color_arr; - for ($i=0,$maxvote=0; $i<sizeof($option_votes_arr); $i++) { - $maxvote = ($option_votes_arr[$i]>$maxvote) ? $option_votes_arr[$i] : $maxvote; - } - $this->options[$poll_id]['maxvote'] = $maxvote; - } - return $this->options[$poll_id]; - } - - function get_poll_option($poll_id) { - if (!isset($this->options_text[$poll_id])) { - $query = $this->db->query("SELECT option_id, option_text FROM ".$this->tbl['poll_data']." WHERE (poll_id = '$poll_id') order by option_id asc"); - while ($data = $this->db->fetch_array($query)) { - $option_id_arr[] = $this->db->record['option_id']; - $option_text_arr[] = $this->db->record['option_text']; - } - $this->options_text[$poll_id]['option_id'] = $option_id_arr; - $this->options_text[$poll_id]['option_text'] = $option_text_arr; - } - return $this->options_text[$poll_id]; - } - - function get_poll_question($poll_id) { - if (!isset($this->poll_question[$poll_id])) { - $row = $this->db->fetch_array($this->db->query("SELECT question FROM ".$this->tbl['poll_index']." WHERE (poll_id = '$poll_id')")); - $this->poll_question[$poll_id] = htmlspecialchars($row['question']); - } - return $this->poll_question[$poll_id]; - } - - function display_poll($poll_id) { - if (!isset($this->poll_view_html[$poll_id]) || !isset($this->poll_view_html[$poll_id][$this->template_set])) { - $pollvars = $this->pollvars; - if (!isset($this->options_text[$poll_id])) { - $this->get_poll_option($poll_id); - } - $question = $this->get_poll_question($poll_id); - eval("\$display_html = \"".$this->get_poll_tpl("display_head")."\";"); - $loop_html = $this->get_poll_tpl("display_loop"); - for ($i=0;$i<sizeof($this->options_text[$poll_id]['option_id']);$i++) { - $data['option_text'] = $this->options_text[$poll_id]['option_text'][$i]; - $data['option_id'] = $this->options_text[$poll_id]['option_id'][$i]; - eval("\$display_html .= \"$loop_html\";"); - } - eval("\$display_html .= \"".$this->get_poll_tpl("display_foot")."\";"); - $this->poll_view_html[$poll_id][$this->template_set] = $display_html; - } - return $this->poll_view_html[$poll_id][$this->template_set]; - } - - function view_poll_result($poll_id,$vote_stat=0) { - if (!isset($this->poll_result_html[$poll_id]) || !isset($this->poll_result_html[$poll_id][$this->template_set])) { - $pollvars = $this->pollvars; - $row = $this->db->fetch_array($this->db->query("SELECT * FROM ".$this->tbl['poll_index']." WHERE (poll_id = '$poll_id')")); - $question = $row['question']; - $VOTE = ($vote_stat==1) ? $this->pollvars['voted'] : ''; - $COMMENT = ($row['comments']==1) ? "<a href=\"javascript:void(window.open('$pollvars[base_url]/comments.php?action=send&id=$poll_id&template_set=$this->template_set','$poll_id','width=230,height=320,toolbar=no,statusbar=no'))\">".$this->pollvars['send_com']."</a>" : ''; - eval("\$result_html = \"".$this->get_poll_tpl("result_head")."\";"); - $i=0; - $loop_html = $this->get_poll_tpl("result_loop"); - if (!isset($this->options[$poll_id])) { - $this->get_poll_data($poll_id); - } - $maxvote = ($this->options[$poll_id]['maxvote'] == 0) ? 1 : $this->options[$poll_id]['maxvote']; - $totalvotes = ($this->options[$poll_id]['total'] == 0) ? 1 : $this->options[$poll_id]['total']; - for ($i=0;$i<sizeof($this->options[$poll_id]['option_id']);$i++) { - $img_width = (int) ($this->options[$poll_id]['votes'][$i]*$this->pollvars['img_length']/$maxvote); - $vote_count = $this->options[$poll_id]['votes'][$i]; - $vote_percent = sprintf("%.2f",($this->options[$poll_id]['votes'][$i]*100/$totalvotes)); - $vote_val = ($this->pollvars['type'] == "percent") ? sprintf("%.1f",($this->options[$poll_id]['votes'][$i]*100/$totalvotes))."%" : $vote_count; - $option_text = $this->options[$poll_id]['option_text'][$i]; - $option_votes = $this->options[$poll_id]['votes'][$i]; - $poll_color = $this->options[$poll_id]['color'][$i]; - eval("\$result_html .= \"$loop_html\";"); - } - $total_votes = $this->options[$poll_id]['total']; - eval("\$result_html .= \"".$this->get_poll_tpl("result_foot")."\";"); - $this->poll_result_html[$poll_id][$this->template_set] = $result_html; - } - return $this->poll_result_html[$poll_id][$this->template_set]; - } - - function update_poll($poll_id,$option_id) { - $this->db->query("UPDATE ".$this->tbl['poll_data']." SET votes=votes+1 WHERE (poll_id='$poll_id') AND (option_id='$option_id')"); - $row = $this->db->fetch_array($this->db->query("SELECT logging as logging FROM ".$this->tbl['poll_index']." WHERE (poll_id = '$poll_id')")); - $timestamp = time(); - if ($this->pollvars['check_ip'] == 2) { - $this->db->query("INSERT INTO ".$this->tbl['poll_ip']." (poll_id,ip_addr,timestamp) VALUES ('$poll_id','$this->ip','$timestamp')"); - } - if ($row['logging'] == 1) { - $host = @gethostbyaddr($this->ip); - $agent = getenv("HTTP_USER_AGENT"); - $this->db->query("INSERT INTO ".$this->tbl['poll_log']." (poll_id,option_id,timestamp,ip_addr,host,agent) VALUES ('$poll_id','$option_id','$timestamp','$this->ip','$host','$agent')"); - } - } - - function get_latest_poll_id() { - $this->db->query("SELECT poll_id FROM ".$this->tbl['poll_index']." WHERE (status < '2') ORDER BY TIMESTAMP DESC LIMIT 1"); - $this->db->fetch_array($this->db->result); - return (!isset($this->db->record['poll_id'])) ? 0 : $this->db->record['poll_id']; - } - - function get_random_poll_id() { - $timestamp = time(); - $this->db->query("SELECT poll_id FROM ".$this->tbl['poll_index']." WHERE (status=1 AND exp_time>$timestamp) OR (status=1 AND expire=0)"); - while ($this->db->fetch_array($this->db->result)) { - $poll_id_arr[] = $this->db->record['poll_id']; - } - if (!isset($poll_id_arr)) { - return 0; - } - $available = sizeof($poll_id_arr)-1; - srand((double) microtime() * 1000000); - $random_id = ($available>0) ? rand(0,$available) : 0; - return $poll_id_arr[$random_id]; - } - - function is_active_poll_id($poll_id) { - $this->db->fetch_array($this->db->query("SELECT * FROM ".$this->tbl['poll_index']." WHERE (poll_id='$poll_id' AND status=1)")); - if (!$this->db->record) { - return false; - } elseif ($this->db->record['expire']==0) { - return true; - } - return ($this->db->record['exp_time']<time()) ? false : true; - } - - function is_valid_poll_id($poll_id) { - if ($poll_id>0) { - $this->db->fetch_array($this->db->query("SELECT poll_id FROM ".$this->tbl['poll_index']." WHERE poll_id=$poll_id AND status<'2'")); - return ($this->db->record['poll_id']) ? true : false; - } else { - return false; - } - } - - function has_voted($poll_id) { - global $HTTP_COOKIE_VARS; - $pollcookie = "AdvancedPoll".$poll_id; - if (isset($HTTP_COOKIE_VARS[$pollcookie])) { - return true; - } - if ($this->pollvars['check_ip']==2) { - $today = time()-$this->pollvars['lock_timeout']*3600; - $this->db->query("DELETE FROM ".$this->tbl['poll_ip']." WHERE (timestamp < $today)"); - $this->db->fetch_array($this->db->query("SELECT * FROM ".$this->tbl['poll_ip']." WHERE (ip_addr = '$this->ip' and poll_id='$poll_id')")); - return ($this->db->record) ? true : false; - } - } - - function get_query_strg($self) { - global $HTTP_SERVER_VARS; - if (isset($HTTP_SERVER_VARS['QUERY_STRING']) && !empty($HTTP_SERVER_VARS['QUERY_STRING'])) { - if (ereg("($self=[0-9]+)",$HTTP_SERVER_VARS['QUERY_STRING'],$regs)) { - $HTTP_SERVER_VARS['QUERY_STRING'] = str_replace($regs[1], "", $HTTP_SERVER_VARS['QUERY_STRING']); - } - $HTTP_SERVER_VARS['QUERY_STRING'] = str_replace("$self=", "", $HTTP_SERVER_VARS['QUERY_STRING']); - if (empty($HTTP_SERVER_VARS['QUERY_STRING'])) { - $append = $HTTP_SERVER_VARS['PHP_SELF']."?"; - } else { - $query_vars = explode("&",$HTTP_SERVER_VARS['QUERY_STRING']); - $append = $HTTP_SERVER_VARS['PHP_SELF']."?"; - for ($i=0; $i<sizeof($query_vars); $i++) { - if (!empty($query_vars[$i])) { - $append .= $query_vars[$i]."&"; - } - } - } - } else { - $append = $HTTP_SERVER_VARS['PHP_SELF']."?"; - } - return $append; - } - - function poll_process($poll_id='') { - global $HTTP_GET_VARS, $HTTP_POST_VARS; - - $poll_ident = (isset($HTTP_POST_VARS['poll_ident'])) ? intval($HTTP_POST_VARS['poll_ident']) : ""; - if ($poll_ident == "") { - if (isset($HTTP_GET_VARS['poll_ident'])) { - $poll_ident = intval($HTTP_GET_VARS['poll_ident']); - } - } - - $option_id = (isset($HTTP_POST_VARS['option_id'])) ? intval($HTTP_POST_VARS['option_id']) : ""; - if ($option_id == "") { - if (isset($HTTP_GET_VARS['option_id'])) { - $option_id = intval($HTTP_GET_VARS['option_id']); - } - } - - $action = (isset($HTTP_POST_VARS['action'])) ? trim($HTTP_POST_VARS['action']) : ""; - if ($action == "") { - if (isset($HTTP_GET_VARS['action'])) { - $action = trim($HTTP_GET_VARS['action']); - } - } - - if ($poll_id=="random") { - $poll_id = (empty($poll_ident)) ? $this->get_random_poll_id() : $poll_ident; - } elseif ($poll_id=="newest") { - $poll_id = $this->get_latest_poll_id(); - } - if ($this->is_valid_poll_id($poll_id)) { - $voted = $this->has_voted($poll_id); - $is_active = $this->is_active_poll_id($poll_id); - if ($action=="results" && $poll_id==$poll_ident) { - return $this->view_poll_result($poll_id,0); - } elseif (!$is_active) { - return $this->view_poll_result($poll_id,0); - } elseif ($is_active && $voted) { - return $this->view_poll_result($poll_id,1); - } elseif (!$voted && isset($option_id) && $action=="vote" && $poll_id==$poll_ident) { - $this->update_poll($poll_id,$option_id); - return $this->view_poll_result($poll_id,0); - } else { - return $this->display_poll($poll_id); - } - } else { - $error = "<b>Poll ID <font color=red>$poll_id</font> does not exist.</b>"; - return $error; - } - } - -} - +<?php +/** + * ---------------------------------------------- + * Advanced Poll 2.0.3 (PHP/MySQL) + * Copyright (c)2001 Chi Kien Uong + * URL: http://www.proxy2.de + * ---------------------------------------------- + */ + +class poll { + + var $db; + var $tbl; + var $pollvars; + var $poll_view_html; + var $poll_result_html; + var $options; + var $options_text; + var $poll_question; + var $form_forward; + var $template_set; + var $ip; + + function poll() { + global $POLLTBL, $CLASS, $HTTP_SERVER_VARS; + $this->tbl = $POLLTBL; + $this->poll_view_html = array(); + $this->poll_result_html = array(); + $this->options = array(); + $this->options_text = array(); + $this->poll_question = array(); + $this->form_forward = ''; + $this->template_set = ''; + + if (isset($HTTP_SERVER_VARS['HTTP_X_FORWARDED_FOR']) && eregi("^[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}$",$HTTP_SERVER_VARS['HTTP_X_FORWARDED_FOR'])) { + $this->ip = $HTTP_SERVER_VARS['HTTP_X_FORWARDED_FOR']; + } else { + $this->ip = getenv("REMOTE_ADDR"); + } + $this->db = $CLASS["db"]; + $this->pollvars = $this->db->fetch_array($this->db->query("SELECT * FROM ".$this->tbl['poll_config'])); + $this->template_set = "default"; + $this->form_forward = basename($HTTP_SERVER_VARS['PHP_SELF']); + if ($this->pollvars['result_order'] == "asc") { + $this->pollvars['result_order'] = "ORDER BY votes ASC"; + } elseif ($this->pollvars['result_order'] == "desc") { + $this->pollvars['result_order'] = "ORDER BY votes DESC"; + } else { + $this->pollvars['result_order'] = ''; + } + } + + function set_template_set($template_set='') { + if (!empty($template_set)) { + $this->db->fetch_array($this->db->query("SELECT * FROM ".$this->tbl['poll_tplset']." WHERE tplset_name='$template_set'")); + if ($this->db->record) { + $this->template_set = $template_set; + } else { + $this->template_set = "default"; + } + } else { + $this->template_set = "default"; + } + return $this->template_set; + } + + function set_display_order($order='') { + switch ($order) { + case "asc": + $this->pollvars['result_order'] = "ORDER BY votes ASC"; + break; + case "desc": + $this->pollvars['result_order'] = "ORDER BY votes DESC"; + break; + default: + $this->pollvars['result_order'] = ""; + return false; + } + return true; + } + + function set_display_result($result='') { + switch ($result) { + case "votes": + $this->pollvars['type'] = "votes"; + break; + case "percent": + $this->pollvars['type'] = "percent"; + break; + default: + return false; + } + return true; + } + + function set_max_bar_length($max_bar_length='') { + if ($max_bar_length && $max_bar_length>0) { + $this->pollvars['img_length'] = $max_bar_length; + return true; + } else { + return false; + } + } + + function set_max_bar_height($max_bar_height='') { + if ($max_bar_height && $max_bar_height>0) { + $this->pollvars['img_height'] = $max_bar_height; + return true; + } else { + return false; + } + } + + function get_poll_tpl($tpl) { + $this->db->fetch_array($this->db->query("SELECT x.*, y.* from ".$this->tbl['poll_tplset']." x, ".$this->tbl['poll_tpl']." y where x.tplset_name='$this->template_set' and x.tplset_id=y.tplset_id AND y.title='$tpl'")); + if ($this->db->record['template']) { + $this->db->record['template'] = ereg_replace("\"", "\\\"", $this->db->record['template']); + return $this->db->record['template']; + } else { + return false; + } + } + + function get_poll_data($poll_id) { + if (!isset($this->options[$poll_id])) { + $this->db->query("SELECT SUM(votes) as total FROM ".$this->tbl['poll_data']." WHERE (poll_id = '$poll_id')"); + $this->db->fetch_array($this->db->result); + $this->options[$poll_id]['total'] = $this->db->record['total']; + $this->db->query("SELECT * FROM ".$this->tbl['poll_data']." WHERE (poll_id = '$poll_id') ".$this->pollvars['result_order']); + while ($this->db->fetch_array($this->db->result)) { + $option_id_arr[] = $this->db->record['option_id']; + $option_text_arr[] = $this->db->record['option_text']; + $option_votes_arr[] = $this->db->record['votes']; + $option_color_arr[] = $this->db->record['color']; + } + $this->options[$poll_id]['option_id'] = $option_id_arr; + $this->options[$poll_id]['option_text'] = $option_text_arr; + $this->options[$poll_id]['votes'] = $option_votes_arr; + $this->options[$poll_id]['color'] = $option_color_arr; + for ($i=0,$maxvote=0; $i<sizeof($option_votes_arr); $i++) { + $maxvote = ($option_votes_arr[$i]>$maxvote) ? $option_votes_arr[$i] : $maxvote; + } + $this->options[$poll_id]['maxvote'] = $maxvote; + } + return $this->options[$poll_id]; + } + + function get_poll_option($poll_id) { + if (!isset($this->options_text[$poll_id])) { + $query = $this->db->query("SELECT option_id, option_text FROM ".$this->tbl['poll_data']." WHERE (poll_id = '$poll_id') order by option_id asc"); + while ($data = $this->db->fetch_array($query)) { + $option_id_arr[] = $this->db->record['option_id']; + $option_text_arr[] = $this->db->record['option_text']; + } + $this->options_text[$poll_id]['option_id'] = $option_id_arr; + $this->options_text[$poll_id]['option_text'] = $option_text_arr; + } + return $this->options_text[$poll_id]; + } + + function get_poll_question($poll_id) { + if (!isset($this->poll_question[$poll_id])) { + $row = $this->db->fetch_array($this->db->query("SELECT question FROM ".$this->tbl['poll_index']." WHERE (poll_id = '$poll_id')")); + $this->poll_question[$poll_id] = htmlspecialchars($row['question']); + } + return $this->poll_question[$poll_id]; + } + + function display_poll($poll_id) { + if (!isset($this->poll_view_html[$poll_id]) || !isset($this->poll_view_html[$poll_id][$this->template_set])) { + $pollvars = $this->pollvars; + if (!isset($this->options_text[$poll_id])) { + $this->get_poll_option($poll_id); + } + $question = $this->get_poll_question($poll_id); + eval("\$display_html = \"".$this->get_poll_tpl("display_head")."\";"); + $loop_html = $this->get_poll_tpl("display_loop"); + for ($i=0;$i<sizeof($this->options_text[$poll_id]['option_id']);$i++) { + $data['option_text'] = $this->options_text[$poll_id]['option_text'][$i]; + $data['option_id'] = $this->options_text[$poll_id]['option_id'][$i]; + eval("\$display_html .= \"$loop_html\";"); + } + eval("\$display_html .= \"".$this->get_poll_tpl("display_foot")."\";"); + $this->poll_view_html[$poll_id][$this->template_set] = $display_html; + } + return $this->poll_view_html[$poll_id][$this->template_set]; + } + + function view_poll_result($poll_id,$vote_stat=0) { + if (!isset($this->poll_result_html[$poll_id]) || !isset($this->poll_result_html[$poll_id][$this->template_set])) { + $pollvars = $this->pollvars; + $row = $this->db->fetch_array($this->db->query("SELECT * FROM ".$this->tbl['poll_index']." WHERE (poll_id = '$poll_id')")); + $question = $row['question']; + $VOTE = ($vote_stat==1) ? $this->pollvars['voted'] : ''; + $COMMENT = ($row['comments']==1) ? "<a href=\"javascript:void(window.open('$pollvars[base_url]/comments.php?action=send&id=$poll_id&template_set=$this->template_set','$poll_id','width=230,height=320,toolbar=no,statusbar=no'))\">".$this->pollvars['send_com']."</a>" : ''; + eval("\$result_html = \"".$this->get_poll_tpl("result_head")."\";"); + $i=0; + $loop_html = $this->get_poll_tpl("result_loop"); + if (!isset($this->options[$poll_id])) { + $this->get_poll_data($poll_id); + } + $maxvote = ($this->options[$poll_id]['maxvote'] == 0) ? 1 : $this->options[$poll_id]['maxvote']; + $totalvotes = ($this->options[$poll_id]['total'] == 0) ? 1 : $this->options[$poll_id]['total']; + for ($i=0;$i<sizeof($this->options[$poll_id]['option_id']);$i++) { + $img_width = (int) ($this->options[$poll_id]['votes'][$i]*$this->pollvars['img_length']/$maxvote); + $vote_count = $this->options[$poll_id]['votes'][$i]; + $vote_percent = sprintf("%.2f",($this->options[$poll_id]['votes'][$i]*100/$totalvotes)); + $vote_val = ($this->pollvars['type'] == "percent") ? sprintf("%.1f",($this->options[$poll_id]['votes'][$i]*100/$totalvotes))."%" : $vote_count; + $option_text = $this->options[$poll_id]['option_text'][$i]; + $option_votes = $this->options[$poll_id]['votes'][$i]; + $poll_color = $this->options[$poll_id]['color'][$i]; + eval("\$result_html .= \"$loop_html\";"); + } + $total_votes = $this->options[$poll_id]['total']; + eval("\$result_html .= \"".$this->get_poll_tpl("result_foot")."\";"); + $this->poll_result_html[$poll_id][$this->template_set] = $result_html; + } + return $this->poll_result_html[$poll_id][$this->template_set]; + } + + function update_poll($poll_id,$option_id) { + $this->db->query("UPDATE ".$this->tbl['poll_data']." SET votes=votes+1 WHERE (poll_id='$poll_id') AND (option_id='$option_id')"); + $row = $this->db->fetch_array($this->db->query("SELECT logging as logging FROM ".$this->tbl['poll_index']." WHERE (poll_id = '$poll_id')")); + $timestamp = time(); + if ($this->pollvars['check_ip'] == 2) { + $this->db->query("INSERT INTO ".$this->tbl['poll_ip']." (poll_id,ip_addr,timestamp) VALUES ('$poll_id','$this->ip','$timestamp')"); + } + if ($row['logging'] == 1) { + $host = @gethostbyaddr($this->ip); + $agent = getenv("HTTP_USER_AGENT"); + $this->db->query("INSERT INTO ".$this->tbl['poll_log']." (poll_id,option_id,timestamp,ip_addr,host,agent) VALUES ('$poll_id','$option_id','$timestamp','$this->ip','$host','$agent')"); + } + } + + function get_latest_poll_id() { + $this->db->query("SELECT poll_id FROM ".$this->tbl['poll_index']." WHERE (status < '2') ORDER BY TIMESTAMP DESC LIMIT 1"); + $this->db->fetch_array($this->db->result); + return (!isset($this->db->record['poll_id'])) ? 0 : $this->db->record['poll_id']; + } + + function get_random_poll_id() { + $timestamp = time(); + $this->db->query("SELECT poll_id FROM ".$this->tbl['poll_index']." WHERE (status=1 AND exp_time>$timestamp) OR (status=1 AND expire=0)"); + while ($this->db->fetch_array($this->db->result)) { + $poll_id_arr[] = $this->db->record['poll_id']; + } + if (!isset($poll_id_arr)) { + return 0; + } + $available = sizeof($poll_id_arr)-1; + srand((double) microtime() * 1000000); + $random_id = ($available>0) ? rand(0,$available) : 0; + return $poll_id_arr[$random_id]; + } + + function is_active_poll_id($poll_id) { + $this->db->fetch_array($this->db->query("SELECT * FROM ".$this->tbl['poll_index']." WHERE (poll_id='$poll_id' AND status=1)")); + if (!$this->db->record) { + return false; + } elseif ($this->db->record['expire']==0) { + return true; + } + return ($this->db->record['exp_time']<time()) ? false : true; + } + + function is_valid_poll_id($poll_id) { + if ($poll_id>0) { + $this->db->fetch_array($this->db->query("SELECT poll_id FROM ".$this->tbl['poll_index']." WHERE poll_id=$poll_id AND status<'2'")); + return ($this->db->record['poll_id']) ? true : false; + } else { + return false; + } + } + + function has_voted($poll_id) { + global $HTTP_COOKIE_VARS; + $pollcookie = "AdvancedPoll".$poll_id; + if (isset($HTTP_COOKIE_VARS[$pollcookie])) { + return true; + } + if ($this->pollvars['check_ip']==2) { + $today = time()-$this->pollvars['lock_timeout']*3600; + $this->db->query("DELETE FROM ".$this->tbl['poll_ip']." WHERE (timestamp < $today)"); + $this->db->fetch_array($this->db->query("SELECT * FROM ".$this->tbl['poll_ip']." WHERE (ip_addr = '$this->ip' and poll_id='$poll_id')")); + return ($this->db->record) ? true : false; + } + } + + function get_query_strg($self) { + global $HTTP_SERVER_VARS; + if (isset($HTTP_SERVER_VARS['QUERY_STRING']) && !empty($HTTP_SERVER_VARS['QUERY_STRING'])) { + if (ereg("($self=[0-9]+)",$HTTP_SERVER_VARS['QUERY_STRING'],$regs)) { + $HTTP_SERVER_VARS['QUERY_STRING'] = str_replace($regs[1], "", $HTTP_SERVER_VARS['QUERY_STRING']); + } + $HTTP_SERVER_VARS['QUERY_STRING'] = str_replace("$self=", "", $HTTP_SERVER_VARS['QUERY_STRING']); + if (empty($HTTP_SERVER_VARS['QUERY_STRING'])) { + $append = $HTTP_SERVER_VARS['PHP_SELF']."?"; + } else { + $query_vars = explode("&",$HTTP_SERVER_VARS['QUERY_STRING']); + $append = $HTTP_SERVER_VARS['PHP_SELF']."?"; + for ($i=0; $i<sizeof($query_vars); $i++) { + if (!empty($query_vars[$i])) { + $append .= $query_vars[$i]."&"; + } + } + } + } else { + $append = $HTTP_SERVER_VARS['PHP_SELF']."?"; + } + return $append; + } + + function poll_process($poll_id='') { + global $HTTP_GET_VARS, $HTTP_POST_VARS; + + $poll_ident = (isset($HTTP_POST_VARS['poll_ident'])) ? intval($HTTP_POST_VARS['poll_ident']) : ""; + if ($poll_ident == "") { + if (isset($HTTP_GET_VARS['poll_ident'])) { + $poll_ident = intval($HTTP_GET_VARS['poll_ident']); + } + } + + $option_id = (isset($HTTP_POST_VARS['option_id'])) ? intval($HTTP_POST_VARS['option_id']) : ""; + if ($option_id == "") { + if (isset($HTTP_GET_VARS['option_id'])) { + $option_id = intval($HTTP_GET_VARS['option_id']); + } + } + + $action = (isset($HTTP_POST_VARS['action'])) ? trim($HTTP_POST_VARS['action']) : ""; + if ($action == "") { + if (isset($HTTP_GET_VARS['action'])) { + $action = trim($HTTP_GET_VARS['action']); + } + } + + if ($poll_id=="random") { + $poll_id = (empty($poll_ident)) ? $this->get_random_poll_id() : $poll_ident; + } elseif ($poll_id=="newest") { + $poll_id = $this->get_latest_poll_id(); + } + if ($this->is_valid_poll_id($poll_id)) { + $voted = $this->has_voted($poll_id); + $is_active = $this->is_active_poll_id($poll_id); + if ($action=="results" && $poll_id==$poll_ident) { + return $this->view_poll_result($poll_id,0); + } elseif (!$is_active) { + return $this->view_poll_result($poll_id,0); + } elseif ($is_active && $voted) { + return $this->view_poll_result($poll_id,1); + } elseif (!$voted && isset($option_id) && $action=="vote" && $poll_id==$poll_ident) { + $this->update_poll($poll_id,$option_id); + return $this->view_poll_result($poll_id,0); + } else { + return $this->display_poll($poll_id); + } + } else { + $error = "<b>Poll ID <font color=red>$poll_id</font> does not exist.</b>"; + return $error; + } + } + +} + ?> \ No newline at end of file Index: class_session.php =================================================================== RCS file: /cvsroot/devil-linux/web/poll/include/class_session.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -u -d -r1.1.1.1 -r1.2 --- class_session.php 2 Jun 2004 13:05:52 -0000 1.1.1.1 +++ class_session.php 18 Sep 2004 16:00:41 -0000 1.2 @@ -1,84 +1,84 @@ -<?php -/** - * ---------------------------------------------- - * Advanced Poll 2.0.3 (PHP/MySQL) - * Copyright (c)2001 Chi Kien Uong - * URL: http://www.proxy2.de - * ---------------------------------------------- - */ - -class poll_session { - - var $expire; - var $table; - var $db; - - function poll_session() { - global $POLLTBL; - $this->table = $POLLTBL; - $this->expire = 7200; - } - - function set_session_time($expire_time='') { - if ($expire_time>0) { - $this->expire = $expire_time; - } - } - - function is_valid_session($session,$user_id) { - $this->db->query("SELECT session, last_visit from ".$this->table['poll_user']." WHERE session='$session' and user_id='$user_id'"); - ... [truncated message content] |
