API tools faq
paste
Godleydemon

Untitled

Godleydemon
Jan 15th, 2017
164
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.20 KB | None | 0 0
raw download clone embed print report
  1. <html>
  2. <head>
  3. <title>Home - Zolus</title>
  4. <link rel="stylesheet" media="all" href="/Main/css/style.css">
  5. <link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet" integrity="sha384-wvfXpqpZZVQGK6TAh5PVlGOfQNHSoD2xbE+QkPxCAFlNEevoEH3Sl0sibVcOQVnN" crossorigin="anonymous">
  6. <link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
  7. <script src="https://code.jquery.com/jquery-1.12.4.js"></script>
  8. <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
  9. <script>
  10. $(document).ready(function () {
  11. var interval = 15000; //number of mili seconds between each call
  12. var refresh = function() {
  13. $.getJSON("http://mcapi.ca/query/8.26.94.180/players",function(json){
  14. if (json.status !== true) {
  15. // error
  16. $("#players .p1").text('The server is Offline').addClass('server-error');
  17. } else {
  18. // success
  19. $("#players .p1").text('There are');
  20. $("#players .p2").text('players online');
  21. $(".player-count").html(json.players.online);
  22. setTimeout(function(){ $('.player-count').removeClass('zoomIn').addClass('zoomOut') }, 14350);
  23. setTimeout(function(){ $('.player-count').removeClass('zoomOut').addClass('zoomIn') }, 0);
  24. }
  25. });
  26. setTimeout(function() {
  27. refresh();
  28. },
  29. interval);
  30. }
  31. refresh();
  32. });
  33. </script>
  34. </head>
  35. <body>
  36. <div class="site">
  37. <nav class="navbar navbar-default" style="border-radius: 0">
  38. <div class="container-fluid" style="max-width: 1000px">
  39. <div class="navbar-header">
  40. <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#main_nav_collapse">
  41. <span class="sr-only">Toggle navigation</span>
  42. <span class="icon-bar"></span>
  43. <span class="icon-bar"></span>
  44. <span class="icon-bar"></span>
  45. </button>
  46. <a class="navbar-brand" href="/">
  47. <img style="margin-top: -2px" src="/Main/images/logo.png" alt="Bar"/>
  48. </a> </div>
  49. <div id="main_nav_collapse" class="collapse navbar-collapse">
  50. <ul class="nav navbar-nav">
  51. <li>
  52. <a class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false"><i class="fa fa-users"></i> <span class="translation_missing" title="translation missing: en.community">Community</span> <span class="caret"></span></a>
  53. <ul class="dropdown-menu" role="menu">
  54.  
  55. <li>
  56. <a href="https://www.reddit.com/r/hcteams" target="_blank">HCTeams</a>
  57. </li>
  58. </ul>
  59. </li>
  60.  
  61. <li>
  62. <a class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false" href="/Main/stats.php"><i class="fa fa-bar-chart"></i> Stats</a>
  63. </li>
  64. <li>
  65. <a href="https://buycraft.zolus.net" target="_blank">
  66. <i class="fa fa-shopping-cart" aria-hidden="true"></i> Store
  67. </a>
  68. </li>
  69. </ul>
  70. <ul class="nav navbar-nav navbar-right">
  71. </ul>
  72. <ul class="nav navbar-nav navbar-right">
  73. <li>
  74. <div class="spinner">
  75. <div class="bounce1"></div>
  76. <div class="bounce2"></div>
  77. <div class="bounce3"></div>
  78. </div>
  79. </li>
  80. </ul>
  81. </div>
  82. </div>
  83. </nav>
  84. <div class="site-content">
  85. <div id="hero" class="text-center">
  86. <div style="padding-top: 150px">
  87. <h1 style="color: white; font-size: 90px; font-weight: 700; text-shadow: 0px 2px 25px black">Zolus Network</h1>
  88. <p style="color: white; font-size: 30px; text-shadow: 0px 2px 25px black; position: relative; float: right; margin-top: 200px;">Online Players: <span class="player-count"></span></p>
  89.  
  90. </div>
  91. </div>
  92. <div style="width: 100%; height: 30px; text-align: center; background-color: #3e3f3a; border-top: 3px #000 solid; border-bottom: 3px #000 solid"></div>
  93. <center>
  94. <br>
  95. <div class="container">
  96. <div class="well">
  97. <div class="table-responsive">
  98. <table class="table table-bordered" style="border-spacing: 0px!important;">
  99. <tr>
  100. <th style='border-top:1px solid #ddd!important; border-bottom:1px solid #ddd!important;border-right:0px!important;border-left:0px!important;'>Rank</th>
  101. <th style="min-width:55px!important; max-width:55px!important;border-top:1px solid #ddd!important; border-bottom:1px solid #ddd!important;border-right:0px!important;border-left:0px!important;"></th>
  102. <th style="border-top:1px solid #ddd!important; border-bottom:1px solid #ddd!important;border-right:0px!important;border-left:0px!important;">Username</th>
  103. <th style="border-top:1px solid #ddd!important; border-bottom:1px solid #ddd!important;border-right:0px!important;border-left:0px!important;">Kills</th>
  104. <th style="border-top:1px solid #ddd!important; border-bottom:1px solid #ddd!important;border-right:0px!important;border-left:0px!important;">Deaths</th>
  105. <th style="border-top:1px solid #ddd!important; border-bottom:1px solid #ddd!important;border-right:0px!important;border-left:0px!important;">Elo</th>
  106. </tr>
  107. <?php
  108. $i = 1;
  109. $con = mysqli_connect("127.0.0.1","practice","--------------","practice");
  110. if (mysqli_connect_errno()) {
  111. echo "Failed to connect to MySQL: " . mysqli_connect_error();
  112. } else {
  113. //echo "Connection made Succesful";
  114. //$listdbtables = array_column(mysqli_fetch_all($con->query('SHOW TABLES')),0);
  115. //echo "<BR>";
  116. echo "<BR>";
  117. //echo "Echoing Tables";
  118. //echo("<BR>" . $listdbtables[0] . "<BR>"); // print the table that was returned on that row.
  119. }
  120. //$results = mysqli_query( $con, "SELECT * FROM 'KDStats'" );
  121. //$sql = "SELECT ign, kills, deaths, elo, average_elo FROM KDStats ORDER BY CAST(average_elo AS float)";
  122. $sql = "SELECT uuid, ign, kills, deaths, elo, average_elo FROM KDStats ORDER BY LENGTH(average_elo) DESC, average_elo DESC LIMIT 0,25";
  123. $result = $con->query($sql);
  124.  
  125. if ($result->num_rows > 0){
  126. while($row = $result->fetch_assoc()){
  127. echo "<tr>"; ?>
  128. <td width="50" style="border-top:1px solid #ddd!important; border-bottom:1px solid #ddd!important;border-right:0px!important;border-left:0px!important;">
  129. <?php
  130. echo $i;
  131. $i++;
  132. ?>
  133.  
  134. </td>
  135. <td style="min-width:55px!important; max-width:55px!important; 1px solid #ddd!important; 1px solid #ddd!important;border-right:0px!important;border-left:0px!important;">
  136.  
  137. <?php
  138. echo "<img src='https://crafatar.com/renders/head/" . $row['uuid'] . ".png' width='60px' height='55px'";
  139. ?>
  140.  
  141. </td>
  142. <?php
  143. echo "<td style='border-top:1px solid #ddd!important; border-bottom:1px solid #ddd!important;border-right:0px!important;border-left:0px!important;'>" . $row['ign'] ."</td>";
  144. echo "<td style='border-top:1px solid #ddd!important; border-bottom:1px solid #ddd!important;border-right:0px!important;border-left:0px!important;'>" . $row['kills'] ."</td>";
  145. echo "<td style='border-top:1px solid #ddd!important; border-bottom:1px solid #ddd!important;border-right:0px!important;border-left:0px!important;'>" . $row['deaths'] ."</td>";
  146. echo "<td style='border-top:1px solid #ddd!important; border-bottom:1px solid #ddd!important;border-right:0px!important;border-left:0px!important;'>" . $row['average_elo'] ."</td>";
  147. echo "<tr>";
  148. }
  149. } else {
  150. echo "something must be wrong?";
  151. }
  152. ?>
  153. </table>
  154. </center>
  155. </div>
  156. </div>
  157. </div>
  158.  
  159. <?php
  160. $con->close();
  161. ?>
  162.  
  163. <footer>
  164. <div class="container">
  165. <div class="row">
  166. <div id="social" class="col-md-4">
  167. <h3 class="uppercase">Follow Us</h3>
  168. <ul class="social">
  169. <li>
  170. <a href="https://twitter.com/ZolusNetwork" class="blue" target="_blank">
  171. <i class="fa fa-twitter" style="position: relative; left: 3px"></i>
  172. </a>
  173. </li>
  174. <li>
  175. <a href="https://youtube.com/ZolusNetwork" class="red" target="_blank">
  176. <i class="fa fa-youtube" style="position: relative; left: 3px"></i>
  177. </a>
  178. </li>
  179. <li>
  180. <a href="https://twitch.tv/ZolusNetwork" class="purp" target="_blank">
  181. <i class="fa fa-twitch"></i>
  182. </a>
  183. </li>
  184. </ul>
  185. </div>
  186. <div class="col-md-4">
  187. <div id="footer_logo"></div>
  188. <p style="margin-top: 4px; text-align: center">Copyright &copy; Zolus 2017</p>
  189. </div>
  190. </div>
  191. </div>
  192. </footer>
  193. </div>
  194. </body>
  195. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!