irclog2html for #wowroster on 20060910

01:21.42Anaxenthey guys anyone online right now with UU installed that can test something for me
05:11.08*** join/#wowroster Anaxent (n=Anaxent@ip68-3-142-242.ph.ph.cox.net)
05:11.08*** mode/#wowroster [+o Anaxent] by ChanServ
05:21.08*** join/#wowroster Zanix (n=Zanix@70-56-206-218.bois.qwest.net)
05:21.08*** mode/#wowroster [+o Zanix] by ChanServ
05:25.56*** join/#wowroster Guest561 (i=CPGGuest@144.139.65.13)
05:32.41Zanixhi guys
05:32.46Zanixback from work
05:32.48WoWn00bhi there :)
05:32.56Zanixhey WoWn00b
06:50.22*** join/#wowroster Guest250 (n=Guest@pool-71-162-118-196.bstnma.fios.verizon.net)
06:50.39Guest250hi
06:52.01Zanixhi
06:53.06Guest250think you could help me w/ a problem?
06:53.11Guest250i know it's kinda late, heh
06:53.47Zanixi might
06:54.01Zanix...be able to help
06:54.24Guest250whenever i try to edit the restor config, i get an error 406 from apache
06:54.35Guest250when i click save
06:54.45Guest250save settings even
06:54.56Guest250"An appropriate representation of the requested resource /admin/config.php could not be found on this server."
06:55.26Guest250can't figure out why it's doing that
06:56.05Zanixunfortunatly, i cant help with that one
06:56.09Guest250hmm
06:56.10Zanixthats mod_security
06:56.14Guest250never seen that before?
06:56.18Zanixi have
06:56.24Guest250oh
06:56.30Zanixnot personally
06:56.42Zanixbut a few users of roster have reported it
06:56.46Guest250do you know if it's possible to "fix"?
06:56.51Zanixpossible
06:56.53Zanixyes
06:56.59Zanix...im looking now
06:57.05Guest250k, thx
06:57.08Guest250i'll be on
06:57.32Zanixhttp://www.wowroster.net/Forums/viewtopic/t=308.html
06:58.20Zanixit's in the UniUploader forums, but it's the same issue
06:58.56Guest250which folder do i put the file in?
06:59.02Guest250admin?
06:59.05Zanixroster/admin/
06:59.07Zanixyes
06:59.20Guest250k, i'll try it
07:00.07Guest250yup, that did it
07:00.09Guest250tyvm
07:00.19Guest250...bye!
07:52.18*** join/#wowroster TinoM (n=Tino@i5387D41B.versanet.de)
07:52.18*** mode/#wowroster [+o TinoM] by ChanServ
08:40.57*** join/#wowroster Warla (n=chris@217-162-116-11.dclient.hispeed.ch)
09:12.52*** join/#wowroster Zanix (n=Zanix@70-56-206-218.bois.qwest.net)
09:12.52*** mode/#wowroster [+o Zanix] by ChanServ
09:26.43Mathos|zZzYo Zanix
09:27.07Mathos|zZzGot 2 missing images sofar
09:27.09Mathos|zZzhttp://fantasyworld.nl/RosterImg/Interface/Icons/INV_Waepon_Bow_ZulGrub_D_01.jpg
09:27.13Mathos|zZzhttp://fantasyworld.nl/RosterImg/Interface/Icons/INV_Waepon_Bow_ZulGrub_D_02.jpg
09:27.25Mathos|zZzweird thing is the way they spelled Weapon in there :P
09:27.47Mathos|zZzbut that is the texture I get from RaidTracker
09:28.00Mathos|zZzso it must be okay, and on Allakhazam they are like that too
09:29.37Mathos|zZzI am thinking about saving all images on <itemid>.jpg
09:30.12Mathos|zZzor at least meake a reference to the itemid
09:36.59Mathos|zZzAnaxent, can I insert a list in DF
09:37.52Anaxentwith in the forums yes
09:38.01Mathos|zZzNevermind, found it lol
09:38.08Anaxentusing bbcode [list][/list]
09:38.10Anaxentlol ok
09:39.38Zanixplaying WSG
09:39.44Zanixsorry i didnt say anything
09:56.17Anaxenthey Zanix hows it going
09:56.26AnaxentI got UU working today with df
09:57.13Zanixcool, very cool
09:57.36AnaxentI had to edit a core DF file that had the form check function to allow the user agent and then modify the update script
09:57.51Anaxenti need to look at how i allow and deny access to that file though
10:17.48Zanixgrrr, we keep losing
10:18.38Zanixor, i keep getting in groups that loose
10:25.03Zanixi think im gonna export a beta of 1.7.1 tomorrow
11:45.37PleegWathi
11:50.40Mathos|zZzAnaxent, you ever tries phpUniUploader ?
11:52.08PleegWatYesterday afternoon I've been looking at some code optimizations. Main thing I've done though is moving the guild_table query to settings.
11:54.09Zanixyou know, we could always convert 1.8 to multi-guild
11:54.20PleegWatWe're getting close to it zanix
11:54.33Zanixyep
11:54.38PleegWatThere are still spots where you'd need to add guild checks
11:54.54Zanixand siggen breaks at the exact moment
11:54.59Zanixlol
11:55.03PleegWatdoesn't work on 1.8?
11:55.06Zanixand some other addons as well
11:55.11Zanixit does
11:55.23PleegWatwell, the 2 I built installers for work
11:55.27Zanixim planning on re-writing siggen for 1.8
11:55.49PleegWatI've been looking at guildbank and guildbank2.php. I can't quite figure how their code works
11:56.13PleegWatguildbank.php seems to be using 2 near identical data queries and I don't understand why
11:56.13Zanixi kinda do
11:58.32Zanixi think query1 actually gets the items and query2 gets the owners
11:58.47PleegWatlet's see, what other stuff was there. I removed a weird code construct in quest.php ('find team'). Minus 2 queries and I don't think it has any effect on functionality
12:00.07PleegWatAnyway with CatGB in main distro do we even need guildbank and guildbank2?
12:01.11Zanixim not sure
12:01.20Zanixi know that some people dont like it
12:01.40PleegWattrue
12:01.51PleegWatThe lack of a per bank view wasn't it?
12:02.05Zanixyeah
12:02.16Zanixi remember mathos saying that he was gonna edit cat guildbank to have the functionality of the other two
12:02.57PleegWatI also should still build a graphical options screen for CatGB
12:04.17Zanixagreed
12:04.30Zanixhave you looked at my last post in the dev forum?
12:04.45PleegWatnot yet today
12:04.50PleegWatI'm reading newsgroups atm
12:05.35Zanixok
12:13.01PleegWatK just read it
12:13.15PleegWatI clarified the permissions question, I hope
12:14.00PleegWatI'm fine with a 1.7.1 beta release
12:15.08Zanixok
12:15.28Zanixmaybe anthony could read it as well, he has great attention to detail
12:15.34PleegWatwell, I still need to study more on how the char page works. I think I'm getting somewhere on it though.
12:16.02PleegWatAnd a look at the keys page suggests to me we might want to move that to an addon, and calculate key possession during character upload
12:16.57Zanixis it cpu/sql intensive ?
12:17.21PleegWatIf I look at the sql log opening the page I get 3 SQL queries per character
12:17.32Zanixyou know, maybe we should move everything to an addon
12:17.34PleegWatIf I look at the code I should get one per key
12:17.47Zanixthen we could easily add a config for each part
12:17.53PleegWatI've been thinking, and that is possible actually.
12:18.03Zanixthen get rid of the separation in the menu
12:18.04PleegWatJust not the upload and character/guild processing parts
12:18.15Zanixand add the ability to move around the items
12:18.16Zanixright
12:18.25Zanixthis is exactly how i wanted to do R2
12:18.49Zanixeverything but uploading, auth, and some other minor items shoudl be core
12:18.58Zanixeverything else, addon...or module even
12:19.00PleegWatI've only just started on real cleanup though. Most of the 1.8 changes so far are reassembling existing code
12:19.54Zanixand with your "upgrade" code for addons, someone could possibly code a "better" or replacement page for the index, or stats
12:20.28PleegWatyes
12:20.46PleegWatThe addons framework needs work though. I really don't like how config profiles work atm
12:20.48Zanixso many nifty ideas :)
12:21.07Zanixhow so?
12:21.30PleegWatwell, there's currently no way except manual pulls to get anything but the default config profile
12:22.25PleegWatThere needs to be a function in addon config to select the currently active profile, but also write that to the addon table so the current active profile is loaded on addon load
12:22.38PleegWatI think I need to put up a topic in the addon dev lounge
12:34.36PleegWatWell, I've got a LBRS run in 20 mins, so I'm going off to game
12:37.37Zanixok
12:37.40Zanixhave fun
12:43.34PleegWatBTW, We might get some extra speedup with unbuffered queries
12:44.05PleegWatNot on when you sort joined tables though, in that case it needs to build a temporary table to sort on and not buffering won't help
12:44.44PleegWatbut places like fetching config data and such, where order doesn't matter. You don't have to wait for all data to be fetched on an unbuffered query
12:45.09Zanixok, sounds cool
12:45.17Zanix...says the sql noob
12:48.08PleegWatthe main disadvantage is that with buffered queries you can move the pointer, fetch earlier records again (no I didn't know that either)
12:48.26PleegWatIf you're only using the records in order, unbuffered queries can add speed occasionally
12:51.53Zanixlike out config table right?
12:51.57PleegWatyes
12:52.16Zanixor for that matter, all addons' config tables
12:52.27PleegWatstuff like mysql_data_seek() won't work unbuffered. But I don't think we use that anywhere
12:52.45Zanixi know one addon does, but i cant remember which one
12:52.56PleegWatcatgb?
12:53.19PleegWator do you mean not an included one
12:54.16PleegWatdoesn't matter much
12:54.35Zanixtrue
12:54.37PleegWatAnyway, it mainly saves in big queries
12:54.47Zanixi dont think roster itself uses it
12:54.55PleegWatlike the membertable one
12:55.16PleegWatBut that's a bad example cause the membertable sorts after joining, and that always means a temporary table is used
12:55.34PleegWatAnd that means it's buffering anyway
13:00.46Zanixok
13:59.03Warlalol
13:59.08Warlai need to use more pots in pvp
13:59.11Warlacheckout my mule
13:59.11Warlahttp://www.wowledgebase.com/?id=6
13:59.21Mathos|zZzwho is good in building wow addons
13:59.30Mathos|zZzI want an In-game-mail spam filter
13:59.43Mathos|zZzI am getting soooo sick of guild.com shit
13:59.51Mathos|zZzgold.com thatis
14:00.38WarlaMathos|zZz
14:00.40Warlathe prob is
14:00.51Warlayou can only get the text of a mail by reading it
14:00.57Warlaso if you'd make a spamfilter
14:01.06Warlait sets the mail cooldown of the mails to 3 days
14:01.11Warlalike youd read em
14:01.35Mathos|zZzdamn.....that is a bloody shame :P
14:01.46Warlawithout "opening" the mails you can read the header infor including the attachment
14:02.50Mathos|zZzcan a rogue open DM backdoor ?
14:03.07Warlaya
14:03.19Mathos|zZzah cool stuff
14:03.27Mathos|zZzcause Roster Keys does not show that
14:03.55Warlabut who doesnt have dm key anyway
14:05.06Mathos|zZzMe :P
14:05.12Mathos|zZzwell....Beela anyway
14:05.18Mathos|zZzLian'Anitrae has got it
14:05.30Mathos|zZzbut we got one in the group that has it now :P
14:10.21Warladm key =easy dm east run
14:12.03*** join/#wowroster Anax (n=Anaxent@209-250-16-194.convergentaz.net)
14:21.57PleegWatOur warrior was shit
14:40.01PleegWatAre there any functions to get a subset of an array?
14:40.13PleegWatI know the values for the keys I want
15:26.40Zanixyawn
15:26.47Zanixim so tired
15:26.58Zanixbut i just finished working on UA 0.7.0 alot
15:26.58PleegWathow late is it over tere?
15:27.03Zanix9:30am
15:27.14PleegWatand you didn't sleep yet I assume?
15:27.29Zanixnope
15:27.35Zanixcheck it out
15:27.36Zanixhttp://cvsroster.homeip.net/ua7/
15:27.47Zanixadmin    changeme
15:28.12PleegWatThe permissions system for char.php is in
15:29.03PleegWatnice
15:29.22Zanixalmost ready to convert it to a roster addon
15:29.27PleegWatdamn, I'm forgetting the update system
15:29.30Zanixjust need to add more crap
15:31.34PleegWatI'll have to adapt the update system to do new members right
15:31.58PleegWatCurrently I assume it'll put them on admin permission level for additional members
15:32.47PleegWatCourse it's an or permission atm, so admin only as a member setting actually equates to 'the same as the roster admin'
15:32.54PleegWatehm
15:32.57PleegWatthe same as the global setting
15:33.02PleegWatI'm not paying attention either
15:34.28Zanixim not grasping it
15:34.35Zanixsorry
15:34.36PleegWatI am not done yet
15:34.40Zanixtoo tired i guess
16:03.01Zanixi think the search page is broken
16:03.11Zanixhttp://cvsroster.homeip.net/adminpanel/indexsearch.php
16:03.20Zanixanyway
16:03.29Zanixim really tired and im gonna pass out
16:03.37Zanixnight...errr ....morning
16:11.29PleegWatseems so
16:19.23PleegWatFixed, and added an error check on the sql queries in question
17:08.07*** join/#wowroster Zanix (n=Zanix@70-56-206-218.bois.qwest.net)
17:08.07*** mode/#wowroster [+o Zanix] by ChanServ
17:20.42PleegWathi
17:27.28Zanixhi
17:27.42Zanix... :( can't sleep
17:31.15PleegWatYou know, I initially had the opinion char.php and the stuff it uses is messy
17:31.18PleegWatBut it isn't
17:31.30PleegWatIt's actually some of the most beautiful code I've encountered yet in roster
17:31.34PleegWatIt's just uncommented
17:40.01PleegWatThe realm status isn't wrapping
17:40.14PleegWathttp://leegwater-68.demon.nl/RosterSVN/roster1x/branches/adminpanel/realmstatus.php
17:44.49Anaxentgood morning
17:44.55PleegWathi anax
17:44.56Anaxenti see the realmstatus image
17:45.07PleegWatthe text isn't wrapping
17:45.12Anaxentthe highe que is off a bit though
17:45.17Anaxentah right
17:45.20PleegWatZanix said he adapted it and it should wrap, but it doesn't
17:45.49Zanixah crap
17:45.58Zanix:(
17:46.25PleegWatStrangely, when I put it on High (Queued) on purpose, it did wrap
17:46.40Zanixhmmm, maybe its a url encoded space or somthing
17:47.22Zanixyou use the EU english reamstatus righ?
17:47.34PleegWatyes
17:48.01PleegWatI'm already entitydecoding it though
17:48.01Zanixok
17:48.38Zanixput it in DIV mode
17:48.40ZanixHigh�(Queued)
17:48.45ZanixHigh?�(Queued)
17:48.50Zanixthats what it looks like
17:49.17PleegWatit's in div mode now
17:49.32Zanixhmm, looks at mine
17:49.38Zanixhttp://cvsroster.homeip.net/adminpanel/realmstatus.php
17:50.20PleegWatstrange
17:50.36PleegWatIt gives a ? for the space
17:50.48PleegWatwait, does that here too
17:50.51PleegWatand breaks the rest of the page
17:51.41Zanixhmmmm
17:51.44PleegWatdoes realmstatus die when it's done?
17:51.59Zanixim not sure
17:52.10Zanix/ Generate image or text?
17:52.11Zanixif( $generate_image )
17:52.11Zaniximg_output($realmData,$err,$image_path,$font_path);
17:52.11Zanixelse
17:52.11Zanixecho text_output($realmData,$err);
17:52.11Zanixexit();
17:52.14Zanixyes, it does
17:52.20Zanixcrap
17:52.26Zanixthat needs to be in the image sectin
17:52.56Zanixoops
17:53.09PleegWatjust make it return()
17:53.23PleegWatreturn does the same as exit if it's the requested file
17:53.32PleegWatbut it returns to the including document if it's included
17:54.23Zanixah
17:55.25PleegWatThe code creating the talent trees needs to be rewritten. It's doing 4*7*3=84 queries
17:55.36PleegWatone for each slot that could hold a talent
17:55.44Zanixyeah, i know
17:55.53Zanixthe old code was way more effecient
17:55.59Zanixbut this looks better
17:56.00PleegWatWe also need prefetching on the items
17:56.15PleegWatthere are way too many item queries, especially on the front page
17:57.01Zanixprefetching? how so?
17:57.40PleegWatWell, on all pages using items, we need to do 1 pull of all items for that char, and write it to the character object
17:58.07Zanixinstead of asking the db for one item at a time?
17:58.13Zanixlike it currently does?
17:58.20PleegWatyes
17:58.33Zanixso, you like lib/char.php?
17:58.48PleegWatyes
17:58.52Zanixthat's wierd
17:59.02PleegWatThere's some weird stuff in it
17:59.08PleegWatbut it's extremely neat in setup
17:59.08Zanixits really confusing at first
17:59.12PleegWatIt's uncommented
17:59.16PleegWatthat put me off
17:59.20Zanixvery...lol
17:59.31PleegWatand $char->out() is weird
17:59.41PleegWatjumping out of php syntax all the time, not staying indented
17:59.51Zanixi really did alot of cleaning to that file some time ago
17:59.52Anaxentwell ill be back in a few heading to qork now
18:00.01Zanixcork?
18:00.05Zanixrofl
18:00.07Anaxentlol yep
18:00.09Zanixi havent slept yet
18:00.16Anaxentwork*
18:00.20Anaxentreally...
18:00.49Anaxentwell get some rest even if it is a cat nap later
18:02.15Zanixi cant sleep
18:02.18Zanixthats the problem
18:04.59Zanixany clue as to why realmstatus is doing this?
18:05.43ZanixHigh&nbsp;(Queued)
18:05.49PleegWatI don't know anything about realmstatus
18:05.52Zanixthats what it looks like in the page
18:05.56Zanixin the html
18:06.11PleegWatI'm already doing an entity decode. Is your image/text code putting it back in?
18:06.51Zanixit shouldnt be editing any of the text
18:08.12ZanixNote: You might wonder why trim(html_entity_decode('&nbsp;')); doesn't reduce the string to an empty string, that's because the '&nbsp;' entity is not ASCII code 32 (which is stripped by trim()) but ASCII code 160 (0xa0) in the default ISO 8859-1 characterset.
18:08.53PleegWatah
18:09.12PleegWatso we end up with a char that doesn't wrap either
18:09.17PleegWatmakes sense actually
18:09.38Zanixyeah, im looking for ' ' a space
18:09.43ZanixASCII 32
18:10.21Zanixso i need to check for both then
18:11.03PleegWatJust change it up where the entity_decode is to replace &nbsp; with ' ' (space) first
18:11.14Zanixgood idea
18:11.32PleegWatThere, the extra talents queries are out
18:12.40Zanixhttp://cvsroster.homeip.net/adminpanel/realmstatus.php
18:12.43Zanixthere we go
18:12.51PleegWatyup
18:13.56Zanixdiv mode doesnt work quite right either
18:14.31PleegWatI don't plan to teach myself GD just to bugfix realmstatus, I'm afraid
18:15.00Zanixlol
18:15.04Zanixthats why im here
18:15.17Zanixi am the GD expert around here, lol
18:16.22PleegWatRanged damage looks weird with me. |cff20ff20146-20
18:16.34PleegWatLooks like a data problem though. It's not parsing the color tag
18:18.50Zanixin admin panel?
18:19.03PleegWaton char page
18:19.04PleegWathttp://leegwater-68.demon.nl/RosterSVN/roster1x/branches/adminpanel/char.php?name=Azymyrta&server=Aggramar&action=character
18:19.17Zanixcan you look in your CP.lua file?
18:19.24Zanixi wanna figure this one out
18:19.44Zanixit doesnt have the end of the color tag so the new parser isnt picking it up
18:20.05Zanixi wanna know if the CO.lua file has the end and if the db field size is too small
18:20.07PleegWat["Ranged Attack"] = {
18:20.07PleegWat["AttackSpeed"] = "1.80",
18:20.08PleegWat["AttackDPS"] = "96.9",
18:20.08PleegWat["HasWandEquipped"] = true,
18:20.08PleegWat["DamageRangeBase"] = "66 - 123|cff20ff20 +80|r",
18:20.08PleegWat["AttackRating"] = 300,
18:20.10PleegWat["DamageRangeTooltip"] = "Ranged<br>Attack Speed (seconds):1.80<br>Damage:66 - 123 +80<br>Damage per Second:96.9",
18:20.13PleegWat["DamageRange"] = "|cff20ff20146-203|r",
18:20.15PleegWat},
18:21.14PleegWatI think that's correct
18:22.32Zanixyep, the db field is too small
18:22.37Zanixup the size
18:22.43Zanixand upload your file
18:23.09PleegWatwhich field is that?
18:23.35PleegWatranged_range?
18:24.31Zanixyeah
18:25.03Zanixshould probably up melee_ranged as well
18:25.13PleegWatPut it from 16 to 32
18:25.23Zanixsure
18:26.12PleegWatdoesn't seem to have changed anything
18:28.20Zanixthis is in 1.8 right?
18:28.24PleegWatyes
18:29.47Zanixits just the tooltip that gets parsed, not the actual string
18:29.50Zanixdang
18:30.07PleegWatFixed the equip fetch
18:30.24PleegWatI'm now fetching equipment in a prefetch function and storing it on $char
18:30.50PleegWatIt still does a big bunch of fetches for the bags and bank views but I can live with that
18:31.04Zanixfunction printAtk
18:31.10Zanixbelow
18:31.11Zanix$atk = $this->data[$type.'_'.$stat];
18:31.19Zanixadd this
18:31.19Zanix$atk = preg_replace('|\|c[a-f0-9]{2}([a-f0-9]{6})(.+?)\|r|','<span style="color:#$1;">$2</span>',$atk);
18:32.03PleegWatfixes the display, but messes up the placement
18:32.28Zanixok, change it so it just removes the extra crap
18:33.09Zanix$atk = preg_replace('|\|c[a-f0-9]{8}(.+?)\|r|','$1',$atk);
18:33.15Zanixsomething like that
18:33.55PleegWat<span style="color - #20ff20;">146-203</span>
18:33.56PleegWatis coming out
18:34.41PleegWatit's replacing : with - lower down
18:34.46PleegWatthat's messing it up
18:34.47Zanixyeah
18:34.51Zanixis it?
18:35.01PleegWatno
18:35.07PleegWatbut coloring actually goes right now too
18:35.28Zanixgotta replace that : before the preg_replace
18:35.39PleegWatI did
18:35.40Zanixcoloring doesnt matter to me
18:35.44PleegWatbut that doesn't fix placement yet
18:36.13Zanixdid you try my second preg_replace?
18:36.41PleegWatthat works
18:38.26Zanixyeah, the css is very touchy here
18:38.36Zanixinsert a randon span and it can mess the whole thing up
18:39.39Zanixok, i got the upgrade_170.sql file updated to fix those two fields
18:41.33PleegWatfixed the damage
18:41.47PleegWatused your second replace, fetch the color with a preg_match
18:41.57PleegWatand insert it into the existing span tag further below
18:42.08Zanixliterally, in both senses of the word
18:42.11Zanixlol
18:42.11PleegWathttp://leegwater-68.demon.nl/RosterSVN/roster1x/branches/adminpanel/char.php?name=Azymyrta&server=Aggramar&action=character
18:42.20Zanixnot bad
18:42.38Zanixworks out well
18:42.45PleegWatalso, we're at 23 queries on that page
18:42.48PleegWatdown from 125
18:42.56Zanixreally?
18:43.00Zanixawesome
18:43.12Zanixyou are the best
18:43.45PleegWatNow, there's serveral player data refetches to remove. That stuff is already in $char->data
18:44.44PleegWatwhy would you, in a member function, have a name+server to member_id translate function?
18:45.19Zanixi have no clue
18:46.02PleegWatit's the 2 pet functions doing it
18:46.32PleegWatpossibly there has been a seperate pet class
18:47.03PleegWatwth, it doesn't even use the player data it fetches
18:47.19PleegWatwait, wrong, it does
18:48.19Zanixwe should almost have a pet object
18:48.39PleegWatyes. But it's in member functions of $char
18:49.01Zanixweird, i never noticed that it requires name ans server
18:49.08Zanixwhy not just pass a member_id
18:49.10Zanixlol
18:49.23PleegWatnot even that
18:49.31PleegWatmember_id is in $char already
18:50.15Zanixi know
18:50.28Zanixweird
18:51.02Zanixi tell people all the time that roster is kind kludged together
18:51.12PleegWatThis
18:51.17PleegWatwas a beautiful char page
18:51.23PleegWatprobably put in by inexperienced coders
18:52.32Zanixi can admit that i was very inexperienced, but i shy'ed away form this file for a very long time
18:55.28Zanixthere we go
18:55.40Zanixor not
18:55.41Zanix:(
18:55.49Zanixhttp://cvsroster.homeip.net/adminpanel/realmstatus.php
19:01.06Zanixcan you look at it in IE6 for me?
19:01.56PleegWatLooks the same in FF, IE6, Opera
19:02.11PleegWatfixed the pet queries
19:02.24Zanixah crap
19:02.36Zanixif its viewed in the actual roster page, it breaks
19:03.21Zanixdown to 16
19:03.48ZanixSELECT i.item_tooltip, i.item_name, i.item_color, p.parry, p.dodge, p.block, p.crit, p.mitigation, p.clientLocale
19:03.53Zanixhmmm, wheres that?
19:04.00PleegWatdunno yet
19:04.08PleegWatI'm working on the dateupdatedutc fetch
19:04.17Zanixah
19:04.18Zanixfunction dumpBonuses
19:04.39PleegWatas I suspected, that one is in membersDetails
19:05.01Zanixyeah, I remember anthony putting that one in
19:05.11Anaxok im here at work now
19:05.21Anaxseems that i keep forgetting to log off ehre at work
19:05.25PleegWatwe've already got the char object at that point
19:05.45Zanixyeah, i did that
19:06.04Zanixbefore, the char object wasnt initialized until the last second
19:06.16Zanix/ Slash char name and server name
19:06.16Zanixif( get_magic_quotes_gpc() )
19:06.16Zanix{
19:06.16Zanix$name = stripslashes( $name );
19:06.16Zanix$server = stripslashes( $server_name_escape );
19:06.16Zanix}
19:06.20Zanixcheck that out
19:06.28Zanixi swear i have never seen that before
19:06.47Zanixdot we have a slash global data in commonfunctions?
19:07.11PleegWatdunno. I had to add it in config to fix the disappearing \ in regex problem
19:07.16PleegWatit fixed it, I tested it
19:07.33Zanixif we jsut do that by default, say in settings.php
19:07.36PleegWatWe should execute it in settings
19:07.37PleegWatyes
19:07.39Zanixthen we can remove that
19:07.50PleegWatwe're down to 15 char queries
19:08.04Zanixand i dont understand why this was put in either
19:08.05Zanixif ( $roster_conf['server_name_comp'] == 0 )
19:08.05Zanix$server_name_escape = $_GET['server'];
19:08.05Zanixelseif ( $roster_conf['server_name_comp'] == 1 )
19:08.07Zanix$server_name_escape = $wowdb->escape($roster_conf['server_name']);
19:08.20PleegWatI don't have teh foggiest
19:08.31PleegWatthat's config?
19:08.37PleegWatwait, no realmstatus
19:08.43Zanixmemberdetails.php
19:08.44PleegWatthat's what you're working on
19:08.46PleegWathm
19:08.58PleegWatyup
19:09.02PleegWatknew I'd seen it recently
19:09.10PleegWatbut I've seen most of roster recently...
19:09.22Zanixits a setting to either grab it as is, or mysql escape it
19:09.54PleegWatI know I looked at that too
19:10.09PleegWatI think it should be possible to dump it
19:10.18Zanixi do remember who put that in
19:10.20Zanixmordon
19:10.40Zanixfor some reason his server complained about this or something
19:10.59Zanixso in order for his roster to work, the server name had to be escaped
19:11.12Zanixbut this broke mine and anthony's roster
19:24.45PleegWatThere, lost the seperate query for dumpbonuses
19:24.53PleegWatdown to 14
19:26.06PleegWatAh, wait a min, former addon code
19:26.19PleegWatso that's why there was a seperate query
19:28.37PleegWatversion? What's in version
19:28.44Zanixhuh?
19:28.47Zanixin the players table?
19:28.52PleegWati think
19:28.55PleegWatcould be members too
19:28.58Zanixsigh
19:29.13PleegWatbetter said
19:29.23PleegWatwhy do we do something else than normal if it's less than 0.96
19:31.22PleegWathm. there doesn't seem to be a version
19:31.25PleegWatnot in players not in members
19:31.33PleegWatit's CPversion or GPversion
19:32.26Zanixi wonder if i removed that....
19:32.43ZanixALTER TABLE `renprefix_players`
19:32.43Zanix<PROTECTED>
19:32.44PleegWatI'm getting empty string
19:32.45Zanixi did
19:32.53PleegWatevidentially the code still works
19:32.54Zanixupgrade_160.sql
19:33.08PleegWatwe'd definitely have heard if we broke something then
19:33.25Zanixyeah, that field has been empty since version 1.04
19:35.36PleegWatGuess CP before 0.96 didn't fetch the skill_order parameter
19:35.47PleegWatbut we don't do compatibility anymore
19:38.45Zanixexactly
19:39.09Zanixthe only reason we pull the version now is to store it so you can purge old profiles if needed
19:40.53PleegWatThere
19:41.00PleegWatWeird compatible code out
19:41.02PleegWatand down to 9
19:43.16PleegWathttp://leegwater-68.demon.nl/RosterSVN/roster1x/branches/adminpanel/char.php?name=Azymyrta&server=Aggramar&action=character
19:43.22PleegWatAlso inserted menu above it
19:43.35PleegWatwhich means up to 11
19:44.37Zanixhaving the menu is gonna be weird
19:44.47Zanixlol, no reason not to have it though
19:46.29PleegWatyeah
19:46.38*** join/#wowroster Zeryl (i=Zeryl@75.132.127.218)
19:46.38*** mode/#wowroster [+o Zeryl] by ChanServ
19:46.51PleegWat03(Zeryl03): The new and improved character page
19:46.51PleegWathttp://leegwater-68.demon.nl/RosterSVN/roster1x/branches/adminpanel/char.php?name=Azymyrta&server=Aggramar&action=character
19:47.00PleegWatDown from 125 queries to 11
19:48.00ZerylVERY nice
19:48.03ZerylI knew it could be done :)
19:48.26Zeryloh darn, you might need 1 more query, lol
19:48.34PleegWatlol
19:48.36PleegWatI know I don't
19:48.36Anaxhows it going Zeryl
19:48.40Zerylhi anax :)
19:48.44AnaxI got UU to work with DF now
19:48.54Zerylcool, how'd ya do it?
19:49.05Anaxa bit of a hack until we get full cookie handling
19:49.24Anaxin the includes/cmsinit.inc file
19:49.48Anaxis where the post check function is so I had to add on to the top to check and allow UU's user agent
19:49.57Zerylahh
19:50.33Anaxand then remove some auth code from the updateProfile.php
19:51.29Zerylmy account on wow has almost 7k gold
19:51.36PleegWatthere, fixed
19:51.41PleegWatI missed the global declares
19:51.57Zerylthat is so much better
19:52.00Zeryland will be quicker
19:52.16Zanix*snif*   its soo beautiful
19:52.20PleegWatI don't think I can go any lower than 11 though
19:52.44ZerylOMGZORZ, hi zanix!!!!
19:52.44Zeryllol
19:52.44Zanixhi
19:52.44Zanixi havent slept yet
19:52.53Zanixi havent had one of these nights in over a year
19:52.56Zerylcan't you do all the talent/spell stuff in one?
19:53.03Zanixwhere i cabsolutly cannot sleep
19:53.06PleegWatOK, spellbook page. We're at 10 and we can theoretically get to 7
19:53.20ZerylI know what you mean zanix, i used to be like that for awhile :(
19:53.30PleegWatpossibly even 6
19:54.31PleegWatno, 7
19:54.41Zanixlol
19:54.50Zerylhsaha
19:54.56Zerylselect * from *
19:55.00Zerylthen you only need one!
19:55.01ZerylROFL
19:55.40Zanixyeah...
19:55.47Zanixlook at my new imporved realmstatus
19:55.50Zanixhttp://cvsroster.homeip.net/adminpanel/realmstatus.php
19:55.59Zerylnew fonts
19:56.04Zerylare they a default font?
19:56.05Zanixjust two
19:56.11Zanixno, i added one
19:56.15Zerylokie
19:56.22Zerylmake sure you watch the copyright on that font
19:56.25PleegWatlol @ zeryl
19:56.28Zanixhad to, to get the right width
19:56.45Zanixit was distributed with the original realmstatus
19:56.49Zerylahh, ok
19:56.52Zanixand i searched the net for it
19:56.59Zanixits free everywhere
19:57.09Zanixi just gotta fix the borders now
19:57.11Zerylok :), just don't want something so small coming back on us
19:57.12Zanix:(
19:57.15Zanixyeah
19:57.18Zanixagreed
19:57.32Mathos|zZzyou guys found the WoW font ?
20:00.04Zanixno
20:00.15Zanixat least, I havent
20:00.17Zanixlol
20:00.49Zeryli don't want to release a new version of missing recipes until someone can confirm or deny that the &locale=xxXX DOES in fact work
20:05.12ZanixYES
20:05.17Zanixi got it to be transparent
20:05.31Zanixnow i know how to fix siggen to be transparent
20:05.36ZanixYES!
20:06.01PleegWatgratz
20:06.35Zanixhttp://cvsroster.homeip.net/adminpanel/index.php
20:06.40Zanixbeautiful
20:07.42Zanixand i got rid of one more image
20:08.05PleegWatyeah, nice
20:08.31Zanixerror.png
20:17.27Zanixgot rid of another image
20:17.32Zanixunknown2.png
20:18.02Zanixdown to five images for realmstatus
20:21.39Zerylnice
20:22.42Zanixand it looks soo good too
20:22.51Zanixand fully locale independant
20:22.53Zanixhttp://cvsroster.homeip.net/adminpanel/index.php
20:24.00Zerylhttp://www.hookah-shisha.com/store/pc/configurePrd.asp?idcategory=15&idproduct=200
20:24.02Zerylpretty
20:25.11PleegWatSpellbook page down
20:26.51Anaxlol nice hooka
20:26.54PleegWatLeaves bag and bank. Can't do the pvp pages cause I don't have pvplog installed, so I need to install it and get some data first.
20:26.58Anaxi think we need 2 more tubes
20:27.08PleegWatand I don't have mail atm so I can't do that either
20:31.08Zeryli can dump my sql table for you pleeg
20:31.16Zeryli've got some pvp data and probably mail
20:32.26PleegWatNah, I'll get my own later on
20:33.15*** join/#wowroster Zerf (n=Zerf@229.29-136-217.adsl-dyn.isp.belgacom.be)
20:33.33Anaxany of you know about mod_rewrite
20:33.41ZerfHello
20:33.49Anaxwhats up Zerf
20:33.58ZerylI know a small bit anax, if it's easy i can help
20:34.06ZerfI speaak not verry well English, I am sorry, I have a problem with WoWRoster
20:34.20Anaxhttp://convictionofsuramar.com/pastebin/41
20:34.25Anaxis the rewrite rules
20:34.35AnaxI need to extend the links by 2 extentions
20:34.55Anaxhttp://localdefence.net/wowrosterdf/char/cname=Anaxent/server=Ner'zhul.html  wroks
20:35.10Anaxhttp://localdefence.net/wowrosterdf/char/cname=Anaxent/server=Ner'zhul.html&action=quests dont work
20:35.23Anaxshould be http://localdefence.net/wowrosterdf/char/cname=Anaxent/server=Ner'zhul/action=quests.html
20:35.24Zerffor load my guild
20:35.59Zerfwhere load guild in wowroster ?
20:36.18Zerylanax: too complicated for me, lol, sorry
20:36.26Anaxlol np me too
20:36.28ZerylZerf: http://www.yoursite.com/roster/update/admin.php
20:36.28Anaxfinal major pre-release of Windows Vista - Release Candidate 1 (RC1) - is now available for download for CPP participants.
20:37.30ZerfZeryl : admin/update.php of update/admin.php  ?
20:37.51Zerylermm, admin/update.php, sorry
20:38.09AnaxZeryl why you always trying to confuse us all
20:38.12Anaxlol
20:38.16Zanixwow
20:38.35Zanix1.8's char screens are loading much faster now
20:38.41Anaxsick
20:38.51ZerfZeryl : Could not find guild in database. Please update members first.
20:39.10Zanixread this
20:39.11Zanixhttp://www.wowroster.net/wiki/index.php/Roster
20:39.25Zanixthere are menu items along the right side
20:39.34Zanix# Requirements
20:39.35Zanix# Change Log
20:39.35Zanix# Installing Roster
20:39.35Zanix# Configuration
20:39.35Zanix# Roster Diagnosics
20:39.35Zanix# Roster Main Menu
20:39.37Zanix# Updating Roster Data
20:40.32Zanixtry the link "Updating Roster Data"
20:40.45Zanixthe wiki is your friend
20:40.48Zanix:)
20:42.19Mathos|zZzGuys, I am still uncertain about that JAvascript sorting
20:42.30Mathos|zZzmy client went nutz the other day
20:43.27Zanixthats not good
20:44.06ZerfMy server is not in the list
20:44.53Zanixwhat do you mean?
20:45.08Zerfsorry ?
20:45.36Zerfmy server
20:45.41Zerfisn't
20:45.49Zanixwhat list?, there is no list of servers
20:46.02Zanixyou set your realmname adn guild name in roster config
20:46.11ZerfRealmstatus URL
20:46.15Zanixthen you upload your CP.lua file to admin/update.php
20:46.22Zanixno
20:46.26Zerfwhat ?
20:46.27Zanixguild settings
20:46.30Zerfok
20:46.59Zerfbut I don't load my guild :s
20:47.08Zanixwho does then
20:47.33Zanixare you just a member in that guild?
20:47.34Zerfwhat ?
20:47.48Zerfnon
20:47.53Zerfi am the guildmaster
20:48.00Zanixwho loads the guild information?
20:48.26Zanixah
20:48.28Zanixok
20:48.46Zanixso, do you have CharacterProfiler and GuildProfiler loaded in wow?
20:49.03Zanixalso, can I get a link to your roster
20:49.25Zerfyes
20:49.33Zerfand I have the files
20:49.39Zerfbut I don't load this
20:50.10Zanixdid you upload CharacterProfiler.lua on the web page roster/admin/update.php
20:50.44Zanixand when you use that page, did you enter your roster admin password in the "Officer's Only" box?
20:51.04Zerylhttp://www.hookah-shisha.com/store/pc/configurePrd.asp?idcategory=15&idproduct=151
20:51.06Zerfyes
20:51.16Zerfand I write the pass but
20:51.34Zanixwhat is in the update log, coy and paste what appears
20:51.35Zerfthe page reload
20:51.55Zanixs/coy/copy/
20:52.20Anaxok so the mod_rewrite im working with is just regex
20:52.34Zerfthe Roster Update Password is the roster config pass ?
20:52.37Zanixyes
20:52.38Anaxso I need to learn how to use regex i guess
20:53.33Zerfthan i have a bug
20:54.15Mathos|zZzAnax, get regex coach
20:54.29Mathos|zZzbrilliant free tool to learn a bit how regex works
20:54.37Zanixi think he has it
20:54.50ZanixZerf: what is the EXACT error you get?
20:56.10ZerfZanix : When I write the password officier for load my guild
20:56.47Zerfthe page isn't for upload ? How to say that
20:57.10ZerfDo you speak a other language ?
20:57.13Mathos|zZzwhat is the URL Zerf ?
20:57.28Mathos|zZzWarla speaks german
20:57.33Mathos|zZzI speak  dutch
20:57.47ZerfAllemand ?
20:57.47Mathos|zZzTinoM speaks german too
20:57.56Mathos|zZzWhaz Allemand ?
20:57.59Mathos|zZzlol
20:58.04Mathos|zZzis that a language ?
20:58.14Zerfno I speak Frans, English and " Nederlands "
20:58.20Mathos|zZzah cool
20:58.27Zerftu parle français ?
20:58.46Zerfurl : http://www.beau-monde.net/admin/update.php
20:58.50Zanixi speak only american english
21:01.04Mathos|zZzZerf, you get what I am saying to you in the other panel
21:02.34Zerfsorry ? Mathos ?
21:02.51MathosI Opened a dialog with you
21:02.59Mathosare you on the Java IRC ?
21:03.09Zerfyes
21:03.19Mathosdid you not get a dialog
21:03.27MathosPop-up blocker may be blocking it
21:04.02Zerfare you sur ? ^o)
21:04.10MathosPretty much
21:04.24MathosOpen a dialog with me then please
21:04.40Mathosright-click on my username in the list here
21:04.54Zerfit is donje
21:04.55Zerfdone *
21:05.02Mathosit is humm
21:05.04AnaxI just downloaded regcoach
21:05.15Mathoscool stuff Anax
21:05.19Anaxchecking iot out now and reading up on how it works thx Mathos
21:05.37Zerfhum
21:05.41MathosNo probs
21:05.45ZerfIg o fast download mIRC
21:05.55MathosGet X-chat
21:05.59Mathosmuch better :P
21:06.20Zerfyes
21:06.20Anaxlol " i speak only american english"    
21:06.28Zanixyep
21:06.34Zanixthe worst language ever
21:06.35Mathoswell....tis quite different from enGB
21:06.42Zerfwhat is the server ?
21:06.51Mathosirc.freenode.net
21:06.56Mathoschannel is #wowroster
21:07.21Mathoscustomize instead of customise
21:07.25Mathos:P
21:07.40MathosAnd....Yeah instead of Yes :)
21:08.06Zanixor yep
21:08.12Zanixor uh huh
21:08.19Mathoshaha
21:08.20Zanixor even yea
21:08.27Zanixor "nod"
21:08.28*** join/#wowroster Zerf002 (n=Zerf@229.29-136-217.adsl-dyn.isp.belgacom.be)
21:08.30Zerf002Re
21:08.32MathosOr...Yoaha
21:08.38Zanixrofl
21:08.46ZerylIt's not going to work unless he registers on the irc server
21:08.59Zerf002I am with mIRC
21:09.05ZerylPM's are disabled on freenode
21:09.10Zerylunless you have identified
21:09.12MathosAh crap
21:09.17Mathosdid not know that
21:09.23Zerf002i do identified ?
21:09.29Mathoswhy did we not stay at WoWRoster.net anyway ?
21:09.40Zerylchanserv
21:09.44Zerylchannel logging
21:09.48Zeryl~apt
21:09.57apti guess apt is the Advanced Package Tool, an advanced frontend for dpkg and rpm (depending on your system).  APT is also known as the best package management system in existence today.
21:09.57Mathosah okay
21:09.57Zerf002i am registered in WowRoster
21:09.58Zanixpossibility of wowroster.net going down
21:10.19Mathoslol
21:10.27Mathosquite full of itself innit
21:10.52Zerf002Mathos, I say you my msn adress ?
21:10.58Mathosokay
21:11.04Zerf002here ?
21:11.28Mathosyeah well....problem is...KMess aint connecting somehow lol
21:11.35Mathosah never ind
21:11.38Mathosit does work
21:11.40Zerf002moucheron_morgan@hotmail.com
21:11.43Mathoslet us hear it!
21:11.45Mathosah cool
21:12.07Zerf002NL ?
21:28.11MathosGuys
21:28.22MathosZerf's system aint working well
21:28.34Mathoswe copied the servname and guildname from his lua file
21:28.42Mathosand still it aint going somehow
21:28.53Mathoscan you copy/paste the exact error Zerf
21:28.55Anaxany errors
21:28.58Mathosfrom the upload window
21:29.58Zanixi got level for regular item in roster now
21:30.03Zanixlike recipies
21:30.15MathosCould not update Geants ...blah, perhaps it is not in the DB
21:30.31Mathoshe uses some wird chars though
21:30.35Mathosin Guildname
21:30.41Mathosmight be the problem somehow
21:31.05Mathostis an e with Accent Graf
21:31.09Mathosor the other one lol
21:32.02Mathoson the roster page itself it displays it weird now too once we changed his config
21:33.05Mathoshttp://www.beau-monde.net/admin/
21:33.17Mathoshttp://www.beau-monde.net/ even
21:33.40Zanixoo
21:34.12MathosHavent payed attention much lately on the forums for these kind of thingies :P
21:34.44Zanixhmmm
21:34.49Mathoshis update window btw mentiones the name (from the LUA) in the correct characters
21:34.57Zanixright
21:34.59Mathoswhich is kinda odd to me
21:35.05Zanixyou shouldnt have to copy the name form CP.lua
21:35.19Mathoswell, best guess cause it wasnt working
21:35.24Zanixit *should* utf-8 encode it if you enter the accents and such
21:35.43Mathosokay, we could try and change it back
21:35.50Zanixyeah
21:35.54MathosZerf, can you change it back please
21:45.53MathosUh oh
21:46.01MathosI might have broken his system now
21:46.03Mathos:P
21:46.06Zanixrofl
21:46.37Zanixmathos
21:46.39ZanixPHP API Type  cgi-fcgi
21:46.46PleegWatwon €13,50
21:46.52Zanixyay!
21:47.01PleegWatOTOH, I paid €13,50 to enter
21:50.20Zanixso, are we ready for 1.7.1 beta?
21:50.37PleegWatI don't see why not
21:51.28Zanixok, im doing the last commit
21:54.03MathosHmmm, his GuildProfiler stuff aint in his lua file
21:54.12Mathoseven though he saved his guildlisting
21:54.15Zanixok, im gonna try a quick upgrade
21:54.20MathosI let him destroy the lua files
21:54.20Zanixdid he exit wow?
21:54.24Mathosyes
21:54.28Zanixok
21:54.45Mathoshe is gonna save only the Guildlist now, and send me his lua again
21:54.56Mathosbut he is running 1.6.0 of GP so that should be okay no ?
21:56.04Zanixyeah, thats the newest version
21:58.04MathosHmm
21:58.08MathosI know what it is I think now
21:58.18MathosHis version number isnt coming through
21:59.42MathosData is from GuildProfiler v
21:59.42MathosThe version of GuildProfiler used to capture data for this guild is older than the minimum version allowed for upload.
21:59.42MathosPlease ensure you are running at least v1.5.1
21:59.52MathosAnyone ever seen that ?
22:00.59*** join/#wowroster Zerf (n=Zerf@229.29-136-217.adsl-dyn.isp.belgacom.be)
22:01.34Mathosreally weird innit Zanix
22:01.48Zanixnope
22:02.30MathosYou seen it happening before then ?
22:02.34Mathoscause I sure havent
22:02.50Zanixi have once, but it was because of another addon
22:02.57Mathosah okay
22:03.01Zanixsome translator for russian
22:03.14Mathoshehe, doubt that he speaks Russian
22:03.22Mathosdo ya Zerf?    Speak russian ?
22:04.09Mathoswell then.....Zerf, the best way to check this is disable all addons except CharacterProfiler and GuildProfiler
22:04.13Mathosthen do the save again
22:04.13ZerylAnax: http://www.convictionofsuramar.com/woza/badmember.php
22:05.10Zerfok
22:06.01ZerylOMG: http://owfs.sourceforge.net/
22:06.04ZerylGlad I found that
22:07.30Anaxwhat is that table
22:08.03Anaxusers and who they are
22:08.30Anaxlike class and maybe a user grp?
22:11.23Zerylusers that are in a usergroup, and not in the guild (based on roster data)
22:14.43*** join/#wowroster Adric (n=Adric@cpe-24-209-67-6.woh.res.rr.com)
22:14.49Adrichey guys
22:14.54Adrichttp://midnightcartel.com/index.php?p=m_exodar
22:15.03Adrichttp://midnightcartel.com/index.php?p=m_silvermoon
22:15.09Adrici finished the city maps for those
22:17.24Zerylnice
22:17.29Zeryli still am in love with your site
22:17.42Mathosokay
22:17.43Adricthanks
22:17.45Mathosthat fixed it
22:18.02Mathosnow he needs to find the addon that caused it :P
22:18.47Mathoshow is the localization done for the class name coloring btw ?
22:18.54Mathoscause it seems messed up on his system
22:19.03Mathosdoes he need to set the Multilanguages manually ?
22:19.08MathosfrFR
22:20.49Mathosah, I am rambling
22:20.58Mathosno one is listening to me anyway :)
22:22.39Mathos*feels ignored and sniffs*
22:22.48Mathos*Mathos needs a hug*
22:22.58Adrici cant read half the text over the W logo on here
22:23.23Adric*hig*
22:23.26Mathosare you on a WAP machine?
22:23.30Adric*sp***hug*
22:23.36Adricwap?
22:23.47Mathosyeah, Internet on your mobile phone :)
22:23.53Adricthere is a w logo background on this chat
22:23.55Adricno
22:24.01Mathosah right
22:24.09MathosJust use an IRC client
22:24.12Mathosmuch better!
22:24.19Adricirc is to complicated though
22:24.19MathosX-chat is what I use
22:24.21Adriclol
22:24.36MathosNot if you only use 1% of the functionality as I do
22:24.52MathosZeryl uses 200% of the Functionality :P
22:25.09Zerylhuh?
22:25.18MathosWell, with the Bots and all
22:25.25Adricyou're a bot!
22:25.27Mathosand mr. ~apt
22:25.30Zerylhe's not mine
22:25.34Mathos~apt
22:25.35aptapt is, like, the Advanced Package Tool, an advanced frontend for dpkg and rpm (depending on your system).  APT is also known as the best package management system in existence today.
22:26.03MathosTBH....he is wrong
22:26.23MathosPortage and FreeBSD Ports are better!
22:26.38Mathoswell.....for me anyway
22:26.56Mathosokay peeps, one page to build (wanted to build 3 the least tonight) and to bed it is
22:27.26Mathosnext time IRC will just stay down untill I am done with the work lol
22:27.39Zerylhehe
22:27.58MathosZeryl, whacha think
22:28.05Zerylyes
22:28.13MathosItemcache, store the ID's including Suffixes or seperate them
22:28.26Mathoshow many will that be ?
22:28.40Mathoscause the lookup will be faster if I do it with the suffix
22:28.48Mathosbut the DB will also be bigger
22:28.52ZerylI say you build it like wow does
22:28.54Zeryla table of each
22:29.00Mathosokay
22:29.03Mathoswill do that then
22:29.10Mathosand join the tables if suffix > 0
22:29.20Mathosand exactly the same with the enchants
22:29.27Mathoswas going that way with enchants anyway
22:29.49Mathosonly my sql knowledge is horrible :P
22:30.03Zerylit should be easy for that
22:30.13Mathosyeah
22:30.19MathosJust need to do some readin
22:30.48MathosI am working on the Cache editor
22:31.01Mathosso DKP admins can administer the DKP cost
22:31.10Zerylselect a.*, b.* where a.itemnumber = xxxx and b.enchantnumber = xxxxx
22:31.22Mathosis anyone able to build a function like HoB_DKP for php ?
22:31.31Mathoscause that would ease the admins grandly
22:31.53MathosThe thing is already localized so should not really be a big issue
22:32.04MathosCould I bother you to do it Zeryl ?
22:32.09Mathosor you busy on other projects
22:32.10Zerylwhat?!
22:32.12Zeryllol
22:32.24Mathosyou are good with that stuff usually :P
22:32.30Zerylgoo with what? i'm confused
22:32.37MathosOkay, there is a wow addon
22:32.48Mathosthat gives us DKP's for items
22:32.53Mathosit is based on stats
22:32.57Zerylok
22:33.12Mathosit would be cool to be able to base the itemcache initial values on that as well
22:33.19Zerylohhh
22:33.20Zerylhrmm
22:33.27ZerylI can look at it, see what I cand o
22:33.33Mathosgrand mate
22:33.38Anaxooo itemcache talk again
22:33.47Mathosnot that I am lazy, I just can not focus on it atm
22:33.51Anaxhows the DB conversion going for you Zeryl
22:34.01Zerylwhat?
22:34.17Zeryli'm not doing anythign w/ my itemcache anymore
22:34.37Anaxat one time you were working on taking itemstats itemDB and was going to maybe make it usefull to us in some way
22:34.38MathosOh Zanix/Zeryl, Anax mentioned it might be usefull to get an itemdb on wowroster.net
22:35.32Mathosso we can actually do much easier itemcaches in OUR format instead of silly allakhazam's
22:35.51Mathoswhat say you ?
22:35.54AnaxI see that an Item DB would be awsome but to get new items added for all of the user qureying alla and thott could be an isse in the end so if we were to go down the route in having an item DB for roster it would make sence to host our own itemDB
22:36.00Zeryli would need 1000% more help on it
22:36.10MathosWell
22:36.12Zerylwait
22:36.14MathosI am up for it
22:36.15ZerylI think i deleted all my work
22:36.19Mathosdont matter
22:36.20Anax.......
22:36.21ZanixNEVER!!!!
22:36.27MathosOh.....:(
22:36.32Zanixi dunno
22:36.34MathosThe boss has spoken
22:36.35Zeryli'll check in a few
22:36.37Zanixi just like saying that in caps
22:36.43Anaxlol
22:36.45MathosI got a pretty good framework here
22:37.03Mathosif you guys get me a DB to work with, I can build it from here
22:37.14Mathosor I can start here
22:37.25Mathosand we shove it to the wowroster site later
22:37.25Zeryli didn't delete it, your in luck
22:37.30Mathosah cool
22:37.34Mathoscan you mail me ?
22:37.38Mathosmathos@fantasyworld.nl
22:37.50MathosI hope all bots listening got my email too :P
22:37.58MathosI wanna test my spam filters here :)
22:38.13MathosOh right, which reminds me
22:38.19Mathossince I am on dynamic IP
22:38.32MathosI got some Non-delivery  reports saying I am on DHCP
22:38.37MathosYeah...SO WHAT
22:38.39Mathos:P
22:38.59MathosSo I need to config my mailserver now to send it to my ISP's smtp *mumbles*
22:39.41Mathosthat is the downside of being on DHCP I guess
22:40.00MathosAnax, did you ever try phpUniUploader ?
22:40.09Mathoscause you never sent me those cookie requirements
22:40.19MathosI have it installed on a MAC now too
22:40.23Mathosworks brilliant
22:40.35Anaxsorry I havnt tried the php version yet as I put the uu on hold until I could work out cookie handling
22:40.48Anaxbut instead found a work around by modding a core DF file
22:40.59Anaxnow that I know I can post with UU
22:41.01MathosYeah I noticed that discussion
22:41.13Zerylmathos: http://www.convictionofsuramar.com/woza/wowdb.rar
22:41.16AnaxI should now tryusing the other version of UU including the PhP version
22:41.36Mathosoki got it thanks
22:41.41Zerylyou'll have to build a sql table though, but should be easy to see in the code where it's trying to insert
22:41.51Mathosyeah, no probs
22:42.08Mathosall I really need to know is what languages Allkhazam supportw
22:42.14Zerylall of them
22:42.21MathosThey do humm....
22:42.26Mathosthat will be a massive DB then
22:42.31Adricthey support D'ni?
22:42.39Zerylhttp://www.sourcepeek.com/wiki/Category:World_of_Warcraft
22:42.43Zerylthat will help you a ton mathos
22:43.05Anaxwhat would be better in the end to have a sql item db or xml
22:43.40MathosSQL
22:44.01Zeryla nice xml feed would be better
22:44.18Mathosnaturally, to feed to clients
22:44.27Zeryl<item><slot>head</slot><armor>80</armor>etcetcetc
22:44.29Mathosbut the stuff must be contained here in sql no ?
22:44.38Zerylya, definetly sql
22:44.47Mathosokay, that is a good idea btw Zeryl
22:44.58Zerylnow, the big thing with all this mathos
22:45.01Mathosstore it like that and we can just build up the tooltips localized
22:45.08Zerylis that you also need a dbctocsv converter, which you can find on curse-gaming
22:45.17Mathosyeah, cant do any of that
22:45.19Zeryland you are gonna have fun making the probably 40-50 tables
22:45.25MathosI am on linux
22:45.29Zerylwine :)
22:45.35Mathosnah
22:45.42Mathosthose tools are often written in .NET
22:45.47MathosMS.NEt
22:45.57Zeryldunno about this one, lol, but probably
22:46.04Mathosand even if I could, I would not install .NET on my system!
22:46.07ZerylI know the wdbtocsv one has a linux counterpart
22:46.34Mathosyeah, I am not really gonna dig through them DB files
22:46.48MathosI am thinking of plundering Allakhazam
22:47.13Zerylwell
22:47.16Zerylyou could
22:47.22Zerylbut writing enough regex for al that will kill you
22:47.29Mathoshehe
22:47.35MathosI got the regex already done
22:47.42Mathosall I need now is Item ID's
22:48.01Mathosan itemid a day, takes my breath away
22:48.01Zerylyour not going to parse it all out NICELY?
22:48.25Zeryli would rather have it as <agility>0</agility><stamina>0</stamina> etcetc
22:48.35MathosI can do that
22:48.54Mathosjust strip the tooltip
22:49.02ZanixMathos , Zeryl , Anax, PleegWat
22:49.07Zerylyes zanix
22:49.12Mathosyes Boss
22:49.21Zanixhttp://www.wowroster.net/Forums/viewtopic/p=5906.html#5906
22:49.26Zanixabout that one site
22:49.28ZerylMathos: I mean in the DB, have rows for each, and a row for "modifier" so things like "+66 ap to undead"
22:49.44Mathosyeah, that will be text
22:50.06Zeryllooks good zanix
22:50.33MathosHmmm
22:50.41MathosZanix, will we get paid for it? :P
22:51.00Zanixhe said he will kick some over in donations
22:51.09Zanixbut we wont get paid for it
22:51.26Mathosokay cool with me then
22:51.34Zanixits a long topic, have you read it all?
22:51.40Mathosyes
22:51.43Zanixah, ok
22:51.45Mathosjust now though
22:52.04Zanixlol
22:52.06Zanixthought so
22:52.06MathosOh crap
22:52.11Mathosanother page lol
22:52.32Zanixrofl
22:52.36Zanixyeah, its 2 pages
22:52.38Mathosyour comment is the most important one no
22:52.57MathosI agree to that fully
22:53.04Mathoswho pays for wowroster
22:53.08Mathosis that matt still ?
22:53.14Zerylya
22:53.17ZerylAFAIK
22:53.26Zanixyep
22:53.31Mathosokay, let him get the funding as far as I am concerned
22:53.36Zanixsame here
22:53.45Zanixi have a donate module for DF
22:53.57MathosCool
22:54.00Zanixits not active, but all i need is matt to set it up for his paypal account
22:54.16Mathosmight just put that on the front page with BIG letters :P
22:54.22Mathosand even maybe in the roster footers
22:54.59Mathosand we might want to get rid of the links in the credits to the guys who originally created roster
22:55.07Zanixwell, log in as admin on the site, and you can see it yourself
22:55.18Mathosnames are cool, but as I can recall there was a virus incident not that long ago
22:55.24Zanixyeah, thats fixed
22:55.27Mathosah cool
22:55.34Zanixi think
22:56.12Mathosis Calvin cool with his email being there btw ?
22:56.18Zanixmathos, did I show you the slightly redesigned realmstatus?
22:56.25Zanixhe hasnt said anything
22:56.55Zanixhttp://cvsroster.homeip.net/trunk/credits.php
22:57.04Zanixi actually changed it to point to his site
22:58.36AnaxZanix the post looks good so we will allow him to do it he just needs to make some corrections then
22:58.58Mathoslooks nice
22:59.02Zanixok, im gonna wait for anthony and seleth to respond as well
22:59.02Mathoswhat is that font btw ?
22:59.06MathosI saw you talking bout it
22:59.07Zanixwhich one
22:59.14Zanix3 fonts
22:59.15MathosRealm status
22:59.16AnaxI still think that what he is doing wowroster,net should offer as well
22:59.18Mathosah lol
22:59.27Anaxand I know we are not ready for it but it is a great idea
22:59.41Zanixyes, it is
22:59.51Zanixsoon anax, soon we will rule them all
23:00.03MathosWell.....we might Anax, but remember that support must be high.....and not that we do a bad job sofar
23:00.17Mathosbut it will be more of a schedule then
23:00.19Anaxlol and you being able to make a bit of extra doe could keep the wiffy off of ur ass if she is
23:00.29Mathoshaha
23:00.51Anaxi know mine gets on my ass everytime I make a bline to the cpu
23:00.54Mathoswell, she sometimes is, but I doubt we could make extra doe with this, perhaps just enough to get the servers going
23:01.14Mathosand that is not what makes her smile :P
23:01.36Mathosbut hey, if you guys wanna do it, I stand behind it
23:01.39Anaxlol right
23:01.59Mathosbut would we then say NO to the guy ?
23:02.06Mathoscause he will be our competitor
23:02.13Anaxwell when you are all ready for something like this I do have a plan of action
23:02.43Mathosokay, can you post it ?
23:03.03Anaxwe have 10k + users at wowroster.net I dont really htink he would be to much compitition as he will also be letting everyone know that this is free to download at wowroster.net
23:03.04Mathoscause I think we really should think something like that over
23:03.37AnaxI will make a post about it as I think it will be very easy to get done
23:03.41Mathosokay, that is true....but are all of those 10k users actually still using wowroster
23:03.58Anaxusing skeleton packages that would install to doamins based off of plan
23:04.02Mathosand how many will make a swap to pay for it
23:04.42MathosWell, programming is my life really, besides the wife naturally :P
23:04.46Anaxtrue but more and more users visit everyday and want what is going on here but have troubles
23:05.04Anaxthe users wouldnt need any kind of full access to the account i wouldnt think
23:05.19Anaxlike ftp and such if done correctly
23:05.25MathosNope, but there are other things to consider
23:05.39MathosDB crashes, availability KPI's
23:05.39Anaxand we could even use symlinks to share files with in all the clients accoutns
23:05.56Anaxright
23:06.22MathosAnd I think though that Roster as it is is not ready for it
23:06.31Mathoswe really need to have a very stable itemcache
23:06.39Mathoscause that is what will kill us otherwise
23:06.41Anaxthe systemn that I use is plesk and it has a module called watch dog that will email the admin of any account status changes like apache going down and such
23:07.08Mathoshehe, I am in Network and Service Level management
23:07.23Mathosdont worry, I can monitor stuff like that easily
23:07.33MathosI could even make it a demo for our customers to see :)
23:07.35*** join/#wowroster ianitor (i=CPGMembe@e178130085.adsl.alicedsl.de)
23:08.01ianitorhi .. i´ve a question about siggin
23:08.03MathosWould be cool though to have something like this
23:08.26Mathoscan we discuss this in a different channel perhaps btw guys ?
23:08.52ianitoryaeh
23:09.03Mathoserr, talking to the others here Ianitor
23:09.10ianitoroh sry ^^
23:09.10Mathosbut mention what question you got
23:09.44ianitori´ve installt the roster and the siggen ... about it dosen´t work ...
23:09.54ianitorbut
23:09.58Mathoswhat is your Link
23:10.17ianitorhttp://zaran.uttx.net/darklords/
23:11.51Zanixso what part doeent work?
23:12.01MathosThe image ?http://zaran.uttx.net/darklords/addons/siggen/av.php? cannot be displayed, because it contains errors.
23:12.22ianitorit dosent create preview or main image
23:12.46Anaxis gd installed?
23:12.51Zanixopen addons/siggen/siggen.php
23:12.59Zanixfind this line
23:13.01Zanixini_set('track_errors',1);
23:13.09Zanixreplace with this
23:13.13Zanix<PROTECTED>
23:16.45MathosThere ya go!
23:16.48ianitorthx i works
23:16.49Mathos:)
23:16.53ianitorit
23:17.10ianitorbig thx
23:17.22ianitorand cya and thanks fpr helping
23:17.40Anaxso Zanix what is it that you did
23:17.50Anaxand why would that create errors
23:18.00Zanixhis server has ini_set disabled
23:18.27Zanixwhich sucks, because thats how i redid my error reporting
23:18.32Anaxah so ini_set is a php function that would be enabled/disabled in the php.ini
23:18.36Zanixso if anything goes wrong
23:18.42Zanixyeah
23:18.47Mathoswell, they are screwed then :P
23:18.52Zerylif(ini_set('blabla')) (ini_set)
23:18.59Mathosjust do a : if_functionexists
23:19.03Mathosor whatever
23:19.05Anaxis there a way you could add a fail safe as when this happen switch to a diffrent error reporting setup
23:19.32MathosThat will be a pain, cause Zanix did it to make life easier :)
23:19.43Zerylalso, i'im going to start looking into TiDY
23:20.18Zanixi dont think yo ucan detect it this way
23:24.16Mathoswhere is ini_set determined ?
23:24.22Mathosit aint php.ini is it ?
23:24.32Mathosallow_ini_set or sommit ?
23:24.44Zanixim not sure
23:26.17Mathosit is webserver based
23:27.00MathosI think tis anyway
23:27.28Zanixcrap, upgrade.php is kinda broken
23:28.37Mathosoops
23:28.51Mathosanyway, I really need to catch some sleep folk
23:28.55Mathossee ya all tomorrow
23:29.34Anaxok gn AMthos
23:29.43Anaxkind of
23:29.47Anaxwhats up with it
23:36.13Anaxwowroster.net is timing out on me
23:37.43Zanixme too
23:38.07AnaxPinging wowroster.net [66.90.118.15] with 32 bytes of data:
23:38.07AnaxRequest timed out.
23:38.08AnaxPing statistics for 66.90.118.15:
23:38.10Anax<PROTECTED>
23:38.31Anaxlol irc is up though
23:42.14Zanixback up for you yet?
23:50.18Zanixah crap
23:50.22Anaxyes
23:50.31ZanixMatt Miller,
23:50.31ZanixYour ticket concerning 'restart server plz' has been responded to.  You can view
23:50.31Zanixthis response (and reply to it if necessary) using the link below(do not respond to this e-ma
23:50.43Zanixhttps://fdcservers.net/helpdesk/ticketview.php?cmd=view&id=4504A254&email=podunk.vn@gmail.com
23:51.05Anaxso he was just rebooting then
23:51.11Anaxcool nothing major
23:51.13Zanixsuppose so
23:51.21Anaxbut with the past i was a bit scared
23:51.23Anaxlol
23:52.21Zerylhrmmm

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.