| 01:28.47 | Foxy | Zanix... you on here still? |
| 01:50.20 | Zeryl | he left |
| 01:50.22 | Zeryl | what's up? |
| 01:51.43 | Foxy | oh not too much... still working on parsing my data out... I've got the parse down to the node leve data of the gatherer.lua but I'm not able to break the sub-array into values for some reason |
| 01:51.57 | Zeryl | example? |
| 01:52.23 | Foxy | what was the site we used last night to post sniplets? |
| 01:52.29 | Foxy | I'll post this |
| 01:52.39 | Zeryl | www.convictionofsuramar.com/pastebin/ |
| 01:52.45 | Foxy | kk |
| 01:53.20 | Foxy | http://www.convictionofsuramar.com/pastebin/70 |
| 01:53.55 | Foxy | gives me this... Value: 1ArrayArray |
| 01:55.14 | Foxy | value (last array) should print something like: |
| 01:55.16 | Foxy | 0.3195, -- [1] |
| 01:55.27 | Foxy | 0.5151, -- [2] |
| 01:55.32 | Foxy | 0, -- [3]' |
| 01:55.38 | Foxy | 0, -- [4] |
| 01:55.46 | Foxy | 0, -- [5] |
| 01:55.51 | Foxy | "IMPORTED", -- [6] |
| 01:56.16 | Foxy | with out the comments :-) |
| 01:56.35 | Zeryl | http://zeryl.mine.nu/gathertest |
| 01:57.15 | Foxy | doh! |
| 01:57.56 | Foxy | <PROTECTED> |
| 01:58.05 | Foxy | sneaky sneaky! |
| 01:58.10 | Zeryl | you needed one more level of for-eaching |
| 01:58.46 | Zeryl | what is 1 2 3? are they the zones? |
| 01:58.51 | Zeryl | i mean continents? |
| 01:59.01 | Foxy | Warning: Invalid argument supplied for foreach() in /var/www/localhost/htdocs/gathertest/index.php on line 30 |
| 01:59.25 | Zeryl | i know, i haven't done much in the way of error checking ;) |
| 01:59.30 | Foxy | should be zones... actuall names, but that's bringing it as a count of array... |
| 02:00.30 | Foxy | gatherer's lua is very poorly laid out for this I think] |
| 02:00.40 | Zeryl | not too bad, one sec |
| 02:06.01 | Zeryl | gonna figure out what number = what zone |
| 02:07.12 | Foxy | I was looking at that the numbers should match the zones in Alphabetical |
| 02:08.02 | Zeryl | treasure = 0, herb = 1, ore = 2 |
| 02:08.22 | Foxy | oh... |
| 02:08.51 | Foxy | so that's nodeType then... |
| 02:15.14 | Zeryl | http://192.168.1.147/gathertest/ |
| 02:16.01 | Zeryl | ermm, ya |
| 02:16.05 | Zeryl | well, the url that works |
| 02:17.31 | Zeryl | azshara = kalimdor correct? |
| 02:20.35 | Kyrin | yes |
| 02:20.50 | Zeryl | sorry, i don't know anymore, i forgot ;) |
| 02:21.22 | Zeryl | refresh the page, more info now ;) |
| 02:28.47 | Zeryl | so do you happen to know the NodeType -> True Name? |
| 02:29.13 | Zeryl | found it |
| 02:30.01 | Zeryl | hrmm, no i didn't |
| 02:32.39 | Zeryl | [2040] = { |
| 02:32.39 | Zeryl | { |
| 02:32.39 | Zeryl | 0.5760000000000001, -- [1] |
| 02:32.39 | Zeryl | 0.2149, -- [2] |
| 02:32.39 | Zeryl | 0, -- [3] |
| 02:32.41 | Zeryl | 0, -- [4] |
| 02:32.44 | Zeryl | 0, -- [5] |
| 02:32.46 | Zeryl | "IMPORTED", -- [6] |
| 02:32.49 | Zeryl | }, -- [1] |
| 02:32.51 | Zeryl | dunno what the 2040 is |
| 02:32.58 | Zeryl | haha, that's you posting on the forums! |
| 02:37.42 | Foxy | hehe, sorry was AFK |
| 02:38.25 | Foxy | me posting...? |
| 02:38.39 | Zeryl | a person using the name foxy, 2 days ago, on the gatherer forums |
| 02:38.48 | Foxy | oh yeah :-D |
| 02:38.59 | Foxy | they changed a lot on the db |
| 02:39.19 | Foxy | use to be seperated by continent and zone... now just zone |
| 02:40.03 | Zeryl | it is by continent and zone |
| 02:40.17 | Zeryl | http://zeryl.mine.nu/gathertest |
| 02:40.39 | Foxy | what designates the continent now? |
| 02:40.40 | Zeryl | I'm trying to find what NodeType translates into, and it'll be complete |
| 02:40.48 | Zeryl | 1 2 3 in the top array |
| 02:41.58 | Foxy | NodeType is in the rest of the lua see the bottom section ["items"] |
| 02:42.08 | Zeryl | it doesn't translate necessarily |
| 02:42.17 | Zeryl | i.e. NodeType = 181555 |
| 02:42.29 | Foxy | or... ["cats"] = { |
| 02:44.24 | Zeryl | i can't find 181555 in the file at all |
| 02:46.30 | Zeryl | in fact, most of them don't translate |
| 02:46.50 | Zeryl | make that all of them |
| 02:47.04 | Foxy | hum... |
| 02:47.43 | Foxy | 181555 I think is a new ore from outlands... not listed in the cat section |
| 02:48.28 | Zeryl | but even in azshara, it wasn't down there |
| 02:48.29 | Foxy | yeah there is no listing in the cat for any of the new ores that I see |
| 02:49.07 | Foxy | gatherer is still in Gama or pregama this could be a problem... |
| 02:49.26 | Zeryl | like i said, NONE of the things are lining up with the stuff at the bottom |
| 02:53.25 | Zeryl | found it |
| 02:53.33 | Foxy | link? |
| 02:53.34 | Zeryl | I was looking at an older version of gatherer for the data |
| 02:53.42 | Zeryl | GatherCategories.lua |
| 02:53.53 | Foxy | oh! |
| 02:54.02 | Foxy | snap I forgot about that :-D |
| 02:55.14 | Zeryl | do you have this all mapped out already in an array/ |
| 02:55.40 | Foxy | the GathererCats? |
| 02:55.44 | Zeryl | ya |
| 02:56.19 | Foxy | na, but I can use case switch to echo it back |
| 02:56.52 | Foxy | or is there a better model for doing this? |
| 02:57.34 | Zeryl | almost done with it ;) |
| 02:58.02 | Foxy | ^ Mega credits to you! 8)8) |
| 03:14.44 | Zeryl | http://192.168.1.147/gathertest/http://192.168.1.147/gathertest/ |
| 03:14.47 | Zeryl | bah |
| 03:14.52 | Zeryl | http://zeryl.mine.nu/gathertest/ |
| 03:14.54 | Zeryl | check that out |
| 03:16.29 | Foxy | Whahoo! that's it! :-D |
| 03:17.31 | Foxy | You're awsome Zeryl! |
| 03:18.48 | Zeryl | yep ;) |
| 03:19.21 | Zeryl | wow |
| 03:19.22 | Zeryl | ok |
| 03:19.46 | *** join/#wowroster Foxy (i=CPGMembe@dhcp3-66-244-107-188.stfd.smithvilledsl.net) |
| 03:20.17 | Foxy | silly browser crashed :@ |
| 03:20.34 | Foxy | Yeah that works like a charm! |
| 03:20.47 | Zeryl | ;) |
| 03:21.01 | Zeryl | now to make it insert to a db, rank the locations, and start a gatherer sharing program |
| 03:22.33 | Foxy | Yeah got part of it right now from past test... Will you be on a while still? (You're in Russia right?) |
| 03:22.55 | Zeryl | i'm in the US |
| 03:22.56 | Zeryl | ;) |
| 03:23.03 | Zeryl | i'll be here until about 2am CST |
| 03:23.11 | Foxy | oh hehe... the domain name tossed me for a loop |
| 03:23.14 | Zeryl | ermm, before the time change |
| 03:23.17 | Zeryl | heh |
| 03:23.23 | Zeryl | using my host for irc ;) |
| 03:23.28 | Foxy | kewl kewl... yeah stupid DST... |
| 03:24.06 | Foxy | brb in a few smoke break and then testing my insert :-D Got a check in it for known nodes :-D |
| 03:24.10 | Zeryl | k |
| 03:30.54 | Anaxent | so whats up guys |
| 03:30.59 | Zeryl | not much |
| 03:34.06 | Zeryl | ok, i'm kinda pissy now, this product i bought, they released a new version, and won't let me upgrade, OR download the old version |
| 03:39.11 | Foxy | let me guess, Nero or Sonic? Those bastards did that to me on my DVD-Burning software |
| 03:39.57 | Zeryl | SqlYog |
| 03:40.08 | Zeryl | it's an amazing interface to a remote sql isntallation when you don't want phpmyadmin installed |
| 03:40.08 | Foxy | doh |
| 03:42.46 | Foxy | I think I've seen that before, allows you to copy databases remote and sync them right |
| 03:45.10 | Zeryl | yep |
| 03:56.35 | Anaxent | yeah that sucks |
| 03:58.23 | Zeryl | hrmm, it's only going down to 4 decimal placed |
| 03:58.25 | Zeryl | places* |
| 03:59.08 | Zeryl | and it's taking freaking FOREVER to insert a line |
| 04:01.39 | *** join/#wowroster Tupsi3472 (n=Miranda@p54B20F44.dip0.t-ipconnect.de) |
| 04:12.38 | Zeryl | got it working |
| 04:16.29 | Foxy | been a while :-D Unix Time Stamps never exceed 10 charictors in length right |
| 04:18.00 | Zeryl | hrmm, don't think so? |
| 04:23.22 | Anaxent | no they have not |
| 04:23.41 | Anaxent | lol ah yeah daylight savings time |
| 04:24.30 | Zeryl | ok, so my next idea is to construct a file that can be downloaded from this data |
| 04:58.05 | Foxy | Zeryl, the data inserts perfectly and in less than a few seconds for 7495 total |
| 05:11.27 | Zeryl | mine takes forever, but it's a slow server |
| 05:12.34 | Foxy | that was on localhost for me :-D |
| 05:12.44 | Zeryl | I haven't tried it on my box, guess I could |
| 05:12.53 | Foxy | 3.6ghz P4 mysql5.0 |
| 05:13.06 | Foxy | on Apache 2 |
| 05:13.20 | Zeryl | lemme try it locally |
| 05:15.01 | Foxy | oh 2 quick questions... the functions.php we've been going over, it's set right now to use a local file rather than the uploaded one from the update.php, can this be changed? And the parser in the functions.php, is this a customer parser just for gatherer.lua? |
| 05:15.47 | Zeryl | no, the parser is the parser from wowroster |
| 05:15.52 | Zeryl | and ya, you can change it over |
| 05:18.47 | Foxy | kewl |
| 05:18.53 | Zeryl | looks like it took 11 second to insert 7495 rows |
| 05:20.14 | Zeryl | but i also have it see if the data exists, and if it does, updates the row to increase the number of times it was seen |
| 05:22.07 | Zeryl | so the number of queries is MUCH higher than what you are using i'm sure |
| 05:23.21 | Zeryl | ya, 15000 queries ;) |
| 05:24.00 | Foxy | yeah, just for quick test I just inserted :-D 11 sec is long, but too long? |
| 05:24.28 | Zeryl | i guess i COULD chain them together |
| 05:30.35 | Zeryl | heh, 2 seconds on the insert! |
| 05:31.26 | Foxy | :-D |
| 05:45.47 | *** join/#wowroster Anaxent (n=Anaxent@ip72-208-134-254.ph.ph.cox.net) |
| 05:45.47 | *** mode/#wowroster [+o Anaxent] by ChanServ |
| 05:49.12 | Foxy | phew... tested yours... that is quite a query :-D |
| 05:49.41 | Anaxent | man my video drive is screwed |
| 05:49.48 | Zeryl | :( |
| 05:49.57 | Anaxent | every time i log out of wow i have toi reboot to fix display issue |
| 05:49.59 | Foxy | install a new driver lately? |
| 05:50.06 | Anaxent | yes just last week |
| 05:50.13 | Anaxent | rolling back in a few secs |
| 05:50.17 | Foxy | what card? or driver set |
| 05:50.24 | Foxy | I would :-D |
| 05:50.36 | Anaxent | this box is a gf 5700 ultra |
| 05:50.44 | Foxy | oh my... |
| 05:51.34 | Anaxent | yeah... amd 64 3200 but 764 chipset |
| 05:52.00 | Anaxent | so no pci-x slots |
| 05:52.08 | Foxy | Zeryl (228.647977829) |
| 05:52.15 | Anaxent | and a very out dated card IMO |
| 05:52.46 | Foxy | I have an ATI 9800 :-) |
| 05:52.46 | Foxy | talk about out dated |
| 05:52.52 | Anaxent | brb rebooting |
| 05:53.36 | Zeryl | what was that foxy? |
| 05:54.00 | Foxy | execution time on your server for updating db |
| 05:54.34 | Zeryl | heh |
| 05:54.40 | Zeryl | i'm doing some other work too ;) |
| 05:55.01 | Zeryl | moving everything to 1 query |
| 05:55.07 | Foxy | augh... sorry don't mean to kill the processor :S |
| 05:55.19 | Zeryl | heh, np |
| 05:55.45 | Foxy | test server isn't dev machine right? :$ |
| 05:55.51 | Zeryl | oth |
| 05:55.53 | Zeryl | bot* |
| 05:55.55 | Zeryl | both* |
| 05:55.56 | Zeryl | lol |
| 05:56.03 | Foxy | doh! |
| 05:56.19 | Zeryl | it's really not liking the queries for some reason :( |
| 05:58.00 | Zeryl | wow, the mysql stuff is pegging the server.... |
| 05:59.40 | Foxy | yeah that's a lot of processor usage... |
| 05:59.59 | Foxy | mine was spiked for a while |
| 06:00.41 | *** join/#wowroster Anaxent (n=Anaxent@ip72-208-134-254.ph.ph.cox.net) |
| 06:00.41 | *** mode/#wowroster [+o Anaxent] by ChanServ |
| 06:01.28 | Anaxent | ok new drivers installed and everything so far feels ok |
| 06:02.24 | Zeryl | wow, you can't chain updates :( |
| 06:03.44 | Foxy | well that puts a stop to a speedy update... hum... |
| 06:04.25 | Zeryl | ya :( |
| 06:06.26 | Anaxent | woot my issue is fixed |
| 06:07.02 | Foxy | kewl wb to the world of no frame lag :-D |
| 06:07.58 | Anaxent | haha yeah it feels great |
| 06:09.13 | Zeryl | alright, i'll talk to you all later. I'm gonna think of how to do this cleaner |
| 06:09.28 | Foxy | laterz |
| 08:47.38 | *** join/#wowroster Vecna (i=Vecnah@vecna.vecnix.net) |
| 09:41.45 | *** join/#wowroster [Beercow] (n=happysl@1304ds1-ksa.0.fullrate.dk) |
| 10:02.26 | *** join/#wowroster [Beercow] (n=happysl@1304ds1-ksa.0.fullrate.dk) |
| 14:33.23 | *** join/#wowroster Guest620 (n=Guest@202.65.241.252) |
| 14:42.02 | *** join/#wowroster Vecna (i=Vecnah@vecna.vecnix.net) |
| 14:53.04 | *** join/#wowroster Kieeps (i=a@c-f641e353.033-8-6b736412.cust.bredbandsbolaget.se) |
| 16:15.42 | *** join/#wowroster Foxy (i=CPGMembe@dhcp3-66-244-107-188.stfd.smithvilledsl.net) |
| 16:16.08 | Foxy | Hello! 8) |
| 17:04.01 | *** join/#wowroster Guest439 (n=Guest@cpc2-stap6-0-0-cust91.nott.cable.ntl.com) |
| 17:22.38 | *** join/#wowroster Anaxent_w (n=chatzill@209-250-16-194.convergentaz.net) |