Ok. I just want to make sure this is legit before I try it. I am setting up
mail quotas, and I want to have it pull the quota from a MySQL database. Now
I have a table that looks like this
+----------------+-------+----------+
| uname | quota | pwd |
+----------------+-------+----------+
| dan | 250 | <hidden> |
+----------------+-------+----------+
The quota field is an integer field. My query looks like this:
quota = ${lookup mysql{select quota from mail where
uname='${quote_mysql:local_part}'}{$value}}M
What this is intended to do is scan the database, get the # of megs allowed,
and return it with the M, so in the case above, it would return 250MB
quota.
Is this correct or would this kill me?
Thanks in advance!