Fix random queries (such as for the random image block) for locales that don't use a period as decimal separator of floating point numbers (such as de_DE).

(Integrating a fix Kohana's SQL generation for floating point numbers. See http://dev.kohanaframework.org/issues/2636.)

1 files changed, 5 insertions, 0 deletions

diff --git a/system/libraries/Database.php b/system/libraries/Database.php
index 98e33fa0..253bb152 100644
--- a/system/libraries/Database.php
+++ b/system/libraries/Database.php
@@ -420,6 +420,11 @@ abstract class Database_Core {
 		{
 			return (string) $value;
 		}
+		elseif (is_float($value))
+		{
+			// Convert to non-locale aware float to prevent possible commas
+			return sprintf('%F', $value);
+		}
 
 		return '\''.$this->escape($value).'\'';
 	}