Changes between Version 1 and Version 2 of Recent Changes All


Ignore:
Timestamp:
Apr 13, 2015, 4:54:03 PM (9 years ago)
Author:
YT Hwang
Comment:

설명이 길게 출력되지 않도록 텍스트 줄임

Legend:

Unmodified
Added
Removed
Modified

  • Recent Changes All

    v1 v2  
    11{{{#!div class="trac-recent-changes"
    22{{{#!SQLTable
    3 SELECT name as '항목', author as '작성자', DATE_FORMAT(FROM_UNIXTIME(time / 1000000), '%Y-%m-%d %H:%i') as '시간', description as '설명'
     3SELECT name as '항목', author as '작성자', DATE_FORMAT(FROM_UNIXTIME(time / 1000000), '%Y-%m-%d %H:%i') as '시간', IF(CHAR_LENGTH(description) > 75, CONCAT(LEFT(description, 75), '...'), description) as '설명'
    44FROM (
    55(SELECT CONCAT('[', type, ':"', id, '"]의 첨부 파일 [attachment:"', filename, ':', type, ':', id, '" ', filename, ']') as name, author, time, description