addLocale("housekeeping.settings"); $sql = $db->query("SELECT * FROM ".PREFIX."settings_pages WHERE id = '".$input->FilterText($_GET['page'])."' LIMIT 1"); if(!isset($_GET['page']) || $db->num_rows($sql) < 1){ header("HTTP/1.0 404 Not Found"); require_once('./error.php'); exit; }else{ $pagerow = $db->fetch_assoc($sql); } function sql46($id) { $sql44 = mysql_query("SELECT * FROM ".PREFIX."settings WHERE category = 'Papiers' AND page = 'content' AND id='".$id."'"); $sql45 = mysql_fetch_assoc($sql44); $sql46 = $sql45['value']; return $sql46; } $page['name'] = $pagerow['name']; $page['category'] = "settings"; require_once('./templates/housekeeping_header.php'); ?>
query("INSERT INTO hk_logs (from_user,to_user,action,message,time) VALUES ('".$user->name."','','settings_modified','System settings modified','".$time."')") or die(mysql_error()); foreach($_POST as $key => $value){ if(($key == "paper_disclaimer" && $value !== sql46('paper_disclaimer')) || ($key == "paper_privacy" && $value !== sql46('paper_privacy'))) { $time = date('d-m-Y H:i:s',mktime(date('H'),date('i'),date('s'),date('m'),date('d'),date('Y'))); $GLOBALS['serverdb']->query("INSERT INTO hk_logs (from_user,to_user,action,message,time) VALUES ('".$user->name."','','settings_modified','Privacy and/or disclaimer modified !','".$time."')") or die(mysql_error()); } $value = $input->FilterText($value); $db->query("UPDATE ".PREFIX."settings SET value = '".$value."' WHERE id = '".$key."' LIMIT 1"); } $settings->generateCache(); ?>
Settings saved.
query("SELECT category FROM ".PREFIX."settings WHERE page = '".$pagerow['id']."' GROUP BY category ORDER BY `order` ASC"); while($row = $db->fetch_assoc($sql)){ echo "

".$row['category']."

\n"; $sql2 = $db->query("SELECT * FROM ".PREFIX."settings WHERE category = '".$row['category']."' AND page = '".$pagerow['id']."' ORDER BY `order` ASC"); while($row2 = $db->fetch_assoc($sql2)){ echo "
\n"; switch($row2['type']){ case "textbox": echo '
'; echo "\n"; break; case "radiobuttons": $values = explode(";",$row2['values']); foreach($values as $value){ $value = explode(",",$value); if($value[0] == $row2['value']){ $value[2] = " checked=\"true\""; } echo ''.$value[1].' '; } echo "
\n"; break; case "selectbox": echo "
\n"; break; case "textarea": echo '
'; break; } } } ?>