ここの情報は古いです。ご理解頂いた上でお取り扱いください。

Changeset 3581


Ignore:
Timestamp:
Jul 31, 2007, 12:49:03 PM (12 years ago)
Author:
maruyama
Message:

#991:admin:トピック・イベント管理にて、ファイルアップロードされているトピックが確認できない

Location:
OpenPNE/branches/work/maruyama/prj_watch_fix/webapp/modules/admin
Files:
4 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/work/maruyama/prj_watch_fix/webapp/modules/admin/lib/db_admin.php

    r3483 r3581  
    20852085    }
    20862086   
    2087     $select = " SELECT ct.*,ct.name as topic_name,c.name as commu_name,m.nickname,ctc.body as body,ctc.image_filename1 as image_filename1,ctc.image_filename2 as image_filename2,ctc.image_filename3 as image_filename3";
     2087    $select = " SELECT ct.*," .
     2088            "ct.name as topic_name,c.name as commu_name," .
     2089            "m.nickname,ctc.body as body," .
     2090            "ctc.image_filename1 as image_filename1,ctc.image_filename2 as image_filename2,ctc.image_filename3 as image_filename3," .
     2091            "ctc.filename as filename,f.original_filename as original_filename";
     2092   
    20882093    $from = " FROM c_commu_topic as ct"
    20892094            ." LEFT JOIN c_member as m ON ct.c_member_id = m.c_member_id "
    20902095            ." LEFT JOIN c_commu as c ON c.c_commu_id = ct.c_commu_id "
    2091             ." LEFT JOIN c_commu_topic_comment as ctc ON (ctc.c_commu_topic_id = ct.c_commu_topic_id AND ctc.number = 0)";
     2096            ." LEFT JOIN c_commu_topic_comment as ctc ON (ctc.c_commu_topic_id = ct.c_commu_topic_id AND ctc.number = 0)"
     2097            ." LEFT JOIN c_file as f ON f.filename = ctc.filename "
     2098            ;
     2099   
    20922100    $order = " ORDER BY r_datetime desc";
    20932101   
     
    21182126    $page_size = intval($page_size);
    21192127   
    2120     $where = " where c_commu_topic_id = ? ";
     2128    $where = " where ct.c_commu_topic_id = ? ";
    21212129    $params[] = $c_commu_topic_id;
    21222130   
    2123     $select = " SELECT ct.*,ct.name as topic_name,c.name as commu_name,m.nickname,ctc.body as body,ctc.image_filename1 as image_filename1,ctc.image_filename2 as image_filename2,ctc.image_filename3 as image_filename3";
     2131    $select = " SELECT ct.*," .
     2132            "ct.name as topic_name,c.name as commu_name," .
     2133            "m.nickname,ctc.body as body," .
     2134            "ctc.image_filename1 as image_filename1,ctc.image_filename2 as image_filename2,ctc.image_filename3 as image_filename3," .
     2135            "ctc.filename as filename,f.original_filename as original_filename";
     2136   
    21242137    $from = " FROM c_commu_topic as ct"
    21252138            ." LEFT JOIN c_member as m ON ct.c_member_id = m.c_member_id "
    21262139            ." LEFT JOIN c_commu as c ON c.c_commu_id = ct.c_commu_id "
    2127             ." LEFT JOIN c_commu_topic_comment as ctc ON (ctc.c_commu_topic_id = ct.c_commu_topic_id AND ctc.number = 0)";
     2140            ." LEFT JOIN c_commu_topic_comment as ctc ON (ctc.c_commu_topic_id = ct.c_commu_topic_id AND ctc.number = 0)"
     2141            ." LEFT JOIN c_file as f ON f.filename = ctc.filename "
     2142            ;
    21282143    $order = " ORDER BY r_datetime desc";
    21292144   
  • OpenPNE/branches/work/maruyama/prj_watch_fix/webapp/modules/admin/page/delete_topic.php

    r3579 r3581  
    2727        $topic['commu_name'] = $commu['name'];
    2828        $topic['c_member'] = $member;
     29        $topic['original_filename'] = db_file_original_filename4filename($topic['filename']);
    2930        $this->set('topic', $topic);
    3031       
  • OpenPNE/branches/work/maruyama/prj_watch_fix/webapp/modules/admin/templates/delete_topic.tpl

    r3484 r3581  
    6969</tr>
    7070({****})
     71({if $topic.filename && $smarty.const.OPENPNE_USE_FILEUPLOAD})
     72<tr>
     73<th>ファイル</th>
     74<td class="textbody">
     75<a href="({t_file_url filename=$topic.filename})">
     76({$topic.original_filename})
     77</a>
     78</td>
     79</tr>
     80({/if})
     81({****})
    7182</tbody>
    7283</table>
  • OpenPNE/branches/work/maruyama/prj_watch_fix/webapp/modules/admin/templates/topic_list.tpl

    r3484 r3581  
    109109</tr>
    110110({****})
     111({if $item.filename && $smarty.const.OPENPNE_USE_FILEUPLOAD})
     112<tr>
     113<th>ファイル</th>
     114<td class="textbody">
     115<a href="({t_file_url filename=$item.filename})">
     116({$item.original_filename})
     117</a>
     118</td>
     119</tr>
     120({****})
     121({/if})
    111122<tr>
    112123<td class="formbutton" colspan="2">
Note: See TracChangeset for help on using the changeset viewer.