Advertisement
Guest User

Untitled

a guest
Sep 22nd, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.37 KB | None | 0 0
  1. <html>
  2. <head>
  3. <style type="text/css">
  4.     .style11 {
  5.             text-align: center;
  6.             font-family: Verdana, Geneva, Tahoma, sans-serif;
  7.             color: #FFFFFF;
  8.             font-size: 15px;
  9.             background-image: url('public/images/bg.png');
  10.     }
  11.     .style12 {
  12.             text-align: center;
  13.             font-family: Verdana, Geneva, Tahoma, sans-serif;
  14.             color: #FFFFFF;
  15.             font-size: 14px;
  16.     }
  17. </style>
  18. </head>
  19. <center><body style="color: #FFFFFF; background-color: #0F0F0F">
  20. <table class="cssmixfinder" cellpadding="2" cellspacing="2">
  21. <tr>
  22. <td class="style11" style="width: 100px; height: 25px">
  23.                                     <strong>Skill</strong></td>
  24. <td class="style11" style="width: 100px; height: 25px">
  25.                                     <strong>Map</strong></td>
  26. <td class="style11" style="width: 100px; height: 25px">
  27.                                     <strong>Rounds</strong></td>
  28. <td class="style11" style="width: 100px; height: 25px">
  29.                                     <strong>Connection</strong></td>
  30. </tr>
  31. <?php
  32.  
  33. if ((isset($_POST['skill'])) && (isset($_POST['map'])) && (isset($_POST['round']))){
  34. $skill = $_POST['skill'];
  35. $map = $_POST['map'];
  36. $round = $_POST['round'];
  37. $id = $_GET["id"];
  38.  
  39. $connection = mysql_connect("127.0.0.1","root","");
  40. mysql_select_db("cssminxfinder", $connection);
  41. $numrows = mysql_query("SELECT count(*) AS nr FROM finder WHERE skill = '$skill' AND map = '$map' AND round = '$round'");
  42. $numrows = mysql_fetch_assoc($numrows);
  43. $nr = $numrows['nr'];
  44.  
  45. if ($nr == '0'){
  46. print 'No mixes matching serach results';
  47. }
  48.  
  49. else {
  50.  
  51. $result = mysql_query("SELECT * FROM finder WHERE skill = '" . $skill . "' AND map = '" . $map . "' AND round = '" . $round . "'");
  52.  
  53. while($result_ar = mysql_fetch_assoc($result)){
  54. ?> 
  55. <tr>
  56. <td class="style12"><?php print ''.$result_ar['skill'].''; ?></td>
  57. <td class="style12"><?php print ''.$result_ar['map'].''; ?></td>
  58. <td class="style12"><?php print ''.$result_ar['round'].''; ?></td>
  59. <?php print "<td class='style12'><a href='steam://connect/" . $result_ar['ip']  . "/" . $result_ar['pass'] . "'> <img src='public/images/connect-icon.png'> </a></td>";?>
  60. <?php mysql_query("DELETE FROM finder WHERE id = '".$_GET["id"]."' LIMIT 1"); ?>
  61. </tr></center>
  62. <?php
  63. }
  64. }
  65. }
  66.  
  67. else {
  68. print 'post values not set';
  69. }
  70. ?>
  71. </table>
  72. </body>
  73. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement