Nice. This looks perfect. I really appreciate it.
Does mysql 4.1 support the MD5 call? --- Urtho <[EMAIL PROTECTED]> wrote: > >> Frogger wrote: > >> > If I am interested in doing my own insert into > the > >> > openser db how should I calculate the following > >> > fields: > >> > > >> > ha1 ha2 > >> > > > I use the following trigger in a setup with domain > support and MySQL 5.0 : > > CREATE TRIGGER `tr_insert_subscriber` BEFORE INSERT > ON `subscriber` FOR EACH ROW > BEGIN > SET NEW.ha1 = > MD5(CONCAT(NEW.username,':',NEW.domain,':',NEW.password)); > SET NEW.ha1b = > MD5(CONCAT(NEW.username,'@',NEW.domain,':',NEW.domain,':',NEW.password)); > END > > > -- > Regards, > Pawel Pierscionek > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ Users mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/users
