Problem about connect to server

Results 1 to 7 of 7
  1. #1
    Account Upgraded | Title Enabled! nguyenhuy is offline
    MemberRank
    May 2006 Join Date
    Việt NamLocation
    744Posts

    Post Problem about connect to server

    Log :
    [03/08/07 12:06:16] Release Date : Dec 19 2005

    [03/08/07 12:06:20] DBMS connected
    [03/08/07 12:06:20] Command registeration completed
    [03/08/07 12:06:20] Match Server Created (Port:6000)
    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    [03/08/07 12:09:21] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=0, AgentCount=0
    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    [03/08/07 12:12:21] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=0, AgentCount=0
    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    [03/08/07 12:15:21] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=0, AgentCount=0
    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    [03/08/07 12:18:21] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=0, AgentCount=0
    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    [03/08/07 12:21:21] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=0, AgentCount=0
    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    [03/08/07 12:24:21] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=0, AgentCount=0
    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

    [03/08/07 12:27:21] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=0, AgentCount=0
    MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.
    server.ini :
    ;HACKED BY CHINA GAMERS FOR RAGEZONE!

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

    [SERVER]
    MAXUSER=2000
    SERVERID=4
    SERVERNAME="Admin"
    FREELOGINIP="222.255.122.20"
    MODE="test"

    [LANGUAGE]
    LANG_TYPE="eng"
    config.xml ( in client ) :
    <?xml version="1.0"?>
    <XML>
    <SERVER>
    <IP>222.255.122.20</IP>
    <PORT>6000</PORT>
    </SERVER>

    <SKIN>Default</SKIN>

    <VIDEO>
    <WIDTH>1024</WIDTH>
    <HEIGHT>768</HEIGHT>
    <COLORBITS>32</COLORBITS>
    <GAMMA>426</GAMMA>
    <FULLSCREEN>TRUE</FULLSCREEN>
    <REFLECTION>true</REFLECTION>
    <LIGHTMAP>true</LIGHTMAP>
    <DYNAMICLIGHT>true</DYNAMICLIGHT>
    <SHADER>false</SHADER>
    <CHARACTORTEXTURELEVEL>0</CHARACTORTEXTURELEVEL>
    <MAPTEXTURELEVEL>0</MAPTEXTURELEVEL>
    <EFFECTLEVEL>0</EFFECTLEVEL>
    <TEXTUREFORMAT>1</TEXTUREFORMAT>
    <NHARDWARETNL>false</NHARDWARETNL>
    </VIDEO>

    <AUDIO>
    <BGM_MUTE>false</BGM_MUTE>
    <BGM_VOLUME>0.405400</BGM_VOLUME>
    <EFFECT_MUTE>false</EFFECT_MUTE>
    <EFFECT_VOLUME>0.256700</EFFECT_VOLUME>
    <SOUND_3D>1</SOUND_3D>
    <A8BITSOUND>false</A8BITSOUND>
    <INVERSESOUND>true</INVERSESOUND>
    <HWMIXING>true</HWMIXING>
    <HITSOUND>true</HITSOUND>
    </AUDIO>

    <MOUSE>
    <SENSITIVITY>0.391900</SENSITIVITY>
    <INVERT>FALSE</INVERT>
    </MOUSE>

    <KEYBOARD>
    <FORWARD>17</FORWARD>
    <BACK>31</BACK>
    <LEFT>30</LEFT>
    <RIGHT>32</RIGHT>
    <MELEEWEAPON>2</MELEEWEAPON>
    <PRIMARYWEAPON>3</PRIMARYWEAPON>
    <SECONDARYWEAPON>4</SECONDARYWEAPON>
    <ITEM1>5</ITEM1>
    <ITEM2>6</ITEM2>
    <PREVOUSWEAPON>16</PREVOUSWEAPON>
    <NEXTWEAPON>18</NEXTWEAPON>
    <RELOAD>19</RELOAD>
    <JUMP>57</JUMP>
    <SCORE>15</SCORE>
    <MENU>1</MENU>
    <TAUNT>41</TAUNT>
    <BOW>7</BOW>
    <WAVE>8</WAVE>
    <LAUGH>9</LAUGH>
    <CRY>10</CRY>
    <DANCE>11</DANCE>
    <SCREENSHOT>88</SCREENSHOT>
    <RECORD>87</RECORD>
    <DEFENCE>29</DEFENCE>
    <TOGGLECHAT>47</TOGGLECHAT>
    </KEYBOARD>

    <MACRO>
    <F1></F1>
    <F2></F2>
    <F3></F3>
    <F4></F4>
    <F5></F5>
    <F6></F6>
    <F7></F7>
    <F8></F8>

    </MACRO>

    <ETC>
    <NETWORKPORT1>7700</NETWORKPORT1>
    <NETWORKPORT2>7800</NETWORKPORT2>
    <BOOST>FALSE</BOOST>
    <REJECT_NORMALCHAT>FALSE</REJECT_NORMALCHAT>
    <REJECT_TEAMCHAT>FALSE</REJECT_TEAMCHAT>
    <REJECT_CLANCHAT>FALSE</REJECT_CLANCHAT>
    <REJECT_WHISPER>FALSE</REJECT_WHISPER>
    <REJECT_INVITE>FALSE</REJECT_INVITE>
    <CROSSHAIR>0</CROSSHAIR>
    </ETC>


    <BINDS>
    </BINDS>
    </XML>
    Ok Plz help me if u can :). Thanks before ( plz dont spam here .)
    I used ijji client and v2patch from legacy . I tried ip 127.0.0.1 but the seem TT_TT .


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

    Re: Problem about connect to server

    You need to the stored procedure InsertServerLog

    Look at the other topic here, There you can find the procedures for insertserverlog

  3. #3
    Account Upgraded | Title Enabled! nguyenhuy is offline
    MemberRank
    May 2006 Join Date
    Việt NamLocation
    744Posts

    Re: Problem about connect to server

    can you post that query to import ? ah , if u can , plz share your db for me . i'm trying a gunz sv so i'm noob here TT_TT . Hope you'll help me

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

    Re: Problem about connect to server

    use this one.

    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO

    CREATE PROCEDURE [dbo].[spInsertServerLog]
    @test1 varchar(MAX),
    @test2 varchar(MAX),
    @test3 varchar(MAX),
    @test4 varchar(MAX),
    @test5 varchar(MAX)
    AS
    BEGIN
    INSERT INTO ServerLog (ID1,ID2,ID3,ID4,ID5) VALUES (@test1,@test2,@test3,@test4,@test5)
    END
    and make sure that you have the table serverlog

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

    Re: Problem about connect to server

    You can better use the one in the other topic, because this one will insert every time a new one, the other updates it

  6. #6

    Re: Problem about connect to server

    You're using the client from IJJI Gunz??? Use the december client from IGunz.

  7. #7
    Account Upgraded | Title Enabled! nguyenhuy is offline
    MemberRank
    May 2006 Join Date
    Việt NamLocation
    744Posts

    Re: Problem about connect to server

    thank all , i remember what you said . I'll try my best :).



Advertisement