Home Cropped

SeniorQuoter is an installable web app in PHP which helps high school yearbooks collect quotes from seniors to be put in the school's yearbook. Read more...

SeniorQuoter 2.0beta1 is out!

Ten more revisions later, all of the small bugs are now out of SeniorQuoter Version 2.0. That means it is time to issues the beta. There are still some big issues which are listed below. However this release is usable. It also needs to be tested on a variety of environments and servers.

This release also marks the end of group study at Haverford. From here on out I will be developing on my own in my free time. This means that future progress will be far slower.

Download from SourceForge

Issues fixed from 2.0alpha2

Note: The database schema has changed. I would start a new install, as upgrading is not supported.

  • Make colors.php print out container color (why was this not done before)
  • have it cache images
  • Tell users to start websites with http:// in setup.php and config.php
  • Make header.inc.php require that setup.php be deleted (for security)
  • Remove <pre> from quote.php and quotes.php
  • Move print invitations link from quotes.php to students.php
  • Remove var_dump from upload_picture.php
  • Clear out unt's info from mysql_connect.php
  • Try to get setup.php to recognize DB info is there
  • Fix up colors.php a lot and fix it not being able to change the bg color
  • Fixed quotes.php and csvexport.php to only get the latest quote!!! (45 min)
  • Fix change_password.php to change the password of the given id, not the logged in user
  • Fix Bug 45: cross installs cookies - by setting cookie path in login.php
  • Say why remove setup.php in header.inc.php
  • Bug 90: Colors is blanked if gets it gets messed up
  • Make Homeroom, Code, Email, and Year optional in add_student.php
  • Make Add student auto genorating a code if none (no JS needed)
  • Delete assign_codes.php since codes will be assigned when user is added
  • Worked with importing to escape and validate (and auto add codes better)
  • Found importing bug (95) where 1st row ignored
  • Fixed remaining counter color in colors.php
  • Set default colors in colors.php to be 6 digits
  • Worked on testing import - fixed a few things including first name and last name order and finding the reason for bug 95.
  • Made student id optional again (and in database this time)
  • Printed out code for each student after import
  • Fixed bug where it would throw an error if quote was exactly length limit!
  • Tested Color Picker in IE7 and resolved bug 70
  • Make sure code is numeric in quote submission index.php
  • Make tabs work (lighter for selected item)
    • Written in header.inc.php $menu tells it which
  • Triaged bug list (marked bugs as fixed when they had actually been fixed for a few days)
    • 16 bugs fixed in last 2 days!
  • Make delete_student.php delete any quotes associated with that student bug 99
  • Don't let users "forget their passwords" if they are disabled. bug 42
  • Link Favicon to each page bug 41
  • Stopped Admin User's Date Registered from being changed on every update bug 46
  • Enable image caching bug 100
  • File bugs for the stuff that still needs to be done.
  • Validate all pages clean up small bugs to make it Valid XHTML
    • Make lots of small fixes
  • Remove "Assign Codes" button from Quotes.php since that page was deleted
  • Make link after install is complete bigger

Open Issues

Some of these are minor or feature requests. The big issues are listed in bold. The site is still usable, but character encoding and security needs to checked out. That is why this release is a beta.

  • 96: Prevent deletion of super-admin user
  • 40: Secure forgot password
  • 71: Upload not secure
  • 77: SQ: Unify character encoding
  • 78: PDF Invitations Bottom Half Uneven
  • 81: SQ: Invitations need Logo and style
  • 103: Homerooms Table doesn't do anything
  • 104: SQ Needs Security Audit
  • 105: Setup INSERT queries don't work
  • 108:SQ Needs to be tested on another server
  • 106: Dashboard is boring
  • 44: SQ: Nasty words dictionary
  • 55: Set up Debugging interface
  • 66: SQ: Sort by letter
  • 88: SQ: Line break limit

SeniorQuoter Version 2 Alpha 2

Ten revisions and two days later, Alpha 2 has a lot of bug fixes in it. In addition, I have finally linked and added icons for all of the pages. Setup should go much smoothly as I have added a lot of error checking code in there. Plus some more fixes here and there. Quotes are now printed as "preformatted" to preserve line breaks. Every script has been edited for the making of this release!

However there is still a ways to go, including character encoding, debugging interface, multiquery setup, and several serious security flaws.

Download from SourceForge

Fixed

  • Setup error handling improved
  • Linking and icons
  • Add link to View Students in add_student.php
  • Change id to class for buttons in admin/admin_users.php
  • Fix spell check in config.php
  • Make button css in admin.css
  • Make register.php print success message in green
  • setup.php: Use new refresh code that works; Print out headers eariler, print out actual errors when checking config, put fresh links in saving config, and continue if it is there, fix printing of googiespell settings
  • Plaz added security features to invitations.php to require log in quote.php and quotes.php
  • output quote in "pre" tags to preserve formatting in quote.php and quotes.php
  • Fixed students.php link in delete_student.php
  • Fixed disable quotes for index.php No more ugly errors when $collect == FALSE!
  • Tested upload_pictures.php
  • Fixed colors.php to work much better
  • changed edit_quote.php and index.php so approval is NULL after edited
  • fixed edit_student.php so you can have any type of character in the homeroom field.
  • URL for hard refresh help
  • Add more error checking to setup.php
    • test DB connection
    • Add refresh links in a lot of places

SeniorQuoter Group Study Crew

The SQ Class Group
From right to left: Michael Gdovin, Sean Maguire, Michael Plasmeier, Shawn Ard, and Gary Hunt

SeniorQuoter Version 2.0alpha1

SeniorQuoter 2.0alpha1 is out!!!! This version still has a lot of bugs (and is missing a lot of links to features), but is feature complete! SeniorQuoter 2.0 was developed by the Group Study at Haverford High School: Michael Plasmeier, Michael Gdovin, Shawn Ard, Sean Maguire, and Gary Hunt.

This version is only recommended for testing (and it needs a lot of that!) There are still many bugs in SeniorQuoter, including several security vulnerabilities. Also many pages are not linked to each other. The team will be spending the next week fixing the bugs.

There will be more posts coming in the next few days listing the features of Version 2.0 and the new administration interface. Also, we made many changes to the database (and more to come possibly), so I wouldn't try to upgrade from version 1. Instead this is for developers to play around with so we can get SeniorQuoter ready for quote collection next year.

Download from SourceForge

View Bugs

New Bug

Or comment on this article.

Bugs

bug_id bug_severity priority op_sys bug_status resolution short_desc
28 normal P3 All NEW Add options to config file
30 normal P2 All NEW Menus not linked right
36 normal P3 All NEW Style SQ Log in page
38 normal P3 All NEW Make redirect a function
40 major P2 All NEW Secure forgot password
41 trivial P3 All NEW SeniorQuoter Fav icon
42 major P2 All NEW SQ: When a user is disabled - don't let them forget password
43 normal P3 All NEW SQ: Make Button-Link CSS
44 minor P3 All SQ: Nasty words dictionary
45 critical P2 All NEW SQ: Cookies go cross install
46 normal P3 All NEW SQ: "Date registered" is changed if a user is edited
55 minor P3 All NEW SQ: Set up Debugging interface
65 major P3 All NEW Funny character don't display right in quotes
66 enhancement P4 All NEW SQ: Sort by letter
70 normal P3 All NEW Color Picker doesn't work in IE7
71 normal P3 All NEW Upload not secure
72 normal P3 All NEW Remember Me Doesn't Work
75 normal P3 All NEW Double Quotes on view quotes page
77 normal P3 All NEW SQ: Unify character encoding
78 normal P3 All NEW PDF Invitations Bottom Half Uneven
81 normal P3 All NEW SQ: Invitations need Logo and style
84 normal P3 All NEW Add Students Needs to only Allow 10 digit codes
85 normal P3 All NEW Upload Picture Needs Refresh

SeniorQuoter Code Worth $ 41,153

I ran David A. Wheeler's 'SLOCCount' on 12/28/2007 and found that SeniorQuoter contained 3.66 person months of code. This would have cost $41,153 to develop had it not been written by volunteers.

Total Physical Source Lines of Code (SLOC) = 1,493
Development Effort Estimate, Person-Years (Person-Months) = 0.30 (3.66)
(Basic COCOMO model, Person-Months = 2.4 * (KSLOC**1.05))
Schedule Estimate, Years (Months) = 0.34 (4.09)
(Basic COCOMO model, Months = 2.5 * (person-months**0.38))
Estimated Average Number of Developers (Effort/Schedule) = 0.89
Total Estimated Cost to Develop = $ 41,153
(average salary = $56,286/year, overhead = 2.40).

Syndicate content