Timestamps are in GMT/BST.
| 00:00:01 | Watusimoto | we can do a lot of work to make it marginally harder |
| 00:00:24 | karamazovapy | I'm just pointing it out - some of our members actually seem to crave negative attention |
| 00:00:31 | Watusimoto | but you can always cook up a level to make getting a particular achieement easy |
| 00:00:37 | Watusimoto | yup |
| 00:00:50 | karamazovapy | I mean for everything |
| 00:00:52 | raptor | maybe ultimately we'll just have to wield the sword of bans and achievement deletion |
| 00:01:07 | Watusimoto | but is a cooked level even cheating? |
| 00:01:20 | Watusimoto | I mean it is in once sense, but not in another |
| 00:01:23 | karamazovapy | I think the easy achievements will be meaningless because they'll all be gotten in a matter of days after their release |
| 00:01:33 | Watusimoto | yes |
| 00:01:45 | Watusimoto | we do want some that are easy though |
| 00:02:02 | raptor | like 'download bitifighter!' |
| 00:02:07 | raptor | that's an easy one... |
| 00:02:10 | karamazovapy | well...yes, but I'd make them more community-based or experience-based than game-performance-related |
| 00:02:11 | raptor | we need more of that |
| 00:02:15 | sam686 | one problem is when there is so many achievements, it doesn't seem to fit in the score board |
| 00:02:21 | Watusimoto | I'm not making any final decisions on what our first achievent should be until i get a little feedback from my proposal |
| 00:02:26 | Watusimoto | sam686: yes |
| 00:02:44 | Watusimoto | 2 ideas -- badges aer currently 10x10 |
| 00:02:57 | Watusimoto | could show 2 rows of 5x5 badges easily |
| 00:03:07 | Watusimoto | badges will be broken into tiers |
| 00:03:12 | Watusimoto | easy, med, hard |
| 00:03:29 | karamazovapy | each person's scoreboard will only show their own achievements, right? |
| 00:03:30 | Watusimoto | could show 10x10 for ones in the highest tier you've achieved, smaller ones for lower tiers |
| 00:03:52 | Watusimoto | I was thinking that scoreboard would show everyone's |
| 00:04:10 | Watusimoto | each client knows achievements of each other player |
| 00:04:24 | Watusimoto | so the only limiation is screen space |
| 00:04:38 | karamazovapy | currently connected players, or all registered players? |
| 00:04:38 | Watusimoto | could also just display 3 easy, 5 med, 1 hard |
| 00:04:45 | raptor | not a limitation with vector graphics! :) |
| 00:04:57 | Watusimoto | only registered players can get acheivements |
| 00:05:33 | raptor | ok, well, i gotta head home |
| 00:05:38 | Watusimoto | later |
| 00:05:38 | karamazovapy | right, but will we display all registered players' achievements, or the registered players currently connected? |
| 00:05:45 | raptor | bye |
| 00:05:49 | Watusimoto | oh, only current players |
| 00:05:58 | Watusimoto | next to their name |
| 00:06:00 | | raptor Quit () |
| 00:06:18 | Watusimoto | maybe we could color their name by highest achiement won |
| 00:06:27 | karamazovapy | ohhh, so we're talking the in-game normal scoreboard here |
| 00:06:33 | Watusimoto | ah, yes, sorry |
| 00:06:49 | Watusimoto | we could tie it into the forums as well |
| 00:07:43 | Watusimoto | that was the whole issue about badges being displayed out-of-game that we went through yesterday |
| 00:07:44 | karamazovapy | I say we just let players pick the one badge they want to display |
| 00:07:52 | Watusimoto | in-game? |
| 00:08:02 | karamazovapy | yeah |
| 00:08:14 | Watusimoto | or maybe just the highest-ranknig one |
| 00:08:15 | karamazovapy | the one their most proud of |
| 00:08:38 | Watusimoto | choosing would require a mechansims for choosing, storing, and trasmitting choice |
| 00:09:09 | Watusimoto | so what do you think about the 20 flags achiemevent? |
| 00:18:02 | karamazovapy | eh - it's fine |
| 00:18:14 | karamazovapy | I'm not excited about it, but I don't really care |
| 00:20:20 | karamazovapy | you've gotten two prize CleverBot responses to each of your posts |
| 00:22:55 | Watusimoto | I never realized cleverbot was a linguist |
| 00:23:01 | Watusimoto | a cunning one at that :-) |
| 00:24:25 | | raptor has joined |
| 00:24:26 | | ChanServ sets mode +o raptor |
| 00:24:33 | raptor | ok haven't gone home yet |
| 00:24:37 | raptor | more owrk to do |
| 00:24:51 | raptor | looks like cleverbot gets the 'reading comprehension fail' achievement |
| 00:26:12 | Watusimoto | I created a stats_level table; feel free to alter |
| 00:26:35 | raptor | ok |
| 00:26:49 | karamazovapy | I've decided that CleverBot is a fitting name |
| 00:27:02 | karamazovapy | he posts things that resemble human intelligence at first blush without actually possessing any |
| 00:27:37 | raptor | game_type is not needed, it's in stats_game |
| 00:27:56 | raptor | should we move it? |
| 00:28:02 | Watusimoto | sure |
| 00:28:11 | Watusimoto | well hold on |
| 00:28:22 | Watusimoto | maybe it should *only* be in stats_level |
| 00:28:25 | raptor | and level_name in stats_game should probably point to the hash... |
| 00:28:39 | raptor | or the level id |
| 00:28:44 | Watusimoto | yes |
| 00:29:00 | Watusimoto | we can change those when we start actually collecting the level stats |
| 00:29:03 | raptor | retro-active on this may be a problem... |
| 00:29:07 | raptor | ok |
| 00:29:13 | Watusimoto | mmmm.... yes |
| 00:29:21 | Watusimoto | retroactive will be a problem |
| 00:29:30 | raptor | i can do it |
| 00:29:36 | Watusimoto | maybe leave duplicate gametype field for the moment |
| 00:30:08 | Watusimoto | can do what? |
| 00:30:16 | raptor | yeah, we can collect stats, then i'll back fill the table |
| 00:30:29 | raptor | or we could start afresh |
| 00:30:52 | Watusimoto | maybe we collect both in parallel for a while, then purge the older stats when we have enough new ones |
| 00:30:57 | raptor | yes |
| 00:31:29 | Watusimoto | we really should create a weekly leaderboard |
| 00:31:37 | Watusimoto | i think we have enough to do it |
| 00:31:47 | karamazovapy | featuring what statistics? |
| 00:31:57 | raptor | would weekly mean in last 7 days, or every 7 days? |
| 00:32:02 | Watusimoto | winningiest player, most plaing player |
| 00:32:09 | Watusimoto | maybe sun-sun? |
| 00:32:20 | Watusimoto | I kind of like having an award that persists for a few days |
| 00:32:37 | Watusimoto | "didn't get it this week, maybe I can get it next week" |
| 00:32:59 | Watusimoto | that seems more satisfying than "maybe I can up my 7-day rolling average and win for a day" |
| 00:33:04 | raptor | we could probably create a view with that data... |
| 00:33:10 | Watusimoto | that would be great |
| 00:33:22 | Watusimoto | maybe what... top 3? |
| 00:33:35 | Watusimoto | people with most games (legal or illegal) |
| 00:33:43 | Watusimoto | people with most wins (legal only) |
| 00:33:46 | raptor | i'd say at least 5 |
| 00:33:49 | raptor | oh... |
| 00:33:50 | Watusimoto | ok |
| 00:33:51 | raptor | wait |
| 00:33:55 | raptor | if multiple, then 3 |
| 00:34:11 | Watusimoto | we want to reward people playing frequently, I think |
| 00:34:23 | karamazovapy | I think you want to display in parallel a "current" view and a view for the past week's winners |
| 00:34:29 | Watusimoto | but wins are only meaningful in a "official" game |
| 00:34:33 | karamazovapy | so people can track their progress |
| 00:34:42 | Watusimoto | what's current? that day? |
| 00:34:49 | raptor | we definitely should have a view with official games |
| 00:34:58 | raptor | which we can leech off of |
| 00:35:07 | Watusimoto | ah, just a filter on the games table, essentially? |
| 00:35:16 | Watusimoto | that's a great idea |
| 00:35:28 | Watusimoto | write once, use many |
| 00:35:29 | karamazovapy | if they're awards that track cumulative stats over the week, you want the current standings for the given week |
| 00:35:47 | Watusimoto | the award is being listed on the leaderboard |
| 00:35:54 | karamazovapy | so you can see that you're currently in second place, but with work you could win |
| 00:36:06 | Watusimoto | ah, so maybe last week's winners, this week's current leaders? |
| 00:36:20 | karamazovapy | right |
| 00:36:24 | Watusimoto | yes, I likeit |
| 00:36:27 | karamazovapy | but current is always changing until it becomes last week |
| 00:36:48 | Watusimoto | last week persists for a week until it;s replaced wiht this week |
| 00:36:54 | karamazovapy | right |
| 00:36:57 | Watusimoto | I like it |
| 00:37:12 | karamazovapy | as a bonus, you could do last month/this month |
| 00:37:12 | Watusimoto | let's start with that |
| 00:37:24 | karamazovapy | or even year over year |
| 00:37:30 | karamazovapy | all-time |
| 00:37:40 | raptor | i don't like all-time much... |
| 00:37:49 | raptor | because players go stale |
| 00:37:50 | Watusimoto | raptor, if you can create a view or view(s) that show that info, I'll see about adding it to the home page |
| 00:38:20 | Watusimoto | I like it from a sense of curiosity, but maybe not something on the home page |
| 00:38:33 | raptor | which data specifically? |
| 00:38:39 | karamazovapy | yeah, I'm not making any suggestions for integration, just tracking ideas |
| 00:38:59 | Watusimoto | to be clear: top 3 (or 5) week-to-date most official wins, most plays (official + unofficial) |
| 00:39:12 | Watusimoto | top 3( or 5) last week wins + plays |
| 00:39:37 | Watusimoto | player name + registerd status |
| 00:40:12 | Watusimoto | week starting at the border btween sat and sun |
| 00:40:20 | Watusimoto | PST |
| 00:40:38 | Watusimoto | or should sunday be the last day? |
| 00:41:40 | Watusimoto | including registered and unregisterd players |
| 00:42:11 | Watusimoto | who's names are ilike "watusimoto" |
| 00:42:43 | raptor | explain 'week-to-date' sunday UTC to sunday UTC, or last midnight UTC - 7 to last midnight UTC? |
| 00:43:30 | Watusimoto | week starting at the border btween sat and sun |
| 00:43:30 | Watusimoto | PST |
| 00:43:58 | karamazovapy | oh - if we're tracking anything to do with winning, do we want to think about team-changing rules? |
| 00:43:59 | Watusimoto | or border btwn sun and mon if you thinkg that's better |
| 00:44:06 | karamazovapy | or team-inequality |
| 00:44:07 | karamazovapy | ? |
| 00:44:25 | Watusimoto | @k for now... not sure how to do that |
| 00:44:40 | Watusimoto | best way is to enforce game changing rules in-game, I think |
| 00:45:03 | Watusimoto | @r -- use border btwwn sun and mon |
| 00:45:11 | raptor | sunday monday i like |
| 00:45:18 | Watusimoto | so if players are up late on saturday they won't spill over |
| 00:45:28 | Watusimoto | and they can waste their whole weekend trying to catch up |
| 00:45:33 | karamazovapy | I'm just wondering if the "winning" team in a 3v1 game actually deserves anything for it |
| 00:46:02 | Watusimoto | this is a question that we won't resolve tonight |
| 00:46:04 | Watusimoto | but |
| 00:46:16 | Watusimoto | I think there are limits to what we can do |
| 00:46:51 | Watusimoto | I think if we restrict team changing to be from winning teams to losing teams, and from teams with more players to ones with fewer players, that will help |
| 00:47:04 | raptor | ok heading out again, i'll work more on this later.. |
| 00:47:09 | Watusimoto | later! |
| 00:47:14 | | raptor Quit () |
| 00:47:47 | Watusimoto | if you play a game that's 3v3 and one player on losing team quits in the last minute, why should winning 3 not get credit? |
| 00:48:31 | Watusimoto | but if it's you and sam686 v me & raptor, that's such an unfair lineup that it shouldn't count |
| 00:48:50 | Watusimoto | there are real mesurement difficulties here |
| 00:49:36 | Watusimoto | so in your 3v1 scenario, how did those teams come about? |
| 00:49:56 | Watusimoto | 3v3 and 2 players quit at the last minute? |
| 00:50:03 | Watusimoto | 2v2 and one player switchted teams? |
| 00:50:25 | sam686 | 3 vs 2, a player left, now it becomes 3 vs 1 |
| 00:50:39 | Watusimoto | sam686 vs. me and raptor and cleverbot? and we manage to eke out a victory anyway? |
| 00:51:06 | Watusimoto | all I'm saying is that making these judgements is hard |
| 00:51:53 | Watusimoto | so I think we start with what we've got, and address the issues if it proves unfair and/or upsetting |
| 00:52:37 | sam686 | there is always a chance that, in 2 vs 1, player joins, it becomes 2 vs 2 |
| 00:52:52 | Watusimoto | exactly |
| 00:53:25 | Watusimoto | k + sam686 v. me, score is 2000 to 0, cleverbot joins, now game "looks" fair |
| 00:54:10 | sam686 | though, it might have not been fair for... half of the play time, scorint 2000 |
| 00:54:47 | sam686 | game reports only see the team stats when the game ends, but not in the start or middle of game |
| 00:57:12 | karamazovapy | I guess my expectation is that none of these achievements/rankings will actually mean anything |
| 00:57:46 | karamazovapy | and my 3v1 scenario was from a 2v2 game where an immature player wanted to be with a friend or on the "good" team |
| 01:05:18 | Watusimoto | they mean nothing |
| 01:05:28 | Watusimoto | leaderboard is fleeting glory |
| 01:05:53 | Watusimoto | the point is it's hard to discern a plaery's motive |
| 01:06:07 | Watusimoto | if we banned changing to winnign team, that would fix your 3v1 scenario |
| 01:06:20 | karamazovapy | not at the beginning of the game |
| 01:07:14 | Watusimoto | true |
| 01:07:29 | Watusimoto | unless we also banned changing to team with more players |
| 01:07:43 | Watusimoto | or to create a team with more players |
| 01:08:14 | Watusimoto | which I wuould only allow if you are changin to a losing team |
| 01:08:22 | sam686 | it is possible to use multiple clients or adding robots, which could be abused to make you change team |
| 01:08:30 | Watusimoto | yes |
| 01:08:43 | Watusimoto | point being it is impossible to create a truly fair system |
| 01:09:06 | Watusimoto | most of the potential fixes are easily gamed |
| 01:09:17 | Watusimoto | so we do our best and hope the communtiy does likewise |
| 01:09:29 | karamazovapy | whatever...I've decided this is on the list of things that don't matter to me |
| 01:10:13 | Watusimoto | heading to bed |
| 01:10:19 | karamazovapy | night |
| 01:10:40 | Watusimoto | sam, I just checked in a stub of a fn for sending level stats to master. take a look and see if there's anything else you feel needs to be there |
| 01:10:44 | Watusimoto | later all! |
| 01:11:22 | sam686 | ok |
| 01:13:32 | | BFLogBot - Commit d0fdfcef4095 | Author: watusim...@bitfighter.org | Log: Added skeleton for sending achievement data to master |
| 01:13:33 | | BFLogBot - Commit 2b127fc0e92c | Author: watusim...@bitfighter.org | Log: Level stats |
| 01:26:13 | | Watusimoto Quit (Ping timeout: 252 seconds) |
| 02:16:49 | | sam686 Quit (Read error: Connection reset by peer) |
| 02:19:46 | | sam686 has joined |
| 02:19:46 | | ChanServ sets mode +v sam686 |
| 02:41:20 | | zoomber_mbp has joined |
| 02:41:24 | zoomber_mbp | hey |
| 02:41:28 | zoomber_mbp | sam686 you on? |
| 02:41:38 | sam686 | hi |
| 02:41:48 | zoomber_mbp | can you do a huge favor for me? |
| 02:42:00 | karamazovapy | he's not gonna buy you drugs |
| 02:42:03 | karamazovapy | DON'T ASK |
| 02:42:04 | sam686 | what is it? |
| 02:42:25 | zoomber_mbp | this is strictly about alcohol, keep your suspicions down. |
| 02:42:59 | zoomber_mbp | ok so |
| 02:43:21 | zoomber_mbp | we still have all the servers up on 15a |
| 02:43:32 | zoomber_mbp | can you help me move the stock/user map servers to 016? |
| 02:43:34 | karamazovapy | not I, said the pig |
| 02:44:08 | zoomber_mbp | But I, said the giraffe. Who's neck was long and broad, a gleaming tower amongst us |
| 02:44:09 | karamazovapy | but you can just drag and drop the directory... |
| 02:44:21 | sam686 | the servers probably only need to be updated... |
| 02:44:41 | zoomber_mbp | my hands are in a bit of a tight know. I'll try my best to do my part. Don't worry about my gibed and whatever servers |
| 02:45:13 | zoomber_mbp | its my fault for not getting not there to update them, i don't ask you to do those for me |
| 02:45:23 | zoomber_mbp | I just want to get the ones I host for watusimoto up to date |
| 02:45:48 | zoomber_mbp | man. ok let me see if i can quickly put some time aside and do this |
| 02:46:12 | sam686 | only problem is, there is 3 servers at 216.231. that is in 015 (which i don't have the password on) |
| 02:46:42 | zoomber_mbp | don't worry about those, they're my problem hahaha, they don't deserve to live/be running right now |
| 02:46:52 | zoomber_mbp | (iPointblank server i assume) |
| 02:47:01 | zoomber_mbp | ^doesn't deserve to live at the moment |
| 02:47:24 | zoomber_mbp | sniper rifle should be no more, forum users shall cry about it and ill yell get over'tit |
| 02:48:42 | sam686 | otherwise, there is only 2 servers up for 015, coming from 74.122. |
| 02:48:50 | zoomber_mbp | excellent |
| 02:48:53 | sam686 | that i can update |
| 02:49:08 | zoomber_mbp | oh, is it as easy as updating? i suppose we can do that, and don't need to worry about the cron scripts |
| 02:51:03 | zoomber_mbp | lets see, i think 216 server is www.maxhushahn.com dns |
| 02:59:57 | sam686 | hg pull https://code.google.com/p/bitfighter/ |
| 03:04:43 | zoomber_mbp | i forgot all my server passwords for ipointblank and privat |
| 03:06:56 | zoomber_mbp | sam686: watch as all 216 servers disappear |
| 03:06:57 | zoomber_mbp | poof |
| 03:09:02 | sam686 | so many ping timed out |
| 03:10:29 | zoomber_mbp | hey sam686, what is the master server ip for the new bit fighter server? |
| 03:10:44 | zoomber_mbp | i tried deleting it from ini file, but still get segmentation faults when trying to connect to server in 016 |
| 03:10:50 | zoomber_mbp | connect to master server* |
| 03:11:09 | zoomber_mbp | i have MasterServerAddressList=IP:67.18.11.66:25955 |
| 03:11:24 | sam686 | MasterServerAddressList=IP:199.192.229.168:25955,bitfighter.org:25955 (but you can delete the MasterServerAddressList= line and it will use the default |
| 03:11:42 | zoomber_mbp | i tried that |
| 03:11:46 | zoomber_mbp | it still connects to 67 one |
| 03:12:00 | | zoomber_mbp has left |
| 03:12:21 | | zoomber_mbp has joined |
| 03:12:44 | zoomber_mbp | ok i just put the new master in and it works |
| 03:12:57 | zoomber_mbp | wait whaaaa |
| 03:13:08 | zoomber_mbp | its putting my server on 15a |
| 03:13:19 | karamazovapy | did you remember to update and not just pull? |
| 03:13:34 | sam686 | hg up bitfighter-016 |
| 03:13:45 | zoomber_mbp | wierd |
| 03:13:48 | zoomber_mbp | yeah i did both |
| 03:13:49 | sam686 | then, make dedicated |
| 03:13:52 | zoomber_mbp | its like, its using the |
| 03:13:53 | zoomber_mbp | oh |
| 03:13:55 | zoomber_mbp | nevermind |
| 03:14:00 | zoomber_mbp | i forgot to use the make command |
| 03:14:01 | zoomber_mbp | hah |
| 03:14:04 | sam686 | oh, make clean may be needed first |
| 03:14:04 | karamazovapy | might even want to make clean then make dedicated |
| 03:14:23 | zoomber_mbp | nono see, using the command "make" just seemed to pass my head |
| 03:14:43 | zoomber_mbp | also, I'm really disorganized apparently, i have no idea what that server was, it had a bunch of random levels in it |
| 03:15:06 | karamazovapy | was that the zany server you and raptor had up? |
| 03:15:24 | zoomber_mbp | ridiculous raptor server? |
| 03:15:29 | karamazovapy | yeah, whatever it was |
| 03:15:34 | karamazovapy | with the nonsense levels |
| 03:15:39 | zoomber_mbp | that thing has disappeared from the universe |
| 03:15:53 | zoomber_mbp | but iPointblank is the one with that stupid sniper rifle, if you mean that one |
| 03:16:08 | karamazovapy | no, you said random levels, so I was thinking of the crazy level server |
| 03:16:20 | zoomber_mbp | oh haha no, i ran that on a completely different server |
| 03:16:23 | zoomber_mbp | physical one |
| 03:16:50 | zoomber_mbp | i guess we have a game going on 016 right now |
| 03:17:10 | karamazovapy | "anal frustrater" classy. |
| 03:17:18 | zoomber_mbp | i was just going to say |
| 03:17:36 | zoomber_mbp | he/she left as soon as i started playing |
| 03:17:45 | zoomber_mbp | guess they got too frustrated.. |
| 03:18:00 | zoomber_mbp | i feel like i know who that is |
| 03:18:14 | zoomber_mbp | sam, who has the same ip as that player? i bet i can guess it |
| 03:18:53 | zoomber_mbp | oh no, make errors |
| 03:19:10 | zoomber_mbp | oh looks like a linking error |
| 03:19:27 | karamazovapy | did you make clean first? |
| 03:19:28 | zoomber_mbp | ill try make clean |
| 03:19:32 | zoomber_mbp | aaah you beat me too it |
| 03:19:42 | zoomber_mbp | yeah, using your suggestion helped, thanks |
| 03:25:30 | zoomber_mbp | BFLogbot irc log link please |
| 03:25:38 | zoomber_mbp | !irclog |
| 03:25:39 | zoomber_mbp | !logs |
| 03:25:42 | zoomber_mbp | !BfLogBot |
| 03:25:47 | zoomber_mbp | BfLogBot |
| 03:25:47 | BFLogBot | I'm a real boy.... I think? |
| 03:25:58 | zoomber_mbp | !rc |
| 03:25:59 | zoomber_mbp | !irc |
| 03:26:03 | zoomber_mbp | Bflogbot irc |
| 03:26:19 | zoomber_mbp | forget it, ill try and find the irc logs myself |
| 03:26:23 | | zoomber_mbp has left |
| 03:26:28 | | zoomber_mbp has joined |
| 03:27:02 | zoomber_mbp | uhh, might just want to change the logbot to say "http://bitfighter.net/irclogs/" instead of that long ip adress |
| 03:28:15 | sam686 | i see a mystery, why is the 216.231 still being listed on 015 server list, even though they are ping timed out? |
| 03:29:05 | zoomber_mbp | yeah, i see those too |
| 03:29:10 | zoomber_mbp | thats wierd |
| 03:29:44 | sam686 | darn it, now my ip address 208.107 is staying listed on 015a server list... |
| 03:29:48 | zoomber_mbp | i couldn't shut them down manually because I forgot the passes, and didn't know where they were located until now, but i did "killall bitfighterd" |
| 03:30:12 | sam686 | i think the 015 master seems a little bit broken now... |
| 03:30:23 | zoomber_mbp | i think its broken, because my server doesn't show the old servers running at all |
| 03:30:52 | zoomber_mbp | hey sam686, are user levels and classic levels on 96 server up to 016 date? |
| 03:31:57 | sam686 | i haven't checked 96 server, all i did is disable all 96 server from auto starting up except bitfighter sam686 |
| 03:32:36 | | raptor has joined |
| 03:32:37 | | ChanServ sets mode +o raptor |
| 03:32:43 | sam686 | i had problems with out of memory, it turns out shutting down mysql and httpd frees enough memory to compile (then i can start up the stuff i shut down) |
| 03:33:34 | zoomber_mbp | ok excellent |
| 03:33:52 | | -leguin.freenode.net- *** Looking up your hostname... |
| 03:33:52 | | -leguin.freenode.net- *** Checking Ident |
| 03:33:52 | | -leguin.freenode.net- *** No Ident response |
| 03:33:52 | | -leguin.freenode.net- *** Couldn't look up your hostname |
| 03:33:56 | | BFLogBot has joined |
| 03:33:56 | | Topic is 'Latest release 016 http://bitfighter.org | Forums: http://bitfighter.org/forums/ | GC Project: http://code.google.com/p/bitfighter/' |
| 03:33:56 | | Set by raptor!~raptor@unaffiliated/greenmachine on Wed Feb 01 04:14:39 GMT 2012 |
| 03:33:56 | | -ChanServ- [#bitfighter] Welcome to #bitfighter. This is an IRC channel, many or all of the users may not be paying attention. Please have patience when waiting for a response. |
| 03:33:59 | zoomber_mbp | I'm working on 74 servers as we speak |
| 03:34:09 | zoomber_mbp | now all 015a master dead |
| 03:34:14 | sam686 | hey raptor, i think the 015 master is having a little problem with connection never dies.. it thinks all the server (and some players like Edwin win) is still up |
| 03:35:01 | raptor | odd |
| 03:35:08 | raptor | no one but watusimoto can take it down... |
| 03:35:16 | raptor | !log |
| 03:35:16 | BFLogBot | This channel is logged - http://bitfighter.org/irclogs/ |
| 03:35:22 | raptor | !commands |
| 03:35:22 | BFLogBot | Commands: airlock bbb bitfighter bot bug bugs dedicated feature help hg log log logs mercurial ninja watusimoto |
| 03:35:35 | zoomber_mbp | raptor, change the bot to point to bitfighter.net/irclogs instead of that long irc address |
| 03:35:43 | raptor | already done |
| 03:35:48 | zoomber_mbp | excellent good sir |
| 03:35:49 | raptor | be back... |
| 03:35:50 | | raptor has left |
| 03:38:47 | zoomber_mbp | who owns 153.19.7.19 server? i go on the webpage and shows "all your base belong to us" |
| 03:38:55 | zoomber_mbp | probably _k's? |
| 03:41:02 | sam686 | 174.37.6. (probably old kserv on 015) and 173. (used for bbb8) |
| 03:42:46 | zoomber_mbp | ah ok |
| 03:42:53 | zoomber_mbp | must be all his new levels then |
| 03:43:36 | sam686 | http://bitfighter.org/gamereports/ says IP:153.19.7.19:2800 = Otwieracz Policja! |
| 03:47:33 | zoomber_mbp | why is -IP:ANY:28000 now an unrecognized command line arguement |
| 03:56:36 | | zoomber_mbp Quit (Quit: zoomber_mbp) |
| 03:58:36 | sam686 | it is -dedicated -hostaddr any:28013 (you may ignore the -dedicated if you did "make dedicated") |
| 04:05:50 | | zoomber_mbp has joined |
| 04:16:01 | karamazovapy | 153.19.7.19 was never mine |
| 04:17:14 | zoomber_mbp | strange |
| 04:17:15 | zoomber_mbp | it is |
| 04:17:59 | | raptor has joined |
| 04:17:59 | | ChanServ sets mode +o raptor |
| 04:18:07 | karamazovapy | my current server is 173.193.226.34 |
| 04:18:09 | raptor | why is master server on moscow standard time? |
| 04:18:16 | karamazovapy | why wouldn't it be? |
| 04:18:19 | zoomber_mbp | ^ |
| 04:18:31 | raptor | because it was on UTC I think |
| 04:18:50 | karamazovapy | but moscow is best cow |
| 04:19:11 | zoomber_mbp | your russian accent very strange russian accent |
| 04:19:37 | zoomber_mbp | My russian accent is real russian accent |
| 04:20:48 | karamazovapy | moss cau ease behst cau |
| 04:22:08 | raptor | sam686: what is cookie41.php in your home directory on the master? |
| 04:22:56 | sam686 | oh, it was an unfinished stuff for setting phpbb cookies (bitfighter.net fails on cookies after database update) |
| 04:23:24 | raptor | ok |
| 04:23:31 | raptor | just loking for suspicious stuff |
| 04:23:34 | raptor | loooking |
| 04:24:19 | sam686 | i think it was based on http://www.phpbb.com/kb/article/fixing-incorrect-cookie-settings/ (2. A special file) |
| 04:24:43 | sam686 | i haven't even got no where besides transferring a file to my home dir |
| 04:26:41 | raptor | hmmm, i don't see much suspicious... |
| 04:26:56 | raptor | ok, i guess moscow time is normal.. |
| 04:27:13 | sam686 | http://sam686.maxhushahn.com/upload/phpbb_cookie_options.PNG was my near-empty phpbb |
| 04:27:28 | raptor | neat |
| 04:27:53 | sam686 | i guess the extra options, like cookie settings might only appear if you are super-admin on phpbb |
| 04:29:00 | raptor | be back later again.. |
| 04:29:04 | | raptor Quit () |
| 04:32:11 | | raptor has joined |
| 04:32:12 | | ChanServ sets mode +o raptor |
| 04:32:59 | sam686 | i see, http://sam686.maxhushahn.com/upload/phpbb-admin-types.png it looks like we don't have "FULL" admin in phpbb... |
| 04:33:02 | raptor | sam686: when you go here, what is the time of the most recent game as it shows you?: http://bitfighter.org/gamereports/ |
| 04:33:43 | sam686 | Game ending on 15 Feb 2012 09:04:50 PM Server barf's home IP Adress IP:69.169. |
| 04:34:14 | raptor | so that is an hour an half in the past for you? |
| 04:34:46 | sam686 | yes, looks like it is 1.5 hours past |
| 04:34:48 | raptor | because i did 1/2 hour ago... |
| 04:35:06 | sam686 | its probably time zone problem |
| 04:35:15 | raptor | yeah... |
| 04:37:33 | raptor | ok, i need to add a note on the top of the page about the timezone... |
| 04:41:39 | raptor | ok, added a note and changed the timezone to america pacific |
| 04:43:36 | sam686 | what time zone are you in? |
| 04:43:40 | raptor | MST |
| 04:43:42 | raptor | mountain |
| 04:43:52 | raptor | it was in mountain |
| 04:43:58 | raptor | which was nice for me :) |
| 04:44:36 | sam686 | it seems like most topic in bitfighter forum often use eastern time zone (_k, mostly) |
| 04:46:06 | raptor | yeah but watusimoto seems to think things should be Pacific |
| 04:49:43 | sam686 | i see several places in TNL that uses mSendPacketList->sendTime < getCurrentTime() (or similar), which is a bad idea when getCurrentTime can overflow and wrap around to zero.. |
| 04:50:54 | raptor | is getCurrentTime() not set to the unix epoc? |
| 04:50:58 | raptor | epoch |
| 04:52:05 | sam686 | U32 getCurrentTime() { return mCurrentTime; } |
| 04:52:13 | sam686 | mCurrentTime = Platform::getRealMilliseconds(); |
| 04:52:23 | raptor | hmmm... |
| 04:52:40 | raptor | yeah that's not good |
| 05:00:22 | sam686 | i can change: getCurrentTime() > pending->mConnectLastSendTime + PuzzleSolutionTimeout |
| 05:00:22 | sam686 | to this : getCurrentTime() - pending->mConnectLastSendTime > PuzzleSolutionTimeout |
| 05:00:53 | sam686 | and that can fix a problem in case a number overflow |
| 05:01:48 | raptor | have we ever run into a number overflow? |
| 05:02:30 | sam686 | i think the old master 015 has ran into overflow milliseconds |
| 05:02:46 | sam686 | and that causes the connection to never die |
| 05:02:51 | raptor | hmm... |
| 05:02:55 | raptor | ok |
| 05:13:08 | | zoomber_mbp Quit (Quit: zoomber_mbp) |
| 05:22:28 | | zoomber_mbp has joined |
| 05:22:55 | zoomber_mbp | hey sam686 sorry for all of a sudden ditching you on that mesh zone game. my laptop died on me |
| 05:24:26 | sam686 | hi |
| 05:24:34 | zoomber_mbp | come back on the server, if you have time |
| 05:25:29 | sam686 | Diamond revenge collection level have problems... |
| 05:25:49 | sam686 | 1. probably can't get past bouncy objects |
| 05:26:12 | sam686 | 2. the message "server don't restart when you leave" is wrong |
| 05:26:25 | zoomber_mbp | yeah, because its new code and i need to re implement that |
| 05:26:32 | zoomber_mbp | and i forgot where that modification was, dang |
| 05:37:36 | sam686 | thats kind of dumb .. even with the input mode set to keyboard, it still controls menu with a joystick... that didn't happen on 015a (on 015a, keyboard input completely disables joytick from anything in game and menus) |
| 05:40:09 | sam686 | i was running 2 clients, one with keyboard input, i was expecting the keyboard input client to ignore all button of joystick (but it entered menu and quit the game instead) |
| 05:41:02 | zoomber_mbp | hmm |
| 05:41:20 | sam686 | link, for easy finding |
| 05:42:39 | zoomber_mbp | link? |
| 05:43:10 | sam686 | just found it |
| 05:45:35 | zoomber_mbp | ok |
| 05:46:01 | zoomber_mbp | see what would rather/like to see, even if you'd rather have a square shape instead of octagon, whatever, and host it |
| 05:46:07 | zoomber_mbp | ill join when done |
| 05:46:07 | raptor | top wins for the last week: http://pastie.org/3392397 |
| 05:46:18 | raptor | finally got the query right |
| 05:47:57 | zoomber_mbp | you know what would be cool? is if text could rotate in game |
| 05:49:05 | zoomber_mbp | when I'm pressing tab in the editor, and holding down the "R" button, i can see it rotate, and i must say, I've never seen something sooo cool |
| 05:49:20 | | BFLogBot - Commit f2415438bf5d | Author: sam8641 | Log: Fixed some TNL problem causing game connection to never die, after getRealMilliseconds overflows |
| 05:57:42 | zoomber_mbp | sam686 still on? |
| 05:58:17 | sam686 | hi |
| 05:59:44 | sam686 | zoomber_mbp zoomber_hello |
| 06:01:33 | zoomber_mbp | what do you think of the map? any ideas yet? |
| 06:02:29 | raptor | 8 servers online!! |
| 06:03:08 | zoomber_mbp | mostly mine lol |
| 06:04:25 | sam686 | it is possible to have a levelgen do al the work of curving a line of text |
| 06:05:22 | zoomber_mbp | ok, lets do that then |
| 06:05:36 | zoomber_mbp | but should we have it be bigger? |
| 06:05:43 | zoomber_mbp | then make obstacles within it? |
| 06:05:54 | zoomber_mbp | oh wait, you mean the text? |
| 06:06:09 | zoomber_mbp | ok, but is there yet a way to make the text rotate live in game? |
| 06:06:11 | sam686 | yes |
| 06:06:28 | sam686 | rotate live, like speedzone of my one map? |
| 06:06:32 | zoomber_mbp | yes |
| 06:07:02 | sam686 | probably need a bit of c++ programming, but it can be done on existing version |
| 06:07:29 | zoomber_mbp | sweet |
| 06:07:32 | zoomber_mbp | lets do it! |
| 06:07:35 | zoomber_mbp | if you have some time.. |
| 06:08:31 | raptor | wait wait wait... |
| 06:08:43 | raptor | i thought we were going to tone down the 'sandbox' aspect a bit... |
| 06:08:54 | sam686 | probably should make some way so it can be done in LUA |
| 06:09:21 | karamazovapy | "we" never did any sandboxing |
| 06:09:34 | raptor | yes, i used the royal 'we' |
| 06:09:42 | sam686 | a levelgen with a onTick that can change position of anything (except barriers, due to the way it is sent to clients) |
| 06:10:14 | raptor | sam686: that is sounding like the fabled supervisor script |
| 06:10:57 | sam686 | it kind of is like a supervisor script, that could do anything a robot could |
| 06:11:07 | karamazovapy | raptor: I don't think zoomber_mbp was privy to the conversations where "we" decided "we" wouldn't do so much custom-server stuff |
| 06:11:24 | sam686 | with, adding much more editing lua stuff |
| 06:11:26 | karamazovapy | and I don't think sam agreed int he first place |
| 06:12:13 | raptor | ah, well, ok then... i didn't remember who was in the conversation |
| 06:12:34 | karamazovapy | I think it was you and watusimoto, and sam and I were present but uninvolved |
| 06:13:10 | karamazovapy | not totally unlike the conversation you and I are having right now |
| 06:14:02 | karamazovapy | but I believe zoomber has stated his intent to create a sandbox branch on the forums |
| 06:15:37 | raptor | ha! |
| 06:15:40 | raptor | ok |
| 06:16:45 | karamazovapy | hey, I'm with you on this one, but I was never in the other camp |
| 06:17:07 | zoomber_mbp | sorry, I'm a bit unreliable on the forums now, I don't read the forums like I used to, due to the huge number of posts that go in every day now. |
| 06:18:03 | zoomber_mbp | Though I can't deny the my intent to continue my iPointblank sandbox, I didn't say that server was going up for sure |
| 06:18:12 | raptor | i just think it would be good to spend our efforts on bugs/issues/features than sand-boxing too much... |
| 06:18:31 | karamazovapy | well the rogue client is the reason I'm not hosting kserv anymore |
| 06:18:32 | zoomber_mbp | in fact, I'll probably end up being too lazy to change anything on it |
| 06:19:00 | raptor | yes, i think we should let /getmaphack die with 015 |
| 06:19:24 | karamazovapy | I just assumed all the rogue code had been ported all along |
| 06:19:28 | zoomber_mbp | well, i never made anything on iPointblank to be harmful or even completely new |
| 06:19:29 | raptor | nope |
| 06:19:34 | zoomber_mbp | and no, no rogue code gets ported all along |
| 06:19:35 | raptor | it was never in the main branch |
| 06:19:49 | raptor | only on sam's mercurial branch |
| 06:19:53 | karamazovapy | it doesn't really have to be in the main branch |
| 06:19:58 | zoomber_mbp | if you haven't noticed, I said in that same post about pointblank, that i discarded any of my old ipointblank mods |
| 06:19:59 | zoomber_mbp | like sniper |
| 06:20:19 | zoomber_mbp | and sniper was just to test the request by people who wanted it to actually be implemented in the game |
| 06:20:37 | zoomber_mbp | giant turrets were just a cool graphical look |
| 06:20:49 | raptor | true, but his branch show it isn't publically ported to 016: https://code.google.com/r/sam8641-bitfighter04/source/list |
| 06:20:49 | zoomber_mbp | and its not like thats where all the games went |
| 06:21:13 | karamazovapy | zoomber...your novelty mods aren't really my concern |
| 06:21:19 | zoomber_mbp | ah, ok, |
| 06:21:20 | raptor | that was the only branch it was created on, and it kepy 015a compatibility |
| 06:21:24 | zoomber_mbp | excellent :) |
| 06:21:26 | raptor | *kept |
| 06:22:19 | karamazovapy | granted, I still think the sandbox thing is a bad idea, but you're free to do whatever you want |
| 06:23:20 | raptor | ok, well, now that i got weekly basic stats set up in the database, i'm heading to bed |
| 06:23:27 | zoomber_mbp | well, just to hear my opinion, as long as the sandbox additions aren't rogue/harsh in any way, and or attracting all the players to just that server, i don't see much harm |
| 06:23:27 | raptor | good night! |
| 06:24:11 | karamazovapy | night raptor |
| 06:24:32 | | raptor Quit () |
| 06:24:34 | karamazovapy | I don't think they do serious harm, but I don't really like seeing unvetted features sneak their way into the game...slipzones, energy items |
| 06:25:12 | karamazovapy | I don't actually know if the varied turrets made it |
| 06:25:25 | karamazovapy | those were my idea and I think they were a disaster! |
| 06:26:34 | zoomber_mbp | oh, those things used in the emperor's revenge dungeon maps? |
| 06:26:40 | karamazovapy | yeah |
| 06:26:41 | sam686 | if you don't like that feature, then don't use it (that goes with speedzone, slip zone, turret shooting burst..) |
| 06:27:14 | karamazovapy | I don't get to pick which features show up when I join a server, though |
| 06:27:31 | karamazovapy | and it's a small enough community that you can't reasonably just go somewhere else if you want a game |
| 06:27:42 | zoomber_mbp | I think what he means, go somew |
| 06:27:43 | zoomber_mbp | well...yeah |
| 06:28:24 | zoomber_mbp | but, don't we? |
| 06:28:33 | karamazovapy | ? |
| 06:28:34 | zoomber_mbp | classic levels, gibbed, user levels? |
| 06:28:47 | karamazovapy | most of the time I just leave when bad levels come up |
| 06:28:53 | zoomber_mbp | retro level server ( i need to restart some of these though, since they're left behind in 15a) |
| 06:29:10 | sam686 | you can pick a server, several servers have limited level that don't have any levels with slip zone / energy item |
| 06:29:13 | karamazovapy | and with map uploads, most of the levels that come up are pretty bad |
| 06:29:29 | zoomber_mbp | all of my servers have map upload disabled, besides sam's server |
| 06:29:46 | karamazovapy | well for better or worse, sam's server is where most of the action is |
| 06:29:54 | zoomber_mbp | there's really only need for one server with map_upload |
| 06:30:49 | zoomber_mbp | thats true, but he is also the center of popularity in this game, possibly because he plays with all the users a lot, therefore, his name and by extension server, probably have gained good reputation |
| 06:31:00 | sam686 | there is map uploads, mostly becasue when that player host, everyone lags or have trouble punching through firewall |
| 06:31:19 | zoomber_mbp | and, to share maps |
| 06:31:26 | karamazovapy | I think it's actually that the young players are more interested in social club than good gameplay |
| 06:31:52 | zoomber_mbp | karamazovapy, I know where your pain is coming from, considering I hosted servers that would never get any attention either, |
| 06:32:02 | karamazovapy | oh, I could care less about that |
| 06:32:20 | zoomber_mbp | ok, so what exactly is the issue then? |
| 06:32:35 | zoomber_mbp | not sarcastically, i actually am confused |
| 06:32:42 | karamazovapy | that I don't like playing poorly designed maps |
| 06:32:48 | sam686 | though, it seems like the good players just don't play very much at all, and the young players play a log... |
| 06:32:58 | sam686 | play a lot... |
| 06:32:58 | zoomber_mbp | ^ |
| 06:33:25 | zoomber_mbp | i back that, because I'm not so active like I used to be on bitfighter. Mainly because I'm so busy |
| 06:33:40 | karamazovapy | well I waste a couple minutes here or there, but because I have adult responsibilites, I can't usually sit around and play game after game |
| 06:34:05 | zoomber_mbp | And I think thats perfectly understandable |
| 06:34:34 | karamazovapy | if I have 15 or 20 minutes to waste and I see a few people are playing, I hop on and the maps are lousy |
| 06:34:45 | karamazovapy | so I play a game or two, or whatever I can tolerate, and then I bail |
| 06:34:47 | zoomber_mbp | i don't see a problem with how active one is on bitfighter |
| 06:35:40 | sam686 | all levels seems kind of a lowsy blue walls, are you blue? |
| 06:35:44 | zoomber_mbp | well, believe it or not, it's not all socializing there. I think its more of a 'greed' desire, which gets implemented into maps, obscuring a need for better gameplay |
| 06:36:17 | karamazovapy | yeah, all I'm saying is that I don't like playing poorly designed maps, that unvetted features lead to maps with bigger problems built-in, and that map uploading has allowed the bad maps to proliferate |
| 06:36:20 | zoomber_mbp | fast flags, fast nexus, whatever that map is called, for example |
| 06:36:31 | sam686 | fast nexus? |
| 06:36:34 | zoomber_mbp | yes |
| 06:36:53 | zoomber_mbp | ok karamazovapy, i understand that, but how can we fix that? That's their lasting opinion, it might change, it might not |
| 06:37:09 | karamazovapy | I can't fix it because it's out of my control |
| 06:37:10 | zoomber_mbp | I'm just grateful I can for once in my life come on bit fighter and actually see people playing |
| 06:37:24 | karamazovapy | and sam doesn't think it's a problem |
| 06:37:27 | karamazovapy | so it is what it is |
| 06:37:45 | karamazovapy | I like the game less, and that's the end of it |
| 06:38:02 | zoomber_mbp | well, I'm sorry to hear that |
| 06:38:15 | karamazovapy | like I said, it is what it is |
| 06:38:25 | zoomber_mbp | I guess your ultimate solution is to call some old players up, like quartz, and bobdaduck, and play a match with them |
| 06:38:30 | karamazovapy | anyway - I've got a morning meeting |
| 06:38:31 | karamazovapy | night |
| 06:38:35 | zoomber_mbp | good night karamazovapy |
| 06:38:48 | zoomber_mbp | and just wait, I'm sure light will shine on this soon enough |
| 06:48:28 | | zoomber_mbp Quit (Quit: zoomber_mbp) |
| 06:48:40 | | sam686 has left |
| 08:05:36 | | LordDVG has joined |
| 08:12:17 | | Watusimoto has joined |
| 08:19:33 | | BFLogBot - Commit 62fab517d55f | Author: watusim...@bitfighter.org | Log: Add teamCount |
| 08:19:35 | | BFLogBot - Commit 6659ffdabfd1 | Author: watusim...@bitfighter.org | Log: Merge |
| 08:19:36 | | BFLogBot - Commit d41da036a79e | Author: watusim...@bitfighter.org | Log: S32 ==> U32 |
| 08:23:55 | | Watusimoto Quit (Ping timeout: 240 seconds) |
| 09:00:18 | | watusimoto has joined |
| 09:00:18 | | ChanServ sets mode +o watusimoto |
| 10:20:07 | | karamazovapy Quit (Read error: Connection reset by peer) |
| 10:20:50 | | karamazovapy has joined |
| 14:28:06 | watusimoto | karamazovapy: see the home page |
| 14:28:15 | watusimoto | we have a leaderboard! |
| 16:00:30 | | raptor has joined |
| 16:00:31 | | ChanServ sets mode +o raptor |
| 16:00:51 | raptor | watusimoto: want me to adjust the player_games views to include all games? |
| 16:12:36 | raptor | watusimoto: i adjusted it - most games' views now include official + unofficial games |
| 16:22:16 | | raptor Quit () |
| 16:24:32 | watusimoto | raptor -- yes, great, thanks! |
| 16:28:59 | watusimoto | karamazovapy: Cheater! |
| 16:29:17 | karamazovapy | who, me? |
| 16:31:10 | karamazovapy | but I'm so innocent and naive! |
| 16:35:10 | watusimoto | added total plays to the crude leaderboard |
| 16:49:17 | | raptor has joined |
| 16:49:17 | | ChanServ sets mode +o raptor |
| 16:50:37 | raptor | the table style makes my eyes bleed |
| 16:52:14 | raptor | watusimoto: how did you pull the data from the database... i'm looking at the PHP and i don't see where you're using credentials.. |
| 17:00:36 | raptor | oh wow, the table changed - it's like magic |
| 17:01:20 | watusimoto | I have changed the table edge colors to match those of the page frame... not sure I like it but it's better |
| 17:01:41 | raptor | yeah, i think it's a bit better |
| 17:01:58 | watusimoto | I added the bf_drupal user (I forget which one it was, it came up in an error msg) to have read-only permissions to the bf_stats db |
| 17:02:09 | watusimoto | kind of amazed it worked.... |
| 17:02:10 | raptor | ahh... cool |
| 17:02:11 | watusimoto | but it did |
| 17:02:29 | watusimoto | at some point you might want to verify I did it right |
| 17:02:34 | raptor | you did |
| 17:02:37 | watusimoto | but I really like the phpadmin tool |
| 17:02:45 | watusimoto | except I can't see view defs there |
| 17:02:57 | raptor | yes - what i do is export the view |
| 17:03:00 | watusimoto | I'm curious about the official game view, how that was generated |
| 17:03:04 | watusimoto | ok, I'll try that |
| 17:03:10 | raptor | it's pretty hairy |
| 17:03:23 | raptor | absolutely bonkers |
| 17:04:36 | raptor | we need to replace teh screenshots with ones from the last BBB |
| 17:05:06 | watusimoto | indeed |
| 17:05:35 | raptor | sam686 has lots of nice ones here: http://sam686.maxhushahn.com/bitfighter/BBB8/index.html |
| 17:06:15 | watusimoto | export the view as what... sql? |
| 17:06:15 | raptor | he recorded the last BB losslessly |
| 17:06:20 | watusimoto | wow |
| 17:06:20 | raptor | yep |
| 17:06:37 | watusimoto | I get this: |
| 17:06:39 | watusimoto | CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_authenticated_game` AS select `stats_player`.`stats_game_id` AS `stats_game_id`,count(`stats_player`.`stats_player_id`) AS `authenticated_count` from `stats_player` where (`stats_player`.`is_authenticated` = 1) group by `stats_player`.`stats_game_id`; |
| 17:06:46 | watusimoto | which is difficult to understand |
| 17:07:11 | raptor | CREATE VIEW `v_authenticated_game` AS |
| 17:07:13 | raptor | SELECT `stats_player`.`stats_game_id` AS `stats_game_id`, |
| 17:07:14 | raptor | COUNT(`stats_player`.`stats_player_id`) AS `authenticated_count` |
| 17:07:16 | watusimoto | in fact, don't even see where authenticated coulg gets used |
| 17:07:17 | raptor | FROM `stats_player` |
| 17:07:17 | raptor | WHERE (`stats_player`.`is_authenticated` = 1) |
| 17:07:19 | raptor | GROUP BY `stats_player`.`stats_game_id` |
| 17:07:39 | raptor | that is a helper view, that i created to work around a mysql bug |
| 17:08:00 | watusimoto | ah, official_game |
| 17:08:02 | raptor | so that view builds up all games with authenticated players |
| 17:08:15 | raptor | then v_official_game uses it to calculate official games |
| 17:08:42 | watusimoto | got it |
| 17:08:52 | watusimoto | authenticated_count` > 1 ==> >= 2 |
| 17:08:59 | watusimoto | etc. |
| 17:09:01 | watusimoto | yes, ok |
| 17:09:06 | raptor | yes |
| 17:09:08 | watusimoto | can these be edited via the interface? |
| 17:09:30 | raptor | sure, to edit a view, just paste the same code in, but change 'create' to 'alter' |
| 17:09:44 | raptor | what did you want to edit? |
| 17:10:06 | raptor | (i found that using ' > x - 1' was slightly faster than ' >= x' |
| 17:10:20 | raptor | which shouldn't be... |
| 17:15:40 | watusimoto | just wondering... it works fine, and while >= would be slightly clearer, it's hardly worth changing if it's not trivial. |
| 17:15:50 | watusimoto | and it's not |
| 17:16:04 | watusimoto | so... great! we have our leaderboard! |
| 17:16:31 | raptor | we can go crazy with views... i don't know why i didn't think about them before.. |
| 17:16:51 | karamazovapy | views? |
| 17:17:10 | raptor | views = predefined queries in database to build up the exact data we want |
| 17:17:22 | karamazovapy | ah |
| 17:17:30 | karamazovapy | are little_apple and blackbird homeschooled...?\ |
| 17:17:36 | raptor | footloose is |
| 17:17:42 | raptor | sometimes i wonder about those two.. |
| 17:18:07 | karamazovapy | aside from other homeschool baggage, I was just wondering based on the way they seem to post on the forums throughout the day |
| 17:18:25 | raptor | oh, that's because they post from mobile devices all day long |
| 17:18:50 | karamazovapy | most schools - especially elementary and middle schools - don't allow mobile devices |
| 17:19:34 | | LordDVG Quit (Remote host closed the connection) |
| 17:19:42 | raptor | i don't know much about the school system anymore - i just know high school was a complete joke for me... and that was before 'no child left behind' |
| 17:20:55 | karamazovapy | next time I teach highschool, I'm going to be biased. I'm going to tell people they can use mobile devices, but not if they're apple products |
| 17:21:03 | raptor | hahaha |
| 17:21:05 | raptor | awesome |
| 17:21:25 | karamazovapy | that oughta rile them up |
| 17:22:35 | watusimoto | ok, out of here |
| 17:22:38 | watusimoto | later gators, |
| 17:24:19 | raptor | bye |
| 17:30:11 | | watusimoto Quit (Read error: Operation timed out) |
| 17:31:29 | raptor | karamazovapy: did you have 4 clients open this morning? |
| 17:36:29 | | sam686 has joined |
| 17:36:30 | | ChanServ sets mode +v sam686 |
| 17:37:01 | karamazovapy | of course! |
| 17:42:16 | karamazovapy | looks like 016 is overrun with servers like 015a was |
| 17:42:29 | raptor | i was enjoying the 3 or 4 count |
| 17:42:37 | karamazovapy | me too |
| 17:44:11 | karamazovapy | oh well. free country. |
| 17:44:16 | raptor | i was thinking - |
| 17:44:39 | raptor | maybe we could crasht hem somehow with a known server-crashing level... |
| 17:44:48 | raptor | but uploads would have to be enabled |
| 17:45:08 | raptor | (I'm in an exploitative mood) |
| 17:45:55 | raptor | but nah, i can't be mean |
| 17:46:50 | karamazovapy | yeah, zoomber went through a lot to put them back up last night |
| 17:48:08 | raptor | oh man - a new Mac OS X is on it's way already |
| 17:50:20 | karamazovapy | hah...from Lion to Mountain Lion |
| 17:50:51 | raptor | oh man, and it looks like we'll have to cryptographically sign bitfighter or it won't run |
| 17:50:58 | raptor | sigh |
| 17:50:58 | karamazovapy | "Several popular iOS apps have been rolled up into the OS and will run across all Apple devices, harmonising the experience for users. It's all backed by iCloud accessed through the user's Apple login." |
| 17:51:15 | karamazovapy | why do apple users want to give so much power to one company? |
| 17:51:19 | raptor | i knew it... |
| 17:51:49 | raptor | then everyone's laptop becomes a 5 -10 pound smart phone |
| 17:51:50 | karamazovapy | oooooh "deep Twitter integration" |
| 17:52:48 | karamazovapy | "Thanks to Gatekeeper the default setting of Mountain Lion OS is that you can only run software from Apple-approved sources - unless you can be bothered to dismiss warnings from the system." |
| 17:52:59 | raptor | ^^ yes |
| 17:53:06 | raptor | that's what i mean by needed to sign applications |
| 17:53:12 | karamazovapy | yeah, I figured |
| 17:53:13 | raptor | blessed from apple |
| 17:53:36 | karamazovapy | I wonder if that will spark any anti-trust cases |
| 17:54:15 | karamazovapy | I know they don't have significant enough marketshare, but that's certainly an aggressive anti-competitive maneuver |
| 17:54:40 | raptor | well, apple has been worse than microsoft at aggressive anti-competitive maneuvers for some time |
| 17:55:43 | karamazovapy | yeah, but making the default setting prompt warnings against unsigned software seems like a new level of hostility |
| 17:56:04 | raptor | probably |
| 17:56:07 | karamazovapy | it's the default aspect that I think is disturbing |
| 17:56:12 | raptor | yep |
| 17:56:40 | raptor | i wonder... it almost seems as though their end goal is to get people off of computers and onto media consuming mobile devices for good |
| 17:57:02 | karamazovapy | didn't steve jobs say the laptop was dead? |
| 17:57:07 | raptor | so if anyone wants to actually get work done, you'd have to stay away from apple (which is practically how it is now) |
| 17:57:17 | raptor | i don't know |
| 17:57:24 | raptor | never paid attention to him |
| 17:57:52 | | LordDVG has joined |
| 17:58:49 | karamazovapy | I did, insomuch as I wanted to see where apple was headed |
| 17:58:55 | karamazovapy | but yeah, "The laptop is dead." |
| 17:59:17 | karamazovapy | I heard rumblings that they were planning on unifying OSes |
| 17:59:33 | raptor | from the looks of it 'mountain lion' is another step in that direction |
| 17:59:53 | karamazovapy | yeah, looks like this is the first big step...that and their "magic" mouse |
| 18:00:38 | raptor | looking at the actual OS libraries and core workings in 10.7 (Lion) it actually looks like they already took a big step in that release |
| 18:00:57 | karamazovapy | hm |
| 18:01:10 | karamazovapy | I wonder if there's a point where they'll actually lose users |
| 18:01:26 | raptor | not if they keep brainwashing the young |
| 18:02:07 | raptor | brainwashing everyone actually... |
| 18:02:15 | karamazovapy | well...but my brother-in-law does some semi-technical work, and he uses both apple and pc products |
| 18:02:52 | karamazovapy | I wonder if they'll reach a point where those people finally throw up their hands |
| 18:03:24 | raptor | i think their message caters to a certain class of people: "you are cool if you have an apple product" |
| 18:03:42 | karamazovapy | yes and no. |
| 18:03:54 | | sam686 Quit (Ping timeout: 245 seconds) |
| 18:04:08 | karamazovapy | my oldest sister (who's a bit of a rage-a-holic) was always frustrated by computers, and her apple "just works" |
| 18:04:24 | karamazovapy | she also sees it as a premium product |
| 18:04:48 | karamazovapy | my mother uses a real computer at work and also has a laptop for travel, but she loves her ipad |
| 18:04:52 | raptor | ah, yes |
| 18:05:04 | karamazovapy | both my sisters and my mother all have iphones now |
| 18:05:21 | | sam686 has joined |
| 18:05:21 | | ChanServ sets mode +v sam686 |
| 18:05:40 | raptor | that's right. i temporarily forgot about that class of people |
| 18:05:53 | raptor | i'm just so used to people at work who have apples as status symbols |
| 18:05:59 | karamazovapy | yeah, they play up the hipster angle, but they also appeal to tech-dumb folks |
| 18:07:48 | raptor | one of the changes they made in 10.7 was to remove the dock indicator that an application was running by default |
| 18:08:15 | karamazovapy | huh. wonder if that's so they can keep things running in the background without you noticing |
| 18:08:26 | raptor | i think they wanted to remove the idea of application running status |
| 18:08:38 | raptor | to simplify further |
| 18:21:24 | | sam686 Quit (Read error: Connection reset by peer) |
| 18:24:59 | | sam686 has joined |
| 18:24:59 | | ChanServ sets mode +v sam686 |
| 20:23:33 | | koda has joined |
| 20:40:32 | | Watusimoto has joined |
| 20:44:19 | | sam686 Quit (Ping timeout: 245 seconds) |
| 20:46:38 | | sam686 has joined |
| 20:46:38 | | ChanServ sets mode +v sam686 |
| 20:57:10 | | LordDVG Quit (Read error: Connection reset by peer) |
| 20:57:29 | | LordDVG has joined |
| 20:57:30 | | LordDVG Quit (Changing host) |
| 20:57:30 | | LordDVG has joined |
| 21:29:51 | | sam686 Quit (Read error: Connection reset by peer) |
| 21:32:51 | | sam686 has joined |
| 21:32:51 | | ChanServ sets mode +v sam686 |
| 21:39:09 | Watusimoto | hi |
| 21:45:59 | | sam686 Quit (Ping timeout: 245 seconds) |
| 21:46:56 | | sam686 has joined |
| 21:46:56 | | ChanServ sets mode +v sam686 |
| 21:54:00 | raptor | hi |
| 21:54:09 | raptor | save me from linux configuration files.. |
| 22:02:59 | raptor | Watusimoto: to se a view in phpmyadmin: show create view <view name> |
| 22:04:31 | Watusimoto | cool |
| 22:04:40 | Watusimoto | suicide. it's the only answer. |
| 22:04:55 | Watusimoto | linux config is hell |
| 22:05:17 | raptor | i'm usually pretty good at it - but this problem is nuts |
| 22:05:27 | raptor | have to step back |
| 22:06:19 | Watusimoto | take a walk |
| 22:07:55 | Watusimoto | is show a button? |
| 22:11:15 | | BFLogBot - Commit 15362ab2323e | Author: watusim...@bitfighter.org | Log: Add stubs for sending leaderboard info to client |
| 22:11:17 | | BFLogBot - Commit e0dc9a60ca37 | Author: watusim...@bitfighter.org | Log: Comments |
| 22:23:42 | raptor | no, it isn't - you have to put it in the SQL part |
| 22:26:20 | Watusimoto | I see |
| 22:26:24 | Watusimoto | speaking of sql... |
| 22:26:34 | Watusimoto | this database.cpp is horrible! |
| 22:26:48 | Watusimoto | not poorly written, just... a lot of stuff |
| 22:29:22 | Watusimoto | like... |
| 22:29:25 | Watusimoto | what's this: |
| 22:29:27 | Watusimoto | U64 DatabaseWriter::getServerFromCache(const GameStats &gameStats) |
| 22:29:28 | Watusimoto | { |
| 22:29:28 | Watusimoto | // Check cache for server info |
| 22:29:28 | Watusimoto | for(S32 i = cachedServers.size() - 1; i >= 0; i--) // Counting backwards visits newest servers first |
| 22:29:28 | Watusimoto | if(cachedServers[i].ip == gameStats.serverIP && cachedServers[i].name == gameStats.serverName ) |
| 22:29:29 | Watusimoto | return cachedServers[i].id; |
| 22:29:31 | Watusimoto | return U64_MAX; |
| 22:29:33 | Watusimoto | } |
| 22:29:34 | | LordDVG Quit (Remote host closed the connection) |
| 22:29:43 | Watusimoto | and how do I adapt it for saving achievements? |
| 22:34:09 | | koda Quit (Quit: I used to be chatting like you. Then I took an arrow in the knee) |
| 22:35:56 | raptor | hi |
| 22:36:10 | raptor | umm... |
| 22:36:12 | raptor | ask sam686? |
| 22:36:47 | raptor | i don't actually think i wrote any of the c++ connector stuff |
| 22:38:35 | Watusimoto | sam686: are you around? |
| 22:38:54 | sam686 | hi |
| 22:39:14 | Watusimoto | hi -- I'm trying to figure out how to get an achievement into the database |
| 22:39:31 | Watusimoto | trying to duplicate the methodology used for inserting stats |
| 22:39:53 | Watusimoto | and I'm trying to understand what the getServerFromCache() method (pasted above) is doing |
| 22:40:10 | Watusimoto | what are we caching, and what is the relationship to stats? |
| 22:40:47 | sam686 | all that getServerFromCache does is to try to speed up inserting stats to database by avoiding one "SELECT" query.. |
| 22:42:30 | Watusimoto | ah, so it keeps a list of recently seen servers in memory, and looks at that list instead of going to the database |
| 22:42:47 | Watusimoto | ok, I get it |
| 22:43:02 | Watusimoto | I can probably ignore that for achievements |
| 22:43:29 | Watusimoto | also, there is a Query object kicking around that looks like it has no member functions or data fields |
| 22:43:47 | Watusimoto | class Query { |
| 22:43:47 | Watusimoto | // Empty class |
| 22:43:47 | Watusimoto | }; |
| 22:43:51 | Watusimoto | what does that do? |
| 22:44:01 | raptor | takes up space! |
| 22:45:23 | | sam686` has joined |
| 22:46:24 | | sam686 Quit (Ping timeout: 245 seconds) |
| 22:48:02 | | sam686` is now known as sam686 |
| 22:48:02 | | ChanServ sets mode +v sam686 |
| 22:55:59 | | sam686 Quit (Ping timeout: 245 seconds) |
| 22:56:25 | raptor | later! |
| 22:56:46 | | raptor Quit () |
| 22:58:10 | Watusimoto | sam: in your disconnect issues, did you see my question about the Query class? |
| 23:00:53 | | sam686 has joined |
| 23:00:53 | | ChanServ sets mode +v sam686 |
| 23:01:24 | | BFLogBot - Commit 81b51ec3bc60 | Author: sam8641 | Log: Not sure how that got there, removed it to allow compiling as non-debug mode |
| 23:25:51 | Watusimoto | sam686: any recollection why serverID is a U64? |
| 23:26:29 | sam686 | well... we could get so many reports, that we would ran out of numbers in U32 |
| 23:29:53 | Watusimoto | but does the database have more than U32? |
| 23:30:00 | Watusimoto | looks like an int |
| 23:30:40 | Watusimoto | i agree our cached value should have the same type as the database value |
| 23:31:01 | Watusimoto | but I think our cached value is a different type |
| 23:33:21 | Watusimoto | int is a S32 |
| 23:33:35 | Watusimoto | bigint is a S64 |
| 23:34:24 | Watusimoto | they also have a 3 byte int called a medium int |
| 23:34:30 | Watusimoto | S24 |
| 23:34:44 | sam686 | i guess it is the way "getServerFromDatabase" returns U64, so i end up using U64 |
| 23:36:06 | sam686 | i haven't written the "getServerFromDatabase" function (i think raptor or someone might have written that) |
| 23:36:27 | Watusimoto | I was mostly wondering because I wasn't sure what type gameId should be |
| 23:36:39 | Watusimoto | I think S32 is the answer |
| 23:37:06 | Watusimoto | I think that even if bitfighter is more popular than minecraft, we'd never see 2 billion servers :-) |
| 23:39:11 | Watusimoto | I guess we can dream though! |
| 23:50:44 | Watusimoto | !@#$%^& |
| 23:50:56 | Watusimoto | I need a gameID before stats have been written |
| 23:51:07 | Watusimoto | crap |
| 23:51:12 | Watusimoto | crap crap crap crap |
