/**
* Gets the account language by id
*/
function getAccountLanguageById($uid)
{
global $application;
$tables = $this->getTables();
$columns = $tables['admin']['columns'];
$query = new DB_Select();
$query->AddSelectField($columns['lng'], 'lng');
$query->WhereValue($columns['id'], DB_EQ, $uid);
$info = $application->db->getDB_Result($query);
return @$info[0]['lng'];
}
/**
* Gets the news list.
*
* @param string $news_type - 'avactis' or 'store' - defines, if external or
* internal news is required.
* Added in case news is required not only for the administrator but also
* for the Avactis users.
* @return array - the latest news array, the length of which is
* NEWS_DISPLAY_COUNT parameter of the News module
*/
function getNewsList($news_type = 'avactis')
{
global $application;
$tables = $this->getTables();
$columns = $tables['news']['columns'];
$query = new DB_Select();
$query->AddSelectField($columns['title'], 'NewsTitle');
$query->AddSelectField($columns['link'], 'NewsLink');
$query->AddSelectField($columns['content'], 'NewsContent');
$query->AddSelectField($columns['category'], 'NewsCategory');
$query->AddSelectField($columns['date'], 'NewsDate');
$query->WhereValue($columns['type'], DB_EQ, $news_type);
$query->SelectOrder($columns['date'], 'DESC');
$query->SelectLimit(0, $this->settings[NEWS_DISPLAY_COUNT]);
return $application->db->getDB_Result($query);
}
