[SPIP Zone] [Spip-zone-commit] r24406 - in /_plugins_/_stable_/selection_d_articles: selection_interface.html selection_interface_fonctions.php

Archives Zone
1

Ainsi que le précise
http://doc.spip.org/@sql_select

la syntaxe est
sql_select ($select, $from, $where, $groupby, $orderby, $limit, $having)

ce qui donne
$result_num = sql_select("ordre", "spip_pb_selection", "id_rubrique=$id_rubrique", "", "ordre DESC", "0,1");

qui devrait marcher partout, sqlite et postgresql compris.

Cédric

Le 17 nov. 08 à 15:46, arno@rezo.net a écrit :

Author: arno@rezo.net
Date: Mon Nov 17 15:46:10 2008
New Revision: 24406

Log:
Correction pour sqlite

Modified:
    _plugins_/_stable_/selection_d_articles/selection_interface.html
    _plugins_/_stable_/selection_d_articles/selection_interface_fonctions.php

Modified: _plugins_/_stable_/selection_d_articles/selection_interface.html

--- _plugins_/_stable_/selection_d_articles/selection_interface.html (original)
+++ _plugins_/_stable_/selection_d_articles/selection_interface.html Mon Nov 17 15:46:10 2008
@@ -32,7 +32,7 @@
     <td style='text-align: center;'>[<a href="?exec=articles&amp;id_article=#ID_ARTICLE"><img src="(#LOGO_ARTICLE||image_reduire{50}|extraire_attribut{src}|url_absolue)" [style="(#LOGO_ARTICLE||image_reduire{50}|extraire_attribut{style})]" /></a>]</td>
     <td class="arial2"><a href="?exec=articles&amp;id_article=#ID_ARTICLE">[(#SURTITRE)<br />]<b>#TITRE</b>[<br />(#SOUSTITRE)]</a></td>
     <td class="arial1">[(#DATE|affdate)]</td>
- <td class="arial1"><b>N°#ID_ARTICLE</b></td>
+ <td class="arial1"><b style="white-space: nowrap;">N°#ID_ARTICLE</b></td>
     [(#EVAL{autoriser('modifier','rubrique', [(#ENV{id_rubrique})])==1}|?{" ",""})
     <td>
       <a title='Retirer de la liste' onclick="$('#pave_selection').load('?exec=selection_interface&id_rubrique=#ENV{id_rubrique}&supprimer_ordre=#ID_ARTICLE'); return false;" href="#"><img src="#CHEMIN{images/croix-rouge.gif}" alt="X" /></a>

Modified: _plugins_/_stable_/selection_d_articles/selection_interface_fonctions.php

--- _plugins_/_stable_/selection_d_articles/selection_interface_fonctions.php (original)
+++ _plugins_/_stable_/selection_d_articles/selection_interface_fonctions.php Mon Nov 17 15:46:10 2008
@@ -23,9 +23,10 @@
     if ($row_test = sql_fetch($result_test)) {
       echo "Cet article est déjà sélectionné.";
     } else {
- $result_num = sql_select("ordre", "spip_pb_selection", "id_rubrique=$id_rubrique", "ordre DESC LIMIT 0,1");
+ // Pas moyen de faire fonctionner le LIMIT 0,1 et l'ordre inverse avec sqlite
+ $result_num = sql_select("ordre", "spip_pb_selection", "id_rubrique=$id_rubrique", "ordre");
       $ordre = 0;
- if ($row_num = sql_fetch($result_num)) {
+ while ($row_num = sql_fetch($result_num)) {
         $ordre = $row_num["ordre"];
       }
       $ordre ++;

_______________________________________________
Spip-zone-commit@rezo.net - http://listes.rezo.net/mailman/listinfo/spip-zone-commit