| Code:
|
<?php
if ( !defined('BLOCK_FILE') ) { Header("Location: ../index.php"); die(); }
global $db, $prefix, $admin, $admin_file;
//Block Opts
$module_name = '20 Last Kills';
$killboard_database = 'KB DB ADDRESS HERE'; //Killboard Database Address
$killboard_user = 'DB USERNAME'; // Killboard Database Username
$killboard_password = 'DB PASSWORD'; // Killboard Database Password
$killboard_url = 'http://killboard.mass-alliance.net/?a=kill_detail&kll_id=';
$corpID = 0;
$allianceID = 0;
$maxKills = 20;
//Start Scroll
#$content = "<marquee behavior='scroll' height=200 direction='up' scrollamount='2' scrolldelay='10' onmouseover='this.stop()' onmouseout='this.start()'>";
$content .= '<table class="kb-table" align="center" cellspacing="1" border=1>
<tr class="kb-table-header">
<td class="kb-table-header" align="center">No.</td>
<td class="kb-table-header" colspan="2" align="center">Ship type</td>
<td class="kb-table-header" colspan="3" align="center">Victim</td>
<td class="kb-table-header" colspan="2" align="center">Final blow</td>
<td class="kb-table-header" align="center">System</td>
<td class="kb-table-header" align="center">Time</td>
</tr>';
//Last Kills
$sql = "SELECT distinct kll_id, kll_timestamp FROM `".$killboard_database."`.kb3_kills kll
INNER JOIN `".$killboard_database."`.kb3_inv_crp inc
ON inc.inc_kll_id = kll.kll_id
INNER JOIN `".$killboard_database."`.kb3_inv_all ina
ON ina.ina_kll_id = kll.kll_id";
if ($allianceID > 0){
$sql .= " WHERE ina.ina_all_id = ".$allianceID;
}
if($corpID > 0){
$sql .= " WHERE inc.inc_crp_id = ".$corpID;
}
$sql .= " GROUP BY kll_id ORDER BY kll_timestamp desc limit 0, ".$maxKills.";";
$result = $db->sql_query($sql);
while($row = $db->sql_fetchrow($result)){
$content .= buildKillRow($row[0],$row['kll_timestamp'],$killboard_database,$killboard_url);
}
$content .= "</table>";
#$content .= "</marquee>";
function buildKillRow($killID,$time,$killboard_database,$killboard_url){
global $db, $prefix, $admin, $admin_file;
// ship and shipclass
$sql2 = "select shp_name, shp_externalid , scl_class FROM `".$killboard_database."`.kb3_ships
join `".$killboard_database."`.kb3_ship_classes
on shp_class = scl_id
where shp_id = (select kll.kll_ship_id from `".$killboard_database."`.kb3_kills kll where kll_id = ".$killID.")";
if (mysql_error()) return mysql_error();
$result2 = $db->sql_query($sql2);
$row2 = $db->sql_fetchrow($result2);
// victim / corp / alliance
$sql3 = "select plt_name, crp_name , all_name, plt_externalid FROM `".$killboard_database."`.kb3_kills
join `".$killboard_database."`.kb3_pilots
on plt_id = kll_victim_id
join `".$killboard_database."`.kb3_corps
on crp_id = plt_crp_id
join `".$killboard_database."`.kb3_alliances
on all_id = crp_all_id
where kll_id = ".$killID;
if (mysql_error()) return mysql_error();
$result3 = $db->sql_query($sql3);
$row3 = $db->sql_fetchrow($result3);
$allimage = $row3[2];
if ($row3[2] != 'None'){
$allimage = preg_replace('/[^a-zA-Z0-9]/', '', $allimage);
$allimage = '<img height=32 width=32 src="http://www.eve-kill.net/img/alliances/'.$allimage.'.png">';
}else{
$allimage = " ";
}
//final_blow
$sql4 = "select plt_name, crp_name , all_name, plt_externalid FROM `".$killboard_database."`.kb3_kills
join `".$killboard_database."`.kb3_pilots
on plt_id = kll_fb_plt_id
join `".$killboard_database."`.kb3_corps
on crp_id = kll_fb_crp_id
join `".$killboard_database."`.kb3_alliances
on all_id = kll_fb_all_id
where kll_id = ".$killID;
if (mysql_error()) return mysql_error();
$result4 = $db->sql_query($sql4);
$row4 = $db->sql_fetchrow($result4);
//System
$sql5 = "select sys_name, sys_sec FROM `".$killboard_database."`.kb3_kills
join `".$killboard_database."`.kb3_systems
on sys_id = kll_system_id
where kll_id = ".$killID;
if (mysql_error()) return mysql_error();
$result5 = $db->sql_query($sql5);
$row5 = $db->sql_fetchrow($result5);
return "<tr><td><a href=".$killboard_url.$killID.">#$killID</a></td>
<td width='32'><img src='http://www.go-pdi.com/edk/img/ships/32_32/".$row2[1].".png'></td>
<td><b>".$row2[0]."</b><br>".$row2[2]."</td>
<td><img src='http://www.eve-kill.net/?a=thumb&id=".$row3[3]."&size=32'></td><td><b>".$row3[0]."</b><br>".$row3[1]."</td><td>".$allimage."</td>
<td><img src='http://www.eve-kill.net/?a=thumb&id=".$row4[3]."&size=32'></td><td><b>".$row4[0]."</b><br>".$row4[1]."</td>
<td>".$row5[0]."(".number_format($row5[1],2).")</td>
<td>$time</td>
</tr>";
}
?>
|
38.107.179.216
