Excuting SQL Query from AdminCP

Hi.

I'm sure there is some way of entering a special code into the "Execute SQL Query" part of the Maintainance tab in Admin Control Panel!

The special code can bring up users PMs that are stored in the database without fussing about with phpMyAdmin.

Any idea what the special code is, and how you alter it to find different users PM's etc?

Many Thanks!

what do you mean brin up user's pms? If you want to read PMs there is a hack for that on vb.org.

Yes, I have the hack installed, it does its job!

But I heard that you can run SQL Queries via AdminCP, which will bring members PM's, but you have to alter the UserID in the code, and message number in the PM box, and you can bring it up!

I am just generally interested as to what the code is, not too important though, as I've already got the hack!

It sounds plausible though!

Some quick SQL code to view messages...

SELECT `message`
FROM `pmtext`
WHERE `fromusername` = 'username'
LIMIT 0 , 30