Changeset 2236
- Timestamp:
- 05/15/07 07:41:37 (2 years ago)
- Files:
-
- discussionplugin/0.10/tracdiscussion/db/db2.py (modified) (1 diff)
- discussionplugin/0.10/tracdiscussion/templates/discussion-macros.cs (modified) (1 diff)
- discussionplugin/0.10/tracdiscussion/templates/message-list.cs (modified) (1 diff)
- discussionplugin/0.10/tracdiscussion/templates/topic-list.cs (modified) (1 diff)
- discussionplugin/0.10/tracdiscussion/wiki.py (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
discussionplugin/0.10/tracdiscussion/db/db2.py
r1252 r2236 37 37 38 38 # Set database schema version. 39 cursor.execute("DROP TABLE forum_old")40 39 cursor.execute("UPDATE system SET value = '2' WHERE" \ 41 40 " name = 'discussion_version'") discussionplugin/0.10/tracdiscussion/templates/discussion-macros.cs
r2014 r2236 107 107 </div> 108 108 <div class="body"> 109 <?cs if:(args.message == message.id) && args.preview ?> 110 <?cs var:discussion.body ?> 111 <?cs else?> 112 <?cs var:message.body ?> 113 <?cs /if ?> 109 <?cs var:message.body ?> 114 110 </div> 115 111 <div class="controls"> discussionplugin/0.10/tracdiscussion/templates/message-list.cs
r2014 r2236 3 3 <?cs linclude "discussion-header.cs" ?> 4 4 5 <h1> Forum #<?cs var:discussion.forum.id ?> - Topic #<?cs var:discussion.topic.id ?>- Message List</h1>5 <h1><?cs var:discussion.forum.name ?> (#<?cs var:discussion.forum.id ?>) - <?cs var:discussion.topic.subject ?> (#<?cs var:discussion.topic.id ?>) - Message List</h1> 6 6 <?cs set:discussion.href = discussion.href + '/' + discussion.forum.id + '/' + discussion.topic.id ?> 7 7 <?cs call:display_discussion(discussion) ?> discussionplugin/0.10/tracdiscussion/templates/topic-list.cs
r2014 r2236 4 4 <?cs include "discussion-header.cs" ?> 5 5 6 <h1>Forum #<?cs var:discussion.forum.id ?> - Topic List</h1> 7 <div class="name"> 8 <?cs var:discussion.forum.name ?> 9 </div> 10 <div class="description"> 11 <?cs var:discussion.forum.description ?> 12 </div> 6 <h1><?cs var:discussion.forum.name ?> (#<?cs var:discussion.forum.id ?>) - Topic List</h1> 7 <h2><?cs var:discussion.forum.subject ?></h2> 8 <p><?cs var:discussion.forum.description ?></p> 13 9 <?cs if:discussion.topics.0.id ?> 14 10 <table class="listing"> discussionplugin/0.10/tracdiscussion/wiki.py
r2014 r2236 106 106 columns = ('forum', 'forum_subject', 'subject') 107 107 sql = "SELECT t.forum, f.subject, t.subject FROM topic t LEFT" \ 108 " JOIN (SELECT subject, id FROM forum GROUP BY id) f ON" \ 109 " t.forum = f.id WHERE t.id = %s" 108 " JOIN forum f ON t.forum = f.id WHERE t.id = %s" 110 109 self.log.debug(sql % (id,)) 111 110 cursor.execute(sql, (id,)) … … 120 119 columns = ('forum', 'topic', 'forum_subject', 'subject') 121 120 sql = "SELECT m.forum, m.topic, f.subject, t.subject FROM" \ 122 " message m, (SELECT subject, id FROM forum GROUP BY id) f," \123 " (SELECT subject, id FROM topic GROUP BY id) t WHERE" \121 " message m, (SELECT subject, id FROM forum) f," \ 122 " (SELECT subject, id FROM topic) t WHERE" \ 124 123 " m.forum = f.id AND m.topic = t.id AND m.id = %s" 125 124 self.log.debug(sql % (id,))
