$OUT_PAY = '';
// Load all sponsor actions
-$result_act = SQL_QUERY("SELECT
+$result_act = sqlQuery("SELECT
`m`.`title` AS `conv_title`,
`c`.`conv_rate`,
`c`.`conv_name`
ORDER BY
`m`.`sort` ASC", __FILE__, __LINE__);
-if (!SQL_HASZERONUMS($result_act)) {
+if (!ifSqlHasZeroNums($result_act)) {
// Load all actions
- while ($content = SQL_FETCHARRAY($result_act)) {
+ while ($content = sqlFetchArray($result_act)) {
// Load row template and switch color
$OUT_ACT .= loadTemplate('guest_sponsor_act_row', TRUE, $content);
} // END - while
// Check for pay types
- $result_pay = SQL_QUERY('SELECT `pay_name`, `pay_rate`, `pay_min_count`, `pay_currency` FROM `{?_MYSQL_PREFIX?}_sponsor_paytypes` ORDER BY `pay_name` ASC', __FILE__, __LINE__);
- if (!SQL_HASZERONUMS($result_pay)) {
+ $result_pay = sqlQuery('SELECT `pay_name`, `pay_rate`, `pay_min_count`, `pay_currency` FROM `{?_MYSQL_PREFIX?}_sponsor_paytypes` ORDER BY `pay_name` ASC', __FILE__, __LINE__);
+ if (!ifSqlHasZeroNums($result_pay)) {
// Load all pay types
- while ($content = SQL_FETCHARRAY($result_pay)) {
+ while ($content = sqlFetchArray($result_pay)) {
// Load row template and switch color
$OUT_PAY .= loadTemplate('guest_sponsor_pay_row', TRUE, $content);
} // END - while
}
// Free memory
-SQL_FREERESULT($result_act);
-SQL_FREERESULT($result_pay);
+sqlFreeResult($result_act);
+sqlFreeResult($result_pay);
// Transfer rows to an array
$content = array(