Red5 Streaming Module

We need a custom module for Red5. It would implement IStreamPlaybackSecurity and IStreamFilenameGenerator so that the following conditions would be met. 1. Content would be streamed from a custom directory corresponding to a database key. 2. Only the first 2 minutes of the stream would be played if the user has not yet purchased access to the stream (this can be determined with a single database query.) This system is the FMS solution we're migrating to as part of our online education site. The portion of the database schema which the project will need is as follows: CREATE TABLE sessions ( nid CHAR(11) NOT NULL PRIMARY KEY DEFAULT '', ip CHAR(15) NOT NULL DEFAULT '0.0.0.0', id INT UNSIGNED NOT NULL DEFAULT 0, loggedIn DATETIME, stamp TIMESTAMP ); CREATE TABLE paid ( did INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, id INT UNSIGNED NOT NULL DEFAULT 0, -- users table key cid INT UNSIGNED NOT NULL DEFAULT 0, -- class table key yid INT UNSIGNED NOT NULL DEFAULT 0, -- paypal table key exp DATETIME NOT NULL DEFAULT '1970-01-01 00:00:00', stamp TIMESTAMP, INDEX(id,cid,yid) ); CREATE TABLE media ( pid CHAR(11) NOT NULL PRIMARY KEY DEFAULT '', cid INT UNSIGNED NOT NULL DEFAULT 0, title CHAR(100) NOT NULL DEFAULT '', eid INT UNSIGNED NOT NULL DEFAULT 0, thumbId CHAR(11) NOT NULL DEFAULT '', thumbOffset CHAR(3) NOT NULL DEFAULT '', width SMALLINT NOT NULL DEFAULT 0, height SMALLINT NOT NULL DEFAULT 0, contentLength INT UNSIGNED NOT NULL DEFAULT 0, duration INT UNSIGNED NOT NULL DEFAULT 0, -- Longest in /etc/apache/[login to view URL] is 55 chars: -- application/vnd.llamagraphics.life-balance.exchange+xml contentType CHAR(55) NOT NULL DEFAULT 'application/octet-stream', uploadFileName CHAR(100) NOT NULL DEFAULT '', -- Longest in /etc/apache/[login to view URL] is 7 chars: -- sv4cpio extension CHAR(7) NOT NULL DEFAULT 'dat', reviewed CHAR(1) NOT NULL DEFAULT 'N', status CHAR(150) NOT NULL DEFAULT 'Awaiting conversion.', dispOrder INT UNSIGNED NOT NULL DEFAULT 0, vtype CHAR(1) NOT NULL DEFAULT 'U', -- 'U' for undefined stamp TIMESTAMP, INDEX(cid) ); The streams are located on the servers under the /video directory. They are indexed by the 11 character pid key in the media table. This works out so that the video files are spread across directories according to the following method. The key is broken down into subdirectory and file name such that a key of 'abcdefghijk' would refer to the FLV stream in the file '/video/a/b/cd/ef/[login to view URL]'. The RTMP URL used to embed our JW FLV Media Player derived player contains the cid and the user's session id (nid in sessions.) So you only need to a single SQL query which will ask if the user has purchased the video. If the user has then begin streaming, if not then start a timer which will allow only the first two minutes of video to be delivered (and seeking past this point is not allowed.) We're open to alternative suggestions for implementation. Security is an important aspect of this project. The following two tutorial pages detail the implementation of most of the project. [login to view URL] [login to view URL]