| 00:03.40 | kierra | ~joevano++ |
| 00:03.49 | kierra | ~JeffM++ |
| 00:27.02 | *** join/#bzflag JeffM1 (~JeffM@cpe-76-167-238-6.socal.res.rr.com) |
| 01:04.52 | *** join/#bzflag bier (~bier@p54A5BE4F.dip.t-dialin.net) |
| 01:04.52 | *** join/#bzflag bier|tp (~bier@p54A5BE4F.dip.t-dialin.net) |
| 01:08.07 | *** join/#bzflag Pimpinella (~frank@gondolin.pimpi.org) |
| 01:18.34 | *** join/#bzflag JeffM (~JeffM@cpe-76-167-238-6.socal.res.rr.com) |
| 01:18.34 | *** join/#bzflag JeffM (~JeffM@unaffiliated/jeffm2501) |
| 01:18.34 | *** mode/#bzflag [+v JeffM] by ChanServ |
| 01:26.05 | *** join/#bzflag Pimpinella (~frank@gondolin.pimpi.org) |
| 01:33.51 | JeffM | BulletCatcher, I am still somewhat curious about what percentage of our weekly players are leauge players, so if one day in the back of your mind you think of a way to get that info I'd be interested :) |
| 01:35.10 | BulletCatcher | I'll see what I can do. |
| 01:35.58 | JeffM | at the least it'll tell us how usefull leauge integration could be |
| 01:38.02 | BulletCatcher | Strayer might be able to get that number easier than anyone else. |
| 01:38.15 | JeffM | maybe, I don't know |
| 01:44.09 | JeffM | have there been any reports of wiki or images, or mainsite not working? |
| 01:47.15 | BulletCatcher | None that I have heard in the last few days. |
| 01:47.17 | BulletCatcher | I saw wiki, etc., break when your old VPS went away yesterday, but it works for me now that you have changed the opencombat.net A record to point to blast007's. |
| 01:47.32 | JeffM | the old machine wasn't a vps, and it's still up |
| 01:47.39 | JeffM | but yes I moved the dns |
| 01:47.58 | JeffM | I moved it because I wasn't sure when it'd go down |
| 01:48.07 | JeffM | and it looks like tim hasn't responded to chagnes yet |
| 01:48.26 | JeffM | I have to keep one of my personal sites broken untill tim makes changes |
| 01:49.02 | BulletCatcher | We appreciate that. |
| 01:49.03 | BulletCatcher | Hopefully Tim will respond tomorrow. |
| 01:49.15 | JeffM | oh the site is crap so it's not anythign major ;) |
| 01:49.28 | JeffM | i Hope DTRemenak got his stuff off |
| 01:59.42 | BulletCatcher | The my.bzflag.org web logs are no help for the stats you want. |
| 02:00.06 | JeffM | off with there heads |
| 02:00.24 | JeffM | they are discrimianting agasinst me, the UN will hear of this! |
| 02:00.36 | BulletCatcher | It's mostly GET and POST methods. ;-) |
| 02:00.45 | BulletCatcher | No HEADs. |
| 02:00.49 | JeffM | heh |
| 02:00.56 | JeffM | well off with there posts is kinda mean |
| 02:01.31 | BulletCatcher | The data I need is sent via POST, so it isn't in the logs. |
| 02:01.33 | JeffM | can we get a count of all the server adds with auth requests in a week? |
| 02:01.37 | JeffM | ahh |
| 02:02.10 | JeffM | can we log it for the next week? |
| 02:03.09 | BulletCatcher | It should be possible to contstruct SQL queries that show the number of registered accounts active in the last week, and to show how many of those are members of the league usergroups. |
| 02:03.24 | JeffM | ok that's something |
| 02:04.58 | BulletCatcher | Maybe blast007 will help. He should have at least some familarity with the schema. |
| 02:13.17 | JeffM | mostly I'm curious about how many people play a week, how many games they play, and if it's general or leauge play |
| 02:13.25 | JeffM | and the the same data for a month |
| 02:18.00 | kierra | who deleted the JeffM posts and FTT's on the sig thread |
| 02:18.35 | kierra | thats a shame....because JeffM's really explained well to the young crew pitching fits over sigs' rules |
| 02:18.49 | JeffM | what thread? |
| 02:19.06 | kierra | the one joe vano locked earlier |
| 02:19.21 | JeffM | I see my posts, they are just on page 1 |
| 02:19.23 | kierra | the debate one on sig's server rules |
| 02:20.04 | kierra | duh, the serves me right for looking at an old page on my ipad |
| 02:20.08 | kierra | my apologies |
| 02:20.22 | kierra | goes refresh her screen and dye her hair blond |
| 02:21.03 | kierra | :P |
| 02:24.29 | JeffM | your ipad discriminates against you |
| 02:26.13 | blast007 | BulletCatcher: there's an actual bzfls log, if that's what you're looking for |
| 02:26.48 | BulletCatcher | I'd have to see what is in it to know for sure. |
| 02:27.54 | *** join/#bzflag Scrumpy (~Scrumpy@smurfnet.xs4all.nl) |
| 02:27.58 | blast007 | JeffM: I'm fine if the DNS is borked for now |
| 02:28.09 | JeffM | blast007, it's pointing to you |
| 02:28.21 | JeffM | I'll let OC be down untill tim gets it right |
| 02:28.25 | blast007 | k |
| 02:28.31 | JeffM | tis a silly place |
| 02:29.35 | BulletCatcher | hums "We're knights of the round table" |
| 02:29.54 | JeffM | dances when he is able |
| 02:32.55 | delusional | ni |
| 02:42.36 | BulletCatcher | blast007: The bzfls log doesn't seem to have the detailed player info we are looking for. |
| 02:49.54 | *** join/#bzflag AAA_awright_ (~a3@ip24-251-159-93.ph.ph.cox.net) |
| 03:06.01 | blast007 | BulletCatcher: what kind of info are you needing? |
| 03:18.42 | *** part/#bzflag kierra (~Jolie@unaffiliated/kierra) |
| 03:18.51 | *** join/#bzflag kierra (~Jolie@unaffiliated/kierra) |
| 03:56.04 | BulletCatcher | blast007: Read the discussion above between JeffM and me for the last 3 hours. |
| 03:56.06 | BulletCatcher | I am thinking we can get a rough count of recent registered players based upon the phpbb_users.user_lastvisit column, and count league members based upon their membership in specific usergroups. |
| 03:57.19 | BulletCatcher | To the extent that http://wiki.phpbb.com/Tables accurately describes our database I shouldn't have too much trouble writing the SQL for that. |
| 04:00.54 | BulletCatcher | I think we'll need Strayer's database to get details like the number of games played or time spent playing. |
| 04:07.51 | BulletCatcher | SELECT COUNT(*) FROM phpbb_users WHERE user_lastvisit >= (UNIX_TIMESTAMP()-604800); |
| 04:07.52 | BulletCatcher | should give the total number of registered users who have authenticated in the last week. |
| 04:14.50 | BulletCatcher | SELECT COUNT(*) FROM phpbb_users,phpbb_user_group,phpbb_groups WHERE user_lastvisit >= (UNIX_TIMESTAMP()-604800) AND phpbb_users.user_id=phpbb_user_group.user_id AND phpbb_user_group.group_id=phpbb_groups.group_id AND phpbb_groups.group_name='GU.LEAGUE'; |
| 04:14.53 | BulletCatcher | should show the number of those players who are on the GU spawnlist. |
| 04:27.39 | BulletCatcher | DUC.LEAGUE is for Ducati, and I am not sure about the 1vs1, Open, and X leagues. |
| 04:31.11 | BulletCatcher | Since many players are members of multiple leagues we would want the last part of the WHERE clause to be something like AND phpbb_groups.group_name IN ('GU.LEAGUE','DUC.LEAGUE','1vs1','ol','xleague') |
| 04:36.10 | *** join/#bzflag Anxuiz (~Anxuiz@unaffiliated/anxuiz) |
| 04:38.16 | JeffM | that's why I was hoping we could do it from the server auth side, not the player auth side, we'd know what groups they were asking for |
| 06:34.14 | *** join/#bzflag Marzipan (~Marzipan@bzflag/player/Marzipan) |
| 06:36.18 | *** join/#bzflag fuz_ (nobody@vau75-10-88-164-23-88.fbx.proxad.net) |
| 07:26.31 | *** join/#bzflag Tuxist (~quassel@dyndsl-080-228-199-232.ewe-ip-backbone.de) |
| 07:49.38 | *** join/#bzflag sirquine (~quine@c-67-176-80-111.hsd1.co.comcast.net) |
| 08:01.15 | *** join/#bzflag Cobra_Fast (~coprah@2a01:4f8:7d:200:0:4e2f:b550:1) |
| 09:35.11 | *** join/#bzflag tupone (~tupone@gentoo/developer/tupone) |
| 09:35.11 | *** mode/#bzflag [+v tupone] by ChanServ |
| 10:07.55 | CIA-111 | BZFlag: 03atupone * r22140 10/trunk/bzflag/ (4 files in 4 dirs): Allow overriding of CFLAGS/CXXFLAGS |
| 11:12.46 | *** join/#bzflag mdskpr_ (~mdskpr@108.25.139.168) |
| 13:16.22 | *** join/#bzflag AAA_awright_ (~a3@ip24-251-159-93.ph.ph.cox.net) |
| 13:23.58 | *** join/#bzflag meeba (~lamer@c-24-9-87-20.hsd1.co.comcast.net) |
| 13:29.17 | *** join/#bzflag spldart (~spldart2@bzflag/contributor/spldart) |
| 13:29.17 | *** mode/#bzflag [+v spldart] by ChanServ |
| 13:58.37 | *** join/#bzflag Anxuiz (~Anxuiz@unaffiliated/anxuiz) |
| 15:04.14 | *** join/#bzflag TimRiker (~TimRiker@bzflag/projectlead/TimRiker) |
| 15:04.14 | *** mode/#bzflag [+o TimRiker] by ChanServ |
| 15:16.19 | BulletCatcher | TimRiker: Can you do the DNS changes today that were requested by blast007? |
| 15:24.44 | *** join/#bzflag meeba (~lamer@c-24-9-87-20.hsd1.co.comcast.net) |
| 15:25.48 | *** join/#bzflag O-Neil (~Miranda@77-20-145-32-dynip.superkabel.de) |
| 16:00.07 | *** join/#bzflag Tuxist (~quassel@dyndsl-080-228-199-232.ewe-ip-backbone.de) |
| 16:53.38 | *** join/#bzflag fuz_ (nobody@vau75-10-88-164-23-88.fbx.proxad.net) |
| 17:01.05 | *** join/#bzflag fuz_ (nobody@vau75-10-88-164-23-88.fbx.proxad.net) |
| 17:04.29 | *** join/#bzflag BulletCatcher (~bc@bzflag/developer/BulletCatcher) |
| 17:10.17 | *** join/#bzflag JeffM (~JeffM@75.16.90.217) |
| 17:10.17 | *** join/#bzflag JeffM (~JeffM@unaffiliated/jeffm2501) |
| 17:10.17 | *** mode/#bzflag [+v JeffM] by ChanServ |
| 18:02.58 | JeffM | TimRiker, did you get the email from blast about DNS entries? |
| 18:04.13 | JeffM | blast007, old host is offline now so we'll see if I missed any DNS entries. |
| 18:05.31 | *** join/#bzflag BulletCatcher (~bc@bzflag/developer/BulletCatcher) |
| 18:14.46 | *** join/#bzflag randomparticle (~randompar@about/essy/snick/randomparticle) |
| 18:27.51 | *** join/#bzflag randomparticle (~randompar@about/essy/snick/randomparticle) |
| 18:50.46 | blast007 | JeffM: looks like just the main site is borked at the moment |
| 18:51.19 | blast007 | the base domain was put in as an A record, and the www host was put in as a CNAM to the base domain ;) |
| 18:52.13 | blast007 | CNAME* |
| 18:52.48 | blast007 | pokes TimRiker about the DNS changes |
| 19:18.03 | *** join/#bzflag fuz_ (nobody@vau75-10-88-164-23-88.fbx.proxad.net) |
| 19:42.35 | JeffM | he put it in as an IP???? |
| 19:43.19 | JeffM | wonders if TimRiker cares anymore |
| 19:43.42 | JeffM | lets just register bzlag.com and use that for the game name |
| 19:44.34 | blast007 | JeffM: the base record seems like it has to be an IP |
| 19:44.52 | blast007 | or at least, that it SHOULD be an IP |
| 19:45.14 | blast007 | I just wonder why we don't use a free DNS host.. |
| 19:45.25 | blast007 | zoneedit supports two free zones |
| 19:45.49 | blast007 | namecheap has freeDNS hosting as well, even if you don't register the domain through them |
| 19:46.28 | JeffM | heck we could pay noIP to host it for 25$ a year and we could al log in |
| 19:46.29 | blast007 | the .com/.org/.net domains are registered through GoDaddy, which has it's own DNS hosting |
| 19:46.36 | JeffM | ya |
| 19:46.40 | blast007 | namecheap can probably do that too |
| 19:47.02 | blast007 | at least if we have the domain through them |
| 19:48.17 | blast007 | there is a "grant modification rights" option with namecheap that would let the owner of the domain give out rights to other namecheap users |
| 19:53.16 | blast007 | no-ip.com looks to be $25/year/domain |
| 19:54.17 | JeffM | yeah I forogot about the others |
| 19:54.34 | JeffM | hell he should GIVE us the login for godaddy, then we can pay it :) |
| 19:55.25 | blast007 | (or transfer it to a registrar that won't hold it hostage if something screws up) :P |
| 19:57.14 | brlcad | the dns records look like they're set up the way they've always been set up, nothing wrong with them (other than pointing to an IP that was let go before dns got updated) |
| 19:57.17 | JeffM | I have had no issues with godaddy |
| 19:57.47 | JeffM | I asked him to point them as cnames to services.bzflag.opencombat.org so that would not happen |
| 19:57.54 | JeffM | oh well |
| 19:58.21 | JeffM | ya try to make it painles... |
| 19:59.59 | blast007 | well, for the ones I had him move (images, and the main site), I had him set it up as a CNAME to opencombat.net since that's how he had set up the other ones |
| 20:00.04 | JeffM | maybe someone will sue is for discriminating against IP-Apermicans |
| 20:01.20 | blast007 | brlcad: like they've always been set up? not quite. A number of them were changed a month or two ago to be CNAME records. |
| 20:01.29 | brad | <PROTECTED> |
| 20:01.32 | brad | fail |
| 20:01.45 | JeffM | they were set up that way when they were on his machine |
| 20:01.47 | TimRiker | was out of town and just got back |
| 20:01.51 | JeffM | huzzah |
| 20:02.46 | TimRiker | note: this won't work... bzflag.org CNAME bzflag.bzexcess.com as zones can't be cnames |
| 20:02.56 | blast007 | yeah, make it 109.169.80.184 |
| 20:04.12 | blast007 | JeffM: I've transferred all my domains away from GoDaddy |
| 20:04.23 | JeffM | what issues did you have? |
| 20:04.37 | blast007 | I hadn't had any yet |
| 20:04.56 | JeffM | just didn't like some of the policies they applied to others? |
| 20:06.09 | blast007 | well, as an example, someone I know has a domain for their business through godaddy, and it is currently disabled witht he name servers set to some bogus servers (NS1/NS2.SUSPENDED-FOR.SPAM-AND-ABUSE.COM) |
| 20:07.00 | blast007 | and they've called support at least three time trying to get it resolved, and support keeps telling them it will be fixed or transferring them between departments saying "they can't help" |
| 20:07.13 | JeffM | hmm |
| 20:07.34 | JeffM | I've never had any issues, and my had an issue but they resolved it very nicely |
| 20:07.56 | blast007 | and supposedly there's a $199 and $50 fees to reactivate a domain that has been suspended, depending on the situation and how you want to resolve it |
| 20:07.57 | JeffM | when my mom died he had to take over and cancel her domain and services etc.. |
| 20:08.14 | *** join/#bzflag DarkCalf (DC@173.231.40.98) |
| 20:08.16 | JeffM | they did it fast and easy for him all over the phone |
| 20:08.54 | blast007 | hmm |
| 20:09.18 | JeffM | he had to prove he knew the account number, and some other stuff, but once that was done they were quite nice. |
| 20:09.21 | blast007 | I never had to contact them, so I can't say for myself what their support is like |
| 20:09.34 | JeffM | they even refuneded the full auto renewal |
| 20:10.09 | TimRiker | request wants downloads.b.o but there isn't one, there is a download.b.o though |
| 20:10.35 | JeffM | we do have more then one download :) |
| 20:10.37 | blast007 | oops, yeah, download.bzflag.org then |
| 20:11.10 | blast007 | JeffM: was a typo though - was trying to update the existing records ;) |
| 20:11.12 | TimRiker | blast007, to downloads.bzflag.bzexcess.com or download.bzflag.bzexcess.com ? |
| 20:11.28 | JeffM | blast007, I figured, I just like downloads over download :) |
| 20:12.11 | blast007 | TimRiker: make it to download.bzflag.bzexcess.com (which I just fixed) |
| 20:13.02 | TimRiker | blast007, services.b.o ? |
| 20:13.40 | TimRiker | beta.b.o ? |
| 20:13.43 | brlcad | blast007: was referring to just bzflag.org and www.bzflag.org, the latter has been a cname to the prior |
| 20:13.52 | blast007 | brlcad: k |
| 20:14.22 | blast007 | TimRiker: I guess make that a CNAME to services.bzflag.bzexcess.com (not sure if we even have anything there yet) |
| 20:14.55 | JeffM | the idea was that was where auth and list would live |
| 20:15.12 | blast007 | ok |
| 20:15.37 | JeffM | to get away from the "my" stuff |
| 20:15.45 | blast007 | yeah :) |
| 20:16.32 | blast007 | whatever we pick, it'd be nice to get an SSL certificate for it so we can auth over SSL |
| 20:16.41 | JeffM | yes |
| 20:16.47 | blast007 | and then integrate other web services into webauth |
| 20:16.52 | JeffM | thats why "services" was thought of |
| 20:21.06 | TimRiker | ~nslookup bzflag.org |
| 20:21.39 | blast007 | awesome, thanks TimRiker |
| 20:21.53 | TimRiker | np. sry to lag a bit being out of town. |
| 20:22.29 | blast007 | TimRiker: is there any chance of having the primary zone moved to some hosting service like NameCheap's FreeDNS or a similar service so that other people can alter records? |
| 20:22.39 | TimRiker | we have backups of the old server? what's the plan? |
| 20:22.57 | blast007 | the sites were already moved over |
| 20:23.14 | blast007 | the ones that had been migrated to JeffM's server, at least |
| 20:23.27 | blast007 | some of them (list, auth, forums) are still on bzflag.bz |
| 20:23.38 | TimRiker | blast007, I'm open to suggestions there. I keep current zone files in version control with comments on changes. I'd like to have that ability. |
| 20:24.15 | TimRiker | just neither b.o nor b.o/bb/ get something useful from here. |
| 20:24.57 | blast007 | bzflag.org works for me |
| 20:25.02 | blast007 | and the forum is at my.bzflag.org/bb/ |
| 20:25.28 | blast007 | hmm, actually bzflag.org isn't working for me I guess |
| 20:25.30 | TimRiker | http://bzflag.org/ give me "It works!" |
| 20:25.42 | blast007 | must have a hosts file record on my server |
| 20:25.43 | TimRiker | s/give/gives/ |
| 20:31.48 | blast007 | there :) |
| 20:53.10 | *** join/#bzflag ahs3- (~ahs3@adsl-065-005-193-158.sip.rdu.bellsouth.net) |
| 21:08.55 | *** join/#bzflag Admirarch (~Athelthra@mrush.mth.abdn.ac.uk) |
| 21:15.41 | *** join/#bzflag lahwran (~lahwran@unaffiliated/lahwran) |
| 21:56.49 | *** join/#bzflag DarkCalff (DC@2002:ade7:2862::ade7:2862) |
| 22:09.50 | *** join/#bzflag DarkCalfz (DC@173.231.40.98) |
| 22:12.04 | *** join/#bzflag Anxuiz (~Anxuiz@unaffiliated/anxuiz) |
| 22:13.28 | *** join/#bzflag DarkCalff (DC@2002:ade7:2862::ade7:2862) |
| 22:15.41 | *** join/#bzflag lahwran- (~lahwran@ipv6.sonicrules.org) |
| 22:17.15 | *** join/#bzflag lahwran- (~lahwran@unaffiliated/lahwran) |
| 22:51.01 | *** join/#bzflag essy (~essy@freenode/staff/sportchick) |
| 22:51.01 | *** mode/#bzflag [+v essy] by ChanServ |
| 22:58.49 | *** join/#bzflag FastLizard4|zZzZ (fastlizard@wikipedia/pdpc.active.FastLizard4) |
| 23:14.44 | *** join/#bzflag FastLizard4|zZzZ (fastlizard@wikipedia/pdpc.active.FastLizard4) |
| 23:17.50 | *** join/#bzflag DarkCalfz (DC@173.231.40.98) |
| 23:18.12 | *** join/#bzflag essy (~essy@freenode/staff/sportchick) |
| 23:18.12 | *** mode/#bzflag [+v essy] by ChanServ |
| 23:21.09 | *** join/#bzflag FastLizard4|zZzZ (fastlizard@wikipedia/pdpc.active.FastLizard4) |
| 23:22.11 | *** join/#bzflag lahwran (~lahwran@unaffiliated/lahwran) |
| 23:28.01 | *** join/#bzflag FastLizard4|zZzZ (fastlizard@wikipedia/pdpc.active.FastLizard4) |
| 23:37.26 | JeffM | blast007 / joevano it does not seem like the new wiki is hooked up to CIA |
| 23:37.28 | JeffM | just FYI |
| 23:51.25 | *** join/#bzflag FastLizard4|zZzZ (fastlizard@wikipedia/pdpc.active.FastLizard4) |
| 23:53.11 | *** join/#bzflag lahwran (lahwran@unaffiliated/lahwran) |