* 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 *
// Sponsor found, load his data...
$data = SQL_FETCHARRAY($result);
- // Translate gender and comma
- $data['gender'] = translateGender($data['gender']);
- $data['points'] = translateComma($data['points']);
- $data['pay'] = translateComma($data['pay']);
-
// Unconfirmed account or changed email address?
if ($data['status'] == 'UNCONFIRMED') {
// Set account to pending
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `status`='PENDING'
-WHERE `id`='%s' AND hash='%s' AND `status`='UNCONFIRMED' LIMIT 1",
- array(bigintval($data['id']), getRequestParameter('hash')), __FILE__, __LINE__);
+ SQL_QUERY_ESC("UPDATE
+ `{?_MYSQL_PREFIX?}_sponsor_data`
+SET
+ `status`='PENDING'
+WHERE
+ `id`=%s AND
+ hash='%s' AND
+ `status`='UNCONFIRMED'
+LIMIT 1",
+ array(
+ bigintval($data['id']),
+ getRequestParameter('hash')
+ ), __FILE__, __LINE__);
// Check on success
if (SQL_AFFECTEDROWS() == 1) {
$data = SQL_FETCHARRAY($result);
// Translate some data
- $data['gender'] = translateGender($data['gender']);
$data['sponsor_created'] = generateDateTime($data['sponsor_created']);
// Prepare email and send it to the sponsor