IRC log for #wowroster on 20080304

02:47.16*** join/#wowroster poetter (n=poetter@e177161029.adsl.alicedsl.de)
05:38.32*** join/#wowroster Zanix (i=Zanix@69.92.238.219)
05:38.32*** mode/#wowroster [+o Zanix] by ChanServ
07:06.49*** join/#wowroster Tupsi (n=Miranda@217.7.101.202)
07:17.06*** join/#wowroster PleegWat|Work (n=ple@82-148-206-57.fiber.unet.nl)
07:17.06*** mode/#wowroster [+o PleegWat|Work] by ChanServ
09:34.04*** join/#wowroster griever (n=griever@ppp121-45-103-158.lns10.adl6.internode.on.net)
09:35.08Grieverevening folks
11:18.32*** join/#wowroster Nefuh (n=nefuh@dslb-084-062-253-192.pools.arcor-ip.net)
14:27.37*** join/#wowroster Nefuh|away (n=nefuh@dslb-084-060-241-192.pools.arcor-ip.net)
15:23.39*** join/#wowroster Gaxme (n=chatzill@71-36-135-88.mpls.qwest.net)
15:23.48Gaxmere
16:03.16*** join/#wowroster Zanix|Work (n=Zanix@71.216.154.51)
16:03.16*** mode/#wowroster [+o Zanix|Work] by ChanServ
16:13.00Gaxme$roster->db->escape($string) will clean it for SQL injection, correct?
16:15.18Zanix|Workyeah
16:15.31Zanix|Workjust make sure it doesnt have slashes in the string already
16:15.47Zanix|Workanything from GET or POST
16:15.55Zanix|Workwill be pre-slashed
16:17.07Gaxme*nod
16:17.10GaxmeIt's from the armory.
16:17.22GaxmeI've just about finished the code for pulling and caching armory items. Heh.
16:17.27GaxmePain in my arse!
16:17.45GaxmeI had to piggyback the item class and have it parse the tooltips.
16:17.53GaxmeWhich works, just took sorting out how to do it.
16:23.07GaxmeNow I just need to store it in the item cache, and that's set. Then get the display tables sorting, and it should be good.
16:25.30GaxmeWith any luck I'll have a beta ready to go by the end of the week.
16:25.48GaxmeI'll need a tutorial at that point about tagging the old version and committing versions. =)
16:26.07GaxmeJust to make sure I don't muck anything up.
16:27.25GaxmeBy the way, when the servers are offline, I'm still seeing realmstatus.php
16:27.27Gaxme<PROTECTED>
16:27.40GaxmeAnd I
16:27.45GaxmeI'm completely updated.
16:34.50Zanix|Workwow
16:34.56Zanix|Workyeah, offline isnt in the db
16:35.52Zanix|Workwait, yes it is
16:35.56Zanix|Workhttp://svnroster.homeip.net/roster/trunk/
16:36.00Zanix|Workim not getting that error
16:36.31Zanix|Workoh
16:36.39Zanix|Workmine is using rs_color_error
16:37.23Zanix|Workwhat region are you? US or EU
16:38.09GaxmeUS
16:38.18Zanix|Workah, there we go
16:38.26Zanix|Workset it to div container
16:40.14GaxmeIt doesn't make much difference really, it just shows in white, but I figured it can go on the super-duper-low-level fix list. =)
16:40.45GaxmeIs it just a matter of the locale string not being there?
16:40.57GaxmeOr that the US version didn't get translated to rs_color_error?
16:45.03Zanix|Workno, I think both have offline
16:45.19Zanix|Worknope
16:45.32Zanix|Workonly US, EU doesnt provide population status
16:45.40Zanix|Workjust full/recommended
16:45.51GaxmeStrange that isn't uniform...
16:45.55Zanix|Workill get offline in there
16:47.45GaxmeAs always, you rock.
16:47.51GaxmeGah, damn armory went down.
16:47.54GaxmeKilling my testing!
16:53.29Zanix|Workcrappy
16:54.16GaxmeHrm, do you know of any way to background a secondary php process from the script?
16:54.35GaxmeFor instance, I don't want to pull item data from the armory on raidtracker upload directly, because the script will time out.
16:54.46GaxmeBut could I background those calls?
16:55.50Zanix|WorkIm not sure
16:56.08Zanix|WorkI would pull from the armory on request of the display data
16:56.11Zanix|Workand cache it
16:56.21Zanix|Worksince it would take too much time on upload
16:56.48Zanix|Workoh, and since you have worked with the armory on items and tooltips, wanna do me a favor when you have time?
16:59.32Zanix|Workthe guild vault
16:59.36Zanix|Workthe item log
16:59.50Zanix|WorkI currently search the vault_items table for matching item_ids
17:00.03Zanix|Workbut for the unknown id's, I wanted to pull from the armory
17:01.57Zanix|Workrs_color_offline notice error fixed, svn[1717]
17:02.39GaxmeSure, I'm basically putting this in a class, so I can share that with you once I've got it done.
17:02.41GaxmeAnd it just extends the item class.
17:02.46GaxmeSince I'm using that to parse the tooltip.
17:02.54GaxmeAnd then caches it if it doesn't exist.
17:03.04GaxmeI'm writing the caching in now.
17:03.19GaxmeSo really you may have to shift a couple variables for how you're storing, or what it is, but it should work to pull it.
17:03.32GaxmeI'm pulling the tooltip and the full data both from the armory.
17:03.48GaxmeJust can't test anything until the armory comes back up. =)
17:04.36GaxmeDo you want what I have so far, or want to wait until I have it done?
17:05.59GaxmeI've ripped off the armorysync tooltip code, by the way.
17:06.27GaxmeSince he had all the functionality in there already to clear out the extraneous content tags.
17:06.57GaxmeThough, honestly, I haven't checked to see if that's necessary... *ponder*
17:07.00GaxmeI should check that raw.
17:07.06Zanix|Worklol
17:07.13Zanix|WorkI can wait till you are done
17:07.49GaxmeOk.
17:08.10GaxmeHrm, is the EU armory up?
17:08.51GaxmeYes it is. Hmmm
17:09.01GaxmeNow how do I force a different locale. =)
17:09.52GaxmeOh, easy. Just set the region.
17:09.59GaxmeSee, there I go talking to myself again.
17:10.34Gaxmeit's enEU?
17:11.16GaxmeNevermind, I'm a moron.
17:11.20GaxmeAgain.
17:14.33GaxmeHmm, definitely need the data striping for the tooltip.
17:15.53GaxmeAre you using the item_parent and item_slot for the vault? And the level? Oh, probably for which tab it's in, I guess.
17:15.59GaxmeI don't have that problem. =)
17:16.14GaxmeYou'll definitely need to change what it stores.
17:16.58Gaxmeitem_parent and item_slot are already going to be set for you, I guess. The only way to get "level" rather than "item_level" is to pull it out of the tooltip that I can see.
17:17.04GaxmeIt's not part of the armory return struct.
17:17.11GaxmeOnly item_level.
17:23.22Zanix|Workah
17:23.27Zanix|Worklevel is required level
17:26.54GaxmeRight.
17:27.14GaxmeI ignored it for this purpose, because I'm only worried about making sure the wowID and the tooltip are stored.
17:28.09GaxmeSo my database has an internal ID, wowID, item_name, item_color, item_texture, item_tooltip, html_tooltip, item_level, locale, and last_update
17:28.32GaxmeAnd the cache function checks the last_update versus the expiration config value as to whether it should load it again.
17:28.55GaxmeWell, I suppose either way, you can shuffle it around as you need to. =)
17:29.19GaxmeI think you're a little better with the php than I am. Don't landblast me too hard on my coding. *wink*
17:36.15Zanix|Workheh
18:03.31*** join/#wowroster fewyn (i=fewyn@rrcs-24-73-143-79.se.biz.rr.com)
18:15.40GaxmeHmm, can you call $update from outside the update hook?
18:16.33GaxmeIE: global $update and use $update->add_value() etc?
18:16.58ZerylI"m sad now, just got news that gary gygax has died :(
18:17.35GaxmeWhen??
18:17.45Zeryleither last night or this morning :(
18:19.36GaxmeSadness...
18:19.50GaxmeThe newest revision probably killed him...
18:19.55Zerylyou're telling me :(
18:20.02ZerylI was in a good mood until I heard that :(
18:38.15Zanix|WorkI had to look up the name
18:38.20Zanix|Workdo I fail in life?
18:39.28Zerylno
18:45.02GaxmeJust in geekdom. =)
18:51.05Zanix|Workah
19:00.29GaxmeOk, Zanix, I think this is working.
19:00.30GaxmeI'll stick it up in pastebin for you?
19:00.52GaxmeIt's not completely cleaned up, still has commented out debugging stuff, but I thought that might help a little if you needed to check the data.
19:01.18Zanix|Worksure, works for me
19:01.49Gaxmepastebin.wowroster.net?
19:03.21Zanix|Workno
19:03.27Zanix|Workhttp://www.wowroster.net/pastebin/
19:03.37Zanix|Workalthough, we probably should point it there
19:04.36GaxmeThere ya go
19:05.52Zanix|Worksweet, thanks
19:07.22GaxmeNot a problem. =)
19:07.27GaxmeOk, gonna go find some lunch.
19:07.52Gaxmeoh, do you need table structure?
19:08.19GaxmeIt's basically the same, I just have the default for the timestamp set to CURRENT_TIMESTAMP
19:09.08Zanix|Workk
19:12.15Zanix|Workyeah, the table structure would be nice
19:12.24Zanix|WorkI dont feel like figuring it out
19:13.00Zanix|Workwhy are you invoking the update class?
19:18.52Zanix|Workad, for the add_value
19:19.11Zanix|Workthere is a mysql function for that
19:19.16Zanix|Work$roster->db->build_query
19:19.36Zanix|Workit returns the same string as $update->assignstr
19:20.39Zanix|Workor are you using this during an update?
19:42.51Zanix|Workhere is a slightly cleaned up version Gaxme: http://www.wowroster.net/pastebin/index.php?show=277
20:02.39GaxmeHmm, ok, I'll use that.
20:03.21GaxmeThanks. =)
20:11.28Zerylhttp://www.wizards.com/default.asp?x=dnd/welcome
20:11.31Zerylit's official
20:13.04Zanix|WorkGaxme, you also inserted the level into the locale field as well
22:15.54GaxmeNow where is that pleegwat when I need to ask him questions about the memberslist!
22:26.23*** join/#wowroster PleegWat (n=PleegWat@212-123-189-114.ip.telfort.nl)
22:26.23*** mode/#wowroster [+o PleegWat] by ChanServ
22:27.59Zanix|WorkGaxme, I think we should finish up the armory parsing option in the itme class
22:30.08GaxmeWell, what was already in there is definitely emptied out.
22:30.15GaxmeCommented out, rather.
22:37.14GaxmeWould definitely make the process easier on future developers. =)
22:37.37GaxmeHonestly, if we're going to do that, though, I'd suggest unifying the item database.
22:37.56GaxmeTurning the equipment/member items list into a linking table, and storing/caching all the items in one table.
22:39.11PleegWatWe've been musing on that for ages
22:39.19PleegWatBut 2.0 is too far in to implement that
22:39.32PleegWatI want to rework the whole storage model on items for 2.1
22:39.39Gaxme*nod
22:39.49GaxmeWell, then, for now we can just fix the armory item reader, I guess.
22:39.59GaxmePleeg, I had a question for you.
22:40.10PleegWatya?
22:40.25GaxmeDoes that sortable memberslist have any way to list things that don't involve members?
22:40.34PleegWatsure
22:40.42GaxmeI must be doing something wrong.
22:40.46PleegWatCheck memberslist/realm/guild.php
22:41.22PleegWatfoldouts are hardcoded on member_id/main_id/alt_type though. I should probably clean that code up some time.
22:44.26GaxmeHrm, gonna see what I'm missing there.
22:44.38GaxmeWhat is the display => in the field options?
22:44.59Zanix|Workdisplay mode
22:45.09Zanix|Workshow, hide, force hide
22:45.17Zanix|WorkI dont know the vaules
22:45.21Zanix|Workand force show
22:47.01GaxmeAhh, ok.
22:47.09PleegWat0 for force invisible through 3 for force show
22:47.22GaxmeAnd do you need a FIELD for every segment pulled in the SELECT?
22:47.27PleegWatIn memberlist, almost all of them are mapped to config option.
22:47.33GaxmeHmm, obviously not.
22:47.34PleegWatYou need a FIELD for every column in the output table
22:47.39GaxmeRight.
22:49.13PleegWatThere's a list of the values in FIELD in memberslist/doc/install (iirc)
22:52.05GaxmeGotcha, thank you.
22:52.27GaxmeThat might be the problem... You need a display control function for each field?
22:52.43Gaxmenote_value, guild_value, etc?
22:52.45Zanix|Workno
22:52.50Zanix|Workthats just an option
22:53.00Zanix|Workyou can pipe the output through a function
22:53.13GaxmeOooh, ok.
22:53.15PleegWatnah, the 'value' callback is optional
22:54.29GaxmeDamn, ok. The callbacks are what was making it barf.
22:54.55Zanix|Workyeah, some of the callbacks point to members list
22:55.33Zanix|Workwhich if you are including it, they should work
22:55.34GaxmeHrm, well, partially. Getting a repeating list.
22:58.20PleegWatlink?
22:58.56PleegWator pastebin your calling file
23:04.08Zanix|Workim kinda surprised to see you awake PleegWat
23:04.20Zanix|Workat this time
23:04.24PleegWatonly just past midnight
23:04.44PleegWatam about to go to bed though
23:06.37Zanix|Workyeah, just used to see you saying good night around 11:30
23:06.39Zanix|Workor 11
23:06.50PleegWatwell, I do live closer to work nowadays
23:08.07Zanix|Workthats true
23:08.19Zanix|Workno 2 hour commutes
23:08.34PleegWataye
23:16.58Zanix|Workalright, im heading home
23:17.00Zanix|Worklater
23:34.45GaxmePut the page up on pastbin.
23:35.53Gaxmeaddons/memberslist/inc/memberslist.php
23:35.54Gaxme<PROTECTED>
23:35.56Gaxme<PROTECTED>
23:35.58Gaxme<PROTECTED>
23:35.59Gaxme<PROTECTED>
23:36.01Gaxme<PROTECTED>
23:36.02Gaxme<PROTECTED>
23:36.04GaxmeGah, sorry.
23:51.54Zanixguah?
23:52.05Zanixor gasp

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