From 6b0b03e60c1ab6fbdee3c5c4477cb5bcbc2f03ae Mon Sep 17 00:00:00 2001
From: =?utf8?q?Roland=20H=C3=A4der?= <roland@mxchange.org>
Date: Tue, 23 Oct 2012 14:37:46 +0000
Subject: [PATCH] Fix for broken SQL

---
 inc/language/coupon_de.php | 1 +
 inc/language/de.php        | 1 +
 inc/mysql-manager.php      | 2 +-
 3 files changed, 3 insertions(+), 1 deletion(-)

diff --git a/inc/language/coupon_de.php b/inc/language/coupon_de.php
index 2f7625386b..bd9f73ee48 100644
--- a/inc/language/coupon_de.php
+++ b/inc/language/coupon_de.php
@@ -101,6 +101,7 @@ addMessages(array(
 
 	// Point account subjects
 	'POINTS_SUBJECT_COUPON_CASHED' => "Einl&ouml;sung eines Gutscheins",
+	'POINTS_SUBJECT_CASHED_COUPON' => "Mitglied hat Gutschein eingel&ouml;st",
 ));
 
 // [EOF]
diff --git a/inc/language/de.php b/inc/language/de.php
index 29c3421af2..cf89482481 100644
--- a/inc/language/de.php
+++ b/inc/language/de.php
@@ -1297,6 +1297,7 @@ addMessages(array(
 	'POINTS_ACCOUNT_TYPE_UNKNOWN'       => "Unbekannter Guthabenkontotyp <span class=\"data\">%s</span> erkannt.",
 	'POINTS_ACCOUNT_TYPE_POINTS'        => "Allgemeinguthaben",
 	'POINTS_ACCOUNT_TYPE_LOCKED_POINTS' => "Gesperrtes Allgemeinguthaben",
+	'POINTS_ACCOUNT_TYPE_USED_POINTS'   => "Abzug",
 
 	// Generic: points "locked mode"
 	'POINTS_LOCKED_MODE_UNKNOWN'  => "Unbekannter Guthabensperrmodus <span class=\"data\">%s</span> erkannt.",
diff --git a/inc/mysql-manager.php b/inc/mysql-manager.php
index 82aca4d8c4..d409f4a3fd 100644
--- a/inc/mysql-manager.php
+++ b/inc/mysql-manager.php
@@ -1619,7 +1619,7 @@ function addBonusMailToQueue ($subject, $text, $receiverList, $points, $seconds,
 	`html_msg`
 ) VALUES (
 	'%s',
-	%s',
+	'%s',
 	'%s',
 	%s,
 	%s,
-- 
2.39.2