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.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.