".print_r($FATAL, true).""); // 01 1 12 3 32 21 1 2 2 10 if (($url_uid) > 0 && (($url_mid > 0) || ($url_bid > 0)) && (count($FATAL) == 0)) { // Maybe he wants to confirm an email? if ($url_mid > 0) { // 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; } 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; } else { // Problem: No ID entered LOAD_URL("index.php"); } if (SQL_NUMROWS($result) == 1) { // Load the entry list($ltype) = SQL_FETCHROW($result); // Clean result SQL_FREERESULT($result); switch ($ltype) { case "NORMAL": // Is the stats ID valid? $result = SQL_QUERY_ESC("SELECT pool_id, url FROM "._MYSQL_PREFIX."_user_stats WHERE id=%d LIMIT 1", array($url_mid), __FILE__, __LINE__); break; case "BONUS": // Bonus-Mails $result = SQL_QUERY_ESC("SELECT id, url FROM "._MYSQL_PREFIX."_bonus WHERE id=%d LIMIT 1", array($url_bid), __FILE__, __LINE__); break; } if (SQL_NUMROWS($result) == 1) { // Load data list($pool, $URL) = SQL_FETCHROW($result); SQL_FREERESULT($result); // Is the user's ID unlocked? $result = SQL_QUERY_ESC("SELECT status, sex, surname, family FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1", array($url_uid), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 1) { list($status, $sex, $sname, $fname) = SQL_FETCHROW($result); SQL_FREERESULT($result); if ($status == "CONFIRMED") { // User has confirmed his account so we can procede... switch ($ltype) { case "NORMAL": $result = SQL_QUERY_ESC("SELECT payment_id FROM "._MYSQL_PREFIX."_user_stats WHERE pool_id=%d LIMIT 1", array(bigintval($pool)), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 1) { list($pay) = SQL_FETCHROW($result); $time = GET_PAY_POINTS($pay, "time"); $payment = GET_PAY_POINTS($pay, "payment"); $VALID = true; } // Free memory SQL_FREERESULT($result); break; case "BONUS": $result = SQL_QUERY_ESC("SELECT points, time FROM "._MYSQL_PREFIX."_bonus WHERE id=%d LIMIT 1", array($url_bid), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 1) { list($points, $time) = SQL_FETCHROW($result); $payment = "0.00000"; $VALID = true; } // Free memory SQL_FREERESULT($result); break; } // Was that mail a valid one? if ($VALID) { // If time is zero seconds we have a sponsor mail. 1 Second shall be set to avoid problems if (($time == "0") && ($payment > 0)) { $URL = URL; $time = "1"; } if (($time > 0) && (($payment > 0) || ($points > 0))) { // He can confirm this mail! // Export data into constants for the template define('_UID_VALUE' , $url_uid); define('_TYPE_VALUE', $type); define('_DATA_VALUE', $DATA); define('_URL_VALUE' , DEREFERER($URL)); // Load template LOAD_TEMPLATE("mailid_frames"); } else { $msg = CODE_DATA_INVALID; } } else { $msg = CODE_POSSIBLE_INVALID; } } else { $msg = CODE_ACCOUNT_LOCKED; } } else { SQL_FREERESULT($result); $msg = CODE_USER_404; } } else { SQL_FREERESULT($result); $msg = CODE_STATS_404; } } else { SQL_FREERESULT($result); $msg = CODE_ALREADY_CONFIRMED; } } else { // Nothing entered $msg = CODE_ERROR_MAILID; } // Error code is set? if (!empty($msg)) { switch ($_CONFIG['mailid_error_redirect']) { case "INDEX": // Redirect to index page LOAD_URL("modules.php?module=index&msg=".$msg); break; case "REJECT": // Redirect to rejection page LOAD_URL($_CONFIG['reject_url']); break; } } else { // Include footer require_once(PATH."inc/footer.php"); } } else { // You have to configure first! LOAD_URL("install.php"); } // Shutdown database link if (is_resource($link)) { SQL_CLOSE($link, __FILE__, __LINE__); } // ?>