Author |
Topic |
|
endomorph
Junior Member
United Kingdom
128 Posts |
Posted - 17 April 2005 : 15:54:16
|
This is the scenario. I have just bought a competitors website and I want to add the members to my forum.
This is what I would like to do -
-Add the members email address -Give them all a password of "xxxxxx" or a 6 character random alphanumeric one -Give them a username of the first part of their email address -Send them the "Thanks for registering ..." email
I could do it manually but this would be time consuming so I was wondering if there is a MOD about for this or maybe someone could write a small ASP script ? I would be happy to pay a small amount if need be.
I think it would make a good MOD anyway for future use.
Please reply below or email me with suggestions/ideas/offers.
Cheers all.
Jim |
Need help with your Snitz ? Most Snitz & ASP custom coding undertaken. Email for info | Search Engine Optimisation |
|
Raavin
Starting Member
16 Posts |
Posted - 16 May 2005 : 20:28:45
|
Mmmmm, so they will be members of your forum and one they are currently on????
Problems are as follows-
Passwords are encrypted with SHA256 so you'd have to get the result of the encryption from the Access file, then replace everyones password with this. You'll find this in the FORUM_MEMBERS table in the M_PASSWORD column.
I would also have a look at the password.asp file and try to see if I could hack it to automatically iterate through the current member list as if they had lost their password. It's quite a short file but I haven't look closely at it. It normally takes a username and email that you enter then compares it with entries in the database. All you need to do is let it send an email every time then loop back. If you don't know anything about ASP then this is going to be a bit of a stretch. If I get time I'll have a look. I'm not a real whizz at ASP but I think it's within reach.
Regards,
Raavin ;)
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 16 May 2005 : 22:07:41
|
If Jim is only copying the users across from one forum to the other, then the fields only need to be copied. If they are encrypted, then they will be the same when you put them in to the db you want. You should be able to copy the table fields across manually with out to much hassle.. |
Cheers, David Greening |
|
|
Raavin
Starting Member
16 Posts |
Posted - 17 May 2005 : 01:32:56
|
You're right of course. I tend to over think things. The only hurdle then is emailing them to let them know. This assumes also that you have MS Access. If you don't, Table Editor is the way to go. Unfortunately you'll have to put together some SQL. It's been about a month since the post so this is probably all redundant.
Raavin
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 17 May 2005 : 03:58:57
|
You can do the same in MS SQL with the tables. But you are right, Jim might not need it now, but then again there could be other users with the same issue.
|
Cheers, David Greening |
Edited by - Classicmotorcycling on 17 May 2005 04:00:16 |
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 17 May 2005 : 10:15:14
|
For the destination database, it seems that you could add an additional field with a prefilled value. The field could be called something like IMPORTED_MEMBERS, and the value set to 1. Next import your data so that all of the imported members get the value of 1 for the IMPORTED_MEMBERS field. After the import, set the default value back to 0. When you go to email the imported members, those who have the value of 1 for IMPORTED_MEMBERS are the only ones emailed. You may also have to modify register.asp and inc_profile.asp to accomodate for this new field.
|
Edited by - Etymon on 17 May 2005 10:25:57 |
|
|
|
Topic |
|