<?php
if(!$_GET['id']) { 
	exit(); 
}

    $id = mysqli_real_escape_string($dbconn, $_GET['id']);
    $result = dbQuery("SELECT * FROM users WHERE validate = '$id' AND validate != ''",false);

    if (!is_array($result)) {

        setMessage(_t('Invalid validation code!'), 'error');

    } else {

        setMessage(_t('Your account has been successfully verified, and you may now <a href="%url">login</a>', array('%url' => "$basehttp/login")));



        $user = dbRow("SELECT record_num FROM users WHERE validate = '$id'");

        dbQuery("UPDATE users SET validate = '', email_verified = 1, session_reload = 1 WHERE validate = '$id'");

        

        sendEmail('email-verified', $user['record_num']);

    }

?>