Zoneserver logging

[chrissdegrece]

Guys, I have found the way to capture the Zoneserver,Mainserver,Accountserver log messages.

"A3 Agent" , is half way complete and will be released soon I hope.

I have a small prob with some "useless" messages which are sent periodically , 40-50 messages simultaneously, which cause "A3 Agent" to throw exception errors.

I hope that I will fix that soon and release the app.

*** Changelog ***
- Removed the grids and all "visual" controls
- Log is kept in MS-SQL, this allows everyone to build its own custom app which processes the events.

For example:
It will be very easy to display in web page , which players are logged on.

 

[VARUN]

good work bro i am planning to get back to dev and will soon release a stable relese in 3-4 weeks of time with Many scripts and all

 

[getdeepz]

Hi

Its better if u split it up in different list boxes , it ll be easy to segregate and looks better.

Rgs
A3Elements - GMToreto

 

[chrissdegrece]

App logic changed, I updated the 1st post in this thread, check it out!

 

[onyourrisk]

Seems More reliable bro

 

[chrissdegrece]

Finally released, it's not "production quality" but it seems that it's usable.

!!!Read the installation instructions below!!!!


You need microsoft .Net for this tool to run.

I N S T A L L A T I O N.......I N S T R U C T I O N S
-----------------------------------------------------

1) Unzip in a folder in your server
2) create a database in your sql server named "a3log"
3) Create a table named "rawlog"

USE [a3log]
GO
/****** Object:  Table [dbo].[rawlog]    Script Date: 02/23/2010 20:53:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[rawlog](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[logdatetime] [datetime] NOT NULL CONSTRAINT [DF_rawlog_logdatetime]  DEFAULT (getdate()),
	[logtext] [varchar](1000) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

4) create an SQL server login "a3log" with password "a3log"
5) create a user named a3log in a3log database which is mapped to the loginname "a3log" with "db_owner" permissions.
6) Create an ODBC DSN named .... "a3log"
7) Run A3Logger.exe BEFORE starting your Zoneserver
8) Edit zoneserver svrinfo.ini and set:

GameLogServerIP = the ip of your server
GameLogServerPort = 8081

9) Start zoneserver, if it found A3Agent it will display a message:
"Connect LogServer OK: <your ip> 8081


Otherwise it will just give you an error message!

10) Login to game and do something , drop items, pickup, buy items, and then quit game
11) Open SQL Mgmt Studio and go to a3log db
12) Open the rawlog table
13) Enjoy


http://forum.ragezone.com/attachments/f98/86011d1299180563-zoneserver-logging-a3logger.zip

 

[onyourrisk]

This is one of awaited release . Thanks will try soon .

 

[chrissdegrece]

Hope you ppl find it useful

 

[wxrbbs]

Hope you ppl find it useful

 

[sammy159]

Yep.....THanks Chriss......I will also Start up with soem Dev with A3.....for RZ guys in July Hope the Luck Supports..




BTW Thanks For THis

 

[onyourrisk]

Luck = Your efforts meets a chance ... so try your best and let us know about your dev. work

 

[chrissdegrece]

Luck? What's luck got to do with dev?


a) "If I get lucky I will make a better GM tool"

or

b) If I am luckier than Chriss then I make an ingame rebirth system

 

[GDTE]

7) Run A3Logger.exe BEFORE starting your Zoneserver <---

where is a3logger.exe? -_-;;;

 

[menaceisin]

good work bro i am planning to get back to dev and will soon release a stable relese in 3-4 weeks of time with Many scripts and all

Tht will be too nice. we will w8ing for cool releases.

 

[chrissdegrece]

OnYourRisk, post the logger re. I can't find it

 

[chrissdegrece]

Re-upload

 

[Hunterzzz]

can you upload the source code of the same

 

[Prot]

can you upload the source code of the same

You are just 10 Years late to ask.

 

[Aa123456]

Luck? What's luck got to do with dev?


a) "If I get lucky I will make a be

You must be registered to see links

ter GM tool"

or

b) If I am luckier than Chriss then I make an ingame rebirth system

 

[TheCruel]

You try to start creating an A3Logger project from this file.
View attachment A3Logger.Form1.txt