Menu
His Majesty The King
  • Home
  • Forum
  • Contact Me
  • Advertise
  • About Me
His Majesty The King

How To: Use SQL to read private messages on a vbulletin forum

Posted on April 4, 2007July 16, 2019 by The King
This applies only to super users who have db access rights. This feature should not be abused. It should only be used in cases of harrasment.

A problem that sometimes arises is that of users sending nasty-grams via PM to each other. Unlike some forum software, vbulletin does a good job of keeping private messages private.

If you find yourself in a situation where you need to know the contents of a private message the following two SQL queries can be performed in the back-end of the vbulletin admin area.

Code:

select * from vb3_pmtext where fromusername='USERNAME'

The above code snippet (change USERNAME to whoever you are searching for) will pull a listing of all PMs sent by a user.

Code:

select * from vb3_pmtext where touserarray like '%USERNAME%'

The above code snippet (change USERNAME to whoever you are searching for) will pull a listing of all PM's sent to that user.

Once again, these two commands are very powerful and should only be used when the need is great. Remember, your forum community places a good deal of trust in you, it is up to you to keep that trust by not abusing the privacy of private messages. Facebooktwitterredditpinterestlinkedinmail
  • Code
  • MySQL
  • vBulletin
  • Leave a Reply Cancel reply

    Your email address will not be published. Required fields are marked *

    *

    code

    Tags

    Advertising Apple Blogging Board Games Campaign Card Games Cats D&D Digg DS Fail Fallout Fallout 3 Family Fiction FWE Google Heroes Humor Make Money Online Movies News Nintendo Opinion PC Pokemon Politics PS3 Review Rockwars Role Playing Games RPG Server Social Media Star Wars Stocks Story The Dice Tower Tom Vasel TV Video Games Weird Wii Wordpress xBox 360
    January 2021
    S M T W T F S
     12
    3456789
    10111213141516
    17181920212223
    24252627282930
    31  
    « Sep    

    Popular Posts

    • Building a town with MySims

      I have been spending the last week or two with EA's new MySims game for th...

    • Wii Sports Golf: Tips and Tricks

      So, you think you know how to play golf? You think you can just grab that...

    • .
      Dungeons and Dragons 5E Cantrips – Fire Bolt

      Now that I have returned to the realm of Dungeons and Dragons I find mysel...

    • Warhammer 40K: Lt. Varas

      I've been working on painting the miniatures that came with the WarHammer...

    • .
      Pokemon Ranger: Manaphy Egg?

      The Feb 2007 issue of Nintendo Power magazine mentions a special Egg you c...

    • .
      Painting the UltraMarines

      I've been working on painting the miniatures that came with the WarHammer...

    • .
      Dungeons and Dragons 5E Cantrips – Dancing Lights

      Dancing Lights is very useful when cast as a tactical spell. While it can n...

    • Wii Fit: The Unboxing

      As I mentioned in my earlier post today my copy of Wii fit arrived via UPS...

    • Pokémon Trading Card Game (TCG): Rumble

      On December 2, 2009 Pokemon International released the Pokémon Trading Car...

    • The Wii goes NASCAR

      No your eyes are not deceiving you that is indeed a NASCAR car with the Wi...

    Recent Posts

    • Papers Please!
    • Dungeons and Dragons 5E Cantrips – Dancing Lights
    • Can’t Run an App in Windows 10? Try System File Checker
    • The Beefed Up Gunners Project
    • Fallout 4 – Evan, part 1
    ©2021 His Majesty The King | Powered by WordPress & Superb Themes