World Characters Fail to get to Zone

**Akkadius** · #1 11-02-2010, 11:32 AM

Apparently when I updated to Rev 1713 I was not able to get any characters from my server to log in. Looked funny for a while to have 0 people on my server for 20 minutes before I came back from helping a coworker and realized this was happening as a bunch of people were trying to get in.

I went back to 1707 just fine, I would have to assume it has something to do with 1712 but that is simply a guess.

Anyways here it is before someone else posts it.

**KLS** · #2 11-02-2010, 03:49 PM

Required SQL is hard.

**Akkadius** · #3 11-02-2010, 05:14 PM

Quote:

Originally Posted by KLS

Required SQL is hard.

Quote:

KLS: Added field to limit AAs based on account creation time.

A very quick glance at this with no SQL anywhere I didn't look twice and I was getting phone calls.

Required SQL is hard.

**joligario** · #4 11-02-2010, 05:51 PM

I'm guessing you found this in r1711?

Code:

ALTER TABLE `altadv_vars` ADD `account_time_required` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `clientver`;
ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;

**Akkadius** · #5 11-02-2010, 06:36 PM

Quote:

Originally Posted by joligario

I'm guessing you found this in r1711?

Code:

ALTER TABLE `altadv_vars` ADD `account_time_required` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `clientver`;
ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;

Absolutely. I normally look in the SQL bin, like I mentioned above I was answering phone calls left and right while trying to reboot.