Mine

<?php
/**
* Joomla Your DKP Module
*
* @version 1.1
* @copyright (C) 2006 by Thumann <Brianm@thumann.dk>
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
* Mambo is Free Software
*
* Credits to: The loveable dev team of wowroster
* And special shout outs to my trousted mentor, The crazy Aussie! ;>
*/
 
defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );
 
$newdb = new database( $host='myhost', 'myuser', 'mypass', $db='mydb', $table_prefix='', $goOffline=true );
 
//start added by thumann
 
global $ueConfig, $my, $mosConfig_lang, $mosConfig_absolute_path, $mosConfig_live_site;
 
        $more_dkp  = intval( $params->get( 'what_moredkp' ) );
        $dkp_number1 = $params->get( 'dkp_number1' );
        $dkp_number2 =   $params->get( 'dkp_number2' );
        $dkp_number3 =   $params->get( 'dkp_number3' );
        $dkp_number4 =    $params->get( 'dkp_number4' );
        
        if ($more_dkp == 1){
        $dkp_count = intval( $params->get( 'dkp_number' ) );
        $dkp_nr    = array($dkp_number1, $dkp_number2, $dkp_number3, $dkp_number4);
        $dkp_url    = array(
     $params->get( 'dkp_url1' ), 
           $params->get( 'dkp_url2' ),
           $params->get( 'dkp_url3' ),
           $params->get( 'dkp_url4' ),
           );
           
        }else{
      $dkp_nr    = array($dkp_number1);
      $dkp_url   = array("eqdkp/");
      $dkp_count = 1;
     }
$username = $my->username;
if(empty($username)){
   echo "Login to see your DKP";
} else {
        $content ="";
        for ($i = 0; $i < $dkp_count; $i++) {
                $newdb->setQuery("SELECT member_earned, member_spent, member_adjustment FROM ".$dkp_nr[$i]."members"
                . "\n WHERE member_name='$username'");
                $dbArray = $newdb->loadAssocList();
                $dbArray = $dbArray[0];
                $total_dkp = $dbArray['member_earned']-$dbArray['member_spent']+$dbArray['member_adjustment'];
                $total_dkp = number_format($total_dkp, 2, '.', '');
                $eqdkplist = $newdb->loadObjectList();
                $newdb->setQuery("SELECT config_value FROM `".$dkp_nr[$i]."config` where config_name = 'main_title'");
                $eqname = $newdb->loadResult();
                if(empty($eqdkplist)){
                echo "No Data found <br>";
                }
                else{
                        $content .="<table cellpadding=\"1\" border=\"0\">";
                        $content .="<tr><td>";
                        $content .="<center><b>".$eqname."</b></center>";
                        if ($total_dkp == 0.00) {
                                $content .= "<span style=\"color: #dddddd;\">$total_dkp</span><br>";
                        }
                        
                        foreach ($eqdkplist as $meseqdkp){
                                if ($total_dkp < 0) {
                                        $content .= "<span style=\"color: #d11719;\">$total_dkp</span><br>";
                                }
                                if ($total_dkp > 0) {
                                        $content .= "<span style=\"color: #0ae11e;\">$total_dkp</span><br>";
                                }
                                if ($total_dkp == 0) {
                                        $content .= "<span style=\"color: #dddddd;\">$total_dkp</span><br>";
                                }
                                $content .="</td></tr>";
                        }
                        $content.="</table>";
                }
        }
}
?>