$content = $dbm->report();
if (!$result) {
//$deleted = $dbm->deleteTables($tables);
$content .= "<p>" . _INSTALL_L114 . "</p>\n";
$b_back = array('start', _INSTALL_L103);
} else {
$content .= "<p>" . _INSTALL_L115 . "</p>\n";
$b_next = array('siteInit', _INSTALL_L112);
}
include 'install_tpl.php';
break;
case 'updateTables':
include_once "../mainfile.php";
include_once './class/dbmanager.php';
$db = new db_manager();
$sql = 'SELECT * FROM ' . $db->prefix('groups');
$result = $db->query($sql);
$content = '<h5>' . _INSTALL_L157 . '</h5>';
$content .= '<table align="center" cellspacing="0" border="1"><tr><td>' . _INSTALL_L158 . '</td><td>' . _INSTALL_L159 . '</td><td>' . _INSTALL_L160 . '</td><td>' . _INSTALL_L161 . '</td></tr>';
while ($myrow = $db->fetchArray($result)) {
if ($myrow['type'] == 'Admin') {
$content .= '<tr><td>' . $myrow['name'] . '</td><td><input type="radio" name="g_webmasters" value="' . $myrow['groupid'] . '" /></td><td> </td><td> </td></tr>';
} elseif ($myrow['type'] == 'User') {
$content .= '<tr><td>' . $myrow['name'] . '</td><td> </td><td><input type="radio" name="g_users" value="' . $myrow['groupid'] . '" /></td><td> </td></tr>';
} else {
$content .= '<tr><td>' . $myrow['name'] . '</td><td> </td><td> </td><td><input type="radio" name="g_anonymous" value="' . $myrow['groupid'] . '" /></td></tr>';
}
}
$content .= '</table>';
$b_back = array();
$b_next = array('updateTables_go', _INSTALL_L132);
$msgs[] = ' Config <b>' . $config['name'] . '</b> added to the database.' . $confop_msgs;
} else {
$msgs[] = ' <span style="color:#ff0000;">ERROR: Could not insert config <b>' . $config['name'] . '</b> to the database.</span>';
}
unset($confobj);
}
unset($configs);
}
foreach ($msgs as $msg) {
echo '<code>' . $msg . '</code><br />';
}
}
// data for table 'block_module_link'
include_once './class/dbmanager.php';
$dbm = new db_manager();
$sql = 'SELECT bid, side FROM ' . $dbm->prefix('newblocks');
$result = $dbm->query($sql);
while ($myrow = $dbm->fetchArray($result)) {
if ($myrow['side'] == 0) {
$dbm->insert("block_module_link", " VALUES (" . $myrow['bid'] . ", 0)");
} else {
$dbm->insert("block_module_link", " VALUES (" . $myrow['bid'] . ", -1)");
}
}
}
echo '<br />';
flush();
sleep(1);
}
$title = _INSTALL_L142;
$content = "<table width='80%' align='center'><tr><td align='left'>\n";
// , '9' => 'skin_blockcenter_r.html');
// foreach ($skinfiles as $key => $skinfile) {
// if(preg_match('/\.css$/', $skinfile)) {
// $type = 'css';
// }else{
// $type = 'skin';
// }
// $dbm->insert('tplfile', " VALUES ($key, 0, '', 'default', '$skinfile', '', $time, $time, '$type')");
// $fp = fopen('./templates/default_skin/'.$skinfile, 'r');
// $skinsource = fread($fp, filesize('./templates/default_skin/'.$skinfile));
// fclose($fp);
// $dbm->insert('tplsource', " (tpl_id, tpl_source) VALUES ($key, '".addslashes($skinsource)."')");
// 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';
$mm = new mainfile_manager("../mainfile.php");
$mm->setRewrite('XOOPS_GROUP_ADMIN', $g_webmasters);
$mm->setRewrite('XOOPS_GROUP_USERS', $g_users);
$mm->setRewrite('XOOPS_GROUP_ANONYMOUS', $g_anonymous);
$ret = $mm->doRewrite();
if (!$ret) {
$content = _INSTALL_L60;
include './install_tpl.php';
exit;
}
}
if (false != $error) {
$b_back = array();
$content = _INSTALL_L162;
include './install_tpl.php';
break;
}
include_once './class/dbmanager.php';
$dbm = new db_manager();
if (!$dbm->query("ALTER TABLE " . $dbm->prefix("newblocks") . " ADD dirname VARCHAR(50) NOT NULL, ADD func_file VARCHAR(50) NOT NULL, ADD show_func VARCHAR(50) NOT NULL, ADD edit_func VARCHAR(50) NOT NULL")) {
}
$result = $dbm->queryFromFile('./sql/upgrade/' . XOOPS_DB_TYPE . '.structure.sql');
$content = $dbm->report();
if (!$result) {
$content .= "<p>" . _INSTALL_L135 . "</p>\n";
$b_back = array();
} else {
$content .= "<p>" . _INSTALL_L136 . "</p>\n";
$b_next = array('updateConfig', _INSTALL_L14);
}
include './install_tpl.php';
