<?php

/***************************************************************************

 *   awForumPanel                                                          *

 *                                                                         *

 *   Copyright © 2002 - 2005 Nick Jones                                    *

 *   http://www.php-fusion.co.uk/                                          *

 *   Copyright (C) 2006 Artur Wiebe                                        *

 *   wibix@gmx.de                                                          *

 *                                                                         *

 *   This program is free software; you can redistribute it and/or modify  *

 *   it under the terms of the GNU General Public License as published by  *

 *   the Free Software Foundation; either version 2 of the License, or     *

 *   (at your option) any later version.                                   *

 ***************************************************************************/

if(!defined("IN_FUSION")) {

   header("Location:../../index.php");

   exit;

}



require_once(INFUSIONS."aw_forum_panel/common.php");





//opentable($locale['025']);

opentable($p_data['panel_name']);



$query_id = dbquery("SELECT thread_subject, thread_lastuser, forum_name,"

   ." fu.user_id, MAX(p.post_id) as last_id, thread_lastpost,"

   ." COUNT(p.post_id) as count_posts, f.forum_id, t.thread_id,"

   ." fu.user_name AS last_user, thread_locked"

   ." FROM ".DB_PREFIX."forums AS f"

   ." INNER JOIN ".DB_PREFIX."threads AS t USING(forum_id)"

   ." INNER JOIN ".DB_PREFIX."posts AS p USING(thread_id)"

   ." LEFT JOIN ".DB_PREFIX."users AS fu ON t.thread_lastuser=fu.user_id"

   ." WHERE ".groupaccess('forum_access')

   ." GROUP BY thread_id"

   ." ORDER BY thread_lastpost DESC"

   ." LIMIT 0,".$settings['numofthreads']);



if(dbrows($query_id)) {

   echo "<table cellspacing='1' width='100%' class='tbl-border'>

<thead>

<tr>

   <th class='tbl2' width='1%'></th>

   <th class='tbl2' align='left'>".$locale['AWF005']."</th>

   <th class='tbl2' align='center' width='1%' style='white-space:nowrap'>".$locale['AWF006']."</th>

   <th class='tbl2' align='center' width='1%' style='white-space:nowrap'>".$locale['AWF007']."</th>

</tr>

</thead>

<tbody>\n";

}

$count = 0;

while($data = dbarray($query_id)) {

   $tbl = "tbl".(($count++ % 2)+1);

   if($data['thread_locked']) {

      $img = "folderlock.gif";

   } else if(iMEMBER && $data['thread_lastpost'] > $lastvisited) {

      $img = "foldernew.gif";

   } else {

      $img = "folder.gif";

   }

   echo "<tr>

   <td class='$tbl'><img src='".THEME."forum/$img' alt=''></td>

   <td class='$tbl'><a href='".FORUM."viewthread.php?forum_id=".$data['forum_id']."&amp;thread_id=".$data['thread_id']."&amp;pid=".$data['last_id']."#post_".$data['last_id']."' title='".$data['thread_subject']."'>".trimlink($data['thread_subject'], 50)."</a><br>".$data['forum_name']."</td>

   <td align='center' class='$tbl' style='white-space:nowrap'>".($data['count_posts']-1)."</td>

   <td class='$tbl' align='center' style='white-space:nowrap'>".showdate("forumdate", $data['thread_lastpost'])."<br><a href='".BASEDIR."profile.php?lookup=".$data['thread_lastuser']."'>".$data['last_user']."</a></td>

</tr>\n";

}

if(dbrows($query_id)) {

   echo "</tbody>

</table>\n";

}





echo "<div align='center'>$awf_menu</div>\n";



closetable();





?>