| 00:15.42 | *** join/#bzflag AAA_awright (~a3@ip24-251-157-63.ph.ph.cox.net) |
| 00:22.43 | *** join/#bzflag McYukon (~McYukon@xplr-ts-v10-208-114-191-42.barrettxplore.com) |
| 02:20.10 | *** join/#bzflag AAA_awright_ (~a3@ip24-251-157-63.ph.ph.cox.net) |
| 02:22.49 | *** join/#bzflag McYukon (~alko@xplr-ts-v10-208-114-191-42.barrettxplore.com) |
| 03:08.53 | *** join/#bzflag McYukon (~alko@xplr-ts-v10-208-114-191-42.barrettxplore.com) |
| 04:21.07 | *** join/#bzflag Packman (~chatzilla@222-154-172-76.jetstream.xtra.co.nz) |
| 04:24.24 | Packman | I seem to have a very bad bug caused by the single line "bzAPIIntList *playerList = bz_newIntList();" |
| 04:25.18 | Packman | Results include 1) no problem, 2) bzfs crashes, 3) the function it is used in is somehow called twice :: recursively even! |
| 04:26.18 | Packman | I'm doubtful, but: can anyone think of any possible reasons? |
| 04:26.58 | blast007 | run it through a debugger |
| 04:28.22 | Packman | how do i debug a plugin? |
| 04:28.49 | Packman | i'm on msvc |
| 04:37.07 | blast007 | Packman: build bzfs (and the plugins) in debug, and tweak the debug options for bzfs to point to the exe and to pass the right arguments (the -loadplugin) |
| 04:38.05 | blast007 | debug options for the bzfs project, that is |
| 04:41.25 | Packman | yuck, one of my bz_debugMessagesf was wrong |
| 04:43.48 | *** join/#bzflag AAA_awright (~a3@ip24-251-157-63.ph.ph.cox.net) |
| 05:04.28 | *** join/#bzflag AAA_awright_ (~a3@ip24-251-157-63.ph.ph.cox.net) |
| 05:08.49 | *** join/#bzflag Constitution (~const@bzflag/developer/Constitution) |
| 05:13.26 | *** join/#bzflag Thumper_ (~Thumper@about/essy/coffeeAddict/Thumper) |
| 05:13.26 | *** mode/#bzflag [+v Thumper_] by ChanServ |
| 05:22.13 | *** join/#bzflag noyb (~noyb@96.247.88.164) |
| 05:37.39 | Packman | the bug i originally claimed is still real: causing the function to call itself recursively for no reason |
| 05:38.01 | Packman | i used the debugger and found that "bz_killPlayer(player->playerID, 0);" is the cause |
| 05:38.36 | Packman | commenting that one line stops the bug (but of course i want to use the kill function) |
| 05:40.01 | Packman | Furthermore, msvc debugger would show some line being run but the console output told me a different line was actually being executed |
| 06:33.09 | *** join/#bzflag Anxuiz (~Anxuiz@c-67-171-11-99.hsd1.wa.comcast.net) |
| 06:33.09 | *** join/#bzflag Anxuiz (~Anxuiz@unaffiliated/anxuiz) |
| 07:23.08 | *** join/#bzflag noyb (~noyb@96.247.88.164) |
| 07:26.17 | *** join/#bzflag Marzipan- (~Marzipan@p5B2262DD.dip.t-dialin.net) |
| 07:27.34 | *** join/#bzflag Marzipan (~Marzipan@bzflag/player/Marzipan) |
| 07:55.53 | *** join/#bzflag AAA_awright_ (~a3@ip24-251-157-63.ph.ph.cox.net) |
| 08:13.06 | *** join/#bzflag PrezKennedy (MK@whitecalf.net) |
| 08:18.33 | *** join/#bzflag Bankersownyou (~zog@adsl-76-199-9-102.dsl.chmpil.sbcglobal.net) |
| 09:21.38 | *** join/#bzflag xaver (~xaver@pD9ED4A7A.dip.t-dialin.net) |
| 09:29.56 | *** join/#bzflag jh` (jh@212-149-235-210.bb.dnainternet.fi) |
| 10:58.57 | *** join/#bzflag alezakos (~kongr45gp@ppp-2-85-30-193.home.otenet.gr) |
| 11:23.32 | *** join/#bzflag Upsetter (~Ups@88.130.191.126) |
| 11:54.15 | *** join/#bzflag Upsetter1 (~Ups@88.130.178.85) |
| 13:15.36 | *** join/#bzflag CBG (~CBG@about/essy/fan/CBG) |
| 13:15.59 | Constitution | hey CBG |
| 13:16.11 | CBG | Hi :) |
| 13:36.27 | *** join/#bzflag alezakos (~kongr45gp@ppp-2-85-27-180.home.otenet.gr) |
| 13:37.01 | *** join/#bzflag bier (~bier@p57A66F2B.dip.t-dialin.net) |
| 13:37.13 | trepan | http://trepan.bzflag.bz/flipgui.jpg -- simple gui change for wider screens |
| 13:37.38 | trepan | (fwiw, panel height/width/opacity can all be adjusted independent of the radar) |
| 13:37.54 | trepan | got curious about the right/left brain aspect of the radar's position :) |
| 13:38.06 | *** join/#bzflag bier|tp (~bier@p57A66F2B.dip.t-dialin.net) |
| 13:39.57 | Upsetter1 | trepan: nice. and ya: change radar to the left side :) |
| 13:40.16 | trepan | makes more sense to have text on the left |
| 13:40.43 | trepan | (at least for english it does :) |
| 13:41.59 | Upsetter1 | well, add an option to swap radar and chat :) |
| 13:42.29 | trepan | you already have that option |
| 13:42.46 | trepan | (but without the manual control of the panel width...) |
| 13:44.41 | Constitution | that's a pretty tiny radar :) |
| 14:09.12 | *** join/#bzflag sirquine (~quine@c-71-199-123-80.hsd1.pa.comcast.net) |
| 14:21.50 | mrapple | you can swap console and radar? o.O |
| 14:21.57 | *** part/#bzflag kierra (~jolie@unaffiliated/kierra) |
| 14:27.50 | Constitution | yo mrapple |
| 14:35.53 | *** join/#bzflag Sniper_Germany (57acffdc@gateway/web/freenode/ip.87.172.255.220) |
| 14:56.39 | brad | cbg is back! |
| 15:15.58 | mrapple | hi Constitution, CBG |
| 15:16.23 | mrapple | also, so you can swap the radar and console? how? |
| 15:20.36 | blast007 | photoshop |
| 15:34.22 | *** join/#bzflag alezakos (~kongr45gp@ppp-2-85-12-205.home.otenet.gr) |
| 15:43.07 | *** join/#bzflag xaver (~xaver@pD9ED4A7A.dip.t-dialin.net) |
| 15:44.54 | alezakos | I suggest making autopilot server-side, if it is possible. Players won't be able to enable autopilot in servers with _disableBots 1. |
| 15:47.12 | trepan | blast007: considerably easier to write the dozen or so lines of code than to do a decent bit of image manip. |
| 15:56.22 | ruskie | ugh... do not really like the interface in that screen |
| 16:00.29 | *** join/#bzflag Upsetter (~Ups@88.130.190.34) |
| 16:04.51 | CBG | So... err... What's the release date for 3.0.0? |
| 16:05.20 | CBG | ;) |
| 16:22.45 | *** join/#bzflag I_Died_Once (~I_Died_On@unaffiliated/idiedonce/x-1828535) |
| 16:26.57 | *** join/#bzflag kierra (~jolie@unaffiliated/kierra) |
| 16:27.36 | *** join/#bzflag sirquine (~quine@c-71-199-123-80.hsd1.pa.comcast.net) |
| 16:32.10 | *** join/#bzflag I_Died_Once (~I_Died_On@unaffiliated/idiedonce/x-1828535) |
| 16:39.54 | *** join/#bzflag alezakos (~alezakos@ppp-2-85-12-205.home.otenet.gr) |
| 16:48.52 | *** join/#bzflag AAA_awright_ (~a3@ip24-251-157-63.ph.ph.cox.net) |
| 16:59.46 | *** join/#bzflag I_Died_Once (~I_Died_On@unaffiliated/idiedonce/x-1828535) |
| 17:03.55 | *** join/#bzflag TD-Linux (~thomas@97-86-233-4.dhcp.roch.mn.charter.com) |
| 17:09.50 | *** join/#bzflag sirquine (~quine@c-71-199-123-80.hsd1.pa.comcast.net) |
| 17:37.11 | *** join/#bzflag jh` (jh@212-149-233-75.bb.dnainternet.fi) |
| 17:37.18 | *** join/#bzflag MindstormsKid (~msk@Wikipedia/MindstormsKid) |
| 17:39.12 | *** join/#bzflag kongr45gpen (~alezakos@ppp-2-85-12-205.home.otenet.gr) |
| 17:39.45 | *** join/#bzflag TyroneFHornigh (~dbw@adsl-71-136-254-245.dsl.sndg02.pacbell.net) |
| 18:11.06 | *** join/#bzflag JeffM2501 (~JeffM@unaffiliated/jeffm2501) |
| 18:11.06 | *** mode/#bzflag [+v JeffM2501] by ChanServ |
| 18:14.41 | *** join/#bzflag sirquine (~quine@c-71-199-123-80.hsd1.pa.comcast.net) |
| 18:20.35 | blast007 | trepan: yeah, I know ;) |
| 18:20.37 | blast007 | at least for you |
| 18:20.43 | *** join/#bzflag Upsetter1 (~Ups@88.130.167.191) |
| 18:21.14 | *** join/#bzflag sirquine (~quine@c-71-199-123-80.hsd1.pa.comcast.net) |
| 18:27.03 | *** join/#bzflag sirquine (~quine@c-71-199-123-80.hsd1.pa.comcast.net) |
| 18:27.31 | *** join/#bzflag alezakos_ (~kongr45gp@ppp-2-85-12-205.home.otenet.gr) |
| 18:27.36 | *** part/#bzflag alezakos_ (~kongr45gp@ppp-2-85-12-205.home.otenet.gr) |
| 18:36.35 | *** join/#bzflag JeffM_ (~JeffM@adsl-75-50-180-85.dsl.lsan03.sbcglobal.net) |
| 18:37.03 | *** join/#bzflag WhiteCalf (MK@whitecalf.net) |
| 18:37.20 | *** join/#bzflag JBdiGriz (~dbw@adsl-71-136-254-245.dsl.sndg02.pacbell.net) |
| 18:39.12 | *** join/#bzflag Bambino_ (~bambino@bzextreme.com) |
| 18:39.50 | *** join/#bzflag alezakos_ (~kongr45gp@ppp-2-85-12-205.home.otenet.gr) |
| 18:40.10 | *** join/#bzflag Murielle` (~Murielle@206.222.19.114) |
| 18:40.14 | *** join/#bzflag cods_ (~cods@tuxee.net) |
| 18:40.43 | *** join/#bzflag kierra (~jolie@c-98-230-46-23.hsd1.fl.comcast.net) |
| 18:40.45 | *** join/#bzflag Quol_away (~Quol@69.90.0.146) |
| 18:40.45 | *** join/#bzflag kierra (~jolie@unaffiliated/kierra) |
| 18:40.46 | *** join/#bzflag sam____ (sam@poulet.zoy.org) |
| 18:40.57 | *** join/#bzflag kongr45gpen (~alezakos@ppp-2-85-12-205.home.otenet.gr) |
| 18:41.02 | *** join/#bzflag javawizard (~jw@bzflag/contributor/javawizard2539) |
| 18:41.03 | *** join/#bzflag joevano (~joevano@bzflag/developer/JoeVano) |
| 18:41.03 | *** mode/#bzflag [+v joevano] by ChanServ |
| 18:41.40 | *** join/#bzflag I_Died_Once (~I_Died_On@unaffiliated/idiedonce/x-1828535) |
| 18:41.57 | *** join/#bzflag blast007 (~blast007@bzflag/developer/Blast) |
| 18:41.57 | *** mode/#bzflag [+v blast007] by ChanServ |
| 18:42.05 | *** join/#bzflag bier (~bier@p57A66F2B.dip.t-dialin.net) |
| 18:44.09 | *** join/#bzflag brlcad (~sean@BZ.BZFLAG.BZ) |
| 18:44.15 | *** join/#bzflag CIA-75 (~CIA@208.69.182.149) |
| 18:45.22 | *** join/#bzflag kongr45gpen (~alezakos@ppp-2-85-12-205.home.otenet.gr) |
| 18:47.45 | *** join/#bzflag blast007_ (~blast007@bzflag/developer/Blast) |
| 18:47.45 | *** mode/#bzflag [+v blast007_] by ChanServ |
| 18:47.53 | *** join/#bzflag Quol_away (~Quol@69.90.0.146) |
| 18:52.02 | *** join/#bzflag kierra (~jolie@unaffiliated/kierra) |
| 18:52.24 | *** join/#bzflag TD-Linux (~thomas@97-86-233-4.dhcp.roch.mn.charter.com) |
| 19:01.25 | Constitution | ~BulletCatcher++ |
| 19:01.31 | Constitution | ~blast007++ |
| 19:03.19 | *** join/#bzflag BulletCatcher (~bc@bzflag/developer/BulletCatcher) |
| 19:05.34 | kierra | ~Constitution++ |
| 19:07.30 | Constitution | also |
| 19:07.34 | Constitution | ~Cobra_Fast++ |
| 19:07.42 | kongr45gpen | ?? |
| 19:08.03 | alezakos | ?? |
| 19:08.06 | Constitution | ibot tell alezakos about karma |
| 19:08.22 | alezakos | <ibot> constitution wants you to know: it has been said that karma is 3 |
| 19:08.33 | JeffM_ | always comes back to bite you |
| 19:08.34 | Constitution | well that is not very helpful is it |
| 19:08.52 | *** join/#bzflag JeffM (~JeffM@unaffiliated/jeffm2501) |
| 19:08.52 | *** mode/#bzflag [+v JeffM] by ChanServ |
| 19:09.07 | alezakos | <ibot> Karma is a community rating system. Use "X++" to increase the karma, or "X--" to decrease it. Ask for ratings using "karma for X?". Karma updates must be in a channel, not private. |
| 19:09.50 | alezakos | x++ |
| 19:10.02 | alezakos | is a noob |
| 19:10.09 | JeffM | x is a name |
| 19:10.15 | Constitution | ~alezakos-- |
| 19:10.21 | Constitution | ;) |
| 19:10.31 | Constitution | ~karma alezakos |
| 19:10.31 | ibot | alezakos has karma of -1 |
| 19:10.35 | JeffM | ibot karma Constitution |
| 19:10.35 | ibot | constitution has karma of 82 |
| 19:10.39 | JeffM | not bad |
| 19:10.50 | Constitution | ibot karma JeffM2501 |
| 19:10.50 | ibot | jeffm2501 has karma of 385 |
| 19:10.57 | alezakos | ibot karma mrapple |
| 19:10.57 | ibot | mrapple has karma of 2 |
| 19:11.08 | JeffM | days of yore that no longer count |
| 19:11.27 | Constitution | good days they were |
| 19:11.34 | JeffM | some yes |
| 19:15.50 | alezakos | ~Constitution-- |
| 19:16.09 | JeffM | ~Constitution++ |
| 19:17.55 | alezakos | Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in G:\xampp\xampp\htdocs\phpBB3\bzfls.php on line 734 <br> ERROR: Missing or invalid server authentication key on bzfls.php |
| 19:18.40 | JeffM | bad setup of phpbb |
| 19:18.43 | JeffM | on wndows even |
| 19:19.22 | alezakos | ok thanks |
| 19:19.41 | JeffM | why are you runing your own list server? |
| 19:20.05 | alezakos | erm... I don't know... maybe for fun |
| 19:20.13 | JeffM | there is no fun in that |
| 19:20.16 | JeffM | just work and pain |
| 19:20.41 | mrapple | I sucesfully ran one once. I can't remember why though... |
| 19:20.55 | alezakos | and map testing |
| 19:21.32 | JeffM | you don't need a list server for map testing |
| 19:21.36 | JeffM | you just need a game server |
| 19:22.05 | alezakos | I don't want to type passwords every time I rejoin |
| 19:22.16 | alezakos | I also usually "kill" the server process |
| 19:22.31 | alezakos | that's why I wouldn't prefer the official server |
| 19:22.32 | JeffM | nether of those things require your own list server |
| 19:23.15 | JeffM | make your server public but advertieze to nobody, then you get global auth but don't show on the list |
| 19:23.26 | mrapple | bzfs -advertise none |
| 19:23.28 | JeffM | or set perms for your bzid localy |
| 19:23.28 | alezakos | I know that trick |
| 19:23.38 | alezakos | and /identify pass? |
| 19:23.42 | JeffM | no |
| 19:23.56 | JeffM | you can give perms to your bzid not a local account |
| 19:24.10 | alezakos | after Ï years when bzflag 3.0 will be released local auth will be dead |
| 19:24.28 | JeffM | just local passwords, not local perms |
| 19:24.34 | JeffM | perms are always local to the server |
| 19:24.46 | alezakos | the usrdb? |
| 19:24.50 | JeffM | yes |
| 19:24.55 | JeffM | only passdb is leaving |
| 19:25.11 | JeffM | the userdb can reference your bzid |
| 19:25.16 | alezakos | why are you trying to persuade me not to use my own list server? |
| 19:25.19 | JeffM | and then add to a local only group that has perms |
| 19:25.33 | JeffM | because you will spend more time figting the list server then you will doing anything useful |
| 19:26.26 | alezakos | I will earn 0 experience? |
| 19:26.34 | JeffM | yeah pretty much |
| 19:26.53 | alezakos | well, I installed phpBB. This is something. |
| 19:26.54 | JeffM | the list server is very specific to our crappy authentication system |
| 19:27.08 | JeffM | even we don't want to do it, and are replacing it |
| 19:27.35 | alezakos | "crappy" authentication system? |
| 19:27.52 | JeffM | bzflag's auth system is not awesome |
| 19:28.00 | alezakos | and not crappy/ |
| 19:28.01 | alezakos | . |
| 19:28.06 | JeffM | yeah it is crappy |
| 19:28.17 | JeffM | it dosn't scale, goes down all the time, breaks when phpbb upgrades |
| 19:28.18 | alezakos | ok then. |
| 19:28.26 | JeffM | has security issues |
| 19:28.33 | JeffM | it was not well designed |
| 19:28.44 | alezakos | maybe you want bzflag to DIE? |
| 19:28.57 | JeffM | that's seperate from this conversation |
| 19:29.08 | JeffM | there is a new auth system based on ldap, it just hasn't been implemented yet |
| 19:29.10 | alezakos | I don't think so. |
| 19:29.19 | JeffM | 2 years and 10,000$ were spent on it |
| 19:29.21 | Constitution | maybe it will die without us helping it along |
| 19:29.27 | JeffM | probably |
| 19:29.30 | alezakos | well, that's good news. |
| 19:29.34 | JeffM | but the ldap system should be implemented |
| 19:29.50 | JeffM | I've been implementing ldap auth at work with great sucsess |
| 19:30.29 | JeffM | mostly for web services, but the idea scales fine to the app |
| 19:30.33 | *** join/#bzflag tofu (~sean@BZ.BZFLAG.BZ) |
| 19:31.22 | alezakos | <infobot> please don't karma yourself |
| 19:36.17 | *** join/#bzflag kierra1 (~jolie@c-98-230-46-23.hsd1.fl.comcast.net) |
| 19:36.39 | *** join/#bzflag Upsetter (~Ups@88.130.167.191) |
| 19:37.40 | *** join/#bzflag I_Died_Once (~I_Died_On@unaffiliated/idiedonce/x-1828535) |
| 19:47.39 | *** join/#bzflag JeffM (~Jeff@unaffiliated/jeffm2501) |
| 19:47.39 | *** mode/#bzflag [+v JeffM] by ChanServ |
| 20:00.08 | *** join/#bzflag Anxuiz (~Anxuiz@unaffiliated/anxuiz) |
| 20:16.17 | *** join/#bzflag kierra (~jolie@unaffiliated/kierra) |
| 20:23.26 | *** join/#bzflag Murielle (~Murielle@unaffiliated/murielle) |
| 20:36.20 | *** join/#bzflag sirquine (~quine@c-71-199-123-80.hsd1.pa.comcast.net) |
| 20:43.33 | *** join/#bzflag xaver (~xaver@pD9ED4A7A.dip.t-dialin.net) |
| 20:46.12 | *** join/#bzflag xaver (~xaver@pD9ED4A7A.dip.t-dialin.net) |
| 20:50.43 | *** join/#bzflag blast007 (~blast007@bzflag/developer/Blast) |
| 20:50.43 | *** mode/#bzflag [+v blast007] by ChanServ |
| 20:56.12 | *** join/#bzflag me1 (~ausom@bzflag/player/Me1) |
| 20:57.46 | *** join/#bzflag Oejet (~oejet@212.45.122.120) |
| 21:14.21 | *** join/#bzflag sirquine (~quine@c-71-199-123-80.hsd1.pa.comcast.net) |
| 21:20.29 | *** join/#bzflag cods (~cods@rsbac/developer/cods) |
| 21:22.57 | *** join/#bzflag R0b0t1 (~Enigma@64-136-219-55.dyn.everestkc.net) |
| 21:22.57 | *** join/#bzflag R0b0t1 (~Enigma@unaffiliated/r0b0t1) |
| 21:58.40 | *** join/#bzflag jh` (~jh_@212-149-233-75.bb.dnainternet.fi) |
| 22:28.48 | *** join/#bzflag noyb (~noyb@96.247.88.164) |
| 22:36.13 | *** join/#bzflag JefferyM (~JefferyM@67-131-219-56.dia.static.qwest.net) |
| 22:36.13 | *** join/#bzflag JefferyM (~JefferyM@unaffiliated/jeffm2501) |
| 22:36.13 | *** mode/#bzflag [+v JefferyM] by ChanServ |
| 23:06.01 | *** part/#bzflag Upsetter (~Ups@88.130.167.191) |
| 23:07.10 | JefferyM | anyone ever store binary files in a database? |
| 23:09.40 | *** join/#bzflag Think_Differentl (~js@pool-71-191-100-76.washdc.east.verizon.net) |
| 23:09.40 | *** join/#bzflag Think_Differentl (~js@bzflag/player/ThinkDifferent) |
| 23:12.25 | *** join/#bzflag McSpider (~McSpider@xplr-ts-v10-208-114-191-42.barrettxplore.com) |
| 23:15.50 | mrapple | JefferyM: mysql has a "blob" feature iirc |
| 23:15.54 | mrapple | looked at it, but never used it |
| 23:16.24 | JefferyM | I know I have questions about encoding the file data so it dosn't get jacked up |
| 23:16.43 | mrapple | ah |
| 23:16.58 | mrapple | heres what i do for my file storage system s.bzextreme.com |
| 23:17.11 | mrapple | all the files are stored in a files dir with a random num as a name, no extension |
| 23:17.15 | AAA_awright | JefferyM: Yeah you want blob, pretty much a TEXT but without a particular encoding, a character array |
| 23:17.29 | JefferyM | mrapple, I can't use a file dir |
| 23:17.34 | mrapple | oh |
| 23:17.52 | mrapple | well if you need to detect the type of file you can use mime_content_type |
| 23:17.53 | JefferyM | AAA_awright, yeah I have the blob, but the files are binary, I'm calling mysql_real_escape_string before I save them |
| 23:17.54 | mrapple | in php |
| 23:18.05 | JefferyM | mrapple, you have no idea what I'm doing and are in the wrong place |
| 23:18.20 | mrapple | k |
| 23:18.27 | JefferyM | bin files that have a / in them are not getting the / back when I save them back to disk |
| 23:18.37 | AAA_awright | JefferyM: Convert them to a hex number, i think PHP's pack() will do that |
| 23:18.40 | mrapple | you know about stripslashes(); ? |
| 23:18.55 | JefferyM | mrapple, I did not call addslashes |
| 23:19.10 | JefferyM | I called mysql_real_escape_string |
| 23:19.12 | mrapple | but mysql_real_escape_string basically does addslashes |
| 23:19.17 | JefferyM | yes it does |
| 23:19.25 | JefferyM | and some other stuff |
| 23:19.43 | JefferyM | and I belive that sql does the remove slashes when the query happens |
| 23:20.01 | JefferyM | I can't find an oposite version of the function |
| 23:20.29 | JefferyM | and I'd rather not use any php methods since the other half of the system uses C++ |
| 23:20.29 | mrapple | right... |
| 23:20.38 | mrapple | good luck! |
| 23:21.02 | AAA_awright | If you are using C++ use a prepared statement (I think that works) |
| 23:21.14 | JefferyM | huh? |
| 23:22.00 | *** join/#bzflag McYukon (~alko@xplr-ts-v10-208-114-191-42.barrettxplore.com) |
| 23:23.21 | JefferyM | I'm not sure why I need to have the query stored on the mysql server, and why that would affect the results from a normal query |
| 23:23.38 | JefferyM | if a prepared statement was different then a normal query I woudl think that would not be a good thing |
| 23:24.17 | AAA_awright | It's not any different except in that some of the content hasn't been defined yet |
| 23:24.25 | AAA_awright | Ah, for PHP, use '0x'.bin2hex($contents) |
| 23:24.34 | JefferyM | ugg |
| 23:24.44 | blast007 | JefferyM: ensure that any of the 'magic quote' crap in PHP is turned off |
| 23:24.47 | JefferyM | I was hooping not to do that |
| 23:24.55 | JefferyM | hmm that could be it |
| 23:25.02 | AAA_awright | I guess I'm not following |
| 23:25.08 | JefferyM | my test case is pure php, store the file then get the file |
| 23:25.30 | JefferyM | AAA_awright, I should not have to encode it once I turn it into a valid escaped string. |
| 23:25.43 | JefferyM | heck I could URL encode it if I had to ;) |
| 23:25.49 | JefferyM | blast007, that in the php config? |
| 23:25.58 | blast007 | http://www.anyexample.com/programming/php/php_mysql_example__image_gallery_(blob_storage).xml |
| 23:26.01 | blast007 | yeah |
| 23:26.28 | AAA_awright | That replaces string escaping |
| 23:26.35 | blast007 | magic_quotes_gpc is for $_GET, $_POST, and $_COOKIES |
| 23:27.05 | JefferyM | I'll have to have IT check that, I don't have access to the php config |
| 23:27.07 | blast007 | basically turn off *any* of the magic_quotes_* stuff :) |
| 23:27.09 | JefferyM | is no sudo |
| 23:27.21 | blast007 | phpinfo() might show if it's on |
| 23:27.24 | JefferyM | that's a good thing to look into, thanks |
| 23:27.54 | blast007 | also, that example I provided might be helpful |
| 23:28.09 | AAA_awright | If it's on you can undo it as example #1 does here http://php.net/manual/en/function.get-magic-quotes-gpc.php |
| 23:28.49 | JefferyM | ok thanks |
| 23:29.04 | blast007 | (which the example I provided does and checks for) |
| 23:35.18 | JefferyM | yeah the magic is off |
| 23:37.00 | blast007 | k |
| 23:39.21 | blast007 | looks like that image gallery example is just doing the mysql_real_escape_string for the file data |
| 23:39.29 | JefferyM | yeah that's all I'm doing |
| 23:39.44 | JefferyM | tho I was doing fread not file_get_contents |
| 23:41.07 | blast007 | which I would think shouldn't matter |
| 23:41.13 | blast007 | file_get_contents is easier code |
| 23:41.31 | blast007 | and has the same effect in this case, since you're having to load the whole file anyways |
| 23:41.41 | JefferyM | yeah I changed over to that, same deal |
| 23:41.56 | blast007 | hrm |
| 23:42.14 | *** join/#bzflag Anxuiz (~Anxuiz@c-67-171-11-99.hsd1.wa.comcast.net) |
| 23:42.14 | *** join/#bzflag Anxuiz (~Anxuiz@unaffiliated/anxuiz) |
| 23:42.17 | blast007 | maybe images don't have /'s in them, but I would think they could |
| 23:42.37 | blast007 | I'll maybe poke at it later and see what I can find |
| 23:42.55 | JefferyM | thanks |
| 23:58.11 | JefferyM | hah, found the problem, my database class was calling stripslashes on it after sql returned it |
| 23:58.52 | JefferyM | double sanatize |
