Unnamed

<?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.' );

$database2 = new database ( 'host', 'user', 'pass', 'database_you_want','' , false);

//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++) {
		$database2->setQuery("SELECT member_earned, member_spent, member_adjustment FROM ".$dkp_nr[$i]."members"
		. "\n WHERE member_name='$username'");
		$dbArray = $database2->loadAssocList();
		$dbArray = $dbArray[0];
		$total_dkp = $dbArray['member_earned']-$dbArray['member_spent']+$dbArray['member_adjustment'];
		$total_dkp = number_format($total_dkp, 2, '.', '');
		$eqdkplist = $database2->loadObjectList();
		$database2->setQuery("SELECT config_value FROM `".$dkp_nr[$i]."config` where config_name = 'main_title'");
		$eqname = $database2->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>";
		}
	}
}
?>