The Arcive of vBulletin Modifications Site.

jim doodle · #1 08-16-2009, 09:08 PM

Is there a simple way to export the user data, reason being i am setting up an owners club and require all users to add their correct postal address, which i then need to export and mail merge with a franking system.

Ideally i want a simple system which the admin can use.

anyone got any ideas?

--------------- Added [DATE]1250464978[/DATE] at [TIME]1250464978[/TIME] ---------------

I am not sure i can do this in the normal backend an di can;t find any advanced export facilities as addons.

what about a custom SQL query?

Code:

SELECT username FROM user WHERE usergroupid='9';

anyone knows the table/names of the custom fields in the database?

--------------- Added [DATE]1250470346[/DATE] at [TIME]1250470346[/TIME] ---------------

To anwer my own question:

Code:

SELECT userid, field6, field7, field11, field8, field12 FROM userfield WHERE userid IN (SELECT userid FROM user WHERE usergroupid='9');

where field6 - field 12 are address fields and usergroup 9 is my desired usergroup to pull from