Nuke to vBulletin (Transfer Users)

This little hack switches all your users from PHPNuke to vBulletin easily :bunny: Post questions here, ICQ, AIM, or MSN Support will NOT be answered!

Note: This will not overwrite current members

This only works on a clean install (Empty the user and userfield tables) :hurt:

-Created by Ted of SimGateway.com
-Fixed by ManagerJosh of WorldSims.org :banana:

Version: Nuke to vB [Final]

[wamadhat]

Ok

I was runing phpnuke 6.9 and now I have VB 2.3.2 I used this hack to transfer my old users from phpnuke to VB 2.3.2 and I succeefully transfer them.
Now any old user want to log in will cause problem with database as I wrote abouve, but any new user can log normaly!
I hop I could explane tha problem correctly.

Best regards,

[ManagerJosh]

Originally Posted by wamadhat

Ok

I was runing phpnuke 6.9 and now I have VB 2.3.2 I used this hack to transfer my old users from phpnuke to VB 2.3.2 and I succeefully transfer them.
Now any old user want to log in will cause problem with database as I wrote abouve, but any new user can log normaly!
I hop I could explane tha problem correctly.


Best regards,

The problem lies as your need to ensure your userids are syncronized with the users of phpnuke.

So that means user1 needs to have userid 1, user2 have userid 2, and so forth

So if both databases weren't syncronized, it appears you get that problem.

[JupMan]

From reading this, I am getting the idea there is no way to convert a PHP message base to vB.

Or am I missing something?

[ManagerJosh]

Originally Posted by JupMan

From reading this, I am getting the idea there is no way to convert a PHP message base to vB.

Or am I missing something?

If you are trying to import the PHP-Nuke's phpBB to, vB its quite possible

Anything is possible. It just is the matter of tinkering around with what you have and getting it to work

[DjJoschimo]

This Script is only for VB 2
I need this for Nuke 7.0 to vb3.0.3! Can everybody help me?

greetz
DJoschimo

[ManagerJosh]

Originally Posted by DjJoschimo

This Script is only for VB 2
I need this for Nuke 7.0 to vb3.0.3! Can everybody help me?


greetz
DJoschimo

Hmmmm..i haven't looked into whether creating something of the sort...however a big problem is the passwords...they wouldn't be transfered properly.

[DjJoschimo]

I have modify the script:

// Import Protocols //
echo("<center><font face=verdana size=4>PHP-Nuke to vBulletin 2.2.6</font></center><p><font size=2 face=verdana>");
while($row2 = mysql_fetch_array($nukequery)) {
$uid = $row2["user_id"];
$user[username] = $row2["username"];
$user[user_password] = $row2["user_password"];
$user[user_email] = $row2["user_email"];
$user[user_website] = $row2["user_website"];
$user[icq] = $row2["user_icq"];
$user[yim] = $row2["user_yim"];
$user[aim] = $row2["user_aim"];
$user[sig] = $row2["user_sig"];

if(is_array($row2)) {
} else {
echo("No Data");
}
$query3 = mysql_query("SELECT * from user WHERE username='$user[username]'");
$row3 = mysql_fetch_array($query3);
if(is_array($row3)) {
echo("User <i>$uid</i> ($user[username])...<font color=blue>already exists</font>!<br>");
} else {

$finsertquery = mysql_query("INSERT INTO `user` ( `userid` , `usergroupid` , `username` , `password` , `email` , `styleid` , `parentemail` , `homepage` , `icq` , `aim` , `yahoo` , `signature` , `adminemail` , `showemail` , `invisible` , `usertitle` , `customtitle` , `joindate` , `cookieuser` , `daysprune` , `lastvisit` , `lastactivity` , `lastpost` , `posts` , `timezoneoffset` , `emailnotification` , `buddylist` , `ignorelist` , `pmfolders` , `receivepm` , `emailonpm` , `pmpopup` , `avatarid` , `options` , `birthday` , `maxposts` , `startofweek` , `ipaddress` , `referrerid` , `nosessionhash` , `inforum` )
VALUES (
'', '2', '$user[username]', '$user[password]', '$user[email]', '1', '', '$user[homepage]', '$user[icq]', '$user[aim]', '$user[yim]', '$user[signature]', '1', '1', '0', '', '0', '1030437308', '1', '-1', '0', '', '0', '0', '', '0', '', '', '', '0', '0', '0', '0', '15', '0000-00-00', '-1', '1', '', '0', '0', '0'
)");
// Import Protocols //

The Script tell me all ok. User xxx Ok, or already in databank
But the script write nothing in the VB User Bank!

Can everybody help me?

[ManagerJosh]

Probably because the fields are wrong. Plus the passwords wouldn't work either. Everyone would have to reset them.

[Gio~Logist]

if it works with a fresh install then it doesnt allow u to transfer members from one forum to another and still keep members on that forum does it?

[ManagerJosh]

Originally Posted by gio~logist

if it works with a fresh install then it doesnt allow u to transfer members from one forum to another and still keep members on that forum does it?

Huh? I'm confused.