vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB5 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=262)
-   -   SQL Query to view Private Messages (https://vborg.vbsupport.ru/showthread.php?t=313422)

ForceHSS 08-05-2014 01:09 PM

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 08-05-2014 10:05 PM

Quote:

Originally Posted by Scanu (Post 2509835)
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 08-06-2014 08:05 PM

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 08-07-2014 01:03 AM

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.


All times are GMT. The time now is 08:12 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00975 seconds
  • Memory Usage 1,727KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete