Revision: 278
http://phpbbproject.svn.sourceforge.net/phpbbproject/?rev=278&view=rev
Author: lord_le_brand
Date: 2008-05-05 13:53:25 -0700 (Mon, 05 May 2008)
Log Message:
-----------
more structure on trackers
Modified Paths:
--------------
trunk/phpbb3/root/includes/project/project_trackers.php
Modified: trunk/phpbb3/root/includes/project/project_trackers.php
===================================================================
--- trunk/phpbb3/root/includes/project/project_trackers.php 2008-05-05 19:20:09 UTC (rev 277)
+++ trunk/phpbb3/root/includes/project/project_trackers.php 2008-05-05 20:53:25 UTC (rev 278)
@@ -102,8 +102,8 @@
$num_tickets = $db->sql_fetchfield('num_tickets', false, $result);
$db->sql_freeresult($result);
- $sql = 'SELECT t.*, c.*, s.*
- FROM ' . PROJECT_TRACKER_TICKETS_TABLE . ' t, ' . PROJECT_TRACKER_CATEGORIES_TABLE . ' c, ' . PROJECT_TRACKER_STATUS_TABLE . " s
+ $sql = 'SELECT t.*, c.*, s.*, COUNT(tc.*) as num_comments
+ FROM ' . PROJECT_TRACKER_TICKETS_TABLE . ' t, ' . PROJECT_TRACKER_CATEGORIES_TABLE . ' c, ' . PROJECT_TRACKER_STATUS_TABLE . ' s, ' . PROJECT_TRACKER_COMMENTS_TABLE . " tc
WHERE t.tracker_id = $tracker_id
" . (($tracker_category) ? "AND t.tracker_category = $tracker_category" : '') . '
AND c.category_id = t.tracker_category
@@ -137,6 +137,7 @@
'TICKET_STATUS' => $tickets[$i]['tracker_status_title'],
'TICKET_AUTHOR' => get_username_string('full', $tickets[$i]['ticket_author'], project_get_author_name($tickets[$i]['ticket_author'])),
'TICKET_TIME' => $user->format_date($tickets[$i]['ticket_time']),
+ 'NUM_COMMENTS' => $tickets[$i]['num_comments'],
'U_VIEW_TICKET' => _module_trackers_url(append_sid(PROJECT_BASE_URL, "i=trackers&mode=ticket&ticket={$trackers[$i]['ticket_id']}")),
));
@@ -271,7 +272,25 @@
case 'comment':
+ switch ($action)
+ {
+ case 'quote':
+ // Fetch quoted post(s)
+
+ case 'new':
+
+ break;
+
+ case 'edit':
+
+ break;
+
+ case 'delete':
+
+ break;
+ }
+
break;
// Manage trackers
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
