Neosteam Server (Chinese, but with English Weapons)

[Brezelpeter]

Nop, that did not work here the result: of the Npc ID 4541: ""퇺㋬쏶᭱ꑱ，㸒骠豉叫⛥�喝ᅈ죣胹㉘刦⋓籅伴ꁢ䱿輺▔▬�賳肨掰��""

i believe one of the problems is, that there has to be a divider char included to divide the button text, the npc text and the single steps of the dialog... so if i convert the binary without knowing them, maybe they interfere..

I will try a couple of different ways to convert the binary´s, maybe i get lucky.

As for the changing Binary you get if you let the server convert the text a couple of times, that could mean that in the binary´s is some sort of timestamp included (by design from the developer), or since he fails to convert it currently, that he puts a timestamp in the corrupt data.

 

[Aknolo]

true that could also be the reason for the different binary output..try finding someway to convert the binary specifying it was converted with UTF-8
if it was Ascii or unicode the Sql Convert should have work right?
guess we need someone to try looking into the script that converts the NpcScriptParams to NpcDataparams got to be something there messing it up since it converting and everything but gives a error about a missing prefix

 

[Brezelpeter]

i can convert it from any char set to another, the question is which combination and what method to use...

Npc ID 4541:
With the Method i created: "𣏕䏦焛熤೿ሾꂚ䦌꧙磺䠑呂堲팢䕼㑏抠罌㪏鐥갥瓟觲ꢀ끣ן�"
Encoding.BigEndianUnicode: "へ䙁䐱䕃㌲䘶䌳㐳䔶㜱ㅂ㜱䄴ぃ䙆ㄲ㍅䄰㥁㐹㡃䕂㔳䔵㈶䄹䐹㜸䙁㐸ㄱ䔳䌸䘹㠰㔸㌲㈶㔲䐳㈲㐵㝃㌴㑆㘲䄰㝆㑃㍁㡆㤴㈵䅃㈵㜴䑆㠹䘲䘳㡃䄸㠰䈰㘳〵䑆䔷"

In both cases i specified that the source is UTF-8 and the Target is Unicode (ucs-2)

 

[Aknolo]

try this one its NpcID 4542 he has 2 steps with text one containing ^(Smile) command making him laugh ingame when clicking on him and next text should be End Conversation
0xB4C55AA4337B201021DDE8B785CB98BEAD723BD4F1F7118B0B903E6153586D80D9C82DE78EE1937952BD2E829D447DFB4B93F1A774F5DD8C844B239BBCAEF0884DDFD07F7659D4395D5D4181DC97E735EE4FD01E640727A303F7FDBE72D9CC8FF7D4468E1D29A1E55AD436BF33DF97144C6C13110800BB739131BD

if you manage to get the ^( somewhere in the text its should convert at intended

 

[Brezelpeter]

.. no, just got useless chinese again (and a lot of it). Maybe the data in NpcData is more then just converted into binary... maybe they shrinked it or compressed it somehow...

just annoying... there are so much possibility´s and all i do is the trial and error method.

The other thing is, why does the server fails to convert it himself if you use the original chinese data in the npcscriptparams. Since it should be the source of the used binary´s in the npcdata, there shouldn't be a problem with the data types. Any Ideas what that could mean?

 

[Aknolo]

must be something wrong with the conversion cant think of anything else
the NpcScriptParams is not the original since in the 800x folder if you peek inside the .exe there you find that the table row i named Script but in the DB its named Script_CN.
we need someone to reverse engineering the NSGameServer_CN_r.exe and see why its giving the error

 

[fallout]

Delete

 

[Brezelpeter]

*update*

still working with a couple of people on a solution... but unfortunately we havent figured out how to translate the Npc Dialogs jet.

If someone wants to give us a helping hand, we would really appreciate that

Here are the dialogs from one Npc. The Hex value represents the 14 steps, probably some sort of divider char and some button text. If we figure out how the Hex value is created, we can translate the last peace of the DB.

the Steps
Step 0, ^[$^[A[" .. userAlias .. "]^[$^(REQUE) 什么事？
Step 1, ^(HELLO)欢迎光临！哦~你在做技师转职啊。
Step 2, 这么说你是从倔强暴躁的伊格雷那里，接受了任务啊。哈哈，你有什么需要吗?
Step 3, 新蒸汽螺栓
Step 4, 商店
Step 5, 结束对话
Step 6, ^(HELLO)欢迎光临，这里是饰品商店，请随便看吧.
Step 7, ^(QCOMP)正好我有新蒸汽螺栓。
Step 8, 给你. 还有请告诉伊格雷，我以后会去跟他要他欠的钱的.
Step 9, 知道了
Step 10, 结束对话
Step 11, 那么新蒸汽充填机的维修就拜托了.
Step 12, 对了！出故障的新蒸汽充填机在此广场的上部。
Step 13, 包以满，无法给你新蒸汽螺栓。
Step 14, 结束对话

The Hex representing the complete Dialogs
0xB1CB01DBFE03C7EEA9FBF5F660A4FD2FD07E2629F7ABD00CBAC1CC3E60C7F315170AE16046A207AC08985E4FFB841F82D6CD682124BC4BD7E8DD6E0527D1EB925F251D09DEDEFB29264D5B347F53E22429F7661B5293709FB419E7E83E4D82DEB37ABAE1B3346AC1E7699BE9334BF1D5149CE69E478D836758B4BDC687AB7838D0A3FA3E821BB35839B718BD9336863F97BC390019F80CA2DDBB3233FD3D56B7DF6E0DACDD8E5AFAFEF4195D096268B61FAA18ACFE42EDB6727E4322041A861ACB729B38F04A20B578BB5112B9E1F2B03972414FB44CC868309A8A2B2A987495F69E78D0F0F231BAAB2F41CA474A230F95547E851A4CD4BF9F28729179F1D54BB331F600255DCA0611277894E20BE05A6D625C917BF7E77A1A94CFD0B95431EADC32F3431243DD7B2B905812F6F5E47F96DA9B558751F535D5486965EAE137AB7AEFDA7660B5D5E7F50C4954148F13DD841621CFC4D5C01A01735208E28FD169AC1AFCFA1A294858F45EC8F1E327B696ECFAE4C7640C4E77188740CA737A9923154F68F40A31AF54159D6BED6FDD55C5F3F868CA57B214E0B84BB472F3CFACF9911B50DF7D0A23ADEE92D58943B8AB7501F7A1AF689FD315E8778AE1AD2C6D314C1BF90187E95268914484A8CCB625E722EE4E

@fallout: why the reupload of the server files?

 

[Aknolo]

Npc ID 4541 type this to warp to the Npc /debug warp 06330, 26562

Step 0, 有新鲜的水果~

Hex:
0xFAD1EC32F6C343E6711B71A40CFF123EA09A498CEB53E526A9D978FA4811E3C8F9
8058322652D322457C344F62A07F4C3A8F9425AC2574DF89F2F38CA880B06305DFE7

This npc just have 1 step with text might help, iam also stuck with the same problem as Brezelpeter


Note this Npc will whisper "有新鲜的水果~" no text box will appear with end conversation box or anything.

Others like the npc Brezelpeter posted will most likley have delays between text lines like most npc have in this DB

 

[TheMachine2k]

Hey,
Brezelpeter asked me to help him out with the NpcDataParams stuff.
The hex strings in this table are not simply encoded with some charset, instead they are encrypted.
I wrote some small proof of concept code (see attachment) in Java to decrypt/encrypt those strings.
Hope that helps to translate most parts of the NPC dialogs. The data in NpcScriptParams doesn't need to be translated when you translate the NpcDataParams table directly.
So just:
1. Decrypt the entries of the NpcDataParams
2. Translate
3. Reencrypt
And you should be fine ...

Example:
This
FAD1EC32F6C343E6711B71A40CFF123EA09A498CEB53E526A9D978FA4811E3C8F98058322652D322457C344F62A07F4C3A8F9425AC2574DF89F2F38CA880B06305DFE7
results in
--????-?? ??-???

function Hello()
MSG("ÓÐÐÂÏʵÄË®¹û~")
end

The "--??....." is a comment (they always start with "--"). It looks like the comments were written in Korean but were not encrypted properly, because all comments I've found were broken and not readable, but all important data was. Maybe the text of these scripts was saved in that way to preserve the Chinese texts, which broke the Korean ones.

Good luck with translating all the NPC data ... over and out.

 

[andy2014]

Thanks im an oldtime ragezone member cant remeber my login, 987655 (aka andy1971) ill take a look at the files and insert some new life if i can, neosteam was a great game, good to see its now on RZ

I should be able to try and recall alot of the NPC dialogue, wouldnt mind getting this up and running as a private server

Ive just grabbed the newer client and newer database that was uploaded a few posts back, if any of yous would like me to join your dev group mail me andrewhoney@zoho.com and we can discuss some more, and jump on skype. Will try and get hold of some old buddies who are good with SQL etc from our old Knight Online server dev team.

 

[Brezelpeter]

Hi,

We still have a small issue (codepage thing) with the translation of the npcdialog, i can decode the hex, change values and recode the thing, so i think i can solve the remaining issue in the next couple of days. Thx to "TheMachine2k" again who did the heavy lifting on that front.

Right now we are translating nearly everything from "Google English" to German, that will take some time but we have a couple of people who are working on it.

Other then the NpcDialog issue we have encountered a couple of problems that need to be fixed.

1. DateTime Issue
The Server wants to write every couple of Minutes into the Table "ServerStatLog", but encounters a problem with the DateTime Format. He try´s to do this "cast (2014/04/20 12:42.000, DateTime)" which cant work (cant convert vchar into datetime). The SQL Statement and the Function to get the datetime is in the server exe, so we cant do much about it. I tried to change my Systemdate but didn't get too far... It seems that there is a similar issue with the ConnMainLog...

2. Billing Database
If you open the Premium Shop the Server writes a Information that he cant find the server "Billing" and that we should run the "sp_addlinkedserver" procedure, but i wasn´t able to do that so far. Did someone encounter that problem?

3. Skill Mapping
Some Skill seem to be out of order. The Skill Elf Shield (206) should not give you the Buff "Berserker" (701). We tried to figure out on how the Skill Mapping works but didnt get mutch results yet.

The rest is looking good .

FYI: we are also looking into the Texture´s, because they nearly scream "mod me" if someone know´s someone who wants to do that, that would be shiny .

 

[Aknolo]

Hi everyone!
Is this legit have anyone tried to translate a npc text and get the server to load it ingame? If this works hats off for TheMachine2k!!
been trying everything i could think of to get the server to load the Npc text with no progress and just a huge headache.


Brezelpeter so your making a german server?

 

[Brezelpeter]

Hi, yes we are making a German Server. I tested the programm and i am able to translate the Dialog and put them in the Server (yes it works and it is in the game visible). The issue i am working on is that he has a Problem if the translated text is longer then the original Text.... but i think i can resolve that issue.

 

[Aknolo]

Oh well id love a English one lucky Germans ^^..
Ive tried the Uploaded java file managed to run it and get the text contained in the Hex string but how do i reencrypt it back when i have edited the text from chinese to english?

 

[rinkoon]

Hello
Nice to see some progress.

Big thanks to TheMachine2k for Your work.
Based on it, I've prepared some small tool:

You must be registered to see links

. Please test it and tell me if it's useful.

I think, we can even make our own quest, when we learn enough about NPC quest script.

Brezelpeter: Are You sure You want to make German speaking server and not common English one?

 

[Brezelpeter]

Yea we have a small community and they want German text... but i hope we can work together on the server to solve the remaining issues...

 

[andy2014]

Yea we have a small community and they want German text... but i hope we can work together on the server to solve the remaining issues...

i wouldnt mind making an english one, or helping with the german one.
but i would prefer an english.

 

[Aknolo]

I have started to translated Diren to google english to be polished later on got someone to setup a server when theres alot less chinese text all over the place.. Anyone got a good tip on how we can share the progress so we aren't translating the same thing instead we can take a Town each. i you wanna google translate or polish the text is up to you any translation is alot easier to track and polish afterwords

 

[Brezelpeter]

We Fixed the Minimap issue... here are the files

View attachment Maps.zip