Show All Projects
I still haven't really "released" this because I kept wanting to make it better, and add KTM-specific features, but haven't gotten back to it.

It lists all of the batches in a Capture installation and a double click opens the image path. I do it outside of the Capture API so it is quicker and does not require opening the batch.

Timeline

Files

  BENCHMARKS  
Loading Time: Base Classes  0.0018
Controller Execution Time ( Project / Id )  0.0204
Total Execution Time  0.0222
  GET DATA  
No GET data exists
  MEMORY USAGE  
902,928 bytes
  POST DATA  
No POST data exists
  URI STRING  
project/id/60/Batch_Image_Path
  CLASS/METHOD  
project/id
  DATABASE:  smkprojects (Project:$db)   QUERIES: 5 (0.0034 seconds)  (Hide)
0.0005   SELECT *
FROM `ProjectResources`
WHERE `ProjectID` = '60' 
0.0005   SELECT *
FROM `Projects`
WHERE `ProjectID` = '60' 
0.0004   SELECT *
FROM `ProjectTags`
WHERE `ProjectID` = '60' 
0.0011   SELECT TagCOUNT(1) AS cnt
FROM 
`ProjectTags`
WHERE `Tag` != 'Private'
GROUP BY `Tag`
HAVING COUNT(1) >
0.0010   SELECT TagCOUNT(1) AS cnt
FROM 
`ProjectTags`
WHERE `Tag` != 'Private'
GROUP BY `Tag`
HAVING COUNT(1) > 
  HTTP HEADERS  (Show)
  CONFIG VARIABLES  (Show)