quote:

---

Originally posted by davemaxwell

Can you do mass adds to the forum within the base code? No

How would you accomplish it?

Essentially, you would need to establish a list of records which you want to have added. You would then need to loop through that list and insert records into the members table, ensuring that the following fields get inserted for sure: M_NAME, M_USERNAME, M_PASSWORD, M_LEVEL, M_EMAIL and M_SHA256. Some things to make sure of:

1) M_NAME is unique
2) M_PASSWORD gets run through the Sha256 encryption algorithm first.
3) M_LEVEL and M_SHA256 are each set to 1
4) M_EMAIL is set.

Do you want to require activation? If so, then your methodology would be slightly different. You'd have to insert them into the MEMBERS_PENDING table and send out emails with the link with the appropriate activation key.

A good step would be to look through register.asp and see what code you can swipe out of there...

---

SET IDENTITY_INSERT new_database.dbo.FORUM_MEMBERS ON

INSERT INTO new_database.dbo.FORUM_MEMBERS
(
  MEMBER_ID
, M_NAME
, M_PASSWORD
, M_DATE
, M_LASTHEREDATE
, M_EMAIL
, M_SHA256
)
SELECT
  idProfile
, chrUserName
, chrPassword
, (CASE
   WHEN ISDATE(dtRegistered)=1 THEN LEFT(REPLACE(REPLACE(REPLACE(CONVERT(varchar(20),dtRegistered,20),':',''),' ',''),'-',''),14)
   ELSE ''
  END)
, (CASE
   WHEN ISDATE(dtSiteLastAccessed)=1 THEN LEFT(REPLACE(REPLACE(REPLACE(CONVERT(varchar(20),dtSiteLastAccessed,20),':',''),' ',''),'-',''),14)
   ELSE ''
  END)
, chrEmail
, 0
FROM old_database.dbo.Profiles

SET IDENTITY_INSERT new_database.dbo.FORUM_MEMBERS OFF