LEFT JOIN
`{?_MYSQL_PREFIX?}_sponsor_paytypes` AS sp
ON
- sp.id=so.payid
+ sp.id=so.payment_id
WHERE
- so.sponsorid='%s'
+ so.sponsor_id=%s
ORDER BY
sp.pay_name ASC",
array($content['id']), __FILE__, __LINE__);
// Send warnings out?
if ($REFERAL['receive_warnings'] == 'Y') {
// Send notification to referal
- $REF_MSG = loadEmailTemplate('sponsor_ref_notify', $REFERAL);
- sendEmail($REFERAL['email'], '{--SPONSOR_REF_NOTIFY_SUBJECT--}', $REF_MSG);
+ $REFERAL_MSG = loadEmailTemplate('sponsor_ref_notify', $REFERAL);
+ sendEmail($REFERAL['email'], '{--SPONSOR_REFERAL_NOTIFY_SUBJECT--}', $REFERAL_MSG);
} // END - if
// Free memory
} // END - if
} // END - if
- // Transfer data to array
- $content['points'] = translateComma($content['points_amount']);
-
// So let's send the email away
$message = loadEmailTemplate('sponsor_unlocked', $content);
sendEmail($content['email'], '{--SPONSOR_UNLOCKED_SUBJECT--}', $message);
FROM
`{?_MYSQL_PREFIX?}_sponsor_data`
WHERE
- `status`='PENDING'
+ `status`='PENDING' OR `status`='UNCONFIRMED'
ORDER BY
`id`", __FILE__, __LINE__);
// Entries found so let's list them!
$OUT = '';
while ($content = SQL_FETCHARRAY($result)) {
- // Transfer data to array
- $content = array(
- 'id' => $content['id'],
- 'gender' => $content['gender'],
- 'surname' => $content['surname'],
- 'family' => $content['family'],
- 'email' => generateEmailLink($content['email'], 'sponsor_data'),
- 'remote_addr' => $content['remote_addr'],
- 'sponsor_created' => generateDateTime($content['sponsor_created'], 2),
- );
+ // Translate some data
+ $content['sponsor_created'] = generateDateTime($content['sponsor_created'], 2);
// Load row template and switch colors
$OUT .= loadTemplate('admin_unlock_sponsor_row', true, $content);