function prepare2upgrade()
{
include_once XOOPS_ROOT_PATH . '/modules/AMS/upgrade/class/dbmanager.php';
include_once XOOPS_ROOT_PATH . '/modules/AMS/upgrade/language/install.php';
$dbm = new db_manager();
$dbm->queryFromFile(XOOPS_ROOT_PATH . '/modules/AMS/sql/mysql.sql');
return $dbm->report();
}
// if(preg_match('/\.css$/',$skinfile)) {
// $cm->write($skinfile, $skinsource);
// }
// }
$dbm->query("INSERT INTO " . $dbm->prefix('group_permission') . " (gperm_groupid, gperm_itemid) SELECT groupid, block_id FROM " . $dbm->prefix('groups_blocks_link'));
$dbm->query("UPDATE " . $dbm->prefix('group_permission') . " SET gperm_name = 'block_read'");
$dbm->query("INSERT INTO " . $dbm->prefix('group_permission') . " (gperm_groupid, gperm_itemid) SELECT groupid, mid FROM " . $dbm->prefix('groups_modules_link') . " WHERE type='A'");
$dbm->query("UPDATE " . $dbm->prefix('group_permission') . " SET gperm_name = 'module_admin' WHERE gperm_name = ''");
$dbm->query("INSERT INTO " . $dbm->prefix('group_permission') . " (gperm_groupid, gperm_itemid) SELECT groupid, mid FROM " . $dbm->prefix('groups_modules_link') . " WHERE type='R'");
$dbm->query("UPDATE " . $dbm->prefix('group_permission') . " SET gperm_name = 'module_read' WHERE gperm_name = ''");
$dbm->query("UPDATE " . $dbm->prefix('group_permission') . " SET gperm_modid = 1");
$dbm->query('DROP TABLE ' . $dbm->prefix('groups_blocks_link'));
$dbm->query('DROP TABLE ' . $dbm->prefix('groups_modules_link'));
// insert some more data
$result = $dbm->queryFromFile('./sql/' . XOOPS_DB_TYPE . '.data.sql');
$content = $dbm->report();
//$content .= $cm->report();
$b_next = array('updateModules', _INSTALL_L14);
include 'install_tpl.php';
break;
case 'updateModules':
$b_next = array('updateModules_go', _INSTALL_L137);
$content = "<p>" . _INSTALL_L141 . "</p>\n";
include 'install_tpl.php';
break;
case 'updateModules_go':
unset($xoopsOption['nocommon']);
include_once "../mainfile.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<?php
/**
*
* @package Legacy
* @version $Id: install_createTables.inc.php,v 1.3 2008/09/25 15:12:35 kilica Exp $
* @copyright Copyright 2005-2007 XOOPS Cube Project <https://github.com/xoopscube/legacy>
* @license https://github.com/xoopscube/legacy/blob/master/docs/GPL_V2.txt GNU GENERAL PUBLIC LICENSE Version 2
*
*/
include_once '../mainfile.php';
include_once './class/dbmanager.php';
$dbm = new db_manager();
$tables = array();
$result = $dbm->queryFromFile('./sql/' . XOOPS_DB_TYPE . '.structure.sql');
$wizard->assign('reports', $dbm->report());
if (!$result) {
$wizard->assign('message', _INSTALL_L114);
$wizard->setBack(array('start', _INSTALL_L103));
} else {
$wizard->assign('message', _INSTALL_L115);
}
$wizard->render('install_createTables.tpl.php');
} else {
echo "Error: Permissions NOT copied <br />";
}
}
break;
case "Update":
/*
include_once XOOPS_ROOT_PATH."/modules/AMS/include/update.php";
xoops_module_update_AMS($xoopsModule, 220); //invoke update procedure - the SQL will fail if already upgraded, but no harm should come to it.
header('location: '.XOOPS_URL.'/modules/system/admin.php?fct=modulesadmin&op=update&module=AMS');
exit();*/
include_once XOOPS_ROOT_PATH . '/modules/AMS/upgrade/class/dbmanager.php';
include_once XOOPS_ROOT_PATH . '/modules/AMS/upgrade/language/install.php';
$dbm = new db_manager();
$dbm->queryFromFile(XOOPS_ROOT_PATH . '/modules/AMS/sql/upgrade.sql');
$feedback = $dbm->report();
echo $feedback;
echo "<br /><br /><a href='" . XOOPS_URL . "/modules/system/admin.php?fct=modulesadmin&op=update&module=AMS'>Proceed</a>";
xoops_cp_footer();
exit;
}
}
include_once XOOPS_ROOT_PATH . "/class/xoopsformloader.php";
$upgrade_form = new XoopsThemeForm('Upgrade', 'upgradeform', 'index.php');
if (!isset($_POST['submit'])) {
$upgrade_form->addElement(new XoopsFormButton('Import Articles and Topics from News module', 'submit', 'Import', 'submit'));
$upgrade_form->addElement(new XoopsFormButton('Articles and Topics ARE Imported Earlier, Proceed to Next Step', 'submit', 'Proceed', 'submit'));
} else {
$upgrade_form->addElement(new XoopsFormButton('MOVE Comments From News Articles to AMS Articles', 'submit', 'Comments', 'submit'));
$mod_handler =& xoops_gethandler('module');
$newsModule =& $mod_handler->getByDirname('news');
$content .= _INSTALL_NO_PLUS_MOD;
}
//Install protector module by default if found.
//TODO: Insert Protector installation - leads to blank page as it is now.
if (file_exists(ICMS_ROOT_PATH . '/modules/protector/xoops_version.php')) {
$content .= xoops_module_install('protector');
/* include_once "./class/mainfilemanager.php";
$mm = new mainfile_manager("../mainfile.php");
$mm->setRewrite('PROTECTOR1', 'include XOOPS_TRUST_PATH.\'/modules/protector/include/precheck.inc.php\')' ;
$mm->setRewrite('PROTECTOR2', 'include XOOPS_TRUST_PATH.\'/modules/protector/include/postcheck.inc.php\')' ;
$result = $mm->doRewrite();
$mm->report();*/
}
$tables = array();
$content .= "<div style='height:auto;max-height:400px;overflow:auto;'>" . $dbm->report() . "</div>";
} else {
$wizard->redirectToPage('+1');
exit;
}
} else {
$content .= '<div>' . _INSTALL_SELECT_MODS_INTRO . '</div>';
$content .= '<div class="dbconn_line">';
$content .= '<h3>' . _INSTALL_SELECT_MODULES . '</h3>';
$content .= '<div id="modinstall" name="install_mods[]">';
$langarr = icms_module_Handler::getAvailable();
foreach ($langarr as $lang) {
if ($lang == 'system' || $lang == 'protector') {
continue;
}
$content .= "<div class=\"langselect\" style=\"text-decoration: none;\"><a href=\"javascript:void(0);\" style=\"text-decoration: none;\"><img src=\"../modules/{$lang}/images/icon_small.png\" alt=\"{$lang}\" /><br />{$lang} <br /><input type=\"checkbox\" checked=\"checked\" name=\"install_mods[]\" value=\"{$lang}\" /></a></div>";
*
* @copyright The XOOPS project http://www.xoops.org/
* @license http://www.fsf.org/copyleft/gpl.html GNU General Public License (GPL)
* @package installer
* @since 2.3.0
* @author Haruki Setoyama <*****@*****.**>
* @author Kazumi Ono <*****@*****.**>
* @author Skalpa Keo <*****@*****.**>
* @author Taiwen Jiang <*****@*****.**>
* @author DuGris (aka L. JEN) <*****@*****.**>
* @version $Id: page_tablescreate.php 3558 2009-09-03 01:55:38Z trabis $
**/
require_once './include/common.inc.php';
defined('XOOPS_INSTALL') or die('XOOPS Installation wizard die');
$pageHasForm = false;
$pageHasHelp = false;
$vars =& $_SESSION['settings'];
include_once "../mainfile.php";
include_once './class/dbmanager.php';
$dbm = new db_manager();
if (!$dbm->isConnectable()) {
$wizard->redirectToPage('-3');
exit;
}
if ($dbm->tableExists('users')) {
$content = '<div class="x2-note confirmMsg">' . XOOPS_TABLES_FOUND . '</div>';
} else {
$result = $dbm->queryFromFile('./sql/' . XOOPS_DB_TYPE . '.structure.sql');
$content = '<div class="x2-note successMsg">' . XOOPS_TABLES_CREATED . "</div><br />" . $dbm->report();
}
include './include/install_tpl.php';
