12-06-2003, 09:05 AM | #1 |
Ironworks Moderator
Join Date: February 28, 2001
Location: Boston/Sydney
Posts: 11,771
|
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 ----- |
12-06-2003, 09:36 AM | #2 | |
Symbol of Cyric
Join Date: March 28, 2003
Location: Australia
Age: 37
Posts: 1,124
|
Quote:
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 ] |
|
12-06-2003, 01:23 PM | #3 | |
The Magister
Join Date: November 13, 2003
Location: Austria
Age: 44
Posts: 143
|
Quote:
Interesting stuff, looks like a join of 3 DB2-tables to me. [ 12-06-2003, 01:29 PM: Message edited by: Ghoul ]
__________________
[img]\"http://www.myimgs.com/data/Ghoul/sigpic.jpg\" alt=\" - \" /><br />A Ghoul every day keeps fresh breath away. <img border=\"0\" title=\"\" alt=\"[Big Grin]\" src=\"biggrin.gif\" /> |
|
12-06-2003, 01:33 PM | #4 |
Ironworks Moderator
Join Date: February 28, 2001
Location: Boston/Sydney
Posts: 11,771
|
Cool, thanks! [img]smile.gif[/img]
|
12-06-2003, 10:49 PM | #5 |
40th Level Warrior
Join Date: October 29, 2001
Location: Western Wilds of Michigan
Posts: 11,752
|
It is a query of a database looking for all the private messages from user 8104 to user 5.
Now, the fact that you're seeing this... that's probably not good. If this is in a log, someone may be trying to hack into the database. If it's in a browser display, it may just be a temporary glitch cleared up with a refresh. If it's somewhere else... hard to say. In most computer environments, the average end user gets no access to SQL or any other DB query tools. The power user may get access to a report writer. The IT department can go wherever they want to... [img]smile.gif[/img]
__________________
*B* Save Early, Save Often Save Before, Save After Two-Star General, Spelling Soldiers -+-+-+ Give 'em a hug one more time. It might be the last. |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|