# # File name: tech_system.php # Author: Kingsley # Date: 10/6/2008 # Time: 7:32 PM # if(isset($_POST["Name"], $_POST["Email"], $_POST["OS"], $_POST["Topic"], $_POST["IConnection"], $_POST["Firewall"], $_POST["Comment"], $_POST["Submit"])) { //generate our ticket and email them back. $name = addslashes($_POST["Name"]); $email = addslashes($_POST["Email"]); $topic = addslashes($_POST["Topic"]); $OS = addslashes($_POST["OS"]); $IConnection = addslashes($_POST["IConnection"]); $Firewall = addslashes($_POST["Firewall"]); $YFire = addslashes($_POST["YFire"]); $SSummary = addslashes($_POST["ShortSummary"]); $Comment = addslashes($_POST["Comment"]); $unique_id = generate_unique_id(); $name = str_replace("@", "(AT)", $name); $info = "$IConnection\n$Firewall\n$YFire\n" . str_replace("\n", "||", $Comment); mysql_query("INSERT INTO `tech_ticket` VALUES('0', '$unique_id', '1', '" . time() . "', '0', '', '$name', '$email', '$topic', '$SSummary', '$OS', '" . time() ."', '$info')"); mail("$name <$email>", "Support Ticket [#$unique_id]", "Hello $name,\n\nThis is an automatic message to let you know that your ticket has been added to the system.\nThere is no need to reply to this message.\n\nKind regards,\nBeyond Gaming", "From: ticket@beyondgaming.org"); mail("ticket@beyondgaming.org", "Support Ticket [#$unique_id]", "Name: $name\nEmail: $email\nTopic: $topic\nOS: $OS\nInternet: $IConnection\nFirewall: $Firewall\nFirewallY: $YFire\nSummary: $SSummary\n$Comment"); print "Your request number is #$unique_id, please put it in the subject when emailing us.
"; } $res = mysql_query("SELECT email from users WHERE username = '{$_SESSION['user']['name']}'"); if(mysql_num_rows($res) == 1) { $emaill = mysql_fetch_array($res); $emaill = $emaill["email"]; } @mysql_free_result($res); if(isset($_SESSION["user"]["name"])) { ?>
} else { ?> You are not registered, or logged in. Please use the "Contact Us" form. } ?>