SK Tushar

/** * Plugin: Google Login Blacklist Check (MySQLi - Linkeei) * Description: Blocks Google login if email is blacklisted (from DB). * Author: Linkeei Dev */ add_hook('james_hook_before_register', function($data) { global $wo; $marker = $data['marker'] ?? ''; $user = $data['user_data'] ?? []; if ($marker !== 'login-with-google') { return; } $email = strtolower(trim($user['email'] ?? '')); if (empty($email)) { throw new Exception("Login blocked: Email is missing."); } $conn = $wo['sqlConnect']; // Use Linkeei's connection // Escape and prepare the query $email_escaped = mysqli_real_escape_string($conn, $email); $query = "SELECT COUNT(*) as count FROM JAMES_blacklisted_emails WHERE LOWER(email) = LOWER('$email_escaped')"; $result = mysqli_query($conn, $query); if ($result) { $row = mysqli_fetch_assoc($result); if ((int)$row['count'] > 0) { throw new Exception("Login blocked: Your email is blacklisted."); } } else { throw new Exception("Login blocked: DB error."); } }); SK Tushar