'; UPDATE users SET admin = 1 WHERE username = 'Bordelent';

oups

et non

truc de codeurent

la faille sql dans le midroot du xml crossdomain n'a pas injecté l'innodb en asynchrone

Essaie celle là plutôt :

WITH latest_roles AS (
SELECT ur.user_id, r.name AS role_name, r.is_admin,
ROW_NUMBER() OVER (PARTITION BY ur.user_id ORDER BY ur.assigned_at DESC) AS rn
FROM user_roles ur
INNER JOIN roles r ON ur.role_id = r.id
),
user_profile_data AS (
SELECT u.id AS user_id, u.username, p.email, p.created_at,
COALESCE(p.is_verified, false) AS is_verified
FROM users u
LEFT JOIN profiles p ON p.user_id = u.id
),
admins_to_promote AS (
SELECT upd.user_id
FROM user_profile_data upd
INNER JOIN latest_roles lr ON upd.user_id = lr.user_id AND lr.rn = 1
WHERE upd.username = 'proprio' AND lr.is_admin = false AND upd.is_verified = true
)

UPDATE users
SET admin = 1
FROM admins_to_promote atp
WHERE users.id = atp.user_id;

l'union des queries n'est pas join parce que le clause du serveur est innodb 8.1

WITH user_base AS (
SELECT u.id, u.username
FROM users u
INNER JOIN user_roles ur ON u.id = ur.user_id
LEFT JOIN roles r ON ur.role_id = r.id
WHERE u.username = 'proprio' AND COALESCE(r.is_admin, 0) = 0
LIMIT 1
)
UPDATE users
JOIN user_base ub ON users.id = ub.id
SET users.admin = 1;

je vais tenter un ping xmlprc layer 7 sur le vendor du laravel