|
From: Greg M. <bli...@us...> - 2008-01-02 21:59:53
|
Update of /cvsroot/phpwebsite-comm/modules/mailinglists/boost In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3572/boost Modified Files: install.sql uninstall.php update.php Added Files: about.html boost.php controlpanel.php dependency.xml permission.php Removed Files: install.php uninstall.sql Log Message: Committing complete rewrite which supports phpWebSite 1.x Index: uninstall.php =================================================================== RCS file: /cvsroot/phpwebsite-comm/modules/mailinglists/boost/uninstall.php,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** uninstall.php 12 Sep 2005 00:36:09 -0000 1.7 --- uninstall.php 2 Jan 2008 21:59:24 -0000 1.8 *************** *** 10,19 **** * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. ! * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. ! * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software --- 10,19 ---- * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. ! * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. ! * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software *************** *** 24,37 **** */ ! if (!$_SESSION['OBJ_user']->isDeity()){ ! header('location:index.php'); ! exit(); ! } ! if ($status = $GLOBALS['core']->sqlImport(PHPWS_SOURCE_DIR . 'mod/mailinglists/boost/uninstall.sql', 1, 1)) { ! $content .= 'All Mailing List tables successfully removed.<br />'; ! $_SESSION['SES_MAILINGLISTS_MANAGER'] = NULL; ! } else { ! $content .= 'There was a problem accessing the database.<br />'; } --- 24,37 ---- */ ! function mailinglists_uninstall(&$content) ! { ! PHPWS_DB::dropTable('mailinglists_lists'); ! PHPWS_DB::dropTable('mailinglists_subscribers'); ! PHPWS_DB::dropTable('mailinglists_emails'); ! PHPWS_DB::dropTable('mailinglists_queue'); ! $content[] = dgettext('mailinglists', 'Database tables removed.'); ! ! return true; } --- NEW FILE: dependency.xml --- <?xml version="1.0"?> <dependency> <module> <title>core</title> <properName>phpWebSite Core</properName> <version>1.7.1</version> <url>http://phpwebsite.appstate.edu/downloads/modules/base/</url> </module> </dependency> --- NEW FILE: permission.php --- <?php /** * Mailing Lists - phpWebSite Module * * See docs/credits.txt for copyright information * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * * @version $Id: permission.php,v 1.1 2008/01/02 21:59:24 blindman1344 Exp $ * @author Greg Meiste <blindman1344 [at] users dot sourceforge dot net> */ $use_permissions = TRUE; $permissions['edit_lists'] = dgettext('mailinglists', 'Edit Lists'); $permissions['delete_lists'] = dgettext('mailinglists', 'Delete Lists'); $permissions['hide_lists'] = dgettext('mailinglists', 'Hide Lists'); $permissions['send_emails'] = dgettext('mailinglists', 'Send Emails'); $permissions['saved_emails'] = dgettext('mailinglists', 'Saved Emails Admin'); $permissions['change_settings'] = dgettext('mailinglists', 'Change Settings'); $permissions['subscriber_admin'] = dgettext('mailinglists', 'Subscriber Admin'); $item_permissions = FALSE; ?> --- NEW FILE: boost.php --- <?php /** * Mailing Lists - phpWebSite Module * * See docs/credits.txt for copyright information * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * * @version $Id: boost.php,v 1.1 2008/01/02 21:59:24 blindman1344 Exp $ * @author Greg Meiste <blindman1344 [at] users dot sourceforge dot net> */ $proper_name = 'Mailing Lists'; $version = '1.0.0'; $register = FALSE; $unregister = FALSE; $import_sql = TRUE; $image_dir = FALSE; $file_dir = FALSE; $version_http = 'http://www.meiste.com/phpws_updates/mailinglists.xml'; $about = TRUE; $priority = 50; $dependency = TRUE; ?> Index: update.php =================================================================== RCS file: /cvsroot/phpwebsite-comm/modules/mailinglists/boost/update.php,v retrieving revision 1.19 retrieving revision 1.20 diff -C2 -d -r1.19 -r1.20 *** update.php 12 Sep 2005 00:36:09 -0000 1.19 --- update.php 2 Jan 2008 21:59:24 -0000 1.20 *************** *** 10,19 **** * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. ! * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. ! * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software --- 10,19 ---- * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. ! * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. ! * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software *************** *** 24,327 **** */ ! if (!$_SESSION['OBJ_user']->isDeity()) { ! header('location:index.php'); ! exit(); ! } ! ! // Need to do core version check ! if (version_compare($GLOBALS['core']->version, '0.9.3-4') < 0) { ! $content .= 'This module requires a phpWebSite core version of 0.9.3-4 or greater to install.<br />'; ! $content .= 'You are currently using phpWebSite core version ' . $GLOBALS['core']->version . '.<br />'; ! return; ! } ! ! // Load help information ! require_once(PHPWS_SOURCE_DIR . 'mod/help/class/CLS_help.php'); ! CLS_help::uninstall_help('mailinglists'); ! CLS_help::setup_help('mailinglists'); ! ! // Update Language ! require_once(PHPWS_SOURCE_DIR . 'mod/language/class/Language.php'); ! PHPWS_Language::uninstallLanguages('mailinglists'); ! PHPWS_Language::installLanguages('mailinglists'); ! ! $status = 1; ! ! if($currentVersion < 0.20) { ! $content .= 'Adding three new columns to the "mod_mailinglists_subscribers" table.<br />'; ! $sql = "ALTER TABLE mod_mailinglists_subscribers ADD (active smallint NOT NULL DEFAULT '1', activeKey int, dateSubscribed date NOT NULL)"; ! $GLOBALS['core']->query($sql, TRUE); ! $content .= 'Columns added successfully!<br />'; ! $content .= 'Updating current subscribers...<br />'; ! ! $sql = 'SELECT userID,listID FROM mod_mailinglists_subscribers'; ! $result = $GLOBALS['core']->getAll($sql, TRUE); ! if(sizeof($result) > 0) { ! $i = 0; ! foreach($result as $row) { ! $key = rand(1,999999999); ! $sql = 'UPDATE mod_mailinglists_subscribers SET activeKey=' . $key . ',dateSubscribed="' . date("Y-m-d") . '" WHERE userID=' . $row['userID'] . ' AND listID=' . $row['listID']; ! $GLOBALS['core']->query($sql, TRUE); ! $i++; ! } ! ! $content .= $i . ' subscribers were updated!<br />'; ! } else { ! $content .= 'No subscribers were found. Skipping this step.<br />'; ! } ! ! $content .= 'Adding columns "footer" and "footerMessage" to "mod_mailinglists_conf".'; ! $sql = "ALTER TABLE mod_mailinglists_conf ADD (footer smallint NOT NULL DEFAULT '0', footerMessage text NOT NULL)"; ! $GLOBALS['core']->query($sql, TRUE); ! $content .= '<br />Columns added successfully!<br />'; ! ! $sql = 'UPDATE mod_mailinglists_conf SET footerMessage="To unsubscribe, login to your subscription menu on our website."'; ! $GLOBALS['core']->query($sql, TRUE); ! ! $content .= 'Configuration settings updated!<br />'; ! ! $sql = 'CREATE TABLE mod_mailinglists_archives ( ! id int PRIMARY KEY, ! listID int NOT NULL, ! subject varchar(60) NOT NULL, ! message text NOT NULL, ! dateSent datetime NOT NULL ! )'; ! $GLOBALS['core']->query($sql, TRUE); ! $content .= 'Archives table created!<br />'; ! ! $content .= 'Adding 9 new columns to the "mod_mailinglists_lists" table.<br />'; ! $sql = "ALTER TABLE mod_mailinglists_lists ADD ! (archive smallint NOT NULL DEFAULT '1', ! archiveLink smallint NOT NULL DEFAULT '1', ! doubleOptIn smallint NOT NULL DEFAULT '1', ! sEmail smallint NOT NULL DEFAULT '1', ! uEmail smallint NOT NULL DEFAULT '1', ! optInMessage text NOT NULL, ! subscribeMessage text NOT NULL, ! unsubscribeMessage text NOT NULL, ! dateCreated date NOT NULL)"; ! ! $GLOBALS['core']->query($sql, TRUE); ! $content .= 'Columns added successfully!<br />'; ! $content .= 'Setting new list options for all lists.<br />'; ! ! $sql = 'SELECT id FROM mod_mailinglists_lists'; ! $result = $GLOBALS['core']->getAll($sql, TRUE); ! if(sizeof($result) > 0) { ! $i = 0; ! ! $message = "You have received this email because you have subscribed to the \\\"[LISTNAME]\\\" mailing list. There is one more step before your subscription is complete. You need to confirm your email address to us before you will begin to receive emails. To do so, please go to the following URL:\n\n"; ! $message .= "[URL]\n\nIf you have gotten this in error, please ignore this email. You will not receive future emails from us."; ! ! $sMessage = "Your subscription to the \\\"[LISTNAME]\\\" mailing list is now complete. You will begin to receive all messages we send out to this list.\n\n"; ! $sMessage .= 'To unsubscribe, just return to our website and login to your subscription menu.'; ! ! $uMessage = "Your subscription to the \\\"[LISTNAME]\\\" mailing list has been terminated. You will no longer receive messages we send out to this list.\n\n"; ! $uMessage .= 'To subscribe again, just return to our website and login to your subscription menu.'; ! ! foreach($result as $row) { ! $sql = 'UPDATE mod_mailinglists_lists SET optInMessage="' . $message . '", subscribeMessage="' . $sMessage . '", unsubscribeMessage="' . $uMessage . '", dateCreated="' . date("Y-m-d") . '" WHERE id=' . $row['id']; ! $GLOBALS['core']->query($sql, TRUE); ! $i++; ! } ! ! $content .= $i . ' mailing lists were updated!<br />'; ! } else { ! $content .= 'No mailing lists were found. Skipping this step.<br />'; ! } ! } ! ! ! if($currentVersion < 0.21) { ! $content .= 'Fixing subscribers that are not stored correctly.<br />'; ! $sql = 'SELECT userID,listID FROM mod_mailinglists_subscribers WHERE dateSubscribed="0000-00-00"'; ! $result = $GLOBALS['core']->getAll($sql, TRUE); ! if(sizeof($result) > 0) { ! $i = 0; ! foreach($result as $row) { ! $key = rand(1,999999999); ! $sql = 'UPDATE mod_mailinglists_subscribers SET activeKey=' . $key . ',dateSubscribed="' . date("Y-m-d") . '" WHERE userID=' . $row['userID'] . ' AND listID=' . $row['listID']; ! $GLOBALS['core']->query($sql, TRUE); ! $i++; ! } ! ! $content .= $i . ' subscribers were fixed!<br />'; ! } else { ! $content .= 'No subscribers needed to be fixed.<br />'; ! } ! } ! ! ! if($currentVersion < 0.30) { ! $sql = "CREATE TABLE mod_mailinglists_useroptions ( ! id int PRIMARY KEY, ! userID int NOT NULL, ! htmlEmail smallint NOT NULL DEFAULT '1' ! )"; ! $GLOBALS['core']->query($sql, TRUE); ! ! $numUsers = $GLOBALS['core']->sqlMaxValue(mod_users, user_id); ! ! for($i=1; $i<=$numUsers; $i++) { ! $GLOBALS['core']->sqlInsert(array('userID'=>$i,'htmlEmail'=>1), 'mod_mailinglists_useroptions'); ! } ! ! $sql = "ALTER TABLE mod_mailinglists_archives ADD (sentBy varchar(20) NOT NULL DEFAULT 'Unknown')"; ! $GLOBALS['core']->query($sql, TRUE); ! ! $sql = 'ALTER TABLE mod_mailinglists_saves ADD (htmlMessage text NOT NULL)'; ! $GLOBALS['core']->query($sql, TRUE); ! ! $sql = 'UPDATE mod_mailinglists_saves SET htmlMessage=message'; ! $GLOBALS['core']->query($sql, TRUE); ! ! $sql = 'ALTER TABLE mod_mailinglists_conf ADD (footerHtmlMessage text NOT NULL)'; ! $GLOBALS['core']->query($sql, TRUE); ! ! $sql = 'UPDATE mod_mailinglists_conf SET footerHtmlMessage=footerMessage'; ! $GLOBALS['core']->query($sql, TRUE); ! ! $sql = "ALTER TABLE mod_mailinglists_lists ! ADD (lastSent datetime NOT NULL, ! lastSentBy varchar(20) NOT NULL DEFAULT 'Unknown', ! fromName varchar(255) NOT NULL, ! fromEmail varchar(255) NOT NULL)"; ! $GLOBALS['core']->query($sql, TRUE); ! ! extract(PHPWS_User::getSettings()); ! $sql = 'UPDATE mod_mailinglists_lists SET fromName="' . $_SESSION['OBJ_layout']->page_title . '", fromEmail="' . $user_contact . '"'; ! $GLOBALS['core']->query($sql, TRUE); ! ! $content .= 'Mailing Lists Updates for Version 0.3.0<br />'; ! $content .= '------------------------------------------<br />'; ! $content .= '- "From" mail header can now be set<br />'; ! $content .= '- Fixed some xhtml compliance errors<br />'; ! $content .= '- Website output now templated for easy customization<br />'; ! $content .= '- Module rights support added<br />'; ! $content .= '- Language support added<br />'; ! $content .= '- HTML support added!!!<br />'; ! $content .= '- Interface improvements<br />'; ! $content .= '- Now keeps track of the date and who sent last email<br />'; ! $content .= '- Archives now stores who sent each email<br />'; ! $content .= '- Other minor tweaks<br />'; ! } ! ! ! if($currentVersion < 0.31) { ! $content .= 'Mailing Lists Updates for Version 0.3.1<br />'; ! $content .= '------------------------------------------<br />'; ! $content .= '- Script now properly checks to see if all emails sent<br />'; ! $content .= '- FAQ doc file added<br />'; ! $content .= '- Subscription Menu now properly displays subscribed lists.<br />'; ! $content .= '- Unsubscribe will no longer send emails to unactive users.<br />'; ! } ! ! if($currentVersion < 0.32) { ! $content .= 'Mailing Lists Updates for Version 0.3.2<br />'; ! $content .= '------------------------------------------<br />'; ! $content .= '- Admin can now add all the website users to a mailing list.<br />'; ! $content .= '- Footers can now have an unsubscribe link.<br />'; ! } ! ! if($currentVersion < 0.33) { ! $content .= 'Mailing Lists Updates for Version 0.3.3<br />'; ! $content .= '------------------------------------------<br />'; ! $content .= '- Now compatible with phpWebSite 0.9.3-2<br />'; ! $content .= '- Minor bug fixed with saved emails.<br />'; ! } ! ! if(in_array($currentVersion, array('0.10', '0.11', '0.20', '0.21', '0.22', '0.30', '0.31', '0.32', '0.33'))) { ! $currentVersion = '0.3.3'; ! } ! ! // Begin using version_compare() ! ! if(version_compare($currentVersion, '0.4.0') < 0) { ! $sql = "ALTER TABLE mod_mailinglists_conf ADD (userSend smallint NOT NULL DEFAULT '0', anonSubscribe smallint NOT NULL DEFAULT '0')"; ! $GLOBALS['core']->query($sql, TRUE); ! ! $sql = "CREATE TABLE mod_mailinglists_anon_subscribers ( ! id int PRIMARY KEY, ! email varchar(50) NOT NULL, ! html int NOT NULL DEFAULT '1', ! listID int NOT NULL, ! active smallint NOT NULL DEFAULT '1', ! activeKey int, ! dateSubscribed date NOT NULL ! )"; ! $GLOBALS['core']->query($sql, TRUE); ! ! $sql = "CREATE TABLE mod_mailinglists_limbo ( ! id int PRIMARY KEY, ! listID int NOT NULL, ! subject varchar(60) NOT NULL, ! message text NOT NULL, ! htmlMessage text NOT NULL, ! sentBy varchar(20) NOT NULL DEFAULT 'Unknown' ! )"; ! $GLOBALS['core']->query($sql, TRUE); ! ! $content .= 'Mailing Lists Updates for Version 0.4.0<br />'; ! $content .= '------------------------------------------<br />'; ! $content .= '- Subscriber Admin has been added.<br />'; ! $content .= '- Help module utilized.<br />'; ! $content .= '- Anonymous visitors can now subscribe to mailing lists.<br />'; ! $content .= '- Registered subscribed users can now send messages to the list.<br />'; ! } ! ! if(version_compare($currentVersion, '0.4.1') < 0) { ! $sql = 'ALTER TABLE mod_mailinglists_lists ADD (subjectPrefix varchar(65) NOT NULL)'; ! $GLOBALS['core']->query($sql, TRUE); ! ! $sql = 'SELECT id,name FROM mod_mailinglists_lists'; ! $result = $GLOBALS['core']->getAll($sql, TRUE); ! if(sizeof($result) > 0) { ! foreach($result as $row) { ! $sql = 'UPDATE mod_mailinglists_lists SET subjectPrefix="[' . $row['name'] . ']" WHERE id=' . $row['id']; ! $GLOBALS['core']->query($sql, TRUE); ! } ! } ! ! $sql = "ALTER TABLE mod_mailinglists_conf ADD (subjectPrefix smallint NOT NULL DEFAULT '1')"; ! $GLOBALS['core']->query($sql, TRUE); ! ! $content .= '<br />Mailing Lists Updates for Version 0.4.1<br />'; ! $content .= '------------------------------------------<br />'; ! $content .= '- Subject prefixes now possible.<br />'; ! $content .= '- Subscriber Admin bug fixes.<br />'; ! $content .= '- Fixed update script to support table prefixes.<br />'; ! } ! ! if(version_compare($currentVersion, '0.5.0') < 0) { ! $sql = 'UPDATE mod_mailinglists_archives SET subject="(No Subject)" WHERE subject=""'; ! $GLOBALS['core']->query($sql, TRUE); ! ! $content .= '<br />Mailing Lists Updates for Version 0.5.0<br />'; ! $content .= '------------------------------------------<br />'; ! $content .= '- Interface improvements<br />'; ! $content .= '- Improved Subscriber Admin<br />'; ! $content .= '- Messages can now be imported from modules<br />'; ! $content .= '- Fixed bug with HTML emails on certain servers<br />'; ! $content .= '- Email subjects now required<br />'; ! } ! ! if(version_compare($currentVersion, '0.5.1') < 0) { ! $content .= '<br />Mailing Lists Updates for Version 0.5.1<br />'; ! $content .= '------------------------------------------<br />'; ! $content .= '- Add All Users no longer adds unapproved users.<br />'; ! $content .= '- Fixed the relative link problem.<br />'; ! $content .= '- One anonymous user can now subscribe to multiple lists.<br />'; ! $content .= '- Email links in HTML emails no longer "mungled"<br />'; ! $content .= '- Better sanity checks on email send form<br />'; ! $content .= '- HTML email preview feature added<br />'; ! $content .= '- Modified how announcements were imported for compatibility with 0.9.3-3<br />'; ! } ! ! if(version_compare($currentVersion, '0.5.2') < 0) { ! $content .= '<br />Mailing Lists Updates for Version 0.5.2<br />'; ! $content .= '------------------------------------------<br />'; ! $content .= '- Now compatible with phpWebSite 0.10.0<br />'; ! $content .= '- Properly handles lists with ID > 9<br />'; } --- 24,31 ---- */ ! function mailinglists_update(&$content, $currentVersion) ! { ! /* Can not update from versions earlier than 1.0.0. */ ! return true; } --- install.php DELETED --- Index: install.sql =================================================================== RCS file: /cvsroot/phpwebsite-comm/modules/mailinglists/boost/install.sql,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** install.sql 1 Sep 2005 02:39:29 -0000 1.7 --- install.sql 2 Jan 2008 21:59:24 -0000 1.8 *************** *** 19,104 **** -- $Id$ ! CREATE TABLE mod_mailinglists_subscribers ( ! userID int NOT NULL, ! listID int NOT NULL, ! active smallint NOT NULL DEFAULT '1', ! activeKey int, ! dateSubscribed date NOT NULL, ! PRIMARY KEY (userID,listID), ! KEY userID (userID), ! KEY listID (listID) ! ); ! ! CREATE TABLE mod_mailinglists_lists ( ! id int PRIMARY KEY, ! name varchar(60) NOT NULL, ! status varchar(4) NOT NULL, ! description text NOT NULL, ! archive smallint NOT NULL DEFAULT '1', ! archiveLink smallint NOT NULL DEFAULT '1', ! doubleOptIn smallint NOT NULL DEFAULT '1', ! sEmail smallint NOT NULL DEFAULT '1', ! uEmail smallint NOT NULL DEFAULT '1', ! optInMessage text NOT NULL, ! subscribeMessage text NOT NULL, ! unsubscribeMessage text NOT NULL, ! dateCreated date NOT NULL, ! lastSent datetime NOT NULL, ! lastSentBy varchar(20) NOT NULL DEFAULT 'Unknown', ! fromName varchar(255) NOT NULL, ! fromEmail varchar(255) NOT NULL, ! subjectPrefix varchar(65) NOT NULL ! ); ! ! CREATE TABLE mod_mailinglists_useroptions ( ! id int PRIMARY KEY, ! userID int NOT NULL, ! htmlEmail smallint NOT NULL DEFAULT '1' ! ); ! ! CREATE TABLE mod_mailinglists_conf ( ! personal varchar(4) NOT NULL, ! footer smallint NOT NULL DEFAULT '0', ! footerMessage text NOT NULL, ! footerHtmlMessage text NOT NULL, ! userSend smallint NOT NULL DEFAULT '0', ! anonSubscribe smallint NOT NULL DEFAULT '0', ! subjectPrefix smallint NOT NULL DEFAULT '1' ! ); ! ! INSERT INTO mod_mailinglists_conf VALUES ('on', '0', 'To unsubscribe:\n[URL]', '<i>To unsubscribe, <a href=\"[URL]\">click here</a>.</i>', '0', '0', '1'); ! ! CREATE TABLE mod_mailinglists_saves ( ! id int PRIMARY KEY, ! name varchar(40) NOT NULL, ! message text NOT NULL, ! htmlMessage text NOT NULL ); ! CREATE TABLE mod_mailinglists_archives ( ! id int PRIMARY KEY, ! listID int NOT NULL, ! subject varchar(60) NOT NULL, ! message text NOT NULL, ! dateSent datetime NOT NULL, ! sentBy varchar(20) NOT NULL DEFAULT 'Unknown' ); ! CREATE TABLE mod_mailinglists_anon_subscribers ( ! id int PRIMARY KEY, ! email varchar(50) NOT NULL, ! html int NOT NULL DEFAULT '1', ! listID int NOT NULL, ! active smallint NOT NULL DEFAULT '1', ! activeKey int, ! dateSubscribed date NOT NULL ); ! CREATE TABLE mod_mailinglists_limbo ( ! id int PRIMARY KEY, ! listID int NOT NULL, ! subject varchar(60) NOT NULL, ! message text NOT NULL, ! htmlMessage text NOT NULL, ! sentBy varchar(20) NOT NULL DEFAULT 'Unknown' ); --- 19,71 ---- -- $Id$ ! CREATE TABLE mailinglists_lists ( ! id INT NOT NULL, ! name VARCHAR(60) NOT NULL, ! description TEXT NULL, ! active SMALLINT NOT NULL DEFAULT '1', ! archive_link SMALLINT NOT NULL DEFAULT '1', ! double_opt_in SMALLINT NOT NULL DEFAULT '1', ! s_email SMALLINT NOT NULL DEFAULT '1', ! u_email SMALLINT NOT NULL DEFAULT '1', ! opt_in_msg TEXT NOT NULL, ! subscribe_msg TEXT NOT NULL, ! unsubscribe_msg TEXT NOT NULL, ! created INT NOT NULL DEFAULT '0', ! from_name VARCHAR(255) NOT NULL, ! from_email VARCHAR(255) NOT NULL, ! subject_prefix VARCHAR(65) NOT NULL, ! PRIMARY KEY (id) ); ! CREATE TABLE mailinglists_subscribers ( ! id INT NOT NULL, ! user_id INT NOT NULL DEFAULT '0', ! email VARCHAR(100) NULL, ! list_id INT NOT NULL DEFAULT '0', ! html SMALLINT NOT NULL DEFAULT '1', ! active SMALLINT NOT NULL DEFAULT '1', ! active_key INT NOT NULL, ! subscribed INT NOT NULL, ! PRIMARY KEY (id) ); ! CREATE TABLE mailinglists_emails ( ! id INT NOT NULL, ! list_id INT NOT NULL DEFAULT '0', ! subject VARCHAR(60) NOT NULL, ! msg_text TEXT NOT NULL, ! msg_html TEXT NULL, ! created INT NOT NULL DEFAULT '0', ! user_id INT NOT NULL DEFAULT '0', ! approved INT NOT NULL DEFAULT '0', ! PRIMARY KEY (id) ); ! CREATE TABLE mailinglists_queue ( ! id INT NOT NULL, ! list_id INT NOT NULL DEFAULT '0', ! subscriber_id INT NOT NULL DEFAULT '0', ! email_id INT NOT NULL DEFAULT '0', ! email_address VARCHAR(100) NULL, ! PRIMARY KEY (id) ); --- NEW FILE: controlpanel.php --- <?php /** * Mailing Lists - phpWebSite Module * * See docs/credits.txt for copyright information * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * * @version $Id: controlpanel.php,v 1.1 2008/01/02 21:59:24 blindman1344 Exp $ * @author Greg Meiste <blindman1344 [at] users dot sourceforge dot net> */ $link[] = array('label' => dgettext('mailinglists', 'Mailing Lists'), 'restricted' => TRUE, 'url' => 'index.php?module=mailinglists', 'description' => dgettext('mailinglists', 'Create and manage Mailing Lists. Send mass mailings here!'), 'image' => 'mailinglists.png', 'tab' => 'admin' ); ?> --- NEW FILE: about.html --- <html> <head> <title>Mailing Lists</title> <link rel="stylesheet" type="text/css" href="themes/default/style.css" /> <link rel="stylesheet" type="text/css" href="themes/default/default.css" /> </head> <body class="padded"> <h1>Mailing Lists</h1> <h3>By Greg Meiste</h3> <p>Lets you create and manage Mailing Lists and send mass mailings to subscribers.</p> <p class="align-center padded"><input type="button" onclick="window.close()" value="Close" /></p> </body> </html> --- uninstall.sql DELETED --- |