- $OUT = ""; $SW = 2;
- $result = SQL_QUERY("SELECT party_uid, trans_id, points, reason, time_trans, trans_type FROM "._MYSQL_PREFIX."_transfers_tmp ORDER BY time_trans DESC", __FILE__, __LINE__);
- while(list($uid, $idx, $points, $reason, $stamp, $type) = SQL_FETCHROW($result))
- {
- if ($type == "OUT") $points = "-$points";
- $OUT .= "<TR>
- <TD class=\"transfer_row1 switch_sw".$SW." bottom2 right2\">
- <FONT class=\"transfer_row1\">".$idx."</FONT>
- </TD>
- <TD class=\"transfer_row2 switch_sw".$SW." bottom2 right2\">
- <FONT class=\"transfer_row2\">".MAKE_DATETIME($stamp, "3")."</FONT>
- </TD>
- <TD class=\"transfer_row3 switch_sw".$SW." bottom2 right2\">
- <FONT class=\"transfer_row3\">".$uid."</FONT>
- </TD>
- <TD class=\"transfer_row4 switch_sw".$SW." bottom2 right2\">
- <FONT class=\"transfer_row4\">".$reason."</FONT>
- </TD>
- <TD class=\"transfer_row5 switch_sw".$SW." bottom2\">
- <FONT class=\"transfer_row5\">".$points."</FONT>
- </TD>
-</TR>\n";
- $total += $points;
+ $OUT = ''; $SW = 2;
+ while ($content = SQL_FETCHARRAY($result)) {
+ // Rewrite points
+ if ($content['trans_type'] == "OUT") $content['points'] = '-'.$content['points']."";
+
+ // Prepare content for template
+ $content['sw'] = $SW;
+ $content['time'] = generateDateTime($content['time_trans'], "3");
+ $content['points'] = translateComma($content['points']);
+
+ // Load row template
+ $OUT .= LOAD_TEMPLATE("member_transfer_row", true, $content);
+
+ // Add points and switch color
+ $total += $content['points'];