About Boss Timer

[PH]KEO(DEV) · 04/05/2018, 14:08

who have Boss timer php scripts?
please share me thanks

~~AnimuNazi~~ · 04/05/2018, 23:44

Try this

[PH]KEO(DEV) · 04/06/2018, 04:01

Quote:

Originally Posted by AnimuNazi

Try this

Spoiler

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<style type="text/css">
html, body {height:100%; margin:0; padding:0;}
#page-background {position:fixed; top:0; left:0; width:100%; height:100%;}
#content {position:relative; z-index:1; padding:10px;}
body,td,th {
color: #000;
}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000">
<div id="page-background"><img src="pic/i5.png" width="1920" height="1200" alt=""></div>
<div id="content">
<?php
function mssql_escape_string($data) {
if(!isset($data) or empty($data)) return '';
if(is_numeric($data)) return $data;
$non_displayables = array(
'/%0[0-8bcef]/', // url encoded 00-08, 11, 12, 14, 15
'/%1[0-9a-f]/', // url encoded 16-31
'/[\x00-\x08]/', // 00-08
'/\x0b/', // 11
'/\x0c/', // 12
'/[\x0e-\x1f]/' // 14-31
);
foreach($non_displayables as $regex)
$data = preg_replace($regex,'',$data);
$data = str_replace("'","''",$data);
return $data;
}

$host = '127.0.0.1';
$dbuser = 'USER_DB'; // put here your DB login
$dbpass = 'Password DB'; // put here your password DB
$database = 'PS_GameLog';
$conn = @c_connect("Driver={SQL Server};Server=$host;Database=$database", $dbuser, $dbpass) or die("Database Connection Error!");
$res = odbc_exec($conn, "SELECT [Text1], [Text2], [Text3], [MapID], [ActionTime] FROM ActionLog WHERE [ActionType]='173' AND [Text2]='death'order by ActionTime desc");
$detail=odbc_fetch_array($res);
if (odbc_num_rows($res)==0);
else{
echo "<center>Boss records
<table cellspacing=1 cellpadding=2 border=1 style=\"border-style:hidden;\">
<tr>
<th>Who killed</th>
<th>Boss Name</th>
<th>Death Time</th>
<th>Map ID</th
</tr>";
while($row = odbc_fetch_array($res))
{
echo "<tr>";
echo "<td>". $row['Text3'] ."</td><td>". $row['Text1'] ."</td><td>". $row['ActionTime'] ."</td><td>". $row['MapID'] ."</td>";
echo "</tr>";
}
echo "</table></center>";
}
?>

hi thanks for this but i already have this
i realy want like this

Spoiler

XareL · 04/06/2018, 14:12

Try This Script same u meaning script ;

Spoiler

[PH]KEO(DEV) · 04/06/2018, 14:17

Quote:

Originally Posted by XareL

Try This Script same u meaning script ;

Spoiler

<style>
/* Tables */
table{border-collapse:collapse;padding:0;margin:0 auto;border:solid 1px #e87308;}
td{border:solid 1px #e87308; padding:0.5px; vertical-align:middle; font-size:11.3px; }
td .form-item{margin:5px 0;}
table th{font-size:11.5px;font-weight:bold;text-align:left;padding:7px 2px;
border:solid 1px #e87308;
font-family:Tahoma, Geneva;

background-image:-webkit-gradient(linear, 0% 0%, 0% 100%, from(#2E2E2E), to(#1D1D1D));
filter:ProgidXImageTransform.Microsoft.gradient( startColorstr=#2E2E2E,endColorstr=#1D1D1D)}
border{color:red;}
</style>

<?
// Connect to MSSQL 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 = '<span style="colorrange; margin: 3px; ">'.$days_left.' '.$daysstr.' '.$hours_left.' '.$hstr.' '.$min_left.' '.$mstr.' '.$sec_left.' '.$sstr.' </span>';
}

echo '
<tr>
<td>'.$boss[0].'</td>
<td>'.$boss[1].'</td>
<td>'.$time_Result.'</td>
</tr>';
}
}
echo '</table>';

?>

nice thanks sir

pardilias · 04/08/2018, 20:18

hello

error
could not find driver
extension is good for temp

[GM]SkyLine.™ · 04/08/2018, 21:18

Quote:

Originally Posted by pardilias

hello

error
could not find driver
extension is good for temp

its not pdo mysql,its pdo sqlsrv.

~~[DEV]Wan~~ · 04/08/2018, 21:28

Quote:

Originally Posted by XareL

Try This Script same u meaning script ;

Spoiler

<style>
/* Tables */
table{border-collapse:collapse;padding:0;margin:0 auto;border:solid 1px #e87308;}
td{border:solid 1px #e87308; padding:0.5px; vertical-align:middle; font-size:11.3px; }
td .form-item{margin:5px 0;}
table th{font-size:11.5px;font-weight:bold;text-align:left;padding:7px 2px;
border:solid 1px #e87308;
font-family:Tahoma, Geneva;

background-image:-webkit-gradient(linear, 0% 0%, 0% 100%, from(#2E2E2E), to(#1D1D1D));
filter:ProgidXImageTransform.Microsoft.gradient( startColorstr=#2E2E2E,endColorstr=#1D1D1D)}
border{color:red;}
</style>

<?
// Connect to MSSQL 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 = '<span style="colorrange; margin: 3px; ">'.$days_left.' '.$daysstr.' '.$hours_left.' '.$hstr.' '.$min_left.' '.$mstr.' '.$sec_left.' '.$sstr.' </span>';
}

echo '
<tr>
<td>'.$boss[0].'</td>
<td>'.$boss[1].'</td>
<td>'.$time_Result.'</td>
</tr>';
}
}
echo '</table>';

?>

hi bro I want ask with u in skype my name is [DEV]Wan

pardilias · 04/08/2018, 23:18

hello

Quote:

Originally Posted by [GM]SkyLine.™

its not pdo mysql,its pdo sqlsrv.

I do not have them in the extension list

[GM]SkyLine.™ · 04/09/2018, 00:05

Quote:

Originally Posted by pardilias

hello

I do not have them in the extension list

What is your php version and what app you use ?

pardilias · 04/09/2018, 01:06

Quote:

Originally Posted by [GM]SkyLine.™

What is your php version and what app you use ?

I was on xampp I'm testing IIS

[GM]SkyLine.™ · 04/09/2018, 01:11

Check your php version and download compatible sqlsrv driver for your php version.

pardilias · 04/09/2018, 01:48

Quote:

Originally Posted by [GM]SkyLine.™

Check your php version and download compatible sqlsrv driver for your php version.

now I have blank page on IIS

extension_dir="C:\Program Files\iis express\PHP\v7.0

microsoft driver x64 for php v7.0 for sql server in IISExpress

windows cache extention 1.3 for php 5.3 dans IISExpress

[GM]SkyLine.™ · 04/09/2018, 02:09

Quote:

Originally Posted by pardilias

now I have blank page on IIS

extension_dir="C:\Program Files\iis express\PHP\v7.0

microsoft driver x64 for php v7.0 for sql server in IISExpress

windows cache extention 1.3 for php 5.3 dans IISExpress

Dear pardilias,

I found topic on forum,please check here =>

pardilias · 04/09/2018, 03:55

Quote:

Originally Posted by [GM]SkyLine.™

Dear pardilias,

I found topic on forum,please check here =>

thank you very much