* @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
"; } else{ $content .=""; $content .=""; } $content.="

"; $content .="".$eqname.""; if ($total_dkp == 0.00) { $content .= "$total_dkp "; } foreach ($eqdkplist as $meseqdkp){ if ($total_dkp < 0) { $content .= "$total_dkp "; } if ($total_dkp > 0) { $content .= "$total_dkp "; } if ($total_dkp == 0) { $content .= "$total_dkp "; } $content .="

"; } } } ?>