Latest Loots is a rather simple addon that fetches the last 20 loots, number can be changed, from eqdkp.

It's currently in version 1.1, so don't expect to much!

English and German version.

Demo (3 database version though)

Check README file for instructions.

Requirements:
Eqdkp, A working and configured eqdkp installtion
Itemstats, A working itemstats 'installation', info can be found in README

That's all i think

Give it a twirl and let me know what you think..

DOWNLOAD


Version history:

v.1.1:
* Now with multidatabase support (eqdkp_config.php)
* Moved the css file from itemstats to default.css
* Latest loot is now sorted by date instead of ID

v.1.0:
* The first release of latestloot
* Single database support


Regs. Thumann

very nice work. can you also post the other 2 eqdkp pages?

Thanks
Joe

http://www.wowroster.net/index.php?name ... opic&t=173

it's the old 1.6 version..

Thumann can be the EQDKP tables in another database ?

A primary try to do it with different DB

Code: Select all

<?php
#--[ EQDKP CONFIG ]--------------------------------------------------------    
    $addon_conf['eqdkp']['db_user2'] = 'user';            // MYSQL Database Username
    $addon_conf['eqdkp']['db_passwd2'] = 'password';        // MYSQL Database Password
    $addon_conf['eqdkp']['db_name2'] = 'dbname';        // MYSQL Database Name
    $addon_conf['eqdkp']['db_host2'] = 'localhost';        // MYSQL Server Address (localhost if the database is on the same machine)
      $addon_conf['eqdkp']['eqdkp_prefix'] = 'eqdkp_';        // MYSQL Database Table prefix for EQDKP tables. (Must match EQDKP setup)
      
// Connect DB
$link = mysql_connect($addon_conf['eqdkp']['db_host2'], $addon_conf['eqdkp']['db_user2'], $addon_conf['eqdkp']['db_passwd2']) or die($_SERVER['PHP_SELF'].":".__LINE__." "."Could not connect");
mysql_select_db($addon_conf['eqdkp']['db_name2']) or die($_SERVER['PHP_SELF'].":".__LINE__." "."Could not select DB");

//Get Main title from eqdkp
$query = "SELECT config_value FROM ".$addon_conf['eqdkp']['eqdkp_prefix']."config WHERE config_name = 'main_title'";
$result = mysql_query($query) or die(mysql_error());
if ($row = mysql_fetch_array($result))
{
    $eqname = $row[0];
}
mysql_free_result($result);

//Get total drops from eqdkp
$query = "select count(*) from ".$addon_conf['eqdkp']['eqdkp_prefix']."items";
$result = mysql_query($query) or die(mysql_error());
if ($row = mysql_fetch_array($result))
{
    $total_drops = $row[0];
}
mysql_free_result($result);
if ($roster_conf['sqldebug'])
{
    print "<!-- $query -->\n";
}

$query = "SELECT `item_name`, `item_buyer` FROM `".$addon_conf['eqdkp']['eqdkp_prefix']."items` ORDER BY item_date DESC limit 20";
if ($roster_conf['sqldebug'])
{
    print "<!-- $query -->\n";
}
echo border('syellow','start');
echo '<table cellpadding="0" cellspacing="0"> ';
echo '<tr>';
echo '<tr><td class="membersHeader">'.$eqname.'</td></tr>';
$result = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_array($result)) {
$last_mc_loot = $row[item_name];
$buyer = $row[item_buyer];

$myhtml = "[item]".$last_mc_loot."[/item] ".'<span class="by-text">'.$wordings[$roster_conf['roster_lang']]['by'].'</span>'." ".'<a href="char.php?name='.urlencode($buyer).'&server='.$roster_conf['server_name'].'">'.utf8_encode($buyer).'</a>'. "";

echo itemstats_parse('<tr><td class="membersHeader">'.$myhtml.'</td></tr>');
}
echo '<tr><td class="membersHeader">'.$wordings[$roster_conf['roster_lang']]['TotalDrops'].': '.$total_drops.'</td></tr>';
echo '</tr>';
echo '</table>';
echo border('syellow','end');
mysql_free_result($result);
$link = $roster_dblink;
if( !$link )
{
    die(basename(__FILE__).': line['.(__LINE__).']<br />'.'User "'.$db_user.'" could not connect to database "'.$db_name.'" on host "'.$db_host.'"<br />MySQL said:<br />'.$wowdb->error());
}

?>

aye... from the old eqdkp addon..

it will be implemented in v. 1.1

And its better use item_date than item_id because any edited item get a new id and can't be a new loot only a mistake o error, date its from loot not from edit.

yup v1.0 is currently useless for me simply because eqdkp has it's own db(s), but it looks really nice on your site though.

hakker use my modification to use different db

New version available for download

Thanks subxero for your support btw

great addon

What I am trying to do is integrate it into a joomla module so those 20 items are shown in the sidebar. But I havent figured out how.

Did anyone ever try this?

yes.. that's no problem.. i've even made a joomla module for it..

i guess you wan't that..

well I wouldnt mind at all :p Did you release it to the public at all?

No, i didn't.. but here it is

Loot History Module

When the download is authorized that is.. hehe

I made a few changes to it.. i moved all the configuration into joomla (module configuration) instead of having it in the php files.. that should make configuration alot easier.. hehe

it also features having eqdkp tables in another database..

Have fun.. and report bugs.. though do it in the integration forum.. i'll create a new topic..

thanks a lot, its much much appreciated!