00:07.24 | Zanix | to anyone that uses UniAdmin, im releasing 0.7.6 soon |
00:08.03 | Anaxent_w | WOOT!!! WOOT!!! |
00:09.00 | Devlinm | hey zanix |
00:09.04 | Zanix | hiya Devlinm |
00:09.15 | Zanix | did you get what I said a few lines up? |
00:10.26 | Foxy378 | UniAdmin woot! :D |
00:11.33 | Devlinm | When you free up zanix, I was wondering if you could take a look at that issue on my site |
00:11.50 | Zanix | guess you didnt get what I said then |
00:12.06 | Zanix | Id like you to install the standalone version of roster on your server |
00:12.13 | Anaxent_w | line 383 of wowdb.php error right |
00:12.15 | Zanix | and siggen with it |
00:12.52 | Devlinm | alright |
00:21.27 | Zanix | I wanna see if that fails as well |
00:27.29 | Foxy378 | other than char and guild is there any other modes to an update? |
00:29.03 | Zeryl | tp://www.filecabi.net/video/NOPDcalledtoarrestcrazydruggedman.htmlhttp://www.filecabi.net/video/NOPDcalledtoarrestcrazydruggedman.html |
00:29.11 | Devlinm | its uploading now |
00:32.57 | Foxy378 | lol, man that guy is messed up lol |
00:33.15 | Foxy378 | yeah mace the druged up guy that'll work |
00:34.28 | Devlinm | ok, one sec man, my dtp client keeps dropping getting a new one |
00:41.16 | Zanix | I may be afk for periods of time |
00:46.12 | Devlinm | that is fine, as you see i may not answer right away aswell |
00:47.44 | Foxy378 | Hum... this is strange :P It seems to be triggering but the file is not being parsed... |
00:48.08 | Anaxent_w | could file size be an issue with trigger files Zanix? |
00:48.28 | Zeryl | it was parsing for me foxy |
00:50.03 | Foxy378 | did you get an empty row inserted into the database? |
00:56.54 | Zeryl | one thing I see, is that you are assigning variables, but not doing anything with them |
00:57.20 | Zeryl | move your queries into the same area as the if(is_array($value)) area |
00:57.53 | Devlinm | i never realized how many files are in that package, grrrr |
01:00.14 | *** join/#wowroster Guest (n=Guest@CPE-72-131-97-106.wi.res.rr.com) |
01:05.54 | Devlinm | im chmod the files now |
01:07.14 | Foxy378 | now nothing is inserted, not even a blank row |
01:10.14 | Zeryl | http://www.convictionofsuramar.com/pastebin/74http://www.convictionofsuramar.com/pastebin/74 |
01:10.17 | Zeryl | http://www.convictionofsuramar.com/pastebin/74 |
01:10.21 | Zeryl | modify your code to look like that |
01:13.35 | *** join/#wowroster Guest056 (i=CPGGuest@116-33.35-65.tampabay.res.rr.com) |
01:13.54 | Guest056 | . |
01:14.01 | Guest056 | fucking fags:^) |
01:14.16 | Zeryl | hrmm, ok |
01:15.27 | *** mode/#wowroster [+o Zeryl] by ChanServ |
01:15.34 | *** mode/#wowroster [+b *!?=Guest@*.tampabar.res.rr.com] by Zeryl |
01:19.07 | Zeryl | I need to figure out how to make this use a ton less queries |
01:19.26 | Devlinm | alright zanix |
01:21.03 | Zeryl | 108 seconds to update 7500 rows :( |
01:21.13 | Anaxent_w | ew |
01:21.45 | Zeryl | maybe an index on the columns i'm pulling on |
01:22.23 | Foxy378 | Zeryl... maybe I've just lost it but that change still gives me nothin |
01:22.27 | Foxy378 | nothing* |
01:22.38 | Zeryl | you did over-write your upload.php w/ mine right? |
01:23.52 | Foxy378 | yeah seen the changes there too... I just had made mine out of order it looked... but yes over wrote it |
01:24.01 | Foxy378 | trigger now works.. |
01:24.18 | Foxy378 | but the array seems to not be parsing? |
01:24.51 | Zeryl | it's doing fine for me it seems |
01:25.05 | Foxy378 | :? |
01:27.58 | Zeryl | ok, so I got it down to 3seconds for updates! |
01:28.12 | Zeryl | added quite a few index's |
01:32.04 | Foxy378 | I must be a tard or something I can't even get this working on my end... at least in the roster addon form |
01:32.08 | Zeryl | one sec |
01:32.16 | Zeryl | it's NOT working here |
01:33.21 | Zeryl | NSERT INTO `roster_gatherer_nodes` (continent, zone, node, gtype, xPos, yPos, count, lastharvest, lastinspect, collector) VALUES('', 'AZSHARA', '2850', 'OPEN', '0.3195', '0.5151', '0', '0', '0', 'IMPORTED'); |
01:33.25 | Zeryl | i have a ton of those |
01:34.30 | Zeryl | in your block where you assign variables, add in echo(<<<<yoursql statement here>>>>); |
01:40.51 | Zeryl | way down, 108 seconds -> 5.1 seconds |
01:42.04 | Foxy378 | if we're both on the same page I should have my functions.php looking like this? http://www.convictionofsuramar.com/pastebin/75 |
01:42.31 | Zeryl | foreach ($GatherData |
01:44.23 | Zeryl | do you have more nodes in a newer file? |
01:45.41 | Foxy378 | perhaps but I have been using the same file to test with the past few days |
01:46.10 | Foxy378 | I haven't been using the most recent copy from my WTF directory |
01:46.51 | Zeryl | i just found a file w/ 15386 data points |
01:52.06 | Zeryl | but it doesn't seem to jive very well with the data I am currently using fromy ou |
01:53.02 | Foxy378 | you're most likely looking at a version from pre- 2.0 gatherer... |
01:54.00 | Zeryl | ya, i'm guessing that's it |
01:54.22 | Zeryl | http://gather.reet.org/ |
01:54.37 | Foxy378 | yeah... that's the tsv files... |
01:54.42 | Zeryl | ya |
01:54.52 | Zeryl | have you imported those |
01:55.16 | Foxy378 | I did in my model database... seen here: gatherer.dragonkillers.us |
01:55.30 | Zeryl | should i import those? |
01:55.32 | Zeryl | I can do that |
01:56.17 | Foxy378 | I had planned to do that, I just want to get the parser going... so later others can add to it for Outlands and what not |
01:56.31 | Zeryl | I'm not sure if tainting the data with it is worth it |
01:57.25 | Foxy378 | the data on that site was submitted via uploads over 6+ months... |
01:57.56 | Foxy378 | the only tainting would be bad data nodes submitted by anyone you don't trust right? |
01:58.10 | Foxy378 | or am I missing something? |
01:58.33 | Zeryl | well, I just don't know if the nodes int hat file are similar to the way the ones from the current gatherer are |
01:58.39 | Zeryl | if that makes sense |
01:58.57 | Foxy378 | they are... |
01:59.04 | Foxy378 | sec... |
01:59.06 | Zeryl | then I guess I could import them |
01:59.21 | Zeryl | and the way I was going to deal with tainted data, is a required 5uploads of the data |
02:01.03 | Foxy378 | I had the same idea except the number of uploads would be higher for public rosters ;D |
02:01.14 | Foxy378 | gatherer.dragonkillers.us/gatherer1.zip |
02:01.30 | Foxy378 | that is the TSV files moved to mysql |
02:01.42 | Foxy378 | the structure is not far off what we have here |
02:01.50 | Zeryl | right |
02:02.03 | Foxy378 | instead of using node numbers he parsed them as names |
02:02.04 | Zeryl | the only issue i'm thinking of, is a node in your file vs a node int eh tsv being like .001 coords off |
02:02.23 | Foxy378 | oh oh I see... |
02:02.42 | Zeryl | but I guess that really is the problem with ANY of these, and soem sort of back-end logic would need to be applied |
02:03.16 | Foxy378 | sure a tolerance for node positioning... |
02:03.35 | Foxy378 | that's what your getting at yeah? |
02:04.09 | Zeryl | ya |
02:04.24 | Zeryl | a bad thing in the tsv is that there isn't a "map" |
02:04.26 | Zeryl | location |
02:04.46 | Foxy378 | nope, see my files for the correction :-) |
02:04.48 | Zeryl | nevermind, i see it |
02:05.01 | Foxy378 | :-D |
02:05.27 | Foxy378 | map is Zone # |
02:06.24 | Foxy378 | the way I approached the mapping was via http://www.wowwiki.com/LocalizedMapZones |
02:06.49 | Zeryl | ahh |
02:06.58 | Foxy378 | this seems to be or at least had been the approach of those making mods for wow utilizing maps |
02:08.10 | Foxy378 | so my thought was if I had a parser to use and insert the data, extracting it to a map system and even making it use other languages (French and German perhaps) would not be a problem |
02:08.19 | Zeryl | ya |
02:08.42 | Foxy378 | back to [] - 1 the parser hehe |
02:10.57 | Zeryl | i'm just happy i got my parse time down so much |
02:11.06 | Zeryl | i mean 108+ seconds down to 14 |
02:11.21 | Foxy378 | that's awsome btw 8) |
02:12.00 | Foxy378 | that's on parsing it local though right not via the roster update.php on a remote? |
02:12.15 | Zeryl | its all the mysql stuff |
02:12.38 | Foxy378 | did you find a way to chain it or something |
02:12.55 | Zeryl | nope |
02:12.58 | Zeryl | i added indexes |
02:13.12 | Zeryl | which makes it know where certain things are without having to look through all the records |
02:14.36 | Foxy378 | 04*Foxy looks for Gnome engineering device to tap into Zeryl's brain and extract all knowledge* |
02:15.13 | Zeryl | http://www.databasejournal.com/features/mysql/article.php/1382791 |
02:16.55 | Foxy378 | ^Good read |
02:17.19 | Zeryl | ya |
02:20.59 | Guest | i seem to be stuck, i am using joomla and i want to use wowroster. i chose to "wraP" wowroster, but sadly joomla's menu really crowds the wowroster. is there a fix? thanks! |
02:21.15 | Zeryl | I don't know if anyone has created a joomla wrapper |
02:21.29 | Zeryl | so I'm not exactly sure how it would work :( |
02:21.33 | Guest | it built into the menu options |
02:22.04 | Foxy378 | Guest, I tried something like that with PHPNuke and found issues too... I wou;d suggest using the standalone version of roster |
02:22.18 | Foxy378 | would* |
02:23.00 | Guest | only issue i seem to run into with that is, the navigation back could be an issue for less web savvy types i fear |
02:23.13 | Guest | back to the home page more or less |
02:23.31 | Foxy378 | By clicking the top banner on the roster you go to the site root |
02:23.53 | separer | ah! sorry i am new, and thanks for the help! |
02:24.04 | separer | totally expected to get flamed lol |
02:24.04 | Foxy378 | no problem :D |
02:24.13 | separer | :band |
02:24.24 | Foxy378 | na the flame is reserved for me typing in blue hehe |
02:26.01 | Foxy378 | Zeryl you think I should just scrap making this a roster addon and stick to a standalone app? |
02:27.25 | Zeryl | i'm not sure |
02:29.24 | Anaxent_w | well if it can work as a standalone |
02:29.33 | Anaxent_w | why would it not work as an addon |
02:30.39 | Foxy378 | Um... I'm a tard and can't even get it to work as a standalone fully let alone bothering everyone to teach me how to bring it in to the roster addon form? |
02:30.56 | Zeryl | it's ready for an addon ;) |
02:31.02 | Foxy378 | ^ I admit it! ;) |
02:32.40 | Anaxent_w | ah lol no worries |
02:33.06 | Zeryl | hrmm, should i install vista? |
02:33.08 | Anaxent_w | well guys |
02:33.09 | Zeryl | i got a copy of it today |
02:33.15 | Anaxent_w | it is now time for me to hfinally head home |
02:33.23 | Zeryl | cya later anax |
02:33.23 | Anaxent_w | .... |
02:33.25 | Foxy378 | on a test pc maybe... |
02:33.34 | Foxy378 | later Anaxent |
02:33.36 | Anaxent_w | I do like vista for alot of what they offer now |
02:33.57 | Anaxent_w | but to fully switch over right after you reinstalled the other day |
02:34.05 | Zeryl | hehe |
02:34.06 | Zeryl | ghost ;) |
02:34.08 | Anaxent_w | yeah what Foxy378 said |
02:34.13 | Foxy378 | The big concern for me would be is it more or less stabel (security) than XP when it released |
02:34.15 | Anaxent_w | ghost would work as well |
02:34.38 | Anaxent_w | but yes pls test it for me let me know if it will be good for me to install or switch over |
02:34.46 | Anaxent_w | I love having ginee pigs |
02:34.48 | Anaxent_w | lol j/k |
02:34.50 | Foxy378 | ^ 8) |
02:34.51 | Anaxent_w | later guys |
02:34.53 | Zeryl | heh, okie |
02:35.02 | Zeryl | i'm gonna be out too, i'm gonna go to bed a bit early :) |
02:51.52 | *** join/#wowroster Guest (n=Guest@71-221-141-233.bois.qwest.net) |
02:52.07 | Guest | ahhhhg, I broke it!!! |
02:53.10 | *** mode/#wowroster [+o Zanix] by ChanServ |
02:53.41 | Zanix | stupid computer |
02:53.45 | Zanix | it failed on me |
02:53.54 | Zanix | and now I have to use my GF's laptop |
03:01.03 | Devlinm | its better then not having a pc |
03:03.11 | Devlinm | still the same error on the new site zanix, the version before this would show the pics but not save, so im sure its in my settings somwhere |
03:03.34 | Devlinm | dont know if it asks you to download index.php though like it did earlier |
03:08.28 | Zanix | can I have a url to an image? |
03:20.03 | Devlinm | http://turtle-face.com/~regulators/rosteraddons/siggen/sig.php?member=Devlinmckena |
03:22.20 | Zanix | 404 error |
03:25.19 | Devlinm | i see why, the code posted on the top is missing a / |
03:25.27 | Devlinm | http://turtle-face.com/~regulators/roster/addons/siggen/sig.php?member=Devlinmckena |
03:30.54 | Zanix | taking a long time to load |
03:31.05 | Devlinm | no crap |
03:31.30 | Zanix | i dunno, what version did you have before this one |
03:31.32 | Devlinm | now what about that fix for the call to member instead of name, is that in this newest version i just got from the site |
03:31.50 | Devlinm | i had the one that came with the df release |
03:32.05 | Zanix | well, DF already called it with member |
03:32.11 | Zanix | so it doesnt need fixed |
03:32.59 | Devlinm | hmmm, i dont know, it has got to be in my srver setup somwhere, cause both the standalone and the df port wont show pics |
03:34.04 | Devlinm | but that is alright man, ill figure it out, for now, i have to be at work by 4 in the morn, so sleep is a must. thank you for taking the time Zanix |
03:35.04 | Devlinm | later |
03:36.35 | *** join/#wowroster Guest (n=Guest@CPE-72-131-97-106.wi.res.rr.com) |
05:12.24 | *** join/#wowroster ds001 (n=ds001@w192.z064003020.sea-wa.dsl.cnc.net) [NETSPLIT VICTIM] |
05:12.24 | *** join/#wowroster dracula (i=dracula@89.98.217.142) [NETSPLIT VICTIM] |
08:43.04 | *** join/#wowroster Guest (n=Guest@pool-70-104-31-226.dllstx.fios.verizon.net) |
08:43.22 | Guest | h |
08:43.29 | Guest | :banana |
09:16.33 | *** join/#wowroster TinoM (n=Tino@i5387C2E5.versanet.de) |
09:16.33 | *** mode/#wowroster [+o TinoM] by ChanServ |
09:16.41 | TinoM | hi |
09:21.25 | PleegWat | hi |
09:21.55 | PleegWat | how's life? |
09:23.10 | TinoM | work, work :) |
09:25.40 | PleegWat | Similar here. Homework. |
09:34.07 | TinoM | wohha, i can still access the svn-rep |
09:35.14 | PleegWat | I don't think we ever clear the access files for that up |
09:36.09 | PleegWat | The localization format changes slightly. Instead of assigning strings to $wordings['deDE']['watever'] you assign to $lang['whatever'] and it's reassigned later |
09:36.27 | PleegWat | Makes copying english text to other langs easier |
09:39.57 | TinoM | nice |
10:07.55 | TinoM | hmm, 2 nested svn-repos are trouble |
10:08.28 | PleegWat | yeah, sounds likely |
10:09.26 | TinoM | but there has to be a easy way to put the Interface-icons into the roster1 structure.... |
10:10.14 | PleegWat | not that I know of |
10:10.27 | PleegWat | You can set roster to use interface icons from a different dir though |
10:16.18 | TinoM | perhaps the best solution, thx |
10:38.21 | *** join/#wowroster TinoM| (n=Tino@i5387D644.versanet.de) |
10:44.44 | *** join/#wowroster TinoM (n=Tino@i5387E697.versanet.de) |
10:44.44 | *** mode/#wowroster [+o TinoM] by ChanServ |
12:28.06 | *** join/#wowroster [Beercow] (n=happysl@1304ds1-ksa.0.fullrate.dk) |
13:54.06 | *** join/#wowroster Sylphid|work (n=gamesand@64.6.15.110.outfitters.com) |
14:35.42 | *** join/#wowroster DrWily (n=drwily@24.106.205.110) |
14:49.04 | *** join/#wowroster Harshmage (i=harshmag@bwitherspoontest.gc.maricopa.edu) |
17:19.12 | *** join/#wowroster Kieeps (i=a@c-f641e353.033-8-6b736412.cust.bredbandsbolaget.se) |
18:05.23 | *** join/#wowroster TinoM| (n=Tino@i5387E645.versanet.de) |
19:05.11 | *** join/#wowroster Guest (n=Guest@S0106000c76cd9256.ok.shawcable.net) |
19:05.37 | Guest | hello room |
19:06.27 | Guest | hello |
19:28.20 | lhunath | I wonder sometmes what possesses people to use that webirc thing |
19:28.29 | lhunath | say hello and leave |
19:29.12 | Zeryl | ya |
19:41.18 | *** join/#wowroster Sylphid|work_ (n=gamesand@64.6.15.110.outfitters.com) |
20:35.22 | PleegWat | Oooh, what does this button do? |
20:49.14 | *** join/#wowroster Anaxent (n=Anaxent@ip72-208-134-254.ph.ph.cox.net) |
20:49.14 | *** mode/#wowroster [+o Anaxent] by ChanServ |
21:49.22 | *** join/#wowroster Foxy (i=CPGMembe@dhcp3-66-244-107-188.stfd.smithvilledsl.net) |
21:49.33 | Foxy | hiyas |