[Development] Soul of the Ultimate Nation - Server Emulator

Tried all and it didnt work for me in InteliJ :)

Quote:

---

Originally Posted by Ashime

@Alex Mgh

This what is available in the market for Spring Boot when searching for plugins.

---

- - - Updated - - -

Not MySql, you need Postgresql
never worked with it before but already got used to it.
It comes with a nice GUI and a SQL Shell.

Quote:

---

Originally Posted by Ashime

Okay. I will have to install Eclipse and MySQL. The ReadMe on GitHub is getting updated today, whether it's by you, CwaniX or I.

---

Quote:

---

Originally Posted by Alex Mgh

Anyway GOOD NEWS!

English translation works !
Translated and Injected most Strings.
Missing:
-Names
-QuestText
-Error/Warning/Loading Messages

https://i.imgur.com/hRNvqEL.png


here is link to some more screenshots:
https://imgur.com/a/ebp4mUc

---

That's awesome. How are you injecting the patch? We need to create a tool to repacking the WPK, that would be more beneficial long term.

- - - Updated - - -
@CwaniX

I cannot update your project in GitHub. All it did was fork the project and the commits I made to README.md is made on my end in my version of the project. Check out the link to see the README.md.
LINK: https://github.com/Ashime/OpenSUN-Server/tree/patch-1

Due to the fact this is my first time doing GitHub, I apologize for the lack of understanding.

- - - Updated - - -

Quote:

---

Originally Posted by Alex Mgh

You have to set the application.location variable in your run/debug configuration.

https://i.imgur.com/sJxZOoN.png
in Eclipse/SpringSuite it looks like this. In IntelliJ almost the same.
Then you have to save the Config files (you can find them in each server as a .PROPERTY_TEMPLATE file)
into a config folder. The config folder must be inside the path you specified as the application.location.

The auth server config is missing two lines, CWanix posted them in page 4 i think

EDIT: here

opensun.agent.ip=127.0.0.1
opensun.agent.port=9000

---

@Alex Mgh
What must you do in the Environment tab to make this work? I have all of the property_template files in a folder called config. Thank you.

https://drive.google.com/open?id=1XI..._nzgY_6Ll9HBDh


English translate for last update in korean server

@CwaniX @Alex Mgh
[STRIKE]Where is the database to attach into PostgreSQL 10?[/STRIKE]

Nevermind, I figured it out from page 1. Its mentioned as listed below:

Quote:

---

Originally Posted by CwaniX

Yes you need PostgreSQL, but the only thing you need to do is create an empty database and a user for it.

---

Quote:

---

Originally Posted by CwaniX

You do not have to manually execute any scripts. The entire base structure will be created the first time the server is started. The only thing you have to do manually is to create a player account with the command:

Code:

---

SELECT public.func_create_user_and_account(<username>, <password>)

---

---

WOW I was away for a while and so much happened here :laugh:. I will have some time tomorrow so I'll try to work on the server a little bit :):.

- - - Updated - - -

Quote:

---

Originally Posted by Ashime

I cannot update your project in GitHub. All it did was fork the project and the commits I made to README.md is made on my end in my version of the project. Check out the link to see the README.md.
LINK: https://github.com/Ashime/OpenSUN-Server/tree/patch-1

Due to the fact this is my first time doing GitHub, I apologize for the lack of understanding.

---

You should be able to create a pull request: https://help.github.com/en/github/co...st-from-a-fork

@CwaniX

Thank you. I am still learning GitHub.

- - - Updated - - -

What must you do in the Environment tab to make the Debugging Configuration settings work for Spring Boot? I have all of the property_template files in a folder called config. Thank you.

Quote:

---

Originally Posted by Ashime

@CwaniX
What must you do in the Environment tab to make the Debugging Configuration settings work for Spring Boot? I have all of the property_template files in a folder called config. Thank you.

---

Did you change the file names accordingly? It should look like this:
Attachment 167118

Quote:

---

Originally Posted by CwaniX

Did you change the file names accordingly? It should look like this:
Attachment 167118

---

I don't have console-server.properties_template. I will change their extension to .properties. What do you do after that?

Quote:

---

Originally Posted by DostaDenis

https://drive.google.com/open?id=1XI..._nzgY_6Ll9HBDh


English translate for last update in korean server

---

Thanks for that, but this server will be EP 1.
We got all the translation files, problem is injecting them into the client. Tho i figured that out too. Any help is appreciated:)

Quote:

---

Originally Posted by Alex Mgh

Thanks for that, but this server will be EP 1.
We got all the translation files, problem is injecting them into the client. Tho i figured that out too. Any help is appreciated:)

---

you can merge the translated files using wpktool
Ex:

Code:

---

wpktool -m Resource.wpk Data\messagetext.txt Inter\messagetext.txt
wpktool -m Resource.wpk Data\Interface\StringTable.txt Inter\Stringtable.txt
wpktool -m Resource.wpk Data\Interface\Stringtableforname.txt Inter\Stringtableforname.txt
wpktool -m Resource.wpk Data\Interface\StringTableForProgram.txt Inter\StringTableForProgram.txt

---

But the problems is the file size need to match with the original files so the right way is to make a tool to unpack/repack the wpk file.

Quote:

---

Originally Posted by ashlay

you can merge the translated files using wpktool
Ex:

Code:

---

wpktool -m Resource.wpk Data\messagetext.txt Inter\messagetext.txt
wpktool -m Resource.wpk Data\Interface\StringTable.txt Inter\Stringtable.txt
wpktool -m Resource.wpk Data\Interface\Stringtableforname.txt Inter\Stringtableforname.txt
wpktool -m Resource.wpk Data\Interface\StringTableForProgram.txt Inter\StringTableForProgram.txt

---

But the problems is the file size need to match with the original files so the right way is to make a tool to unpack/repack the wpk file.

---

Thanks for the advise.
I have a way to inject everything i want into the WPK, regardless of size :) I can even add new stuff if i want.
Problem is that sometimes the the Client gets error messages if the translated file contains stuff the client cannot handle and crashes.
I am pretty sure i will get a solid full translated client in a week depending how much time i have.

UDPATE:

https://i.imgur.com/W2Qanra.png

95% of names work too :)
and Error Messeges etc.

basicly "only" QuestText is left.

Quote:

---

Originally Posted by Ashime

❈ ServerList Packet

I was able to figure out majority of the bytes for the ansServerList packet. I was able to have two servers, one server with one channel, and the second server with two channels. Please review the packet structure below the protocols listed below.

The protocols for ServerList follow as:
byte S2C_ansSrvList_Srv = 0x11;
byte S2C_ansSrvList_Chn = 0x12;

Use this information below to create a dynamic server list packet on the auth/agent server. Couldn't tell if your server has this setup or not.

Code:

---


/*
    SERVERS ONLY:
    Size (2 bytes)
    Category (1 byte - 0x33)
    Protocol (1 byte - 0x11)
    # of Servers (1 byte)
    Server Name (32 bytes)
    Unknown (1 byte)
    Server # (1 byte)
    Unknown (1 byte)
    Unknown (1 byte) - filler/separator (0x00)
    Server Name (32 bytes)
    Unknown (1 byte)
    Server # (1 byte)
    Unknown (1 byte)
    */

/*
    CHANNELS ONLY:
    Size (2 bytes)
    Category (1 byte - 0x33)
    Protocol (1 byte - 0x12)
    # of Channels (1 byte)
    Channel Name (33 bytes)
    Server # (1 byte)
    Channel # (1 byte)
    Unknown (1 byte) - terminator byte (cannot be 0x00)
    Unknown (1 byte) - filler/separator (0x00)
    Channel Name (33 bytes)
    Server # (1 byte)
    Channel # (1 byte)
    Unknown (1 byte) - terminator byte (cannot be 0x00)
    Unknown (1 byte) - filler/separator (0x00)
    Channel Name (33 bytes)
    Server # (1 byte)
    Channel # (1 byte)
    Unknown (1 byte) - terminator byte (cannot be 0x00)
    */

---

---

I implemented this fragment and it works like a charm :):.
Attachment 167146

Quote:

---

Originally Posted by CwaniX

I implemented this fragment and it works like a charm :):.
Attachment 167146

---

Very very nice.
I will upload the english client tomorrow.
Its 95% english appart from quests. But its going to be along time until we can need to think about that.
@CwaniX could you try and help me understand the way you process packets from client and send them back. It seems so different from what I am used to in c#.

Quote:

---

Originally Posted by CwaniX

I implemented this fragment and it works like a charm :):.
Attachment 167146

---

@CwaniX
I'm glad to hear that worked out for you. I will post more information about packets - if I can figure them out, so you can create dynamic packets. I will try and work on newer packets when I get to it. Also, I still haven't been able to use your server because I'm not sure on what to do with the config files. @Alex Mgh mentioned something about loading the folder location in Eclipse through the Debug Configuration under the Spring Boot section. Not sure on what I actually need to do under that menu. Thank you!

- - - Updated - - -

Quote:

---

Originally Posted by Alex Mgh

Very very nice.
I will upload the english client tomorrow.
Its 95% english appart from quests. But its going to be along time until we can need to think about that.
@CwaniX could you try and help me understand the way you process packets from client and send them back. It seems so different from what I am used to in c#.

---

@Alex Mgh

I can't wait to see all of the work you have put into the client. It's nice to have someone doing that. English patches can take a long time unless you find the patches elsewhere. Either way, it's very much appreciated.