00:15.09 | Anaxent | your guild? |
00:15.15 | Zeryl | yep |
00:15.20 | Anaxent | its going good I have been training 3 new techs today |
00:15.29 | Anaxent | yeah makes me wonder about mine as well |
00:15.31 | Zeryl | cool, more tech support ;P |
00:15.38 | Anaxent | we have alot of peeps but not many raid |
00:15.55 | Anaxent | and not many use our site nor the features |
00:16.03 | Zeryl | ya, i know :( |
00:16.20 | Anaxent | i still think we should make our own wowroster.net guild |
00:16.25 | Zeryl | hehe |
00:16.28 | Anaxent | lol |
00:16.30 | Zeryl | i don't wanna re-roll :( |
00:16.45 | Anaxent | i know and I couldnt get my gf to do it either |
00:17.02 | Anaxent | and if she wont I cant play much....sigh |
00:17.10 | Zeryl | so she does play? |
00:17.15 | Anaxent | yes |
00:17.20 | Zeryl | awesome :P |
00:17.29 | Anaxent | she just hit 41 on a warrior |
00:17.38 | Anaxent | she had a 43 hunter on a pve server |
00:18.03 | Anaxent | until i made a switch back to Ner'Zhul pvp server where I started playing on day one |
00:32.41 | Anaxent | Zanix u awake |
00:32.50 | Anaxent | Zeryl take alook at wowroster.net |
00:32.56 | Anaxent | does it look right too you |
00:33.40 | Zeryl | lol, no |
00:33.46 | Zeryl | the bottom image of the blocks on the left is screwed up |
00:34.06 | Zeryl | <td class="tbll"><img src="themes/wsg_Cardinal/images/forums/spacer.gif" alt="" height="4" width="8"></td> |
00:34.06 | Zeryl | <td class="tblbot"><img src="themes/wsg_Cardinal/images/forums/spacer.gif" alt="" height="4" width="8"></td> |
00:34.06 | Zeryl | <td class="tblr"><img src="themes/wsg_Cardinal/images/forums/spacer.gif" alt="" height="4" width="8"></td> |
00:34.50 | Anaxent | it wasnt like that this afternoon |
00:36.56 | Warla | anaxent |
00:37.00 | Zanix|away | i am...but im leaving to get food |
00:37.01 | Anaxent | yes? |
00:37.22 | Anaxent | so did you make an update to wowroster.net by chance Zanix|away |
00:37.24 | Warla | is it possible to setup a second set of SQL database? so i can have 1 from regular wow |
00:37.29 | Warla | and the second on where i can test BC |
00:37.32 | Warla | i updated my mod |
00:37.40 | Warla | and its BC compatible now |
00:37.47 | Zanix|away | not that I know of |
00:37.49 | Anaxent | sure you have access to do it all man |
00:37.50 | Warla | http://darky28.dyndns.org/chris/wowprofiles/index.php?id=1 |
00:37.58 | Anaxent | let me pm u the server deatils for plesk |
00:37.59 | Warla | ok plex? |
00:38.03 | Warla | k |
00:38.56 | Zanix|away | no, i didnt change anything |
00:39.21 | Anaxent | huh... |
00:39.28 | Anaxent | well the site now looks wierd |
00:39.56 | Zanix|away | just on the home page |
00:40.20 | Anaxent | right just there |
00:40.43 | Zanix|away | everywhere else looks ok |
00:41.28 | Anaxent | it could be from the looty bank upload then |
00:41.35 | Anaxent | with the review that is posted with it |
00:41.51 | Anaxent | could be in a div or table that is not closed right im guessing |
00:42.31 | Zanix|away | yeah, i was thinking that |
00:43.39 | Zanix|away | its the quote box |
00:44.36 | Zanix|away | look now |
00:45.17 | Zanix|away | ok, im gonna go now |
00:45.19 | Zanix|away | brb |
00:45.19 | Anaxent | cool back to narmal |
00:45.25 | Anaxent | ok |
00:45.34 | Anaxent | Warla did that help you |
00:49.32 | Warla | ya :-) |
00:49.38 | Warla | i think i got it |
01:04.44 | Anaxent | cool let me know if there is anything you need |
01:04.58 | Anaxent | and did you notice the help desk option in the bottom of the menu |
01:05.05 | Anaxent | it will send me an email |
01:26.24 | Warla | k :-) |
01:33.39 | Anaxent | so Warla whay does it take sooo long to load your profiler |
01:35.47 | Zanix | because almost all the data has to load first |
01:36.55 | Zanix | and isn't this his personal server? |
01:36.55 | Zanix | http://darky28.dyndns.org/chris/wowprofiles/index.php?id=1 |
01:36.59 | Zanix | on his laptop? |
01:37.04 | Anaxent | that is but he also has it on my server |
01:37.12 | Anaxent | http://www.wowledgebase.com/?id=1 |
01:37.19 | Anaxent | makes me wonder |
01:37.34 | Anaxent | your site pulls up fast and so does mine |
01:37.46 | Zanix | are we all on the same vps? |
01:38.08 | Anaxent | I know his labtop is a turtle to the net for us |
01:38.12 | Anaxent | yes we are |
01:40.21 | Zanix | well, then my last statement may be true, it's alot of data for the browser to process and download |
01:41.10 | Zanix | it does ahve quite a few html errors |
01:41.27 | Anaxent | and seems like alot of the css sytles is inline rather than external |
01:41.28 | Zanix | 1831 warnings |
01:41.32 | Zanix | that too |
01:42.34 | Zanix | and its all done in tables as well |
01:42.54 | Zanix | and the entire table has to download before a browser will render it |
01:43.28 | Anaxent | i see and that is where div has advantages right? |
01:43.48 | Zeryl | i think so |
01:43.56 | Zanix | right |
01:44.48 | Zanix | this is why I converted his first version of the character pages in the current implementation of R2 in to divs |
01:45.24 | Zanix | i think mine loads much faster |
01:45.28 | Zanix | http://cvsroster.homeip.net/roster2x/trunk/?p=char&member=86 |
01:45.53 | Zeryl | move that to another server to test that |
01:46.09 | Zanix | move what? mine? |
01:46.30 | Zeryl | ya |
01:47.30 | Zanix | true |
01:48.29 | Anaxent | move it to our vps |
03:10.26 | Anaxent | later guys |
03:10.33 | Anaxent | time to head home now |
05:00.37 | *** join/#wowroster Zeryl_ (i=Zeryl@75-132-127-218.dhcp.stls.mo.charter.com) |
05:21.49 | *** join/#wowroster Smaugie776 (n=chatzill@fullerton-cuda-2-70-37-65-52.lmdaca.adelphia.net) |
05:22.09 | Smaugie776 | Howdy, havin a weird error with UU.7.0, anyone around? |
05:26.54 | Smaugie776 | zanix? |
05:34.24 | Smaugie776 | havin a weird error with UU.7.0, anyone around? |
05:41.36 | Zanix | kinda |
05:41.39 | Zanix | im playing wow |
05:50.15 | Smaugie776 | oh. |
05:50.17 | Smaugie776 | still there? |
05:50.47 | Smaugie776 | when I try to upload addons in the uuadmin interface I get the following error |
05:51.17 | Smaugie776 | Parse error: syntax error, unexpected $end, expecting ']' in /home/.irish/*username*/*webaddress*/include/pclzip.lib.php on line 768 |
05:53.07 | Smaugie776 | i had this error with a version a ways back |
05:53.31 | Smaugie776 | some setting making it go to the site address rather than that host directory structure |
06:10.36 | Zanix | hmm |
06:11.00 | Zanix | looks like a corrupted upload |
06:11.08 | Zanix | of the php file, not the zip file |
06:12.12 | Smaugie776 | testing |
06:12.37 | Smaugie776 | damn |
06:12.39 | Smaugie776 | that was it |
06:12.41 | Smaugie776 | sorry |
06:14.27 | Zanix | it's ok |
06:14.47 | Zanix | is it working ok now |
06:15.02 | Smaugie776 | yea |
06:15.08 | Smaugie776 | working like a dream :) |
06:17.04 | Zanix | sweet |
06:19.35 | Smaugie776 | thanks again... later. |
07:12.39 | Warla | zanix |
07:12.41 | Warla | ya there? |
07:12.48 | Zanix | yeah, playing wow |
07:13.00 | Warla | i was wondering if you made the icons for the Draenei yet :-) |
07:13.10 | Warla | the ones for the profiler on top left corner the round ones |
07:26.59 | Zanix | No, not yet |
07:27.08 | Zanix | I dont have the beta data yet |
07:27.17 | Zanix | I used wowmodelviewer |
08:40.51 | Warla | i c |
08:41.00 | Warla | does modelviewer work with Beta? |
08:59.31 | Zanix | i dunno |
08:59.46 | Zanix | as I said, I don't have the beta to check |
10:39.29 | PleegWat | hi |
10:51.54 | Zanix | hiya |
10:52.06 | *** join/#wowroster Orphis (n=Orphis@sop06-1-82-228-251-21.fbx.proxad.net) |
10:52.09 | Zanix | what's up pleeg? |
10:52.26 | Zanix | hey, the svn timeline is back up |
10:53.52 | PleegWat | not much |
10:56.15 | Zanix | I cant belive this |
10:56.19 | PleegWat | ? |
10:56.29 | Zanix | http://www.wowroster.net/Forums/viewtopic/t=1809.html |
10:56.35 | Zanix | <PROTECTED> |
10:57.02 | Zanix | just a little while ago, I noticed the Roster:Updateing page was defaced in the wiki |
10:57.17 | Zanix | IP: 24.4.4.3 |
10:57.29 | Zanix | irritationg... |
10:57.35 | Zanix | and guess what? |
10:57.41 | Zanix | that guy's ip address |
10:57.45 | PleegWat | yeah |
10:57.46 | Zanix | ...the same |
10:57.49 | PleegWat | Now that you say it |
10:57.55 | PleegWat | BAN HIM! |
10:58.13 | PleegWat | Some users you're just better off without |
10:58.33 | Zanix | yeah |
10:58.57 | PleegWat | Haven't been keeping up with the wiki at all really |
11:00.10 | Zanix | I look in there to make sure it isn't wreaked |
11:00.18 | PleegWat | heh |
11:00.29 | Zanix | i like my post though |
11:00.31 | Zanix | "Edit: Also, next time you decide to deface the WiKi, use a different IP address, I know it was you..." |
11:00.43 | PleegWat | I know most of the trunk changes get documented in the wiki. |
11:00.54 | Zanix | yeah, I try to keep up on that |
11:00.59 | PleegWat | If I decide to document an aspect of 1.8 I usually add a file in the docs folder |
11:01.37 | Zanix | yeah, i saw that |
11:02.45 | Zanix | I also just fixed a display thing in Projects Pro |
11:02.59 | PleegWat | I really should do that login stuff in 1.8... |
11:03.00 | Zanix | in the admin section though |
11:03.07 | Zanix | hehe |
11:03.18 | Zanix | im trying to work on UniAdmin |
11:03.30 | Zanix | to get those bugs fixes and features in |
11:06.42 | PleegWat | 0203Mp3 Player02] Artist..::03Dr. Demento02::.. Title..::03The Funny Farm - They're Coming To Take Me Away02::.. Played..::033202::.. 02.0302UPP0302. |
11:07.03 | Zanix | hehe |
11:07.05 | Zanix | good one |
11:07.30 | PleegWat | I hijacked my sis's mp3 collection |
11:07.40 | PleegWat | Hardly have any myself |
11:10.27 | Zanix | ah |
11:10.32 | Zanix | mine is too big i think |
11:10.47 | Zanix | 4299 mp3s |
11:11.03 | PleegWat | 850 files in this one |
11:11.19 | PleegWat | But that includes album cover images her media player downloaded I think |
11:12.36 | PleegWat | hm, those aren't in there anymore. She must've cleaned it up. |
11:13.11 | PleegWat | Local FTP server on my sys. It was on my sys cause her needed a reformat. |
11:15.29 | Zanix | hmm, looks like the 2.0 PTR are out |
11:15.33 | Zanix | or will be very soon |
11:15.40 | Zanix | http://forums.worldofwarcraft.com/thread.html?topicId=36975623&sid=1 |
11:18.52 | Zanix | nice |
11:18.53 | Zanix | API Changes: Information |
11:18.58 | Zanix | * NEW GetSpellCritChance(school) |
11:27.02 | Zanix | that post is long |
11:48.34 | *** join/#wowroster Orphys (n=Orphis@sop06-1-82-228-251-21.fbx.proxad.net) |
12:08.48 | *** join/#wowroster Orphis (n=Orphis@sop06-1-82-228-251-21.fbx.proxad.net) |
12:31.08 | Zanix | hey pleeg |
12:31.11 | Zanix | still there? |
12:32.16 | Zanix | i want a better SQL query for gathering addons |
12:32.42 | Zanix | I want to grab the list of addons and get a count of how many files for that addon |
13:01.25 | Zanix | and we are down for 36 hours :( |
13:05.02 | PleegWat | hi |
13:05.26 | PleegWat | How do you mean how many files for that addon |
13:05.37 | PleegWat | luaUploader files? |
13:06.42 | Zanix | yeah |
13:06.49 | Zanix | addons are stored in one table |
13:07.03 | Zanix | and the file details are stored in another |
13:07.09 | Zanix | by addon id |
13:07.12 | Zanix | as the key |
13:07.52 | Zanix | I'd like to get the addon data and the number of files in one quick query |
13:08.11 | PleegWat | add a COUNT() and a join |
13:11.10 | Zanix | to the mysql manual! |
13:16.34 | PleegWat | You need to join in the table with the files, in a left join |
13:17.07 | PleegWat | add the COUNT() of the primary key of the table of files to the fields you're SELECTing |
13:17.18 | PleegWat | and add all fields in the first table to the GROUP BY clause |
13:17.33 | PleegWat | or just its primary key. NOt sure. |
13:24.16 | Zanix | SELECT `a`.* COUNT(`f`.`addon_id`) FROM `uniadmin_addons` a LEFT JOIN `uniadmin_files` f ON `a`.`id` = `f`.`addon_id` GROUP BY `a`.`id` |
13:24.40 | PleegWat | yes |
13:24.54 | Zanix | not working :( |
13:25.02 | PleegWat | I assume you're testing the query in phpmyadmin? |
13:25.13 | Zanix | yeah |
13:25.19 | PleegWat | what are you getting? |
13:25.23 | Zanix | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COUNT( `f` . `addon_id` ) |
13:25.37 | PleegWat | oh, you missed a comma |
13:25.38 | Zanix | i think i missed a comma |
13:25.40 | PleegWat | after `a`.* |
13:26.00 | Zanix | i believe that did it |
13:27.52 | PleegWat | nice |
13:28.17 | Zanix | SELECT `a`.*, COUNT(`f`.`addon_id`) AS num_files FROM `uniadmin_addons` AS a LEFT JOIN `uniadmin_files` AS f ON `a`.`id` = `f`.`addon_id` GROUP BY `a`.`id` ORDER BY `a`.`name` ASC |
13:28.20 | PleegWat | I misunderstood initially, thought you were working on some roster thing |
13:28.26 | Zanix | oh |
13:28.28 | Zanix | lol |
13:28.34 | PleegWat | doesn't matter for the solution |
13:28.52 | Zanix | this is much better than running a query for every addon |
13:29.09 | PleegWat | yeah |
13:29.38 | PleegWat | It's the profession field slownes all over again as the number of addons increases |
13:31.23 | Zanix | yeah |
13:31.53 | PleegWat | I should ask on a newsgroup sometime if there's a proper SQL solution to it |
13:32.03 | PleegWat | The way we're fetching it now feels kinda ugly |
13:32.36 | PleegWat | Also because we're not filtering the skills, but fetching all of them. |
13:33.17 | PleegWat | The SQL gives enough data that you could add icons for all weapoin skills/languages/etc. a char knows just by adding stuff to the localization files |
13:37.47 | Zanix | hmmm |
13:37.53 | Zanix | http://www.drkalliance.com/uniadmin/index.php?p=addons |
13:37.57 | Zanix | sorting works now |
13:44.55 | PleegWat | Hm, does it do addon download size too? |
13:45.22 | PleegWat | (with the innocense of someone who doesn't have the faintest idea what data is in the tables) |
13:49.20 | Zanix | no, I dont have a size yet |
13:54.52 | PleegWat | I want to reserve a TBC collectors edition but I can't find it anywhere |
13:55.01 | Zanix | really quick, how do you get file size in php? |
13:55.10 | PleegWat | filesize()? |
13:55.30 | Zanix | ...that simple huh? |
13:55.45 | PleegWat | int filesize ( string filename ) |
13:55.46 | PleegWat | Returns the size of the file in bytes, or FALSE (and generates an error of level E_WARNING) in case of an error. |
13:56.54 | Zanix | so just suppress this with @ then |
13:57.13 | PleegWat | Dunno what errors you can get |
13:57.24 | PleegWat | Checking for existance in advance probably covers it |
14:00.44 | Zanix | yeah |
14:10.39 | Zanix | im also going to add a subpage for every addon |
14:10.47 | Zanix | giving file details as well |
14:14.33 | Zanix | http://www.drkalliance.com/uniadmin/index.php?p=addons |
14:14.36 | Zanix | files sizes |
15:00.13 | *** join/#wowroster Sylphid|work (n=gamesand@64.6.15.110.outfitters.com) |
15:00.31 | *** join/#wowroster Sylphid|work (n=gamesand@64.6.15.110.outfitters.com) |
15:58.37 | *** join/#wowroster Specis (n=Specis@82-40-16-139.cable.ubr03.uddi.blueyonder.co.uk) |
15:59.56 | *** join/#wowroster Warla (i=Darky28@70-111.0-85.cust.bluewin.ch) |
16:00.11 | Warla | hi |
16:00.16 | Zanix|away | bye |
16:00.21 | Zanix|away | sleepy tim efor me |
16:00.28 | Zanix|away | 9am and i havent went to bed yet |
16:00.35 | Warla | heh |
16:00.41 | Warla | i'm working on my mod like crazy |
16:00.43 | Warla | :-) |
16:00.48 | Warla | works like a charm in BC |
16:01.00 | Warla | its the first and only snapshot mod that works in BC :-) |
16:01.09 | Zanix|away | snapshot? |
16:01.18 | Warla | yea |
16:01.21 | Warla | like CP |
16:01.22 | Zanix|away | ive been working on UniAdmin |
16:01.24 | Zanix|away | http://www.drkalliance.com/uniadmin/index.php?p=addons |
16:01.32 | Zanix|away | getting in some requested features |
16:45.30 | Sylphid|work | hey zanix u need any help with UA just lemme know |
16:45.34 | Sylphid|work | be glad to help |
16:48.58 | PleegWat | hi |
17:27.02 | Sylphid|work | hows it goin PleegWat |
18:03.00 | PleegWat | fine |
18:34.26 | *** join/#wowroster Smaugie776 (n=chatzill@fullerton-cuda-2-70-37-65-52.lmdaca.adelphia.net) |
18:56.47 | *** join/#wowroster Orphis (n=Orphis@sop06-1-82-228-251-21.fbx.proxad.net) |
20:06.44 | *** join/#wowroster Mathos (n=mathos@234-253-045-062.dynamic.caiway.nl) |
20:06.44 | *** mode/#wowroster [+o Mathos] by ChanServ |
20:07.18 | Mathos | Yoooo |
20:48.41 | Mathos | Zeryl_ are you there ? |
21:13.22 | *** join/#wowroster Anaxent (n=Anaxent@ip68-3-142-242.ph.ph.cox.net) |
21:13.22 | *** mode/#wowroster [+o Anaxent] by ChanServ |
21:13.47 | Anaxent | hey guys hows it going |
21:20.09 | Warla | heya |
21:41.20 | Anaxent | hows it going Warla |
21:41.39 | Anaxent | im thinking of picking up a new cell phone from either tmobile or sprint |
21:45.00 | Anaxent | either The Sprint PCS VisionSM Smart Device PPC-6700 or T-Mobile Dash both using the win mobile os |
23:17.07 | Zanix|away | hey guys |
23:17.07 | Zanix|away | http://www.wowinsider.com/2006/11/14/ptrs-online-well-sorta/ |
23:21.01 | Zanix | "Players will no longer be able to jump onto the top of the Dun Baldur Fortress in Alterac Valley and get behind the terrain to attack other players." |
23:21.03 | Zanix | yay! |
23:22.47 | Zanix | "Various graphical errors will be noticeable while viewing maps." |
23:22.50 | Zanix | ?? werid |