MaMo Net

[Edit task] Enhancement #166 Details
[Posts handling] Nur eine Benachrichtigung schicken bei sofortiger Benachrichtigung

Nur genau eine E-Mail-Benachrichtigung schicken bei sofortiger Benachrichtigung. E-Mail nur bei dem erstem neuen Beitrag schicken, nicht aber bei den weiteren neuen Beiträgen.

Query:
geshi_hlcode_txtdownloadgeshi_hlcode_title
  1. SELECT t.id, t.topic, u.name, u.mail, u.language, COUNT(*) AS num
  2. FROM {$db->pre}abos AS a
  3.         LEFT JOIN {$db->pre}user AS u ON u.id = a.mid
  4.         LEFT JOIN {$db->pre}topics AS t ON t.id = a.tid
  5.         INNER JOIN {$db->pre}replies AS r ON r.topic_id = t.id AND r.date >= u.lastvisit
  6. WHERE a.type = '' AND a.tid = '<TOPIC_ID>' AND a.mid != '<POSTER_ID>'
  7. GROUP BY t.id HAVING num = 1;

Language-Datei anpassen ("eine oder mehr ...")




Closed (ass. to MaMo)

   Medium


MaMo

18.03.2008, 15:43

Implemented

22 Mar 2009 18:02

MaMo

0.8 RC4

0.8 Gold

  100 %

Minimal change

 Changes history
DateUserAction
18.03.2008, 15:43MaMoOpened task
03.05.2008, 18:08MaMoChanged type (Bug → Enhancement)
  Changed status (New → Confirmed)
  Changed priority (Low → Medium)
  Changed description
  Changed due version (0.8 RC5 → 0.8.1)
25.07.2008, 15:59MaMoChanged due version (0.8.1 → 0.8 RC6)
  Changed description
19.12.2008, 17:10MaMoChanged description
  Changed due version (0.8 RC6 → 0.8.1)
21.03.2009, 15:48MaMoChanged estimated cost (Average work → Minimal change)
  Changed percent complete (0 % → 75 %)
  Changed due version (0.8.1 → 0.8 Gold)
  Changed description
  Changed assigned user ( → MaMo)
  Changed status (Confirmed → Assigned)
21.03.2009, 15:52MaMoChanged description
22.03.2009, 18:02MaMoChanged status (Assigned → Closed)
  Changed close reason (None → Implemented)
  Changed description
  Changed percent complete (75 % → 100 %)

Alle Zeitangaben in GMT +02:00. Aktuelle Uhrzeit: 21:40.