Hi guys,
sorry for bump again this thread (started by me

) but I have a question..
I wanna extract from my db
just users that have activated its account by email.
I thought to run a query like this:
Code:
SELECT username, email FROM user WHERE usergroup_id='2' AND usergroup_id='7' AND ...
or a code like this:
Code:
SELECT username, email FROM user, usergroup WHERE usergroup_id='2' AND usergroup_id='7' AND ...
This code is NOT correct but is just to explain my idea, if it's correct..
Sadly I don't know the vbulletin DB diagram (also googled a lot), can someone help me?
Thanks in advance!
--------------- Added [DATE]1300949738[/DATE] at [TIME]1300949738[/TIME] ---------------
Up!
It is very strange that none is interested to extract usename and emails fro the DB to make newsletter with an external software. The common documentation about this is strongly poor...