On of my main roster is overhere : http://www.les-potes-ages.fr/roster/

They asked if they could have a second roster - for their H2 clan - on another EU server (Khaz Modan).

No hassle, I said to myself, I tried the Armory Guild Insert and Update function.
This really works

Nevertheless, I found two issues:

What I found is that the keys addon aborted with an SQL error. (normally, should have an empty list, none of the 4 members should have any keys, becuase this info isn't present when updating with the Armory).

First thing : these database fields in the roster2_guilds table aren't set by Armory :
- faction
- factionEn
These values are retrieved by the Armory - they just have to be assigend into the database table.

One of those fields is used in keys addon, so its normal it barks.

Next issue :
open addon/keys/locale/frFR.php
It should read

Code: Select all

$lang['inst_keys']['H'] = array(

instead of

Code: Select all

$inst_keys['H'] = array(

Only frFR.phpp has this error.
Other language files seem to be ok.

So what has faction and factionEn to be set? Armory has only a factionid.

'faction' is the localized faction name
'factionEn' is the English translation

poetter wrote:So what has faction and factionEn to be set? Armory has only a factionid.

Well
roster2_guilde.factionEn = 'Alliance'
roster2_guilde.faction = 'Alliance'
(these two are set like this for a french roster)

I saw in the full data logs from AS, when grabbing a H2 Guild from Blizzard, that these values were present.
I was looking for these, because I found out that these fields were empty in the guilde table after the init.
The keys addon was complaining about being column value 'factionEn' being an empty string here:

Code: Select all

$items = $roster->locale->act['inst_keys'][ substr($roster->data['factionEn'],0,1) ];

I didn't didn't find a translation table like
faction => factionEn ......

($roster->locale->act['inst_keys']'[H'] - wasn't set neither for French language only, see my other post = other bug )