[djlee]

u probably need to create a mod for this ... something along the lines of

select * from messages

then you want to inner join the id's to get the usernames (hence making 1 long query for the data) then output using a while loop and table htm format

obviously i doubt anyone here will actually code this for you .. its completly unethical and an invasion of privacy ..

a more ethical way to do this is to select only one users messages whom you may suspect be breaking the rules (i.e. spamming) that way you aint constantly snooping on ppl's messages but even then it holds the question whether you will get bored from time to time and decide to vew peoples messages

all in all it can be done but its not exactly "right" to do it ... if you suspect a bad user then check the messages via phpmyadmin rather than using a script (this also adds security as someone could find the script and break it to view your messages instead)