Timestamps are in GMT/BST.
| 00:34:05 | raptor | so tell me about your database additions? one fake materialized view with a trigger to refresh it every so often? |
| 00:41:05 | kaen | two triggers to update it on insertions |
| 00:41:17 | kaen | one for stats_player and stats_player_shots each |
| 00:41:27 | raptor | two? |
| 00:41:33 | kaen | yes |
| 00:42:00 | raptor | so you insert the stats_player data first, then later add back in the shots data (and this to not do enormous joins?) |
| 00:42:22 | raptor | ^^ my guess |
| 00:42:41 | kaen | spot on. |
| 00:43:03 | raptor | dude - you're a fast learner |
| 00:43:10 | kaen | heh thanks |
| 00:45:03 | | BFLogBot - Commit 099b9d9fec88 | Author: buckyballreaction | Log: Fix compile warnings |
| 00:49:36 | raptor | dinner time! |
| 00:49:38 | raptor | oh |
| 00:49:40 | raptor | also |
| 00:50:09 | raptor | if you create a directory 'public_html' in your home directory you can have stuff live at bitfighter.org/~kaen/ |
| 00:50:24 | kaen | awesome. thanks :) |
| 01:25:50 | raptor | mmm dinner |
| 02:08:58 | raptor | yeah, so... the classical Greeks were a messed up bunch of people.. |
| 02:11:03 | raptor | they were proud that they could be lost at sea, stumble upon a peaceful culture, sack the city, kill the men and children, take the women, then tell the story to strangers to gain favor |
| 02:26:39 | kaen | I can't disagree with that. |
| 02:26:47 | kaen | Alexander the Great was a pretty cool guy, though |
| 02:29:17 | kaen | I guess I'm just basing that off of watching reign: the conqueror though |
| 02:36:38 | kaen | I have always been a fan of pythagoras, too. Something about a cult of mathematics is appealing to me. |
| 02:42:40 | raptor | haha |
| 03:13:36 | | raptor Quit () |
| 03:30:47 | | BFLogBot - Commit e5e7cdd2d4d5 | Author: buckyballreaction | Log: Hopefully handle all remaining cases of interrupting engineered teleport exit placement |
| 04:20:00 | | raptor has joined |
| 04:20:01 | | ChanServ sets mode +o raptor |
| 04:36:08 | kaen | raptor, I uploaded the stats stuff to ~/gamereports |
| 04:36:18 | raptor | hi |
| 04:36:22 | kaen | you'll have to run the sql queries before the scripts will work |
| 04:36:24 | kaen | hello :) |
| 04:36:40 | raptor | ok, let me look... |
| 04:36:59 | kaen | when I did that locally, I got an error regarding utf8_unicode_ci blah blah |
| 04:37:14 | kaen | which necessitated my converting the charsets of the tables involved to match |
| 04:37:58 | raptor | wait wait... |
| 04:38:07 | raptor | what was the original charset? |
| 04:39:06 | raptor | oh good, you excluded robots |
| 04:40:03 | kaen | I think it was because my table (player_mv) was created with utf8_general_ci, and the ones imported were utf8_unicode_ci |
| 04:40:17 | raptor | ah |
| 04:40:18 | raptor | yes |
| 04:40:28 | raptor | i always do stuff unicode... |
| 04:40:29 | kaen | either will work, they just need to match |
| 04:40:36 | raptor | habit from work |
| 04:40:48 | raptor | someday we'll have japanese translations! |
| 04:40:55 | kaen | :) |
| 04:42:07 | | raptor analyzed the triggers... |
| 04:42:14 | raptor | analyzes... |
| 04:42:17 | kaen | oh good |
| 04:42:37 | raptor | wow |
| 04:42:39 | raptor | so |
| 04:42:56 | raptor | you: insert in the mv if it's a new player |
| 04:43:06 | raptor | if not, you update the old with new calculations |
| 04:43:22 | kaen | yep |
| 04:43:42 | raptor | i don't think i've ever created a trigger this complex before... |
| 04:44:00 | kaen | it looks more complex than it is because of the damn pivot tables |
| 04:44:10 | kaen | er, I guess it really is that complex |
| 04:44:21 | kaen | but it shouldn't be @_@ |
| 04:44:21 | raptor | what do you consider pivot tables? |
| 04:44:38 | kaen | those if() cascades |
| 04:44:50 | kaen | were referred to as pivot tables in some stuff I was reading |
| 04:45:02 | raptor | question |
| 04:45:28 | raptor | if i use all 5 weapons in a match, is that trigger launched 5 times for my one player? |
| 04:45:41 | raptor | or will it depend on if i insert all 5 rows at once? |
| 04:45:49 | kaen | yes, because stats_player_shots will have 5 insertions |
| 04:46:07 | raptor | have you tested speed of these triggers? |
| 04:46:48 | kaen | takes ~5 minutes to insert all of stats_player and stats_player_shot with these triggers on my laptop |
| 04:46:56 | kaen | is the best I can give you |
| 04:47:01 | kaen | oh, that was with bots included |
| 04:47:26 | raptor | evil bots |
| 04:47:31 | kaen | yes |
| 04:47:57 | kaen | oops |
| 04:48:07 | raptor | yes? |
| 04:48:10 | kaen | just tried to use the mysql shell in ssh window >.< |
| 04:48:16 | raptor | haha |
| 04:49:34 | raptor | ok, table and triggers set-up... |
| 04:49:49 | kaen | the suspense is killing me |
| 04:49:54 | raptor | hehe |
| 04:50:18 | kaen | deployments always get me worked up :P |
| 04:51:49 | raptor | oh good, you figured out that i safely kept the credentials in a separate php file |
| 04:52:09 | raptor | i suppose that wasn't hard to figure out.. |
| 04:52:12 | kaen | heh |
| 04:52:14 | raptor | but you kept it that way... thanks |
| 04:52:28 | kaen | you bet |
| 04:52:37 | raptor | first run... |
| 04:52:43 | raptor | http://bitfighter.org/gamereports/stats.php |
| 04:52:56 | kaen | :) |
| 04:53:01 | raptor | it works!! |
| 04:53:14 | raptor | it's ALIIIIIVE!! |
| 04:53:25 | kaen | lol |
| 04:53:44 | raptor | your search beats the pants off of my crude one on gamereports... |
| 04:54:04 | raptor | ok, testing trigger... |
| 04:58:38 | kaen | muahahhahahahahhha |
| 04:58:44 | kaen | VICTORY! |
| 04:58:49 | raptor | it works!!! |
| 04:58:53 | raptor | splendid! |
| 04:58:58 | kaen | I honestly can not believe it |
| 04:59:02 | raptor | ok, now the real test... |
| 04:59:14 | raptor | post about it in the forums under announcements :) |
| 04:59:15 | kaen | :o |
| 04:59:29 | kaen | me? |
| 04:59:31 | raptor | actually wait |
| 04:59:34 | kaen | alright |
| 04:59:48 | raptor | let me do some restructuring... |
| 04:59:56 | kaen | you got it |
| 05:00:11 | kaen | I'll be back in just a few |
| 05:12:10 | kaen | back |
| 05:12:15 | raptor | ok, almost done |
| 05:14:16 | raptor | ok, on the server at /var/www/html/stats |
| 05:14:28 | raptor | i gave you access to your three files to update it directly |
| 05:14:32 | raptor | *to update |
| 05:14:41 | kaen | awesome! |
| 05:17:28 | raptor | ok, this is crude: http://bitfighter.org/stats/ |
| 05:18:12 | raptor | so, i can post in the anouncements if you want me to - but maybe you'd provide more shock value since the community knows you less? :) |
| 05:18:25 | kaen | I'd love to :) |
| 05:24:40 | raptor | well, i think it's a job fantastically done |
| 05:24:59 | kaen | thanks. I don't think it's done though ^^ |
| 05:25:31 | raptor | the fans will scream for more, i'm sure... |
| 05:25:38 | raptor | also hobbies are never done... |
| 05:25:50 | kaen | too true |
| 05:33:04 | kaen | and now we wait for the money to roll in! |
| 05:33:11 | raptor | hahaha |
| 05:33:13 | raptor | hee hee |
| 05:33:15 | raptor | hoo hoo |
| 05:33:19 | kaen | :) |
| 05:44:55 | raptor | good post! |
| 05:45:12 | kaen | thanks. I'm not much for words |
| 05:45:32 | raptor | me neither - just drop the data and get outta there.. |
| 05:45:45 | kaen | exactly |
| 05:46:33 | raptor | would you like to do some testing with the teleports with me? that last commit of mine fixed a bunch.. |
| 05:46:44 | kaen | you bet |
| 05:46:48 | kaen | lemme update |
| 05:47:29 | kaen | 19 changesets. I guess it's been a while :P |
| 05:48:14 | raptor | watusimoto loves to do like 10 at once |
| 05:48:28 | raptor | usually cleaning up my formatting errors... :/ |
| 05:48:33 | kaen | alright I've rebuilt |
| 05:48:34 | kaen | lol |
| 05:48:40 | raptor | ok |
| 05:48:49 | raptor | i'm the 69.169... server |
| 05:49:07 | kaen | -.- |
| 05:49:09 | kaen | segfault |
| 05:49:20 | kaen | rebuild *harder* |
| 05:49:20 | raptor | did you do a full rebuild? |
| 05:49:27 | raptor | (I changed loads of headers...) |
| 05:49:29 | kaen | no, I was hoping I would get lucky |
| 05:49:32 | kaen | heh |
| 05:49:36 | raptor | ha |
| 05:51:36 | raptor | how long does it take you to fully compile? |
| 05:51:51 | raptor | I usually just do the zap/ directory to shave off some time... |
| 05:51:59 | kaen | something like 3-4 minutes |
| 05:52:20 | kaen | doing Triangle right now, should be almost done |
| 05:52:27 | raptor | ahh triangle |
| 05:52:39 | raptor | that's the library that would keep us from selling the game... |
| 05:52:41 | raptor | :) |
| 05:54:33 | sam686 | i haven't been looking at bitfighter for a few days, until just now.... found 2 files with mixed line ending.. |
| 05:55:04 | raptor | hi sam686 |
| 05:55:11 | raptor | compile the latest and join my server |
| 05:55:45 | sam686 | compiling... it takes about 4 minutes for me to full compile zap... |
| 05:56:42 | sam686 | i think i have one more minute to finish compiling.. |
| 05:56:50 | raptor | yay |
| 05:57:26 | sam686 | done, now running it.. |
| 06:06:55 | raptor | night kaen |
| 06:21:00 | raptor | good ngiht! |
| 06:21:05 | sam686 | night.. |
| 06:21:07 | | raptor Quit () |
| 06:59:49 | | sam686 Quit () |
| 07:33:56 | | Watusimoto has joined |
| 08:21:28 | | koda has joined |
| 08:56:02 | | Watusimoto Quit (Read error: Connection reset by peer) |
| 10:14:56 | | koda Quit (Quit: koda) |
| 10:24:42 | | LordDVG has joined |
| 10:31:40 | | Watusimoto has joined |
| 10:57:55 | | Watusimoto Quit (Ping timeout: 260 seconds) |
| 11:31:55 | | koda has joined |
| 12:07:08 | | koda Quit (Quit: koda) |
| 12:18:39 | | koda has joined |
| 13:39:29 | | koda Quit (Quit: koda) |
| 13:56:32 | | raptor has joined |
| 13:56:32 | | ChanServ sets mode +o raptor |
| 14:04:46 | | aussiebitfighter has joined |
| 14:06:14 | | aussiebitfighter has left |
| 14:47:00 | | BFLogBot - Commit 9ef35a1819fc | Author: buckyballreaction | Log: Fix game lobby chatting (again,) this time when there are servers in the list |
| 15:07:03 | | BFLogBot - Commit 2f2312d181a3 | Author: buckyballreaction | Log: Engineered teleporters are harder to destroy; they have same health as other engineered items. Do we need some sort of health feedback? |
| 15:27:48 | | koda has joined |
| 15:40:34 | | Watusimoto has joined |
| 16:07:39 | | Watusimoto Quit (Ping timeout: 272 seconds) |
| 16:46:40 | | Watusimoto has joined |
| 16:48:40 | Watusimoto | hi |
| 16:55:14 | kaen | ahoy |
| 17:05:45 | | raptor Quit () |
| 17:33:51 | Watusimoto | ahoy, welcome aboard |
| 18:02:49 | | sam686 has joined |
| 18:02:49 | | ChanServ sets mode +v sam686 |
| 20:16:02 | | Watusimoto Quit (Read error: Connection reset by peer) |
| 20:17:14 | | Watusimoto has joined |
| 21:30:59 | | LordDVG Quit (Remote host closed the connection) |
| 22:35:33 | Watusimoto | I'm heading to bed |
| 22:36:22 | Watusimoto | raptor, if you read this, I did a little teleporter refactoring for my own purposes, and it touched on your stuff. I think I was able to simplify it a tiny bit, and engineering still seems to work, so... fingers crossed! |
| 22:42:47 | | BFLogBot - Commit c21f3dddca61 | Author: watusim...@bitfighter.org | Log: Remove redundant getClassId methods |
| 22:42:49 | | BFLogBot - Commit 72c9190ab7cd | Author: watusim...@bitfighter.org | Log: Move Telerporter from lunar to luaW |
| 22:42:50 | | BFLogBot - Commit 9cc66d80b448 | Author: watusim...@bitfighter.org | Log: Delegate teleporter destination management to a new class |
| 22:42:52 | | BFLogBot - Commit 20c223b286f1 | Author: watusim...@bitfighter.org | Log: Formatting |
| 22:42:53 | | BFLogBot - Commit 2b4e8a8cc901 | Author: watusim...@bitfighter.org | Log: Removed some variables, reworked some things, and now teleporters can be added from Lua scripts WITHOUT crashing. Except they go nowhere, and I had to remove teleporters from the editor to avoid crashes. This needs to be fixed, obviously. |
| 22:42:55 | | BFLogBot - Commit 30de070c896f | Author: watusim...@bitfighter.org | Log: Now, without explanation, teleporter works in the editor again... perhaps it was that whitespace I added in teleporter.cpp |
| 22:42:56 | | BFLogBot - Commit 7e3c2a5a7032 | Author: watusim...@bitfighter.org | Log: Merge -- hope I got it right! |
| 22:52:59 | | BFLogBot - Commit 14101eb43d33 | Author: watusim...@bitfighter.org | Log: Comment |
| 22:55:25 | | Watusimoto Quit (Ping timeout: 260 seconds) |
| 23:18:13 | | raptor has joined |
| 23:18:14 | | ChanServ sets mode +o raptor |
| 23:42:29 | raptor | yeah |
| 23:42:40 | raptor | teleporter still works after his refactor... phoew! |
| 23:42:46 | raptor | or is it: phew! |
| 23:42:51 | raptor | or whew! |
| 23:48:05 | | BFLogBot - Commit bff24ec61db0 | Author: buckyballreaction | Log: Fix compiling in Linux. Why was a pointer used for teleport destinations? |
| 23:51:30 | | koda Quit (Quit: koda) |