PDA

View Full Version : World Characters Fail to get to Zone


Akkadius
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
11-02-2010, 03:49 PM
Required SQL is hard.

Akkadius
11-02-2010, 05:14 PM
Required SQL is hard.

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
11-02-2010, 05:51 PM
I'm guessing you found this in r1711?

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
11-02-2010, 06:36 PM
I'm guessing you found this in r1711?

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.