addLocale("housekeeping.help"); $page['name'] = $lang->loc['pagename.help']; $page['category'] = "users"; require_once('./templates/housekeeping_header.php'); if(isset($_GET['do']) && $_GET['do'] == "pickup"){ $id = $input->FilterText($_GET['id']); $db->query("UPDATE ".PREFIX."help SET picked_up = '1' WHERE id = '".$id."' LIMIT 1"); $message = $lang->loc['message.help.picked.up']; unset($_POST); unset($_GET); }elseif($_GET['do'] == "remove"){ if(isset($_POST['id']) && isset($_POST['remove'])){ if($_POST['id'] == "*"){ $db->query("TRUNCATE TABLE ".PREFIX."help"); }else{ $db->query("DELETE FROM ".PREFIX."help WHERE id = '".$input->FilterText($_POST['id'])."' LIMIT 1"); } unset($_POST); unset($_GET); $message = $lang->loc['message.help.removed']; } }elseif($_GET['do'] == "reply"){ $id = $input->FilterText($_GET['id']); $db->query("UPDATE ".PREFIX."help SET picked_up = '1' WHERE id = '".$id."' LIMIT 1"); $sql = $db->query("SELECT * FROM ".PREFIX."help WHERE id = '".$input->FilterText($_GET['id'])."' LIMIT 1"); $row = $db->fetch_assoc($sql); $usql = $serverdb->query("SELECT id FROM ".PREFIX."users WHERE name = '".$input->FilterText($input->HoloText($row['username']))."' LIMIT 1"); if($serverdb->num_rows($usql) > 0){ $userid = $db->result($usql); }else{ $userid = null; } $alert = urlencode($lang->loc['alert.message.1'].' '.$user->name.', '.$lang->loc['alert.message.2'].': "'.$row['subject'].'"'."\n\n"); header('Location: '.PATH.'/7vpba0cuy2gcy0d1ch1njin4holc5hiztxuhk4b01ozu2/alerts?do=create&type=single&help=true&userid='.$userid.'&alert='.$alert); } if((isset($_GET['id']) || isset($_POST['id'])) && empty($row)){ $sql = $db->query("SELECT * FROM ".PREFIX."help WHERE id = '".$input->FilterText($_GET['id'])."' LIMIT 1"); $row = $db->fetch_assoc($sql); if($_GET['id'] == "all"){ $row['id'] = "*"; $row['subject'] = $lang->loc['all']; } } switch($_GET['do']){ case "remove": $lang->addLocale("housekeeping.help.remove"); $icon = "help.png"; $description = $lang->loc['help.remove.desc']; $content = '

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

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

'.$message.'

'; } $content .= '

'; $sql = $db->query("SELECT * FROM ".PREFIX."help ORDER BY picked_up ASC, date DESC"); $i = 0; while($row = $db->fetch_assoc($sql)){ $i++; $usql = $serverdb->query("SELECT id FROM ".PREFIX."users WHERE name = '".$input->FilterText($input->HoloText($row['username']))."' LIMIT 1"); if($serverdb->num_rows($usql) > 0){ $userid = $db->result($usql); }else{ $userid = null; } if($input->IsEven($i)){ $even = ' class="even"'; }else{ $even = ''; } $content .= ' '; } $content .= '

'.$lang->loc['subject'].'	'.$lang->loc['message'].'	'.$lang->loc['username'].'	'.$lang->loc['date'].'	'.$lang->loc['picked.up'].'	'.$lang->loc['actions'].'
'; if(!empty($userid)){ $content .= ''.$input->HoloText($row['subject']).''; }else{ $content .= $input->HoloText($row['subject']); } $content .= '	'; if(!empty($userid)){ $content .= ''.$input->HoloText($row['message']).''; }else{ $content .= $input->HoloText($row['message']); } $content .= '	'; if(!empty($userid)){ $content .= ''.$input->HoloText($row['username']).''; }else{ $content .= $input->HoloText($row['username']); } $content .= '	'.date('n/j/Y g:i A',$row['date']).'	'.$input->HoloText($row['picked_up']).'	'; if(!empty($userid)){ $content .= ''; } $content .= '

'; break; } ?>

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