<?php
 
session_start();
include "app/php/require.ini.php";
 
if (isset($_GET['email']) && preg_match('/^([a-zA-Z0-9])+([a-zA-Z0-9\._-])*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-]+)+$/', $_GET['email'])) {
	$email = $_GET['email'];
}
if (isset($_GET['key']) && (strlen($_GET['key']) == 32)) {
	$key = $_GET['key'];
}
 
if (isset($email) && isset($key)) {
	$active_defaul = 0;
 
	$stmt = $con->prepare("SELECT * FROM users WHERE email=? AND email_code=? AND active=?");
	$stmt->bind_param("ssi",$email,$key,$active_defaul);
	$stmt->execute();
	$stmt->store_result();
	if ($stmt->num_rows>0) {
		echo "¡La cuenta ya se ha activado o la URL no es válida!";
	} else {
		echo "¡Tu cuenta ha sido activada!";
		$active = 1;
		$stmtA = $con->prepare("UPDATE users SET active=? WHERE email=?");
		$stmtA->bind_param("is",$active,$email);
		$stmtA->execute();
 
	}
 
} else {
	echo "Redirrecionar a otro sitio";
}

PD9waHAKCnNlc3Npb25fc3RhcnQoKTsKaW5jbHVkZSAiYXBwL3BocC9yZXF1aXJlLmluaS5waHAiOwoKaWYgKGlzc2V0KCRfR0VUWydlbWFpbCddKSAmJiBwcmVnX21hdGNoKCcvXihbYS16QS1aMC05XSkrKFthLXpBLVowLTlcLl8tXSkqQChbYS16QS1aMC05Xy1dKSsoW2EtekEtWjAtOVwuXy1dKykrJC8nLCAkX0dFVFsnZW1haWwnXSkpIHsKCSRlbWFpbCA9ICRfR0VUWydlbWFpbCddOwp9CmlmIChpc3NldCgkX0dFVFsna2V5J10pICYmIChzdHJsZW4oJF9HRVRbJ2tleSddKSA9PSAzMikpIHsKCSRrZXkgPSAkX0dFVFsna2V5J107Cn0KCmlmIChpc3NldCgkZW1haWwpICYmIGlzc2V0KCRrZXkpKSB7CgkkYWN0aXZlX2RlZmF1bCA9IDA7CgkKCSRzdG10ID0gJGNvbi0+cHJlcGFyZSgiU0VMRUNUICogRlJPTSB1c2VycyBXSEVSRSBlbWFpbD0/IEFORCBlbWFpbF9jb2RlPT8gQU5EIGFjdGl2ZT0/Iik7Cgkkc3RtdC0+YmluZF9wYXJhbSgic3NpIiwkZW1haWwsJGtleSwkYWN0aXZlX2RlZmF1bCk7Cgkkc3RtdC0+ZXhlY3V0ZSgpOwoJJHN0bXQtPnN0b3JlX3Jlc3VsdCgpOwoJaWYgKCRzdG10LT5udW1fcm93cz4wKSB7CgkJZWNobyAiwqFMYSBjdWVudGEgeWEgc2UgaGEgYWN0aXZhZG8gbyBsYSBVUkwgbm8gZXMgdsOhbGlkYSEiOwoJfSBlbHNlIHsKCQllY2hvICLCoVR1IGN1ZW50YSBoYSBzaWRvIGFjdGl2YWRhISI7CgkJJGFjdGl2ZSA9IDE7CgkJJHN0bXRBID0gJGNvbi0+cHJlcGFyZSgiVVBEQVRFIHVzZXJzIFNFVCBhY3RpdmU9PyBXSEVSRSBlbWFpbD0/Iik7CgkJJHN0bXRBLT5iaW5kX3BhcmFtKCJpcyIsJGFjdGl2ZSwkZW1haWwpOwoJCSRzdG10QS0+ZXhlY3V0ZSgpOwoKCX0KCn0gZWxzZSB7CgllY2hvICJSZWRpcnJlY2lvbmFyIGEgb3RybyBzaXRpbyI7Cn0=