Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- date_default_timezone_set('Europe/London');
- include("includes/altisdb.php");
- $time_one_week = time() - 604800;
- $one_week_ago = date("Y-m-d H:i:s",$time_one_week);
- $current_date_time = date("Y-m-d H:i:s",time());
- $distance_select = mysqli_query($con, "SELECT * FROM `playerkills` WHERE `killdate` >= '".$one_week_ago."'
- AND `killdate` < '".$current_date_time."'
- AND `headdamage` > 0.99
- AND `killer` NOT IN ('76561198020431007',
- '76561198071959741',
- '76561197971109372',
- '76561198107990566',
- '76561198079919180',
- '76561198092645246',
- '76561198086053865',
- '76561198023409182',
- '76561198064300066',
- '76561198000639140',
- '76561198070122528',
- '76561198078970923',
- '76561198151054747',
- '76561198044329024',
- '76561198125906795',
- '76561198160590377',
- '76561198053949843'
- ) ORDER BY `distance` DESC LIMIT 0,5");
- echo"<center>";
- echo "<h1><b>Longest Headshots</b></h1>";
- $counter = 1;
- if(mysqli_num_rows($distance_select) > 0){
- while($distance_row = mysqli_fetch_object($distance_select)){
- $playerid = $distance_row->victim;
- $killerid = $distance_row->killer;
- $weapon = $distance_row->weapon;
- $distance = $distance_row->distance;
- $victim_query = mysqli_query($con, "SELECT * FROM `players` WHERE `playerid` = '".$playerid."'");
- $victim_fetch = mysqli_fetch_object($victim_query);
- $victim_name = $victim_fetch->name;
- $killer_query = mysqli_query($con, "SELECT * FROM `players` WHERE `playerid` = '".$killerid."'");
- $killer_fetch = mysqli_fetch_object($killer_query);
- $killer_name = $killer_fetch->name;
- 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 />";
- $counter++;
- }
- } else {
- echo"No headshots yet!";
- }
- echo"</center>";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement