case '1':
$rafflesystem = JText::_('AUP_COUPON_CODES');
break;
case '0':
default:
$rafflesystem = JText::_('AUP_POINTS');
}
echo $rafflesystem;
?>
</td>
<td align="center">
<?php
if ($row->raffledate == $nullDate) {
echo '-';
} else {
echo JHTML::_('date', $row->raffledate, JText::_('DATE_FORMAT_LC2')) . '<br />' . nicetimeAdm($row->raffledate, 0);
}
?>
</td>
<td align="center">
<?php
if ($row->winner1) {
$db = JFactory::getDBO();
$query = "SELECT u.*, aup.referreid FROM #__users AS u, #__alpha_userpoints AS aup" . "\n WHERE u.id = {$row->winner1} AND u.id = aup.userid";
$db->setQuery($query);
$result = $db->loadObjectList();
if ($result) {
foreach ($result as $winner) {
$linkuser1 = "index.php?option=com_alphauserpoints&task=showdetails&cid={$winner->referreid}&name={$winner->name}";
echo "<a href=\"{$linkuser1}\">";
echo $winner->name;
</strong>
</td>
<td class="title">
<strong><?php
echo JText::_('AUP_POINTS');
?>
</strong>
</td>
</tr>
<?php
foreach ($rowsLA as $rowLA) {
?>
<tr>
<td>
<?php
echo nicetimeAdm($rowLA->insert_date);
?>
</td>
<td>
<?php
echo JText::_($rowLA->rule_name);
?>
</td>
<td>
<?php
$linkLA = "<a href=\"index.php?option=com_alphauserpoints&task=showdetails&cid=" . $rowLA->referreid . "&name=" . htmlspecialchars($rowLA->uname, ENT_QUOTES, 'UTF-8') . "\">";
echo $linkLA . htmlspecialchars($rowLA->uname, ENT_QUOTES, 'UTF-8') . "</a>";
?>
</td>
<td>
