Nice that it worked out for you

The admin folder contains the code (embryo status) for managing the addon in the ..... roster addon config section.
Have a look at the Keys_BC addon (soon to be abandoned), you'll find the same folder. The admin section in the roster shows says you what is does (will do).

I’m pretty sure that Pleegwat already mentioned this in a recent post.

What your are doing right now is looking at the "bleeding edge code corner" of WoWRoster.net
Code pops up, is pasted away, and changes all the time.

Taking code from there for your live roster site could be helpfull, but also dangerous.

"Be careful out there"

I inserted 1 more requirement to the "Temple" definition on my own roster. Added at line 220

Code: Select all

                'Q|Akama\\\'s Promise|1||1',
++                'R|Ashtongue Deathsworn|1925||1',
                'Q|The Secret Compromised|1||1',


A lot of people will have done all quests up to "Akama's Promise" and after that you don't have a quest anymore so the Key addon couldn't track it anymore.
The next quest is picked up at Karathress in SSC, and not everyone will get to that point so quickly. With this line added people can still track their progress of the questline at this stage since you will have 1925 reputation with the Ashtongue Deathsworn if you've done the questline this far.
The only thing that slightly bothers me is that I can't put a nice description for the tooltip but that's something I can live with

Where did you add the "'R|Ashtongue Deathsworn|1925||1" line? It sounds like the perfect solution for the problem so far, but I can't seem to find it anywhere in my Key BC folder. The only file I see to edit is install_enUS.

This is not for key_bc, this is for the keys addon included with Roster

foreseit wrote:Where did you add the "'R|Ashtongue Deathsworn|1925||1" line? It sounds like the perfect solution for the problem so far, but I can't seem to find it anywhere in my Key BC folder. The only file I see to edit is install_enUS.

Yes, I added it to install_enUS.php (which is in the locale) dir indeed. Mind you, this doesn't change the database, uninstall and install the keys addon after the change to update the database.

Ah! It is all clear now... lol. I was confused. >< Now all my efforts to translate Keys BC is wasted. lol. oh well. (note to self, L2 double check forums faster)

OK. I was about to pull my hair out doing the manual updating via webSVN. Then I tried re-uploading my CP.lua file, and it worked. whew! TY so much for the help.

On a different note... I remember before being able to click on the column title & it would open up the thottbot page for that particular key. I really like the sorting function, but would there be a way to bring back the ability to go to thottbot / wowhead / etc? Perhaps like with Made by where you can click the icon to come up with a selection of where to go? There would probably need to be something to click in the boxes that are empty.

I really like the hover tooltip for the column titles of Key BC, any plans to implement that?

(ok. enough suggestions from the peanut gallery) Thanks again for all your work.

Doing stuff with the header bar is not currently supported by the memberslist library (which generates the key page). I'll look into hooking up item links somewhere.

I've also been considering putting in a larger key overview when left-clicking a key location.

I move to new hosting machine with php5.1 and mysql 5

And now i get

Code: Select all

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 1
SQL:
INSERT INTO `roster_addons_keys_keycache` (`member_id`, `key_name`, `stage`) SELECT '344', `stages`.`key_name`, `stages`.`stage` FROM `roster_addons_keys_stages` AS stages, `roster_reputation` AS data WHERE `stages`.`locale` = 'esES' AND `stages`.`faction` = 'H' AND `data`.`member_id` = '344' AND `stages`.`type` = 'R' AND `data`.`name` = `stages`.`value` AND `stages`.`count` <= `data`.`curr_rep` + CASE `data`.`Standing` END;
File: lib/dbal/mysql.php
Line: 235

For next version you can add Mount Hyjal Submit "key" ?

Code: Select all

   'MH' => array(
      'Q|The Vials of Eternity|1||1',
      'In|Vash\\\'s Vial Remnant|1|()|1',
      'In|Kael\\\'s Vial Remnant|1|()|1',
      'R|The Scale of the Sands|1||1',
      'Key|inv_potion_101|'
   )

Hm, it seems it's not loading the nonactive locale translation files. I'll look into it.

As well the rogues with correct lockpicking skill are not take in care in all keys :/

Like SG in horde (its only avaible from a rogue with LP 275)

I fixed the locale loading in the latest SVN.

The lockpicking thing, is that a data issue or a detection issue? Is the correct required lockpicking in the DB? Is the correct lockpicking level in the DB for the rogue who is incorrectly reported as not being able to pick the lock? Has the rogue with the issue uploaded since the lockpicking definition was last updated (or the addon was last reinstalled)?

Hello,
I'm playing with the German client of WoW and translated the Keys Addon for everybody:

deDE.php

Code: Select all

<?php
/**
 * WoWRoster.net WoWRoster
 *
 * LICENSE: Licensed under the Creative Commons
 *          "Attribution-NonCommercial-ShareAlike 2.5" license
 *
 * deDE Locale
 *
 * @copyright  2002-2007 WoWRoster.net
 * @license    http://creativecommons.org/licenses/by-nc-sa/2.5   Creative Commons "Attribution-NonCommercial-ShareAlike 2.5"
 * @version    SVN: $Id: deDE.php 1696 2008-02-19 21:52:03Z pleegwat $
 * @link       http://www.wowroster.net
 * @package    InstanceKeys
 * @subpackage Locale
*/

$lang['keys'] = 'Schlüssel';
$lang['keys_desc'] = 'Listet Instanzschlüssel von Gildenmitgliedern auf';
$lang['keybutton'] = 'Schlüssel|Listet Instanzschlüssel von Gildenmitgliedern auf';

$lang['admin']['keys_conf'] = 'Main Settings|Main Settings for Instance Keys';
$lang['admin']['keys_cats'] = 'Categories|Define what keys to show in what categories';
$lang['admin']['colorcmp'] = 'Completed Color|Color of complete steps in the Quests/Parts tooltip';
$lang['admin']['colorcur'] = 'Current Color|Color of current step in the Quests/Parts tooltip';
$lang['admin']['colorno'] = 'Incomplete Color|Color of incomplete steps in the Quests/Parts tooltip';
$lang['admin']['keys_access'] = 'Access|Set who can view the keys list';

// language definitions for the rogue instance keys 'fix'
$lang['thievestools']='Diebeswerkzeug';
$lang['lockpicking']='Schlossknacken';

$lang['Quests'] = 'Quests';
$lang['Parts'] = 'Parts';
$lang['key_status'] = '%1$s %2$s Status';

$lang['rep2level'] = array(
    'Hasserfüllt' => -42000,
    'Feindselig' => -6000,
    'Unfreundlich' => -3000,
    'Neutral' => 0,
    'Freundlich' => 3000,
    'Wohlwollend' => 9000,
    'Respektvoll' => 21000,
    'Ehrfürchtig' => 42000
);
 

and install_deDE.php

Code: Select all

have a nice day :-)