On my site I have the user email verification system enabled as part of the user account registration process. I have had a *lot* of users try to register with fake emails (even though I've warned them in several places they need to use a real email address). Once they realize they need to register with a real email address, they re-register with a real address. But their old bogus account is still in the system, unverified.

I would like to be able to search for all of these bogus accounts and remove them from the DB to help keep the DB light. How can I do this in XOOPS 2.0.7.1?

In the database, go to the xoops_users table and look for any record where the 'level' is '0'

It's even easier than that:
Go to System -> Find Users, under "Type of users to show" set it to "In-Active Only"

cool thanks!