Location: PHPKode > projects > TorrentTrader > TorrentTrader-v2.06/upload/account-confirm.php
<?
//
//  TorrentTrader v2.x
//	This file was last updated: 21/June/2007
//	
//	http://www.torrenttrader.org
//
//
// Confirm account Via email and send PM
//
require_once("backend/functions.php");


$id = (int)$_GET["id"];
$md5 = $_GET["secret"];

if (!$id)
	show_error_msg("Error","Thats not a valid ID!",1);

dbconn();

$res = mysql_query("SELECT password, secret, status FROM users WHERE id = $id");
$row = mysql_fetch_array($res);

if (!$row)
	show_error_msg("Error", "No user found with that ID, unconfirmed accounts expire after ".($site_config['signup_timeout']/86400)." days.",1);

if ($row["status"] != "pending") {
	header("Refresh: 0; url=account-confirm-ok.php?type=confirmed");
	exit();
}

$sec = $row["secret"];

if ($md5 != md5($sec))
	show_error_msg("Error","There has been a problem with your activation link",1);

$newsec = mksecret();

mysql_query("UPDATE users SET secret=" . sqlesc($newsec) . ", status='confirmed' WHERE id=$id AND secret=" . sqlesc($row["secret"]) . " AND status='pending'");

if (!mysql_affected_rows())
	show_error_msg("Error","Unable to activate account please contact a admin",1);

header("Refresh: 0; url=account-confirm-ok.php?type=confirm");
?>
Return current item: TorrentTrader