Log in

View Full Version : adding a column to the user table


punchbowl
08-18-2007, 11:22 AM
straightforward in mysql or do I have to somehow register the new field within vb too?

Dismounted
08-19-2007, 06:04 AM
You will only need to add the field as vBulletin will grab the whole row (SELECT *).

Opserty
08-19-2007, 08:41 AM
Wouldn't it be easier just to add a custom userfield (private if need be)? or is there some advantage of adding it on the user table?

Dismounted
08-19-2007, 09:04 AM
It depends on the purpose of what you are trying to achieve.

punchbowl
08-19-2007, 10:38 AM
You will only need to add the field as vBulletin will grab the whole row (SELECT *).

super - thanks.

Basically I want to use the field to store which banner was last viewed so I don't repeat them. I can store banners and any additional info elsewhere if I need to (not that bothered tbh.)

I'm not sure about custom userfields to be perfectly honest but I'll have a look around.

Cheers

Dismounted
08-19-2007, 01:21 PM
Custom userfields are only really needed when you want Admins/Users to edit a database field, in which this case there isn't a need.