<?php
/************************************************************************
- * MXChange v0.2.1 Start: 01/27/2004 *
- * ================ Last change: 07/13/2004 *
+ * Mailer v0.2.1-FINAL Start: 01/27/2004 *
+ * =================== Last change: 07/13/2004 *
* *
* -------------------------------------------------------------------- *
* File : what-list_cats.php *
// Add description as navigation point
addMenuDescription('admin', __FILE__);
-if (isGetRequestElementSet('userid')) {
+if (isGetRequestParameterSet('userid')) {
// Check if the user already exists
- $result = SQL_QUERY_ESC("SELECT `surname`, `family`, `email` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1",
- array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__);
- if (SQL_NUMROWS($result) == 1) {
+ if (fetchUserData(getRequestParameter('userid'))) {
// Loads surname, family's name and the email address
- $content = SQL_FETCHARRAY($result);
+ $content = getUserDataArray();
// Prepare constants
- // @TODO No longer needed? define('__CATS_BASE' , "<a href=\"{?URL?}/modules.php?module=admin&userid=");
- $content['userid'] = bigintval(getRequestElement('userid'));
+ // @TODO No longer needed? define('__CATS_BASE' , '<a href="{%url=modules.php?module=admin&userid=');
+ $content['userid'] = bigintval(getRequestParameter('userid'));
$content['member_links'] = generateMemberAdminActionLinks($content['userid']);
- $content['email'] = "<a href=\"".generateEmailLink($content['email'], 'user_data')."\">".$content['surname']." ".$content['family']."</a>";
+ $content['email'] = '<a href="' . generateEmailLink($content['email'], 'user_data') . '">' . $content['surname'] . ' ' . $content['family'] . '</a>';
// Ok, list categories of this user
$result_cats = SQL_QUERY("SELECT `id`, `cat` FROM `{?_MYSQL_PREFIX?}_cats` ORDER BY `sort` ASC", __FILE__, __LINE__);
while ($content = merge_array($content, SQL_FETCHARRAY($result_cats))) {
// Check user's selection
$result_user = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_cats` WHERE `userid`=%s AND `cat_id`=%s LIMIT 1",
- array(bigintval(getRequestElement('userid')), bigintval($content['id'])), __FILE__, __LINE__);
+ array(bigintval(getRequestParameter('userid')), bigintval($content['id'])), __FILE__, __LINE__);
// Set selection
$selection = "<font color=\"#ee0000\">{--NO--}</div>";
}
} else {
// User not found
- loadTemplate('admin_settings_saved', false, sprintf(getMessage('ADMIN_MEMBER_404'), $content['userid']));
+ loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_MEMBER_404', $content['userid']));
}
-
- // Free result
- SQL_FREERESULT($result);
} else {
// Output selection form with all confirmed user accounts listed
addMemberSelectionBox();