SQL Query To View A Private Message

[McLarenDan]

Hi,

Is there such a query to view a certain users messages?

I saw one for vB 3.X

SELECT message FROM pmtext WHERE fromuserid = XXX;

But these tables don't exist in vB5... Any advice?

[Mark.B]

vB5 uses completely different database structures so there's no way to easily do that.
You're better off looking directly in the database, at the "text" table, this contains the text for all content types.

[McLarenDan]

Thanks for this Mark, I found the info I wanted.