Author: esj@rezo.net
Date: 2007-10-04 17:34:06 +0200 (jeu, 04 oct 2007)
New Revision: 10509
Log:
Abstraction des clauses avec WHERE, avec ORDER BY seul
Dépot obtenu par:
{{{
for i in $(grep -l 'spip_query..SELECT.*FROM.*WHERE[^E]* ORDER BY[^GL]*; *$' [a-i]*/*php|grep -v inc/meta.php)
do
echo $i
sed 's/spip_query..SELECT *\(.*[^ ]\) *FROM *\(.*[^ ]\) *WHERE *\([^E]*[^ ]\) *ORDER BY *\([^HL]*;\) *$/sql_select("\1", "\2", "\3", "", "\4/;s/ "" *\.//;s/ch(sql_select\(.*\));/sel\1;/' $i > x
mv x $i
done
}}}
et interventions manuelles dans inc/auth et mots_edit.
Modified:
spip/ecrire/exec/accueil.php
spip/ecrire/exec/articles_tous.php
spip/ecrire/exec/articles_versions.php
spip/ecrire/exec/brouteur_frame.php
spip/ecrire/exec/documents_liste.php
spip/ecrire/exec/message.php
spip/ecrire/exec/mots_edit.php
spip/ecrire/exec/rechercher_auteur.php
spip/ecrire/exec/statistiques_visites.php
spip/ecrire/genie/syndic.php
spip/ecrire/inc/agenda.php
spip/ecrire/inc/auth.php
spip/ecrire/inc/documents.php
spip/ecrire/inc/editer_auteurs.php
spip/ecrire/inc/editer_mot.php
spip/ecrire/inc/instituer_auteur.php
spip/ecrire/inc/presentation.php