function _buildQuery()
{
$db =& JFactory::getDBO();
$query = ' SELECT id, word, description, published, access, language FROM #__fsf_glossary ';
$where = array();
if ($this->lists['search']) {
$where[] = '(LOWER( word ) LIKE ' . $db->Quote('%' . FSFJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')';
}
if ($this->lists['order'] == 'word') {
$order = ' ORDER BY word ' . $this->lists['order_Dir'];
} else {
$order = ' ORDER BY ' . $this->lists['order'] . ' ' . $this->lists['order_Dir'] . ', word';
}
if ($this->lists['ispublished'] > -1) {
$where[] = 'published = ' . $this->lists['ispublished'];
}
if (FSFAdminHelper::Is16()) {
FSFAdminHelper::LA_GetFilterState();
if (FSFAdminHelper::$filter_lang) {
$where[] = "language = '" . FSFJ3Helper::getEscaped($db, FSFAdminHelper::$filter_lang) . "'";
}
if (FSFAdminHelper::$filter_access) {
$where[] = "access = '" . FSFJ3Helper::getEscaped($db, FSFAdminHelper::$filter_access) . "'";
}
}
$where = count($where) ? ' WHERE ' . implode(' AND ', $where) : '';
$query .= $where . $order;
return $query;
}
function SaveAPI()
{
$username = JRequest::getVar('username');
$apikey = JRequest::getVar('apikey');
$db =& JFactory::getDBO();
$qry = "REPLACE INTO #__fsf_settings (setting, value) VALUES ('fsj_username','" . FSFJ3Helper::getEscaped($db, $username) . "')";
$db->setQuery($qry);
$db->Query();
$qry = "REPLACE INTO #__fsf_settings (setting, value) VALUES ('fsj_apikey','" . FSFJ3Helper::getEscaped($db, $apikey) . "')";
$db->setQuery($qry);
$db->Query();
// update url links
if (FSFAdminHelper::Is16()) {
$updater = new FSFUpdater();
$updater->SortAPIKey($username, $apikey);
}
$mainframe = JFactory::getApplication();
$link = FSFRoute::x('index.php?option=com_fsf&view=backup', false);
$mainframe->redirect($link);
}
function _buildQuery()
{
$db =& JFactory::getDBO();
$query = ' SELECT f.id as id, question, answer, f.ordering as ordering, f.published as published, c.title as title, f.featured, f.access, f.language FROM #__fsf_faq_faq as f LEFT JOIN #__fsf_faq_cat as c ';
$query .= ' ON f.faq_cat_id = c.id ';
$where = array();
if ($this->lists['search']) {
$where[] = '(LOWER( question ) LIKE ' . $db->Quote('%' . FSFJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')';
}
if ($this->lists['order'] == "fsf_filter_access") {
$this->lists['order'] = "f.access";
}
if ($this->lists['order'] == "fsf_filter_language") {
$this->lists['order'] = "f.language";
}
if ($this->lists['order'] == 'f.ordering') {
$order = ' ORDER BY f.ordering ' . $this->lists['order_Dir'];
} else {
$order = ' ORDER BY ' . $this->lists['order'] . ' ' . $this->lists['order_Dir'] . ', f.ordering';
}
if ($this->lists['faq_cat_id'] > 0) {
$where[] = 'faq_cat_id = ' . $this->lists['faq_cat_id'];
}
if ($this->lists['ispublished'] > -1) {
$where[] = 'f.published = ' . $this->lists['ispublished'];
}
if (FSFAdminHelper::Is16()) {
FSFAdminHelper::LA_GetFilterState();
if (FSFAdminHelper::$filter_lang) {
$where[] = "f.language = '" . FSFJ3Helper::getEscaped($db, FSFAdminHelper::$filter_lang) . "'";
}
if (FSFAdminHelper::$filter_access) {
$where[] = "f.access = '" . FSFJ3Helper::getEscaped($db, FSFAdminHelper::$filter_access) . "'";
}
}
$where = count($where) ? ' WHERE ' . implode(' AND ', $where) : '';
$query .= $where . $order;
return $query;
}
function __construct()
{
$this->id = "faqs";
$this->descs = JText::_("FAQS");
$this->has_ordering = 1;
$this->table = "#__fsf_faq_faq";
$this->fields = array();
$field = new FSF_Content_Field("question", JText::_("QUESTION"), "long");
$field->link = 1;
$field->search = 1;
$this->AddField($field);
$field = new FSF_Content_Field("faq_cat_id", JText::_("CATEGORY"), "lookup");
$field->lookup_table = "#__fsf_faq_cat";
$field->lookup_required = 1;
$field->lookup_id = "id";
$field->lookup_order = "title";
$field->lookup_title = "title";
$field->lookup_select_msg = JText::_("PLEASE_SELECT_A_CATEGORY");
$this->AddField($field);
$field = new FSF_Content_Field("answer", JText::_("ANSWER"), "text");
$field->search = 1;
$field->more = "fullanswer";
$this->AddField($field);
$field = new FSF_Content_Field("featured", JText::_("Featured"), "checkbox");
$field->required = false;
$this->AddField($field);
$field = new FSF_Content_Field("tags", JText::_("Tags"), "tags");
$field->tags_table = "#__fsf_faq_tags";
$field->tags_key = "faq_id";
$field->required = 0;
$this->AddField($field);
if (FSFAdminHelper::Is16()) {
if (empty(FSFAdminHelper::$langs)) {
FSFAdminHelper::LoadLanguages();
FSFAdminHelper::LoadAccessLevels();
}
$filter_langs = array();
$filter_access = array();
$field = new FSF_Content_Field("language", JText::_("LANGUAGE"), "lookup", "lang_art");
$field->lookup_required = 1;
$field->lookup_id = "id";
$field->lookup_title = "title";
foreach (FSFAdminHelper::$langs as $lang) {
$filter_langs[$lang->value] = $lang->text;
$field->lookup_extra[$lang->value] = $lang->text;
}
$this->AddField($field);
$field = new FSF_Content_Field("access", JText::_("Access"), "lookup");
$field->lookup_required = 1;
$field->lookup_id = "id";
$field->lookup_title = "title";
foreach (FSFAdminHelper::$access_levels as $lang) {
$filter_access[$lang->value] = $lang->text;
$field->lookup_extra[$lang->value] = $lang->text;
}
$this->AddField($field);
}
$this->list = array();
$this->list[] = "question";
$this->list[] = "faq_cat_id";
$this->list[] = "featured";
if (FSFAdminHelper::Is16()) {
$this->list[] = "language";
$this->list[] = "access";
}
$this->edit = array();
$this->edit[] = "faq_cat_id";
$this->edit[] = "question";
$this->edit[] = "featured";
if (FSFAdminHelper::Is16()) {
$this->edit[] = "language";
$this->edit[] = "access";
}
$this->edit[] = "answer";
$this->edit[] = "tags";
$this->order = "ordering DESC";
$this->link = "index.php?option=com_fsf&view=faq&faqid=%ID%";
$filter = new FSF_Content_Filter("faq_cat_id", "id", "title", "#__fsf_faq_cat", "title", "CATEGORY");
$this->AddFilter($filter);
if (FSFAdminHelper::Is16()) {
$filter = new FSF_Content_Filter("language", "id", "title", "", "", "SELECT_LANGUAGE", "lang_filter", $filter_langs);
$this->AddFilter($filter);
$filter = new FSF_Content_Filter("access", "id", "title", "", "", "SELECT_ACCESS", "", $filter_access);
$this->AddFilter($filter);
}
}
static function LA_Form($item, $nolangs = false)
{
if (FSFAdminHelper::Is16()) {
?>
<tr>
<td width="135" align="right" class="key">
<label for="title">
<?php
echo JText::_("JFIELD_ACCESS_LABEL");
?>
:
</label>
</td>
<td>
<?php
echo FSFAdminHelper::GetAccessForm($item->access);
?>
</td>
</tr>
<?php
if (!$nolangs) {
?>
<tr>
<td width="135" align="right" class="key">
<label for="title">
<?php
echo JText::_("JFIELD_LANGUAGE_LABEL");
?>
:
</label>
</td>
<td>
<?php
echo FSFAdminHelper::GetLanguagesForm($item->language);
?>
</td>
</tr>
<?php
}
}
}
?>
</fieldset>
<!-- ##NOT_TEST_END## -->
<!-- -->
<!-- -->
</td>
<td width="45%" valign="top">
<?php
if (FSFAdminHelper::Is16()) {
JHTML::addIncludePath(array(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_fsf' . DS . 'html'));
?>
<?php
echo JHTML::_('fsjtabs.start');
$title = "Version";
echo JHTML::_('fsjtabs.panel', $title, 'cpanel-panel-' . $title, true);
$ver_inst = FSFAdminHelper::GetInstalledVersion();
$ver_files = FSFAdminHelper::GetVersion();
if (FSFAdminHelper::IsFAQs()) {
?>
<h3>If you like Freestyle FAQs please vote or review us at the <a href='http://extensions.joomla.org/extensions/directory-a-documentation/faq/11910' target="_blank">Joomla extensions directory</a></h3>
<?php
} elseif (FSFAdminHelper::IsTests()) {
