| 00:30.29 | *** join/#wowroster AnthonyB (n=Anthony@124-168-176-195.dyn.iinet.net.au) |
| 00:30.29 | *** mode/#wowroster [+o AnthonyB] by ChanServ |
| 02:21.09 | *** join/#wowroster dracula (i=dracula@dhcp-077-251-023-107.chello.nl) |
| 02:46.20 | *** join/#wowroster poetter (n=poetter@e177165076.adsl.alicedsl.de) |
| 05:20.38 | *** join/#wowroster dracula (i=dracula@dhcp-077-251-023-107.chello.nl) |
| 07:00.21 | *** join/#wowroster Boyo (n=Boyo@pool-71-244-225-232.chi01.dsl-w.verizon.net) |
| 07:01.10 | *** join/#wowroster PleegWat (n=PleegWat@212-123-189-114.ip.telfort.nl) |
| 07:01.10 | *** mode/#wowroster [+o PleegWat] by ChanServ |
| 07:22.14 | *** join/#wowroster PleegWat|Work (n=ple@82-148-206-57.fiber.unet.nl) |
| 07:22.14 | *** mode/#wowroster [+o PleegWat|Work] by ChanServ |
| 07:47.58 | *** join/#wowroster Tupsi (n=Miranda@217.7.101.202) |
| 15:07.33 | *** join/#wowroster Zanix|Work (n=Zanix@71.216.154.51) |
| 15:07.33 | *** mode/#wowroster [+o Zanix|Work] by ChanServ |
| 17:05.15 | Zanix|Work | morning |
| 17:16.52 | *** join/#wowroster Gaxme (n=chatzill@64.247.200.42) |
| 17:18.47 | Gaxme | Heya. |
| 17:18.57 | Zanix|Work | hi |
| 17:19.00 | Gaxme | Ok, digging my way through the way the roster item DB is loaded. |
| 17:19.18 | Gaxme | What process does the item tooltip go through to get colorized? |
| 17:23.38 | Gaxme | Essentially I just want a way to hijack the tooltip data off the armory and colorize it. |
| 17:23.52 | Gaxme | Since it appears that items stored in the main database are associated with specific members. |
| 17:26.56 | Gaxme | Ahh, nevermind, I found it. |
| 17:27.19 | Gaxme | But it's private to the item lib. So... I need to figure out a way to pull armory data and parse it through that. The armory parse mode should work, I guess. |
| 17:29.17 | Gaxme | Hmm. |
| 17:29.26 | Gaxme | The armory code is all commented out. |
| 17:29.53 | Gaxme | Sooo... Hmmm. I need to grab the HTML tooltip, then force a colorization somehow. |
| 17:30.35 | Gaxme | Or beg for _makeTooltipHTML() to be made to accept a tooltip as an argument, or insert a new function. |
| 17:31.19 | Gaxme | Or I'm missing something. |
| 17:31.20 | Gaxme | LOL |
| 17:31.31 | Gaxme | See, there I go thinking out loud again. |
| 17:38.18 | Gaxme | Why do I keep forgetting this. $roster->data['locale'], or where is that stored? |
| 17:39.48 | Zanix|Work | $roster->config['locale'] |
| 17:40.16 | Gaxme | Thank you. *sigh*] |
| 17:40.42 | Zanix|Work | $roster->data is the scope/anchor data |
| 17:40.54 | Zanix|Work | $roster->config is what is in RosterCP |
| 17:42.44 | Zanix|Work | I would see how poetter does it in AS |
| 17:43.12 | Zanix|Work | because he gets the tooltip data and stores it in the items table |
| 18:02.58 | Zanix|Work | so my company is re-doing our site |
| 18:03.19 | Zanix|Work | and I found a checklist of step to take for this process |
| 18:03.26 | Zanix|Work | and now im stuck on what Im doing |
| 18:03.32 | Zanix|Work | lol |
| 18:09.58 | Gaxme | Stuck on your checklist |
| 18:10.01 | Gaxme | ? |
| 18:16.59 | Zanix|Work | naw, found on on the net |
| 18:38.51 | Zanix|Work | I usually have a problem between a checklist or outline and actually beginning the process |
| 19:32.02 | *** join/#wowroster Boyo (n=Boyo@pool-71-244-225-232.chi01.dsl-w.verizon.net) |
| 20:16.20 | Gaxme | Hrm, well, it appears that armorysync still stores in the regular table since it's associated with members. |
| 20:16.39 | Gaxme | If I don't want to be loading the items every time, I'm probably going to have to make a new table. |
| 20:16.48 | Gaxme | Which does beg an overall design question. |
| 20:17.36 | Gaxme | I know that info and armorysync both use roster_items. Vault uses its own table, and it seems mine will use its own table. |
| 20:18.42 | Gaxme | From what I can tell vault just substitutes guild_id for member_id, and mine is essentially going to be a table that exists independent of member or guild association. (Raw items by locale) |
| 20:19.07 | Gaxme | Would we be better off having one global items database that everything writes to, and having addons (info, vault, etc) just create linking tables that have additional data? |
| 20:19.36 | Gaxme | Otherwise we're potentially swelling three item databases, perhaps more if people write more addons. |
| 20:21.00 | PleegWat | We're planning to do that for the next version |
| 20:21.16 | PleegWat | But calvin has been planning the same for some time, so we've been more or less waiting for that. And it wasn't on our 2.0 shortlist |
| 20:21.27 | Gaxme | Gotcha. |
| 20:21.51 | Gaxme | Well, I'll write this with that in mind. |
| 20:22.02 | Gaxme | Going to want item expiration caps as well, I'd guess. |
| 20:22.05 | Gaxme | Since items can change. |
| 20:24.15 | Gaxme | Could really be basically the same structure, just adding in last_update and a couple other additional fields. |
| 20:24.41 | Gaxme | And adding in a couple code hooks to the item class for fetching and parsing from the armory for updates. |
| 20:24.56 | Gaxme | Thinking out loud again. =) |
| 20:25.31 | Gaxme | Hmm, can you do me a favor? See if you can hit the US armory? http://armory.worldofwarcraft.com |
| 20:25.34 | Gaxme | Seems to be down for me. |
| 20:26.22 | Gaxme | Which also means my timeout isn't working. Heh. |
| 20:33.55 | *** join/#wowroster TisBoyo (n=Boyo@pool-71-244-225-232.chi01.dsl-w.verizon.net) |
| 20:34.13 | *** join/#wowroster Boyo (n=Boyo@pool-71-244-225-232.chi01.dsl-w.verizon.net) |
| 21:13.20 | Zanix|Work | yeah, armory is timing out for me as well |
| 21:13.22 | *** join/#wowroster shaitian (n=shaitian@host86-142-244-79.range86-142.btcentralplus.com) |
| 21:31.05 | shaitian | Anyone here that can answer a support question on Roster 2.0? |
| 21:35.33 | Gaxme | Other than "It's beta"? =) |
| 21:35.36 | Gaxme | Can try. |
| 21:36.14 | shaitian | Well I know that and if found issue then would report it but it is a big one so doudt it and is me |
| 21:36.50 | PleegWat | just explain the question? |
| 21:36.58 | shaitian | when I go in the Addon Manager and say Install any of the addons there the Config_addons table in databse is removed |
| 21:37.10 | PleegWat | that's weird |
| 21:37.13 | PleegWat | what addon, or any? |
| 21:37.39 | PleegWat | Can you copy me the query log, and the php error box (if any)? |
| 21:37.51 | shaitian | guess any but only did the two character and memberlist ones |
| 21:38.18 | shaitian | it appears to install correctly but when reload it errors and says cannot find the table |
| 21:38.30 | shaitian | looking in the databse I see the table is gone |
| 21:39.28 | shaitian | just done a frsh install, ie whiped database etc |
| 21:40.02 | PleegWat | I need the query log, to find out what query dropped the table and at what file/line |
| 21:40.52 | shaitian | ok will have to do that after doing a fresh install again |
| 21:41.40 | shaitian | so try and install new addon and display the query it producues? |
| 21:41.58 | PleegWat | copy/paste the entire query log please |
| 21:42.39 | shaitian | ok give me a couple of mins |
| 21:42.45 | PleegWat | use www.wowroster.net/pastebin |
| 21:47.00 | Gaxme | Think that's part of the rollback? |
| 21:47.41 | PleegWat | I think it's probably a rollback bug |
| 21:47.47 | Gaxme | *nod |
| 21:47.52 | PleegWat | shaitian, are temp tables on/off? |
| 21:49.03 | shaitian | where check that? |
| 21:49.09 | PleegWat | roster config. |
| 21:49.22 | PleegWat | If you didn't touch it, the default's to use them. |
| 21:49.34 | PleegWat | Just get me the query log. It'll tell me. |
| 21:53.01 | Gaxme | Hrm, Pleeg, you remember if you can add a datefiled to the database with default NOW() ? |
| 21:53.17 | Gaxme | ie: `last_update` datetime NOT NULL default 'NOW()', |
| 21:53.36 | PleegWat | default NULL, iirc. |
| 21:53.38 | PleegWat | check the manual |
| 21:53.47 | Gaxme | Will do. |
| 21:53.48 | PleegWat | it's something like that, and it's possible |
| 21:55.25 | Gaxme | Hmm, can't be a constant or an expression, but it works for timestamps. |
| 21:55.39 | Gaxme | So, timestamp it is! |
| 21:56.25 | shaitian | ok this is silly question, where is the Query log stored? |
| 21:56.41 | PleegWat | bottom of the screen |
| 21:57.15 | shaitian | have box labeled PHP Errors and then one with SQL queries |
| 21:57.23 | PleegWat | those are the ones |
| 21:57.29 | PleegWat | give me both in the pastebin |
| 21:57.52 | shaitian | turned on extended so will be lot of stuff |
| 21:57.55 | shaitian | that is ok? |
| 21:57.58 | PleegWat | ya |
| 22:00.34 | shaitian | ok done |
| 22:02.03 | shaitian | did not explain in it what I did but just posted the stuff after I clicked the blue install buttin |
| 22:03.07 | PleegWat | k good |
| 22:04.58 | shaitian | hope it helps, is a strange one and am sure it is me |
| 22:05.21 | PleegWat | create pages/test.php |
| 22:05.23 | PleegWat | contents: |
| 22:05.57 | PleegWat | <?php $roster->db->query("CREATE TEMPORARY TABLE `test` (id int);"); |
| 22:06.04 | PleegWat | Then go to index.php?p=test |
| 22:06.12 | PleegWat | ]and tell me if there's error output |
| 22:06.29 | PleegWat | hm, damn. You may need to reinstall first. |
| 22:07.27 | shaitian | ok np, give me a min |
| 22:11.25 | shaitian | databse error |
| 22:11.34 | shaitian | 1044: Access denied for user 'guildill4'@'%' to database 'guildill4' |
| 22:12.49 | PleegWat | huh? |
| 22:13.08 | PleegWat | hm, may be what I'm suspecting anyway |
| 22:13.14 | PleegWat | rest of the page renders properly? |
| 22:13.37 | shaitian | http://www.guild-illusion.com/TestSite/phpBB2/roster/index.php?p=test |
| 22:13.39 | shaitian | yes |
| 22:13.50 | PleegWat | It is what i expected then. |
| 22:14.00 | PleegWat | You're unable to create temp tables |
| 22:14.04 | PleegWat | There's an option to turn them off |
| 22:14.16 | PleegWat | but appearantly it fails spectacularly if you leave that one on |
| 22:14.21 | PleegWat | I'll see if i can make a test |
| 22:15.18 | shaitian | so yuo want me to change the temporty table setting to off then? |
| 22:15.22 | PleegWat | yes |
| 22:18.57 | shaitian | fail, I set a admin password and got it wrong in both boxes so now no idea what it is |
| 22:22.38 | shaitian | Thanks, worked fine this time with tables turned off |
| 22:23.47 | Zanix|Work | yeah, some people do not have TEMPORARY access on databases |
| 22:24.02 | PleegWat | committing a fix |
| 22:24.20 | Zanix|Work | and most addons use the same config table for config options, so the addon installer makes a backup table |
| 22:24.56 | PleegWat | It basically runs the query up there, and if it gets an error it will turn temp tables off |
| 22:26.18 | PleegWat | going off for bed. Night. |
| 22:27.26 | Gaxme | Night, Pleeg. I'm off to head home. =) |
| 22:27.45 | Gaxme | Back on later. This grabbing armory thing has me obsessed. Heh |
| 22:28.29 | shaitian | thanks for help and glad I was able to help with an issue |
| 22:30.43 | Zanix|Work | good night PleegWat |