Visit the Ironworks Gaming Website Email the Webmaster Graphics Library Rules and Regulations Help Support Ironworks Forum with a Donation to Keep us Online - We rely totally on Donations from members Donation goal Meter

Ironworks Gaming Radio

Ironworks Gaming Forum

Go Back   Ironworks Gaming Forum > Ironworks Gaming Forums > General Discussion > General Conversation Archives (11/2000 - 01/2005)

 
 
Thread Tools Search this Thread
Old 12-06-2003, 09:05 AM   #1
Memnoch
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

-----

__________________


Memnoch is offline  
Old 12-06-2003, 09:36 AM   #2
Intrepid
Symbol of Cyric
 

Join Date: March 28, 2003
Location: Australia
Age: 36
Posts: 1,124
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 ]
Intrepid is offline  
Old 12-06-2003, 01:23 PM   #3
Ghoul
The Magister
 

Join Date: November 13, 2003
Location: Austria
Age: 43
Posts: 143
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 ]
__________________
[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\" />
Ghoul is offline  
Old 12-06-2003, 01:33 PM   #4
Memnoch
Ironworks Moderator
 

Join Date: February 28, 2001
Location: Boston/Sydney
Posts: 11,771
Cool, thanks! [img]smile.gif[/img]
__________________


Memnoch is offline  
Old 12-06-2003, 10:49 PM   #5
Bungleau
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.
Bungleau is offline  
 


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT -4. The time now is 07:45 AM.


Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2024 Ironworks Gaming & ©2024 The Great Escape Studios TM - All Rights Reserved