Dont have the server hourly activity graph

[TONYTOC]

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.

[Panther]

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

[TONYTOC]

Thx Panther...http://69.90.34.90

[Richi]

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

[Panther]

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.

[Richi]

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?

[Panther]

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

[Richi]

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

[Panther]

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.

[horndog]

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.

[Panther]

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.

[Panther]

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.

[TONYTOC]

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 16719 times

IE:

hourlyie.jpg (110.1 KiB) Viewed 16719 times

[Panther]

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;

[Panther]

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).

[TONYTOC]

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.

[Panther]

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

[TONYTOC]

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.

[Richi]

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


Edit: work ,Thanks

[TONYTOC]

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>

[Panther]

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.

[TONYTOC]

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!

[Panther]

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?

[TONYTOC]

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

Not sure which one you wanted there.

[Panther]

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.

[TONYTOC]

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.

[Panther]

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

[TONYTOC]

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?

[Panther]

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

[TONYTOC]

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?