The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
query help please
I have a need on my site where I manually subscribe users to certain forums (not individual threads) by using the queries below:
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 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] this gets time consuming when their are many forums to subscribe them to. Is there a way I can specify more than just one forum ID like the above? like instead of just 34, also specify 35,36,38,39 in each of the two queries above? Thanks for your help! |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|