Project

General

Profile

1
<?php
2
/**
3
 *
4
 * @category        modules
5
 * @package         JsAdmin
6
 * @author          WebsiteBaker Project, modified by Swen Uth for Website Baker 2.7
7
 * @copyright       (C) 2006, Stepan Riha, 2009-2011, Website Baker Org. e.V.
8
 * @link			http://www.websitebaker2.org/
9
 * @license         http://www.gnu.org/licenses/gpl.html
10
 * @platform        WebsiteBaker 2.8.x
11
 * @requirements    PHP 5.2.2 and higher
12
 * @version         $Id: install.php 1537 2011-12-10 11:04:33Z Luisehahne $
13
 * @filesource		$HeadURL: svn://isteam.dynxs.de/wb-archiv/branches/2.8.x/wb/modules/jsadmin/install.php $
14
 * @lastmodified    $Date: 2011-12-10 12:04:33 +0100 (Sat, 10 Dec 2011) $
15
 *
16
*/
17

    
18
// prevent this file from being accessed directly
19
/* -------------------------------------------------------- */
20
if(defined('WB_PATH') == false)
21
{
22
	// Stop this file being access directly
23
	die('<head><title>Access denied</title></head><body><h2 style="color:red;margin:3em auto;text-align:center;">Cannot access this file directly</h2></body></html>');
24
}
25
/* -------------------------------------------------------- */
26

    
27
// add new rows to table "settings"
28

    
29
$msg = array ();
30
$table = TABLE_PREFIX ."mod_jsadmin";
31
$jsadminDefault = array (
32
	array ( 'id' => '1','name' => 'mod_jsadmin_persist_order','value' => '1' ),
33
	array ( 'id' => '2','name' => 'mod_jsadmin_ajax_order_pages','value' => '1' ),
34
	array ( 'id' => '3','name' => 'mod_jsadmin_ajax_order_sections','value' => '1' ),
35
);
36

    
37
$database->query("DROP TABLE IF EXISTS `$table`");
38
$sql = 'CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'mod_jsadmin` ('
39
	. ' `id` INT(11) NOT NULL DEFAULT \'0\','
40
	. ' `name` VARCHAR(255) NOT NULL DEFAULT \'0\','
41
	. ' `value` INT(11) NOT NULL DEFAULT \'0\','
42
	. ' PRIMARY KEY ( `id` )'
43
	. ' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci';
44

    
45
if($database->query($sql) ) {
46

    
47
	for($x=0;$x<sizeof($jsadminDefault); $x++) {
48
		$sql  = 'INSERT INTO '.$table.' SET ';
49
		$sql .= '`id`=\''.$jsadminDefault[$x]['id'].'\', ';
50
		$sql .= '`name`=\''.$jsadminDefault[$x]['name'].'\', ';
51
		$sql .= '`value`=\''.$jsadminDefault[$x]['value'].'\' ';
52
		if(!$database->query($sql) ) { $msg[] = $database->get_error();}
53
	}
54
} else {
55
	$msg[] = $database->get_error();
56
}
57

    
(6-6/13)