/trunk/MorgDKP/plugins/morgdkp
$pools = array(); |
$eventlist = FetchAllEvents($dbname, $table_prefix); |
$aliaslist = FetchAliasSimple($dbname, $table_prefix); |
$resultmulti = mysql_query("SHOW TABLES FROM $dbname LIKE '" . $table_prefix . "plus_config'"); |
$eqdkpplus = mysql_fetch_array($resultmulti); |
if ($eqdkpplus[0]) { |
$result = mysql_query("SELECT * FROM " . $table_prefix . 'multidkp'); |
if ($result) { |
$eqdkpplus = mysql_query("SELECT * FROM " . $table_prefix . "plus_config WHERE config_name = 'pk_multidkp'"); |
if ($eqdkpplus) { |
$multipool = mysql_fetch_array($eqdkpplus); |
$singlepool = 0; |
if ($multipool['config_value'] == 1) { |
$result = mysql_query("SELECT * FROM " . $table_prefix . 'multidkp'); |
while ($row = mysql_fetch_array($result)) { |
$pools[$row['multidkp_id']] = $row['multidkp_name']; |
} |
'value'=>$eventlist[$row['multidkp2event_eventname']]['event_value']); |
} |
} else { |
$pools[1] = $DBName[1] or "DKP"; |
$events[1] = $DBName[1] or "DKP"; |
if (!$DBName[1]) $DBName[1] = "DKP"; |
$pools[1] = $DBName[1]; |
$events[1] = $DBName[1]; |
$singlepool = true; |
} |
$offset += count($pools) - 1; |
foreach ($pools as $pluspoolnum => $poolname) { |
$earnedresult = mysql_query($sql); |
$earned = 0; |
while ($earnedrow = mysql_fetch_array($earnedresult)) { |
if ($events[$earnedrow['raid_name']]['pool'] == $poolname) $earned += $earnedrow[1]; |
if ($singlepool or $events[$earnedrow['raid_name']]['pool'] == $poolname) $earned += $earnedrow[1]; |
} |
$sql = "SELECT ". $table_prefix . 'raids' . ".raid_name, SUM(". $table_prefix . 'items' .".item_value) FROM " . |
$table_prefix . 'items' . " LEFT JOIN " . $table_prefix . 'raids' . " ON " . $table_prefix . 'items' . ".raid_id=" . |
$spentresult = mysql_query($sql); |
$spent = 0; |
while ($spentrow = mysql_fetch_array($spentresult)) { |
if ($events[$spentrow['raid_name']]['pool'] == $poolname) $spent += $spentrow[1]; |
if ($singlepool or $events[$spentrow['raid_name']]['pool'] == $poolname) $spent += $spentrow[1]; |
} |
$adjust = 0; |
$sql = "SELECT adjustment_reason, adjustment_value, raid_name FROM " . $table_prefix . 'adjustments' . |
" WHERE member_name = '" . $member . "';"; |
$adjresult = mysql_query($sql); |
while ($adjrow = mysql_fetch_array($adjresult)) { |
if ($events[$adjrow['raid_name']]['pool'] == $poolname) $adjust += $adjrow['adjustment_value']; |
if ($singlepool or $events[$adjrow['raid_name']]['pool'] == $poolname) $adjust += $adjrow['adjustment_value']; |
} |
$balance = $earned - $spent + $adjust; |
$added = 0; |
<form method="post"> |
<input type="hidden" name="retrieve" value="1"> |
<h1><a href="<?php echo $admin_path?>" target="_self" style="color: #FDFDFD;">Return to eqDKP Admin</a></h1> |
<b><u>MorgDKP Export</b></u> |
<b><u>MorgDKP Export v2.0</b></u> |
<br> |
<br> |
<?php if ($php_version > 5) {?> |