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
ANDpmt.privmsgs_text_id= pm.privmsgs_id
ANDpm.privmsgs_to_userid = 5
ANDu.user_id= pm.privmsgs_from_userid
ANDu2.user_id= pm.privmsgs_to_userid
Line : 118
File : /home/roamer/public_html/krforums/mods/prillian/im_read.php
-----
|
Like Intrepid I think this query shows you all PM between the two users (ID 8104 and ID 5).
Interesting stuff, looks like a join of 3 DB2-tables to me.
[ 12-06-2003, 01:29 PM: Message edited by: Ghoul ]