Announcement

Collapse
No announcement yet.

Mass subscribing to threads

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mass subscribing to threads

    I have imported from SMF 1.1.5 and I must say that vBulletin is packed with features, and it just works!

    Anyway, one thing my users have asked about is if there is a way they could be subscribed to all of the imported threads that they posted in.

    Is this possible?

    Nobody has thread subscriptions now, and I would like to do a mass subscription for everyone to the threads they had posted into in the past.

    Thanks

  • #2
    What version of MySQL are you running ?

    If it is 5 and you have no table prefix then it's this :

    Code:
    INSERT INTO subscribethread (userid, threadid)
    SELECT thread.postuserid, thread.threadid
    FROM thread 
    WHERE importthreadid <> 0;
    I wrote ImpEx.

    Blog | Me

    Comment

    Loading...
    Working...
    X