$sql99->db_Select_gen($query2);
while ($row99 = $sql99->db_Fetch()) {
$item_count = $row99['count(*)'];
}
$sql99->db_Select_gen($query);
while ($row99 = $sql99->db_Fetch()) {
$item_buyer = $row99["item_buyer"];
$raid_id = $row99["raid_id"];
$raid_name = $row99["raid_name"];
$item_date = $row99["item_date"];
$item_value = $row99["item_value"];
$text .= '
<tr class="row1">
<td width="90" nowrap="nowrap">' . strftime($pref['shortdate'], $item_date) . '</td>
<td width="35%"><a href="view_member.php?n=' . utf8_encode($item_buyer) . '">' . utf8_encode($item_buyer) . '</a></td>';
if (WCMCheckCharAdmin()) {
$text .= '
<td width="65%"><a href="view_raid.php?r=' . $raid_id . '">' . stripslashes($raid_name) . '</a></td>';
} else {
$text .= '
<td width="65%">' . stripslashes($raid_name) . '</td>';
}
$text .= '
<td width="60" nowrap="nowrap" class="negative">' . $item_value . '</td>
</tr>';
}
$text .= '
<tr>
<th colspan="4" class="footer">... found ' . $item_count . ' item(s)</th>
</tr>
if (!defined("e107_INIT")) {
require_once "../../class2.php";
}
require_once HEADERF;
require_once e_PLUGIN . "e107dkp/includes/config.php";
global $pref;
$character = utf8_decode($_GET['n']);
$userID = USERID;
if (!$_GET['n']) {
header("Location: /index.php");
}
if ($pref['wcm_version']) {
require_once e_PLUGIN . "wcm/includes/config.php";
$charID = WCMgetCharInfoByName($character, "char_id");
if (WCMCheckChar($userID, $charID) || WCMCheckCharAdmin()) {
list($thirty, $sixty, $ninty) = DKPraidCount($character);
// give our attendence and points
$text = '
<table width="100%" border="0" cellspacing="1" cellpadding="2">
<tr>
<th align="center" colspan="6" nowrap="nowrap"><u>: ' . utf8_encode($character) . ' :</u></th>
</tr>
<tr>
<td class="row1" width="20%" nowrap="nowrap"><b>Earned</b>: <span class="positive">0.00</span></td>
<td class="row2" width="20%" nowrap="nowrap"><b>Spent</b>: <span class="negative">0.00</span></td>
<td class="row1" width="20%" nowrap="nowrap"><b>Adjustment</b>: <span class="neutral">0.00</span></td>
<td class="row2" width="40%" nowrap="nowrap"><b>Current</b>: <span class="neutral">0.00</span></td>
</tr>
<tr>
