It's already built into threads, in the Admin menu look for User Stats and it will give you that info and a lot more. If you want the query itself you can dig it up from admin/showstats.php
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.
