|
Joined: Feb 2003
Posts: 196
Member
|
Member
Joined: Feb 2003
Posts: 196 |
Is there a way I can search by user ID and get the user loggin name?
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
SELECT U_LoginName FROM w3t_Users WHERE U_Number = xxx
|
|
|
|
Joined: Feb 2003
Posts: 196
Member
|
Member
Joined: Feb 2003
Posts: 196 |
aha and where should I put that command and where the results appear
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Under the admin menu.. into SQL Queries.
|
|
|
|
Joined: Feb 2003
Posts: 196
Member
|
Member
Joined: Feb 2003
Posts: 196 |
I knew that, but I just realized that I get the results there as well Thanks buddy
|
|
|
|
Joined: Mar 2003
Posts: 215
Junior Member
|
Junior Member
Joined: Mar 2003
Posts: 215 |
You can also plug the number in for the profile page: example: http://yourdomain/ubbthreads/showprofile.php?Cat=&User=###This won't require being Admin to check...and you can click on another user to load a profile and edit the URL quite easily.
|
|
|
|
Joined: Feb 2003
Posts: 196
Member
|
Member
Joined: Feb 2003
Posts: 196 |
Hmmm now why didnt I thought of that LOL. You guys are just too much for me . Thanks
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
That won't show you "login name" if you need that. The public profile will only show you display name.
|
|
|
|
Joined: Feb 2003
Posts: 196
Member
|
Member
Joined: Feb 2003
Posts: 196 |
Actually, between you and I. I was going through the messages in PHPMYADMIN, but you see the tables only shows User ID sender and receiver. You can imagin how difficult for me to know who is who, so now I know, even if its display name
|
|
|
|
Joined: Mar 2003
Posts: 215
Junior Member
|
Junior Member
Joined: Mar 2003
Posts: 215 |
Oh that's true Joshpet...
In that case...just edit any user you can find and switch the ID for the id you want. By the time you've done that you could have typed out the SQL though...
|
|
|
|
Joined: Aug 2002
Posts: 1,191
Kahuna
|
Kahuna
Joined: Aug 2002
Posts: 1,191 |
Salim,
If you want to see who posted what the query you need to run in phpmyadmin:
SELECT P.B_Board, ........ , U.U_Username FROM w3t_Posts P, w3t_Users U WHERE P.B_Posterid = U.U_Number
This will show you the username instead of the user number
Nikos
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
Addict
Joined: Apr 2002
Posts: 1,768 |
I'm wondering whether it would be ethical for me to post my super-duper query for peeking at PMs.
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
he he I sometimes peek at the PMs on my board too. Sometimes ya gotta keep tabs on what's going on.
|
|
|
|
Joined: Apr 2001
Posts: 3,266
Member
|
Member
Joined: Apr 2001
Posts: 3,266 |
Don't feel alone Josh I do the same
|
|
|
|
Joined: Aug 2002
Posts: 1,191
Kahuna
|
Kahuna
Joined: Aug 2002
Posts: 1,191 |
For me there is no need (yet) cause like I said before we are only 80 users. But for other boards quite big in number of users and in a quite competitive environment some admins can be "excused" for peeking at the PM's to see if their users are advertising other boards.
Nikos
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 449
Joined: February 2008
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|