Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook pagefor updates, or we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.)
You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser.
Oh you're a true contributor! Please, someone award her a golden medal!
She's a contributor of settling your needy butt 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.
