| 01:00.25 | *** join/#wowroster Zeryl (i=Zeryl@75-132-127-218.dhcp.stls.mo.charter.com) |
| 01:00.25 | *** mode/#wowroster [+o Zeryl] by ChanServ |
| 01:00.54 | Zeryl | hi all |
| 02:51.42 | Zanix | hi |
| 02:58.28 | Zanix | anyone? |
| 03:13.18 | Zanix | no one? |
| 03:16.06 | *** join/#wowroster Zeryl (i=Zeryl@75-132-127-218.dhcp.stls.mo.charter.com) |
| 03:16.06 | *** mode/#wowroster [+o Zeryl] by ChanServ |
| 03:16.23 | Zanix | hi Zeryl |
| 03:16.30 | Zeryl | hi Zanic |
| 03:16.32 | Zeryl | Zanix* |
| 03:16.45 | PoloDude | hey guys |
| 03:16.48 | Zanix | hows it going |
| 03:16.51 | PoloDude | bye guys :p |
| 03:16.55 | Zeryl | hi bye |
| 03:17.00 | Zeryl | i'm good zanix, and you? |
| 03:17.03 | PoloDude | it's going bad, need to get up in 2h :p |
| 03:17.05 | Zanix | later polo |
| 03:17.12 | Zanix | ewww, that sucks |
| 03:17.14 | Zeryl | ohhhh |
| 03:17.17 | Zanix | im alright |
| 03:17.23 | PoloDude | ye, need to bring gf to school lol |
| 03:17.25 | Zeryl | i'm stayin up tonight too |
| 03:17.25 | Zanix | worked for 8 hours, :) |
| 03:17.30 | PoloDude | made a promise so |
| 03:17.34 | Zeryl | work sucks |
| 03:17.34 | Zanix | er, I mean :( |
| 03:17.49 | Zanix | im gonna be up all night |
| 03:17.50 | PoloDude | if i didn't have made that i would have slept till like 4pm :p |
| 03:17.54 | Zanix | working on my site |
| 03:18.22 | PoloDude | need to work on site too, ie6 still fucks up my design :( |
| 03:18.38 | PoloDude | fonts to big, and ah well other stuff |
| 03:18.41 | Zanix | ie7 is officially out tonight I believe |
| 03:18.45 | Zeryl | www.wowace.com/files |
| 03:18.49 | Zeryl | does that work for you guys? |
| 03:18.54 | PoloDude | to tired, must ... go ... bed ... |
| 03:18.58 | Zanix | lol |
| 03:18.59 | Zeryl | working now, nevermind |
| 03:19.08 | PoloDude | yups works Zeryl |
| 03:19.21 | Zanix | for me as well |
| 03:19.39 | PoloDude | ok well night guys :) hope i'll get betakey tomorrow ^^ |
| 03:19.48 | PoloDude | friend of mine has got one for me xD |
| 03:20.18 | PoloDude | once i have it i'll let you guys know :) |
| 03:20.33 | PoloDude | then you can also tell me what kind of info you need :) |
| 03:20.37 | PoloDude | well, cya |
| 03:28.42 | Zanix | that's gonna be nice |
| 03:28.51 | Zanix | so what are you up to tonight Zeryl? |
| 03:29.00 | Zeryl | nothing at all |
| 03:29.03 | Zeryl | being really bored |
| 04:00.54 | Zeryl | what about you? |
| 04:00.59 | Zeryl | oh, and i think i found a problem w/ UU |
| 04:01.07 | Zeryl | another one |
| 04:04.42 | *** join/#wowroster Guest255 (n=Guest@68-112-73-240.dhcp.jcsn.tn.charter.com) |
| 04:05.06 | Kayn | Sup everyone |
| 04:30.00 | Zanix | im gonna go get food |
| 04:30.18 | Zeryl | have fun |
| 04:30.33 | Zanix | ill try |
| 06:01.52 | *** join/#wowroster TinoM (n=Tino@i5387D188.versanet.de) |
| 06:01.52 | *** mode/#wowroster [+o TinoM] by ChanServ |
| 06:16.31 | *** join/#wowroster Vathral (i=nn@user-0cev143.cable.mindspring.com) |
| 06:48.19 | *** join/#wowroster PoloDude (n=PoloDude@d5152CB22.access.telenet.be) |
| 06:48.19 | *** mode/#wowroster [+v PoloDude] by ChanServ |
| 06:48.30 | PoloDude | gooooooood morning xD |
| 06:48.45 | PoloDude | damn that was a short night :/ |
| 06:49.32 | PoloDude | zanix? |
| 06:54.05 | Zanix | kinda |
| 06:55.49 | Zanix | playing wow |
| 06:58.08 | PoloDude | ah, you any idea how i can contact AnthonyB? |
| 06:58.24 | PoloDude | he on msn or so? he works at M$ right? |
| 06:59.12 | PoloDude | cause i wonder if he got a better idea what Enthusiast Evangelist actually is :) |
| 07:02.28 | Zanix | yeah |
| 07:03.13 | Zanix | anthony_bennet@hotmail.com |
| 07:09.46 | PleegWat | hi |
| 07:11.15 | PoloDude | thx :) |
| 07:12.08 | PoloDude | is he online now btw? :p |
| 07:12.12 | PoloDude | and hi PleegWat :) |
| 07:17.16 | PleegWat | Hm, I should look into getting those guildbanks to work again |
| 07:19.05 | PleegWat | Weird thing is, I changed the DB format so I'd expect SQL errors, but I get flow errors |
| 07:22.27 | PleegWat | Hm, does calvin have TBC beta access? If he does we might get a cp.lua from his tbc branch, that should be enough to get the roster adapted |
| 07:30.04 | Anaxent | hey guys hows it going |
| 07:30.49 | Anaxent | so Zanix what would it take to add a new feture to UA for addon dependancies |
| 07:30.50 | Zanix | no he isnt |
| 07:31.00 | Zanix | i dunno |
| 07:31.28 | Zanix | to both pleeg and anax |
| 07:31.47 | PleegWat | hi zanix |
| 07:31.51 | PleegWat | hi anax |
| 07:31.51 | Zanix | hey |
| 07:32.00 | Anaxent | Hi PleegWat |
| 07:32.49 | Anaxent | i was just playing wow with my GF she is now a 35 warrior and i have my lock uptp 36 now |
| 07:33.07 | Zanix | sweet |
| 07:33.21 | Zanix | so, dependant addons huh? |
| 07:33.26 | PleegWat | Did I ever mention I hate the DB wrapper sometimes? Like when a $result=false isn't caught by the using code? |
| 07:33.41 | Zanix | no kidding |
| 07:33.54 | Anaxent | i know we have required addons but say titan bar ot ct |
| 07:34.12 | Anaxent | there are other addons made for them that require the main addon |
| 07:34.44 | Anaxent | so if i were to install this addon it would let me know that i need to install this other one with it |
| 07:35.47 | Anaxent | as well as i would like to see if matt can add a description to the UA/UU so when in UU and oyu were to set an addon to be updated you can see a small desc of what it does |
| 07:37.51 | PleegWat | OK because of the db changes you can't determine guild bank by character name |
| 07:38.07 | PleegWat | since the char name is in a different table and catching that is too much work |
| 07:38.22 | Anaxent | addon #1 , addon #2 and 3 depends on adddon #1; so if you were to install/update addon #2 or 3 UU would tell you that ! is required |
| 07:38.43 | PoloDude | addons work like a charm for |
| 07:38.44 | PoloDude | me |
| 07:38.54 | Anaxent | so if you cant get the guild bank name how do you get guild bank data |
| 07:39.29 | PoloDude | probably not lol |
| 07:39.50 | PleegWat | WHY DO I GET THE USELESS WOWDB ERRORS |
| 07:40.18 | PleegWat | http://leegwater-68.demon.nl/RosterSVN/roster1x/branches/adminpanel/guildbank.php both print_r()s are parameter sets to die_quietly |
| 07:40.27 | PleegWat | first one in both is a wowdb error, or supposed to be |
| 07:40.38 | Anaxent | what did it say , drop all tables remove all files reupload all files then go back to stepo #1? |
| 07:41.16 | PleegWat | Everything is linked on member ID |
| 07:41.30 | PleegWat | The name@server is only stored in the character table |
| 07:41.43 | PleegWat | So if you need to specify that you need to join in that |
| 07:41.47 | PleegWat | Which I'm already doing |
| 07:49.34 | Zanix | sorry, i was in wow |
| 07:50.43 | PleegWat | There, bank1 works |
| 07:51.40 | PleegWat | If we set up coding standards, can they include 'use explicit inner/outer joins rather than commas and conditions in where'? |
| 07:53.24 | Anaxent | yes i think now would be the best time to strat working up a model of code standards |
| 07:53.35 | Anaxent | for both roster as welll as addons |
| 07:54.59 | PleegWat | $mulemoney = $wowdb->fetch_array($wowdb->query( PLEASE NEVER DO THIS |
| 07:55.51 | PleegWat | anyway bank2 works too now |
| 07:56.57 | Anaxent | is cat bank going to be included into roster or staying as an addon |
| 07:59.34 | PleegWat | addon |
| 07:59.57 | PleegWat | could the author of catgb please just die on error instead of echoing the wowdberror and returning |
| 08:00.21 | PoloDude | ask matheos, he did that no? |
| 08:03.48 | Zanix | lol |
| 08:03.54 | Zanix | sweet |
| 08:04.01 | PoloDude | what? |
| 08:04.14 | Zanix | yeah, cat gbank is mathos |
| 08:05.11 | PleegWat | Why the hell do all queries inside die_quietly fail |
| 08:07.24 | Zanix | that reminds me, id like to steal this - http://wiki.nexoscms.org/index.php/Coding_Standards |
| 08:07.31 | Zanix | well, if their site was up |
| 08:07.55 | Zanix | i dunno |
| 08:08.02 | Zanix | maybe we need a "real" db layer |
| 08:08.18 | Zanix | and not include all that sql stuff in wowdb |
| 08:08.40 | PoloDude | fun i'm running in rare spawns |
| 08:08.46 | PoloDude | second in one day lol |
| 08:09.57 | Zanix | i saw one in sunken temple |
| 08:10.30 | PoloDude | lvl 23 though |
| 08:10.42 | PoloDude | hope me and my pet will be able to handle it :p |
| 08:10.47 | Zanix | fun stuff |
| 08:11.04 | PleegWat | Yeah, I've been thinking we could have a new class roster_query or wowdb_query or so |
| 08:11.15 | PleegWat | and do like $result = new wowdb_query($query) |
| 08:11.30 | PleegWat | And then the class can do the dying if the calling page doesn't |
| 08:11.52 | PoloDude | bugger, 65% and dead :p |
| 08:17.03 | Zanix | yeah |
| 08:17.06 | Zanix | that would be nice |
| 08:17.41 | PleegWat | Well I fixed the double die |
| 08:17.55 | PleegWat | The menu include in die_quietly was after closing the DB |
| 08:20.17 | Zanix | ah, that could of done it :p |
| 08:20.21 | Zanix | lol |
| 08:20.30 | Zanix | i hate missing stuff like that |
| 08:22.09 | PleegWat | Anyway why are we storing gold, silver, copper as seperate variables everywhere? |
| 08:23.23 | PleegWat | http://leegwater-68.demon.nl/RosterSVN/roster1x/branches/adminpanel/addon.php?dbname=guildbank It loads, but there's still an error sometimes |
| 08:23.41 | PleegWat | All quanitites are multiplied by 284 |
| 08:24.06 | PleegWat | But I think mathos gets to solve that one |
| 08:24.13 | Zanix | lol |
| 08:24.32 | Zanix | i dunno about the money thing |
| 08:24.40 | Zanix | thats how it was back to version 1.03 |
| 08:24.53 | PleegWat | I think it's along the lines of 'because CP stores it like that' |
| 08:25.01 | PleegWat | which is a stupid reason |
| 08:25.07 | PleegWat | I know the item cache stores it in coppers |
| 08:25.16 | PleegWat | So presumably blizzard stores everything in coppers |
| 08:25.21 | PleegWat | which is logical. |
| 08:25.53 | Zanix | i sould think so |
| 08:26.11 | Zanix | i do know that the mail table stores it in coppers |
| 08:26.30 | PleegWat | There, committed |
| 08:27.39 | PleegWat | I think next up I'll go work on page scopes. A page's scope is gonna define what menu it shows. |
| 08:27.59 | Zanix | luck |
| 08:29.11 | PleegWat | guild, char_collect, player_collect, player |
| 08:29.23 | PleegWat | realm too, probably |
| 08:29.41 | PleegWat | team once we've got the data on those |
| 08:30.37 | PleegWat | Well, I'm going off. Need to go to the dentist in half an hour and haven't breakfasted yet. |
| 08:31.13 | Zanix | have fun :s |
| 09:54.24 | PleegWat | hi |
| 09:57.25 | Zanix | hi again |
| 09:59.47 | PleegWat | What I've been thinking for the multiguild support |
| 10:00.47 | PleegWat | We could have a couple of scopes for pages, have them set it on an object, then let the object return, based on scope and the parameters of the page, the FROM and WHERE clasues for SQL calls. |
| 10:03.09 | PleegWat | So if I'd call the memberslist page with ?realm=aggramar, the realms page could set the scope to char_collect (collection of characters with or without player data), and the scope object could then return the FROM clause merging characters LEFT JOIN players LEFT JOIN members, and the WHERE clause with `characters`.`server` = 'aggramar' |
| 10:17.52 | Zanix | ok |
| 10:25.32 | Zanix | sounds good |
| 11:23.19 | PleegWat | Hm, what name for this one |
| 11:23.24 | PleegWat | Long names are annoying |
| 11:23.32 | PleegWat | Short ones are risky cause they may get reused |
| 11:33.40 | Zanix | what one |
| 11:33.48 | PleegWat | the scope class |
| 11:33.56 | PleegWat | roster_scope feels too long |
| 11:34.21 | Zanix | feels just fine for me |
| 11:36.33 | PleegWat | Should I include the keywords in the FROM and WHERE returns? |
| 11:37.06 | PleegWat | I'm thinking include it in the FROM cause you need to have all except the first one with merge conditions, so any extra tables need merge conditions |
| 11:37.17 | PleegWat | But omit it in the WHERE cause that gives more flexibility |
| 11:38.04 | Zanix | im not sure |
| 11:47.08 | PleegWat | Hm, how to handle. I've made the guild and player scopes. The char_collect and player_collect ones need a bit more work cause they are valid in guild, realm, and in the future team scope |
| 11:47.47 | PleegWat | If I include guild, team, realm in the join and they aren't referenced I don't know if the query optimizer will remove them |
| 13:05.44 | Zanix | grrr |
| 13:05.58 | Zanix | im trying to re-learn alt monitor |
| 13:25.47 | PleegWat | ? |
| 13:26.39 | PleegWat | I've stopped actively working on AltMonitor |
| 13:27.08 | PleegWat | Dunno how I'm gonna handle it in 1.8 yet. Probably a 'other chars on this account' link in the character page, or as menu left pane |
| 13:27.34 | PoloDude | i dunno why but most of my guildies uu don't seem to upload :( |
| 13:29.54 | Zanix | that sucks |
| 13:30.50 | PleegWat | Mine works fine. Char and guild uploads, 1.7.1 and 1.8.0 |
| 13:32.32 | PleegWat | AB isn't going to well today. 2 chanceless losses so far, no wins. |
| 13:38.32 | Zanix | mmm |
| 13:38.40 | Zanix | well, i am using wowrosterdf |
| 13:49.34 | Zanix | that could be part of the problem |
| 14:23.08 | PleegWat | heh |
| 14:23.19 | PleegWat | I didn't have the ported versions in mind when writing altmonitor |
| 14:28.55 | PleegWat | Damn. I forgot to add faction to the character table |
| 14:31.16 | Zanix | lol |
| 14:31.20 | Zanix | it's ok |
| 14:31.51 | Zanix | ive already had to fix alot of mistakes in anaxents port |
| 14:32.40 | PleegWat | BTW on the update script, if you ever feel like reoranizing it part of the order is there witha reason |
| 14:33.14 | PleegWat | Like first create the new field, then move the data over, then drop the old field. And only call ALTER TABLE once per table |
| 14:34.47 | PleegWat | Ow, we store faction as full string? Was expecting first letter |
| 14:44.48 | PleegWat | There. Next step: Putting in the realm table |
| 14:46.51 | Zanix | fun |
| 14:46.56 | Zanix | i feel so sick |
| 14:47.00 | Zanix | 8:45am |
| 14:47.05 | Zanix | been working on my site |
| 14:47.12 | PleegWat | CREATE TABLE `renprefix_realms` ( |
| 14:47.12 | PleegWat | `realm_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, |
| 14:47.12 | PleegWat | `name` varchar(32) NOT NULL, |
| 14:47.12 | PleegWat | PRIMARY KEY (`realm_id`), |
| 14:47.12 | PleegWat | UNIQUE KEY `realm_name` (`name`) |
| 14:47.12 | PleegWat | ) TYPE=MyISAM |
| 14:47.17 | PleegWat | Isn't really anything else I think |
| 14:47.24 | Zanix | EU, US ? |
| 14:47.28 | PleegWat | CP doesn't fetch anything on realm level |
| 14:47.36 | PleegWat | You wanna manually determine that? |
| 14:47.42 | Zanix | we could |
| 14:48.03 | PleegWat | Have ppl specify it on upload or something? |
| 14:48.17 | PleegWat | I'd rather limit to one of them |
| 14:49.22 | PleegWat | We could put in PvE/PvP/RP/RP-PvP. If we want to extract it from the realmstatus page |
| 14:49.41 | PleegWat | PvE is called Normal in US |
| 14:52.03 | PleegWat | Might be easier to just use realm names and forget about a realm table |
| 14:53.33 | PleegWat | Well, actually we have to store the serverstatus name somewhere, and config isn't usable for that in a multiguild situation |
| 14:53.38 | PleegWat | multirealm I mena |
| 14:53.40 | PleegWat | *mean |
| 15:02.00 | Zanix | maybe... |
| 15:02.13 | Zanix | i wish there was a way to get the server group though |
| 15:02.47 | PleegWat | Well, when I asked on the UI forums they suggested using the timezone |
| 15:02.53 | PleegWat | but I don't think CP fetches that |
| 15:02.55 | Zanix | also, if we have a realms table, we could possibly store the realmstatus info there as well |
| 15:03.06 | Zanix | i dont think it does wither |
| 15:03.09 | Zanix | *either |
| 15:03.19 | PleegWat | We could ask calvin to add it though |
| 15:03.33 | PleegWat | Appearantly you can get the UTC time and the server time from the LUA |
| 15:03.37 | PleegWat | The difference is the timezon |
| 15:03.43 | PleegWat | s/timezon/timezone/ |
| 15:04.19 | PleegWat | EU always has timezone UTC+1, with daylight savings time |
| 15:04.33 | Zanix | that might just work |
| 15:04.52 | PleegWat | Anywhere else you can use client language |
| 15:09.32 | PleegWat | Cause enUS is the only language that occurs in multiple regions |
| 15:10.34 | Zanix | well, guild may be nice |
| 15:10.51 | PleegWat | whaddaya mean |
| 15:10.51 | Zanix | so we can get the locale of who scanned the guild info |
| 15:11.02 | Zanix | GuildProfiler does store it |
| 15:11.07 | PleegWat | I'm not following |
| 15:11.30 | Zanix | the guild list |
| 15:12.23 | Zanix | I mean, it would be nice to grab the locale that the guildinfo/memberlist that GuildProfiler gathers |
| 15:12.38 | PleegWat | We don't have localized stuff in there do we |
| 15:12.45 | PleegWat | or are classnames localized? |
| 15:12.45 | Zanix | im not sure |
| 15:12.50 | Zanix | they are |
| 15:13.13 | Zanix | then we wont have to manually set a locale in config either |
| 15:13.32 | PleegWat | yeah |
| 15:13.49 | Zanix | Gp does get the locale, I just checked |
| 15:18.48 | PleegWat | I don't see how this helps. The locale can be stored on realm level. But what we capture is client locale, not server locale |
| 15:19.09 | PleegWat | I can take my enUS (european) client, and connect to a german or french server, and store data of that |
| 15:19.13 | PleegWat | I can put that on a roster |
| 15:19.34 | PleegWat | All locale settings in my CP would still indicate enUS even though it's a german or french server |
| 15:19.55 | Zanix | true |
| 15:20.55 | PleegWat | The locale is only useful to filter out chinese and korean clients, since those only work on chinese and korean servers respectively |
| 15:20.59 | *** join/#wowroster TinoM| (n=Tino@i5387D188.versanet.de) |
| 15:21.26 | PleegWat | hi sphinx |
| 15:24.01 | PleegWat | I'd prefer if we could get blizzard to supply the server's region, language, and type ingame. And spell server name identically ingame and on serverstatus. But that's on the level of 'keep dreaming' |
| 15:26.11 | Zanix | no kidding |
| 15:30.02 | PleegWat | I don't think blizzard ever expected profiling sites and packages like us to appear |
| 15:30.16 | PleegWat | They certainly didn't accomodate for it |
| 15:34.26 | PleegWat | More keep dreaming |
| 15:49.32 | *** join/#wowroster Ducky1231 (n=Matt@host86-137-148-86.range86-137.btcentralplus.com) |
| 15:49.47 | Ducky1231 | Hello!! :P |
| 15:53.02 | *** join/#wowroster Vathral (n=nn@po.bmcc.cuny.edu) |
| 16:09.27 | Zanix | well, im going to sleep |
| 16:09.30 | Zanix | later |
| 19:32.47 | *** join/#wowroster PleegWat (i=PleegWat@leegwater-68.demon.nl) |
| 19:32.47 | *** mode/#wowroster [+o PleegWat] by ChanServ |
| 21:14.30 | *** join/#wowroster Vathral (i=nn@user-0cev143.cable.mindspring.com) |