About Boss Timer

getMessage()); } echo ''; @$time = date("Y-m-d H:i:s.000"); // add here more bosses, just the MobID. @$bosses = array(1 => '2480', '2481', '2482', '2483', '835', '1259', '2472', '2785', '2803', '2821', '2839', '3050'); foreach ($bosses as $key => $value) { $query = $conn->prepare ("SELECT TOP 1 [MobName], [CharName], [ActionTime] FROM PS_GameLog.dbo.Boss_Death_Log WHERE MobID= ? ORDER BY ActionTime DESC"); $query->bindValue(1, $value, PDO::PARAM_INT); $query->execute(); $boss = $query->fetch(PDO::FETCH_NUM); if ($boss[0] != NULL){ // WHEN YOU ADD A MOB REMEMBER TO ADD THE TIME switch ($value){ case 2480: $hours = 3; break; case 2481: $hours = 3; break; case 2482: $hours = 3; break; case 2483: $hours = 2; break; case 835: $hours = 3; break; case 1259: $hours = 3; break; case 2472: $hours = 7; break; case 2785: $hours = -2; break; case 2803: $hours = -2; break; case 2821: $hours = -2; break; case 2839: $hours = -2; break; case 3050: $hours = 72; break; } @$nextTime = date("Y-m-d H:i:s", strtotime($boss[2].'+'.$hours.' hours')); if ($nextTime < $time){ $time_Result = 'In Spawn Time'; } else { $newTime = strtotime($nextTime); $time1 = strtotime($time); $countdown = $newTime - $time1; $days_left = gmdate("d", $countdown); $hours_left = gmdate("H", $countdown); $min_left = gmdate("i", $countdown); $sec_left = gmdate("s", $countdown); $daysstr = "d"; if ($days_left != "1"){ $daysstr = "d"; }else{ $daysstr = ""; $days_left = ""; } $hstr = "h"; if ($hours_left != "1"){ $hstr = "h"; } $mstr = "m"; if ($min_left != "1"){ $mstr = "m"; } $sstr = "s"; if ($sec_left != "1"){ $sstr = "s"; } $time_Result = ''.$days_left.' '.$daysstr.' '.$hours_left.' '.$hstr.' '.$min_left.' '.$mstr.' '.$sec_left.' '.$sstr.' '; } echo ' '; } } echo '
Boss Name Killed by Next Respawn in
'.$boss[0].' '.$boss[1].' '.$time_Result.'
'; ?>

<?php

// Connect to server with Shaiya credentials using PDO
$sqlUser = 'Shaiya'; // YOUR SHAIYA ACCOUNT NAME
$sqlPass = 'Shaiya123'; // YOUR SHAIYA ACCOUNT PASSWORD
$database = 'PS_UserData';

try {
$conn = new PDO("sqlsrv:Server=127.0.0.1;Database=$database", $sqlUser, $sqlPass);
}
catch (PDOException $e){
die($e->getMessage());
}

echo '<table width="300">
<tr class="boss-record">
<th class="boss-record">Boss Name</th>
<th class="boss-record">Killed by</th>
<th class="boss-record">Next Respawn in</th>
</tr>';

@$time = date("Y-m-d H:i:s.000");

// add here more bosses, just the MobID.
@$bosses = array(1 => '2480', '2481', '2482', '2483', '835', '1259', '2472', '2785', '2803', '2821', '2839', '3050');

foreach ($bosses as $key => $value) {
$query = $conn->prepare ("SELECT TOP 1 [MobName], [CharName], [ActionTime] FROM PS_GameLog.dbo.Boss_Death_Log WHERE MobID= ? ORDER BY ActionTime DESC");
$query->bindValue(1, $value, PDO::PARAM_INT);
$query->execute();
$boss = $query->fetch(PDO::FETCH_NUM);

if ($boss[0] != NULL){

// WHEN YOU ADD A MOB REMEMBER TO ADD THE TIME
switch ($value){
case 2480: $hours = 3; break;
case 2481: $hours = 3; break;
case 2482: $hours = 3; break;
case 2483: $hours = 2; break;
case 835: $hours = 3; break;
case 1259: $hours = 3; break;
case 2472: $hours = 7; break;
case 2785: $hours = -2; break;
case 2803: $hours = -2; break;
case 2821: $hours = -2; break;
case 2839: $hours = -2; break;
case 3050: $hours = 72; break;

}
@$nextTime = date("Y-m-d H:i:s", strtotime($boss[2].'+'.$hours.' hours'));

if ($nextTime < $time){
$time_Result = '<span style="color:green; margin: 3px;">In Spawn Time</span>';
} else {

$newTime = strtotime($nextTime);
$time1 = strtotime($time);

$countdown = $newTime - $time1;
$days_left = gmdate("d", $countdown);
$hours_left = gmdate("H", $countdown);
$min_left = gmdate("i", $countdown);
$sec_left = gmdate("s", $countdown);

$daysstr = "d";
if ($days_left != "1"){
$daysstr = "d";
}else{
$daysstr = "";
$days_left = "";
}
$hstr = "h";
if ($hours_left != "1"){
$hstr = "h";
}
$mstr = "m";
if ($min_left != "1"){
$mstr = "m";
}
$sstr = "s";
if ($sec_left != "1"){
$sstr = "s";
}

$time_Result = ''.$days_left.' '.$daysstr.' '.$hours_left.' '.$hstr.' '.$min_left.' '.$mstr.' '.$sec_left.' '.$sstr.' '; } echo ' ';
}
}
echo '
<tr>
<td>'.$boss[0].'</td>
<td>'.$boss[1].'</td>
<td>'.$time_Result.'</td>
</tr>';
?>