<?php
/************************************************************************
- * MXChange v0.2.1 Start: 11/23/2003 *
- * =============== Last change: 09/23/2004 *
+ * Mailer v0.2.1-FINAL Start: 11/23/2003 *
+ * =================== Last change: 09/23/2004 *
* *
* -------------------------------------------------------------------- *
* File : what-sub_points.php *
// Is the form sent?
if ((isFormSent()) && (postRequestElement('points') > 0)) {
$result_main = SQL_QUERY("SELECT userid, email FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `status`='CONFIRMED' ORDER BY `userid` ASC",
- __FILE__, __LINE__);
+ __FILE__, __LINE__);
while ($content = merge_array($content, SQL_FETCHARRAY($result_main))) {
// Ok, add points to used points and send an email to him...
subtractPoints('admin_all', $content['userid'], postRequestElement('points'));
loadTemplate('admin_sub_points_all');
}
} elseif (isGetRequestElementSet('userid')) {
- // User ID found in URL so we use this give him some credits
- $result = SQL_QUERY_ESC("SELECT `surname`, `family`, `email` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s AND `status`='CONFIRMED' LIMIT 1",
- array(bigintval(getRequestElement('userid'))),__FILE__, __LINE__);
- if (SQL_NUMROWS($result) == 1) {
+ // User id found in URL so we use this give him some credits
+ if (fetchUserData(getRequestElement('userid'))) {
// Selected user does exist
- $content = SQL_FETCHARRAY($result);
+ $content = getUserDataArray();
if ((isFormSent()) && (isPostRequestElementSet(('points')))) {
// Ok, add to used points and send an email to him...
// User not found!
loadTemplate('admin_settings_saved', false, "<div class=\"admin_failed\">".sprintf(getMessage('ADMIN_MEMBER_404'), getRequestElement('userid'))."</div>");
}
-
- // Free result
- SQL_FREERESULT($result);
} else {
// Output selection form with all confirmed user accounts listed
- addMemberSelectionBox('0', true);
+ addMemberSelectionBox(0, true);
}
// [EOF]