Changeset 48489 in spip-zone

Timestamp:

Jun 4, 2011, 11:28:32 PM (10 years ago)

Author:

denisb@…

Message:

svp : la requete sql ne se termine pas sur le where...

File:

• _plugins_/svp/inc/where_compatible_spip.php (modified) (2 diffs)

_plugins_/svp/inc/where_compatible_spip.php

@@ -20 +20 @@
         ELSE TRIM(LEADING \'[\' FROM '.$min.') <= \''.$version.'\'
         END
-        AND
+AND
         CASE WHEN '.$max.' = \'\'
         OR '.$max.' = \']\'
@@ -35 +35 @@
         // le critere s'applique a une BRANCHE (1.9, 2.0, ...)
         elseif (count(explode('.', $version)) == 2) {
-                $where = 'LOCATE(\''.$version.'\', '.$table.'.branches_spip) '.$op.' 0;';
+                $where = 'LOCATE(\''.$version.'\', '.$table.'.branches_spip) '.$op.' 0';
         }
         // le critere est vide ou mal specifie
         else {
-                $where = '\'1=1\';';
+                $where = '1=1';
         }