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]

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:
INSERT INTO subscribeforum (userid, forumid, emailupdate) VALUES (12, 34, 1)


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

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

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?

[Andreas]

If you want to overwrite you must use UPDATE or REPLACE instead of INSERT

[btappan]

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


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

forgive me for not understanding this, but i am trying to run these queries using OVERWRITE in place of insert and am getting a sytax error. I don't care what my users current subscriptions are, I need to overwrite them all and subsribe them to the forums I indicate. I basically need it spelled out to me how to write out these two queries. the second one to subsribe ALL my current users to forum id 12 and the second to subscribe new users one by one as they register to forum id 12. Thanks for your help. Ill get this on my own one day


EDIT: I think i am just going to delete the table entries through phpmyadmin. I can then run the queries above without problems.