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_VERSION = "0.1.2";
43 // Auto-set extension version
44 if (empty($EXT_VER)) $EXT_VER = $EXT_VERSION;
46 // Version history array (add more with , "0.1" and so on)
47 $EXT_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");
49 switch ($EXT_LOAD_MODE)
51 case "register": // Do stuff when installation is running (modules.php?module=admin&action=login is called)
52 // SQL commands to run
56 case "remove": // Do stuff when removing extension
57 // SQL commands to run
58 $SQLs[] = "DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE `action`='newsletter' AND what != 'send_newsletter' LIMIT 3";
59 $SQLs[] = "DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_member_menu` WHERE `what`='newsletter' LIMIT 1";
62 case "activate": // Do stuff when admin activates this extension
63 // SQL commands to run
64 $SQLs[] = "UPDATE `{!_MYSQL_PREFIX!}_member_menu` SET `locked`='N', `visible`='Y' WHERE `what`='newsletter' LIMIT 1";
67 case "deactivate": // Do stuff when admin deactivates this extension
68 // SQL commands to run
69 $SQLs[] = "UPDATE `{!_MYSQL_PREFIX!}_member_menu` SET `locked`='Y', `visible`='N' WHERE `what`='newsletter' LIMIT 1";
72 case "update": // Update an extension
75 case "0.0.1": // SQL queries for v0.0.1
76 $SQLs[] = "INSERT INTO `{!_MYSQL_PREFIX!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('newsletter', NULL, 'Newsletter','Einstellungen am Newsletter, Newsletter versenden, Abbestellungen auflisten usw.', 3)";
77 $SQLs[] = "INSERT INTO `{!_MYSQL_PREFIX!}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('newsletter','list_newsletter','Abbestellungen','Alle Abbestellungen auflisten und bearbeiten.', 2)";
78 $SQLs[] = "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)";
79 $SQLs[] = "UPDATE `{!_MYSQL_PREFIX!}_admin_menu` SET `action`='newsletter', `what`='send_newsletter', `title`='Versenden', `sort`='1' WHERE `what`='newsletter' LIMIT 1";
80 $SQLs[] = "INSERT INTO `{!_MYSQL_PREFIX!}_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('main','newsletter','Newsletter-Empfang','N','Y', 10)";
81 $SQLs[] = "ALTER TABLE `{!_MYSQL_PREFIX!}_config` ADD nl_charge FLOAT(10,2) UNSIGNED NOT NULL DEFAULT '5.00'";
82 $SQLs[] = "ALTER TABLE `{!_MYSQL_PREFIX!}_user_data` ADD nl_receive ENUM('Y','N') NOT NULL DEFAULT 'Y'";
83 $SQLs[] = "ALTER TABLE `{!_MYSQL_PREFIX!}_user_data` ADD nl_until VARCHAR(10) NOT NULL DEFAULT 0";
84 $SQLs[] = "ALTER TABLE `{!_MYSQL_PREFIX!}_user_data` ADD nl_timespan VARCHAR(10) NOT NULL DEFAULT 0";
86 // Update notes (these will be set as task text!)
87 $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.";
90 case "0.0.2": // SQL queries for v0.0.2
91 // Update notes (these will be set as task text!)
92 $UPDATE_NOTES = "URL im Versendeformular und Option <em>Immer aktiv</em> für diese Erweiterung deaktiviert.";
95 case "0.0.3": // SQL queries for v0.0.3
96 // Update notes (these will be set as task text!)
97 $UPDATE_NOTES = "Wörter <strong>Mailtausch</strong>, <strong>Mailtausches</strong> und <strong>Mailtauscher</strong> sind austauschbar.";
100 case "0.0.4": // SQL queries for v0.0.4
101 // Update notes (these will be set as task text!)
102 $UPDATE_NOTES = "HTML-Code ausgelagert in Templates und SQL-Anweisungen abgesichert.";
105 case "0.0.5": // SQL queries for v0.0.5
106 // Update notes (these will be set as task text!)
107 $UPDATE_NOTES = "Abspeichern von Einstellungen repariert.";
110 case "0.0.6": // SQL queries for v0.0.6
111 // Update notes (these will be set as task text!)
112 $UPDATE_NOTES = "Bitte Script inc/monthly_newsletter.php löschen!";
115 case "0.0.7": // SQL queries for v0.0.7
116 // Update notes (these will be set as task text!)
117 $UPDATE_NOTES = "Script <strong>inc/monthly/monthly_newsletter.php</strong> wird nicht mehr ausgeführt, wenn die Erweiterung nicht aktiviert ist.";
120 case "0.0.8": // SQL queries for v0.0.8
121 // Update notes (these will be set as task text!)
122 $UPDATE_NOTES = "Sicherheitsupdate für die Include-Befehle.";
125 case "0.0.9": // SQL queries for v0.0.9
126 // Update notes (these will be set as task text!)
127 $UPDATE_NOTES = "Nur bei installierter Erweiterung <strong>html_mail</strong> können Sie auch HTML-Mails versenden.";
130 case "0.1.0": // SQL queries for v0.2.1
131 // Update notes (these will be set as task text!)
132 $UPDATE_NOTES = "Nur bei installierter Erweiterung <strong>html_mail</strong> können Sie auch HTML-Mails versenden.";
135 case "0.1.1": // SQL queries for v0.1.1
137 // Update notes (these will be set as task text!)
138 $UPDATE_NOTES = "Währung auf die Erweiterung <a href=\"#\"><strong>ext-other.zip</strong></a> verlagert. Bitte auch diese aktualisieren.";
141 case "0.1.2": // SQL queries for v0.1.2
142 // Update notes (these will be set as task text!)
143 $UPDATE_NOTES = "Fehlerhinweis bei deaktivierter Erweiterung verbessert.";
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 (isBooleanConstantAndTrue('__DAILY_RESET') && (!isBooleanConstantAndTrue('DEBUG_MODE')) && ($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'));