[Gio~Logist]

A query like this is what you'd want.

select userid, username, email from user WHERE languageid == 'x'

So in a vb page it will be something like:

PHP Code:

$vbulletin->db->query_read("SELECT userid, username, email
                        FROM " . TABLE_PREFIX . "user
                        WHERE languageid == 'x'
                    "); 


Replace x with the languageid for the language you're trying to pull info based on.