| 
      1
     | 
    
      <?php
 
     | 
  
  
    | 
      2
     | 
    
      
 
     | 
  
  
    | 
      3
     | 
    
      // $Id: install.php 919 2009-02-02 17:08:46Z Ruebenwurzel $
 
     | 
  
  
    | 
      4
     | 
    
      
 
     | 
  
  
    | 
      5
     | 
    
      /*
 
     | 
  
  
    | 
      6
     | 
    
      
 
     | 
  
  
    | 
      7
     | 
    
       Website Baker Project <http://www.websitebaker.org/>
 
     | 
  
  
    | 
      8
     | 
    
       Copyright (C) 2004-2009, Ryan Djurovich
 
     | 
  
  
    | 
      9
     | 
    
      
 
     | 
  
  
    | 
      10
     | 
    
       Website Baker is free software; you can redistribute it and/or modify
 
     | 
  
  
    | 
      11
     | 
    
       it under the terms of the GNU General Public License as published by
 
     | 
  
  
    | 
      12
     | 
    
       the Free Software Foundation; either version 2 of the License, or
 
     | 
  
  
    | 
      13
     | 
    
       (at your option) any later version.
 
     | 
  
  
    | 
      14
     | 
    
      
 
     | 
  
  
    | 
      15
     | 
    
       Website Baker is distributed in the hope that it will be useful,
 
     | 
  
  
    | 
      16
     | 
    
       but WITHOUT ANY WARRANTY; without even the implied warranty of
 
     | 
  
  
    | 
      17
     | 
    
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 
     | 
  
  
    | 
      18
     | 
    
       GNU General Public License for more details.
 
     | 
  
  
    | 
      19
     | 
    
      
 
     | 
  
  
    | 
      20
     | 
    
       You should have received a copy of the GNU General Public License
 
     | 
  
  
    | 
      21
     | 
    
       along with Website Baker; if not, write to the Free Software
 
     | 
  
  
    | 
      22
     | 
    
       Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 
     | 
  
  
    | 
      23
     | 
    
      
 
     | 
  
  
    | 
      24
     | 
    
      */
 
     | 
  
  
    | 
      25
     | 
    
      
 
     | 
  
  
    | 
      26
     | 
    
      // prevent this file from being accessed directly
 
     | 
  
  
    | 
      27
     | 
    
      if(!defined('WB_PATH')) { exit('Cannot access this file directly'); }
     | 
  
  
    | 
      28
     | 
    
      
 
     | 
  
  
    | 
      29
     | 
    
      $table = TABLE_PREFIX.'mod_captcha_control';
 
     | 
  
  
    | 
      30
     | 
    
      $database->query("DROP TABLE IF EXISTS `$table`");
     | 
  
  
    | 
      31
     | 
    
      
 
     | 
  
  
    | 
      32
     | 
    
      $database->query("CREATE TABLE `$table` (
     | 
  
  
    | 
      33
     | 
    
      	`enabled_captcha` VARCHAR(1) NOT NULL DEFAULT '1',
 
     | 
  
  
    | 
      34
     | 
    
      	`enabled_asp` VARCHAR(1) NOT NULL DEFAULT '0',
 
     | 
  
  
    | 
      35
     | 
    
      	`captcha_type` VARCHAR(255) NOT NULL DEFAULT 'calc_text',
 
     | 
  
  
    | 
      36
     | 
    
      	`asp_session_min_age` INT(11) NOT NULL DEFAULT '20',
 
     | 
  
  
    | 
      37
     | 
    
      	`asp_view_min_age` INT(11) NOT NULL DEFAULT '10',
 
     | 
  
  
    | 
      38
     | 
    
      	`asp_input_min_age` INT(11) NOT NULL DEFAULT '5',
 
     | 
  
  
    | 
      39
     | 
    
      	`ct_text` LONGTEXT NOT NULL
 
     | 
  
  
    | 
      40
     | 
    
      	)"
 
     | 
  
  
    | 
      41
     | 
    
      );
 
     | 
  
  
    | 
      42
     | 
    
      
 
     | 
  
  
    | 
      43
     | 
    
      // add new row using the table default values defined above
 
     | 
  
  
    | 
      44
     | 
    
      $database->query("
     | 
  
  
    | 
      45
     | 
    
      	INSERT INTO `$table`
 
     | 
  
  
    | 
      46
     | 
    
      		(`enabled_captcha`, `enabled_asp`, `captcha_type`)
 
     | 
  
  
    | 
      47
     | 
    
      	VALUES
 
     | 
  
  
    | 
      48
     | 
    
      		('1', '1', 'calc_text')
     | 
  
  
    | 
      49
     | 
    
      ");
 
     | 
  
  
    | 
      50
     | 
    
      
 
     | 
  
  
    | 
      51
     | 
    
      ?>
 
     |