| 01:21.02 | *** join/#wowroster AdricTW (n=Adric@cpe-24-33-126-185.cinci.res.rr.com) |
| 01:21.02 | *** mode/#wowroster [+o AdricTW] by ChanServ |
| 01:48.17 | *** join/#wowroster Zeryl_ (n=Zeryl@24-178-44-20.dhcp.sprt.il.charter.com) |
| 01:48.17 | *** mode/#wowroster [+o Zeryl_] by ChanServ |
| 02:46.27 | *** join/#wowroster poetter_ (n=poetter@e177163103.adsl.alicedsl.de) |
| 03:10.45 | *** join/#wowroster Zanix_Again (n=Zanix@69.92.238.219) |
| 03:12.29 | *** join/#wowroster Zanix__ (n=Zanix@69.92.238.219) |
| 03:14.56 | *** mode/#wowroster [+o Zanix] by ChanServ |
| 03:38.03 | *** join/#wowroster Zanix (n=Zanix@69.92.238.219) |
| 03:38.03 | *** mode/#wowroster [+o Zanix] by ChanServ |
| 06:39.58 | *** join/#wowroster Zanix_Again (n=Zanix@69.92.238.219) |
| 06:42.06 | *** mode/#wowroster [+o Zanix] by ChanServ |
| 07:16.34 | *** join/#wowroster PleegWat|Work (n=ple@82-148-206-57.fiber.unet.nl) |
| 07:16.34 | *** mode/#wowroster [+o PleegWat|Work] by ChanServ |
| 07:26.49 | *** join/#wowroster Tupsi (n=Miranda@217.7.101.202) |
| 15:10.22 | *** join/#wowroster Gaxme (n=chatzill@64.247.200.42) |
| 15:11.55 | Gaxme | Hola |
| 16:09.17 | *** join/#wowroster Zanix|Work (n=Zanix@71.216.154.51) |
| 16:09.17 | *** mode/#wowroster [+o Zanix|Work] by ChanServ |
| 18:04.22 | *** join/#wowroster Gaxme (n=chatzill@64.247.200.42) |
| 18:05.34 | Gaxme | Hmm, anyone around? Need to bounce locale string arrays vs. database off someone. =) |
| 18:05.58 | Zanix|Work | im here |
| 18:06.38 | Gaxme | Cool. |
| 18:07.04 | Gaxme | Ok, so, like we were discussing in that multi-guild thread, I've been using a mixture of database and arrays for data. |
| 18:07.32 | Gaxme | The locale arrays have a benefit that if a specific locale doesn't exist, it fails back to the English. |
| 18:08.15 | Gaxme | However, if I want to make it easier to update the list of say, bosses, I could create a database for it that contains their names, zones, and has a locale index, and parse by that. |
| 18:08.32 | Gaxme | It would allow me to put a frontend on for adding/changing/removing those strings at will, rather than file editing. |
| 18:09.26 | Gaxme | And would also allow database calls to pull combined data where it matches across all tables, rather than looping through an array and pulling each set out. |
| 18:10.03 | Zanix|Work | in my opionion, it is just as easy to update a file as it is for a db, from the developer side |
| 18:10.15 | Gaxme | Locale checking isn't hard for the database level, I suppose. |
| 18:10.25 | Zanix|Work | but from a user side, editing the db via an interface is easier than editing a file |
| 18:11.08 | Zanix|Work | the keys addon in 2.0 has moved to the second style |
| 18:11.11 | Gaxme | So the question really is does the content (zones and bosses specifically) change often enough to warrant putting a front end on it. |
| 18:11.28 | Zanix|Work | where the defaults are in a file |
| 18:11.43 | Gaxme | Hmm. |
| 18:12.37 | Gaxme | I suppose if the data was stored in the db, I could just populate it on install with the english locale, and if the $roster->['config']['locale'] string can't be found for the current version, it can just default back to enUS... |
| 18:13.20 | Gaxme | Then the side question, of course, is whether adding a handful of db calls is more intensive than looping an array. |
| 18:13.30 | Gaxme | On memory or processor. |
| 18:13.45 | Gaxme | Since I know that larger files get fairly memory intensive depending on which options are turned on. |
| 18:18.17 | Zanix|Work | true |
| 18:18.30 | Zanix|Work | php doesnt seem to handle arrays efficiently |
| 18:21.01 | Gaxme | I guess it seems more efficient to lean toward the database side. Can give out sql files to inject, and at some point add a front end for editing. |
| 20:25.03 | Gaxme | Hmm, is there a method in the dbal that handles reading in sql dumps? |
| 20:25.08 | Gaxme | You know what, I'll just look. =) |
| 20:25.30 | PleegWat | no, only single queries |
| 20:25.39 | PleegWat | If you need to run multiple, explode over ; |
| 20:25.43 | PleegWat | then run them one-by-one |
| 20:25.50 | PleegWat | watch for injection |
| 20:26.38 | Gaxme | Except it's got all the additional trash in it as well. Heh. |
| 20:26.54 | Gaxme | Guess I can force it to ignore that. |
| 20:27.29 | Gaxme | Hmm, actually, that's a different export format than I'm used to. |
| 20:27.46 | PleegWat | a sql dump consists of sql queries, which you can run one-by-one |
| 20:28.06 | PleegWat | Since you're loading into a precreated table, it's probably easier to use a pipe-delimited format |
| 20:28.11 | PleegWat | or comma, or whatever is handy |
| 20:28.34 | PleegWat | pipe is quite safe, it occurs in data much less often than comma |
| 20:28.41 | PleegWat | | |
| 20:29.50 | Gaxme | I just stuck it up on pastebin, at least it's default. You remember the command line for delimiter offhand? |
| 21:01.12 | Gaxme | Hmm, any objection to adding a companion file_reader function to the functions lib? |
| 21:05.42 | Zanix|Work | because we have a file_writer function? |
| 21:05.54 | Gaxme | Sure! |
| 21:06.00 | Gaxme | It really doesn't matter. |
| 21:06.09 | Gaxme | I'm going to write it either way, methinks. |
| 21:06.16 | Gaxme | Just didn't know if you'd want it in the lib or not. |
| 21:06.59 | Gaxme | Honestly, it's so small it's barely worth it. |
| 21:08.31 | Gaxme | Hell, may not even need it. I forgot about the sql infile thing. Hrm, however, that requires that the user has file access. |
| 21:08.41 | Gaxme | Which many hosts probably don't allow. |
| 21:08.56 | Zanix|Work | probably |
| 21:19.07 | Gaxme | Hmm, when an addon's install.def.php is being executed, are the $addon['dir'] strings already populated? |
| 21:22.07 | Gaxme | In particular $addon['basename']; |
| 21:22.08 | Gaxme | If not, I'll just pull the roster base and decend that way. |
| 21:22.12 | Gaxme | descend even |
| 21:26.38 | Zanix|Work | im not sure |
| 21:26.42 | Zanix|Work | let me look at the code |
| 22:36.39 | Gaxme | Gotta run, back tomorrow. =) |
| 23:07.56 | *** join/#wowroster luciver[oFF] (n=luciver@h1082.serverkompetenz.net) [NETSPLIT VICTIM] |
| 23:12.53 | *** join/#wowroster poetter (n=poetter@e177163103.adsl.alicedsl.de) |
| 23:16.37 | *** join/#wowroster PleegWat (n=PleegWat@212-123-189-114.ip.telfort.nl) [NETSPLIT VICTIM] |
| 23:16.37 | *** join/#wowroster poetter_ (n=poetter@e177163103.adsl.alicedsl.de) [NETSPLIT VICTIM] |
| 23:16.37 | *** mode/#wowroster [+o PleegWat] by irc.freenode.net |
| 23:21.44 | *** join/#wowroster PleegWat (n=PleegWat@212-123-189-114.ip.telfort.nl) [NETSPLIT VICTIM] |
| 23:21.45 | *** mode/#wowroster [+o PleegWat] by ChanServ |