irclog2html for #wowroster on 20070102

00:30.13*** join/#wowroster Guest (n=Guest@74-129-216-197.dhcp.insightbb.com)
00:30.29Guesthello
00:31.07Marticusfreenode interesting
00:31.36*** join/#wowroster Marticus (n=demart01@74-129-216-197.dhcp.insightbb.com)
00:31.43Marticusmuch better irssi ftw
00:32.27Marticusfyi the wowprofilers site has some cookie issue and new account registration is broken
00:34.49*** join/#wowroster Zeryl_ (n=Zeryl@75-132-127-218.dhcp.stls.mo.charter.com)
00:51.25*** join/#wowroster Zanix|work (n=Zanix@71-221-154-173.bois.qwest.net) [NETSPLIT VICTIM]
00:51.29*** mode/#wowroster [+o Zeryl] by ChanServ
01:36.34[PUPPETS]GonzoMarticus: FYI: Read the topic ;)
02:17.37*** join/#wowroster alandrias (n=alandria@cpe-69-205-191-62.stny.res.rr.com)
02:17.55alandriasHey all
02:31.17*** join/#wowroster Adric (i=CPGMembe@cpe-24-209-8-153.cinci.res.rr.com)
02:31.39Adricyou there?
03:35.54Anaxentadric?  stay around longer
03:36.07[PUPPETS]Gonzohe won't read :)
03:37.41[PUPPETS]Gonzodo you guys know a roster addon, where you can search for a specific item (e.g. "runecloth") and it will search in all chars / bags for theese items?
03:39.14AnaxentHUH ?
03:40.47[PUPPETS]Gonzofor example: I am looking for some herbs and want to know, which chars have them, so I can ask them
03:41.16[PUPPETS]Gonzoso I would like to enter "winterbite" in some search field and it should print me all chars and the number of items they have
04:03.27[PUPPETS]Gonzogn8 :)
04:23.18draculahmm, sorting the roster by a date column isn't completely right
04:24.39draculait puts "Dec 30th" on top, and "Jan 1st" on bottom... while in fact the "Jan 1st" is newer than "Dec 30th"
04:25.06draculadoesn't it sort by the actual unix timestamp ?
04:28.43draculaI tend to sort by "Last updated" column to see who has been updating lately... but now I have to check both top and bottom for the most recent uploads :s
06:03.12PleegWatIt's a date column in mysql and mysql is the one doing the sorting
06:03.20PleegWatit must be inserting the years incorrectly
11:24.22*** join/#wowroster Guest837 (n=Guest@ip70-187-182-200.oc.oc.cox.net)
11:31.44*** join/#wowroster stridar (i=CPGMembe@ip68-111-220-53.sd.sd.cox.net)
11:32.15stridaranyone around?
11:43.32*** join/#wowroster [Beercow] (n=happysl@1304ds1-ksa.0.fullrate.dk)
15:51.12Anaxentgood morning
15:51.24PleegWathi
15:52.04Anaxenthow you doinf PleegWat
15:52.06PleegWatI did some cleanup in the R2 framework.
15:52.17Anaxentcool
15:52.19PleegWatGot rid of a big bundle of unnecesary ternary conditions
15:52.26AnaxentI get all that now
15:52.30Anaxentlol
15:52.54Anaxentternary's have been a bit hard for me to fully understand
15:53.09Anaxentdid you change them into if/else
15:53.20PleegWatwhy use (is_object((isset(cpMain::$instance['classname']))?cpMain::$instance['classname']:NULL))
15:53.33PleegWatIf you're already got cpMain::isClass('classname')
15:55.15PleegWatAnd I got rid of some unnecesary files. The common header/footer since having them seperately doesn't add to having them in the index file. The autoload system, for the same reason.
15:55.42PleegWatAnd I've deleted class/cpsql/cpmysql since that layer was only there as a reminder to himself that he had to make that
16:06.04*** join/#wowroster [Beercow] (n=happysl@1304ds1-ksa.0.fullrate.dk)
16:14.34Anaxentdo you not like the autoload system or do not see a need for it?
16:22.51*** join/#wowroster [Beercow] (n=happysl@1304ds1-ksa.0.fullrate.dk)
16:43.42*** join/#wowroster Tsikura (i=nn@user-0cev16e.cable.mindspring.com)
16:44.41draculait's been a while ago since we've seen Mathos in here...
16:50.54PleegWatI don't see a need for it
17:47.48*** join/#wowroster [Beercow] (n=happysl@1304ds1-ksa.0.fullrate.dk)
17:59.46*** join/#wowroster ds001 (n=ds001@w192.z064003020.sea-wa.dsl.cnc.net)
19:01.19[PUPPETS]Gonzocould you guys please send me your characterprofiler.lua files, as I want to play around with some data for my public roster? Thanks
19:01.28[PUPPETS]Gonzomailto wowroster@deswahnsinns.de
19:11.04PleegWathi
19:17.05[PUPPETS]Gonzohi pleegwat
19:17.22PleegWathi gonzo
19:17.36[PUPPETS]Gonzocould you please send me your characterprofiler.lua file for testing my public roster? :)
19:17.52PleegWatsure
19:17.55PleegWatcan you recieve DCC?
19:18.22[PUPPETS]GonzoI fear, I can't (bouncer)
19:18.28[PUPPETS]Gonzowowroster@deswahnsinns.de would be nice
19:19.31PleegWaton it's way
19:19.42[PUPPETS]Gonzothanks a lot
19:20.03[PUPPETS]Gonzoafter fixing my basic problems, I'll have a look on multiple languages :-|
19:21.44[PUPPETS]Gonzoit's nice to see, how the roster grew - several coding styles, variable-naming styles, etc :)
19:22.32PleegWatlol yeah
19:23.48[PUPPETS]GonzoI found a few missing '' quotes around some variables in sql queries (they don't harm the normal roster but I changed the type of member_id to varchar) - shall I report them? if yes: where?
19:24.12PleegWatprobably no use, since R2 is a full recode anyway
19:24.18PleegWatWhy'd you change member_id to varchar?
19:25.09[PUPPETS]Gonzoas I said, I make a public roster. According to an idea by ulminia, I use the member_id field as md5sum of name + server
19:25.22PleegWatic
19:25.30[PUPPETS]Gonzothis way I have a unique identifiert for each char and don't have to change too much original code
19:25.39PleegWatI'd have stuck with auto_increment, that should work just the same
19:25.51PleegWatJust add a realm column
19:28.27[PUPPETS]GonzoI tried to avoid adding extra columns, as I thought it might break addons easier then changing the type of member_id
19:29.30PleegWatAdding an extra column won't hurt
19:29.40PleegWatSELECT * is only used when fetching data for char.php
19:29.57PleegWatAnd everything merges on member_id
19:31.33PleegWatMeh. Multiguild will be native on R2
19:31.44[PUPPETS]Gonzodamn. Next time when I spend 60 minutes on fixing the recipe upload, please remind me to check, if my lua file contains data for recipes...
19:31.52PleegWatEven accross the atlantic, probably
19:31.53PleegWatLOL
19:32.03Anaxentlol
19:32.07[PUPPETS]GonzoI am looking forward to seeing R2 - but until then, a public roster will be finde to have :)
19:32.32PleegWatleegwater-68.demon.nl/RosterSVN/roster2x/trunk/'
19:32.35[PUPPETS]Gonzofinde -> nice
19:33.00PleegWatappend plugin-config, plugin-db, or module-config for some tech demos
19:33.09PleegWatThere aren't any real modules yet, we're in the framework stage
19:33.37Anaxenti like that
19:33.42Anaxent"comming soon!"
19:33.52PleegWatWasn't it you that added it?
19:33.57PleegWatmust've been zanix
19:34.37[PUPPETS]Gonzo"When it is done!" :)
19:35.23PleegWatYeah, the blame says zanix did it
19:35.41Anaxentoh my Gf is getting mad at me
19:36.13Anaxentim telling her she has to build a new warrior on her own account
19:36.32Anaxentand not mine as im not able to play my toons when she is playing
19:36.44Anaxentno reason to get mad IMO
19:36.46Anaxentlol
19:37.08PleegWatYou can PCT a character between accounts if they're on the same CC
19:37.23Anaxentthe account needs the same last name
19:38.31AnaxentI had emailed blizzard about this the other day after I tried moving her toon to her account
19:41.55PleegWatic
19:44.47[PUPPETS]Gonzothen chance the last name
19:44.52[PUPPETS]Gonzotell blizzard, you married her
19:45.00[PUPPETS]Gonzo-> she changed her name
19:45.36AnaxentI just logged in to both our accounts and noticed we are not using the same CC...
19:45.46AnaxentI just maybe able to do this
19:47.28[PUPPETS]Gonzoanaxent, could you please send me your characterprofiler.lua file to wowroster@deswahnsinns.de ? I would like to test my public roster 1.72 :)
19:47.42Anaxentsure
19:48.43[PUPPETS]Gonzothanks a lot
19:50.20[PUPPETS]Gonzothe table is named pvp2, the file pvp3... :)
19:57.29PleegWatyes
19:57.31PleegWatlogical isn't it
19:59.18Anaxentjust sent it
20:05.51[Beercow]Evening all
20:06.59[PUPPETS]Gonzothanks, anaxent
20:15.47*** join/#wowroster MarcLiath (n=MarcLiat@xdsl-84-44-176-111.netcologne.de)
20:16.29MarcLiathhello
20:17.12*** join/#wowroster MarcLiath (n=MarcLiat@xdsl-84-44-176-111.netcologne.de)
20:17.16MarcLiathhello
20:17.34MarcLiathanyone on who can help me little bit
20:20.34PleegWatnot in under a minute
20:21.04[PUPPETS]Gonzogermans...
20:21.37PleegWatlol
20:21.55PleegWatTakes one to hate one I guess
20:22.45PleegWatSomehow it reminds me of a german woman who stood near us on a camping a few years back
20:22.59PleegWatThe first thing she said was "Guten Tag"
20:23.11PleegWatThe second "Es is glücklich das Sie kein Juden seit"
20:23.32PleegWatnot that that's in any way related
20:23.42PleegWatjust ignore the rambling guy
20:26.49[PUPPETS]Gonzostrange saying from that german woman...
20:27.08PleegWatyes
20:27.23PleegWatcourse, my spelling is probably off
20:27.56[PUPPETS]Gonzoone question, the "display keys" looks for the clientlocale and faction of the first guild member and uses that locale for the queries.... if I have different locales within my guild, not all keys will be displayed, right?
20:28.14PleegWatthe keys page is a mess
20:29.43[PUPPETS]Gonzowo my guess might be right?
20:29.51PleegWatit probably is
20:30.00[PUPPETS]Gonzook. Broken by design :)
20:30.10[PUPPETS]GonzoI'll concentrate on other issues then :)
20:30.10PleegWatRoster is known to work messy with cross-language guilds
20:30.27PleegWatYou get french/german rosters already where some players use the german client and some use the english languagepack
20:31.37[PUPPETS]Gonzoyes. As the german translations are shit...
20:31.45[PUPPETS]Gonzo(blizzards translations)
20:31.50PleegWatwas gonna say that
20:32.09PleegWathard to translate roster properly for stuff that depends on values we can only get localized from the client
20:32.36PleegWatLuckily CP 2.0 fetches more delocalized data than earlier versions did
20:33.02[PUPPETS]Gonzostrange enough: it somehow works:  http://wow3.deswahnsinns.de/indexinst.php
20:33.27PleegWatseems so
20:33.37PleegWatYou are aware that page does 1 query per key per character?
20:34.19PleegWatIf we add a page like that to R2 I want it rewritten with update triggers to determine key progress
20:35.29[PUPPETS]Gonzothis will be a good idea
20:35.55[PUPPETS]Gonzobut in the meantime I use your code (and your code does one query/key/char) :)
20:36.11PleegWatyeah
20:36.21PleegWatBut I bet you're slowly finding out why we're working on a rewrite
20:37.08Anaxentwhat you don't like all the diffrent coding styles?
20:37.16Anaxenthaha
20:37.34PleegWatWell, I'm going off
20:37.42PleegWatNeed to get out of bed early tomorrow so need to get in early tonight
20:37.44PleegWatnight
20:38.00Anaxentgood night
20:38.36[PUPPETS]GonzoI know why you work on the rewrite since many month ;)
20:38.42[PUPPETS]Gonzosleep well
22:28.36*** join/#wowroster Zeryl (n=Zeryl@75-132-127-218.dhcp.stls.mo.charter.com) [NETSPLIT VICTIM]
22:28.36*** mode/#wowroster [+o Zeryl] by irc.freenode.net
22:34.38*** join/#wowroster Zeryl (n=Zeryl@75-132-127-218.dhcp.stls.mo.charter.com) [NETSPLIT VICTIM]
22:34.38*** mode/#wowroster [+o Zeryl] by irc.freenode.net
22:44.22*** join/#wowroster Zeryl (n=Zeryl@75-132-127-218.dhcp.stls.mo.charter.com) [NETSPLIT VICTIM]
22:44.22*** mode/#wowroster [+o Zeryl] by irc.freenode.net
22:57.16*** join/#wowroster Zeryl (n=Zeryl@75-132-127-218.dhcp.stls.mo.charter.com) [NETSPLIT VICTIM]
22:57.16*** mode/#wowroster [+o Zeryl] by irc.freenode.net
22:59.39*** join/#wowroster Guest (n=Guest@ool-43551566.dyn.optonline.net)
23:12.48[PUPPETS]GonzoI don't get it... I can't find, where the default list (index.php display) is actually build and printed...
23:15.23[PUPPETS]GonzoI should complain faster, I just found it :)

Generated by irclog2html.pl by Jeff Waugh - find it at freshmeat.net! Modified by Tim Riker to work with blootbot logs, split per channel, etc.