Reply to thread

Message

<blockquote data-quote="Central" data-source="post: 377705" data-attributes="member: 57042">Hello, I have stumbled across with this Staff Pin System and decided to release it.All you have to do is follow the following steps:<ul>
<li data-xf-list-type="ul">With the code's you will see below you will need to edit them</li>
<li data-xf-list-type="ul">The code marked bottom of the client.php file you will need to change mysql password to your mysql password</li>
<li data-xf-list-type="ul">As well as changing mysql database name with your database name</li>
<li data-xf-list-type="ul">Once completed those, please add that code to the bottom of the client.php, add it after &lt;div class=&quot;client&quot;&gt;&lt;/div&gt; or something along the lines as this.</li>
<li data-xf-list-type="ul">Go to app/tpl/skins/SKINFOLDER/ and make a new php file and name it spk, and add the contents of the spk code from this topic into there.</li>
<li data-xf-list-type="ul">Go to your database, right click the table users and click Design Table (only if you are using Navicat) and add a new field, this field should be called staff_pin and you will just need to save it, if it says you havent filled anything in, put the type as Varchar and the limit or something as 255.</li>
</ul>[SPOILER=&quot;Bottom of the Client.php file&quot;]&lt;style&gt;&nbsp; &nbsp; body {&nbsp; &nbsp; background-color: #212121;}&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; form {&nbsp; &nbsp; &nbsp; &nbsp; position:absolute;&nbsp; &nbsp; &nbsp; &nbsp; top:30%;&nbsp; &nbsp; &nbsp; &nbsp; right:0;&nbsp; &nbsp; &nbsp; &nbsp; left:0;&nbsp; &nbsp; &nbsp; &nbsp; text-align: center;&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; select {&nbsp; &nbsp; &nbsp; &nbsp; background-image: url('<a href="http://i.imgur.com/yokKfHN.png');" target="_blank">http://i.imgur.com/yokKfHN.png');</a>&nbsp; &nbsp; &nbsp; &nbsp; background-size: 150px 150px;&nbsp; &nbsp; &nbsp; &nbsp; height: 160px;&nbsp; &nbsp; &nbsp; &nbsp; width: 130px;&nbsp; &nbsp; &nbsp; &nbsp; font-size: 50px;&nbsp; &nbsp; &nbsp; &nbsp; text-indent: 40%;&nbsp; &nbsp; &nbsp; &nbsp; color: orange;&nbsp; &nbsp; &nbsp; &nbsp; border: none;&nbsp; &nbsp; &nbsp; &nbsp; border-radius: 10px;&nbsp; &nbsp; &nbsp; &nbsp; text-align: center}&nbsp; &nbsp; select:focus,&nbsp; &nbsp; input:focus {&nbsp; &nbsp; &nbsp; &nbsp; outline: none;&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; input {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; color: orange;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; background-color: transparent;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; border: 1px solid orange;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; height: 100px;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; width: 100px;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; border-radius: 100%;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; font-size: 50px;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; select:hover {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; color: darkorange;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; input:hover {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; color: darkorange;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; border: 1px solid darkorange;&nbsp; &nbsp; &nbsp; &nbsp; }&lt;/style&gt;&nbsp; &nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $connect = mysql_connect(&quot;localhost&quot;, &quot;root&quot;, &quot;my sql password&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mysql_select_db(&quot;mysql database name&quot;, $connect);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $username = $_SESSION[&quot;user&quot;][&quot;username&quot;];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $query = mysql_query(&quot;SELECT * FROM `users` WHERE `username` = '$username'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(mysql_num_rows($query) == 1)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $row = mysql_fetch_assoc($query);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $rank = $row[&quot;rank&quot;];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($rank &gt;= 2 &amp;&amp; !isset($_SESSION[&quot;correct_key&quot;]))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;form action='spk' method='post'&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;select name='first'&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='0'&gt;0&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='1'&gt;1&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='2'&gt;2&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='3'&gt;3&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='4'&gt;4&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='5'&gt;5&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='6'&gt;6&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='7'&gt;7&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='8'&gt;8&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='9'&gt;9&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/select&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;select name='second'&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='0'&gt;0&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='1'&gt;1&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='2'&gt;2&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='3'&gt;3&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='4'&gt;4&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='5'&gt;5&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='6'&gt;6&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='7'&gt;7&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='8'&gt;8&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='9'&gt;9&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/select&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;select name='third'&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='0'&gt;0&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='1'&gt;1&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='2'&gt;2&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='3'&gt;3&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='4'&gt;4&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='5'&gt;5&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='6'&gt;6&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='7'&gt;7&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='8'&gt;8&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='9'&gt;9&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/select&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;select name='fourth'&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='0'&gt;0&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='1'&gt;1&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='2'&gt;2&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='3'&gt;3&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='4'&gt;4&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='5'&gt;5&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='6'&gt;6&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='7'&gt;7&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='8'&gt;8&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option value='9'&gt;9&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/select&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type='submit' name='staff_key' value='Go' /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/form&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; exit;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; die(&quot;Sorry, something went wrong with your account, apparently you do not exist, please try logging in.&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &lt;/body&gt;&lt;/div&gt;&nbsp; [/SPOILER][SPOILER=&quot;spk.php&quot;]&lt;?php&nbsp; &nbsp; session_start();&nbsp; &nbsp; $username = strip_tags(stripslashes(mysql_real_escape_string($_SESSION[&quot;user&quot;][&quot;username&quot;])));&nbsp; &nbsp; &nbsp; &nbsp; $connect = mysql_connect(&quot;localhost&quot;, &quot;root&quot;, &quot;$wqoiwqwqs&quot;);&nbsp; &nbsp; mysql_select_db(&quot;fixeddb&quot;, $connect);&nbsp; &nbsp; &nbsp; &nbsp; $first = strip_tags(stripslashes(mysql_real_escape_string($_POST[&quot;first&quot;])));&nbsp; &nbsp; $second = strip_tags(stripslashes(mysql_real_escape_string($_POST[&quot;second&quot;])));&nbsp; &nbsp; $third = strip_tags(stripslashes(mysql_real_escape_string($_POST[&quot;third&quot;])));&nbsp; &nbsp; $fourth = strip_tags(stripslashes(mysql_real_escape_string($_POST[&quot;fourth&quot;])));&nbsp; &nbsp; $key = $first.&quot;&quot;.$second.&quot;&quot;.$third.&quot;&quot;.$fourth;&nbsp; &nbsp; if(is_numeric($key))&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $query = mysql_query(&quot;SELECT * FROM `users` WHERE `username` = '$username'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; $row = mysql_fetch_assoc($query);&nbsp; &nbsp; &nbsp; &nbsp; $valid_key = $row[&quot;staff_pin&quot;];&nbsp; &nbsp; &nbsp; &nbsp; if($key == $valid_key)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; session_start();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $_SESSION[&quot;correct_key&quot;] = $key;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; die(&quot;Incorrect Key!&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }else&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; die(&quot;Key must be 4 numbers...&quot;);&nbsp; &nbsp; &nbsp; &nbsp; }?&gt;&lt;style&gt;&nbsp; &nbsp; body {&nbsp; &nbsp; &nbsp; &nbsp; background-color: #212121;&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; #container {&nbsp; &nbsp; &nbsp; &nbsp; position: absolute;&nbsp; &nbsp; &nbsp; &nbsp; width: 600px;&nbsp; &nbsp; &nbsp; &nbsp; height: 172px;&nbsp; &nbsp; &nbsp; &nbsp; margin: auto;&nbsp; &nbsp; &nbsp; &nbsp; position: absolute;&nbsp; &nbsp; &nbsp; &nbsp; top: 0; left: 0; bottom: 0; right: 0;&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; #main {&nbsp; &nbsp; &nbsp; &nbsp; width: 500px;&nbsp; &nbsp; &nbsp; &nbsp; text-align: center;&nbsp; &nbsp; &nbsp; &nbsp; height: 70px;&nbsp; &nbsp; &nbsp; &nbsp; padding: 10px;&nbsp; &nbsp; &nbsp; &nbsp; background-color: #333333;&nbsp; &nbsp; &nbsp; &nbsp; border: 1px solid orange;&nbsp; &nbsp; &nbsp; &nbsp; margin: 0 auto;&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; #main h1 {&nbsp; &nbsp; &nbsp; &nbsp; color: orange;&nbsp; &nbsp; &nbsp; &nbsp; font-size: 20px;&nbsp; &nbsp; &nbsp; &nbsp; font-family: sans-serif;&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; #nav {&nbsp; &nbsp; &nbsp; &nbsp; box-sizing: border-box;&nbsp; &nbsp; &nbsp; &nbsp; border: 1px solid orange;&nbsp; &nbsp; &nbsp; &nbsp; width: 200px;&nbsp; &nbsp; &nbsp; &nbsp; height: 50px;&nbsp; &nbsp; &nbsp; &nbsp; background-color: #333333;&nbsp; &nbsp; &nbsp; &nbsp; text-align: center;&nbsp; &nbsp; &nbsp; &nbsp; margin: 30 auto;&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; #nav h2,&nbsp; &nbsp; #nav a {&nbsp; &nbsp; &nbsp; &nbsp; text-decoration: none;&nbsp; &nbsp; &nbsp; &nbsp; color: orange;&nbsp; &nbsp; &nbsp; &nbsp; font-size: 20px;&nbsp; &nbsp; &nbsp; &nbsp; font-family: sans-serif;&nbsp; &nbsp; &nbsp; &nbsp; line-height: 20px;&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; #nav:hover,&nbsp; &nbsp; #main:hover {&nbsp; &nbsp; &nbsp; &nbsp; border: 1px solid darkorange;&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; #main h1:hover,&nbsp; &nbsp; #nav h2:hover {&nbsp; &nbsp; &nbsp; &nbsp; color: darkorange;&nbsp; &nbsp; }&lt;/style&gt;&lt;div id=&quot;container&quot;&gt;&lt;div id=&quot;main&quot;&gt;&nbsp; &nbsp; &lt;h1&gt;You have entered your staff pin correctly! Click the button to go back to the client!&lt;/h1&gt;&lt;/div&gt;&lt;div id=&quot;nav&quot;&gt;&nbsp; &nbsp; &lt;a href=&quot;{url}/client&quot;&gt;&lt;h2&gt;Enter Client&lt;/h2&gt;&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;[/SPOILER]Screenshot<img src="http://i.imgur.com/0a9vN0a.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /> </blockquote>

[QUOTE="Central, post: 377705, member: 57042"] Hello, I have stumbled across with this Staff Pin System and decided to release it. All you have to do is follow the following steps: [LIST] [*]With the code's you will see below you will need to edit them [*]The code marked [B]bottom of the client.php file [/B]you will need to change [B]mysql password [/B]to your mysql password [*]As well as changing [B]mysql database name [/B]with your database name [*]Once completed those, please add that code to the bottom of the client.php, add it after [B]<div class="client"></div> [/B]or something along the lines as this. [*]Go to [B]app/tpl/skins/SKINFOLDER/ [/B]and make a new php file and name it spk, and add the contents of the spk code from this topic into there. [*]Go to your database, right click the table [B]users [/B]and click Design Table (only if you are using Navicat) and add a new field, this field should be called [B]staff_pin [/B]and you will just need to save it, if it says you havent filled anything in, put the type as Varchar and the limit or something as 255. [/LIST] [SPOILER="Bottom of the Client.php file"] <style> body { background-color: #212121; } form { position:absolute; top:30%; right:0; left:0; text-align: center; } select { background-image: url('[URL]http://i.imgur.com/yokKfHN.png');[/URL] background-size: 150px 150px; height: 160px; width: 130px; font-size: 50px; text-indent: 40%; color: orange; border: none; border-radius: 10px; text-align: center } select:focus, input:focus { outline: none; } input { color: orange; background-color: transparent; border: 1px solid orange; height: 100px; width: 100px; border-radius: 100%; font-size: 50px; } select:hover { color: darkorange; } input:hover { color: darkorange; border: 1px solid darkorange; }</style> <?php $connect = mysql_connect("localhost", "root", "my sql password"); mysql_select_db("mysql database name", $connect); $username = $_SESSION["user"]["username"]; $query = mysql_query("SELECT * FROM `users` WHERE `username` = '$username'"); if(mysql_num_rows($query) == 1) { $row = mysql_fetch_assoc($query); $rank = $row["rank"]; if($rank >= 2 && !isset($_SESSION["correct_key"])) { ?> <form action='spk' method='post'> <select name='first'> <option value='0'>0</option> <option value='1'>1</option> <option value='2'>2</option> <option value='3'>3</option> <option value='4'>4</option> <option value='5'>5</option> <option value='6'>6</option> <option value='7'>7</option> <option value='8'>8</option> <option value='9'>9</option> </select> <select name='second'> <option value='0'>0</option> <option value='1'>1</option> <option value='2'>2</option> <option value='3'>3</option> <option value='4'>4</option> <option value='5'>5</option> <option value='6'>6</option> <option value='7'>7</option> <option value='8'>8</option> <option value='9'>9</option> </select> <select name='third'> <option value='0'>0</option> <option value='1'>1</option> <option value='2'>2</option> <option value='3'>3</option> <option value='4'>4</option> <option value='5'>5</option> <option value='6'>6</option> <option value='7'>7</option> <option value='8'>8</option> <option value='9'>9</option> </select> <select name='fourth'> <option value='0'>0</option> <option value='1'>1</option> <option value='2'>2</option> <option value='3'>3</option> <option value='4'>4</option> <option value='5'>5</option> <option value='6'>6</option> <option value='7'>7</option> <option value='8'>8</option> <option value='9'>9</option> </select> <input type='submit' name='staff_key' value='Go' /> </form> <?php exit; } }else { die("Sorry, something went wrong with your account, apparently you do not exist, please try logging in."); } ?> </body></div> [/SPOILER] [SPOILER="spk.php"] <?php session_start(); $username = strip_tags(stripslashes(mysql_real_escape_string($_SESSION["user"]["username"]))); $connect = mysql_connect("localhost", "root", "$wqoiwqwqs"); mysql_select_db("fixeddb", $connect); $first = strip_tags(stripslashes(mysql_real_escape_string($_POST["first"]))); $second = strip_tags(stripslashes(mysql_real_escape_string($_POST["second"]))); $third = strip_tags(stripslashes(mysql_real_escape_string($_POST["third"]))); $fourth = strip_tags(stripslashes(mysql_real_escape_string($_POST["fourth"]))); $key = $first."".$second."".$third."".$fourth; if(is_numeric($key)) { $query = mysql_query("SELECT * FROM `users` WHERE `username` = '$username'"); $row = mysql_fetch_assoc($query); $valid_key = $row["staff_pin"]; if($key == $valid_key) { session_start(); $_SESSION["correct_key"] = $key; }else{ die("Incorrect Key!"); } }else { die("Key must be 4 numbers..."); } ?> <style> body { background-color: #212121; } #container { position: absolute; width: 600px; height: 172px; margin: auto; position: absolute; top: 0; left: 0; bottom: 0; right: 0; } #main { width: 500px; text-align: center; height: 70px; padding: 10px; background-color: #333333; border: 1px solid orange; margin: 0 auto; } #main h1 { color: orange; font-size: 20px; font-family: sans-serif; } #nav { box-sizing: border-box; border: 1px solid orange; width: 200px; height: 50px; background-color: #333333; text-align: center; margin: 30 auto; } #nav h2, #nav a { text-decoration: none; color: orange; font-size: 20px; font-family: sans-serif; line-height: 20px; } #nav:hover, #main:hover { border: 1px solid darkorange; } #main h1:hover, #nav h2:hover { color: darkorange; } </style> <div id="container"> <div id="main"> <h1>You have entered your staff pin correctly! Click the button to go back to the client!</h1> </div> <div id="nav"> <a href="{url}/client"><h2>Enter Client</h2></a> </div> </div> [/SPOILER] [B]Screenshot [IMG]http://i.imgur.com/0a9vN0a.png[/IMG] [/B] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members