* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team *
* For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
$content['points'] = bigintval(postRequestElement('points'));
// Load userid
- $result_main = SQL_QUERY("SELECT `userid`, `email` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `status`='CONFIRMED' ORDER BY `userid` ASC",
+ $result_main = sqlQuery("SELECT `userid`, `email` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `status`='CONFIRMED' ORDER BY `userid` ASC",
__FILE__, __LINE__);
- while ($row = SQL_FETCHARRAY($result_main)) {
+ while ($row = sqlFetchArray($result_main)) {
// Merge both arrays
$content = merge_array($content, $row);
// Prepare content
$content = array(
- 'reason' => SQL_ESCAPE(postRequestElement('reason')),
+ 'reason' => sqlEscapeString(postRequestElement('reason')),
'points' => bigintval(postRequestElement('points')),
'subject' => 'admin_sub_all',
);
// Load message and send it away
$message = loadEmailTemplate('member_sub_points', $content, bigintval($content['userid']));
- sendEmail($row['userid'], '{--ADMIN_SUB_SUBJECT--}', $message);
+ sendEmail($row['userid'], '{--ADMIN_SUB_POINTS_SUBJECT--}', $message);
} // END - while
// Free memory
- SQL_FREERESULT($result_main);
+ sqlFreeResult($result_main);
// Output message
- displayMessage('{--ADMIN_ALL_POINTS_SUBTRACTED--}');
+ displayMessage('{--ADMIN_ALL_POINTS_SUB_DONE--}');
} else {
// Display form add points
loadTemplate('admin_sub_points_all');
// Prepare content
$content = array(
- 'reason' => SQL_ESCAPE(postRequestElement('reason')),
+ 'reason' => sqlEscapeString(postRequestElement('reason')),
'points' => bigintval(postRequestElement('points')),
'subject' => 'admin_sub_single',
);
// Load email and send it away
$message = loadEmailTemplate('member_sub_points', $content, bigintval(getRequestElement('userid')));
- sendEmail(getRequestElement('userid'), '{--ADMIN_SUB_SUBJECT--}', $message);
+ sendEmail(getRequestElement('userid'), '{--ADMIN_SUB_POINTS_SUBJECT--}', $message);
// Output message
displayMessage('{--ADMIN_POINTS_SUBTRACTED--}');
}
} else {
// User not found
- loadTemplate('admin_settings_unsaved', FALSE, '{%message,ADMIN_MEMBER_404=' . bigintval(getRequestElement('userid')) . '%}');
+ displayErrorMessage('{%message,ADMIN_MEMBER_404=' . bigintval(getRequestElement('userid')) . '%}');
}
} else {
// Output selection form with all confirmed user accounts listed