My server's Problem

Results 1 to 11 of 11
  1. 01-05-11 #1
    qL090
    Apprentice qL090 is offline
    MemberRank
    Mar 2011 Join Date
    13Posts

    My server's Problem

    hi . I use July server pack . I have a cannot access server problem but i login with false | PASSWORD error !! ..
    Reply With Quote Reply With Quote
  2. Check out our sponsor
    My server's Problem
  3. 01-05-11 #2
     Phoenix 
      Phoenix is offline
    ModeratorRank
    Mar 2009 Join Date
    6,890Posts

    Re: My server's Problem

    Post your server.ini.
    Reply With Quote Reply With Quote
  4. 02-05-11 #3
    qL090
    Apprentice qL090 is offline
    MemberRank
    Mar 2011 Join Date
    13Posts

    Re: My server's Problem

    [DB]
    DNS=GunzDB
    USERNAME=sa
    PASSWORD=123321

    [SERVER]
    MAXUSER=100
    SERVERID="1"
    SERVERNAME=GunzServer
    ;FREELOGINIP="127.0.0.1" ; PLEASE DON'T CHANGE THIS.
    KEEPERIP=192.168.1.3
    MONITORIP=192.168.1.3
    MONITORPORT="9000"
    MODE="clan"
    COUNTRY="BRZ"
    LANGUAGE="BRZ"
    USETICKET="0"

    [LOCALE]
    DBAgentIP="127.0.0.1"
    DBAgentPort="5100"

    [FILTER]
    USE="0"
    ACCEPT_INVALID_IP="1"

    [ENVIRONMENT]
    USE_HSHIELD="0"
    USE_XTRAP="0"
    USE_EVENT="0"
    USE_MD5="0"
    USE_FILECRC="0"
    USE_RESOURCECRC32CACHECKECK="0"

    [POWERLEVELING]
    USE_POWERLEVELING_DB_BLOCK="1"
    POWERLEVELING_DB_BLOCKTIME="100000"

    [KILLTRACKER]
    USE_KILLTRACKER="1"
    MAXKILLCOUNT_ON_TRACETIME="50"
    KILLCOUNT_TRACETIME="50"

    [LOOPLOG]
    USE_LOOPLOG="1"
    MAX_LOOP_TIME_GAP="3600"
    Reply With Quote Reply With Quote
  5. 02-05-11 #4
     Phoenix 
      Phoenix is offline
    ModeratorRank
    Mar 2009 Join Date
    6,890Posts

    Re: My server's Problem

    Never seen such a messed up server.ini before. Quotes are missing everywhere.
    Use this:
    Code:
    [DB]
DNS="GunzDB"
USERNAME="sa"
PASSWORD="123321"

[SERVER]
MAXUSER="100"
SERVERID="1"
SERVERNAME="GunzServer"
;FREELOGINIP=""
KEEPERIP="192.168.1.3"
MONITORIP="127.0.0.1"
MONITORPORT="9000"
MODE="clan"
COUNTRY="BRZ"
LANGUAGE="BRZ"
USETICKET="0"

[LOCALE]
DBAgentIP="127.0.0.1"
DBAgentPort="5100"

[FILTER]
USE="0"
ACCEPT_INVALID_IP="1"

[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_MD5="0"
USE_FILECRC="0"
USE_RESOURCECRC32CACHECKECK="0"

[POWERLEVELING]
USE_POWERLEVELING_DB_BLOCK="1"
POWERLEVELING_DB_BLOCKTIME="100000"

[KILLTRACKER]
USE_KILLTRACKER="1"
MAXKILLCOUNT_ON_TRACETIME="50"
KILLCOUNT_TRACETIME="50"

[LOOPLOG]
USE_LOOPLOG="1"
MAX_LOOP_TIME_GAP="360000"
    Last edited by Phoenix; 02-05-11 at 09:14 PM.
    Reply With Quote Reply With Quote
  6. 06-05-11 #5
    qL090
    Apprentice qL090 is offline
    MemberRank
    Mar 2011 Join Date
    13Posts

    angry Re: My server's Problem

    if I enter the wrong password , I have cannot error | AGAİN
    -------------------------------------------------------------------------------
    Server.ini
    Code:
    [DB]
DNS="GunzDB"
USERNAME="sa"
PASSWORD="123321"

[SERVER]
MAXUSER="100"
SERVERID="1"
SERVERNAME="GunzServer"
;FREELOGINIP=""
KEEPERIP="192.168.1.3"
MONITORIP="127.0.0.1"
MONITORPORT="9000"
MODE="clan"
COUNTRY="BRZ"
LANGUAGE="BRZ"
USETICKET="0"

[LOCALE]
DBAgentIP="127.0.0.1"
DBAgentPort="5100"

[FILTER]
USE="0"
ACCEPT_INVALID_IP="1"

[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_MD5="0"
USE_FILECRC="0"
USE_RESOURCECRC32CACHECKECK="0"

[POWERLEVELING]
USE_POWERLEVELING_DB_BLOCK="1"
POWERLEVELING_DB_BLOCKTIME="100000"

[KILLTRACKER]
USE_KILLTRACKER="1"
MAXKILLCOUNT_ON_TRACETIME="50"
KILLCOUNT_TRACETIME="50"

[LOOPLOG]
USE_LOOPLOG="1"
MAX_LOOP_TIME_GAP="360000"
    Locator.ini
    Code:
    [DB]
DNS=GunzDB
USERNAME=sa
PASSWORD=123321

[NETWORK]
IP=192.168.1.3
PORT="8900"

[ENV]
ID="1"
LOCATOR_UID_HIGH="5"
LOCATOR_UID_LOW="0"
MAX_ELAPSED_UPDATE_SERVER_STATUS_TIME="1000"
UDP_LIVE_TIME="10000000"
MAX_FREE_RECV_COUNT_PER_LIVE_TIME="9"
BLOCK_TIME="0"
UPDATE_UDP_MANAGER_ELAPSED_TIME="3"
MARGIN_OF_ERROR_MIN="500000"
USE_COUNTRY_CODE_FILTER="no" 
ELAPSED_TIME_UPDATE_LOCATOR_LOG="3600000"
ACCEPT_INVALID_IP="1"
TEST_SERVER="0"
    Aggent.xlm
    Code:
    <?xml version="1.0" encoding="euc-kr"?>
<XML>
<AGENTCONFIG>
<NAME>GunzServer</NAME>
<MAXCLIENT>200</MAXCLIENT>
<MATCHSERVERADDRESS ip="192.168.1.3" tcpport="6000"/>
<ADDRESS ip="192.168.1.3" tcpport="7777" udpport="5100"/>
</AGENTCONFIG>
</XML>
    Reply With Quote Reply With Quote
  7. 06-05-11 #6
    GTFO
    Apprentice GTFO is offline
    MemberRank
    Apr 2011 Join Date
    24Posts

    Re: My server's Problem

    post your matchserver logs
    Reply With Quote Reply With Quote
  8. 07-05-11 #7
    gregon13
    Alpha Member gregon13 is offline
    MemberRank
    Nov 2007 Join Date
    CanadaLocation
    1,945Posts

    Re: My server's Problem

    Locator.ini
    Code:
    [DB]
DNS="GunzDB"
USERNAME="sa"
PASSWORD="123321"

[NETWORK]
IP="192.168.1.3"
PORT="8900"

[ENV]
ID="1"
LOCATOR_UID_HIGH="5"
LOCATOR_UID_LOW="0"
MAX_ELAPSED_UPDATE_SERVER_STATUS_TIME="1000"
UDP_LIVE_TIME="10000000"
MAX_FREE_RECV_COUNT_PER_LIVE_TIME="9"
BLOCK_TIME="0"
UPDATE_UDP_MANAGER_ELAPSED_TIME="3"
MARGIN_OF_ERROR_MIN="500000"
USE_COUNTRY_CODE_FILTER="no" 
ELAPSED_TIME_UPDATE_LOCATOR_LOG="3600000"
ACCEPT_INVALID_IP="1"
TEST_SERVER="0"
    if I enter the wrong password , I have cannot error | AGAİN
    also enter the right password and you can connect lol
    Last edited by gregon13; 07-05-11 at 03:47 PM.
    Reply With Quote Reply With Quote
  9. 08-05-11 #8
    qL090
    Apprentice qL090 is offline
    MemberRank
    Mar 2011 Join Date
    13Posts

    sad Re: My server's Problem

    MatchServer Log
    Code:
    Load XML from memory : strings.xml(0x0037) - SUCCESS
Load XML from memory : cserror.xml(0x0037) - SUCCESS
MMatchEventFactoryManager::ParseEvent - Event.xml¿¡ ¾ø´Â Event ID(2)ÀÔ´Ï´Ù.
MMatchEventFactoryManager::ParseEvent - Event.xml¿¡ ¾ø´Â Event ID(3)ÀÔ´Ï´Ù.
MMatchEventFactoryManager::ParseEvent - Event.xml¿¡ ¾ø´Â Event ID(2)ÀÔ´Ï´Ù.
MMatchEventFactoryManager::ParseEvent - Event.xml¿¡ ¾ø´Â Event ID(3)ÀÔ´Ï´Ù.
[05/07/11 11:25:05] DBMS connected

[05/07/11 11:25:05] Command registeration completed


10
MBMatchServer::AddClanServerSwitchDownSchedule - make close clan mode schedule success. next close clan mode time is 11-5-31 23:50

10
Inited client file list (1)
Start GambleItem Init.
End GambleItem Init.

Start shop GItem list log.
GambleItemCount : 0.
End shop GItem list log.


=== Dump GambleItem Info. ===
Gamble item list.

Send shop gamble item list.
Shop gamble item count : 0
=== Completed Dump GambleItem Info. ===

success init security.
FILE PATH : D:\GunzServer\MatchServer\MD5HashValue.txt
MD5 Hash Value => 2c 04 05 30 70 71 a1 d7 86 dd 95 dc c6 38 8c d3 

================================== Server configure info ==================================
[05/07/11 11:25:06] Release Date : Jul 21 2008
[05/07/11 11:25:06] X-Trap Off
[05/07/11 11:25:06] MD5 Check Off
[05/07/11 11:25:06] Loop Log Save On - Time Gap : (360000)
[05/07/11 11:25:06] Server Country : BRAZIL
[05/07/11 11:25:06] Command version : (57)
[05/07/11 11:25:06] Event usable state : (false)
[05/07/11 11:25:06] Load event size : (0)
[05/07/11 11:25:06] FileCRCCheckSum usable state : (false)
[05/07/11 11:25:06] FileCRC size : (1)
[05/07/11 11:25:06] Country Code Filter usalbe state : (false)
[05/07/11 11:25:06] Accept Invalied IP state : (true)
[05/07/11 11:25:06] Keeper IP : (192.168.1.3)
[05/07/11 11:25:06] Monitor IP : (127.0.0.1)
[05/07/11 11:25:06] Ticket use : 0

===========================================================================================

[05/07/11 11:25:06] Match Server Created (Port:6000)

[05/07/11 11:25:27] Start agent Register (CommUID 0:10) IP:192.168.1.3, TCPPort:7777, UDPPort:5100
 
[05/07/11 11:25:27] Agent Added (UID:010)
[05/07/11 11:25:27] Agent Registered (CommUID 0:10) IP:192.168.1.3, TCPPort:7777, UDPPort:5100
 
[05/07/11 11:30:06] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1, CommandPool=4, objHistoryCount=2

MMatchDBMgr::GetAccountInfo - Must declare the scalar variable "@aid".

MMatchDBMgr::UpdateAccountLastLoginTime - Error converting data type numeric to int.

MMatchDBMgr::GetAccountInfo - Must declare the scalar variable "@aid".

MMatchDBMgr::UpdateAccountLastLoginTime - Error converting data type numeric to int.

MMatchDBMgr::GetAccountInfo - Must declare the scalar variable "@aid".

MMatchDBMgr::UpdateAccountLastLoginTime - Error converting data type numeric to int.

MMatchDBMgr::GetAccountInfo - Must declare the scalar variable "@aid".

MMatchDBMgr::UpdateAccountLastLoginTime - Error converting data type numeric to int.
    Last edited by qL090; 08-05-11 at 02:20 AM.
    Reply With Quote Reply With Quote
  10. 08-05-11 #9
     Phoenix 
      Phoenix is offline
    ModeratorRank
    Mar 2009 Join Date
    6,890Posts

    Re: My server's Problem

    Execute this on your database:

    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
    Reply With Quote Reply With Quote
  11. 12-05-11 #10
    qL090
    Apprentice qL090 is offline
    MemberRank
    Mar 2011 Join Date
    13Posts
    Quote Originally Posted by Phoenix View Post
    Execute this on your database:

    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
    This code wasn't work ..
    i opened new quary and,copy this code,..
    press excute but it wasn't ok .. You say lessproblemdb than my db ??
    Reply With Quote Reply With Quote
  12. 13-05-11 #11
    qL090
    Apprentice qL090 is offline
    MemberRank
    Mar 2011 Join Date
    13Posts

    Re: My server's Problem

    Msg 137, Level 15, State 2, Procedure spGetAccountInfo, Line 14
    Must declare the scalar variable "@aid".
    Reply With Quote Reply With Quote


« Previous Thread | Next Thread »

Advertisement