Development Notes

• Working theory: The following two changes to php.ini allow larger than 8MB uploads
  • There is a memory_limit directive in PHP.ini that defaults to 8 MB. We changed this to 50 MB.
  • There is a post_max_size directive which might be left out of php.ini. If left out, it defaults to 8 MB. We added and changed this directive to 50 MB.

• Significant changes to site Design etc. I've designed and created the new Tables in the DB that we should need. When we design the critiques page (to make it middle-school friendly), we'll have to make significant changes to that table, but the overall structure is in place.

• Added new version of CSS (changes made by Lee)
• Added new version of Tutorial page (plus a lot of docs that are linked) (also made by Lee)

• Animation Displayer seems to be working fine. Need to test it out with more codecs on different computers etc.
  • Will begin comment system soon

• phpBB now logs visits in the AnivalDB.
  • Made a change (added some includes) to phpBB -> includes\page_tail.php

• Created admin.php (resides in the admin directory)
  • This pages has links to all the other administrative task pages that we have created.

• Made changes to screeningroom_genre.php and personalanimations.php
  • The titles of the animations are now links to the viewer page

• Made cosmetic changes to animationviewer.php

• All current Anival (non-phpBB) pages are logging visits.
  • Added new table to Anival DB, it is called "Log"
    • Stores all the visitor information
• Created new directory called "admin"
  • Added 2 new files: log_visits.php, visits_anival.php
    • log_visits.php is included by the footer -> records and inserts in DB
    • visits_anival.php -> shows page stats
• Moved admin_featuredanimation.php and admin_process_featuredanim.php to the admin folder

• Continued work on the Members page
• Started work on adding the "logging" page/stuff that was developed elsewhere.

• Movie display now works! I'm going to start a commenting system for movies and develop this page. Still have problem with directly downloading and playing a file.
• Javascript form validation is complete for uploads!
• Need to make sure that 11@ and 1@ are interpreted differently in the main screening room page.

• Completed Movie admin that allows deletions. It deletes the movie info from the DB only if the files are deleted. One thing to watch out for, if you reload this page after performing a deletion, you will receive an error since php will try to delete the file again (which no longer exists).

• Started working on displaying videos within a page. Seems to be working correctly, except for that problem we had with opening files directly (i.e. When we click on a link to a video, we are presented with the Open or Save options. If we open, the file will not play, but if we save, then open, it works fine.) No idea, right now, how to fix this.
  • I think this might be related to some kind of DRM or windows firewalling. I was about to try quicktime to see how that worked when the server went down again. I'll have to try later

• Started to make changes to the members page. This will display a list of current members as well as their studio affiliations.
• Asked for more quota.

• Created an admin.php page. Not really sure where it should go in the end, so for now its just in the root. I'm working on adding movie deletion functionality. In order to verify that the user that is viewing the page is an admin, I'm querying phpbb's db for the user's user_level, which I will compare with the session variable of the user viewing the page.
  • This required an additional include (that should not be in the web-live directories for the phpbb_db connection stuff). I don't have permissions on that directory, so it is temporarily contained in admin.php
  • Mostly done, don't know why the button is so small and at the top of the page, also need to add php deletion code to actually get the files. right now, would only delete the entry from sql (probably...need to test it)
  • Got the unlink() function to work correctly, but there's a problem with iterating over all checked files, only the first one is caught for some reason.
  • Will be finishing this and working on video viewing this weekend.
    • server was down monday night, and is again tuesday morning :-(

• Created two new pages admin_featuredanimation.php and admin_process_featuredanimation.php
  • From these pages an admin can select an animation and make it "featured"
• Also made changes to LEFT_featuredanimation.php in order to display the information on the featured animation. (Doh!)
  • We need to take a look at the actual design, since it isn't really working just yet. Also, make sure all the appropriate linking is done!

• screeningroom/search_results.php is now showing the results of the searches made.

• Made changes to RIGHT_search.php
  • This will search the movies by username (participant) as well as title.
  • Created screeningroom/search_results.php, this is where the search results should show.

• I'm making change to Pear_DB.inc and pass.inc
  • I will add a NEW db connection so that both anival AND phpBB are available.
    • NOTE: This change affects all since it is in file NOT in CVS!!
  • The main change is that db calls will go to either of two dbases.
    • $db -> Anival
    • $db_phpBB -> phpBB
  • NOTE: If the phpBB user/pass change, they must be changed here TOO!!!

• The home page to competition (competition.php) now displays all the information on competitions and challenges. They are ordered by end date.
  • admin_competition and admin_process_competition are the admin pages.
    • Use admin_competition to create competitions and challenges.
    • process_competition adds stuff to the DB and not much else.

• Started working on the competition pages. In particular designed the DB to store that info (chech phpMyadmin...4 new tables)
• Have started to work on the pages to administrate the competition.
  • Add new competitions, challenges to existing competitions, etc.
• All of the above is pretty preliminary.

• Completely reorganized the dir. structure
  • There are now specific directories for JOSE, PETER and RELEASE.
    • These have the same files except where JOSE or PETER have made changes in their stuff.
    • RELEASE will have the latest release version after JOSE and PETER have updated and committed their stuff to the CVS server.
  • There are 2 folders that are NOT IN the CVS.
    • includesSPECIAL has files that should reside outside of the html dir. (files with passwords)

• uploads is where all the animation uploads will reside. This folder should be "synced" with whatever the anival DB knows.
• phpMyadmin also resides in the "root". This is good.
• All files not mentioned above are now CVSable.

• Fixed processupload.php so that it inserts the correct timestamp.
  • (it used to only insert the date, now it is the date and time)
• Random animation is now working. Still needs more "info", but at least the random select is ok. (includes/RIGHT_randomanimation.php)
• Latest animation is now working. Still needs more work like random animation. (includes/RIGHT_latestanimation.php)

• Screeningroom.php now displays the number of animations in each category.

• More progress on screeningroom_genre.php
  • The page now lists all the movies of the given genre and displays them in a nice little table.
  • Genres are stored as @ where the "at" is used to separate them.
    • Ex: A movie categorized as genres 1 and 2 would have MOVIES_GENRE= 1@2@

• The upload page now includes checkboxes for the categories.
  • These are generated dynamically (gasp!) and are processed carefully in order to construct the string of genres that is inserted into the database.

• Created new pages screeningroom_genre.php and personalanimations.php
  • Also made edits to loginbox.php to add a link to personalanimations.php

• Created new table "Genre". Holds information on the genre of animations. 3 fields.
  • Edited screeningroom.php so that it shows a list of all the genres. This page links to screeningroom_genre.php which will list all the animations of a particular genre.

• Added new colum to MOVIES table. It is called MOVIES_GENRE and will hold a string of the genres that a certain movie has been associated with.

• Fixed includes of PearDb and pass.inc. Pages in the root directory now have a variable called $rootdir. The includes are now conditional depending on that. (see includes/header.php for details)

• We are now using the PEAR dbase wrapper. It is really easy to use though you might want to check out the web documentation.

• Anivals general header file is including the DBinfo.(include/header.php)
  • The info is in two special include files located in (./includesSPECIAL):
    • pass.inc -> Has the user and password
    • Pear_DB.inc -> Has the DBname and the host. The DB connection is actually opened from here.

• The upload processing page (screeningroom/processupload) is working correctly now. (it checks mime type and inserts into database)

• The screening room home page (screeningroom/screeningroom.php) now lists all the movies in the DB (with links to them)
  • I can't get the links to work...I think it is a permissions problem on the upload dir...