2 /************************************************************************
3 * MXChange v0.2.1 Start: 02/26/2005 *
4 * ================ Last change: 02/26/2005 *
6 * -------------------------------------------------------------------- *
7 * File : ext-newsletter.php *
8 * -------------------------------------------------------------------- *
9 * Short description : Extension for sending newsletters *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Erweiterung zum Versenden von Newslettern *
12 * -------------------------------------------------------------------- *
14 * -------------------------------------------------------------------- *
15 * Copyright (c) 2003 - 2008 by Roland Haeder *
16 * For more information visit: http://www.mxchange.org *
18 * This program is free software; you can redistribute it and/or modify *
19 * it under the terms of the GNU General Public License as published by *
20 * the Free Software Foundation; either version 2 of the License, or *
21 * (at your option) any later version. *
23 * This program is distributed in the hope that it will be useful, *
24 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
25 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
26 * GNU General Public License for more details. *
28 * You should have received a copy of the GNU General Public License *
29 * along with this program; if not, write to the Free Software *
30 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
32 ************************************************************************/
34 // Some security stuff...
35 if (!defined('__SECURITY')) {
36 $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
41 EXT_SET_VERSION("0.1.2");
43 // Version history array (add more with , "0.1" and so on)
44 EXT_SET_VER_HISTORY(array("0.0", "0.0.1", "0.0.2", "0.0.3", "0.0.4", "0.0.5", "0.0.6", "0.0.7", "0.0.8", "0.0.9", "0.1.0", "0.1.1", "0.1.2"));
46 switch ($EXT_LOAD_MODE)
48 case "register": // Do stuff when installation is running (modules.php?module=admin&action=login is called)
49 // SQL commands to run
53 case "remove": // Do stuff when removing extension
54 // SQL commands to run
55 ADD_SQL("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE `action`='newsletter' AND what != 'send_newsletter' LIMIT 3");
56 ADD_SQL("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_member_menu` WHERE `what`='newsletter' LIMIT 1");
59 case "activate": // Do stuff when admin activates this extension
60 // SQL commands to run
61 ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_member_menu` SET `locked`='N', `visible`='Y' WHERE `what`='newsletter' LIMIT 1");
64 case "deactivate": // Do stuff when admin deactivates this extension
65 // SQL commands to run
66 ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_member_menu` SET `locked`='Y', `visible`='N' WHERE `what`='newsletter' LIMIT 1");
69 case "update": // Update an extension
72 case "0.0.1": // SQL queries for v0.0.1
73 ADD_SQL("INSERT INTO `{!_MYSQL_PREFIX!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('newsletter', NULL, 'Newsletter','Einstellungen am Newsletter, Newsletter versenden, Abbestellungen auflisten usw.', 3)");
74 ADD_SQL("INSERT INTO `{!_MYSQL_PREFIX!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('newsletter','list_newsletter','Abbestellungen','Alle Abbestellungen auflisten und bearbeiten.', 2)");
75 ADD_SQL("INSERT INTO `{!_MYSQL_PREFIX!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('newsletter','config_newsletter','Einstellungen','Gebühr zum Abbestellen des Newsletters usw. sind hier einstellbar.', 3)");
76 ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_admin_menu` SET `action`='newsletter', `what`='send_newsletter', `title`='Versenden', `sort`='1' WHERE `what`='newsletter' LIMIT 1");
77 ADD_SQL("INSERT INTO `{!_MYSQL_PREFIX!}_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('main','newsletter','Newsletter-Empfang','N','Y', 10)");
78 ADD_SQL("ALTER TABLE `{!_MYSQL_PREFIX!}_config` ADD nl_charge FLOAT(10,2) UNSIGNED NOT NULL DEFAULT '5.00'");
79 ADD_SQL("ALTER TABLE `{!_MYSQL_PREFIX!}_user_data` ADD nl_receive ENUM('Y','N') NOT NULL DEFAULT 'Y'");
80 ADD_SQL("ALTER TABLE `{!_MYSQL_PREFIX!}_user_data` ADD nl_until VARCHAR(10) NOT NULL DEFAULT 0");
81 ADD_SQL("ALTER TABLE `{!_MYSQL_PREFIX!}_user_data` ADD nl_timespan VARCHAR(10) NOT NULL DEFAULT 0");
83 // Update notes (these will be set as task text!)
84 EXT_SET_UPDATE_NOTES("Vor der eigentlichen Freigabe dieser Erweiterungen habe ich sie versehendlich im Archiv mit auf den Server hochgeladen. Diese Version fügt die bereits angekündigte Funktionalitäten, wie zum Beispiel das Einstellen der Abschaltgebühr.");
87 case "0.0.2": // SQL queries for v0.0.2
88 // Update notes (these will be set as task text!)
89 EXT_SET_UPDATE_NOTES("URL im Versendeformular und Option <em>Immer aktiv</em> für diese Erweiterung deaktiviert.");
92 case "0.0.3": // SQL queries for v0.0.3
93 // Update notes (these will be set as task text!)
94 EXT_SET_UPDATE_NOTES("Wörter <strong>Mailtausch</strong>, <strong>Mailtausches</strong> und <strong>Mailtauscher</strong> sind austauschbar.");
97 case "0.0.4": // SQL queries for v0.0.4
98 // Update notes (these will be set as task text!)
99 EXT_SET_UPDATE_NOTES("HTML-Code ausgelagert in Templates und SQL-Anweisungen abgesichert.");
102 case "0.0.5": // SQL queries for v0.0.5
103 // Update notes (these will be set as task text!)
104 EXT_SET_UPDATE_NOTES("Abspeichern von Einstellungen repariert.");
107 case "0.0.6": // SQL queries for v0.0.6
108 // Update notes (these will be set as task text!)
109 EXT_SET_UPDATE_NOTES("Bitte Script inc/monthly_newsletter.php löschen!");
112 case "0.0.7": // SQL queries for v0.0.7
113 // Update notes (these will be set as task text!)
114 EXT_SET_UPDATE_NOTES("Script <strong>inc/monthly/monthly_newsletter.php</strong> wird nicht mehr ausgeführt, wenn die Erweiterung nicht aktiviert ist.");
117 case "0.0.8": // SQL queries for v0.0.8
118 // Update notes (these will be set as task text!)
119 EXT_SET_UPDATE_NOTES("Sicherheitsupdate für die Include-Befehle.");
122 case "0.0.9": // SQL queries for v0.0.9
123 // Update notes (these will be set as task text!)
124 EXT_SET_UPDATE_NOTES("Nur bei installierter Erweiterung <strong>html_mail</strong> können Sie auch HTML-Mails versenden.");
127 case "0.1.0": // SQL queries for v0.2.1
128 // Update notes (these will be set as task text!)
129 EXT_SET_UPDATE_NOTES("Nur bei installierter Erweiterung <strong>html_mail</strong> können Sie auch HTML-Mails versenden.");
132 case "0.1.1": // SQL queries for v0.1.1
134 // Update notes (these will be set as task text!)
135 EXT_SET_UPDATE_NOTES("Währung auf die Erweiterung <a href=\"#\"><strong>ext-other.zip</strong></a> verlagert. Bitte auch diese aktualisieren.");
138 case "0.1.2": // SQL queries for v0.1.2
139 // Update notes (these will be set as task text!)
140 EXT_SET_UPDATE_NOTES("Fehlerhinweis bei deaktivierter Erweiterung verbessert.");
145 case "modify": // When the extension got modified
148 case "test": // For testing purposes. For details see file inc/modules/admin/what-extensions.php, arround line 305.
151 default: // Do stuff when extension is loaded
152 // URL ends which are used to indentify the end of an URL or email link
153 // Don't use these chars in links... ;-)
155 $GLOBALS['url_ends'] = array(
162 // Valid email chars (without @, or do you want to have another @ inside your email addy?)
163 $GLOBALS['valid_email_chars'] = array(
164 'a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s',
165 't','u','v','w','x','y','z','a','B','C','D','E','F','G','H','I','J','K','L',
166 'M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z','-','.','_','0','1',
167 '2','3','4','5','6','7','8','9'
170 if (isResetModeEnabled() && (!isDebugModeEnabled()) && ($GLOBALS['output_mode'] != 1)) {
171 // Daily reset was run so let's check out for expired newsletter orders
172 $INC_POOL[] = sprintf("%sinc/monthly/monthly_newsletter.php", constant('PATH'));