* $Date:: $ *
* $Tag:: 0.2.1-FINAL $ *
* $Author:: $ *
- * Needs to be in all Files and every File needs "svn propset *
- * svn:keywords Date Revision" (autoprobset!) at least!!!!!! *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * For more information visit: http://www.mxchange.org *
+ * Copyright (c) 2009 - 2012 by Mailer Developer Team *
+ * For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
// Some security stuff...
if ((!defined('__SECURITY')) || (!isAdmin())) {
die();
-}
+} // END - if
// Add description as navigation point
-addMenuDescription('admin', __FILE__);
+addYouAreHereLink('admin', __FILE__);
-if (isPostRequestParameterSet('del')) {
+if (isFormSent('delete')) {
// Delete entries from tables
- if (countPostSelection() > 0) {
+ if (ifPostContainsSelections()) {
// Init SQLs
initSqls();
// Delete entries...
- foreach (postRequestParameter('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));
+ 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));
} // END - foreach
// Run all SQLs
} // 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` ASC", __FILE__, __LINE__);
+$result = SQL_QUERY('SELECT
+ `userid` AS `from_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) {
+if (!SQL_HASZERONUMS($result)) {
// Output rows
- $OUT = ''; $SW = 2;
+ $OUT = '';
while ($content = SQL_FETCHARRAY($result)) {
// Prepare data for the row template
- $content = array(
- 'sw' => $SW,
- 'trans_id' => $content['trans_id'],
- 'time_trans' => generateDateTime($content['time_trans'], 3),
- 'userid_from' => generateUserProfileLink($content['userid']),
- 'userid_to' => generateUserProfileLink($content['to_userid']),
- 'reason' => $content['reason'],
- 'points' => translateComma($content['points']),
- );
+ $content['time_trans'] = generateDateTime($content['time_trans'], 3);
// Load row template
- $OUT .= loadTemplate('admin_del_transfer_row', true, $content);
+ $OUT .= loadTemplate('admin_delete_transfer_row', TRUE, $content);
// Sum points and switch colors
- $total += $content['points']; $SW = 3 - $SW;
+ $total += $content['points'];
} // END - while
// Free memory
SQL_FREERESULT($result);
} else {
// Nothing for in and out
- $OUT = "<tr>
- <td colspan=\"6\" align=\"center\" class=\"bottom\">
- ".loadTemplate('admin_settings_saved', true, getMessage('TRANSFER_NO_INOUT_TRANSFERS'))."
+ $OUT = '<tr>
+ <td colspan="6" align="center" class="bottom">
+ ' . displayMessage('{--TRANSFER_NO_INOUT_TRANSFERS--}', TRUE) . '
</td>
-</tr>";
+</tr>';
}
// ... and add them to a constant for the template
$content['rows'] = $OUT;
// Remeber total amount
-$content['total'] = translateComma($total);
+$content['total_points'] = $total;
// Set title
-$content['title'] = getMessage('TRANSFER_LIST_ALL');
+$content['title'] = '{--TRANSFER_LIST_ALL--}';
// Show delete button here
-$content['delete'] = '<input type="reset" class="admin_reset" value="{--UNDO_SELECTIONS--}" />
-<input type="submit" name="del" class="admin_delete" value="{--TRANSFER_DELETE--}" />';
+$content['delete'] = '<input type="reset" class="form_reset" value="{--UNDO_SELECTIONS--}" />
+<input type="submit" name="delete" class="form_delete" value="{--ADMIN_DELETE_TRANSFERS_SUBMIT--}" />';
// Load final template
-loadTemplate('admin_list_transfer', false, $content);
+loadTemplate('admin_list_transfer', FALSE, $content);
// [EOF]
?>