irclog2html for #wowroster on 20070225

`01:02.02`	`*** join/#wowroster PleegWat_ (i=PleegWat@leegwater-68.demon.nl)`
`01:02.02`	`*** mode/#wowroster [+o PleegWat_] by ChanServ`
`04:02.11`	`*** join/#wowroster Tupsi3472 (n=Miranda@p54B23CF5.dip0.t-ipconnect.de)`
`04:28.28`	`lhunath`	`zanix: have a look and tell me how well / not so well the following application works: http://www.lyndir.com/stuff/jUniUploader.jar`
`04:30.04`	`lhunath`	`so far it won't do much other than sit there and look pretty. the settings tab should let you browse to your wow folder and then should list your wow accounts; the big buttons should all send you to some webpage except for the launch wow button which does nothing so far.`
`04:41.05`	`Zanix`	`ok, ill look`
`04:41.20`	`Zanix`	`I got a java error`
`04:41.31`	`Zanix`	`Could not find main class`
`04:41.36`	`Zanix`	`Program will exit`
`04:58.52`	`lhunath`	`woot.`
`05:01.31`	`lhunath`	`damned class-path weirdness -_-`
`05:16.03`	`Zanix`	`hehe`
`05:16.11`	`Zanix`	`let me know when you have another try ready`
`05:25.41`	`Zanix`	`ill be back later`
`05:33.41`	`lhunath`	`got something that'll work, but resolving a tiny issue with it still.`
`05:34.02`	`lhunath`	`http://www.lyndir.com/stuff/jUniUploader.jar`
`06:27.46`	`Zanix`	`back`
`06:28.10`	`Zanix`	`same error`
`06:28.17`	`Zanix`	`:(`
`06:31.20`	`lhunath`	`hrm; that new one should work`
`06:32.07`	`lhunath`	`any chance you can copy paste the output?`
`06:32.28`	`Zanix`	`its a dialog box that pops up`
`06:33.17`	`Zanix`	`ah`
`06:33.30`	`Zanix`	`its asking me to get java 5 rev 11`
`06:33.36`	`lhunath`	`;o`
`06:33.36`	`Zanix`	`ill install it and see`
`06:33.42`	`lhunath`	`oki`
`06:34.23`	`Zanix`	`same error`
`06:35.00`	`lhunath`	`any chance you can 'java -jar jUniUploader.jar' on a commandline and copypaste me the output?`
`06:35.09`	`lhunath`	`or screenshot it ;x`
`06:36.05`	`Zanix`	`Exception in thread "main" java.lang.UnsupportedClassVersionError: Bad version n`
`06:36.06`	`Zanix`	`umber in .class file`
`06:36.06`	`Zanix`	`<PROTECTED>`
`06:36.06`	`Zanix`	`<PROTECTED>`
`06:36.06`	`Zanix`	`<PROTECTED>`
`06:36.06`	`Zanix`	`<PROTECTED>`
`06:36.08`	`Zanix`	`<PROTECTED>`
`06:36.10`	`Zanix`	`<PROTECTED>`
`06:36.12`	`Zanix`	`<PROTECTED>`
`06:36.14`	`Zanix`	`<PROTECTED>`
`06:36.16`	`Zanix`	`<PROTECTED>`
`06:36.18`	`Zanix`	`<PROTECTED>`
`06:36.20`	`Zanix`	`<PROTECTED>`
`06:36.22`	`Zanix`	`<PROTECTED>`
`06:36.23`	`lhunath`	`not the same error ^^`
`06:36.35`	`Zanix`	`nope`
`06:36.42`	`Zanix`	`command line spits this out`
`06:36.45`	`lhunath`	`sure you updated completely?`
`06:36.51`	`Zanix`	`I think so`
`06:37.02`	`Zanix`	`ill try the update check in java again`
`06:37.16`	`Zanix`	`says I have the latest`
`06:37.23`	`lhunath`	`hmm; perhaps you have both 4 and 5 installed and its using java4`
`06:37.35`	`Zanix`	`I know I dont have 4`
`06:37.53`	`Zanix`	`earliets I have is 5.0 rev 6`
`06:38.11`	`lhunath`	`I see`
`06:39.28`	`Zanix`	`the older jUU works`
`06:40.28`	`lhunath`	`it's my compiler that's newer than your vm`
`06:40.29`	`Zanix`	`I can try to restart my computer`
`06:41.04`	`Zanix`	`Version 1.5.0 (build 1.5.0_11-b03)`
`06:42.53`	`Zanix`	`im going to restart`
`06:42.56`	`Zanix`	`ill brb`
`06:45.43`	`*** join/#wowroster Zanix (n=Zanix@71-221-147-10.bois.qwest.net)`
`06:45.43`	`*** mode/#wowroster [+o Zanix] by ChanServ`
`06:45.53`	`Zanix`	`im back`
`06:46.20`	`lhunath`	`ok, I think I got it to compile for java5 now. I'm using java 6 ;x`
`06:46.36`	`lhunath`	`but only java 5 features, heh.`
`06:46.47`	`lhunath`	`http://www.lyndir.com/stuff/jUniUploader.jar try downloading it again now`
`06:50.42`	`Zanix`	`there we go`
`06:50.49`	`Zanix`	`pretty`
`06:51.04`	`lhunath`	`ah, excellent.`
`06:51.51`	`Zanix`	`are you going to have the same upload rules that the current jUU allows?`
`06:52.27`	`lhunath`	`I'm not yet sure. I saw it allows for alot of dynamic combining of all sorts of rules.`
`06:52.42`	`Zanix`	`yeah, that what alot of people liked about it`
`06:53.10`	`Zanix`	`that it was more flexible in uploading to multiple sites then the standard UniUploader is`
`06:53.12`	`lhunath`	`what did they use it for? As I see it you can only have x accounts, so x upload rules`
`06:53.27`	`Zanix`	`well, I like to upload to 4 sites`
`06:53.35`	`Zanix`	`soemtimes up to 6`
`06:53.52`	`Zanix`	`my test site, my older versions of roster`
`06:53.54`	`lhunath`	`hmm several rosters? You mean if you have different characters in different guilds?`
`06:53.55`	`Zanix`	`my guild site`
`06:53.56`	`Zanix`	`rpgo`
`06:54.21`	`Zanix`	`yes, several rosters that required several different passwords`
`06:54.28`	`lhunath`	`hmm, that does indeed justify it`
`06:54.52`	`lhunath`	`I will provide a simular to the same functionality`
`06:54.57`	`lhunath`	`similar`
`06:54.57`	`Zanix`	`you could always throw an advanced mode in`
`06:55.03`	`lhunath`	`indeed.`
`06:55.13`	`Zanix`	`show what you have now, that just creates one rule`
`06:55.20`	`Zanix`	`for the noobs`
`06:55.26`	`Zanix`	`:)`
`06:55.32`	`lhunath`	`as I see it, uniadmin can define field names, which are basically variables it sends along with all the other sync info?`
`06:55.45`	`Zanix`	`I do have to say that this is very nice looking, you are quite handy at interfaces`
`06:56.02`	`Zanix`	`if you need access to UniAdmin, I have a test site`
`06:56.09`	`lhunath`	`heh, I try to please the eye as well as the spirit :P`
`06:56.23`	`Zanix`	`http://cvsroster.homeip.net/uniadmin/trunk/`
`06:56.27`	`lhunath`	`I suppose I can use my own uniadmin`
`06:56.30`	`Zanix`	`you can`
`06:56.40`	`Zanix`	`this is a newer version than what is released`
`06:56.43`	`Zanix`	`0.7.6`
`06:56.48`	`Zanix`	`I made some fixes`
`06:56.55`	`lhunath`	`I see; what are the most important differences?`
`06:57.05`	`Zanix`	`good question`
`06:57.08`	`Zanix`	`let me look`
`06:57.10`	`Zanix`	`lol`
`06:57.25`	`Zanix`	`All remote addons (wowace) will now be stored locally`
`06:57.39`	`lhunath`	`The main reason I made it look appealing is because people are not eager to use a loader to start their wow.`
`06:57.48`	`Zanix`	`Addon xml file list is only outputted if there are addons in the UA db`
`06:57.59`	`lhunath`	`If it looks nice, and friendly they will be easier persuaded to use the tool`
`06:58.01`	`Zanix`	`very true`
`06:58.17`	`Zanix`	`http://cvsroster.homeip.net/uniadmin/trunk/interface.php?OPERATION=GETADDONLIST`
`06:58.47`	`Zanix`	`this is the addon xml that is outputted for UniUploader`
`06:58.47`	`Zanix`	`there are other things UniAdmin outputs as well`
`06:59.07`	`Zanix`	`oh, the user pass on my UniAdmin test is`
`06:59.09`	`Zanix`	`admin : c`
`06:59.35`	`lhunath`	`right :)`
`06:59.55`	`Zanix`	`dang`
`06:59.56`	`lhunath`	`interesting output, that will be convenient.`
`06:59.59`	`Zanix`	`my server crashed`
`07:00.02`	`lhunath`	`heh.`
`07:00.27`	`Zanix`	`doesnt take much`
`07:00.30`	`Zanix`	`lol`
`07:00.34`	`lhunath`	`Apache?`
`07:00.39`	`lhunath`	`or the whole pc?`
`07:00.48`	`Zanix`	`whole pc`
`07:00.55`	`lhunath`	`:o`
`07:00.57`	`Zanix`	`winxp sp2, running apache2 php 5.2`
`07:01.03`	`Zanix`	`mysql 5.whatever`
`07:01.32`	`lhunath`	`mine's gentoo linux`
`07:01.48`	`Zanix`	`i want to switch that box to linux, but im lazy`
`07:02.08`	`Zanix`	`i can get windows running faster than I can linux`
`07:02.14`	`lhunath`	`I want to switch my home box to bsd, but I'm lazy too.`
`07:02.31`	`Zanix`	`k, its back up`
`07:02.40`	`lhunath`	`zanix++`
`07:02.46`	`Zanix`	`no wait, its windows 2000`
`07:02.47`	`Zanix`	`lol`
`07:02.49`	`Zanix`	`i forgot`
`07:03.02`	`Zanix`	`what's up lhunath`
`07:03.03`	`lhunath`	`do you have some kind of api or something for what kind of requests I can throw at interface.php?`
`07:03.45`	`lhunath`	`s/api/docs/`
`07:04.06`	`Zanix`	`not atm`
`07:04.12`	`lhunath`	`s/./poke apt*/`
`07:04.19`	`Zanix`	`I can try to make something up really quick`
`07:04.24`	`Zanix`	`its not that big of a list`
`07:04.30`	`lhunath`	`I can look at the php source`
`07:04.38`	`Zanix`	`yeah, that works too`
`07:04.43`	`Zanix`	`I shoul dpost this on the net though`
`07:05.09`	`lhunath`	`yeah, some docs are always good for reference`
`07:05.19`	`Zanix`	`interface.php?OPERATION=`
`07:05.47`	`Zanix`	`GETADDON, GETADDONLIST, GETSETTINGS, GETUAVER, GETFILEMD5`
`07:06.12`	`Zanix`	`ADDON= is used with OPERATION=GETADDON`
`07:06.38`	`Zanix`	`FILENAME= is used with OPERATION=GETFILEMD5`
`07:06.48`	`Zanix`	`and that is to check the md5 of the logos`
`07:06.54`	`Zanix`	`there are two logos in UniUploader`
`07:07.33`	`Zanix`	`I can provide sample output from UniUploader`
`07:07.56`	`lhunath`	`GETADDON fetches the zip for a given addon name; GETADDONLIST fetches a list of addons and md5 sums for each of its files; GETSETTINGS gets a list of field values; GETFILEMD5 gets the md5 of the given file owned by an addon`
`07:08.00`	`lhunath`	`something like that?`
`07:08.15`	`lhunath`	`oh logos.`
`07:08.45`	`lhunath`	`:o`
`07:09.19`	`lhunath`	`hardly beta`
`07:09.20`	`lhunath`	`heh`
`07:09.36`	`ds001`	`w/e you wanna call it... its purdy.`
`07:09.54`	`lhunath`	`thanks. Hope I can keep the effort up and make it work purdily too.`
`07:10.12`	`ds001`	`what? function too?! your a madman..`
`07:10.25`	`Zanix`	`http://www.wowroster.net/pastebin/index.php?show=74`
`07:10.35`	`Zanix`	`thats the sample output from UniUploader`
`07:10.58`	`Zanix`	`GETFILEMD5 is for logos in UU only`
`07:11.14`	`Zanix`	`it doesn't get info for addons`
`07:11.23`	`ds001`	`so, i've been messing with LUA and CP for a few hours now.. and I still hate LUA`
`07:11.29`	`Zanix`	`lol`
`07:11.43`	`ds001`	`but I did manage to get enchantment colors back in the tooltip sting`
`07:11.55`	`ds001`	`sockets are still kicking my ass`
`07:11.57`	`Zanix`	`sweet, you should send that to calvin`
`07:12.56`	`ds001`	`yeah.. i will when im not embarassed of the hack job I did to get that far.. :D`
`07:13.07`	`Zanix`	`hehe`
`07:13.29`	`lhunath`	`getaddon operation requires a ulogin?`
`07:13.34`	`lhunath`	`and no password, right?`
`07:13.41`	`Zanix`	`it doesnt`
`07:13.55`	`Zanix`	`in the future, it may be used to get a custom list`
`07:14.14`	`Zanix`	`but for now, UniUploader just sends all the GET variables`
`07:14.21`	`Zanix`	`or post, not sure what kind they are`
`07:14.25`	`Zanix`	`either GET or POST`
`07:14.37`	`lhunath`	`yeah, I saw you parse REQUEST`
`07:14.47`	`lhunath`	`s/REQ/_REQ/`
`07:15.04`	`Zanix`	`RetrData: val1: GETSETTINGS`
`07:15.05`	`Zanix`	`RetrData: param2: ulogin`
`07:15.05`	`Zanix`	`RetrData: val2: Treyce`
`07:15.05`	`Zanix`	`RetrData: param3: password`
`07:15.05`	`Zanix`	`RetrData: val3: somepassword`
`07:15.17`	`lhunath`	`so ..`
`07:15.31`	`lhunath`	`what's the point in sending the synctourl with getsettings?`
`07:15.32`	`Zanix`	`ignore val1`
`07:15.45`	`lhunath`	`isn't that always the same url you used to perform the getsettings op on?`
`07:16.00`	`Zanix`	`it is`
`07:16.16`	`Zanix`	`i dont know how or why UU does what it does, but it does what it does, lol`
`07:16.31`	`lhunath`	`heh`
`07:16.38`	`Zanix`	`oh because UniAdmin can set the suncro url`
`07:16.51`	`Zanix`	`s/suncro/syncro/`
`07:17.02`	`lhunath`	`in case it wants to migrate to a different server? ;x`
`07:17.11`	`Zanix`	`right`
`07:17.23`	`Zanix`	`you can leave an old copy of UniAdmin running and have it set a new url`
`07:17.51`	`Zanix`	`jUU did ignore some of these variables`
`07:17.54`	`lhunath`	`say, does anyone know to what degree you can communicate through savedvariables while wow is running?`
`07:18.12`	`Zanix`	`well, you can modify it, but wow wont see it untill you log`
`07:18.16`	`lhunath`	`I saw you can force wow to flush its settings, but can you force it to read them in too?`
`07:18.30`	`Zanix`	`as far as I know`
`07:19.36`	`lhunath`	`I suppose it should theoretically be possible to make a feature that syncs website raid calendar stuff with the ingame guild calendar ;p`
`07:20.19`	`ds001`	`it will save/reread files if you /reload (or /console reload) but WoW will not read any new files`
`07:20.41`	`lhunath`	`right.`
`07:21.03`	`lhunath`	`does the save button on characterprofiler actually flush data into the characterprofiler's savedvariables files?`
`07:21.16`	`lhunath`	`because that button does not /reload`
`07:21.34`	`ds001`	`no.. that just uses the cached files in wow with out querying WoW.`
`07:22.14`	`ds001`	`still wont be saved to the .lua until you /reload or exit wow.`
`07:22.32`	`Zanix`	`you can save anything unless you /reloadui`
`07:22.35`	`Zanix`	`or log`
`07:23.00`	`lhunath`	`s/can/can't/ ?`
`07:24.02`	`*** join/#wowroster [Beercow] (n=happysl@1304ds1-ksa.0.fullrate.dk)`
`07:24.10`	`ds001`	`WoW only writes its saved variables on /reloadui or /quit /logout`
`07:26.44`	`lhunath`	`yeah, anyway.`
`07:26.49`	`lhunath`	`back to jUU for me`
`07:27.01`	`Zanix`	`lol`
`08:54.34`	`Zanix`	`hows jUU so far?`
`08:54.36`	`Zanix`	`lol`
`09:08.05`	`*** join/#wowroster Vecna (i=Vecnah@vecna.vecnix.net)`
`09:33.14`	`lhunath`	`gradients++`
`09:33.34`	`lhunath`	`just couldn't get the colors right until I thought of gradients`
`09:34.15`	`lhunath`	`need some refractoring.`
`09:34.51`	`lhunath`	`the big problem is how do I start a browser ..`
`09:35.16`	`lhunath`	`esp in a portable way`
`09:41.55`	`Zanix`	`not sure`
`09:42.01`	`Zanix`	`I wish you lick though`
`09:42.05`	`Zanix`	`i mean luck`
`09:42.08`	`Zanix`	`man am i tired`
`09:42.15`	`Zanix`	`im going to bed`
`09:42.21`	`Zanix`	`good night`
`11:14.44`	`*** join/#wowroster DiscoWay\|Sleep_ (n=chatzill@c-71-193-217-112.hsd1.or.comcast.net)`
`11:18.15`	`*** join/#wowroster DiscoWay\|Sleep__ (n=chatzill@c-71-193-217-112.hsd1.or.comcast.net)`
`11:45.25`	`*** join/#wowroster Tupsi (n=Miranda@p54B23CF5.dip0.t-ipconnect.de)`
`13:10.17`	`*** join/#wowroster [PCXNETGAMES]-Be (n=beau@cpe-66-27-88-157.san.res.rr.com)`
`13:10.34`	`[PCXNETGAMES]-Be`	`anyone here that can help me?`
`14:00.55`	`Mathos\|zZz`	`Depends`
`14:01.04`	`Mathos\|zZz`	`ah hes gone lol`
`18:43.47`	`*** join/#wowroster Anaxent (n=chatzill@209-250-16-194.convergentaz.net)`
`19:40.33`	`*** join/#wowroster DiscoWay (n=chatzill@c-71-193-217-112.hsd1.or.comcast.net)`
`19:40.43`	`DiscoWay`	`Morning`
`19:41.42`	`Zanix`	`hi`
`19:59.03`	`DiscoWay`	`Im still workin on the function sortOutTooltip Zanix, but i found a bug with ds001's gem mod that is preventing me from continuing. So waiting for him to get on so i can show him.`
`20:00.55`	`Zanix`	`fun stuff`
`20:02.34`	`Zanix`	`i do like this gem mod alot`
`20:02.43`	`DiscoWay`	`Im actually enjoying this, when my wrists are hurting =\, but yea I managed to learn alot from how this code works`
`20:02.57`	`Zanix`	`right on`
`20:03.02`	`DiscoWay`	`Oh, you may check to see if this happens to you, goto this post`
`20:03.13`	`DiscoWay`	`or url i should say`
`20:03.16`	`DiscoWay`	`http://www.nomad-legacy.net/WoWRosterDF/char/cname=Korjyrin/server=Feathermoon.html`
`20:03.17`	`Zanix`	`lol`
`20:03.22`	`DiscoWay`	`look at the shoulders`
`20:04.20`	`Zanix`	`what's wrong?`
`20:04.21`	`DiscoWay`	`notice the sockets, now look at both gem ids, now just below it, notice is say 2967 found twice, doenst even mention 2761 in the found.`
`20:04.28`	`Zanix`	`oh`
`20:04.30`	`DiscoWay`	`They second socket should be what is listed in the bonus area`
`20:04.41`	`DiscoWay`	`+4 Spell Critical Rating and +5 Spell Damage`
`20:05.12`	`Zanix`	`im going to go eat lunch`
`20:05.21`	`Zanix`	`ill be back later`
`20:05.29`	`DiscoWay`	`Aah, ok, have a good lunch`
`20:05.42`	`PleegWat`	`I'm thinking about building something in R2 that parses item tooltips on upload`
`20:05.57`	`PleegWat`	`then store all properties separatelyu`
`20:06.58`	`DiscoWay`	`well it does store the item properly in the database as like 27738:2967:2761 etc etc, its just i think there is some bad code someplace when it goes to retrieve it`
`20:07.49`	`PleegWat`	`Haven't really looked at those two mods closely yet`
`20:08.31`	`PleegWat`	`http://leegwater-68.demon.nl/roster/addon.php?roster_addon_name=SortMember`
`20:09.03`	`DiscoWay`	`they are actually pretty good, problem is that blizzard is so inconsistant on naming enchants and gems and other equip pluses, that they all end up under either Increases or Improves, or gems have that annoying "&" or "and" seperation`
`20:09.21`	`PleegWat`	`yeah`
`20:09.29`	`DiscoWay`	`so many else if statments`
`20:09.42`	`DiscoWay`	`but im gaining head way on it =)`
`20:10.20`	`DiscoWay`	`I have gotten alot of the enchants to be listed in proper places so far, and im still working on the gems`
`20:10.21`	`PleegWat`	`With detecting the various magical attributes, I'll probably start out at the top of the tooltip and stop figuring stuff out where the gems and the green lines start, cause there's such a shitload of possibilities there`
`20:10.54`	`DiscoWay`	`yea`
`20:11.12`	`PleegWat`	`That'd keep parse times on upload acceptable, and still give the advantage of not needing special code to filter on EG shoulder plate stuff`
`20:15.28`	`DiscoWay`	`But even if you do it that way, wouldnt you still have to do a ton of else if statments when you could just do it under the function sortOutTooltip? or are you thinking in terms of speed when you go to click on a character?`
`20:15.50`	`DiscoWay`	`for the roster performance i mean`
`20:16.04`	`PleegWat`	`Well, what I'm thinking to do on R2 is splitting stuff up on upload`
`20:16.42`	`DiscoWay`	`You would stil lhave to find all those possibilities though using ereg right?`
`20:17.25`	`DiscoWay`	`Sorry if i sound weird asking strange questions, still learning in the process =p`
`20:17.30`	`PleegWat`	`Well, if you're parsing the whole thing you've got the advantage of knowing what order you'll get stuff`
`20:18.03`	`PleegWat`	`Once you find the strength line, you know you're not getting any slot/quality/we lines`
`20:18.24`	`PleegWat`	`if you find the agi line and you don't have a strength line yet, you know there's not gonna be a strength line`
`20:22.27`	`DiscoWay`	`This line was fun, +24 Ranged Attack Power/+10 Stamina/+10 Hit Rating , I was able to get the Hit Rating to detect and add it to the right bonus area, now just gotta make one for ranged attack power`
`20:58.31`	`Zanix`	`im back`
`21:04.04`	`PleegWat`	`I've got inequalities working`
`21:04.25`	`PleegWat`	`http://leegwater-68.demon.nl/Roster/addon.php?roster_addon_name=SortMember put >60 in the level filter box`
`21:05.28`	`PleegWat`	`Will work on dates, but only if you enter a UTC timestamp value next to the symbol`
`21:05.49`	`Zanix`	`very nice`
`21:05.50`	`PleegWat`	`<, >, <=, =<, >=, =>, == are currently supported`
`21:06.37`	`PleegWat`	`So you can search EG on shamans over level 60`
`21:06.55`	`Zanix`	`ooo`
`21:07.12`	`PleegWat`	`Or any character under 40 in orgrimmar`
`21:07.32`	`Zanix`	`hmm`
`21:07.41`	`Zanix`	`you should see if you can do this case insensative`
`21:07.46`	`PleegWat`	`it is`
`21:07.53`	`Zanix`	`not it isnt`
`21:07.54`	`PleegWat`	`Filtering zone doesn't seem to work. Weird.`
`21:07.59`	`Zanix`	`I tried hunter`
`21:08.02`	`Zanix`	`then Hunter`
`21:08.11`	`Zanix`	`lower case h doesnt work`
`21:08.26`	`PleegWat`	`damn wait`
`21:08.30`	`PleegWat`	`sorting is insensitive`
`21:08.32`	`PleegWat`	`filtering isn't`
`21:08.33`	`PleegWat`	`damn`
`21:10.37`	`PleegWat`	`works now`
`21:13.05`	`Zanix`	`yay`
`21:13.28`	`PleegWat`	`ok damn`
`21:13.31`	`PleegWat`	`found a bug`
`21:15.53`	`PleegWat`	`fixed`
`21:21.45`	`Zanix`	`im trying to make the sql better in the stats module in U`
`21:21.46`	`Zanix`	`UniAdmin`
`21:25.15`	`Zanix`	`http://cvsroster.homeip.net/uniadmin/trunk/index.php?p=stats`
`21:27.19`	`Zanix`	`test : c`
`21:27.31`	`PleegWat`	`There was a working user/pass in my cache`
`21:27.49`	`Zanix`	`ah, cool`
`21:27.50`	`PleegWat`	`your pie charts can definitely use work`
`21:28.37`	`Zanix`	`well, they were matt's`
`21:28.44`	`Zanix`	`and yes, they can`
`21:28.58`	`Zanix`	`I thought about using css instaed of GD`
`21:29.11`	`PleegWat`	`I doubt CSS can do that`
`21:29.20`	`Zanix`	`it can`
`21:29.24`	`Zanix`	`I found something`
`21:29.30`	`PleegWat`	`Is that code using mysql_num_rows a lot?`
`21:29.35`	`*** join/#wowroster Guest353 (i=CPGGuest@CPE-72-135-118-93.new.res.rr.com)`
`21:29.40`	`PleegWat`	`Can you rewrite it to use queries with aggregate functions?`
`21:29.50`	`Zanix`	`I cant`
`21:30.08`	`Zanix`	`remember my sql knowledge is minimal`
`21:30.11`	`PleegWat`	`Is this query list complete? I doubt it`
`21:30.46`	`PleegWat`	`There's no query that could return the data in the last 10 requests box in top`
`21:31.52`	`Zanix`	`well, there is one query to get the total number of rows`
`21:31.58`	`Zanix`	`then a query to limit the rows`
`21:34.47`	`Zanix`	`the functions that builds the pie is weird`
`21:34.47`	`PleegWat`	`Ah, right, that query is at the other end. k.`
`21:36.13`	`PleegWat`	`yes, and it uses a lot of unneeded queries.`
`21:36.20`	`PleegWat`	`Gimme a couple of mins to look at it closer`
`21:37.09`	`Zanix`	`maybe using a count on unique values?`
`21:39.33`	`PleegWat`	"SELECT count(`id`), `$field_name` FROM `".UA_TABLE_STATS."` GROUP BY `$field_name`"
`21:39.37`	`PleegWat`	`I think that's the query you need`
`21:40.25`	`Zanix`	`where, lol`
`21:40.35`	`Zanix`	`in build_pie()`
`21:43.40`	`PleegWat`	`yeah`
`21:43.44`	`PleegWat`	`rebuilding the surrounding code`
`21:43.56`	`Zanix`	`right`
`21:45.00`	`PleegWat`	`http://www.wowroster.net/pastebin/index.php?show=75`
`21:45.43`	`Zanix`	`nope`
`21:45.54`	`PleegWat`	`bugs?`
`21:46.26`	`Zanix`	`you left if( is_array($array) )`
`21:46.45`	`PleegWat`	`ow`
`21:47.14`	`PleegWat`	`apart from that, it looks like it works`
`21:48.08`	`Zanix`	`yeah`
`21:48.23`	`PleegWat`	`You should probably tune the time one to use bigger chunks though`
`21:48.35`	`Zanix`	`very nice`
`21:48.39`	`Zanix`	`im not sure how`
`21:48.40`	`PleegWat`	`I think it's using per-minute chunks, which definitely don't give a usable graph`
`21:48.47`	`Zanix`	`it is`
`21:48.58`	`Zanix`	`its stored in the DB as a unix timestamp`
`21:49.37`	`Zanix`	`that page loads much, much quicker now`
`21:49.42`	`PleegWat`	`Put a check in the function and divide the stamp by 3600, then you get per hour`
`21:50.02`	`PleegWat`	`Or divide by 24*3600 for per day`
`21:50.18`	`PleegWat`	`Still, you'd get the 5 highest traffic hours/days`
`21:50.27`	`PleegWat`	`You probably want a bar graph or a line graph for time`
`21:50.44`	`Zanix`	`probably`
`21:58.13`	`Zanix`	`I cant find that css pie chart thing anymore`
`21:58.18`	`Zanix`	`I should have bookmarked it`
`22:00.25`	`PleegWat`	`note to self: Don't bother putting ubuntu into hibernate again. It isn't even faster than rebooting, let alone being faster than having vmware suspend it`
`22:01.15`	`Zanix`	`lol`
`22:03.52`	`Zanix`	`well, that sql works great`
`22:27.21`	`PleegWat`	`Well, it's not too difficult`
`22:27.52`	`PleegWat`	`Basically step 1 is, if you've got a query and the only thing you do with the result is num_rows, you use COUNT() in the query instead`
`22:31.20`	`PleegWat`	`Step 2, you can pull together all the different pulls for distinct values in the $field_name with a group by clause, eliminating the multiplicity of queries to just 1.`
`22:31.39`	`PleegWat`	`After that some stuff so simple even you should have thought of it at that point, like pulling in the order and the LIMIT.`
`22:32.01`	`Zanix`	`yeah :(`
`22:32.11`	`PleegWat`	`The only reason I can think of for matt to do it like this is that he didn't know about COUNT() when he wrote it`
`22:32.53`	`Zanix`	`perhaps`
`22:33.11`	`Zanix`	`will count work when you limit a query?`
`22:33.45`	`PleegWat`	`Yes`
`22:33.55`	`PleegWat`	`The query is processed roughly in the order you write it`
`22:34.13`	`PleegWat`	`Not even that roughly with mysql, cause its optimizer is near nonexistant`
`23:44.32`	`*** join/#wowroster Mathos (n=Mathos@218-253-045-062.dynamic.caiway.nl)`
`23:44.32`	`*** mode/#wowroster [+o Mathos] by ChanServ`

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.