Query Error

MySQL Error : Query Error
Error Number: 1054 Unknown column 'captcha' in 'field list'
Date        : Sun, August 8, 2010 21:26:53
IP          : 91.64.10.121
Browser     : Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.2.8) Gecko/20100722 Firefox/3.6.8
Referer     : (gekürzt)/AdvancedPoll/admin/admin_settings.php?session=(gekürzt)&uid=(gekürzt)
PHP Version : 5.2.6-1+lenny8
OS          : Linux
Server      : Apache
Server Name : (gekürzt)
Script Name : /AdvancedPoll/admin/admin_settings.php

<?php
/**
 * ----------------------------------------------
 * Advanced Poll 2.0.8 (PHP/MySQL)
 * Copyright (c) Chi Kien Uong
 * URL: http://www.proxy2.de
 * ----------------------------------------------
 */

require_once "./common.inc.php";

function delete_poll($poll_id) {
    global $CLASS, $POLLTBL;
    $poll_id = intval($poll_id);
    $CLASS["db"]->query("DELETE FROM $POLLTBL[poll_data] where (poll_id = '$poll_id')");
    $CLASS["db"]->query("DELETE FROM $POLLTBL[poll_index] where (poll_id = '$poll_id')");
    $CLASS["db"]->query("DELETE FROM $POLLTBL[poll_log] where (poll_id = '$poll_id')");
    $CLASS["db"]->query("DELETE FROM $POLLTBL[poll_comment] where (poll_id = '$poll_id')");
}

function poll_index() {
    global $CLASS, $auth, $pollvars, $entry, $lang, $weekday, $months, $POLLTBL;
    if(!isset($entry)) {
        $entry = 0;
    }
    $CLASS["db"]->fetch_array($CLASS["db"]->query("select count(*) as total from $POLLTBL[poll_index]"));
    $total = $CLASS["db"]->record['total'];
    $time_offset = $pollvars["time_offset"]*3600;
    list($wday,$mday,$month,$year,$hour,$minutes) = split("( )",date("w j n Y H i",time()+$time_offset));
    $newdate = "$weekday[$wday], $mday ".$months[$month-1]." $year $hour:$minutes";
    $next_page = $entry+$pollvars['polls_pp'];
    $prev_page = $entry-$pollvars['polls_pp'];
    $navigation ='';
    if ($prev_page >= 0) {
        $navigation = "  <img src=\"$pollvars[base_gif]/back.gif\" width=\"16\" height=\"14\">&nbsp;<a href=\"$pollvars[SELF]?session=$auth[session]&uid=$auth[uid]&entry=$prev_page\">$lang[NavPrev]</a>\n";
    }
    if ($next_page < $total) {
        $navigation = $navigation. "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"$pollvars[SELF]?session=$auth[session]&uid=$auth[uid]&entry=$next_page\">$lang[NavNext]</a>&nbsp;<img src=\"$pollvars[base_gif]/next.gif\" width=\"16\" height=\"14\">\n";
    }
    $CLASS["template"]->set_templatefiles(array(
        "index" => "admin_index.html",
        "index_tr" => "admin_index_tr.html"
    ));
    $CLASS["template"]->register_vars("index_tr",array(
        "poll_id" => "$row[poll_id]"
    ));
    $index_tr = $CLASS["template"]->pre_parse("index_tr");
    $results = $CLASS["db"]->query("select * from $POLLTBL[poll_index] order by poll_id desc limit $entry, $pollvars[polls_pp]");
    $admin_index_tr = '';
    while ($row = $CLASS["db"]->fetch_array($results)) {
        $question = htmlspecialchars($row['question']);
        $date = date("j-M-Y",$row['timestamp']+$time_offset);
        if ($row['expire']==0) {
            $exp_date = "<font color=\"#0000FF\">$lang[IndexNever]</font>";
        } else {
            $exp_date = (time()>$row['exp_time']) ? "<font color=\"#FF6600\">$lang[IndexExpire]</font>" : date("j-M-Y",$row['exp_time']+$time_offset)." (<font color=\"#FF0000\">".round(($row["exp_time"]-time())/86400)."</font>)";
        }
        $days = (int) ((time()-$row['timestamp']+$time_offset)/86400);
        if ($row['status'] == 1) {
            $image = "$pollvars[base_gif]/folder.gif";
            $alt = "$lang[EditOn]";
        } elseif ($row['status'] == 2) {
            $image = "$pollvars[base_gif]/hidden.gif";
            $alt = "$lang[EditHide]";
        } else {
            $image = "$pollvars[base_gif]/lock.gif";
            $alt = "$lang[EditOff]";
        }
        $alt = htmlspecialchars($alt);
        $image2 = ($row['logging'] == 1) ? "$pollvars[base_gif]/log.gif" : "$pollvars[base_gif]/log_off.gif";
        $image3 = ($row['comments'] == 1) ? "$pollvars[base_gif]/reply.gif" : "$pollvars[base_gif]/co_dis.gif";
        $image4 = ($row['status'] == 2) ? "$pollvars[base_gif]/text_off.gif" : "$pollvars[base_gif]/text.gif";
        eval("$admin_index_tr .= \"$index_tr\";");
    }
    $CLASS["template"]->register_vars("index", array(
        "poll_user" => $CLASS["db"]->db['user'],
        "poll_host" => $CLASS["db"]->db['host']
    ));
    $admin_index = $CLASS["template"]->pre_parse("index");
    eval("echo \"$admin_index\";");
}

function poll_new($message) {
    global $CLASS, $auth, $pollvars, $lang, $color_array;
    $source_array = array(
        "aqua","blue","brown","darkgreen","gold","green","grey","orange","pink","purple","red","yellow"
    );
    for ($i=0,$java_script='';$i<sizeof($source_array); $i++) {
        $java_script .= "$source_array[$i] = new Image(); $source_array[$i].src = \"$pollvars[base_gif]/$source_array[$i].gif\";\n";
    }
    for ($i=1,$poll_options=''; $i < $pollvars['def_options']+1; $i++) {
        $poll_options .= "        <tr>
                 <td width=\"25%\" class=\"td1\">$lang[NewOption] $i</td>
                 <td width=\"40%\">
                   <input type=\"text\" name=\"option_id[$i]\" size=\"38\" class=\"input\" maxlength=\"100\">
                 </td>
                 <td class=\"td2\" width=\"10%\">
                   <select class=\"select\" name=\"color[$i]\" onChange=\"javascript:ChangeBar(options[selectedIndex].value,$i)\">
                    <option value=\"blank\">---</option>\n";
        for ($j=0; $j <sizeof($source_array); $j++) {
            $poll_options .= "<option value=\"$source_array[$j]\">$color_array[$j]</option>\n";
        }
        $poll_options .= "       </select></td>
            <td width=\"25%\" align=\"left\"><img src=\"$pollvars[base_gif]/blank.gif\" name=\"bar$i\" width=\"35\" height=\"12\"></td>
            </tr>\n";
    }
    $CLASS["template"]->set_templatefiles(array(
        "admin_new" => "admin_new.html"
    ));
    $admin_new = $poll_login = $CLASS["template"]->pre_parse("admin_new");
    eval("echo \"$admin_new\";");
}

function create_poll() {
    global $CLASS, $POLLTBL;
    global $logging, $expire, $exp_time, $status, $comments;
    global $option_id, $question, $color;
    $timestamp = time();
    if (!isset($expire)) {
        $expire=1;
    }
    if (!isset($comments)) {
        $comments=0;
    }
    if (!isset($exp_time)) {
        $exp_time=$timestamp;
    } else {
        $exp_time=$timestamp+$exp_time*86400;
    }
    if (!get_magic_quotes_gpc()) {
        $question = addslashes($question);
    }
    $CLASS["db"]->query("INSERT INTO $POLLTBL[poll_index] (question,timestamp,status,logging,exp_time,expire,comments) VALUES ('$question','$timestamp','$status','$logging','$exp_time','$expire','$comments')");
    $sql_result = $CLASS["db"]->query("SELECT poll_id FROM $POLLTBL[poll_index] WHERE timestamp=$timestamp");
    $CLASS["db"]->fetch_array($sql_result);
    $poll_id = $CLASS["db"]->record['poll_id'];
    for($i=1; $i <= sizeof($option_id); $i++) {
        $option_id[$i] = trim($option_id[$i]);
        if (!empty($option_id[$i])) {
            if (!get_magic_quotes_gpc()) {
                $option_id[$i] = addslashes($option_id[$i]);
            }
            $CLASS["db"]->query("INSERT INTO $POLLTBL[poll_data] (poll_id, option_id, option_text, color, votes) VALUES('$poll_id', '$i', '$option_id[$i]','$color[$i]',0)");
        }
    }
}

if (!isset($action)) {
    $action='';
}

no_cache_header();

switch ($action) {

    case "new":
        $message = $lang["NewTitle"];
        poll_new("$message");
        break;

    case "show":
        poll_index();
        break;

    case "delete":
        if (isset($id)) {
            delete_poll($id);
        }
        poll_index();
        break;

    case "create":
        $question = trim($question);
        if (!empty($question)) {
            create_poll();
            poll_index();
        } else {
            $message = $lang["EditMis"];
            poll_new("$message");
        }
        break;

    default:
        poll_index();
        break;
}

?>

<?php
/**
 * ----------------------------------------------
 * Advanced Poll 2.0.8 (PHP/MySQL)
 * Copyright (c) Chi Kien Uong
 * URL: http://www.proxy2.de
 * ----------------------------------------------
 */

if (!isset($PHP_SELF)) {
    if (isset($_GET)) {
        while (list($name, $value)=each($_GET)) {
            $$name=$value;
        }
    }
    if (isset($_POST)) {
        while (list($name, $value)=each($_POST)) {
            $$name=$value;
        }
    }
}
$PHP_SELF = $_SERVER["PHP_SELF"];

$CLASS = array();

require_once "../include/config.inc.php";
require_once "../include/$POLLDB[class]";
require_once "../include/class_session.php";
require_once "../include/class_template.php";

function no_cache_header() {
    header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
    header("Last-Modified: " . gmdate("D, d M Y H:i:s") . "GMT");
    header("Cache-Control: no-cache, must-revalidate");
    header("Pragma: no-cache");
}

$CLASS["db"] = new polldb_sql;
$CLASS["db"]->connect();
$pollvars = $CLASS["db"]->fetch_array($CLASS["db"]->query("SELECT * FROM $POLLTBL[poll_config]"));
$CLASS["db"]->free_result($CLASS["db"]->result);
$pollvars['SELF'] = basename($_SERVER["PHP_SELF"]);
$lang = array();
if (is_file("../lang/$pollvars[lang]")) {
    include ("../lang/$pollvars[lang]");
} else {
    include ("../lang/english.php");
}
$CLASS["template"] = new poll_template();
$CLASS["template"]->set_rootdir("./templates");
$CLASS["session"] = new poll_session();
$CLASS["session"]->db = &$CLASS["db"];

$auth = $CLASS["session"]->check_session_id();

if (!$auth) {
    $message = (isset($_POST['username']) || isset($_POST['password'])) ? $lang['FormWrong'] : $lang['FormEnter'];
    $CLASS["template"]->set_templatefiles(array(
        "login" => "admin_login.html"
    ));
    $poll_login = $CLASS["template"]->pre_parse("login");
    no_cache_header();
    eval("echo \"$poll_login\";");
    exit();
}

?>

<?php
/**
 *
 *  MySQL      -> class_mysql.php
 *  PostgreSQL -> class_pgsql.php
 *
 */

$POLLDB["dbName"] = (gekürzt);
$POLLDB["host"]   = "(gekürzt)";
$POLLDB["user"]   = "(gekürzt)";
$POLLDB["pass"]   = "(gekürzt)";
$POLLDB["class"]  = "(gekürzt)";


/* tables  */

$POLLTBL["poll_config"]  = "poll_config";
$POLLTBL["poll_index"]   = "poll_index";
$POLLTBL["poll_data"]    = "poll_data";
$POLLTBL["poll_ip"]      = "poll_ip";
$POLLTBL["poll_log"]     = "poll_log";
$POLLTBL["poll_comment"] = "poll_comment";
$POLLTBL["poll_user"]    = "poll_user";
$POLLTBL["poll_tpl"]     = "poll_templates";
$POLLTBL["poll_tplset"]  = "poll_templateset";

?>

<?php
/**
 * ----------------------------------------------
 * Advanced Poll 2.0.8 (PHP/MySQL)
 * Copyright (c) Chi Kien Uong
 * URL: http://www.proxy2.de
 * ----------------------------------------------
 */

require_once "./common.inc.php";
require_once "../include/class_input2db.php";

function get_lang_list($dir) {
    $lang_list = '';
    chdir("$dir");
    $hnd = opendir(".");
    while ($file = readdir($hnd)) {
        if(is_file($file)) {
            $langlist[] = $file;
        }
    }
    closedir($hnd);
    if ($langlist) {
        asort($langlist);
        while (list ($key, $file) = each ($langlist)) {
            if (ereg(".php|.php3",$file,$regs)) {
                $lang_list .= "<option value=\"".$file."\">".str_replace("$regs[0]","","$file")."</option>\n";
            }
        }
    }
    return $lang_list;
}

function addspecialchars($input='') {
    if(is_array($input)) {
        reset($input);
        while (list($var,$value) = each($input)) {
            $input[$var] = htmlspecialchars($value);
        }
        return $input;
    } else {
        return false;
    }
}


$action = (!isset($_REQUEST['action'])) ? '' : trim($_REQUEST['action']);  


$message = $lang["SetText"];

if ($action == "update") {
    if (!eregi(".php|.php3", $_POST['cfg']['lang'])) {
        $_POST['cfg']['lang'] = "english.php";
    }
    
    if (!eregi("^[0-9]+$", $_POST['cfg']['entry_pp']) || $_POST['cfg']['entry_pp']==0) {
        $_POST['cfg']['entry_pp'] = 1;
    }
    $_POST['cfg']['captcha'] = (!isset($_POST['cfg']['captcha']) || ($_POST['cfg']['captcha'] != "on")) ? "off" : "on";
    $CLASS["db_input"] = new input2db();
    $result = $CLASS["db_input"]->update_db_row($POLLTBL["poll_config"],$_POST['cfg'],"config_id",1);
    if ($result) {
        $pollvars = $CLASS["db"]->fetch_array($CLASS["db"]->query("SELECT * FROM $POLLTBL[poll_config]"));
        $pollvars['SELF'] = basename($_SERVER['PHP_SELF']);
        $CLASS["db"]->free_result($CLASS["db"]->result);
        $lang = array();
        include (dirname(dirname(__FILE__))."/lang/$pollvars[lang]");
        $message = $lang["Updated"];
    } else {
        $message = $lang["NoUpdate"];
    }
}

$CLASS["template"]->set_templatefiles(array(
    "admin_settings" => "admin_settings.html"
));

$pollvars = addspecialchars($pollvars);
$langlist = get_lang_list("../lang");
$check_ip = ($pollvars["check_ip"] == 0) ? "selected" : "";
$no_ip_check = ($pollvars["check_ip"] == 2) ? "selected" : "";
$votes = ($pollvars["type"] == "votes") ? "checked" : "";
$percent = ($pollvars["type"] == "percent") ? "checked" : "";
$order_usort = ($pollvars["result_order"] == "usort") ? "selected" : "";
$order_asc = ($pollvars["result_order"] == "asc") ? "selected" : "";
$order_desc = ($pollvars["result_order"] == "desc") ? "selected" : "";
$capcha_check = ($pollvars["captcha"] == "on") ? "checked" : "";

$admin_settings = $CLASS["template"]->pre_parse("admin_settings");
no_cache_header();
eval("echo \"$admin_settings\";");

?>

<?php
/**
 * ----------------------------------------------
 * Advanced Poll 2.0.8 (PHP/MySQL)
 * Copyright (c) Chi Kien Uong
 * URL: http://www.proxy2.de
 * ----------------------------------------------
 */

class input2db extends polldb_sql {

    function input2db() {
        $this->polldb_sql();
        $this->connect();
    }

    function format_array($vars_array='') {
        if (is_array($vars_array)) {
            reset($vars_array);
            if (get_magic_quotes_gpc()) {
                while (list($var, $value)=each($vars_array)) {
                    $vars_array[$var] = trim($value);
                }
            } else {
                while (list($var, $value)=each($vars_array)) {
                    $vars_array[$var] = trim(addslashes($value));
                }    
            }
            reset($vars_array);
            return $vars_array;
        } else {
            return false;
        }
    }
    
    function insert_db_row($table,$vars='') {
        if (!is_array($vars)) {
            return false;
        }
        $vars = $this->format_array($vars);
        while (list($var,$value)=each($this->VARS)) {
            $arr_var[] = $var;
            $arr_value[] = "'$value'";
        }
        $tb_var = implode(",",$arr_var);
        $tb_value = implode(",",$arr_value);
        $this->query("INSERT INTO $table ($tb_var) VALUES ($tb_value)");
        return ($this->result) ? true : false;
    }
    
    function update_db_row($table,$vars='',$id,$row_id) {
        if (!is_array($vars)) {
            return false;
        }
        $vars = $this->format_array($vars);
        if (sizeof($vars)) {
            $query ='';
            while (list($var,$value)=each($vars)) {
                $query .= "$var='$value',";
            }
            $query = substr($query, 0, strlen($query)-1);
            $this->query("UPDATE $table SET $query WHERE($id=$row_id)");
            return true;
        } else {
            return false;
        }
    }


}

?>

<?php

$tbl[] = "CREATE TABLE $POLLTBL[poll_config] (
   config_id smallint(5) unsigned NOT NULL auto_increment,
   base_gif varchar(60) NOT NULL,
   lang varchar(20) NOT NULL,
   title varchar(60) NOT NULL,
   vote_button varchar(30) NOT NULL,
   result_text varchar(40) NOT NULL,
   total_text varchar(40) NOT NULL,
   voted varchar(40) NOT NULL,
   send_com varchar(40) NOT NULL,
   img_height int(5) DEFAULT '0' NOT NULL,
   img_length int(5) DEFAULT '0' NOT NULL,
   table_width varchar(6) NOT NULL,
   bgcolor_tab varchar(7) NOT NULL,
   bgcolor_fr varchar(7) NOT NULL,
   font_face varchar(70) NOT NULL,
   font_color varchar(7) NOT NULL,
   type varchar(10) DEFAULT '0' NOT NULL,
   check_ip smallint(2) DEFAULT '0' NOT NULL,
   lock_timeout int(9) DEFAULT '0' NOT NULL,
   time_offset varchar(5) DEFAULT '0' NOT NULL,
   entry_pp int(4) unsigned DEFAULT '0' NOT NULL,
   poll_version varchar(5) NOT NULL default '0',
   base_url varchar(100) NOT NULL default '',
   result_order varchar(20) NOT NULL default '',
   def_options smallint(3) unsigned NOT NULL default '0',
   polls_pp int(5) unsigned NOT NULL default '0',
   captcha varchar(5) NOT NULL,
   PRIMARY KEY (config_id)
)";

$tbl[] = "CREATE TABLE $POLLTBL[poll_data] (
   id int(11) NOT NULL auto_increment,
   poll_id int(11) DEFAULT '0' NOT NULL,
   option_id int(11) DEFAULT '0' NOT NULL,
   option_text varchar(100) NOT NULL,
   color varchar(20) NOT NULL,
   votes int(14) DEFAULT '0' NOT NULL,
   PRIMARY KEY (poll_id, option_id),
   KEY id (id)
)";

$tbl[] = "CREATE TABLE $POLLTBL[poll_index] (
   poll_id int(11) unsigned NOT NULL auto_increment,
   question varchar(100) NOT NULL,
   timestamp int(11) DEFAULT '0' NOT NULL,
   status smallint(2) DEFAULT '0' NOT NULL,
   logging smallint(2) DEFAULT '0' NOT NULL,
   exp_time int(11) DEFAULT '0' NOT NULL,
   expire smallint(2) DEFAULT '0' NOT NULL,
   comments smallint(2) DEFAULT '0' NOT NULL,
   PRIMARY KEY (poll_id)
)";

$tbl[] = "CREATE TABLE $POLLTBL[poll_ip] (
   ip_id int(11) NOT NULL auto_increment,
   poll_id int(11) DEFAULT '0' NOT NULL,
   ip_addr varchar(15) NOT NULL,
   timestamp int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (ip_id)
)";

$tbl[] = "CREATE TABLE $POLLTBL[poll_log] (
   log_id int(11) unsigned NOT NULL auto_increment,
   poll_id int(11) DEFAULT '0' NOT NULL,
   option_id int(11) DEFAULT '0' NOT NULL,
   timestamp int(11) DEFAULT '0' NOT NULL,
   ip_addr varchar(15) NOT NULL,
   host varchar(255) NOT NULL,
   agent varchar(255) DEFAULT '0' NOT NULL,
   PRIMARY KEY (log_id)
)";

$tbl[] = "CREATE TABLE $POLLTBL[poll_user] (
   user_id smallint(5) NOT NULL auto_increment,
   username varchar(30) NOT NULL,
   userpass varchar(32) NOT NULL,
   session varchar(32) NOT NULL,
   last_visit int(11) NOT NULL,
   PRIMARY KEY (user_id)
)";

$tbl[] = "CREATE TABLE $POLLTBL[poll_comment] (
   com_id int(9) NOT NULL auto_increment,
   poll_id int(9) DEFAULT '0' NOT NULL,
   time int(11) DEFAULT '0' NOT NULL,
   host varchar(255) NOT NULL,
   browser varchar(255) NOT NULL,
   name varchar(60) NOT NULL,
   email varchar(100) NOT NULL,
   message text NOT NULL,
   PRIMARY KEY (com_id)
)";

$tbl[] = "CREATE TABLE $POLLTBL[poll_tpl] (
  tpl_id int(10) unsigned NOT NULL auto_increment,
  tplset_id int(10) unsigned NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  template mediumtext NOT NULL,
  PRIMARY KEY  (tpl_id)
)";

$tbl[] = "CREATE TABLE $POLLTBL[poll_tplset] (
  tplset_id int(10) unsigned NOT NULL auto_increment,
  tplset_name varchar(50) NOT NULL default '',
  created datetime default '0000-00-00 00:00:00',
  PRIMARY KEY  (tplset_id)
)";

?>