Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 Adding Members "En Mass"
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

endomorph
Junior Member

United Kingdom
128 Posts

Posted - 17 April 2005 :  15:54:16  Show Profile
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  Show Profile
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 ;)

Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts

Posted - 16 May 2005 :  22:07:41  Show Profile
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
Go to Top of Page

Raavin
Starting Member

16 Posts

Posted - 17 May 2005 :  01:32:56  Show Profile
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

Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts

Posted - 17 May 2005 :  03:58:57  Show Profile
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
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts

Posted - 17 May 2005 :  10:15:14  Show Profile  Visit Etymon's Homepage
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.34 seconds. Powered By: Snitz Forums 2000 Version 3.4.07