Project

General

Profile

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
?>
(3-3/5)