I had cannot Acccess server Error
-----------------------------------
-----------------------------------------------Code:nhn server mode is real Load XML from memory : strings.xml(0x0037) - SUCCESS Load XML from memory : cserror.xml(0x0037) - SUCCESS [08/13/11 10:05:58] DBMS connected [08/13/11 10:05:58] Command registeration completed 10 MBMatchServer::AddClanServerSwitchDownSchedule - make close clan mode schedule success. next close clan mode time is 11-8-31 23:50 10 Inited client file list (1) success init security. FILE PATH : C:\Documents and Settings\Administrator\Desktop\DestinityFiles\Gunz ServerFiles Rev 5\MatchServer\MD5HashValue.txt MD5 Hash Value => 6e ff 40 c1 22 1e 4b 2b 33 ce 22 41 7d c4 3a 3d ================================== Server configure info ================================== [08/13/11 10:05:58] Release Date : Jun 13 2007 [08/13/11 10:05:58] X-Trap Off [08/13/11 10:05:58] MD5 Check Off [08/13/11 10:05:58] Server Country : BRAZIL [08/13/11 10:05:58] Command version : (56) [08/13/11 10:05:58] Event usable state : (false) [08/13/11 10:05:58] Load event size : (1) [08/13/11 10:05:58] FileCRCCheckSum usable state : (false) [08/13/11 10:05:58] FileCRC size : (1) [08/13/11 10:05:58] Country Code Filter usalbe state : (false) [08/13/11 10:05:58] Accept Invalied IP state : (true) [08/13/11 10:05:58] Keeper IP : (188.132.229.68) [08/13/11 10:05:58] Monitor IP : (127.0.0.1) =========================================================================================== [08/13/11 10:05:58] Match Server Created (Port:6000) success to update CustomIP MMatchDBMgr::GetAccountInfo - Must declare the scalar variable "@aid". MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'. MMatchDBMgr::UpdateAccountLastLoginTime - Error converting data type numeric to int. MMatchDBMgr::GetAccountInfo - Must declare the scalar variable "@aid". MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'. MMatchDBMgr::UpdateAccountLastLoginTime - Error converting data type numeric to int. MMatchDBMgr::GetAccountInfo - Must declare the scalar variable "@aid". MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'. MMatchDBMgr::UpdateAccountLastLoginTime - Error converting data type numeric to int. RealCPNet> SessionCreated=6, SessionDestroyed=5
@aid Scaler init Error
i Excute
but error :Code:GO /****** Object: StoredProcedure [dbo].[spGetAccountInfo] Script Date: 02/01/2011 20:15:07 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROC [dbo].[spGetAccountInfo] @AID int , @ServerID int = 0 AS BEGIN SET NOCOUNT ON SELECT AID, UserID, UGradeID, Name, HackingType , DATEPART(yy, EndHackingBlockTime) AS HackBlockYear, DATEPART(mm, EndHackingBlockTime) AS HackBlockMonth , DATEPART(dd, EndHackingBlockTime) AS HackBlockDay, DATEPART(hh, EndHackingBlockTime) AS HackBlockHour , DATEPART(mi, EndHackingBlockTime) AS HackBlockMin FROM Account(NOLOCK) WHERE AID = @AID update Account set LastLoginTime = getdate(), ServerID = @ServerID where aid = @aid END
i use Rev5 FilesCode:Msg 137, Level 15, State 2, Procedure spGetAccountInfo, Line 14 Must declare the scalar variable "@aid".
who will help me , i gift VPS



Reply With Quote

