Differences From Artifact [27bcfdfcff]:

• File src/alerts.c — part of check-in [e1ad499265] at 2022-09-15 16:58:49 on branch trunk — Added lmtime value to chat-timeline-user's chat messages, using the server's local time, to fix time display in the /chat message popup. (user: stephan size: 114863) [more...]

To Artifact [1b6bfaf871]:

• File src/alerts.c — part of check-in [1f0f62261c] at 2022-11-11 22:24:09 on branch ticket-notification-fix — A proposed fix for ticket [ad9aa572e7972f57]. Use an UPDATE rather than a REPLACE where possible when redoing EVENT table entries for tickets that are being rebuild, in order to avoid unnecessary notification events. (user: drh size: 114999) [more...]

2941
2942
2943
2944
2945
2946
2947





2948
2949
2950
2951
2952
2953
2954

2941
2942
2943
2944
2945
2946
2947
2948
2949
2950
2951
2952
2953
2954
2955
2956
2957
2958
2959

+
+
+
+
+

      " SELECT eventid,"
      "        EXISTS(SELECT 1 FROM private WHERE rid=substr(eventid,2)),"
      "        sentMod"
      "   FROM pending_alert"
      "  WHERE sentSep IS FALSE;"
      "DELETE FROM wantalert WHERE needMod AND sentMod;"
    );
  }
  if( g.fSqlTrace ){
    fossil_trace("-- wantalert contains %d rows\n",
        db_int(0, "SELECT count(*) FROM wantalert")
    );
  }

  /* Step 2: compute EmailEvent objects for every notification that
  ** needs sending.
  */
  pEvents = alert_compute_event_text(&nEvent, (flags & SENDALERT_DIGEST)!=0);
  if( nEvent==0 ) goto send_alert_expiration_warnings;