<?php
   /**
    * $Id$
    */
    require_once './config/config.php';
    require_once SP_INCLUDEDIR . '/pear/DB.php';
    require_once SP_INCLUDEDIR . '/patTemplate.php';
    require_once SP_INCLUDEDIR . '/patErrorManager.php';
    
    $PAT        =&  new patTemplate('html');
    $PAT->setBasedir(SP_SKINDIR . '/tg/default');
    $PAT->readTemplatesFromFile('install.tmpl');
    $PAT->addGlobalVar('SP_SKINDIR', SP_SKINDIR . '/tg/default');
    
    $dbc        =&  DB::connect(SP_DB_DSN);
    if (PEAR::isError($dbc)) {
        $PAT->addVar('startpage', 'PAGE_TITLE', 'tgcSimplePoll - Installation');
        $PAT->addVar('install', 'SUCCEEDED', 'no');
        $PAT->addVar('install', 'ERRMSG', 'Connecting to DB failed! Check your settings in config.php');
        $PAT->displayParsedTemplate('page');
        exit;
    }
    
    $queries    =   array();
    $queries[]  =   "DROP TABLE IF EXISTS " . SP_DB_TABLEPREFIX ."admin;";
    $queries[]  =   "CREATE TABLE " . SP_DB_TABLEPREFIX ."admin (" .
                    "uId int unsigned NOT NULL, " .
                    "username varchar(20) NOT NULL default '', " .
                    "password varchar(50) NOT NULL default '', " .
                    "PRIMARY KEY  (uId) " .
                    ") TYPE=MyISAM;";
    $queries[]  =   "INSERT INTO " . SP_DB_TABLEPREFIX ."admin (uId, username, password) VALUES (1, 'admin', md5('admin'));";

    $queries[]  =   "DROP TABLE IF EXISTS " . SP_DB_TABLEPREFIX ."options;";
    $queries[]  =   "CREATE TABLE " . SP_DB_TABLEPREFIX ."options ( " .
                    "oId tinyint(3) unsigned NOT NULL default '0', " .
                    "qId int(10) unsigned NOT NULL default '0', " .
                    "answer varchar(255) NOT NULL default '', ".
                    "PRIMARY KEY  (oId,qId) " .
                    ") TYPE=MyISAM;";
                    
    $queries[]  =   "DROP TABLE IF EXISTS " . SP_DB_TABLEPREFIX ."questions;";
    $queries[]  =   "CREATE TABLE " . SP_DB_TABLEPREFIX ."questions ( " .
                    "qId int(10) unsigned NOT NULL, " .
                    "question varchar(255) NOT NULL default '', " .
                    "PRIMARY KEY  (qId) " .
                    ") TYPE=MyISAM;";
                    
    $queries[]  =   "DROP TABLE IF EXISTS " . SP_DB_TABLEPREFIX ."votes;";
    $queries[]  =   "CREATE TABLE " . SP_DB_TABLEPREFIX ."votes ( " .
                    "vId int(10) unsigned NOT NULL, " .
                    "qId int(10) unsigned NOT NULL default '0', " .
                    "oId tinyint(3) unsigned NOT NULL default '0', " .
                    "ip varchar(15) default NULL, " .
                    "host varchar(255) default NULL, " .
                    "sid varchar(50) default NULL," .
                    "date timestamp(14) NOT NULL, " .
                    "PRIMARY KEY  (vId) " .
                    ") TYPE=MyISAM;";
                 
    foreach($queries as $query) {
        $result =   $dbc->query($query);
        if (PEAR::isError($result)) {
            $PAT->addVar('startpage', 'PAGE_TITLE', 'tgcSimplePoll - Installation');
            $PAT->addVar('install', 'SUCCEEDED', 'no');
            $PAT->addVar('install', 'ERRMSG', 'Table creation failed! Please try again.');
            $PAT->displayParsedTemplate('page');
            exit;
        }
    }

    
    $PAT->addVar('startpage', 'PAGE_TITLE', 'tgcSimplePoll - Installation');
    $PAT->addVar('install', 'SUCCEEDED', 'yes');
    $PAT->displayParsedTemplate('page');
?>