API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 22nd, 2016
93
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.24 KB | None | 0 0
raw download clone embed print report
  1. <html>
  2. <head>
  3. <meta charset="utf-8">
  4. <meta name="viewport" content="width=device-width">
  5. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" integrity="sha384-1q8mTJOASx8j1Au+a5WDVnPi2lkFfwwEAa8hDDdjZlpLegxhjVME1fgjWPGmkzs7" crossorigin="anonymous">
  6. <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.0/jquery.min.js"></script>
  7. <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
  8. </head>
  9. <body>
  10. <div class="panel panel-default">
  11. <!-- Default panel contents -->
  12. <div class="panel-heading"><h3>Fahandungs-Liste | DieFreimaurer</h3></div>
  13. <div class="panel-body">
  14. </br>
  15. <?php
  16. $username = "root";
  17. $password = "#Lappen123247#";
  18. $hostname = "localhost";
  19. $db_name = "a3";
  20. if( $_GET["edit"] and $_GET["pid"]) {
  21. $pid = $_GET["pid"];
  22. $_link = mysql_connect($hostname, $username, $password);
  23. if (!$_link)
  24. {
  25. die("Keine Verbindung zur Datenbank möglich: " .
  26. mysql_error());
  27. }
  28. mysql_select_db($db_name, $_link);
  29. $_wantedCrimes;
  30. $_wantedName;
  31. $_wantedBounty;
  32. $_sql = "SELECT * FROM wanted WHERE wantedID=" . $pid;
  33. $knast = "";
  34. $reason;
  35. $minute;
  36. $_resultat = mysql_query($_sql, $_link);
  37. while($row = mysql_fetch_assoc($_resultat)) {
  38. $_wantedCrimes = $row["wantedCrimes"];
  39. $_wantedName = $row["wantedName"];
  40. $_wantedBounty = $row["wantedBounty"];
  41. if (strpos($row["wantedCrimes"] ,'Mord')!==false or strpos($row["wantedCrimes"] ,'Überfahren einer Person')!==false or strpos($row["wantedCrimes"] ,'Töten eines Polizisten')!==false or $row["wantedBounty"] > "999999") {
  42. $knast = "Ja";
  43. if(strpos($row["wantedCrimes"] ,'Mord')!==false or strpos($row["wantedCrimes"] ,'Überfahren einer Person')!==false or strpos($row["wantedCrimes"] ,'Töten eines Polizisten')!==false and $row["wantedBounty"] > "999999"){
  44. $reason = "Mord/Kill + Geld &uuml;ber 1Mio";
  45. $minute = $row["wantedBounty"] / 100000;
  46. $minute = round($minute);
  47. $minute = $minute + 15;
  48. }elseif(strpos($row["wantedCrimes"] ,'Mord')!==false or strpos($row["wantedCrimes"] ,'Überfahren einer Person')!==false or strpos($row["wantedCrimes"] ,'Töten eines Polizisten')!==false){
  49. $reason = "Mord/Kill";
  50. $minute = $row["wantedBounty"] / 100000;
  51. $minute = round($minute);
  52. $minute = $minute + 15;
  53. }elseif($row["wantedBounty"] > "999999"){
  54. $reason = " Geld &uuml;ber 1Mio";
  55. $minute = $row["wantedBounty"] / 100000;
  56. $minute = round($minute);
  57. $minute = $minute + 15;
  58. }
  59. }else{
  60. $knast = "Nein";
  61. }
  62.  
  63. }
  64. $string = $_wantedCrimes;
  65. $string = str_replace("ä", "&auml;", $string);
  66. $string = str_replace("ü", "&uuml;", $string);
  67. $string = str_replace("ö", "&ouml;", $string);
  68. $string = str_replace("Ä", "&Auml;", $string);
  69. $string = str_replace("Ü", "&Uuml;", $string);
  70. $string = str_replace("Ö", "&Ouml;", $string);
  71. $string = str_replace("ß", "&szlig;", $string);
  72. $_wantedCrimes = $string;
  73. $prozent = $_wantedBounty / "1000000" * "100";
  74. if ($knast == "Ja"){
  75. echo('<div class="row">
  76. <div class="panel panel-default"><div class="panel-body">' . '<h4>Name: ' . $_wantedName . '</h4>' . '<h4>Geht ins Gef&auml;ngnis?: ' . $knast . '</h4>' . '
  77. </br><font color="red"><h4>Kopfgeld:' . number_format($_wantedBounty, 0, ',', '.') .'$ </br> Grund: ' . $reason . ' | ' . $minute . 'min. </h4></br>
  78. </font>
  79. <div class="col-xs-12 col-sm-6 col-md-8">
  80. </br>
  81. <div class="progress">
  82. <div class="progress-bar progress-bar-success progress-bar-striped active" style="width: 55%">
  83. <span class="sr-only">55% Complete (success)</span>
  84. </div>
  85. <div class="progress-bar progress-bar-warning progress-bar-striped active" style="width: 30%">
  86. <span class="sr-only">30% Complete (warning)</span>
  87. </div>
  88. <div class="progress-bar progress-bar-danger progress-bar-striped active" style="width: 15%">
  89. <span class="sr-only">15% Complete (danger)</span>
  90. </div>
  91. </div>
  92. </div>');
  93. }else{
  94. $_p1;
  95. $_p2;
  96. $_p3;
  97. if($prozent <= "55"){
  98. $_p1 = $prozent . "%";
  99. $_p2 = "0%";
  100. $_p3 = "0%";
  101. }elseif($prozent < "85"){
  102. $_p1 = "55%";
  103. $_p2tmp = $prozent - "55";
  104. $_p2 = $_p2tmp . "%";
  105. $_p3 = "0%";
  106. }elseif($prozent >= "85"){
  107. $_p1 = "55%";
  108. $_p2 = "30%";
  109. $_p3tmp = $prozent - "85";
  110. $_p3 = $_p3tmp . "%";
  111.  
  112. }
  113. echo('<div class="row">
  114. <div class="panel panel-default"><div class="panel-body">' . '<h4>Name: ' . $_wantedName . '</h4>' . '<h4>Geht ins Gef&auml;ngnis?: ' . $knast . '</h4>' . '</br><h4>Kopfgeld:' . number_format($_wantedBounty, 0, ',', '.') .'$</h4></br></div></div>
  115. <div class="col-xs-12 col-sm-6 col-md-8">
  116. <div class="progress">
  117. <div class="progress-bar progress-bar-success progress-bar-striped active" style="width: ' . $_p1 .'">
  118. <span class="sr-only">'. $_p1 .' Complete (success)</span>
  119. </div>
  120. <div class="progress-bar progress-bar-warning progress-bar-striped active" style="width: '. $_p2 .'">
  121. <span class="sr-only">'. $_p2 .' Complete (warning)</span>
  122. </div>
  123. <div class="progress-bar progress-bar-danger progress-bar-striped active" style="width: '. $_p3 .'">
  124. <span class="sr-only">'. $_p3 .' Complete (danger)</span>
  125. </div>
  126. </div></div>
  127. </div>');
  128. }
  129. function GetBetween($string, $start, $end)
  130. {
  131. $pos = stripos($string, $start);
  132.  
  133. $str = substr($string, $pos);
  134.  
  135. $str_two = substr($str, strlen($start));
  136.  
  137. $second_pos = stripos($str_two, $end);
  138.  
  139. $str_three = substr($str_two, 0, $second_pos);
  140.  
  141. $get_tmp = trim($str_three); // remove whitespaces
  142.  
  143. if(preg_match_all('/\d+/', $get_tmp, $numbers))
  144. return end($numbers[0]);
  145. }
  146. echo('<div class="row"><div class="col-md-8">');
  147. echo('<table class="table table-striped table-hover table-bordered sortable" id="tblData">
  148. <thead>
  149. <tr>
  150. <th>Straftat</th>
  151. <th>Anzahl</th>
  152. </tr>
  153. </thead>
  154. <tbody>');
  155.  
  156.  
  157. $tmp_wanted_crimes = str_replace('"[[',"",$_wantedCrimes);
  158. $tmp_wanted_crimes = str_replace(']]"',"",$tmp_wanted_crimes);
  159. $wanted_array = explode( '],[',$tmp_wanted_crimes );
  160. for($i=0; $i < count($wanted_array); $i++) {
  161. $tmp_w_array = $wanted_array[$i];
  162. $tmp_w_array = str_replace('"',"",$tmp_w_array);
  163. $tmp_wa_array = explode( ',',$tmp_w_array);
  164. echo('<tr><td>' . $tmp_wa_array[1] . "</td><td>" . $tmp_wa_array[0] . "</td></tr>");
  165. }
  166.  
  167.  
  168.  
  169. echo('</tbody></table></div></div></br></br>');
  170. echo('<a href="?" class="btn btn-default">Zur&uuml;ck</a></br>');
  171. mysql_close($_link);
  172. }else{
  173. echo('<div class="input-group">
  174. <span class="input-group-addon" id="basic-addon1">@</span>
  175. <input type="text" class="form-control" placeholder="Player search..." aria-describedby="basic-addon1" id="search">
  176. </div>
  177. </br>
  178. <table class="table table-striped table-hover table-bordered sortable" id="tblData">
  179. <thead>
  180. <tr>
  181. <th>Name</th>
  182. <th>Kopfgeld</th>
  183. <th>Muss ins Gef&auml;ngnis</th>
  184. <th>Actions</th>
  185. </tr>
  186. </thead>
  187. <tbody>');
  188. $_link = mysql_connect($hostname, $username, $password);
  189. if (!$_link)
  190. {
  191. die("Keine Verbindung zur Datenbank m&ouml;glich: " .
  192. mysql_error());
  193. }
  194. mysql_select_db($db_name, $_link);
  195.  
  196. $_sql = "SELECT * FROM wanted WHERE active=1 ORDER BY wantedBounty DESC";
  197. $_resultat = mysql_query($_sql, $_link);
  198. while($row = mysql_fetch_assoc($_resultat)) {
  199. $knast = "";
  200. if (strpos($row["wantedCrimes"] ,'Mord')!==false or strpos($row["wantedCrimes"] ,'Überfahren einer Person')!==false or strpos($row["wantedCrimes"] ,'Töten eines Polizisten')!==false or $row["wantedBounty"] > "999999") {
  201. $knast = "Ja";
  202. }else{
  203. $knast = "Nein";
  204. }
  205. $string = $row["wantedName"];
  206. $string = str_replace("ä", "&auml;", $string);
  207. $string = str_replace("ü", "&uuml;", $string);
  208. $string = str_replace("ö", "&ouml;", $string);
  209. $string = str_replace("Ä", "&Auml;", $string);
  210. $string = str_replace("Ü", "&Uuml;", $string);
  211. $string = str_replace("Ö", "&Ouml;", $string);
  212. $string = str_replace("ß", "&szlig;", $string);
  213. $string = str_replace("´", "", $string);
  214. echo('<tr><td>' . $string . '</td><td>' . number_format($row["wantedBounty"], 0, ',', '.') . '$</th><td>' . $knast. '</th><td><a href="?edit=1&pid=' . $row["wantedID"] . '">Ansehen</a></td></tr>');
  215. }mysql_close($_link);
  216. echo(' </tbody>
  217. </table>
  218. </div>');
  219. }
  220. ?>
  221. </br>
  222. <footer class="footer">
  223. <div class="container">
  224. <p class="text-muted" style=" text-align: center;">Made by Rentner Reiner @PineappleNET</p>
  225. </div>
  226. </footer>
  227. <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js"></script>
  228. <script type="text/javascript">
  229. $(document).ready(function()
  230. {
  231. $('#search').keyup(function()
  232. {
  233. searchTable($(this).val());
  234. });
  235. });
  236.  
  237. function searchTable(inputVal)
  238. {
  239. var table = $('#tblData');
  240. table.find('tr').each(function(index, row)
  241. {
  242. var allCells = $(row).find('td');
  243. if(allCells.length > 0)
  244. {
  245. var found = false;
  246. allCells.each(function(index, td)
  247. {
  248. var regExp = new RegExp(inputVal, 'i');
  249. if(regExp.test($(td).text()))
  250. {
  251. found = true;
  252. return false;
  253. }
  254. });
  255. if(found == true)$(row).show();else $(row).hide();
  256. }
  257. });
  258. }
  259. </script>
  260. </body>
  261. </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!