* $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 *
// Enougth points?
if ($points > 0) {
// Pay this out!
- $result = SQL_QUERY_ESC('SELECT
+ $result = sqlQueryEscaped('SELECT
`id`,
`type`,
`rate`,
ORDER BY
`type` ASC',
array($points), __FUNCTION__, __LINE__);
- if (!SQL_HASZERONUMS($result)) {
+
+ // Some entries found?
+ if (!ifSqlHasZeroNums($result)) {
// Init output
$OUT = '';
// Now let's check
- while ($content = SQL_FETCHARRAY($result)) {
+ while ($content = sqlFetchArray($result)) {
// Are these points enougth?
if ($points >= $content['min_points']) {
// Prepare content for template
loadTemplate('member_payout_list', TRUE, $OUT);
} else {
// No payout types setup so far
- loadTemplate('admin_settings_unsaved', FALSE, '{--MEMBER_PAYOUT_SETUP_INCOMPLETE--}');
+ displayErrorMessage('{--MEMBER_PAYOUT_SETUP_INCOMPLETE_LOW_POINTS--}');
}
// Free memory
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
} else {
// Points is empty
- loadTemplate('admin_settings_unsaved', FALSE, '{--MEMBER_PAYOUT_NO_POINTS_ENTERED--}');
+ displayErrorMessage('{--MEMBER_PAYOUT_NO_POINTS_ENTERED--}');
}
}