I have a simple job for an Actionscript/php programmer.
I have a template that i want extended. It is a dynamic playlist flash video template. The template is from the adobe website and can be accessed via the following link: [url removed, login to view] The template is the zip file called video_playlist_as3_cs4. I need a coder to download,this template and use the version for “Progressive download”, as I don’t have a flash media server for streaming. I hope all this makes sense? The way the template works right now is that it has an flv player, with a tile list component, as a dynamic playlist, which gets its data from a static xml file. The flv player in turn plays vidoes from the dynamic playlist. (access the template and see what i'm talking about).
I need a programmer to edit the playlist and write some php, so the playlist gets its video data from a Mysql database table. You could write a Mysql query and convert this to dynamic xml for the playlist via php – I’d leave you to figure out the best way.
The second extension to the template is to allow users register and login to the application in order to watch the videos from the plalist. I want a MySQL back end database.
The database will contain 2 tables:
Video table: "Video id" (int), "src" (varchar) - this holds the path to the video, "desc" (varchar), holds description of video, "thumb" (varchar), holds the path to the thumbnail of the video displayed on the playlist/tile list, "uploaded" (datetime) - holds the date and time the video was uploaded, "points" (int/ varchar) this holds the number of points awarded for watching a particular video.
User table: "User Id" (int), "Video" id(int) - this is the foreign key showing which videos users have earnt points from, "username" (varchar), "password" (varchar), "email" (varchar), "firstname" (varchar), "lastname"(varchar), "numpoints" (int/varchar) holds the cumulative number of points a user has earnt from watching videos e.g. if they have watched 2 videos that awarded 2 points each, then this field will display "4".
PS: I have a database already built with this structure, do you want me to export the sql file and email to you? Or is there no need?
How will this work?
Videos details: I will manually populate the database with video details - so no need to build in any video entry functionality.
Users: Users need to register via a front end form and provide all their details before they can watch any videos.
View videos: Building on the template, users will login first and then can scroll the playlist and watch videos. It would also help if the system displays a usersname and number of points as they access the playlist and watch videos. (maybe a dynamic text box)
Once a video is finished playing, the number of points should be awarded to the user, depending on how many points that particular video awards (details on the video table on database). You can experiment with any number to start with e.g. 3 points.
Please note that points are allocated only after the video has stopped playing.
Are there any questions?
Budget very limited here, can pay only up to $100.