What Tables are effected...

[interrealm]

I'm working on integrating the vB into my site and was wondering what tables would be effected by adding members to the user table from outside of vb?

To make sure this is clear, I have a script from a seperate webpage that will add a new user to the user table that vB uses. Will doing this outside of vB cause problems or should I also be intserting data into other tables at the same time.

[Admin]

You need to insert the record into the `user` table and also another record into the `userfield` table (this is important).

[interrealm]

what about the date/time fields. While I was looking.. i notce they arn't standard date/time fields, but instead are int set. What format do these use? or can i leave those blank?

[Admin]

For date fields that are INT(10) you use PHP's UNIX timestamp (see http://www.us2.php.net/manual/en/function.time.php).

[interrealm]

Ok... thats going to make it pretty hard to do via cold fusion which is what the majority of the rest of my site is made in I think. Would it be ok to simply insert an existing value, say I sign up on Jan 5, 2002 and take the value used for that login and use it to inserto into the required fields? I know that the "signup" date might be wrong but i'm not too concerned about that.. since whenever they come back to the sight and log in they will update other values correctly.

Does anyone have a "signup script" built in PHP that would work from outside of vB? I'd like to be able to add extra fields like "address, city, state, zip" and a few others that I'll be using through out my site.

[Admin]

Are you sure ColdFusion doesn't support UNIX Timestamp? I doubt it...

[interrealm]

Good news is there is a tag for CF that supports Unix TS conversion.

Now my last question for now... Will it effect vB if i add fields to the user table? such as address and whatnot? if i give them a unique prefix on each field name like XXXadd, XXXzip and so on that way i twon't effect future possible additions by the vB developers.? Should I add these to the "userfield" table instead?

[Admin]

You should probably prefix the fields you add like you said, just to be on the safe side.
But I would recommend adding them as profile fields, from the Admin CP. You can set them to be only editable by admins, or hidden from regular users, which is enough unless you need more things to them.

[interrealm]

Very cool.. thanks for the help.

Once i get it done I'll post it here if ya want... it might be handy to add a "non-php hack" section for things like this.

Like i said.. once i get this completed I can post the info if desired.