Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Release] Logging Unique Kills on a Scheduled Task (php)

The Best DDoS Protected Servers
Flowlance

Flowlance

Newbie Spellweaver
Joined
Mar 22, 2012
Messages
31
Reaction score
14
Caipi said:
Why dun you insert the textdata_object.txt file into a table and link it through a JOIN statement to the overview ;o so it'll cover all listed Uniques - doesn't matter the amount of new selfmade uniques
Click to expand...

Hmm. Feel like I have more control this way. You might not want to show all uniques
 
serend

serend

Skilled Illusionist
Joined
Mar 12, 2012
Messages
338
Reaction score
27
would you have how to place in table so looks neat please i tried but then just get error :(
 
serend

serend

Skilled Illusionist
Joined
Mar 12, 2012
Messages
338
Reaction score
27
Flowlance - [Release] Logging Unique Kills on a Scheduled Task (php) - RaGEZONE Forums


looks very messy on site how to put into colums/tables ?

or just rls your ranking script from your site ;)
 
Last edited:
Flowlance

Flowlance

Newbie Spellweaver
Joined
Mar 22, 2012
Messages
31
Reaction score
14
Ah. Yeah it's messy, it's just a basic output page, I expect people to modify it to their liking. Hope this helps get you started:

PHP: 
<html>
<head>
<title>Basic unique output page</title>
<style type="text/css">
table {
	border-collapse: collapse;
}

th {
	border: 1px solid #000;
	background: #eee;
}

tr {
	text-align: center;
}

tr:hover {
	background: #e7f0f5;
}

td {
	border: 1px solid #000;
}
</style>
</head>
<body>
<?php 
include("config.php"); 

// Add uniques you want to allow / display in the following array: 
$allowed = array( 
    'MOB_CH_TIGERWOMAN' => 'Tiger Girl', 
    'MOB_OA_URUCHI'     => 'Uruchi', 
    'MOB_KK_ISYUTARU'   => 'Isyutaru', 
    'MOB_TK_BONELORD'   => 'Lord Yarkan', 
    'MOB_EU_KERBEROS'   => 'Cerberus', 
    'MOB_AM_IVY'        => 'Captain Ivy', 
    'MOB_RM_TAHOMET'    => 'Demon Shaitan' 
); 

foreach($allowed as $k => $v) { 
    $uniques = empty($uniques) ? "" : $uniques . ","; 
    $uniques .= "'" . $k . "'"; 
} 

echo "<table cellspacing=0 cellpadding=0 style='width: 300px;'>
<tr><th>#</th><th>Name</th><th>Kills</th></tr>"; 
$counter=1;
$query = $mssql->query("SHARD", "SELECT TOP 15 CharName16, COUNT(*) AS Kills FROM UniqueKills WHERE Monster IN(".$uniques.") GROUP BY CharName16 ORDER BY Kills DESC"); 
while($row=$mssql->fetch($query)) { 
    echo "<tr><td>" . $counter . "</td><td>" . $row['CharName16'] . "</td><td>" . $row['Kills'] . "</td></tr>";
	$counter++;
}
echo "</table>

<br />

<table cellspacing=0 cellpadding=0 style='width: 400px;'>
<tr><th>Name</th><th>Killed</th><th>Time</th></tr>"; 
$query = $mssql->query("SHARD", "SELECT TOP 15 * FROM UniqueKills WHERE Monster IN(".$uniques.") ORDER BY Timestamp DESC"); 
while($row=$mssql->fetch($query)) { 
    echo "<tr><td>" . $row['CharName16'] . "</td><td>" . $allowed[$row['Monster']] . "</td><td>" . date("d-m-Y H:i", $row['Timestamp']) . "</td></tr>"; 
} 
echo "</table>";
?>
</body>
</html>
 
serend

serend

Skilled Illusionist
Joined
Mar 12, 2012
Messages
338
Reaction score
27
nice thnx

do u know whats causing this to display --> 
 
Naty48

Naty48

CPP/C#/PHP/ASM
Joined
Apr 7, 2009
Messages
452
Reaction score
189
Flowlance said:
I can write a class using mssql instead if that makes it easier. i like sqlsrv though, as it is fully supported with all sql server versions and have a lot of neat features. Harder yes.
Afaik mssql does not work with sql server 2008 or 2012 at all
Click to expand...


you wrong my dear friend , im working with SQL'08 and mssql driver = PERFECT.
also tested with SQL'12 with mssql driver = PERFECT.

if you dont know how to setup apache/php correctly that's the cause .

do not misslead people.

anyway , nice release - but i already did something like that but from php cron job.

well , it works flewless and consume Really small amount of well , everything :D
 
You must log in or register to reply here.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
197
Guests online
9,746
Total visitors
9,943
Totals may include hidden visitors.

Forum statistics

Threads
429,114
Messages
4,590,381
Members
280,756
Latest member
vengali
Most visitors online was 10387 , on 26 Apr 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top