";
}
//loot
$query2 = " SELECT * FROM
tbl_loot
WHERE
deleted = 0
AND
member_id = $memberid
AND
pool = $rec_id
ORDER BY
loot_date DESC";
$result2 = mysql_query($query2);
if ($result2) {$number2 = mysql_numrows($result2);} else {$number2=0;}
$dkp_total_spent = 0;
if ($number2!=0){
$o=0;
$bgcolour = "#FFFFFF";
while($o<$number2){
$rec_loot_date = mysql_result($result2,$o,"loot_date");
$rec_item = stripslashes(mysql_result($result2,$o,"description"));
$rec_dkp = mysql_result($result2,$o,"dkp");
$dkp_total_spent = $dkp_total_spent + $rec_dkp;
if ($rec_raid_date !="" && $rec_loot_date != "0000-00-00 00:00:00"){
$dt_elements = explode(" " ,$rec_loot_date);
$date_elements = explode("-" ,$dt_elements[ 0]);
$rec_loot_date = $date_elements[2]."-".$date_elements[1]."-".$date_elements[0];
} else {
$rec_loot_date = " ";
}
echo "
| $rec_loot_date |
$rec_item |
Paid $rec_dkp $rec_name DKP |
";
$o++;
if ($bgcolour == "#FFFFFF"){
$bgcolour = "#F5F5FF";
} else {
$bgcolour = "#FFFFFF";
}
}
echo "
|
|
|
Total $dkp_total_spent $rec_name DKP spent
|
";
}
//Adjustments
if ($rec_deleted == 0){
$query2 = " SELECT * FROM
tbl_mod
INNER JOIN
tbl_mod_dkp on tbl_mod.id = tbl_mod_dkp.mod_id
WHERE
tbl_mod.deleted = 0
AND
tbl_mod.member_id = $memberid
AND
tbl_mod_dkp.pool_id = $rec_id
ORDER BY
award_date DESC";
$result2 = mysql_query($query2);
if ($result2) {$number2 = mysql_numrows($result2);} else {$number2=0;}
$dkp_total_adj = 0;
if ($number2!=0){
$o=0;
while($o<$number2){
$rec_award_date = mysql_result($result2,$o,"award_date");
$rec_type = mysql_result($result2,$o,"tbl_mod.type");
$rec_reason = stripslashes(mysql_result($result2,$o,"tbl_mod.reason"));
$rec_dkp = mysql_result($result2,$o,"tbl_mod_dkp.dkp");
$dkp_total_adj = $dkp_total_adj + $rec_dkp;
if ($rec_award_date !="" && $rec_raid_date != "0000-00-00 00:00:00"){
$dt_elements = explode(" " ,$rec_award_date);
$date_elements = explode("-" ,$dt_elements[ 0]);
$rec_award_date = $date_elements[2]."-".$date_elements[1]."-".$date_elements[0];
} else {
$rec_award_date = " ";
}
echo "
| $rec_award_date |
$rec_type |
$rec_reason |
Adjustment: $rec_dkp $rec_name DKP |
";
$o++;
}
echo "
|
|
|
Total $dkp_total_adj $rec_name DKP Adjustments
|
";
}
$dkp_balance = $dkp_total_earned + $dkp_total_adj - $dkp_total_spent;
if ($dkp_balance >= 0){
$dkp_balance = "Balance $dkp_balance $rec_name DKP";
} else {
$dkp_balance = "Balance $dkp_balance $rec_name DKP";
}
echo"
| |
|
|
$dkp_balance |
";
} else {
$form_icon = "";
}
?>