This community not respect others work ..
This community not respect others work ..
but here leaking is allowedOriginally Posted by Luna8080
Link Geodata Added
Be careful!! virus threat in the Geodata link.
Confirmed. VirusTotal scan results: https://www.virustotal.com/gui/file/...ae41/detection
The link has been removed.
@Onyen542 make sure to not share viruses on RaGEZONE.
hmm let i check and reupload the geodata maybe infected virus.
- - - Updated - - -
Link Update, no virus infected
Total virus scan : https://www.virustotal.com/gui/url/3...2945/detection
You scanned the webpage:
You'll see something like this if you scanned a file:
But you are right, the new files do not contain a virus. Thanks for updating
I come from China, can I add your Skype friend? Is it convenient to tell you your skypeid?
Good day, MySQL5GearDAO.java does anyone have a full version of 5.8?
You can test 5.8 on link downloadOn my emulator 5.8 have custom for gear save use this //gearset
5.8 when I try to create a character. It prompts dB for errors.
Send console log error here.
2020-07-23 13:51:44,262 INFO [main] com.aionemu.gameserver.GameServer [null:-1] Connected to LoginServer!2020-07-23 13:51:44,765 INFO [ReadWrite-0 Dispatcher] com.aionemu.gameserver.network.BannedMacManager [null:-1] [BannedMacManager] Loaded 0 banned mac addresses2020-07-23 13:51:59,377 INFO [Accept Dispatcher] com.aionemu.gameserver.network.aion.AionConnection [null:-1] connection from: 127.0.0.12020-07-23 13:51:59,385 INFO [ReadWrite-0 Dispatcher] com.aionemu.gameserver.network.aion.serverpackets.SM_VERSION_CHECK [null:-1] Authentication with Client Version 5.82020-07-23 13:51:59,450 ERROR [ReadWrite-0 Dispatcher] com.aionemu.commons.network.packet.BaseClientPacket [BaseClientPacket.java:251] Missing S for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE2020-07-23 13:51:59,451 ERROR [ReadWrite-0 Dispatcher] com.aionemu.commons.network.packet.BaseClientPacket [BaseClientPacket.java:233] Missing Q for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE2020-07-23 13:51:59,456 INFO [InstantPool-11] com.aionemu.gameserver.network.loginserver.LoginServer [null:-1] [LoginServer] Account authed: 1 = a19892020-07-23 13:51:59,468 INFO [PacketProcessor:1] com.aionemu.gameserver.network.aion.A.TA [null:-1] 0 IPv4: {}2020-07-23 13:51:59,468 INFO [PacketProcessor:1] com.aionemu.gameserver.network.aion.A.TA [null:-1] Mac: E0-D5-5E-2E-E5-5E2020-07-23 13:51:59,469 INFO [PacketProcessor:1] com.aionemu.gameserver.network.aion.A.TA [null:-1] HDD SERIAL: 000000002020-07-23 13:51:59,470 INFO [PacketProcessor:1] com.aionemu.gameserver.network.aion.A.TA [null:-1] Local IP: {192.168.202.1}2020-07-23 13:51:59,470 INFO [PacketProcessor:1] com.aionemu.gameserver.network.aion.A.TA [null:-1] Connect IP: 127.0.0.12020-07-23 13:52:12,505 ERROR [PacketProcessor:2] mysql5.MySQL5PlayerDAO [MySQL5PlayerDAO.java]:275] Error saving new player: 100989946 Gdgsgcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'cube_expands' in 'field list' at sun.reflect.GeneratedConstructorAccessor476.newInstance(Unknown Source) ~[na:na] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80] at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80] at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE] at mysql5.MySQL5PlayerDAO.saveNewPlayer(MySQL5PlayerDAO.java]:271) ~[na:na] at com.aionemu.gameserver.services.player.PlayerService.storeNewPlayer(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.A.qA.runImpl(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.AionClientPacket.run(Unknown Source) [AL-Game.jar:na] at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) [al-commons.jar:na] at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:41) [al-commons.jar:na] at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:266) [al-commons.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]2020-07-23 13:52:14,609 ERROR [PacketProcessor:3] mysql5.MySQL5PlayerDAO [MySQL5PlayerDAO.java]:275] Error saving new player: 100989946 Gdgsgcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'cube_expands' in 'field list' at sun.reflect.GeneratedConstructorAccessor476.newInstance(Unknown Source) ~[na:na] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80] at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80] at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE] at mysql5.MySQL5PlayerDAO.saveNewPlayer(MySQL5PlayerDAO.java]:271) ~[na:na] at com.aionemu.gameserver.services.player.PlayerService.storeNewPlayer(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.A.qA.runImpl(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.AionClientPacket.run(Unknown Source) [AL-Game.jar:na] at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) [al-commons.jar:na] at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:41) [al-commons.jar:na] at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:266) [al-commons.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]2020-07-23 13:52:19,583 INFO [pool-4-thread-1] com.aionemu.gameserver.network.loginserver.LoginServer [null:-1] Sending account disconnected 1
THX！！！
"Unknown column 'cube_expands' in 'field list'"
Are you sure the mysql database and server exist, and that that column exists?...
WHat you talking about ^^ if no db how he even pass to create character panel lol ^^
You have wrong field in the base =your db have mess there missing in table "Players" position "cube_expands"
instert that in console and enter.
DROP TABLE IF EXISTS `players`;CREATE TABLE `players` ( `id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `account_id` int(11) NOT NULL, `account_name` varchar(50) NOT NULL, `exp` bigint(20) NOT NULL DEFAULT 0, `recoverexp` bigint(20) NOT NULL DEFAULT 0, `x` float NOT NULL, `y` float NOT NULL, `z` float NOT NULL, `heading` int(11) NOT NULL, `world_id` int(11) NOT NULL, `world_owner` int(11) NOT NULL DEFAULT 0, `gender` enum('MALE','FEMALE') NOT NULL, `race` enum('ASMODIANS','ELYOS') NOT NULL, `player_class` enum('WARRIOR','GLADIATOR','TEMPLAR','SCOUT','ASSASSIN','RANGER','MAGE','SORCERER','SPIRIT_MASTER','PRIEST','CLERIC','CHANTER','ENGINEER','GUNNER','ARTIST','BARD','RIDER','ALL') NOT NULL, `creation_date` timestamp NULL DEFAULT NULL, `deletion_date` timestamp NULL DEFAULT NULL, `last_online` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(), `cube_expands` tinyint(1) NOT NULL DEFAULT 0, `advanced_stigma_slot_size` tinyint(1) NOT NULL DEFAULT 0, `warehouse_size` tinyint(1) NOT NULL DEFAULT 0, `mailbox_letters` tinyint(4) unsigned NOT NULL DEFAULT 0, `title_id` int(3) NOT NULL DEFAULT -1, `bonus_title_id` int(3) NOT NULL DEFAULT -1, `dp` int(3) NOT NULL DEFAULT 0, `soul_sickness` tinyint(1) unsigned NOT NULL DEFAULT 0, `reposte_energy` bigint(20) NOT NULL DEFAULT 0, `goldenstar_energy` bigint(20) NOT NULL DEFAULT 0, `growth_energy` bigint(20) NOT NULL DEFAULT 0, `bg_points` int(11) NOT NULL DEFAULT 0, `online` tinyint(1) NOT NULL DEFAULT 0, `note` text DEFAULT NULL, `mentor_flag_time` int(11) NOT NULL DEFAULT 0, `initial_gamestats` int(11) NOT NULL DEFAULT 0, `last_transfer_time` decimal(20,0) NOT NULL DEFAULT 0, `fatigue` int(11) NOT NULL DEFAULT 0, `fatigueRecover` int(11) NOT NULL DEFAULT 0, `fatigueReset` int(11) NOT NULL DEFAULT 0, `stamps` int(11) NOT NULL DEFAULT 0, `last_stamp` timestamp NULL DEFAULT NULL, `rewarded_pass` int(1) NOT NULL DEFAULT 0, `joinRequestLegionId` int(11) NOT NULL DEFAULT 0, `joinRequestState` enum('NONE','DENIED','ACCEPTED') NOT NULL DEFAULT 'NONE', `frenzy_points` int(4) NOT NULL DEFAULT 0 COMMENT 'Upgrade Arcade FrenzyPoints', `frenzy_count` int(1) NOT NULL DEFAULT 0, `show_inventory` int(1) NOT NULL DEFAULT 1, `bonus_buff_time` timestamp NULL DEFAULT NULL, `bonus_type` enum('RETURN','NEW','NORMAL') NOT NULL DEFAULT 'NORMAL', `wardrobe_size` int(4) NOT NULL, `is_highdaeva` tinyint(1) NOT NULL DEFAULT 0, `addon_cp` int(11) NOT NULL DEFAULT 0, `creativity_step` int(11) NOT NULL DEFAULT 0, `wardrobe_slot` int(11) NOT NULL DEFAULT 2, `luna_consume_count` int(11) NOT NULL DEFAULT 0, `muni_keys` int(11) NOT NULL DEFAULT 0, `luna_consume` int(11) NOT NULL DEFAULT 0, `toc_floor` int(11) NOT NULL DEFAULT 0, `minion_skill_points` int(5) NOT NULL DEFAULT 0, `is_newbie_guide` tinyint(4) DEFAULT NULL, `service_bonus` varchar(255) DEFAULT NULL, `service_bonus_time` timestamp NULL DEFAULT NULL, `minion_point` int(255) DEFAULT 0, `minion_function_time` timestamp NULL DEFAULT NULL, `minion_auto_renew_function` tinyint(1) DEFAULT 0, `minion_auto_charge` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `name_unique` (`name`) USING BTREE, KEY `account_id` (`account_id`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
Reply With Quote
