displayMessage('{--ADMIN_SEND_COUPON_DESCRIPTION_NOT_ENTERED--}');
} else {
// All fields are set, so we can start looking for users who wants to receive coupons
- $result = SQL_QUERY("SELECT
+ $result = sqlQuery("SELECT
`userid`
FROM
`{?_MYSQL_PREFIX?}_user_data`
__FILE__, __LINE__);
// Are there entries left?
- if (!SQL_HASZERONUMS($result)) {
+ if (!ifSqlHasZeroNums($result)) {
// Convert timestamp selections
$expirationTime = time() + createEpocheTimeFromSelections('coupon_default_time', postRequestArray());
// Insert coupon data
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_coupon_data` (`coupon_expired`, `total_created`, `points`, `coupon_description`) VALUES ('{%%pipe,SQL_EPOCHE_TO_TIMESTAMP=%s%%}', %s,%s,'%s')",
+ sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_coupon_data` (`coupon_expired`, `total_created`, `points`, `coupon_description`) VALUES ('{%%pipe,SQL_EPOCHE_TO_TIMESTAMP=%s%%}', %s,%s,'%s')",
array(
$expirationTime,
- SQL_NUMROWS($result),
+ sqlNumRows($result),
bigintval(postRequestElement('points')),
postRequestElement('coupon_description')
), __FILE__, __LINE__
);
// Get the insert id from the table
- $couponId = SQL_INSERT_ID();
+ $couponId = getSqlInsertId();
// Init userid array
$adminUserids = array();
// Load entry
- while (list($userid) = SQL_FETCHROW($result)) {
+ while (list($userid) = sqlFetchRow($result)) {
// Debug message
//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'NUMS=' . SQL_NUMROWS($result) . ',userid=' . $userid);
} // END - while
// The above loop should always set $couponCode, so we can now insert it
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_coupons` (`coupon_id`, `userid`, `coupon_code`) VALUES (%s,%s,'%s')",
+ sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_user_coupons` (`coupon_id`, `userid`, `coupon_code`) VALUES (%s,%s,'%s')",
array(
$couponId,
$userid,
}
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
}
} else {
// Prepare some template data