Validation code invalid. Please login, re-enter email and try again. Home'; exit; } $userObj = userContextClass::getUser(intval($_GET['userid']), ['fields' => ['playername', 'email', 'email_verified', 'username']]); $userdetails = $userObj->fields()->toDict(); if (!$userdetails) { die("Error"); } $userObj->fields()->setEmail_verified('VALIDATED'); $userObj->saveUser(['email_verified']); //UPDATE THE DETAILED ADVERT TRACKER STATS TO SHOW EMAIL IS CONFIRMED $userID=mimic_escape_string($_GET['userid']); $signup="update adverttracker_details set `email_verified`=1 where userID='$userID'"; DS::q('adverttracker_details', $signup); $query = "INSERT INTO `logs_emailconfirm` ( `userid` , `ver_date`, `ver_IP` , `ver_browser` , `email` , `link` ) VALUES ( '" . mimic_escape_string($_GET['userid']) . "', CURRENT_TIMESTAMP , '" . $ip . "', '" . $_SERVER['HTTP_USER_AGENT'] . "', '" . $userdetails['email'] . "', '" . mimic_escape_string($_SERVER['REQUEST_URI']) . "' ) ON DUPLICATE KEY update ver_date = CURRENT_TIMESTAMP(); "; DS::q('logs_emailconfirm', $query); ?> Email verified'; echo '

Please login at the home page.

Email already verified

Continue to home page'; } echo ''; echo ''; } ?>