$bbuserinfo and customfields

[Pseudomizer]

Hello @LL,

i need a little help to finish my new hack.

The problem i have is $customfields. In the DB there is a table called userfield which has all the definitions for customfields but NOT the actual data. I can get the data with $bbuserinfo($profilefield['birthday']) but i would like to access this without a specific userid. I would like to read out all birthday fields, locations, etc from each user.

At the moment i can only read the data with:

select field28 from userfield order by userid;

But this will not work for all people because field28 will not always be field28. If someone creates a new profilefield he will get the next number which is available. So my script will fail in 90% of the cases. I would like to prevent this.

Is there a way to optimize this please ?

Any help is appreciated.

Cheers,