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()) {