//
// First we would like to store the data and get it's pool position back...
// @TODO Try to move out url_tlock to a filter for extra SQL statements
- $result = SQL_QUERY_ESC("SELECT
+ $result = sqlQueryEscaped("SELECT
`id`,
`data_type`
FROM
postRequestElement('url')
), __FILE__, __LINE__);
- if (SQL_NUMROWS($result) == 1) {
+ if (sqlNumRows($result) == 1) {
// Load id and mail type
- $data = SQL_FETCHARRAY($result);
+ $data = sqlFetchArray($result);
} // END - if
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
if ($data['data_type'] == 'TEMP') {
/*
// Still no error?
if (empty($data['url'])) {
// Check for userids
- $result = SQL_QUERY_ESC("SELECT
+ $result = sqlQueryEscaped("SELECT
`c`.`userid`
FROM
`{?_MYSQL_PREFIX?}_user_cats` AS `c`
), __FILE__, __LINE__);
// Are there still receivers left?
- if (SQL_NUMROWS($result) >= postRequestElement('receiver')) {
+ if (sqlNumRows($result) >= postRequestElement('receiver')) {
// Load receivers from database
$TEST = array(); $count = '0';
- while ($holidayContent = SQL_FETCHARRAY($result)) {
+ while ($holidayContent = sqlFetchArray($result)) {
if (isExtensionInstalledAndNewer('holiday', '0.1.3')) {
// Check for his holiday status
- $result_holiday = SQL_QUERY_ESC("SELECT
+ $result_holiday = sqlQueryEscaped("SELECT
`id`
FROM
`{?_MYSQL_PREFIX?}_user_holidays`
`holiday_end` > UNIX_TIMESTAMP()
LIMIT 1",
array($holidayContent['userid']), __FILE__, __LINE__);
- if (SQL_NUMROWS($result_holiday) == 1) {
+ if (sqlNumRows($result_holiday) == 1) {
// Exclude user who are in holiday
$holidayContent['userid'] = '0';
} // END - if
// Free memory
- SQL_FREERESULT($result_holiday);
+ sqlFreeResult($result_holiday);
} // END - if
if (isValidId($holidayContent['userid'])) {
} // END - while
// Free memory
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Implode array into string for the sending pool
$receiver = implode($TEST, ';');
$content['target_send'] = count($TEST);
// Update receiver list
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `receive_mails`=`receive_mails`-1 WHERE `userid` IN (%s) LIMIT %s",
+ sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `receive_mails`=`receive_mails`-1 WHERE `userid` IN (%s) LIMIT %s",
array(
convertReceivers($receiver),
bigintval($content['target_send'])
if (isAdmin()) $whereStatement = '';
// Display order form
- $result_cats = SQL_QUERY('SELECT
+ $result_cats = sqlQuery('SELECT
`id`,
`cat`
FROM
`sort` ASC', __FILE__, __LINE__);
// Some categories found?
- if (!SQL_HASZERONUMS($result_cats)) {
+ if (!ifSqlHasZeroNums($result_cats)) {
// Enought points left?
if ($totalPoints > 0) {
// Initialize array...
} // END - if
// ... and begin loading stuff
- while ($categoriesContent = SQL_FETCHARRAY($result_cats)) {
+ while ($categoriesContent = sqlFetchArray($result_cats)) {
$categories['id'][] = bigintval($categoriesContent['id']);
array_push($categories['name'], $categoriesContent['cat']);
// Select users in current category
- $result_userids = SQL_QUERY_ESC('SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_cats` WHERE `cat_id`=%s AND `userid` != %s ORDER BY `userid` ASC',
+ $result_userids = sqlQueryEscaped('SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_cats` WHERE `cat_id`=%s AND `userid` != %s ORDER BY `userid` ASC',
array(bigintval($categoriesContent['id']), getMemberId()), __FILE__, __LINE__);
$userid_cnt = '0';
- while (list($userid) = SQL_FETCHROW($result_userids)) {
+ while (list($userid) = sqlFetchRow($result_userids)) {
// Check for holiday system
$isHolidayActive = FALSE;
if (isExtensionInstalledAndNewer('holiday', '0.1.3')) {
// Check user's holiday status
- $result_holiday = SQL_QUERY_ESC("SELECT
+ $result_holiday = sqlQueryEscaped("SELECT
COUNT(`d`.`userid`) AS `cnt`
FROM
`{?_MYSQL_PREFIX?}_user_data` AS `d`
array(bigintval($userid)), __FILE__, __LINE__);
// Fetch entry
- list($count) = SQL_FETCHROW($result_holiday);
+ list($count) = sqlFetchRow($result_holiday);
// Free memory
- SQL_FREERESULT($result_holiday);
+ sqlFreeResult($result_holiday);
// Is holiday is active?
$isHolidayActive = ($count == 1);
if ($isHolidayActive === FALSE) {
// Check if the user want's to receive mails?
- $result_ver = SQL_QUERY_ESC("SELECT `zip` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s" . $HTML . " AND `receive_mails` > 0 AND `status`='CONFIRMED' LIMIT 1",
+ $result_ver = sqlQueryEscaped("SELECT `zip` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s" . $HTML . " AND `receive_mails` > 0 AND `status`='CONFIRMED' LIMIT 1",
array(bigintval($userid)), __FILE__, __LINE__);
- if ((SQL_NUMROWS($result_ver) == 1) && (isPostRequestElementSet('zip')) && (isOrderMultiPageEnabled())) {
+ if ((sqlNumRows($result_ver) == 1) && (isPostRequestElementSet('zip')) && (isOrderMultiPageEnabled())) {
// Get zip code
- list($zip) = SQL_FETCHROW($result_ver);
+ list($zip) = sqlFetchRow($result_ver);
if (substr($zip, 0, strlen(postRequestElement('zip'))) == postRequestElement('zip')) {
// Ok, ZIP code part is found
$userid_cnt++;
} // END - if
} else {
// Count numbers up!
- $userid_cnt += SQL_NUMROWS($result_ver);
+ $userid_cnt += sqlNumRows($result_ver);
}
// Free result
- SQL_FREERESULT($result_ver);
+ sqlFreeResult($result_ver);
} // END - if
} // END - while
// Free memory
- SQL_FREERESULT($result_userids);
+ sqlFreeResult($result_userids);
array_push($categories['userids'], $userid_cnt);
} // END - while
// Free memory
- SQL_FREERESULT($result_cats);
+ sqlFreeResult($result_cats);
// Now we need to load the mail types...
- $result = SQL_QUERY("SELECT `id`, `price`, `payment`, `mail_title` FROM `{?_MYSQL_PREFIX?}_payments` WHERE `price` > 0 AND `payment` > 0 ORDER BY `payment` ASC", __FILE__, __LINE__);
+ $result = sqlQuery("SELECT `id`, `price`, `payment`, `mail_title` FROM `{?_MYSQL_PREFIX?}_payments` WHERE `price` > 0 AND `payment` > 0 ORDER BY `payment` ASC", __FILE__, __LINE__);
$payments = array();
- if (!SQL_HASZERONUMS($result)) {
+ if (!ifSqlHasZeroNums($result)) {
// Is the error code set?
if (isGetRequestElementSet('code')) {
// Display error message
} // END - if
// Load all email types...
- while ($payment = SQL_FETCHARRAY($result)) {
+ while ($payment = sqlFetchArray($result)) {
array_push($payments, $payment);
} // END - while
// Free memory
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Output user's points
$content['total_points'] = $totalPoints;
$target = '';
// Check if we already have an order placed and make it editable
- $result = SQL_QUERY_ESC("SELECT
+ $result = sqlQueryEscaped("SELECT
`subject`,
`text`,
`payment_id`,
LIMIT 1",
array(getMemberId()), __FILE__, __LINE__);
- if (SQL_NUMROWS($result) == 1) {
+ if (sqlNumRows($result) == 1) {
// Old order found
- $content = merge_array($content, SQL_FETCHARRAY($result));
+ $content = merge_array($content, sqlFetchArray($result));
// Fix max receivers when it is too much
if ((isset($categories['userids'][$content['cat_id']])) && ($content['target_send'] > $categories['userids'][$content['cat_id']])) {
}
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
if ((isPostRequestElementSet('data')) || ((getOrderMultiPage() != 'Y') && ((!isAdmin()) && (!isExtensionActive('html_mail'))))) {
// Pre-output categories
projects / mailer.git / blobdiff