X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=0.2.1%2Finc%2Fmodules%2Fadmin%2Fwhat-del_transfer.php;h=27ace76a17cb7358e9ba9132f45761b1487e6be1;hb=7bc25dd08431c94ce9edca131d56c1a36b13c28a;hp=0d1dc80afce2c92a9445fdedc8dc9684c1c43416;hpb=157ee010917df5ca07e6d31b42f67417b2516d74;p=mailer.git diff --git a/0.2.1/inc/modules/admin/what-del_transfer.php b/0.2.1/inc/modules/admin/what-del_transfer.php index 0d1dc80afc..27ace76a17 100644 --- a/0.2.1/inc/modules/admin/what-del_transfer.php +++ b/0.2.1/inc/modules/admin/what-del_transfer.php @@ -1,117 +1,117 @@ - 0) - { - // Delete entries... - foreach ($_POST['sel'] as $id=>$sel) - { - $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_transfers_in WHERE trans_id=%d LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_transfers_out WHERE trans_id=%d LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - } - } -} - -// We only need outgoing transfers -$result = SQL_QUERY("SELECT userid, to_uid, trans_id, points, reason, time_trans FROM "._MYSQL_PREFIX."_user_transfers_out ORDER BY trans_id", __FILE__, __LINE__); -$total = "0"; -if (SQL_NUMROWS($result) > 0) -{ - // Output rows - $OUT = ""; $SW = 2; - while(list($uid1, $uid2, $idx, $points, $reason, $stamp) = SQL_FETCHROW($result)) - { - // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'idx' => $idx, - 'stamp' => MAKE_DATETIME($stamp, "3"), - 'uid_from' => ADMIN_USER_PROFILE_LINK($uid1), - 'uid_to' => ADMIN_USER_PROFILE_LINK($uid1), - 'reason' => $reason, - 'points' => TRANSLATE_COMMA($points), - ); - - // Load row template - $OUT .= LOAD_TEMPLATE("admin_del_transfer_row", true, $content); - - // Sum points and switch colors - $total += $points; $SW = 3 - $SW; - } - - // Free memory - SQL_FREERESULT($result); -} - else -{ - // Nothing for in and out - $OUT = " - - ".LOAD_TEMPLATE("admin_settings_saved", true, TRANSFER_NO_INOUT_TRANSFERS)." - -"; -} - -// ... and add them to a constant for the template -define('__TRANSFER_ROWS', $OUT); - -// Remeber total amount -define('__TRANSFER_TOTAL_VALUE', $total); - -// Set title -define('__TRANSFER_TITLE', TRANSFER_LIST_ALL); - -// Show delete button here -define('__TRANSFER_DELETE', " * "); - -// Load final template -LOAD_TEMPLATE("admin_list_transfer"); - -// -?> + 0) + { + // Delete entries... + foreach ($_POST['sel'] as $id=>$sel) + { + $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_transfers_in WHERE trans_id=%d LIMIT 1", + array(bigintval($id)), __FILE__, __LINE__); + $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_transfers_out WHERE trans_id=%d LIMIT 1", + array(bigintval($id)), __FILE__, __LINE__); + } + } +} + +// We only need outgoing transfers +$result = SQL_QUERY("SELECT userid, to_uid, trans_id, points, reason, time_trans FROM "._MYSQL_PREFIX."_user_transfers_out ORDER BY trans_id", __FILE__, __LINE__); +$total = "0"; +if (SQL_NUMROWS($result) > 0) +{ + // Output rows + $OUT = ""; $SW = 2; + while(list($uid1, $uid2, $idx, $points, $reason, $stamp) = SQL_FETCHROW($result)) + { + // Prepare data for the row template + $content = array( + 'sw' => $SW, + 'idx' => $idx, + 'stamp' => MAKE_DATETIME($stamp, "3"), + 'uid_from' => ADMIN_USER_PROFILE_LINK($uid1), + 'uid_to' => ADMIN_USER_PROFILE_LINK($uid1), + 'reason' => $reason, + 'points' => TRANSLATE_COMMA($points), + ); + + // Load row template + $OUT .= LOAD_TEMPLATE("admin_del_transfer_row", true, $content); + + // Sum points and switch colors + $total += $points; $SW = 3 - $SW; + } + + // Free memory + SQL_FREERESULT($result); +} + else +{ + // Nothing for in and out + $OUT = " + + ".LOAD_TEMPLATE("admin_settings_saved", true, TRANSFER_NO_INOUT_TRANSFERS)." + +"; +} + +// ... and add them to a constant for the template +define('__TRANSFER_ROWS', $OUT); + +// Remeber total amount +define('__TRANSFER_TOTAL_VALUE', $total); + +// Set title +define('__TRANSFER_TITLE', TRANSFER_LIST_ALL); + +// Show delete button here +define('__TRANSFER_DELETE', " * "); + +// Load final template +LOAD_TEMPLATE("admin_list_transfer"); + +// +?>