window.location = \"../index.php\""; } else { ?> Tech Admin Panel = 6){ ?>

Tools Menu
Contact Kingsley
My Tickets
Support Ticket
View Applications
View all
Mass Email
Add a member to Tech
Remove member

Status Owner Summary Tech Owner Last Updated More Info "; while($info = mysql_fetch_array($sql)){ $owner = $info["ticket_owner"]; $towner = $info["ticket_tech_owner"]; $summary = $info["ticket_short_summary"]; $updated = date("d/n/y g:i:s A", $info["ticket_last_updated"]); $status = Status($info["ticket_status"]); print " $status $owner $summary $towner $updated Click "; } print ""; // Figure out the total number of results in DB: $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num from `tech_ticket`"),0); // Figure out the total number of pages. Always round up using ceil() $total_pages = ceil($total_results / $max_results); // Build Page Number Hyperlinks echo "

Select a page

"; // Build Previous Link if($page > 1){ $prev = ($page - 1); echo "< "; } for($i = 1; $i <= $total_pages; $i++){ if(($page) == $i){ echo "$i "; } else { echo "$i "; } } // Build Next Link if($page < $total_pages){ $next = ($page + 1); echo ">"; } print"

"; break; case "view_support_ticket"; $id = $_GET["id"]; $info = mysql_query("SELECT * FROM `tech_ticket` WHERE ticket_id = '$id'"); if(@mysql_num_rows($info) == 1) { $info = mysql_fetch_array($info); $temp = explode("\n",$info["ticket_info"]); $iconnection = $temp[0]; $firewall = $temp[2]; $comment = str_replace("||", "\n", $temp[3]); ?>

Their name:
Their email:
Owner:	Give ownership"; } else { print $info["ticket_tech_owner"]; }?>
No owner:	">Take Ownership
Topic:
Operating System:
Internet Connection:
Firewall:
Short Summary:
<?=$comment;?>

login("themeparktrips.co.uk", "ticket+beyondgaming.org", "xq7FC3cCD.)v"); $emailnum = $POP->getEmails(); $email = $POP->readEmails($emailnum); for($i = 1; $i <= $emailnum; $i++) { $subject[$i] = $email[$i]["subject"]; $message[$i] = $email[$i]["body"]; $from[$i] = $email[$i]["from"]; } //k, got everything.. $TID = addslashes($_GET["id"]); $q = mysql_query("SELECT * from tech_ticket WHERE ticket_tech_owner = '{$_SESSION['user']['name']}' AND ticket_id = '$TID'"); if(@mysql_num_rows($q) > 0) { $r = mysql_fetch_array($q); for($i = 1; $i <= count($subject); $i++) { //which one's are mine? if(strpos($subject[$i], $r["ticket_unique_id"]) > 0) { $mine[] = $i; $subject_reply = $subject[$i]; $from_reply = $from[$i]; } } } for($i = 0; $i < count($mine); $i++) { print "

".$subject[$mine[$i]]."

".$message[$mine[$i]]."

"; } ?>

Message:

Status Summary Last Updated   "; while($info = mysql_fetch_array($sql)){ $owner = $info["ticket_owner"]; $towner = $info["ticket_tech_owner"]; $summary = $info["ticket_short_summary"]; $updated = date("d/n/y g:i:s A", $info["ticket_last_updated"]); $status = Status($info["ticket_status"]); print " $status $summary $updated Support Mode "; } print ""; // Figure out the total number of results in DB: $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num from `tech_ticket` WHERE ticket_tech_owner = '{$_SESSION['user']['name']}'"),0); // Figure out the total number of pages. Always round up using ceil() $total_pages = ceil($total_results / $max_results); // Build Page Number Hyperlinks echo "

Select a page

"; // Build Previous Link if($page > 1){ $prev = ($page - 1); echo "< "; } for($i = 1; $i <= $total_pages; $i++){ if(($page) == $i){ echo "$i "; } else { echo "$i "; } } // Build Next Link if($page < $total_pages){ $next = ($page + 1); echo ">"; } print"

"; break; case "send_mail"; ?>

Name:
Subject:
Optional level:
Message:

NameVotes"; while($r = mysql_fetch_array($q)){ $votes = @mysql_num_rows(mysql_query("SELECT * from `votes` where vote_id='".$r["id"]."'")); $name = explode("\n",$r["application"]); ?> "> '}" /> "; } if(is_numeric($_GET["id"]) && $_GET["id"] != ""){ $id = addslashes($_GET["id"]); $q = mysql_query("SELECT * from `applications` where id='$id'"); $vq = @mysql_query("SELECT * from votes where vote_id = '$id'"); $r = mysql_fetch_array($q); $info = explode("\n",$r["application"]); ?>

Application loged at:
Name:
Email:
Age:
DoB:
Country:
Timezone:
Time Available:
Meet new people:
Experience with hardware:
Explain: ",$info["9"])?>
Communication skills:
Handle Abuse: ",$info["11"])?>
Why help: ",$info["12"])?>
Previous exp: ",$info["13"])?>
Related exp: ", $info["14"])?>

Task(s) wanted: 0){ while($vr = mysql_fetch_array($vq)){ if($vr["voter"] == $myname){ $voted = true; } print "\n\n\n"; } } ?>

Voter	Vote	Reason
{$vr['voter']}	{$vr['vote']}	{$vr['reason']}

Vote:	YesNo
Reason:

UsernameLevelLast LoginStrikesIP Address"; while($users = mysql_fetch_array($q)){ $s = mysql_query("SELECT * from strikes where username='".$users["username"]."'"); ?>

" name="username" />

"; break; case "add_to_Tech"; ?>

Username:
Level:	$i"; } print "6"; } elseif($lvl6chk < 3){ for($i=1;$i<=$maxlvl;$i++){ print "$i"; } } ?>

Member:	".$member["username"].""; } ?>

"); print "Email sent."; } break; case "take_ticket_ownership"; $tid = addslashes($_GET["tid"]); $q = mysql_query("SELECT * from tech_ticket where ticket_id = '$tid'"); if(@mysql_num_rows($q) == 1) { mysql_query("UPDATE tech_ticket SET ticket_tech_owner = '{$_SESSION['user']['name']}', ticket_last_updated = '" . time() . "' WHERE ticket_id = '$tid'"); print "You now own ticket $tid
My Tickets"; } break; case "search_staff"; if(isset($_POST["smember"])) { print ""; } else { print ""; } break; case "send_mail"; $name = $_POST["Name"]; $subject = $_POST["Subject"]; $message = $_POST["Message"]; $adminp = $_GET["committee"]; if($name != "" && $subject != "" && $message != ""){ $message .= "\nFrom: $adminp"; mail("kingsley@beyondgaming.org", $subject, $message, "From: $name "); print "Email sent!
"; } else { print "Make sure to fill out all forms!
"; } break; case "vote"; $app_id = addslashes($_POST["app_id"]); $vote = addslashes($_POST["vote"]); $reason = addslashes($_POST["reason"]); if(($_SESSION["committee"]["name"] == "Admin" && $_SESSION["user"]["level"] >= 6) || ($_SESSION["committee"]["name"] == "Tech" && $_SESSION["user"]["level"] >= 6) && trim($vote) != "" && trim($reason) != "" && trim($app_id) != ""){ mysql_query("INSERT INTO votes values ('$app_id', '$myname', '$vote', '$reason')"); print "Voted!"; } else { print "You cannot submit a vote"; } break; case "mass_email"; if(($_SESSION["committee"]["name"] == "Admin" && $_SESSION["user"]["level"] > 5) || ($_SESSION["committee"]["name"] == "Tech" && $_SESSION["user"]["level"] >= 6)){ $subject = $_POST["subject"]; $message = $_POST["message"]; $level = $_POST["level"]; print MassEmail("Tech", $level, $subject, $message); } break; case "delete_application"; $app_id = addslashes($_GET["app_id"]); if(($_SESSION["committee"]["name"] == "Admin" || $_SESSION["committee"]["name"] == "Tech") && $_SESSION["user"]["level"] == 7){ if(trim($app_id) != "") { mysql_query("DELETE from applications where id = '$app_id' AND committee = 'tech'"); mysql_query("INSERT INTO `adminlogs` values ('$myname', 'Delete application', '$app_id => Tech', 'Accepted', '$time')"); print "Deleted application"; } else { print "You must have an ID to delete!"; } } else { mysql_query("INSERT INTO `adminlogs` values ('$myname', 'Delete application', '$app_id => Tech', 'Denied', '$time')"); print "You cannot delete this application!"; } break; case "Tech_Application"; if(($_SESSION["committee"]["name"] == "Admin" && $_SESSION["user"]["level"] > 5) || ($_SESSION["committee"]["name"] == "Tech" && $_SESSION["user"]["level"] == 7)){ if($config["Apps_Tech"]){ mysql_query("UPDATE site_config set site_value = 0 where site_option = 'Apps_Tech'"); ?>