function __construct() { parent::__construct(); $mainframe = JFactory::getApplication(); global $option; // Get pagination request variables $aparams = FSF_Settings::GetViewSettingsObj('faqs'); $this->_enable_pages = $aparams->get('enable_pages', 1); $limit = $mainframe->getUserStateFromRequest('global.list.limit', 'limit', FSF_Settings::Get('faq_per_page'), 'int'); if ($this->_enable_pages == 0) { $limit = 999999; } $limitstart = JRequest::getVar('limitstart', 0, '', 'int'); // In case limit has been changed, adjust it $limitstart = $limit != 0 ? floor($limitstart / $limit) * $limit : 0; $this->setState('limit', $limit); $this->setState('limitstart', $limitstart); $this->_curcatid = JRequest::getInt('catid'); $this->_search = JRequest::getVar('search', '', '', 'string'); $this->_catlist = $this->_getCatList(); if ($this->_search != "") { $this->_curcattitle = JText::_("SEARCH_RESULTS"); $this->_curcatid = -1; $this->_curcatimage = "/components/com_fsf/assets/images/search.png"; } else { if ($this->_curcatid == "0") { $this->_curcattitle = JText::_("ALL_FAQS"); $this->_curcatimage = "/components/com_fsf/assets/images/allfaqs.png"; } else { foreach ($this->_catlist as $cat) { if ($cat['id'] == $this->_curcatid) { $this->_curcattitle = $cat['title']; $this->_curcatimage = $cat['image']; $this->_curcatdesc = $cat['description']; } } } } }
static function AddSCEditor() { if (!FSF_Helper::$sceditor) { if (FSF_Settings::Get('support_sceditor')) { $document = JFactory::getDocument(); $document->addScript(JURI::root() . 'components/com_fsf/assets/js/sceditor/jquery.sceditor.bbcode.js'); $document->addScript(JURI::root() . 'components/com_fsf/assets/js/sceditor/include.sceditor.js'); $document->addScriptDeclaration("var sceditor_emoticons_root = '" . JURI::root(true) . "/components/com_fsf/assets/';"); $document->addScriptDeclaration("var sceditor_style_root = '" . JURI::root(true) . "/components/com_fsf/assets/js/sceditor/';"); $document->addStyleSheet(JURI::root() . 'components/com_fsf/assets/js/sceditor/themes/default.css'); } FSF_Helper::$sceditor = true; } }
<div class="fsf_spacer"></div> <?php echo FSF_Helper::PageSubTitle("PLEASE_SELECT_A_TAG"); ?> <div class='faq_category'> <div class='faq_category_image'> <img src='<?php echo JURI::root(true); ?> /components/com_fsf/assets/images/tags-64x64.png' width='64' height='64'> </div> <div class='fsf_spacer contentheading' style="padding-top:6px;padding-bottom:6px;"> <?php if (FSF_Settings::Get('faq_cat_prefix')) { ?> <?php echo JText::_("FAQS"); ?> <?php } ?> <?php echo JText::_('TAGS'); ?> </div> </div> <div class='fsf_clear'></div>
function ParserPopulateTicket(&$parser, $row) { $parser->Clear(); if ($row) { $parser->SetVar('ref', $row['reference']); $parser->SetVar('subject', "<a href='" . FSFRoute::_('index.php?option=com_fsf&view=admin&layout=support&ticketid=' . $row['id']) . "'>" . $row['title'] . "</a>"); $parser->SetVar("status", "<span style='color:" . $row['color'] . ";'>" . $row['status'] . "</span>"); if ($row['user_id'] == 0) { $name = $row['unregname'] . " (" . JText::_("UNREG") . ")"; } else { $name = $row['name']; } $parser->SetVar("name", $name); $parser->SetVar("lastactivity", FSF_Helper::Date($row['lastupdate'], FSF_DATETIME_SHORT)); $parser->SetVar("opened", FSF_Helper::Date($row['opened'], FSF_DATETIME_SHORT)); $parser->SetVar("closed", FSF_Helper::Date($row['closed'], FSF_DATETIME_SHORT)); $parser->SetVar("department", $row['department']); $parser->SetVar("category", $row['category']); $parser->SetVar("product", $row['product']); $parser->SetVar("priority", "<span style='color:" . $row['pricolor'] . ";'>" . $row['priority'] . "</span>"); $groups = implode(", ", $row['groups']); $parser->SetVar('groups', $groups); $parser->SetVar('deletebutton', 'deletebutton'); $parser->SetVar('archivebutton', 'archivebutton'); if (array_key_exists("custom", $row)) { $allcustom = array(); if (count($row['custom']) > 0) { foreach ($row['custom'] as $id => $value) { if (array_key_exists($id, $this->customfields)) { $field = $this->customfields[$id]; if ($field['type'] == "plugin") { $aparams = FSFCF::GetValues($field); if (array_key_exists("plugin", $aparams) && array_key_exists("plugindata", $aparams)) { $plugin = FSFCF::get_plugin($aparams['plugin']); $value = $plugin->Display($value, $aparams['plugindata'], array('ticketid' => $row['id'], 'userid' => $row['user_id'], 'ticket' => $row), $field['id']); } } $text = "<span class='fsf_support_fieldname'>" . $this->customfields[$id]['description'] . "</span>"; if ($this->customfields[$id]['type'] == "checkbox") { if ($value == "on") { $value = JText::_("Yes"); } else { $value = JText::_("No"); } } $parser->SetVar("custom" . $id, $value); $parser->SetVar("custom_" . $id, $value); $allcustom[] = $text . ": " . $value; } } } //echo "All custom : " . implode(", ",$allcustom) . "<br>"; $parser->SetVar("custom", implode(", ", $allcustom)); } if ($row['assigned'] == '') { $parser->SetVar('handlername', JText::_("UNASSIGNED")); } else { $parser->SetVar('handlername', $row['assigned']); } $parser->SetVar('username', $row['username']); $parser->SetVar('email', $row['useremail']); $parser->SetVar('handlerusername', $row['handlerusername']); $parser->SetVar('handleremail', $row['handleremail']); $icons = ""; if (FSF_Settings::get('support_show_msg_counts')) { $icons .= "<span>"; $icons .= "<span style='font-weight:normal;top:-2px;position:relative;padding-right:2px;'>" . $row['msgcount']['total'] . "</span><span style='font-weight:normal;top:-2px;position:relative;padding-right:2px;'>x</span><img src='" . JURI::root(true) . "/components/com_fsf/assets/images/messages.png'>"; $icons .= "</span>"; } $cotime = $this->db_time - strtotime($row['checked_out_time']); if ($cotime < FSF_Settings::get('support_lock_time') && $row['checked_out'] != $this->userid && $row['checked_out'] > 0) { $html = "<div class='fsf_user_tt'>" . $row['co_user']->name . " (" . $row['co_user']->email . ")</div>"; $icons .= "<img class='fsj_tip' src='" . JURI::root(true) . "/components/com_fsf/assets/images/lock.png' title=\"" . JText::_('TICKET_LOCKED') . "::" . $html . "\">"; } else { $icons .= "<img src='" . JURI::root(true) . "/components/com_fsf/assets/images/blank_16.png'>"; } if (!FSF_Settings::get('support_hide_tags')) { if (isset($row['tags'])) { $html = ""; foreach ($row['tags'] as $tag) { $html .= "<div class='fsf_tag_tt'>" . $tag['tag'] . "</div>"; } $icons .= "<img class='fsj_tip' src='" . JURI::root(true) . "/components/com_fsf/assets/images/tag.png' title=\"" . JText::_('TICKET_TAGS') . "::" . $html . "\">"; } else { $icons .= "<img src='" . JURI::root(true) . "/components/com_fsf/assets/images/blank_16.png'>"; } } if (isset($row['attach'])) { $html = "<table class='fsf_attach_tt'>"; foreach ($row['attach'] as $attach) { $html .= "<tr style='border:0px;'><td nowrap style='border:0px;'>" . $attach['filename'] . " </td><td nowrap style='border:0px;'> " . FSF_Helper::display_filesize($attach['size']) . "</td></tr>"; } $html .= "<table>"; $icons .= "<img class='fsj_tip' src='" . JURI::root(true) . "/components/com_fsf/assets/images/attach.png' title=\"" . JText::_('TICKET_ATTACHMENTS') . "::" . $html . "\">"; } else { $icons .= "<img src='" . JURI::root(true) . "/components/com_fsf/assets/images/blank_16.png'>"; } $parser->SetVar('icons', $icons); $delete = "<a href='" . FSFRoute::x('index.php?option=com_fsf&view=admin&layout=support&tickets=' . JRequest::getVar('tickets') . '&delete=' . $row['id']) . "'>"; $delete .= "<img src='" . JURI::root(true) . "/components/com_fsf/assets/images/delete_ticket.png'>"; $delete .= JText::_("DELETE") . "</a>"; $archive = "<a href='" . FSFRoute::x('index.php?option=com_fsf&view=admin&layout=support&tickets=' . JRequest::getVar('tickets') . '&archive=' . $row['id']) . "'>"; $archive .= "<img src='" . JURI::root(true) . "/components/com_fsf/assets/images/archive_ticket.png'>"; $archive .= JText::_("ARCHIVE") . "</a>"; $parser->SetVar('archivebutton', $archive); $parser->SetVar('deletebutton', $delete); // TODO: trhl /*id='ticket_<?php echo $ticket['id'];?>' onmouseover="$('ticket_<?php echo $ticket['id'];?>').style.background = '<?php echo FSF_Settings::get('css_hl'); ?>';$('ticket_<?php echo $ticket['id'];?>_2').style.background = '<?php echo FSF_Settings::get('css_hl'); ?>';" onmouseout="$('ticket_<?php echo $ticket['id'];?>').style.background = '';$('ticket_<?php echo $ticket['id'];?>_2').style.background = '';"*/ $this->_permissions = FSF_Ticket_Helper::getAdminPermissions(); $type = "unassigned"; if ($row['admin_id'] == $this->_permissions['id']) { $type = "mine"; } else { if ($row['admin_id'] > 0) { $type = "other"; } } $style = ""; if (array_key_exists($row['ticket_pri_id'], $this->priorities)) { $pri = $this->priorities[$row['ticket_pri_id']]; if ($pri['backcolor']) { $style .= "background-color: {$pri['backcolor']};"; } } $handler_highlight = "ticket_type_{$type}"; $parser->SetVar('handler_highlight', $handler_highlight); $trhl = " class='ticket_{$row['id']} ' onmouseover='highlightticket({$row['id']})' onmouseout='unhighlightticket({$row['id']})' "; if (FSF_Settings::get('support_entire_row')) { $style .= "cursor: pointer;"; $trhl .= " onclick='window.location=\"" . FSFRoute::x('&limitstart=&ticketid=' . $row['id']) . "\"' "; } $trhl .= " style='{$style}' "; $parser->SetVar('trhl', $trhl); } $parser->SetVar("showassigned", $this->showassigned); $parser->SetVar("hidehandler", FSF_Settings::get('support_hide_handler')); $parser->SetVar("candelete", FSF_Settings::get('support_delete')); $parser->SetVar("view", $this->ticket_view); }
function display($tpl = null) { $mainframe = JFactory::getApplication(); JHTML::_('behavior.modal', 'a.fsf_modal'); //JHTML::_('behavior.mootools'); $db = JFactory::getDBO(); $aparams = FSF_Settings::GetViewSettingsObj('glossary'); $this->use_letter_bar = $aparams->get('use_letter_bar', 0); if ($this->use_letter_bar) { $this->letters = array(); if (FSF_Settings::get('glossary_all_letters')) { $letters = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); foreach ($letters as $letter) { $this->letters[$letter] = 0; } } $qry = "SELECT UPPER(SUBSTR(word,1,1)) as letter FROM #__fsf_glossary"; $where = array(); $where[] = "published = 1"; if (FSF_Helper::Is16()) { $where[] = 'language in (' . $db->Quote(JFactory::getLanguage()->getTag()) . ',' . $db->Quote('*') . ')'; $user = JFactory::getUser(); $where[] = 'access IN (' . implode(',', $user->getAuthorisedViewLevels()) . ')'; } if (count($where) > 0) { $qry .= " WHERE " . implode(" AND ", $where); } $qry .= " GROUP BY letter ORDER BY letter"; $db->setQuery($qry); $letters = $db->loadObjectList(); foreach ($letters as $letter) { $this->letters[$letter->letter] = 1; } if (count($this->letters) == 0) { return parent::display("empty"); } } $this->curletter = ""; // if we are showing on a per letter basis only if ($this->use_letter_bar == 2) { $this->curletter = JRequest::getVar('letter', $this->letters[0]->letter); } $where = array(); $where[] = "published = 1"; $query = "SELECT * FROM #__fsf_glossary"; if ($this->curletter) { $where[] = "SUBSTR(word,1,1) = '" . FSFJ3Helper::getEscaped($db, $this->curletter) . "'"; } if (FSF_Helper::Is16()) { $where[] = 'language in (' . $db->Quote(JFactory::getLanguage()->getTag()) . ',' . $db->Quote('*') . ')'; $user = JFactory::getUser(); $where[] = 'access IN (' . implode(',', $user->getAuthorisedViewLevels()) . ')'; } if (count($where) > 0) { $query .= " WHERE " . implode(" AND ", $where); } $query .= " ORDER BY word"; $db->setQuery($query); $this->rows = $db->loadObjectList(); $pathway =& $mainframe->getPathway(); if (FSF_Helper::NeedBaseBreadcrumb($pathway, array('view' => 'glossary'))) { $pathway->addItem("Glossary"); } if (FSF_Settings::get('glossary_use_content_plugins')) { // apply plugins to article body $dispatcher =& JDispatcher::getInstance(); JPluginHelper::importPlugin('content'); $art = new stdClass(); if (FSF_Helper::Is16()) { //$aparams = new JParameter(null); } else { $aparams = new stdClass(); } $this->params =& $mainframe->getParams('com_fsf'); foreach ($this->rows as &$row) { if ($row->description) { $art->text = $row->description; $art->noglossary = 1; if (FSF_Helper::Is16()) { $results = $dispatcher->trigger('onContentPrepare', array('com_fsf.glossary', &$art, &$this->params, 0)); } else { $results = $dispatcher->trigger('onPrepareContent', array(&$art, &$this->params, 0)); } $row->description = $art->text; } if ($row->longdesc) { $art->text = $row->longdesc; $art->noglossary = 1; if (FSF_Helper::Is16()) { $results = $dispatcher->trigger('onContentPrepare', array('com_fsf.glossary.long', &$art, &$this->params, 0)); } else { $results = $dispatcher->trigger('onPrepareContent', array(&$art, &$this->params, 0)); } $row->longdesc = $art->text; } } } parent::display($tpl); }
static function getAdminPermissions() { if (empty(FSF_Ticket_Helper::$_permissions)) { $mainframe = JFactory::getApplication(); global $option; $user = JFactory::getUser(); $userid = $user->id; $db = JFactory::getDBO(); $query = "SELECT * FROM #__fsf_user WHERE user_id = '" . FSFJ3Helper::getEscaped($db, $userid) . "'"; $db->setQuery($query); FSF_Ticket_Helper::$_permissions = $db->loadAssoc(); if (!FSF_Ticket_Helper::$_permissions) { FSF_Ticket_Helper::$_permissions['mod_kb'] = 0; FSF_Ticket_Helper::$_permissions['mod_test'] = 0; FSF_Ticket_Helper::$_permissions['support'] = 0; FSF_Ticket_Helper::$_permissions['seeownonly'] = 1; FSF_Ticket_Helper::$_permissions['autoassignexc'] = 1; FSF_Ticket_Helper::$_permissions['allprods'] = 1; FSF_Ticket_Helper::$_permissions['allcats'] = 1; FSF_Ticket_Helper::$_permissions['alldepts'] = 1; FSF_Ticket_Helper::$_permissions['artperm'] = 0; FSF_Ticket_Helper::$_permissions['id'] = 0; FSF_Ticket_Helper::$_permissions['groups'] = 0; FSF_Ticket_Helper::$_permissions['reports'] = 0; FSF_Ticket_Helper::$_permissions['settings'] = ''; } FSF_Ticket_Helper::$_permissions['userid'] = $userid; FSF_Ticket_Helper::$_perm_only = ''; FSF_Ticket_Helper::$_perm_prods = ''; FSF_Ticket_Helper::$_perm_depts = ''; FSF_Ticket_Helper::$_perm_cats = ''; FSF_Ticket_Helper::$_permissions['perm_where'] = ''; // // check for permission overrides for Joomla 1.6 if (FSF_Settings::get('perm_article_joomla') || FSF_Settings::get('perm_mod_joomla')) { if (FSF_Helper::Is16()) { $newart = 0; $newmod = 0; $user = JFactory::getUser(); if ($user->authorise('core.edit.own', 'com_fsf')) { $newart = 1; } if ($user->authorise('core.edit', 'com_fsf')) { $newart = 2; $newmod = 1; } if ($user->authorise('core.edit.state', 'com_fsf')) { $newart = 3; $newmod = 1; } if (FSF_Settings::get('perm_article_joomla') && $newart > FSF_Ticket_Helper::$_permissions['artperm']) { FSF_Ticket_Helper::$_permissions['artperm'] = $newart; } if (FSF_Settings::get('perm_mod_joomla') && $newmod > FSF_Ticket_Helper::$_permissions['mod_kb']) { FSF_Ticket_Helper::$_permissions['mod_kb'] = $newmod; } // } else { $newart = 0; $newmod = 0; $user = JFactory::getUser(); if ($user->authorize('com_fsf', 'create', 'content', 'own')) { $newart = 1; } if ($user->authorize('com_fsf', 'edit', 'content', 'own')) { $newart = 2; $newmod = 1; } if ($user->authorize('com_fsf', 'publish', 'content', 'all')) { $newart = 3; $newmod = 1; } if (FSF_Settings::get('perm_article_joomla') && $newart > FSF_Ticket_Helper::$_permissions['artperm']) { FSF_Ticket_Helper::$_permissions['artperm'] = $newart; } if (FSF_Settings::get('perm_mod_joomla') && $newmod > FSF_Ticket_Helper::$_permissions['mod_kb']) { FSF_Ticket_Helper::$_permissions['mod_kb'] = $newmod; } } } } return FSF_Ticket_Helper::$_permissions; }
function display($tpl = null) { JHTML::_('behavior.modal'); $what = JRequest::getString('what', ''); $this->tab = JRequest::getVar('tab'); if (JRequest::getVar('task') == "cancellist") { $mainframe = JFactory::getApplication(); $link = FSFRoute::x('index.php?option=com_fsf&view=fsfs', false); $mainframe->redirect($link); return; } $settings = FSF_Settings::GetAllViewSettings(); // CHANGE $db =& JFactory::getDBO(); if ($what == "save") { $data = JRequest::get('POST', JREQUEST_ALLOWRAW); foreach ($data as $setting => $value) { if (array_key_exists($setting, $settings)) { $settings[$setting] = $value; } } foreach ($settings as $setting => $value) { if (!array_key_exists($setting, $data)) { $settings[$setting] = 0; $value = 0; } // skip any setting that is in the templates list if (array_key_exists($setting, $templates)) { continue; } if (array_key_exists($setting, $large)) { continue; } $qry = "REPLACE INTO #__fsf_settings_view (setting, value) VALUES ('"; $qry .= FSFJ3Helper::getEscaped($db, $setting) . "','"; $qry .= FSFJ3Helper::getEscaped($db, $value) . "')"; $db->setQuery($qry); $db->Query(); //echo $qry."<br>"; } $link = 'index.php?option=com_fsf&view=settingsview#' . $this->tab; if (JRequest::getVar('task') == "save") { $link = 'index.php?option=com_fsf'; } //exit; $mainframe = JFactory::getApplication(); $mainframe->redirect($link, JText::_("View_Settings_Saved")); exit; } else { $document = JFactory::getDocument(); $document->addStyleSheet(JURI::root() . 'administrator/components/com_fsf/assets/css/js_color_picker_v2.css'); $document->addScript(JURI::root() . 'administrator/components/com_fsf/assets/js/color_functions.js'); $document->addScript(JURI::root() . 'administrator/components/com_fsf/assets/js/js_color_picker_v2.js'); $this->assignRef('settings', $settings); JToolBarHelper::title(JText::_("FREESTYLE_FAQS") . ' - ' . JText::_("VIEW_SETTINGS"), 'fsf_viewsettings'); JToolBarHelper::apply(); JToolBarHelper::save(); JToolBarHelper::cancel('cancellist'); FSFAdminHelper::DoSubToolbar(); parent::display($tpl); } }
static function GetViewSettingsObj($view) { // return a view setting object that can be used in place of the getPageParameters object // needs info about what view we are in, and access to the view settings FSF_Settings::_Get_View_Settings(); return new FSF_View_Settings($view, FSF_Settings::$fsf_view_settings); }
static function GetInstalledVersion() { return FSF_Settings::get('version'); }
<?php /** * @package Freestyle Joomla * @author Freestyle Joomla * @copyright (C) 2013 Freestyle Joomla * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html **/ defined('_JEXEC') or die; ?> <div style="clear:both;"></div> <?php if (!FSF_Settings::get('hide_powered')) { ?> <div align="center" style="text-align:center;padding-top:20px;"> <a href="http://www.freestyle-joomla.com/"> Powered by Freestyle FAQs <br> <img style="padding-top:2px;" border="0" src="<?php echo JURI::root(true); ?> /components/com_fsf/assets/images/logo_small.png"><br> </a> </div> <?php }
function display($tpl = null) { JHTML::_('behavior.modal'); if (JRequest::getVar('task') == "cancellist") { $mainframe = JFactory::getApplication(); $link = FSFRoute::x('index.php?option=com_fsf&view=fsfs', false); $mainframe->redirect($link); return; } $what = JRequest::getString('what', ''); $this->tab = JRequest::getVar('tab'); $settings = FSF_Settings::GetAllSettings(); $db =& JFactory::getDBO(); if ($what == "testref") { return $this->TestRef(); } else { if ($what == "save") { $large = FSF_Settings::GetLargeList(); $templates = FSF_Settings::GetTemplateList(); $intpltable = FSF_Settings::StoreInTemplateTable(); // save support custom setting $head = JRequest::getVar('support_list_head', '', 'post', 'string', JREQUEST_ALLOWRAW); $row = JRequest::getVar('support_list_row', '', 'post', 'string', JREQUEST_ALLOWRAW); $qry = "REPLACE INTO #__fsf_templates (template, tpltype, value) VALUES ('custom', 1, '" . FSFJ3Helper::getEscaped($db, $head) . "')"; $db->setQuery($qry); $db->Query(); $qry = "REPLACE INTO #__fsf_templates (template, tpltype, value) VALUES ('custom', 0, '" . FSFJ3Helper::getEscaped($db, $row) . "')"; $db->setQuery($qry); $db->Query(); unset($_POST['support_list_head']); unset($_POST['support_list_row']); // save templates $intpltable = FSF_Settings::StoreInTemplateTable(); foreach ($intpltable as $template) { $value = JRequest::getVar($template, '', 'post', 'string', JREQUEST_ALLOWRAW); $qry = "REPLACE INTO #__fsf_templates (template, tpltype, value) VALUES ('" . FSFJ3Helper::getEscaped($db, $template) . "', 2, '" . FSFJ3Helper::getEscaped($db, $value) . "')"; $db->setQuery($qry); $db->Query(); } // large settings foreach ($large as $setting) { if (!array_key_exists($setting, $templates)) { continue; } $value = JRequest::getVar($setting, '', 'post', 'string', JREQUEST_ALLOWRAW); $qry = "REPLACE INTO #__fsf_settings_big (setting, value) VALUES ('"; $qry .= FSFJ3Helper::getEscaped($db, $setting) . "','"; $qry .= FSFJ3Helper::getEscaped($db, $value) . "')"; //echo $qry."<br>"; $db->setQuery($qry); $db->Query(); $qry = "DELETE FROM #__fsf_settings WHERE setting = '" . FSFJ3Helper::getEscaped($db, $setting) . "'"; //echo $qry."<br>"; $db->setQuery($qry); $db->Query(); unset($_POST[$setting]); } $data = JRequest::get('POST', JREQUEST_ALLOWRAW); foreach ($data as $setting => $value) { if (array_key_exists($setting, $settings)) { $settings[$setting] = $value; } } foreach ($settings as $setting => $value) { if (!array_key_exists($setting, $data)) { $settings[$setting] = 0; $value = 0; } if (!array_key_exists($setting, $templates)) { continue; } if (array_key_exists($setting, $large)) { continue; } $qry = "REPLACE INTO #__fsf_settings (setting, value) VALUES ('"; $qry .= FSFJ3Helper::getEscaped($db, $setting) . "','"; $qry .= FSFJ3Helper::getEscaped($db, $value) . "')"; $db->setQuery($qry); $db->Query(); //echo $qry."<br>"; } //exit; $link = 'index.php?option=com_fsf&view=templates#' . $this->tab; if (JRequest::getVar('task') == "save") { $link = 'index.php?option=com_fsf'; } $mainframe = JFactory::getApplication(); $mainframe->redirect($link, JText::_("Settings_Saved")); exit; } else { if ($what == "customtemplate") { $this->CustomTemplate(); exit; } else { // load other templates $intpltable = FSF_Settings::StoreInTemplateTable(); $tpls = array(); foreach ($intpltable as $template) { $settings[$template] = ''; $settings[$template . '_default'] = ''; $tpls[] = FSFJ3Helper::getEscaped($db, $template); } $tpllist = "'" . implode("', '", $tpls) . "'"; $qry = "SELECT * FROM #__fsf_templates WHERE template IN ({$tpllist})"; $db->setQuery($qry); $rows = $db->loadAssocList(); if (count($rows) > 0) { foreach ($rows as $row) { if ($row['tpltype'] == 2) { $settings[$row['template']] = $row['value']; } else { if ($row['tpltype'] == 3) { $settings[$row['template'] . '_default'] = $row['value']; } } } } // load ticket template stuff $qry = "SELECT * FROM #__fsf_templates WHERE template = 'custom'"; $db->setQuery($qry); $rows = $db->loadAssocList(); if (count($rows) > 0) { foreach ($rows as $row) { if ($row['tpltype'] == 1) { $settings['support_list_head'] = $row['value']; } else { if ($row['tpltype'] == 0) { $settings['support_list_row'] = $row['value']; } } } } else { $settings['support_list_head'] = ''; $settings['support_list_row'] = ''; } $qry = "SELECT * FROM #__fsf_templates WHERE tpltype = 2"; $db->setQuery($qry); $rows = $db->loadAssocList(); if (count($rows) > 0) { foreach ($rows as $row) { $settings[$row['template']] = $row['value']; } } $document = JFactory::getDocument(); $document->addStyleSheet(JURI::root() . 'administrator/components/com_fsf/assets/css/js_color_picker_v2.css'); $document->addScript(JURI::root() . 'administrator/components/com_fsf/assets/js/color_functions.js'); $document->addScript(JURI::root() . 'administrator/components/com_fsf/assets/js/js_color_picker_v2.js'); $document->addScript(JURI::root() . 'administrator/components/com_fsf/assets/js/codemirror/codemirror.js'); $document->addScript(JURI::root() . 'administrator/components/com_fsf/assets/js/codemirror/modes/css/css.js'); $document->addScript(JURI::root() . 'administrator/components/com_fsf/assets/js/codemirror/modes/javascript/javascript.js'); $document->addScript(JURI::root() . 'administrator/components/com_fsf/assets/js/codemirror/modes/xml/xml.js'); $document->addScript(JURI::root() . 'administrator/components/com_fsf/assets/js/codemirror/modes/htmlmixed/htmlmixed.js'); $document->addStyleSheet(JURI::root() . 'administrator/components/com_fsf/assets/css/codemirror/codemirror.css'); $this->assignRef('settings', $settings); JToolBarHelper::title(JText::_("FREESTYLE_FAQS") . ' - ' . JText::_("TEMPLATES"), 'fsf_templates'); JToolBarHelper::apply(); JToolBarHelper::save(); JToolBarHelper::cancel('cancellist'); FSFAdminHelper::DoSubToolbar(); parent::display($tpl); } } } }
function listTags() { $mainframe = JFactory::getApplication(); $aparams = FSF_Settings::GetViewSettingsObj('faqs'); $pathway = $mainframe->getPathway(); $pathway->addItem(JText::_("TAGS")); $db =& JFactory::getDBO(); $qry = "SELECT tag FROM #__fsf_faq_tags "; $qry .= ' WHERE language in (' . $db->Quote(JFactory::getLanguage()->getTag()) . ',' . $db->Quote('*') . ')'; $qry .= "GROUP BY tag ORDER BY tag"; $db->setQuery($qry); $this->tags = $db->loadObjectList(); parent::display("tags"); }
* @package Freestyle Joomla * @author Freestyle Joomla * @copyright (C) 2013 Freestyle Joomla * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html **/ defined('_JEXEC') or die; ?> <script> function ResetElement(tabid) { document.getElementById('tab_' + tabid).style.display = 'none'; document.getElementById('link_' + tabid).style.backgroundColor = ''; document.getElementById('link_' + tabid).onmouseover = function() { this.style.backgroundColor='<?php echo FSF_Settings::get('css_hl'); ?> '; } document.getElementById('link_' + tabid).onmouseout = function() { this.style.backgroundColor=''; } } function ShowTab(tabid) { ResetElement('general'); // // ##NOT_TEST_END## ResetElement('visual'); // ##NOT_TEST_START##
function display($tpl = null) { JHTML::_('behavior.modal'); $what = JRequest::getString('what', ''); $this->tab = JRequest::getVar('tab'); if (JRequest::getVar('task') == "cancellist") { $mainframe = JFactory::getApplication(); $link = FSFRoute::x('index.php?option=com_fsf&view=fsfs', false); $mainframe->redirect($link); return; } $settings = FSF_Settings::GetAllSettings(); $db =& JFactory::getDBO(); if ($what == "testref") { return $this->TestRef(); } else { if ($what == "testdates") { return $this->testdates(); } else { if ($what == "save") { // $large = FSF_Settings::GetLargeList(); $templates = FSF_Settings::GetTemplateList(); // save any large settings that arent in the templates list foreach ($large as $setting) { // skip any setting that is in the templates list if (array_key_exists($setting, $templates)) { continue; } // $value = JRequest::getVar($setting, '', 'post', 'string', JREQUEST_ALLOWRAW); $qry = "REPLACE INTO #__fsf_settings_big (setting, value) VALUES ('"; $qry .= FSFJ3Helper::getEscaped($db, $setting) . "','"; $qry .= FSFJ3Helper::getEscaped($db, $value) . "')"; $db->setQuery($qry); $db->Query(); $qry = "DELETE FROM #__fsf_settings WHERE setting = '" . FSFJ3Helper::getEscaped($db, $setting) . "'"; $db->setQuery($qry); $db->Query(); unset($_POST[$setting]); } $data = JRequest::get('POST', JREQUEST_ALLOWRAW); foreach ($data as $setting => $value) { if (array_key_exists($setting, $settings)) { $settings[$setting] = $value; } } foreach ($settings as $setting => $value) { if (!array_key_exists($setting, $data)) { $settings[$setting] = 0; $value = 0; } // skip any setting that is in the templates list if (array_key_exists($setting, $templates)) { continue; } if (array_key_exists($setting, $large)) { continue; } $qry = "REPLACE INTO #__fsf_settings (setting, value) VALUES ('"; $qry .= FSFJ3Helper::getEscaped($db, $setting) . "','"; $qry .= FSFJ3Helper::getEscaped($db, $value) . "')"; $db->setQuery($qry); $db->Query(); //echo $qry."<br>"; } $link = 'index.php?option=com_fsf&view=settings#' . $this->tab; if (JRequest::getVar('task') == "save") { $link = 'index.php?option=com_fsf'; } //exit; $mainframe = JFactory::getApplication(); $mainframe->redirect($link, JText::_("Settings_Saved")); exit; } else { if ($what == "customtemplate") { $this->CustomTemplate(); exit; } else { $qry = "SELECT * FROM #__fsf_templates WHERE template = 'custom'"; $db->setQuery($qry); $rows = $db->loadAssocList(); if (count($rows) > 0) { foreach ($rows as $row) { if ($row['tpltype']) { $settings['support_list_head'] = $row['value']; } else { $settings['support_list_row'] = $row['value']; } } } else { $settings['support_list_head'] = ''; $settings['support_list_row'] = ''; } // $document = JFactory::getDocument(); $document->addStyleSheet(JURI::root() . 'administrator/components/com_fsf/assets/css/js_color_picker_v2.css'); $document->addScript(JURI::root() . 'administrator/components/com_fsf/assets/js/color_functions.js'); $document->addScript(JURI::root() . 'administrator/components/com_fsf/assets/js/js_color_picker_v2.js'); $this->assignRef('settings', $settings); JToolBarHelper::title(JText::_("FREESTYLE_FAQS") . ' - ' . JText::_("SETTINGS"), 'fsf_settings'); JToolBarHelper::apply(); JToolBarHelper::save(); JToolBarHelper::cancel('cancellist'); FSFAdminHelper::DoSubToolbar(); parent::display($tpl); } } } } }
static function Footer() { FSF_Glossary::GetGlossary(); if (count(FSF_Glossary::$fsf_glossary) == 0) { return ""; } $tail = "<div id='glossary_words' style='display:none;'>"; foreach (FSF_Glossary::$fsf_glossary as $word => $tip) { $wordl = strtolower($word); // skip any entries that we havent found a match for if (!array_key_exists($wordl, FSF_Glossary::$all_replaced)) { continue; } $wordl = preg_replace("/[^a-z0-9]/", "", $wordl); if (FSF_Settings::get('glossary_title')) { $tail .= "<div id='glossary_{$wordl}'><h4>{$word}</h4><div class='fsj_gt_inner'>{$tip}</div></div>"; } else { $tail .= "<div id='glossary_{$wordl}'><div class='fsj_gt_inner'>{$tip}</div></div>"; } } $tail .= "</div>"; return $tail; }
</div> <?php } ?> </div> </div> <?php if ($this->tmpl) { echo "</div>"; } ?> <?php include JPATH_SITE . DS . 'components' . DS . 'com_fsf' . DS . '_powered.php'; if (FSF_Settings::get('glossary_faqs')) { echo FSF_Glossary::Footer(); } ?> <?php if ($this->tmpl) { echo "</div>"; } ?> <?php echo $this->tmpl ? FSF_Helper::PageStylePopupEnd() : FSF_Helper::PageStyleEnd(); ?> <script>
function __construct($total, $limitstart, $limit) { $this->skinstyle = FSF_Settings::get('skin_style'); parent::__construct($total, $limitstart, $limit); }