// Shall I display links or not?
if (($listed === TRUE) && (!empty($sql))) {
// Load mail data
- $result_master = SQL_QUERY($sql, __FILE__, __LINE__);
+ $result_master = sqlQuery($sql, __FILE__, __LINE__);
// Is there an entry?
- if (SQL_NUMROWS($result_master) == 1) {
+ if (sqlNumRows($result_master) == 1) {
// Mail order / bonus mail found
- $poolData = SQL_FETCHARRAY($result_master);
+ $poolData = sqlFetchArray($result_master);
// If there is a pool id and $ID is not set, we take it
if (($poolData['id'] > 0) && ($ID == '-1')) {
// Load unconfirmed mail links. Hmmm, this select query is pretty cool
// but it does only show unconfirmed mail links from existing user
// accounts. So if you have delete one you did not see those links
- $result = SQL_QUERY_ESC("SELECT
+ $result = sqlQueryEscaped("SELECT
`l`.`userid`,
`u`.`status`,
`u`.`surname`,
),__FILE__, __LINE__);
// Are there entries?
- if (!SQL_HASZERONUMS($result)) {
+ if (!ifSqlHasZeroNums($result)) {
// At least one link left to confirm
$OUT = '';
- while ($row = SQL_FETCHARRAY($result)) {
+ while ($row = sqlFetchArray($result)) {
// User data found? We can take any field of u.
if (!is_null($row['status'])) {
// Prepare data for the row template
// Prepare content
$content = $poolData;
- $content['unconfirmed'] = SQL_NUMROWS($result);
+ $content['unconfirmed'] = sqlNumRows($result);
$content['timestamp'] = generateDateTime($poolData['timestamp'], 2);
$content['rows'] = $OUT;
// Free memory
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Load final template
loadTemplate('admin_list_unconfirmed', FALSE, $content);
}
// Free result
- SQL_FREERESULT($result_master);
+ sqlFreeResult($result_master);
} // END - if
// [EOF]