PLEASE HELP: add multimple FORUM subscriptions at once
 

is there anyway I can do either one of the following?

1. Make a link for my users that when clicked, will subscribe them to MULTIPLE forums that I specify = like X,Y,Z etc. etc.

or

2. quickly Manually subscribe ALL of my users to forums that I specify?

I need badly to somehow get all of my users subscribed to a few forums in particular. how might I go about this?

I am surprised no one else has interest in this, It is real pain to subsribe to 10 or 15 subforums in a row.

anybody?

Well, all you have to do is create the apropriate records in table subscribeforum.

emailupdate: 0=No Update, 1=Immediate Update, 2=Daily Digest, 3=Weekly Digest

How would I go about doing this? I need to subscribe them to forums so they get emailed new threads in that forum NOT subscribe them to individual thread replies. Your help is appreciated

Examples
To subscribe UserID 12 to ForumID 34 using immediate updates:
[sql]INSERT INTO subscribeforum (userid, forumid, emailupdate) VALUES (12, 34, 1)[/sql]


To subscribe ALL your users to forum ID 34 using immediate updates:
[sql]INSERT IGNORE INTO subscribeforum (userid, forumid, emailupdate) SELECT userid, 34 AS forumid, 1 AS emailupdate FROM user[/sql]

Thank you.....one more thing
when you are subscribing to a forum as a user, there is no option for immediated updates, only daily and weekly, what is going to happen if i run this query and specify immediate updates?

Immediate updates to my knowledge are only available to specific THREAD subscriptions

Hmm ... never tried that, as I don't use subscriptions much.
(And forum subscriptions not at all)
I thought this was also available for forums.

If it does not work just issue an UPDATE afterwards to set it to 2 or 3

well i ran the query:

I ran the query:
INSERT INTO subscribeforum (userid, forumid, emailupdate) VALUES (10, 13, 1)

This does not cause an error message, and does add a subsription. but if you use "1" for email notification, it does not send an email, however using 2 and 3 do send emails.

ALSO noticed: if any of VALUES (x, y, z) match what is already in the table I get the following error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1062
error desc: Duplicate entry '13-10' for key 2

do i need a dump table command or something?

does anybody know how to make this query overwrite an existing subscription?