>> Site Map >> Forums >> General
Forum module - topics in forum:
General - Got a general or non nuke problem which doesn't fit anywhere else, ask here.
phpfusion to phpnuke user conversion
Hi All,
Have been searching for some kind of converter or instructions on how/if it is possible to convert/export/import my users table from phpfusion to phpnuke?
If anyone have some hints for me or even a converter, it would be very appriciated, i am posting the fusion_users table structure below in case somebody is willing to help
Best Regards
Patric
user_id smallint(5)
user_name varchar(30)
user_password varchar(32)
user_email varchar(100)
user_hide_email tinyint(1)
user_location varchar(50)
user_birthdate date
user_aim varchar(16)
user_icq varchar(15)
user_msn varchar(100)
user_yahoo varchar(100)
user_web varchar(200)
user_theme varchar(100)
user_offset char(3)
user_avatar varchar(100)
user_sig text
user_posts smallint(5)
user_joined int(10)
user_lastvisit int(10)
user_ip varchar(20)
user_rights text
user_groups text
user_level tinyint(3)
user_status tinyint(1)
I'm sure I did this for someone a year or so ago, I'll try and find the sql query I used.
Sorry, it was the other way I helped someone, phpnuke to phpfusion.
Why do you want to change from fusion anyway?
Thanks for looking though!
Used to have nuke but the site got hacked twice so we changed to fusion.
The main reason is the fusion forum, it lacks many features that phpbb has, basic things líke group moderation, polls, easier smiley controls etc etc (you can ofocurse modify fusion which we have done, but you modify files so much that in the end it takes you hours to apply any new security patches etc)
Best Regards
mrpg
I'll try and change it around to work the other way for you.
I'll post up the sql query and instructions on what you need to do when I've done it.
Right, here we go.
Go and install phpnuke in the same database as fusion.
Don't set up any users on the nuke site yet (you can setup admin if you want just don't select create user)
Then just copy the following sql query into phpmyadmin
| Code: : |
| INSERT INTO nuke_users (username, user_password, user_email, user_from, user_icq, user_msnm, user_yim, user_website, user_regdate) SELECT n.user_name, n.user_password, n.user_email, n.user_location, n.user_icq, n.user_msn, n.user_yahoo, n.user_web, n.user_joined FROM fusion_users n WHERE n.user_id > 2 |
It'll convert all the users in your fusion_users table over to nuke_users
It does work because I just tested it here locally.
You may also notice that the sql query starts at user id 2, that's because there should already be a user id 1 on a fresh nuke install which is the anonymous account.
Unfortunately nuke is a bit backward and uses standard dates instead of unixtime so you'll need to also run the following to set all users regdate to the current date, either that or go through all of them with the help of a site like http://www.captain.at/review-unixtime-javascript.php to convert them individually.
| Code: : |
| UPDATE nuke_users SET user_regdate = "Dec 31 2006" ; |
Good luck
And I hope you're not installing anything newer than 7.6.
Great stuff m8, much appriciated!!!
I did however take the long road before i noticed you had posted again
and manually used phpmyadmin to modify the fusion_users table to look like nuke_users and then renamed the tables.Your query sounds much easier! , but i am sure this post will help many people in the future who wants to do the same switch!
Many thanks again!
Best Regards
mrpg
hi,
Is it possible the same thing for forum messages?
Thanks a lot
For the user is very good!!!!
