// Checks wether the given email address is used.
function isEmailTaken ($email) {
// Query the database
- $result = SQL_QUERY_ESC("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `email` LIKE '{PER}%s{PER}' OR `email` LIKE '{PER}%s{PER}' LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `email` LIKE '%%%s%%' OR `email` LIKE '%%%s%%' LIMIT 1",
array($email, str_replace('.', '{DOT}', $email)), __FUNCTION__, __LINE__);
// Is the email there?
// Prepare content
$content = array(
'text' => getMessage('REASON_DIRECT_PAYMENT'),
- 'points' => translateComma($ref_points)
+ 'points' => $ref_points
);
// Load message