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

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Merging duplicate members
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

taropatch
Average Member

USA
741 Posts

Posted - 12 July 2004 :  10:01:58  Show Profile
If I go in to my Access db and change the R_AUTHOR in FORUM_REPLY and T_AUTHOR in FORUM_TOPICS, is this an effective way to consolidate a duplicate member? I want to delete a dup member but without losing their posts under the 2nd/duplicated member name.

I tried searching this forum and archives but surprising did not find anything. Maybe I didn't search well.

Also, have not seen any mods to handle the duplicate member situation.

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 12 July 2004 :  10:49:06  Show Profile  Send ruirib a Yahoo! Message
You could handle that with a simple dbs file set to change the values for those two fields you referred to. You'd probably also need to delete any subscriptions for the member id to delete, but that should be it.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

taropatch
Average Member

USA
741 Posts

Posted - 12 July 2004 :  11:29:36  Show Profile
Thanks Rui. I will try it. Just have to find a good time to shut my forum down and do back ups.
Go to Top of Page

taropatch
Average Member

USA
741 Posts

Posted - 12 July 2004 :  11:54:01  Show Profile
Cool. It worked like a charm and was easy enough.

What is the best way to look through the database looking for duplicate memberships? It would be good to consolidate and clean it up every so often.
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.39 seconds. Powered By: Snitz Forums 2000 Version 3.4.07