3 * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)
4 * Copyright (C) 2002-2009 The Nucleus Group
6 * This program is free software; you can redistribute it and/or
7 * modify it under the terms of the GNU General Public License
8 * as published by the Free Software Foundation; either version 2
9 * of the License, or (at your option) any later version.
10 * (see nucleus/documentation/index.html#license for more info)
13 * @license http://nucleuscms.org/license.txt GNU General Public License
14 * @copyright Copyright (C) 2002-2009 The Nucleus Group
15 * @version $Id: upgrade2.0.php 1388 2009-07-18 06:31:28Z shizuki $
18 function upgrade_do400()
20 if ( upgrade_checkinstall(400) )
22 return "already installed";
25 /* in config table, 'Language' is renamed 'Locale' and the value is changed */
26 if ( !upgrade_checkIfColumnExists('config','Locale') )
28 $query = "SELECT * FROM %s WHERE name='Language'";
29 $query = sprintf($query, sql_table('config'));
30 $res = sql_query($query);
31 while ( $o = mysql_fetch_object($res) )
33 $language = $o->Language;
36 $locale = i18n::convert_old_language_file_name_to_locale($language);
38 $query = "INSERT INTO %s (name, value) VALUE('Locale', '%s');";
39 $query = sprintf($query, sql_table('config'), $locale);
40 upgrade_query("Renaming Language for configs to Locale", $query);
42 $query = "DELETE * FROM %s WHERE name='Language';";
43 $query = sprintf($query, sql_table('config'));
44 upgrade_query("Renaming Language for configs to Locale", $query);
47 /* in member table, deflang field is renamed as mlocale */
48 if ( !upgrade_checkIfColumnExists('member','mlocale') )
50 $query = "ALTER TABLE %s CHANGE deflang mlocale varchar(10) NOT NULL default '';";
51 $query = sprintf($query, sql_table('member'));
52 upgrade_query("Renaming deflang column for members to mlocale", $query);
55 /* update database version */
56 update_version('400');