WizZy™ Posted April 26, 2009 Posted April 26, 2009 I was bored and i got nothing to do.. so i made a simple PHP script.It is a script ,who you can put in your site for players to report others for bugs. Demo : http://l2phytes.no-ip.org/report.php (if you think this is an ad ,remove my topic.) So here we go.. I configure it for a table called "hack" (dunno why :D) but you can change it anyway.. For SQL CREATE TABLE `reports` ( `ot` varchar(255) collate latin1_swedish_ci NOT NULL default '', `id` int(11) collate latin1_swedish_ci NOT NULL auto_increment, `izp` varchar(255) collate latin1_swedish_ci NOT NULL, `screen` varchar(255) collate latin1_swedish_ci NOT NULL default '', `pesen` varchar(255) collate latin1_swedish_ci NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=376 ; conf.php <?php $user = "root"; //Your MySQL user $pass = "pass"; //Your MySQL Password $db = "hack"; //Your MySQL database $host = "localhost"; // Your MySQL address (its as default) $connection = mysql_connect($host, $user, $pass) or die("Error with MySQL connecting"); // AIO connect $db = mysql_select_db($db,$connection)or die("Error with MySQL connecting2"); // database connect $chars="set character set latin1"; //set chars mysql_query($chars); // mysql query for chars ?> report.php <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <?php include('conf.php');?> <center> <p>Still beta version! For bugs report at forum and reward shall follow. <br> <br> Submiter (Your nick Ingame): <input type="text" name="user"><br> Hacker nick (Ingame): <input type="text" name="izp"><br> What he do?: <input type="text" name="pesen"><br> Screenshot or proof: <input type="text" name"screen"> </p> <p><strong>NOTE : If you do a fake report ,all IP's are stored in the databse.So if you do a fake , we will find your IP and ban your account for 1 month.So be careful what you do!</strong><br> <input type="submit" name="button" value="Report"> </p> <?php if($_POST['button']){ $b=$_POST['user']; $izp=$_POST['izp']; $screen=$_POST['screen']; $pesen=$_POST['pesen']; $query = mysql_query("INSERT INTO `reports` (ot, izp, pesen, screen) VALUES('$ot','$izp','$pesen','$screen')"); echo "You reported someone successfuly.<br><a href=\"index.php\">Go back to the index</a>";} ?> <center> reportadmin.php - NOTE : Its secured!Please read the file carefuly to see where to edit. <?php include('conf.php'); session_start(); $name[] = "user1"; $pass[] = "pass1"; // Username for login 1 $name[] = "user2"; $pass[] = "pass2"; // Username for login 2 //You can add as much users you want. function loginform(){ //The form that unlogged users will use echo '<fieldset style="padding: 2">'; echo '<legend>Login</legend>'; echo '<form method=post action="?">'; echo 'Name: <input type=text name=username value="' . $_POST[username] . '">'; //The name echo '<br>'; echo 'Pass: <input type=password name=pass>'; //The password echo '<br>'; echo '<input type=submit name="s1" value="Login">'; // The submit button echo '</form>'; echo '</fieldset>'; } if($_GET['action'] == "logout"){ // Logging out $_SESSION['loggedin'] = false; $_SESSION['username'] = ""; } if($_SESSION['loggedin'] == false){ // Protection from NULL logins if(!$_POST['s1']){ loginform(); }else{ $tmpname = $_POST['username']; #the username the user has submitted $tmppass = $_POST['pass']; #the password the user has submitted $t = count($name); #count the total users $i = 0; while($i <= $t){ if($tmpname == $name[$i] && $tmppass == $pass[$i]){ //Checking $_SESSION['loggedin'] = true; $_SESSION['username'] = $name[$i]; header('Location: ?'); #reload the page } $i++; } echo "Your attempt is invalid.IP stored."; //If something is wrong loginform(); #show the form } die; // if something is wrong , destroy it } ?> <center><br>Welcome <?php echo $_SESSION['username']; ?> <br><a href="?action=logout">Logout</a> . </center> <br> <?php $query="SELECT * FROM reports ORDER by id DESC LIMIT 1"; // Selection of SQL table and column $result=mysql_query($query); // Getting query while ( $r = mysql_fetch_array( $result )){ // The result $ot=$r['ot']; // From $id=$r['id']; // NULL $pesen=$r['pesen']; // What he did $izp=$r['izp']; // Hacker name $screen=$r['screen']; // Screen or proof echo"<b>Submitted by </b>: $ot"; echo "<b><br>Hacker name </b>: $izp"; echo "<b><br>And he tryes to do </b>: $pesen"; echo "<b><br>And proof is </b>: $screen"; echo ""; } ?> <?php $file = fopen('ipadmin.txt', 'a'); // opens ,create a new file with storage fwrite($file,$_SERVER['REMOTE_ADDR']."\n"); // Ip storing fclose($file); // Close the file echo "<br><b>Your ip was stored successfuly.</b>"; // if successful ?> [uPDATES] reportadmin.php is secured and passwords added also IP is recording. [uPDATES] All credits to Me.. I`ll add some protects because i think its hackable..Like they can submit a java ALERT command and fuk up some things.. So i`ll secure it when i can.This is from me 4 now.. Thanks for viewing my topic. Quote
Animus Posted July 22, 2009 Posted July 22, 2009 Awesome share man!Very usefull for the good operation of a server! Quote
Draagoon Posted July 22, 2009 Posted July 22, 2009 nice report system, i will definitely use it. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.