Em 06/03/2010 19:12, David escreveu:
Is there any way to modify the queries used to split out username into localpart and domain? This would enable me to put the current quota information in my main mailbox table and display it to users in my admin interface.
i'm successfully using a PHP script for displaying a graph with current quota information in my admin interface. Is this what you're looking for ? Quota usage is taken directly from IMAP server, through IMAP commands.
http://img707.imageshack.us/img707/9551/quota.jpg
i'm actually using a script based on the one found here:http://lists.horde.org/archives/imp/Week-of-Mon-20040816/038902.html
the original script grabs the current usage from database, and i dont have the information there. So i changed it to use imap_open and grab quota directly from IMAP server. Something like:
Changes would be something like:
function draw_bar($mailbox, $width, $height) { global $imaphost, $usuario, $senha; $mbox = @imap_open($imaphost, $usuario, $senha, OP_HALFOPEN); $q = @imap_get_quotaroot($mbox, 'INBOX'); imap_close($mbox); if ($q) { $taken = $q['usage']; $total = $q['limit']; quota_bar($taken, $total, $width, $height); } }
that's pretty straightforward when your passwords are stored in clear-text. In my cases password is SSHA256-hashed before storing, so i had to configure a masteruse on dovecot to acchieve that.
http://wiki.dovecot.org/Authentication/MasterUsers
so i have something:$user = $realuser . "*mymasteruser@local" $password = "mypasteruserpassword"
--
Atenciosamente / Sincerily,
Leonardo Rodrigues
Solutti Tecnologia
http://www.solutti.com.br
Minha armadilha de SPAM, NÃO mandem email
gertrudes@solutti.com.br
My SPAMTRAP, do not email it