- SELECT t.id, t.topic, u.name, u.mail, u.language, COUNT(*) AS num
- FROM {$db->pre}abos AS a
- LEFT JOIN {$db->pre}user AS u ON u.id = a.mid
- LEFT JOIN {$db->pre}topics AS t ON t.id = a.tid
- INNER JOIN {$db->pre}replies AS r ON r.topic_id = t.id AND r.date >= u.lastvisit
- WHERE a.type = '' AND a.tid = '<TOPIC_ID>' AND a.mid != '<POSTER_ID>'
- GROUP BY t.id HAVING num = 1;
[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:
Language-Datei anpassen ("eine oder mehr ...")
Closed (ass. to MaMo)
MaMo
18.03.2008, 15:43
Implemented
22 Mar 2009 18:02
MaMo
0.8 RC4
0.8 Gold
Minimal change
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
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

Date | User | Action |
18.03.2008, 15:43 | MaMo | Opened task |
03.05.2008, 18:08 | MaMo | Changed 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:59 | MaMo | Changed due version (0.8.1 → 0.8 RC6) |
Changed description | ||
19.12.2008, 17:10 | MaMo | Changed description |
Changed due version (0.8 RC6 → 0.8.1) | ||
21.03.2009, 15:48 | MaMo | Changed 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:52 | MaMo | Changed description |
22.03.2009, 18:02 | MaMo | Changed status (Assigned → Closed) |
Changed close reason (None → Implemented) | ||
Changed description | ||
Changed percent complete (75 % → 100 %) |
Alle Zeitangaben in GMT +01:00. Aktuelle Uhrzeit: 16:42.