define('__POINTS_VALUE', $_POST['points']);
if ((isset($_POST['ok'])) && ($_POST['points'] > 0))
{
- $result_main = SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE status='CONFIRMED' ORDER BY userid", __FILE__, __LINE__);
+ $result_main = SQL_QUERY("SELECT userid FROM `{!MYSQL_PREFIX!}_user_data` WHERE status='CONFIRMED' ORDER BY userid", __FILE__, __LINE__);
while (list($uid) = SQL_FETCHROW($result_main))
{
// User ID found in URL so we use this give him some credits
- $result = SQL_QUERY_ESC("SELECT surname, family, email FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s AND status='CONFIRMED' LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT surname, family, email FROM `{!MYSQL_PREFIX!}_user_data` WHERE userid=%s AND status='CONFIRMED' LIMIT 1",
array(bigintval($uid)), __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1)
{
if ((isset($_POST['ok'])) && (!empty($_POST['points'])))
{
// Ok, add points to used points and send an email to him...
- SUB_POINTS($uid, $_POST['points']);
+ SUB_POINTS("admin_all", $uid, $_POST['points']);
// Prepare content
$content = array(
- 'text' => SQL_ESCAPE($_POST['reason']),
+ 'text' => SQL_ESCAPE($_POST['reason']),
'points' => bigintval($_POST['points'])
);
elseif (!empty($_GET['u_id']))
{
// User ID found in URL so we use this give him some credits
- $result = SQL_QUERY_ESC("SELECT surname, family, email FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s AND status='CONFIRMED' LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT surname, family, email FROM `{!MYSQL_PREFIX!}_user_data` WHERE userid=%s AND status='CONFIRMED' LIMIT 1",
array(bigintval($_GET['u_id'])),__FILE__, __LINE__);
- if (SQL_NUMROWS($result) == 1)
- {
+ if (SQL_NUMROWS($result) == 1) {
// Selected user does exist
list($sname, $fname, $email) = SQL_FETCHROW($result);
SQL_FREERESULT($result);
- if ((isset($_POST['ok'])) && (!empty($_POST['points'])))
- {
+ if ((isset($_POST['ok'])) && (!empty($_POST['points']))) {
// Ok, add to used points and send an email to him...
- SUB_POINTS(bigintval($_GET['u_id']), $_POST['points']);
+ SUB_POINTS("admin_single", bigintval($_GET['u_id']), $_POST['points']);
// Prepare content
$content = array(
- 'text' => SQL_ESCAPE($_POST['reason']),
+ 'text' => SQL_ESCAPE($_POST['reason']),
'points' => bigintval($_POST['points'])
);
// Output message
LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_POINTS_SUBTRACTED);
- }
- else
- {
+ } else {
// Opps, missing form here
- define('__USER_VALUE', "<A href=\"".CREATE_EMAIL_LINK($email, "user_data")."\">".$sname." ".$fname."</A>");
- define('__UID_VALUE', $_GET['u_id']);
+ define('__USER_VALUE', "<a href=\"".CREATE_EMAIL_LINK($email, "user_data")."\">".$sname." ".$fname."</a>");
+ define('__UID', bigintval($_GET['u_id']));
LOAD_TEMPLATE("admin_sub_points");
}
- }
- else
- {
+ } else {
// User not found!
- OUTPUT_HTML("<STRONG class=\"admin_failed\">".ADMIN_MEMBER_404_1.$_GET['u_id'].ADMIN_MEMBER_404_2."</STRONG>");
+ LOAD_TEMPLATE("admin_settings_saved", false, "<div class=\"admin_failed\">".ADMIN_MEMBER_404_1.$_GET['u_id'].ADMIN_MEMBER_404_2."</strong>");
}
-}
- else
-{
+} else {
// Output selection form with all confirmed user accounts listed
ADD_MEMBER_SELECTION_BOX("0", true);
}