Final post for class

16:00-18:00

Final class meeting, with group presentations.

This was a very useful class - I'd recommend it highly to anyone with a good programming background needing a quick course in web development and design.


Over and out...

Finished developer notes

12:00-2:00
Finished developer notes, contents are:

Account summary (username, passwords, various account descriptions)
Site administration (login information, and index page for editable content)
Content management (howto for image upload, RTE and calendar database)
Technical details (how to write a new web page, site layout, etc.)

class meeting

15:45-19:30
Met for class, did site review as group. (Fixed typos, gramatical errors, nits, etc.) Wrote whatever temporary content we could.

Site is now fully "live", no more lorum ipsem, though still plenty of "coming soon"... It's a shame, but our client apparently had still another death in the family, and has basically been out of action for the entire term. As far as content goes, we put up what we could.

more docs

15:00-17:00 -

• worked on technical docs.
• Added primitive weekly site backup, using mysqldump and tar. (Scheduled as cron job via dreamhost crontab panel.)
• Updated site xls file

worked on docs

18:00-22:00

Fixed a few minor issues, and wrote the docs for technical description of website.

• Technical details documentation is about 3/4 done. (Rough draft)
• Administrator's guide is about 3/4 done. (Rough draft)
• Content management users guide about 1/4 done.
• Replaced "disclaimer" link in footer with link, in red, to the administration page for the duration of an administrative login session. (<~10 minutes)
• Made some minor suggestions for Aubrey's forms. (Code was fine, just needed some refactoring to tidy up.)

team meeting

16:00-19:00

• Finalized the header and footer formats, replaced all the old files.
• Accepted the new file upload manager. Marked images as uploadable. (Got help from instructors for DOM code problems.)
• Cleaned up nits in style sheet (with Manit & Amy)

21:30 - 23:00

• Finished with the uploadable images. (Renamed images to correspond to their container pages; duplicated images that were linked from multiple pages.)

Except for the content, the site is basically complete. It's been a bit disappointing to get so little feedback from Nancy. :/

Added file upload support

16:00-23:30 (approx)

• Wrote php form for file uploading (uploadmgr.php) and for accepting the uploaded file (upload.php)
• Wrote javascript routines so that file upload manager is spawned when the image to upload is clicked. (Took a long time, since I needed to learn the javascript.)

Behavior of the upload manager

• img "alt" property is replaced (java onload function) by "click to upload" to give a cheesy tooltip in IE. (This required adding a "name" property to uploadable images. I don't like this.)
• img "onclick" added to launch the upload manager.
• May add red border to editable pictures in admin mode.

unify style sheets and navigation

16:00-23:00 (approx)

• Group meeting from 16:00-17:00,
• After discussion in class:
  Removed style directives from content pages, as much as possible. (With much help from Amy)
• Wrote new include file header that shows the appropriate secondary navigation (based on a variable)
• Stripped out all the secondary navigation stuff from the content pages.

Calendar function is working

17:00 - 21:00
Still need some work on style and I/O formatting, but INSERT, UPDATE and DELETE all work, along with presentation of a calendar (ranged query) for each event type (MUSIC, VISUAL, etc) or for all events together.

Action items:

• Use javascript for presenting data, rather than generating html with php. (It must be more efficient for the server.)
• Add relabelling for generic field-name input
• Add support (and security) for fully typed generic sql I/O

site plan, calendar

15:00-19:00

• Wrote the site plan, rough draft.
• Came up with a usable design for the calendar.
• Helped Zeke with rte configuration.
  

calendar plan

Will serve ranged queries on date, using first, last date and optional event type. Schema is:

CREATE TABLE calendar (

event_id INT NOT NULL AUTO_INCREMENT UNIQUE,
start_date DATE NOT NULL,
start_time TIME NOT NULL,
end_date DATE,
end_time TIME,
event_type ENUM ('MUSIC', 'VISUAL', 'PERFORMANCE', etc),
event_name VARCHAR(100),
event_location VARCHAR(100),
html_text TEXT(2000)


PRIMARY KEY (event_id),
KEY(start_date)
);
Limitations of RTE mean that uploaded images must go in a directory named .../image, and must be named by hand. This means that a user (dynamic) image directory is required, which I will call
href="/uploads/image" 

Some minor updates

16:00-19:30

• Added 'edit' subsection to admin.php page (links to all rte-editable pages)
• Configured rte to match site style so that site default font-size and style are preserved.
• Configured rte buttons to include just a few, including "save." (This took an embarrassingly long time, because I was getting burned by the browser cache. I ended up browsing the fckeditor forums for the answer.)
• added necessary php stuff to homepage to allow rte to work.
  
• Updated site index spreadsheet.
• Wrote simple contact form POST script.
  

Action items:

• Do we need file upload capabilities for images? (Probably, to make updating the main page easier.)
  
• None of the source <img> tags have width and height attributes. (Bad for slow connections.)
• How do you get this functionality?
  <input type="submit"
    onclick="history.back(); document.login.submit()" />
  

New admin page

16:00-19:00 (class)

• cleaned up the admin (replaced 6 web pages with 1.) Now does login/logout, add/drop user.
  
• wrote the xls page
• helped Amy R set up main-site php include files to her taste.
  

Work on admin layout

13:30-16:00

For admin layout, I would like a single admin page with multiple views controlled by a checkbox. I have most of the pages set up as separate php areas, but I'd prefer to do it on a single web page.

Also, writing rough drafts of

Required areas:

• Login [optionally in administrator mode, which also allows editing rte entries]
  
• Logout
• Add/drop/update users
• Update site page, xls file.
  

Action items

• How to do this with DOM scripting?
• Since aubrey and I are presumably working on the same site, do we share a site plan, etc?
• Time spent "on project" vs time spent for background?
• Talk to zack about rtes
  

Move php to live site.

~14:00 - 21:00

• Uploaded all test php material to main site.
• Uploaded Amy's development deployment to main site, did php-ization into fragments fragments.
  
• Set up user database (users table, html fragments table)
  
• Fixed site-dependency of php material
• Made initial default index.php file, including test edit field
• Failed to create a decent toolbar :(
  

Action items:

• I am having trouble editing javascript -- I edited the fckconfig.js, but the changes were not detected by the php server. (MyToolBar not found, etc.)
• Need advice on how to lay out include files vs content.
• How to redirect apache server from index.html to index.php (so that whitecenterarts.com references the php file directly)
  

FCK editor -- notes

Downloaded FCK editor. Attempt to make php sample page.

Problems:
- PHP sample page from wiki is broken. Replaced with .../_samples/php/...html
- sample program has incorrect variable name (BasePath, not Basepath)

Got it working, using relative paths.

July 5, 4:00-8:00
Reviewed and edited schedule and client information from Amy Richardson. Added Developer deliverables and schedule.

Investigated more web pages associated with WCAA:

Whidbey arts Not really topical--more gallery and less community
SnohomishArts Council Not really topical.
Georgetown Neighborhood Assoc.
Shoreline Arts Cold color scheme; also I don't like the deep navigation from left-panel. (Should be a site map.)
Freemont Art Council (Nice, buts needs more text on front page.)

Note that highlighted upcoming events list on front page is nice. (cf Georgetown, Shoreline.) It makes the page "feel" a lot more active.

Action items

- meeting with Nancy!
- MYSQL login!
- What is cgi-bin, etc for zephyr?
- Is it possible to set up a UNIX group for WEB210 on zephyr? We can use something like

~pmcilr01/public_html/web210-dev/

as a prototyping/staging area for the project. I would prefer that this page be editable only by members of the class, rather than the entire world. Meantime, I'll use group "users" as a proxy.

Updated: Jul 5 20:00

RTE investigation

3:00-4:00
Looked for javascript rtes. Found a useful review site. Also found openWYSIWYG. All of them are pretty simple. I'll probably select the rte by the size of the javascript.

Tested some of the rtes out in a test php document; they are very easy to set up, but I still need to figure out how to handle "POST" events on zephyr.

ITC 280 link:
http://zephir.seattlecentral.edu/~bnewman/conceptRTE/rteTest.php

12:30-3:00

• Verified login on student network.
• Set up zephyr account after some confusion due to improper registration. (WEB210 vs ITC 210)
• I did create a few test pages (html and php), but am unable to log in to mysql.
• Copied the templates from Bill's ITC210 page.
• Wrote DDL for calendar, institution, general user. Waiting on mysql login.
  

Unfortunately, there is still no response from Nancy on a first meeting. I sent a note asking whether she would like a simple calendar with all events (like seedseattle), or if she is expecting many events/week.

List of freeware apps

Product reviews

Application	Name	Description	Sample
Forum	Google/Yahoo group	Hosted newsgroup/tree view
Forum	phPBB	Basic freeware, very popular	phpBB community
Forum	vBulletin	Basic freeware, very popular	VBulletin community