Pitboss WebStats Proof of Concept - Curious About Interest

[OverloadUT]

Fosse - That would work as a last resort. It's just... as you said, ridiculous hacky

MooManOf - That's true. I haven't implemented a news system yet (although I suppose I should just put some static text, which is better than nothing.) Until now, I didn't want anyone going to CivStats.com to use the tool without viewing this thread. It was kind of an alpha that I didn't want everyone using. Now that the whole "add a game" feature is implemented and whatnot, I think it's time to do that.

 

[MooManof_]

If not a link to the app, a link to this thread should have been there. And my offer to help is still open - even if it's mostly just administrating the website.

 

[grimliin]

I am having issues with my game. I have the latest civstats running, but its not updating any of the logins or turn completions since I upgraded. On my server I see the successful upload, and it looks like it is registering at the website. Any ideas?

 

[Bernout1]

I am having issues with my game. I have the latest civstats running, but its not updating any of the logins or turn completions since I upgraded. On my server I see the successful upload, and it looks like it is registering at the website. Any ideas?

Just to get rid of the obvious, you *are* running 1.61 right?

Bernout

 

[grimliin]

yep, it is

 

[OverloadUT]

Well, what game is it that you're having problems with?

 

[grimliin]

guess that would help huh?

RP Free for ALL PTBS

 

[grimliin]

looks lik you fixed it whatever it was, thanks!!

 

[grimliin]

Well it spit out a bunch of info when I posted it was fixed before, but now its back to not working again. Not sure what is wrong...

 

[MooManof_]

Checked your firewall? That can sometimes play tricks on CivStats

 

[OverloadUT]

Yeah, a firewall could cause problems with the uploader - it needs to communicate on port 80 to do it's thing.

Other than that, I can't imagine why it wouldn't be uploading the stats correctly, especially if the app is saying it's doing a successful upload. Have you checked the logfile to see what it says in there? It would be named [YourProfileName].log.

 

[grimliin]

turned the firewall off, itsupdating the time and stuff, and sending out new turn notifies, but no turn indicators or login logs. Here are the last few lines of the log.

7/17/2006 15:54:51 tt - Player 18's type is now: 1
7/17/2006 15:54:53 tt - Upload Finished. Data Downloaded: 21 Time: 1.70731699140533
7/17/2006 15:54:53 tt - Upload Finished. Data Downloaded: 21 Time: 0.453216819456104
7/17/2006 15:54:54 tt - Upload Finished. Data Downloaded: -1 Time: 0.339874760619017

I tried going back to .7, but same thing. Wondering if something on your server side doesn't like my game. Can you blank it to try again?

 

[OverloadUT]

Open up your Pitbossstats.ini file and change the loglevel to 2.

Then run the app like normal, and after it does an upload or two, please post the last several lines from the log here. You'll want to edit out your password from the log.

Also, there are a few .tmp files that are created when it uploads data. After you start and stop it, please post the contents of each of the .tmp files. It should only be one line, something like pbupload=1|queries=10 but it might have a php error in there too. That's what I'm looking for.

 

[grimliin]

Not successfully uploading now. Firewall is turned off. Don't know what else to try...

7/18/2006 7:21:12 tt - Player 18's type is now: 1
7/18/2006 7:21:14 tt - Upload Finished. Data Downloaded: 21 Time: 1.4622886428303
7/18/2006 7:21:14 tt - Upload Finished. Data Downloaded: 21 Time: 0.345812107404712
7/18/2006 7:21:15 tt - Upload Finished. Data Downloaded: -1 Time: 0.308921943990088
7/18/2006 7:21:15 tt - Upload FAILED. Return code: -4
7/18/2006 7:21:25 tt - Upload Finished. Data Downloaded: -1 Time: 0.307103835822709
7/18/2006 7:21:25 tt - Upload FAILED. Return code: -4
7/18/2006 7:21:35 tt - Upload Finished. Data Downloaded: -1 Time: 0.322045678989927
7/18/2006 7:21:35 tt - Upload FAILED. Return code: -4
7/18/2006 7:21:46 tt - Upload Finished. Data Downloaded: -1 Time: 0.380481597521473
7/18/2006 7:21:46 tt - Upload FAILED. Return code: -4
7/18/2006 7:21:56 tt - Upload Finished. Data Downloaded: -1 Time: 0.306162934115928
7/18/2006 7:21:56 tt - Upload FAILED. Return code: -4
7/18/2006 7:22:06 tt - Upload Finished. Data Downloaded: -1 Time: 0.318325373755603
7/18/2006 7:22:07 tt - Upload FAILED. Return code: -4
7/18/2006 7:22:17 tt - Upload Finished. Data Downloaded: -1 Time: 0.344863104109601
7/18/2006 7:22:17 tt - Upload FAILED. Return code: -4

gamedata.tmp pbupload:1|queries:4|

init.tmp pbupload:1|queries:5|

 

[OverloadUT]

Very strange. It appears to be uploading the init command and the game data command, but it fails on the player update command. Do you have a playerdata.tmp file?

Also, I mispoke. Could you do the same thing with a loglevel of 3? That's when it should actually show us the exact URL it's trying to access.

Data downloaded -1 means that either the server returned an error (404 or 403 or 503) or it wasn't able to contact the server at all...

 

[grimliin]

no, don't have payerdata.tmp

7/18/2006 15:57:16 tt - Total Parse Time: 6.83503797270323
7/18/2006 15:57:16 tt - Queueing data to upload. Items in queue before this one: 0
7/18/2006 15:57:16 tt - Starting an upload. Func=Init URL: http://www.civstats.com/pbupload.ph...ame=RP+Free+for+All+PTBS&timestamp=1153252636
7/18/2006 15:57:16 tt - Queueing data to upload. Items in queue before this one: 1
7/18/2006 15:57:17 tt - Queueing data to upload. Items in queue before this one: 2
7/18/2006 15:57:21 tt - Upload Finished. Data Downloaded: 21 Time: 4.72569083500836
7/18/2006 15:57:21 tt - Starting an upload. Func=GameData URL: http://www.civstats.com/pbupload.ph...=1840+BC&TurnTimer=32253&timestamp=1153252636
7/18/2006 15:57:22 tt - Upload Finished. Data Downloaded: 21 Time: 0.475747057237722
7/18/2006 15:57:22 tt - Starting an upload. Func=PlayerData URL: http://www.civstats.com/pbupload.ph...er-Davion&P18Type=1&P18Score=83&P18Finished=1
7/18/2006 15:57:22 tt - Upload Finished. Data Downloaded: -1 Time: 0.346615561474992
7/18/2006 15:57:22 tt - Upload FAILED. Return code: -4

 

[OverloadUT]

Hrm...

I'm starting to think that the problem might be related to the scripting language I'm using choking on a GET request that is so long. That URL is over 1000 characters! I'm sure that's some violation of hte W3C guidelines.

I entered the URL manually and the data successfully updated in your game, so the problem is not on the php's end, which is a shame because that would have been an easy fix.

Unfortunately there is no other easy way to do it. I might have to move all of the data to POST variables, but that would require a significant rewrite.

I will experiment with the data you gave me to see if I can confirm that it's a problem with the scripting language I'm using and see if I can work around it easily.

 

[grimliin]

alright, thanks, if you find out I'm just over a threshhold I could request players to shorten names or find another way to trim off a few chars

 

[OverloadUT]

You know that significant rewrite I was talking about? It's done

I'm glad this problem came up actually, because it gave me the push I needed to rework the uploading system. Plus it was very fun to write a fully compliant HTTP/1.1 client.

Of course, there's still the question if it will actually fix your problem!

Please try using this new version of the uploader.

Other people probably shouldn't update to this new version quite yet. It has a LOT of changed code and might not work completely, although I have done extensive testing. I would just like to give it another day before I "offically" release it.

 

[grimliin]

woo hoo, we are back in business!! Thanks!!!