UTStatsDB Forums

Posted: **Tue May 12, 2009 4:38 pm**

UTStatsDB version 3.06 standalone
windows 2003 server
PHP version 5
Unreal Tournament 3
UT3 stats 1.04
sqlite

Wonder if anyone has had this same problem. I did not have one on my test server on vista machine so when i set up the stat page on my gameserver i downloaded a fresh install of 3.06 and still the same thing. Everything else seems to work as it should i just dont get this graph. All the code is in the .php so not sure what i might be doing wrong.

Posted: **Tue May 12, 2009 5:41 pm**

Send me a link to the web site and I can take a look.

Posted: **Wed May 13, 2009 12:36 am**

Thx Panther...http://69.90.34.90

Posted: **Tue May 19, 2009 7:30 am**

Hello i am the same problem ,you can helpme to resolve this problem? ,sorry for my write, i dont write well inglesh ,onli spanish
my ip for stats is http://190.2.45.7 , the version installed on server is dbstats 3.6 standalone ,is a windows server ,PHP/5.2.8 ,database sqlite
I replace the styles with the original and don't work neither ,y dont now where this the problem , and I proved with styles8 on this forum and don't work neither

Thank you

Posted: **Tue May 19, 2009 9:37 am**

If either of you switch to one of the built-in styles, does it work?
By the way, Tonytoc - you have some code on your page that shows up after the closing html tag.

Posted: **Tue May 19, 2009 1:28 pm**

I am prove with one ,two,tree,etc styles built-in and dont work , never work
i have to download from websvn some new version of some archive?

Posted: **Tue May 19, 2009 2:34 pm**

The graph was included in the 3.06 release and should show up as long as there are matches on the server.

Posted: **Tue May 19, 2009 3:21 pm**

ok thank , then there is not a solution for my problem , perhaps installing again very difficult ,i dont acces to server files ,but if to the stats in ftp mode
The files in the WebSVN they are upgrades ?

Thank

Posted: **Tue May 19, 2009 3:41 pm**

Use the SVN files at your own risk. There's no guarantee of anything being stable or functional at all there. Also, upgrades for SVN versions are not supported.

Posted: **Wed May 20, 2009 11:12 am**

For what it's worth: For the short time I was using UTStatsDB version 3.06 standalone I didn't have the server hourly activity graph either.

Posted: **Thu May 21, 2009 12:17 am**

It appears that SQLite does not have support for the method being used to query the database. I'll look into it to see if there's another way I can accomplish this.

Posted: **Thu May 21, 2009 12:45 am**

Try replacing the following line in index.php:

Code: Select all

  $result = sql_query("SELECT HOUR(gm_start) AS hour, COUNT(gt_pnum) AS pcount FROM {$dbpre}matches, {$dbpre}playersgt WHERE gm_num=gt_num GROUP BY hour");

With:

Code: Select all

  if (strtolower($dbtype) == "sqlite")
    $result = sql_query("SELECT strftime('%H', gm_start) AS hour, COUNT(gt_pnum) AS pcount FROM {$dbpre}matches, {$dbpre}playersgt WHERE gm_num=gt_num GROUP BY hour");
  else
    $result = sql_query("SELECT HOUR(gm_start) AS hour, COUNT(gt_pnum) AS pcount FROM {$dbpre}matches, {$dbpre}playersgt WHERE gm_num=gt_num GROUP BY hour");

Please let me know if this works - it is untested. I also need to know if it works in Microsoft SQL.

Posted: **Thu May 21, 2009 11:47 am**

Nice work Panther. There is something weird at hour 23 though in firefox. The bar sits low covering up the number. Might be just mine. The graph is completely different in ie however (different times).
Firefox:

: hourgraph.jpg (121.04 KiB) Viewed 16495 times

IE:

: hourlyie.jpg (110.1 KiB) Viewed 16495 times

Posted: **Thu May 21, 2009 1:15 pm**

Can you run a database query with the SQLite query utility and send me the results?

Code: Select all

SELECT strftime('%H', gm_start) AS hour, COUNT(gt_pnum) AS pcount FROM ut_matches, ut_playersgt WHERE gm_num=gt_num GROUP BY hour ORDER BY hour;

Posted: **Thu May 21, 2009 1:21 pm**

Nevermind on that. Try getting the page to validate by correcting your XHTML page errors first. It's most likely related to the invalid content causing rendering problems. Oddly enough, it renders perfectly in Mozilla SeaMonkey (I hate using its new name).

Posted: **Thu May 21, 2009 2:38 pm**

I have not been able to get that to work correctly in ie no matter where i put it. It does work just fine in firefox. I went ahead and deleted it to see what i get and its still as in the above pics.

Posted: **Thu May 21, 2009 2:48 pm**

You could try the lastest index.php file via SVN.

Posted: **Thu May 21, 2009 3:14 pm**

negative, no change.

The timeline looks correct in IE. I have no idea whats going on with the one on FireFox.

Hopefully some other folks give this a go so i can see if its just on my end. I have noticed that pbgBrockHeads is all goofy in IE but fine in FireFox.

Posted: **Sat May 23, 2009 7:17 pm**

this solution work for mi ?
i want to prove this now

Edit: work ,Thanks

Posted: **Mon Jun 29, 2009 6:06 am**

UTStatsDB version 3.06 standalone
windows 2003 server
PHP version 5
Unreal Tournament 3
UT3 stats 1.04
sqlite

Can you run a database query with the SQLite query utility and send me the results?

Here are my results. I was able to clear up the hanging bar in hour 23 by using the latest serverquery.php but the graph is still incorrect. I have removed any of the code that was causing issues before, as well as using latest index.php.

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\Tony>sqlite d:\utstatsdb\utstatsdb.db
SQLite version 2.8.17
Enter ".help" for instructions
sqlite> SELECT strftime('%H', gm_start) as HOUR, COUNT(gt_pnum) AS pcount FROM u
t_matches, ut_playersgt WHERE gm_num=gt_num GROUP BY hour ORDER BY hour;
00|145
01|123
02|101
03|89
04|55
05|52
06|65
07|66
08|73
09|105
10|127
11|126
12|132
13|145
14|136
15|161
16|187
17|183
18|193
19|181
20|180
21|177
22|179
23|172
sqlite>

Posted: **Mon Jun 29, 2009 12:18 pm**

I don't see a problem with the data being pulled, which means the cause must be somewhere in the index.php file or the style sheet.

Posted: **Mon Jun 29, 2009 1:46 pm**

I went ahead and tried all the styles (looked the same) as well as used the index.php from the web/svn with no added code on my part (looked the same). Does anyone have it working properly using sqlite? Weird!

Posted: **Mon Jun 29, 2009 4:04 pm**

I've run it with SQLite on my development server with no problem. What's the URL to your server so I can take a look at the output?

Posted: **Mon Jun 29, 2009 11:54 pm**

Server url: http://69.90.34.90:7777
stat url: http://69.90.34.90:80

Not sure which one you wanted there.

Posted: **Tue Jun 30, 2009 9:00 am**

I don't see how it ends up generating that output. The graph lines that you see do represent the data being output by PHP, which means that it must somehow be querying the database incorrectly. Can you send me a copy of your utstatsdb.db file? You can rar/zip it up and PM it to me. Thanks.

Posted: **Tue Jun 30, 2009 11:27 am**

Can you send me a copy of your utstatsdb.db file? You can rar/zip it up and PM it to me. Thanks.

No, thank you. File sent.

Posted: **Wed Jul 01, 2009 12:26 am**

The graphs work properly with SQLite using the current SVN version of the following files:
index.php
language/lang_en.php
resource/style#.css

Posted: **Wed Jul 01, 2009 1:26 pm**

Ok ive tried all those and get the same look. Maybe im not updating correctly. I copy the text from the websvn file and wipe out whats in the current file and past the websvn code in it. Is this the right way?

Posted: **Wed Jul 01, 2009 1:58 pm**

I've enabled the download option in WebSVN so you can simply download and replace existing files.

Posted: **Wed Jul 01, 2009 4:08 pm**

Thanks Panther. I appreciate you spending your time looking into it. Unfortunately nothing seems to be working for me. I even tried another fresh reinstall without all the custom stuff and still no go. Maybe ill dip my toes into the mysql waters and see what happens. Never messed with it though..is it fairly easy for a beginner?

UTStatsDB Forums

Dont have the server hourly activity graph

Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph

Re: Dont have the server hourly activity graph