addLocale("housekeeping.recommended");
$page['name'] = $lang->loc['pagename.recommended'];
$page['category'] = "tools";
if(isset($_POST['search'])){
$sql = $data->select7($input->FilterText($_POST['query']));
$search_results = "\n"; $i = 0;
while($row = $db->fetch_row($sql)){
if($input->IsEven($i)){ $even = "even"; }else{ $even = "odd"; }
$search_results .= "| ".$row[1]." | ".$row[0]." |
\n";
$i++;
}
$search_results .= "
";
}else{
$search_results = "\n| ".$lang->loc['search.desc']." |
";
}
if(isset($_GET['do']) && $_GET['do'] == "save"){
$row = $_POST;
$sponsored[(int) $row['sponsered']] = ' selected="true"';
$selected[$row['type']] = ' selected="true"';
if(!is_numeric($row['rec_id']) && $row['type'] == "room"){ $error = $lang->loc['error.invalid.roomid']."
"; }
if(!is_numeric($row['rec_id']) && $row['type'] == "group"){ $temp = $db->fetch_row($data->select8($input->FilterText($row['rec_id']))); $row['rec_id'] = $temp[0]; }
if(empty($row['rec_id'])){ $error = $lang->loc['error.no.recid']."
"; }
if($row['type'] == "room" && $row['sponsered'] != "0"){ $error = $lang->loc['error.invalid.location']; }
if(empty($error)){
if(!empty($row['id'])){
$db->query("UPDATE ".PREFIX."recommended SET rec_id = '".$input->FilterText($row['rec_id'])."', type = '".$input->FilterText($row['type'])."', sponsered = '".$input->FilterText($row['sponsered'])."' LIMIT 1");
$message = $lang->loc['message.recommended.modified'];
}else{
$db->query("INSERT INTO ".PREFIX."recommended (rec_id,type,sponsered) VALUES ('".$input->FilterText($row['rec_id'])."','".$input->FilterText($row['type'])."','".$input->FilterText($row['sponsered'])."')");
$message = $lang->loc['message.recommended.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."recommended WHERE id = '".$input->FilterText($_POST['id'])."' LIMIT 1");
unset($_POST); unset($_GET);
$message = $lang->loc['message.recommended.removed'];
}
}
if((isset($_GET['id']) || isset($_POST['id'])) && empty($row)){
$sql = $db->query("SELECT * FROM ".PREFIX."recommended WHERE id = '".$input->FilterText($_GET['id'])."' LIMIT 1");
$row = $db->fetch_assoc($sql);
$sponsored[(int) $row['sponsered']] = ' selected="true"';
$selected[$row['type']] = ' selected="true"';
}elseif(empty($row)){
$row['rec_id'] = $input->HoloText($_GET['recid']);
if(!empty($_GET['recid'])){ $selected['room'] = ' selected="true"'; }else{ $selected['group'] = ' selected="true"'; }
$sponsored[0] = ' selected="true"';
}
switch($_GET['do']){
case "create":
$lang->addLocale("housekeeping.recommended.create");
$icon = "recommended_create.png";
$description = $lang->loc['recommended.create.desc'];
$content = "";
if(!empty($error)){ $content .= ''.$error.'
'; }
$content .=
'';
break;
case "remove":
$lang->addLocale("housekeeping.recommended.remove");
$icon = "recommended_remove.png";
$description = $lang->loc['recommended.remove.desc'];
$content =
''.$lang->loc['confirm.remove'].' "'.$row['rec_id'].'"?
';
break;
default:
$lang->addLocale("housekeeping.recommended.display");
$icon = "recommended.png";
$description = $lang->loc['recommended.display.desc'];
$content = "";
if(isset($message) && !empty($message)){ $content .= ''.$message.'
'; }
$content .=
'';
break;
}
$page['scrollbar'] = true;
require_once('./templates/housekeeping_header.php');
?>
loc['pagename.recommended']; ?>
loc['pagename.recommended']; ?>
!['.$lang->loc['edit'].']('.PATH.'/housekeeping/images/icons/edit.png "'.$lang->loc['edit'].'"){kind=icon}
!['.$lang->loc['remove'].']('.PATH.'/housekeeping/images/icons/remove.png "'.$lang->loc['remove'].'"){kind=icon}