function display($tpl = null)
{
JToolBarHelper::title(JText::_("FAQ_MANAGER"), 'fsf_faqs');
JToolBarHelper::custom('autosort', 'autosort', 'autosort', 'Auto Sort', false);
JToolBarHelper::divider();
JToolBarHelper::deleteList();
JToolBarHelper::editList();
JToolBarHelper::addNew();
JToolBarHelper::cancel('cancellist');
FSFAdminHelper::DoSubToolbar();
$lists = $this->get('Lists');
$this->assignRef('data', $this->get('Data'));
$this->assignRef('pagination', $this->get('Pagination'));
$query = 'SELECT id, title FROM #__fsf_faq_cat ORDER BY ordering';
$db =& JFactory::getDBO();
$categories[] = JHTML::_('select.option', '0', JText::_("SELECT_CATEGORY"), 'id', 'title');
$db->setQuery($query);
$categories = array_merge($categories, $db->loadObjectList());
$lists['cats'] = JHTML::_('select.genericlist', $categories, 'faq_cat_id', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'id', 'title', $lists['faq_cat_id']);
$categories = array();
$categories[] = JHTML::_('select.option', '-1', JText::_("IS_PUBLISHED"), 'id', 'title');
$categories[] = JHTML::_('select.option', '1', JText::_("PUBLISHED"), 'id', 'title');
$categories[] = JHTML::_('select.option', '0', JText::_("UNPUBLISHED"), 'id', 'title');
$lists['published'] = JHTML::_('select.genericlist', $categories, 'ispublished', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'id', 'title', $lists['ispublished']);
$this->assignRef('lists', $lists);
parent::display($tpl);
}
function display($tpl = null)
{
$faqcat =& $this->get('Data');
$isNew = $faqcat->id < 1;
$text = $isNew ? JText::_("NEW") : JText::_("EDIT");
JToolBarHelper::title(JText::_("FAQ_CATEGORY") . ': <small><small>[ ' . $text . ' ]</small></small>', 'fsf_categories');
JToolBarHelper::save();
if ($isNew) {
JToolBarHelper::cancel();
} else {
// for existing items the button is renamed `close`
JToolBarHelper::cancel('cancel', 'Close');
}
FSFAdminHelper::DoSubToolbar();
$path = JPATH_SITE . DS . 'images' . DS . 'fsf' . DS . 'faqcats';
if (!file_exists($path)) {
mkdir($path, 0777, true);
}
$files = JFolder::files($path, '(.png$|.jpg$|.jpeg$|.gif$)');
$sections[] = JHTML::_('select.option', '', JText::_("NO_IMAGE"), 'id', 'title');
foreach ($files as $file) {
$sections[] = JHTML::_('select.option', $file, $file, 'id', 'title');
}
$lists['images'] = JHTML::_('select.genericlist', $sections, 'image', 'class="inputbox" size="1" ', 'id', 'title', $faqcat->image);
$this->assignRef('lists', $lists);
$this->assignRef('faqcat', $faqcat);
parent::display($tpl);
}
function display($tpl = null)
{
$mainframe = JFactory::getApplication();
$glossary =& $this->get('Data');
$isNew = $glossary->id < 1;
$text = $isNew ? JText::_("NEW") : JText::_("EDIT");
JToolBarHelper::title(JText::_("GLOSSARY_ITEM") . ': <small><small>[ ' . $text . ' ]</small></small>', 'fsf_glossary');
JToolBarHelper::save();
if ($isNew) {
JToolBarHelper::cancel();
} else {
// for existing items the button is renamed `close`
JToolBarHelper::cancel('cancel', 'Close');
}
FSFAdminHelper::DoSubToolbar();
$this->assignRef('glossary', $glossary);
parent::display($tpl);
}
function display($tpl = null)
{
JToolBarHelper::title(JText::_("FAQ_CATEGORIES"), 'fsf_categories');
JToolBarHelper::deleteList();
JToolBarHelper::editList();
JToolBarHelper::addNew();
JToolBarHelper::cancel('cancellist');
FSFAdminHelper::DoSubToolbar();
$this->assignRef('lists', $this->get('Lists'));
$this->assignRef('data', $this->get('Data'));
$this->assignRef('pagination', $this->get('Pagination'));
$categories = array();
$categories[] = JHTML::_('select.option', '-1', JText::_("IS_PUBLISHED"), 'id', 'title');
$categories[] = JHTML::_('select.option', '1', JText::_("PUBLISHED"), 'id', 'title');
$categories[] = JHTML::_('select.option', '0', JText::_("UNPUBLISHED"), 'id', 'title');
$this->lists['published'] = JHTML::_('select.genericlist', $categories, 'ispublished', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'id', 'title', $this->lists['ispublished']);
parent::display($tpl);
}
function display($tpl = null)
{
JToolBarHelper::title(JText::_("ADMINISTRATION"), 'fsf_admin');
JToolBarHelper::cancel('cancellist');
FSFAdminHelper::DoSubToolbar();
$this->log = "";
$task = JRequest::getVar('task');
$updater = new FSFUpdater();
if ($task == "saveapi") {
return $this->SaveAPI();
}
if ($task == "cancellist") {
$mainframe = JFactory::getApplication();
$link = FSFRoute::x('index.php?option=com_fsf&view=fsfs', false);
$mainframe->redirect($link);
return;
}
if ($task == "update") {
$this->assignRef('log', $updater->Process());
parent::display();
return;
}
if ($task == "backup") {
$this->assignRef('log', $updater->BackupData('fsf'));
}
if ($task == "restore") {
// process any new file uploaded
$file = JRequest::getVar('filedata', '', 'FILES', 'array');
if (array_key_exists('error', $file) && $file['error'] == 0) {
$data = file_get_contents($file['tmp_name']);
$data = unserialize($data);
global $log;
$log = "";
$log = $updater->RestoreData($data);
$this->assignRef('log', $log);
parent::display();
return;
}
}
parent::display($tpl);
}
function display($tpl = null)
{
$mainframe = JFactory::getApplication();
$faq =& $this->get('Data');
$isNew = $faq->id < 1;
$text = $isNew ? JText::_("NEW") : JText::_("EDIT");
JToolBarHelper::title(JText::_("FAQ") . ': <small><small>[ ' . $text . ' ]</small></small>', 'fsf_faqs');
JToolBarHelper::save();
if ($isNew) {
JToolBarHelper::cancel();
} else {
// for existing items the button is renamed `close`
JToolBarHelper::cancel('cancel', 'Close');
}
FSFAdminHelper::DoSubToolbar();
$this->assignRef('faq', $faq);
$query = 'SELECT id, title' . ' FROM #__fsf_faq_cat' . ' ORDER BY ordering';
$db =& JFactory::getDBO();
$db->setQuery($query);
$sections = $db->loadObjectList();
if (count($sections) < 1) {
$link = FSFRoute::x('index.php?option=com_fsf&view=faqs', false);
$mainframe->redirect($link, "You must create a FAQ category first");
return;
}
if ($faq->id > 0) {
$qry = "SELECT * FROM #__fsf_faq_tags WHERE faq_id = " . FSFJ3Helper::getEscaped($db, $faq->id) . " ORDER BY tag";
$db->setQuery($qry);
$this->tags = $db->loadObjectList();
} else {
$this->tags = array();
}
$lists['catid'] = JHTML::_('select.genericlist', $sections, 'faq_cat_id', 'class="inputbox" size="1" ', 'id', 'title', intval($faq->faq_cat_id));
$this->assignRef('lists', $lists);
parent::display($tpl);
}
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');
$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);
}
}
function display($tpl = null)
{
JToolBarHelper::title(JText::_('FREESTYLE_FAQS'), 'fsf.png');
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);
}
}
}
}