ok, my site is back up and running, so the above links should all work again.. sorry it took me so long, but my computers were horribly damaged in the move, and I had to replace them.

I would be interested in what changes you made for it to work with the mods you listed. I didn't realize any changes were needed for them.

Hi, i know you posted this a couple of months ago but i was having trouble getting my database to work..
Error creating tables... i think your update maybe a solution.. however your link does not seem to work... can you repost a new download linkñ


Sorry, I have been moving over the last several ...

I have updated the patch file on the link above. I think I have all the breaking bugs worked out.

In case I forgot to mention, this patch still has a few bugs and should not be used on a live site, unless you are familiar with PHP and SQL cmds.
I found a bug in the Main Config, which hide most of the Text Fields. I have corrected this, but it is not in the current patch. I will try and get it ...

cool. I have a patch file here http://dragonsys.noip.me/utstatsdb/index.php?stats=downloads
The patch file includes the MySQLi & PHP 5.4 updates, as well as all my mods. I will break this all out, but this will give you a start if you want/have the time. There is also a RAR file containing the ...

Mods:

Selectable Layouts - 100%
Friendly Layout Names - 100%
Downloads - 75%: descriptions require a manual file edit (simple text edit)
All Demorec Files Listing - 75%: descriptions require a manual file edit (simple text edit)
Random UT Logo (top of Sidebar) - 100%
Random AI player ...

I am working on making this script work with MySQLi & PHP v5.4. I will create a patch based on the current download version, unless you have another version you would like me to patch.

I also have a few mods which I will release as well, such as random images in the sidebar.

You can view my demo ...

even when trying to access SVN with a client it prompts for credentials.

I decided just to use screenshots from in game, the problem is, as a spectator you get a banner at the bottom (.. Fire to join...) so I am converting the images into animated gifs set at 256x128, to complete more of the collection started by DogsBody , since he is no longer making updates to his ...

Yes, you can extract the images from the maps, but you'd probably have to load them in the editor.

yeah I tried using unrealed, but I just don't know it well enough to figure how to extract the images. I'll keep digging.

F9 takes a screenshot.

right, but how do you get the user out of the way. Guess I could use a private server and join as spectator...

I was hoping to be able to find a way to extract the images from the map files, but I have been unable to do so. I know there are screenshots in there, as the ...

Where do you find the custom map images (if not supplied with the map) or how can I create the images?
I have a bunch of maps which do not have images, and would like to get/create them.

LMAO
guess I thought it was just overall stats rankings, not just human vs human.

Thanks

Ranking do not appear to be working. http://dragons-server.com/utstatsdb/rankings.php
I have the following settings:
Min. Rank Matches: 1
Min. Rank Time: 0
Rank System: Enabled
Rank Bots: Disabled

is there another settings somewhere I'm missing?


UTStatsDB version - 3.0.6
Operating system and ...

Would it be possible to make the Date Format customizable?
You have it so we can change the Hour Format, but the date comes out as a pretty long string (Mon, May 09 2011 at 2:43:17 AM). It would be great if we could change the php date() format

My host opened up the ports for UDP and it's all good now. Looks like the fwrite() & fclose() errors went away as well.
Thanks for all your help!

make sure you are using two different query ports as well, in your ut2004.ini

The libraries that were written for handling HTTP requests through UT3 don't seem to work reliably and as far as I know nothing has been done with them for ages so I wouldn't hold my breath on the automated method. If you can, set up a cron script to retrieve the logs for you.

seems like most ...

my webhost has opened outbound ports of 7777, 6500 & 7787 (TCP) but it's still not working. I just realized they are UDP... lol

and my UT2004 stats are working perfectly now :)
Only problem left is the automated uploading of UT3 logs, but I understand it's still in development, so I manually FTP ...

It's possible that there's a firewall blocking the outgoing ports from the webserver. Check with your host provider.

looks like that is part of the problem. According to my webhost, they block all ports, by default, and only allow/open the ones required. I have asked if they can open the UT3 ...

Using a stock version of UTStatsDB 3.05 (I also tried the newer version of utserverquery.php with the same results) I didn't have any problem displaying your 2004 or UT3 server stats:
http://www.utstatsdb.com/demo/

Does your PHP configuration include sockets support? You can check by creating a ...

Try the current SVN version of serverquery.php:
http://www.utstatsdb.com/websvn/dl.php?repname=utstatsdb&path=%2Ftrunk%2Fserverquery.php&rev=135

I did, got the same error, only different line numbers.

Warning: fwrite(): 27 is not a valid stream resource in /home/dragserv/public_html/utstatsdb ...

yeah it is pretty long, but it was what my host assigned to me, and I have not figured out how to change it yet.

Ok, so I set the Game Port to 6500 (which is the current Query Port), but it still shows as offline. Also, when I add my UT2004 Server to the query list I get a bunch of fwrite & fclose ...

I figured out the FTP issue, in the DB for utstatsdb the FTP password is set to varchar(30), I raised it to 50 and now FTP works.

When I try to parse logs I get the following:

Initializing ftp file transfer.

Warning: ftp_login() [function.ftp-login]: User 'user' or password is not valid. in /home/.../public_html/utstatsdb/logs.php on line 452
Unable to login to ftp server 'server' on port '21' for user 'user'.
Setting ...

I have done some of that as well.
I would be interested in the mods you did, so I could add what I don't have to my site.

http://www.dragonsys.org/utstatsdb