FUDforum: How To » Bulk Subscribe

Home » FUDforum » How To » Bulk Subscribe

Show: Today's Messages :: Polls :: Message Navigator

Bulk Subscribe [message #26719]

Fri, 05 August 2005 16:00

jhogue

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

Report message to a moderator

[Message index]

		Bulk Subscribe By: jhogue on Fri, 05 August 2005 16:00
		Re: Bulk Subscribe By: Ilia on Mon, 08 August 2005 02:28
		Re: Bulk Subscribe By: jhogue on Tue, 09 August 2005 23:59

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) ] [

]

Current Time: Wed Nov 27 08:37:18 GMT 2024

Total time taken to generate the page: 0.04830 seconds