· 9 years ago · May 10, 2017, 07:02 AM
1<?php
2// Database configs, edit below to your configs
3$hostname = "localhost";
4$username = "username";
5$password = "password";
6$database = "database";
7$table = "admins";
8
9// No need to edit further
10
11// Connect to DB
12mysql_connect("$hostname", "$username", "$password") or die(mysql_error());
13mysql_select_db("$database") or die(mysql_error());
14
15// Create the admin table if it doesnt exist, and chances are it doesnt ;)
16mysql_query("CREATE TABLE IF NOT EXISTS ".$table." (
17 `fieldnumber` int(10) NOT NULL auto_increment,
18 `steamid` varchar(255) NOT NULL default '',
19 `password` varchar(255) NOT NULL default '',
20 `adminrights` varchar(255) NOT NULL default '',
21 `accountflags` varchar(255) NOT NULL default '',
22 `comments` varchar(255) NOT NULL default '',
23
24 PRIMARY KEY (`fieldnumber`)
25) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;");
26
27// Form fields
28$steamid = $_POST['steamid'];
29$password = $_POST['password'];
30$adminrights = $_POST['adminrights'];
31$accountflags = $_POST['accountflags'];
32$comments = $_POST['comments'];
33$fieldnumber = $_GET['fieldname'];
34$editadmin = $_GET['editadmin'];
35$dbquery = $_POST['dbquery'];
36$fieldnumber1 = $_POST['fieldnumber1'];
37
38// Refresh page
39$place = $_SERVER['PHP_SELF'];
40
41$selectquery = mysql_query("SELECT * FROM ".$table."") or die(mysql_error());
42$contentquery = mysql_fetch_array($selectquery);
43
44echo "
45<style>
46.steam {
47background:#eeeeee;
48font-family:tahoma;
49width:175px;
50height:20px;
51padding-left:10px;
52border:#ededed, 1px;
53color:#000000;
54text-decoration:none;
55}
56.steamtext {
57background:#ffffff;
58height:10px;
59width:175px;
60text-align:center;
61}
62.textbox {
63width:175px;
64}
65.steamtext1 {
66background:#ffffff;
67}
68</style>
69<body bgcolor='#aaaaaa'>
70
71<div align='center'>
72 <table cellspacing='1' cellpadding='0' width="100%>
73 <tr>
74 <td class='steam'>Steam ID</td>
75 <td class='steam'>Password</td>
76 <td class='steam'>Admin Rights</td>
77 <td class='steam'>Account Flags</td>
78 <td class='steam'>Comments</td>
79 <td class='steam'>Select</td>
80 </tr>
81 <form method='GET' action='$place'>
82";
83while($contentquery = mysql_fetch_array($selectquery)){
84echo "
85 <tr>
86 <td class='steamtext'>$contentquery[steamid]</td>
87 <td class='steamtext'>$contentquery[password]</td>
88 <td class='steamtext'>$contentquery[adminrights]</td>
89 <td class='steamtext'>$contentquery[accountflags]</td>
90 <td class='steamtext'>$contentquery[comments]</td>
91 <td class='steamtext' width='25'><input type='radio' name='fieldname'
92
93value='$contentquery[fieldnumber]'></td>
94 </tr>
95 ";}
96echo "
97 <tr>
98 <td colspan='6' class='steamtext1'>
99 <input type='submit' value='New' name='editadmin'><input type='submit' value='Edit'
100
101name='editadmin'><input type='submit' value='Delete' name='editadmin'></td>
102 </tr>
103 </form>
104";
105if ($editadmin=="New") {
106echo "
107<form method='POST' action='$place'>
108 <tr>
109 <td class='steamtext'><input class='textbox' type='text' name='steamid'></td>
110 <td class='steamtext'><input class='textbox' type='text' name='password'></td>
111 <td class='steamtext'><input class='textbox' type='text' name='adminrights'></td>
112 <td class='steamtext'><input class='textbox' type='text' name='accountflags'></td>
113 <td class='steamtext'><input class='textbox' type='text' name='comments'></td>
114 <td bgcolor='#ffffff' align='center'><input width='150' type='submit' name='dbquery'
115
116value='Submit'></td>
117 </tr>
118</form>
119";
120}
121if ($editadmin==Edit) {
122$query = mysql_query("SELECT * FROM $table WHERE fieldnumber=$fieldnumber;") or die(mysql_error("Error, Select query is teh
123
124uberfailz"));
125$editadmin = mysql_fetch_array($query);
126echo "
127<form method='POST' action='$place'>
128 <tr>
129 <td class='steamtext'><input class='textbox' type='text' name='fieldnumber1'
130
131value='$fieldnumber' readonly></td>
132 <td class='steamtext'><input value='$editadmin[steamid]' class='textbox' type='text'
133
134name='steamid'></td>
135 <td class='steamtext'><input value='$editadmin[password]' class='textbox' type='text'
136
137name='password'></td>
138 <td class='steamtext'><input value='$editadmin[adminrights]' class='textbox' type='text'
139
140name='adminrights'></td>
141 <td class='steamtext'><input value='$editadmin[accountflags]' class='textbox' type='text'
142
143name='accountflags'></td>
144 <td class='steamtext'><input value='$editadmin[comments]' class='textbox' type='text'
145
146name='comments'></td>
147 <td bgcolor='#ffffff'><input width='150' type='submit' name='dbquery' value='Update'></td>
148 </tr>
149</form>
150";
151}
152echo "
153 </tr>
154 </form>
155 </table>
156</div>
157
158</body>
159
160";
161
162// INSERT Content
163if ($dbquery==Submit) {
164mysql_query("INSERT INTO ".$table." (`fieldnumber`, `steamid`, `password`, `adminrights`, `accountflags`, `comments`)
165
166VALUES('', '$steamid', '$password', '$adminrights', '$accountflags', ';$comments');") or die("Error, insert query failed");
167echo "<script>self.location='".$place."';</script>\n";
168}
169
170// UPDATE Content
171if ($dbquery==Update) {
172mysql_query("UPDATE ".$table." SET steamid = '$steamid',password = '$password',adminrights = '$adminrights',accountflags =
173
174'$accountflags',comments = '$comments' WHERE fieldnumber = '$fieldnumber1';") or die("Error, update query failed");
175echo "<script>self.location='".$place."';</script>\n";
176}
177
178// DELETE Content
179if ($editadmin==Delete) {
180mysql_query("DELETE FROM ".$table." WHERE fieldnumber=$fieldnumber;") or die(mysql_error("Error, Delete query is teh
181
182uberfailz"));
183echo "<script>self.location='".$place."';</script>\n";
184}
185
186?>