Langly
01-11-2006, 12:34 PM
I need to add 20000 users from my Postnuke CMS to my vbulletin. Since there isn't anything out there publically released that works to do this I have to do it manually, one at a time. The main difference I can see between the two user databases is the passwords. What will happen when the user tries to login if I did not conver their password to vbulletin format? Can they still login? How can I make it so they have to redo their password?
Here is what I'm talking about:
Postnuke user SQL database
INSERT INTO `nuke_users` VALUES (23168, '', 'lazyday', 'lazyday@gmail.com', '', '', 'blank.gif', '1136230830', '', '', '', '', '', 1, 0, '', '', '', 'bcab041ac2a505bvc72b3e4dd4cd5da1', 5, '', 0, 0, 0, '', 0, '', '', 4096, 0, 6.0, 2, '2', 'YES');
vbulletin user SQL database:
INSERT INTO `user` VALUES (3577, 3, '', 0, 'lazyday', '8331bbda9d62cz20a43cf85402845df3', '2006-01-02', 'lazy@gmail.com', 0, '', '', '', '', '', '', '', 1, 2, 'Junior Member', 0, 1136230616, 0, 1136230616, 1136230715, 0, 0, 10, 5, '-6', 1, 0, 0, 0, 3159, '02-28-1985', '1985-02-28', -1, -1, '222.68.17.188', 0, 9, 0, 0, 1, 0, 0, 'WdW', 0);
I have to change all my Postnuke CMS users into the above vbulletin format. Anyone know of something that can do this?
Here is what I'm talking about:
Postnuke user SQL database
INSERT INTO `nuke_users` VALUES (23168, '', 'lazyday', 'lazyday@gmail.com', '', '', 'blank.gif', '1136230830', '', '', '', '', '', 1, 0, '', '', '', 'bcab041ac2a505bvc72b3e4dd4cd5da1', 5, '', 0, 0, 0, '', 0, '', '', 4096, 0, 6.0, 2, '2', 'YES');
vbulletin user SQL database:
INSERT INTO `user` VALUES (3577, 3, '', 0, 'lazyday', '8331bbda9d62cz20a43cf85402845df3', '2006-01-02', 'lazy@gmail.com', 0, '', '', '', '', '', '', '', 1, 2, 'Junior Member', 0, 1136230616, 0, 1136230616, 1136230715, 0, 0, 10, 5, '-6', 1, 0, 0, 0, 3159, '02-28-1985', '1985-02-28', -1, -1, '222.68.17.188', 0, 9, 0, 0, 1, 0, 0, 'WdW', 0);
I have to change all my Postnuke CMS users into the above vbulletin format. Anyone know of something that can do this?