ADD_DESCR('member', __FILE__);
// Load data
-$result = SQL_QUERY_ESC("SELECT opt_in FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
-array(getUserId()), __FILE__, __LINE__);
+$result = SQL_QUERY_ESC("SELECT `opt_in` FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `userid`=%s LIMIT 1",
+ array(getUserId()), __FILE__, __LINE__);
list($opt_in) = SQL_FETCHROW($result);
// Free memory
sendAdminNotification($ADMIN_SUBJ, 'admin_transfer_points');
// Transfer is completed
- LOAD_TEMPLATE('admin_settings_saved', false, getMessage('TRANSFER_COMPLETED')."<br /><a href=\"{!URL!}/modules.php?module=login&what=transfer\">{--TRANSFER_CONTINUE_OVERVIEW--}</a>");
+ LOAD_TEMPLATE('admin_settings_saved', false, getMessage('TRANSFER_COMPLETED')."<br /><a href=\"{?URL?}/modules.php?module=login&what=transfer\">{--TRANSFER_CONTINUE_OVERVIEW--}</a>");
} elseif (!$valid_code) {
// Invalid Touring code!
LOAD_TEMPLATE('admin_settings_saved', false, "<div class=\"member_note\">{--TRANSFER_INVALID_CODE--}</div>");
// Check incoming transfers
$total = GET_TOTAL_DATA(getUserId(), 'user_transfers_in', 'id', 'userid', true);
if ($total > 0) {
- define('__TRANSFER_IN_LINK', "<a href=\"{!URL!}/modules.php?module=login&what=transfer&mode=list_in\">".$dmy."</a>");
+ define('__TRANSFER_IN_LINK', "<a href=\"{?URL?}/modules.php?module=login&what=transfer&mode=list_in\">".$dmy."</a>");
} else {
define('__TRANSFER_IN_LINK', $dmy);
}
$total += $dmy;
if ($dmy > 0) {
- define('__TRANSFER_OUT_LINK', "<a href=\"{!URL!}/modules.php?module=login&what=transfer&mode=list_out\">".$dmy."</a>");
+ define('__TRANSFER_OUT_LINK', "<a href=\"{?URL?}/modules.php?module=login&what=transfer&mode=list_out\">".$dmy."</a>");
} else {
define('__TRANSFER_OUT_LINK', $dmy);
}
// Total transactions
if ($total > 0) {
- define('__TRANSFER_ALL_LINK', "<a href=\"{!URL!}/modules.php?module=login&what=transfer&mode=list_all\">".$total."</a>");
+ define('__TRANSFER_ALL_LINK', "<a href=\"{?URL?}/modules.php?module=login&what=transfer&mode=list_all\">".$total."</a>");
} else {
define('__TRANSFER_ALL_LINK', $total);
}
case 'Y':
define('__TRANSFER_ALLOW_Y', ' checked="checked"');
define('__TRANSFER_ALLOW_N', '');
- define('__TRANSFER_NEW_LINK', "<a href=\"{!URL!}/modules.php?module=login&what=transfer&mode=new\">{--TRANSFER_NOW_LINK--}</a>");
+ define('__TRANSFER_NEW_LINK', "<a href=\"{?URL?}/modules.php?module=login&what=transfer&mode=new\">{--TRANSFER_NOW_LINK--}</a>");
break;
case 'N':