- 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
Changes history| 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 +02:00. Aktuelle Uhrzeit: 16:42.