// Generate hash code
$DATA['keys'][] = 'hash';
// @TODO Rewrite this to API function
- $DATA['values'][] = md5(session_id() . getEncryptSeperator() . $postData['email'] . getEncryptSeperator() . detectRemoteAddr() . getEncryptSeperator() . detectUserAgent() . getEncryptSeperator() . time());
+ $DATA['values'][] = md5(session_id() . getEncryptSeparator() . $postData['email'] . getEncryptSeparator() . detectRemoteAddr() . getEncryptSeparator() . detectUserAgent() . getEncryptSeparator() . time());
$DATA['keys'][] = 'remote_addr';
$DATA['values'][] = detectRemoteAddr();
}
// Load main menu entries
$result_main = SQL_QUERY("SELECT
- `action` AS `main_action`,`title` AS `main_title`
+ `action` AS `main_action`,
+ `title` AS `main_title`
FROM
`{?_MYSQL_PREFIX?}_sponsor_menu`
WHERE
while ($content = SQL_FETCHARRAY($result_main)) {
// Load sub menus
$result_sub = SQL_QUERY_ESC("SELECT
- `what` AS `sub_what`,`title` AS `sub_title`
+ `what` AS `sub_what`,
+ `title` AS `sub_title`
FROM
`{?_MYSQL_PREFIX?}_sponsor_menu`
WHERE
$EMAIL = true;
// Okay, has changed then add status with UNCONFIRMED and new hash code
- $sql .= " `status`='EMAIL', `hash`='%s',";
+ $sql .= " `status`='EMAIL',`hash`='%s',";
// Generate hash code
// @TODO Rewrite this to API function
- $HASH = md5(session_id() . getEncryptSeperator() . $postData['email'] . getEncryptSeperator() . detectRemoteAddr() . getEncryptSeperator() . detectUserAgent() . getEncryptSeperator() . time());
+ $HASH = md5(session_id() . getEncryptSeparator() . $postData['email'] . getEncryptSeparator() . detectRemoteAddr() . getEncryptSeparator() . detectUserAgent() . getEncryptSeparator() . time());
$DATA[] = $HASH;
} // END - if
} // END - if
$sql = substr($sql, 0, -1);
// Add last_change
- $sql .= ', `last_change`=NOW()';
+ $sql .= ',`last_change`=NOW()';
// Add SQL tail data
$sql .= " WHERE `id`=%s AND `password`='%s' LIMIT 1";