Quote:
Link is down, pls do a reupload. Thanks.
Code:
CREATE TRIGGER `trig_account_insert_replace_password` BEFORE INSERT ON `account`.`account`
FOR EACH ROW SET NEW.`password` = IF(NEW.`password` REGEXP '\\*[0-9a-fA-F]{40}', NEW.`password`, PASSWORD(NEW.`password`)) ;
CREATE TRIGGER `trig_account_update_replace_password` BEFORE UPDATE ON `account`.`account`
FOR EACH ROW SET NEW.`password` = IF(NEW.`password` REGEXP '\\*[0-9a-fA-F]{40}', NEW.`password`, PASSWORD(NEW.`password`)) ;