PLEASE HELP: add multimple FORUM subscriptions at once

[btappan]

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?

[btappan]

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

[btappan]

anybody?

[Andreas]

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

[btappan]

Originally Posted by KirbyDE

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

[Andreas]

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]

[btappan]

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

[Andreas]

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

[btappan]

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?

[btappan]

Originally Posted by btappan

well i ran the query:

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

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

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