JakeG
05-20-2001, 10:48 PM
I run the latest release of vBulletin (2 as of the coming release today) at http://ninten.com and am currently working on a leagues system which will be used on the site, in no ways related to message forums, apart from the fact that I'd like to use the same members table for the members of the leagues.
Firstly, I'd like to know what changes I can make to the members table. I'm aware that through the CP it's possible to 'Add' User Profile Fields. What I think I'd like to do is add the filed "isleague" to the table as an ENUM ('Y','N') DEFAULT 'N' field. Should this be added through the 'Add User Profile Fields' or simply be calling an SQL command directly to the MySQL database directly?
For example, will this create any problems when updating to later versions of vBulletin etc.?
The way I believe my system will work is that I will store other values relating to users in a separate table. For example, this will store fields such as 'rank', 'won', 'lost', 'drawn', 'points' etc. This table will then join with the vbulletin.members table through the username (or whatever it's called) field.
Again, my question here is related to changes in vBulletin. Should this leagues-members table be part of the same vBulletin MySQL database, or should it be in a separate database (for example, would vBulletin bugger it up at all through one of the admin or upgrading options? If it did, then it would need to reside in it's own separate database). Or, alternatively, would it be an even better idea to simply use the one members table for vBulletin and the leagues system, hence not requiring a separate members table?
I hope you understood all that! It would be fantastic if someone could help me on this one. I haven't had a chance to study the vBulletin code yet but that's what I'm working on this week.
Firstly, I'd like to know what changes I can make to the members table. I'm aware that through the CP it's possible to 'Add' User Profile Fields. What I think I'd like to do is add the filed "isleague" to the table as an ENUM ('Y','N') DEFAULT 'N' field. Should this be added through the 'Add User Profile Fields' or simply be calling an SQL command directly to the MySQL database directly?
For example, will this create any problems when updating to later versions of vBulletin etc.?
The way I believe my system will work is that I will store other values relating to users in a separate table. For example, this will store fields such as 'rank', 'won', 'lost', 'drawn', 'points' etc. This table will then join with the vbulletin.members table through the username (or whatever it's called) field.
Again, my question here is related to changes in vBulletin. Should this leagues-members table be part of the same vBulletin MySQL database, or should it be in a separate database (for example, would vBulletin bugger it up at all through one of the admin or upgrading options? If it did, then it would need to reside in it's own separate database). Or, alternatively, would it be an even better idea to simply use the one members table for vBulletin and the leagues system, hence not requiring a separate members table?
I hope you understood all that! It would be fantastic if someone could help me on this one. I haven't had a chance to study the vBulletin code yet but that's what I'm working on this week.