/** * 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); }