changing MYSQL table column names

[osayidan]

Hi
I'm working on integrating a game server with vbulletin, and to do so i will have to change the column names that one of these uses to match the other, I think it would take much longer to modify the game source code for this, so i will go for changing it on vbulletin.

What i need to do is as follows:
change the VB table field "userid" to "account_id"
change the VB table field "username" to "userid"

Obviously, i know how to change the field names in MySQL, what i need help with is a quick and/or efficient and accurate way of changing the vbulletin source to properly use these new field names.

Thanks.

[Dismounted]

Good luck with that. userid and username is used everywhere in the code.

[Paul M]

I wouldn't try that if I were you. You will more than likely break your forum in a big way.

Much easier to add two columns to the user table and either have a plugin that populates them on sign-up, or a cron job that periodically replicates the values across.

[Marco van Herwaarden]

If you are using MySQL 5, then you might also be able to create a VIEW on the user table with different column names.

[osayidan]

Got it working by changing a few things in the game source code, turns out i didn't even have to touch vbulletin.
Thanks for the advice though.