[Users] ha1 ha2

[Frogger]

Nice.

This looks perfect.  I really appreciate it.

Does mysql 4.1 support the MD5 call?



--- Urtho <junk at urtho.net> 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