EQEmulator Forums - World Characters Fail to get to Zone

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - World Characters Fail to get to Zone (https://www.eqemulator.org/forums/showthread.php?t=32405)

Akkadius

11-02-2010 11:32 AM

World Characters Fail to get to Zone

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

Quote:

Originally Posted by KLS (Post 193896)

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

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

11-02-2010 06:36 PM

Quote:

Originally Posted by joligario (Post 193900)

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.

All times are GMT -4. The time now is 01:12 AM.