I just done this a few days ago for a member database with 600 and another with 500.
the problem you face is someone having the same name(public and user), so i wrote thsi script:
i have old members dir ina folder called "new" and another in the folder called "old".
run that script, and it will highlight any problems, because i didn't ahve many i didn't bother writing a script that sorted out the problems, i just entered each files and changed it (only had 30 or so problems, and in them rename the username to username-old (same with public name)).
Now once you have got this far, i copyed over the files, and renamed them, using flash file renamer (
http://www.rlvision.com/flashren/about.asp) rename the new ubb members from the very last member number of the old members (treating it like you are adding the new members the old members), and say you old member went from 1 to 437, you would rename the new ones from 438.
Then you have a members list problem, so i wrote this below:
That produces a new list of members, then just copy and taste it into memberslist.cgi
And now mine is fine and running with no problems.
It took about 5 mins for the first script to finish, and that was runnign off my computer, my best advice is downlaod both member files, and install perl on your computer and run them.
Any problems, or need me to explain a bit more how i did it, just say here and i will try and get something organised.
[ 11-30-2001 04:30 PM: Message edited by: Andrew ]