About this Page
This is a discussion on e107 > phpnuke within the Nuke 7.x - General forums, part of the PHP-Nuke 7.x category; Is there a way to convert a e107 database to phpnuke? I need to move over 150 users from my ...

raiisak · #1 (**permalink**) 08-06-2005, 08:05 AM

Is there a way to convert a e107 database to phpnuke?
I need to move over 150 users from my old e107 site to my new
phpnuke powered site.

Plz reply, all help are of intrest!

Cheers..

raiisak · #2 (**permalink**) 08-08-2005, 10:01 AM

If its not doable plz post so

raiisak · #3 (**permalink**) 08-08-2005, 10:07 AM

Im almost beggin.. I have googled this issue for days now.. I really dont whant to manuall add all those users again.. Are there another solution?
Perhaps a mass add user module or block?

dar63 · #4 (**permalink**) 08-08-2005, 05:48 PM

Not promising anything but post up the structure for your e107 user table.

I may be able to make a basic converter.

raiisak · #5 (**permalink**) 08-09-2005, 08:19 AM

I didnt wanted to post all of my users email adress and so on here so I PM you the table.. Sweet jezus I hope you can help me here...

Its alot of work doing this manually I tell you ..

Cheers mate..

dar63 · #6 (**permalink**) 08-09-2005, 02:13 PM

You're confused, I asked for the table structure, I don't want your user list.

raiisak · #7 (**permalink**) 08-09-2005, 03:54 PM

lol, yeh you are right man! I am.. hehe

Here are the core_sql install file:

Code:

#
# Table structure for table `user`
#

CREATE TABLE user (
  user_id int(10) unsigned NOT NULL auto_increment,
  user_name varchar(100) NOT NULL default '',
  user_customtitle varchar(100) NOT NULL default '',
  user_password varchar(32) NOT NULL default '',
  user_sess varchar(32) NOT NULL default '',
  user_email varchar(100) NOT NULL default '',
  user_homepage varchar(150) NOT NULL default '',
  user_icq varchar(10) NOT NULL default '',
  user_aim varchar(100) NOT NULL default '',
  user_msn varchar(100) NOT NULL default '',
  user_location varchar(150) NOT NULL default '',
  user_birthday date NOT NULL default '0000-00-00',
  user_signature text NOT NULL,
  user_image varchar(100) NOT NULL default '',
  user_timezone char(3) NOT NULL default '',
  user_hideemail tinyint(3) unsigned NOT NULL default '0',
  user_join int(10) unsigned NOT NULL default '0',
  user_lastvisit int(10) unsigned NOT NULL default '0',
  user_currentvisit int(10) unsigned NOT NULL default '0',
  user_lastpost int(10) unsigned NOT NULL default '0',
  user_chats int(10) unsigned NOT NULL default '0',
  user_comments int(10) unsigned NOT NULL default '0',
  user_forums int(10) unsigned NOT NULL default '0',
  user_ip varchar(20) NOT NULL default '',
  user_ban tinyint(3) unsigned NOT NULL default '0',
  user_prefs text NOT NULL,
  user_new text NOT NULL,
  user_viewed text NOT NULL,
  user_visits int(10) unsigned NOT NULL default '0',
  user_admin tinyint(3) unsigned NOT NULL default '0',
  user_login varchar(100) NOT NULL default '',
  user_class text NOT NULL,
  user_perms text NOT NULL,
  user_realm text NOT NULL,
  user_pwchange int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (user_id),
  UNIQUE KEY user_name (user_name)
) TYPE=MyISAM;
# --------------------------------------------------------

Phew.. Thats all.. I hope you will do this mate. There are several in the e107 forum that ask for the same, but this is the place to ask for it!! heh.
Kinda rude asking for a converter to another system over there, lol.

Thanks for trying to help me!

dar63 · #8 (**permalink**) 08-09-2005, 05:03 PM

Right, make a complete backup of your e107_user table, import it into your nuke database and then run this via the sql section. You should already have one user called anonymous in the nuke_users table and that needs to stay.

Code:

INSERT INTO nuke_users (username, user_password, user_email, user_from, user_icq, user_msnm, user_aim, user_website, user_regdate, user_sig)
SELECT n.user_name, n.user_password, n.user_email, n.user_location, n.user_icq, n.user_msn, n.user_aim, n.user_homepage, n.user_join, user_signature
FROM e107_user n
WHERE n.user_id > 0

Unfortunately I cant change the reg dates because 107 uses unixtime stamp and nuke uses normal Date/time, so afterwards run the query below to make all reg dates the same as the first entry, future registrations will be fine though.

Code:

UPDATE nuke_users SET user_regdate = "Jan 30 2005" ;

Maybe someone can do something better but I did say it would be basic.

raiisak · #9 (**permalink**) 08-09-2005, 07:46 PM

Thank you so much for taking the time and showing me this!
I am sure this will be as much for help for me as for the others..
We who had this problem owe you bigtime mate..
THANK YOU!

One last question before I leave this tread to itself:
Is there a sql command for setting all of the members as Subscribed?
I need to mail them all in a hurry about the changes.. hehe

Again my friend, thanks...

dar63 · #10 (**permalink**) 08-09-2005, 08:12 PM

Code:

UPDATE nuke_users SET newsletter = "1" ;

About this PageThis is a discussion on e107 > phpnuke within the Nuke 7.x - General forums, part of the PHP-Nuke 7.x category; Is there a way to convert a e107 database to phpnuke? I need to move over 150 users from my ...

e107 > phpnuke

About this Page
This is a discussion on e107 > phpnuke within the Nuke 7.x - General forums, part of the PHP-Nuke 7.x category; Is there a way to convert a e107 database to phpnuke? I need to move over 150 users from my ...