Show All Projects
At the end of high school and beginning of college, many of my friends had online journals. I wanted a more convenient way to read them than checking a bunch of links to see if any were updated. So I wrote this program which allowed you to keep a list of users on LiveJournal, DeadJournal, and Blurty that you followed, then it would sort and combine them for easy reading.

I released this at the time to the friends whose journals I was reading. Back then it was pretty useful to be able to just run a shortcut to this program to display any updates from the past week. Now this can be accomplished much more simply by using RSS, but RSS wasn't as well known when I wrote this.

VB6

Timeline

Screenshots

  BENCHMARKS  
Loading Time: Base Classes  0.0019
Controller Execution Time ( Project / Id )  0.0115
Total Execution Time  0.0135
  GET DATA  
No GET data exists
  MEMORY USAGE  
904,128 bytes
  POST DATA  
No POST data exists
  URI STRING  
project/id/58/JournalCombine
  CLASS/METHOD  
project/id
  DATABASE:  smkprojects (Project:$db)   QUERIES: 5 (0.0035 seconds)  (Hide)
0.0006   SELECT *
FROM `ProjectResources`
WHERE `ProjectID` = '58' 
0.0005   SELECT *
FROM `Projects`
WHERE `ProjectID` = '58' 
0.0004   SELECT *
FROM `ProjectTags`
WHERE `ProjectID` = '58' 
0.0009   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)