Zoneserver logging

Joined
Oct 6, 2009
Messages
965
Reaction score
137
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.
 
Last edited:
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
 
Hi

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

Rgs
A3Elements - GMToreto
 
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"
Code:
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
zslog - Zoneserver logging - RaGEZONE Forums

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 :thumbup1:


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

Attachments

  • logsampl - Zoneserver logging - RaGEZONE Forums
    logsample.webp
    17.3 KB · Views: 433
Last edited:
Yep.....THanks Chriss......I will also Start up with soem Dev with A3.....for RZ guys in July Hope the Luck Supports..

:D


BTW Thanks For THis :-)
 
Luck? What's luck got to do with dev?


a) "If I get lucky I will make a be ter GM tool"

or

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