Quote:
Originally posted by Memnoch:
Do you know what this means?
----
SELECT u.username, u.user_id, u.user_sig_bbcode_uid, u.user_sig, pm.*, pmt.privmsgs_bbcode_uid, pmt.privmsgs_text, u2.username
AS username2, u2.user_id
AS user_id2
FROM phpbb_privmsgs pm, phpbb_privmsgs_text pmt, phpbb_users u, phpbb_users u2
WHERE pm.privmsgs_id = 8104
AND pmt.privmsgs_text_id = pm.privmsgs_id
AND pm.privmsgs_to_userid = 5
AND u.user_id = pm.privmsgs_from_userid
AND u2.user_id = pm.privmsgs_to_userid
Line : 118
File : /home/roamer/public_html/krforums/mods/prillian/im_read.php
-----
|
displays the usernames, member id sig etc
to me it looks like a personal message from memember ID 8104 to member 5
so this SQL should display all PMs between these two members
although I could be wrong
[ 12-06-2003, 09:38 AM: Message edited by: Intrepid ]