Untitled

<?php
// Database configs, edit below to your configs
$hostname = "localhost";
$username = "username";
$password = "password";
$database = "database";
$table = "admins";

// No need to edit further

// Connect to DB
mysql_connect("$hostname", "$username", "$password") or die(mysql_error());
mysql_select_db("$database") or die(mysql_error());

// Create the admin table if it doesnt exist, and chances are it doesnt ;)
mysql_query("CREATE TABLE IF NOT EXISTS ".$table." (
  `fieldnumber` int(10) NOT NULL auto_increment,
  `steamid` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `adminrights` varchar(255) NOT NULL default '',
  `accountflags` varchar(255) NOT NULL default '',
  `comments` varchar(255) NOT NULL default '',

  PRIMARY KEY  (`fieldnumber`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;");

// Form fields
$steamid = $_POST['steamid'];
$password = $_POST['password'];
$adminrights = $_POST['adminrights'];
$accountflags = $_POST['accountflags'];
$comments = $_POST['comments'];
$fieldnumber = $_GET['fieldname'];
$editadmin = $_GET['editadmin'];
$dbquery = $_POST['dbquery'];
$fieldnumber1 = $_POST['fieldnumber1'];

// Refresh page
$place = $_SERVER['PHP_SELF'];

$selectquery = mysql_query("SELECT * FROM ".$table."") or die(mysql_error());
$contentquery = mysql_fetch_array($selectquery);

echo "
<style>
.steam {
background:#eeeeee;
font-family:tahoma;
width:175px;
height:20px;
padding-left:10px;
border:#ededed, 1px;
color:#000000;
text-decoration:none;
}
.steamtext {
background:#ffffff;
height:10px;
width:175px;
text-align:center;
}
.textbox {
width:175px;
}
.steamtext1 {
background:#ffffff;
}
</style>
<body bgcolor='#aaaaaa'>

<div align='center'>
    <table cellspacing='1' cellpadding='0' width="100%>
            <tr>
            <td class='steam'>Steam ID</td>
            <td class='steam'>Password</td>
            <td class='steam'>Admin Rights</td>
            <td class='steam'>Account Flags</td>
            <td class='steam'>Comments</td>
            <td class='steam'>Select</td>
        </tr>
    <form method='GET' action='$place'>
";
while($contentquery = mysql_fetch_array($selectquery)){
echo "
            <tr>
                <td class='steamtext'>$contentquery[steamid]</td>
                <td class='steamtext'>$contentquery[password]</td>
                <td class='steamtext'>$contentquery[adminrights]</td>
                <td class='steamtext'>$contentquery[accountflags]</td>
                <td class='steamtext'>$contentquery[comments]</td>
                <td class='steamtext' width='25'><input type='radio' name='fieldname'

value='$contentquery[fieldnumber]'></td>
            </tr>
            ";}
echo "
            <tr>
                <td colspan='6' class='steamtext1'>
                <input type='submit' value='New' name='editadmin'><input type='submit' value='Edit'

name='editadmin'><input type='submit' value='Delete' name='editadmin'></td>
            </tr>
            </form>
";
if ($editadmin=="New") {
echo "
<form method='POST' action='$place'>
            <tr>
                <td class='steamtext'><input class='textbox' type='text' name='steamid'></td>
                <td class='steamtext'><input class='textbox' type='text' name='password'></td>
                <td class='steamtext'><input class='textbox' type='text' name='adminrights'></td>
                <td class='steamtext'><input class='textbox' type='text' name='accountflags'></td>
                <td class='steamtext'><input class='textbox' type='text' name='comments'></td>
                <td bgcolor='#ffffff' align='center'><input width='150' type='submit' name='dbquery'

value='Submit'></td>
            </tr>
</form>
";
}
if ($editadmin==Edit) {
$query = mysql_query("SELECT * FROM $table WHERE fieldnumber=$fieldnumber;") or die(mysql_error("Error, Select query is teh

uberfailz"));
$editadmin = mysql_fetch_array($query);
echo "
<form method='POST' action='$place'>
            <tr>
                <td class='steamtext'><input class='textbox' type='text' name='fieldnumber1'

value='$fieldnumber' readonly></td>
                <td class='steamtext'><input value='$editadmin[steamid]' class='textbox' type='text'

name='steamid'></td>
                <td class='steamtext'><input value='$editadmin[password]' class='textbox' type='text'

name='password'></td>
                <td class='steamtext'><input value='$editadmin[adminrights]' class='textbox' type='text'

name='adminrights'></td>
                <td class='steamtext'><input value='$editadmin[accountflags]' class='textbox' type='text'

name='accountflags'></td>
                <td class='steamtext'><input value='$editadmin[comments]' class='textbox' type='text'

name='comments'></td>
                <td bgcolor='#ffffff'><input width='150' type='submit' name='dbquery' value='Update'></td>
            </tr>
</form>
";
}
echo "
            </tr>
        </form>
    </table>
</div>

</body>

";

// INSERT Content
if ($dbquery==Submit) {
mysql_query("INSERT INTO ".$table." (`fieldnumber`, `steamid`, `password`, `adminrights`, `accountflags`, `comments`)

VALUES('', '$steamid', '$password', '$adminrights', '$accountflags', ';$comments');") or die("Error, insert query failed");
echo "<script>self.location='".$place."';</script>\n";
}

// UPDATE Content
if ($dbquery==Update) {
mysql_query("UPDATE ".$table." SET steamid = '$steamid',password = '$password',adminrights = '$adminrights',accountflags =

'$accountflags',comments = '$comments' WHERE fieldnumber = '$fieldnumber1';") or die("Error, update query failed");
echo "<script>self.location='".$place."';</script>\n";
}

// DELETE Content
if ($editadmin==Delete) {
mysql_query("DELETE FROM ".$table." WHERE fieldnumber=$fieldnumber;") or die(mysql_error("Error, Delete query is teh

uberfailz"));
echo "<script>self.location='".$place."';</script>\n";
}

?>