I'm assuming you don't have a backup of your old mainfile.php, so here's the easiest ways I've found...
Option 1Make a backup of your database using a tool like phpMyAdmin. When you go to export the database, make sure "Drop table if exists" is selected in the options. Leave everything else at its default setting.
After you've made a backup of your database and verified it, drop the database from the server.
Now, just install the new version of XOOPS just like you are starting from scratch, except give the new installation the same database server, db name, db username, db password, and db prefix as your original install.
Now import the original database you backed up earlier. This will overwrite the new database, thus restoring your data.
If your database is over 2MB, you may want to look into a Staggered MySQL Dump Importer like BigDump.
Link:
http://www.ozerov.de/bigdump.phpOption 2Delete the contents of mainfile.php, paste the following into your mainfile.php and change the values in
bold red.
// $Id: mainfile.dist.php,v 1.7 2004/12/26 19:11:47 Onokazu Exp $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
// //
// ------------------------------------------------------------------------ //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// You may not change or alter any portion of this comment or credits //
// of supporting developers from this source code or any supporting //
// source code which is considered copyrighted (c) material of the //
// original comment or credit authors. //
// //
// This program is distributed in the hope that it will be useful, //
// but WITHOUT ANY WARRANTY; without even the implied warranty of //
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------ //
if ( !defined("XOOPS_MAINFILE_INCLUDED") ) {
define("XOOPS_MAINFILE_INCLUDED",1);
// XOOPS Physical Path
// Physical path to your main XOOPS directory WITHOUT trailing slash
// Example: define('XOOPS_ROOT_PATH', '/your/www/path');
define('XOOPS_ROOT_PATH', '[b][color=ff0000]/your/www/path[/color][/b]');
// XOOPS Virtual Path (URL)
// Virtual path to your main XOOPS directory WITHOUT trailing slash
// Example: define('XOOPS_URL', 'http://www.yourwebsite.com');
define('XOOPS_URL', '[b][color=ff0000]http://www.yourwebsite.com[/color][/b]');
define('XOOPS_CHECK_PATH', 1);
// Protect against external scripts execution if safe mode is not enabled
if ( XOOPS_CHECK_PATH && !@ini_get('safe_mode') ) {
if ( function_exists('debug_backtrace') ) {
$xoopsScriptPath = debug_backtrace();
if ( !count($xoopsScriptPath) ) {
die("XOOPS path check: this file cannot be requested directly");
}
$xoopsScriptPath = $xoopsScriptPath[0]['file'];
} else {
$xoopsScriptPath = isset($_SERVER['PATH_TRANSLATED']) ? $_SERVER['PATH_TRANSLATED'] : $_SERVER['SCRIPT_FILENAME'];
}
if ( DIRECTORY_SEPARATOR != '/' ) {
// IIS6 may double the chars
$xoopsScriptPath = str_replace( strpos( $xoopsScriptPath, '\\', 2 ) ? '\\' : DIRECTORY_SEPARATOR, '/', $xoopsScriptPath);
}
if ( strcasecmp( substr($xoopsScriptPath, 0, strlen(XOOPS_ROOT_PATH)), str_replace( DIRECTORY_SEPARATOR, '/', XOOPS_ROOT_PATH)) ) {
exit("XOOPS path check: Script is not inside XOOPS_ROOT_PATH and cannot run.");
}
}
// Database
// Choose the database to be used
define('XOOPS_DB_TYPE', 'mysql');
// Table Prefix
// This prefix will be added to all new tables created to avoid name conflict in the database. If you are unsure, just use the default 'xoops'.
define('XOOPS_DB_PREFIX', '[b][color=ff0000]YourPrefix[/color][/b]');
// Database Hostname
// Hostname of the database server. If you are unsure, 'localhost' works in most cases.
define('XOOPS_DB_HOST', '[b][color=ff0000]db_host[/color][/b]');
// Database Username
// Your database user account on the host
define('XOOPS_DB_USER', '[b][color=ff0000]db_user[/color][/b]');
// Database Password
// Password for your database user account
define('XOOPS_DB_PASS', '[b][color=ff0000]db_passwd[/color][/b]');
// Database Name
// The name of database on the host. The installer will attempt to create the database if not exist
define('XOOPS_DB_NAME', '[b][color=ff0000]db_name[/color][/b]');
// Use persistent connection? (Yes=1 No=0)
// Default is 'Yes'. Choose 'Yes' if you are unsure.
define('XOOPS_DB_PCONNECT', 0);
define('XOOPS_GROUP_ADMIN', '1');
define('XOOPS_GROUP_USERS', '2');
define('XOOPS_GROUP_ANONYMOUS', '3');
if (!isset($xoopsOption['nocommon']) && XOOPS_ROOT_PATH != '') {
include XOOPS_ROOT_PATH."/include/common.php";
}
}
?>
Don't forget to chmod mainfile.php to 444 when your done!
Hope this helps.
James
Insanity can be defined as "doing the same thing over and over and expecting different results."
Stupidity is not a crime. Therefore, you are free to go.
