Porting Member Info to Other Systems

[silurius]

I'm helping build a membership database for our project, and I'd like to have the vBulletin DB be the system of record for users. Eventually we are going to have to port the numbers and names out to some kind of card system.

I wanted to create a custom field assigning numbers to users in a sequence, but there didn't seem to be a built-in way (or plugin) to accomplish that, so I edited the MEMBERINFO template to add "(Member # $userinfo[userid])".

For exporting member info to another system, has anyone else developed a process, or even a basic script? I know enough SQL to get my self in trouble so I'd love to see feedback from someone who has been down this path before.

[Marco van Herwaarden]

SELECT * FROM user;

[silurius]

SELECT * FROM user;

Thanks! I actually need something like the following, except that this is only yielding info for my very first user:

SELECT user.userid, user.username, userfield.field17, userfield.field18, userfield.field19, user.joindate, user.email
from user, userfield
order by user.userid, joindate;

[Marco van Herwaarden]

Well that query will not only list the first user, it will list every user, PLUS for every user all the userfield rows of all users.