Final projects notes
From Wsms
The projects where presented during thursday may 31th, friday june 1th and monday june 4th, 2007
[edit]
Thursday, may 31st
[edit]
Project 1. Web server security, scripts, system recovery & backup
Everyone was fancy-dressed to this presentation. Mary-Rose looks gorgeous and Ace is wearing a beautiful red tie!.
- Team members
- Ace R,
Mary-Rose G.
Rob J.
Scott F.
Ace makes a great introduction of his team mates.
He presents the linux server, the PHP and the MySQL security bridges.
Then he describes SEO Tous, which is a search engine optimization marketing, to make a web page come up ion the search engines.
Scott shows us the installation of MySQL and the results of this research.
Mary-Rose shows the results of her research in security and safety.
Rob shows us the system set up and the backup. He was the system administrator, and the project is running in a box in his house.
[edit]
Project 2. Movie database
This is a project that uses MySQL and PHP.
Jason has prepared a script and he is saying it while we read it on the screen.
- Project administrator - Jason
This project is about helping Jason's uncle, who has a lot of movies and gets a little bit lost into them. It keeps a database updated, and you can connect to it using internet. Everything works ok, though he forgot to turn off PHP errors.
[edit]
Project 3. Windows disaster recovering with knoppix
- Project administrator - Michael F.
[edit]
Project 4. Database administration with PERL and SQL
- Project administrator - Hui Peng
[edit]
Project 5. Personality Tests
- Project administrator - Steven
This is a test that tells you in wich group of personality do you fit. Then, after answering all the questions, you can go to the site that explains you about your personality.
Steven thinks that Joe looks more ravishing in a "pirate of the caribean" suit.
[edit]
Project 6. Setting up Moodle
Moodle is a tool to set up online courses (works as webct) and it's free.
- Project administrator - Tina Lu
[edit]
Project 7. WSMS consulting
- Project Team
- Efren Cabrera
Kim Shane
Bob Stevens
Sheila Akuntalar
Ace Rashid
Ace shows a little outline of the project, and his work in PHP scripting.
Efren presents his work on setting-up the windows 2003 server.
Kim shows us how he setted up thje Active Directory.
Bob shows us about some security aspects.
Sheela tells us about the server database setup.
[edit]
Project 8. Solve a problem in flash memory security
David wanted to make a flash drive secure. He draws a small flash drive out of his pocket, waves it in front of the class and says "Here is my project, this is a totally secure flash drive. Thank you". He is intended to go back to his seat, but Joe tells him that he has to do a presentation. So, he does.
- Project administrator - David Tanaguchi
There is a program that simulates a new hard drive out of the flash drive. You can protect it with a password (even a image file such that the picture of your dog can be used as a password), and you can put super-secret information on it. In that way, if a person looses the flash memory, at least will not be giving away the (probably very sensitive) information.
[edit]
Friday jun 1st
[edit]
Project 9. Casa de Kuma
This girls setted up a webpage to support their business, wich is a clothing factory for dogs.
- Project team - Yuki
Emma
[edit]
Project 10. Design and Implementation of a Lightweight Extensible Content Management System
by Ralf Peeks
[edit]
Motivation
- Ability to generate and access content from any network-connected computer
- Wiki/Myspace-like functionality through a very compact and transparent system
- Testing ground for new technologies (minimizing side-effects)
[edit]
Requirements
- Users have password protected areas where they can store content.
- Users can publish content.
- The user interface is simple with minimal complexity.
- Technologies that prevent the extensibility of the base system should be avoided, e.g. closed source software.
[edit]
Use Cases
- An almost omnipresent high performance personal notebook - without the need for synchronization or transportation.
- A collaboration system for informal learning environments (tutoring).
- A publishing system for bandwidth intensive data as a complement for email
[edit]
Demonstration
- Log-in as existing user, review of stored data
- Review of community data
- Editing information
- Adding content
- Registering as a new user
[edit]
Realization Details
- Handling of regular expressions
To replace text like [[-Display Name-filename.jpg-]] by an actual link that will trigger the download, the following code can be used:
function translateFileLinks( $text )
{
$pattern_1 = '\[\[\-([[:alnum:][:blank:][:punct:]]+)\-([[:alnum:][:punct:]]+)\-\]\]';
$replace_1 = '<a href="download.php?file=\\2">\\1<a>';
$text = ereg_replace( $pattern_1 , $replace_1 , $text );
// automatically uses global scope, use "blank" instead of "space" for multiline strings
return $text;
}
- File access via "downloads.php"
- Hides the source directory
- Uses PHP functions to stream the data
- Alternative to embedding of images into HTML-pages
[edit]
Outlook
- Add support for hierarchical data (tree structures) and regrouping of branches
- Implement a test harness
- Use a version control system after refactoring code and reviewing the file structure.
- Further separate data access and presentation to make evaluation of technologies like AJAX or alternative databases easier.
[edit]
Resources
- PHP for the WWW – Larry Ullman
- MySQL – Paul DuBois
- PHP Solutions – David Powers (“download.php”)
- SQL for Smarties – Joe Celko
[edit]
Project 11. Sdvault
You can review the information about this projet in sdvault.wikiplanet.com
- Project Team
- George Geller
Efren Cabrera
Ivone I.
Tina Lu
Angelica M.
Ralf Peeks
Xinshan Q.
Svetlana S
Rick H.
[edit]
Project 12. User Authentication
- Project administrator - David, Steven Mac, Tuan Pham
Everyone but Steven is sick. So, he presents this project. The presentation is very good, and shows us how to install MySQL, and how to configure our computer to work with authentication. Remarkable good presentation.
[edit]
Recruiter lecture: How to dress up for a telephone interview
The name of the recruiter is John Gruenwald.
He works for Ihire Associates.
His telephon numbers are:
T. 619.564.4383
M. 619.251.0600
F. 619.564.4405
His e-mail is: john_g@hireassociates.com
This presentation is about how to behave correctly when we are being interviewed for a new job. It was useful to listen to it.
[edit]
Monday june 4th
[edit]
Project 13. Application of administrative task in a web server
- Project administrator - Helen Uchihara
Helen shows us her aplication, and she shares with us a little about the problems she encountered, and how she decided finaly to migrate to windows.
At the end, she gave a gift to each one of us. That gift consists in an envelope, and inside we find some initials, and a description of the relationship that we will have with the persons that have those initials, if we met them sometime in the future.
[edit]
Award ceremony
The school gives awards to those students that had made a good effort in this class.
Ace Rashid obtains two of them, because we all voted and choose him as our best classmate.
George Geller gets one because he is one of the most helpful persons in this course, and he had worked a lot in it.
The next two awards are surprises. This are given to the students according to their records. Lynda and Joe had a hard time dicussing to whom should they give those. Because a lot of students in the class really deserve them.
Hui Peng gets one because she has been dedicated and helpful to her classmates.
Me!!...I just won an award! And I wasn't prepared for that!!! It was a total surprise! Joe said the reasons because they gave it to me, but I was so excited, that I couldn't take notes.
