Changeset 1280


Ignore:
Timestamp:
2007/01/22 12:05:20 (17 years ago)
Author:
kakinaka
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed

  • temp/test-xoops.ec-cube.net/html/modules/newbb/response.php

    r1279 r1280  
    11<?php 
    2 // $Id: viewforum.php,v 1.7 2006/05/01 02:37:28 onokazu Exp $ 
    3 //  ------------------------------------------------------------------------ // 
    4 //                XOOPS - PHP Content Management System                      // 
    5 //                    Copyright (c) 2000 XOOPS.org                           // 
    6 //                       <http://www.xoops.org/>                             // 
    7 //  ------------------------------------------------------------------------ // 
    8 //  This program is free software; you can redistribute it and/or modify     // 
    9 //  it under the terms of the GNU General Public License as published by     // 
    10 //  the Free Software Foundation; either version 2 of the License, or        // 
    11 //  (at your option) any later version.                                      // 
    12 //                                                                           // 
    13 //  You may not change or alter any portion of this comment or credits       // 
    14 //  of supporting developers from this source code or any supporting         // 
    15 //  source code which is considered copyrighted (c) material of the          // 
    16 //  original comment or credit authors.                                      // 
    17 //                                                                           // 
    18 //  This program is distributed in the hope that it will be useful,          // 
    19 //  but WITHOUT ANY WARRANTY; without even the implied warranty of           // 
    20 //  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the            // 
    21 //  GNU General Public License for more details.                             // 
    22 //                                                                           // 
    23 //  You should have received a copy of the GNU General Public License        // 
    24 //  along with this program; if not, write to the Free Software              // 
    25 //  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307 USA // 
    26 //  ------------------------------------------------------------------------ // 
    27 // Author: Kazumi Ono (AKA onokazu)                                          // 
    28 // URL: http://www.myweb.ne.jp/, http://www.xoops.org/, http://jp.xoops.org/ // 
    29 // Project: The XOOPS Project                                                // 
    30 // ------------------------------------------------------------------------- // 
    312require_once("../../modules/newbb/class/class.util.php"); 
    323 
    … …  
    205176$xoopsTpl->assign('forum_name', 'Âбþ¾õ¶·°ìÍ÷'); 
    206177 
    207 $sql = 'SELECT topic_id, topic_title, topic_response, from_unixtime(topic_time) as topic_time, uname FROM xoops_bb_topics as tpc left join xoops_users as usr on tpc.topic_response_uid = usr.uid ORDER BY topic_response, topic_id DESC'; 
     178$sql = 'SELECT topic_id, topic_title, topic_response, topic_last_post_id, from_unixtime(topic_time) as topic_time, uname FROM xoops_bb_topics as tpc left join xoops_users as usr on tpc.topic_response_uid = usr.uid ORDER BY topic_response, topic_id DESC'; 
    208179if ( !$result = $xoopsDB->query($sql) ) { 
    209180    redirect_header('index.php',2,_MD_ERROROCCURED); 
    … …  
    218189    $xoopsTpl->append('topics', array( 
    219190                                'topic_fix'=>$fix, 
     191                                'topic_number'=>$myrow['topic_last_post_id'], 
    220192                                'topic_title'=>$myrow['topic_title'], 
    221193                                'topic_response'=>$myrow['topic_response'], 
Note: See TracChangeset for help on using the changeset viewer.