Conversion from float to string is dependent on locale

[GoogleCodeExporter]

String cast gives floats like "1,12" with the german locale and MySQL doesn't 
like that.

Possible Patch:

--- sk2/sk2_core_class.php      2009-05-14 12:40:20.000000000 +0200
+++ spam-karma2/sk2_core_class.php      2011-12-14 11:25:57.000000000 +0100
@@ -663,8 +663,10 @@
                                continue;
                        if (is_array($val))
                                $val = serialize($val);
-                       if (is_int($val) || is_float($val))
+                       if (is_int($val))
                                $query .= "`$key` = " . $val . ",";
+                       elseif (is_float($val))
+                               $query .= "`$key` = " . sprintf("%F", $val) . 
",";
                        else
                                $query .= "`$key` = '" . sk2_escape_string($val) . "', ";

Original issue reported on code.google.com by philipp....@gmail.com on 14 Dec 2011 at 10:34

[GoogleCodeExporter]

Attaching patch per Philipp's suggestion.

Original comment by stephen....@gmail.com on 4 Mar 2012 at 5:08

• Added labels: has-patch

Attachments:

• SKissue_27_Stutz_patch.diff

[GoogleCodeExporter]

Original comment by stephen....@gmail.com on 4 Mar 2012 at 5:09

• Changed state: HasPatch
• Removed labels: has-patch

[strider72]

Marked "Help Wanted". Would be great if a German speaker could test this patch.

[strider72]

New branch to test this: See "stutz-patch" branch