Superfluous SQL query rewritten to getUserData() call

[mailer.git] / inc / modules / member / what-welcome.php

diff --git a/inc/modules/member/what-welcome.php b/inc/modules/member/what-welcome.php
index 82e42d8691fc0f6c1d5ebb67effb5078fec80323..534f2f9a388de4b63276fcd236066d9c9b2580a1 100644 (file)
--- a/inc/modules/member/what-welcome.php
+++ b/inc/modules/member/what-welcome.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009, 2010 by Mailer Developer Team                    *
+ * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -54,11 +54,8 @@ $content = array(
 // Load header template
 loadTemplate('member_welcome_header', false, $content);
 
-// Chedk if he is returning from a profile update notification
-$result = SQL_QUERY_ESC("SELECT userid FROM `{?_MYSQL_PREFIX?}_user_data` WHERE notified='Y' AND `userid`=%s LIMIT 1",
-       array(getMemberId()), __FILE__, __LINE__);
-
-if ((SQL_NUMROWS($result) == 1) && (isExtensionActive('profile'))) {
+// Check if he is returning from a profile update notification
+if ((getUserData('notified') == 'Y') && (isExtensionActive('profile'))) {
        // Yes, he is so let's place him his wanted buttons
        loadTemplate('member_profile_outdated');
 } else {
@@ -66,9 +63,6 @@ if ((SQL_NUMROWS($result) == 1) && (isExtensionActive('profile'))) {
        loadTemplate('member_welcome');
 }
 
-// Free memory
-SQL_FREERESULT($result);
-
 // Load footer template
 loadTemplate('member_welcome_footer');