Patch to add "answered" status flag to the forums and timeline
|Reported by:||mickem||Owned by:||Blackhex|
Since I wanted a way to indicate that questions (on my forum) have been answered I added a status filed which translates to a icon indicator so it is simple to know when a topic has been answered or not.
This is kind of hard to describe but in essence you can toggle "answered" and once a topic is answered it will get a "check box" on top of the regular yellow icon. Really useful if you ask me.
The patch is created using svn diff so let me know if that is an incorrect syntax. *NOTICE* this changes the database so create a backup first as there is no "downgrade" (ie. it will not remove the extra column from the topic table). The alteration to the database is very slim (just adds a column to the topic table).
The icon did not seem to make it into the patch to I attached it separately.
Script to remove the column from the database (ie. if you want to uninstall, but this is manual work and not very tested so take care, and always do a backup):
BEGIN TRANSACTION; CREATE TEMPORARY TABLE t1_backup(id integer PRIMARY KEY, forum integer, time integer, author text, subscribers text, subject text, body text); INSERT INTO t1_backup SELECT id, forum, time, author, subscribers, subject, body FROM topic; DROP TABLE topic; CREATE TABLE topic ( id integer PRIMARY KEY, forum integer, time integer, author text, subscribers text, subject text, body text); INSERT INTO topic SELECT id, forum, time, author, subscribers, subject, body FROM t1_backup; DROP TABLE t1_backup; COMMIT;
*please note* this is only visible in timeline and "compact" forum view as that is what I use so set:
[discussion] default_topic_display = compact