3 * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)
\r
4 * Copyright (C) 2002-2009 The Nucleus Group
\r
6 * This program is free software; you can redistribute it and/or
\r
7 * modify it under the terms of the GNU General Public License
\r
8 * as published by the Free Software Foundation; either version 2
\r
9 * of the License, or (at your option) any later version.
\r
10 * (see nucleus/documentation/index.html#license for more info)
\r
13 * @license http://nucleuscms.org/license.txt GNU General Public License
\r
14 * @copyright Copyright (C) 2002-2009 The Nucleus Group
\r
15 * @version $Id: upgrade3.4.php 1416 2009-09-24 15:58:08Z ftruscot $
\r
18 function upgrade_do340() {
\r
20 if (upgrade_checkinstall(340))
\r
21 return 'already installed';
\r
23 // Give user warning if they are running old version of PHP
\r
24 if (phpversion() < '5') {
\r
25 echo 'WARNING: You are running NucleusCMS on a older version of PHP. PHP4 support will be depreciated in the next release, please consider upgrade to PHP5!';
\r
28 // lengthen tpartname column of nucleus_template
\r
29 $query = " ALTER TABLE `" . sql_table('template') . "`
\r
30 MODIFY `tpartname` varchar(64) NOT NULL default '' ;";
\r
32 upgrade_query('Altering ' . sql_table('template') . ' table', $query);
\r
34 // lengthen tdname column of nucleus_template_desc
\r
35 $query = " ALTER TABLE `" . sql_table('template_desc') . "`
\r
36 MODIFY `tdname` varchar(64) NOT NULL default '' ;";
\r
38 upgrade_query('Altering ' . sql_table('template_desc') . ' table', $query);
\r
40 // create DebugVars setting
\r
41 if (!upgrade_checkIfCVExists('DebugVars')) {
\r
42 $query = 'INSERT INTO '.sql_table('config')." VALUES ('DebugVars',0)";
\r
43 upgrade_query('Creating DebugVars config value',$query);
\r
46 // create DefaultListSize setting
\r
47 if (!upgrade_checkIfCVExists('DefaultListSize')) {
\r
48 $query = 'INSERT INTO '.sql_table('config')." VALUES ('DefaultListSize',10)";
\r
49 upgrade_query('Creating DefaultListSize config value',$query);
\r
52 // changing the member table
\r
53 if (!upgrade_checkIfColumnExists('member', 'mautosave')) {
\r
54 $query = ' ALTER TABLE ' . sql_table('member') . ' ADD mautosave TINYINT(2) DEFAULT 1';
\r
55 upgrade_query('Adding a new row for the autosave member option', $query);
\r
59 // update database version
\r
60 update_version('340');
\r