<?php
/************************************************************************
- * MXChange v0.2.1 Start: 10/22/2005 *
- * =============== Last change: 10/22/2005 *
+ * Mailer v0.2.1-FINAL Start: 10/22/2005 *
+ * =================== Last change: 10/22/2005 *
* *
* -------------------------------------------------------------------- *
* File : monthly_beg.php *
// Shall we exclude webmaster's own userid?
if ((getConfig('beg_include_own') != 'Y') && (getConfig('beg_userid') > 0)) {
// Exclude it
- $whereStatement1 = sprintf(" AND `userid` != %s", getConfig('beg_userid'));
+ $whereStatement1 = " AND `userid` != {?beg_userid?}";
} // END - if
// Let's check if there are some points left we can 'pay'...
// Use last online stamp only when autopurge for inactive members is activated
if ((getConfig('ap_inactive_since') > 0) && (getConfig('beg_active') == 'Y')) {
// Okay, include last online timestamp
- $whereStatement1 .= sprintf(" AND `last_online` >= (UNIX_TIMESTAMP() - %s)", getConfig('ap_inactive_since'));
+ $whereStatement1 .= " AND `last_online` >= (UNIX_TIMESTAMP() - {?ap_inactive_since?})";
} // END - if
} // END - if
FROM
`{?_MYSQL_PREFIX?}_user_data`
WHERE
- `status`='CONFIRMED'" . $whereStatement1 . " AND `beg_points` > 0
+ `status`='CONFIRMED'" . $whereStatement1 . " AND
+ `beg_points` > 0
ORDER BY
- `beg_points` DESC, `userid` ASC
+ `beg_points` DESC,
+ `userid` ASC
LIMIT {?beg_ranks?}", __FILE__, __LINE__);
if (SQL_NUMROWS($result_main) > 0) {