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)
 SQL to add MEMBER_ID to all private forums		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

StephenD
Senior Member

Australia
1044 Posts
Posted - 06 December 2005 :  19:27:13  Show Profile  Send StephenD a Yahoo! Message
One one of my site I've got about 35 private allowed member list forums. I don't have the usergroups mod installed (I can never get it to work - seperate issue) and am looking for a way to quickly insert the member id into the allowed member lists without going in and manually editing each forum.

laser
Advanced Member

Australia
3859 Posts
Posted - 07 December 2005 :  05:56:23  Show Profile
Just figure out the SQL statement and run it X times and substituting the forum number. Just monitor what is changing in the database in your first few additions.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 07 December 2005 :  06:00:09  Show Profile  Send ruirib a Yahoo! Message
You just need to add the FORUM_ID and MEMBER_ID to the FORUM_ALLOWED_MEMBERS table. 


INSERT INTO FORUM_ALLOWED MEMBERS (FORUM_ID,MEMBER_ID) VALUES (fDesiredID,mDesiredID)



Snitz 3.4 Readme | Like the support? Support Snitz too
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.37 seconds. Powered By: Snitz Forums 2000 Version 3.4.07