I have written a forum application and I want to create message boxes for each user.
For example, user member name is Osama his mail box will be
I have installed postfix on my server and converted imap users to MySQL.
I have a table named
users containing their mail addresses and passwords
I want import their messages to the database.
The normal way to get the messages is connect to imap and get the user messages.
But I want to make it like users and create table named
messages to contain user messages
Then to get messages for a user I would do:
mysql_query("SELECT * FROM messages where mail = $user_mail);
Is there any way to do the import from the mail server using cron jobs or something in postfix?