Oh you're a true contributor! Please, someone award her a golden medal!
She's a contributor of settling your needy ass down.
Sorry that we don't want kids like you advertising on other servers forums, something I suspect you would do.
Invalid hash most likley means a proper connection is not being set up with the server.
When we tested MMOP, whenever the server was down it was stuck on hashing.
Good luck on making a server, you will need alot plus more.
2012/10/21 01:08:50 - usp_getuserinfo error : [Microsoft][SQL Server Native Client 10.0][SQL Server]there is no UserInfo
2012/10/21 01:08:50 - usp_license_getUserLicenseDetailInfoByNickname error : [Microsoft][SQL Server Native Client 10.0][SQL Server]not user
2012/10/21 01:08:53 - !!!!!!!!! Can't get community server list
2012/10/21 01:08:54 - usp_getuserinfo error : [Microsoft][SQL Server Native Client 10.0][SQL Server]there is no UserInfo
2012/10/21 01:08:54 - usp_license_getUserLicenseDetailInfoByNickname error : [Microsoft][SQL Server Native Client 10.0][SQL Server]not user
2012/10/21 01:09:03 - !!!!!!!!! Can't get community server list
2012/10/21 01:09:05 - Hash Reload OK.
2012/10/21 01:09:06 - Max query : name(usp_getCurrentGameMoney), time(41), query(usp_getCurrentGameMoney usernum(int)(3393) )
2012/10/21 01:09:11 - usp_logout error : [Microsoft][SQL Server Native Client 10.0][SQL Server]Procedure or function usp_logout has too many arguments specified.
Edit the tables like KillerStefan said.
It's pretty straightforward.
If you're using the latest koreaTest files (and possibly other files), that is 2012-03-02_1_koreaTest.zip, a stored procedure won't work correctly.
To fix it, you should execute this, to alter the procedure:
Code:
USE [talesrunner]
GO
/****** Object: StoredProcedure [dbo].[usp_startRoomServer] Script Date: 03/03/2012 21:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/*****************************************************************************
Name:
Desc:
Return-values:
Parameters:
Input
----------------------------
Output
----------------------------
Auth:
Date:
Version:
******************************************************************************
Change History
******************************************************************************
Date: 2011.11.23
----------------------------
Author: Kim SangUk
----------------------------
Description: 룸 서버가 켜질때 유저의 팜 리스트 정보의 룸 서버 번호와, 룸 핸들 값을 초기화 한다
----------------------------
******************************************************************************
Date: 2012.01.31
----------------------------
Author: Kim SangUk
----------------------------
Description: 각 서버별 팜 캐시 최대치 추가
----------------------------
******************************************************************************/
ALTER PROCEDURE [dbo].[usp_startRoomServer]
@ip varchar(20),
@port int
AS
SET NOCOUNT ON
EXEC dbo.usp_LogTranCount @@procid
declare @roomservernum int;
declare @farmCacheMax int;
declare @limitRoomCount int;
select @roomservernum = fdNum, @farmCacheMax = fdFarmCacheMax, @limitRoomCount = fdLimitRoomCount
from tblServerListRoomSvr with (nolock)
where fdServerIP = @ip and
fdServerPort = @port;
update tblServerListRoomSvr
set fdStartServerDateTime = getdate()
where fdServerIP = @ip and
fdServerPort = @port;
update tblUserFarmList set fdRoomServerNum = 0, fdRoomHandle = 0, fdCacheRoomServerNum = 0
where fdRoomServerNum = @roomservernum
if @roomservernum is null
begin
raiserror('cannot find proper server', 16, 1);
return;
end
else
select servernum = @roomservernum,
farmCacheMax = @farmCacheMax,
limitRoomCount = @limitRoomCount,
dbtime = getdate();
That should be all you need to make the servers start without problems.
