<?xml version="1.0" ?>
<mosinstall type="component">
  <name>MaMML</name>
  <creationDate>2005-06-03</creationDate>
  <author>Schmalls / Joshua Thompson</author>
  <copyright>© 2004-2005 Schmalls / Joshua Thompson / All Rights Reserved</copyright>
  <license>http://www.gnu.org/copyleft/gpl.html GNU/GPL</license>
  <authorEmail>schmalls@gmail.com</authorEmail>
  <authorUrl>http://www.schmalls.com</authorUrl>
  <version>0.4.12</version>
  <description>Mailing List / Newsletter component for Mambo 4.5.x</description>
  <files>
    <filename>mamml.php</filename>
    <filename>mamml.html.php</filename>
    <filename>languages/english.php</filename>
    <filename>languages/dutch.php</filename>
    <filename>languages/french.php</filename>
    <filename>languages/germanf.php</filename>
    <filename>languages/russian.php</filename>
  </files>
  <install>
    <queries>
      <query>
        CREATE TABLE IF NOT EXISTS `#__mamml_letters` (
            `id` int(10) NOT NULL auto_increment,
            `list_name` varchar(32) NOT NULL default '',
            `list_desc` text NOT NULL,
            `sendername` varchar(32) NOT NULL default '',
            `senderemail` varchar(64) NOT NULL default '',
            `bounceadres` varchar(64) NOT NULL default '',
            `layout` text NOT NULL,
            `subscribemessage` text NOT NULL,
            `unsubscribemessage` text NOT NULL,
            `html` tinyint(1) NOT NULL default '0',
            `hidden` tinyint(1) NOT NULL default '0',
            PRIMARY KEY  (`id`),
            UNIQUE KEY `list_name` (`list_name`)
          ) TYPE=MyISAM;
      </query>
      <query>
        CREATE TABLE IF NOT EXISTS `#__mamml_mailing` (
          `list_id` int(11) NOT NULL default '0',
          `send_date` datetime NOT NULL default '0000-00-00 00:00:00',
          `list_subject` varchar(100) NOT NULL default '',
          `list_content` text NOT NULL,
          `list_textonly` text NOT NULL,
          `attachments` text NOT NULL,
          `published` tinyint(1) NOT NULL default '0',
          `visible` tinyint(1) NOT NULL default '1',
          PRIMARY KEY  (`list_id`,`send_date`)
        ) TYPE=MyISAM;
      </query>
      <query>
        CREATE TABLE IF NOT EXISTS `#__mamml_stats_detailed` (
          `listid` int(11) NOT NULL default '0',
          `send_date` datetime NOT NULL default '0000-00-00 00:00:00',
          `subscriber_id` int(11) NOT NULL default '0',
          `html` tinyint(1) NOT NULL default '0',
          `read` tinyint(1) NOT NULL default '0',
          UNIQUE KEY `listid` (`listid`,`send_date`,`subscriber_id`)
        ) TYPE=MyISAM;
      </query>
      <query>
        CREATE TABLE IF NOT EXISTS `#__mamml_stats_detailed_unregistered` (
          `listid` int(11) NOT NULL default '0',
          `send_date` datetime NOT NULL default '0000-00-00 00:00:00',
          `subscriber_id` int(11) NOT NULL default '0',
          `html` tinyint(1) NOT NULL default '0',
          `read` tinyint(1) NOT NULL default '0',
          UNIQUE KEY `listid` (`listid`,`send_date`,`subscriber_id`)
        ) TYPE=MyISAM;
      </query>
      <query>
        CREATE TABLE IF NOT EXISTS `#__mamml_stats_overall` (
          `listid` int(11) NOT NULL default '0',
          `send_date` datetime NOT NULL default '0000-00-00 00:00:00',
          `html_sent` int(11) NOT NULL default '0',
          `text_sent` int(11) NOT NULL default '0',
          `html_read` int(11) NOT NULL default '0',
          UNIQUE KEY `listid` (`listid`,`send_date`)
        ) TYPE=MyISAM;
      </query>
      <query>
        CREATE TABLE IF NOT EXISTS `#__mamml_subscribers` (
          `subscriber_id` varchar(12) NOT NULL default '0',
          `receive_html` tinyint(1) NOT NULL default '0',
        `confirmed` tinyint(1) NOT NULL default '1',
          `subscribe_date` datetime NOT NULL default '0000-00-00 00:00:00',
          PRIMARY KEY  (`subscriber_id`)
        ) TYPE=MyISAM;
      </query>
      <query>
        CREATE TABLE IF NOT EXISTS `#__mamml_unregistered` (
          `unregistered_id` int(11) NOT NULL auto_increment,
          `name` varchar(64) NOT NULL default '',
          `email` varchar(64) NOT NULL default '',
          `receive_html` tinyint(1) NOT NULL default '0',
          `confirmed` tinyint(1) NOT NULL default '0',
          `subscribe_date` datetime NOT NULL default '0000-00-00 00:00:00',
          PRIMARY KEY (`unregistered_id`),
          UNIQUE KEY `email` (`email`)
        ) TYPE=MyISAM;
      </query>
    </queries>
  </install>
  <uninstall>
  </uninstall>
  <installfile>install.mamml.php</installfile>
  <uninstallfile>uninstall.mamml.php</uninstallfile>
  <administration>
    <menu>MaMML</menu>
    <submenu>
      <menu act="newsletter">Управление новостями</menu>
      <menu act="registered">Зарегистрированые подписчики</menu>
      <menu act="unregistered">Незарегистрированые подписчики</menu>
      <menu act="mailing">Управление рассылками</menu>
      <menu act="statistics">Статистика</menu>
      <menu act="configuration">Конфигурация</menu>
      <menu act="update">Обновить</menu>
    </submenu>
    <files>
      <filename>admin.mamml.php</filename>
      <filename>admin.mamml.html.php</filename>
      <filename>toolbar.mamml.php</filename>
      <filename>toolbar.mamml.html.php</filename>
      <filename>configuration.php</filename>
      <filename>mamml.version.php</filename>
      <filename>classes/class.mailing.php</filename>
      <filename>classes/class.subscribers.php</filename>
      <filename>classes/class.phpmailer.php</filename>
      <filename>classes/class.smtp.php</filename>
      <filename>mamml.png</filename>
      <filename>images/configuration.png</filename>
      <filename>images/documentation.png</filename>
      <filename>images/mailing.png</filename>
      <filename>images/newsletter.png</filename>
      <filename>images/registered.png</filename>
      <filename>images/statistics.png</filename>
      <filename>images/unregistered.png</filename>
      <filename>images/update.png</filename>
    </files>
  </administration>
</mosinstall>