Recent Loot

[tiburon]

I would kill for a php module that would pull recent loots from raids for the frontpage of my website. Has anyone managed to do this? If so please share

[kc8pnd]

This is super easy to do with just a few lines of php hehe.

This is a sample I made up for our website. I use the same code in a php block.
Stand alone: http://www.wizardscouncil.net/Recent.php
Example using that code and the include from wowhead (http://www.wowhead.com/?powered).
http://wizardscouncil.net/site/index.php?page=31

Code:

$username = "";
$password = "";
$hostname = "localhost";
$database =  "";
$link = mysql_connect($hostname, $username, $password);
if (!$link) {
    die('Could not connect: ' . mysql_error());
}

$db_found = mysql_select_db($database, $link);

if ($db_found) {

$SQL = " SELECT * FROM `dkp_itemcache`LIMIT 0 , 10";
$result = mysql_query($SQL);

while ($db_field = mysql_fetch_assoc($result)) {
print "<a href='" . $db_field['link'] . "'>" . $db_field['name'] .  "</a><BR>";
}
mysql_close($link);
}
else {
mysql_close($link);
}
mysql_close($link);

Just input the info with your webdkp database information then you should be good to go!

[tiburon]

ZOMG I LOVE YOU!!! WOOT THANK YOU SO MUCH!!!


Is there a way to list it so it will show who got the loot?
Like [Loot] to Membername

[tiburon]

Ok next issue..I put this on and anytime i look at the loottable it fills the list up with loot from the loottable..not the list from the awards...can you please help me here?