With MMS FoxBox, publishing photos received by MMS is really easy!


All you need is a normal SIM card MMS enabled. Configure the MMS foxbox to receive message sfrom your operator following MMS CONFIGURATION.
Each time a MMS message was received, MMS FOXBOX will insert Message details  inside the embedded SQLITE database. The db mms.sqlite is located into /mnt/flash/root/db and contains 2 tables:
1- Incoming
2- Media

Table Incoming  fields are: id, subject, fromnum, carboncopy, bcarboncopy, contenttype, timestdel, deliverydate, and messagesize.

id: is the identification provided by the carrier and is unique and used as primary key
subject: is the subject of the MMS message
fromnum: conatins the sender number
carboncopy: contains the number in CC to the MMS (usually NULL)
bcarboncopy: as CC contains the BCC number (usually NULL)
contenttype: type of MMS usually application/vnd.wap.multipart.related
timestdel: is the timestamp of delivery
messagesize: Size of the MMS in Kbytes

Table Media fileds are:
id, mtype, fromnum, ext, filename
id: is the identification provided by the carrier and is unique and used as external key for Incoming to media 1:n relation.
mtype: Is the mime type of the media ex. application/smil, image/jpeg, image/gif or text/plain for the text of the message
fromnum: the number of the sender (usefull for data check and abuse)
ext: the extension of the file.jpg, .gif, .txt etc...
filename: the filename of the media with full path (usefull to switch storage for ex. USB KEY or external harddrive)

All media are saved in /mnt/flash/root/documents and vailable over webdav, FTP and SSH.

The online MMS gallery LIVE DEMO (http://demo.kdev.it/mms.php ) use WEBDAV to publish the DB mms.sqite and all the media on this frontend webserver.

You can administer all databases by connecting to http://YOUR FOXBOX/sqladmin/index.php and execute custom queries, create triggers dump data using SQLITE MANAGER.