I want HELP !

Results 1 to 2 of 2
  1. #1
    Novice destinity is offline
    MemberRank
    Aug 2011 Join Date
    2Posts

    I want HELP !

    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
    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
    but error :
    Code:
    Msg 137, Level 15, State 2, Procedure spGetAccountInfo, Line 14
    Must declare the scalar variable "@aid".
    i use Rev5 Files
    who will help me , i gift VPS
    Last edited by destinity; 13-08-11 at 12:15 PM.


  2. #2
    The beer?? Its here !!! Rotana is offline
    MemberRank
    Jan 2007 Join Date
    The NetherlandsLocation
    1,733Posts

    Re: I want HELP !

    Change
    Code:
    update Account set LastLoginTime = getdate(), ServerID = @ServerID  where aid = @aid
    To
    Code:
    update Account set LastLoginTime = getdate(), ServerID = @ServerID  where AID = @AID
    I hope i helped you. Do i get an VPS now??



Advertisement