I have a website with over 17,000 users. The website is grouped into 25 users a piece. So I can say that I need about 680 forums created and I can't do that physically. I also need to store each boardID and attach it to the group of users. I have a group ID already so I can attach the group ID to a board ID, but I still don't know how to create a board dynamically.

On creating the board, I need a moderator to take control of the board as well. I know who the moderators will be already, but when creating it dynamically how do I assign moderators dynamically?

I see and understand this is a VERY unique situation, but is it possible and if so how do I do it? I know PHPBB can do it, but I want to use a C#/ASP.NET solution and this is the best board out there with that requirement. Please help me out!!!

I do appreciate all the help I am about to receive and if I get this up and working, I do not see a problem with a nice donation to YAF.

Once you have "the lay of the land", you can better plan out what you need to do. For example, I believe that you don't assign specific people to be a moderator for a specific forum - you add them to the moderator group and give that group moderator access to the specific forum. So, if you want to have different moderators for different forums, you will need to make a different moderator group for each forum.

One approach you might take would be to create a table for the specs you need like:

ForumName   ModeratorUsername   ForumID     ModeratorUserID     ModeratorsGroupID
Forum1      Moderator1          NULL        NULL                NULL
Forum2      Moderator2          NULL        NULL                NULL
Forum3      Moderator3          NULL        NULL                NULL

Then you could write some queries to do the work for you like:

-- create forums
INSERT  INTO yaf_Forum (Name)
SELECT  ForumName
FROM    specTable

-- save the forum IDs for later user
UPDATE  st
SET     st.ForumID = yf.ForumID
FROM    specTable st
        INNER JOIN yaf_Forum yf ON yf.Name = st.ForumName



-- add moderator users
INSERT  INTO yaf_User (ProviderUserKey, Name)
SELECT  ProviderUserKey = u.UserId, Name = st.ModeratorUserName
FROM    specTable st
        INNER JOIN aspnet_Users u ON st.ModeratorUsername = u.UserName

-- save the user IDs for later use
UPDATE  st
SET     st.ModeratorUserID = yu.UserID
FROM    specTable st
        INNER JOIN yaf_User yu ON yu.Name = st.ModeratorUsername



-- create moderator groups
INSERT  INTO yaf_Group (Name)
SELECT  ForumName + 'Moderators'
FROM    specTable

-- save the group IDs for later use
UPDATE  st
SET     st.ModeratorsGroupID = yg.GroupID
FROM    specTable st
        INNER JOIN yaf_Group yg ON yg.Name = st.ForumName + 'Moderators'



-- add moderators to appropriate moderators group
INSERT  INTO yaf_UserGroup (UserID, GroupID)
SELECT  UserID = ModeratorUserID, GroupID = ModeratorGroupID

Note this is just theory and speculation, don't take the above code as anything other than illustrating the idea.

Any other way of doing this?

It sounded like this would be a one-time thing to do - setting up all the forums you need - not an ongoing thing.

What needs to happen after the initial 680 forums are setup?

#1 won't need to be redone - it's a one-time thing to get you "caught up".

When you say "creation of a new board needs to be in complete control of those 25 users", do you mean board or forum? I ask because you could create 1 board per group, have the group members be board admins for that board which would allow them to create/edit/delete the forums in that board. You would still be the host admin (site admin) with control over all boards. This would require no code changes or new code to be written.

Or am I still not getting it?

Each group gets a board. Not a forum. Each group will decide and have total control over their board and the forums in it. I will need to have complete control over ALL boards as the site admin.

Not to make this more confusing, but I must say that Boards (Not Forums) can be removed at any time. But most the time, The board will be moved with the 25 users over time instead, but when the users create a new group, they will need to automatically have a new board created with them.

Last note: I will need to keep records over which group has control over each board. I already have a group ID which is a GUID. I will need to attach this group ID to every Board ID that is created.

I came across the code yaf does to delete a board which you can use. You can either call yaf's code (YAF.Classes.Data.DB.board_delete) or yaf's stored procedure (yaf_board_delete). That should save you some work when your users delete a group.

I did tho, build two more controls for the forum. A Top Post control and Last Viewed control I figured I would post them on the site, but there will be a little piece of code that will need to be looked at by the real Devs of YAF to fix it a little. Good controls, because I can put them anywhere on my site and they work...