Usergroup comparison page.

[designBox]

Hello,

I have searched almost everywhere an answer to this question but, unfortunately, it seems it has never been done before.

Basically I would like to build a vb page where the visitors (potential members) could review and compare the different usergroups to subscribe on. 1 is free, the 2 others are payable subscriptions.

I am trying to build a kind of table overview, where the option cells are automatically updated from the database.

Has anyone already made such thing? Anyone ready to try?

Thank you.

[Lynne]

I've never seen something like that. It shouldn't be too hard if you know what you are doing.

[designBox]

Thank you Lynne.
Actually, I am reading the "how-to include a non-vb page" tutorial.

However, too many new things for me, It's still confusing and I have no clue where to begin...

[Lynne]

It's a good tutorial, but start by just getting your page/template to show and then slowly add content (queries and such that produce your results) one thing at a time.

[designBox]

Yes, this is actually the way I am working (I should write experimenting... :P)

However, I have no clue how to retrieve the value of each usergroup option (for example: ability to have a signature or the max size of the allowed image...)

I looked everywhere in the documentation and on both forums (.com and .org) and wasn't able to find the beginning of an answer...

Maybe I am not using the correct search words...
Could you enlight me?

[Lynne]

You will need to look at the usergroup table and see what fields you want to grab and then make a query to do so.

[designBox]

Ah okay, it has to be a sql query. I was looking for an option like vboption['name']....

Thank you very much Lynne.