* $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 *
} // END - if
// Load user links data
- $result = SQL_QUERY_ESC("SELECT `userid`, `stats_id`, `%s`, `link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `userid`=%s ORDER BY `id` ASC",
+ $result = sqlQueryEscaped("SELECT `userid`, `stats_id`, `%s`, `link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `userid`=%s ORDER BY `id` ASC",
array(
$linkDataName,
bigintval(getRequestElement('userid'))
), __FILE__, __LINE__);
// Are there some entries?
- if (!SQL_HASZERONUMS($result)) {
+ if (!ifSqlHasZeroNums($result)) {
// Some unconfirmed mails left
if (getRequestElement('delete') == 'all') {
// Delete all unconfirmed mails by this user
- SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `userid`=%s LIMIT %s",
- array(bigintval(getRequestElement('userid')), SQL_NUMROWS($result)), __FILE__, __LINE__);
+ sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `userid`=%s LIMIT %s",
+ array(bigintval(getRequestElement('userid')), sqlNumRows($result)), __FILE__, __LINE__);
// Prepare mail and send it away
- $message = loadEmailTemplate('member_delete_links', SQL_NUMROWS($result), bigintval(getRequestElement('userid')));
+ $message = loadEmailTemplate('member_delete_links', sqlNumRows($result), bigintval(getRequestElement('userid')));
sendEmail(getUserData('userid'), '{--ADMIN_DELETE_LINK_SUBJECT--}', $message);
// Display message
$OUT = '';
// List all unconfirmed mails
- while ($linkData = SQL_FETCHARRAY($result)) {
+ while ($linkData = sqlFetchArray($result)) {
// Initializes all other elements
$linkData['mail_id'] = '';
$linkData['problem'] = '{--ADMIN_GENERAL_MAIL_PROBLEM--}';
// @TODO Rewrite this to includes/filter
switch ($linkData['link_type']) {
case 'NORMAL':
- $result_data = SQL_QUERY_ESC("SELECT `subject`, `timestamp_ordered` AS `timestamp`, `cat_id` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `id`=%s LIMIT 1",
+ $result_data = sqlQueryEscaped("SELECT `subject`, `timestamp_ordered` AS `timestamp`, `cat_id` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `id`=%s LIMIT 1",
array(bigintval($linkData['stats_id'])), __FILE__, __LINE__);
$linkData['link_type'] = 'mailid';
$linkData['mail_id'] = $linkData['stats_id'];
break;
case 'BONUS':
- $result_data = SQL_QUERY_ESC("SELECT `subject`, `timestamp`, `cat_id` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
+ $result_data = sqlQueryEscaped("SELECT `subject`, `timestamp`, `cat_id` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
array(bigintval($linkData['bonus_id'])), __FILE__, __LINE__);
$linkData['link_type'] = 'bonusid';
$linkData['mail_id'] = $linkData['bonus_id'];
break;
default: // Problem in application detected!
- reportBug(__FILE__, __LINE__, sprintf("Invalid email type %s detected.", $linkData['link_type']));
+ reportBug(__FILE__, __LINE__, sprintf('Invalid email type %s detected.', $linkData['link_type']));
break;
} // END - switch
// Is there an entry?
- if (SQL_NUMROWS($result_data) == 1) {
+ if (sqlNumRows($result_data) == 1) {
// Mail was found
- $mailData = merge_array($linkData, SQL_FETCHARRAY($result_data));
+ $mailData = merge_array($linkData, sqlFetchArray($result_data));
// Fix empty subject
if (empty($mailData['subject'])) {
}
// Free result
- SQL_FREERESULT($result_data);
+ sqlFreeResult($result_data);
} // END - while
// Remember list in constant for the template
$content = array(
'email' => '<a href="' . generateEmailLink(getUserData('email'), 'user_data') . '">' . getUserData('email') . '</a>',
'rows' => $OUT,
- 'nums' => SQL_NUMROWS($result),
+ 'nums' => sqlNumRows($result),
'userid' => bigintval(getRequestElement('userid')),
);
// Free memory
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Load final template
loadTemplate('admin_list_links', FALSE, $content);