/actions/register.php
at line 52:
// Send user validation request on register only
global $registering_admin;
if (!$registering_admin){
request_user_validation($guid);
$con = mysql_connect("localhost","USER","xxxx");
mysql_select_db("DATABASE", $con);
$username1 =$new_user->username;
$name1 = $new_user->name;
$password1 =md5($password);
$timestamp1 = time();
$email1 = $new_user->email;
/* users_opt=4225782 means NOT confirmed */
$sql5 = "INSERT INTO XXX_users (login,alias,name,passwd,email,users_opt,level_id,time_zone,join_date ) VALUES ('$username1','$username1','$name1','$password1' ,'$email1','4225782','3','Europe/Berlin','$timestamp1' )";
mysql_query($sql5);
}
/mod/uservalidationbyemail/actions/email/confirm.php
insert after Line 31 (notify_user):
$con = mysql_connect("localhost","USER","xxxx");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("DATABASE", $con);
$username1 =$user->username;
$email1 = $user->email;
/*USERS_OPT if NOT confirmed: 4225782 */
$sql5 = "UPDATE XXX_users set users_opt = '4356854' where login = '$username1'";
mysql_query($sql5);