* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
* Copyright (c) 2009 - 2011 by Mailer Developer Team *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
* Copyright (c) 2009 - 2011 by Mailer Developer Team *
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
// Remove last ", " from SQL string
$sql = substr($sql, 0, -2)." WHERE `id`=%s LIMIT 1";
// Remove last ", " from SQL string
$sql = substr($sql, 0, -2)." WHERE `id`=%s LIMIT 1";
case 'added': // Sponsor successfully added with account status = UNCONFIRMED!
// Check for his id number
$result = SQL_QUERY_ESC("SELECT `id`,`hash` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE '%s' REGEXP `email` LIMIT 1",
case 'added': // Sponsor successfully added with account status = UNCONFIRMED!
// Check for his id number
$result = SQL_QUERY_ESC("SELECT `id`,`hash` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE '%s' REGEXP `email` LIMIT 1",
if (SQL_NUMROWS($result) == 1) {
// id found so let's load it for the confirmation email
list($id, $hash) = SQL_FETCHROW($result);
if (SQL_NUMROWS($result) == 1) {
// id found so let's load it for the confirmation email
list($id, $hash) = SQL_FETCHROW($result);
- $content['email'] = postRequestParameter('email');
- $content['surname'] = postRequestParameter('surname');
- $content['family'] = postRequestParameter('family');
+ $content['email'] = postRequestElement('email');
+ $content['surname'] = postRequestElement('surname');
+ $content['family'] = postRequestElement('family');
// Generate email and send it to the new sponsor
$message = loadEmailTemplate('sponsor_confirm', $content, $id);
// Generate email and send it to the new sponsor
$message = loadEmailTemplate('sponsor_confirm', $content, $id);