January 12, 2005
dev thoughts
there arent any markers for the white board in the lab, so im reduced to making dev notes here. i suppose this will do. please skip if you care not about database dev, html, javascript, etc.
so.
two things. 1 is the timeline, the other is comment weighting.
1. the timeline. pretty easy to do - a php loop writing out a span for each hour. pull the movie(s) data from the db - start time and length. you can find a start and end time then, round to the hour and assign a class to each span based on that. thats the basic code. then the placement on the page is somewhat tricky. thatll really have to be dealt with later as i refine the layout. for now, if i put it in the top right of the screen, then its sitting in the top iframe with the dropdown. which is ok. it just means that as you pick from the dropdown, then you need to reload that top iframe as well. and we need to tweak the drop to only show per day instead of per movie.
whew.
2. the comment weighting. without dealing with all the math yet, i just want to deal with the number of times a thumbnail is clicked on. i can keep track of that with a javascript array i suppose and then write that data out to the db on page unload. ill have to test this and make a new db table - itll hold 3 different counters: comment count, author count (which is really a boolean flag) and the clicker count. there will be a primary key, a timecode and a main id which links back to the main movie file. whew. thatll be some fun juggling too.
time to start on #1 in earnest and see where we land.
sorry, just had to reason some of this out so i knew where i was about to head.
Posted by tripp at January 12, 2005 04:52 PM