API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 7th, 2017
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 8.28 KB | None | 0 0
raw download clone embed print report
  1. <html><head><title>Supreme Skillers Admin</title><b>Supreme Skillers Admin Controls </b> Make sure you change your Password from the default.<form action="login.php" method="post"><input align=right type=submit name=submit value=Logout></form></head>
  2. <table border="4" align=right>
  3.   <tr><td align="center">
  4.   <body>
  5.   <form action="admin.php" method="post">
  6.   <table border="0"><caption><h4>Change Password?</h4></caption>
  7.   <TR><TD>Username      </TD><TD><input name="username" type="text"><br></TD>
  8.   <TR><TD>Current Password</TD> <TD>     <input name="old" type="password" size="20" maxlength="12"><br></TD>
  9.   <TR><TD>New Password</TD> <TD>     <input name="new" type="password" size="20" maxlength="12"><br></TD>
  10.   <TR><TD>Re-Enter Password</TD> <TD>     <input name="newconfirm" type="password" size="20" maxlength="12"><br></TD>
  11.   </table>
  12.   <input name="Change" type="submit" value="Change">
  13.   </form>
  14.   </body>
  15.  
  16. <?php
  17. if (strlen($_POST['username']) > 0) {
  18.   include('connect.inc');
  19.   $name = $_POST['username'];
  20.   $pass = $_POST['old'];
  21.   $total = mysql_query("SELECT COUNT(*) FROM users WHERE User='$name' AND Password='$pass'", $conn) or die(mysql_error());
  22.   $row = mysql_fetch_row($total);
  23.   $recordsfound = $row[0];
  24.   if ($recordsfound == 1) {
  25.     if (strlen($_POST['new']) > 5 && strlen($_POST['new']) < 13) {
  26.       if ($_POST['new'] == $_POST['newconfirm']) { mysql_query('UPDATE users SET password=\''. $_POST['new'] .'\' WHERE user=\''. $_POST['username'] .'\';') or die(mysql_error()); echo "PassWord Changed"; }
  27.       if ($_POST['new'] != $_POST['newconfirm']) { echo("Passwords do not Match"); }
  28.     }
  29.     else { echo "You have not entered a Valid new Password. Password must contain 6-12 AlphaNumeric Characters\n"; }
  30.   }
  31.   else { echo "Your Current Password was incorrect\n"; }
  32. }
  33. ?>
  34.  
  35. </td></tr><tr><td align="center" bgcolor="949494">
  36. <b>Force Update Monthly Skills.</b>
  37.   <form action="updater.php" method="get">Group 1 <input name="group1" type="submit" value="update"></form><form action="updater.php" method="get">Group 2 <input name="group2" type="submit" value="update"></form>
  38.   <form action="updater.php" method="get">Group 3 <input name="group3" type="submit" value="update"></form><form action="updater.php" method="get">Group 4 <input name="group4" type="submit" value="update"></form>
  39.   <form action="updater.php" method="get">Group 5 <input name="group5" type="submit" value="update"></form><form action="updater.php" method="get">Group 6 <input name="group6" type="submit" value="update"></form>
  40.   <form action="updater.php" method="get">Group 7 <input name="group7" type="submit" value="update"></form>
  41. </td></tr>
  42.  
  43. </table>
  44. <table border=0 cellspacing=2 cellpadding=1>
  45. <td valign=top align=justify>
  46. <table border="4">
  47. <tr><td><b>Month</b></td><td><b>Skill 1</b></td><td><b>Skill 2</b></td></tr>
  48. <tr><td>January</td><td><?php skill(Skill1,January); ?></td><td><?php skill(Skill2,January); ?></td></tr>
  49. <tr><td>February</td><td><?php skill(Skill1,February); ?></td><td><?php skill(Skill2,February); ?></td></tr>
  50. <tr><td>March</td><td><?php skill(Skill1,March); ?></td><td><?php skill(Skill2,March); ?></td></tr>
  51. <tr><td>April</td><td><?php skill(Skill1,April); ?></td><td><?php skill(Skill2,April); ?></td></tr>
  52. <tr><td>May</td><td><?php skill(Skill1,May); ?></td><td><?php skill(Skill2,May); ?></td></tr>
  53. <tr><td>June</td><td><?php skill(Skill1,June); ?></td><td><?php skill(Skill2,June); ?></td></tr>
  54. <tr><td>July</td><td><?php skill(Skill1,July); ?></td><td><?php skill(Skill2,July); ?></td></tr>
  55. <tr><td>August</td><td><?php skill(Skill1,August); ?></td><td><?php skill(Skill2,August); ?></td></tr>
  56. <tr><td>September</td><td><?php skill(Skill1,September); ?></td><td><?php skill(Skill2,September); ?></td></tr>
  57. <tr><td>October</td><td><?php skill(Skill1,October); ?></td><td><?php skill(Skill2,October); ?></td></tr>
  58. <tr><td>November</td><td><?php skill(Skill1,November); ?></td><td><?php skill(Skill2,November); ?></td></tr>
  59. <tr><td>December</td><td><?php skill(Skill1,December); ?></td><td><?php skill(Skill2,December); ?></td></tr>
  60. <?php
  61. $dropdown = $_GET['dropdown'];
  62. function dropdown() {
  63.   include('connect.inc');
  64.   $result = mysql_query("SELECT Skill FROM skills") or die(mysql_error());
  65.   echo("<select name=dropdown>");
  66.     while($array = mysql_fetch_array($result)) {
  67.       echo("<option value='$array[0]'>$array[0] </option>");
  68.     }
  69.   echo("</select>");
  70. }
  71. function skill($skill,$month) {
  72.   include('connect.inc');
  73.   $out = mysql_query("SELECT $skill FROM monthlyskill WHERE Month='$month'") or die(mysql_error());
  74.   while($array = mysql_fetch_array($out)) {
  75.     echo("$array[0]");
  76.   }
  77. }
  78. ?>
  79. </table>
  80. </td>
  81.  
  82. <?php //##################################################################################################### ?>
  83.  
  84. <td valign="top" align="center">
  85. <table border="4">
  86. <tr><td align="center">
  87. <table>
  88. <form action="admin.php" method="post">
  89. <caption><h4>Update Monthly Skills</h4></caption>
  90. <tr><td align=center><b>Month</b></td><td align=center><b>Skill1</b></td><td align=center><b>Skill2</b></td></tr>
  91. <tr><td><?php monthdrop(); ?></td><td><?php skill1drop(); ?></td><td><?php skill2drop(); ?></td></tr>
  92. <?php
  93. function monthdrop() {
  94. include('connect.inc');
  95.   $result = mysql_query("SELECT month FROM monthlyskill") or die(mysql_error());
  96.   echo("<select name=monthdrop>");
  97.     while($array = mysql_fetch_array($result)) {
  98.       echo("<option value='$array[0]'>$array[0] </option>");
  99.     }
  100.   echo("</select>");
  101. }
  102. function skill1drop() {
  103. include('connect.inc');
  104.   $result = mysql_query("SELECT Skill FROM Skills") or die(mysql_error());
  105.   echo("<select name=skill1drop>");
  106.     while($array = mysql_fetch_array($result)) {
  107.       echo("<option value='$array[0]'>$array[0] </option>");
  108.     }
  109.   echo("</select>");
  110. }
  111. function skill2drop() {
  112. include('connect.inc');
  113.   $result = mysql_query("SELECT Skill FROM Skills") or die(mysql_error());
  114.   echo("<select name=skill2drop>");
  115.     while($array = mysql_fetch_array($result)) {
  116.       echo("<option value='$array[0]'>$array[0] </option>");
  117.     }
  118.   echo("</select>");
  119. }
  120. if (strlen($_POST['skill1drop']) > 1) {
  121.     mysql_query('UPDATE monthlyskill SET Skill1=\''. $_POST['skill1drop'] .'\' WHERE Month=\''. $_POST['monthdrop'] .'\';') or die(mysql_error());
  122. }
  123. if (strlen($_POST['skill2drop']) > 1) {
  124.     mysql_query('UPDATE monthlyskill SET Skill2=\''. $_POST['skill2drop'] .'\' WHERE Month=\''. $_POST['monthdrop'] .'\';') or die(mysql_error());
  125. }
  126. ?>
  127. </table>
  128. <input name="Submit" type="submit" value="Submit Changes">
  129. </form>
  130. </table>
  131. <br>
  132. ^^^^^^ Use this to Change the Skills in a certain month, make sure you dont set the same skill twice, or edit the current month.
  133. </br>
  134. <br>
  135. <------ A list of the Monthly skills. Do not change the current months skills or it will fuck up.
  136. </br>
  137. <br>
  138. Use the update buttons to update the tables auto-update every hour or so. Pot luck getting the person you want. --------->
  139. </br>
  140. </td>
  141.  
  142.  
  143. <tr><td valign=top align=justify>
  144.  
  145. <table>
  146. <tr><td>Add Member</td></tr>
  147. <tr><td>
  148. <form action="admin.php" method="post"> <input type=text name=addrsn> <input type=submit name=add value=Add><input name="admin" type="checkbox" value="1">Admin?</form>
  149. </td></tr>
  150. </table>
  151. <?php
  152.  
  153. include('connect.inc');
  154.   $rsn = $_POST['addrsn'];
  155.   if (strlen($_POST['addrsn']) > 1) {
  156.     mysql_query("INSERT INTO users (User) VALUES ('$rsn')") or die(mysql_error());
  157.     if ($_POST['admin'] == 1) {
  158.       mysql_query('UPDATE users SET Access=\'1\' WHERE user=\''. $_POST['addrsn'] .'\';') or die(mysql_error());
  159.     }
  160. }
  161. ?>
  162.  
  163.  
  164.  
  165. <table>
  166. <tr><td>Remove Member</td></tr>
  167. <tr><td>
  168. <form action="admin.php" method="post"> <input type=text name=removersn> <input type=submit name=remove value=Remove></form>
  169. </td></tr>
  170. </table>
  171. <?php
  172. include('connect.inc');
  173.   $rsn = $_POST['removersn'];
  174.   if (strlen($_POST['removersn']) > 1) {
  175.     mysql_query("DELETE FROM users WHERE User = '$rsn'") or die(mysql_error());
  176. }
  177. ?>
  178.  
  179.  
  180.  
  181. <tr><td>
  182. <table border="4">
  183. <td><b>Supreme Skillers MemberList</b></td>
  184. <?php
  185. users();
  186. function users() {
  187. include('connect.inc');
  188.   $result = mysql_query("SELECT User FROM users ORDER BY user ASC") or die(mysql_error());
  189.     while($array = mysql_fetch_array($result)) {
  190.       echo("<tr><td>$array[0]</td></tr>");
  191.     }
  192. }
  193. ?>
  194. </table>
  195. </td></tr>
  196.  
  197.  
  198. </table>
  199. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!