X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-rallye.php;h=6b2fb3bdf00f5c8b3a040e23f7aac624cfc7edc7;hb=675778ff98b75b6c5071e2709c2d6b0af86cf79d;hp=a4997d35b3e3199f17c82989711d7136a729f69d;hpb=4f089d36fcc801992932f3a1f47ab139b573a38d;p=mailer.git

diff --git a/inc/extensions/ext-rallye.php b/inc/extensions/ext-rallye.php
index a4997d35b3..6b2fb3bdf0 100644
--- a/inc/extensions/ext-rallye.php
+++ b/inc/extensions/ext-rallye.php
@@ -218,8 +218,8 @@ PRIMARY KEY (id)
 				break;
 
 			case '0.2.0': // SQL queries for v0.2.0
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_rallye_data` ADD min_users BIGINT(20) UNSIGNED NOT NULL DEFAULT 0");
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_rallye_data` ADD min_prices BIGINT(20) UNSIGNED NOT NULL DEFAULT 3");
+				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_rallye_data` ADD `min_users` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0");
+				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_rallye_data` ADD `min_prices` BIGINT(20) UNSIGNED NOT NULL DEFAULT 3");
 
 				// Update notes (these will be set as task text!)
 				setExtensionUpdateNotes("Ablaufen der Rallyes intergriert. Bauen Sie in Ihr Template <strong>templates/de/emails/member/member_rallye_notify.tpl</strong> folgende zwei Zeilen ein:<br />
@@ -329,7 +329,7 @@ Zudem sollten Sie mindestens folgende Templates (in <strong>templates/".getLangu
 	case 'init': // Do stuff when extension is initialized
 		// Do stuff only when not in CSS mode
 		// @TODO Move this code into rallye_functions.php
-		if (getOutputMode() != 1) {
+		if (!isCssOutputMode()) {
 			// Get total member count
 			$total = getTotalConfirmedUser();
 
@@ -337,13 +337,13 @@ Zudem sollten Sie mindestens folgende Templates (in <strong>templates/".getLangu
 			$ADD1 = ''; $ADD2 = ''; $OR = '';
 			if (isExtensionInstalledAndNewer('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)";
+				$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
@@ -363,14 +363,14 @@ LIMIT 1", __FILE__, __LINE__);
 
 			// 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."
+	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 <= UNIX_TIMESTAMP()".$OR.")
+	d.`is_active`='Y' AND
+	d.`notified`='Y' AND
+	d.`expired`='N' AND
+	(d.`end_time` <= UNIX_TIMESTAMP()".$OR.")
 LIMIT 1", __FILE__, __LINE__);
 			if ((SQL_NUMROWS($result) == 1) && (isExtensionActive('autopurge'))) {
 				// End rallye here...