// Normal-Mails
$result = SQL_QUERY_ESC("SELECT link_type FROM "._MYSQL_PREFIX."_user_links WHERE stats_id=%d AND userid=%d LIMIT 1",
array($url_mid, $url_uid), __FILE__, __LINE__);
- $TYPE = "mailid"; $DATA = $url_mid;
+ $type = "mailid"; $DATA = $url_mid;
}
elseif ($url_bid > 0)
{
// Bonus-Mail
$result = SQL_QUERY_ESC("SELECT link_type FROM "._MYSQL_PREFIX."_user_links WHERE bonus_id=%d AND userid=%d LIMIT 1",
array($url_bid, $url_uid), __FILE__, __LINE__);
- $TYPE = "bonusid"; $DATA = $url_bid;
+ $type = "bonusid"; $DATA = $url_bid;
}
else
{
}
if (SQL_NUMROWS($result) == 1)
{
+ // Load the entry
list($ltype) = SQL_FETCHROW($result);
+
+ // Clean result
SQL_FREERESULT($result);
switch ($ltype)
{
// He can confirm this mail!
// Export data into constants for the template
define('_UID_VALUE' , $url_uid);
- define('_TYPE_VALUE', $TYPE);
+ define('_TYPE_VALUE', $type);
define('_DATA_VALUE', $DATA);
define('_URL_VALUE' , DEREFERER($URL));