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.
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.
vBulletin® v3.8.11, Copyright ©2000-2025, vBulletin Solutions Inc.