Previous Thread
Next Thread
Print Thread
Hop To
Joined: Apr 2014
Posts: 1
O
stranger
stranger
O Offline
Joined: Apr 2014
Posts: 1
Hi,
Can anyone tell me how can I use the Tab SQL command? Where can I learn how to do this?
Thanks in advance.

Joined: Dec 2003
Posts: 6,562
Likes: 78
Joined: Dec 2003
Posts: 6,562
Likes: 78
any mysql query/command works in that screen.
You can start with say phpmyadmin.
which will show you the query on certain functions.
Or read the manual:
http://us2.php.net/manual/en/
It is not for the faint of heart.

For example if you wish to find people with more than 99 Private messages.
Enter the following in the screen.
SQL Query
SELECT COUNT(*) as PMs, u.USER_DISPLAY_NAME
FROM
ubbt_PRIVATE_MESSAGE_USERS pmu, ubbt_PRIVATE_MESSAGE_TOPICS pmt, ubbt_USERS u
WHERE pmu.TOPIC_ID=pmt.TOPIC_ID
AND pmu.USER_ID=u.USER_ID
GROUP BY pmu.USER_ID HAVING PMs>99
ORDER BY PMs DESC

Of course the ubbt prefix may need to be changed for your site.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
spam issues
by ECNet - 03/19/2024 11:45 PM
Who's Online Now
1 members (1 invisible), 879 guests, and 150 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)