EQEmulator Forums

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 08:22 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.