Advertisement
Guest User

Untitled

a guest
Jan 22nd, 2017
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.62 KB | None | 0 0
  1. <?php
  2. date_default_timezone_set('Europe/London');
  3. include("includes/altisdb.php");
  4.  
  5. $time_one_week = time() - 604800;
  6. $one_week_ago = date("Y-m-d H:i:s",$time_one_week);
  7. $current_date_time = date("Y-m-d H:i:s",time());
  8.  
  9. $distance_select = mysqli_query($con, "SELECT * FROM `playerkills` WHERE `killdate` >= '".$one_week_ago."'
  10. AND `killdate` < '".$current_date_time."'
  11. AND `headdamage` > 0.99
  12. AND `killer` NOT IN ('76561198020431007',
  13. '76561198071959741',
  14. '76561197971109372',
  15. '76561198107990566',
  16. '76561198079919180',
  17. '76561198092645246',
  18. '76561198086053865',
  19. '76561198023409182',
  20. '76561198064300066',
  21. '76561198000639140',
  22. '76561198070122528',
  23. '76561198078970923',
  24. '76561198151054747',
  25. '76561198044329024',
  26. '76561198125906795',
  27. '76561198160590377',
  28. '76561198053949843'
  29. ) ORDER BY `distance` DESC LIMIT 0,5");
  30. echo"<center>";
  31. echo "<h1><b>Longest Headshots</b></h1>";
  32. $counter = 1;
  33. if(mysqli_num_rows($distance_select) > 0){
  34. while($distance_row = mysqli_fetch_object($distance_select)){
  35. $playerid = $distance_row->victim;
  36. $killerid = $distance_row->killer;
  37. $weapon = $distance_row->weapon;
  38. $distance = $distance_row->distance;
  39. $victim_query = mysqli_query($con, "SELECT * FROM `players` WHERE `playerid` = '".$playerid."'");
  40. $victim_fetch = mysqli_fetch_object($victim_query);
  41. $victim_name = $victim_fetch->name;
  42. $killer_query = mysqli_query($con, "SELECT * FROM `players` WHERE `playerid` = '".$killerid."'");
  43. $killer_fetch = mysqli_fetch_object($killer_query);
  44. $killer_name = $killer_fetch->name;
  45. echo $counter.". <b>".$killer_name."</b><br /><font size=\"2\"><img src=\"../img/icons/dead.png\"> ".$victim_name."<br />".number_format($distance)." meters<br />".$weapon."</font><br /><br />";
  46. $counter++;
  47. }
  48. } else {
  49. echo"No headshots yet!";
  50. }
  51. echo"</center>";
  52. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement