- Joined
- Sep 21, 2013
- Messages
- 2,319
- Reaction score
- 3,109
Have the same issue, I downloaded the file but same issue
You searched here?
You must be registered to see links
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!Have the same issue, I downloaded the file but same issue
AL-Game\config\main\rates.properties
I put that version.dll into the bin32 folder, it fixed the Not_aion 5.8 client "Cannot regist XignCode Module" error so I can login and play, but I now have the old Windows 10 mouse problem does that version.dll have the fix? I see it is mentioned in the Launcher/aion_start_local.bat file but it doesn't seem to work.You can use this...
Yes, use version 1.6I put that version.dll into the bin32 folder, it fixed the Not_aion 5.8 client "Cannot regist XignCode Module" error so I can login and play, but I now have the old Windows 10 mouse problem does that version.dll have the fix? I see it is mentioned in the Launcher/aion_start_local.bat file but it doesn't seem to work.
You can use this...
This isn't AionGer, but it's way better
- bin32 for this emu in the Aion Login FIX folder.
Many fixes have been made by me, but i won't continue with fixes for this...
You must be registered to see links
Have fun!!
[USER=2000306500]Echo[/USER] offecho Starting Aion 5.8 Server...start bin32\Aion.bin -ip:127.0.0.1 -port:2106 -cc:1 -lang:ENG -noweb -nowebshop -nokicks -ncg -noauthgg -charnamemenu -ingameshop
Hello,
I'm trying to get this single player EMU Setup but I cant seem to get around an error on the client.
image of error:
You must be registered to see links
Change it to -cc:2 and test.
Also check this on the clientYou must be registered to see links
[Err] 1067 - Invalid default value for 'time'[Err] /*Navicat MySQL Data TransferSource Server : Aion_5.8Source Server Version : 50546Source Host : localhost:3306Source Database : al_server_gsTarget Server Type : MYSQLTarget Server Version : 50546File Encoding : 65001Date: 2017-08-08 17:34:25*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for abyss_landing-- ----------------------------DROP TABLE IF EXISTS `abyss_landing`;CREATE TABLE `abyss_landing` ( `id` int(11) NOT NULL, `level` int(11) NOT NULL DEFAULT '1', `points` int(10) NOT NULL DEFAULT '0', `siege` int(10) NOT NULL DEFAULT '0', `commander` int(10) NOT NULL DEFAULT '0', `artefact` int(10) NOT NULL DEFAULT '0', `base` int(10) NOT NULL DEFAULT '0', `monuments` int(10) NOT NULL DEFAULT '0', `quest` int(10) NOT NULL DEFAULT '0', `facility` int(10) NOT NULL DEFAULT '0', `race` enum('ELYOS','ASMODIANS') NOT NULL, `level_up_date` timestamp NOT NULL DEFAULT '2015-01-01 01:00:00', PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for abyss_rank-- ----------------------------DROP TABLE IF EXISTS `abyss_rank`;CREATE TABLE `abyss_rank` ( `player_id` int(11) NOT NULL, `daily_ap` int(11) NOT NULL, `daily_gp` int(11) NOT NULL, `weekly_ap` int(11) NOT NULL, `weekly_gp` int(11) NOT NULL, `ap` int(11) NOT NULL, `gp` int(11) NOT NULL, `rank` int(2) NOT NULL DEFAULT '1', `top_ranking` int(4) NOT NULL, `daily_kill` int(5) NOT NULL, `weekly_kill` int(5) NOT NULL, `all_kill` int(4) NOT NULL DEFAULT '0', `max_rank` int(2) NOT NULL DEFAULT '1', `last_kill` int(5) NOT NULL, `last_ap` int(11) NOT NULL, `last_gp` int(11) NOT NULL, `last_update` decimal(20,0) NOT NULL, `rank_pos` int(11) NOT NULL DEFAULT '0', `old_rank_pos` int(11) NOT NULL DEFAULT '0', `rank_ap` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`player_id`), CONSTRAINT `abyss_rank_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for account_balance-- ----------------------------DROP TABLE IF EXISTS `account_balance`;CREATE TABLE `account_balance` ( `account_id` int(11) NOT NULL, `price_id` int(11) NOT NULL DEFAULT '0', `value` int(255) DEFAULT '0', PRIMARY KEY (`account_id`,`price_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for announcements-- ----------------------------DROP TABLE IF EXISTS `announcements`;CREATE TABLE `announcements` ( `id` int(3) NOT NULL AUTO_INCREMENT, `announce` text NOT NULL, `faction` enum('ALL','ASMODIANS','ELYOS') NOT NULL DEFAULT 'ALL', `type` enum('SHOUT','ORANGE','YELLOW','WHITE','SYSTEM') NOT NULL DEFAULT 'SYSTEM', `delay` int(4) NOT NULL DEFAULT '1800', PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for banned_hdd-- ----------------------------DROP TABLE IF EXISTS `banned_hdd`;CREATE TABLE `banned_hdd` ( `uniId` int(10) NOT NULL AUTO_INCREMENT, `hdd_serial` varchar(50) NOT NULL, `time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, `details` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`uniId`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for base_location-- ----------------------------DROP TABLE IF EXISTS `base_location`;CREATE TABLE `base_location` ( `id` int(11) NOT NULL, `race` enum('ELYOS','ASMODIANS','NPC') NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for blocks-- ----------------------------DROP TABLE IF EXISTS `blocks`;CREATE TABLE `blocks` ( `player` int(11) NOT NULL, `blocked_player` int(11) NOT NULL, `reason` varchar(100) NOT NULL DEFAULT '', PRIMARY[Err] 1067 - Invalid default value for 'time'[Err] CREATE TABLE `log_command_add` ( `id` int(11) NOT NULL AUTO_INCREMENT, `admin_id` int(11) NOT NULL DEFAULT '0', `admin_name` varchar(255) DEFAULT '', `player_id` int(11) DEFAULT '0', `player_name` varchar(255) DEFAULT '', `item_unique` int(255) DEFAULT '0', `item_id` int(11) DEFAULT '0', `item_name` varchar(255) DEFAULT '', `item_count` varchar(255) DEFAULT '0', `description` varchar(255) DEFAULT '', `date` datetime DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=211 DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for log_exchange_admin-- ----------------------------DROP TABLE IF EXISTS `log_exchange_admin`;CREATE TABLE `log_exchange_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `admin_id` int(11) NOT NULL DEFAULT '0', `admin_name` varchar(255) DEFAULT '', `player_id` int(11) DEFAULT '0', `player_name` varchar(255) DEFAULT '', `item_id` int(11) DEFAULT '0', `item_name` varchar(255) DEFAULT '', `item_count` varchar(255) DEFAULT '0', `description` varchar(255) DEFAULT '', `date` datetime DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=429 DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for log_exchange_player-- ----------------------------DROP TABLE IF EXISTS `log_exchange_player`;CREATE TABLE `log_exchange_player` ( `id` int(11) NOT NULL AUTO_INCREMENT, `player_id` int(11) NOT NULL DEFAULT '0', `player_name` varchar(255) DEFAULT '', `partner_id` int(11) DEFAULT '0', `partner_name` varchar(255) DEFAULT '', `item_id` int(11) DEFAULT '0', `item_name` varchar(255) DEFAULT '', `item_count` varchar(255) DEFAULT '0', `description` varchar(255) DEFAULT '', `date` datetime DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=8995 DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for log_mail_admin-- ----------------------------DROP TABLE IF EXISTS `log_mail_admin`;CREATE TABLE `log_mail_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `admin_id` int(11) NOT NULL DEFAULT '0', `admin_name` varchar(255) DEFAULT '', `item_id` int(11) DEFAULT '0', `item_name` varchar(255) DEFAULT '', `item_count` varchar(255) DEFAULT '0', `player_recive_name` varchar(255) DEFAULT '', `description` varchar(255) DEFAULT '', `date` datetime DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for log_mail_player-- ----------------------------DROP TABLE IF EXISTS `log_mail_player`;CREATE TABLE `log_mail_player` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sender_id` int(11) NOT NULL DEFAULT '0', `sender_name` varchar(255) DEFAULT '', `item_id` int(11) DEFAULT '0', `item_name` varchar(255) DEFAULT '', `item_count` varchar(255) DEFAULT '0', `player_recive_name` varchar(255) DEFAULT '', `description` varchar(255) DEFAULT '', `date` datetime DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1029 DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for mail-- ----------------------------DROP TABLE IF EXISTS `mail`;CREATE TABLE `mail` ( `mail_unique_id` int(225) NOT NULL, `mail_recipient_id` int(11) NOT NULL, `sender_name` varchar(26) NOT NULL, `mail_title` varchar(20) NOT NULL, `mail_message` varchar(1000) NOT NULL, `unread` tinyint(4) NOT NULL DEFAULT '1', `attached_item_id` int(11) NOT NULL, `attached_kinah_count` bigint(20) NOT NULL, `attached_ap_count` bigint(20) NOT NULL, `express` tinyint(4) NOT NULL DEFAULT '0', `recieved_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`mail_unique_id`), KEY `mail_recipient_id` (`mail_recipient_id`), CONSTRAINT `FK_mail` FOREIGN KEY (`mail_recipient_id`) REFERENCES `players` (`id`) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Table struct[Msg] Finished - Unsuccessfully--------------------------------------------------
Thank you for the response
I saw that the gameserver was wrong in gameserver.properties, and did not know there were so many country codes Id have to change
That error is resolved.
However I have to redo my sql because I had version 8.0 install and many database errors and I can't get in game.
Hello, sorry to bother again
Im experiencing another problem completely unrelated to what I just posted lol
I've installed mysql 5.7 in attempt to redo my databases but Navicat refuses to import tables correctly. Previously I had sql 8.0 installed with the same table creation problem and when I got around the country code issue I created a character and failed to join because a game server "world db" discrpeancy. Im assuming the table importation/creation errors were because of my sql version that I had installed. But now I'm not sure
Below is the error I have when executing the a al_server_gs sql file
Code:[Err] 1067 - Invalid default value for 'time'[Err] /*Navicat MySQL Data TransferSource Server : Aion_5.8Source Server Version : 50546Source Host : localhost:3306Source Database : al_server_gsTarget Server Type : MYSQLTarget Server Version : 50546File Encoding : 65001Date: 2017-08-08 17:34:25*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for abyss_landing-- ----------------------------DROP TABLE IF EXISTS `abyss_landing`;CREATE TABLE `abyss_landing` ( `id` int(11) NOT NULL, `level` int(11) NOT NULL DEFAULT '1', `points` int(10) NOT NULL DEFAULT '0', `siege` int(10) NOT NULL DEFAULT '0', `commander` int(10) NOT NULL DEFAULT '0', `artefact` int(10) NOT NULL DEFAULT '0', `base` int(10) NOT NULL DEFAULT '0', `monuments` int(10) NOT NULL DEFAULT '0', `quest` int(10) NOT NULL DEFAULT '0', `facility` int(10) NOT NULL DEFAULT '0', `race` enum('ELYOS','ASMODIANS') NOT NULL, `level_up_date` timestamp NOT NULL DEFAULT '2015-01-01 01:00:00', PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for abyss_rank-- ----------------------------DROP TABLE IF EXISTS `abyss_rank`;CREATE TABLE `abyss_rank` ( `player_id` int(11) NOT NULL, `daily_ap` int(11) NOT NULL, `daily_gp` int(11) NOT NULL, `weekly_ap` int(11) NOT NULL, `weekly_gp` int(11) NOT NULL, `ap` int(11) NOT NULL, `gp` int(11) NOT NULL, `rank` int(2) NOT NULL DEFAULT '1', `top_ranking` int(4) NOT NULL, `daily_kill` int(5) NOT NULL, `weekly_kill` int(5) NOT NULL, `all_kill` int(4) NOT NULL DEFAULT '0', `max_rank` int(2) NOT NULL DEFAULT '1', `last_kill` int(5) NOT NULL, `last_ap` int(11) NOT NULL, `last_gp` int(11) NOT NULL, `last_update` decimal(20,0) NOT NULL, `rank_pos` int(11) NOT NULL DEFAULT '0', `old_rank_pos` int(11) NOT NULL DEFAULT '0', `rank_ap` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`player_id`), CONSTRAINT `abyss_rank_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for account_balance-- ----------------------------DROP TABLE IF EXISTS `account_balance`;CREATE TABLE `account_balance` ( `account_id` int(11) NOT NULL, `price_id` int(11) NOT NULL DEFAULT '0', `value` int(255) DEFAULT '0', PRIMARY KEY (`account_id`,`price_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for announcements-- ----------------------------DROP TABLE IF EXISTS `announcements`;CREATE TABLE `announcements` ( `id` int(3) NOT NULL AUTO_INCREMENT, `announce` text NOT NULL, `faction` enum('ALL','ASMODIANS','ELYOS') NOT NULL DEFAULT 'ALL', `type` enum('SHOUT','ORANGE','YELLOW','WHITE','SYSTEM') NOT NULL DEFAULT 'SYSTEM', `delay` int(4) NOT NULL DEFAULT '1800', PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for banned_hdd-- ----------------------------DROP TABLE IF EXISTS `banned_hdd`;CREATE TABLE `banned_hdd` ( `uniId` int(10) NOT NULL AUTO_INCREMENT, `hdd_serial` varchar(50) NOT NULL, `time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, `details` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`uniId`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for base_location-- ----------------------------DROP TABLE IF EXISTS `base_location`;CREATE TABLE `base_location` ( `id` int(11) NOT NULL, `race` enum('ELYOS','ASMODIANS','NPC') NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for blocks-- ----------------------------DROP TABLE IF EXISTS `blocks`;CREATE TABLE `blocks` ( `player` int(11) NOT NULL, `blocked_player` int(11) NOT NULL, `reason` varchar(100) NOT NULL DEFAULT '', PRIMARY[Err] 1067 - Invalid default value for 'time'[Err] CREATE TABLE `log_command_add` ( `id` int(11) NOT NULL AUTO_INCREMENT, `admin_id` int(11) NOT NULL DEFAULT '0', `admin_name` varchar(255) DEFAULT '', `player_id` int(11) DEFAULT '0', `player_name` varchar(255) DEFAULT '', `item_unique` int(255) DEFAULT '0', `item_id` int(11) DEFAULT '0', `item_name` varchar(255) DEFAULT '', `item_count` varchar(255) DEFAULT '0', `description` varchar(255) DEFAULT '', `date` datetime DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=211 DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for log_exchange_admin-- ----------------------------DROP TABLE IF EXISTS `log_exchange_admin`;CREATE TABLE `log_exchange_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `admin_id` int(11) NOT NULL DEFAULT '0', `admin_name` varchar(255) DEFAULT '', `player_id` int(11) DEFAULT '0', `player_name` varchar(255) DEFAULT '', `item_id` int(11) DEFAULT '0', `item_name` varchar(255) DEFAULT '', `item_count` varchar(255) DEFAULT '0', `description` varchar(255) DEFAULT '', `date` datetime DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=429 DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for log_exchange_player-- ----------------------------DROP TABLE IF EXISTS `log_exchange_player`;CREATE TABLE `log_exchange_player` ( `id` int(11) NOT NULL AUTO_INCREMENT, `player_id` int(11) NOT NULL DEFAULT '0', `player_name` varchar(255) DEFAULT '', `partner_id` int(11) DEFAULT '0', `partner_name` varchar(255) DEFAULT '', `item_id` int(11) DEFAULT '0', `item_name` varchar(255) DEFAULT '', `item_count` varchar(255) DEFAULT '0', `description` varchar(255) DEFAULT '', `date` datetime DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=8995 DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for log_mail_admin-- ----------------------------DROP TABLE IF EXISTS `log_mail_admin`;CREATE TABLE `log_mail_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `admin_id` int(11) NOT NULL DEFAULT '0', `admin_name` varchar(255) DEFAULT '', `item_id` int(11) DEFAULT '0', `item_name` varchar(255) DEFAULT '', `item_count` varchar(255) DEFAULT '0', `player_recive_name` varchar(255) DEFAULT '', `description` varchar(255) DEFAULT '', `date` datetime DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for log_mail_player-- ----------------------------DROP TABLE IF EXISTS `log_mail_player`;CREATE TABLE `log_mail_player` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sender_id` int(11) NOT NULL DEFAULT '0', `sender_name` varchar(255) DEFAULT '', `item_id` int(11) DEFAULT '0', `item_name` varchar(255) DEFAULT '', `item_count` varchar(255) DEFAULT '0', `player_recive_name` varchar(255) DEFAULT '', `description` varchar(255) DEFAULT '', `date` datetime DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1029 DEFAULT CHARSET=utf8;-- ------------------------------ Table structure for mail-- ----------------------------DROP TABLE IF EXISTS `mail`;CREATE TABLE `mail` ( `mail_unique_id` int(225) NOT NULL, `mail_recipient_id` int(11) NOT NULL, `sender_name` varchar(26) NOT NULL, `mail_title` varchar(20) NOT NULL, `mail_message` varchar(1000) NOT NULL, `unread` tinyint(4) NOT NULL DEFAULT '1', `attached_item_id` int(11) NOT NULL, `attached_kinah_count` bigint(20) NOT NULL, `attached_ap_count` bigint(20) NOT NULL, `express` tinyint(4) NOT NULL DEFAULT '0', `recieved_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`mail_unique_id`), KEY `mail_recipient_id` (`mail_recipient_id`), CONSTRAINT `FK_mail` FOREIGN KEY (`mail_recipient_id`) REFERENCES `players` (`id`) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Table struct[Msg] Finished - Unsuccessfully--------------------------------------------------
Downgraded again to MYsql 5.5.57 and no more import issues, fingers crossed I can get some gameplay going.
Sorry for the ignorance, wasn't aware of so many different dependencies during the setup lol.Just check the MySQL version in ZeroXI_controller_read_me, from UniServerZ that comes with Emu, version 5.5.
//useskill
Is there any chance for the source code of this to be shared? =)This isn't AionGer, but it's way better
- bin32 for this emu in the Aion Login FIX folder.
Many fixes have been made by me, but i won't continue with fixes for this...
You must be registered to see links
Have fun!!
If im not wrong this is latest copy open source on GitHubIs there any chance for the source code of this to be shared? =)