// php, php3, html, etc, whatever your vb board is running
// BACK UP YOUR DATABASE
##################################################################################################################
# CHANGE NOTHING BELOW THIS LINE # CHANGE NOTHING BELOW THIS LINE # CHANGE NOTHIING BELOW THIS LINE # CHANGE NOTHI
##################################################################################################################
include_once './../db_mysql.php';
include_once './../ImpExFunction.php';
include_once './../ImpExDatabaseCore.php';
// BACK UP YOUR DATABASE
extract(parse_ini_file('./../ImpExConfig.php'), EXTR_SKIP);
$Db_target = new DB_Sql_vb_impex();
$Db_target->appname = 'vBulletin:ImpEx Target';
$Db_target->appshortname = 'vBulletin:ImpEx Target';
$Db_target->type = 'mysql';
$Db_target->database = $targetdatabase;
$Db_target->connect($targetserver, $targetuser, $targetpassword, 0);
$Db_target->select_db($targetdatabase);
$Imp_database = new ImpExDatabaseCore();
$thread_ids_array = $Imp_database->get_threads_ids($Db_target, $Db_target->type, $target_table_prefix);
// BACK UP YOUR DATABASE
# Posts
if ($do_posts) {
$posts = $Db_target->query("SELECT postid, pagetext FROM " . $targettableprefix . "post");
while ($post = $Db_target->fetch_array($posts)) {
if (strrpos($post['pagetext'], $old_domain . $old_forum_path)) {
$text = $post['pagetext'];
// Threads id replacment
#viewtopic.php\?topic OR viewtopic.php\?t
$text = preg_replace("#(.*){$old_domain}{$old_forum_path}viewtopic.php\\?topic=([0-9]+)\\&forum=[0-9]+(.*)#isUe", "phpBB_thread_id_swapper(\$file_extenstion, \$new_domain, \$new_forum_path, '\\1', '\\2', \$thread_ids_array)", $post['pagetext']);
$Db_target->query("UPDATE " . $targettableprefix . "post SET pagetext='" . addslashes($text) . "' WHERE postid='" . $post['postid'] . "'");
echo "<br /><b>Post done -></b><i> " . $post['postid'] . "</i>";
define('IDIR', ($getcwd = getcwd()) ? $getcwd : '.');
include_once './../db_mysql.php';
// BACK UP YOUR DATABASE
require_once './../ImpExConfig.php';
$targetserver = $impexconfig['target']['server'];
$targetuser = $impexconfig['target']['user'];
$targetpassword = $impexconfig['target']['password'];
$targetdatabase = $impexconfig['target']['database'];
$targettableprefix = $impexconfig['target']['tableprefix'];
$targettablecharset = $impexconfig['target']['charset'];
$Db_target = new DB_Sql_vb_impex();
$Db_target->appname = 'vBulletin:ImpEx Target';
$Db_target->appshortname = 'vBulletin:ImpEx Target';
$Db_target->type = 'mysql';
$Db_target->database = $targetdatabase;
$Db_target->connect($targetserver, $targetuser, $targetpassword, 0, $targettablecharset);
$Db_target->select_db($targetdatabase);
// BACK UP YOUR DATABASE
# Posts
if ($do_posts) {
$posts = $Db_target->query("SELECT postid, pagetext, title FROM " . $targettableprefix . "post");
while ($post = $Db_target->fetch_array($posts)) {
$text = str_replace(array_keys($replacer), $replacer, $post['pagetext']);
$title_text = str_replace(array_keys($replacer), $replacer, $post['title']);
#$text = preg_replace('##siU', '', $text);
#$title_text = preg_replace('##siU', '', $text);
$Db_target->query("UPDATE " . $targettableprefix . "post SET pagetext='" . addslashes($text) . "', title='" . addslashes($title_text) . "' WHERE postid='" . $post['postid'] . "'");
echo "<br /><b>Post done -></b><i> " . $post['postid'] . "</i>";
}
}
# Signatures
// Id swapper.
// Swaps all the userids in the database for the imported userid
// THIS IS A GARRUNTEED WAY TO TRASH YOU DB !!!
// COMPLETLY INVALIDATES SUPPORT
// USE AT YOUR OWN RISK.
//
// I / we / the company takes no responsiability for you running this script
// Jerry - jerry.hutchings@vbulletin.com
define('DIR', ($getcwd = getcwd()) ? $getcwd : '.');
require_once DIR . '/db_mysql.php';
$Db_target = new DB_Sql_vb_impex();
$Db_target->server = 'localhost';
$Db_target->user = '******';
$Db_target->password = '******';
$Db_target->database = 'vb3';
$Db_target->connect();
$refrence_ids = array();
$ids = $Db_target->query("SELECT userid,importuserid FROM user where importuserid !='null'");
while ($id = $Db_target->fetch_array($ids)) {
$refrence_ids[$id['userid']] = $id['importuserid'];
}
echo "<h4>Altering tables.........</h4>";
// ALTER TO UNSIGNED && DROP PRIMARY KEY
$Db_target->query("ALTER TABLE `user` CHANGE `userid` `userid` INT( 10 ) NOT NULL");
$Db_target->query("ALTER TABLE `user` DROP PRIMARY KEY");
echo "<p>User table.....</p>";
$Db_target->query("ALTER TABLE `customavatar` CHANGE `userid` `userid` INT( 10 ) NOT NULL");
$Db_target->query("ALTER TABLE `customavatar` DROP PRIMARY KEY");
echo "<p>User table.....</p>";
echo "<h4>Tables well the truly done now ........</h4>";
$i = 0;
} else {
$ImpExDisplay->display_error($ImpExDisplay->phrases['no_mssql_support']);
$ImpExDisplay->display_error($ImpExDisplay->phrases['no_mssql_support_link']);
exit;
}
}
}
$Db_source->appname = 'vBulletin:ImpEx Source';
$Db_source->appshortname = 'vBulletin:ImpEx Source';
$Db_source->database = $impexconfig['source']['database'];
if (strtolower(trim($impexconfig['source']['databasetype'])) == 'mysql' or strtolower(trim($impexconfig['source']['databasetype'])) == 'mysqli') {
$Db_source->type = 'mysql';
} else {
$Db_source->type = $impexconfig['source']['databasetype'];
}
$Db_source->connect($impexconfig['source']['server'], $impexconfig['source']['user'], $impexconfig['source']['password'], $impexconfig['source']['persistent'], $impexconfig['source']['charset']);
if ($Db_source->link_id) {
// got connected
switch ($Db_source->geterrno()) {
case 1046:
$ImpExDisplay->display_error($ImpExDisplay->phrases['no_source_set']);
exit;
break;
case 1049:
$ImpExDisplay->display_error($ImpExDisplay->phrases['source_not_exsist']);
exit;
break;
}
} else {
$ImpExDisplay->display_error($ImpExDisplay->phrases['failed_connection']);
exit;
require_once IDIR . '/db_mysql.php';
require_once IDIR . '/ImpExFunction.php';
require_once IDIR . '/ImpExDatabaseCore.php';
require_once IDIR . '/ImpExDatabase_360.php';
require_once IDIR . '/ImpExModule.php';
require_once IDIR . '/ImpExSession.php';
require_once IDIR . '/ImpExController.php';
require_once IDIR . '/ImpExDisplay.php';
require_once IDIR . '/ImpExDisplayWrapper.php';
$Db_target = new DB_Sql_vb_impex();
$Db_source = new DB_Sql_vb_impex();
$Db_target->appname = 'vBulletin:ImpEx Target';
$Db_target->appshortname = 'vBulletin:ImpEx Target';
$Db_target->database = $impexconfig['target']['database'];
$Db_target->type = $impexconfig['target']['databasetype'];
$Db_target->connect($impexconfig['target']['server'], $impexconfig['target']['user'], $impexconfig['target']['password'], $impexconfig['target']['persistent'], $impexconfig['target']['charset']);
$Db_target->select_db($impexconfig['target']['database']);
// #############################################################################
// Session start
// #############################################################################
$ImpExDisplay = new ImpExDisplay();
$ImpExDisplay->phrases =& $impex_phrases;
$ImpEx = new ImpExController();
$ImpExSession = new ImpExSession();
$tire_1 = '';
$tire_2 = '';
$tire_3 = '';
#var_dump($folders);
foreach (scandir(IDIR . "/systems/") as $id => $folder) {
if ($folder[0] != '.' and $folder != 'index.html' and $folder != 'webboard' and $folder != 'ubbthreads' and $folder != 'rat' and $folder != 'ikon' and $folder != 'ubb' and $folder != 'phpBB' and $folder != 'gossamer_threads' and $folder != 'gossamer_threads.zip' and $folder != 'probid.zip') {
require_once IDIR . "/systems/" . $folder . "/000.php";