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 */ } } }
/** * 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); }
/** * log in a user * @param string $uname username as entered in the login form * @param string $pwd password entered in the login form * @return object icms_member_user_Object {@link icms_member_user_Object} reference to the logged in user. FALSE if failed to log in */ public function loginUser($uname, $pwd) { $icmspass = new icms_core_Password(); if (strstr($uname, '@')) { $uname = self::icms_getLoginFromUserEmail($uname); } /* $is_expired = $icmspass->passExpired($uname); if ($is_expired == 1) { redirect_header(ICMS_URL . '/user.php?op=resetpass&uname=' . $uname, 5, _US_PASSEXPIRED, false); } */ $pwd = $icmspass->verifyPass($pwd, $uname); $table = new icms_db_legacy_updater_Table('users'); if ($table->fieldExists('loginname')) { $criteria = new icms_db_criteria_Compo(new icms_db_criteria_Item('loginname', $uname)); } elseif ($table->fieldExists('login_name')) { $criteria = new icms_db_criteria_Compo(new icms_db_criteria_Item('login_name', $uname)); } else { $criteria = new icms_db_criteria_Compo(new icms_db_criteria_Item('uname', $uname)); } $criteria->add(new icms_db_criteria_Item('pass', $pwd)); $user = $this->_uHandler->getObjects($criteria, false); if (!$user || count($user) != 1) { $user = false; return $user; } return $user[0]; }
public function __construct($name) { parent::__construct($name); $this->_errors = icms_core_Debug::setDeprecated('icms_db_legacy_updater_Table', sprintf(_CORE_REMOVE_IN_VERSION, '1.4')); }
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; }
/** * This Private Function returns the User Encryption Type belonging to username. * @copyright (c) 2007-2008 The ImpressCMS Project - www.impresscms.org * @since 1.2.3 * @param string $uname Username to find Enc_type for. * @return string returns the Encryption type of the user. */ private function priv_getUserEncType($uname) { if (!isset($uname) || isset($uname) && $uname == '') { redirect_header('user.php', 2, _US_SORRYNOTFOUND); } $table = new icms_db_legacy_updater_Table('users'); $uname = @htmlspecialchars($uname, ENT_QUOTES, _CHARSET); if ($table->fieldExists('loginname')) { $sql = icms::$xoopsDB->query(sprintf("SELECT enc_type FROM %s WHERE loginname = %s", icms::$xoopsDB->prefix('users'), icms::$xoopsDB->quoteString($uname))); list($enc_type) = icms::$xoopsDB->fetchRow($sql); } elseif ($table->fieldExists('login_name')) { $sql = icms::$xoopsDB->query(sprintf("SELECT enc_type FROM %s WHERE login_name = %s", icms::$xoopsDB->prefix('users'), icms::$xoopsDB->quoteString($uname))); list($enc_type) = icms::$xoopsDB->fetchRow($sql); } else { $sql = icms::$xoopsDB->query(sprintf("SELECT enc_type FROM %s WHERE uname = %s", icms::$xoopsDB->prefix('users'), icms::$xoopsDB->quoteString($uname))); list($enc_type) = icms::$xoopsDB->fetchRow($sql); } return (int) $enc_type; }
* cleaning required please add $CleanWritingFolders = 1 and otherwise $CleanWritingFolders = 0 * Like this below: */ $CleanWritingFolders = true; /* end of dbversion 18 update */ $icmsDatabaseUpdater->updateModuleDBVersion($newDbVersion, 'system'); echo sprintf(_DATABASEUPDATER_UPDATE_OK, icms_conv_nr2local($newDbVersion)) . '<br />'; } if (!$abortUpdate) { $newDbVersion = 33; } /* * New symlinks need to be added to the db */ if ($dbVersion < $newDbVersion) { $table = new icms_db_legacy_updater_Table('icmspage'); $new_pages = array("NULL, 1, '" . _CPHOME . "', 'admin.php', 1", "NULL, 1, '" . _MI_SYSTEM_ADMENU14 . "', 'modules/system/admin.php?fct=avatars*', 1", "NULL, 1, '" . _MI_SYSTEM_ADMENU1 . "', 'modules/system/admin.php?fct=banners*', 1", "NULL, 1, '" . _MI_SYSTEM_ADMENU2 . "', 'modules/system/admin.php?fct=blocksadmin*', 1", "NULL, 1, '" . _MI_SYSTEM_ADMENU19 . "', 'modules/system/admin.php?fct=blockspadmin*', 1", "NULL, 1, '" . _MI_SYSTEM_ADMENU16 . "', 'modules/system/admin.php?fct=comments*', 1", "NULL, 1, '" . _MI_SYSTEM_ADMENU12 . "', 'modules/system/admin.php?fct=findusers*', 1", "NULL, 1, '" . _MI_SYSTEM_ADMENU21 . "', 'modules/system/admin.php?fct=customtag*', 1", "NULL, 1, '" . _MI_SYSTEM_ADMENU3 . "', 'modules/system/admin.php?fct=groups*', 1", "NULL, 1, '" . _MI_SYSTEM_ADMENU13 . "', 'modules/system/admin.php?fct=images*', 1", "NULL, 1, '" . _MI_SYSTEM_ADMENU11 . "', 'modules/system/admin.php?fct=mailusers*', 1", "NULL, 1, '" . _MD_AM_MDAD . "', 'modules/system/admin.php?fct=modulesadmin*', 1", "NULL, 1, '" . _MI_SYSTEM_ADMENU20 . "', 'modules/system/admin.php?fct=pages*', 1", "NULL, 1, '" . _MI_SYSTEM_ADMENU6 . "', 'modules/system/admin.php?fct=preferences*', 1", "NULL, 1, '" . _MI_SYSTEM_ADMENU7 . "', 'modules/system/admin.php?fct=smilies*', 1", "NULL, 1, '" . _MI_SYSTEM_ADMENU15 . "', 'modules/system/admin.php?fct=tplsets*', 1", "NULL, 1, '" . _MI_SYSTEM_ADMENU9 . "', 'modules/system/admin.php?fct=userrank*', 1", "NULL, 1, '" . _MI_SYSTEM_ADMENU10 . "', 'modules/system/admin.php?fct=users*', 1", "NULL, 1, '" . _MD_AM_VRSN . "', 'modules/system/admin.php?fct=version*', 1"); foreach ($new_pages as $new_page) { $table->setData($new_page); } $table->addData(); unset($table); $icmsDatabaseUpdater->updateModuleDBVersion($newDbVersion, 'system'); echo sprintf(_DATABASEUPDATER_UPDATE_OK, icms_conv_nr2local($newDbVersion)) . '<br />'; } if (!$abortUpdate) { $newDbVersion = 34; } /* The admin control panel now consists of blocks - these need to be set as visible * Control Panel, System Warnings, Modules Installed */
/** * Logic for updating a module * * @todo add installation_notify(), only if the version of the module changes * * @param str $dirname * @return str Result messages from the module update */ function icms_module_update($dirname) { global $icmsConfig, $icmsAdminTpl; $msgs = array(); $dirname = trim($dirname); $module_handler = icms::handler('icms_module'); $module =& $module_handler->getByDirname($dirname); // Save current version for use in the update function $prev_version = $module->getVar('version'); $prev_dbversion = $module->getVar('dbversion'); /** * http://www.php.net/manual/en/language.oop5.paamayim-nekudotayim.php * @todo PHP5.3.0 supports $icmsAdminTpl::template_clear_module_cache($module->getVar('mid')); */ $icmsAdminTpl->template_clear_module_cache($module->getVar('mid')); // we dont want to change the module name set by admin $temp_name = $module->getVar('name'); $module->loadInfoAsVar($dirname); $module->setVar('name', $temp_name); /* * ensure to only update those fields that are currently available in the database * this is required to allow structural updates for the module table */ $table = new icms_db_legacy_updater_Table("modules"); foreach (array_keys($module->vars) as $k) { if (!$table->fieldExists($k)) { unset($module->vars[$k]); } } if (!$module_handler->insert($module)) { $msgs[] = sprintf('<p>' . _MD_AM_UPDATE_FAIL . '</p>', $module->getVar('name')); } else { $newmid = $module->getVar('mid'); $msgs[] = _MD_AM_MOD_DATA_UPDATED; $tplfile_handler =& icms::handler('icms_view_template_file'); $deltpl =& $tplfile_handler->find('default', 'module', $module->getVar('mid')); $delng = array(); if (is_array($deltpl)) { $xoopsDelTpl = new icms_view_Tpl(); // clear cache files $xoopsDelTpl->clear_cache(NULL, 'mod_' . $dirname); // delete template file entry in db $dcount = count($deltpl); for ($i = 0; $i < $dcount; $i++) { if (!$tplfile_handler->delete($deltpl[$i])) { $delng[] = $deltpl[$i]->getVar('tpl_file'); } } } $templates = $module->getInfo('templates'); if ($templates !== FALSE) { $msgs[] = _MD_AM_MOD_UP_TEM; foreach ($templates as $tpl) { $tpl['file'] = trim($tpl['file']); if (!in_array($tpl['file'], $delng)) { $tpldata =& xoops_module_gettemplate($dirname, $tpl['file']); $tplfile =& $tplfile_handler->create(); $tplfile->setVar('tpl_refid', $newmid); $tplfile->setVar('tpl_lastimported', 0); $tplfile->setVar('tpl_lastmodified', time()); if (preg_match("/\.css$/i", $tpl['file'])) { $tplfile->setVar('tpl_type', 'css'); } else { $tplfile->setVar('tpl_type', 'module'); } $tplfile->setVar('tpl_source', $tpldata, TRUE); $tplfile->setVar('tpl_module', $dirname); $tplfile->setVar('tpl_tplset', 'default'); $tplfile->setVar('tpl_file', $tpl['file'], TRUE); $tplfile->setVar('tpl_desc', $tpl['description'], TRUE); if (!$tplfile_handler->insert($tplfile)) { $msgs[] = sprintf(' <span style="color:#ff0000;">' . _MD_AM_TEMPLATE_INSERT_FAIL . '</span>', '<strong>' . $tpl['file'] . '</strong>'); } else { $newid = $tplfile->getVar('tpl_id'); $msgs[] = sprintf(' <span>' . _MD_AM_TEMPLATE_INSERTED . '</span>', '<strong>' . $tpl['file'] . '</strong>', '<strong>' . $newid . '</strong>'); if ($icmsConfig['template_set'] == 'default') { if (!$icmsAdminTpl->template_touch($newid)) { $msgs[] = sprintf(' <span style="color:#ff0000;">' . _MD_AM_TEMPLATE_RECOMPILE_FAIL . '</span>', '<strong>' . $tpl['file'] . '</strong>'); } else { $msgs[] = sprintf(' <span>' . _MD_AM_TEMPLATE_RECOMPILED . '</span>', '<strong>' . $tpl['file'] . '</strong>'); } } } unset($tpldata); } else { $msgs[] = sprintf(' <span style="color:#ff0000;">' . _MD_AM_TEMPLATE_DELETE_FAIL . '</span>', $tpl['file']); } } } $blocks = $module->getInfo('blocks'); $msgs[] = _MD_AM_MOD_REBUILD_BLOCKS; if ($blocks !== FALSE) { $count = count($blocks); $showfuncs = array(); $funcfiles = array(); for ($i = 1; $i <= $count; $i++) { if (isset($blocks[$i]['show_func']) && $blocks[$i]['show_func'] != '' && isset($blocks[$i]['file']) && $blocks[$i]['file'] != '') { $editfunc = isset($blocks[$i]['edit_func']) ? $blocks[$i]['edit_func'] : ''; $showfuncs[] = $blocks[$i]['show_func']; $funcfiles[] = $blocks[$i]['file']; $template = $content = ''; if ((isset($blocks[$i]['template']) && trim($blocks[$i]['template']) != '')) { $content =& xoops_module_gettemplate($dirname, $blocks[$i]['template'], TRUE); } if (!$content) { $content = ''; } else { $template = $blocks[$i]['template']; } $options = ''; if (!empty($blocks[$i]['options'])) { $options = $blocks[$i]['options']; } $sql = "SELECT bid, name FROM " . icms::$xoopsDB->prefix('newblocks') . " WHERE mid='" . (int) $module->getVar('mid') . "' AND func_num='". (int) $i . "' AND show_func='" . addslashes($blocks[$i]['show_func']) . "' AND func_file='" . addslashes($blocks[$i]['file']) . "'"; $fresult = icms::$xoopsDB->query($sql); $fcount = 0; while ($fblock = icms::$xoopsDB->fetchArray($fresult)) { $fcount++; $sql = "UPDATE " . icms::$xoopsDB->prefix("newblocks") . " SET name='" . addslashes($blocks[$i]['name']) . "', edit_func='" . addslashes($editfunc) . "', content='', template='" . $template . "', last_modified=" . time() . " WHERE bid='". (int) $fblock['bid'] . "'"; $result = icms::$xoopsDB->query($sql); if (!$result) { $msgs[] = sprintf(' ' . _MD_AM_UPDATE_FAIL, $fblock['name']); } else { $msgs[] = sprintf(' ' . _MD_AM_BLOCK_UPDATED, '<strong>' . $fblock['name'] . '</strong>', '<strong>' . icms_conv_nr2local($fblock['bid']) . '</strong>'); if ($template != '') { $tplfile =& $tplfile_handler->find('default', 'block', $fblock['bid']); if (count($tplfile) == 0) { $tplfile_new =& $tplfile_handler->create(); $tplfile_new->setVar('tpl_module', $dirname); $tplfile_new->setVar('tpl_refid', (int) $fblock['bid']); $tplfile_new->setVar('tpl_tplset', 'default'); $tplfile_new->setVar('tpl_file', $blocks[$i]['template'], TRUE); $tplfile_new->setVar('tpl_type', 'block'); } else { $tplfile_new = $tplfile[0]; } $tplfile_new->setVar('tpl_source', $content, TRUE); $tplfile_new->setVar('tpl_desc', $blocks[$i]['description'], TRUE); $tplfile_new->setVar('tpl_lastmodified', time()); $tplfile_new->setVar('tpl_lastimported', 0); if (!$tplfile_handler->insert($tplfile_new)) { $msgs[] = sprintf(' <span style="color:#ff0000;">' . _MD_AM_TEMPLATE_UPDATE_FAIL . '</span>', '<strong>' . $blocks[$i]['template'] . '</strong>'); } else { $msgs[] = sprintf(' ' . _MD_AM_TEMPLATE_UPDATED, '<strong>' . $blocks[$i]['template'] . '</strong>'); if ($icmsConfig['template_set'] == 'default') { if (!$icmsAdminTpl->template_touch($tplfile_new->getVar('tpl_id'))) { $msgs[] = sprintf(' <span style="color:#ff0000;">' . _MD_AM_TEMPLATE_RECOMPILE_FAIL . '</span>', '<strong>' . $blocks[$i]['template'] . '</strong>'); } else { $msgs[] = sprintf(' ' . _MD_AM_TEMPLATE_RECOMPILED, '<strong>' . $blocks[$i]['template'] . '</strong>'); } } } } } } if ($fcount == 0) { $newbid = icms::$xoopsDB->genId(icms::$xoopsDB->prefix('newblocks') . '_bid_seq'); $block_name = addslashes($blocks[$i]['name']); /* @todo properly handle the block_type when updating the system module */ $sql = "INSERT INTO " . icms::$xoopsDB->prefix("newblocks") . " (bid, mid, func_num, options, name, title, content, side, weight, visible, block_type, c_type, isactive, dirname, func_file, show_func, edit_func, template, bcachetime, last_modified) VALUES ('" . (int) $newbid . "', '". (int) $module->getVar('mid') . "', '". (int) $i . "', '" . addslashes($options) . "', '" . $block_name . "', '" . $block_name . "', '', '1', '0', '0', 'M', 'H', '1', '" . addslashes($dirname) . "', '" . addslashes($blocks[$i]['file']) . "', '" . addslashes($blocks[$i]['show_func']) . "', '" . addslashes($editfunc) . "', '" . $template . "', '0', '" . time() . "')"; $result = icms::$xoopsDB->query($sql); if (!$result) { $msgs[] = sprintf(' ' . _MD_AM_CREATE_FAIL, $blocks[$i]['name']); echo $sql; } else { if (empty($newbid)) { $newbid = icms::$xoopsDB->getInsertId(); } $groups =& icms::$user->getGroups(); $gperm_handler = icms::handler('icms_member_groupperm'); foreach ($groups as $mygroup) { $bperm =& $gperm_handler->create(); $bperm->setVar('gperm_groupid', (int) $mygroup); $bperm->setVar('gperm_itemid', (int) $newbid); $bperm->setVar('gperm_name', 'block_read'); $bperm->setVar('gperm_modid', 1); if (!$gperm_handler->insert($bperm)) { $msgs[] = sprintf(' <span style="color:#ff0000;">' . _MD_AM_BLOCK_ACCESS_FAIL . '</span>', '<strong>' . $newbid . '</strong>', '<strong>' . $mygroup . '</strong>'); } else { $msgs[] = sprintf(' ' . _MD_AM_BLOCK_ACCESS_ADDED, '<strong>' . $newbid . '</strong>', '<strong>' . $mygroup . '</strong>'); } } if ($template != '') { $tplfile =& $tplfile_handler->create(); $tplfile->setVar('tpl_module', $dirname); $tplfile->setVar('tpl_refid', (int) $newbid); $tplfile->setVar('tpl_source', $content, TRUE); $tplfile->setVar('tpl_tplset', 'default'); $tplfile->setVar('tpl_file', $blocks[$i]['template'], TRUE); $tplfile->setVar('tpl_type', 'block'); $tplfile->setVar('tpl_lastimported', 0); $tplfile->setVar('tpl_lastmodified', time()); $tplfile->setVar('tpl_desc', $blocks[$i]['description'], TRUE); if (!$tplfile_handler->insert($tplfile)) { $msgs[] = sprintf(' <span style="color:#ff0000;">' . _MD_AM_TEMPLATE_INSERT_FAIL . '</span>', '<strong>' . $blocks[$i]['template'] . '</strong>'); } else { $newid = $tplfile->getVar('tpl_id'); $msgs[] = sprintf(' ' . _MD_AM_TEMPLATE_INSERTED, '<strong>' . $blocks[$i]['template'] . '</strong>', '<strong>' . $newid . '</strong>'); if ($icmsConfig['template_set'] == 'default') { if (!$icmsAdminTpl->template_touch($newid)) { $msgs[] = sprintf(' <span style="color:#ff0000;">' . _MD_AM_TEMPLATE_RECOMPILE_FAIL . '</span>', '<strong>' . $blocks[$i]['template'] . '</strong>'); } else { $msgs[] = sprintf(' ' . _MD_AM_TEMPLATE_RECOMPILED, '<strong>' . $blocks[$i]['template'] . '</strong>'); } } } } $msgs[] = sprintf(' ' . _MD_AM_BLOCK_CREATED, '<strong>' . $blocks[$i]['name'] . '</strong>', '<strong>' . $newbid . '</strong>'); $sql = "INSERT INTO " . icms::$xoopsDB->prefix('block_module_link') . " (block_id, module_id, page_id) VALUES ('" . (int) $newbid . "', '0', '1')"; icms::$xoopsDB->query($sql); } } } } $icms_block_handler = icms::handler('icms_view_block'); $block_arr = $icms_block_handler->getByModule($module->getVar('mid')); foreach ($block_arr as $block) { if (!in_array($block->getVar('show_func'), $showfuncs) || !in_array($block->getVar('func_file'), $funcfiles)) { $sql = sprintf("DELETE FROM %s WHERE bid = '%u'", icms::$xoopsDB->prefix('newblocks'), (int) $block->getVar('bid')); if (!icms::$xoopsDB->query($sql)) { $msgs[] = sprintf(' <span style="color:#ff0000;">' . _MD_AM_BLOCK_DELETE_FAIL . '</span>', '<strong>' . $block->getVar('name') . '</strong>', '<strong>' . $block->getVar('bid') . '</strong>'); } else { $msgs[] = sprintf(' ' . _MD_AM_BLOCK_DELETED, '<strong>' . $block->getVar('name') . '</strong>', '<strong>' . $block->getVar('bid') . '</strong>'); if ($block->getVar('template') != '') { $tplfiles =& $tplfile_handler->find(NULL, 'block', $block->getVar('bid')); if (is_array($tplfiles)) { $btcount = count($tplfiles); for ($k = 0; $k < $btcount; $k++) { if (!$tplfile_handler->delete($tplfiles[$k])) { $msgs[] = sprintf(' <span style="color:#ff0000;">' . _MD_AM_BLOCK_TMPLT_DELETE_FAILED . '</span>', '<strong>' . $tplfiles[$k]->getVar('tpl_file') . '</strong>', '<strong>' . $tplfiles[$k]->getVar('tpl_id') . '</strong>'); } else { $msgs[] = sprintf(' ' . _MD_AM_BLOCK_TMPLT_DELETED, '<strong>' . $tplfiles[$k]->getVar('tpl_file') . '</strong>', '<strong>' . $tplfiles[$k]->getVar('tpl_id') . '</strong>'); } } } } } } } } // first delete all config entries $config_handler = icms::handler('icms_config'); $configs =& $config_handler->getConfigs(new icms_db_criteria_Item('conf_modid', $module->getVar('mid'))); $confcount = count($configs); $config_delng = array(); if ($confcount > 0) { $msgs[] = _MD_AM_CONFIGOPTION_DELETED; for ($i = 0; $i < $confcount; $i++) { if (!$config_handler->deleteConfig($configs[$i])) { $msgs[] = sprintf(' <span style="color:#ff0000;">' . _MD_AM_CONFIGOPTION_DELETE_FAIL . '</span>', '<strong>' . $configs[$i]->getvar('conf_id') . '</strong>'); // save the name of config failed to delete for later use $config_delng[] = $configs[$i]->getvar('conf_name'); } else { $config_old[$configs[$i]->getvar('conf_name')]['value'] = $configs[$i]->getvar('conf_value', 'N'); $config_old[$configs[$i]->getvar('conf_name')]['formtype'] = $configs[$i]->getvar('conf_formtype'); $config_old[$configs[$i]->getvar('conf_name')]['valuetype'] = $configs[$i]->getvar('conf_valuetype'); $msgs[] = sprintf(' ' . _MD_AM_CONFIGOPTION_DELETED, '<strong>' . $configs[$i]->getVar('conf_id') . '</strong>'); } } } // now reinsert them with the new settings $configs = $module->getInfo('config'); if ($configs !== FALSE) { if ($module->getVar('hascomments') != 0) { include_once ICMS_INCLUDE_PATH . '/comment_constants.php' ; array_push($configs, array( 'name' => 'com_rule', 'title' => '_CM_COMRULES', 'description' => '', 'formtype' => 'select', 'valuetype' => 'int', 'default' => 1, 'options' => array( '_CM_COMNOCOM' => XOOPS_COMMENT_APPROVENONE, '_CM_COMAPPROVEALL' => XOOPS_COMMENT_APPROVEALL, '_CM_COMAPPROVEUSER' => XOOPS_COMMENT_APPROVEUSER, '_CM_COMAPPROVEADMIN' => XOOPS_COMMENT_APPROVEADMIN) ) ); array_push($configs, array( 'name' => 'com_anonpost', 'title' => '_CM_COMANONPOST', 'description' => '', 'formtype' => 'yesno', 'valuetype' => 'int', 'default' => 0 ) ); } } else { if ($module->getVar('hascomments') != 0) { include_once ICMS_INCLUDE_PATH . '/comment_constants.php' ; $configs[] = array( 'name' => 'com_rule', 'title' => '_CM_COMRULES', 'description' => '', 'formtype' => 'select', 'valuetype' => 'int', 'default' => 1, 'options' => array( '_CM_COMNOCOM' => XOOPS_COMMENT_APPROVENONE, '_CM_COMAPPROVEALL' => XOOPS_COMMENT_APPROVEALL, '_CM_COMAPPROVEUSER' => XOOPS_COMMENT_APPROVEUSER, '_CM_COMAPPROVEADMIN' => XOOPS_COMMENT_APPROVEADMIN ) ); $configs[] = array( 'name' => 'com_anonpost', 'title' => '_CM_COMANONPOST', 'description' => '', 'formtype' => 'yesno', 'valuetype' => 'int', 'default' => 0 ); } } if ($module->getVar('hasnotification') != 0) { if (empty($configs)) { $configs = array(); } // Main notification options include_once ICMS_INCLUDE_PATH . '/notification_constants.php'; $options = array( '_NOT_CONFIG_DISABLE' => XOOPS_NOTIFICATION_DISABLE, '_NOT_CONFIG_ENABLEBLOCK' => XOOPS_NOTIFICATION_ENABLEBLOCK, '_NOT_CONFIG_ENABLEINLINE' => XOOPS_NOTIFICATION_ENABLEINLINE, '_NOT_CONFIG_ENABLEBOTH' => XOOPS_NOTIFICATION_ENABLEBOTH, ); $configs[] = array( 'name' => 'notification_enabled', 'title' => '_NOT_CONFIG_ENABLE', 'description' => '_NOT_CONFIG_ENABLEDSC', 'formtype' => 'select', 'valuetype' => 'int', 'default' => XOOPS_NOTIFICATION_ENABLEBOTH, 'options'=>$options ); // Event specific notification options // FIXME: for some reason the default doesn't come up properly // initially is ok, but not when 'update' module.. $options = array(); $notification_handler = icms::handler('icms_data_notification'); $categories =& $notification_handler->categoryInfo('', $module->getVar('mid')); foreach ($categories as $category) { $events =& $notification_handler->categoryEvents($category['name'], FALSE, $module->getVar('mid')); foreach ($events as $event) { if (!empty($event['invisible'])) { continue; } $option_name = $category['title'] . ' : ' . $event['title']; $option_value = $category['name'] . '-' . $event['name']; $options[$option_name] = $option_value; } } $configs[] = array( 'name' => 'notification_events', 'title' => '_NOT_CONFIG_EVENTS', 'description' => '_NOT_CONFIG_EVENTSDSC', 'formtype' => 'select_multi', 'valuetype' => 'array', 'default' => array_values($options), 'options' => $options ); } if ($configs !== FALSE) { $msgs[] = _MD_AM_CONFIG_ADDING; $config_handler = icms::handler('icms_config'); $order = 0; foreach ($configs as $config) { // only insert ones that have been deleted previously with success if (!in_array($config['name'], $config_delng)) { $confobj =& $config_handler->createConfig(); $confobj->setVar('conf_modid', (int) $newmid); $confobj->setVar('conf_catid', 0); $confobj->setVar('conf_name', $config['name']); $confobj->setVar('conf_title', $config['title'], TRUE); $confobj->setVar('conf_desc', $config['description'], TRUE); $confobj->setVar('conf_formtype', $config['formtype']); $confobj->setVar('conf_valuetype', $config['valuetype']); if (isset($config_old[$config['name']]['value']) && $config_old[$config['name']]['formtype'] == $config['formtype'] && $config_old[$config['name']]['valuetype'] == $config['valuetype'] ) { // preserve the old value if any // form type and value type must be the same // need to deal with arrays, because getInfo('config') doesn't convert arrays if (is_array($config_old[$config['name']]['value'])) { $confobj->setVar('conf_value', serialize($config_old[$config['name']]['value']), TRUE); } else { $confobj->setVar('conf_value', $config_old[$config['name']]['value'], TRUE); } } else { $confobj->setConfValueForInput($config['default'], TRUE); } $confobj->setVar('conf_order', $order); $confop_msgs = ''; if (isset($config['options']) && is_array($config['options'])) { foreach ($config['options'] as $key => $value) { $confop =& $config_handler->createConfigOption(); $confop->setVar('confop_name', $key, TRUE); $confop->setVar('confop_value', $value, TRUE); $confobj->setConfOptions($confop); $confop_msgs .= sprintf('<br /> ' . _MD_AM_CONFIGOPTION_ADDED, '<strong>' . $key . '</strong>', '<strong>' . $value . '</strong>'); unset($confop); } } $order++; if (FALSE !== $config_handler->insertConfig($confobj)) { $msgs[] = sprintf(' ' . _MD_AM_CONFIG_ADDED, '<strong>' . $config['name'] . '</strong>. ') . $confop_msgs; } else { $msgs[] = sprintf(' <span style="color:#ff0000;">' . _MD_AM_CONFIG_ADD_FAIL . '</span>', '<strong>' . $config['name'] . '</strong>. '); } unset($confobj); } } unset($configs); } // add module specific tasks to system autotasks list $atasks = $module->getInfo('autotasks'); $atasks_handler = &icms_getModuleHandler('autotasks', 'system'); if (isset($atasks) && is_array($atasks) && (count($atasks) > 0)) { $msgs[] = _MD_AM_AUTOTASK_UPDATE; $criteria = new icms_db_criteria_Compo(); $criteria->add(new icms_db_criteria_Item('sat_type', 'addon/' . $module->getInfo('dirname'))); $items_atasks = $atasks_handler->getObjects($criteria, FALSE); foreach ($items_atasks as $task) { $taskID = (int) $task->getVar('sat_addon_id'); $atasks[$taskID]['enabled'] = $task->getVar('sat_enabled'); $atasks[$taskID]['repeat'] = $task->getVar('sat_repeat'); $atasks[$taskID]['interval'] = $task->getVar('sat_interval'); $atasks[$taskID]['name'] = $task->getVar('sat_name'); } $atasks_handler->deleteAll($criteria); if (is_array($atasks)) { foreach ($atasks as $taskID => $taskData) { if (!isset($taskData['code']) || trim($taskData['code']) == '') continue; $task = &$atasks_handler->create(); if (isset($taskData['enabled'])) $task->setVar('sat_enabled', $taskData['enabled']); if (isset($taskData['repeat'])) $task->setVar('sat_repeat', $taskData['repeat']); if (isset($taskData['interval'])) $task->setVar('sat_interval', $taskData['interval']); if (isset($taskData['onfinish'])) $task->setVar('sat_onfinish', $taskData['onfinish']); $task->setVar('sat_name', $taskData['name']); $task->setVar('sat_code', $taskData['code']); $task->setVar('sat_type', 'addon/' . $module->getInfo('dirname')); $task->setVar('sat_addon_id', (int) $taskID); if (!($atasks_handler->insert($task))) { $msgs[] = sprintf(' <span style="color:#ff0000;">' . _MD_AM_AUTOTASK_FAIL . '</span>', '<strong>' . $taskData['name'] . '</strong>'); } else { $msgs[] = sprintf(' ' . _MD_AM_AUTOTASK_ADDED, '<strong>' . $taskData['name'] . '</strong>'); } } } unset($atasks, $atasks_handler, $task, $taskData, $criteria, $items, $taskID); } // execute module specific update script if any $update_script = $module->getInfo('onUpdate'); $ModName = ($module->getInfo('modname') != '') ? trim($module->getInfo('modname')) : $dirname; if (FALSE !== $update_script && trim($update_script) != '') { include_once ICMS_MODULES_PATH . '/' . $dirname . '/' . trim($update_script); $is_IPF = $module->getInfo('object_items'); if (!empty($is_IPF)) { $icmsDatabaseUpdater = icms_db_legacy_Factory::getDatabaseUpdater(); $icmsDatabaseUpdater->moduleUpgrade($module, TRUE); array_merge($msgs, $icmsDatabaseUpdater->_messages); } if (function_exists('xoops_module_update_' . $ModName)) { $func = 'xoops_module_update_' . $ModName; if (!$func($module, $prev_version, $prev_dbversion)) { $msgs[] = sprintf(_MD_AM_FAIL_EXEC, '<strong>' . $func . '</strong>'); } else { $msgs[] = $module->messages; $msgs[] = sprintf(_MD_AM_FUNCT_EXEC, '<strong>' . $func . '</strong>'); } } elseif (function_exists('icms_module_update_' . $ModName)) { $func = 'icms_module_update_' . $ModName; if (!$func($module, $prev_version, $prev_dbversion)) { $msgs[] = sprintf(_MD_AM_FAIL_EXEC, '<strong>' . $func . '</strong>'); } else { $msgs[] = $module->messages; $msgs[] = sprintf(_MD_AM_FUNCT_EXEC, '<strong>' . $func . '</strong>'); } } } $msgs[] = '</code><p>' . sprintf(_MD_AM_OKUPD, '<strong>' . $module->getVar('name') . '</strong>') . '</p>'; } $ret = '<code>' . implode('<br />', $msgs); return $ret; }
} if ($dbVersion < $newDbVersion) { $table = new icms_db_legacy_updater_Table('modules'); if ($table->fieldExists('dbversion')) { $icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` MODIFY dbversion INT(11) unsigned NOT NULL DEFAULT 1", 'Successfully modified field dbversion in table modules', ''); } $icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` MODIFY version smallint(5) unsigned NOT NULL default '102'", 'Successfully modified field version in table modules', ''); unset($table); $icmsDatabaseUpdater->updateModuleDBVersion($newDbVersion, 'system'); echo sprintf(_DATABASEUPDATER_UPDATE_OK, icms_conv_nr2local($newDbVersion)) . '<br />'; } if (!$abortUpdate) { $newDbVersion = 9; } if ($dbVersion < $newDbVersion) { $table = new icms_db_legacy_updater_Table('users'); $icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` DROP INDEX unamepass, ADD INDEX unamepass (uname (10), pass (10))", 'Successfully altered the index unamepass on table users', ''); $icmsDatabaseUpdater->runQuery("ALTER TABLE `" . $table->name() . "` MODIFY pass_expired tinyint(1) unsigned NOT NULL default 0", 'Successfully altered field pass_expired in table users', ''); unset($table); $icmsDatabaseUpdater->updateModuleDBVersion($newDbVersion, 'system'); echo sprintf(_DATABASEUPDATER_UPDATE_OK, icms_conv_nr2local($newDbVersion)) . '<br />'; } if (!$abortUpdate) { $newDbVersion = 10; } if ($dbVersion < $newDbVersion) { if (getDbValue(icms::$xoopsDB, 'newblocks', 'show_func', 'show_func="b_social_bookmarks"') == FALSE) { $sql = "SELECT bid FROM `" . icms::$xoopsDB->prefix('newblocks') . "` WHERE show_func='b_social_bookmarks'"; $result = icms::$xoopsDB->query($sql); list($new_block_id) = icms::$xoopsDB->FetchRow($result); icms::$xoopsDB->queryF(" INSERT INTO " . icms::$xoopsDB->prefix("block_module_link") . " VALUES (" . $new_block_id . ", 0, 1);");