Web
Internet related experiments; subset overlaps with CS.
FTP user accounts
I got a PHP based account form working fine, and auto creates user subdirectory, nifty. I'm not sure about security yet, and likely will combine it with mysql. It's limited in number of ftp accounts and storage quota.
http://gophercg.com/web/login/ftp_account2.php
Perl & MySQL
Somewhat redundant. I am learning to use perl to connect/query SQL. Perl's more powerful than PHP, but it seems PHP-SQL interface is simpler.
Maybe use Perl for regexp and calculations, PHP for more frontend html interfacing, and SQL just to store and organize data.
PHP & MySQL
Implemented a register/login system from editing some template code. The SQL's fairly simple, and more involved are the PHP files. I'm learning the PHP parts, and customizing it. It's quite useless for a site like mine, but it's just for experimental fun!
Javascript Time
Been awhile since writing javascript, here's one:
Hi! Please enable javascript to display date here.
Flash Player
I made a video reels website for eCoast Animation Studio. The famed JW Player can open many video/image file types, so I embedded the player into my custom SWF with buttons UI. There was a bit of a hack embedding an external player, and connecting UI to the player, by only accessing the player's API.
Since the company site changed again, here's a sample portfolio SWF.
dbWeb (V22.0060: Database Design and Web Implementation)
Practice Excel, macros, VBA:
hw2.xls & printout hw2.pdf
dbWeb - Database Design
Project 01 (system documentation)
Funcitonal Specification
Content: storyboards, frames, and videos of animation are stored with relevant custom parameters. The UI includes interactive view of visual assets and edit of organization and metadata. Users have an offline/online website UI. Online UI may require login authentication.
Purpose: Currently open to ideas. Custom Flash photo/media album. Collaborative application for storyboarding. Ease massive animation frames organization. Website presentation of auto generated videos from (large matrix of) Maya parameter adjustments, to speed up user's parameter adjustment (similar to work from my teacher pzman, see below). Maya nodes parameter simulation in real time, which eases node programming, but requires efficiency optimization.
I will begin with the Flash album idea, used mainly for storyboard/frames presentation and review.
Users: investors (producers), artists, programmers
Files: each image is under 5MB, but frames count and video size are unbounded.
Approximate sizes:
image < 5MB
frames per shot < 1000
shots per scene < 60
scenes per film < 40
video < 500MB
all database text < 10MB
Calculations:
Compare image visual difference/speed.
Find duplicate image.
Frames sequence caching
Bandwidth size kbps
frame rate fps, frame duration seconds
sort
Input:
ASCII text, RSS feed, online photo/video sites
Output:
Flash photo album: multiple frames per page, 1 frame/storyboard slideshow.
frames->animation conversion: play and timeline scroll
media info summary, video->thumbnails
Organization tools next to image
Technical Specification
Software: PHP, Pearl/Bash, MySQL, Flash.
Hardware:
local: 1 media server
online: 1 video server from a video host, 1 photo host, 1 website server with database and scripts support.
Structure:
fileFormats: lookup
compression: lookup
scene: It's a collection of shots.
shot: It's a collection of images and videos.
image: file with type=image
video: file with type=video
Access file hw4a_01
PDF relationship hw4a