How much is the interest on a Player Stats Script ?

[Mirio]

The links do work for me.

is there "not" missing?

[Urmel]

The links do work for me.

is there "not" missing?

Yesterday they didn't, today they redo.

[[-z-]]

Okay I was able to see it today. I'd definitely be interested in this code. Particularly the database design.

[Kaworru]

Okay I was able to see it today. I'd definitely be interested in this code. Particularly the database design.

There is no Database behind this the Perlscript simple parse the Logfile and generate the static HTML files.

[Kaworru]

Released the first public Version, please take a look in the other Thread about this.

[[-z-]]

Okay I was able to see it today. I'd definitely be interested in this code. Particularly the database design.

There is no Database behind this the Perlscript simple parse the Logfile and generate the static HTML files.

Damn . I have the first hunk of already written in php. I need a database behind it.

[Kaworru]

Mhhhhhh why you need a Database behind this ?

The Logfiles are not realy big and so you can parse then without a problem.
I think my parser used another logfile its simple used the "server.log" as your parser.

But its also no problem to parse the data to a database, but you need also to parse the hole server.log to update the database.

When it help you i will make a database plugin for the next version so that you can put the data in html or in a database.

For for me it make no realy sense to used a database for this.
The it would be better to rewrite the server source to put the score direct in the database.

The main problem is, that you dont have a timestamp and so you cant realy say the database keep data from the timestamp and the logfile have new data after timestamp....

It would be possible but no so simple, because you need such a timestamp for each player ^^° and need to compare this which each timestamp in the logfile.

[The mysterious Mr. 4m]

The links do work for me.

"No error occured."

Thanks for noticing!

[Dokujisan]

Mhhhhhh why you need a Database behind this ?

First thought that came to my mind is the ability to delete or rename the log file after each parse and then the next parse would append the new log data into the database and then delete the log again and the cycle continues. I would think it would be faster to do this than to parse a 200MB log file each day for the data. Or maybe I'm misunderstanding exactly how your script works? Do you have a data container that can be easily appended each day with fresh data? My understanding is that it's going straight from log to HTML, correct?

The second thought I had is that using a database could allow more easily tying in the data to another database driven app, like a forum. I'm thinking something like displaying a player's stats under their profile.

[Kaworru]

Hi,
the problem there is when you delete the logfile and only parse them to the database you can only used simple statistic for that.

Because in the parse data you dont see, which player has killed with player how often and so you can only make a statistic about simple thing like general kills and deaths and so on.

But you can't make a relation ship between events without copy the data 1:1 to the database.

So when you need such a relation ship between players its simpler to parse the hole logfile and write the output data to the database.

I also writing a logfile compressor which read out the important infos and used a timestamp to parse only new data to it so your logfile is compressed and small, but this is not finished yet.

But it has no sense to put the hole logfile into the database to get such a relation ship.
Because the Database is only a big text file (mysql) with a special struction and so you can simple used the logfile insteat.

Its has sense to put the parse Data into a Database to used this in a Community Board, but i would not recommended to copy the Logfile 1:1 into a Database and then calculate the score or relation ships between events.