Changeset 112727 in spip-zone

Timestamp:

Dec 11, 2018, 5:35:00 PM (2 months ago)

Author:

cedric@…

Message:

Correction de r112420 qui ne marchait pas le update avec clause sub select etant refuse dans ce cas

Location:

_plugins_/mailsubscribers/trunk

Files:

• inc/mailsubscribinglists.php (modified) (1 diff)
• paquet.xml (modified) (1 diff)

_plugins_/mailsubscribers/trunk/inc/mailsubscribinglists.php

@@ -24 +24 @@
         // placer le pointeur sur les subscriptions pour le genie
         // uniquement sur les subscribers qui ont au moins un des segments valide (sinon si tout refuse il n'y aura rien a faire)
-        $in_subscribers_valides = sql_get_select("DISTINCT zz.id_mailsubscriber", "spip_mailsubscriptions as zz", "zz.statut!=".sql_quote('refuse') . ' AND zz.id_mailsubscribinglist='.intval($id_mailsubscribinglist));
-        sql_updateq('spip_mailsubscriptions', array('actualise_segments' => 1), 'id_segment=0 AND id_mailsubscribinglist=' . intval($id_mailsubscribinglist) . " AND id_mailsubscriber IN ($in_subscribers_valides)");
+        // on est oblige de faire des series de allfetsel/update car on ne peut pas faire un update avec ne sous requete comme celle la
+        $n = 0;
+        while ($in_subscribers_valides = sql_allfetsel(
+                "DISTINCT id_mailsubscriber",
+                "spip_mailsubscriptions",
+                "statut!=" . sql_quote('refuse') . ' AND actualise_segments=0 AND id_segment=0 AND id_mailsubscribinglist=' . intval($id_mailsubscribinglist), '', '', '0,10000')){
+                $in_subscribers_valides = array_column($in_subscribers_valides, 'id_mailsubscriber');
+                sql_updateq('spip_mailsubscriptions', array('actualise_segments' => 1), 'id_segment=0 AND id_mailsubscribinglist=' . intval($id_mailsubscribinglist) . " AND " . sql_in('id_mailsubscriber', $in_subscribers_valides));
+                spip_log("actualise_segments=1 sur liste $id_mailsubscribinglist et " . count($in_subscribers_valides) . ' inscrits', 'mailsubscribers');
+                $n += count($in_subscribers_valides);
+        }
+        spip_log("actualise_segments=1 sur liste $id_mailsubscribinglist et TOTAL $n inscrits", 'mailsubscribers');
 }
 

_plugins_/mailsubscribers/trunk/paquet.xml

@@ -2 +2 @@
         prefix="mailsubscribers"
         categorie="communication"
-        version="2.9.8"
+        version="2.9.9"
         etat="stable"
         compatibilite="[3.0.0;3.2.*]"