-<?php\r
-/************************************************************************\r
- * MXChange v0.2.1 Start: 06/19/2004 *\r
- * ================ Last change: 12/26/2004 *\r
- * *\r
- * -------------------------------------------------------------------- *\r
- * File : ext-rallye.php *\r
- * -------------------------------------------------------------------- *\r
- * Short description : Referal rallye *\r
- * -------------------------------------------------------------------- *\r
- * Kurzbeschreibung : Ref-Rallyes starten *\r
- * -------------------------------------------------------------------- *\r
- * *\r
- * -------------------------------------------------------------------- *\r
- * Copyright (c) 2003 - 2008 by Roland Haeder *\r
- * For more information visit: http://www.mxchange.org *\r
- * *\r
- * This program is free software; you can redistribute it and/or modify *\r
- * it under the terms of the GNU General Public License as published by *\r
- * the Free Software Foundation; either version 2 of the License, or *\r
- * (at your option) any later version. *\r
- * *\r
- * This program is distributed in the hope that it will be useful, *\r
- * but WITHOUT ANY WARRANTY; without even the implied warranty of *\r
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *\r
- * GNU General Public License for more details. *\r
- * *\r
- * You should have received a copy of the GNU General Public License *\r
- * along with this program; if not, write to the Free Software *\r
- * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *\r
- * MA 02110-1301 USA *\r
- ************************************************************************/\r
-\r
-// Some security stuff...\r
-if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])))\r
-{\r
- $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";\r
- require($INC);\r
-}\r
-\r
-// Version number\r
-$EXT_VERSION = "0.3.4";\r
-\r
-// Auto-set extension version\r
-if (empty($EXT_VER)) $EXT_VER = $EXT_VERSION;\r
-\r
-// Version history array (add more with , "0.1" and so on)\r
-$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", "0.2.2", "0.2.3", "0.2.4", "0.2.5", "0.2.6", "0.2.7", "0.2.8", "0.2.9", "0.3.0", "0.3.1", "0.3.2", "0.3.3", "0.3.4");\r
-\r
-switch ($EXT_LOAD_MODE)\r
-{\r
-case "register": // Do stuff when installtion is running (modules.php?module=admin&action=login is called)\r
- // SQL commands to run\r
- $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_data";\r
- $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_prices";\r
- $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_users";\r
- $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_rallye_data (\r
-id bigint(20) not null auto_increment,\r
-admin_id bigint(20) not null default '0',\r
-title varchar(255) not null default '',\r
-descr longblob not null,\r
-template varchar(255) not null default '',\r
-start_time varchar(10) not null default '0',\r
-end_time varchar(10) not null default '0',\r
-auto_add_new_user enum('Y', 'N') not null default 'Y',\r
-is_active enum('Y', 'N') not null default 'N',\r
-send_notify enum('Y', 'N') not null default 'Y',\r
-notified enum('Y', 'N') not null default 'N',\r
-KEY (admin_id),\r
-PRIMARY KEY (id)\r
-) TYPE=MyISAM";\r
- $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_rallye_prices (\r
-id bigint(20) not null auto_increment,\r
-rallye_id bigint(20) not null default '0',\r
-price_level bigint(20) not null default '0',\r
-points bigint(20) not null default '0',\r
-info longblob not null,\r
-KEY (rallye_id),\r
-PRIMARY KEY(id)\r
-) TYPE=MyISAM";\r
- $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_rallye_users (\r
-id bigint(20) not null auto_increment,\r
-rallye_id bigint(20) not null default '0',\r
-userid bigint(20) not null default '0',\r
-refs bigint(20) not null default '0',\r
-KEY (rallye_id),\r
-KEY (userid),\r
-PRIMARY KEY(id)\r
-) TYPE=MyISAM";\r
- // Admin menu\r
- $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('rallye', '', 'Rallye-Management', 'Richten Sie neue Ref-Rallyes ein, die zeitgesteuert anfangen und aufhöhren. Dabei wird alles weitere automatisch geregelt.', '9')";\r
- $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('rallye', 'add_rallye', 'Neue Rallye hinzufügen', 'Neue Ref-Rallye hinzufügen.', '1')";\r
- $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('rallye', 'config_rallye_prices', 'Preise einrichten', 'Richten Sie Preise zu den Rallyes ein.', '2')";\r
- $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('rallye', 'list_rallyes', 'Rallyes verwalten', 'Alle bestehenden Ref-Rallyes auflisten, bearbeiten, stoppen, löschen usw.', '3')";\r
- // Guest menu\r
- $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_guest_menu (action, what, title, visible, locked, sort) VALUES ('main', 'rallyes', 'Ref-Rallyes', 'Y', 'Y', '9')";\r
- // Member menu\r
- $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (action, what, title, visible, locked, sort) VALUES('main', 'rallyes', 'Ref-Rallyes', 'Y', 'Y', '9')";\r
- break;\r
-\r
-case "remove": // Do stuff when removing extension\r
- // SQL commands to run\r
- $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_data";\r
- $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_prices";\r
- $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_users";\r
- $SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_admin_menu WHERE action='rallye' LIMIT 4";\r
- $SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_guest_menu WHERE what='rallye' LIMIT 1";\r
- $SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_member_menu WHERE what='rallye' LIMIT 1";\r
- break;\r
-\r
-case "activate": // Do stuff when admin activates this extension\r
- // SQL commands to run\r
- $SQLs[] = "UPDATE "._MYSQL_PREFIX."_guest_menu SET visible='Y', locked='N' WHERE what='rallyes' LIMIT 1";\r
- $SQLs[] = "UPDATE "._MYSQL_PREFIX."_member_menu SET visible='Y', locked='N' WHERE what='rallyes' LIMIT 1";\r
- break;\r
-\r
-case "deactivate": // Do stuff when admin deactivates this extension\r
- // SQL commands to run\r
- $SQLs[] = "UPDATE "._MYSQL_PREFIX."_guest_menu SET visible='Y', locked='Y' WHERE what='rallyes' LIMIT 1";\r
- $SQLs[] = "UPDATE "._MYSQL_PREFIX."_member_menu SET visible='Y', locked='Y' WHERE what='rallyes' LIMIT 1";\r
- break;\r
-\r
-case "update": // Update an extension\r
- switch ($EXT_VER)\r
- {\r
- case "0.0.1": // SQL queries for v0.0.1\r
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD expired enum('Y', 'N') not null default 'N'";\r
-\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Ablaufen der Rallyes intergriert.";\r
- break;\r
-\r
- case "0.0.2": // SQL queries for v0.0.2\r
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_users ADD curr_points double(23,3) not null default '0.000'";\r
-\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Aktueller {!POINTS!}-Stand wird beachtet.";\r
- break;\r
-\r
- case "0.0.6": // SQL queries for v0.0.6\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Fehler <I>Unknown column 'd.useid' in 'on clause'</I> behoben.";\r
- break;\r
-\r
- case "0.0.7": // SQL queries for v0.0.7\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Fehlende Abfrage im Mitlieder-Modul, on Erweiterung auch aktiviert ist.";\r
- break;\r
-\r
- case "0.0.8": // SQL queries for v0.0.8\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Fehler <U>Template nicht gefunden</U> behoben und Admin-Formulare ausgelagert";\r
- break;\r
-\r
- case "0.0.9": // SQL queries for v0.0.9\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Fehler beseitigt, wenn error_reporting=E_ALL gesetzt ist. Und der vorherige Fehler <U>Template nicht gefunden</U> ist endlich beseitigt.";\r
- break;\r
-\r
- case "0.1.0": // SQL queries for v0.1.0\r
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_users CHANGE curr_points curr_points double(23,5) not null default '0.00000'";\r
-\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "5 Nachkommastellen implementiert.";\r
- break;\r
-\r
- case "0.1.1": // SQL queries for v0.1.1\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Fehler beseitigt, wenn error_reporting=E_ALL gesetzt ist.";\r
- break;\r
-\r
- case "0.1.2": // SQL queries for v0.1.2\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Problem mit Speicherung der Einstellungen beseitigt.";\r
- break;\r
-\r
- case "0.1.3": // SQL queries for v0.1.3\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Anzeigefehler im Gast-/Mitgliedsbereich behoben.";\r
- break;\r
-\r
- case "0.1.4": // SQL queries for v0.1.4\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Admin-Mails korregiert.";\r
- break;\r
-\r
- case "0.1.5": // SQL queries for v0.1.5\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Menüpunkte im Gast-/Mitgliedsbereich können nicht mehr aufgerufen werden, wenn die Erweiterung deaktiviert ist.";\r
- break;\r
-\r
- case "0.1.6": // SQL queries for v0.1.6\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Seit <A href=\"".SERVER_URL."/patches/340-Gast_Mitgliedsmenue_Deaktivieren.zip\">Patch 340</A> überflüssige HTML-Tags entfernt.";\r
- break;\r
-\r
- case "0.1.7": // SQL queries for v0.1.7\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Aktivierte bzw. abgelaufene Rallyes werden nur ausserhalb des CSS-Modus geladen (wenn also nicht css.php aufgerufen wurde)";\r
- break;\r
-\r
- case "0.1.8": // SQL queries for v0.1.8\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Weitere Templates vom Admin-Bereich ausgelagert und Referral-Anazahl in der Mail zur Rallye-Ankündigung repariert.";\r
- break;\r
-\r
- case "0.1.9": // SQL queries for v0.1.9\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Funktion ADMIN_USER_PROFILE_LINK() mit Verlinkung auf Referral-Liste implementiert.";\r
- break;\r
-\r
- case "0.2.0": // SQL queries for v0.2.0\r
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD min_users bigint(20) not null default '0'";\r
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD min_prices bigint(20) not null default '3'";\r
-\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Ablaufen der Rallyes intergriert. Bauen Sie in Ihr Template <STRONG>templates/de/emails/member/member_rallye_notifty.tpl</STRONG> folgende zwei Zeilen ein:<BR>\r
-<UL>\r
- <LI>$DATA[min_users]</LI>\r
- <LI>$DATA[min_prices]</LI>\r
-</UL>\r
-Zudem sollten Sie mindestens folgende Templates (in <STRONG>templates/".GET_LANGUAGE()."/html/guest/</STRONG> !) aktualisieren:<BR>\r
-<UL>\r
- <LI><STRONG>guest_rallye_footer.tpl</STRONG></LI>\r
- <LI><STRONG>guest_rallye_header.tpl</STRONG></LI>\r
-</UL>";\r
- break;\r
-\r
- case "0.2.1": // SQL queries for v0.2.1\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Wörter <STRONG>Mailtausch</STRONG>, <STRONG>Mailtausches</STRONG> und <STRONG>Mailtauscher</STRONG> sind austauschbar.";\r
- break;\r
-\r
- case "0.2.2": // SQL queries for v0.2.2\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Links wegen <STRONG>what=admins_contct</STRONG> geändert.";\r
- break;\r
-\r
- case "0.2.3": // SQL queries for v0.2.3\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "HTML-Code ausgelagert in Templates und SQL-Anweisungen abgesichert.";\r
- break;\r
-\r
- case "0.2.4": // SQL queries for v0.2.4\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Abspeichern von Einstellungen repariert.";\r
- break;\r
-\r
- case "0.2.5": // SQL queries for v0.2.5\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Menüpunkt "Rallyes verwalten" repariert.";\r
- break;\r
-\r
- case "0.2.6": // SQL queries for v0.2.6\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Automatisches Starten von Referral-Rallyes repariert.";\r
- break;\r
-\r
- case "0.2.7": // SQL queries for v0.2.7\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Fatalen Fehler beseitigt.";\r
- break;\r
-\r
- case "0.2.8": // SQL queries for v0.2.8\r
- // Update notes (these will be set as task text!)\r
-\r
- $UPDATE_NOTES = "Vorbereitung auf die neue Mediendaten v0.0.4.";\r
- break;\r
-\r
- case "0.2.9": // SQL queries for v0.2.9\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Sicherheitsupdate für die Include-Befehle.";\r
- break;\r
-\r
- case "0.3.0": // SQL queries for v0.3.0\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "if-Anweisungen auf Funktion <STRONG>empty()</STRONG> umgestellt.";\r
- break;\r
-\r
- case "0.3.1": // SQL queries for v0.3.1\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Erweiterung für automatisch generierte Admin-Kontaktlinks geändert.";\r
- break;\r
-\r
- case "0.3.2": // SQL queries for v0.3.2\r
- $SQLs[] = "UPDATE "._MYSQL_PREFIX."_member_menu SET action='rals', sort='1', title='Referral-Rallye' WHERE what='rallyes' LIMIT 1";\r
-\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Mitgliedsmenü komplett umgebaut.";\r
- break;\r
-\r
- case "0.3.3": // SQL queries for v0.3.3\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Rallyes werden nun nur dann automatisch beseitigt, wenn die Erweiterung <strong>autopurge</strong> installiert und aktiviert ist.";\r
- break;\r
-\r
- case "0.3.4": // SQL queries for v0.3.4\r
- // Update notes (these will be set as task text!)\r
- $UPDATE_NOTES = "Fehlerhinweis bei deaktivierter Erweiterung verbessert.";\r
- break;\r
- }\r
- break;\r
-\r
-default: // Do stuff when extension is loaded\r
- // Do stuff only when not in CSS mode\r
- if (($CSS != "1") && ($CSS != "-1"))\r
- {\r
- // Get total member count\r
- $TOTAL = GET_TOTAL_DATA("CONFIRMED", "user_data", "userid", "status", true);\r
-\r
- // Add more data on higher versions\r
- $ADD1 = ""; $ADD2 = ""; $OR = "";\r
- if (GET_EXT_VERSION("rallye") >= "0.2.0")\r
- {\r
- $ADD1 = ", min_users, min_prices";\r
- $ADD2 = ", d.min_users, d.min_prices";\r
- $OR = " OR (d.min_users <= ".$TOTAL." AND d.min_users > 0)";\r
- }\r
-\r
- // Check for new started but not notified rallyes\r
- $result = SQL_QUERY("SELECT SQL_SMALL_RESULT id, title, start_time, end_time, send_notify".$ADD1."\r
-FROM "._MYSQL_PREFIX."_rallye_data\r
-WHERE is_active='Y' AND notified='N' AND expired='N' AND start_time <= ".time()." AND end_time > ".time()."\r
-LIMIT 1", __FILE__, __LINE__);\r
- if (SQL_NUMROWS($result) == 1)\r
- {\r
- // Start rallye\r
- RALLYE_AUTOSTART_RALLYES($result);\r
- }\r
-\r
- // Free memory\r
- SQL_FREERESULT($result);\r
-\r
- // Check for expired rallyes\r
- $result = SQL_QUERY("SELECT SQL_SMALL_RESULT d.id, d.title, d.start_time, d.end_time, d.send_notify".$ADD2."\r
-FROM "._MYSQL_PREFIX."_rallye_data AS d\r
-WHERE d.is_active='Y' AND d.notified='Y' AND d.expired='N' AND (d.end_time <= ".time()."".$OR.")\r
-LIMIT 1", __FILE__, __LINE__);\r
- if ((SQL_NUMROWS($result) == 1) && (EXT_IS_ACTIVE("autopurge")))\r
- {\r
- // End rallye here...\r
- RALLYE_EXPIRE_RALLYES($result);\r
- }\r
-\r
- // Free memory\r
- SQL_FREERESULT($result);\r
- }\r
- break;\r
-}\r
-\r
-// Language file prefix\r
-$EXT_LANG_PREFIX = "rallye";\r
-\r
-// Extension is always active?\r
-$EXT_ALWAYS_ACTIVE = "N";\r
-\r
-//\r
-?>\r
+<?php
+/************************************************************************
+ * MXChange v0.2.1 Start: 06/19/2004 *
+ * ================ Last change: 12/26/2004 *
+ * *
+ * -------------------------------------------------------------------- *
+ * File : ext-rallye.php *
+ * -------------------------------------------------------------------- *
+ * Short description : Referal rallye *
+ * -------------------------------------------------------------------- *
+ * Kurzbeschreibung : Ref-Rallyes starten *
+ * -------------------------------------------------------------------- *
+ * *
+ * -------------------------------------------------------------------- *
+ * Copyright (c) 2003 - 2008 by Roland Haeder *
+ * For more information visit: http://www.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 *
+ * 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., 51 Franklin St, Fifth Floor, Boston, *
+ * MA 02110-1301 USA *
+ ************************************************************************/
+
+// Some security stuff...
+if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])))
+{
+ $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
+ require($INC);
+}
+
+// Version number
+$EXT_VERSION = "0.3.4";
+
+// 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", "0.2.2", "0.2.3", "0.2.4", "0.2.5", "0.2.6", "0.2.7", "0.2.8", "0.2.9", "0.3.0", "0.3.1", "0.3.2", "0.3.3", "0.3.4");
+
+switch ($EXT_LOAD_MODE)
+{
+case "register": // Do stuff when installtion is running (modules.php?module=admin&action=login is called)
+ // SQL commands to run
+ $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_data";
+ $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_prices";
+ $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_users";
+ $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_rallye_data (
+id bigint(20) not null auto_increment,
+admin_id bigint(20) not null default '0',
+title varchar(255) not null default '',
+descr longblob not null,
+template varchar(255) not null default '',
+start_time varchar(10) not null default '0',
+end_time varchar(10) not null default '0',
+auto_add_new_user enum('Y', 'N') not null default 'Y',
+is_active enum('Y', 'N') not null default 'N',
+send_notify enum('Y', 'N') not null default 'Y',
+notified enum('Y', 'N') not null default 'N',
+KEY (admin_id),
+PRIMARY KEY (id)
+) TYPE=MyISAM";
+ $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_rallye_prices (
+id bigint(20) not null auto_increment,
+rallye_id bigint(20) not null default '0',
+price_level bigint(20) not null default '0',
+points bigint(20) not null default '0',
+info longblob not null,
+KEY (rallye_id),
+PRIMARY KEY(id)
+) TYPE=MyISAM";
+ $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_rallye_users (
+id bigint(20) not null auto_increment,
+rallye_id bigint(20) not null default '0',
+userid bigint(20) not null default '0',
+refs bigint(20) not null default '0',
+KEY (rallye_id),
+KEY (userid),
+PRIMARY KEY(id)
+) TYPE=MyISAM";
+ // Admin menu
+ $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('rallye', '', 'Rallye-Management', 'Richten Sie neue Ref-Rallyes ein, die zeitgesteuert anfangen und aufhöhren. Dabei wird alles weitere automatisch geregelt.', '9')";
+ $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('rallye', 'add_rallye', 'Neue Rallye hinzufügen', 'Neue Ref-Rallye hinzufügen.', '1')";
+ $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('rallye', 'config_rallye_prices', 'Preise einrichten', 'Richten Sie Preise zu den Rallyes ein.', '2')";
+ $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('rallye', 'list_rallyes', 'Rallyes verwalten', 'Alle bestehenden Ref-Rallyes auflisten, bearbeiten, stoppen, löschen usw.', '3')";
+ // Guest menu
+ $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_guest_menu (action, what, title, visible, locked, sort) VALUES ('main', 'rallyes', 'Ref-Rallyes', 'Y', 'Y', '9')";
+ // Member menu
+ $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (action, what, title, visible, locked, sort) VALUES('main', 'rallyes', 'Ref-Rallyes', 'Y', 'Y', '9')";
+ break;
+
+case "remove": // Do stuff when removing extension
+ // SQL commands to run
+ $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_data";
+ $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_prices";
+ $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_users";
+ $SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_admin_menu WHERE action='rallye' LIMIT 4";
+ $SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_guest_menu WHERE what='rallye' LIMIT 1";
+ $SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_member_menu WHERE what='rallye' LIMIT 1";
+ break;
+
+case "activate": // Do stuff when admin activates this extension
+ // SQL commands to run
+ $SQLs[] = "UPDATE "._MYSQL_PREFIX."_guest_menu SET visible='Y', locked='N' WHERE what='rallyes' LIMIT 1";
+ $SQLs[] = "UPDATE "._MYSQL_PREFIX."_member_menu SET visible='Y', locked='N' WHERE what='rallyes' LIMIT 1";
+ break;
+
+case "deactivate": // Do stuff when admin deactivates this extension
+ // SQL commands to run
+ $SQLs[] = "UPDATE "._MYSQL_PREFIX."_guest_menu SET visible='Y', locked='Y' WHERE what='rallyes' LIMIT 1";
+ $SQLs[] = "UPDATE "._MYSQL_PREFIX."_member_menu SET visible='Y', locked='Y' WHERE what='rallyes' LIMIT 1";
+ break;
+
+case "update": // Update an extension
+ switch ($EXT_VER)
+ {
+ case "0.0.1": // SQL queries for v0.0.1
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD expired enum('Y', 'N') not null default 'N'";
+
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Ablaufen der Rallyes intergriert.";
+ break;
+
+ case "0.0.2": // SQL queries for v0.0.2
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_users ADD curr_points double(23,3) not null default '0.000'";
+
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Aktueller {!POINTS!}-Stand wird beachtet.";
+ break;
+
+ case "0.0.6": // SQL queries for v0.0.6
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Fehler <I>Unknown column 'd.useid' in 'on clause'</I> behoben.";
+ break;
+
+ case "0.0.7": // SQL queries for v0.0.7
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Fehlende Abfrage im Mitlieder-Modul, on Erweiterung auch aktiviert ist.";
+ break;
+
+ case "0.0.8": // SQL queries for v0.0.8
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Fehler <U>Template nicht gefunden</U> behoben und Admin-Formulare ausgelagert";
+ break;
+
+ case "0.0.9": // SQL queries for v0.0.9
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Fehler beseitigt, wenn error_reporting=E_ALL gesetzt ist. Und der vorherige Fehler <U>Template nicht gefunden</U> ist endlich beseitigt.";
+ break;
+
+ case "0.1.0": // SQL queries for v0.1.0
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_users CHANGE curr_points curr_points double(23,5) not null default '0.00000'";
+
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "5 Nachkommastellen implementiert.";
+ break;
+
+ case "0.1.1": // SQL queries for v0.1.1
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Fehler beseitigt, wenn error_reporting=E_ALL gesetzt ist.";
+ break;
+
+ case "0.1.2": // SQL queries for v0.1.2
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Problem mit Speicherung der Einstellungen beseitigt.";
+ break;
+
+ case "0.1.3": // SQL queries for v0.1.3
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Anzeigefehler im Gast-/Mitgliedsbereich behoben.";
+ break;
+
+ case "0.1.4": // SQL queries for v0.1.4
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Admin-Mails korregiert.";
+ break;
+
+ case "0.1.5": // SQL queries for v0.1.5
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Menüpunkte im Gast-/Mitgliedsbereich können nicht mehr aufgerufen werden, wenn die Erweiterung deaktiviert ist.";
+ break;
+
+ case "0.1.6": // SQL queries for v0.1.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> überflüssige HTML-Tags entfernt.";
+ break;
+
+ case "0.1.7": // SQL queries for v0.1.7
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Aktivierte bzw. abgelaufene Rallyes werden nur ausserhalb des CSS-Modus geladen (wenn also nicht css.php aufgerufen wurde)";
+ break;
+
+ case "0.1.8": // SQL queries for v0.1.8
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Weitere Templates vom Admin-Bereich ausgelagert und Referral-Anazahl in der Mail zur Rallye-Ankündigung repariert.";
+ break;
+
+ case "0.1.9": // SQL queries for v0.1.9
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Funktion ADMIN_USER_PROFILE_LINK() mit Verlinkung auf Referral-Liste implementiert.";
+ break;
+
+ case "0.2.0": // SQL queries for v0.2.0
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD min_users bigint(20) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD min_prices bigint(20) not null default '3'";
+
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Ablaufen der Rallyes intergriert. Bauen Sie in Ihr Template <STRONG>templates/de/emails/member/member_rallye_notifty.tpl</STRONG> folgende zwei Zeilen ein:<BR>
+<UL>
+ <LI>$DATA[min_users]</LI>
+ <LI>$DATA[min_prices]</LI>
+</UL>
+Zudem sollten Sie mindestens folgende Templates (in <STRONG>templates/".GET_LANGUAGE()."/html/guest/</STRONG> !) aktualisieren:<BR>
+<UL>
+ <LI><STRONG>guest_rallye_footer.tpl</STRONG></LI>
+ <LI><STRONG>guest_rallye_header.tpl</STRONG></LI>
+</UL>";
+ break;
+
+ case "0.2.1": // SQL queries for v0.2.1
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Wörter <STRONG>Mailtausch</STRONG>, <STRONG>Mailtausches</STRONG> und <STRONG>Mailtauscher</STRONG> sind austauschbar.";
+ break;
+
+ case "0.2.2": // SQL queries for v0.2.2
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Links wegen <STRONG>what=admins_contct</STRONG> geändert.";
+ break;
+
+ case "0.2.3": // SQL queries for v0.2.3
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "HTML-Code ausgelagert in Templates und SQL-Anweisungen abgesichert.";
+ break;
+
+ case "0.2.4": // SQL queries for v0.2.4
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Abspeichern von Einstellungen repariert.";
+ break;
+
+ case "0.2.5": // SQL queries for v0.2.5
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Menüpunkt "Rallyes verwalten" repariert.";
+ break;
+
+ case "0.2.6": // SQL queries for v0.2.6
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Automatisches Starten von Referral-Rallyes repariert.";
+ break;
+
+ case "0.2.7": // SQL queries for v0.2.7
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Fatalen Fehler beseitigt.";
+ break;
+
+ case "0.2.8": // SQL queries for v0.2.8
+ // Update notes (these will be set as task text!)
+
+ $UPDATE_NOTES = "Vorbereitung auf die neue Mediendaten v0.0.4.";
+ break;
+
+ case "0.2.9": // SQL queries for v0.2.9
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Sicherheitsupdate für die Include-Befehle.";
+ break;
+
+ case "0.3.0": // SQL queries for v0.3.0
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "if-Anweisungen auf Funktion <STRONG>empty()</STRONG> umgestellt.";
+ break;
+
+ case "0.3.1": // SQL queries for v0.3.1
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Erweiterung für automatisch generierte Admin-Kontaktlinks geändert.";
+ break;
+
+ case "0.3.2": // SQL queries for v0.3.2
+ $SQLs[] = "UPDATE "._MYSQL_PREFIX."_member_menu SET action='rals', sort='1', title='Referral-Rallye' WHERE what='rallyes' LIMIT 1";
+
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Mitgliedsmenü komplett umgebaut.";
+ break;
+
+ case "0.3.3": // SQL queries for v0.3.3
+ // Update notes (these will be set as task text!)
+ $UPDATE_NOTES = "Rallyes werden nun nur dann automatisch beseitigt, wenn die Erweiterung <strong>autopurge</strong> installiert und aktiviert ist.";
+ break;
+
+ case "0.3.4": // SQL queries for v0.3.4
+ // 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
+ // Do stuff only when not in CSS mode
+ if (($CSS != "1") && ($CSS != "-1"))
+ {
+ // Get total member count
+ $TOTAL = GET_TOTAL_DATA("CONFIRMED", "user_data", "userid", "status", true);
+
+ // Add more data on higher versions
+ $ADD1 = ""; $ADD2 = ""; $OR = "";
+ if (GET_EXT_VERSION("rallye") >= "0.2.0")
+ {
+ $ADD1 = ", min_users, min_prices";
+ $ADD2 = ", d.min_users, d.min_prices";
+ $OR = " OR (d.min_users <= ".$TOTAL." AND d.min_users > 0)";
+ }
+
+ // Check for new started but not notified rallyes
+ $result = SQL_QUERY("SELECT SQL_SMALL_RESULT id, title, start_time, end_time, send_notify".$ADD1."
+FROM "._MYSQL_PREFIX."_rallye_data
+WHERE is_active='Y' AND notified='N' AND expired='N' AND start_time <= ".time()." AND end_time > ".time()."
+LIMIT 1", __FILE__, __LINE__);
+ if (SQL_NUMROWS($result) == 1)
+ {
+ // Start rallye
+ RALLYE_AUTOSTART_RALLYES($result);
+ }
+
+ // Free memory
+ SQL_FREERESULT($result);
+
+ // Check for expired rallyes
+ $result = SQL_QUERY("SELECT SQL_SMALL_RESULT d.id, d.title, d.start_time, d.end_time, d.send_notify".$ADD2."
+FROM "._MYSQL_PREFIX."_rallye_data AS d
+WHERE d.is_active='Y' AND d.notified='Y' AND d.expired='N' AND (d.end_time <= ".time()."".$OR.")
+LIMIT 1", __FILE__, __LINE__);
+ if ((SQL_NUMROWS($result) == 1) && (EXT_IS_ACTIVE("autopurge")))
+ {
+ // End rallye here...
+ RALLYE_EXPIRE_RALLYES($result);
+ }
+
+ // Free memory
+ SQL_FREERESULT($result);
+ }
+ break;
+}
+
+// Language file prefix
+$EXT_LANG_PREFIX = "rallye";
+
+// Extension is always active?
+$EXT_ALWAYS_ACTIVE = "N";
+
+//
+?>