home *** CD-ROM | disk | FTP | other *** search
/ Chip 2004 April / CMCD0404.ISO / Software / Freeware / Programare / dotproject / modules / projects / vw_forums.php < prev    next >
Encoding:
PHP Script  |  2003-02-19  |  1.5 KB  |  46 lines
  1. <?php /* PROJECTS $Id: vw_forums.php,v 1.7 2003/02/19 03:53:34 eddieajau Exp $ */
  2. GLOBAL $AppUI, $project_id;
  3. // Forums mini-table in project view action
  4.  
  5. $sql = "
  6. SELECT forum_id, forum_project, forum_description, forum_owner, forum_name, forum_message_count,
  7.     DATE_FORMAT(forum_last_date, '%d-%b-%Y %H:%i' ) forum_last_date,
  8.     project_name, project_color_identifier, project_id
  9. FROM forums
  10. LEFT JOIN projects ON project_id = forum_project
  11. WHERE forum_project = $project_id
  12. ORDER BY forum_project, forum_name
  13. ";
  14. //echo "<pre>$sql</pre>";
  15. $rc = db_exec($sql);
  16. ?>
  17.  
  18. <table width="100%" border="0" cellpadding="2" cellspacing="1" class="tbl">
  19. <tr>
  20.     <th nowrap> </th>
  21.     <th nowrap width="100%"><?php echo $AppUI->_('Forum Name');?></th>
  22.     <th nowrap><?php echo $AppUI->_('Messages');?></th>
  23.     <th nowrap><?php echo $AppUI->_('Last Post');?></th>
  24. </tr>
  25. <?php
  26. while ($row = db_fetch_assoc( $rc )) { ?>
  27. <tr>
  28.     <td nowrap align=center>
  29. <?php
  30.     if ($row["forum_owner"] == $AppUI->user_id) { ?>
  31.         <A href="./index.php?m=forums&a=addedit&forum_id=<?php echo $row["forum_id"];?>"><img src="./images/icons/pencil.gif" alt="expand forum" border="0" width=12 height=12></a>
  32. <?php } ?>
  33.     </td>
  34.     <td nowrap><A href="./index.php?m=forums&a=viewer&forum_id=<?php echo $row["forum_id"];?>"><?php echo $row["forum_name"];?></a></td>
  35.     <td nowrap><?php echo $row["forum_message_count"];?></td>
  36.     <td nowrap>
  37.         <?php echo (intval( $row["forum_last_date"] ) > 0) ? $row["forum_last_date"] : 'n/a'; ?>
  38.     </td>
  39. </tr>
  40. <tr>
  41.     <td></td>
  42.     <td colspan=3><?php echo $row["forum_description"];?></td>
  43. </tr>
  44. <?php }?>
  45. </table>
  46.