[轉貼]UBB 2 PHPBB2

文章由 **slime** » 2002-01-17 23:49

把以下的檔案存成 ubb-phpbb2.php就可以了
可以轉換會員資料

<?php
/******************************************************************************
Amended on 10th January 2001
Convertor for UBB6 to phpbb 2.0

I took the old script from Kevin (THANX A MILLION KEVIN!). I amended
it a little (about just 5% of it) to suit the db structure for phpbb2.0

Somethings changed:
- appending of phpbb_ to all tables (you have to find and change it is you have a different prefix)
- changing of $total to reflect reverse numbering. It seems Kevin placed the oldest as the newest user
- changing debug output
- addition of mktime to reflect epoch timing
- changed about 10% of codes :P
- tested on ubb 6.1

by theagent (Ivan Tan - sky@aquarealms.com)

******************************************************************************/
/******************************************************************************
This script was used to convert my Ultimate BBS 6.04C users to
phpBB 1.40 users. Let me know if you have any problems and I'll
be happy to help you out.

Usage Instructions:

Copy this script (remove the .txt) into a directory that is available via
a web browser. Set the $memberpath as instructed below. Set the MySQL
parameters $dbhost,$dbname,$dbuser and $dbpass.

Load this script into your browser and convert your users.

Happy Converting!

Kevin - kevin@kevincurtis.org
******************************************************************************/

// Updated to work with 6.04 UBB
// will not get the priv's but will transfer the rest.

?>

<html>
<head>
<title>UBB 6.04C to PhpBB 2.0 User Conversion</title>
</head>

<body bgcolor="#FFFFFF" text="#000000" link="#0000FF" vlink="#0000FF" alink="#FF0000">
<div align="center">UBB 6.04c to PhpBB 2.0</div>

<?
// Define you Members path here in one of 2 ways. Local: c:\Inetpub\webroot\Members\\\"
// For Windows Users:
// $memberpath = "C:\Inetpub\webroot\Members\\\";
// For ?nix users:
// $memberpath = "/root/http/uub/members/";
// or URL Based like below...
// $memberpath = getcwd()."/Members/"; // In this case this file is located in the Web Root directory, which contains a members folder.
$memberpath = "";
echo " Members path: $memberpath";
//exit;
clear;

$dbhost = "";
$dbname = "";
$dbuser = "";
$dbpass = "";
$numrows = 0;
$result = 0;

function valid_email ($email)
{
if (eregi("^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\.[a-z]{2,3}$", $email, $check))
{
if ( getmxrr(substr(strstr($check[0], '@'), 1), $validate_email_temp) )
{
return TRUE;
}
}
return FALSE;
}

printf(" Connecting to Database... ");
$db = mysql_connect("$dbhost", "$dbuser", "$dbpass") or
die("Error: could not connect to the database. Using username $dbuser and password $dbpass. Please go back and try again.");
@mysql_select_db("$dbname", $db) or die ("Error: Could not open database.");
printf("Connected to Database Successfully.");
// open directory, load member filenames into array
printf(" Opening Members path: $memberpath");
$handle = opendir($memberpath);
$a = 0;

while ($file = readdir($handle))
{
if((preg_match('/00/', $file)))
{
printf(" processing member file: $memberpath$file ");
$member = file("$memberpath$file");
$username = addslashes(trim($member[0]));
$sql_select = "select username from phpbb_users where username = '$username'";
printf(" Looking for username: $username");
$result = mysql_query($sql_select,$db);
if($result)
{
$numrows = mysql_num_rows($result);
if ($numrows > 0)
printf(" - username already in table! ");
else
{
$members[$a] = $file;
echo " file $a: $file";
$a++;
}
}
}
}
closedir($handle);

// count remaining elements of array
$i = count($members) -1;

// reversing (crude but it does the job)

$tempmembers = $members;
$count = 0;
while( $i >= 0 )
{
$members[$i] = $tempmembers[$count];
$i--;
$count++;
}

// count remaining elements of array
$i = count($members) -1;

// insert data into phpBB mysql database
$t = $i +1;
// for each member, gather data for import
echo " Processing $t members .";
while ( $i >= 0 )
{
//$member = explode( "|", $members[$i]);
$member = file("$memberpath$members[$i]");
$username = addslashes(trim($member[0]));
$user_password = md5(trim($member[1]));
//$user_password = trim($member[1]);
$user_email = trim($member[2]);
//if ( !valid_email($user_email) ) { $user_email = ""; }
$user_website = trim($member[3]);
//$user_rights = trim($member[4]);
$user_occ = addslashes(trim($member[5]));
$user_from = addslashes(trim($member[6]));
$user_posts = trim($member[7]);
//echo " user_rank: $member[8]);
$user_intrest = addslashes(trim($member[9]));
$user_regdate = trim($member[10]);
list ($xpmonth, $xpday, $xpyear) = split ('[/.-]', $user_regdate);
$user_regdate = mktime(1,1,1,$xpmonth,$xpday,$xpyear);
$user_sig = addslashes(trim($member[12]));

echo ".";

$sql = "SELECT max(user_id) AS total FROM phpbb_users";
if(!$r = mysql_query($sql, $db))
die("Error connecting to the database.");
list($total) = mysql_fetch_array($r);
$total += 1;
// $sql = "INSERT INTO phpbb_users (user_id, username, user_regdate, user_email, user_icq, user_password, user_occ, user_interests, user_from, user_website, user_sig, user_aim, user_viewemail, user_yim, user_msnm)
// VALUES ('$total', '$username', '$regdate', '$email', '$icq', '$passwd', '$occ', '$intrest', '$from', '$website', '$sig', '$aim', '$sqlviewemail', '$yim', '$msnm')";

$sql = "insert into phpbb_users ( user_id, username, user_regdate, user_password, user_email, user_website, user_occ, user_from, user_posts, user_interests, user_sig ) values ('$total','$username', '$user_regdate', '$user_password', '$user_email', '$user_website', '$user_occ', '$user_from', '$user_posts', '$user_intrest', '$user_sig' );";

printf("%s ",$sql) ; // un comment to debug
if ($username)
{
$sql = "insert into phpbb_users ( user_id, username, user_regdate, user_password, user_email, user_website, user_occ, user_from, user_posts, user_interests, user_sig ) values ('$total','$username', '$user_regdate', '$user_password', '$user_email', '$user_website', '$user_occ', '$user_from', '$user_posts', '$user_intrest', '$user_sig' );";
if ($sql)
{
printf(" Inserting Record... ");
$result=mysql_query($sql,$db);
if (!$result)
{
$msg.= "Mysql error: ".mysql_error($db)." ";
printf(" Mysql error: ".mysql_error($db)." ");
}
else if (mysql_affected_rows() < 1) {
printf(" Insert failed for user: $username ");
}
}
}
else
printf(" User already in database: $username ");
$i--;
}

mysql_close($db);

echo "Done Processing!";
exit;
?>
</body>
</html>