Timestamps are in GMT/BST.
| 01:25:00 | | watusimoto Quit (Ping timeout: 248 seconds) |
| 01:56:00 | | karamazovapy_ is now known as karamazovapy |
| 02:17:00 | | raptor has joined |
| 02:17:00 | | ChanServ sets mode +o raptor |
| 04:08:00 | | watusimoto has joined |
| 04:32:00 | raptor | good evening |
| 04:44:00 | watusimoto | hi |
| 04:46:00 | raptor | hi |
| 04:47:00 | watusimoto | very sleepy... |
| 04:47:00 | sam686 | hi |
| 04:47:00 | raptor | already? |
| 04:47:00 | raptor | too many late nights |
| 04:47:00 | watusimoto | trying to get a few more bugs fixed so I can check somethign in |
| 04:47:00 | watusimoto | I really like my latest architecture |
| 04:48:00 | raptor | oh good |
| 04:48:00 | watusimoto | definitely the right track |
| 04:48:00 | raptor | i'm going to scrap about half my work with the shared_ptr and wait for your latest before i continue |
| 04:48:00 | watusimoto | you think that's easiest? |
| 04:48:00 | raptor | hg clones are great |
| 04:48:00 | raptor | yes |
| 04:49:00 | raptor | because i need to rethink a few things |
| 04:49:00 | watusimoto | I've done that in the past as well |
| 04:49:00 | raptor | so i'm back to trying to patch coreaudio on mac to accept audio input |
| 04:49:00 | sam686 | problem is still isn't fixed, there is some problem with stats and using name filter taking a long time (30 seconds) to load in http://bitfighter.org/gamereports/ ... While my server stats works much faster http://96.2.123.136/upload/1/index.php |
| 04:50:00 | raptor | i forgot about that, sam686. watusimoto are there indices on the stats database on the master server server? |
| 04:51:00 | watusimoto | not sure |
| 04:51:00 | watusimoto | only if you put them there |
| 04:51:00 | raptor | well, my schema had them |
| 04:51:00 | watusimoto | then they're there |
| 04:51:00 | raptor | hmmm |
| 04:51:00 | raptor | maybe RAM usage on the master server server is high? and it is swapping a bit? |
| 04:51:00 | sam686 | now it seems to take much longer the more stats there is.. |
| 04:51:00 | watusimoto | I can check if I you tell me how |
| 04:52:00 | raptor | command line: free -m |
| 04:52:00 | raptor | shows free memory with buffers and swap space used (in MB) |
| 04:55:00 | watusimoto | [eykamp@domo eykamp]$ free -m |
| 04:55:00 | watusimoto | total used free shared buffers cached |
| 04:55:00 | watusimoto | Mem: 2007 1915 91 0 43 547 |
| 04:56:00 | raptor | swap? |
| 04:56:00 | raptor | should be another line... |
| 04:56:00 | watusimoto | Swap: 1023 213 810 |
| 04:56:00 | watusimoto | 3 lines |
| 04:56:00 | watusimoto | mem |
| 04:56:00 | watusimoto | buffers/cache |
| 04:56:00 | watusimoto | swap |
| 04:57:00 | raptor | can i see the buffer line? |
| 04:57:00 | watusimoto | -/+ buffers/cache: 1323 683 |
| 04:57:00 | watusimoto | used = 1323 |
| 04:57:00 | watusimoto | free = 683 |
| 04:57:00 | raptor | ok, so it's good still |
| 04:57:00 | sam686 | does CPU usage go up to 100% while trying to load stats with name filter? |
| 04:57:00 | raptor | swapping a little, but not much |
| 04:57:00 | raptor | i wonder if it's just a taxed server |
| 04:58:00 | watusimoto | watching top |
| 04:58:00 | watusimoto | idle = 89, 97, 76, 50, 68, 66, 61 |
| 04:59:00 | raptor | is the database engine itself shared as well? like one instance of mysqld is shared among all users? |
| 05:00:00 | sam686 | database (mysql) version? could be outdated? |
| 05:00:00 | watusimoto | proably shared |
| 05:00:00 | watusimoto | probably outdated |
| 05:00:00 | raptor | i bet the issue is database locking |
| 05:02:00 | watusimoto | 26% idle 23, 30, 44, 44, 49, 46 |
| 05:03:00 | watusimoto | mysqld is consistenly in the top 2 processes |
| 05:03:00 | watusimoto | 6% cpu, 10% memory |
| 05:03:00 | raptor | yeah - we must be fighting with the other users |
| 05:03:00 | watusimoto | possibly |
| 05:03:00 | watusimoto | just saw 2 myslqd processes |
| 05:04:00 | raptor | curious |
| 05:04:00 | raptor | could you run the same query that the game reports is running |
| 05:04:00 | raptor | but directly on the database? |
| 05:04:00 | raptor | then that'll let us know if it really is a database issue |
| 05:04:00 | raptor | i could be network related |
| 05:05:00 | watusimoto | ps aux |grep mysql |wc -l |
| 05:05:00 | raptor | or socket-related.. |
| 05:05:00 | watusimoto | prints 3 |
| 05:05:00 | watusimoto | sure |
| 05:05:00 | watusimoto | do you know what it is? |
| 05:05:00 | raptor | i'm fishiing it out again... |
| 05:05:00 | watusimoto | of where I can find it, if that would be easier? |
| 05:06:00 | raptor | i got it |
| 05:06:00 | raptor | http://96.2.123.136/upload/query.txt |
| 05:10:00 | watusimoto | 348 rows in set (2.38 sec) |
| 05:10:00 | raptor | 2 seconds! |
| 05:10:00 | sam686 | are you doing name filter and date filter? |
| 05:10:00 | raptor | oh oops, name filter... |
| 05:11:00 | watusimoto | doing everything you pasted |
| 05:11:00 | raptor | let me rebuild that... |
| 05:11:00 | watusimoto | ok |
| 05:11:00 | raptor | sam what name did you use? |
| 05:11:00 | sam686 | raptor, ZoombeR |
| 05:11:00 | sam686 | you can try one or the other or any other name |
| 05:12:00 | sam686 | it appears nearly equally slow no matter which name is used |
| 05:12:00 | raptor | ok watusimoto, new query: http://96.2.123.136/upload/1query.txt |
| 05:14:00 | watusimoto | this one is running a tad slower |
| 05:14:00 | watusimoto | just a smidge |
| 05:14:00 | raptor | ha |
| 05:14:00 | watusimoto | ok. almost done here |
| 05:15:00 | raptor | hahaha |
| 05:15:00 | watusimoto | juuusst wrapping it up |
| 05:15:00 | sam686 | for my server, i get Empty set (0.09 sec) on my database server... so your server taking forever? |
| 05:15:00 | watusimoto | Empty set (1 min 30.19 sec) |
| 05:15:00 | raptor | woot! |
| 05:15:00 | watusimoto | not forever, only 1.5 minutes |
| 05:15:00 | raptor | ok, now try this: |
| 05:15:00 | raptor | er, just try the inner select statement |
| 05:16:00 | raptor | in that last query i gave you - 4 lines |
| 05:16:00 | watusimoto | Empty set (0.00 sec) |
| 05:16:00 | raptor | well that was fast |
| 05:17:00 | raptor | now try running that long query once more |
| 05:17:00 | raptor | let's rule out the cache |
| 05:17:00 | raptor | and do you know what version of mYsql it is running? |
| 05:18:00 | watusimoto | mysql Ver 14.12 Distrib 5.0.45, for pc-linux-gnu (i686) using readline 5.0 |
| 05:19:00 | watusimoto | faster! |
| 05:19:00 | watusimoto | Empty set (1 min 28.04 sec) |
| 05:19:00 | raptor | hahaha |
| 05:19:00 | watusimoto | cache |
| 05:20:00 | sam686 | its only less then 5% speed gain... |
| 05:20:00 | raptor | that makes no sense |
| 05:20:00 | raptor | we need to see if there is an index on stats_game.stats_game_id |
| 05:20:00 | raptor | will 'describe' do that? |
| 05:21:00 | watusimoto | no |
| 05:21:00 | watusimoto | describe stats_game.stats_game_id |
| 05:21:00 | watusimoto | -> ; |
| 05:22:00 | raptor | sam686: what version of mysql are you running? |
| 05:22:00 | sam686 | my SQL version is at |
| 05:22:00 | sam686 | +-------------------------+------------------------------+ |
| 05:22:00 | sam686 | | protocol_version | 10 | |
| 05:22:00 | sam686 | | version | 5.1.50-community | |
| 05:22:00 | sam686 | | version_comment | MySQL Community Server (GPL) | |
| 05:22:00 | sam686 | | version_compile_machine | ia32 | |
| 05:22:00 | sam686 | | version_compile_os | Win32 | |
| 05:22:00 | sam686 | +-------------------------+------------------------------+ |
| 05:22:00 | raptor | do describe stats_game, watusimoto |
| 05:22:00 | watusimoto | \mysql Ver 14.12 Distrib 5.0.45, for pc-linux-gnu (i686) using readline 5.0 |
| 05:22:00 | watusimoto | that worked |
| 05:23:00 | watusimoto | +------------------+----------------------+------+-----+-------------------+----------------+ |
| 05:23:00 | watusimoto | | Field | Type | Null | Key | Default | Extra | |
| 05:23:00 | watusimoto | +------------------+----------------------+------+-----+-------------------+----------------+ |
| 05:23:00 | raptor | specific line for stats_game_id? |
| 05:23:00 | watusimoto | http://pastebin.com/svmqwVcf |
| 05:24:00 | raptor | ok, it's the primary |
| 05:24:00 | raptor | hmmm |
| 05:24:00 | raptor | i think i may know the quirk.. |
| 05:24:00 | raptor | you don't mind pasting the db info to pastebin? |
| 05:25:00 | watusimoto | what do you mean? |
| 05:26:00 | raptor | well, at work i'm not allow to pass info about databases around publically |
| 05:27:00 | watusimoto | I got that, what do you mean by the db info? |
| 05:27:00 | raptor | would it bother you if i posted the queries to pastebin |
| 05:27:00 | watusimoto | the queries? no, as long as there's no pws or server info |
| 05:27:00 | raptor | ok |
| 05:28:00 | raptor | i think i know the problem |
| 05:28:00 | raptor | let me redo the query real quick... |
| 05:32:00 | raptor | ok try this evil query: |
| 05:32:00 | raptor | http://pastie.org/1969710 |
| 05:33:00 | raptor | wait |
| 05:33:00 | raptor | ok reload that page |
| 05:33:00 | raptor | i forgot to add the player name |
| 05:33:00 | raptor | now try it |
| 05:35:00 | watusimoto | 263 rows in set (1.08 sec) |
| 05:35:00 | raptor | sweet! |
| 05:35:00 | sam686 | i get 357 rows in set (0.14 sec) on my database... |
| 05:36:00 | raptor | now both try the original equivalent: http://pastie.org/1969723 |
| 05:36:00 | raptor | and see if you get the same rows |
| 05:37:00 | sam686 | i get 357 rows in set (0.09 sec) on the original equivalent |
| 05:37:00 | raptor | haha |
| 05:37:00 | raptor | so mysql 5.1 doesn't have the problem |
| 05:38:00 | raptor | watusimoto should return with results and minute now :) |
| 05:38:00 | watusimoto | I'm listenting to all things considered... they did a story on bitcoin |
| 05:38:00 | watusimoto | never expected to hear that |
| 05:38:00 | sam686 | my version of mysql might be about 6 months outdated (i installed mysql / phpbb at sept 14, 2010) |
| 05:39:00 | raptor | so bitcoin boggles the brain |
| 05:40:00 | sam686 | actually, both the original and new one is about the same on my database (averages to 0.10 seconds) |
| 05:41:00 | raptor | watusimoto: were you able to execute that second query? |
| 05:41:00 | raptor | sam686: they should be the same server-side, but if my theory is correct, then in mysql 5.0 and earlier they weren't |
| 05:41:00 | watusimoto | still plugging away |
| 05:42:00 | raptor | oh man |
| 05:43:00 | raptor | i'm hoping it matches the same numbe of rows |
| 05:43:00 | raptor | as long as sam hasn't completed another game.... |
| 05:43:00 | watusimoto | yeah, this query sucks |
| 05:43:00 | sam686 | i am not in game, so it shouldn't change number of rows.. |
| 05:45:00 | sam686 | umm did you forget a ; and think it is running a query? |
| 05:45:00 | watusimoto | ; is there |
| 05:46:00 | watusimoto | I think it's running |
| 05:46:00 | watusimoto | mysql is at 25% cpu |
| 05:46:00 | watusimoto | 263 rows in set (9 min 22.41 sec) |
| 05:47:00 | raptor | yes! |
| 05:47:00 | sam686 | thats a long time.. |
| 05:47:00 | raptor | that's is so bad it is absolutely amazing |
| 05:47:00 | watusimoto | but are they they same rows? |
| 05:47:00 | sam686 | no one ever going to wait that long for a page to load.. |
| 05:47:00 | raptor | sam686 can you confirm? |
| 05:47:00 | sam686 | confirm the speed results on my database? |
| 05:48:00 | raptor | do a quick diff on one of the colums between the two queries |
| 05:48:00 | sam686 | ok |
| 05:48:00 | raptor | confirm they are the same rows between the two queries |
| 05:48:00 | raptor | watusimoto: can you send my the current index.php that is under gamereports/ on that server? |
| 05:49:00 | sam686 | new query: 357 rows in set (0.14 sec) |
| 05:49:00 | sam686 | origonal query 357 rows in set (0.13 sec) |
| 05:49:00 | raptor | sam686: are you comparing rows? |
| 05:50:00 | sam686 | i was inputting the 2 different queries.. |
| 05:50:00 | sam686 | the two query i input was http://pastie.org/pastes/1969710 and http://pastie.org/pastes/1969723 |
| 05:50:00 | watusimoto | it's in the ~ folder on the game server |
| 05:52:00 | raptor | thanks |
| 05:52:00 | raptor | sam686, if you aren't doing so, can you compare the outputs of the two queries to make sure they match? |
| 05:56:00 | sam686 | seems to be the same order.. |
| 05:56:00 | raptor | excellent |
| 05:59:00 | watusimoto | committed editor changes |
| 05:59:00 | watusimoto | still lots broken |
| 05:59:00 | watusimoto | but I think this is the final structure for a while |
| 05:59:00 | raptor | yay! |
| 06:00:00 | raptor | also |
| 06:00:00 | raptor | the new index.php is on the game server |
| 06:00:00 | watusimoto | same place? |
| 06:00:00 | raptor | yep |
| 06:00:00 | raptor | ~ |
| 06:00:00 | watusimoto | OK |
| 06:00:00 | raptor | so want to know the problem? |
| 06:00:00 | | BitfighterLogBot - Commit 59e88ac2d62c | Author: watusim...@bitfighter.org | Log: More progress on using embedded geometry |
| 06:00:00 | watusimoto | ok |
| 06:00:00 | | BitfighterLogBot - Commit 11b6f16d7b10 | Author: watusim...@bitfighter.org | Log: Merge |
| 06:00:00 | watusimoto | file updated on server |
| 06:01:00 | raptor | i guess mysql 5.0 and earlier suffered from a much lower performance server-side query optimizer |
| 06:01:00 | sam686 | you can test my database, shown in http://96.2.123.136/upload/1/db_functions.php.txt |
| 06:01:00 | raptor | which oracle has had for a while |
| 06:01:00 | sam686 | oops, not localhost |
| 06:02:00 | raptor | so basically a query with a sub-query wasn't optimized very well, and in fact was worse performing |
| 06:02:00 | sam686 | you can test my database with $server = "96.2.123.136:3306"; |
| 06:02:00 | raptor | but if you changed your sub-query into an inner-join, the optimizer made it work fine |
| 06:02:00 | raptor | and all is well with the world |
| 06:02:00 | sam686 | you can test my database with server = "96.2.123.136:3306"; |
| 06:02:00 | sam686 | oops i thoughe it failed to output on my IRC.. |
| 06:05:00 | raptor | thanks sam, i tested the outputs - they are identical |
| 06:05:00 | raptor | http://bitfighter.org/gamereports/ is MUCH faster now |
| 06:06:00 | watusimoto | great! |
| 06:06:00 | raptor | that 9 minute query took 5 seconds in my browser :) |
| 06:09:00 | sam686 | might want to check my version of gameStats php - http://96.2.123.136/upload/1/index.php.txt I might have change it slightly (i think it is when 2 games ends at exactly the same time stamps) |
| 06:10:00 | raptor | here is the one on bitfighter.org now: http://96.2.123.136/upload/11index.php_ |
| 06:10:00 | raptor | oh man, i'm falling asleep fast |
| 06:14:00 | raptor | wow watusimoto, that's a lot of changed files |
| 06:15:00 | sam686 | i might as well update, i don't see anything i have changed when reading diffs ( its a long time ago... ) |
| 06:16:00 | raptor | one of these days linux will work again, i promise.. |
| 06:18:00 | watusimoto | I've been working hard! |
| 06:20:00 | raptor | sam686, what was broken with the previous geometric sort? |
| 06:21:00 | sam686 | i think the sort was expecting a function that returns bool, where qsort expects function to return S32 |
| 06:21:00 | raptor | ah ok |
| 06:21:00 | sam686 | i was getting Asserts failuer, "invalid operator <" |
| 06:29:00 | watusimoto | raptor: how hard would it be to make a frequency analysis of the game stat data? plot # games per day played or soemthing |
| 06:29:00 | watusimoto | to measure trends in playership |
| 06:29:00 | watusimoto | or number of players |
| 06:29:00 | watusimoto | or... |
| 06:29:00 | raptor | probably not hard, however i do not have experience with graphs |
| 06:30:00 | watusimoto | these stats seem odd: |
| 06:30:00 | watusimoto | Game ending on 24 May 2011 04:22:43 PM |
| 06:30:00 | watusimoto | oh, maybe not |
| 06:30:00 | watusimoto | I didn't realize it was ctf |
| 06:30:00 | watusimoto | looks like it was just a killfest |
| 06:31:00 | watusimoto | I saw all the kils and a 0-0 score |
| 06:31:00 | watusimoto | but that could be |
| 06:31:00 | sam686 | a single team capture the flag? |
| 06:31:00 | watusimoto | no, red v green |
| 06:31:00 | watusimoto | 4 humans v a ton or robots |
| 06:31:00 | watusimoto | rupert, sam, s_bot, footloose |
| 06:31:00 | watusimoto | v38 bots |
| 06:31:00 | sam686 | maybe, and does kills counts killing your team with mines? |
| 06:32:00 | watusimoto | raptor -- when I make quick and dirty graphs, I just make the bars horizontal and print *s |
| 06:32:00 | watusimoto | :-) |
| 06:32:00 | raptor | ah |
| 06:32:00 | watusimoto | could probably do something similar with table cells |
| 06:32:00 | raptor | and here i was researching a php graph framework: http://jpgraph.net/ |
| 06:33:00 | watusimoto | wow |
| 06:33:00 | sam686 | i remember, i was doing /addbots 50 0 "" (empty string scripts will create a robot that do absolutely nothing) |
| 06:33:00 | watusimoto | maybe you can just plug a query into that package |
| 06:33:00 | raptor | that's what i was hoping |
| 06:33:00 | watusimoto | there's a tutorial |
| 06:34:00 | watusimoto | only 750 pages |
| 06:34:00 | watusimoto | better start reading |
| 06:34:00 | watusimoto | you have a long night |
| 06:34:00 | raptor | haha |
| 06:34:00 | raptor | and i'm almost unconscious as it is.. |
| 06:35:00 | watusimoto | http://jpgraph.net/features/src/show-example.php?target=new_bar1.php |
| 06:35:00 | watusimoto | pretty easy! |
| 06:35:00 | watusimoto | most of that is configuring colors |
| 06:35:00 | raptor | that's awesome! |
| 06:35:00 | watusimoto | indeed |
| 06:35:00 | raptor | ok, what do we need for the data |
| 06:36:00 | watusimoto | run a query, dump results into an array, set some colors, plot |
| 06:37:00 | watusimoto | that's the real quesion! |
| 06:37:00 | watusimoto | easy but not terribly useful is #games per day |
| 06:37:00 | watusimoto | maybe #players per day |
| 06:37:00 | watusimoto | ? |
| 06:37:00 | watusimoto | maybe #GAMES per day is good |
| 06:38:00 | raptor | all three! |
| 06:38:00 | watusimoto | oh wait, we're not logging testing games 9from editor), so maybe #games is good |
| 06:38:00 | watusimoto | sure |
| 06:38:00 | watusimoto | I'm just interested in some trends of how the game is doing |
| 06:39:00 | raptor | ok, let me whip something up real fast - now that i have access to sam's db :) |
| 06:39:00 | watusimoto | maybe we can make a mongo plot of players v games played for the current month or something |
| 06:39:00 | watusimoto | just to encourage people to get their numbers up:-) |
| 06:40:00 | watusimoto | ok, too much for now, but maybe this is a good time to start thiking about a leaderboard |
| 06:40:00 | watusimoto | we have plenty of data |
| 06:41:00 | raptor | sam686: can i export your database for my own nefarious purposes? |
| 06:41:00 | raptor | i ask because it may be some network traffic for you for a minute or two.. |
| 06:41:00 | sam686 | ok.. you can if your want.. |
| 06:42:00 | sam686 | my internet is about 2 Mbps upload and 20 Mbps downloads.. |
| 06:43:00 | raptor | bah - my query analyzer won't let me grab the whole db |
| 06:45:00 | watusimoto | boo |
| 06:45:00 | raptor | i'm getting it table by table |
| 06:45:00 | raptor | got it, thanks sam686 |
| 06:59:00 | watusimoto | get some sleep -- do it tomorrow |
| 06:59:00 | raptor | aye aye |
| 06:59:00 | sam686 | bye.. |
| 06:59:00 | raptor | night |
| 07:00:00 | watusimoto | night |
| 07:00:00 | sam686 | i will be going to bed in maybe about 10 minutes. |
| 07:01:00 | watusimoto | night as well |
| 07:01:00 | watusimoto | me too, if this works soon |
| 07:01:00 | watusimoto | I'm in dangerous territory... messing with bot zones |
| 07:01:00 | raptor | uh oh |
| 07:01:00 | watusimoto | trying to get them to use the same new geometry methods |
| 07:01:00 | watusimoto | I'm having certain... compilation difficulties |
| 07:02:00 | watusimoto | this new method is so cool! have to use it everywhere! |
| 07:02:00 | raptor | just please don't use pointainer |
| 07:02:00 | watusimoto | nope |
| 07:02:00 | watusimoto | that should be removed. |
| 07:02:00 | watusimoto | I |
| 07:03:00 | watusimoto | I'll do it if no one else does |
| 07:03:00 | sam686 | i made conversion to TypeNumbers for BotNavMeshZones, so no longer needs typeMask for bot zones... might want to figure out LUA bot script for typeNumbers instead of typeMask.. |
| 07:03:00 | sam686 | for bot:findObjects(...) |
| 07:03:00 | raptor | please |
| 07:04:00 | sam686 | raptor says pointainer won't work in linux... |
| 07:04:00 | watusimoto | it will be removed |
| 07:16:00 | raptor | ah much better... |
| 07:16:00 | raptor | if you discount the robots stats are actually meaningful |
| 08:17:00 | | raptor Quit (Remote host closed the connection) |
| 08:51:00 | | BitfighterLogBot - Commit aac2f46868ac | Author: watusim...@bitfighter.org | Log: Apply new geometry technique to botzones, moved core methods to BfObject |
| 08:51:00 | | BitfighterLogBot - Commit 6721ec9c2ea1 | Author: watusim...@bitfighter.org | Log: Simplify, get rid of extraneous methods |
| 09:01:00 | | BitfighterLogBot - Commit 8bdf38438c6e | Author: watusim...@bitfighter.org | Log: Killed the venerable Polyline class... RIP, my friend. |
| 09:11:00 | | BitfighterLogBot - Commit ef0af473e90a | Author: watusim...@bitfighter.org | Log: Get rid of convex from botzones |
| 09:16:00 | | watusimoto Quit (Ping timeout: 276 seconds) |
| 10:04:00 | | sam686 has left |
| 10:20:00 | | sam686 has joined |
| 10:20:00 | | ChanServ sets mode +v sam686 |
| 10:58:00 | | sam686 has left |
| 15:35:00 | | raptor has joined |
| 15:35:00 | | ChanServ sets mode +o raptor |
| 16:12:00 | | watusimoto has joined |
| 16:12:00 | raptor | hi |
| 16:12:00 | raptor | i have graphs done |
| 16:12:00 | raptor | not perfect |
| 16:13:00 | raptor | except they depend on the php-gd extension - i do not know if it exists on the master server erver |
| 16:49:00 | watusimoto | how would I tell? |
| 16:49:00 | watusimoto | we could probably install it if it's something that can be done without root |
| 16:54:00 | watusimoto | I found this line last night: |
| 16:54:00 | watusimoto | void processLevelLoadLine(U32 argc, U32 id, const char **argv) { /* TODO: Fill this in! */} |
| 16:54:00 | watusimoto | in the editor |
| 16:55:00 | watusimoto | it seems like a rather important thing to be missing |
| 17:23:00 | | watusimoto Quit (Ping timeout: 260 seconds) |
| 17:43:00 | | watusimoto has joined |
| 17:47:00 | raptor | i put the archive called 'graphs.tar.gz' on the game server^2 |
| 17:47:00 | raptor | just extract it into the gamereports/ directory |
| 17:47:00 | watusimoto | ah, great |
| 17:47:00 | watusimoto | ok, will do |
| 17:47:00 | raptor | then go to bitfighter.org/gamereports/graphs/ |
| 17:48:00 | raptor | if it fails, then you don't have the php-gd extension installed |
| 17:48:00 | raptor | but that is a common extension |
| 17:49:00 | watusimoto | unpacked |
| 17:50:00 | watusimoto | working, mostly |
| 17:53:00 | raptor | what the heck is that warning |
| 17:53:00 | raptor | but cool |
| 17:53:00 | raptor | err... the day filter isn't working |
| 17:53:00 | raptor | weird |
| 17:56:00 | raptor | huh - that day filter should be working |
| 18:04:00 | raptor | what version of php is on that server? php --version |
| 18:06:00 | raptor | i know the problelm... |
| 18:06:00 | raptor | let me get you a new archive |
| 18:25:00 | watusimoto | PHP 5.2.13 (cli) (built: May 6 2010 16:12:26) |
| 18:25:00 | watusimoto | with zend |
| 18:30:00 | raptor | ok |
| 18:31:00 | raptor | I finished fixing/tidying the graph |
| 18:31:00 | raptor | a new archive is copied to the game server |
| 18:31:00 | raptor | please wipe out the old graphs folder completely |
| 18:32:00 | watusimoto | ok |
| 18:33:00 | watusimoto | done |
| 18:34:00 | raptor | um |
| 18:34:00 | raptor | did you put it in the correct place? |
| 18:34:00 | watusimoto | let me see |
| 18:35:00 | raptor | or move the db_functions.php elsewhere? |
| 18:35:00 | watusimoto | ah, no |
| 18:35:00 | watusimoto | all in the graphs subfolder |
| 18:35:00 | watusimoto | I'll move it up |
| 18:35:00 | raptor | ok phoew |
| 18:35:00 | watusimoto | ok |
| 18:38:00 | raptor | now gamereports is missing, too.. |
| 18:42:00 | watusimoto | oh super crap |
| 18:42:00 | watusimoto | I screwed up big time |
| 18:42:00 | watusimoto | ok, hold on |
| 18:43:00 | raptor | if you overwrote the gamereports index.php - it is still found on the game server |
| 18:44:00 | watusimoto | I clobbered everything |
| 18:44:00 | watusimoto | I've copied index.php back from the server |
| 18:44:00 | watusimoto | and graphs as well |
| 18:45:00 | watusimoto | but there must have been other supporting files which are now gone |
| 18:45:00 | watusimoto | like dbfunctions.php? |
| 18:46:00 | watusimoto | too tired |
| 18:48:00 | raptor | db_functions.php |
| 18:48:00 | raptor | here is a sample copy: http://96.2.123.136/upload/db_functions.php_ |
| 18:48:00 | watusimoto | yes |
| 18:48:00 | watusimoto | sigh. ok! |
| 18:48:00 | watusimoto | this is a bad day |
| 18:48:00 | raptor | you only have to alter the data at the top |
| 18:49:00 | raptor | no problem |
| 18:50:00 | watusimoto | ok, stats page back up |
| 18:50:00 | watusimoto | sort of |
| 18:50:00 | watusimoto | probably used wrong db |
| 18:51:00 | watusimoto | ok, looking better |
| 18:51:00 | watusimoto | graphs working better |
| 18:52:00 | raptor | hooray! |
| 18:52:00 | watusimoto | ok, all seems to be working well now |
| 18:52:00 | watusimoto | thanks! |
| 18:52:00 | raptor | mission accomplished |
| 18:52:00 | watusimoto | indeed. one tweak... can you make the right side of the graph go up a little more? |
| 18:52:00 | watusimoto | :-) |
| 18:52:00 | raptor | ok |
| 18:53:00 | raptor | what do you mean 'right side' ? |
| 18:53:00 | watusimoto | actually, we should probably not show current days data, as that will always make things seem pessimistic |
| 18:53:00 | watusimoto | I just meant that the graphs show slightly falling usage |
| 18:53:00 | watusimoto | I wanted to make them show increasing usage |
| 18:53:00 | watusimoto | I was joking |
| 18:53:00 | raptor | getting into politics i see? |
| 18:53:00 | watusimoto | just trying to justify all the work :-) |
| 18:53:00 | raptor | haha |
| 18:54:00 | raptor | ok, i can probably chop off the current day |
| 18:54:00 | raptor | makes sense, anyways |
| 18:54:00 | watusimoto | actually, this isn't bad... wild fluccuations, but overall a fairly even graph |
| 18:55:00 | watusimoto | and we had our all-time peak just this month |
| 18:56:00 | watusimoto | 78 games yesterday isn't really that bad! |
| 18:56:00 | watusimoto | with 20+ unique players |
| 18:56:00 | watusimoto | not exactly facebook |
| 18:56:00 | watusimoto | but maybe better than myspace |
| 18:57:00 | raptor | haha |
| 18:57:00 | raptor | ok, i put a new 'graphs.php' on the game server |
| 18:57:00 | raptor | overwrite the one in gamereports/graphs/ |
| 18:57:00 | watusimoto | ok |
| 18:58:00 | watusimoto | oh, much better |
| 19:05:00 | raptor | not exactly google graphs, but not too bad, i think.. |
| 19:07:00 | watusimoto | not bad at all |
| 19:07:00 | watusimoto | certainly adequate for our purposes |
| 19:07:00 | watusimoto | I was looking into how to add a trendline, but that seems like a fair bit of work |
| 19:08:00 | watusimoto | so I'll skip it! |
| 19:08:00 | raptor | haha |
| 19:13:00 | watusimoto | was just looking at jqplot... same thing but client side |
| 19:19:00 | raptor | oh wow |
| 19:20:00 | raptor | i don't know how to hook into the php data with jQuery... |
| 19:20:00 | raptor | other than outputing in-script the data |
| 19:21:00 | watusimoto | I think you'd dump it to a JS array... uh, what you said |
| 19:22:00 | watusimoto | there's probably a way to have the js go back to the server to fetch the data |
| 19:23:00 | raptor | with zend, maybe |
| 19:23:00 | raptor | don't know zend, though |
| 19:23:00 | raptor | oh wait |
| 19:23:00 | raptor | actually, yes |
| 19:23:00 | raptor | i can do an AJAX request to a specific PHP |
| 19:26:00 | watusimoto | that's probably the proper way to do it, though if the data isn't changing, and the initial download isn't too heavy... why bother? |
| 19:49:00 | raptor | so... basically we are ok for now? |
| 20:06:00 | watusimoto | totally ok |
| 20:22:00 | | sam686 has joined |
| 20:22:00 | | ChanServ sets mode +v sam686 |
| 21:20:00 | sam686 | i see a problem with stats sending. When it is too big to send stats, my server stops sending anymore stats... it stopped since Game ending on 24 May 2011 06:20 ... (PM) And my server starts sending stats after my server re-connect to master.. |
| 21:22:00 | sam686 | all my server stats did go here... http://96.2.123.136/upload/1/index.php it stopped sending stats when there is 100 bots.. |
| 21:50:00 | | raptor Quit (Remote host closed the connection) |
| 22:05:00 | | koda has joined |
| 23:10:00 | | watusimoto slaps watusimoto with a large smelly trout |
| 23:10:00 | | watusimoto slaps watusimoto with a large smelly trout |
| 23:26:00 | | koda Quit (Quit: koda) |
| 23:33:00 | | raptor has joined |
| 23:33:00 | | ChanServ sets mode +o raptor |
| 23:34:00 | raptor | smelly trout? i don't get it |
| 23:34:00 | sam686 | probably used hydra, right click name, and choost "Slap" |
| 23:40:00 | watusimoto | I wasn't sure that went out to everyone or was printed locally |
| 23:40:00 | watusimoto | yes, hydra, slap |
| 23:40:00 | | watusimoto slaps raptor upside da head with a hairy goldfish |
| 23:40:00 | | watusimoto pops down the farm, grabs a Shetland Pony and slaps sam686 with it! |
| 23:40:00 | | sam686 dusts off a kitchen towel and slaps it at BitfighterLogBot |
| 23:41:00 | watusimoto | well, this is a delightful new feature! |
| 23:41:00 | | raptor raptor stares in awe |
| 23:41:00 | raptor | fail |
| 23:41:00 | | raptor fails miserably |
| 23:41:00 | | sam686 uses /me command |
| 23:45:00 | raptor | sam686: did you see http://bitfighter.org/gamereports/graphs/ |
| 23:47:00 | sam686 | ok, i see that, game count and unique player count.. |
| 23:48:00 | sam686 | it looks like i don't see increase number of players.. |
| 23:51:00 | watusimoto | another metric we could graph would be player-games; the daily sum of the number of human players in each game |
| 23:52:00 | watusimoto | that might be a measure of "intensity" of play |
| 23:54:00 | raptor | that's easy enough |
| 23:55:00 | raptor | on the same graph? |