Thread: Extra fields in "user"

Originally Posted by Songoty

will mess up structure of insertions

Ah, so if i wanted variables done by name i would have to create a new table and store the names again?

Also, is there a way to enter data into these tables upon registering on the forum? So for example if i had the table; "imagelinks" or something, is there a way to automatically set an entry as "user, null" when registering?

you could try adding it to "the end" within the table, that shouldnt stuff insertions up form recolleciton

Originally Posted by Patawic

you could try adding it to "the end" within the table, that shouldnt stuff insertions up form recolleciton

ment to comment last night, but as Patawic said it should be fine as long as you add it at the end of the table

Unless vbulletin use some weird syntax, when you insert into a table you do something like this:

Code:

INSERT INTO table (col1, col2, col3) VALUES (value1, value2, value3);

Adding extra columns shouldn't make a difference since in your INSERT INTO statement you already specify which columns and the order of them that you are going to use in the VALUES bit.

vbulletin uses its own methods for executing queries.

Originally Posted by Patawic

vbulletin uses its own methods for executing queries.

But ultimately it'll generate SQL like the above and send that off to the MySQL server?

it uses the same queries etc, just different methods of sending it