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

This SUNEmu is released on last year or last two year...I forgot the exact time...

I am not sure if people have post this emu on this forum....but I think this one is different with SUN Online server file+gmtool [latest fix 8Nov09] - RaGEZONE - MMO development community this one....

By my test, this emu is working good...but still have some bugs and missing other main maps...
-----------------------------------------------------------------------------------------------
Bugs i have found:
-buffs skills didnt work
-missing lots of maps (hopefully people can put all maps into emu from the client of Recourse.wpk this file...) cuz the dev person only put 2 maps into the emu just for test...
-selected a char and then back to char selection and then enter the world is not working.
...
..

the rest is working good...like killing mobs,,spawn, cash shop, skills,etc....

---------------------------------------
LINKS:
SUNEmu: https://mega.co.nz/#!hFZR2Crb!d1LBxI...zXTHl39kAdzr2A

MATCH CLIENT: SUNOnline ver 1.0.0.6.7z_免费高速下载|百度云 网盘-分享无限制

SUNONLINE source: https://mega.co.nz/#!ZMh2EZ7L!WwRFG0...ddHLZ76wGQQ4iU

SUNEmu source: https://mega.co.nz/#!gUwgBT7Y!1ipPaQ...wtCwFBSmp_ORto

P.S. the registration tools is in Chinese...I will pose the translation on here later...or u can see the old one for reference.
-----------------------------------------------------------------------------------------------
I am very into this game since the game was in the beta test in NA and CN server .....
I also hope people can continue to develop up this emu to a perfect one...I am very appreciate it!!
----------------------------------------------------------------------------------------------

Have downloaded. I'll get to work on it, and let you know my results :)
TYVM for the upload.

have fun..

Quote:

---

Originally Posted by tedchow

have fun..

---

How to play?

there has a launcher inside of the SUNEMu folder......run it...default ip is 127.0.0.1

Quote:

---

Originally Posted by game123res

How to play?

---

Client not download. upload mega please.

Use google chrome, it'll translate the pan.baidu website. It will download, it just takes a while. If you are still having problems, I'll do a mega upload.

I have it running.
I tinkered with it a bit to set it up for my LAN's ip addresses, but got it running fine.
2 maps, 1 mob and no skills....but it runs.
I'll have a tinker with it and see what I can do to get more stuff to work.
Will let you know as I find more out :)

most skills are working...u have to use gm tool to add points on ur charater

I keep crashing when I hover over skills to see the description..cant drag them to the skill bar either...
A few issues, but mostly working.

Running. Skills working. Client fully translated to english. Having slight issues with character creation..I can only create shadow class...anything else crashes Agentserver. I'll look into that.
Only 2 maps still...working on it :)

better to put the rest of maps into the Emu first ,,,before fixing other bugs

- - - Updated - - -

i have no bugs to create any characters in the Emu...buffs skills are not working....and armors didnt effective....

Cool emu. the translation is rdy? any probability to add an .txt file about reg tools?

Hello, I've downloaded everything and everything seems to work but at the second I launch the game I get "An error has been occurred on the anti-hacking monitor functions. (101). How to solve this? =]

Quote:

---

Originally Posted by Macgyver70

Running. Skills working. Client fully translated to english. Having slight issues with character creation..I can only create shadow class...anything else crashes Agentserver. I'll look into that.
Only 2 maps still...working on it :)

---

dear friend, you managed to connect into the server? could explain how to do it walk?

Client is better for mega

- - - Updated - - -

Which files need here to translate the server to be Russian?
Sorry for my anglisky.

virsual studio version ?

Client half shakes and more do not want to overwrite

I'm uploading it right now. I don't know why the original poster didn't consider uploading it to Mega. Either way, good luck because the server seems to have issues.

From what I noticed these are the problem I have come across:

1) Trying to create an character with already existing name will crash the server.
2) Trying to create any character besides the Shadow will crash the server.
3) If you create a character besides a Shadow, you will not be able to load into the character screen for that account.
4) Adding any servers through stored procedures in the DB will not load in the server listing for the client.
5) Can only create an account through GM tool.
6) If you decided to create a Shadow, the server crashes while loading into the login map (Triangel).

Note: I have heard from a friend that some in game features don't work properly, like buffs and skill points. I don't know for sure since I cannot load into Triangel. Yes, I have the map uploaded into the data folder for the server.

- - - Updated - - -

Here is the link for the client that corresponds to the server.

NOTICE: DOWNLOAD LINK IS BROKEN (update on Nov. 23, 2015). CHECK FUTURE (newer) POSTS!!!

Download link: [STRIKE]https://mega.nz/#!9EEQkSCL!t2kTauxbC...e-vp4qJgepfTLE[/STRIKE]

- - - Updated - - -

I finally loaded into Tringel and I have to say, it was working fine until I opened the Cash Shop. Cash Shop = Crashing.

- - - Updated - - -

I got the Cash Shop working. I even added in the text file for the waypoints to work. Although, I noticed something really problematic. Regardless of the waypoints, if you go through any active portal like the portal from Tringel to Incomplete Memorial, you automatically teleport to Zapir Lake. If you do use the waypoint, you will still teleport to Zapir Lake...even if its a town like Waldchen. I tried changing the world.txt file that houses the information for waypoint and portal locations go, but the AgentServer.exe will not start up due runtime error.

Update!

I went back through the files and realized that you can update the maps, waypoints, and etc. The world.txt file has been highly modified and to update the maps, you have to keep the modified format. A lot of the information in the text files is unknown for the most part.

I do not have an updated world.txt file. I just thought this information could help people update the server files.

good work!!! could you share the latest files?

The files I have are the same ones posted one the first page (seriously). As I stated, I don't have an updated world.txt file, but I'm in the process of remaking the world.txt file. The link I posted on here for the client is currently broken since I had to reorganize my MegaShare files, so I'll be updating that soon.


UPDATE!!!

SUN Client v1007:

NAME: SUN_v1007(Uncompacted).rar
SIZE: 2.34GBs
LINK: https://mega.nz/#!1c9VRQ6S!tvJW5m5pgQ-7DkJebkLZF6wKhJ_zHB-cBee7Jmd-JDY

INFO: This client works for me. I am allowed to login and enter the game server. Be aware that this client is not translated, so it's still in Traditional Chinese.

Update!

I'm currently working on the world.txt file so the GameServer.exe will recognize the new maps. The only problem I have come across is the GameServer pushing out an error that I can't fix because the header associated to the error in the world.txt file is unknown. This header is stated as unknown because I don't know what to fill in to remove this error.

Here is the header: dImage1~6

Here is the error: Assertion failed: 0 == GetMapInfo <pMapInfo -> MapCode>, sun<game>\programcommon\mapinfoparser.cpp, line 162

Error in mapinfoparser.cpp:

// dImage1~6까지 추가(성현창)
for(int i=0;i<sMAPINFO::MAX_FIELD_NUM;++i)
{
sr.GetNextTokenType(TOKEN_NUMBER); pMapInfo->dwImageCode[i] = sr.GetTokenNumber();
}


ASSERT( NULL == GetMapInfo(pMapInfo->MapCode) );
AddMapInfo( pMapInfo, pMapInfo->MapCode );


MapGroup * pGroup = NULL;
if( NULL == (pGroup = GetMapGroup( pMapInfo->MapKind )) )
{
pGroup = new MapGroup;
AddMapGroup( pGroup, pMapInfo->MapKind );
}
ASSERT( NULL == pGroup->GetMapInfoIndex(pMapInfo->byMType) );
pGroup->AddMapInfoIndex( pMapInfo, pMapInfo->byMType );
pGroup->AddMapInfoCode( pMapInfo, pMapInfo->MapCode );
}


sr.CloseFile();


return TRUE;
}



NOTES: If I can get this world.txt file updated properly, I'll post an updated version of the file.

Client http://sun.zhaouc.com/sun1/#down ) Client need update ) :ott1:

Is that source legal? Can i install? :8:

The errors I am getting are not from the client, the errors originate from the server itself. Zhaouc is the new retail Chinese server that took The9's place in the Chinese gaming market.

- - - Updated - - -

Update!

I have updated the world.txt file but I'm now getting a buffer error from the server when the server tries to "Create map pool...ndler."



BOOL GetFromBuffer( void *pDst, BYTE *pSrc, int iGet, int iTotalSize, int *piCurrent)
{
if ( iTotalSize < *piCurrent + iGet)
{
assert( !"GetFromBuffer - No more data from Buffer"); //The line that is receiving the error.
return ( FALSE);
}


memcpy( pDst, &pSrc[*piCurrent], iGet);
*piCurrent += iGet;
return ( TRUE);
}


The other part of the code that defines some of the headers.

/// @name --- 버퍼관련 처리
void GetFloatString( char *lpszDst, float fValue, int iLevel = 4);
BOOL GetFromBuffer( void *pDst, BYTE *pSrc, int iGet, int iTotalSize, int *piCurrent);

// iTotalSize 짜리 버퍼인 Src 가 *piCurrent 만큼 쓰인 상태고, 여기서 iGet 만큼 pDst 로 얻는다.


char* ParamBool2Str( BOOL bParam);
char* ParamInt2Str( int iParam, char *lpszBuffer);
BOOL ParamStr2Bool( char *lpszStr);
int ParamStr2Int( char *lpszStr);
char CharToUpper( char cChar);



I'm going to look at some other server code and see if they left more comments in or have changed the code when updating the server executables. If anyone know of any information about it, I would be highly interested in the information.

- - - Updated - - -

Update!

I forgot to add this a while back. For anyone who wants to get away from using MSSQL that is apart of the server files, you may use the zip below, this zip contains the 'sunonline.bak' that came from the original database in MSSQL. All you will need is MS SQL 2008-2013 and restore 'sunonline.bak'. After you restore the database, you will have to create an ODBC connection, which I did (local) for Server and SQL authentication login of 'sa' and '123456'. The ID (sa) and Password (123456) can be found in AuthServer.ini file in the main SunEmu folder.

UPDATE! LINK DOESN'T WORK! PLEASE CHECK PAGE FIVE FOR UPDATED DATABASE!
Download Link: [STRIKE]https://mega.nz/#!sUk0XJjL!EY_j1FwWz...RndXzI6JdNJHV8[/STRIKE]

Quote:

---

Originally Posted by Ashime

[...]

- - - Updated - - -

Update!

I forgot to add this a while back. For anyone who wants to get away from using MSSQL that is apart of the server files, you may use the zip below, this zip contains the 'sunonline.bak' that came from the original database in MSSQL. All you will need is MS SQL 2008-2013 and restore 'sunonline.bak'. After you restore the database, you will have to create an ODBC connection, which I did (local) for Server and SQL authentication login of 'sa' and '123456'. The ID (sa) and Password (123456) can be found in AuthServer.ini file in the main SunEmu folder.

Download Link: https://mega.nz/#!sUk0XJjL!EY_j1FwWz0koXL06sOSFf0lrIJZFRRndXzI6JdNJHV8

---

*will try later and edit message if works or not*


also Tuan's blog:[Portable] Soul of Ultimate Nation - 奇迹世界 - Free servers and guide!!!!
has some neat files, i managed to make the Server "Run fine" but in client if i try connect to server i bug, it say something in chinese and i can't "connect" (type login and password again but click "login" (the button under password box) and nothing happens). i was reading last time and saw that System.wpk needs to has some files edited for a proper connection. i'm somewhat "stuck" can someone check if the problem is with me or its the files? (downlo client and serv to try...)

i translated with google and did these steps:

Code:

---

Accounts available :

Login Pass 1000002 123456

Installation instructions:
  1.Extract server in the D drive (the path D: / Server)

  2.Chay ODBC.reg give ok then to enter D: \ Server \ SQL- 2000 Run GSql.exe

  3.Chay StartServer.exe (may have anti -virus programs as a virus , the first was swept into Sun- Server folders runs respectively 1-6 or 2 is off and running antivirus go bt )

Customer account and logging on StartGame.exe

  Note: For Win 7 machine using the two processes

2- and 4- DatabaseProxy AccountProxy.exe Reconciling Win XP SP3 to perform bt it will not fall
Sign GSQL the items used in SQL Server Navicat (SQL Native Client installation requires only ok and then set )

SQL Login: sa
Pass: laoyang


RAR Password : tuan565

---

*just a note*

Thank you for the information. I will look at the files provided and go over the information.

- - - Updated - - -

Update!

The buffer error I have been receiving is from the Map folder being updated. I'm not sure if certain maps are causing the problems or if it is something else that is conflicting with the Map folder.

- - - Updated - - -

Update!

I checked out those files you posted wall57. They are not anymore updated than the ones I have. The server setup still depends on the GSQL and the client is much older than the one I have. I would have to say the way the server files are setup is pretty interesting and very easy to use.

For anyone who plans to use those files, you will still have to update the maps, but all the character may work unlike the server files posted on the first page.

- - - Updated - - -

You mentioned how the client was sitting at the login screen not allowing you to connect, it's because the client version is out of date. If you translate the text in the bottom right corner, it should say 'Version out of date.' I cannot get the GSQL to load the new databases I've never seen before but honestly, I don't want to even try because the maps are out of date.

If you want to post some pictures, I can give you some advise to help fix the server or the errors you may come across. I'm going back to the server files I was working on since I have made so much progress on it.

- - - Updated - - -

Update!

I updated the maps in the Map folder with no buffer error. I'm working on the world.txt file.

Quote:

---

Originally Posted by Ashime

[...]

---

there is no problems from me on these files man, keep up with yours since they seem good, i'm a bit tired of playing the only sun private server. besides i found a extractor:
Attachment 155216

i also noticed in the System.wpk that in way down (LOGIN.INI) theres the thing i mentioned above

Spoiler:

Code:

---

;
; ·Î±ä Á¤º¸
;

[PARAM]

;
; °³¹ß ¼­¹ö±º(0)
; 'GameServerList_Dev.ini'
;
;LOGIN_SERVER_TYPE = 0
;LOGIN_SERVER_IP    = 10.1.28.129
;LOGIN_SERVER_PORT  = 10100

;
; »ç³»Å×½ºÆ® ¼­¹ö±º(1)
; 'GameServerList_Public.ini'
;
;LOGIN_SERVER_TYPE = 1
;LOGIN_SERVER_IP    = 10.1.47.6
;LOGIN_SERVER_PORT  = 44405


;
; ¼­ºñ½º ¼­¹ö±º(2)
; 'GameServerList_Service.ini'
;
LOGIN_SERVER_TYPE = 2
LOGIN_SERVER_IP    = ftp://sunpatch.nefficient.co.kr
LOGIN_SERVER_PORT  = 44405

---

also the client version is in there too

Code:

---

[GENERAL]
VERSION = 1.6.3

---

i don't know if you had that extractor but it may help others too, i could not find a packer to replace the file...

btw how did you manage to get the original chinese text? for me shows garbled text, google can't help me with eng files either.

@wall57

extratc: wpktool -m system.wpk
replace/merge: files wpktool -m system.wpk LOGIN.INI LOGIN.INI

for merge files must be same size as original.

Quote:

---

Originally Posted by ashlay

@wall57

extratc: wpktool -m system.wpk
replace/merge: files wpktool -m system.wpk LOGIN.INI LOGIN.INI

for merge files must be same size as original.

---

I haven't had to need to use the wpk tool to replace the Login.ini. I can load the game with the default Login.ini. This would be more useful towards translating the client to English.

Quote:

---

Originally Posted by Ashime

I'm uploading it right now. I don't know why the original poster didn't consider uploading it to Mega. Either way, good luck because the server seems to have issues.

From what I noticed these are the problem I have come across:

1) Trying to create an character with already existing name will crash the server.
2) Trying to create any character besides the Shadow will crash the server.
3) If you create a character besides a Shadow, you will not be able to load into the character screen for that account.
4) Adding any servers through stored procedures in the DB will not load in the server listing for the client.
5) Can only create an account through GM tool.
6) If you decided to create a Shadow, the server crashes while loading into the login map (Triangel).

Note: I have heard from a friend that some in game features don't work properly, like buffs and skill points. I don't know for sure since I cannot load into Triangel. Yes, I have the map uploaded into the data folder for the server.

- - - Updated - - -

Here is the link for the client that corresponds to the server.

NOTICE: DOWNLOAD LINK IS BROKEN (update on Nov. 23, 2015). CHECK FUTURE (newer) POSTS!!!

Download link: https://mega.nz/#!9EEQkSCL!t2kTauxbC...e-vp4qJgepfTLE

- - - Updated - - -

I finally loaded into Tringel and I have to say, it was working fine until I opened the Cash Shop. Cash Shop = Crashing.

- - - Updated - - -

I got the Cash Shop working. I even added in the text file for the waypoints to work. Although, I noticed something really problematic. Regardless of the waypoints, if you go through any active portal like the portal from Tringel to Incomplete Memorial, you automatically teleport to Zapir Lake. If you do use the waypoint, you will still teleport to Zapir Lake...even if its a town like Waldchen. I tried changing the world.txt file that houses the information for waypoint and portal locations go, but the AgentServer.exe will not start up due runtime error.

---

These don't seem to be difficult bugs to fix. I'll look into this myself if they haven't already been looked in to.

Quote:

---

Originally Posted by wall57

there is no problems from me on these files man, keep up with yours since they seem good, i'm a bit tired of playing the only sun private server. besides i found a extractor:
Attachment 155216

i also noticed in the System.wpk that in way down (LOGIN.INI) theres the thing i mentioned above

Spoiler:

Code:

---

;
; ·Î±ä Á¤º¸
;

[PARAM]

;
; °³¹ß ¼­¹ö±º(0)
; 'GameServerList_Dev.ini'
;
;LOGIN_SERVER_TYPE = 0
;LOGIN_SERVER_IP    = 10.1.28.129
;LOGIN_SERVER_PORT  = 10100

;
; »ç³»Å×½ºÆ® ¼­¹ö±º(1)
; 'GameServerList_Public.ini'
;
;LOGIN_SERVER_TYPE = 1
;LOGIN_SERVER_IP    = 10.1.47.6
;LOGIN_SERVER_PORT  = 44405


;
; ¼­ºñ½º ¼­¹ö±º(2)
; 'GameServerList_Service.ini'
;
LOGIN_SERVER_TYPE = 2
LOGIN_SERVER_IP    = ftp://sunpatch.nefficient.co.kr
LOGIN_SERVER_PORT  = 44405

---

also the client version is in there too

Code:

---

[GENERAL]
VERSION = 1.6.3

---

i don't know if you had that extractor but it may help others too, i could not find a packer to replace the file...

btw how did you manage to get the original chinese text? for me shows garbled text, google can't help me with eng files either.

---

@wall57

The Chinese characters can be achieved in a few ways.

System Locale (Restart Required)
1) Go to your Control Panel.
2) Go to Clock, Language, and Region
3) Go to Region and Language
4) A window will pop up, click the tab called Administrator
5) At the bottom is a button to change your System Locale, also known as Language Unicode

Microsoft Excel (Software Restart)
1) Go to File
2) Go to Options
3) Go to Language

I have my System Locale and Excel set to Korean. If you choose not to change your System Locale and have Excel then changing Excel's Language would be the better choice. Changing your System Locale too much can affect your keyboard. I had problems with my keyboard changing to Korean when I pressed shift.

I have migrated the GSQL to MS SQL 2008 R2 because I can easily alter the database and the sql is in English. The wpk tool is nice for extracting the client and replacing files within the client. I don't use it much anymore since I have been working on updating the server.

How many maps can you access on the server files you are working on? Can you use more than the shadow class?

- - - Updated - - -

Quote:

---

Originally Posted by 0x4233

These don't seem to be difficult bugs to fix. I'll look into this myself if they haven't already been looked in to.

---

@0x4233

I have updated everything in the server's data folder except for the world.txt file. I get a buffer error when I update the world file. If you get a buffer error on updating the Maps, it's because you have to place the maps in one folder at a time and restart the Game Server.

I still can't use any other character besides the Shadow. The Battle Zone doesn't work since I can't update the world.txt file.

@Ashime
could you create a github or svn repo so we can use your source with the bug fixes?

Quote:

---

Originally Posted by SheenBR

@Ashime
could you create a github or svn repo so we can use your source with the bug fixes?

---

@SheenBR

Are you asking for source code or server files? I'm just trying to clarify what you are asking.

I want the source of the SUNEmu right? But I noticed there are bugs while creating characters and a bug in the map pool? (I read you talking something about it)
So I wondered if you have fixed them already and released some bug-fixed source

Quote:

---

Originally Posted by SheenBR

I want the source of the SUNEmu right? But I noticed there are bugs while creating characters and a bug in the map pool? (I read you talking something about it)
So I wondered if you have fixed them already and released some bug-fixed source

---

@SheenBR
I haven't even touched the source code since I don't understand C++. Regarding the server files and the SQL database, I haven't fixed the characters (so I can only play the Shadow class) and I fixed the map pool for the Map folder only. I'm still trying to fix the world.txt since that controls what maps you can actually waypoint and travel to. The world.txt is giving me the buffer error that I posted on page 2 of this thread.

I can post some files but everyone will have to give me some time since I have to pack it up and upload it.

Quote:

---

Originally Posted by Ashime

@SheenBR
I haven't even touched the source code since I don't understand C++. Regarding the server files and the SQL database, I haven't fixed the characters (so I can only play the Shadow class) and I fixed the map pool for the Map folder only. I'm still trying to fix the world.txt since that controls what maps you can actually waypoint and travel to. The world.txt is giving me the buffer error that I posted on page 2 of this thread.

I can post some files but everyone will have to give me some time since I have to pack it up and upload it.

---

For the bug with the creating characters, if the code seems ok, check the mssql procedures.

Quote:

---

Originally Posted by 0x4233

For the bug with the creating characters, if the code seems ok, check the mssql procedures.

---

@0x4233
The Stored Procedure for Creating a Character looks fine to me.

Stored Procedure Code:
USE [sunonline]
GO
/****** Object: StoredProcedure [dbo].[S_CreateChar] Script Date: 12/27/2015 19:48:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/* ====================================================================================
1) Procedure Name : S_CreateChar
2) Date : 2009. 06. 25.
3) Team : UCD
-- ====================================================================================*/


ALTER Procedure [dbo].[S_CreateChar]
@userGuid int, --//??GUID
@userID varchar(12), --// ?? ??
@CharName varchar(20), --// ??? ??
@class tinyint,
@Height tinyint,
@face tinyint,
@Hair tinyint


AS
Begin


SET NOCOUNT ON
SET XACT_ABORT ON


DECLARE @result tinyint


--// ??? ???
SET @result = 0


--====================================================================================
-- ??? ???? ??
--====================================================================================
If EXISTS ( SELECT CharName FROM T_Character (nolock) WHERE CharName = @CharName )
begin
SET @result = 1 --// ?? ???? ??
GOTO ProcEnd
end


--====================================================================================
-- ??? ???? ??
--====================================================================================


If NOT EXISTS ( SELECT UserGuid FROM T_Account (nolock) WHERE UserGuid @userGuid )
begin
--====================================================================================
-- ??? ?? ? ?? ??
--====================================================================================
-- ??? ?? ??
Insert into T_Account values @userGuid @userID,0,0,0,0,0,0)
-- ?? ?? ??
insert T_Warehouse
select @userGuid,WarehouseItem,Money,pw,getdate() from T_WarehouseSet
end


--====================================================================================
-- ?? ??
--====================================================================================
Declare @g1 int, @g2 int, @g3 int, @g4 int, @g5 int, @slot int, @CharGuid int


SELECT @g1=CharGuid1, @g2=CharGuid2, @g3=CharGuid3,@g4=CharGuid4, @g5=CharGuid5 FROM T_Account (nolock) Where UserGuid = @userGuid




if @g1=0 SET @slot=0
else if @g2=0 SET @slot=1
else if @g3=0 SET @slot=2
else if @g4=0 SET @slot=3
else if @g5=0 SET @slot=4
else
begin
set @result = 2
GOTO ProcEnd
end


begin tran






-- ??? ?? ??
insert T_Character
select @userGuid @slot,ClassCode @CharName,@Height @face @Hair,Level,Strength,Dexterity,Vitality,Intelligence,Spirit,SkillStat1,SkillStat2,UserPoint,Exp,MaxHP,MaxHP,MaxMP,MaxMP,Money,RemainStat,RemainSkill,SelectedStyle,1,1,1,Region,LocationX,LocationY,LocationZ,NULL,1,0,1,InventoryItem,TmpInventoryItem,EquipItem,Skill,Quick,Style,Quest,Mission,0,0,0,0,0,0,0,0,0,0,0,0,NULL,NULL,getdate(),getdate(),getdate(),0 FROM T_CharacterSet (nolock) where CharCode @class


-- ??? ???? ??
select @CharGuid=@@IDENTITY


--====================================================================================
-- ? ?? ?? ???? ??
--====================================================================================


if( @slot=0)
begin
UPDATE T_Account SET CharGuid1 = @CharGuid
WHERE UserGuid = @userGuid
set @result=@@ERROR
GOTO TranProcEnd
end
else if( @slot =1)
begin
UPDATE T_Account SET CharGuid2 = @CharGuid
WHERE UserGuid = @userGuid
set @result=@@ERROR
GOTO TranProcEnd
end
else if( @slot = 2)
begin
UPDATE T_Account SET CharGuid3 = @CharGuid
WHERE UserGuid = @userGuid
set @result=@@ERROR
GOTO TranProcEnd
end
else if( @slot= 3)
begin
UPDATE T_Account SET CharGuid4 = @CharGuid
WHERE UserGuid = @userGuid
set @result=@@ERROR
GOTO TranProcEnd
end
else if( @slot = 4)
begin
UPDATE T_Account SET CharGuid5 = @CharGuid
WHERE UserGuid = @userGuid
set @result=@@ERROR
GOTO TranProcEnd
end




TranProcEnd: -- GOTO
if @result<>0)
begin
ROLLBACK TRAN
set @result=3
return @result
end
ELSE
begin
COMMIT TRAN
select UserGuid,CharGuid,Slot,CharName,HeightCode,FaceCode,HairCode,ClassCode,LV,Region,LocationX,LocationY,LocationZ,EquipItem
from T_Character (nolock)
where CharGuid @CharGuid


return @result
end


ProcEnd: -- GOTO
if @result<>0
return @result


SET NOCOUNT OFF
SET XACT_ABORT OFF


end

- - - Updated - - -

Server Files, Source, & Database!

Here is the Source, Server, and Database for the files I am using. I posted the client I am using in a earlier post on this thread (page 2).

PLEASE SEE THE NEW LINKS ON PAGE 5.
Download Link (Mega): [STRIKE]https://mega.nz/#!AQEnnTgC!Am483DUu6...QXr0FgwZR7OPDg[/STRIKE]

is it just me or are you missing a @ variable here?
Not sure if the variable belongs there or not but give that a shot, second, the procedure doesn't give off any errors upon execution? Something else to try is to execute it through mssql and see if it adds a character with the correct class. if it does, the issue is within the code.

of course you'll need to provide the stored procedure with some parameters.

I'll download the files on my development laptop and see what I can do to help.

Update:
Just be sure to login and check to see if it did add the character with the correct class.

-- ??? ?? ??
insert T_Character
select @userGuid @slot,@ClassCode @CharName,@Height @face@Hair,Level,Strength,Dexterity,Vitality,Intelligence,Spirit,SkillStat1,SkillStat2,UserPoint,Exp,MaxHP,MaxHP,MaxMP,MaxMP,Money,RemainStat,RemainSkill,SelectedStyle,1,1,1,Region,LocationX,LocationY,LocationZ,NULL,1,0,1,InventoryItem,TmpInventoryItem,EquipItem,Skill,Quick,Style,Quest,Mission,0,0,0,0,0,0,0,0,0,0,0,0,NULL,NULL,getdate(),getdate(),getdate(),0 FROM T_CharacterSet (nolock) where CharCode @class


Add me to skype: mindlessz0mbi3

Quote:

---

Originally Posted by 0x4233

is it just me or are you missing a @ variable here?
Not sure if the variable belongs there or not but give that a shot, second, the procedure doesn't give off any errors upon execution? Something else to try is to execute it through mssql and see if it adds a character with the correct class. if it does, the issue is within the code.

of course you'll need to provide the stored procedure with some parameters.

I'll download the files on my development laptop and see what I can do to help.

Update:
Just be sure to login and check to see if it did add the character with the correct class.

-- ??? ?? ??
insert T_Character
select @userGuid @slot,@ClassCode @CharName,@Height @face@Hair,Level,Strength,Dexterity,Vitality,Intelligence,Spirit,SkillStat1,SkillStat2,UserPoint,Exp,MaxHP,MaxHP,MaxMP,MaxMP,Money,RemainStat,RemainSkill,SelectedStyle,1,1,1,Region,LocationX,LocationY,LocationZ,NULL,1,0,1,InventoryItem,TmpInventoryItem,EquipItem,Skill,Quick,Style,Quest,Mission,0,0,0,0,0,0,0,0,0,0,0,0,NULL,NULL,getdate(),getdate(),getdate(),0 FROM T_CharacterSet (nolock) where CharCode @class


Add me to skype: mindlessz0mbi3

---

if i recall correctly, this server was in a blog called zhaogguaigan (or something like that)

the source was posted eons ago but it's very buggy (and old). i believe tuan's blog server and this server is based off that source. strange thing though is that on the zhao blog, the guy was using a berserker too, not just shadow.


now about the so called world.txt in the server. i checked the one reposted and "my current" one, the diff is pretty big though... i'll see if i get the chinese texts of me client to get it fixed, this is the only problem for connect. :laugh:

now i finally got the words working, i set as a korean region. now i'll explain:
1 - Setup server fine, no errors
2 - Wait load until it shows server screen (image under)

Spoiler:

http://i.imgur.com/RG0DVUc.jpg

3 - Type login and password, connect normally
4 - Show server screen, clicking on it show the Server1 (i guess)
5 - Click on Server1 gives error screen (image under)

Spoiler:

http://i.imgur.com/FDr5TEB.jpg

6 - Google translates weird stuff when used, even pregnant text it translated :|

Quote:

---

Originally Posted by wall57

if i recall correctly, this server was in a blog called zhaogguaigan (or something like that)

the source was posted eons ago but it's very buggy (and old). i believe tuan's blog server and this server is based off that source. strange thing though is that on the zhao blog, the guy was using a berserker too, not just shadow.


now about the so called world.txt in the server. i checked the one reposted and "my current" one, the diff is pretty big though... i'll see if i get the chinese texts of me client to get it fixed, this is the only problem for connect. :laugh:

now i finally got the words working, i set as a korean region. now i'll explain:
1 - Setup server fine, no errors
2 - Wait load until it shows server screen (image under)

Spoiler:

https://forum.ragezone.com/cache.php...%2FRG0DVUc.jpg

3 - Type login and password, connect normally
4 - Show server screen, clicking on it show the Server1 (i guess)
5 - Click on Server1 gives error screen (image under)

Spoiler:

https://forum.ragezone.com/cache.php...%2FFDr5TEB.jpg

6 - Google translates weird stuff when used, even pregnant text it translated :|

---

this may be an issue with the connectivity, I can't read what it translates but... just ensure that the connection configuration has been configured correctly. Go from there.


UPDATE:
The files are running, it's not the procedure as far as I have seen. I'll keep looking to figure out what the cause maybe to the class issue.

Anyone managed to get in?

Very nice game but these files/sources are very old (beta test i think) official server is now on episode II version 1.5.0.4.
http://i.imgur.com/3KR8LiG.jpg
http://i.imgur.com/wkW9Eat.jpg

@ashlay
I have some databases that fit for EP2 SUN but the problem with the EP2 server files is they don't work. Those files (EP2) are so complicated and hard to manage. I haven't been up to even start up the server with all the correct executables. You can use the EP2 databases with older server files like SunEmu.
@wall57
I'll try the stored procedure but the client loads all the correct information into the database. I don't see what the problem is other than maybe Style code, Skill Code, or anything similar to it. I've tried updating the Resource.wpk in the client to see if the client was the problem and the client works fine. Every time I make a character the Agent or Auth (would have to check which one is crashing again) server crashes.
@LegalSin
I can login on the client and play a character. The only problem I have came across is guild creation (which I might have fixed), maps, way points, and battle zone. Battle zone, maps, and way points don't work because the world text file is not updated which I'm also currently working on.

i have some newer files (incomplete/infected) chs files version 1204 lack some exe's or config files idk...
maybe someone have full files
http://i.imgur.com/9GPMe2p.png

@ashlay
Those are files I have never seen before but I doubt those are newer files. I have three sets of server files, SunEmu, 1007, and 1204. The only ones that work are the SunEmu and 1007. I cannot get a client to connect to the 1007 server files. The 1204 are completed but I cannot get the Auth Server, Account and DB Proxy to connect.

- - - Updated - - -
@0x4233
I tried changing the query for the S_CreateChar with the @ on ClassCode as you suggested and I received an error.
Error:
Msg 137, Level 15, State 2, Procedure S_CreateChar, Line 77
Must declare the scalar variable "@ClassCode".

The class code is coming from a table called T_CharacterSet. I checked everything in there, even compared it to the client and other databases. The data in T_CharacterSet seems fine.

- - - Updated - - -

I checked the dependencies for S_CreateChar and the dependencies are T_Account, T_Character, T_CharacterSet, T_Warehouse, and T_WarehouseSet. I checked everything in T_Account, T_Character, and T_CharacterSet and everything looked good there. I noticed there is a lot of entries on T_Warehouse. I'm going to wipe that and see if that is the problem.

- - - Updated - - -

Also, when you make a character or try to login to an account with a character besides the shadow, the Agent Server crashes.

I have fixed the database to where I can make all five characters. Now I have to figure out how to fix the characters not being able to load into the Game Server. Every time I try to load in any character besides the Shadow the Game Server crashes.

Attachment 155365

I have a ton of databases which none work for character creation or character load-in. If anyone has some databases in which one or two of the characters work, please let me know, I'm trying to compile working characters into one database. If no one has a database that can create anything besides the Shadow, then I'm looking for information to solve some of the problems I am experiencing.

I have some columns that I don't know where the data is coming from, therefore I cannot correct it accordingly. I'm pretty much guessing and checking data from a bunch of databases. Please see the picture below for column names and data. If anyone has any information about the data, please let me know. I will release the database once I get some characters fixed. Thank you!

Attachment 155389

Quote:

---

Originally Posted by Ashime

I have a ton of databases which none work for character creation or character load-in. If anyone has some databases in which one or two of the characters work, please let me know, I'm trying to compile working characters into one database. If no one has a database that can create anything besides the Shadow, then I'm looking for information to solve some of the problems I am experiencing.

I have some columns that I don't know where the data is coming from, therefore I cannot correct it accordingly. I'm pretty much guessing and checking data from a bunch of databases. Please see the picture below for column names and data. If anyone has any information about the data, please let me know. I will release the database once I get some characters fixed. Thank you!

---

isn't that hex?
anyways i used a hex editor and... meh... the skill 1st place translated to this:
`êaêkêaÄêº(over a "A")êýL(a bit crazy)º(over a "a") and a black ball... since i know so little about it i can't be sure of what does it mean, besides i could not type 0x in hex values but a search in google says it is used to refer to octal number.

and using a octal converter gave me a mess...

so far i'll try focusing on the translation of the files. i don't know any koreans that could help with the overall translation, but hey, there's google out there...

@wall57
I tried what you suggested and I couldn't get anything to work so I tried something else out. Now, I can get the characters to load in the Game Server. I noticed that guild creation, Temple of Blood, battle zone rooms, and etc don't work. So I'm going to fix the database up to where these functions work.

Attachment 155468Attachment 155469Attachment 155470Attachment 155471Attachment 155472

Anyone know anything about the world.txt file? It's in the data folder inside the server files. I'm receiving errors when I go to update the file.

Attachment 155480

The picture above is the world.txt from the data folder. The entry that is covered in a red box is the additional entry I added that is causing the buffer error. I can remove the additional entry and the Game Server will load fine.

Attachment 155481

The picture above is the error that the Game Server is giving me with the additional entry in the world.txt file. I looked up the error in the source code (see picture below).

Attachment 155482

I need help on this because the world.txt file houses all the maps in which a player can walk or waypoint to. I'm still working on the database at this current moment but I was hoping someone could offer some information or maybe help with it.

@wall57

On Tuan's server files that he composed, were you able to login on more than two maps, if so which ones?

i have the server files that got it from chinese private server....

@pengsaizhen

Can you upload and post the link to your server files? I am trying to get a set of fully working server files to release to the public. Most of these server files are incomplete. Thank you.

Quote:

---

Originally Posted by pengsaizhen

i have the server files that got it from chinese private server....

---

nice.... but, the question is: can you share it?

Quote:

---

Originally Posted by Ashime

@wall57

On Tuan's server files that he composed, were you able to login on more than two maps, if so which ones?

---

i failed to translate the error message, i'm stuck there, if i could get past it i would share the info on maps.
by the way i've tried to normal settings and using the ip on from sys.wpk my loopback adapter. fail over fail :p

@wall57

I am willing to help you if you are willing to help out in return. I know a lot but cant figure the remaining errors for the server and database. I found someone outside of Ragezone who is going to look at the database. I know why the database doesn't work for certain things but the world.txt is unknown to me.

The System.wpk houses some IPs and those are only useful if you aren't using the .bat. If you are using the .bat, you need to ignore the System.wpk. For the IP and Port in the .bat, you need to use what is in the SUNEmu or Server.ini file, which for 90% of the server files I've seen is 127.0.0.1 and 44405 unless modified.

If you are not using the .bat, you need to get a hexeditor and open up the Sungame.exe and change both IPs, one to local and the other to your external IP. Personally, I would use the .bat for now because changing the .exe can cause problems.

- - - Updated - - -

For anyone who really wants to help, I made another post in the help section. I will help you setup the server to the point of where I am at. I know where all the current problems are at and I need help fixing them.

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

I have found something rather interesting when I execute a stored procedure called S_SelectChar. The procedure requires CharGuid for it to execute and when I input the data the procedure resulted in nothing. I checked the table called T_Character and the CharGuid I input for my character was correct. If anyone can give me some pointers for this problem, that would be nice! In the meantime, I'm going to keep looking for the solution.

S_SelectChar (Stored Procedure)

USE [sunonline]
GO


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




ALTER Procedure [dbo].[S_SelectChar]
@CharGuid int


AS


SET NOCOUNT ON


begin


SELECT T_Character.UserGuid,T_Character.Slot,T_Character.ClassCode,T_Character.CharGuid,T_Character.CharName,T_Character.HeightCode,T_Character.FaceCode,T_Character.HairCode,T_Character.LV,T_Character.Strength,T_Character.Dexterity,T_Character.Vitality,T_Character.Inteligence,T_Character.Spirit,T_Character.SkillStat1,T_Character.SkillStat2,T_Character.UserPoint,T_Character.Exp,T_Character.MaxHP,T_Character.HP,T_Character.MaxMP,T_Character.MP,T_Character.Money,T_Character.RemainStat,T_Character.RemainSkill,T_Character.SelectedStyle,T_Character.PKState,T_Character.CharState,T_Character.StateTime,
T_Character.Region,T_Character.LocationX,T_Character.LocationY,T_Character.LocationZ,T_Character.TitleID,T_Character.TitleTime,T_Character.InvisibleOpt,T_Character.InventoryLock,T_Character.InventoryItem,T_Character.TmpInventoryItem,
T_Character.EquipItem,T_Character.Skill,T_Character.Quick,T_Character.Style,T_Character.Quest,T_Character.Mission,T_Character.PlayLimitedTime,T_CharacterPVP.PVPPoint,T_CharacterPVP.PVPScore,T_CharacterPVP.PVPGrade,T_CharacterPVP.PVPDraw,T_CharacterPVP.PVPSeries,T_CharacterPVP.PVPKill,T_CharacterPVP.PVPDie,T_CharacterPVP.PVPMaxKill,T_CharacterPVP.PVPMaxDie,T_GuildMain.GuildName,T_GuildMain.GuildGuid,T_GuildUsers.GuildPosition,T_GuildUsers.GuildNickName
FROM T_Character (nolock)
JOIN T_CharacterPVP ON T_Character.CharGuid = T_CharacterPVP.CharGuid
JOIN T_GuildUsers ON T_Character.CharGuid = T_GuildUsers.CharGuid
JOIN T_GuildMain ON T_GuildUsers.GuildGuid = T_GuildMain.GuildGuid
WHERE T_Character.CharGuid @CharGuid and T_Character.DelChk=0


end


SET NOCOUNT OFF


Attachment 155688


Attachment 155689

I also noticed that any buff or skill that adds a status doesn't work, so heals over time and etc, will not work.

Good news!

I have found a way to add more maps to the world but I cannot waypoint or portal to these maps! I will not release anything (no point in releasing unfinished work) until I solve the issue regarding the waypoints and portals. Here is a picture:

Attachment 155811

Anyone have source code for the wpktool? Or have any way to add files or recompile the wpk?

Quote:

---

Originally Posted by Ashime

Anyone have source code for the wpktool? Or have any way to add files or recompile the wpk?

---

i can help you on translate/unpack and repack files if you want.

Quote:

---

Originally Posted by ashlay

i can help you on translate/unpack and repack files if you want.

---

@ashlay
I have the commands for the wpktool but when i try to merge files inside the Resource.wpk it feeds back some error that doesn't translate. I would like to learn how to do this so i don't have to keep asking people to do it for me. If you want to error, let me know. If you want to post how you merge files into the Resource, I would highly appreciate it.

Oh the other note, I try what you posted on page 2 or 3 and that worked for the System.wpk only. (Yes I changed the names to the wpk for Resource).

@Ashime
modified file need to be exactly same size as original or will not work.

@ashlay
How can that be since translating certain files to English makes the file bigger naturally. I tried that too. I cut the English file down to the same size as the Chinese file and renamed it. It still didn't work. That's the same way with the English patch for Korea...those files are hundred percent translated and the size is probably not the same. Unless they are done through a different way.

- - - Updated - - -
@ashlay
I appreciate your time in responding but I'm really trying to figure this out. Any help is better than none. A simple example on how you merge your files would be nice, you can type it out like you did for the System.wpk on page two. Thank you.

@Ashime
I was playing official KR server and i have partial translated before they make an official translation.
here are last translation: EngPatch2.1

Here is an updated version of the sunonline database.
This comes with the working characters and already preloaded skills upon making a character.

There is still some preexisting problems that I'm currently still working on:
1) Cannot access warehouse
2) Cannot create guild
3) Cannot delete character
4) Cannot grant GM rights to a character

Database 'sunonline':

NAME: sunonline.rar
SIZE: 531kbs
LINK: [STRIKE]https://mega.nz/#!RYs3RYZZ!sUvSdfc7-_bamwfdeH-SxUu5wazJFh7ZwrbZEN2sW-A

[/STRIKE]INFO: Characters have been fixed so now you can load into the game server. Any skills starting out with have been added. All binary code for all the characters have been fixed. Any problems mentioned above have not been fixed yet.

Quote:

---

Originally Posted by Ashime

Here is an updated version of the sunonline database.
This comes with the working characters and already preloaded skills upon making a character.

There is still some preexisting problems that I'm currently still working on:
1) Cannot access warehouse
2) Cannot create guild
3) Cannot delete character
4) Cannot grant GM rights to a character

LINK: https://mega.nz/#!RYs3RYZZ!sUvSdfc7-_bamwfdeH-SxUu5wazJFh7ZwrbZEN2sW-A

---

Link not work

@alladyn5
Thanks for letting me know. I think I moved the file to another folder. I will edit my original post above and put the new link in. I will also check all my other links on this topic and fix them if they are broken.

I have officially updated all the links I have posted on this topic. I will be compiling everything into one massive collection so people don't have to dig through the five pages to find everything.

Here is the completed collection of files that I am using.

SUN Server Files, Database, and Source Code:

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

INFO: Contains the newer database which is still not finished. Please check the post above or on this help post (http://forum.ragezone.com/f859/onlin...files-1092227/) for the problems about the server files and database. There is PLENTY of ReadMe text files to set up the server. Please read them!

SUN Client v1007:

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

INFO: This client is completely uncompacted which comes with the wpktool and an unpacked sungame.exe for easy modification. The hack shield is bypassed and comes with a .bat file to start up the game to connect to the server.

Other Files:

Server Data Patch (only)
NAME: Updated Data v2.rar
SIZE: 738.3 MBs
LINK:https://mega.nz/#!hNECnaxI!4IXyQCM-mHDZ8hpZM5bEtKQIWYTwF9fzovOcbBdsqsI

INFO: Dump everything inside the rar into the data folder (...\SunEmu\data).

SUN Online Database (only)
NAME: sunonline.rar
SIZE: 531KBs
LINK: https://mega.nz/#!ocVGjCRZ!kK9OzVE_I6oRX0jlMsVjgeCJVcCIupH-hjVntFZGVjs

INFO: This is the updated database that is in the Server Files.rar.

Original Built-in MSSQL (Microsoft SQL 2000)
NAME: OLD SQL Server.rar
SIZE: 32.8MBs
LINK: https://mega.nz/#!FZ02jDJI!OjS9EBUpsv4urobzgBl2ycFpaAtI5732e17F7vx30sk

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 .

NOTE: I will update this as I go and may add more files. Please be aware that all these files are the same files as the ones on page 1 but altered/fixed in some way. There is plenty of things that still need to be worked on.


Main Issues:

All these issues are a work in progress and I would highly recommend anyone jumping in to help if they are up to it. Please check:http://forum.ragezone.com/f859/onlin...files-1092227/ , for any post differences as I may not keep up with one or the other. Thank you.

Database Problems:
1) Character Deletion
2) Creating Game Room for Battle Zone
3) Accessing Personal Warehouse
4) Temple of Blood is non-existing (migrate tables)

Server Files Problem(s):
1) World.txt (Buffer Error)
2) Teleporting to Areas (Related to World.txt)
3) Portaling to Areas (Related to World.txt)
4) Statuses (Heals over time, buffs, and etc don't work) *

Client Problem(s):
1) Statuses (Heals over time, buffs, and etc don't work) *

Key
* = Not sure if it's a problem with the client or server.



DISCLAIMER

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. Also, I will be uploading all of my files onto Google in due time. If anyone has any suggestions towards hosting sites similar to Google or MEGA that works best for them, please let me know.

I'm picking this project back up and I'm going to try and fix the maps.

Quote:

---

Originally Posted by JohnSmith72

Hello, I've downloaded everything and everything seems to work but at the second I launch the game I get "An error has been occurred on the anti-hacking monitor functions. (101). How to solve this? =]

---

@JohnSmith72

I had this error on one of my laptops and I could never figure out what the problem was. I would try it on another computer with a different OS or better specs. If you cannot do that then turn off your anti-virus or add the client in as an except through your firewall or anti-virus. That's all I can suggest.

@Ashime
your last sunemu release works on LAN or just local? i try to login virtual box(server) and client on host and i can't login.
you have any tool to create account?

Quote:

---

Originally Posted by ashlay

@Ashime
your last sunemu release works on LAN or just local? i try to login virtual box(server) and client on host and i can't login.
you have any tool to create account?

---

@ashlay

It works on the same computer. I haven't even tried on another computer on the same side of the router. There is a connection ip in SunEmu.ini called ' CONNECTIONIP = '. This should allow players outside to connect to the server. You may need to do port forwarding and whatever else which I can't help you with.

I have never done anything on a virtual machine for these server files. To make an account, I logging in on the SQL database through SQL Server Management Studio and edit the table called 'T_User'. If you need anymore information, let me know.

i want to help ok tell me about deleting character creating guild etc problems where we can start to fix the db

Quote:

---

Originally Posted by Ionut Alexandru

i want to help ok tell me about deleting character creating guild etc problems where we can start to fix the db

---

@Ionut Alexandru

Honestly, I don't know where to start on the database. I know that when you go to delete a character on the client side, it doesn't actually delete it, but if you do it on the database end, it will partially delete the character. I say partially delete because it removes the character from T_Account but not T_Character. So the client still reads the character info from T_Character.

Other problems with the database is you cannot access your account storage and I'm not sure what is causing the issue there. You cannot create a guild and this has something to do with the database not inputting data into T_Character and T_GuildMain. This is either an issue with the client asking and receiving incorrect requests from the DBserver itself (coding issue) or its the database stored procedure.

I'm willing to help on this matter but I'm not very good at editing or creating stored procedures for a database since I don't know the syntax or whatever very well.

Anyone have an older EP1 client by chance?

- - - Updated - - -
@ashlay

Check the SunEmu.ini under channel01 folder. There is an IP and Port listed as 127.0.0.1:44405. Try changing the IP under there and see if that helps.

I found out that the guild creation problem actually comes from the client. I got this client's Resource.wpk from a retail EP1 server (奇迹世界（SUN）官方网站|奇迹世界1（SUN1）官方网站) and they have disabled guild creation in their client. I'm going to convert this client back to a slightly older state (the9.com). I will update the link on page 5. Although warehouse access is still an issue that I'm currently working on.

Main Issues:
All these issues are a work in progress and I would highly recommend anyone jumping in to help if they are up to it. Please check: http://forum.ragezone.com/f859/onlin...files-1092227/ , for any post differences as I may not keep up with one or the other. Thank you.

Database Problems:
1) Character Deletion
2) Creating Game Room for Battle Zone
3) Accessing Personal Warehouse
4) Temple of Blood is non-existing (migrate tables)

Server Files Problem(s):
1) World.txt (Buffer Error)
2) Teleporting to Areas (Related to World.txt)
3) Portaling to Areas (Related to World.txt)
4) Statuses (Heals over time, buffs, and etc don't work) *

Client Problem(s):
1) Statuses (Heals over time, buffs, and etc don't work) *

Key
* = Not sure if it's a problem with the client or server.

I will put this list on page 5 where all the links are and will update both when someone else or I fix it...or find new problems.

Here is a patch for the data folder. I will be testing the server out to see if it fixed any of the problems in game. I will be putting this on page 5.

Updated Data v2.rar
Size: 738.3 mbs
Link: https://mega.nz/#!hNECnaxI!4IXyQCM-mHDZ8hpZM5bEtKQIWYTwF9fzovOcbBdsqsI

Quote:

---

Originally Posted by Ashime

Here is a patch for the data folder. I will be testing the server out to see if it fixed any of the problems in game. I will be putting this on page 5.

Updated Data v2.rar
Size: 738.3 mbs
Link: https://mega.nz/#!hNECnaxI!4IXyQCM-mHDZ8hpZM5bEtKQIWYTwF9fzovOcbBdsqsI

---

god djob

help :closedeyes:
Auth
[ERROR]: [26:58:14]SendPacket Error -1!
(X) 1.Error WSARecv, error code = -1

Agent
[DEBUG]: [26:58:58]CreateClientSideAcceptedObject()
Heartbeat reset!
[DEBUG]: [26:59:0][TempUser::_isAuthenticatedUser] AuthID[201595928] Auth Failed
!

Quote:

---

Originally Posted by riccokell

help :closedeyes:
Auth
[ERROR]: [26:58:14]SendPacket Error -1!
(X) 1.Error WSARecv, error code = -1

Agent
[DEBUG]: [26:58:58]CreateClientSideAcceptedObject()
Heartbeat reset!
[DEBUG]: [26:59:0][TempUser::_isAuthenticatedUser] AuthID[201595928] Auth Failed
!

---

@riccokell

Auth error is coming from the client. Are you sitting at the character selection screen that is partially faded out (black)?

If that's the case, I will upload a new client that works for me because I had that error too.

- - - Updated - - -

Quote:

---

Originally Posted by pimpa

god djob

---

@pimpa

Thank you. Feel free to test out the server.

SUN Client v1007

Attachment 156835Attachment 156836Attachment 156837

Quote:

---

Originally Posted by riccokell

SUN Client v1007

Attachment 156835Attachment 156836Attachment 156837

---

@riccokell

Did you setup the ODBC correctly? You have to make sure you can connect to the database called "sunonline" successfully. If you cannot do that, open up SQL Server Configuration Manager, enable TCP/IP under SQL Native Client 10.0 (it may differ for you) and SQL Server Network, and then double left click on TCP/IP under SQL Server Network and make sure IP (127.0.0.1) and port (1433) is enabled. Make sure the dynamic port at the bottom of that same menu is set to blank...not 0 or any other number.

If that doesn't work...I will upload my text guides and give out the new client. The client I posted before eventually gave me an authentication error and I couldn't fix it even after reinstalling SQL and the server.

Give me a few hours and I will post the new client and guides.

- - - Updated - - -

Here is an updated guide to setting up the database and etc.

DB & Server Guide
NAME: Setup Guide.rar
SIZE: 2 KBs
LINK: https://mega.nz/#!9YkDHSBQ!yOIFARllgZp1OviLBF5qy3OFA3CQomdnkpElx2Hm5x4

- - - Updated - - -

Here is the client that I am using.

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

- - - Updated - - -
@riccokell

If the problem still continues, open up Microsoft SQL Server Management Studio, expand sunonline database, open up T_Account table, delete everything in that table, open up T_Character table, and delete everything in that table. You should be able to load the character selection menu after you delete everything in those two tables.

can you make new pach for korea?aloth new staf update https://pbs.twimg.com/media/Ci5y6XuWgAEDDOq.jpg

Quote:

---

Originally Posted by pimpa

can you make new pach for korea?aloth new staf update https://pbs.twimg.com/media/Ci5y6XuWgAEDDOq.jpg

---

@pimpa

I have released v1204 server files (http://forum.ragezone.com/f857/relea...files-1101181/), you can check those out if you want. These server files cannot support a lot of EP2. You can do any EP2 client before the Mystic and you can add all of the items from EP2 if you have a repacker.

- - - Updated - - -

Quote:

---

Originally Posted by GODSKIN

คนไทยใช่ไหมครับ
ไม่ทราบว่า โหลด SUN Korea จากเวปไหนครับ
ผมโหลด ที่ handgame แต่ไม่มีไอดี

อยากทราบว่า สมัครไอดียังไงครับ

ขอบคุณครับผม

---

@GODSKIN

You can buy an account from newgameway or something like that for 12.50 (don't know the currency).

cen you giwe youre server tu test??

- - - Updated - - -

Quote:

---

Originally Posted by GODSKIN

คนไทยใช่ไหมครับ
ไม่ทราบว่า โหลด SUN Korea จากเวปไหนครับ
ผมโหลด ที่ handgame แต่ไม่มีไอดี

อยากทราบว่า สมัครไอดียังไงครับ

ขอบคุณครับผม

---

you can buy ac from tabao 3$ per ac

- - - Updated - - -

Quote:

---

Originally Posted by Ashime

@pimpa

I have released v1204 server files (http://forum.ragezone.com/f857/relea...files-1101181/), you can check those out if you want. These server files cannot support a lot of EP2. You can do any EP2 client before the Mystic and you can add all of the items from EP2 if you have a repacker.

- - - Updated - - -


@GODSKIN

You can buy an account from newgameway or something like that for 12.50 (don't know the currency).

---

me wona test server

Quote:

---

Originally Posted by pimpa

cen you giwe youre server tu test??

- - - Updated - - -


you can buy ac from tabao 3$ per ac

- - - Updated - - -


me wona test server

---

@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 am having a problem with armor and weapons becoming +12 (highest enchantment level) upon equipping to your character and once you unequip the armor and weapons they become +0 again. I've looked through the armor, weapons, accessories, and enchant text files to find nothing. I might check the database. Does anyone have a slight clue on what maybe causing this? If anyone has any tips, please let me know. Thank you.

Hi guys. I know that i write it so late but anyone have server files and client SUN online Episode II? I love this game so much and wanna to create server for playing but all links in this thread are broken. Please help me ;(

Quote:

---

Originally Posted by BloodForce

Hi guys. I know that i write it so late but anyone have server files and client SUN online Episode II? I love this game so much and wanna to create server for playing but all links in this thread are broken. Please help me ;(

---

@BloodForce

Check page 5 for the entire collection of my EP1 server files and client (middle of the page) and page 6 for newer Database/Server guide and client (middle of the page). If you want EP2 server files you will have to go here. Just be aware that those server files are only compatible up to the Mystic class and has problems.

Quote:

---

Originally Posted by Ashime

@BloodForce

Check page 5 for the entire collection of my EP1 server files and client (middle of the page) and page 6 for newer Database/Server guide and client (middle of the page). If you want EP2 server files you will have to go here. Just be aware that those server files are only compatible up to the Mystic class and has problems.

---

Thanks dude. So could you give me sunemu and text\video tutorial please (yeah, i'm noob in that). :junglejane:

Quote:

---

Originally Posted by BloodForce

Thanks dude. So could you give me sunemu and text\video tutorial please (yeah, i'm noob in that). :junglejane:

---

@BloodForce

If you download the files on page 5 there is already a lot of text guides, but for the newer ones, please download ones on page 6 (middle of the page). If you plan on using the EP2 server files, they do not come with any text guides because the server has not been able to launch successfully.

I do not plan on doing a video guide since I do not have the computer to record and launch the server with client. If you need more help, reply on this post or send me a private message (Do not request assistance over Skype - I don't do Skype period, thank you).

I am currently working on the database. At this current moment I have fixed Character Deletion and Account Creation. I have not tested any of it yet but I will soon. Here is what I'm currently working on:

1) Friends list (Adding, Blocking, and Removing)

2) Guild (Creation, Adding Members, and Deletion)

3) Character Deletion (Update Character Deletion to check if character is in Guild)

4) Password Reset (Make a stored procedure to reset password when someone has forgotten theirs)

5) Storage (Fix account storage to gain access)

6) Equipment (Find the problem and fix it...possibly add the detailed data into another table)

Please keep in mind that I will release the fixed database after I finish and test a good portion of the things on the list.

Quote:

---

Originally Posted by Ashime

@BloodForce

Check page 5 for the entire collection of my EP1 server files and client (middle of the page) and page 6 for newer Database/Server guide and client (middle of the page). If you want EP2 server files you will have to go here. Just be aware that those server files are only compatible up to the Mystic class and has problems.

---

Thx but now i've a problem with launching SUN server. When I did all what I need i tried to start AuthServer. All configurations was yours.
http://joxi.ru/8AnzywkcxadPAO.jpg

@BloodForce

What type of database are you using? Built-in MSSQL 2000, MySQL, MS SQL 2008, 2012, etc, NaviCat, or something else?

Did you setup the database correctly? Did you check to see if the server accepts TCP, Pipes, or something else?

Did you check if the server accepts certain IPs like your IPv4, local, or something else? What ports do you have setup on your SQL?

Did you setup ODBC if needed?

If you are using any IPs or ports different from 127.0.0.1: 1433 for your SQL server then you need to change it in the SUNEmu.ini.

Have you tried running the server executables under the compatibility mode for your OS? (AuthServer, DBServer, AgentServer, and GameServer).

I've setup the server for a few people all on different OS and computer specs and it works. The only thing I haven't done is run the server files under a Virtual Machine, so if you are doing that, I cannot help you.

Quote:

---

Originally Posted by Ashime

@BloodForce

What type of database are you using? Built-in MSSQL 2000, MySQL, MS SQL 2008, 2012, etc, NaviCat, or something else?

Did you setup the database correctly? Did you check to see if the server accepts TCP, Pipes, or something else?

Did you check if the server accepts certain IPs like your IPv4, local, or something else? What ports do you have setup on your SQL?

Did you setup ODBC if needed?

If you are using any IPs or ports different from 127.0.0.1: 1433 for your SQL server then you need to change it in the SUNEmu.ini.

Have you tried running the server executables under the compatibility mode for your OS? (AuthServer, DBServer, AgentServer, and GameServer).

I've setup the server for a few people all on different OS and computer specs and it works. The only thing I haven't done is run the server files under a Virtual Machine, so if you are doing that, I cannot help you.

---

>> What type of database are you using? Built-in MSSQL 2000, MySQL, MS SQL 2008, 2012, etc, NaviCat, or something else? Did you setup the database correctly? Did you check to see if the server accepts TCP, Pipes, or something else?
- I use MS SQL Server 2012 express. I think the database installed correctly (i use ur guide inside SQL Backup folder). ODBC already exist on my computer and i create data source without any problems. Other servers such as AgentServer_d and GameServer_d successfuly. I launch all servers in correct order.http://joxi.ru/5mdzZELcnlQKA1.jpg
>> Did you setup ODBC if needed?
http://joxi.ru/4AkzxYnceJD62q.jpg
All ports that server needs are opened. Help please :mellow:

@BloodForce

From what you provided it looks like a database issue or a compatibility issue.

• Did you enable TCP under Sql Server Configuration Manager?
• Did you enable 127.0.0.1 under Sql Server Configuration Manager?
• Did you change the dynamic port to a static port (1433)?

If you answered no to any or all of those then follow the steps below:

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'.

If you answered yes to the previous questions then you may need to check:

• Compatibility mode for (Auth, DB, Agent, and Game Server).
• Check to see if "sa" is enabled.
• Check to see if "sa" is defaulted to the "sunonline" database.

Here is the newest download for the DB/Server Guides.

Quote:

---

Originally Posted by Ashime

@BloodForce

From what you provided it looks like a database issue or a compatibility issue.

• Did you enable TCP under Sql Server Configuration Manager?
• Did you enable 127.0.0.1 under Sql Server Configuration Manager?
• Did you change the dynamic port to a static port (1433)?

If you answered no to any or all of those then follow the steps below:

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'.

If you answered yes to the previous questions then you may need to check:

• Compatibility mode for (Auth, DB, Agent, and Game Server).
• Check to see if "sa" is enabled.
• Check to see if "sa" is defaulted to the "sunonline" database.

Here is the newest download for the DB/Server Guides.

---

Thanks! When i enable 127.0.0.1 in SQL Server Configuration Manager mine servers started successfully! Is it usual status of servers, isn't it?
http://joxi.ru/VrwY0wvUdM3X2X.jpgSo could you give me a tip how to translate game and how to create account for connecting please?
UPD:
I founded user for login but when i do this SUN drop me an error. I use as login 123456 and pass 12345678. Is it right?
http://joxi.ru/V2V5VX9SWQXXmv.jpg

@BloodForce

I'm glad the last post helped you. I will list what you can do to create an account in the database first and then the possible solutions to fix your login error.

Account Creation:

1) Start up SQL Server Management Studio and Login.

2) Expand "sunonline" database and expand a sub-directory called "Tables".

3) Find a table called "T_User".

4) Fill in the appropriate data and click enter.
NOTE: Do not fill in the first column. The database will generate that number. The last column called "Sts" fill in "0".

Example: Some number, username, password, 0.

Now the error you are receiving on the server while trying to login is a packet error. I haven't been able to exactly figure out what is causing this error. Here a list of things to check out:

• Try this database* instead (it helped me).
• Download the newer client. (Also listed halfway down Page 6)[STRIKE]
• Check and ensure that your firewall has made an exception for the server (Auth, Agent, DB, and Game Server). This should be listed as a private connection if it was already added.[/STRIKE]

* = Database has created characters set to Lv.135 with 100M.

If you figure out how to get around this error through any other means please let me know. Thank you.

For anyone receiving "<X> 1. Error WSARecv, error code = -1" on the AuthServer.exe and "CreateClientSideAcceptObject<> Heartbeat Reset!" on the AgentServer.exe, here is the solution.

• If any changes have been done to the Stored Procedures please convert them back to their original state.
• If you received the database the way it is and you are receiving the error then reset the database back to an older version.
• If none of that works, try downloading this client. (Also listed halfway down Page 6)

Quote:

---

Originally Posted by Ashime

@BloodForce

I'm glad the last post helped you. I will list what you can do to create an account in the database first and then the possible solutions to fix your login error.

Account Creation:

1) Start up SQL Server Management Studio and Login.

2) Expand "sunonline" database and expand a sub-directory called "Tables".

3) Find a table called "T_User".

4) Fill in the appropriate data and click enter.
NOTE: Do not fill in the first column. The database will generate that number. The last column called "Sts" fill in "0".

Example: Some number, username, password, 0.

Now the error you are receiving on the server while trying to login is a packet error. I haven't been able to exactly figure out what is causing this error. Here a list of things to check out:

• Try this database* instead (it helped me).[STRIKE]
• Check and ensure that your firewall has made an exception for the server (Auth, Agent, DB, and Game Server). This should be listed as a private connection if it was already added.[/STRIKE][STRIKE]
• Download the newer client. (Also listed halfway down Page 6)[/STRIKE]

* = Database has created characters set to Lv.135 with 100M.

If you figure out how to get around this error through any other means please let me know. Thank you.

---

idk why you stroke out "Download the newer client. (Also listed halfway down Page 6)" but when i do that mine SUN run with success! http://joxi.ru/a2XWPk9SLvQ3mg.jpg
But now i need your tip! Could you help me to translate this to English? How to do that?
http://joxi.ru/KAxYEwlULOwyr8.jpg
Also why i appeared in Tringel while it isn't start city?
UPD: i can't move from city to other locations using portals.