Release: UTStats Beta 4

[toa]

Originally Posted by altgamer

pics problem.. heh.
one of my friends said it's because i'm running on a windows server with IIS 6.0, it doesnt recognize the /0/164/9/.jpg and makes it invalid, when going to it, it says invalid input file, which is the same error given when its not found.

Yes, that seems to be the problem.
You can access the picture using 'normal' parameters: http://s1.rivalflame.com/pic.php?num=0&pid=164&gid=9. However, since boards seem to have problems with '?' and '&' in picture URLs, we decided to use PATH_INFO.
A quick google search turned up this page: http://msdn.microsoft.com/library/en...035b5d65c9.asp. Dunno if that helps, but it might be worth a try
Another approach would be to use something similar to Apache's mod_rewrite. But I don't know whether IIS offers such features!?

Edit: I did not forget about your other post. I'm looking into it

[toa]

Originally Posted by PizzaMan

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'BETWEEN ip_from AND ip_to' at line 1

That's a strange error
Could you mail me the log please?

[PizzaMan]

Sent.

[toa]

Originally Posted by PizzaMan

Sent.

Thx. Problem was that this player had no IP address logged. I mailed you a quickfix and we'll have a look at the log again.

[PizzaMan]

Import works now, but suddenly DM-Deck16][ is listed twice: http://www.stats.uks-forums.com/?p=m...ount&sort=DESC

Would that have anything to do with this fix?

[[RZA]Frenzy]

Log file Sent...

Thank you!

[fugley]

Wooooooooo very nice forethought or possibly seen before but I love it …
Our server spat the dummy last night with one or two crashes and upon getting up this morning I found the stats page logging the same server setup as before but with instantgib in brackets which made for a whole new rankings table. Where I thought I’d have a play in the admin panel before coming here for help and found the Add/Edit Game Types and went for gold and merge the two, then recalculated the rankings. Very Nice

Although it opened up one question, when doing anything like this and maybe more when merging player names do you have to recalculate rankings ? i had merge one or two player names before, but never recalculated the rankings only to find they were a little upset to see they went from top 10 to bottom 400, although these ppls have now come right after this recalculation with no new games played

[PizzaMan]

I think the BB code report should start with the map name on top, you cant tell which map it was without clicking the link:

Red Team Lineup
{CEC}gAnDaLf
~{CEC}Doggy
~{CEC}Enfant_de_solo
~{CEC}JujuBickoille
~{CEC}ParadoX

Blue Team Lineup
[DB]$aphod
[DB]Clavain
[DB]Sense
[DB]Slut
[DB]wizard

Statistics
First Blood: ~{CEC}ParadoX
Red Team Belts: 
Blue Team Belts: 
Red Team Amps: 
Blue Team Amps: 

Match Report
A nice game of Capture the Flag took place this map with both teams trying hard to get flags back but only occasionally succeeding.

Blue Team however managed to succesfully cap more than Red Team with big help from [DB]$aphod who capped 2.
[DB]wizard made it hard for the Red Team defenders taking the flag a total of 9 times.
Not to say that the defence was bad at all, ~{CEC}Doggy got 7 flag kills and this made attacking hard work for Blue Team.

Sealing off the base for Blue Team was some nice defence including [DB]Sense who sealed the base 3 times.
Covering the flag carrier for Blue Team mostly was [DB]Sense with 5 covers.

Attacking in vain at the other end of the map was ~{CEC}Enfant_de_solo who managed to take the Blue Team flag 5 times, but unfortunately was unable to match the 5 caps made by Blue Team.
~{CEC}Enfant_de_solo was also up against some heavy defence including [DB]$aphod with 6 flag kills and [DB]Slut with 4 flag kills.

Good game and congratulations Blue Team.
Stats player of the map was [DB]wizard with 502.941 stat points.
Well played both teams.

This report was created with UTStats from the following game:

http://www.stats.uks-forums.com/?p=match&mid=457

(DB is our CTF team)

[{AS}Loki]

Originally Posted by PizzaMan

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'BETWEEN ip_from AND ip_to' at line 1

I got the exact same thing a couple of times. Only happens to me on JB maps though. Log wont get processed, and every time I try to import it imports that JB map. So I end up with 24 times that map if I dont look at it a day..

[PizzaMan]

ignore this post

I looked at the logs and found that the player had made small changes to his name from map to map in the same war. Odd.

[Deus IX]

Originally Posted by Azazel

I think weapon stats have hit there limit, if you can show me another stats with more information (shots, hits, damage dealt!!) then I'll be impressed.

i tried, but i'm sorry. i can't...

Originally Posted by Azazel

2k4Combos are 2k4 spreees, not UT sprees.
We will also not force the use of an addon.
Sorry UT sprees are here to stay.

i see... too bad.

Originally Posted by Azazel

Do you still want us to see if we can support it?

yeah! where to send?

uhm.. i would still like to see those W/T/L 's added. My friend sent a message that he also thinks that logging the W/T/L 's is important. After all it is a tournament. This addition wouldn't even be that hard to add (not that i could do it), but that's what i think... right?

and i'm wondering... what are the maximum limitations of the statistics? Max. players, max games etc. and does the old games get deleted and merged into somesort of core data to save space or something?

[[RZA]Frenzy]

Regarding those Logs giving me errors on import...

It seems that My web host was having SQL Server issues and they shut it all down last night for maintenance. This morning I come back and ran it and it works fine! Sorry about the false alarm.

BTW - I don't know what you did to the Import Script, but in the last version I would get SQL Questions exceeded when I would import 20 logs at one time. In this version, it just imported 119 without a hiccup! Great job on the upgrade!

[TeKNology]

Helo im trying to get the utstats thingy to work but here's my problem:

Importing Unreal.ngLog.2005.04.15.02.39.46.7777.log
Creating Temp MySQL Table: uts_temp_g065nc9s
Backing Up Log File: Succeeded (gzip)
Player Data Moved to Temp MySQL: Yes
Match Data Created: No (Empty Match) <------------- keep geeting that
Deleting Temp MySQL Table: uts_temp_g065nc9s

why and wut am i doing wrong?

[toa]

Originally Posted by fugley

Although it opened up one question, when doing anything like this and maybe more when merging player names do you have to recalculate rankings ? i had merge one or two player names before, but never recalculated the rankings only to find they were a little upset to see they went from top 10 to bottom 400, although these ppls have now come right after this recalculation with no new games played

If you want to have really correct rankings, you'll have to recalculate them after such actions, yes. We just add all ranking points when you merge players / edit gametypes. That won't be as correct as recalculating everything but it's a lot faster

[toa]

Originally Posted by {AS}Loki

I got the exact same thing a couple of times. Only happens to me on JB maps though. Log wont get processed, and every time I try to import it imports that JB map. So I end up with 24 times that map if I dont look at it a day..

I've attached a fixed script (save in UTStats/import after unzipping) which will be able to process player entries without IPs. But I still can't tell why the logs don't contain IP infos. We're still investigating I suppose

Edit: The updated script can now be found in the fix package (see first post)

[toa]

Originally Posted by Deus IX

uhm.. i would still like to see those W/T/L 's added. My friend sent a message that he also thinks that logging the W/T/L 's is important. After all it is a tournament. This addition wouldn't even be that hard to add (not that i could do it), but that's what i think... right?

I've added it to our ToDo-list. I won't promise an ETA tho

and i'm wondering... what are the maximum limitations of the statistics? Max. players, max games etc. and does the old games get deleted and merged into somesort of core data to save space or something?

The limit is probably your database
There is not much space we could save. But we'll probably have an option to automatically purge old matches in the future.

You may mail me your logs and I'll see what I can do:

[toa]

Originally Posted by [RZA]Frenzy

It seems that My web host was having SQL Server issues and they shut it all down last night for maintenance. This morning I come back and ran it and it works fine! Sorry about the false alarm.

Okay, cool
I had no problems importing your logs and tried quite some stuff but couldn't reproduce your errors (duplicate ids).

BTW - I don't know what you did to the Import Script, but in the last version I would get SQL Questions exceeded when I would import 20 logs at one time. In this version, it just imported 119 without a hiccup! Great job on the upgrade!

I don't think we did that much. We optimised some things here and there, but your host probably increased your query limits. Thank them

[toa]

Originally Posted by TeKNology

Match Data Created: No (Empty Match) <------------- keep geeting that
Deleting Temp MySQL Table: uts_temp_g065nc9s

why and wut am i doing wrong?

Uhm, you aren't trying to import emty matches, are you

If those logs are not empty (more than 1 player playing there), tell us some more about your configuration please (OS, php version, webserver version, ftp download?).

[TeKNology]

Originally Posted by toa

Uhm, you aren't trying to import emty matches, are you

If those logs are not empty (more than 1 player playing there), tell us some more about your configuration please (OS, php version, webserver version, ftp download?).

nope its a 12 slot public server thats used alot.

here's all the info ya wanted.. http://bounty.elitezone.net/phpinfo.php

auto ftp upload.

[B_Man]

As I said before I will update you about MH (MonsterHunt).

I think it takes the events from the matches, but it does not import it to any game type, either DM, or MH....

- B