addLocale("housekeeping.faq"); $page['name'] = $lang->loc['pagename.faq']; $page['category'] = "tools"; require_once('./templates/housekeeping_header.php'); if(isset($_GET['do']) && $_GET['do'] == "save"){ $row = $_POST; if(empty($row['title'])){ $error = $lang->loc['error.no.title']; } if(empty($error)){ if(!empty($row['id'])){ if($_GET['type'] == "cat"){ $db->query("UPDATE ".PREFIX."faq SET title = '".$input->FilterText($row['title'])."', show_in_footer = '".$input->FilterText($row['show_in_footer'])."' WHERE id = '".$input->FilterText($row['id'])."' LIMIT 1"); $message = $lang->loc['message.cat.modified']; }else{ $db->query("UPDATE ".PREFIX."faq SET title = '".$input->FilterText($row['title'])."', show_in_footer = '".$input->FilterText($row['show_in_footer'])."', catid = '".$input->FilterText($row['catid'])."', content = '".nl2br($input->FilterText($row['content'],true))."' WHERE id = '".$input->FilterText($row['id'])."' LIMIT 1"); $message = $lang->loc['message.item.modified']; } }else{ if($_GET['type'] == "cat"){ $db->query("INSERT INTO ".PREFIX."faq (type,catid,title,content,show_in_footer) VALUES ('cat','0','".$input->FilterText($row['title'])."','','".$input->FilterText($row['show_in_footer'])."')"); $message = $lang->loc['message.cat.created']; }else{ $db->query("INSERT INTO ".PREFIX."faq (type,catid,title,content,show_in_footer) VALUES ('item','".$input->FilterText($row['catid'])."','".$input->FilterText($row['title'])."','".nl2br($input->FilterText($row['content'],true))."','".$input->FilterText($row['show_in_footer'])."')"); $message = $lang->loc['message.item.created']; } } unset($_POST); unset($_GET); }else{ $_GET['do'] = "create"; } }elseif($_GET['do'] == "remove"){ if(isset($_POST['id']) && isset($_POST['remove'])){ $db->query("DELETE FROM ".PREFIX."faq WHERE id = '".$input->FilterText($_POST['id'])."' LIMIT 1"); $message = $lang->loc['message.removed']; unset($_POST); unset($_GET); } } if((isset($_GET['id']) || isset($_POST['id'])) && empty($row)){ $sql = $db->query("SELECT * FROM ".PREFIX."faq WHERE id = '".$input->FilterText($_GET['id'])."' LIMIT 1"); $row = $db->fetch_assoc($sql); $selected[(int) $row['show_in_footer']] = ' checked="true"'; }elseif(empty($row)){ $row['show_in_footer'] = "0"; $selected[0] = ' checked="true"'; } switch($_GET['do']){ case "create": $lang->addLocale("housekeeping.faq.create"); $icon = "faq.png"; $description = $lang->loc['faq.create.desc']; $content = ""; if(!empty($error)){ $content .= '

'.$error.'

'; } if($_GET['type'] == "cat"){ $content .= '

'; }else{ $content .= '

'; } break; case "remove": $lang->addLocale("housekeeping.faq.remove"); $icon = "faq.png"; $description = $lang->loc['faq.remove.desc']; $content = '

'.$lang->loc['confirm.remove'].' "'.$input->HoloText($row['title']).'"?

'; break; default: $lang->addLocale("housekeeping.faq.display"); $icon = "faq.png"; $description = $lang->loc['faq.display.desc']; $content = ""; if(isset($message) && !empty($message)){ $content .= '

'.$message.'

'; } $content .= '

'.$lang->loc['categories'].'

'; $sql = $db->query("SELECT * FROM ".PREFIX."faq WHERE type = 'cat' ORDER BY id ASC"); $i = 0; while($row = $db->fetch_assoc($sql)){ $i++; if($input->IsEven($i)){ $even = ' class="even"'; }else{ $even = ''; } $content .= ' '; } $content .= '

'.$lang->loc['id'].'	'.$lang->loc['name'].'	'.$lang->loc['actions'].'
'.$row['id'].'	'.$row['title'].'

'.$lang->loc['items'].'

'; $sql = $db->query("SELECT * FROM ".PREFIX."faq WHERE type = 'item' ORDER BY catid ASC, id ASC"); $i = 0; while($row = $db->fetch_assoc($sql)){ $i++; if($input->IsEven($i)){ $even = ' class="even"'; }else{ $even = ''; } $content .= ' '; } $content .= '

'.$lang->loc['category'].'	'.$lang->loc['title'].'	'.$lang->loc['actions'].'
'.$row['catid'].'	'.$input->HoloText($row['title']).'

'; break; } ?>

loc['pagename.faq']; ?> loc['pagename.faq']; ?>