Alliedassault           
FAQ Calendar
Go Back   Alliedassault > Lounge > Offtopic
Reload this Page Aa.com Question
Offtopic Any topics not related to the games we cover. Doesn't mean this is a Spam-fest. Profanity is allowed, enter at your own risk.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old
  (#26)
BadScript is Offline
Senior Member
 
Posts: 2,651
Join Date: Jan 2002
   
Default 06-05-2004, 04:16 AM

If you guys just wanted a short answer skip to the last two paragraphs, else read:

This forum used to be hosted on a perl version of ubb, Ultimate Bulletin Board.

As you may know, ubb ultilize something called a flat-file database (if you dont know what it is take a look <a href=http://www.webopedia.com/TERM/F/flat_file_database.html>here</a>, if you're too lazy it's just kinna like a huge excel spreadsheet); and at one point the site traffic is so heavy, about 20x more heavy then the current load I would say, that no machine in the world (or that I could afford) could handle that kinna traffic with a ff db powered forum.

The solution is to move from ubb perl/semi-colin seperated text file to phpBB php/mysql. But at that time there were already thousands of members registered, and some of the more dedicated members swore that they would hire a hitman to "deal with the situation" should I decide to remove all records and start over again.

Back then I had little knowledge and patient on the phpBB db structure, so I downloaded one of those database converter script and decided to try my luck. All goes well, except that the "join date" column on the user table did not get imported at all, so the default value 000000000000 were used instead.

Now the zero(s) value in the timestamp would actually correspond to 00:00:00 1 Jan 1970 GMT; EST is GMT -5 and therefore all EST systems subtract 5 hours from that day so it became 31 dec 1969.

Basically, every member who registered before the migration would have 31 Dec 1969 as his/her join date.

So there ya go.
  
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



Powered by vBulletin® Version 3.8.12 by ScriptzBin
Copyright ©2000 - 2025, vBulletin Solutions Inc.
vBulletin Skin developed by: vBStyles.com
© 1998 - 2007 by Rudedog Productions | All trademarks used are properties of their respective owners. All rights reserved.