So finaly. i made it work for me.
I made a few changes in different Files.
1. Give Send_Email-function the User_ID
As written above the UserID is always 0. Got to File Prepare_Data_For_Insertion.php in line 96 should be this code:
if ($Sign_Up_Email == "Yes") {EWD_FEUP_Send_Email($User_Fields, $Additional_Fields_Array);}
change it to
if ($Sign_Up_Email == "Yes") {EWD_FEUP_Send_Email($User_Fields, $Additional_Fields_Array, $User_ID);}
2. Edit the Confirm Link
This is necessary to get to the “Thanks for confirming”-message an not to the register form again.
Same file (Prepare_Data_For_Insertion.php) in the function EWD_FEUP_Send_Email there scold be this this lines (145):
if (strpos($PageLink, "?") !== false) {
$ConfirmationLink = $PageLink . "&User_ID=" . $User_ID . "&ConfirmationCode=" . $ConfirmationCode;
}
else {
$ConfirmationLink = $PageLink . "?User_ID=" . $User_ID . "&ConfirmationCode=" . $ConfirmationCode;
}
I changed it like this:
if (strpos($PageLink, "?") !== false) {
$ConfirmationLink = $PageLink . "&ConfirmEmail=true&UserID=" . $User_ID . "&ConfirmationCode=" . $ConfirmationCode;
}
else {
$ConfirmationLink = $PageLink . "?ConfirmEmail=true&UserID=" . $User_ID . "&ConfirmationCode=" . $ConfirmationCode;
}
Explanation:
In the file Insert_Register_Form i found this line:
if (isset($_GET['ConfirmEmail'])) {ConfirmUserEmail();}
It makes that the Confirm-thing is only done if there is a ConfirmEmail set in URL.
This brings me to another solution:
Simply change this line to:
if (isset($_GET['ConfirmationCode'])) {ConfirmUserEmail();}
This checks if there is a ConfirmationCode in the Link, so you don’t need a ConfirmEmail anymore. (not tested)
3. Change select-wuery to set confirm status
Got to the File Process_Front_End_Forms.php. On the End of this file is the function ConfirmUserEmail. On the beginning of this function there are these three lines:
$User_ID = $_GET[‘UserID’];
$Email_Address = $_GET[‘ConfirmEmail’];
$Confirmation_Code = $_GET[‘ConfirmationCode’];`
The names in the GETs should be exactly the same like in the URL (step 2).
The next line should be this:
$Retrieved_User_ID = $wpdb->get_row($wpdb->prepare("SELECT User_ID FROM $ewd_feup_user_table_name WHERE User_ID=%d AND User_Confirmation_Code=%s", $User_ID, $ConfirmationCode));
change it to:
$Retrieved_User_ID = $wpdb->get_row($wpdb->prepare(“SELECT User_ID FROM $ewd_feup_user_table_name WHERE User_ID=” . $User_ID . ” AND User_Confirmation_Code='” . $Confirmation_Code . “‘”));
<em>Note for the Developers:</em>
Most mistakes come because of different names of variables. Sometimes you’re using ConfirmationCode, sometimes Confirmation_Code. Maybe it would be nice idea to name the same thing always the same ??
PS: Thanks to Pistacho for your help. For me it also works without changing $ConfirmationCode = EWD_FEUP_RandomString();.
