I need a thunderbird extension written to enable messages to be right clicked and saved to a mysql database with most of the separate email header items in separate fields in the database as well as the raw message in a field
The extension UI should provide configurable mysql server, username, password, and table.
The extension UI should give a right click option on a message in thunderbird index view or a button on toolbar while message is highlighted 'Archive', whereafter a dialog is presented to to select the record from a separate table in same database to store an id with the email record in the database( ie we are storing emails in a database linked to a specific property or asset id number in a separate table in the database, so you would select the email and right click and select archive and then get dialog with select box to select property to save email to using id of that property in the email record in the email table)
I will provide a mysql schema for the stored emails as well as the corresponding table to get the id of the related record from.
I have created this same system as a squirrelmail plugin already, but some of our users want to be able to use a real desktop client and this would be essential for them to do so. All of the machines running this extension will be in local intranet so direct access to mysql with a user and pass over port 3306 will be available to the extension.
The extension would also set a special imap flag 'filed' after the message has succesfully been saved to database
Extension only needs to be in english, no localization necessary. Must have at least a little graceful error checking for:
no connection to database with descriptive message(ie bad username access denied, cannot reach host, etc)
Software should be delivered as an xpi as well as regular zip file containing all files.
Software should be compatible with thunderbird [url removed, login to view] and mysql server [url removed, login to view](it is on a debian etch box)
please be fluent in english
schemas for two involved tables attached