Search found 533 matches

Go to advanced search

by Panther
Tue Mar 31, 2026 9:10 pm
Forum: UTStatsDB
Topic: Some Database Questions
Replies: 10
Views: 9971

Re: Some Database Questions

Many of the map images for some of the game types included in UTStatsDB are from me playing a map and taking a screenshot.
by Panther
Tue Mar 31, 2026 12:03 pm
Forum: UTStatsDB
Topic: Some Codebase Questions
Replies: 7
Views: 7062

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.
by Panther
Tue Mar 31, 2026 12:00 pm
Forum: UTStatsDB
Topic: Some Database Questions
Replies: 10
Views: 9971

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.
by Panther
Sun Mar 29, 2026 9:57 am
Forum: UTStatsDB
Topic: Problems with Weaponnames and UTSTatsDB
Replies: 10
Views: 9498

Re: Problems with Weaponnames and UTSTatsDB

Great that you figured out a solution!
by Panther
Sat Mar 28, 2026 11:58 am
Forum: UTStatsDB
Topic: Some Codebase Questions
Replies: 7
Views: 7062

Re: Some Codebase Questions

You brought up some good points of reducing repeated code, and that there is a lot of clean-up that can be done, but there is certainly the matter of how much time to spend on making things look better versus working better. I am still working on getting the new special event handling working ...
by Panther
Sat Mar 28, 2026 11:07 am
Forum: UTStatsDB
Topic: Some Codebase Questions
Replies: 7
Views: 7062

Re: Some Codebase Questions

The software was written in 2003 for a single version...UT2003. It was a weekend project initially. When you ask about everything being in one script, I assume you mean the log parser. The original version was extremely basic, but then I wrote a more a more robust logger in C for the global stats ...
by Panther
Sat Mar 28, 2026 10:32 am
Forum: UTStatsDB
Topic: Problems with Weaponnames and UTSTatsDB
Replies: 10
Views: 9498

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.
by Panther
Thu Mar 26, 2026 12:16 am
Forum: UTStatsDB
Topic: Problems with Weaponnames and UTSTatsDB
Replies: 10
Views: 9498

Re: Problems with Weaponnames and UTSTatsDB

What logger are you using?
by Panther
Wed Mar 25, 2026 11:32 am
Forum: UTStatsDB
Topic: Problems with Weaponnames and UTSTatsDB
Replies: 10
Views: 9498

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 Panther
Mon Mar 23, 2026 4:31 pm
Forum: News
Topic: Further UTStatsDB Development
Replies: 0
Views: 2056

Further UTStatsDB Development

I'm aware of some issues with the 3.10 release, and almost released a version 3.11, but eventually a number improvements and fixes have been made. Version 3.12 is in testing and will soon be ready for release, just fixing a few minor issues, plus it was brought to my attention that support for ...
by Panther
Mon Mar 23, 2026 10:47 am
Forum: UTStatsDB
Topic: Transfering logs with rsync and automating parsing
Replies: 0
Views: 2002

Transfering logs with rsync and automating parsing

Here are some details on using rsync to transfer log files from a game server to the web server.

First, you need to create a script, such as /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 ...
by Panther
Sun Mar 22, 2026 11:51 pm
Forum: UTStatsDB
Topic: How to get Demos into the UTStatsDB
Replies: 13
Views: 12030

Re: How to get Demos into the UTStatsDB

Mein Deutsch ist begrenzt.

I had help for the translation for UTStatsDB (and the Epic Games global stats).
by Panther
Sun Mar 22, 2026 10:27 pm
Forum: UTStatsDB
Topic: How to get Demos into the UTStatsDB
Replies: 13
Views: 12030

Re: How to get Demos into the UTStatsDB

I just checked, the code is still in place for displaying demorec links in the Match Stats page.
by Panther
Sun Mar 22, 2026 10:23 pm
Forum: UTStatsDB
Topic: How to get Demos into the UTStatsDB
Replies: 13
Views: 12030

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 /etc ...
by Panther
Sun Mar 22, 2026 9:35 pm
Forum: UTStatsDB
Topic: How to get Demos into the UTStatsDB
Replies: 13
Views: 12030

Re: How to get Demos into the UTStatsDB

That's an improvement, at least it contains most of the timestamp and would be much easier to locate. I've added configuration to the log config settings for the demorec files. I'll work on getting it to function. I don't even remember how the link is displayed, if it is at all.
by Panther
Sun Mar 22, 2026 12:32 pm
Forum: UTStatsDB
Topic: How to get Demos into the UTStatsDB
Replies: 13
Views: 12030

Re: How to get Demos into the UTStatsDB

Also, is there no way to improve the naming convention of the demorec files, set them to the match start time, or log the file name? The names make it difficult since it would require calculating the match length, adding that to the start time, then go looking for a file name with roughly that ...
by Panther
Sun Mar 22, 2026 12:20 pm
Forum: UTStatsDB
Topic: How to get Demos into the UTStatsDB
Replies: 13
Views: 12030

Re: How to get Demos into the UTStatsDB

You provided three demo recs and four logs, and the map names of the logs don't line up with the demo recs.
by Panther
Sun Mar 22, 2026 12:07 am
Forum: UTStatsDB
Topic: Matchstatistics
Replies: 11
Views: 10648

Re: Matchstatistics

FYI, these logs parsed fine in my current version. Once you send me some demorec files (with matching log files) I'll get that added back in.
by Panther
Sat Mar 21, 2026 1:05 pm
Forum: UTStatsDB
Topic: How to get Demos into the UTStatsDB
Replies: 13
Views: 12030

Re: How to get Demos into the UTStatsDB

It looks like back in the early days of UTStatsDB before most of the configuration was put into a menu allowing multiple configs, it had:
$demodir = "./Demos/"; // Set to your demorec file path
$demoext = "demo4"; // Extension of demorec files
$demourl = "Demos/"; // Prefix to URL path of demorec ...
by Panther
Fri Mar 20, 2026 12:50 am
Forum: UTStatsDB
Topic: Matchstatistics
Replies: 11
Views: 10648

Re: Matchstatistics

I didn't realize file uploads weren't working. We recently changed server hardware. Go ahead and try now.
by Panther
Thu Mar 19, 2026 11:58 am
Forum: UTStatsDB
Topic: Matchstatistics
Replies: 11
Views: 10648

Re: Matchstatistics

Are the duplicate weapons occuring in a single match or across multiple matches? I'd prefer if you could narrow this down to one or two matches to debug it.
by Panther
Thu Mar 19, 2026 10:28 am
Forum: UTStatsDB
Topic: Matchstatistics
Replies: 11
Views: 10648

Re: Matchstatistics

That's certainly a bug, possibly an encoding error causing that. Send me one of your match logs that have this issue and I'll take a look. It's also possible that it's already been corrected in the current code, but I do have one more similar problem to fix.
by Panther
Thu Mar 19, 2026 10:24 am
Forum: UTStatsDB
Topic: Fatal Error Uncaught Myqli_exception_error
Replies: 3
Views: 4100

Re: Fatal Error Uncaught Myqli_exception_error

I only supplied SQL configurations with the full standalone verisions of UTStatsDB I created back in 2008, which I definitely don't advise using anymore. Better to use a modern version of MySQL (or better, MariaDB) and start with the stock configuration that can be tweaked for your hardware.
by Panther
Thu Mar 19, 2026 10:20 am
Forum: UTStatsDB
Topic: Some Database Questions
Replies: 10
Views: 9971

Re: Some Database Questions

Currently my work in progress has a couple of bugs to fix, but I'll try to get to that soon. I haven't had much time for working on it these days, but I was just looking into them the other day and corrected some of them. As for MyISAM vs InnoDB, MyISAM is significantly faster (at least for reads ...
by Panther
Sun Mar 15, 2026 1:11 pm
Forum: UTStatsDB
Topic: Some Database Questions
Replies: 10
Views: 9971

Re: Some Database Questions

I should add, I've lately worked on PHP compatibility and fixing various bugs I've found. I currently have the system running smoothly on PHP 8.5.
by Panther
Sun Mar 15, 2026 12:48 pm
Forum: UTStatsDB
Topic: Some Database Questions
Replies: 10
Views: 9971

Re: Some Database Questions

I've mostly focussed on MySQL/MariaDB support, though certainly ADODB would have made supporting multiple database systems easier. It does, however, have its drawbacks. I've continued working on fixing some issues and improving performance. Some tables do not require any indexes because the entire ...
by Panther
Tue Jul 15, 2025 1:13 pm
Forum: UTStatsDB
Topic: Version 3.10
Replies: 10
Views: 1172433

Re: Version 3.10

I'm testing version 3.11 and will release it shortly. Among other issues, this will correct some encoding problems that would cause duplicate map and other entries.
by Panther
Tue Jul 15, 2025 10:15 am
Forum: UTStatsDB
Topic: Version 3.10
Replies: 10
Views: 1172433

Re: Version 3.10

What version of PHP and SQL are you running? It seems as though a hard error is being thrown instead of just returning an empty result where the system would then initialize the database.
by Panther
Wed May 21, 2025 11:33 pm
Forum: UTStatsDB
Topic: Version 3.10
Replies: 10
Views: 1172433

Re: Version 3.10

Your post was also lost in the system as a pending approval. You are now a fully registered account, and I'm looking to correct the system notifications. I'm not sure why you received the magic_quotes error, since that was supposed to have been removed in version 3.10. I just checked my current ...
by Panther
Wed May 21, 2025 11:22 pm
Forum: UTStatsDB
Topic: Fatal error: Uncaught mysqli_sql_exception
Replies: 4
Views: 18747

Re: Fatal error: Uncaught mysqli_sql_exception

I do apologize for not seeing your messages until now. I did not receive the system notifications of your new posts and though I had visited the forums a few times I did not log in, so did not see the posts with pending approval. Your account is now fully registered. I've been working on some ...

Go to advanced search