Search found 43 matches

Go to advanced search

by SkullCollector
Tue May 19, 2026 4:21 am
Forum: UTStatsDB
Topic: UTStatsDB work in Progress ?
Replies: 2
Views: 65

Re: UTStatsDB work in Progress ?

Wow, no reactions ? :o
by SkullCollector
Sun May 17, 2026 10:38 am
Forum: UTStatsDB
Topic: UTStatsDB work in Progress ?
Replies: 2
Views: 65

Re: UTStatsDB work in Progress ?

Rest of my screenshots
show_match1.png
show_match2.png
show_match3.png
show_match4.png


And this is a Work from 3 or 4 Days.

when it is ready, i can put a zip File with my work for all.

Since I have known this tool for a very long time—dating back to my days with UT2004—I want to give ...
by SkullCollector
Sun May 17, 2026 10:31 am
Forum: UTStatsDB
Topic: UTStatsDB work in Progress ?
Replies: 2
Views: 65

UTStatsDB work in Progress ?

Hi there,
since i'm plying with my friends together on my Own Server and using the Old Version of UTStatsDB in Version 3.06 (because all Versions after that doesn't count headshots IMHO) and other strange things. The Accuracy of the Weapons are not logged correctly because of Problems with the ...
by SkullCollector
Tue Apr 28, 2026 6:35 am
Forum: UTStatsDB
Topic: SQL Queries
Replies: 0
Views: 555

SQL Queries

Hi there,
after i revamped the Script with some new functions and caching functions including the ADODB Layer.
i reduce in matchhigh.php the sql queries from over 200 *yes you read it right* to 20 with a rendertime from the Page to 0.006 seconds.

i cache the calls of the map , player and wepon ...
by SkullCollector
Sat Apr 25, 2026 10:18 pm
Forum: UTStatsDB
Topic: Fix for the suspicious Weaponname Bug :-)
Replies: 2
Views: 7472

Re: Fix for the suspicious Weaponname Bug :-)

So after some Matches with UTComp enabled i figured some new Weapons out that makes new Entrys in the Weapons Table.
New Names but the same Weapons.
Here are my new function and the edited function get_weapon

This is the for the File includes/logspecial.php
Put it before function get_weapon ...
by SkullCollector
Fri Apr 03, 2026 12:42 pm
Forum: UTStatsDB
Topic: Fix for the suspicious Weaponname Bug :-)
Replies: 2
Views: 7472

Re: Fix for the suspicious Weaponname Bug :-)

Found a damn typo :

Change

Code: Select all

'oldshieldgunut' => 'OldShieldGunUTSnd',
into :

Code: Select all

'oldshieldgunutsnd' => 'OldShieldGunUTSnd',
to much coding last few days..
Sorry for that

Skully
by SkullCollector
Fri Apr 03, 2026 4:29 am
Forum: UTStatsDB
Topic: Fix for the suspicious Weaponname Bug :-)
Replies: 2
Views: 7472

Fix for the suspicious Weaponname Bug :-)

Since the error with the strange weapon names occurred again, I quickly built a solution for it.
Quickly is an joke....


function replaceWordsWithNumbers($string) {
// Mapping (lowercase for compare)
$map = array(
'minigun' => 'Minigun',
'flakcannon' => 'FlakCannon',
'assaultrifle ...
by SkullCollector
Tue Mar 31, 2026 9:12 pm
Forum: UTStatsDB
Topic: Some Codebase Questions
Replies: 7
Views: 18843

Re: Some Codebase Questions


Have you missed something? Probably not. I had started making these changes years ago and only just started looking into it again, trying to pick up where I left off and get the new special events system working.

I had a similar thought.
Well, there are more important things than that.

I've ...
by SkullCollector
Tue Mar 31, 2026 9:01 pm
Forum: UTStatsDB
Topic: Some Database Questions
Replies: 10
Views: 15852

Re: Some Database Questions


That's not practical to do on the fly by the web server, so better to get your map collection together and stick them all in mapimages.


Yeah i know. But the most maps that i have on my Server are not Vanilla Maps and not all have made a Screenshot. :-D

I have some Images , but not all. Anyway ...
by SkullCollector
Mon Mar 30, 2026 1:44 am
Forum: UTStatsDB
Topic: Some Codebase Questions
Replies: 7
Views: 18843

Re: Some Codebase Questions

well, i found some realy strange things.

chat_log.png

as you can see in the Screenshot, Headshots are shown. But not added to any player or to the Totals of UTStatsdb.
And i can't find a database table where this text is in.
ut_gtchat nothing with HEADSHOT in it.
I don't get it :-D
that cames ...
by SkullCollector
Mon Mar 30, 2026 1:34 am
Forum: UTStatsDB
Topic: Some Database Questions
Replies: 10
Views: 15852

Re: Some Database Questions


Yes i know MyIsam is faster, but in Case of Databases Crashes an other stupid things that can happen, i prefer Security. :-D

as far as i know and remember, in Maps can be Images .
but i will have a look in the map files and see.


I found a syntax for extracting a image from Unreal Maps ...
by SkullCollector
Sun Mar 29, 2026 1:05 pm
Forum: UTStatsDB
Topic: Problems with Weaponnames and UTSTatsDB
Replies: 10
Views: 22740

Re: Problems with Weaponnames and UTSTatsDB

Great that you figured out a solution!
Sure, but that is not the answer of the why questions....
by SkullCollector
Sun Mar 29, 2026 12:10 am
Forum: UTStatsDB
Topic: Problems with Weaponnames and UTSTatsDB
Replies: 10
Views: 22740

Re: Problems with Weaponnames and UTSTatsDB

Hi,
so i have checked this things with the AntiTCC.
The order of the mutators appears to be important.

First AntiTCC, then UTComp. Then the statistics will look correct. Without thousands of new Weaponnames.
Thats Realy strange i think..

But ok, a nice to know :-)
by SkullCollector
Sat Mar 28, 2026 11:43 am
Forum: UTStatsDB
Topic: Some Codebase Questions
Replies: 7
Views: 18843

Re: Some Codebase Questions

I think I misspoke. It's probably due to my poor English. Sorry for that.

If everything is the same for all Unreal types, then I understand why you handle everything in one place and don't write a separate codebase for each game type like UT99, UT2003, UT2004 and UT3.

OK, I understand why you didn ...
by SkullCollector
Sat Mar 28, 2026 10:49 am
Forum: UTStatsDB
Topic: Problems with Weaponnames and UTSTatsDB
Replies: 10
Views: 22740

Re: Problems with Weaponnames and UTSTatsDB


I vaguely remember seeing weapon names do that sort of thing before due to a bug in how the objects were handled. See if the behavior occurs when only the AntiTCC mutator is enabled.

Ok, i will try it out tomorrow.
hmm, i remember that i have done that also. In the curious Weapon Names are in ...
by SkullCollector
Sat Mar 28, 2026 8:11 am
Forum: UTStatsDB
Topic: Some Codebase Questions
Replies: 7
Views: 18843

Re: Some Codebase Questions

This is what i have done so far in the main.inc.php


/**
We now filter the superglobals like $_GET, $_POST, $_ENV, and $_REQUEST to verify the accuracy of the sent data.
* Function call: filter_struct_utf8(1, $_GET or $_POST);
*
* @param integer $type Constant like INPUT_XXX.
* @param array ...
by SkullCollector
Sat Mar 28, 2026 2:36 am
Forum: UTStatsDB
Topic: Some Codebase Questions
Replies: 7
Views: 18843

Some Codebase Questions

I have a few questions about the source code, and please don't take this as criticism; I'm just asking out of pure interest.

Why was the script written so that all the Unreal Engine components are processed in a single script?
imho : Which ones of the Games can be setup in the Config File. So if ...
by SkullCollector
Fri Mar 27, 2026 11:22 am
Forum: UTStatsDB
Topic: Problems with Weaponnames and UTSTatsDB
Replies: 10
Views: 22740

Re: Problems with Weaponnames and UTSTatsDB



What logger are you using?


OL Stats 3.01 from your database here.
Was recommendet by UTStatsDB. Any other Version from that ?
Maybe it is UTCOmp that make this. I will test that.


I think i found the Problem.
after i deaktivate UTCOMp. Nothing changed.
So i reactivate the mut.
After i ...
by SkullCollector
Fri Mar 27, 2026 10:51 am
Forum: UTStatsDB
Topic: Problems with Weaponnames and UTSTatsDB
Replies: 10
Views: 22740

Re: Problems with Weaponnames and UTSTatsDB

What logger are you using?
OL Stats 3.01 from your database here.
Was recommendet by UTStatsDB. Any other Version from that ?
Maybe it is UTCOmp that make this. I will test that.
by SkullCollector
Fri Mar 27, 2026 10:49 am
Forum: UTStatsDB
Topic: Problems with Weaponnames and UTSTatsDB
Replies: 10
Views: 22740

Re: Problems with Weaponnames and UTSTatsDB


Because each weapon is being relabeled repeatedly by the mutator with custom names, so the stats see it as a new weapon. I'm not sure what the purpose is for that. If the stats were to simply strip numbers off the end of weapon names, that could potentially impact some that shouldn't be modified ...
by SkullCollector
Wed Mar 25, 2026 12:02 am
Forum: UTStatsDB
Topic: Problems with Weaponnames and UTSTatsDB
Replies: 10
Views: 22740

Problems with Weaponnames and UTSTatsDB

hi there,

On my Server runs the Mutator UTComp Version 1.8b
If you enable the Enhanced Netcode Feature it will push new WeaponNames into the Logfiles :

It looks like this :
6103.99 K 3 DamTypeRocket 4 NewNet_SniperRifle
6103.99 S 3 1.00 frag
6103.99 T 0 1.00 tdm_frag
6105.16 I 8 UDamagePack
6106 ...
by SkullCollector
Tue Mar 24, 2026 11:52 pm
Forum: UTStatsDB
Topic: How to get Demos into the UTStatsDB
Replies: 13
Views: 27903

Re: How to get Demos into the UTStatsDB

Morning,

feedback :

rsynch with ssh keys works like candy.

here is my script to pull the logfiles and the demo files from my ut server.


#!/bin/sh
rsync --rsh=/usr/bin/ssh --remove-source-files <user@servername>:/home/unreal/.ut2004/UserLogs/Stats_*.log /srv/www/html/ut/Logs/
rsync --rsh=/usr ...
by SkullCollector
Sun Mar 22, 2026 11:45 pm
Forum: UTStatsDB
Topic: How to get Demos into the UTStatsDB
Replies: 13
Views: 27903

Re: How to get Demos into the UTStatsDB


Guten Morgen.

/etc/cron.d:
*/5 * * * * apache /etc/utstatslogs >/dev/null 2>&1

/etc/utstatslogs
#!/bin/sh
rsync --rsh=/bin/ssh --remove-source-files user@server.com:/usr/local/ut/UserLogs/Stats_*.log /var/http/ut/Logs/
cd /var/http/ut
/usr/bin/php ./logs.php pass=<updatepass> nohtml

chmod +x ...
by SkullCollector
Sun Mar 22, 2026 9:44 pm
Forum: UTStatsDB
Topic: How to get Demos into the UTStatsDB
Replies: 13
Views: 27903

Re: How to get Demos into the UTStatsDB

Good Morning from good old Germany :-D

well, make it like the MapImage. If there a Demo File, link it under the Mapname if not than not :-D
oh, write it into the database . need a new field with varchar 100 and than put it in.
i would make it the same way with the Mapimage. If there an Image for ...
by SkullCollector
Sun Mar 22, 2026 8:54 pm
Forum: UTStatsDB
Topic: How to get Demos into the UTStatsDB
Replies: 13
Views: 27903

Re: How to get Demos into the UTStatsDB

Well, i'm know using the Mutator DemoRec.
this one saves it like : 0323-0436-DM-Deck17.demo4
The Logfile looks like that : Stats_7777_2026_03_23_04_36_25

Unfortunately, there is no other way to customize the filenames for the demo files.
hope that can use for the UTStatsDB.

I will attach this here ...
by SkullCollector
Sun Mar 22, 2026 1:56 am
Forum: UTStatsDB
Topic: How to get Demos into the UTStatsDB
Replies: 13
Views: 27903

Re: How to get Demos into the UTStatsDB

Here are some logs with demos.

hope you can it back into the script
by SkullCollector
Sun Mar 22, 2026 1:33 am
Forum: UTStatsDB
Topic: How to get Demos into the UTStatsDB
Replies: 13
Views: 27903

Re: How to get Demos into the UTStatsDB

Well, these setting never seen .

But ok. I send you 3 Demos with the logfiles here.

i will make some matches and upload these files here
by SkullCollector
Sun Mar 22, 2026 1:29 am
Forum: UTStatsDB
Topic: Matchstatistics
Replies: 11
Views: 23867

Re: Matchstatistics

Oki,
her a Matchlog and a demo File.

Time from the Logfile is the Starting time.
Time from the Demorec File is the Endtime of the Match.

Both files in the zip File
by SkullCollector
Sat Mar 21, 2026 11:51 am
Forum: UTStatsDB
Topic: How to get Demos into the UTStatsDB
Replies: 13
Views: 27903

How to get Demos into the UTStatsDB

Hi there,

some questions about the Demo Rec Files from UT2004. I Autocreate the Serverside Demos with UTCOmp.

the demos looks like this :
3-20-2026-(08-19)-DM-Morbias-2k3.demo4

I can see the setting for a demo path in the logs section, but I can't find anywhere to change the file extension ...
by SkullCollector
Fri Mar 20, 2026 12:33 pm
Forum: UTStatsDB
Topic: Matchstatistics
Replies: 11
Views: 23867

Re: Matchstatistics


I didn't realize file uploads weren't working. We recently changed server hardware. Go ahead and try now.


Ah yo. Files now online here :-D Thanks for fixing that.

by the way...i think i have an Old V3.10 ot utstats DB. Cause I cant use Demo Files. BEcause no settings in admin area to set them ...

Go to advanced search