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