/** * 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."); } });
Dhrubo Mitra
Ta bort kommentar
Är du säker på att du vill ta bort den här kommentaren?
amir hamza
Ta bort kommentar
Är du säker på att du vill ta bort den här kommentaren?