FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Bulk Subscribe
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Bulk Subscribe [message #26719] Fri, 05 August 2005 16:00 Go to previous message
jhogue is currently offline  jhogue   United States
Messages: 28
Registered: April 2005
Location: at the computer
Karma:
Junior Member
I have a few hundred users. We want to subscribe them to our main forum/mailing list in bulk, rather than having to teach them do it themselves.

So, I think I need to create entries the fud_forum_notify table.

1) is it safe to delete the few subcriptions I have by merely deleting the row for its association in the fud_forum_notify table?

2) is it ok to create subscriptions simply by creating a new entry in the fud_forum_notify table?

the logic is like this, but I know the proper commands.

get a list of ids from fud_users id column
for each fud_user id
insert fud_forum_notify set user_id = fud_user.id, set forum_id=5

-- or extracting a list or user ids into a temporary table, setting all forum_ids to 5, then appending? those records.

-J
[Message index]
 
Read Message
Read Message
Read Message
Previous Topic: Forum attachments going out over the mailing list
Next Topic: include a php file
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 10 11:31:59 GMT 2024

Total time taken to generate the page: 0.04763 seconds