$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',
);
} // END - while
// Free memory
- SQL_FREERESULT($result_main);
+ sqlFreeResult($result_main);
// Output message
displayMessage('{--ADMIN_ALL_POINTS_SUB_DONE--}');
// Prepare content
$content = array(
- 'reason' => SQL_ESCAPE(postRequestElement('reason')),
+ 'reason' => sqlEscapeString(postRequestElement('reason')),
'points' => bigintval(postRequestElement('points')),
'subject' => 'admin_sub_single',
);