[RELEASE] Soul of Ultimate Nation Emulator, Server Files, GM-Tools & More!

hello people have a problem set and scan everything as it comes in the DB Setup guide but when I start the game I get this error[IMG]http://thumbs.subefotos.com/fc34fa05...2a935b6b5o.jpg[/IMG]

Quote:

---

Originally Posted by Franco Derlis

hello people have a problem set and scan everything as it comes in the DB Setup guide but when I start the game I get this error[IMG]http://thumbs.subefotos.com/fc34fa05...2a935b6b5o.jpg[/IMG]

---

Try to turn-off your antivirus and firewall. I hope it help you cuz in error windows i see some words about firewall .

@Franco Derlis

What you are experiencing is a client connection issue. This issue is too generic, so can you provide more information?

• Are you receiving any server-side response errors?
• Did you check the .bat file inside the client folder for correct IP and Port?
• Did you change anything on the database or server end (IP/Port wise)?

@BloodForce

The reason why I crossed out the client is because sometimes the client doesn't always fix that error you were receiving. I edited my previous post and left the client as an option. Now, I have some sad news to give you regarding translations and maps, so here it goes:

• I haven't been able to successfully update the maps. So at the moment there is no way to update the maps.
• I haven't been able to successfully update the client to read in English. There is a way to do it but I'm struggling with it. If you are interested in translating, please let me know.

I will download again the client to download it first page 5 and if not that I will review your recommendations ... once happened to me the same but with lineage 2 and fix it by replacing the system file server and data client server game

Quote:

---

Originally Posted by Franco Derlis

I will download again the client to download it first page 5 and if not that I will review your recommendations ... once happened to me the same but with lineage 2 and fix it by replacing the system file server and data client server game

---

do not know if this is the problem, and if it's like I can change the ip client? look ^^

http://thumbs.subefotos.com/beab2af4...ad20dcc5fo.jpg

@Franco Derlis

Right click that file and click edit. Change the IP to "127.0.0.1" and leave the port to "44405". That should fix your connection issue.

and I could fix the problem ... SunRun right click edit and change the ip ip server ...>. <

@Franco Derlis

Did that fix your issue?

and I ran to edit the file, but the most I can do in the game is the amount of money turn editing the sql not know how to get pjtas city xD

@Franco Derlis

Pjtas City? I haven't found a way to get more maps loaded into the server.

the problem is not the number of cities.bugg is with teleportation between cities

- - - Updated - - -

the problem is not the number of cities.bugg is with teleportation between cities

@Franco Derlis

Like I said before, I haven't been able to find a way to update the maps, so you are stuck with Tringle and Zapir Lake at the moment.

I have done everything I can at the moment to fix these SUN Server Files except update the maps which I'm still working on.

Here is a list of things that need to be addressed when rebuilding the SUN Server for EP1:

1) Queries need to be updated in the Server.

• Database stored procedures cannot be updated because the server queries do not match.
  
• Server queries can only read T_Friend (Friendslist), T_GuildMain (Main Guild info w/ Guild Master), T_Warehouse (Account Storage), T_Character, T_User (Accounts), and some other minor tables.
  
• The following tables with their stored procedures attached cannot perform correctly:

T_GuildMain (doesn't update T_Character therefore guild doesn't attach to the character),

T_Warehouse (doesn't access the account storage),

T_Character (doesn't transfer character data to T_CharacterDelete and actually delete the entry from T_Character),

T_Friend (doesn't add the character when inputting a name), and
T_User (cannot read any changes to account creation).

2) Update Server to give more detailed errors.

• This can be achieved through listing the errors in the window as it already does or producing a text file as logs (like what some of the newer files do).

Other suggestions or things to consider:

1) Temple of Blood may need to be added.

• Not sure yet since I'm still working on the maps.

2) Add in EP2 Characters.

• If you want to convert the Server Files to EP2.

Also, some of query issues can be taken care of through a website or 3rd party programs such as launchers (creating encrypted accounts, deleting characters, and maybe creating guilds). Please keep in mind this is a list of the problems I have come across, if you find a way to fix some of these problems without receiving any errors, please let me know. Thank you.

Here is a list of things I have fixed and still working on in the database. Please keep in mind that I am still working on the database and will not be releasing it until I finish.

Working On:

• ​Warehouse (Access)
• Password Reset
• GM Account (Creation, Update, Delete)
• Server Info (Connecting tables and fixing data)

Finished:

• Guild (Creation, Add/Remove Member, Deletion, and Change Rank)
• Character Deletion
• Account Creation (new security features)
• Friendlist (Add, Remove, and Block)

This list will update periodically in the future so please check back later for new updates. If you noticed any issues with the database please message me or leave a post on this thread. Thank you.

Sadly, the new database doesn't work with the current server files, so I am going to see if I can rebuild the server with a friend. Maybe in the future a new release of the server will show up on RageZone. If anyone has any questions, please contact me here on RageZone through a private message.

has anyone working files ??:sleep:

@alladyn5

These files work but there is some issues with them. Most of the problems in game has to do with the database. The Stored procedures are not working properly on the database end. You cannot alter the procedures unless you update the server's query commands. If you have any questions, let me know.

Give link to working server files, database and client.

@alladyn5
The files provided on page 5 and 6 all work. Let me know if the link(s) stop working or you need help. As mentioned before, these files are incomplete and have issues such as maps not loading in, Temple of blood, GM rights, and so much more. Although the base game works, such as loading in characters, wearing armors and etc. Skills are still buggy and I'm not sure what is actually causing that.

Where did you get the files?

@marelegg

I obtained these files from the first page of this post. Some of the links on the first page may not work anymore, which is why I uploaded them again but on mega.

Quote:

---

Originally Posted by Ashime

@marelegg

I obtained these files from the first page of this post. Some of the links on the first page may not work anymore, which is why I uploaded them again but on mega.

- - - Updated - - -



Thank you for the lovely advertising. Should of posted that in a more appropriate section, but thats my opinion.

---

For sure this are not the files from the first post,are not the complete files....like in the posted video and doesnt work with this client

At no stage did Ashime say that the files were complete. She even states that it is an EP1 SERVER! Maybe open your eyes and READ the posts. The posted video is from the LATEST server...as she CLEARLY STATES. If you can do better than Ashime has with these files, then POST THEM, or stop running your big mouth.

@Macgyver70 calm down i didnt acused him lol... you make me laught ...i just asked for files and i saw the files are episode 1 yeah thats why i didnt understand how he got the latest version...with work for sure he got the latest version i know....

PEACE!

@marelegg
These files are the same files from page one. I did not replace or alter the files except for a few minor things, such as removing the built-in MS SQL 2000, and possibly changing the client for another EP 1 client (I can't remember if I did). Other than that it's all the same. These files were never complete to begin with. In fact any SUN server files posted on Ragezone for the most part are not complete. I would have to say these are more complete compared to some other file I have seen. If you have any questions, ask on here or send me a private message.

@Macgyver70
Relax. Honestly there is nothing wrong with questioning the source of the files. I have no problem with what marelegg asked. Thank you for trying to clarify things.

- - - Updated - - -

For anyone who is interested in knowing, I am currently working on the source code for basically building a new set of server files, but it's a rather slow process since I am working on it by myself. The files I am working on are the same source code I posted but altered (so they are EP1 source code/server files). I haven't built anything that works yet.

The currently working EP1 server could possibly be worked out to where everything works, but I can't tell you how to fix everything. If you are curious about what is wrong with the current server files, please go start on page 5 and work your way from there. I have posted a lot of things wrong with this set of server files. If you would like my help on finishing this or answering some questions, please let me know.

As of right now, I can't work on the source code and trying to fix the pre-existing server files. I do know the maps work for the pre-existing files but I can't remember how I did it and there was a conflicting issue at some point. Although, I will come back to them and possibly fix the maps, only if I get more time to do so.

Also, I'm in the process of moving all of my files from Mega to something else since Mega is now data capping your downloads. I will update all of my links once I get that all finished.

I apologise if I came across a little terse, I had just come from a Unity forum where it appears that not one person knows how to use the back button, so you end up fielding the same questions over and over...then I drop over here and the first post I see is asking questions already answered previously.....cue throbbing vein in head....lol.
The question needs to be asked as to whether it is worth pursuing this version any further. I have put a couple of non fruitful years into trying to make a working EP2 server, as I know has Ashime.
Now there is a working 1602 server out there...And functionally it is miles different than the Ep1 stuff we are currently working with.
Should our efforts not be better spent on decoding the new server functions? Learning the new opcodes, and where they fit in.
Ep1 is not gonna cut it these days. Ppl want their E3's or E4's...

@Macgyver70

Truthfully, this pre-existing server files can be tweaked to work but its a pain. Anyone who can is better off taking the source code from here, get rid of all of the errors and warning, use these server files and the ones you make to pick up an run time errors since they are the same code, and then work on upgrading your error free server files. Atm that is what Im working on, but it takes a while. Someone else and I have two of the four servers currently warning and error free. Only problem is, we havent tested them during runtime so I have no idea whether its going to work or not.

As for EP1 and EP2, it depends on who you talk to because ive heard mixed things about both episodes and truthfully each episode has their strengths and weaknesses. EP1 is easier to get atm because of how the current server code is setup. If you decide to do EP2...you have A LOT of updating in the code to do.

Well, exactly. Just figuring out the item awakening and evolution, then there's the bingo, the new BZ setup....a LOT of changes need to be made, but at the moment we have no idea of the opcodes for any of it. Even the latest code we have is before they made that change.

I was a big fan of this game in the past, and love the dedication, keep it up!

I think I'll just end up paying the 10k to buy a legit server. Considering that my ONLY competition would be SunBest, who now expects his customers to pay for their gears for a THIRD time.....scam much?
I love this game, but in the time we have been fucking round with this server, we could have WRITTEN our own game in the same style.
THAT is where my efforts will be focused. Not floggin any dead horses any more.

@The_Gatekeeper_
Yeah, I am a big fan of SUN as well, but not so much of EP2.

@Macgyver70
Writing your own game is the way to go. I personally dont have enough experience to write my own game atm, but SUN's source code is just good practice for me as I continue to learn.

On the other hand, I'm going to try and finish the source code I have by pulling certain code off of other incomplete source code. I will let everyone know how that goes. Honestly, I'm going to make a whole new post towards the development of what I have when I can. I'm officially going to stop working on these pre-existing files for sure. I will release everything I have including stuff I didnt quite finish. Private message me if you need anything.

Soul of the Ultimate Nation Online
Server Files, Source, Database, Client(s), & Tools

Tables of Contents

Spoiler:

I. Information
a. General
b. Credits

II. S.U.N Files
a. Server
b. Database
c. Client
d. Source
e. Tools/Other
f. Incomplete Files

III. Guide
a. Database
b. Server
c. Client

IV. Other
a. Known Issues
b. S.U.N Help Thread

V. Disclaimer
a. MEGA Download Limit

I. Information

a. General

Spoiler:

These server files are compatible to S.U.N Online Episode 1 (v.1007). Relatively speaking these files are 2010 or older. Due to the fact that there are no truly working S.U.N files someone will have to take the time to sit down and make it from either the source code provided here or the source code that I will be releasing soon. The server and client has up to five classes, maximum level of 135, and every map before Episode 2. Unfortunately, there is no repacker for the client, only an unpacker which would be the WPKTool under Tools in Section II. Keep in mind that these files are still incomplete and need to be worked on or rebuilt.

Another thing I want to mention is that I separated the files up and compressed them even more this time around when uploading the files to Google Drive compared to in the past with MEGA. For anyone wishing to download anything off of MEGA please see Section V labeled as Disclaimer for a bypass on MEGA’s download limit.

b. Credits

Spoiler:

I would like to say special thanks to @tedchow for even uploading these files and anyone who has even sat down to help get these files to where they are at now.

II. S.U.N Files

a. Server

Spoiler:

Google Drive Download (Recommended)

NAME: SUN_Server.rar
SIZE: 1GB
LINK: https://drive.google.com/file/d/0B4X...uNGnYxm2Dj2-3g

INFO: Contains only the Server.


MEGA Download

NAME: Server Files.rar
SIZE: 1.59GBs
LINK: https://mega.nz/#!oJUiQL7Q!_1GkKcoPU...GT3nxw6vrXaMmo

INFO: Contains the Server, Database, and Source code.

b. Database

Spoiler:

Microsoft SQL 2008 R2 SP 2 (Recommended)

LINK: https://www.microsoft.com/en-us/down....aspx?id=30438
INFO: Remember to get the SQL Express and SQL Management Studio x86 or x64-bit version respectively to your computer at the same time.

Microsoft SQL 2008 R2 SP 3 ONLY (Recommended)

LINK: https://www.microsoft.com/en-us/down....aspx?id=44271

Google Drive Download (Recommended)

NAME: SUN_Database.rar
SIZE: 662KBs
LINK: https://drive.google.com/file/d/0B4X...oueoldkmrfgqjA

c. Client

Spoiler:

Google Drive Download (Recommended)

NAME: SUN_v1007(Compact).rar
SIZE: 2GBs
LINK: https://drive.google.com/file/d/0B4X...uDXWgffnCRjCoQ


NAME: SUN_v1007(Uncompact).rar
SIZE: 2GBs
LINK: https://drive.google.com/file/d/0B4X...aQ64BKmo0qAqkQ



MEGA Download

NAME: SUN_v1007(Compact).rar
SIZE: 2.35GBs
LINK: https://mega.nz/#!hVlFBKZb!5b1sOij76...0ef2spZJl8PQtg


NAME: SUN_v1007(Uncompact).rar
SIZE: 2.34GBs
LINK: https://mega.nz/#!1c9VRQ6S!tvJW5m5pg...B-cBee7Jmd-JDY

d. Source

Spoiler:

Google Drive Download (Recommended)

NAME: SUN_Source.rar
SIZE: 883MBs
LINK: https://drive.google.com/file/d/0B4X...kHrSQj73M-my-A

e. Tools/Other

Spoiler:

Google Drive Download (Recommended)

NAME: WPKTool.rar
SIZE: 12KBs
LINK: https://drive.google.com/file/d/0B4X...iCT8vAo3CV32CQ

NAME: MS_SQL_2000.rar (Not Needed)
SIZE: 33MBs
LINK: https://drive.google.com/file/d/0B4XWZPUA9qERYWNqTFh0NlJWdnc/view?usp=sharing&resourcekey=0-QRmIhqU5UUMFADHAzZibbw



MEGA Download

NAME: OLD SQL Server.rar
SIZE: 32.8MBs
LINK: https://mega.nz/#!FZ02jDJI!OjS9EBUps...732e17F7vx30sk

INFO: I personally do not recommend using this. I removed it from the files I am currently using because it's in Chinese, has tons of problems, and you cannot transfer or restore data. Basically it's not possible to create a backup or transfer new tables or data in. You do not need this for the server to run properly but if you choose not to use this, you need to go get an SQL server (MySQL, MS SQL, and etc) in your preferred language. I use MS SQL 2008 R2 (Version doesn't matter, get 2012 if you want). If you plan on using this and there is .dll missing for certain things in the SQL 2000 then look into the following directories: \mssql\Tools\isqlw\Resources ,\mssql\Tools\SQLManager\Resource .

f. Incomplete Files

Spoiler:

Google Drive Download (Recommended)

NAME: SunEmu_Original.rar
SIZE: 304MBs
LINK: https://drive.google.com/file/d/0BzU...wtnpcIWc7Ho60A

INFO: This set of SUN files are older than what was provided in Source under Section II.



NAME: Archive_04-2017.rar
SIZE: 2GBs
LINK: https://drive.google.com/file/d/0BzU...ujGv29Mn3RC3FA

INFO: The archived files for 04-2017 starts at 04-28-2017 and ends at 04-29-2017, which these are more updated than the source under Section II in the subsection called "Source". The source code under that section is from 04-22-2017.



NAME: Archive_05-2017_Part1.rar
SIZE: 4.1GBs
LINK: https://drive.google.com/file/d/0BzU...VhvVCpO7YHY5Cw

INFO: The archived files for 05-2017_Part1 starts at 05-01-2017 and stops at 05-10-2017.



NAME: Archive_05-2017_Part2.rar
SIZE: 3.2GBs
LINK: https://drive.google.com/file/d/0BzU2BRmROUjjOF9ZbnNJX3BTVW8/view?usp=sharing&resourcekey=0-T7LyBt38kNRD-r2BIitYXQ

INFO: The archived files for 05-2017_Part2 starts at 05-14-2017 and stops at 05-28-2017 since that was the last day I stopped working on the files. You can find the progress report inside the "Unknown" folder but there is no source code. I have to upload the most current set of files I have from when I was working on them back in 05-2017.


NAME: SUN_v1007_Unknown.pdf
SIZE: 276KBs
LINK: https://drive.google.com/file/d/0BzU...35pntvdo9mVsTQ

INFO: Goes with SunEmu_v1007_Source.rar. I forgot to pack it into the .rar before I uploaded it.



NAME: SunEmu_v1007_Source.rar
SIZE: 4GBs
LINK: https://drive.google.com/file/d/0BzU...nYDgXltaRjmnhA

INFO: This is the most recently updated source from 05-28-2017. Please check the progress report inside the "Unknown" folder in the "Archived" folder. AuthServer needs to be completely updated since it's missing the most out of all of the servers and contains some Aion source code. Please check subsection a called "Known Issues" under Section IV: Other, this will contain all the most recent known issues about the source code.

III. Guides

a. Database

Spoiler:

Instructions

For first time installation of Microsoft SQL, please follow the steps below. These steps will allow the SUN Server and SQL Database to communication with each other, therefore allowing the SUN Server to obtain information for the client. If 'DBServer.exe' gets any errors, please check 'Server Properties' under Microsoft SQL Server Management Studio or the 'DBServer.ini' in the main 'SUNEmu' folder.

Spoiler:

Login on SSMS:

1) Open up 'Microsoft SQL Server Management Studio'.
2) On the small window, leave 'Server type:' as 'Database Engine'.
3) For 'Server name:' it should be your PC name, .\ServerName, or (localhost)\ServerName.

NOTE: Should be default to your PC name.

4) Leave 'Authentication:' as 'Windows Authentication'.
5) Click 'Connect' at the bottom.

Spoiler:

Restore Database:

1) Right click on 'Databases' folder at the top
2) Click 'Restore Database...'
3) In the window that popped up, click 'From device' under 'Source for restore'.
4) Click '...' and browse for 'sunonline.bak', then click 'OK'.
5) In the table below, check mark whichever is recently updated.
6) Click the dropdown box next to 'To database:' under 'Destination for restore'.
7) Click the first 'sunonline' on the dropdown box under 'Destination for restore'.
8) Click 'OK' at the bottom of the window and wait for the Database to restore.

Spoiler:

Enabling 'sa' as login:

1) Open up Microsoft SQL Server Management Studio
2) Right Click on the main SQL name at the top, then click 'New Query'
3) Copy and Paste the code below and execute/run the query.

NOTE: It's better to use a stronger Password than '123456', if the password is changed then go to \Server\AuthServer.ini and change the password at the bottom under '[SQL_SERVER]'. This can be applied if you don't decide to use 'sa' as the login.

CODE:
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'123456'
GO
ALTER LOGIN [sa] ENABLE
GO

4) If step 3 doesn't work and the 'sa' login is not enabled under 'Security' folder then go to the link below.
LINK: https://sudeeptaganguly.wordpress.co...in-sql-server/

Spoiler:

Allowing Remote Connections:

1) Open up Microsoft SQL Server Management Studio
2) Right click on the main SQL name at the top and click 'Properties'
3) Click on 'Security' on the left-hand side
4) Check 'SQL Server and Windows Authentication mode'
5) Then click on 'Connections' on the left-hand side
6) Check 'Allow remote connections to this server'
7) Click 'OK' at the bottom

Spoiler:

Changing Configuration Manager:

1) Open up Sql Server Configuration Manager.
2) On the left-hand side, left click 'SQL Server Network Configuration'.
3) On the right-hand side, there should be 'Protocols for MSSQLSERVER', left click it.

NOTE: The name for your server may be different, in this case it's 'MSSQLSERVER'.

4) On right-hand side, there should be a list, right click 'TCP/IP', and enable it.
5) Now left click 'TCP/IP' and another window should pop up.
6) Click the 'IP Addresses' tab.
7) Scroll down to find '127.0.0.1' and enable this IP Address.
8) Make sure 'TCP Dynamic Ports' is blank and 'TCP Port' is '1433'.
9) Scroll all the way down to the bottom to 'IPAll'.
10) Make sure 'TCP Dynamic Ports' is blank and 'TCP Port' is '1433'.
11) Click 'OK' at the bottom of the window.
12) On the left-hand side, left click 'SQL Server Services'.
13) On the right-hand side, right click SQL Server(MSSQLSERVER), and click 'Restart'.

NOTE: The name for your server may be different, in this case it's 'MSSQLSERVER'.

Spoiler:

Creating ODBC:

1) Open up Data Sources (ODBC)
2) Under User DSN click Add on the right-hand side
3) Select SQL Server Native Client 10.0 and click Finish

NOTE: This will be installed on the machine in most installations of Microsoft SQL.

4) In the box, next to 'Name:' type the name of the connection of your choice

NOTE: 'sunonline' would probably be a better choice since it's easier to find.

5) In the box, next to 'Server:' type in '127.0.0.1' and click Next.

NOTE: The Description box can be left blank.

6) Check the second option for 'With SQL Server authentication using a login ID'
7) For 'Login ID:' type in 'sa' and for 'Password:' type in '123456'

NOTE: This login and password can be found in the 'AuthServer.ini' in the main 'Server' folder.

8) Click Next. Check 'Change the default database to:' and select 'sunonline' in the dropbox.
9) Click Next. If you wish to change your language of SQL Server system messages, then do so here.
10) Click Finish. A window should popup and click 'Test Data Source...'.
11) If a window pops up saying 'TESTS COMPLETED SUCCESSFULLY!' then click OK, then click OK again, and click OK for the third time.

b. Server

Spoiler:

Instructions

At this point the Microsoft SQL and ODBC should be setup correctly. If not, please check the ReadMe.txt under \SQLBackup\ReadMe.txt or Database\ReadMe.txt

Spoiler:

Startup

1) AuthServer.exe
2) DBServer.exe
3) AgentServer_d.exe
4) GameServer_d.exe

NOTE: \Server\channel01\GameServer_d.exe

c. Client

Spoiler:

Launch

Go to the directory in which S.U.N Online is installed in and run a file called ‘Launch_SUN.bat’. This should automatically start up the client.

IV. Other

a. Known Issues

Spoiler:

Database

1) May not be able to restore in MSSQL 2014 or later due to the fact that the database was upgraded to 2008. To get MSSQL 2008 R2 SP2, please check Database under Section II.

2) A lot of the Stored Procedures are out of date, therefore they do not run properly. The database requires a lot of updating on the query end. If you decide to do this then you need to update the source code end for the server to communicate to the database.

3) Tables and binary needs to be updated properly. One thing I have noticed over time is that the tables need to be updated to fit the server and client end. The binary preloaded into some of the tables need to updated or removed for the client to properly load or update.

Server

1) The server does not load in guild related information from the database. This problem occurs from the fact that the code related to this is nulled out in the source code.

2) The server has buffering issues when sorting through large amounts of data. I'm assuming the hard coded in packet size needs to be updated on the server source code end.

3) The Cash Shop slots and tabs are hard coded to only provide 5 pages or tabs and 25 items total on all 5 pages. This issue is found in the game server source code.

4) There is map loading issues. The client cannot load into new maps and the server has a hard time accepting new maps that are linked (other than Tringel and Zapir Lake). I personally believe there is a packet issue or it's hard coded in.

5) The servers (I know for a fact DB and Game Server) do not recognize anything related to GM, such as verifying GM accounts/characters, commands, and etc. This is because the GM related code is not complete in the source code.

6) There is a lot of skills that do not work because of all sort of reasons. Some don't work due to the skill not existing on the server end, some have incorrect status effects such as the user gets stunned when they shouldn't, the skills don't have lingering effects such as heals or buffs, and etc. because they are not coded in on the source code.

7) All constants (const.h) or defines (define.h, commondef.h, and etc.) on the server end needs to be updated. These files were originally built from Aion, so please keep that in mind if you decide to pick up the source code.

8) Lots of animations on the server end don't work. For an example, sitting, waving, auto-attacking (with or without weapon), and etc. This occurs because the constants and defines (number 7 in this list) needs to be updated.

b. S.U.N Help Thread

Spoiler:

Please see the subsection above called Known Issues for a more details about the server. Here is another thread for this set of server files if anyone wants to use it. It’s optional.

LINK: http://forum.ragezone.com/f859/onlin...files-1092227/

V. Disclaimer

a. MEGA Download Limit

Spoiler:

For anyone who wishes to download my files off of MEGA but getting that download limit issue, please follow the guide on this website. I'm not responsible for anything on that website, but the programs provided has helped me get around the download limit issue. If anyone has any suggestions towards hosting sites similar to Google or MEGA that works best for them, please let me know.

god bless you thank i will try

- - - Updated - - -

Quote:

---

Originally Posted by Ashime

Soul of the Ultimate Nation Online
Server Files, Source, Database, Client(s), & Tools

Tables of Contents

Spoiler:

I. Information
a. General
b. Credits

II. S.U.N Files
a. Server
b. Database
c. Client
d. Source
e. Tools/Other
f. Incomplete Files

III. Guide
a. Database
b. Server
c. Client

IV. Other
a. Known Issues
b. S.U.N Help Thread

V. Disclaimer
a. MEGA Download Limit

I. Information

a. General

Spoiler:

These server files are compatible to S.U.N Online Episode 1 (v.1007). Relatively speaking these files are 2010 or older. Due to the fact that there are no truly working S.U.N files someone will have to take the time to sit down and make it from either the source code provided here or the source code that I will be releasing soon. The server and client has up to five classes, maximum level of 135, and every map before Episode 2. Unfortunately, there is no repacker for the client, only an unpacker which would be the WPKTool under Tools in Section II. Keep in mind that these files are still incomplete and need to be worked on or rebuilt.

Another thing I want to mention is that I separated the files up and compressed them even more this time around when uploading the files to Google Drive compared to in the past with MEGA. For anyone wishing to download anything off of MEGA please see Section V labeled as Disclaimer for a bypass on MEGA’s download limit.

b. Credits

Spoiler:

I would like to say special thanks to @tedchow for even uploading these files and anyone who has even sat down to help get these files to where they are at now.

II. S.U.N Files

a. Server

Spoiler:

Google Drive Download (Recommended)

NAME: SUN_Server.rar
SIZE: 1GB
LINK: https://drive.google.com/open?id=0B4...TZQUHVTUDJhMnM

INFO: Contains only the Server.


MEGA Download

NAME: Server Files.rar
SIZE: 1.59GBs
LINK: https://mega.nz/#!oJUiQL7Q!_1GkKcoPU...GT3nxw6vrXaMmo

INFO: Contains the Server, Database, and Source code.

b. Database

Spoiler:

Microsoft SQL 2008 R2 SP 2 (Recommended)

LINK: https://www.microsoft.com/en-us/down....aspx?id=30438
INFO: Remember to get the SQL Express and SQL Management Studio x86 or x64-bit version respectively to your computer at the same time.

Microsoft SQL 2008 R2 SP 3 ONLY (Recommended)

LINK: https://www.microsoft.com/en-us/down....aspx?id=44271

Google Drive Download (Recommended)

NAME: SUN_Database.rar
SIZE: 662KBs
LINK: https://drive.google.com/open?id=0B4...nZfV1Z3aDZCNzA

c. Client

Spoiler:

Google Drive Download (Recommended)

NAME: SUN_v1007(Compact).rar
SIZE: 2GBs
LINK: https://drive.google.com/open?id=0B4...29RT0wtc2RCdzQ


NAME: SUN_v1007(Uncompact).rar
SIZE: 2GBs
LINK: https://drive.google.com/open?id=0B4...FlTSS1BS1ZOMGs



MEGA Download

NAME: SUN_v1007(Compact).rar
SIZE: 2.35GBs
LINK: https://mega.nz/#!hVlFBKZb!5b1sOij76...0ef2spZJl8PQtg


NAME: SUN_v1007(Uncompact).rar
SIZE: 2.34GBs
LINK: https://mega.nz/#!1c9VRQ6S!tvJW5m5pg...B-cBee7Jmd-JDY

d. Source

Spoiler:

Google Drive Download (Recommended)

NAME: SUN_Source.rar
SIZE: 883MBs
LINK: https://drive.google.com/open?id=0B4...UdOUGltWFNXNEk

e. Tools/Other

Spoiler:

Google Drive Download (Recommended)

NAME: WPKTool.rar
SIZE: 12KBs
LINK: https://drive.google.com/open?id=0B4...WhlU1BfbWVKQU0

NAME: MS_SQL_2000.rar (Not Needed)
SIZE: 33MBs
LINK: https://drive.google.com/open?id=0B4...WNqTFh0NlJWdnc



MEGA Download

NAME: OLD SQL Server.rar
SIZE: 32.8MBs
LINK: https://mega.nz/#!FZ02jDJI!OjS9EBUps...732e17F7vx30sk

INFO: I personally do not recommend using this. I removed it from the files I am currently using because it's in Chinese, has tons of problems, and you cannot transfer or restore data. Basically it's not possible to create a backup or transfer new tables or data in. You do not need this for the server to run properly but if you choose not to use this, you need to go get an SQL server (MySQL, MS SQL, and etc) in your preferred language. I use MS SQL 2008 R2 (Version doesn't matter, get 2012 if you want). If you plan on using this and there is .dll missing for certain things in the SQL 2000 then look into the following directories: \mssql\Tools\isqlw\Resources ,\mssql\Tools\SQLManager\Resource .

e. Incomplete Files

Spoiler:

Coming Soon!

III. Guides

a. Database

Spoiler:

Instructions

For first time installation of Microsoft SQL, please follow the steps below. These steps will allow the SUN Server and SQL Database to communication with each other, therefore allowing the SUN Server to obtain information for the client. If 'DBServer.exe' gets any errors, please check 'Server Properties' under Microsoft SQL Server Management Studio or the 'DBServer.ini' in the main 'SUNEmu' folder.

Spoiler:

Login on SSMS:

1) Open up 'Microsoft SQL Server Management Studio'.
2) On the small window, leave 'Server type:' as 'Database Engine'.
3) For 'Server name:' it should be your PC name, .\ServerName, or (localhost)\ServerName.

NOTE: Should be default to your PC name.

4) Leave 'Authentication:' as 'Windows Authentication'.
5) Click 'Connect' at the bottom.

Spoiler:

Restore Database:

1) Right click on 'Databases' folder at the top
2) Click 'Restore Database...'
3) In the window that popped up, click 'From device' under 'Source for restore'.
4) Click '...' and browse for 'sunonline.bak', then click 'OK'.
5) In the table below, check mark whichever is recently updated.
6) Click the dropdown box next to 'To database:' under 'Destination for restore'.
7) Click the first 'sunonline' on the dropdown box under 'Destination for restore'.
8) Click 'OK' at the bottom of the window and wait for the Database to restore.

Spoiler:

Enabling 'sa' as login:

1) Open up Microsoft SQL Server Management Studio
2) Right Click on the main SQL name at the top, then click 'New Query'
3) Copy and Paste the code below and execute/run the query.

NOTE: It's better to use a stronger Password than '123456', if the password is changed then go to \Server\AuthServer.ini and change the password at the bottom under '[SQL_SERVER]'. This can be applied if you don't decide to use 'sa' as the login.

CODE:
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'123456'
GO
ALTER LOGIN [sa] ENABLE
GO

4) If step 3 doesn't work and the 'sa' login is not enabled under 'Security' folder then go to the link below.
LINK: https://sudeeptaganguly.wordpress.co...in-sql-server/

Spoiler:

Allowing Remote Connections:

1) Open up Microsoft SQL Server Management Studio
2) Right click on the main SQL name at the top and click 'Properties'
3) Click on 'Security' on the left-hand side
4) Check 'SQL Server and Windows Authentication mode'
5) Then click on 'Connections' on the left-hand side
6) Check 'Allow remote connections to this server'
7) Click 'OK' at the bottom

Spoiler:

Changing Configuration Manager:

1) Open up Sql Server Configuration Manager.
2) On the left-hand side, left click 'SQL Server Network Configuration'.
3) On the right-hand side, there should be 'Protocols for MSSQLSERVER', left click it.

NOTE: The name for your server may be different, in this case it's 'MSSQLSERVER'.

4) On right-hand side, there should be a list, right click 'TCP/IP', and enable it.
5) Now left click 'TCP/IP' and another window should pop up.
6) Click the 'IP Addresses' tab.
7) Scroll down to find '127.0.0.1' and enable this IP Address.
8) Make sure 'TCP Dynamic Ports' is blank and 'TCP Port' is '1433'.
9) Scroll all the way down to the bottom to 'IPAll'.
10) Make sure 'TCP Dynamic Ports' is blank and 'TCP Port' is '1433'.
11) Click 'OK' at the bottom of the window.
12) On the left-hand side, left click 'SQL Server Services'.
13) On the right-hand side, right click SQL Server(MSSQLSERVER), and click 'Restart'.

NOTE: The name for your server may be different, in this case it's 'MSSQLSERVER'.

Spoiler:

Creating ODBC:

1) Open up Data Sources (ODBC)
2) Under User DSN click Add on the right-hand side
3) Select SQL Server Native Client 10.0 and click Finish

NOTE: This will be installed on the machine in most installations of Microsoft SQL.

4) In the box, next to 'Name:' type the name of the connection of your choice

NOTE: 'sunonline' would probably be a better choice since it's easier to find.

5) In the box, next to 'Server:' type in '127.0.0.1' and click Next.

NOTE: The Description box can be left blank.

6) Check the second option for 'With SQL Server authentication using a login ID'
7) For 'Login ID:' type in 'sa' and for 'Password:' type in '123456'

NOTE: This login and password can be found in the 'AuthServer.ini' in the main 'Server' folder.

8) Click Next. Check 'Change the default database to:' and select 'sunonline' in the dropbox.
9) Click Next. If you wish to change your language of SQL Server system messages, then do so here.
10) Click Finish. A window should popup and click 'Test Data Source...'.
11) If a window pops up saying 'TESTS COMPLETED SUCCESSFULLY!' then click OK, then click OK again, and click OK for the third time.

b. Server

Spoiler:

Instructions

At this point the Microsoft SQL and ODBC should be setup correctly. If not, please check the ReadMe.txt under \SQLBackup\ReadMe.txt or Database\ReadMe.txt

Spoiler:

Startup

1) AuthServer.exe
2) DBServer.exe
3) AgentServer_d.exe
4) GameServer_d.exe

NOTE: \Server\channel01\GameServer_d.exe

c. Client

Spoiler:

Launch

Go to the directory in which S.U.N Online is installed in and run a file called ‘Launch_SUN.bat’. This should automatically start up the client.

IV. Other

a. Known Issues

Spoiler:

Database

1) May not be able to restore in MSSQL 2014 or later due to the fact that the database was upgraded to 2008. To get MSSQL 2008 R2 SP2, please check Database under Section II.

2) A lot of the Stored Procedures are out of date, therefore they do not run properly. The database requires a lot of updating on the query end. If you decide to do this then you need to update the source code end for the server to communicate to the database.

3) Tables and binary needs to be updated properly. One thing I have noticed over time is that the tables need to be updated to fit the server and client end. The binary preloaded into some of the tables need to updated or removed for the client to properly load or update.

Server

1) The server does not load in guild related information from the database. This problem occurs from the fact that the code related to this is nulled out in the source code.

2) The server has buffering issues when sorting through large amounts of data. I'm assuming the hard coded in packet size needs to be updated on the server source code end.

3) The Cash Shop slots and tabs are hard coded to only provide 5 pages or tabs and 25 items total on all 5 pages. This issue is found in the game server source code.

4) There is map loading issues. The client cannot load into new maps and the server has a hard time accepting new maps that are linked (other than Tringel and Zapir Lake). I personally believe there is a packet issue or it's hard coded in.

5) The servers (I know for a fact DB and Game Server) do not recognize anything related to GM, such as verifying GM accounts/characters, commands, and etc. This is because the GM related code is not complete in the source code.

6) There is a lot of skills that do not work because of all sort of reasons. Some don't work due to the skill not existing on the server end, some have incorrect status effects such as the user gets stunned when they shouldn't, the skills don't have lingering effects such as heals or buffs, and etc. because they are not coded in on the source code.

7) All constants (const.h) or defines (define.h, commondef.h, and etc.) on the server end needs to be updated. These files were originally built from Aion, so please keep that in mind if you decide to pick up the source code.

8) Lots of animations on the server end don't work. For an example, sitting, waving, auto-attacking (with or without weapon), and etc. This occurs because the constants and defines (number 7 in this list) needs to be updated.



More to come!

b. S.U.N Help Thread

Spoiler:

Please see the subsection above called Known Issues for a more details about the server. Here is another thread for this set of server files if anyone wants to use it. It’s optional.

LINK: http://forum.ragezone.com/f859/onlin...files-1092227/

V. Disclaimer

a. MEGA Download Limit

Spoiler:

For anyone who wishes to download my files off of MEGA but getting that download limit issue, please follow the guide on this website. I'm not responsible for anything on that website, but the programs provided has helped me get around the download limit issue. If anyone has any suggestions towards hosting sites similar to Google or MEGA that works best for them, please let me know.

---

god bless you thank i will try

@SMF001

Good luck. If you need anything, post on here or private message me. Have fun!

just a quick update:

there are some .txt .xml files within the sources, they actually have types of "lists" left by the devs of the game, as is, i've found a .ppt file containing all the steps for the server communication, wich ended to be FTP (potentially cash shop).

problem is, they are in Korean. since my Korean is enough to get myself killed. i have no idea what to do there, the sources are "a bit okay" and the binary updater seem to have a charm mostly for the tests. again, problem is that is in Korean. getting dem files translated into google is like "asking a deaf guy where is the terlet".

don't get me wrong, i'm only pointing a potential gold mine, for anyone that can translate these Korean files, logs with "TODO" and some functions as well. also there is some ASM in the source, just learn the basic bytes handling and you will be fine (most of the time).

and i really recommend using IpLoopback, cause sniffing with wireshark be easy, and the game actually does send half-assed packets to the server (i've been testing with Shards of War btw... and it's working with "login packets")

-edit-
here be a "commented" bit of code from TypeDefine.h (from agentserver's sun3d engine folder)

Code:

---

/// CDrawBase::RenderMeshGroup ÇÒ¶§ ÆĶó¹ÌÅÍ
/*typedef struct
{
        HANDLE m_hTexDiffuseToUse;        ///< ¿ø·¡ ÅؽºÃÄ ¸»°í ¹Ù²ã¼­ »ç¿ë
        float m_fUShift, m_fVShift;        ///< UV shift ±â´É
        BOOL m_bUVNormal;                        ///< normal ÂüÁ¶Çؼ­ u, v °è»êÇÑ´Ù.
        WzVector m_wvUVNormal[2];        ///< normal ÀÌ u, v ¿¡ ¹ÌÄ¡´Â ¿µÇâ
        BOOL m_bUVLight;                        ///< light ¿Í normal ÂüÁ¶Çؼ­ u, v °è»êÇÑ´Ù.
        int m_iSunLight;                        ///< Gouraud, Phong µî ½¦À̵ùÀÇ Àû¿ë ¿©ºÎ ( 1 - default, 0 - Àû¿ë¾ÈÇÔ, 2 - ¹«Á¶°Ç Àû¿ëÇÔ)
        WzUVVert *m_pwuvUsePhongUV;        ///< Phong ½¦À̵ù¿¡¼­ »ç¿ëÇÏ´Â u, v
        HANDLE m_hTextureFilter;        ///< ÇÊÅÍ¿ë ÅýºÃÄ( ±¸¸Û ¶Ô¸° À̹ÌÁö )
} WzRenderMeshGroupParam;

inline void InitRenderMeshGroupParam( WzRenderMeshGroupParam *pwrmgp)
{
        pwrmgp->m_hTexDiffuseToUse = 0;//INVALID_HANDLE_VALUE;        ///< 0 - ¸Þ½¬°¡ °¡Áø ÅؽºÃÄ »ç¿ë, INVALID_HANDLE_VALUE - Èò»ö ÅؽºÃÄ
        pwrmgp->m_fUShift = 0.0f;
        pwrmgp->m_fVShift = 0.0f;
        pwrmgp->m_bUVNormal = FALSE;
        pwrmgp->m_bUVLight = FALSE;
        pwrmgp->m_iSunLight = 1;
        pwrmgp->m_pwuvUsePhongUV = NULL;
        pwrmgp->m_hTextureFilter = INVALID_HANDLE_VALUE;
}
*/

---

since i'm a using a notebook i didn't arse myself into adding a Korean languague pack (not that it would help, since google is the one that needs a better languague pack).

@wall57
I will look through the source and see if I can find anything that may help. Just please keep in mind that the server executables are much larger and more complete than the source code. I did spend a few days trying to reconstruct the source code and I got the AuthServer fully built with no errors or warnings. The issue is that the source code is incomplete by itself. I have other source code to where I might be able to piece a server back together. Aside from that I found a more complete source code that has nine servers instead of four. I will probably be making a development post soon on RageZone. I just haven't made a true decision on what files to really work on because they are completely different in structure.

Im going to look into what you suggested and see what I get.

The nine server version is the correct one. I think that is where we need to aim. I have the korean text files as well, I think I sent them to you ages ago Ashime, when we were still trying to fix the EMU.

@Macgyver70
I am going through the SUN source for the nine servers and checking it out. It is more complete than the SUNEmu but has way more bugs than the SUNEmu files. Korean text files?

I'll see if I can track down my copy of them and repost for you. It's Korean, but you can googlate most of it, as Korean translates a lot better than Chinese. It's all dev notes and such.

First of all, i haf to thank asime the easy install guide, which helps me save a lot of time. mainly, i do haf a big problem to creating a charater. i use the tool which Asime's provided(OLD SQL Server.rar) to create an account, but when i access to the server i cannot created any character. is there anyway that i can create character by manually rewrite the data file? or any other way? THank you all

Quote:

---

Originally Posted by alice80125

First of all, i haf to thank asime the easy install guide, which helps me save a lot of time. mainly, i do haf a big problem to creating a charater. i use the tool which Asime's provided(OLD SQL Server.rar) to create an account, but when i access to the server i cannot created any character. is there anyway that i can create character by manually rewrite the data file? or any other way? THank you all

---

@alice80125
I would not use the Old SQL 2000 server. Please install and use MSSQL 2008-2012 or anything similar to MSSQL.

Does anyone know how to update, rebuild, or require newer Enc1-2 and Dec1-2.dat files that are inside the data folder for the SUN server files? They are encryption and decryption files, but I have no source code to rebuild them, cannot open them, and they do not come from the client.

I have some source code that I have been working on for the SunEmu files. The problem is that it is 13~14GBs and is incomplete. At the time, I am not able to continue working on them. AuthServer and DBServer are/can compile and work. The AgentServer and GameServer either compile or don't depends on the archive you use and do not work at all. I am currently working on a way to upload these files. I might have to compress and upload them all as separate files. If I don't make a new thread, these files will be going up under Incomplete Files Section on page 9.

I'm currently uploading all of my work-in-progress files for the SunEmu. I have 1/3 files uploaded. Please be patient because I'm separating one file that is 8GBs and the other is 13GBs. I will post more information about the files as they get closer to finishing on the upload. The original files are uploaded and updated on page 9 under Section II for Incomplete Files.

- - - Updated - - -

I have uploaded all of my archived files for SunEmu. They are under subsection f called "Incomplete Files" in Section II. I'm working on uploading my most recent version of SunEmu from 05-28-2017. These files will be much larger because I had removed a lot of unnecessary files when archiving. When I say unnecessary I truly mean files that didn't need to be copied more than once since they were never going be altered.

I have officially uploaded my latest source of the incomplete SunEmu files on page 9. Check out SunEmu_v1007_Source.rar and SUN_v1007_Unknown.pdf under subsection f called "Incomplete Files" in Section II. All information has been posted there, but if you have any questions about the files or need help, ask here or contact me. I will be taking a break on these files.

Please do check out the archived rars for the progression of the files and the SUN_v1007_Unknown.pdf to see where the current files are at. The current files may or may not compile compare to the previous version, but 2~3 out of 4 of the servers will compile and at least 2 of them will run. The files are not complete even though they will compile and run. Good luck!

Hi, @Ashime , I used the Server files and Uncompact 1007 client in page 9, every things seems ok, but after i select server line , i got an error to prompt me re-login. also an error messages appeared in AgentServer window(xxx is a random number):
TempUser::_isAuthenticatedUser] AuthID[xxxxxx] Auth Failed!
can you give me some advice? thanks.

@sunjunps
In the previous posts on here, someone mentioned that the client on page 6 worked for them. Instead of going back to page 6 to find it, here is the information about the client and the link.

CH SUN Client v1007
NAME: Soul of the Ultimate Nation.rar
SIZE: 2.35 GBs
LINK: https://mega.nz/#!hVlFBKZb!5b1sOij76Apm3VZ1JlPoe4j0oGCTH0ef2spZJl8PQtg

What I think is causing that authentication issue is the fact that the uncompact client is not compatible. If that is the case, then I should remove it from the client section on page 9. Makes me wonder if the compact client on page 9 even works.

Quote:

---

Originally Posted by Ashime

@sunjunps
In the previous posts on here, someone mentioned that the client on page 6 worked for them. Instead of going back to page 6 to find it, here is the information about the client and the link.

CH SUN Client v1007
NAME: Soul of the Ultimate Nation.rar
SIZE: 2.35 GBs
LINK: https://mega.nz/#!hVlFBKZb!5b1sOij76Apm3VZ1JlPoe4j0oGCTH0ef2spZJl8PQtg

What I think is causing that authentication issue is the fact that the uncompact client is not compatible. If that is the case, then I should remove it from the client section on page 9. Makes me wonder if the compact client on page 9 even works.

---

Sorry for the late reply, I can use this client to login the game, create character, start game. but after i login the game, there's nothing can do. can not enter the dungeon, can not portal, no mission. am I missing something else?

some error log from GS:
[ERROR]: [13:20:14][AG] PacketType Error!!Category[EA] Protocol[09]
[ERROR]: [13:20:22][AG] PacketType Error!!Category[FD] Protocol[7B]
[U:33][P:33]:Disconnect From Gameserver
[DEBUG]: [13:24:26][U:33:P:33:ID:123456][2]:Login!
[ERROR]: [13:24:32][AG] PacketType Error!!Category[EA] Protocol[09]
[ERROR]: [13:25:34][AG] PacketType Error!!Category[6F] Protocol[10]
Message Size Error too small: size(0) category(205) protocol(205)
(127.0.0.1)
[ERROR]: [13:25:34][AG] PacketType Error!!Category[CD] Protocol[CD]
[U:33][P:33]:Disconnect From Gameserver
[DEBUG]: [13:55:33][U:33:P:33:ID:123456][2]:Login!
[ERROR]: [13:55:39][AG] PacketType Error!!Category[EA] Protocol[09]
[ERROR]: [13:55:41][AG] PacketType Error!!Category[65] Protocol[44]
[ERROR]: [13:57:20][AG] PacketType Error!!Category[65] Protocol[44]
[U:33][P:33]:Disconnect From Gameserver

@sunjunps
Thats the catch, the server is not complete, so you will have to complete the source provided or remake the server by scratch.

Here is what you cannot do:
1) Missions
2) Quests
3) Temple of Blood
4) Battle Zone (PVE/PVP)
5) Crafting/Enhancing

And much more. You can fix the waypoint and portal problems by getting the GameServer to load the correct data in the world.txt, field.txt, and a few other files (I will have to look at the files later to tell you which ones)

@Ashime, thanks for you reply.
I will say it's a difficult job for me. Even I like this game, I cannot spend so many time on it. Also the C code is hard to understand. So I have to give up this game server.
Thank you for your hard work, and good luck.

url is broken T)T

Quote:

---

Originally Posted by systemcorp

url is broken T)T

---

@systemcorp

I just checked all the URLs that I posted on page 9 and they are still good. If any of the URLs on page 1 is broken, I cant help there.

Quote:

---

Originally Posted by Ashime

@systemcorp

I just checked all the URLs that I posted on page 9 and they are still good. If any of the URLs on page 1 is broken, I cant help there.

---

hi, do you still have the files for these? I just the url you posted on page 9, it requires permission. Thanks in advance.

I have updated all of my Google download links on page 9. No doubt that my Mega download links are down, but that will take longer to update.

- - - Updated - - -

At this current moment I will not be updating my MEGA download links because all of my files from that site were deleted on me. Therefore I would have to upload everything from Google to MEGA again.

Quote:

---

Originally Posted by Ashime

@pimpa

You can setup the server with the files I have posted and test the server yourself. I sadly do not have a computer good enough to host off of. Sorry.

---

i hawe god pc Screenshot by Lightshot (prnt.sc)https://prnt.sc/or1CCMiCLImxhttps://prnt.sc/or1CCMiCLImx