To work on new files

[Lugapha]

Ok, so no one wants to make one so i will do it for you and get the ball rolling. The new files have some errors that need fixed to make them run. lets start with listing the errors that needs fixed

Error listings as known (updated as people find others and as they get fixed)
currently in each section we have seen these errors.


Account

• none so far, seems to run(i expect maybe something after somone logs in but not tested yet)

AccountLog

• missing procedures in the db's
  
  1. usp_Connection_getWorldUserList
     
     

     -- =============================================
     -- 0 = working
     -- -1 = error
     -- just a check?????????might need a new table for current connections or something
     -- =============================================
     ALTER PROCEDURE [dbo].[usp_Connection_getWorldUserList] 
     @nWorldNo int,
     @nRet int = 0 output
     AS
     BEGIN
     	
     	SET NOCOUNT ON;
     SET @nRet = 0
     
     	IF ISNULL(@nWorldNo,0) < 0   BEGIN
     		SET @nRet = -1
     		RETURN
     	END
     	
     SELECT  
     nUserNo
     
     FROM tAccountLog
     where nWorldNo = @nWorldNo
     End

  2. usp_Connection_setClearAll (this happens before the exe starts to do anything)
  3. usp_Connection_setClearWorld (this procedure happens after disconnecting from the world manager)

Login

• none as of this moment

Character

• missing procedure in the db's
  
  1. usp_Auction_setEnd (this one is looking for a return value in the format of int)

GameLog

• none as of this moment

World Manager

• none as of this moment

Zone

• contains 2 exe's
  
  1. 5ZoneServer2.exe
     
     • returns a minidump file(open this file with a c++ compiler add symbols from pdb)
  2. 5ServerStackObserver.exe
     
     • Unknown as to what it does and crashes if you try to run on win7. Need more info...

Client

• Havent tryed to connect yet. More info later.

This is an opertunity for this comunity to work together and make it work. Everyone will benefit this way. Please post thoughts and ideas for fixing the errors and post other errors you find along the way. I will update this as things get worked out.

Thank you for your time and effort on this project.

[MentaL]

[cieto12345]

As i tested out every server except Zone Server runs fine.
To make the Login Server work we have to write or add the procedures for AccountLog.

000127 2012-11-04 09:40:00 ERROR - CSQLPUserConnection::usp_User_Connection_getLogIn, state = 37000 error_num = 2812 error_str =

I try my best to fix the login first.

[d4xyjen]

Lugapha and I started to work on this we Planned to Bypass the errors first and then would fix it as we go its the most important steps on making the server file Run so this Script might bypass your First Problem and would lead to another one






USE [AccountLog]
GO
/****** Object: StoredProcedure [dbo].[usp_User_Connection_getLogIn] Script Date: 11/04/2012 01:03:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[usp_User_Connection_getLogIn]
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
SELECT
nUserNo,
nWorldNo
FROM tAccountLog
-- end


PS As stated Above this is not the real Stored Procedures for that Missing we Just made this to bypass the Errors so we could progress on Making the files run we would fix more later

[cieto12345]

Thanks I will continue on the files. If i fix something i will post it here :)

[xKeRnx]

To the Client:
I use the HK client
And have the Fiesta.bin converted to an exe
The TextData.shn rewritten into English.
And then connected via a Fiesta.bat!

[cieto12345]

I added your procedure and now i want to tell you what is still missing for login:

000049 2012-11-04 12:25:00 ERROR - CSQLPUserConnection::usp_User_Connection_getLogIn, state = 37000 error_num = 8146 error_str = [Microsoft][ODBC SQL Server Driver][SQL Server]Die usp_Connection_getWorldUserList-Prozedur hat keine Parameter, aber Argumente wurden bereitgestellt.

ALTER PROCEDURE [dbo].[usp_Connection_getWorldUserList]
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET NOCOUNT ON;

-- Insert statements for procedure here
SELECT nUserNo, nWorldNo FROM tAccountLog
END
-- end

This one is missing:

000035 2012-11-04 12:19:01 ERROR - CSQLPUserConnection::usp_User_Connection_setAccLogUp, state = 37000 error_num = 2812 error_str = [Microsoft][ODBC SQL Server Driver][SQL Server]Die gespeicherte Prozedur 'usp_Connection_setClearAll' wurde nicht gefunden.

[Riko]

Startin zone end in error. It seems the zone need some LUA scripts.

5ZoneServer2.exe caused an: < EXCEPTION_ACCESS_VIOLATION >
In module: 5ZoneServer2.exe at: < 0023:0059DE0F >
, luaS_newlstr()+0063 byte(s), d:\????\_jp\2012-02\2012-02-20\server\5zoneserver2\luascript\lua-5.1.4\src\lstring.c, line 0084+0004 byte(s)
--------------------------------------------------------------------------
0023:0059DE0F, 5ZoneServer2.exe,   luaS_newlstr()+0063 byte(s), d:\????\_jp\2012-02\2012-02-20\server\5zoneserver2\luascript\lua-5.1.4\src\lstring.c, line 0084+0004 byte(s)
0023:0058D051, 5ZoneServer2.exe,   lua_getfield()+0049 byte(s), d:\????\_jp\2012-02\2012-02-20\server\5zoneserver2\luascript\lua-5.1.4\src\lapi.c, line 0550+0028 byte(s)
0023:00588428, 5ZoneServer2.exe,   LuaScript::ls_FunctionCall()+0024 byte(s), d:\????\_jp\2012-02\2012-02-20\server\5zoneserver2\luascript\luascript.cpp, line 0467
0023:0055F8A9, 5ZoneServer2.exe,   ZoneServer::zs_ServiceThreadFunction()+0169 byte(s), d:\????\_jp\2012-02\2012-02-20\server\5zoneserver2\zoneserver.cpp, line 0918+0026 byte(s)
0023:750733AA, kernel32.dll,   BaseThreadInitThunk()+0018 byte(s)
0023:77629EF2, ntdll.dll,   RtlInitializeExceptionChain()+0099 byte(s)
0023:77629EC5, ntdll.dll,   RtlInitializeExceptionChain()+0054 byte(s)

I think the ???? = EC8BA4ED9689ED8C8CEC9DBC = 실행파일 = means Executable file (found that in zone server hex)

But i can't find the path to edit.

[Crystalz]

Anyone still have the Hunter Kingdom client? And is willing to upload it please? :P

[Spoon]

Anyone still have the Hunter Kingdom client? And is willing to upload it please? :P

This.

Good luck guys. The only people who are actually willing to help the community out. :')

[Crystalz]

Yeah it's nice.

[Lugapha]

i don't believe that we need to build usp_User_Connection_getLogIn. I think it is the outgoing procedure from the exe and it is looking for 1.usp_Connection_getWorldUserList. So i was trying to figure how to access the world user list and came up with this. Not tested but it does stop the error lol. We need more info on all of the procedures. like what is being sent in and what it wants returned. I just guessed on this one.
<----------------------------updated------------------------------>

 see main post

<----------------------------updated------------------------------>

[cieto12345]

Yes usp_Connection_getWorldUserList is needed as I see in logs.
For the other procedure usp_Connection_setClearAll we need an integer as return.
Not tested out but it could look like this (@nRet int OUTPUT because i saw it in logs)

ALTER PROCEDURE [dbo].[usp_Connection_setClearAll]

@nLogNo int,
@nRet int OUTPUT /* 1 = cleared? / -1 = error? */

AS
BEGIN

SET NOCOUNT ON;

SET @nRet = 1;
RETURN @nRet;

END

do not know which int server needs maybe it needs -1, 0, 1 or the lognumber

[xKeRnx]

The formal parameter "@nLogNo" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output.

[Canic]

The formal parameter "@nLogNo" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output.

USE [AccountLog]
GO
/****** Object:  StoredProcedure [dbo].[usp_Connection_setClearAll]    Script Date: 04.11.2012 17:21:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[usp_Connection_setClearAll]

@nRet int OUTPUT /* 1 = cleared? / -1 = error? */

AS
BEGIN

SET NOCOUNT ON;

SET @nRet = 1;
RETURN @nRet;

END

#Edit 1

Now we need a Procedure for usp_User_Connection_setAccLogUp

000034 2012-11-04 17:36:18 ERROR - CSQLPUserConnection::usp_User_Connection_setAccLogUp, ret(0), nRet(1)

[xKeRnx]

and The formal parameter "@nWorldUserList" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output.

no sorry :D

[Lugapha]

and The formal parameter "@nWorldUserList" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output.

no sorry :D

i don't get that error after i returned a value but we really need to find whats passing and what it should do exactly

[xKeRnx]

I had forgotten that OUTPUT

[cieto12345]

finally got that message:

000034 2012-11-04 17:29:36 ERROR - CSQLPUserConnection::usp_User_Connection_setAccLogUp, ret(-1), nRet(0)
000035 2012-11-04 17:29:36 ERROR - CSQLPUserConnection::usp_User_Connection_setAccLogUp, state = 37000 error_num = 8162 error_str = [Microsoft][ODBC SQL Server Driver][SQL Server]Der formale Parameter '@nLogNo' wurde nicht als OUTPUT-Parameter deklariert, aber der tatsächlich übergebene Parameter hat eine Ausgabe angefordert.

translated to English it means that the output value has to be "nLogNo". so i guess it does not need nRet.
i am going to continue tomorrow still have something other to do

[Lugapha]

CSQLPUserConnection::usp_User_Connection_setAccLogUp is needing a value of 0 returned to it from .usp_Connection_setClearAll in the mssql. now we know the answer but we still don't know what its trying to do. 1 returned a error

[Kreain]

Not to be a downer, but I don't see why your even trying. :p

[Lugapha]

Not to be a downer, but I don't see why your even trying. :p

why not,u guys tryed and finally got it. It is a great project to bring the community together and people can learn from everything. Trial and error can help to understand whats going on and how it works. Some tips would be nice if you want to send us in the right direction.

[xKeRnx]

000068 2012-11-04 19:00:18 <NUMBER OF 60 IOCP WORKTHREAD STARTED, 12 CPU DETECTED>
000069 2012-11-04 19:00:21 <NUMBER OF 81 SESSION WORKER STARTED>
000070 2012-11-04 19:00:21 <SUCCESSED SESSION MANAGER INIT> PG_AL_DB
000071 2012-11-04 19:00:21 <SUCCSSED LISTEN AT IP=127.0.0.1, Port=9005, BacklogCount=1 >
000072 2012-11-04 19:00:21 <MAIN THREAD START>
000073 2012-11-04 19:00:21 SERVER WORK START ---------------------------------------------------

[cieto12345]

000068 2012-11-04 19:00:18 <NUMBER OF 60 IOCP WORKTHREAD STARTED, 12 CPU DETECTED>
000069 2012-11-04 19:00:21 <NUMBER OF 81 SESSION WORKER STARTED>
000070 2012-11-04 19:00:21 <SUCCESSED SESSION MANAGER INIT> PG_AL_DB
000071 2012-11-04 19:00:21 <SUCCSSED LISTEN AT IP=127.0.0.1, Port=9005, BacklogCount=1 >
000072 2012-11-04 19:00:21 <MAIN THREAD START>
000073 2012-11-04 19:00:21 SERVER WORK START ---------------------------------------------------

even if you try to login? if yes... what did you do

hmmm... setAccLogUp, seems to be something about doing with accountlogs, and setClearAll, maybe delete something? idk, to sleepy :D

[iPaxX]

nice to see ppl on ragezone working in a team old times comming back :D

Login errors, thanks to manova :P

Blocked User IP address GameID = 86
Invalid User ID. User ID does not excist in database GameID = 89
Invalid User Password. Doesn't match with your User ID GameID = 90
Server maintenance GameID = 91
Banned User ID GameID = 92
Invalid Closed Beta Tester GameID = 93
Server Offline GameID = 93
No Connection to Server GameID = 93
UserName is too long/Forum GameID = 93

[Cyndaquil]

nice to see ppl on ragezone working in a team old times comming back :D

Login errors, thanks to manova :P

Blocked User IP address GameID = 86
Invalid User ID. User ID does not excist in database GameID = 89
Invalid User Password. Doesn't match with your User ID GameID = 90
Server maintenance GameID = 91
Banned User ID GameID = 92
Invalid Closed Beta Tester GameID = 93
Server Offline GameID = 93
No Connection to Server GameID = 93
UserName is too long/Forum GameID = 93

congratz on leaching from Victus.

At others: Good Lcuk on getting these files to work!