UBB.Developers Forums UBB.threads 7 Development How Do I? Searching by User ID?

Is there a way I can search by user ID and get the user loggin name?

SELECT U_LoginName
FROM w3t_Users
WHERE U_Number = xxx

aha and where should I put that command and where the results appear

Under the admin menu.. into SQL Queries.

I knew that, but I just realized that I get the results there as well Thanks buddy

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.

Hmmm now why didnt I thought of that LOL. You guys are just too much for me . Thanks

That won't show you "login name" if you need that. The public profile will only show you display name.

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

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...

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

I'm wondering whether it would be ethical for me to post my super-duper query for peeking at PMs.

he he

I sometimes peek at the PMs on my board too. Sometimes ya gotta keep tabs on what's going on.

Don't feel alone Josh I do the same

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.