perl plugin to write to a mysql db

This project is simple. Write a plugin for my website that allows users to create and edit entries in a database. The website in question is running virtualmin. ## Deliverables This is what needs doing: (the scope has been changed as i've done half the work myself since I require a working email system) <strike>1) Setup Postfix and Dovecot to use a mysql (or other appropriate dbm) database for users and mail mappings. A tutorial is avaliable here, but will need modifying to suit my exact needs: [login to view URL] 1a) Provide detailed step by step instructions on how to replicate this on my virtualmin setup.</strike> I had need for email to be working so did this part myself. 2) The major part: Provide a virtualmin plugin which does the following: - Gives virtual server admins an interface to create, list update and delete email accounts for the domain(s) they own. - Virtual server admins should only be able to add virtual mail users eg the accounts they create shouldn't create matching system accounts. - All email accounts should be stored in the mysql database. - Mail recieved in these accounts should be stored relative to the home directory of the owning virtual server. <strike>2a) Module should install and configure itself (create the needed tables mysql users etc) </strike>All the tables have been created when i did part 1, module should still provide required installation stuff but for my uses, no longer needs to worry about creating tables. <strike> 2b) It is desirable that virtual users can still login to usermin to read their mail.</strike> This is impossible to do - have already tried :P <strike>3) optional extra: It would be really nice if you could import all my emails (about 20-30 accounts) into this new system.</strike> By the time the plugin is functional i'll probably have done this already. I am a programmer myself, i'm just too busy to devote any more time to resolving these server issues at the moment, the plugin is a fairly simple one probably no more than a days work. I need this plugin doing as soon as possible and as cheaply as possible however it needs to be done well. I will be inspecting your source code as well as the functionallity of the plugin before releasing funds. The plugin will probably be of use to a great number of other people, I'm willing to negotiate a shared copywrite on the finial code and allow you to sell the plugin to other buyers if this is something you'd be interested in doing. Until a finial coder is selected, any questions asked and answered may be posted up here to help other bidders. <hr /> <b>A better description of requirements</b> I envisage something like this: The plugin (using the api) will add a link somewhere appropriate to virtualmin or webmin that says 'Manage email addresses' That page will have 4 links on it: -Add email alias -Add email account -Set catch all address -List email accounts Add email alias will allow (by typing or select box) the user to add an email address that to the aliases table, two addresses will be required from the user <email> and <destination> <destination> should already exist either as a virtual mailbox or as the default email address which is <accountname>[at]<domainname> <email> should not exist as a virtual mailbox, nor should it be the default account. Adding an email account is a little bit more involved but only slightly. The form should ask for an address and a password, the email address shouldnt already exist. The virtual_mailboxes table then needs populating with: email address, password, mailbox path (value should be domain/user/) system account name, and the uid and gid of the system account. Setting a catchall address: this is essentially just an alias however the email part of it must be set as [at]<domain> Listing accounts: all accounts belonging to the domain should be shown with options to delete, change password or show login details. The default mail address should also be shown but without the option to delete it or change the password. deleting should remove the entry from the database and remove the dir ~/var/mail/<domain>/<user> and should provide a confirmation screen informing the user that if they delete the account all emails will be lost. change password is obvious. show login details should display a screen listing pop3/imap configuration details. Currently the details that should be shown are: [h3]pop3[h3]: server: mail.<domain> port: 110 username: <email address> OR for the default account <username> (for default account only)password: Your virtualmin password (should be text not the acctual password) [h3]imap[/h3] same as pop3 but with port:143 I may want/need to change the items on that screen at some point, so make sure that part of the code is well commented.