Update - Commits 610-611

Hello people.

This commit contains Login Server rework along with few minor additions.

- Updated login server to make full use of MMOCore and its NIO Selector. This is the first public C4 project that made L2J modern MMOCore operate with it.
- Cleanup of GameServerThread and took care of some duplicate values, since they were already kept into GameServerInfo instances.
- Added corrected GNU licences to certain classes.
- Column rename fixes for custom tables. Thanks SCRASH0.

For live servers, there are few SQL fields and the hexid file that need to be updated.

For taking care of SQL changes:

Code:


ALTER TABLE `accounts` CHANGE `lastServer` `last_server` INT(4) NULL DEFAULT '1';
ALTER TABLE `accounts` CHANGE `lastIP` `last_ip` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;
ALTER TABLE `accounts` CHANGE `lastactive` `last_active` DECIMAL(20,0) NULL DEFAULT NULL;


Hexid example:

Code:


#the hexID to auth into login
#Sat May 25 18:33:54 EEST 2019
HexID=<your hexid>
+ServerID=<your server id>


Regarding revision 611, the following patch should be run in MySQL.
The following patch has to be applied in MySQL.

Code:


ALTER TABLE `custom_droplist` CHANGE `min` `min_drop` INT(11) NOT NULL DEFAULT '0';
ALTER TABLE `custom_droplist` CHANGE `max` `max_drop` INT(11) NOT NULL DEFAULT '0';
ALTER TABLE `custom_merchant_buylists` CHANGE `order` `item_order` DECIMAL(4,0) NOT NULL DEFAULT '0';


Thanks a lot for your support and have fun.

Best regards,
DnR

Kudos to DnR.
Awesome work as always mate.

Good thing the project keeps getting better.