Project

General

Profile

1 1538 Luisehahne
<?php
2
/**
3
 *
4
 * @category        module
5
 * @package         Form
6
 * @author          WebsiteBaker Project
7 1714 Luisehahne
 * @copyright       2009-2012, Website Baker Org. e.V.
8 1538 Luisehahne
 * @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$
13
 * @filesource		$HeadURL$
14
 * @lastmodified    $Date$
15
 * @description
16
 */
17
18
// Must include code to stop this file being access directly
19
/* -------------------------------------------------------- */
20
if(defined('WB_PATH') == false)
21
{
22
	// Stop this file being access directly
23 1714 Luisehahne
		die('<h2 style="color:red;margin:3em auto;text-align:center;">Cannot access this file directly</h2><');
24 1538 Luisehahne
}
25
/* -------------------------------------------------------- */
26
27
$msg = array();
28
$aTable = array('mod_form_fields','mod_form_settings','mod_form_submissions');
29
for($x=0; $x<sizeof($aTable);$x++) {
30
	if(($sOldType = $database->getTableEngine(TABLE_PREFIX.$aTable[$x]))) {
31
		if(('myisam' != strtolower($sOldType))) {
32
			if(!$database->query('ALTER TABLE `'.TABLE_PREFIX.$aTable[$x].'` Engine = \'MyISAM\' ')) {
33
				$msg[] = $database->get_error();
34
			}
35
		}
36
	} else {
37
		$msg[] = $database->get_error();
38
	}
39
}
40 1714 Luisehahne
41
// later in upgrade.php
42
$table_name = TABLE_PREFIX.'mod_form_settings';
43
$field_name = 'perpage_submissions';
44
$description = "INT NOT NULL DEFAULT '10' AFTER `max_submissions`";
45
if(!$database->field_exists($table_name,$field_name)) {
46
	$database->field_add($table_name, $field_name, $description);
47
}
48 1538 Luisehahne
// ------------------------------------