Printable View
well but im talking about player logs lol, i had an error talking about player logs, sp.InsertPlayerLogs , and i'm asking if u have that proc, or could u help me on how to get it...
EDIT: Wait, I found it lol, link: http://forum.ragezone.com/attachment...ql2005.sql.txt
Quote:
Originally Posted by InnerDark
but what's it????GunzDB?????
how use it??
creat new query???
how??how??how??how??
help me
creat tut
i am noob!!!!help me now help me nowQuote:
Originally Posted by jnq1234
help me now
help me now
help me now
help me now
help me now
help me now
help me nowhelp me now
Ok
1> Open Sql Studio Management
2> Delete your table SeverLog And stored Procedure InsertServerLog
3> Click New Query
4> Past this in it
5> And select your Database [GunzDB] and hit execute the red !Quote:
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ServerLog](
[ID1] [varchar](max) COLLATE Latin1_General_CI_AS NULL,
[ID2] [varchar](max) COLLATE Latin1_General_CI_AS NULL,
[ID3] [varchar](max) COLLATE Latin1_General_CI_AS NULL,
[ID4] [varchar](max) COLLATE Latin1_General_CI_AS NULL,
[ID5] [varchar](max) COLLATE Latin1_General_CI_AS NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
6> Create an new query and past this in it
7> Select your database again and hit Execute the red !Quote:
GO
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
8> Start your server and everything most be alright now.
Btw i took the procedure and table from an release of this forum, the credit go to the orginale maker,
BTW2 I use an other table and procedure, with other name not test or something
If you want to keep from having a 100GB database, you'll also want to add a delete line to remove the old entry like below:
GO
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
DELETE FROM ServerLog WHERE ID1 = @test1
INSERT INTO ServerLog (ID1,ID2,ID3,ID4,ID5) VALUES (@test1,@test2,@test3,@test4,@test5)
END
DELETE also comes in handy in some of the other table logs.
AquaLung....
.
Just a hint, you can change this:
To this, which is cleaner and it's the way you're supposed to update:Quote:
DELETE FROM ServerLog WHERE ID1 = @test1
INSERT INTO ServerLog (ID1,ID2,ID3,ID4,ID5) VALUES (@test1,@test2,@test3,@test4,@test5)
Quote:
UPDATE ServerLog SET ID2=@test2, ID3=@test3, ID4=@test4, ID5=@test5 WHERE ID1=@test1
This is true, but they will want to run the DELETE line first. If there DB already contains 200 entries in the table, UPDATE will update all 200 entries.Quote:
Originally Posted by alduath
AquaLung
.
who give me a bypass and gunz offline of gunz international
thanks you alot
Quote:
Originally Posted by Rotana
i delete SeverLog (in table) and InsertServerLog (in Procedure) and creat new query and pasted it and Execute but it has a problem same
[03/06/07 01:24:56] Release Date : Dec 19 2005
[03/06/07 01:25:07] DBMS connected
[03/06/07 01:25:07] Command registeration completed
[03/06/07 01:25:10] Match Server Created (Port:6000)
[03/06/07 01:28:10] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=0, AgentCount=0
[03/06/07 01:31:16] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=0, AgentCount=0
RealCPNet> SessionCreated=1, SessionDestroyed=0
in matchserver.exe
need creat new query???and past this==>>http://forum.ragezone.com/attachment...ql2005.sql.txt===and execute??
is it GunzDb???==i had it ((old???))
may be!!!!
press star==>run==>type((cmd))==>in Dos i typed((ipconfig)) and i see my ip????
is it ip to change FREELOGINIP in local.ini???
or go to website Geolocation IP Address to Country City Region Latitude Longitude ZIP Code ISP Domain Name Database for Developers | IP2Location™ ==>to se my ip????
but ip in Geolocation IP Address to Country City Region Latitude Longitude ZIP Code ISP Domain Name Database for Developers | IP2Location™ else ip when i do press star==>run==>type((cmd))==>in Dos i typed((ipconfig)) and i see my ip????
help pleaseQuote:
Originally Posted by jnq1234
i delete SeverLog (in table) and InsertServerLog (in Procedure) and creat new query and pasted it and Execute but it has a problem same
[03/06/07 01:24:56] Release Date : Dec 19 2005
[03/06/07 01:25:07] DBMS connected
[03/06/07 01:25:07] Command registeration completed
[03/06/07 01:25:10] Match Server Created (Port:6000)
[03/06/07 01:28:10] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=0, AgentCount=0
[03/06/07 01:31:16] GARBAGE SESSION CLEANING : ClientCount=0,
may be i fix ==>i need unpacth system.mrs in Clien (NAgunz or iGunz or LEgegame...)and copy zitem.xml and out put to matchsever foldel ==>and creat ACC (in table)==>Administrator banned and ...
then???? then???
then???? then???
then???? then???
see my problem
MMatchDBMgr::InsertQuestGameLog - No se encontr
MMatchDBMgr::InsertQuestGameLog - No se encontr