A Couple Of Random Questions

[UserName]

Hello everyone. I have a couple of questions for you guru's:

1) As some of you know, I am integrating the vB with my full site membership system. I am currently using the first release of verion 1.1.3. My developer emailed me today and told me that the 'joindate' field in the DB has a type of DATE in my older version of the script, but in the new one it has a type of UNSIGNED INT. I don't know if it has changed or if my developer is nuts, but I'm wondering if someone can tell me what the proper type for this field is?

2) If a user hits the PREVIEW POST button before posting it, and another user has posted on the thread since that user started composing their message, will the preview screen show the new post (the one posted while the user was composing their message) down at the bottom (where the complete thread is shown)?

Thanks for the help!

[John]

1) That is correct. The date is now stored as an integer in the same way that Unix stores the time: number of seconds after 1970. That is a *lot* faster than using a MySQL date field, and is also more likely to be supported by other databases.

2) Yes it will show the new post.

John