AIKA ONLINE: Leak Server Files and Tools editing.

[I Am NoLimiT]

use PL bin editor ,load the decrypted file,actualizar lista,edit all and save,then crypt again test that if it works

Thanks for sharing friend xlw00tlx going to test that later. Godspeed!

 

[xlw00tlx]

 

[I Am NoLimiT]

How to you save it?Cause when I saved it the file size change to few KB and when I tried to use it the game throw error on PI.

 

[starkiller]

How to you save it?Cause when I saved it the file size change to few KB and when I tried to use it the game throw error on PI.

yeah the same thing is happening to me it always defaults to like 42k i noticed it loads 6000 lines on the original Pl but from the edit it says 113 which causes the Aika client to throw a pl error and crash.

 

[xlw00tlx]

i didnt edit anything yet i dont want it to break,its supossed that you load line by line in the IP editor,edit and save then crypt it but idk how it works

 

[starkiller]

i didnt edit anything yet i dont want it to break,its supossed that you load line by line in the IP editor,edit and save then crypt it but idk how it works

thats pretty much what i figured but ive been too busy lately to just sit down and go through it, I might start on it tomorrow on my day off.

 

[tornadoo]

Can someone please upload a correct db please? This is my error when trying to execute:

[SQL] Query aika_db_limpa start[ERR] 1273 - Unknown collation: 'utf8mb4_0900_ai_ci'[ERR] -- MySQL dump 10.13  Distrib 8.0.31, for Win64 (x86_64)---- Host: localhost    Database: aika_db4-- -------------------------------------------------------- Server version    8.0.17/*!40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET [USER=1333464006]old[/USER]_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!50503 SET NAMES utf8 */;/*!40103 SET [USER=1333464006]old[/USER]_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00' */;/*!40014 SET [USER=1333464006]old[/USER]_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET [USER=1333464006]old[/USER]_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET [USER=1333464006]old[/USER]_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET [USER=1333464006]old[/USER]_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;---- Table structure for table `account_validate`--DROP TABLE IF EXISTS `account_validate`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `account_validate` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `email` varchar(255) NOT NULL,  `code` varchar(40) NOT NULL,  `verified` tinyint(1) NOT NULL DEFAULT '0',  `referrer` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,  `verified_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,  PRIMARY KEY (`id`),  UNIQUE KEY `email` (`email`,`code`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `account_validate`--LOCK TABLES `account_validate` WRITE;/*!40000 ALTER TABLE `account_validate` DISABLE KEYS */;/*!40000 ALTER TABLE `account_validate` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `accounts`--DROP TABLE IF EXISTS `accounts`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `accounts` (  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,  `forum_id` int(10) unsigned NOT NULL,  `username` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,  `password_hash` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,  `mail` varchar(254) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,  `last_token` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,  `last_token_creation_time` int(10) unsigned DEFAULT NULL,  `nation` int(10) unsigned DEFAULT NULL,  `isactive` int(10) unsigned DEFAULT '0',  `account_status` int(10) unsigned DEFAULT '0',  `account_type` int(10) unsigned DEFAULT '0',  `storage_gold` int(10) unsigned DEFAULT '0',  `cash` int(11) DEFAULT '0',  `ip_created` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,  `time_created` int(10) unsigned DEFAULT NULL,  `premium_time` bigint(20) unsigned NOT NULL DEFAULT '1',  `ban_days` int(10) unsigned DEFAULT NULL,  `playtime` int(10) unsigned DEFAULT NULL,  PRIMARY KEY (`id`),  UNIQUE KEY `forum_id` (`forum_id`),  UNIQUE KEY `username` (`username`,`mail`)) ENGINE=InnoDB AUTO_INCREMENT=2179 DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `accounts`--LOCK TABLES `accounts` WRITE;/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;INSERT INTO `accounts` VALUES (1,1,'admin','21232f297a57a5a743894a0e4a801fc3','admin@gmail.com','8c2429e7fe8c3f5319049de2417a7a2a',7,0,0,0,0,0,0,'127.0.0.1',1673047794,1642714066,0,NULL);/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `auction`--DROP TABLE IF EXISTS `auction`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `auction` (  `AuctionId` int(11) NOT NULL AUTO_INCREMENT,  `Active` int(11) NOT NULL DEFAULT '1',  `CharacterId` int(11) NOT NULL,  `ItemType` in[SQL] Finished with error

 

[I Am NoLimiT]

Can someone please upload a correct db please? This is my error when trying to execute:


[SQL] Query aika_db_limpa start[ERR] 1273 - Unknown collation: 'utf8mb4_0900_ai_ci'[ERR] -- MySQL dump 10.13 Distrib 8.0.31, for Win64 (x86_64)---- Host: localhost Database: aika_db4-- -------------------------------------------------------- Server version 8.0.17/*!40101 SET @old_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @old_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @old_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!50503 SET NAMES utf8 */;/*!40103 SET @old_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00' */;/*!40014 SET @old_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @old_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @old_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @old_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;---- Table structure for table `account_validate`--DROP TABLE IF EXISTS `account_validate`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `account_validate` ( `id` int(11) NOT NULL AUTO_INCREMENT, `email` varchar(255) NOT NULL, `code` varchar(40) NOT NULL, `verified` tinyint(1) NOT NULL DEFAULT '0', `referrer` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `verified_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`,`code`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `account_validate`--LOCK TABLES `account_validate` WRITE;/*!40000 ALTER TABLE `account_validate` DISABLE KEYS */;/*!40000 ALTER TABLE `account_validate` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `accounts`--DROP TABLE IF EXISTS `accounts`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `accounts` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `forum_id` int(10) unsigned NOT NULL, `username` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `password_hash` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `mail` varchar(254) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `last_token` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `last_token_creation_time` int(10) unsigned DEFAULT NULL, `nation` int(10) unsigned DEFAULT NULL, `isactive` int(10) unsigned DEFAULT '0', `account_status` int(10) unsigned DEFAULT '0', `account_type` int(10) unsigned DEFAULT '0', `storage_gold` int(10) unsigned DEFAULT '0', `cash` int(11) DEFAULT '0', `ip_created` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `time_created` int(10) unsigned DEFAULT NULL, `premium_time` bigint(20) unsigned NOT NULL DEFAULT '1', `ban_days` int(10) unsigned DEFAULT NULL, `playtime` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `forum_id` (`forum_id`), UNIQUE KEY `username` (`username`,`mail`)) ENGINE=InnoDB AUTO_INCREMENT=2179 DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `accounts`--LOCK TABLES `accounts` WRITE;/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;INSERT INTO `accounts` VALUES (1,1,'admin','21232f297a57a5a743894a0e4a801fc3','admin@gmail.com','8c2429e7fe8c3f5319049de2417a7a2a',7,0,0,0,0,0,0,'127.0.0.1',1673047794,1642714066,0,NULL);/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `auction`--DROP TABLE IF EXISTS `auction`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `auction` ( `AuctionId` int(11) NOT NULL AUTO_INCREMENT, `Active` int(11) NOT NULL DEFAULT '1', `CharacterId` int(11) NOT NULL, `ItemType` in[SQL] Finished with error

Download and install MYSQL 8, then restore the database using Navicat and tick the button 'continue on error'

 

[starkiller]

use PL bin editor ,load the decrypted file,actualizar lista,edit all and save,then crypt again test that if it works

I have 90% of the client translated atm ill upload it once its finished later also dont use the PL_Editor its crap use the master editor and editm items names cash shop etc you have the option to save to server and client even fix and add quests through it.

 

[I Am NoLimiT]

I have 90% of the client translated atm ill upload it once its finished later also dont use the PL_Editor its crap use the master editor and editm items names cash shop etc you have the option to save to server and client even fix and add quests through it.

Yeah you are right about this, I don't recommend PL_Editor its mess up the PL.Bin
btw nice work starkiller on your progress on this project.

 

[xlw00tlx]

@starkiller how to make the master editor open the quest and npc files then?

 

[starkiller]

@starkiller how to make the master editor open the quest and npc files then?

If you have the master editor set up correctly it should auto open the npc files and quests from the server and client

There you can edit the texts and the conditions for the quests on the client and server b sure to save it locally and to the client I havent done much for the quests yet cuz im still working on translation but its on the list if you need any more help or want to work on this (this goes for any one that actually wants to try to make something of this, add me on discord Sunkilla#2336)

 

[xlw00tlx]

but tell me how to setup it correctly then...what path did you use in the master editor client or server or where are the files located

 

[starkiller]

but tell me how to setup it correctly then...what path did you use in the master editor client or server or where are the files located

OH okay yeah my bad sorry about that under the AikaServer.ini config file in the server folder you can edit the master editor path
should look like this at the bottom of the file

Just put the path where every you have the client installed and by default it will read from the data folder of the server and the files from the client side as well. I have my Aika Server folder on C: Drive and my client folder on E: Drive.

My C: Drive looks like this if that helps

Aika Server containing all the server files and the Database folder containing all the related files to that folder.

 

[starkiller]

Spawnmobs:
edit AllMobsInfo.csv and MonsterListCSV.csv for spawnmobs (locate: AikaServer\Bin\Data\Mobs)
modify x,y in the MonsterListCSV.csv with Master Editor on Mobs tab

AllMobsInfo.csv EX:
1,Max Filhote,216,0,0,207,134,1,7,119,119,1025,0,0,17,25,18,17,45,0,0,0,0,0,23,0,1
216 is the area/map code. (I don't have code list)

Reinforcement:
View attachment 173175
+1 = 16
+2 = 32
+3 = 48
....
+12 = 192
...
+15 = 240 (a few weapons can +15)

Anyone can share translated client-side UI\FieldScene6.bin and UI\FieldSceneB6.bin. (English / Chinese)

About AikaServer.dproj , I've compiled and no success. Source code is damaged before publish, right?

I'm currently translating FieldScene6/FieldSceneB6 if that's all you need I can upload once finished but I plan to upload a completely English compatible server once its all finished.

 

[xlw00tlx]

master editor still not loading set the path correctly ,can anyone share a config?

 

[starkiller]

master editor still not loading set the path correctly ,can anyone share a config?

Here you go just fill out the info for your MySQL and database name and password and if you have the iNiZ client on Drive E all the better if not just try and change the drive letter and open master editor from inside the server files. If you need anymore help let me know.


View attachment AikA Config Files.zip



Also here's some progress on the FieldScene6.bin

there might be some errors or mis-translations but ill go back through it and if any one finds anything just let me know and ill get it fixed.



I was able to open the NA Version of the FieldScene files so I can make a better translation comparing them side by side.

 

[I Am NoLimiT]

here is AikaReborn's character info

You must be registered to see links

The only difference on what @starkiller progress on translation was Ele Resist, but Resistance also will do.

 

[starkiller]

The only difference on what @starkiller progress on translation was Ele Resist, but Resistance also will do.

Yeah that's all Fixed now and its comparable to the Reborn Version, Ive been wracking my head trying to figure out the Item Usage/Box open error I'm getting and trying to fix it.
PacketControl: UseItem error. msg['31/12/1969 22:00' is not a valid date and time : I get that every-time I try to open a premium Item or Use one it seems to default to Unix Epoch Time (31/12/1969) which doesn't match the actual time so it throws an error Im assuming its because its a bad delphi build maybe? Is any one else experiencing this and found a way to solve it?

 

[MorpheuX]

Does anyone know how to perform edits? Add NPC's, update similar to normal Aika (I used encrypt and decrypt), but still with binary protection when opening editlist