New function fetchUserData() introduced to API, total rewrite (not all)

[mailer.git] / inc / modules / admin / what-list_cats.php

diff --git a/inc/modules/admin/what-list_cats.php b/inc/modules/admin/what-list_cats.php
index 7aaf18c3f9a88c7c12e5c8841f9755206256e6cb..f5eeb03c7b0e8da874d112166f753fd65ed23921 100644 (file)
--- a/inc/modules/admin/what-list_cats.php
+++ b/inc/modules/admin/what-list_cats.php
@@ -47,11 +47,9 @@ addMenuDescription('admin', __FILE__);
 
 if (isGetRequestElementSet('userid')) {
        // Check if the user already exists
 
 if (isGetRequestElementSet('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(getRequestElement('userid'))) {

                // Loads surname, family's name and the email address
                // 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&amp;userid=");
 
                // Prepare constants
                // @TODO No longer needed? define('__CATS_BASE'   , "<a href=\"{?URL?}/modules.php?module=admin&amp;userid=");


@@ -100,9 +98,6 @@ if (isGetRequestElementSet('userid')) {
                // User not found
                loadTemplate('admin_settings_saved', false, sprintf(getMessage('ADMIN_MEMBER_404'), $content['userid']));
        }
                // User not found
                loadTemplate('admin_settings_saved', false, sprintf(getMessage('ADMIN_MEMBER_404'), $content['userid']));
        }

-
-       // Free result
-       SQL_FREERESULT($result);

 } else {
        // Output selection form with all confirmed user accounts listed
        addMemberSelectionBox();
 } else {
        // Output selection form with all confirmed user accounts listed
        addMemberSelectionBox();