IRC log for #bzflag on 20091122

00:07.47*** join/#bzflag mrapplecomputer1 (n=admin@c-69-180-173-220.hsd1.mn.comcast.net)
00:21.49*** join/#bzflag JeffM (n=JeffM@bzflag/projectadmin/JeffM)
00:21.49*** mode/#bzflag [+o JeffM] by ChanServ
00:47.26*** join/#bzflag xaver (n=xaver@pD9ED7D6B.dip.t-dialin.net)
00:56.02*** join/#bzflag AAA_awright_ (n=a3@ip24-251-157-63.ph.ph.cox.net)
01:14.57*** join/#bzflag MindstormsKid (n=msk@Wikipedia/MindstormsKid)
01:17.25*** join/#bzflag xaver (n=xaver@pD9ED7D6B.dip.t-dialin.net)
01:45.03*** join/#bzflag xaver (n=xaver@pD9ED7D6B.dip.t-dialin.net)
01:54.59*** join/#bzflag xaver (n=xaver@pD9ED7D6B.dip.t-dialin.net)
01:57.14*** join/#bzflag Think_Differentl (n=fatass@bzflag/player/ThinkDifferent)
01:57.14*** join/#bzflag spldart (n=spldart2@bzflag/contributor/spldart)
01:57.14*** mode/#bzflag [+v spldart] by irc.freenode.net
01:57.20*** join/#bzflag short_circuit (n=spldart2@71.29.230.37)
01:57.50*** join/#bzflag fatass (n=fatass@pool-96-231-84-91.washdc.east.verizon.net)
01:58.27*** mode/#bzflag [+v spldart] by ChanServ
02:01.20*** join/#bzflag xaver__ (n=xaver@pD9ED426C.dip.t-dialin.net)
02:24.42mrapplecomputer1hey um, this is kinda wierd
02:24.48mrapplecomputer1me and fish were playing on his map
02:25.00mrapplecomputer1and i had OO in a building and he had SW and he coudlnt kill me in the building
02:25.07mrapplecomputer1but when i came out, he was able to kill me
02:25.33mrapplecomputer1we just tested it and the same thing happened. any ideas why? sw is supposed to kill tanks with oo in buildings i know that for sure
02:26.28BulletCatcherQuit using a cheat client. ;-)
02:26.48mrapplecomputer1:|
02:26.56mrapplecomputer1we just tested it on multiple people
02:26.59BulletCatcherbranch or trunk?
02:27.10mrapplecomputer12.0.13
02:27.40BulletCatcherYes, SW is supposed to kill OO when they are in a building.
02:27.44BulletCatcherIt usually does.
02:27.51mrapplecomputer1yes but its not
02:28.10BulletCatcherThere may be some oddity with the map.  Try a different one.
02:28.10mrapplecomputer1is there any reason why it shouldnt other then a major bug in 2.0.13 ?
02:28.15mrapplecomputer1ok
02:28.38me1mrapplecomputer1,
02:28.45mrapplecomputer1yes
02:28.53me1sorry, that was an accident
02:33.55*** join/#bzflag spldart (n=spldart2@bzflag/contributor/spldart)
02:33.55*** mode/#bzflag [+v spldart] by irc.freenode.net
02:37.46*** join/#bzflag xaver (n=xaver@pD9ED426C.dip.t-dialin.net)
02:38.32*** join/#bzflag Pimpi_ (n=frank@gondolin.pimpi.org)
02:49.30*** join/#bzflag bier_ (n=bier@pD9E2E6BF.dip.t-dialin.net)
02:49.30*** join/#bzflag jcp (n=jw@unaffiliated/javawizard2539) [NETSPLIT VICTIM]
02:49.30*** join/#bzflag PrezKennedy (i=Matthew@208.43.126.194) [NETSPLIT VICTIM]
02:49.30*** join/#bzflag joevano (n=joevano@bzflag/developer/JoeVano)
02:49.30*** mode/#bzflag [+v joevano] by irc.freenode.net
02:51.08*** join/#bzflag PrezKennedyII (i=Matthew@whitecalf.net)
02:55.29*** join/#bzflag joevano (n=joevano@c-67-177-186-145.hsd1.in.comcast.net)
02:55.53*** mode/#bzflag [+v joevano] by ChanServ
02:56.30*** join/#bzflag bier_ (n=bier@pD9E2E6BF.dip.t-dialin.net)
03:04.01*** join/#bzflag jcp (n=jw@unaffiliated/javawizard2539) [NETSPLIT VICTIM]
03:04.06*** join/#bzflag dcat (n=dirtycat@ip70-188-1-177.rn.hr.cox.net)
03:05.47*** join/#bzflag Default__ (n=Default@97.95.228.124)
03:08.42*** join/#bzflag spldart (n=spldart2@bzflag/contributor/spldart)
03:08.42*** mode/#bzflag [+v spldart] by irc.freenode.net
03:32.17*** join/#bzflag mrapplecompute-1 (n=admin@c-69-180-162-150.hsd1.mn.comcast.net)
03:33.40*** part/#bzflag mrapplecompute-1 (n=admin@unaffiliated/mrapplecomputer1)
03:35.42*** join/#bzflag mrapplecompute-2 (n=admin@unaffiliated/mrapplecomputer1)
03:50.20*** join/#bzflag PrezKennedy (i=Matthew@208.43.126.194)
04:11.58*** join/#bzflag AAA_awright (n=a3@24.251.157.63)
04:47.57JeffMblast007: you arround?
04:48.03blast007yep
04:48.43JeffMgot any idea how to do an sql query that will only return rows that have a datetime field before a specifc datetime?
04:48.50JeffM< dosn't seem to work
04:49.10JeffMbassicly trying to find anything that hasn't been updated in 300 seconds
04:49.17blast007hmm, can't say I've ever tried that before
04:49.26blast007only used datetime fields a few times
04:49.27JeffMso I subtract 300 seconds from now and use that in the where
04:49.34JeffM<PROTECTED>
04:49.41blast007let me see if I've done something like that before
04:51.02blast007ah, guess I was just doing a unix timestamp most recently. so no, haven't had any experience with comparing datetime's
04:51.16JeffMok, I shall reasearch more, thanks :)
04:51.33JeffMmysql dosn't track the last update to a record does it?
04:51.52blast007I don't think it does automatically
04:52.02JeffMnether did I, that's why I threw a field in there
04:52.12blast007but I think you can create a field that is set to the current datatime (or unix timestamp) when the record is updated
04:54.12blast007'on update current_timestamp' might only work for the timestamp data type: http://dev.mysql.com/doc/refman/5.0/en/timestamp.html
04:54.54JeffMahh so I don't have to push it
04:55.51blast007http://bugs.mysql.com/bug.php?id=12765  <-- that bug mentions using triggers to get the desired functionality for datetime
04:57.26JeffMI like the sugested fix
05:00.28JeffMahah, got it just had some bad quotes
05:00.47blast007k
05:00.47JeffMthe sql param in the command will take care of the ''
05:01.14JeffMyay, my wierd crap actualy works :)
05:02.01JeffMthanks for the info on the timestamp field, that may come in handy
05:02.07JeffMfor the zone database
05:04.20*** join/#bzflag jcp (n=jw@unaffiliated/javawizard2539)
05:16.28BulletCatcherJeffM: From my experience, your @DeadDate method is the best way to  use a datetime type.
05:19.54JeffMyeah just shove it in :)
05:25.34JeffMnow to make a character server
05:35.12*** join/#bzflag L4m3r_Eee (n=L4m3r@bzflag/developer/L4m3r)
05:35.12*** mode/#bzflag [+v L4m3r_Eee] by ChanServ
06:06.58*** join/#bzflag temporalD (n=ATD@bzflag/serverop/TemporalDistraction)
06:39.58*** join/#bzflag xaver__ (n=xaver@pD9ED7498.dip.t-dialin.net)
06:45.08*** join/#bzflag PrezKennedy (i=Matthew@208.43.126.194)
07:03.17*** join/#bzflag TD--Linux (n=wheeeeee@96-42-93-246.dhcp.roch.mn.charter.com)
07:53.52*** join/#bzflag xwissen (n=xaver@pD9ED7D78.dip.t-dialin.net)
07:56.32*** join/#bzflag xaver (n=xaver@pD9ED7D78.dip.t-dialin.net)
08:00.35blast007kujaneck
08:00.40blast007ww
08:48.55*** join/#bzflag ramirez (n=ramirez@189.124.144.197)
09:26.20*** join/#bzflag deprecated (n=deprecat@c-98-225-59-252.hsd1.wa.comcast.net)
09:35.44*** join/#bzflag joevano (n=joevano@bzflag/developer/JoeVano)
09:35.45*** mode/#bzflag [+v joevano] by ChanServ
12:19.59*** join/#bzflag Upsetter (n=ups@88.130.163.5)
12:24.59*** join/#bzflag Murielle (n=murielle@unaffiliated/murielle)
12:26.54*** join/#bzflag Wits (n=Wits@249.93.188.72.cfl.res.rr.com)
12:43.15*** join/#bzflag AAA_awright (n=a3@24.251.157.63)
13:38.47*** join/#bzflag mrapplecomputer1 (n=admin@unaffiliated/mrapplecomputer1)
16:10.38*** join/#bzflag Default__ (n=Default@97.95.228.124)
16:32.29brlcadhuh, something wrong with the image uploader
16:32.40brlcadpurplepanzer's last three images are hozered
16:36.58*** join/#bzflag Wits (n=Wits@249.93.188.72.cfl.res.rr.com)
17:11.51*** join/#bzflag Thumper_ (n=Thumper@about/essy/coffeeAddict/Thumper)
17:11.51*** mode/#bzflag [+v Thumper_] by ChanServ
17:18.23*** join/#bzflag Qew (n=qew@unaffiliated/qew)
17:20.14*** join/#bzflag delusional (n=Delusion@unaffiliated/delusional)
17:40.42*** join/#bzflag Tupone (n=Tupone@gentoo/developer/tupone)
17:40.42*** mode/#bzflag [+v Tupone] by ChanServ
18:12.50*** join/#bzflag JeffM (n=JeffM@bzflag/projectadmin/JeffM)
18:12.51*** mode/#bzflag [+o JeffM] by ChanServ
18:34.05*** join/#bzflag mrapplecomputer1 (n=admin@unaffiliated/mrapplecomputer1)
18:36.28*** part/#bzflag mrapplecomputer1 (n=admin@unaffiliated/mrapplecomputer1)
18:43.27*** join/#bzflag R0b0t1 (n=Enigma@unaffiliated/r0b0t1)
18:59.01*** join/#bzflag temporalD (n=ATD@bzflag/serverop/TemporalDistraction)
19:38.23*** join/#bzflag Upsetter (n=ups@88.130.183.237)
20:04.15*** join/#bzflag bier|tp (n=bier@pD9E2C0FA.dip.t-dialin.net)
20:04.27*** join/#bzflag bier_ (n=bier@pD9E2C0FA.dip.t-dialin.net)
20:07.42*** join/#bzflag Think_Differentl (n=fatass@pool-96-231-84-91.washdc.east.verizon.net)
20:30.41*** join/#bzflag Wyk3d (n=wyk3d@cl-86-125-162-247.cablelink.mures.rdsnet.ro)
20:31.57*** join/#bzflag mrapplecomputer1 (n=admin@unaffiliated/mrapplecomputer1)
20:33.58*** join/#bzflag mrapplecomputer1 (n=admin@c-69-180-173-220.hsd1.mn.comcast.net)
20:36.43*** join/#bzflag trepan (n=trepan@unaffiliated/trepan)
20:36.43*** mode/#bzflag [+v trepan] by ChanServ
20:47.21*** join/#bzflag me1 (n=ausom@bzflag/player/Me1)
21:01.01*** join/#bzflag a_meteorite (n=a_meteor@unaffiliated/ameteorite/x-000000001)
22:18.48*** join/#bzflag Flash (n=jwmelto@bzflag/developer/Flash)
22:19.05*** join/#bzflag Djpenguin (n=David@c-71-202-201-94.hsd1.ca.comcast.net)
23:00.53*** join/#bzflag spldart (n=spldart2@bzflag/contributor/spldart)
23:00.53*** mode/#bzflag [+v spldart] by ChanServ
23:21.44CIA-65BZFlag: 03Gabe G23 07http://my.bzflag.org * r6794 10/w/TorBlock: Fixed a punctuation mistake, no biggy.
23:22.25Gabe_G23^^ lol
23:26.27*** join/#bzflag Yassen (n=Yassen@unaffiliated/yassen)
23:31.54*** join/#bzflag TD-Linux (n=wheeeeee@about/essy/indecisive/TD-Linux)
23:40.19CIA-65BZFlag: 0394.75.220.40 07http://my.bzflag.org * r6795 10/w/User_talk:Gabe_G23: Ohai Gabe_G23
23:48.18Gabe_G23um... somebody delete that
23:48.48spldartPlay much?
23:49.43CIA-65BZFlag: 03Michaelgoss 07http://my.bzflag.org * r6796 10/w/User_talk:Gabe_G23: made Gabe_G23 bold text
23:51.16*** join/#bzflag a3Dman (n=3Dman@41.238.117.65)
23:51.55Gabe_G23spldart: not me :(
23:53.47*** join/#bzflag a3Dman_ (n=3Dman@41.238.117.65)
23:54.18CIA-65BZFlag: 03Michaelgoss 07http://my.bzflag.org * r6797 10/w/User_talk:Gabe_G23: Michael Goss the biggest fgt in the universe (I am very proud of this)
23:54.34a3Dman_O.o
23:55.16CIA-65BZFlag: 03Blast 07http://my.bzflag.org * r0 10/w/Special:Log/block: blocked [[User:Michaelgoss]] with an expiry time of infinite (account creation disabled, e-mail blocked): Inserting nonsense/gibberish into pages
23:55.18*** join/#bzflag mac-mini (n=mac-mini@unaffiliated/macmini/x-648924)
23:55.35a3Dman_:)
23:55.44CIA-65BZFlag: 03Blast 07http://my.bzflag.org * r0 10/w/Special:Log/delete: deleted "[[User talk:Gabe G23]]": garbage
23:55.51me1does anyone else see the navbar as below the main block?
23:56.19blast007me1: navbar of what?
23:56.23me1the wiki
23:56.30me1it's like
23:56.31blast007no
23:56.35me1_below_ the main block
23:56.42blast007screenshot?
23:57.03Gabe_G23thx blast007
23:57.07blast007Gabe_G23: np
23:59.15me1it looks to be chrome-specific: http://dl.dropbox.com/u/170176/untitled.JPG

Generated by irclog2html.pl Modified by Tim Riker to work with infobot.