// Delete entries...
foreach ($_POST['sel'] as $id => $sel)
{
- $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_transfers_in WHERE trans_id=%s LIMIT 1",
- array(bigintval($id)), __FILE__, __LINE__);
- $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_transfers_out WHERE trans_id=%s LIMIT 1",
- array(bigintval($id)), __FILE__, __LINE__);
+ SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_transfers_in` WHERE trans_id=%s LIMIT 1",
+ array(bigintval($id)), __FILE__, __LINE__);
+ SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_transfers_out` WHERE trans_id=%s 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__);
+$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))
+ while (list($uid1, $uid2, $idx, $points, $reason, $stamp) = SQL_FETCHROW($result))
{
// Prepare data for the row template
$content = array(
else
{
// Nothing for in and out
- $OUT = "<TR>
- <TD colspan=\"6\" align=\"center\" class=\"bottom2\" height=\"70\">
+ $OUT = "<tr>
+ <td colspan=\"6\" align=\"center\" class=\"bottom2\" height=\"70\">
".LOAD_TEMPLATE("admin_settings_saved", true, TRANSFER_NO_INOUT_TRANSFERS)."
- </TD>
-</TR>";
+ </td>
+</tr>";
}
// ... and add them to a constant for the template
define('__TRANSFER_TITLE', TRANSFER_LIST_ALL);
// Show delete button here
-define('__TRANSFER_DELETE', "<INPUT type=\"reset\" class=\"admin_reset\" value=\"".UNDO_SELECTIONS."\"> * <INPUT type=\"submit\" name=\"del\" class=\"admin_delete\" value=\"".TRANSFER_DELETE."\">");
+define('__TRANSFER_DELETE', "<input type=\"reset\" class=\"admin_reset\" value=\"".UNDO_SELECTIONS."\" /> * <input type=\"submit\" name=\"del\" class=\"admin_delete\" value=\"".TRANSFER_DELETE."\" />");
// Load final template
LOAD_TEMPLATE("admin_list_transfer");