Problem about connect to server

[nguyenhuy]

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 .

 

[Rotana]

You need to the stored procedure InsertServerLog

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

 

[nguyenhuy]

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

 

[Rotana]

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

 

[Rotana]

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

 

[Linear88]

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

 

[nguyenhuy]

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