$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 runFilterChain('run_sqls'); } // END - if } // END - if // We only need outgoing transfers $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_HASZERONUMS($result)) { // Output rows $OUT = ''; while ($content = SQL_FETCHARRAY($result)) { // Prepare data for the row template $content['time_trans'] = generateDateTime($content['time_trans'], 3); // Load row template $OUT .= loadTemplate('admin_delete_transfer_row', true, $content); // Sum points and switch colors $total += $content['points']; } // END - while // Free memory SQL_FREERESULT($result); } else { // Nothing for in and out $OUT = '