From 35d505439eacf99f4e1052ad9656adeeaade394a Mon Sep 17 00:00:00 2001 From: Jean-Marc Pigeon Date: Sat, 15 Nov 2025 23:16:44 -0500 Subject: [PATCH] Adjusting updpass trigger definition --- sql/mailleur.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/mailleur.sql b/sql/mailleur.sql index fbf3b31..550978d 100644 --- a/sql/mailleur.sql +++ b/sql/mailleur.sql @@ -179,8 +179,8 @@ CREATE FUNCTION updpass() IF NEW.password IS NULL OR length(trim(NEW.password)) = 0 OR substring(NEW.password,1,1) = '$' THEN - set NEW.hash=NULL; - set NEW.password=NEW.password; + NEW.hash=NULL; + NEW.password=NEW.password; ELSE NEW.hash = md5(HASHING); NEW.password = crypt (NEW.password,gen_salt('md5')); -- 2.47.3