List of all language keys and what they give access to

Does anyone know where I can get a list of all the List of all language keys and what they give access to?? 

They are in the database or you could open the file "/langs/lang-en.php" and see them all there.

Perfect thanks

Sorry to be a pain mscott, but what table are they in in the DB? I've had a look and can't see it, I'd prefer to update all my dolphin sites via a query over the interface as I have a few.

Thanks

It will not be as easy as you might think. There are two tables that hold the info you need.

The table sys_localization_keys holds the keys.

Then sys_localization_strings holds all the stings for each language which contains a reference to the keys ID.

It will not be a easy query if you intend to update via phpMyAdmin.



Updating via a script may be a lot easier. For example.

<?php

require_once('inc/header.inc.php');
require_once(BX_DIRECTORY_PATH_INC . 'db.inc.php');
require_once(BX_DIRECTORY_PATH_INC . 'design.inc.php');
require_once(BX_DIRECTORY_PATH_INC . 'languages.inc.php');
require_once(BX_DIRECTORY_PATH_INC . 'utils.inc.php');


$aLangKeys = array(
    '_dbcsName' => 'Name:',
    '_dbcsTitle' => 'Title:',
    '_dbcsUserLink' => 'User Link:',
    '_dbcsUserQuery' => 'User Query:',
    '_dbcsAdminLink' => 'Admin Link:',
    '_dbcsAdminQuery' => 'Admin Query:',
    '_dbcsIconName' => 'Icon Name:',
    '_dbcsSave' => 'Save',
    '_dbcsDelete' => 'Delete',
    '_dbcsCancel' => 'Cancel',
    '_dbcsSiteStatsManager' => 'Site Stats Manager',
    '_dbcsActiveItems' => 'Active Items',
    '_dbcsInactiveItems' => 'Inactive Items',
    '_dbcsAddNewSiteStatItem' => 'Add New Site Stat Item'
);


foreach ($aLangKeys as $sKey => $sValue) {
    updateStringInLanguage($sKey, $sValue);
}

if (!compileLanguage()) {
    echo "Error compiling language file.";
    exit;
}

?>

Ouch... but thanks Deano.. will play in my test environment first ;)