xF1 Mark all PMs as read (queries)

  • Downloading from our site will require you to have a paid membership. Upgrade to a Premium Membership today!

    Dont forget read our Rules! Also anyone caught Sharing this content will be banned. By using this site you are agreeing to our rules so read them. Saying I did not know is simply not an excuse! You have been warned.

Radio

    ven0m

    ven0m

    Administrator
    Staff member
    Administrator
    Moderator
    Platinum
    xenForo 2.x.x
    xenForo 1.x.x
    Contributor
    vBulletin All Access Pass
    The Chest
    Verified
    Ultra Platinum VIP
    Platinum VIP
    Gold VIP
    Silver VIP
    Premium
    Member
    Jul 17, 2005
    20,503
    7,742
    321
    localhost
    Heisenberg submitted a new resource:

    You must be registered for see links
    - Mark all PMs as read (queries)

    You can run these queries on your database to mark all PMs as read:

    Code: 
    UPDATE xf_conversation_recipient
SET last_read_date = UNIX_TIMESTAMP();

UPDATE xf_conversation_user
SET is_unread = 0;

UPDATE xf_user
SET conversations_unread = 0;

    Backup First.
    Click to expand...

    You must be registered for see links
     
    You must log in or register to reply here.
    Thread starter Similar threads Forum Replies Date
    ven0m xF1 Mass prune all PMs (queries) Tips & Guides 0
    Similar threads
    Top Bottom