Language id renamed, some network query amounts added

[mailer.git] / inc / extensions / ext-rallye.php

diff --git a/inc/extensions/ext-rallye.php b/inc/extensions/ext-rallye.php
index 6bdaf75503c913f0e7e6f2515745b1b29acbade4..fe00417623539260fa9ea913acd4c4f617db42a4 100644 (file)
--- a/inc/extensions/ext-rallye.php
+++ b/inc/extensions/ext-rallye.php
@@ -17,7 +17,7 @@
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
- * For more information visit: http://www.mxchange.org                  *
+ * 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 *
@@ -41,10 +41,10 @@ if (!defined('__SECURITY')) {
 } // END - if
 
 // Version number
-setThisExtensionVersion('0.3.5');
+setThisExtensionVersion('0.3.6');
 
 // 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', '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', '0.3.5'));
+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', '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', '0.3.5', '0.3.6'));
 
 switch (getExtensionMode()) {
        case 'register': // Do stuff when installation is running
@@ -63,7 +63,7 @@ switch (getExtensionMode()) {
 `send_notify` ENUM('Y','N') NOT NULL DEFAULT 'Y',
 `notified` ENUM('Y','N') NOT NULL DEFAULT 'N',
 PRIMARY KEY (`id`),
-KEY (`admin_id`)",
+INDEX (`admin_id`)",
                        'Main rallye data');
 
                addDropTableSql('rallye_prices');
@@ -308,7 +308,7 @@ Zudem sollten Sie mindestens folgende Templates (in <strong>templates/".getLangu
                                break;
 
                        case '0.3.5': // SQL queries for 0.3.5
-                               // This update depends on sql_patches
+                               // This update depends on ext-sql_patches
                                addExtensionDependency('sql_patches');
 
                                // Register filter
@@ -317,6 +317,16 @@ Zudem sollten Sie mindestens folgende Templates (in <strong>templates/".getLangu
                                // Update notes (these will be set as task text!)
                                setExtensionUpdateNotes("Filter hinzugef&uuml;gt und ist von <strong>sql_patches</strong> abh&auml;ngig.");
                                break;
+
+                       case '0.3.6': // SQL queries for v0.3.6
+                               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_points_data` (`subject`,`column_name`,`locked_mode`,`payment_method`) VALUES ('rallye_winner','points','LOCKED','DIRECT')");
+
+                               // This depends on ext-sql_patches
+                               addExtensionDependency('sql_patches');
+
+                               // Update notes
+                               setExtensionUpdateNotes("Gewinn aus der Referal-Rallye wird nun &uuml;ber die Tabelle <strong>{OPEN_CONFIG}_MYSQL_PREFIX{CLOSE_CONFIG}_points_data</strong> verwaltet.");
+                               break;
                } // END - switch
                break;
 
@@ -336,14 +346,14 @@ Zudem sollten Sie mindestens folgende Templates (in <strong>templates/".getLangu
                        // Add more data on higher versions
                        $ADD1 = ''; $ADD2 = ''; $OR = '';
                        if (isExtensionInstalledAndNewer('rallye', '0.2.0')) {
-                               $ADD1 = ", `min_users`, `min_prices`";
+                               $ADD1 = ", `min_users`,`min_prices`";
                                $ADD2 = ", d.`min_users`, d.`min_prices`";
                                $OR   = " OR (d.`min_users` <= " . $total . " AND d.`min_users` > 0)";
                        } // END  - if
 
                        // Check for new started but not notified rallyes
                        $result = SQL_QUERY("SELECT SQL_SMALL_RESULT
-       `id`, `title`, `start_time`, `end_time`, `send_notify`" . $ADD1 . "
+       `id`,`title`,`start_time`,`end_time`,`send_notify`" . $ADD1 . "
 FROM
        `{?_MYSQL_PREFIX?}_rallye_data`
 WHERE