| 00:01.49 | Nago | ahh nice |
| 00:32.14 | *** join/#wowroster PleegWat_ (i=PleegWat@leegwater-68.demon.nl) |
| 00:32.15 | *** mode/#wowroster [+o PleegWat_] by ChanServ |
| 00:48.11 | *** join/#wowroster PleegWat (i=PleegWat@leegwater-68.demon.nl) |
| 00:48.11 | *** mode/#wowroster [+o PleegWat] by ChanServ |
| 01:06.17 | *** join/#wowroster FoxyofAzgalor (n=FoxyofAz@dhcp3-66-244-107-188.stfd.smithvilledsl.net) |
| 01:06.49 | FoxyofAzgalor | Hello again everyone :-D |
| 01:13.04 | Zeryl | hello |
| 01:13.24 | Zanix | hi guys |
| 01:13.38 | FoxyofAzgalor | :-D |
| 01:13.38 | Zeryl | what's up z man |
| 01:14.29 | FoxyofAzgalor | You know, I've tried both using update and replace and both ways it still dies midway through on it... changing uploads on duplicate that is |
| 01:14.46 | Zeryl | you are still doing it PER node |
| 01:14.52 | FoxyofAzgalor | yeah |
| 01:15.01 | Zeryl | use the same theory i used for initial insertion (building a query string), and it won't time out |
| 01:16.02 | FoxyofAzgalor | If I remember right the code is almost exactly the same as the last one you used for parsing a local copy, just modified for the roster... |
| 01:16.31 | Zeryl | post the functions.php ona pastebin somewhere |
| 01:16.57 | FoxyofAzgalor | are you using Trillian? I could transfer you the file, pastebin.com has been erroring out the past few days, db issues it looks like |
| 01:17.11 | Zeryl | www.wowroster.net/pastebin or convictionofsuramar.com/pastebin |
| 01:17.57 | FoxyofAzgalor | sec horde agro :-D |
| 01:19.52 | FoxyofAzgalor | http://www.wowroster.net/pastebin/index.php?show=96 |
| 01:20.57 | Zeryl | i don't see the replace into in there |
| 01:23.06 | FoxyofAzgalor | doh, posted the wrong one |
| 01:34.42 | FoxyofAzgalor | http://www.wowroster.net/pastebin/index.php?show=97 |
| 01:35.00 | FoxyofAzgalor | sorry the ol'phone is ringing off the hook here |
| 01:35.01 | FoxyofAzgalor | brbr |
| 01:38.29 | Zeryl | the whole idea behind the replace into is that it is ONE query |
| 01:38.42 | Zeryl | you don't need any of the others |
| 01:38.47 | Zeryl | if it finds a row with that data, it replaces the data, if not, it inserts a new row |
| 01:41.03 | *** join/#wowroster PleegWat_ (i=PleegWat@leegwater-68.demon.nl) |
| 01:41.03 | *** mode/#wowroster [+o PleegWat_] by ChanServ |
| 01:47.16 | FoxyofAzgalor | $query = "REPLACE INTO `".$db_prefix."gatherer_nodes`` (continent, map, nodeNumber, nodeTypeWord, nodeType, xPos, yPos, uploads, method) VALUES ('".$locations[$index]."', '".mysql_real_escape_string($map)."', '".$nodeNumber."', '".$nodetypeword."', '".$nodeInfo2['gtype']."', '".$xPos."', '".$yPos."', '$count+1', '".$type."');"; |
| 01:47.27 | FoxyofAzgalor | so that should work right? |
| 01:48.09 | Zeryl | I tihnk so |
| 01:48.15 | FoxyofAzgalor | kk |
| 01:57.05 | FoxyofAzgalor | oh poo! I over wrote my functions.php that I had posted the other day with this one lol |
| 01:58.47 | FoxyofAzgalor | that'll teach me to back up :-D |
| 01:58.52 | Zanix | you should use the addon svn |
| 01:58.58 | Zanix | then error like this can be avoided |
| 01:58.59 | Zeryl | yep |
| 01:59.49 | FoxyofAzgalor | yeah hehe, say are you able to use TortoiseSVN to connect to the svn? |
| 02:00.26 | Zeryl | ya |
| 02:01.05 | Zanix | yep |
| 02:01.09 | Zanix | all the devs are |
| 02:02.03 | Zanix | http://wowroster.net/svn/roster1_addons |
| 02:02.22 | Zanix | well, read the stuff in the SVNergy module first |
| 02:02.29 | Zanix | http://www.wowroster.net/SVNergy.html |
| 02:02.34 | Zanix | it has rules and such |
| 02:03.00 | ds001 | lol.. nice post Zanix and Zeryl (re: mr. help vampire) |
| 02:03.24 | Zanix | yep |
| 02:03.33 | Zanix | I dont tolerate crap like that |
| 02:05.31 | FoxyofAzgalor | okay, I'll use the SVN for sure :-) |
| 02:08.17 | FoxyofAzgalor | just caught the vampire thing :-) hope I didn't start off like that |
| 02:12.33 | FoxyofAzgalor | :-P don't suppose anyone here happened to download a copy of my addon the other day? |
| 02:12.58 | Zeryl | what do you need it for? |
| 02:13.26 | FoxyofAzgalor | the functions.php hehe I over wrote it with a new one... |
| 02:14.07 | FoxyofAzgalor | looked like this: http://www.wowroster.net/pastebin/index.php?show=98 but I know I had made a change in it to get it working... |
| 02:15.57 | FoxyofAzgalor | btw: if you can avoid it, don't break your 5th metatarsal it hurts like, well yeah just don't do it :-D |
| 02:16.58 | FoxyofAzgalor | ^ the bone behind your little toe... |
| 02:17.29 | Zeryl | hehe |
| 02:21.27 | *** join/#wowroster PleegWat_ (i=PleegWat@leegwater-68.demon.nl) |
| 02:21.27 | *** mode/#wowroster [+o PleegWat_] by ChanServ |
| 02:25.03 | FoxyofAzgalor | before I start the next part of my project, anyone care to make some suggestions on how best to write the database back to .lua files? |
| 02:25.19 | Zanix | yeah |
| 02:25.25 | Zeryl | that's a great question |
| 02:25.30 | Zanix | I got code that will convert an array to an lua file |
| 02:25.38 | FoxyofAzgalor | ohz |
| 02:25.45 | Zeryl | the new array's zanix? |
| 02:25.54 | Zeryl | i mean the new lua |
| 02:26.21 | FoxyofAzgalor | back in a sec, silly phone, you'd think I was working for 411 or something |
| 02:26.56 | Zanix | http://www.wowroster.net/pastebin/index.php?show=99 |
| 02:27.12 | Zanix | doesnt matter much |
| 02:27.13 | Zeryl | you've been holding out on me, you ass ;) |
| 02:27.24 | Zanix | both ways work |
| 02:28.05 | FoxyofAzgalor | back, I need a 900 number so I can make money off home PC/networking consulting :-D |
| 02:28.27 | FoxyofAzgalor | Zanix, this looks awsome! |
| 02:30.36 | Zanix | its isnt tested |
| 02:30.41 | Zanix | so beware |
| 02:30.46 | FoxyofAzgalor | about to be :-D |
| 02:31.58 | FoxyofAzgalor | * @param string $indent Tells how far to indent -- does this add extra indents to sub-arrays? |
| 02:32.48 | Zeryl | seems to be |
| 02:32.55 | Zeryl | just from reading |
| 02:32.59 | Zeryl | but i haven't used the code |
| 02:33.29 | *** join/#wowroster PleegWat_ (i=PleegWat@leegwater-68.demon.nl) |
| 02:33.29 | *** mode/#wowroster [+o PleegWat_] by ChanServ |
| 03:15.36 | *** join/#wowroster PleegWat_ (i=PleegWat@leegwater-68.demon.nl) |
| 03:15.36 | *** mode/#wowroster [+o PleegWat_] by ChanServ |
| 03:18.23 | *** join/#wowroster PleegWat_ (i=PleegWat@leegwater-68.demon.nl) |
| 03:18.23 | *** mode/#wowroster [+o PleegWat_] by ChanServ |
| 03:53.49 | FoxyofAzgalor | Zanix, you still about? |
| 03:55.39 | Zeryl | he ran away |
| 03:55.50 | FoxyofAzgalor | hehe, I would too if I was him |
| 03:56.47 | Zanix | naw, im here |
| 03:56.52 | Zanix | kinda |
| 03:56.55 | FoxyofAzgalor | testing his array writer.... I'm wondering if I'm not building the array correct or calling it wrong... |
| 03:56.56 | Zanix | im making dinner |
| 03:57.41 | Zeryl | error_reporting(E_ALL); ini_set('display_errors', 1); |
| 03:57.47 | Zeryl | that will help you out quite a bit |
| 03:57.47 | Zanix | that helps |
| 03:57.53 | FoxyofAzgalor | kk |
| 03:58.11 | Zeryl | then you'll at least understand somewhat what is going on |
| 03:58.22 | Zeryl | i still think EVERYONe should program in it |
| 03:58.51 | FoxyofAzgalor | dies on line 31 |
| 03:59.05 | FoxyofAzgalor | Notice: Undefined variable: out in C:\apache2triad\htdocs\roster\addons\gatherer\writer.php on line 31 |
| 03:59.13 | Zeryl | that's a notice |
| 03:59.16 | Zeryl | that isn't dying |
| 03:59.18 | FoxyofAzgalor | writer.php being the array writer |
| 03:59.25 | Zeryl | errors cause cying |
| 03:59.37 | Zeryl | dying* |
| 03:59.37 | FoxyofAzgalor | crying :-P |
| 03:59.45 | FoxyofAzgalor | something hehe |
| 04:00.20 | FoxyofAzgalor | http://www.wowroster.net/pastebin/index.php?show=101 my array |
| 04:01.49 | Zeryl | i don't see anything wrong there |
| 04:02.05 | FoxyofAzgalor | array looks to form correct yeah? |
| 04:02.33 | Zeryl | from what I can tell |
| 04:02.50 | Zeryl | i don't know why you are doing the foreach using array_keys though |
| 04:05.37 | Zanix | yeah, thats sooooo php 3 |
| 04:06.11 | FoxyofAzgalor | :-D self taught so I'm not going to make excuses for my poor scipts |
| 04:06.35 | FoxyofAzgalor | yes yes I need to go back to school, hehe |
| 04:07.18 | Zanix | if you need the keys |
| 04:07.21 | Zanix | so this |
| 04:07.36 | Zeryl | oh, and I don't know that anything but that last line is gonna be in the array you pass, try $gatherdata[] = array..... |
| 04:07.40 | Zanix | foreach( $array as $key => $value) |
| 04:08.23 | Zeryl | I don't think it's even necessary ot have the foreach on there at all |
| 04:09.33 | Zanix | i didnt look at his code |
| 04:09.41 | Zanix | heh |
| 04:09.57 | Zanix | you know what, wowdb uses array_keys() alot |
| 04:10.01 | Zanix | I just saw that |
| 04:11.01 | FoxyofAzgalor | Notice: Undefined variable: out in C:\apache2triad\htdocs\roster\addons\gatherer\writer.php on line 31 no numeric top-level keys allowed |
| 04:12.15 | FoxyofAzgalor | so I should drop id since id = number |
| 04:12.37 | Zanix | well, you can just wrap it in another array |
| 04:12.43 | Zeryl | one thing you really should do, is look at the array before it's inserted into the db, and re-make it and pass that into the function |
| 04:12.54 | FoxyofAzgalor | kk |
| 04:13.21 | Zeryl | that will hopefully make it work |
| 04:15.49 | Zanix | going to the store, ill be back |
| 04:16.04 | FoxyofAzgalor | :-D bring back some chips & salsa |
| 04:17.55 | Zanix | alreay have some here at home |
| 04:17.59 | Zanix | :) |
| 04:18.03 | Zanix | i am snack central |
| 04:18.06 | Zanix | hehe |
| 04:18.08 | Zanix | laterz |
| 04:18.13 | FoxyofAzgalor | lol |
| 04:34.27 | Zeryl|Sleep | night |
| 04:34.35 | FoxyofAzgalor | laterz |
| 05:38.31 | FoxyofAzgalor | phew, it's like still 80* out side and raining |
| 05:45.29 | Zanix | its like 35* outside my place |
| 05:45.31 | Zanix | or 25 even |
| 05:45.39 | Zanix | yep 35\ |
| 05:45.42 | FoxyofAzgalor | burr... stop talking about cold weather it finally dethauled here lol |
| 05:46.30 | FoxyofAzgalor | or warmed up rather... |
| 05:46.51 | FoxyofAzgalor | did you bring us back any tasty treats? |
| 05:47.00 | Zanix | nope, sorry |
| 05:47.03 | Zanix | all for me |
| 05:47.07 | FoxyofAzgalor | :-( |
| 05:49.56 | Zanix | you know, i have learned the hard way to ALWAYS pour salsa over a sink or trash can |
| 05:50.02 | Zanix | years ago |
| 05:50.15 | Zanix | and tonight, I go against my own advice |
| 05:50.33 | Zanix | and I spill salsa all over the counter |
| 05:50.53 | FoxyofAzgalor | :-D I learned to eat spaghetti at the table and not on the white carpet (now pink) in the living room hehe |
| 05:51.03 | FoxyofAzgalor | been there done that lol |
| 05:52.12 | FoxyofAzgalor | guess my chips & salsa idea was stuck in your head as you drove to the store? |
| 05:54.02 | Zanix | yeah, but as i said, I already had chips an salsa here |
| 05:54.08 | Zanix | I just got some 7up |
| 05:54.16 | FoxyofAzgalor | :-) |
| 05:55.04 | *** join/#wowroster Tupsi (n=lumpi@217.7.101.202) |
| 06:05.01 | FoxyofAzgalor | Zanix, got time for a tough one? :-D |
| 06:05.18 | Zanix | sorta |
| 06:05.23 | Zanix | im kinda working on roster stuff |
| 06:05.40 | FoxyofAzgalor | kk, don't let me keep you then |
| 06:13.37 | *** join/#wowroster Zeryl|Sleep (n=Zeryl@72.22.91.18) [NETSPLIT VICTIM] |
| 06:13.37 | *** mode/#wowroster [+o Zeryl|Sleep] by irc.freenode.net |
| 06:13.56 | *** mode/#wowroster [-o Zeryl|Sleep] by ChanServ |
| 06:34.10 | FoxyofAzgalor | grrr... |
| 06:38.12 | Zanix | problems? |
| 06:39.28 | FoxyofAzgalor | yeah maybe, testing using REPLACE INTO to avoid duplicates... and having some bad outcomes |
| 06:40.47 | FoxyofAzgalor | I have 7555 rows on an INSERT INTO, I change it to REPLACE INTO and it deletes all but 400 or so rows |
| 06:40.53 | Zanix | why use replace? |
| 06:41.09 | FoxyofAzgalor | someone suggested it earlier... |
| 06:41.10 | *** join/#wowroster Kaos (n=Korpus@vir78-1-82-230-45-137.fbx.proxad.net) |
| 06:41.13 | Zanix | you more options |
| 06:41.26 | Zanix | sql syntax allos for handling on duplicates |
| 06:41.30 | Zanix | allows |
| 06:42.19 | FoxyofAzgalor | looked into ON DUPLCIATE KEY UPDATE but that requires a column to be a key and the only key is not being called... if that makes sence |
| 06:42.29 | Zanix | ah |
| 06:42.37 | Zanix | so how does your db look? |
| 06:42.59 | Zanix | or, how are you storing the items? |
| 06:43.04 | FoxyofAzgalor | CREATE TABLE `renprefix_gatherer_nodes` ( |
| 06:43.04 | FoxyofAzgalor | <PROTECTED> |
| 06:43.04 | FoxyofAzgalor | <PROTECTED> |
| 06:43.04 | FoxyofAzgalor | <PROTECTED> |
| 06:43.04 | FoxyofAzgalor | <PROTECTED> |
| 06:43.05 | FoxyofAzgalor | <PROTECTED> |
| 06:43.07 | FoxyofAzgalor | <PROTECTED> |
| 06:43.09 | FoxyofAzgalor | <PROTECTED> |
| 06:43.11 | FoxyofAzgalor | <PROTECTED> |
| 06:43.13 | FoxyofAzgalor | <PROTECTED> |
| 06:43.15 | FoxyofAzgalor | <PROTECTED> |
| 06:43.17 | FoxyofAzgalor | <PROTECTED> |
| 06:43.19 | FoxyofAzgalor | <PROTECTED> |
| 06:43.21 | FoxyofAzgalor | <PROTECTED> |
| 06:43.23 | FoxyofAzgalor | <PROTECTED> |
| 06:43.25 | FoxyofAzgalor | <PROTECTED> |
| 06:43.27 | FoxyofAzgalor | <PROTECTED> |
| 06:43.29 | FoxyofAzgalor | <PROTECTED> |
| 06:43.31 | FoxyofAzgalor | <PROTECTED> |
| 06:43.33 | FoxyofAzgalor | ) TYPE=MyISAM AUTO_INCREMENT=1 ; |
| 06:43.35 | FoxyofAzgalor | the heck... some how I got all those keys lol |
| 06:43.49 | Zanix | you should have pastebinned that as well |
| 06:43.50 | Zanix | :( |
| 06:44.02 | FoxyofAzgalor | my bad |
| 06:44.07 | Zanix | its ok |
| 06:44.12 | Zanix | only one table? |
| 06:45.10 | FoxyofAzgalor | yeah |
| 06:47.23 | FoxyofAzgalor | http://www.wowroster.net/pastebin/index.php?show=102 how it should be |
| 06:49.48 | Zanix | what is mpa for? |
| 06:49.50 | Zanix | map |
| 06:50.24 | FoxyofAzgalor | map is the zone, it's stored so that when I pull the results I can map to an image |
| 06:51.01 | FoxyofAzgalor | echo("<map>\n <a_map continent=\"$continent\" map=\"$map\" image=\"/addons/gatherer/images/MAP/$continent/$map.jpg\"> \n"); |
| 06:51.12 | FoxyofAzgalor | like that |
| 06:58.43 | Zanix | $continent is like kalmidor, eastern kingdoms, outlnad? |
| 06:58.53 | FoxyofAzgalor | correct |
| 06:58.56 | Zanix | hmmm |
| 06:59.08 | Zanix | you should normalize this a bit |
| 06:59.56 | FoxyofAzgalor | yeah I had started to do that but between going that route and getting a function built to avoid duplicates I've lost it hehe |
| 07:00.13 | FoxyofAzgalor | sure these pain killers for my toe aren't helping either :-D |
| 07:00.26 | Zanix | dang |
| 07:01.49 | Zanix | what is uploads? |
| 07:01.56 | Zanix | and method |
| 07:02.18 | FoxyofAzgalor | the count of times the item has been uploaded, method is the name of the person collecting |
| 07:03.03 | Zanix | ah |
| 07:03.11 | Zanix | ok, count, hmmm |
| 07:03.55 | Zanix | well |
| 07:03.58 | FoxyofAzgalor | yeah my though and Zeryl's was to avoid duplicates and update count +1 when duplicate is encountered if that makes sence |
| 07:04.09 | Zanix | i have a better idea |
| 07:04.13 | FoxyofAzgalor | ? |
| 07:04.23 | Zanix | :) |
| 07:04.27 | Zanix | give me a bit |
| 07:04.33 | FoxyofAzgalor | I'm all eyes |
| 07:05.18 | Zanix | does gatherer store nodes by contenent -> zone |
| 07:05.24 | FoxyofAzgalor | correct |
| 07:05.27 | Zanix | or better yet, give me a file |
| 07:05.41 | FoxyofAzgalor | my gatherer.lua |
| 07:05.45 | Zanix | sure |
| 07:06.11 | Zanix | nodeNumber, nodeType, nodeTypeWord |
| 07:06.14 | Zanix | what are those? |
| 07:06.47 | FoxyofAzgalor | number is the ingame number for the node, type is like mine, herb and word is like Iron Ore etc |
| 07:07.07 | Zanix | ah |
| 07:07.20 | Zanix | wow has a game based id for each node? |
| 07:07.46 | FoxyofAzgalor | :-D well that is what gatherer and those type of mod give it |
| 07:07.57 | Zanix | ah |
| 07:08.08 | Zanix | is it the same for all users of gatherer |
| 07:08.15 | FoxyofAzgalor | yeah |
| 07:08.25 | FoxyofAzgalor | the number is |
| 07:08.41 | Zanix | ok |
| 07:09.18 | FoxyofAzgalor | http://gatherer.dragonkillers.us/Gatherer.lua |
| 07:15.59 | Zanix | ok contenant ids are 1 = kalmidor |
| 07:16.05 | Zanix | 2= E kingdoms |
| 07:16.10 | Zanix | 3= outland |
| 07:16.11 | FoxyofAzgalor | correct |
| 07:16.13 | Zanix | right? |
| 07:16.14 | FoxyofAzgalor | yep |
| 07:16.24 | Zanix | the a sub array is the zone |
| 07:16.33 | Zanix | is that the same no matter what locale? |
| 07:16.34 | FoxyofAzgalor | right |
| 07:16.41 | FoxyofAzgalor | correct |
| 07:16.48 | FoxyofAzgalor | ie |
| 07:16.48 | Zanix | so they do the conversion, nice |
| 07:17.06 | FoxyofAzgalor | yeah good storage procedure :-D |
| 07:17.26 | Zanix | its ok |
| 07:17.39 | FoxyofAzgalor | :-P |
| 07:17.50 | Zanix | ok, the next number in |
| 07:17.54 | Zanix | ["AZSHARA"] = { |
| 07:17.54 | Zanix | [2850] = { |
| 07:18.01 | Zanix | what does that mean? |
| 07:18.14 | Zanix | sorry im making you teach me gatherer |
| 07:18.16 | Zanix | lol |
| 07:18.24 | Zanix | do they have docs on their format? |
| 07:18.33 | PleegWat | hi |
| 07:18.41 | FoxyofAzgalor | zone and node, ie this is a mine node in Azshara |
| 07:19.05 | FoxyofAzgalor | Hiya PleegWat |
| 07:20.23 | FoxyofAzgalor | christ the php docs on UPDATE, ON DUPLICATE and REPLACE all blend together so much it's a pain to figure out what one to use hehe |
| 07:29.42 | FoxyofAzgalor | zanix, http://gatherer.dragonkillers.us/gatherer.zip if you want to test it as a addon |
| 07:35.17 | *** join/#wowroster robojerk (n=robojerk@cpe-67-49-103-62.socal.res.rr.com) |
| 07:35.53 | robojerk | hello |
| 07:36.02 | FoxyofAzgalor | hiya Robojerk |
| 07:36.30 | robojerk | first time in here |
| 07:36.40 | FoxyofAzgalor | Welcome then :-D |
| 07:36.50 | robojerk | Thanks. |
| 07:37.26 | Zanix | hi robo |
| 07:37.30 | Zanix | nice to see ya here |
| 07:37.43 | robojerk | Hello, it's nice to be seen. =) |
| 07:37.50 | Zanix | can I call you robo... |
| 07:37.53 | robojerk | sure |
| 07:37.54 | Zanix | or is it just jerk? |
| 07:37.58 | FoxyofAzgalor | lol |
| 07:37.59 | Zanix | lol |
| 07:38.02 | robojerk | lol |
| 07:38.08 | robojerk | I respond to either |
| 07:38.20 | Zanix | good to know |
| 07:39.02 | robojerk | wish I could irc from work.. been meaning to check out the channel but the companies firewall blocks everything |
| 07:40.24 | FoxyofAzgalor | brb time to pop some pills |
| 07:40.54 | PleegWat | yeah, companies do that somethimes |
| 07:40.56 | PleegWat | wonder why |
| 07:41.16 | FoxyofAzgalor | :-D you don't have to think too hard on that one |
| 07:41.39 | robojerk | I work for a sub company of a conglomerate bank. They block everything to prevent insider trading |
| 07:42.19 | Zanix | that sucks |
| 07:42.26 | Zanix | i dont have access to a computer at my job |
| 07:42.29 | PleegWat | I mean, like, the company doesn't exactly benefit from you chatting in the boss's time right? |
| 07:42.44 | Zanix | well, I do, but Im usually too busy to just play on the computer |
| 07:43.05 | robojerk | my problem is I have too much time on my hands |
| 07:43.26 | robojerk | the company I work for was bought out a year ago.. I lost like 75% of my responsibilities |
| 07:43.34 | PleegWat | ic |
| 07:43.38 | robojerk | so now day dream |
| 07:43.42 | robojerk | listen to music |
| 07:43.43 | FoxyofAzgalor | lol |
| 07:45.59 | Zanix | sounds boring |
| 07:46.00 | robojerk | It is. |
| 07:46.00 | robojerk | You guys working on anything interesting? |
| 07:46.01 | Zanix | oh, did you get my pm back robo? |
| 07:46.01 | Zanix | ..always |
| 07:46.01 | Zanix | :) |
| 07:46.04 | robojerk | about SVNergy, yes I did |
| 07:46.40 | FoxyofAzgalor | I'm working on giving Zanix a complex via looking over my horrable php scripts :-P |
| 07:46.57 | robojerk | lol |
| 07:47.19 | robojerk | I've been tinkering with some half assed attempt someone did to port eqdkp to dragonfly |
| 07:47.47 | FoxyofAzgalor | that sounds like fun hehe |
| 07:47.54 | robojerk | I made it atleast look better |
| 07:49.22 | Zanix | robo: was it enough info |
| 07:50.03 | robojerk | yeah, I'm in the process of transfering hosts so if I need more info I'll send you more PM's when that time comes. |
| 07:51.04 | robojerk | but for now I'm good. =) |
| 07:51.32 | Zanix | cool, im more than willing to help you if you want the same |
| 07:52.42 | robojerk | I'm interested in it, but I need to get all set up first.. The wife and guild are kind of slowing me down. |
| 07:52.59 | robojerk | but the guild part might not be an issue any more |
| 07:58.12 | Zanix | lol |
| 08:00.11 | FoxyofAzgalor | Zanix, did you think up a mind boggling solution for the check for duplicates? |
| 08:00.27 | Zanix | yeah, but im not sure atm |
| 08:00.32 | FoxyofAzgalor | hehe |
| 08:09.15 | robojerk | Here's what I'm working on. what do you guys think? http://blacktemplars.org/index.php?name=dfeqdkp |
| 08:10.28 | FoxyofAzgalor | I think there is something wron with the paging |
| 08:10.56 | FoxyofAzgalor | even though you only have 1 entry it pages for over 30 at 1 per page |
| 08:11.17 | robojerk | yeah |
| 08:11.19 | FoxyofAzgalor | 6* not 30 |
| 08:12.52 | FoxyofAzgalor | oh news & standings do not have a boarder around them like the rest... Looks better with no boarder |
| 08:14.08 | robojerk | I'm just trying to fix all the linking right now. I can't figure out how to get it compliant with DF coding standards |
| 08:14.20 | FoxyofAzgalor | from standings using the filter tosses you to the home page of the site |
| 08:14.30 | FoxyofAzgalor | looking good though :-D |
| 08:14.30 | robojerk | hmm |
| 08:15.22 | robojerk | hehe, I didn't even look at the filter yet |
| 08:16.34 | FoxyofAzgalor | order by spent is not working there either, you wanted a general feed back and not a testing I guess :-D |
| 08:16.51 | robojerk | =) |
| 08:16.58 | robojerk | I am a horrible coder |
| 08:17.23 | robojerk | my guild makes fun of me because I make so many typos just in the raid chat |
| 08:17.28 | FoxyofAzgalor | lol |
| 08:18.21 | FoxyofAzgalor | it looks like you have many of your links pointing at the root folder for a query rather than at a module |
| 08:19.27 | FoxyofAzgalor | or the current page as file not module name... if that makes sence |
| 08:20.26 | robojerk | this module has too many links lol |
| 08:21.34 | *** join/#wowroster Nago (n=Nago@209-144-2-131.westok.net) |
| 08:21.40 | Nago | hi ya all |
| 08:21.49 | FoxyofAzgalor | yellow |
| 08:22.54 | Nago | yellow ? |
| 08:22.54 | FoxyofAzgalor | hello hehe |
| 08:23.00 | Nago | hhahah |
| 08:23.15 | FoxyofAzgalor | CNN HEADLINE: Eighty sheep found in man's home I'm not even going to click that one hehe |
| 08:23.29 | Nago | LOL |
| 08:24.04 | Nago | anyone support ? |
| 08:24.22 | FoxyofAzgalor | what's the problem? |
| 08:24.34 | Nago | does i have to update the Guild profiles everytime ? |
| 08:24.58 | FoxyofAzgalor | only if you want a list of current members |
| 08:25.08 | Nago | okay i did |
| 08:25.11 | Nago | update it but got Error |
| 08:25.17 | FoxyofAzgalor | error? |
| 08:25.32 | Nago | yes it only update my character profiles not guild said it Error Table |
| 08:25.33 | Nago | <PROTECTED> |
| 08:25.51 | FoxyofAzgalor | can you run it again and post the error here? |
| 08:25.57 | Nago | okay |
| 08:26.00 | Nago | there tons |
| 08:26.33 | robojerk | time for bed.. Nice chatting with you guys.. |
| 08:26.40 | Nago | Quest [] could not be inserted |
| 08:26.44 | Nago | u too robo |
| 08:26.55 | Nago | 1062: Duplicate entry '239-' for key 1 |
| 08:27.01 | FoxyofAzgalor | later bro |
| 08:27.02 | Zanix | search the forums |
| 08:27.04 | Nago | let me od it again |
| 08:27.04 | Nago | Quest [] could not be inserted |
| 08:27.10 | Zanix | already been answered and fixed |
| 08:27.17 | FoxyofAzgalor | yeah there is a patch for that error |
| 08:27.18 | Nago | 1062: Duplicate entry '239-' for key 1 |
| 08:27.30 | FoxyofAzgalor | sec I think I bookmarked it too |
| 08:28.21 | FoxyofAzgalor | btw: I hate my dsl, slower than me walking on a broken toe hehe |
| 08:29.45 | Nago | ahh |
| 08:31.25 | FoxyofAzgalor | ... http://www.wowroster.net/Forums/viewtopic/t=2699.html |
| 08:32.58 | *** join/#wowroster Nago (n=Nago@209-144-2-131.westok.net) |
| 08:33.11 | FoxyofAzgalor | guess that answered his question |
| 08:33.26 | *** join/#wowroster Nago (n=Nago@209-144-2-131.westok.net) |
| 08:33.30 | Nago | link it pls |
| 08:33.44 | Nago | i had ot turn off the pop up |
| 08:33.46 | FoxyofAzgalor | http://www.wowroster.net/Forums/viewtopic/t=2699.html |
| 08:36.20 | Nago | another question |
| 08:36.30 | Nago | in rosterdiag .. there is not suppose to have RED ? |
| 08:37.39 | FoxyofAzgalor | If there is something showing up red in the tables at the bottom then you have some out of date files... |
| 08:37.59 | FoxyofAzgalor | see the box that says Download Update Package From: SVN @ http://www.wowroster.net/roster_updater/ |
| 08:38.31 | FoxyofAzgalor | check zip and click Get Update Package |
| 08:38.41 | FoxyofAzgalor | unzip it and upload it to your roster |
| 08:39.02 | Nago | where od i chekc the zip ? |
| 08:39.59 | PleegWat | With those errors, are you sure you have the latest roster version? |
| 08:40.02 | FoxyofAzgalor | scroll down the page you'll see a table with BLUE text says Download Update Package From: |
| 08:40.14 | PleegWat | you need to log in before getting update package |
| 08:40.20 | FoxyofAzgalor | You are using 1.7.3 right |
| 08:40.43 | FoxyofAzgalor | he's on the rosterdiag.php I think |
| 08:40.55 | Nago | yes |
| 08:40.58 | Nago | 1.7.3 |
| 08:41.04 | Nago | there red said Crital |
| 08:41.24 | FoxyofAzgalor | yeah that indicates the file needs to be replaced on your server |
| 08:41.36 | Nago | reinstall ? |
| 08:42.01 | Zanix | it means there is an update for that file |
| 08:42.04 | FoxyofAzgalor | no, replace the file on your server with the downloaded file from wowroster.net |
| 08:42.26 | Nago | okay okay where do i update it ? |
| 08:42.44 | Nago | that link |
| 08:42.44 | Nago | http://www.wowroster.net/roster_updater/ |
| 08:43.14 | FoxyofAzgalor | if you are logged into the roster and on the rosterdiag.php page scroll down the page till you see a table with blue text Download Update Package From: SVN @ http://www.wowroster.net/roster_updater/ |
| 08:43.14 | FoxyofAzgalor | <PROTECTED> |
| 08:43.14 | FoxyofAzgalor | .zip Archive |
| 08:43.14 | FoxyofAzgalor | .tar.gz Archive |
| 08:43.35 | FoxyofAzgalor | select zip and click Get Update Package |
| 08:45.02 | FoxyofAzgalor | Hey Zanix, I just tried that myself, getting the update package and both the zip and gzip are corrupt...? |
| 08:45.20 | Nago | do i have ot type like www.silentsfire.com/roster_updater/ ? |
| 08:45.28 | Zanix | really, weird |
| 08:46.14 | FoxyofAzgalor | Nago, I'll make this easy for ya http://www.wowroster.net/Downloads/details/id=88.html |
| 08:47.07 | Nago | i did |
| 08:47.11 | Nago | it not make any difference |
| 08:47.46 | Nago | ahh |
| 08:47.46 | Nago | now i see |
| 08:48.42 | FoxyofAzgalor | did that correct it? if so try updating your roster again |
| 08:48.52 | Nago | guild roster |
| 08:48.58 | FoxyofAzgalor | yeah |
| 08:49.17 | Nago | it update |
| 08:49.41 | Nago | so that mean i can update it anytime i want .. even tho i have to upload db in it ? |
| 08:50.38 | FoxyofAzgalor | yeah |
| 08:52.53 | Nago | does 1.7.0 addon can wokr on 1.7.3 ? |
| 08:54.04 | FoxyofAzgalor | you should check the forums http://www.wowroster.net/Forums/viewforum/f=5.html for newer versions of the addons... but generally speaking many of them still work |
| 09:05.21 | FoxyofAzgalor | I think I'm going to take a little cat nap... |
| 09:05.27 | Nago | good ngiht |
| 09:06.15 | FoxyofAzgalor | cya |
| 09:06.29 | *** part/#wowroster FoxyofAzgalor (n=FoxyofAz@dhcp3-66-244-107-188.stfd.smithvilledsl.net) |
| 09:10.06 | *** join/#wowroster PleegWat (i=PleegWat@leegwater-68.demon.nl) |
| 09:10.07 | *** mode/#wowroster [+o PleegWat] by ChanServ |
| 09:10.49 | PleegWat | I hate system crashes :( |
| 09:11.17 | PleegWat | I get them occasionally. I suspect they're caused by the generic nVidia driver not being 100% compatible with my branded card |
| 09:15.50 | Zanix | that sucks |
| 09:17.16 | PleegWat | But the most recent version of the asus driver is ancient |
| 09:17.30 | PleegWat | so I'll live with a crash a week and better performance |
| 09:18.19 | Zanix | character pages done |
| 09:18.34 | PleegWat | nice |
| 09:18.42 | Zanix | well, the char tabs anyway |
| 09:19.51 | PleegWat | Busy with homework http://homepages.cwi.nl/~manegold/teaching/DBtech/practicum/assignment_2.html |
| 09:20.56 | Zanix | fun stuff |
| 09:21.29 | PleegWat | currently splitting my statement into steps |
| 09:21.49 | Zanix | http://cvsroster.homeip.net/roster/trunk/index.php?p=char&member=97 |
| 09:21.55 | PleegWat | TPC-H query 5 |
| 09:24.44 | Zanix | I think i may get rid of that "all" tab |
| 09:25.06 | Zanix | lol, I dont even wanna try that homework |
| 09:25.22 | PleegWat | meh, mainly a lot of work |
| 09:25.47 | Zanix | so I need your advice, should the All tab on the skills tab stay or go? |
| 09:26.10 | Zanix | it doesnt swap the individual images |
| 09:26.15 | Zanix | the plus minus |
| 09:26.21 | PleegWat | hm, remove it then |
| 09:26.30 | Zanix | k |
| 09:27.06 | Zanix | and i dont wanna deal with it |
| 09:27.08 | Zanix | lol |
| 09:38.12 | Zanix | all, commited for your viewing pleasure |
| 09:41.02 | PleegWat | After I done my homework maybe |
| 09:41.07 | PleegWat | g'night |
| 09:42.58 | Zanix | night |
| 12:42.35 | *** join/#wowroster DrWily (n=drwily@24.106.205.110) |
| 15:11.36 | *** join/#wowroster Sylphid|work (n=gamesand@64.6.15.110.outfitters.com) |
| 15:28.19 | *** join/#wowroster Harshmage (i=harshmag@bwitherspoontest.gc.maricopa.edu) |
| 15:37.55 | Harshmage | waking up at 5 am and doing something for a little less than a half hour, then going back to bed, REALLY throws your sleep schedule off....20 minutes late to work, driving on one of the most crowded roads in Phoenix. |
| 15:53.42 | Zeryl | hehe |
| 16:34.44 | *** join/#wowroster Harshmage (i=harshmag@bwitherspoontest.gc.maricopa.edu) |
| 16:49.17 | *** join/#wowroster ds001 (n=ds001@w192.z064003020.sea-wa.dsl.cnc.net) |
| 18:05.33 | *** join/#wowroster Sylphid|work (n=gamesand@64.6.15.110.outfitters.com) |
| 18:39.14 | *** join/#wowroster Tupsi (n=Miranda@p54b229f1.dip0.t-ipconnect.de) |
| 18:44.56 | Harshmage | We are the Geek. Lower your firewalls and surrender your processors. We will add your technological resources to our network. Your computers will adapt to service us. |
| 19:21.39 | Zeryl | lol |
| 19:24.30 | *** join/#wowroster Kaos (n=Korpus@vir78-1-82-230-45-137.fbx.proxad.net) |
| 19:39.35 | *** join/#wowroster Kaos (n=Korpus@vir78-1-82-230-45-137.fbx.proxad.net) |
| 19:48.21 | *** join/#wowroster Kaos (n=Korpus@vir78-1-82-230-45-137.fbx.proxad.net) |
| 20:19.22 | *** join/#wowroster PleegWat_ (i=PleegWat@leegwater-68.demon.nl) |
| 20:19.22 | *** mode/#wowroster [+o PleegWat_] by ChanServ |
| 20:35.22 | *** join/#wowroster Zanix (n=Zanix@71-221-141-233.bois.qwest.net) [NETSPLIT VICTIM] |
| 20:35.23 | *** join/#wowroster Sylphid|work (n=gamesand@64.6.15.110.outfitters.com) [NETSPLIT VICTIM] |
| 20:35.23 | *** join/#wowroster ds001 (n=ds001@w192.z064003020.sea-wa.dsl.cnc.net) [NETSPLIT VICTIM] |
| 20:35.23 | *** join/#wowroster Harshmage (i=harshmag@bwitherspoontest.gc.maricopa.edu) [NETSPLIT VICTIM] |
| 20:35.23 | *** join/#wowroster dracula (i=dracula@89.98.217.142) [NETSPLIT VICTIM] |
| 20:35.23 | *** join/#wowroster Anaxent (n=Anaxent@ip72-208-134-254.ph.ph.cox.net) [NETSPLIT VICTIM] |
| 20:35.23 | *** join/#wowroster Kyrin (n=gostlund@d198-53-224-65.abhsia.telus.net) [NETSPLIT VICTIM] |
| 20:35.23 | *** join/#wowroster lhunath (n=lhunath@92.56-13-195.om-powered.net) [NETSPLIT VICTIM] |
| 20:35.23 | *** join/#wowroster Liandra (i=garion@sai.sente.nl) [NETSPLIT VICTIM] |
| 20:35.23 | *** join/#wowroster [PUPPETS]Gonzo (i=spaminat@80.69.47.16) [NETSPLIT VICTIM] |
| 20:35.23 | *** mode/#wowroster [+oo Zanix Anaxent] by irc.freenode.net |
| 20:35.32 | *** join/#wowroster FoxyofAzgalor (n=FoxyofAz@dhcp3-66-244-107-188.stfd.smithvilledsl.net) |
| 20:35.33 | FoxyofAzgalor | hello all |
| 22:09.19 | FoxyofAzgalor | Zanix, you around? |
| 22:09.30 | Zanix | no |
| 22:09.30 | FoxyofAzgalor | lol |
| 22:09.36 | Zanix | I just got home |
| 22:09.40 | Zanix | Im reading email |
| 22:09.43 | FoxyofAzgalor | :-D |
| 22:09.43 | Zanix | give me a bit |
| 22:09.47 | FoxyofAzgalor | kk |
| 22:30.33 | Zanix | now im reading forum posts |
| 22:30.33 | FoxyofAzgalor | lol, take your time :-D |
| 22:51.58 | *** join/#wowroster Guest951 (n=Guest@hlfxns01bbg-142068076063.dhcp-dynamic.ns.aliant.net) |
| 22:53.48 | SirToast | Hey everyone, I just installed WoWRoster 1.7.3, but for whatever reason, it's not liking the characterprofile.lua when I try to import it., saying "Could not find Guild in Database" |
| 22:54.03 | Zanix | did you read the intall instructions? |
| 22:54.08 | FoxyofAzgalor | did you do all the preinstall? |
| 22:54.32 | Zanix | http://www.wowroster.net/wiki/index.php/Roster:Install |
| 22:54.36 | Zanix | http://www.wowroster.net/wiki/index.php/Roster:Config |
| 22:54.42 | Zanix | http://www.wowroster.net/wiki/index.php/Roster:Updating |
| 22:55.51 | SirToast | I'm not getting the save button the social window, I'm guessing I have an old version of GuildProfiler? I downloaded whatever the most recent CHaracterProfiler is |
| 22:57.12 | Zanix | from our site or rpgoufitter.com |
| 22:57.22 | Zanix | CP is 2.0.6 and GP is 2.0.5 |
| 22:57.25 | SirToast | Grabbing it not, sec |
| 22:57.42 | Zanix | I think im going to make a first upload guide |
| 22:57.47 | Zanix | lol |
| 22:57.50 | Zanix | I got to go |
| 22:57.53 | Zanix | ill be back though |
| 22:58.10 | ds001 | Hey Zanix.. bye Zanix.. :) |
| 22:58.20 | SirToast | sorry:) I had this all working when it was WowRoster 1.5, but but that was a while ago |
| 23:14.18 | FoxyofAzgalor | Zanix you still trolling? |
| 23:23.00 | *** join/#wowroster Kaos (n=Kaos@vir78-1-82-230-45-137.fbx.proxad.net) |
| 23:26.10 | Zanix | im back |
| 23:26.13 | Zanix | and done reading |
| 23:26.50 | FoxyofAzgalor | :-D just wanted to check back with you about the duplicate issue from last night |
| 23:27.16 | Zanix | to be honest, I havent looked into much after we talked |
| 23:27.25 | Zanix | I was still working on roster stuff |
| 23:27.48 | Zanix | but now I can look at it some |
| 23:28.16 | FoxyofAzgalor | kk no worries, I'll continue to try some stuff, I've just googled for days and all I see doesn't seem to work |
| 23:29.01 | FoxyofAzgalor | I can send via pastebin a copy of a script Zeryl says works on his end... on mine it just seems to die |
| 23:31.30 | Zanix | ok |
| 23:34.15 | FoxyofAzgalor | http://www.wowroster.net/pastebin/index.php?show=103 |
| 23:34.54 | FoxyofAzgalor | For me it dies when uploading and duplicates found, it will update maybe a few hundred or so and that's it |
| 23:38.01 | Zanix | how long does the script run? |
| 23:38.07 | Zanix | and what is the parse time on the lua file? |
| 23:38.16 | FoxyofAzgalor | well it runs for about 20sec and dies |
| 23:40.34 | Zanix | what is your php time limit? |
| 23:40.50 | FoxyofAzgalor | good question never checked |
| 23:42.11 | FoxyofAzgalor | is that in PHPini? |
| 23:42.52 | Zanix | yep |
| 23:42.58 | FoxyofAzgalor | sec |
| 23:43.01 | Zanix | you can also set it via ini_set |
| 23:43.20 | FoxyofAzgalor | oh... |
| 23:43.32 | FoxyofAzgalor | didn't think about that |
| 23:43.47 | Zanix | http://www.php.net/manual/en/ref.info.php#ini.max-execution-time |
| 23:43.54 | Zanix | well, this is bad anyway |
| 23:44.04 | Zanix | your script shouldn't exceed that anyway |
| 23:45.04 | Zanix | so, what we need to do, is limit the info sent to sql |
| 23:46.32 | Zanix | what you need, is a separate upload page, and not tie into update.php |
| 23:46.53 | Zanix | since triggers run only when CP.lua is uploaded, you already loose that time |
| 23:47.03 | Zanix | it take for that to process |
| 23:47.43 | Harshmage | I'm out....long day... |
| 23:48.09 | Zanix | and running updates isn't helping either |
| 23:48.29 | Zanix | on every itteration |
| 23:50.02 | FoxyofAzgalor | the update is to see how many times it has been uploaded... or should I just call it good with 1 upload? |
| 23:50.21 | Zanix | why does it need to be updated? |
| 23:51.00 | FoxyofAzgalor | the thought was if you see it 1 time it might not be valid, but 12 times it's a good node mark |
| 23:51.35 | Zanix | that makes sense |
| 23:53.03 | FoxyofAzgalor | yeah |
| 23:53.28 | FoxyofAzgalor | so all in all I should make a seperate upload page then to eliviate the run time |
| 23:54.06 | Zanix | I bet that will help |
| 23:54.24 | Zanix | since the size of the gather file is large by itself |
| 23:54.35 | FoxyofAzgalor | yeah mine is like 1.5mb |
| 23:55.33 | FoxyofAzgalor | I'll work on that some tonight then, ty |