Archive for October 26, 2007

Draft Proposal

  • Project Idea

When I first approached this assignment I had little conception of what I could create as my prototype and knew even less about the specifics of television online, although I had briefly touched upon it as a web user and television scholar. In speaking with my tutor he suggested the topic area of Video on Demand (VoD) as a new direction of television online that would also relate to my specialism.

I have produced websites before but, nothing that features video content so I thought this would be an ideal opportunity for me to create something more professional than I had in previous assignments. It will also expand upon my expertise in television by adding another facet to my abilities, enabling me to provide something different to employees when I graduate.

  • To produce a…

In order to develop my idea further I researched into the technology of VoD, how it works, which broadcasters are using it, what applications are used to create and view video content and, most importantly, who are my potential competitors.

This wealth of research led to much brainstorming of what I wanted my project to achieve. Ideally it will be a website of television programmes, mainly UK and US based, that viewers will be able to stream to their computers. Although most of the content would be available for a nominal fee, there would be programmes available for free, but this is dependant on the copyright restrictions of each individual programme, especially in relation to US produced programmes.

  • Pre-Production

As I am still in the planning stage I will need to complete research into the format of streaming and applications I wish to use. I intend to use either Windows Media, RealPlayer or Quicktime as these are media players commonly used by websites and users. Once I have finalised this decision I will make sure I am able to use the technology correctly to ensure my prototype is to a professional standard. I intend to achieve this through using online tutorials, video lectures and text books to teach myself the skills I will need to use.

  • Addressing my Professional and Technical Objectives

This project will not only improve my skills in Dreamweaver but, also enhance how I create websites and the content I use, resulting in a higher quality project. I hope by experimenting with streaming video files and learning more about this subject it will help my overall knowledge of television online. It may also lead to creating a CV website, featuring my show reel, once I have graduated as a way of advertising myself to prospective employers.

I also want this website to appear professional in its design and content, something I feel I have not achieved in my previous work due to my inexperience. To achieve this I will timetable my week to ensure that I maintain work on the prototype throughout the semester and therefore not produce a rushed website.


A draft proposal (dorota jablonska)

  • I will create a game in flash.

The game will have a turret point which shoots in the direction of the mouse.

The turret point will shoot to the opponents which will go from top to bottom.

To get to the next level you will have to shoot a sufficient number of the opponents.

the game takes place in a work environment- warehouse

You will start the game on the first level  as a labour worker. If you shoot enough opponents you will get to the  second level and you will get promotion for a senior worker.

And then as follows:

Level 3- team leader

Level 4- supervisor

Level 5- trainee manager

Level 6- manager

Level 7- director

  • The game will be placed on my final project website which will aim at European Union citizens who come to England to start a new life. It will also be placed on the Independent Polish web portal which provides information, forums, articles, chat rooms for Polish who live in Birmingham
  • The game will aim at European Union Citizens who come to England to start a new life. Those people usually emigrate for economic reason. They are often very well qualified but thy have only basic communication skills in English. Therefore they are unable to undertake tasks  according to their qualifications which may lead them to a frustration.
  • My game will give them the chance to take their frustration out, give a little bit of fun, make them laugh
  • My technical objectives- Scrolling game background, shooting objects, scoring points, levels, sound- volume control,
  • The main tutorial site which I use
  • Design: warehouse, changing templates- different photos of a warehouse,
  • Similar products ….
  • When I finish the product I will do the usability test among Polish people who live in Birmingham When completed I will test the product on the potential target audience.

Simple login script?

Like mentioned in one of my previous blogs, in order to start any tutorial in which requires a database you need to download MySQL and PHP which works simultaneously together. Once you have downloaded these two, and preferably Apache to view your final outcome, (which I can assure you is one of the hardest parts) you can start on one of these simple tutorials I found at : Within this tutorial it gives you a step-by-step guide looking at creating a simple login section. 

  1. After getting MySQL and PHP up and running on your computer, you need to create 4 blank PHP web pages entitled: register.php, login.php, members.php, and logout.php.
  2. Once these have been created and up and running, we need to create a database in MySQL in order to store the users information. The code they used is

 Name the table “dbUsers.” It will need 4 fields:

[I]Name             Type                 Addition[/I]
id                  int(10)              Primary Key, AUTO_INCREMENT
username            varchar(16)          Unique
password            char(16)          
email               varchar(25)   

  1. When this is done we need to start creating and designing the registration page. This can be done by creating a PHP document called dbConfig.php. This file about to be created contains the coding to enable PHP and MySQL to communicate with one another. With the code above you need to enter users into the equation by adding them into the MySQL saved file.
  2. Then into the dbConfig.php file add the following code to call MySQL for the database information

// Replace the variable values below
// with your specific database information.
$host = “localhost”;
$user = “UserName”;
$pass = “Password”;
$db   = “dbName”;

// This part sets up the connection to the
// database (so you don’t need to reopen the connection
// again on the same page).
$ms = mysql_pconnect($host, $user, $pass);
if ( !$ms )
echo “Error connecting to database.\n”;

// Then you need to make sure the database you want
// is selected.

  1. You need to then set up the registration page we created in step 1. (Register.php) in order to do this inset this code into the document


// dbConfig.php is a file that contains your
// database connection information. This
// tutorial assumes a connection is made from
// this existing file.
include (“dbConfig.php”);

//Input vaildation and the dbase code
if ( $_GET[“op”] == “reg” )
 $bInputFlag = false;
 foreach ( $_POST as $field )
  if ($field == “”)
   $bInputFlag = false;
   $bInputFlag = true;
 // If we had problems with the input, exit with error
 if ($bInputFlag == false)
  die( “Problem with your registration info. ”
   .”Please go back and try again.”);

 // Fields are clear, add user to database
 //  Setup query
 $q = “INSERT INTO `dbUsers` (`username`,`password`,`email`) ”
  .”VALUES (‘”.$_POST[“username”].”‘, ”
  .”PASSWORD(‘”.$_POST[“password”].”‘), ”
 //  Run query
 $r = mysql_query($q);
 // Make sure query inserted user successfully
 if ( !mysql_insert_id() )
  die(“Error: User not added to database.”);
  // Redirect to thank you page.
  Header(“Location: register.php?op=thanks”);
 } // end if

//The thank you page
elseif ( $_GET[“op”] == “thanks” )
 echo “<h2>Thanks for registering!</h2>”;
//The web form for input ability
 echo “<form action=\”?op=reg\” method=\”POST\”>\n”;
 echo “Username: <input name=\”username\” MAXLENGTH=\”16\”><br />\n”;
 echo “Password: <input type=\”password\” name=\”password\” MAXLENGTH=\”16\”><br />\n”;
 echo “Email Address: <input name=\”email\” MAXLENGTH=\”25\”><br />\n”;
 echo “<input type=\”submit\”>\n”;
 echo “</form>\n”;
// EOF
?>   6.      We need to next check that the information provided by the registered user corresponds with the information within the set up database. Since when the user registered, we encrypted their password using the MySQL PASSWORD() function, we re-encrypt the password the user supplied in the login form and cross-check this with the existing value in the dBase. If login information is O.K., then we need to use sessions to store the user’s ID so they can access member-only content. <?php
// dBase file
include “dbConfig.php”;

if ($_GET[“op”] == “login”)
 if (!$_POST[“username”] || !$_POST[“password”])
  die(“You need to provide a username and password.”);
 // Create query
 $q = “SELECT * FROM `dbUsers` ”
  .”WHERE `username`='”.$_POST[“username”].”‘ ”
  .”AND `password`=PASSWORD(‘”.$_POST[“password”].”‘) ”
  .”LIMIT 1″;
 // Run query
 $r = mysql_query($q);

 if ( $obj = @mysql_fetch_object($r) )
  // Login good, create session variables
  $_SESSION[“valid_id”] = $obj->id;
  $_SESSION[“valid_user”] = $_POST[“username”];
  $_SESSION[“valid_time”] = time();

  // Redirect to member page
  Header(“Location: members.php”);
  // Login not successful
  die(“Sorry, could not log you in. Wrong login information.”);
//If all went right the Web form appears and users can log in
 echo “<form action=\”?op=login\” method=\”POST\”>”;
 echo “Username: <input name=\”username\” size=\”15\”><br />”;
 echo “Password: <input type=\”password\” name=\”password\” size=\”8\”><br />”;
 echo “<input type=\”submit\” value=\”Login\”>”;
 echo “</form>”;

7 Next is to set up a members area


Now that the user has logged in successfully, and has his id, username, and login stored in session variables, we can start working with member-only content. A major thing to remember is that any page you want to carry session data over to you must declare a session_start(); at the top of your code.


if (!$_SESSION[“valid_user”])
// User not logged in, redirect to login page
Header(“Location: login.php”);

// Member only content
// …
// …
// …

// Display Member information
echo “<p>User ID: ” . $_SESSION[“valid_id”];
echo “<p>Username: ” . $_SESSION[“valid_user”];
echo “<p>Logged in: ” . date(“m/d/Y”, $_SESSION[“valid_time”]);

// Display logout link
echo “<p><a href=\”logout.php\”>Click here to logout!</a></p>”;
?>  7.      And lastly when the user exits the website we should be able to offer the ability for the user to destroy the session variables. In order to do this open up the logout.php document and copy and paste this coding  <?php

// Logged out, return home.
Header(“Location: index.php”);
?>  This tutorial is pretty straight forward, and the coding seems reasonable enough to read and understand. However the coding is very long winded therefore you can see how many files and how long the coding for each section needs to be. For login sections alone it requires 4 pages, what about all the other sections people require? How many files will you need to create? Marc  Http://