<?php
/************************************************************************
- * MXChange v0.2.1 Start: 10/07/2004 *
+ * Mailer v0.2.1-FINAL Start: 10/07/2004 *
* ================ Last change: 11/25/2004 *
* *
* -------------------------------------------------------------------- *
if (isPostRequestElementSet('del')) {
// Delete entries from tables
- $SEL = countPostSelection();
- if ($SEL > 0) {
+ if (countPostSelection() > 0) {
// Init SQLs
initSqls();
// Delete entries...
foreach (postRequestElement('sel') as $id => $sel) {
- addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_in` WHERE trans_id=%s LIMIT 1",
- array(bigintval($id)), __FILE__, __LINE__, false));
- addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_out` WHERE trans_id=%s LIMIT 1",
- array(bigintval($id)), __FILE__, __LINE__, false));
+ addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_in` WHERE `trans_id`=%s LIMIT 1",
+ array(bigintval($id)), __FILE__, __LINE__, false));
+ addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_transfers_out` WHERE `trans_id`=%s LIMIT 1",
+ array(bigintval($id)), __FILE__, __LINE__, false));
} // END - foreach
// Run all SQLs
runFilterChain('run_sqls');
- }
-}
+ } // END - if
+} // END - if
// We only need outgoing transfers
-$result = SQL_QUERY("SELECT userid, to_userid, trans_id, points, reason, time_trans FROM `{?_MYSQL_PREFIX?}_user_transfers_out` ORDER BY trans_id", __FILE__, __LINE__);
+$result = SQL_QUERY("SELECT `userid`, `to_userid`, `trans_id`, `points`, `reason`, `time_trans` FROM `{?_MYSQL_PREFIX?}_user_transfers_out` ORDER BY `trans_id` ASC", __FILE__, __LINE__);
$total = '0';
if (SQL_NUMROWS($result) > 0) {
// Output rows
$content = array(
'sw' => $SW,
'trans_id' => $content['trans_id'],
- 'stamp' => generateDateTime($content['time_trans'], 3),
+ 'time_trans' => generateDateTime($content['time_trans'], 3),
'userid_from' => generateUserProfileLink($content['userid']),
'userid_to' => generateUserProfileLink($content['to_userid']),
'reason' => $content['reason'],
// Sum points and switch colors
$total += $content['points']; $SW = 3 - $SW;
- }
+ } // END - while
// Free memory
SQL_FREERESULT($result);
} else {
// Nothing for in and out
$OUT = "<tr>
- <td colspan=\"6\" align=\"center\" class=\"bottom2\" height=\"70\">
+ <td colspan=\"6\" align=\"center\" class=\"bottom\">
".loadTemplate('admin_settings_saved', true, getMessage('TRANSFER_NO_INOUT_TRANSFERS'))."
</td>
</tr>";