addLocale("housekeeping.alerts"); $page['name'] = $lang->loc['pagename.alerts']; $page['category'] = "users"; require_once('./templates/housekeeping_header.php'); $type = $_GET['type']; if(isset($_POST['search'])){ $sql = $serverdb->query("SELECT id,name FROM ".PREFIX."users WHERE name LIKE '%".$input->FilterText($_POST['query'])."%' LIMIT 50"); $search_results = "\n"; $i = 0; while($row = $db->fetch_row($sql)){ if($input->IsEven($i)){ $even = "even"; }else{ $even = "odd"; } $search_results .= "\n"; $i++; } $search_results .= "
".$row[1]."".$row[0]."
"; }else{ $search_results = "\n
".$lang->loc['search.desc']."
"; } if(isset($_GET['do']) && $_GET['do'] == "save"){ $row = $_POST; if($type == "single" && empty($row['userid'])){ $error = $lang->loc['error.no.userid']; } if(!empty($row['alert'])){ $error = $lang->loc['error.no.alert']; } if(empty($_POST['hotel']) && empty($_POST['site'])){ $error = $lang->loc['error.no.where']; } if(empty($error)){ if($row['site'] == "1"){ if(!empty($row['id'])){ if($type == "single"){ $db->query("UPDATE ".PREFIX."alerts SET alert = '".$input->FilterText($row['alert'])."', time = '".time()."' WHERE id = '".$input->FilterText($row['id'])."' LIMIT 1"); }else{ $orginal = @$db->result($db->query("SELECT alert FROM ".PREFIX."alerts WHERE id = '".$row['id']."' LIMIT 1")); $db->query("UPDATE ".PREFIX."alerts SET alert = '".$input->FilterText($row['alert'])."', time = '".time()."' WHERE alert = '".$orginal."' AND type = '0'"); } $message = $lang->loc['message.alert.modified']; }else{ if($type == "single"){ $db->query("INSERT INTO ".PREFIX."alerts (userid,alert,type,time) VALUES ('".$input->FilterText($row['userid'])."','".$input->FilterText($row['alert'])."','2','".time()."')"); }else{ @set_time_limit(0); $sql = $db->query("SELECT id FROM ".PREFIX."users"); while($urow = $db->fetch_row($sql)){ $db->query("INSERT INTO ".PREFIX."alerts (userid,alert,type,time) VALUES ('".$input->FilterText($urow[0])."','".$input->FilterText($row['alert'])."','0','".time()."')"); } } $message = $lang->loc['message.alert.created']; } } if($row['hotel'] == "1"){ if($type == "single"){ @SendMUSData('HKMW'.$row['userid'].chr(2).$row['alert']); }else{ @set_time_limit(0); $sql = $db->query("SELECT id FROM ".PREFIX."users"); while($urow = $db->fetch_row($sql)){ @SendMUSData('HKTM'.$urow[0].chr(2).$row['alert']); } } } if($row['help'] == "true"){ header('Location: '.PATH.'/housekeeping/help'); } unset($_POST); unset($_GET); }else{ $_GET['do'] = "create"; } }elseif($_GET['do'] == "remove"){ if(isset($_POST['id']) && isset($_POST['remove'])){ if($type == "single"){ $db->query("DELETE FROM ".PREFIX."alerts WHERE id = '".$input->FilterText($_POST['id'])."' LIMIT 1"); }else{ $orginal = @$db->result($db->query("SELECT alert FROM ".PREFIX."alerts WHERE id = '".$input->FilterText($_POST['id'])."' LIMIT 1")); $db->query("DELETE FROM ".PREFIX."alerts WHERE alert = '".$orginal."' AND type = '0'"); } unset($_POST); unset($_GET); $message = $lang->loc['message.alert.removed']; } } if((isset($_GET['id']) || isset($_POST['id'])) && empty($row)){ $sql = $db->query("SELECT * FROM ".PREFIX."alerts WHERE id = '".$input->FilterText($_GET['id'])."' LIMIT 1"); $row = $db->fetch_assoc($sql); $checked[0] = ' checked="true"'; }elseif(empty($row)){ if(!empty($_GET['userid'])){ $row['userid'] = $input->HoloText($_GET['userid']); } if(!empty($_GET['alert'])){ $row['alert'] = $input->HoloText(urldecode($_GET['alert'])); } $checked[0] = ' checked="true"'; $checked[1] = ' checked="true"'; } switch($_GET['do']){ case "create": $lang->addLocale("housekeeping.alerts.create"); $icon = "alerts.png"; if($type == "single"){ $description = $lang->loc['alerts.create.single.desc']; $content = ""; if(!empty($error)){ $content .= '
'.$error.'
'; } $content .= '
'; if(!empty($row['id'])){ $content .= ''; } if($_GET['help'] == "true"){ $content .= ''; } $content .= '




  
'; }else{ $description = $lang->loc['alerts.create.mass.desc']; $content = ""; if(!empty($error)){ $content .= '
'.$error.'
'; } $content .= '
'; if(!empty($row['id'])){ $content .= ''; } $content .= '


  
'; } break; case "remove": $lang->addLocale("housekeeping.alerts.remove"); $icon = "alerts.png"; $description = $lang->loc['alerts.remove.desc']; $content = '
'.$lang->loc['confirm.remove'].' "'.$input->HoloText($row['alert']).'"?
'; break; default: $lang->addLocale("housekeeping.alerts.display"); $icon = "alerts.png"; $description = $lang->loc['alerts.display.desc']; $content = ""; if(isset($message) && !empty($message)){ $content .= '
'.$message.'
'; } $content .= '
'; $sql = $db->query("SELECT * FROM ".PREFIX."alerts WHERE type = '0' GROUP BY alert ORDER BY time DESC"); $i = 0; while($row = $db->fetch_assoc($sql)){ $i++; if($input->IsEven($i)){ $even = ' class="even"'; }else{ $even = ''; } $content .= ' '; } $sql = $db->query("SELECT * FROM ".PREFIX."alerts WHERE type > '0' ORDER BY time DESC"); while($row = $db->fetch_assoc($sql)){ $i++; if($input->IsEven($i)){ $even = ' class="even"'; }else{ $even = ''; } $content .= ' '; } $content .= '
'.$lang->loc['alert'].' '.$lang->loc['userid'].' '.$lang->loc['date'].' '.$lang->loc['actions'].'
'.$input->HoloText($row['alert']).' '.$lang->loc['mass'].' '.date('n/j/Y g:i A',$row['time']).' '.$lang->loc['edit'].''.$lang->loc['remove'].'
'.$input->HoloText($row['alert']).' '.$row['id'].' '.date('n/j/Y g:i A',$row['time']).' '.$lang->loc['edit'].''.$lang->loc['remove'].'
'; break; } ?>
loc['pagename.alerts']; ?> loc['pagename.alerts']; ?>