X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-holiday.php;h=40c517ca7fcbb3d4b58e737df56eeb7bf7983fe8;hp=b26919897f161afa340e5a6572f8e886be4bf0e4;hb=6d08952d672c5a5de7d8522f894a5665599a2a4a;hpb=52e8a0635bd0b7c653845685c55e4e5f251375fe

diff --git a/inc/extensions/ext-holiday.php b/inc/extensions/ext-holiday.php
index b26919897f..40c517ca7f 100644
--- a/inc/extensions/ext-holiday.php
+++ b/inc/extensions/ext-holiday.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 06/17/2004 *
- * ================                             Last change: 01/13/2006 *
+ * Mailer v0.2.1-FINAL                                Start: 06/17/2004 *
+ * ===================                          Last change: 01/13/2006 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : ext-holiday.php                                  *
@@ -10,10 +10,14 @@
  * -------------------------------------------------------------------- *
  * Kurzbeschreibung  : Ferienantraege von Mitgliedern                   *
  * -------------------------------------------------------------------- *
- *                                                                      *
+ * $Revision::                                                        $ *
+ * $Date::                                                            $ *
+ * $Tag:: 0.2.1-FINAL                                                 $ *
+ * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
- * Copyright (c) 2003 - 2008 by Roland Haeder                           *
- * For more information visit: http://www.mxchange.org                  *
+ * Copyright (c) 2003 - 2009 by Roland Haeder                           *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team                   *
+ * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * 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 *
@@ -32,219 +36,86 @@
  ************************************************************************/
 
 // Some security stuff...
-if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])))
-{
-	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
-	require($INC);
-}
+if (!defined('__SECURITY')) {
+	die();
+} // END - if
 
 // Version number
-$EXT_VERSION = "0.2.1";
-
-// Auto-set extension version
-if (empty($EXT_VER)) $EXT_VER = $EXT_VERSION;
-
-// Version history array (add more with , "0.1" and so on)
-$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", "0.1.3", "0.1.4", "0.1.5", "0.1.6", "0.1.7", "0.1.8", "0.1.9", "0.2.0", "0.2.1");
-
-switch ($EXT_LOAD_MODE)
-{
-case "register": // Do stuff when installtion is running (modules.php?module=admin&action=login is called)
-	// Create database
-	$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_user_holidays";
-	$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_user_holidays (
-id bigint(20) not null auto_increment,
-userid bigint(20) not null default '0',
-holiday_start varchar(10) not null default '0',
-holiday_end varchar(10) not null default '0',
-comments longblob not null,
-KEY (userid),
-PRIMARY KEY(id)
-) TYPE=MyISAM";
-
-	// Add default values to config
-	$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD holiday_max bigint(20) not null default '30'";
-
-	// Add member menu
-	$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (action, what, title, sort, visible, locked) VALUES ('main', 'holiday', 'Urlaubsschaltung', '4', 'Y', 'Y')";
-
-	// Add admin menus
-	$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, sort, descr) VALUES ('holiday', '', 'Urlaubsmanagement', '4', 'Hier k&ouml;nnen Sie Urlaubsschaltungen Ihrer Mitglieder auflisten oder auch wieder aufheben.')";
-	$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, sort, descr) VALUES ('holiday', 'list_holiday', 'Auflisten', '1', 'Alle Urlaubsschaltungen auflisten.')";
-	$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, sort, descr) VALUES ('holiday', 'del_holiday', 'Urlaub beenden', '2', 'Urlaubsschaltungen aufheben. Geben Sie bitte mehr als nur &quot;Verstoss gegen unsere AGBs&quot; ein!')";
-	$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, sort, descr) VALUES ('holiday', 'config_holiday', 'Einstellungen', '3', 'Maximale Tage f&uuml;r Urlaub usw. einstellen.')";
-
-	// Remove 0 max mails per day
-	$SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_max_receive WHERE value='0' LIMIT 1";
-	break;
-
-case "remove": // Do stuff when removing extension
-	// SQL commands to run
-	$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_user_holidays";
-	$SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_member_menu WHERE what='holiday' LIMIT 1";
-	$SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_admin_menu WHERE action='holiday' LIMIT 4";
-	$SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_max_receive WHERE value='0' LIMIT 1";
-	$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_max_receive (value, comment) VALUES('0', 'Urlaub')";
-	break;
-
-case "activate": // Do stuff when admin activates this extension
-	// SQL commands to run
-	$SQLs[] = "UPDATE "._MYSQL_PREFIX."_member_menu SET visible='Y', locked='N' WHERE action='main' AND what='holiday' LIMIT 1";
-	break;
-
-case "deactivate": // Do stuff when admin deactivates this extension
-	// SQL commands to run
-	$SQLs[] = "UPDATE "._MYSQL_PREFIX."_member_menu SET visible='Y', locked='Y' WHERE action='main' AND what='holiday' LIMIT 1";
-	break;
-
-case "update": // Update an extension
-	switch ($EXT_VER)
-	{
-	case "0.0.2": // SQL queries for v0.0.2
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Fehlende Abfrage im Mitlieder-Modul, on Erweiterung auch aktiviert ist.";
-		break;
+setThisExtensionVersion('0.2.3');
 
-	case "0.0.3": // SQL queries for v0.0.3
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Fehler beseitigt, wenn error_reporting=E_ALL gesetzt ist.";
-		break;
+// Version history array (add more with , '0.0.1' and so on)
+setExtensionVersionHistory(array('0.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', '0.1.3', '0.1.4', '0.1.5', '0.1.6', '0.1.7', '0.1.8', '0.1.9', '0.2.0', '0.2.1', '0.2.2', '0.2.3'));
 
-	case "0.0.4": // SQL queries for v0.0.4
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Problem mit Speicherung der Einstellungen beseitigt.";
-		break;
+switch (getExtensionMode()) {
+	case 'setup': // Do stuff when installation is running
+		// Create database
+		addDropTableSql('user_holidays');
+		addCreateTableSql('user_holidays', "
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`holiday_start` VARCHAR(10) NOT NULL DEFAULT 0,
+`holiday_end` VARCHAR(10) NOT NULL DEFAULT 0,
+`comments` LONGTEXT NOT NULL,
+PRIMARY KEY (`id`),
+INDEX (`userid`)",
+			'User holiday data');
 
-	case "0.0.5": // SQL queries for v0.0.5
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Men&uuml;punkte im Gast-/Mitgliedsbereich k&ouml;nnen nicht mehr aufgerufen werden, wenn die Erweiterung deaktiviert ist.";
-		break;
+		// Add default values to config
+		addConfigAddSql('holiday_max', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 30');
 
-	case "0.0.6": // SQL queries for v0.0.6
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Seit <A href=\"".SERVER_URL."/patches/340-Gast_Mitgliedsmenue_Deaktivieren.zip\">Patch 340</A> &uuml;berfl&uuml;ssige HTML-Tags entfernt.";
-		break;
+		// Add member menu
+		addMemberMenuSql('main', 'holiday', 'Urlaubsschaltung', 4);
 
-	case "0.0.7": // SQL queries for v0.0.7
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "IP-Nummer und Browserbezeichnung wird in Admin-Mails eingesetzt.";
-		break;
+		// Add admin menus
+		addAdminMenuSql('holiday', NULL, 'Urlaubsmanagement', 'Hier k&ouml;nnen Sie Urlaubsschaltungen Ihrer Mitglieder auflisten oder auch wieder aufheben.', 4);
+		addAdminMenuSql('holiday', 'list_holiday', 'Auflisten', 'Alle Urlaubsschaltungen auflisten.', 1);
+		addAdminMenuSql('holiday', 'del_holiday', 'Urlaub beenden', 'Urlaubsschaltungen aufheben. Geben Sie bitte mehr als nur &quot;Verstoss gegen unsere AGBs&quot; ein!', 2);
+		addAdminMenuSql('holiday', 'config_holiday', 'Einstellungen', 'Maximale Tage f&uuml;r Urlaub usw. einstellen.', 3);
 
-	case "0.0.8": // SQL queries for v0.0.8
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Link zum Mitgliedsprofil in Funktion <U>ADMIN_USER_PROFILE_LINK()</U> ausgelagert.";
+		// Remove 0 max mails per day
+		addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_max_receive` WHERE value=0 LIMIT 1");
 		break;
 
-	case "0.0.9": // SQL queries for v0.0.9
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "W&ouml;rter <STRONG>Mailtausch</STRONG>, <STRONG>Mailtausches</STRONG> und <STRONG>Mailtauscher</STRONG> sind austauschbar.";
-		break;
+	case 'remove': // Do stuff when removing extension
+		// SQL commands to run
+		addDropTableSql('user_holidays');
+		addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `what`='holiday' LIMIT 1");
+		addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `action`='holiday' LIMIT 4");
+		addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_max_receive` WHERE `value`=0 LIMIT 1");
+		addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` (`value`, `comment`) VALUES (0,'Urlaub')");
 
-	case "0.1.0": // SQL queries for v0.2.1
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Sicherheitsupdate: SQL-Anweisungen gesch&uuml;tzt.";
+		// Unregister filter
+		unregisterFilter(__FILE__, __LINE__, 'user_exclusion_sql', 'HOLIDAY_USER_EXCLUSION_SQL', TRUE, isExtensionDryRun());
+		unregisterFilter(__FILE__, __LINE__, 'pre_mail_recipient_check', 'CHECK_USER_HOLIDAY', TRUE, isExtensionDryRun());
+		unregisterFilter(__FILE__, __LINE__, 'pre_category_mail_order_check', 'PRE_USERID_HOLIDAY_CHECK', TRUE, isExtensionDryRun());
 		break;
 
-	case "0.1.1": // SQL queries for v0.1.1
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Abspeichern von Einstellungen repariert.";
+	case 'activate': // Do stuff when admin activates this extension
+		// SQL commands to run
+		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `visible`='Y',`locked`='N' WHERE `what`='holiday' LIMIT 1");
 		break;
 
-	case "0.1.2": // SQL queries for v0.1.2
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Abspeichern der Urlaubsanfrage korregiert.";
+	case 'deactivate': // Do stuff when admin deactivates this extension
+		// SQL commands to run
+		addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `visible`='N',`locked`='Y' WHERE `what`='holiday' LIMIT 1");
 		break;
 
-	case "0.1.3": // SQL queries for v0.1.3
-		$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD holiday_active enum('Y', 'N') not null default 'N'";
-		$SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_max_receive WHERE value='0' LIMIT 1";
-		$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD holiday_lock bigint(20) not null default '".(60*60*24*2)."'";
-
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Die Mitglieder-Accounts werden nicht mehr gesperrt, sondern nur auf <STRONG>Urlaub</STRONG> geschaltet. Lassen Sie sich nicht davon verwirren, dass sie &quot;freigegeben&quot; sind!";
+	case 'update': // Update an extension
 		break;
 
-	case "0.1.4": // SQL queries for v0.1.4
-		$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD holiday_mode enum('DIRECT', 'RESET') not null default 'RESET'";
-
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Urlaubsschaltung wird erst Abends um 00:00 Uhr aktiv und nicht durch die Beantragung. Dies kann nun auch auf direkte Umstellung eingestellt werden.";
+	case 'modify': // When the extension got modified
 		break;
 
-	case "0.1.5": // SQL queries for v0.1.5
-		$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD holiday_mode enum('DIRECT', 'RESET') not null default 'RESET'";
-
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Sicherheitsupdate f&uuml;r die Include-Befehle.";
+	case 'test': // For testing purposes
 		break;
 
-	case "0.1.6": // SQL queries for v0.1.6
-		$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD holiday_activated bigint(20) not null default '0'";
-
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Fehlende Tabellenspalte hinzugef&uuml;gt.";
+	case 'init': // Do stuff when extension is initialized
 		break;
 
-	case "0.1.7": // SQL queries for v0.1.7
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "if-Anweisungen auf Funktion <STRONG>empty()</STRONG> umgestellt.";
+	default: // Unknown extension mode
+		reportBug(__FILE__, __LINE__, sprintf("Unknown extension mode %s in extension %s detected.", getExtensionMode(), getCurrentExtensionName()));
 		break;
+} // END - switch
 
-	case "0.1.8": // SQL queries for v0.1.8
-		$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu_las (la_id, la_action, la_what) VALUES ('member', '', 'list_holiday')";
-		$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu_las (la_id, la_action, la_what) VALUES ('member', '', 'del_holiday')";
-		$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu_las (la_id, la_action, la_what) VALUES ('config', '', 'config_holiday')";
-
-		// Depends on sql_patches (or you have to execute these both SQL statements by phpMyAdmin
-		$EXT_UPDATE_DEPENDS = "sql_patches";
-
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Erweiterung in's neue Men&uuml;system integriert.";
-		break;
-
-	case "0.1.9": // SQL queries for v0.1.9
-		$SQLs[] = "UPDATE "._MYSQL_PREFIX."_member_menu SET action='account', sort='2', title='In Urlaub' WHERE what='holiday' LIMIT 1";
-
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Mitgliedsmen&uuml; komplett umgebaut.";
-		break;
-
-	case "0.2.0": // SQL queries for v0.2.0
-		$SQLs[] = "UPDATE "._MYSQL_PREFIX."_admin_menu SET title = 'Urlaubsmanagement' WHERE action = 'holiday' AND what='' LIMIT 1";
-
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Mitgliedsmen&uuml; komplett umgebaut.";
-		break;
-
-	case "0.2.1": // SQL queries for v0.2.1
-		// Update notes (these will be set as task text!)
-		$UPDATE_NOTES = "Fehlerhinweis bei deaktivierter Erweiterung verbessert.";
-		break;
-	}
-	break;
-
-default: // Do stuff when extension is loaded
-	$dummy = LOAD_CONFIG();
-	// Copy data to config array
-	$_CONFIG['holiday_max']  = $dummy['holiday_max'];  // Maximum days for holiday
-	$_CONFIG['holiday_lock'] = $dummy['holiday_lock']; // Lock deactivation in member area for X seconds
-	$_CONFIG['holiday_mode'] = $dummy['holiday_mode']; // Mode for activating holiday
-	unset($dummy);
-
-	// Do we have a daily-reset-run?
-	if (((defined('__DAILY_RESET')) && ($_CONFIG['holiday_mode'] == "RESET")) || ($_CONFIG['holiday_mode'] == "DIRECT"))
-	{
-		// Ok, let's check for finished holidays and unlock those accounts
-		$INC_POOL[] = PATH."inc/reset/reset_holiday.php";
-	}
-	break;
-}
-
-// Language file prefix
-$EXT_LANG_PREFIX = "holiday";
-
-// Extension is always active?
-$EXT_ALWAYS_ACTIVE = 'N';
-
-//
+// [EOF]
 ?>