|
@@ -422,21 +373,20 @@ case "list_all": // List all transactions
// First of all create the temporary table
$result = SQL_QUERY("CREATE TEMPORARY TABLE "._MYSQL_PREFIX."_transfers_tmp (
trans_id VARCHAR(12) NOT NULL DEFAULT '',
-party_uid BIGINT(20) NOT NULL DEFAULT '0',
-points BIGINT(20) NOT NULL DEFAULT '0',
+party_uid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+points BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
reason VARCHAR(255) NOT NULL DEFAULT '',
time_trans VARCHAR(10) NOT NULL DEFAULT '0',
-trans_type ENUM('IN', 'OUT') NOT NULL DEFAULT 'IN',
+trans_type ENUM('IN','OUT') NOT NULL DEFAULT 'IN',
KEY(party_uid)
) TYPE=HEAP", __FILE__, __LINE__);
// Let's begin with the incoming list
$result = SQL_QUERY_ESC("SELECT trans_id, from_uid, points, reason, time_trans FROM "._MYSQL_PREFIX."_user_transfers_in WHERE userid=%s ORDER BY id LIMIT %s",
-array($GLOBALS['userid'], $_CONFIG['transfer_max']), __FILE__, __LINE__);
- while ($DATA = SQL_FETCHROW($result))
- {
+array($GLOBALS['userid'], getConfig('transfer_max')), __FILE__, __LINE__);
+ while ($DATA = SQL_FETCHROW($result)) {
$DATA[] = "IN";
- $DATA = implode("', '", $DATA);
+ $DATA = implode("','", $DATA);
$res_temp = SQL_QUERY("INSERT INTO "._MYSQL_PREFIX."_transfers_tmp (trans_id, party_uid, points, reason, time_trans, trans_type) VALUES ('".$DATA."')", __FILE__, __LINE__);
}
@@ -445,11 +395,10 @@ array($GLOBALS['userid'], $_CONFIG['transfer_max']), __FILE__, __LINE__);
// As the last table transfer data from outgoing table to temporary
$result = SQL_QUERY_ESC("SELECT trans_id, to_uid, points, reason, time_trans FROM "._MYSQL_PREFIX."_user_transfers_out WHERE userid=%s ORDER BY id LIMIT %s",
-array($GLOBALS['userid'], $_CONFIG['transfer_max']), __FILE__, __LINE__);
- while ($DATA = SQL_FETCHROW($result))
- {
+array($GLOBALS['userid'], getConfig('transfer_max')), __FILE__, __LINE__);
+ while ($DATA = SQL_FETCHROW($result)) {
$DATA[] = "OUT";
- $DATA = implode("', '", $DATA);
+ $DATA = implode("','", $DATA);
$res_temp = SQL_QUERY("INSERT INTO "._MYSQL_PREFIX."_transfers_tmp (trans_id, party_uid, points, reason, time_trans, trans_type) VALUES ('".$DATA."')", __FILE__, __LINE__);
}
@@ -457,29 +406,27 @@ array($GLOBALS['userid'], $_CONFIG['transfer_max']), __FILE__, __LINE__);
SQL_FREERESULT($result);
$total = 0;
- if (SQL_NUMROWS($result) > 0)
- {
+ if (SQL_NUMROWS($result) > 0) {
// Output rows
$OUT = ""; $SW = 2;
$result = SQL_QUERY("SELECT party_uid, trans_id, points, reason, time_trans, trans_type FROM "._MYSQL_PREFIX."_transfers_tmp ORDER BY time_trans DESC", __FILE__, __LINE__);
- while(list($uid, $idx, $points, $reason, $stamp, $type) = SQL_FETCHROW($result))
- {
+ while(list($uid, $idx, $points, $reason, $stamp, $type) = SQL_FETCHROW($result)) {
if ($type == "OUT") $points = "-$points";
$OUT .= " |
|
@@ -528,12 +473,9 @@ case "": // Overview page
SQL_FREERESULT($result);
$total=$dmy;
- if ($dmy > 0)
- {
- define('__TRANSFER_IN_LINK', "".$dmy."");
- }
- else
- {
+ if ($dmy > 0) {
+ define('__TRANSFER_IN_LINK', "".$dmy."");
+ } else {
define('__TRANSFER_IN_LINK', $dmy);
}
@@ -543,66 +485,62 @@ case "": // Overview page
SQL_FREERESULT($result);
$total+=$dmy;
- if ($dmy > 0)
- {
- define('__TRANSFER_OUT_LINK', "".$dmy."");
- }
- else
- {
+ if ($dmy > 0) {
+ define('__TRANSFER_OUT_LINK', "".$dmy."");
+ } else {
define('__TRANSFER_OUT_LINK', $dmy);
}
// Total transactions
- if ($total > 0)
- {
- define('__TRANSFER_ALL_LINK', "".$total."");
- }
- else
- {
+ if ($total > 0) {
+ define('__TRANSFER_ALL_LINK', "".$total."");
+ } else {
define('__TRANSFER_ALL_LINK', $total);
}
- if (isset($_POST['ok']))
- {
+ if (isset($_POST['ok'])) {
// Save settings
- $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET opt_in='%s' WHERE userid=%s LIMIT 1",
- array($_POST['opt_in'], $GLOBALS['userid']), __FILE__, __LINE__);
+ SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_user_data` SET opt_in='%s' WHERE userid=%s LIMIT 1",
+ array($_POST['opt_in'], $GLOBALS['userid']), __FILE__, __LINE__);
// Rember for next switch() command
$opt_in = $_POST['opt_in'];
// "Settings saved..."
- OUTPUT_HTML(" ".SETTINGS_SAVED." ");
+ LOAD_TEMPLATE("admin_settings_saved", false, "".SETTINGS_SAVED." ");
}
+
switch ($opt_in)
{
- case 'Y':
- define('__TRANSFER_ALLOW_Y', ' checked');
+ case "Y":
+ define('__TRANSFER_ALLOW_Y', " checked=\"checked\"");
define('__TRANSFER_ALLOW_N', "");
- define('__TRANSFER_NEW_LINK', "".TRANSFER_NOW_LINK."");
+ define('__TRANSFER_NEW_LINK', "".TRANSFER_NOW_LINK."");
break;
- case 'N':
+ case "N":
define('__TRANSFER_ALLOW_Y', "");
- define('__TRANSFER_ALLOW_N', ' checked');
+ define('__TRANSFER_ALLOW_N', " checked=\"checked\"");
define('__TRANSFER_NEW_LINK', TRANSFER_PLEASE_ALLOW_OPT_IN);
break;
}
// Check for latest out-transfers
- $result = SQL_QUERY_ESC("SELECT time_trans FROM "._MYSQL_PREFIX."_user_transfers_out WHERE time_trans > ".(time() - $_CONFIG['transfer_timeout'])." AND userid=%s ORDER BY time_trans DESC LIMIT 1", array($GLOBALS['userid']), __FILE__, __LINE__);
- if (SQL_NUMROWS($result) == 0)
- {
+ $result = SQL_QUERY_ESC("SELECT time_trans
+FROM "._MYSQL_PREFIX."_user_transfers_out
+WHERE time_trans > (UNIX_TIMESTAMP() - %s) AND userid=%s
+ORDER BY time_trans DESC
+LIMIT 1", array(getConfig('transfer_timeout'), $GLOBALS['userid']), __FILE__, __LINE__);
+ if (SQL_NUMROWS($result) == 0) {
// Load template
define('__TRANSFER_SETTINGS_CONTENT', LOAD_TEMPLATE("member_transfer_settings", true));
- }
- else
- {
+ } else {
// Load newest transaction
list($newest) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
define('__TRANSFER_SETTINGS_CONTENT', TRANSFER_LATEST_IS_1.MAKE_DATETIME($newest, "3").TRANSFER_LATEST_IS_2);
}
+
// Load template
LOAD_TEMPLATE("member_transfer_overview");
break;
|