How to get two usernames

[lorenw]

Hi all

This is for a condo forum that has bad blood.
The owner wants to view all pm's on his phpbb forum.

I'm not really on board with this because private means private.

I may opt out (depending on what you say) but also took this as a challenge.

The query I have is

SELECT phpbb_privmsgs_text.privmsgs_text, phpbb_users.username 
FROM phpbb_privmsgs_text
INNER JOIN 
phpbb_privmsgs
ON phpbb_privmsgs.privmsgs_id = phpbb_privmsgs_text.privmsgs_text_id
INNER JOIN 
phpbb_users
ON phpbb_users.user_id = phpbb_privmsgs.privmsgs_from_userid
AND phpbb_users.user_id = phpbb_privmsgs.privmsgs_to_userid

How do I select username twice( the from and to)?

I will not do this unless it is disclosed to th members but members are 60+ and may not understand this and the owner knows this.

I know this is a grey area but now I am on a quest for this, how do you get two user names with this query?
Thanks

[tripy]

How do I select username twice

Simply, you do 2 joins, on the same table, but matching the 2 users.

SELECT phpbb_privmsgs_text.privmsgs_text, user_from.username as from, user_to.username as to
FROM phpbb_privmsgs_text
INNER JOIN  phpbb_privmsgs
  ON phpbb_privmsgs.privmsgs_id = phpbb_privmsgs_text.privmsgs_text_id
INNER JOIN phpbb_users as user_from
  ON phpbb_users.user_id = phpbb_privmsgs.privmsgs_from_userid
INNER JOIN phpbb_users as user_to
  ON phpbb_users.user_id = phpbb_privmsgs.privmsgs_to_userid

I will not do this unless it is disclosed to th members but members are 60+ and may not understand this and the owner knows this.

I would be you, I'll bail out. As you said, private is private.
I may be a bit overzealous, but as long as there is no a requirement from the justice, I would refuse to do that.
More on the point, in my country, you are not allowed to eye drop on a private conversation.
If the users notice this, they can bring the operator to a court and trial him, as well as the people that helped him to achieve this.
It goes even as far as the boss of a firm is not allowed to inspect the mails that come from or are going to his employees, except if the employees are noticed of this.
An email is considered as private as a letter, and protected the same way.

[r937]

tripy, very nice reply, that was very thorough

[tripy]

Thanks Rudy.

[lorenw]

Many thanks, I tried the AS but was placing it wrong.

I will just say it can't be done and move on. I have always expected that moderators could see all of the private mesages and told the person that that feature should already be somewhere in the admin section.

Privacy laws are so confusing, in Italy all wifi activity must be logged and the US is proposing a similar law.

Also in the US, the electronic voting machine manufaturer Diebold had their inter office memo/emails posted on the web. At first people were asked to take them down and when it got legal, it was determined that they could be displayed since they were sent unencrypted over the internet.

The key is "private" message, and once they know they are being monitored they would switch to the phone.

Last thing I need is a legal issue.
I am totally against big brother and will opt out of this project and a big thanks for the input and answer, it will be filed away for future use.


Cheers
Loren