SQL Query to view Private Messages

[ForceHSS]

Use this plugin it will let you login to his account and check the pms he has sent but not sure if it will work for vb5 you could talk to the coder to see if they will make it for vb5

[Dead Eddie]

Originally Posted by Scanu

Then I'm not sure i completely understand what he wants

He wants to read the contents of the private messages.

That's the node table in vb5. Not the Private Message table. The PM table just contains meta data about the type of message.

[ARLreborn]

Hi guys,

I actually found what I wanted to find in the table "Text".

I wasnt out to invade anyone elses messages. I just wanted confirmation of a certain post being sent around to various members... Downloaded the "test" db - Ctrl + F in Notepad ++ and bingo, found the exact same message someone else reported to about 130 different people.

Thanks for the help all.

I'd like to just mention one thing - we do NOT invade peoples messages without reason, all I wanted to see was a certain message and I found it.

Solved!

@Dead Eddie, thanks for that code, not sure it works - as I havent tried it, but I'd like to personally thank you for replying without questioning. (I wont be using this code as I have found what I needed to - but much appreciate your time, sir!)

@AusPhotography - Thank you too

@ the haters - I only had one PM reported, the staff member swore it was only one person he sent it too. But alas - we found multiple entries in 'text' db. He knew which accounts were our test accounts unfortunately.

Have a great day folks!

[Max Taxable]

Haters? People who try to help are haters?

You didn't tell us it was a staff member. You said it was a user.

I offered my procedure for you in the event that you're ambivalent about reading private messages. Alot of people are and there's nothing wrong with that. In the future, may I suggest you have some decoy accounts only you know. That's how I do all of mine.

Decoy account and test account are two different things.