Compile list based on AIM/MSN/Skype etc etc

[BlueNinjaGo]

I would like a list of all the users who have entered in a name for AIM (for example)... is there an easy way of doing this?

[1Unreal]

Go into the Adminc CP > Maintenance > Execute SQL Query

Paste this in to find ICQ:


SELECT username, icq
FROM `user`
WHERE `icq` != ''


Just replace icq with aim, yahoo, msn or skype to find the others.

[BlueNinjaGo]

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'RevForums.user' doesn't exist

Any thoughts?

[1Unreal]

Do your tables have a prefix?

[BlueNinjaGo]

"vb_" i believe