Query to subscribe a single user to a thread

[Nick]

I am looking for a query to subscribe a single user to a single thread.

Any help is appreciated

[Jake Bunce]

INSERT INTO subscribethread
(userid, threadid, emailupdate, folderid, canview)
VALUES ('[color=red]X[/color]', '[color=red]Y[/color]', '[color=red]Z[/color]', '0', '1')

Where X is the userid of the user, Y is the threadid of the thread, and Z is the number 0 (no email updates), 1 (instant email), 2 (daily updates), or 3 (weekly updates).

Backup first and test it.

[Nick]

Awesome, thanks Jake!

[Nick]

I just want to confirm that this does in fact work