[Tutorial] Soul Worker Server + Client Setup Guide

https://i.postimg.cc/fyy6Z2LC/3dgifmaker80964.gif
SoulWorker Server + Client Setup Guide
Revision 3
Author By : Flipend0

Code:

---

Special Thanks to the following members:

- jivori : Release of the server files
- Darnell : Successfully setting up the server, Added comments to configuration, Helpful Advice on MS-SQL, Providing me a test VM to help make the tutorial
- Rulake : Successfully setting up the server, Helpful Advice on MS-SQL
- Prozaks : Repaired tb_Buff.res, Fixed Dipluce horizon and Grasscover Camp, Ported EN translation to JP Client (with help from the SWHQ Translation Team)
- b_ : Query fix for logging in the channel after character creation

---

Introduction
Welcome to the SoulWorker Server + Client Setup Tutorial. In this guide we will learn how to properly setup the server files that was provided
to us. Starting from a Clean Windows installation and ending to a successful client login to play. Due note that this is a very basic guide to setup
the server in a localhost enviroment. If you are expecting to host an actual private server you should know as a server administrator to properly handle
IP and Ports.

Let's begin.

STEP 1 : Required Files

You will need the following files to start.

Windows Server OS 2016 : Get it here!
Microsoft SQL 2017 Developer Edition : Get it here!
SoulWorker Server Files- Repack : Get it here!
SoulWorker DB Files : Get it here!
SoulWorker Client Files- Repack : Get it here!


NOTE: You don't have to do it on a clean windows installation, But it is recommended.
After downloading all the files required. Set up your Server OS 2016 and boot up the machine.

STEP 2 : MS-SQL Installation

https://i.postimg.cc/QxH1NnvZ/Capture.png
After you've installed Windows. Launch the SQL 2017 Developer Installation
Select Custom, and proceed to the next field. SQL will now start installing to your system

https://i.postimg.cc/4N7HRHhJ/Capture4.png
When it's done, you should recieve the Server Installation Center, proceed to click on the very first selection for the Standalone Installation.

https://i.postimg.cc/WztF3hWw/Capture5.png
You will now be presented to the SQL Setup Wizard. Proceed to the next fields as normal until you reach to the Feature Selection field.
In here, you will need to check the box for "Database Engine Service", Proceed to click next until you hit the Database Engine Configuration

https://i.postimg.cc/nr5sQpNb/Capture6.png
In this area, select "Mixed Mode" and click on "Add Current User". Input your password for the Database, Please remember your password as it will be needed
later on in the tutorial.
Proceed to click next and finalize the setup wizard.

https://i.postimg.cc/Qd771KX6/Capture7.png
When the wizard is successfully set up. Find the SQL Configuration Manager and run it.

https://i.postimg.cc/VNcCRsvz/Capture8.png
Search for Protocols for your Server, and highlight the TCP/IP field. Right click on it and Select Properties.

https://i.postimg.cc/3wCDbM0m/Capture9.png
Please ensure that both Enabled and Listen All is set to Yes, Apply.

https://i.postimg.cc/X7mFrk0G/Capture2.png
Now it's time to go back to the Server Installation Center. This time, you must Install the SQL Server Management Tools.
Proceed with the installation as normal. If it tells you to reboot after installation, please do so.

https://i.postimg.cc/Twt5fr9P/Capture10.png
After installation, find the SQL Server Management Tools and run it.

https://i.postimg.cc/yNBDRfpd/Capture11.png
You will be presented to the SQL Server Login.
The server name will be your localhost or IP of choice
the Login ID is usually "sa"
the password is the DB password you set up previously from the Wizard.
Proceed to connect.

https://i.postimg.cc/05HK40jW/Capture12.png
After a successful connection. Head over to the Object Explorer and Right click on Databases. You will need to make new databases.

https://i.postimg.cc/c4pgx1Qf/Capture13.png
Input the following fields for Database Name and click on OK
The names must be inputted each time :

Code:

---

AccountDB
CommonDB
GameDB
GMToolDB
LogDB

---

https://i.postimg.cc/T3nyp89F/Capture14.png
For each database, make a new query.

https://i.postimg.cc/hvHjtM7K/Capture15.png
From the DB folder extracted, you'll find the SQL files.
For each database, open the SQL file with Notepad and Copy-Paste the text to the query window.
Press Execute the query after copy-pasting. Perform this for each Database.

NOTE : Is is normal to see errors in Common, Log, and GameDB.

https://i.postimg.cc/B6ntYj0f/Capture16.png
Last but not least, Execute this query here

Code:

---

EXEC sp_addlinkedserver @Server='LAccountDB',
  @srvproduct=N'',
  @Provider=N'SQLNCLI', 
  @DaTasrc=N'127.0.0.1';

  exec sp_serveroption @Server='LAccountDB' , @optname= 'rpc', @optvalue ='TRUE'
exec sp_serveroption @Server='LAccountDB' , @optname= 'rpc out', @optvalue='TRUE'

---

After this, you are now done with the MS-SQL configuration.


STEP 3 : Server Configuration

https://i.postimg.cc/wBV7Qhnk/Capture17.png
Now you must navigate to your server files. Head over there and find the config file that's located from the config folder, Edit the file

https://i.postimg.cc/NMCFWQs9/Capture18.png
The instructions are provided here. Please read the instructions closely and properly set up your IPs, Ports, Database user ID and Password.

https://i.postimg.cc/RC8qdCp2/Capture19.png
If done successfully, it should look like this.

https://i.postimg.cc/Rh3hm2hP/Capture20.png
Once the config is complete, run sw_server_start.bat
I recommend you take a 15 minute break after running this, it'll take a while for the server to start up...

https://i.postimg.cc/X7CqzMTq/Capture21.png
If done successfully, it should look like this.

NOTE : Is is normal to see missing AI and ActionData files on the GameServer Init.

After this, you are now done with the Server configuration.

STEP 4 : Client Configuration

https://i.postimg.cc/hG4QSTLv/Capture25.png
On your client, there is a file called start_sw.bat.
You may choose to edit the bat file and change the IP and Port if desired to do so
Otherwise, go head and run the bat file, this will start the game client.

https://i.postimg.cc/T3JWMCWB/Capture22.png
The SQL procedure for login is set up to handle Auto-Registration by default.
To perform Auto-Registration, Enter your ID and Pass on the login screen.
Wait for 2 minutes, then proceed to log in again.

https://i.postimg.cc/GpM89tKQ/Capture23.png
If successful, you'll now be at the server select screen.
Currently, there's no way to define the name of the server at the moment. By default it will show the IP instead.
Proceed to log into the server

https://i.postimg.cc/JnvscF9H/Capture24.png
If everything goes well, you should now be able to play Soulworker.
That's about it. I hope this tutorial explains well enough on how to set up the server.
I expect to see some SoulWorker private servers after this, I'll be interested in trying them out


If you have any questions, or would like to proceed further along with the development status of Soulworker
Please head to our discord server at here
Good Luck

Awesome ������

Really well explained tutorial, good work :beer:

Great, we just need to wait for the client now!

Edit: there is no DB in the server files, needs to be downloaded from the other server post!

Thanks a lot for guide.Server works perfectly.

The client link is now included

Awesome guide

Amazing, so organized and easy to understand !
good work sir!

@Flipend0 nice guide good job. :)

Thanks for this guide! Which specs should my root have for a good start?

i select character and got stuck i cant enter the game
server shows this error
https://media.discordapp.net/attachm...551&height=413

Thanks for the great guide !!!
But I still cant get the server to run. There are a few problems exists
1. When I executed the query, it gave me error in CommonDB, GameDB and even the last one, not CommnonDB and LogDB. Is that normal ???
https://i.postimg.cc/2V9km2WX/1.png
https://i.postimg.cc/0zSL3f0S/2.png
https://i.postimg.cc/TyXZXDt4/3.png

2. Gameserver.exe kept giving me a bunch of Missing Resource Load Fail before automatically closed , while the others was totally fine . Is there anyway to fix this ???
https://i.postimg.cc/PL4FsFpC/4.png

runs on Windows 8.

Thanks for the guide! can't wait to see more development for this awesome game!

Revision 3 -

* Added missing SQL files on the downloads section
* Redid some wording on the tutorial.

fixed my issue @Flipend0 add to the main page! if you set a PIN code and the config of server says <USE_SECOND_PW ON="0"/> you lock your character FOREVER and you cannot login with it again

I have this error
how to solve?

estou com este erro
como resolver


https://ibb.co/QcVqcZW

Hello, can the client mirror a copy to Google. It takes me 13 days to download the client.
您好，请问客户端能否镜像一份放到谷歌。我在 下载 客户端需要13天的时间。

Okay so, I followed the instructions, got to the server selection screen, and when I click on it, if freezes just for few seconds and then doesn't do anything else, doesn't go anywhere else but stay in server selection.

someone to help?

alguém pra ajudar?

https://ibb.co/QcVqcZW

you didn't change the res folder the gameserver can't load the resources this is your mistake

Quote:

---

Originally Posted by Neliel Tu

you didn't change the res folder the gameserver can't load the resources this is your mistake

---

thanks

obrigado

Not worthed...to much missing files, to much bugs, also community on discord won't help you at all, even i have shared with them some solutions, helped them ... when you have a question, they just ignore you :) and yeah what to expect, RAGEZONE on Discord server...
To many files missing, databases won't register a ton of informations.
And you can't tell me that i'm not able to set the SQL connectivity...as they said to me on Discord, something meessed up with SQL...
Really? Check out my releases here on ragezone before talking, every single release i made on ragezone has something to do with SQL and server files under SQL.
So if you expect help from them...just don't! :) GL.
Why would you go on discord server to meet another Ragezone :D
F0 started this because he needed guys for him, he got them... :P now he doesn't care to share anymore.
I'm not blaming anyone here, just pure oppinion.
So...not worthed, for more help go to BAIDU.
EDIT: That's my feedback!

Awesome work! Thank you, i have one question. I'ts emulator or server files?

doesn't work on windows 10 pro 64 bit?

Quote:

---

Originally Posted by sasuke

doesn't work on windows 10 pro 64 bit?

---

The client works for x86/x64, agents/servers only x64.

Quote:

---

Originally Posted by S37uP!Update

Not worthed...to much missing files, to much bugs, also community on discord won't help you at all, even i have shared with them some solutions, helped them ... when you have a question, they just ignore you :) and yeah what to expect, RAGEZONE on Discord server...
To many files missing, databases won't register a ton of informations.
And you can't tell me that i'm not able to set the SQL connectivity...as they said to me on Discord, something meessed up with SQL...
Really? Check out my releases here on ragezone before talking, every single release i made on ragezone has something to do with SQL and server files under SQL.
So if you expect help from them...just don't! :) GL.
Why would you go on discord server to meet another Ragezone :D
F0 started this because he needed guys for him, he got them... :P now he doesn't care to share anymore.
I'm not blaming anyone here, just pure oppinion.
So...not worthed, for more help go to BAIDU.
EDIT: That's my feedback!

---

if no one helping you , go ahead and leave the discord , nobody give a shit of what you said, we work hard to understand how they work
also the files leaked with few bugs that right , but your brain is a total failure , also give respect to the hard workers in the discord. i also start to think
what will be happening if @Flipend0 wont write any guides anymore.

also @S37uP!Update after checking your profile page your said you have releases stuff , but after check all the profile data
your nothing then one who need help that all, if you smart at last don't lie .

Quote:

---

Originally Posted by S37uP!Update

Not worthed...to much missing files, to much bugs, also community on discord won't help you at all, even i have shared with them some solutions, helped them ... when you have a question, they just ignore you :) and yeah what to expect, RAGEZONE on Discord server...
To many files missing, databases won't register a ton of informations.
And you can't tell me that i'm not able to set the SQL connectivity...as they said to me on Discord, something meessed up with SQL...
Really? Check out my releases here on ragezone before talking, every single release i made on ragezone has something to do with SQL and server files under SQL.
So if you expect help from them...just don't! :) GL.
Why would you go on discord server to meet another Ragezone :D
F0 started this because he needed guys for him, he got them... :P now he doesn't care to share anymore.
I'm not blaming anyone here, just pure oppinion.
So...not worthed, for more help go to BAIDU.
EDIT: That's my feedback!

---

without him you wouldn't even know what to do with these files lmao

ungrateful af

Quote:

---

Originally Posted by S37uP!Update

Not worthed...to much missing files

---

Please provide the information of these "Missing Files", So far. We only have missing AI files for very end-game content and the Ranking Information appears to be missing
both of these can easily be re-created by hand, and it doesn't seem to be deemed worthy as "to much missing". The game itself is in a playable state.

Quote:

---

to much bugs, also community on discord won't help you at all, even i have shared with them some solutions, helped them ... when you have a question, they just ignore you :) and yeah what to expect, RAGEZONE on Discord server...

---

You had a very unique and rare bug regarding the DB dropping your connection on localhost and on your dedi.
No one was able to help you out because absoutely nobody in the community had ever had that experience.
It's true that you did provide some solutions, (I read all 523 of your messages on discord). However most of these solutions are very common sense solutions to most of the developers in the scene.
Basicly, it was information we already knew, It's fine to pass it down, it just becomes redundant to be used as a statement when everyone else already knows.
Us "not helping you at all" however, is a very false statement, in order to help you, you have to help yourself as well.
Please remember that you are in a MMO Development enviroment where having strong troubleshooting skills is a requirement to survive in this area.

Quote:

---

To many files missing, databases won't register a ton of informations.

---

This is also false, the DB logs everything that you do in the game
For more information, please see LogDB in your SQL Management Tool.

Quote:

---

And you can't tell me that i'm not able to set the SQL connectivity...as they said to me on Discord, something meessed up with SQL...
Really? Check out my releases here on ragezone before talking, every single release i made on ragezone has something to do with SQL and server files under SQL.

---

Again, You had a very unique and rare bug regarding the DB dropping your connection on localhost and on your dedi.
No one was able to help you out because absoutely nobody in the community had ever had that experience.
However, I'm glad that you made releases and that you have SQL Skillsets. Since you've been around for so long
surely, you must've mastered SQL and have a lot of troubleshooting solutions within you, right? I hope so...

Quote:

---

F0 started this because he needed guys for him, he got them... :P

---

Yes. That is correct. I started this new entire dev scene because I actually like the game itself. That's why I am investing my time worth in this game and in the community.
I build discord servers because that is the modern way to build connections within the community. I enjoy talking to other developers in the scene and what they can provide, and what I can provide back to the scene whenever I possibly can.
That's the entire point of being in a MMO Development community. That's why I got so many connections, contributions and respect in the MMOEXTRA scene. Prehaps you should try to do the same.

Quote:

---

now he doesn't care to share anymore.

---

This is false. It appears you have failed to perform actual research on me. I've done (so) (many)(contributions) in multiple dev scenes that include sharing information down.
Including this tutorial I made.

Quote:

---

So...not worthed, for more help go to BAIDU.
EDIT: That's my feedback!

---

Sweet, now here's my feedback.
Your post was extremely disrepectful to the ammount of work this community has done.
That's a huge disappointment, especially since you've been around since 2008.
That is 13 years in service on RZ, you should've already mastered how the MMO dev scene works around here, you should've gotten a lot more connections than I do.
You were supposed to be better than me.
But no, You failed.
You failed to give respect to everyone that worked hard in this community to make this a thing for everyone, including you.
You failed to provide actual contributions and solutions to the scene. Whatever if it's resources, tools, developers, etc. having 13 years of MMO Development, surely you could've provided SOMETHING to Soulworker.
but, I think most importantly you've failed in basic communication skills and empathy in the MMO dev community.
It's people like you that prevents the community from progressing further beyond.
It's people like you that drives contribution developers away from the scene.
It's people like you that causes others to "withhold" information.
and I am not going to allow that behavior and disrepect to happen in the SoulWorker PS Scene.

Quote:

---

Originally Posted by S37uP!Update

Not worthed...to much missing files, to much bugs, also community on discord won't help you at all, even i have shared with them some solutions, helped them ... when you have a question, they just ignore you :) and yeah what to expect, RAGEZONE on Discord server...

---

This is quite disappointing to see.

So that private conversation on discord where I basically ensure that all the configuration was correct was not helping you at all.

On top of that this statement sounds like you're a victim.

I hope that you find the help you need on Baidu, how ungrateful and disrespectful you were here won't help you there. You might want to keep that part to yourself.

At the end of the day nowhere in this tutorial is there guarantees that the server will operate perfectly or that we know everything this is to know about how the server operates.

I got the server running and was able to get in game but not without help, however once I was able to get in, I showed people how I did it LIVE in the discord on a call with a screen share.

Totally the RAGEZONE way right?

The #faq, #downloads, and #support channels written by members "on discord won't help you at all" though, right.

Patches for the game being discussed in a fully public channel for anyone to take and use for their own development is "RAGEZONE on discord server..." though.

I had to make an account just to respond to this nonsense.

P.S. I'm the Darnell in the credits.

i want to mention something else , not all the answers peoples writes are answered by 100% sometime its not been watched we are not Autodesk support, the discord server started to work around and fix the server issues we are all work together here, not happy go to hell.
and take it to your attention there is also real life in side.

Quote:

---

Originally Posted by Neliel Tu

you didn't change the res folder the gameserver can't load the resources this is your mistake

---

what should I do with the Res folder?

Quote:

---

Originally Posted by sasuke

what should I do with the Res folder?

---

the res folder is the game resources where you can changes the gameplay there is tool to edit this files
if i am right, take a look at this tool SWadmin
its can edit the res files

thanks bro

I get this error how do I resolve?XIOCPServer :: Init :: Listen Socket Init Fail.!

Quote:

---

Originally Posted by Neliel Tu

the res folder is the game resources where you can changes the gameplay there is tool to edit this files
if i am right, take a look at this tool SWadmin
its can edit the res files

---

ty for release, which .v files including .res?

Quote:

---

Originally Posted by djbadboys38

ty for release, which .v files including .res?

---

data12.v

which ip to change to run the server on lan?
Sorry for bad English

qual os ip trocar para rodar o servidor em lan?
desculpe pelo inglês ruim

Quote:

---

Originally Posted by sasuke

thanks bro

I get this error how do I resolve?XIOCPServer :: Init :: Listen Socket Init Fail.!

---

about that error , this is happening with the 2 servers on
like if i will open 2 gameserver the last i will open will report that error because the one earlier
already opened and listen to protocol, to the point you cannot open 2 service of one module.
the result will be "XIOCPServer :: Init :: Listen Socket Init Fail.!"

everything is ok but i get this error, any solution?

Attachment 169010

Quote:

---

Originally Posted by djbadboys38

everything is ok but i get this error, any solution?

Attachment 169010

---

I had this error
set the folder path (RES)

https://ibb.co/JBMQGNx


eu tive este erro
configure o caminho da pasta (RES)

Quote:

---

Originally Posted by ubirajara

I had this error
set the folder path (RES)

https://ibb.co/JBMQGNx


eu tive este erro
configure o caminho da pasta (RES)

---

thank you so much, i forgot ^^

Hello everyone, tell me please, I'm trying to start the server, it immediately closes without errors

Quote:

---

Originally Posted by Twiline

Hello everyone, tell me please, I'm trying to start the server, it immediately closes without errors

---

up to your ram min 8 gb

my pc has 4gb of ram and the server works.




o meu pc tem 4gb de memória ram e o server funciona.

Everything solved the problem thanks for the server working!
Everything solved the problem thanks for the server working!

when I import CommonDB and GameDB Queries I get these errors

Quote:

---

Originally Posted by sasuke

when I import CommonDB and GameDB Queries I get these errors

---

this in the tutorial
NOTE : Is is normal to see errors in Common, Log, and GameDB.

when i start the server it gives me tb_Achievement errors

Quote:

---

Originally Posted by sasuke

when i start the server it gives me tb_Achievement errors

---

check your "res" folder dir. in config

Quote:

---

Originally Posted by djbadboys38

check your "res" folder dir. in config

---

what should i check in the RES folder?

wemade_swjp > config
open config.xml
replace this code

Quote:

---

<RESLOAD TYPE="FILE" FILE_PATH="./res" />

---

Quote:

---

Originally Posted by ryruz

wemade_swjp > config
open config.xml
replace this code

---

Is this normal or is there any corrections?

Quote:

---

Originally Posted by sasuke

Is this normal or is there any corrections?

---

ignore, its not error

yes some Ai file are missing.

Quote:

---

Originally Posted by ryruz

yes some Ai file are missing.

---

how do we create an account?

Quote:

---

Originally Posted by sasuke

how do we create an account?

---

Just login, its automatically created

Quote:

---

Originally Posted by djbadboys38

Just login, its automatically created

---

it gives me connection error

now i'm stopped at the server selection but i can't log in

If you're having issues getting past the server selection screen when setting up your own server and it says "public", then you need to change the public IP strings in your config.xml file. Any instances of PUBLIC_IP="public" will need to be changed to reflect how you want to set things up:

1. For a local setup only, change all instances of public to 127.0.0.1.
2. For a LAN setup, change all instances of public to your LAN IP address.
3. For a WAN setup, change all instances of public to your WAN IP address which you can obtain from a site such as https://www.whatismyip.com/. Also note that you will need to properly forward all ports and account for NAT hairpinning as well, which I will not explain here and you will need to learn how to do yourself, as all modems and routers are different.

password for data12.v

Quote:

---

@PDB@?LoadBinaryVersion

---

for pack .res to .v just use that tool.

after edit .res file, make zip with password and with same folders (..\bin\table\*.res)
http://forum.ragezone.com/image/png;...AASUVORK5CYII=
use "Pack data.v archive.bat"

Code:

---

@Echo off
color a
xor.exe data12.zip data12.v 0x55
pause

---

it's work fine

some files are missing in swadmin tool.
can add it here
https://i.imgur.com/s3WrTVP.png

All the tb_* structures has been extracted here
https://gist.github.com/x1nixmzeng/a...ba30d5e647bc4f

like?

thanks for sharing this and let us to be able to play it in our own pcs.

did someone run into problems with the map not showing correctly ? I can't see the minimap correctly.

I was checking the logs from the server and I have the following error:

Quote:

---

[21-02-18 15:42:20] [game.system][INFO] INIT HAN_NETCAFE : OFF
[21-02-18 15:42:20] [game.system][INFO] ==============================================
[21-02-18 15:42:20] [game.system][ERROR] [InitQuestTable] m_mapMainQuestOrder_Char1 size (count:244)
[21-02-18 15:42:20] [game.system][ERROR] [InitQuestTable] m_mapMainQuestOrder_Char2 size (count:215)
[21-02-18 15:42:20] [game.system][ERROR] [InitQuestTable] m_mapMainQuestOrder_Char3 size (count:214)
[21-02-18 15:42:20] [game.system][ERROR] [InitDefaultPhotoItemID] Error TB_PHOTO_ITEM Table - Char_Class [ID:20001]
[21-02-18 15:42:20] [game.system][ERROR] [InitDefaultPhotoItemID] Error TB_PHOTO_ITEM Table - Char_Class [ID:20002]
[21-02-18 15:42:20] [game.system][ERROR] [InitDefaultPhotoItemID] Error TB_PHOTO_ITEM Table - Char_Class [ID:20003]
[21-02-18 15:42:20] [game.system][ERROR] [InitDefaultPhotoItemID] Error TB_PHOTO_ITEM Table - Char_Class [ID:20004]
[21-02-18 15:42:20] [game.system][ERROR] [InitDefaultPhotoItemID] Error TB_PHOTO_ITEM Table - Char_Class [ID:20005]
[21-02-18 15:42:20] [game.system][ERROR] [InitDefaultPhotoItemID] Error TB_PHOTO_ITEM Table - Char_Class [ID:20006]
[21-02-18 15:42:20] [game.system][ERROR] [InitDefaultPhotoItemID] Error TB_PHOTO_ITEM Table - Char_Class [ID:20007]
[21-02-18 15:42:20] [game.system][ERROR] [InitDefaultPhotoItemID] Error TB_PHOTO_ITEM Table - Char_Class [ID:20008]
[21-02-18 15:42:20] [game.system][ERROR] [InitPCAkashic] Error TB_AKASHIC_RECORDS (0)
[21-02-18 15:42:20] [game.system][INFO] [INIT] ResourceMgr - Load Complete!
[21-02-18 15:42:20] [game.system][INFO] [INIT] DBAgent Init
[21-02-18 15:42:21] [game.system][INFO] <ITEM_FACTORY> Factory Init ( 1, 1 )
[21-02-18 15:42:22] [game.system][DEBUG] ProcessWaitUser [T:0] (0/0/0)
[21-02-18 15:42:23] [game.system][DEBUG] ProcessWaitUser [T:32] (0/0/10000)

---

Any idea ? I double checked the location of RES folder, and I got some errors while doing the query into the db (but in the tutorial said it was normal to happen)

Honestly..

It was super easy for me to setup, i was just missing one thing and asked in the discord and got a simple answer, fully understood it and happily carried on my way.

The server works perfectly fine for myself, installed what needed to be installed via this tutorial and rand what needed to be ran.
and ez pz, done and dusted.

It isn't rocket science.

so, +rep

is this error normal?

Quote:

---

Originally Posted by sasuke

is this error normal?

---

I'm experiencing the same issue, and having trouble viewing the map and some colours ingame.

When I run my game, some colors are wrong and some texts are hard to read, and the map isn't appearing correctly (as seen in the screenshots I'm attaching).
Attachment 169143Attachment 169144Attachment 169145
I read all the forum but I couldn't find anyone with my same problem. I started from scratch again and still got the same problem. I make sure my RES folder is in the correct location. My drivers are all updated and I can run the official SW without problem.


The only error I find (that might be related ?) is, when I open my:
ObserveAgent.exe and ManagementAgent.exe
I get the following error:

Code:

---

log4cxx: Could not read configuration file [C:\wemade_swjp/Config/OBSERVEAGENT_LogSetting.properties].
log4cxx: No appender could be found for logger (game.system).
log4cxx: Please initialize the log4cxx system properly.

---

And in ControlServer.exe, RelayServer.exe, LoginServer.exe, and GameServer.exe
I get the following errors:

Code:

---

[21-02-21 14:08:28] [game.system][ERROR] [InitQuestTable] m_mapMainQuestOrder_Char1 size (count:244)
[21-02-21 14:08:28] [game.system][ERROR] [InitQuestTable] m_mapMainQuestOrder_Char2 size (count:215)
[21-02-21 14:08:28] [game.system][ERROR] [InitQuestTable] m_mapMainQuestOrder_Char3 size (count:214)
[21-02-21 14:08:28] [game.system][ERROR] [InitDefaultPhotoItemID] Error TB_PHOTO_ITEM Table - Char_Class [ID:20001]
[21-02-21 14:08:28] [game.system][ERROR] [InitDefaultPhotoItemID] Error TB_PHOTO_ITEM Table - Char_Class [ID:20002]
[21-02-21 14:08:28] [game.system][ERROR] [InitDefaultPhotoItemID] Error TB_PHOTO_ITEM Table - Char_Class [ID:20003]
[21-02-21 14:08:28] [game.system][ERROR] [InitDefaultPhotoItemID] Error TB_PHOTO_ITEM Table - Char_Class [ID:20004]
[21-02-21 14:08:28] [game.system][ERROR] [InitDefaultPhotoItemID] Error TB_PHOTO_ITEM Table - Char_Class [ID:20005]
[21-02-21 14:08:28] [game.system][ERROR] [InitDefaultPhotoItemID] Error TB_PHOTO_ITEM Table - Char_Class [ID:20006]
[21-02-21 14:08:28] [game.system][ERROR] [InitDefaultPhotoItemID] Error TB_PHOTO_ITEM Table - Char_Class [ID:20007]
[21-02-21 14:08:28] [game.system][ERROR] [InitDefaultPhotoItemID] Error TB_PHOTO_ITEM Table - Char_Class [ID:20008]
[21-02-21 14:08:28] [game.system][ERROR] [InitPCAkashic] Error TB_AKASHIC_RECORDS (0)

---

Also (only on GameServer.exe) a lot of entries like those:

Code:

---

[21-02-19 00:16:41] <ERROR> [ \AI\Ai_PC_A_Lv2.lua ] AI »ý¼º ½ÇÆÐ (  F:\_PROGRAM_HG\Source\Soulworker\GameServer\XGameServer\Monster.cpp  2986)
[21-02-19 00:16:41] < 1100002 MONSTER> No Ai Script ( \AI\Ai_PC_A_Lv2.lua ).
[21-02-19 00:16:41] SetupAnimation No ActionData (2:1110001)
[21-02-19 00:16:41] <ERROR> [ \AI\Ai_PC_A_Lv1.lua ] AI »ý¼º ½ÇÆÐ (  F:\_PROGRAM_HG\Source\Soulworker\GameServer\XGameServer\Monster.cpp  2986)
[21-02-19 00:16:41] < 1110001 MONSTER> No Ai Script ( \AI\Ai_PC_A_Lv1.lua ).
...
[21-02-19 00:16:48] <ERROR> [ \AI\Ai_MOB_0518_FlameWraith.lua ] AI  »ý¼º ½ÇÆÐ (  F:\_PROGRAM_HG\Source\Soulworker\GameServer\XGameServer\Monster.cpp  2986)
[21-02-19 00:16:48] < 31804208 MONSTER> No Ai Script ( \AI\Ai_MOB_0518_FlameWraith.lua ).
[21-02-19 00:16:48] SetupAnimation No ActionData (2:31804209)
[21-02-19 00:16:48] <ERROR> [ \AI\Ai_MOB_0534_FlameBanisher.lua ]  AI »ý¼º ½ÇÆÐ (  F:\_PROGRAM_HG\Source\Soulworker\GameServer\XGameServer\Monster.cpp  2986)
[21-02-19 00:16:48] < 31804209 MONSTER> No Ai Script ( \AI\Ai_MOB_0534_FlameBanisher.lua ).
...
[21-02-20 22:20:53] <ERROR> [ \AI\Ai_MOB_0532_GrowlBeast.lua ] AI  »ý¼º ½ÇÆÐ (  F:\_PROGRAM_HG\Source\Soulworker\GameServer\XGameServer\Monster.cpp  2986)
[21-02-20 22:20:53] < 31804406 MONSTER> No Ai Script ( \AI\Ai_MOB_0532_GrowlBeast.lua ).
[21-02-20 22:20:53] SetupAnimation No ActionData (2:31804407)
...
[21-02-21 13:27:06] [ MOB_0525_HackedCondenser.adf ] Missing Resource Load Fail
[21-02-21 13:27:06] [ MOB_0516_Register.adf ] Missing Resource Load Fail
[21-02-21 13:27:06] [ MOB_0535_FanaticsHelper.adf ] Missing Resource Load Fail
[21-02-21 13:27:06] [ MOB_9174_Jeremy.adf ] Missing Resource Load Fail
[21-02-21 13:27:06] [ MOB_0525_HackedCondenser.adf ] Missing Resource Load Fail
[21-02-21 13:27:06] [ MOB_9178_GigaTitan.adf ] Missing Resource Load Fail
[21-02-21 13:27:06] [ MOB_9174_Jeremy.adf ] Missing Resource Load Fail
[21-02-21 13:27:06] [ MOB_0526_FlameTamer.adf ] Missing Resource Load Fail
[21-02-21 13:27:06] [ MOB_0527_MurderHood.adf ] Missing Resource Load Fail
...

---

My gameplay isn't affected at all, is just the graphic problem.

Another question I have is if it's possible and where I could place the translation from Miyumi (https://github.com/Miyuyami/SoulWorkerHQTranslations) within this game.

I tried search in the data folder using the browser but couldn't find way to do it.

Thanks in advance

Quote:

---

Originally Posted by kyastar

I'm experiencing the same issue, and having trouble viewing the map and some colours ingame.

When I run my game, some colors are wrong and some texts are hard to read, and the map isn't appearing correctly (as seen in the screenshots I'm attaching).
Attachment 169143Attachment 169144Attachment 169145
I read all the forum but I couldn't find anyone with my same problem. I started from scratch again and still got the same problem. I make sure my RES folder is in the correct location. My drivers are all updated and I can run the official SW without problem.


The only error I find (that might be related ?) is, when I open my:
ObserveAgent.exe and ManagementAgent.exe
I get the following error:

Code:

---

log4cxx: Could not read configuration file [C:\wemade_swjp/Config/OBSERVEAGENT_LogSetting.properties].
log4cxx: No appender could be found for logger (game.system).
log4cxx: Please initialize the log4cxx system properly.

---

And in ControlServer.exe, RelayServer.exe, LoginServer.exe, and GameServer.exe
I get the following errors:

My gameplay isn't affected at all, is just the graphic problem.

Another question I have is if it's possible and where I could place the translation from Miyumi (https://github.com/Miyuyami/SoulWorkerHQTranslations) within this game.

I tried search in the data folder using the browser but couldn't find way to do it.

Thanks in advance

---

You need to change the Decimal Symbol from , "comma" to ."dot"

- - - Updated - - -

Quote:

---

Originally Posted by sasuke

is this error normal?

---

Yes this is normal sasuke, anyway...do you create SW server now? :D Not to much success with Cabal? :D It's hard on cabal or what?

Quote:

---

Originally Posted by S37uP!Update

You need to change the Decimal Symbol from , "comma" to ."dot"

- - - Updated - - -



Yes this is normal sasuke, anyway...do you create SW server now? :D Not to much success with Cabal? :D It's hard on cabal or what?

---

Thanks a lot! that made it all work, even got some more japanese text translated into english, was really helpfull!

Quote:

---

Originally Posted by S37uP!Update

You need to change the Decimal Symbol from , "comma" to ."dot"

- - - Updated - - -



Yes this is normal sasuke, anyway...do you create SW server now? :D Not to much success with Cabal? :D It's hard on cabal or what?

---

cabal already did and everything ok

how can I remove the 2nd password check ? I tried comment that line in the config file

Code:

---

<!--USE_SECOND_PW ON="0"/-->

---

but nothing changed, I also tried play with the values from the AccountDB > TB_ACCOUNT
but no advances either, any idea ?

Hello Sir/Ma’am,This is an official notice from Lex Protector LLP, on behalf of our client Lion Games Co. Ltd in its Intellectual Property matters.Our client owns and retains all rights of his copyrighted work. It has recently come to our attention that the website hosted by you i.e. http://forum.ragezone.com, has copied the work titled “soulworker” from our client’s website and posted at their website. The infringer has neither requested nor received permission from our client to use the protected work in any way.Our client never authorized you to copy his copyrighted work. The application is our client’s intellectual property and as such, it is an extremely valuable asset of their business. Accordingly, our client has instructed us to take appropriate steps to protect their business interest.For your reference, we have attached the copyright certificate and the URL of the infringing website.Copyright violation:1. http://forum.ragezone.com/f858/tutorial-soulworker-server-client-setup-1193551/Identification of Copyrighted Work:Our client has complained that the infringer has copied the work titled “soulworker” from our client’s website and posted at their website, without any authorization. Our client has exclusive ownership over the work and has not authorised anyone to copy it. We strongly oppose your act of using such Copyrighted Work.This Letter is an official notification under Section 512© of Digital Millennium Copyright Act (DMCA) and we request that you immediately notify the infringer of this notice and inform them of their duty to remove the infringing material immediately and notify them to cease any further/him posting of infringing material to your server in the future.We are providing this notice in good faith and with reasonable belief that the rights of my client are being infringed. Under penalty of perjury, we certify that the information contained in the notification is both true and accurate, and we have the authority to act on behalf of the owner of the copyright(s) involved.Please take necessary steps to remove the content by 24-48 hour of receipt of this e-mail.We are looking forward to the best support from your end and thanks in advance.Sincerely
Aurobinda PandaAttorney at Law##############

In 7 days this thread will be switched over :)

If you wish to do so immediately. You may proceed to
If possible, also remove any of my posts related to "Soulworker"

Thank you sir.
And how can I to change the language to chinese,sorry!My english not well.

Hi, firstly thanks for sharing the files.

I have a problem which I can't get past.

I'm getting the error
<03/10 07:00:47>:Try Connect :
<03/10 07:00:47>:Connect Error:()
<03/10 07:00:47>:[SQL_HANDLE_DBC] 08003 0 [Microsoft][ODBC Driver Manager] Connection not open
<03/10 07:00:47>:[SQL_HANDLE_DBC] 08003 0 [Microsoft][ODBC Driver Manager] Connection not open

I deleted everything and started over but I still get this error ...

anyone willing to help me out please?

Thanks in advance

Failed to load table tb_achievement

it shows from loginserver, gameserver, relayserver, controlserver.

idk why it happened. help

https://postfiles.pstatic.net/MjAyMT....png?type=w773

https://postfiles.pstatic.net/MjAyMT....png?type=w773

https://postfiles.pstatic.net/MjAyMT....png?type=w773

SLOVED!


error "failed loading table file. (tb_Achievement) " appear on starting client. what may causes this error? bro..help me.

- - - Updated - - -

Quote:

---

Originally Posted by Nyamochka

password for data12.v



for pack .res to .v just use that tool.

after edit .res file, make zip with password and with same folders (..\bin\table\*.res)
http://forum.ragezone.com/image/png;...AASUVORK5CYII=
use "Pack data.v archive.bat"

Code:

---

@Echo off
color a
xor.exe data12.zip data12.v 0x55
pause

---

it's work fine

---

when edit and save .res file(such as tb_UI_String.res, tb_speech_string.res ... etc ) with SWAdmin, then replace into data12.zip and repack data12.zip to data12.v with xor, error "failed loading table file. (tb_Achievement) " appear on starting client. what may causes this error? bro..help me.

How to fix this sir ?
https://i.ibb.co/PgPgwSp/Untitled.png

Quote:

---

Originally Posted by vo6tu7

How to fix this sir ?
https://i.ibb.co/PgPgwSp/Untitled.png

---

sqlserver must install and run, and no need ODBC, check you file "sever/config/config.xml".

how to translate the non english tips/quest objectives and so on? thanks.

@Flipend0

Many thanks for this really good Tutorial. I set it up with no Problems after first try. Only difference is that i used "SQL Server 2008 R2 (Developer) @ Windows 7 64-Bit Ultimate".

I found out how to add "Cash" for using in the Fashion etc Shop (pressing "C" InGame).

1. Database > AccountDB > TB_ACCOUNT (Table)
2. ACCOUNT_ID <-> CASH

My little Daughter can now finally buy much Clothes :-)

Good guide, thanks

Hello, I want to know how to open and view all res format files, and want to change the experience rate and equipment attributes.Ordinary database cannot view all information in res format

-05-05 19:54:15] [game.contents][ERROR] <GAME> Failed loading table file.(tb_Achievement) anyone know how to fix this? i dont have the script. thanks.
AND HOW TO TRANSLATE THE GAME TO ENGLISH.TNX

Quote:

---

Originally Posted by xqh0728

sqlserver must install and run, and no need ODBC, check you file "sever/config/config.xml".

---

CHANGE the server folder without space like "SoulWorkerServerfiles" then inside the wemade_swjp file. just copy the directory for res

Quote:

---

Originally Posted by Men In White

AND HOW TO TRANSLATE THE GAME TO ENGLISH.TNX

---

join discord in first page and search

I am getting these errors:

GameServer.exe:
[game.contents][ERROR] CheckRankingRewardTable error - Not FindLastReward <ID:210705101>

ControlServer.exe:
[game.contents][DEBUG] <LOGIN> eSUB_CMD_SERVER_CREATE_MAZE_REQ : 1000 / 2111301 / 2111301

LoginServer.exe:
[game.relay][ERROR] <MAZE> Recv from failed server < 0 / 3 >

If someone can help i will appreciate it!

[ERROR] [DB_SOCKET] OnNotConnect ( 2 ) !!
[ERROR] [DB_SOCKET] OnNotConnect ( 0 ) !!
[ERROR] [DB_SOCKET] OnNotConnect ( 3 ) !!
[ERROR] [DB_SOCKET] OnNotConnect ( 1 ) !!

Happens on LoginServer and AuthServer. All others run fine.

IPs are set correctly to internal Network addresses (192.168.x.x) and private to 127.0.0.1

I need the start_sw.bat. from the client could you share it with me

Quote:

---

Originally Posted by itacho

I need the start_sw.bat. from the client could you share it with me

---

open notepad. paste this text below:
@Echo off
start SoulWorker100.exe IP:127.0.0.1 PORT:10000 MultiExecuteClient:yes SkipWMModule:yes

and save the file as .bat and u good to go.

hi i found this tutorial and i think i di all the steps right but the client wont launch

this pops you in log history WARNING: SetDataDirectory('E:\wemade_swjp\SoulWorker\datas\data00.v') failed!

update: i have no clue what im doing i tried opening it in Vdata Explorer and i got Failed to open the files as VFile : Found invalid data while decoding.

i have the same issue and i also checked the config and i can t really know why is it happening

https://i.imgur.com/6Zhn5BD.jpeg
https://i.imgur.com/mqkIUAk.jpg
https://i.imgur.com/TCpyupi.jpg
https://i.imgur.com/PavmzDo.jpg


works great!

https://forum.ragezone.com/image/png...BJRU5ErkJggg==


https://forum.ragezone.com/image/png...BJRU5ErkJggg==


i cant start game . how to fix

how to translate language
how to change rate drop ex item drop rate exp rate

thank you sir for this tutorial

Thank you very much for this tutorial. It is great.
May I ask one question about my GameServer.exe ?
I got issue that I can't get pass through play game after selected the character.
I noticed that my GameServer stuck, it did not look like the final game server window that you have shown.
Yours is listening, but mine was stuck.

Please help to suggest. Thank you very much.

https://i.postimg.cc/CKpc2fY6/Screen...3-34-24-PM.png
https://i.postimg.cc/CKpc2fY6/Screen...3-34-24-PM.png

Quote:

---

Originally Posted by Milon Ce

Thank you very much for this tutorial. It is great.
May I ask one question about my GameServer.exe ?
I got issue that I can't get pass through play game after selected the character.
I noticed that my GameServer stuck, it did not look like the final game server window that you have shown.
Yours is listening, but mine was stuck.

Please help to suggest. Thank you very much.

https://i.postimg.cc/CKpc2fY6/Screen...3-34-24-PM.png
https://i.postimg.cc/CKpc2fY6/Screen...3-34-24-PM.png

---

On Discord I posted a patched server a few months ago, maybe I'll create an updated tutorial soonTM.
https://i.imgur.com/qgeie4n.png

https://cdn.discordapp.com/attachmen...patched_72.exe

Greetings

@Rulake,

Thank you very very much.

Thanks release. :thumbup:
The server's memory is being used much. :/::$:

*
[game.contents][ERROR] <GAME> Failed loading table file.(tb_Achievement) <- in controlserver and next servers.

[22-02-06 21:12:36] [game.system][ERROR] [SYSTEM] Failed Load Common Table DB !! ( Driver={SQL Server};Server=127.0.0.1,1433;Database=CommonDB;Uid=sa;Pwd=****; ) <- in GameServer

This error pops up. is this normal?

Quote:

---

ah i found it
<RESLOAD TYPE="FILE" FILE_PATH="[Server Path]/res" />

Need to fix this.

---

Quote:

---

The server is using about 10G of memory...
If you do not set up virtual memory, it is difficult to start the server and run the client.
Hmm, seems to work fine on a computer with a lot of memory.(About 16G)
Currently eating close to 8G of memory, and after a few minutes it drops by half.

For reference, I use Windows 10 Home. (not a Windows server. Windows Server is hard to pay for...T_T )
Virtual memory set on SSD.

---

Quote:

---

Works fine, but doesn't go beyond server selection.



* Solved. edit PUBLIC_IP to my ip.

---

May I ask ?

How to use GM tool ?

Thank you very much.

The GM commands I found, only :

/levelup xx
/gold x xx (x=0,1,2,3) (xx=amount)
/item x xxxx x (x=type) (xxxx=id [res file]) (x=amount)

These are the only commands I found. (Another one is /warp)

Can I ask questions ?

Is there any other GM commands ?

Thank you very much.