Changes between Initial Version and Version 1 of Recent Changes All

Timestamp:

Apr 29, 2014, 12:11:12 PM (10 years ago)

Author:

YT Hwang

Comment:

Trac 전체 변경 사항 나열 페이지

Recent Changes All

@@ +1 @@
+{{{#!div class="trac-recent-changes"
+{{{#!SQLTable
+SELECT name as '항목', author as '작성자', DATE_FORMAT(FROM_UNIXTIME(time / 1000000), '%Y-%m-%d %H:%i') as '시간', description as '설명'
+FROM (
+(SELECT CONCAT('[', type, ':"', id, '"]의 첨부 파일 [attachment:"', filename, ':', type, ':', id, '" ', filename, ']') as name, author, time, description
+FROM attachment)
+UNION
+(SELECT CONCAT('[milestone:"', name, '"]') as name, '' as author, completed as time, description
+FROM milestone
+WHERE completed != 0)
+UNION
+(SELECT CONCAT(repository.value, '의 변경사항 [changeset:', rev * 1, '/', repository.value, ' "[', rev * 1, ']"]') as name, author, time, message as description
+FROM revision
+JOIN repository ON repos = id AND name='name')
+UNION
+(SELECT CONCAT('티켓 #', id) as name, reporter as author, time, summary as description
+FROM ticket)
+UNION
+(SELECT CONCAT('티켓 #', ticket) as name, author, time, newvalue as description
+FROM ticket_change
+WHERE field = 'comment')
+UNION
+(SELECT CONCAT('[wiki:', name, ']') as name, author, time, comment as description
+FROM wiki
+WHERE author != 'trac')
+ORDER BY (UNIX_TIMESTAMP() * 1000000 - time)
+) AS X
+LIMIT 5
+}}}
+}}}