Nuke to vBulletin (Transfer Users)

[Viol4ted]

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 :D

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]

[Attrox]

Nice hack! I wish it was released when I used vB...but yeah, it's cool.

[Albasoul]

Does this hack work for Postnuke? Postnuke is a fork of PHPNuke and at this point in the develelopment is a complete rewrite of PHPNuke. If you could do something similar for postnuke, a lot of people would use your hack and be thankful.

http://www.postnuke.com

[ManagerJosh]

It should be able to transfer users. If the postnuke user table is the same, it should be able to transfer.

However I recommend you check to make sure the structure is the same.

I'll have to check with Ted since I helped him in this. But I'm pretty sure it works.

[Viol4ted]

Originally posted by Albasoul
Does this hack work for Postnuke? Postnuke is a fork of PHPNuke and at this point in the develelopment is a complete rewrite of PHPNuke. If you could do something similar for postnuke, a lot of people would use your hack and be thankful.

http://www.postnuke.com

I'll check that for you when I wake up :classic:

[DrkFusion]

Nice hack, but many peoples goals is to achieve full nuke and vb integration hehe, yours seems to be different :)

Anyways good hack

[Viol4ted]

Nice av drkfusion......

[DemiNeo0101]

ya a vb and nuke intagration would be way to hard since each hack modual would have to be edited to keep the intagration going.

[ManagerJosh]

Using the vb to phpnuke alpha hack, you can possibly integrate them. However it isn't a pure integration, but at least it works :)

[ManagerJosh]

Two things people should know about this revised edition.

1) You don't need a clean install of vBulletin anymore. If you have existing users from Both PHP-Nuke and vBulletin, PHP-Nuke users will be transfered into vBulletin regardless of how many users they have in vBulletin.

Nuke users will be added after your current vbulletin users without affecting posts, threads, forums, and whatever data that is currently in vBulletin and PHP-Nuke. I have tested it for every possible scenario I can think of. If you have a scenario, please post it here and I'll see if I can simulate the scenario and make the necessary adjustments to the script.

2) An error in the previous script was the improper transfering of userids should you have existing users. I have fixed that however it requires access to global.php therefore you are now required to upload the file to

/admin

As always, please make backups your nuke database and your vBulletin database in case something happens. Ted and I will not be responsible if this script causes damage to vBulletin, PHP-Nuke, and anything not mentioned herein.

[Viol4ted]

Originally posted by ManagerJosh
Two things people should know about this revised edition.

1) You don't need a clean install of vBulletin anymore. If you have existing users from Both PHP-Nuke and vBulletin, PHP-Nuke users will be transfered into vBulletin regardless of how many users they have in vBulletin.

Nuke users will be added after your current vbulletin users without affecting posts, threads, forums, and whatever data that is currently in vBulletin and PHP-Nuke. I have tested it for every possible scenario I can think of. If you have a scenario, please post it here and I'll see if I can simulate the scenario and make the necessary adjustments to the script.


2) An error in the previous script was the improper transfering of userids should you have existing users. I have fixed that however it requires access to global.php therefore you are now required to upload the file to

/admin



As always, please make backups your nuke database and your vBulletin database in case something happens. Ted and I will not be responsible if this script causes damage to vBulletin, PHP-Nuke, and anything not mentioned herein.

Thanks ManagerJosh, I added the updated version. :rolleyes:

[BladesM3]

so with this, when new users sign up under phpnuke does it automatically convert it to vbull user files? is this all id need to integrate vbull and phpnuke user datafiles?

[ManagerJosh]

This isn't an integration script, Blade. This is an import script where you would import the users from PHP-Nuke to vBulletin.

[BladesM3]

ahh... see i need an integraton script...

[ManagerJosh]

I recommend this hack though mind you it was designed for phpnuke 5.5/5.6

http://www.vbulletin.org/hacks/index.php?s=&action=showhack&hackid=268

[Dev-United]

This hack has a error in the download link

[ManagerJosh]

I'm not sure what error message you are seeing, but I'm not seeing any error message in the download link.

[Dev-United]

Sorry for the confusion. I was refering to the nuketovbfinal.zip file, the direct link in the hacks section gives an error. But I now see that the file is attached to the first post in this thread.

[suewh]

I cant get the attachement to download? It says I am not logged in??????

[ManagerJosh]

Try again. I'm not sure why but you should be able to download it since you are able to post here.

[ManagerJosh]

An updated version for PHP-Nuke 6.5 will be out in a few days. I just need time to write it. :)

[amp2000]

Hi Manager Josh
What do I need to make your script work with phpnuke 6.0 ??
When I tried your script it said:

User ()...success!

and it added in 1 empty entry into my vb user table, I then got

User ()...already exists!
User ()...already exists!
User ()...already exists!
User ()...already exists!

120 times, once for each user.

Just to clarify what I want to do, I want to transfer 120 user's from phpnuke 6.0 to my vBulletin 2.3.0 database. Please help me as I dont want to have to do it manually.

Thanks
amp2000

[ManagerJosh]

I'm getting the wierd feeling you installed into your nuke/admin directory. Install here:

$bburl/admin

It requires global.php from vBulletin.

[amp2000]

Thanks for the reply ManagerJosh but that wasnt the problem, it was my DB :rolleyes:
On reading your reply I assumed the script should work on phpnuke 6.0 so I tried it on a clean nuke6.0 install & it worked, I then got a backup copy of my database containing all the user's & it worked beautifully so it seem's the problem was with my database, *not* the script.

Thank you so much for your reply/help/script, youve saved me a ton of work ;)

Cheers
amp2000

[ManagerJosh]

Sure thing :)

Glad to be of assistance.

[Zachery]

will it work for 2.2.9 or 2.3?

[ManagerJosh]

I did not see any changes made to the vBulletin user database, so yes it should work.

Be sure you install it in your forums/admin directory and not nuke/admin directory.

[ManagerJosh]

5-20-2003 - Updated version of Script.

ZIP Contains Older Version (for people who has an older version pf PHP-Nuke) and Newer Version that supports PHP-Nuke 6.5.

[random_X]

thank's ...

i will tray it with Nuke 6.8 + VB 2.3.0

[gizzmo0]

any news about this.. I too have gotten errors about the users not getting tranfer over to this.. from nuke 6.5 to vb2.3.2

[ManagerJosh]

Gizzmo, what sort of errors? Are you using the up to date script I wrote?

[gizzmo0]

User ()...already exists!
User ()...already exists!
User ()...already exists!
User ()...already exists!

This and sometimes it has just some letters in it.. Im running phpnuke 6.5. and vb 2.3.x

[ManagerJosh]

User ()...already exists!
User ()...already exists!
User ()...already exists!
User ()...already exists!

This and sometimes it has just some letters in it.. Im running phpnuke 6.5. and vb 2.3.x
Just looking at that, I already know that:

You place the import script into the /admin/ folder of phpnuke.

You are suppose to put the import script into the /admin/ folder of vBulletin.

[gizzmo0]

You place the import script into the /admin/ folder of phpnuke

Nope its in the vb forum admin.. the first couple lines work than the rest are repeats above... this is for 6.5 nuke not the nuketobb by tom.

[gizzmo0]

Fixed the settings and get this
Database error in vBulletin Control Panel 2.3.2:

Invalid SQL: INSERT INTO userfield
(userid,field1,field2,field3,field4)
VALUES
('74','', '', '', '')
mysql error: Unknown column 'field1' in 'field list'

mysql error number: 1054

[ManagerJosh]

Fixed the settings and get this
Database error in vBulletin Control Panel 2.3.2:

Invalid SQL: INSERT INTO userfield
(userid,field1,field2,field3,field4)
VALUES
('74','', '', '', '')
mysql error: Unknown column 'field1' in 'field list'

mysql error number: 1054
Did you add any additional custom fields?

[gizzmo0]

Nope. Not at all. All done by phpnuke 6.5 nothen been changed.

[ManagerJosh]

Nope. Not at all. All done by phpnuke 6.5 nothen been changed.

I meant for vBulletin....any new fields (custom ones) added besides the standard number of fields?

[gizzmo0]

nope nothen.. just added the arcade script. but it didnt change anything that i know of.

[jribz]

I get the same error trying to move users from nuke 6.7 to vbulletin 2.32, any suggestions?

Edit: the error being user already exists

[ManagerJosh]

My hunch is that the script is being runned from your nuke admin directory and not vBulletin admin directory.

If you are willing, PM me your contact information (AIM preferred) and I'll lend a hand.

[jribz]

OK, I think the problem is that I'm running nuke 6.7 with phpbb port from nukecops, that may be the issue since I think some of the queries are different, can this be modified to work with that?

[ManagerJosh]

OK, I think the problem is that I'm running nuke 6.7 with phpbb port from nukecops, that may be the issue since I think some of the queries are different, can this be modified to work with that?
There wasn't any changes to *prefix*_users so I don't know what's wrong.

I'd like to go in first hand and see what's wrong.


There is also the possibility you didn't configure the script with all the proper MySQL Properties.

[jribz]

There wasn't any changes to *prefix*_users so I don't know what's wrong.

I'd like to go in first hand and see what's wrong.


There is also the possibility you didn't configure the script with all the proper MySQL Properties.I'd appreciate any help you can offer. The script has been configured correctly, but now I noticed above you were asking someone about custom vb fields, which I have added two I believe. Contact me on AIM if you can. Thanks

[ManagerJosh]

I'd appreciate any help you can offer. The script has been configured correctly, but now I noticed above you were asking someone about custom vb fields, which I have added two I believe. Contact me on AIM if you can. Thanks
I added you but you are not appearing on my lists.

[jribz]

I sent a PM to you Josh in regards to contacting you.

[jribz]

Done and working, thanks for all your help! :cool:

[ManagerJosh]

Done and working, thanks for all your help! :cool:
NP :)

[wamadhat]

Dear Mr. ManagerJosh

I transfer all my users from nuke to VB using this hack but when I want to log any name of users I got this Error message:

********* Error Message **********

Database error in vBulletin 2.3.2:

Invalid SQL: SELECT COUNT(privatemessageid) AS messages FROM privatemessage WHERE userid= AND dateline>0 AND folderid=0
mysql error: You have an error in your SQL syntax near 'AND dateline>0 AND folderid=0' at line 1

mysql error number: 1064

********* Error Message **********

What do you think?

Regards,

[ManagerJosh]

Dear Mr. ManagerJosh


I transfer all my users from nuke to VB using this hack but when I want to log any name of users I got this Error message:

********* Error Message **********

Database error in vBulletin 2.3.2:

Invalid SQL: SELECT COUNT(privatemessageid) AS messages FROM privatemessage WHERE userid= AND dateline>0 AND folderid=0
mysql error: You have an error in your SQL syntax near 'AND dateline>0 AND folderid=0' at line 1

mysql error number: 1064

********* Error Message **********

What do you think?

Regards,
I'm not sure what you were trying to accomplish. Could you elaborate a bit more?

[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]

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]

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]

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]

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.

[sqzdog]

How do I use this script to import my phpnuke users, etc?

[Neo]

there should be a install file in the zip package.

[Marco van Herwaarden]

This script is for vB2, not vB3.

Check out the ImpEx utility at vbulletin.com

[Langly]

Impex won't work. It only converts the forum users to vbulletin and not the Postnuke users.


This script is for vB2, not vB3.

Check out the ImpEx utility at vbulletin.com

[Kiint]

This script is for vB2, not vB3.

Check out the ImpEx utility at vbulletin.com

I've been looking for a script to inport my nuke 7.9 users into vBulletin 3.6.3 with no luck so far...the ImpeEx script just gave me SQL errors when trying to insert users as i could only use the phpbb importer (there is no PHPnuke importer).

If I could import just my users then that would be great...anyone know of any scripts/hacks that will do this for the above versions?

[ecansel]

Yes,

We want to PHPNuke users to vbulletin 3,6,3..
How can we do?

[MoniK]

Hello,

which PHPNuke Version do you have ?

I've worked with Nuke the last 5 years and supported it in Germany, of course I could help you for transferring users and posts into VB.

Greets from Hamburg, Germany,
Monika