public function updateDatabase() { global $navigation; global $htmlOutput; require_once 'db/db100.php'; $answer = ''; if (\Db_100::getSystemVariable('version') != '1.0.4') { $module = \Db_100::getModule(null, 'administrator', 'email_queue'); $group = \Db_100::getParameterGroup($module['id'], 'admin_translations'); \Db_100::addStringParameter($group['id'], 'Email queue', 'email_queue', 'Email queue', 1); $module = \Db_100::getModule(null, 'developer', 'modules'); $group = \Db_100::getParameterGroup($module['id'], 'admin_translations_install'); \Db_100::addStringParameter($group['id'], 'Updated module detected', 'updated_module_detected', 'New version detected', 1); \Db_100::addStringParameter($group['id'], 'Install', 'install', 'Install', 1); \Db_100::addStringParameter($group['id'], 'Update', 'update', 'Update', 1); $module = \Db_100::getModule(null, 'standard', 'menu_management'); $group = \Db_100::getParameterGroup($module['id'], 'admin_translations'); \Db_100::addStringParameter($group['id'], 'Save', 'save', 'Save', 1); $module = \Db_100::getModule(null, 'community', 'newsletter'); $group = \Db_100::getParameterGroup($module['id'], 'admin_translations'); \Db_100::addStringParameter($group['id'], 'Where to send?', 'where_to_send', 'Send test email to: ', 1); $sql = "update `" . DB_PREF . "parameter` set `name` = 'was_sent' where `name` = 'was_send' "; $rs = mysql_query($sql); if (!$rs) { trigger_error($sql . ' ' . mysql_error()); } //delete duplicated parameter $module = \Db_100::getModule(null, 'developer', 'std_mod'); $group = \Db_100::getParameterGroup($module['id'], 'admin_translations'); $sql = "select * from `" . DB_PREF . "parameter` where `group_id` = '" . (int) $group['id'] . "' and `name` = '" . mysql_real_escape_string('error_required') . "'"; $rs = mysql_query($sql); $parameters = array(); if ($rs) { while ($lock = mysql_fetch_assoc($rs)) { $parameters[] = $lock; } } else { trigger_error($sql . " " . mysql_error()); } if (sizeof($parameters) > 1) { $sql = "delete from `" . DB_PREF . "parameter` where `id` = " . (int) $parameters[1]['id'] . " "; $rs = mysql_query($sql); if (!$rs) { trigger_error($sql . " " . mysql_error()); } } //end delete duplicated parameter //fix logo galery layout field $sql = "update `" . DB_PREF . "mc_text_photos_logo_gallery` set `layout` = 'default' where `layout` = 'undefined' "; $rs = mysql_query($sql); if (!$rs) { trigger_error($sql . ' ' . mysql_error()); } //correct separator module_id field $sql = "select * from `" . DB_PREF . "content_element_to_modules` where `group_key` = 'text_photos' and `module_key` = 'separator' "; $rs = mysql_query($sql); if (!$rs) { trigger_error($sql . ' ' . mysql_error()); } $contentToModule = array(); while ($lock = mysql_fetch_assoc($rs)) { $contentToModule[] = $lock; } $sql = "select * from `" . DB_PREF . "mc_text_photos_separator` where 1 "; $rs = mysql_query($sql); if (!$rs) { trigger_error($sql . ' ' . mysql_error()); } $separators = array(); while ($lock = mysql_fetch_assoc($rs)) { $separators[] = $lock; } foreach ($contentToModule as $key => $module) { if (isset($separators[$key])) { $sql = "update `" . DB_PREF . "content_element_to_modules` set `module_id` = " . (int) $separators[$key]['id'] . " where `id` = " . (int) $module['id'] . " "; $rs = mysql_query($sql); if (!$rs) { trigger_error($sql . ' ' . mysql_error()); } } } //end correct separator module_id field //fix to_big to too_big $sql = "update `" . DB_PREF . "parameter` set `name` = 'too_big' where `name` = 'to_big' "; $rs = mysql_query($sql); if (!$rs) { trigger_error($sql . ' ' . mysql_error()); } if ($this->curStep == $this->stepCount) { \Db_100::setSystemVariable('version', '1.0.4'); } } if ($this->curStep == $this->stepCount) { header("location: " . $navigation->generateLink($navigation->curStep() + 1)); } else { header("location: " . $navigation->generateLink($navigation->curStep(), $navigation->curScript() + 1)); } return $answer; }
public function updateDatabase() { global $navigation; global $htmlOutput; require_once 'db/db100.php'; $answer = ''; if (\Db_100::getSystemVariable('version') != '1.0.1 Beta') { $module = \Db_100::getModule(null, 'standard', 'menu_management'); $group = \Db_100::getParameterGroup($module['id'], 'admin_translations'); $sql = "\n INSERT INTO `" . DB_PREF . "parameter` (`name`, `admin`, `row_number`, `regexpression`, `group_id`, `translation`, `comment`, `type`) VALUES\n('error_type_url_empty', 1, 17, '', " . $group['id'] . ", 'Error type url empty', NULL, 'string');\n "; $rs = mysql_query($sql); if ($rs) { $sql2 = "INSERT INTO `" . DB_PREF . "par_string` (`value`, `parameter_id`) VALUES\n('External url can\\'t be empty', " . mysql_insert_id() . ")"; $rs2 = mysql_query($sql2); if (!$rs2) { trigger_error($sql2 . " " . mysql_error()); } } else { trigger_error($sql . " " . mysql_error()); } if ($this->curStep == $this->stepCount) { \Db_100::setSystemVariable('version', '1.0.1 Beta'); } } if ($this->curStep == $this->stepCount) { header("location: " . $navigation->generateLink($navigation->curStep() + 1)); } else { header("location: " . $navigation->generateLink($navigation->curStep(), $navigation->curScript() + 1)); } return $answer; }