Rewrites/fixes for handling config entries in SQLs

[mailer.git] / lead-confirm.php

diff --git a/lead-confirm.php b/lead-confirm.php
index 6f2b0ef79d55ce252b547cc943234fc4062a2c95..65a1ecfa7c75f2c704694dcd6903799003533f9e 100644 (file)
--- a/lead-confirm.php
+++ b/lead-confirm.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 05/14/2007 *
- * ===============                              Last change: 05/14/2007 *
+ * Mailer v0.2.1-FINAL                                Start: 05/14/2007 *
+ * ===================                          Last change: 05/14/2007 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : lead-confirm.php                                 *
@@ -18,6 +18,7 @@
  * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
+ * Copyright (c) 2009, 2010 by Mailer Developer Team                    *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -69,17 +70,15 @@ $content = array(
 // Is the cookie set?
 if (isSessionVariableSet('lead_userid')) {
        // Is the user-account unlocked and valid?
-       $result = SQL_QUERY_ESC("SELECT `email` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s AND `status`='CONFIRMED' LIMIT 1",
-               array(bigintval(getSession('lead_userid'))), __FILE__, __LINE__);
-       if (SQL_NUMROWS($result) == 1) {
-               // Secure the ID number
+       if (fetchUserData(getSession('lead_userid'))) {
+               // Secure the id number
                $content['lead_userid'] = bigintval(getSession('lead_userid'));
 
                // Load the email address
-               list($email) = SQL_FETCHROW($result);
+               $content['lead_email'] = getUserData('email');
        } else {
                // Not found!
-               $content['lead_userid'] = 0;
+               $content['lead_userid'] = '0';
        }
 } else {
        // Maybe spider?