/**
* Automatic update of the system module
*
* @param object $module reference to the module object
* @param int $oldversion The old version of the database
* @param int $dbVersion The database version
* @return mixed
*/
function xoops_module_update_system(&$module, $oldversion = NULL, $dbVersion = NULL)
{
global $icmsConfig, $xoTheme;
$from_112 = $abortUpdate = FALSE;
$oldversion = $module->getVar('version');
if ($oldversion < 120) {
$result = icms::$xoopsDB->query("SELECT t1.tpl_id FROM " . icms::$xoopsDB->prefix('tplfile') . " t1, " . icms::$xoopsDB->prefix('tplfile') . " t2 WHERE t1.tpl_module = t2.tpl_module AND t1.tpl_tplset=t2.tpl_tplset AND t1.tpl_file = t2.tpl_file AND t1.tpl_id > t2.tpl_id");
$tplids = array();
while (list($tplid) = icms::$xoopsDB->fetchRow($result)) {
$tplids[] = $tplid;
}
if (count($tplids) > 0) {
$tplfile_handler = icms::handler('icms_view_template_file');
$duplicate_files = $tplfile_handler->getObjects(new icms_db_criteria_Item('tpl_id', "(" . implode(',', $tplids) . ")", "IN"));
if (count($duplicate_files) > 0) {
foreach (array_keys($duplicate_files) as $i) {
$tplfile_handler->delete($duplicate_files[$i]);
}
}
}
}
$icmsDatabaseUpdater = icms_db_legacy_Factory::getDatabaseUpdater();
//$dbVersion = $module->getDBVersion();
//$oldversion = $module->getVar('version');
ob_start();
$dbVersion = $module->getDBVersion();
echo sprintf(_DATABASEUPDATER_CURRENTVER, icms_conv_nr2local($dbVersion)) . '<br />';
echo "<code>" . sprintf(_DATABASEUPDATER_UPDATE_TO, icms_conv_nr2local(ICMS_SYSTEM_DBVERSION)) . "<br />";
/*
* DEVELOPER, PLEASE NOTE !!!
*
* Everytime we add a new upgrade block here, the dbversion of the System Module will get
* incremented. It is very important to modify the ICMS_SYSTEM_DBVERSION accordingly
* in htdocs/include/version.php
*
* When we start a new major release, move all the previous version's upgrade scripts to
* a separate file, to minimize file size and memory usage
*/
$CleanWritingFolders = FALSE;
if ($dbVersion < 40) {
include 'update-112-to-122.php';
}
/* Begin upgrade to version 1.3 */
if (!$abortUpdate) {
$newDbVersion = 41;
}
if ($dbVersion < $newDbVersion) {
/* Add new tables and data for the help suggestions and quick search */
$table = new icms_db_legacy_updater_Table('autosearch_cat');
if (!$table->exists()) {
$table->setStructure("`cid` int(11) NOT NULL auto_increment,\n\t\t\t\t `cat_name` varchar(255) NOT NULL,\n\t\t\t\t `cat_url` text NOT NULL,\n\t\t\t\t PRIMARY KEY (`cid`)");
if (!$table->createTable()) {
$abortUpdate = TRUE;
$newDbVersion = 40;
}
if (!$abortUpdate) {
icms_loadLanguageFile('system', 'admin');
$search_cats = array("NULL, '" . _MD_AM_ADSENSES . "', '/modules/system/admin.php?fct=adsense'", "NULL, '" . _MD_AM_AUTOTASKS . "', '/modules/system/admin.php?fct=autotasks'", "NULL, '" . _MD_AM_AVATARS . "', '/modules/system/admin.php?fct=avatars'", "NULL, '" . _MD_AM_BANS . "', '/modules/system/admin.php?fct=banners'", "NULL, '" . _MD_AM_BKPOSAD . "', '/modules/system/admin.php?fct=blockspadmin'", "NULL, '" . _MD_AM_BKAD . "', '/modules/system/admin.php?fct=blocksadmin'", "NULL, '" . _MD_AM_COMMENTS . "', '/modules/system/admin.php?fct=comments'", "NULL, '" . _MD_AM_CUSTOMTAGS . "', '/modules/system/admin.php?fct=customtag'", "NULL, '" . _MD_AM_USER . "', '/modules/system/admin.php?fct=users'", "NULL, '" . _MD_AM_FINDUSER . "', '/modules/system/admin.php?fct=finduser'", "NULL, '" . _MD_AM_ADGS . "', '/modules/system/admin.php?fct=groups'", "NULL, '" . _MD_AM_IMAGES . "', '/modules/system/admin.php?fct=images'", "NULL, '" . _MD_AM_MLUS . "', '/modules/system/admin.php?fct=mailusers'", "NULL, '" . _MD_AM_MIMETYPES . "', '/modules/system/admin.php?fct=mimetype'", "NULL, '" . _MD_AM_MDAD . "', '/modules/system/admin.php?fct=modulesadmin'", "NULL, '" . _MD_AM_PREF . "', '/modules/system/admin.php?fct=preferences'", "NULL, '" . _MD_AM_RATINGS . "', '/modules/system/admin.php?fct=rating'", "NULL, '" . _MD_AM_SMLS . "', '/modules/system/admin.php?fct=smilies'", "NULL, '" . _MD_AM_PAGES . "', '/modules/system/admin.php?fct=pages'", "NULL, '" . _MD_AM_TPLSETS . "', '/modules/system/admin.php?fct=tplsets'", "NULL, '" . _MD_AM_RANK . "', '/modules/system/admin.php?fct=userrank'", "NULL, '" . _MD_AM_VERSION . "', '/modules/system/admin.php?fct=version'");
foreach ($search_cats as $cat) {
$table->setData($cat);
}
$table->addData();
}
unset($table);
}
$table = new icms_db_legacy_updater_Table('autosearch_list');
if (!$table->exists() && !$abortUpdate) {
$table->setStructure("`id` int(11) NOT NULL auto_increment,\n\t\t\t\t `cat_id` int(11) NOT NULL,\n\t\t\t\t `name` varchar(255) NOT NULL,\n\t\t\t\t `img` varchar(255) NOT NULL,\n\t\t\t\t `desc` text NOT NULL,\n\t\t\t\t `url` text NOT NULL,\n\t\t\t\t PRIMARY KEY (`id`)");
if (!$table->createTable()) {
$abortUpdate = TRUE;
$newDbVersion = 40;
}
if (!$abortUpdate) {
icms_loadLanguageFile('system', 'admin');
icms_loadLanguageFile('system', 'preferences', TRUE);
$search_items = array("NULL, 1, '" . _MD_AM_ADSENSES . "', '/modules/system/admin/adsense/images/adsense_small.png', '" . _MD_AM_ADSENSES_DSC . "', '/modules/system/admin.php?fct=adsense'", "NULL, 2, '" . _MD_AM_AUTOTASKS . "', '/modules/system/admin/autotasks/images/autotasks_small.png', '" . _MD_AM_AUTOTASKS_DSC . "', '/modules/system/admin.php?fct=autotasks'", "NULL, 3, '" . _MD_AM_AVATARS . "', '/modules/system/admin/avatars/images/avatars_small.png', '" . _MD_AM_AVATARS_DSC . "', '/modules/system/admin.php?fct=avatars'", "NULL, 4, '" . _MD_AM_BANS . "', '/modules/system/admin/banners/images/banners_small.png', '" . _MD_AM_BANS_DSC . "', '/modules/system/admin.php?fct=banners'", "NULL, 5, '" . _MD_AM_BKPOSAD . "', '/modules/system/admin/blockspadmin/images/blockspadmin_small.png', '" . _MD_AM_BKPOSAD_DSC . "', '/modules/system/admin.php?fct=blockspadmin'", "NULL, 6, '" . _MD_AM_BKAD . "', '/modules/system/admin/blocksadmin/images/blocksadmin_small.png', '" . _MD_AM_BKAD_DSC . "', '/modules/system/admin.php?fct=blocksadmin'", "NULL, 7, '" . _MD_AM_COMMENTS . "', '/modules/system/admin/comments/images/comments_small.png', '" . _MD_AM_COMMENTS_DSC . "', '/modules/system/admin.php?fct=comments'", "NULL, 8, '" . _MD_AM_CUSTOMTAGS . "', '/modules/system/admin/customtag/images/customtag_small.png', '" . _MD_AM_CUSTOMTAGS_DSC . "', '/modules/system/admin.php?fct=customtag'", "NULL, 9, '" . _MD_AM_USER . "', '/modules/system/admin/users/images/users_small.png', '" . _MD_AM_USER_DSC . "', '/modules/system/admin.php?fct=users'", "NULL, 10, '" . _MD_AM_FINDUSER . "', '/modules/system/admin/findusers/images/findusers_small.png', '" . _MD_AM_FINDUSER_DSC . "', '/modules/system/admin.php?fct=findusers'", "NULL, 11, '" . _MD_AM_ADGS . "', '/modules/system/admin/groups/images/groups_small.png', '" . _MD_AM_ADGS_DSC . "', '/modules/system/admin.php?fct=groups'", "NULL, 12, '" . _MD_AM_IMAGES . "', '/modules/system/admin/images/images/images_small.png', '" . _MD_AM_IMAGES_DSC . "', '/modules/system/admin.php?fct=images'", "NULL, 13, '" . _MD_AM_MLUS . "', '/modules/system/admin/mailusers/images/mailusers_small.png', '" . _MD_AM_MLUS_DSC . "', '/modules/system/admin.php?fct=mailusers'", "NULL, 14, '" . _MD_AM_MIMETYPES . "', '/modules/system/admin/mimetype/images/mimetype_small.png', '" . _MD_AM_MIMETYPES_DSC . "', '/modules/system/admin.php?fct=mimetype'", "NULL, 15, '" . _MD_AM_MDAD . "', '/modules/system/admin/modulesadmin/images/modulesadmin_small.png', '" . _MD_AM_MDAD_DSC . "', '/modules/system/admin.php?fct=modulesadmin'", "NULL, 16, '" . _MD_AM_PREF . " - " . _MD_AM_AUTHENTICATION . "', '/modules/system/admin/preferences/images/preferences_small.png', '" . _MD_AM_AUTHENTICATION_DSC . "', '/modules/system/admin.php?fct=preferences&op=show&confcat_id=7'", "NULL, 16, '" . _MD_AM_PREF . " - " . _MD_AM_AUTOTASKS . "', '/modules/system/admin/preferences/images/preferences_small.png', '" . _MD_AM_AUTOTASKS_PREF_DSC . "', '/modules/system/admin.php?fct=preferences&op=show&confcat_id=13'", "NULL, 16, '" . _MD_AM_PREF . " - " . _MD_AM_CAPTCHA . "', '/modules/system/admin/preferences/images/preferences_small.png', '" . _MD_AM_CAPTCHA_DSC . "', '/modules/system/admin.php?fct=preferences&op=show&confcat_id=11'", "NULL, 16, '" . _MD_AM_PREF . " - " . _MD_AM_GENERAL . "', '/modules/system/admin/preferences/images/preferences_small.png', '" . _MD_AM_GENERAL_DSC . "', '/modules/system/admin.php?fct=preferences&op=show&confcat_id=1'", "NULL, 16, '" . _MD_AM_PREF . " - " . _MD_AM_PURIFIER . "', '/modules/system/admin/preferences/images/preferences_small.png', '" . _MD_AM_PURIFIER_DSC . "', '/modules/system/admin.php?fct=preferences&op=show&confcat_id=14'", "NULL, 16, '" . _MD_AM_PREF . " - " . _MD_AM_MAILER . "', '/modules/system/admin/preferences/images/preferences_small.png', '" . _MD_AM_MAILER_DSC . "', '/modules/system/admin.php?fct=preferences&op=show&confcat_id=6'", "NULL, 16, '" . _MD_AM_PREF . " - " . _MD_AM_METAFOOTER . "', '/modules/system/admin/preferences/images/preferences_small.png', '" . _MD_AM_METAFOOTER_DSC . "', '/modules/system/admin/preferences/images/preferences_small.png'", "NULL, 16, '" . _MD_AM_PREF . " - " . _MD_AM_MULTILANGUAGE . "', '/modules/system/admin/preferences/images/preferences_small.png', '" . _MD_AM_MULTILANGUAGE_DSC . "', '/modules/system/admin.php?fct=preferences&op=show&confcat_id=8'", "NULL, 16, '" . _MD_AM_PREF . " - " . _MD_AM_PERSON . "', '/modules/system/admin/preferences/images/preferences_small.png', '" . _MD_AM_PERSON_DSC . "', '/modules/system/admin.php?fct=preferences&op=show&confcat_id=10'", "NULL, 16, '" . _MD_AM_PREF . " - " . _MD_AM_PLUGINS . "', '/modules/system/admin/preferences/images/preferences_small.png', '" . _MD_AM_PLUGINS_DSC . "', '/modules/system/admin.php?fct=preferences&op=show&confcat_id=12'", "NULL, 16, '" . _MD_AM_PREF . " - " . _MD_AM_SEARCH . "', '/modules/system/admin/preferences/images/preferences_small.png', '" . _MD_AM_SEARCH_DSC . "', '/modules/system/admin.php?fct=preferences&op=show&confcat_id=5'", "NULL, 16, '" . _MD_AM_PREF . " - " . _MD_AM_USERSETTINGS . "', '/modules/system/admin/preferences/images/preferences_small.png', '" . _MD_AM_USERSETTINGS_DSC . "', '/modules/system/admin.php?fct=preferences&op=show&confcat_id=2'", "NULL, 16, '" . _MD_AM_PREF . " - " . _MD_AM_CENSOR . "', '/modules/system/admin/preferences/images/preferences_small.png', '" . _MD_AM_CENSOR_DSC . "', '/modules/system/admin.php?fct=preferences&op=show&confcat_id=4'", "NULL, 17, '" . _MD_AM_RATINGS . "', '/modules/system/admin/rating/images/rating_small.png', '" . _MD_AM_RATINGS_DSC . "', '/modules/system/admin.php?fct=rating'", "NULL, 18, '" . _MD_AM_SMLS . "', '/modules/system/admin/smilies/images/smilies_small.png', '" . _MD_AM_SMLS_DSC . "', '/modules/system/admin.php?fct=smilies'", "NULL, 19, '" . _MD_AM_PAGES . "', '/modules/system/admin/pages/images/pages_small.png', '" . _MD_AM_PAGES_DSC . "', '/modules/system/admin.php?fct=pages'", "NULL, 20, '" . _MD_AM_TPLSETS . "', '/modules/system/admin/tplsets/images/tplsets_small.png', '" . _MD_AM_TPLSETS_DSC . "', '/modules/system/admin.php?fct=tplsets'", "NULL, 21, '" . _MD_AM_RANK . "', '/modules/system/admin/userrank/images/userrank_small.png', '" . _MD_AM_RANK_DSC . "', '/modules/system/admin.php?fct=userrank'", "NULL, 22, '" . _MD_AM_VRSN . "', '/modules/system/admin/version/images/version_small.png', '" . _MD_AM_VRSN_DSC . "', '/modules/system/admin.php?fct=version'");
foreach ($search_items as $item) {
$table->setData($item);
}
$table->addData();
}
unset($table);
}
/* Optimize old tables and fix data structures */
$table = new icms_db_legacy_updater_Table('config');
$icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` DROP INDEX conf_mod_cat_id, ADD INDEX mod_cat_order(conf_modid, conf_catid, conf_order)", 'Successfully altered the indexes on table config', '');
unset($table);
$table = new icms_db_legacy_updater_Table('group_permission');
$table->addAlteredField('gperm_modid', "SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0'", 'gperm_modid');
$table->alterTable();
$icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` DROP INDEX itemid, DROP INDEX groupid, DROP INDEX gperm_modid", 'Successfully dropped the indexes on table group_permission', '');
$icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` ADD INDEX name_mod_group (gperm_name(10), gperm_modid, gperm_groupid)", 'Successfully added the indexes on table group_permission', '');
unset($table);
$table = new icms_db_legacy_updater_Table('modules');
$icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` DROP INDEX hasmain, DROP INDEX hasadmin, DROP INDEX hassearch, DROP INDEX hasnotification, DROP INDEX name, DROP INDEX dirname", 'Successfully dropped the indexes on table modules', '');
$icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` ADD INDEX dirname (dirname(5)), ADD INDEX active_main_weight (isactive, hasmain, weight)", 'Successfully added the indexes on table modules', '');
unset($table);
$table = new icms_db_legacy_updater_Table('users');
$icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` DROP INDEX email, DROP INDEX uiduname, DROP INDEX unamepass", 'Successfully dropped the indexes on table users', '');
$icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` DROP INDEX login_name, ADD UNIQUE INDEX login_name (login_name)", 'Successfully added the indexes on table users', '');
unset($table);
$table = new icms_db_legacy_updater_Table('priv_msgs');
$icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` DROP INDEX to_userid", 'Successfully dropped the indexes on table priv_msgs', '');
unset($table);
$table = new icms_db_legacy_updater_Table('ranks');
$icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` DROP INDEX rank_min", 'Successfully dropped the indexes on table ranks', '');
unset($table);
/* Corrects an error from db version 4 */
$table = new icms_db_legacy_updater_Table('users');
if ($table->fieldExists('pass')) {
$table->addAlteredField('pass', "varchar(255) NOT NULL default ''", 'pass');
$table->alterTable();
}
unset($table);
/* change IP address to varchar(64) in session to accomodate IPv6 addresses */
$table = new icms_db_legacy_updater_Table('session');
if ($table->fieldExists('sess_ip')) {
$table->addAlteredField('sess_ip', "varchar(64) NOT NULL default ''", 'sess_ip');
$table->alterTable();
}
unset($table);
/* add modname and ipf to modules table */
$table = new icms_db_legacy_updater_Table("modules");
$alter = FALSE;
if (!$table->fieldExists("modname")) {
$table->addNewField("modname", "varchar(25) NOT NULL default ''");
$alter = TRUE;
}
if (!$table->fieldExists("ipf")) {
$table->addNewField("ipf", "tinyint(1) unsigned NOT NULL default '0'");
$alter = TRUE;
}
if ($alter) {
$table->addNewFields();
}
unset($table, $alter);
$module_handler = icms::handler('icms_module');
$modules = $module_handler->getObjects();
foreach ($modules as $module) {
if ($module->getInfo("modname") !== FALSE) {
$module->setVar("modname", $module->getInfo("modname"));
}
if ($module->getInfo("object_items") !== FALSE) {
$module->setVar("ipf", 1);
}
$module_handler->insert($module);
}
unset($module_handler, $modules);
/* add slot for adsense and rename fields */
$table = new icms_db_legacy_updater_Table('system_adsense');
if (!$table->fieldExists("slot")) {
$table->addNewField("slot", "varchar(12) NOT NULL default ''");
$table->addNewFields();
}
if ($table->fieldExists("border_color")) {
$icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` CHANGE border_color color_border varchar(6) NOT NULL default ''");
}
if ($table->fieldExists("background_color")) {
$icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` CHANGE background_color color_background varchar(6) NOT NULL default ''");
}
if ($table->fieldExists("link_color")) {
$icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` CHANGE link_color color_link varchar(6) NOT NULL default ''");
}
if ($table->fieldExists("url_color")) {
$icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` CHANGE url_color color_url varchar(6) NOT NULL default ''");
}
if ($table->fieldExists("text_color")) {
$icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` CHANGE text_color color_text varchar(6) NOT NULL default ''");
}
unset($table);
/* rename content field for customtag */
$table = new icms_db_legacy_updater_Table("system_customtag");
if ($table->fieldExists("content")) {
$icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` CHANGE content customtag_content text NOT NULL");
}
unset($table);
/* rename gperm_name from view to view_customtag for system module */
$table = new icms_db_legacy_updater_Table("group_permission");
$icmsDatabaseUpdater->runQuery("UPDATE `" . $table->name() . "` SET gperm_name = 'view_customtag' WHERE gperm_name = 'view' AND gperm_modid = 1", "", "");
unset($table);
/* reset default source editor if jsvi is used */
$configs = icms::$config->getConfigs(icms_buildCriteria(array("conf_name" => "sourceeditor_default")));
if (count($configs) == 1 && $configs[0]->getVar("conf_value") == "jsvi") {
$configs[0]->setVar("conf_value", "editarea");
icms::$config->insertConfig($configs[0]);
}
unset($configs);
/* New HTML Purifier options -
* purifier_HTML_FlashAllowFullScreen, after purifier_HTML_AttrNameUseCDATA
* purifier_Output_FlashCompat, after purifier_HTML_FlashAllowFullScreen
* purifier_Filter_AllowCustom, after purifier_Filter_YouTube
* purifier_Core_NormalizeNewlines, after purifier_Core_RemoveInvalidImg
*/
$table = new icms_db_legacy_updater_Table("config");
// retrieve the value of the position before the config to be inserted.
$configs = icms::$config->getConfigs(icms_buildCriteria(array("conf_name" => "purifier_HTML_AttrNameUseCDATA")));
$p = $configs[0]->getVar('conf_order') + 1;
//move all the other options down
$icmsDatabaseUpdater->runQuery("UPDATE `" . $table->name() . "` SET conf_order = conf_order + 2 WHERE conf_order >= " . $p . " AND conf_catid = " . ICMS_CONF_PURIFIER, "", "");
$icmsDatabaseUpdater->insertConfig(ICMS_CONF_PURIFIER, 'purifier_HTML_FlashAllowFullScreen', '_MD_AM_PURIFIER_HTML_FLASHFULLSCRN', '0', '_MD_AM_PURIFIER_HTML_FLASHFULLSCRNDSC', 'yesno', 'int', $p);
$icmsDatabaseUpdater->insertConfig(ICMS_CONF_PURIFIER, 'purifier_Output_FlashCompat', '_MD_AM_PURIFIER_OUTPUT_FLASHCOMPAT', '0', '_MD_AM_PURIFIER_OUTPUT_FLASHCOMPATDSC', 'yesno', 'int', $p++);
// retrieve the value of the position before the config to be inserted.
$configs = icms::$config->getConfigs(icms_buildCriteria(array("conf_name" => "purifier_Filter_YouTube")));
$p = $configs[0]->getVar('conf_order') + 1;
//move all the other options down
$icmsDatabaseUpdater->runQuery("UPDATE `" . $table->name() . "` SET conf_order = conf_order + 1 WHERE conf_order >= " . $p . " AND conf_catid = " . ICMS_CONF_PURIFIER, "", "");
$icmsDatabaseUpdater->insertConfig(ICMS_CONF_PURIFIER, 'purifier_Filter_AllowCustom', '_MD_AM_PURIFIER_FILTER_ALLOWCUSTOM', '0', '_MD_AM_PURIFIER_FILTER_ALLOWCUSTOMDSC', 'yesno', 'int', $p);
// retrieve the value of the position before the config to be inserted.
$configs = icms::$config->getConfigs(icms_buildCriteria(array("conf_name" => "purifier_Core_RemoveInvalidImg")));
$p = $configs[0]->getVar('conf_order') + 1;
//move all the other options down
$icmsDatabaseUpdater->runQuery("UPDATE `" . $table->name() . "` SET conf_order = conf_order + 1 WHERE conf_order >= " . $p . " AND conf_catid = " . ICMS_CONF_PURIFIER, "", "");
$icmsDatabaseUpdater->insertConfig(ICMS_CONF_PURIFIER, 'purifier_Core_NormalizeNewlines', '_MD_AM_PURIFIER_CORE_NORMALNEWLINES', '1', '_MD_AM_PURIFIER_CORE_NORMALNEWLINESDSC', 'yesno', 'int', $p);
unset($table);
/* Finish up this portion of the db update */
if (!$abortUpdate) {
$icmsDatabaseUpdater->updateModuleDBVersion($newDbVersion, 'system');
echo sprintf(_DATABASEUPDATER_UPDATE_OK, icms_conv_nr2local($newDbVersion)) . '<br />';
}
}
/* 1.3 beta|rc|final release */
/*
* This portion of the upgrade must remain as the last section of code to execute
* Place all release upgrade steps above this point
*/
echo "</code>";
if ($abortUpdate) {
icms_core_Message::error(sprintf(_DATABASEUPDATER_UPDATE_ERR, icms_conv_nr2local($newDbVersion)), _DATABASEUPDATER_UPDATE_DB, TRUE);
}
if ($from_112 && !$abortUpdate) {
/**
* @todo create a language constant for this text
*/
echo _DATABASEUPDATER_MSG_FROM_112;
echo '<script>setTimeout("window.location.href=\'' . ICMS_MODULES_URL . '/system/admin.php?fct=modulesadmin&op=install&module=content&from_112=1\'",20000);</script>';
}
$feedback = ob_get_clean();
if (method_exists($module, "setMessage")) {
$module->messages = $module->setMessage($feedback);
} else {
echo $feedback;
}
$icmsDatabaseUpdater->updateModuleDBVersion($newDbVersion, 'system');
return icms_core_Filesystem::cleanFolders(array('templates_c' => ICMS_COMPILE_PATH . "/", 'cache' => ICMS_CACHE_PATH . "/"), $CleanWritingFolders);
}
function icms_module_update_content($module)
{
$content_handler = icms_getModuleHandler('content', basename(dirname(dirname(__FILE__))), 'content');
$gperm_handler = icms::handler('icms_member_groupperm');
$table = new icms_db_legacy_updater_Table('icmscontent');
if ($table->exists()) {
echo '<code><b>Importing data from the core content manager</b></code><br />';
$sql = "SELECT * FROM " . icms::$xoopsDB->prefix('icmscontent');
$result = icms::$xoopsDB->query($sql);
echo '<code>';
while ($row = icms::$xoopsDB->fetchArray($result)) {
$obj = $content_handler->create(true);
$obj->setVar('content_pid', $row['content_supid']);
$obj->setVar('content_uid', $row['content_uid']);
$obj->setVar('content_title', $row['content_title']);
$obj->setVar('content_body', $row['content_body']);
$obj->setVar('content_css', $row['content_css']);
$obj->setVar('content_tags', $row['content_tags']);
$obj->setVar('content_visibility', $row['content_visibility']);
$obj->setVar('content_published_date', (int) $row['content_created']);
$obj->setVar('content_updated_date', date(_DATESTRING));
$obj->setVar('content_weight', $row['content_weight']);
$obj->setVar('short_url', $row['content_menu']);
$obj->setVar('counter', $row['content_reads']);
$obj->setVar('content_status', $row['content_status']);
$obj->setVar('content_makesymlink', 0);
$obj->setVar('content_showsubs', 1);
$obj->setVar('content_cancomment', 1);
$obj->setVar('dohtml', 1);
$obj->setVar('dobr', 1);
$obj->setVar('doimage', 1);
$obj->setVar('dosmiley', 1);
$obj->setVar('doxcode', 1);
$content_handler->insert($obj, true);
/**
* Importing the permissions from the old page to add to the new one and deleting the old permissions
*/
//Getting the groups that have read permission to this content page
$groups = $gperm_handler->getGroupIds('content_read', $row['content_id']);
//Deleting the permissions to the old page
$criteria = new icms_db_criteria_Compo();
$crit = new icms_db_criteria_Compo(new icms_db_criteria_Item('gperm_name', 'content_read'));
$crit->add(new icms_db_criteria_Item('gperm_name', 'content_admin'), 'OR');
$criteria->add($crit);
$criteria->add(new icms_db_criteria_Item('gperm_itemid', $row['content_id']));
$criteria->add(new icms_db_criteria_Item('gperm_modid', 1));
$gperm_handler->deleteAll($criteria);
//Adding permissions to allow the groups allowed to read the old content page to read the new content page
foreach ($groups as $group) {
$gperm_handler->addRight('content_read', $obj->getVar('content_id'), $group, $module->getVar("mid"));
}
/**
* Deleting the symlinks from the old page
*/
$seo = $obj->handler->makelink($obj);
$url = str_replace(ICMS_URL . '/', '', $obj->handler->_moduleUrl . $obj->handler->_itemname . '.php?page=' . $seo);
$old_seo = str_replace("-", "_", $seo);
$symlink_handler = icms_getModuleHandler('pages', 'system');
$criteria = new icms_db_criteria_Compo(new icms_db_criteria_Item('page_url', '%' . $old_seo, 'LIKE'));
$criteria->add(new icms_db_criteria_Item('page_moduleid', 1));
$symlinks_remove = $symlink_handler->getObjects($criteria);
$criteria = new icms_db_criteria_Compo(new icms_db_criteria_Item('page_url', '%' . $url, 'LIKE'));
$criteria->add(new icms_db_criteria_Item('page_moduleid', $module->getVar("mid")));
$symlinks_added = $symlink_handler->getObjects($criteria);
foreach ($symlinks_added as $symlink) {
$symlinks_added = $symlink;
break;
}
/**
* If needed, changing the startpage to use the new symlink created
*/
if (count($symlinks_remove) > 0) {
foreach ($symlinks_remove as $symlink) {
$sql_preferences = 'SELECT * FROM ' . icms::$xoopsDB->prefix('config') . ' WHERE conf_name = "startpage" AND conf_value LIKE \'%"1-' . $symlink->getVar('page_id') . '"%\'';
$result_preferences = icms::$xoopsDB->query($sql_preferences);
if (icms::$xoopsDB->getRowsNum($result_preferences) > 0) {
$row_preferences = icms::$xoopsDB->fetchArray($result_preferences);
$arr = unserialize($row_preferences['conf_value']);
foreach ($arr as $k => $v) {
if ($v == '1-' . $symlink->getVar('page_id')) {
$arr[$k] = $module->getVar("mid") . '-' . $symlinks_added->getVar('page_id');
}
}
$value = serialize($arr);
icms::$xoopsDB->queryF('UPDATE ' . icms::$xoopsDB->prefix('config') . ' SET conf_value = \'' . $value . '\' WHERE conf_name = "startpage"');
}
$symlink_handler->delete($symlink, true);
}
}
echo ' -- <b>' . $row['content_title'] . '</b> successfully imported!<br />';
}
echo '</code>';
echo '<code><b>Core Content Manager table successfully dropped.</b></code><br />';
$table->dropTable();
/**
* Importing the core content manager blocks
*/
echo '<code><b>Importing the core content manager blocks and configurations.</b></code><br />';
$icms_block_handler = icms_getModuleHandler('blocksadmin');
//Content Block
$criteria = new icms_db_criteria_Compo(new icms_db_criteria_Item('show_func', 'content_content_display_show'));
$content_content_block = $icms_block_handler->getObjects($criteria, false, true);
$content_content_block = $content_content_block[0] ? $content_content_block[0] : false;
$criteria = new icms_db_criteria_Compo(new icms_db_criteria_Item('show_func', 'b_content_show'));
$content_blocks = $icms_block_handler->getObjects($criteria, true, true);
foreach ($content_blocks as $block) {
$nb = $content_content_block;
$nb->setVar('visiblein', $block->getVar('visiblein', 'e'));
$nb->setVar('options', $block->getVar('options', 'e'));
$nb->setVar('title', $block->getVar('title', 'e'));
$nb->setVar('side', $block->getVar('side', 'e'));
$nb->setVar('weight', $block->getVar('weight', 'e'));
$nb->setVar('visible', $block->getVar('visible', 'e'));
$nb->setVar('isactive', $block->getVar('isactive', 'e'));
$nb->setVar('last_modified', time());
if ($block->getVar('block_type', 'D')) {
//Cloned Version of the Block
$nb->setVar('block_type', 'K');
$nb->setVar('bid', 0);
$nb->setNew();
}
if ($icms_block_handler->insert($nb, true)) {
$criteria = new icms_db_criteria_Compo(new icms_db_criteria_Item('gperm_name', 'block_read'));
$criteria->add(new icms_db_criteria_Item('gperm_itemid', $block->getVar('bid', 'e')));
$criteria->add(new icms_db_criteria_Item('gperm_modid', 1));
$perms = $gperm_handler->getObjects($criteria, true);
foreach ($perms as $perm) {
$gperm_handler->addRight('block_read', $nb->getVar('bid'), $perm->getVar('gperm_groupid'), $module->getVar("mid"));
$gperm_handler->delete($perm);
}
echo '<code>Block <b>' . $block->getVar('title', 'e') . '</b> successfully imported.</code><br />';
} else {
echo '<code>Error while importing block <b>' . $block->getVar('title', 'e') . '</b>.</code><br />';
}
$icms_block_handler->delete($block, true);
}
//Content Menu Block
$criteria = new icms_db_criteria_Compo(new icms_db_criteria_Item('show_func', 'content_content_menu_show'));
$content_menu_block = $icms_block_handler->getObjects($criteria, false, true);
$content_menu_block = $content_menu_block[0] ? $content_menu_block[0] : false;
$criteria = new icms_db_criteria_Compo(new icms_db_criteria_Item('show_func', 'b_content_menu_show'));
$criteria->add(new icms_db_criteria_Item('show_func', 'b_content_relmenu_show'), 'OR');
$content_menu_blocks = $icms_block_handler->getObjects($criteria, true, true);
foreach ($content_menu_blocks as $block) {
$nb = $content_menu_block;
$nb->setVar('visiblein', $block->getVar('visiblein', 'e'));
$nb->setVar('options', $block->getVar('options', 'e') . '|0');
$nb->setVar('title', $block->getVar('title', 'e'));
$nb->setVar('side', $block->getVar('side', 'e'));
$nb->setVar('weight', $block->getVar('weight', 'e'));
$nb->setVar('visible', $block->getVar('visible', 'e'));
$nb->setVar('isactive', $block->getVar('isactive', 'e'));
$nb->setVar('last_modified', time());
if ($block->getVar('block_type', 'D')) {
//Cloned Version of the Block
$nb->setVar('block_type', 'K');
$nb->setVar('bid', 0);
$nb->setNew();
}
if ($icms_block_handler->insert($nb, true)) {
$criteria = new icms_db_criteria_Compo(new icms_db_criteria_Item('gperm_name', 'block_read'));
$criteria->add(new icms_db_criteria_Item('gperm_itemid', $block->getVar('bid', 'e')));
$criteria->add(new icms_db_criteria_Item('gperm_modid', 1));
$perms = $gperm_handler->getObjects($criteria, true);
foreach ($perms as $perm) {
$gperm_handler->addRight('block_read', $nb->getVar('bid'), $perm->getVar('gperm_groupid'), $module->getVar("mid"));
$gperm_handler->delete($perm);
}
echo '<code>Block <b>' . $block->getVar('title', 'e') . '</b> successfully imported.</code><br />';
} else {
echo '<code>Error while importing block <b>' . $block->getVar('title', 'e') . '</b>.</code><br />';
}
$icms_block_handler->delete($block, true);
}
if (is_dir(ICMS_ROOT_PATH . '/modules/system/admin/content')) {
icms_unlinkRecursive(ICMS_ROOT_PATH . '/modules/system/admin/content');
echo '<code>Folder removed successfully.</code><br />';
}
if (is_file(ICMS_ROOT_PATH . '/kernel/content.php')) {
icms_deleteFile(ICMS_ROOT_PATH . '/kernel/content.php');
echo '<code>File removed successfully.</code><br />';
}
/*if (is_file(ICMS_ROOT_PATH . '/content.php')) {
icms_deleteFile(ICMS_ROOT_PATH . '/content.php');
echo '<code>File removed successfully.</code><br />';
}*/
if (is_file(ICMS_ROOT_PATH . '/modules/system/templates/system_content.html')) {
icms_deleteFile(ICMS_ROOT_PATH . '/modules/system/templates/system_content.html');
echo '<code>File removed successfully.</code><br />';
}
if (is_file(ICMS_ROOT_PATH . '/modules/system/templates/system_content_list.html')) {
icms_deleteFile(ICMS_ROOT_PATH . '/modules/system/templates/system_content_list.html');
echo '<code>File removed successfully.</code><br />';
}
icms_clean_folders(array('templates_c' => ICMS_ROOT_PATH . "/templates_c/", 'cache' => ICMS_ROOT_PATH . "/cache/"), true);
$sql = sprintf("DELETE FROM %s WHERE confcat_name= '_MD_AM_CONTMANAGER'", icms::$xoopsDB->prefix('configcategory'));
if (!($result = icms::$xoopsDB->queryF($sql))) {
echo 'Error while removing category.';
}
$sql = sprintf("DELETE FROM %s WHERE (conf_modid = '0' AND conf_catid = '9')", icms::$xoopsDB->prefix('config'));
if (!($result = icms::$xoopsDB->queryF($sql))) {
echo 'Error while removing category items.';
}
echo '<code>Data from Core Content Manager successfully imported.</code><br />';
}
unset($table);
$feedback = ob_get_clean();
if (method_exists($module, "setMessage")) {
$module->messages = $module->setMessage($feedback);
} else {
echo $feedback;
}
return true;
}
function upgradeObjectItem($dirname, $item)
{
$module_handler = icms_getModuleHandler($item, $dirname);
if (!$module_handler) {
return false;
}
$table = new icms_db_legacy_updater_Table($dirname . '_' . $item);
$object = $module_handler->create();
$objectVars = $object->getVars();
if (!$table->exists()) {
// table was never created, let's do it
$structure = "";
foreach ($objectVars as $key => $var) {
if ($var['persistent']) {
$type = $this->getFieldTypeFromVar($var);
if ($key == $module_handler->keyName) {
$extra = "auto_increment";
} else {
$default = $this->getFieldDefaultFromVar($var);
if ($default != 'nodefault') {
$extra = "default '{$default}'";
} else {
$extra = false;
}
}
if ($extra) {
$structure .= "`{$key}` {$type} not null {$extra},";
} else {
$structure .= "`{$key}` {$type} not null,";
}
}
}
$ModKeyNames = $module_handler->keyName;
$structure .= "PRIMARY KEY (";
if (is_array($ModKeyNames)) {
$structure .= "`" . $ModKeyNames[0] . "`";
foreach ($ModKeyNames as $ModKeyName) {
$structure .= $ModKeyName != $ModKeyNames[0] ? ", `" . $ModKeyName . "`" : "";
}
} else {
$structure .= "`" . $ModKeyNames . "`";
}
$structure .= ")";
$table->setStructure($structure);
if (!$this->updateTable($table)) {
/**
* @todo trap the errors
*/
}
foreach ($table->_messages as $msg) {
$this->_messages[] = $msg;
}
} else {
$existingFieldsArray = $table->getExistingFieldsArray();
foreach ($objectVars as $key => $var) {
if ($var['persistent']) {
if (!isset($existingFieldsArray[$key])) {
// the fiels does not exist, let's create it
$type = $this->getFieldTypeFromVar($var);
$default = $this->getFieldDefaultFromVar($var);
if ($default != 'nodefault') {
$extra = "default '{$default}'";
} else {
$extra = false;
}
$table->addNewField($key, "{$type} not null " . $extra);
} else {
// if field already exists, let's check if the definition is correct
$definition = strtolower($existingFieldsArray[$key]);
$type = $this->getFieldTypeFromVar($var);
if ($key == $module_handler->keyName) {
$extra = "auto_increment";
} else {
$default = $this->getFieldDefaultFromVar($var, $key);
if ($default != 'nodefault') {
$extra = "default '{$default}'";
} else {
$extra = false;
}
}
$actual_definition = "{$type} not null";
if ($extra) {
$actual_definition .= " {$extra}";
}
if ($definition != $actual_definition) {
$table->addAlteredField($key, $actual_definition);
}
}
}
}
// check to see if there are some unused fields left in the table
foreach ($existingFieldsArray as $key => $v) {
if (!isset($objectVars[$key]) || !$objectVars[$key]['persistent']) {
$table->addDropedField($key);
}
}
if (!$this->updateTable($table)) {
/**
* @todo trap the errors
*/
}
}
}
}
if (!$abortUpdate) {
$newDbVersion = 27;
}
if ($dbVersion < $newDbVersion) {
$handler = icms_getModulehandler('userrank', 'system');
$handler->MoveAllRanksImagesToProperPath();
$icmsDatabaseUpdater->updateModuleDBVersion($newDbVersion, 'system');
echo sprintf(_DATABASEUPDATER_UPDATE_OK, icms_conv_nr2local($newDbVersion)) . '<br />';
}
if (!$abortUpdate) {
$newDbVersion = 28;
}
if ($dbVersion < $newDbVersion) {
$table = new icms_db_legacy_updater_Table('system_autotasks');
if (!$table->exists()) {
$table->setStructure("sat_id int(10) unsigned NOT NULL AUTO_INCREMENT,\n\t\t\t\t\tsat_name varchar(255) NOT NULL,\n\t\t\t\t\tsat_code text NOT NULL,\n\t\t\t\t\tsat_repeat int(11) NOT NULL,\n\t\t\t\t\tsat_interval int(11) NOT NULL,\n\t\t\t\t\tsat_onfinish smallint(2) NOT NULL,\n\t\t\t\t\tsat_enabled INT(1) NOT NULL,\n\t\t\t\t\tsat_lastruntime int(15) unsigned NOT NULL,\n\t\t\t\t\tsat_type varchar(100) NOT NULL DEFAULT 'custom',\n\t\t\t\t\tsat_addon_id int(2) unsigned zerofill DEFAULT NULL,\n\t\t\t\t\tPRIMARY KEY (sat_id),\n\t\t\t\t\tKEY sat_interval (sat_interval),\n\t\t\t\t\tKEY sat_lastruntime (sat_lastruntime),\n\t\t\t\t\tKEY sat_type (sat_type)\n\t\t\t\t\t");
$table->createTable();
}
unset($table);
if (getDbValue(icms::$xoopsDB, 'configcategory', 'confcat_name', 'confcat_name="_MD_AM_AUTOTASKS"') == FALSE) {
icms::$xoopsDB->queryF(" INSERT INTO " . icms::$xoopsDB->prefix("configcategory") . " (confcat_id, confcat_name) VALUES (13, '_MD_AM_AUTOTASKS')");
}
$icmsDatabaseUpdater->insertConfig(ICMS_CONF, 'sourceeditor_default', '_MD_AM_SRCEDITOR_DEFAULT', 'editarea', '_MD_AM_SRCEDITOR_DEFAULT_DESC', 'editor_source', 'text', 16);
$icmsDatabaseUpdater->insertConfig(IM_CONF_AUTOTASKS, 'autotasks_system', '_MD_AM_AUTOTASKS_SYSTEM', 'internal', '_MD_AM_AUTOTASKS_SYSTEMDSC', 'autotasksystem', 'text', 1);
$icmsDatabaseUpdater->insertConfig(IM_CONF_AUTOTASKS, 'autotasks_helper', '_MD_AM_AUTOTASKS_HELPER', 'wget %url%', '_MD_AM_AUTOTASKS_HELPERDSC', 'select', 'text', 2);
$config_id = icms::$xoopsDB->getInsertId();
$sql = "INSERT INTO " . icms::$xoopsDB->prefix('configoption') . " (confop_id, confop_name, confop_value, conf_id)" . " VALUES" . " (NULL, 'PHP-CGI', 'php -f %path%', {$config_id}), " . " (NULL, 'wget', 'wget %url%', {$config_id}), " . " (NULL, 'Lynx', 'lynx --dump %url%', {$config_id})";
if (!icms::$xoopsDB->queryF($sql)) {
return false;
}
