arman/science-ation
1
1
Fork 0
forked from science-ation/science-ation
Code Pull Requests Activity
2,342 Commits 9 Branches 6 Tags 30 MiB
master
Commit Graph

385 Commits

Author SHA1 Message Date
james
4ee617eb52 Add more school information to the schools database (school lanaguage, school level, principal and school email addresS) 2006-10-15 17:11:56 +00:00
james
952047cc11 Add a prize value field to award prizes, also add editor the the value, as well add editor for the contact position 2006-09-20 16:24:52 +00:00
james
474c000377 Add a position field to the award sponsors contacts 2006-09-20 15:33:46 +00:00
james
0ebd709a13 Add the option to collect teacher signatures on the signature page 2006-09-18 19:33:48 +00:00
james
050f2093fb Replace "Sex" with "Gender", and allow the db field to be null, instead of defaulting to "male" 
BUG#105
 2006-09-04 16:28:28 +00:00
james
486536b331 Add full db 22 file 
update installer to properly add the current year's configuration variables
 2006-09-04 15:42:34 +00:00
justin
a169e422e6 Add support to choose what status a project must have to be used by the judge scheduler. Allows for any of open, payment pending or complete projects to be allowed. 2006-08-12 18:05:38 +00:00
james
14e93e0c12 Split the Configuration Variables page into separate 'Category' pages 2006-08-11 18:53:10 +00:00
dave
e7d726355d The new judge scheduler. 
- Missing: Having a project judged more than once by different judging teams is
  untested, I don't htink it'll work properly, still working on that part.
- Missing: Auto updating the configuration if any of the variables are missing.
- Missing: A way to preserve judging questions (like willing_chair), so the
  user doesn't delete them and break the scheduler, OR, notice saying that the
  question has been deleted and the scheduler won't use the chair calculations,
  then we need a way to add them back in with the click of a button.
 2006-08-01 19:43:15 +00:00
dave
6fc83836af Implemented a judges division editor, to be used before the automatic judge scheduler to 
set groups of divisions that judges can judge within.
 2006-07-31 18:17:37 +00:00
james
1519b427d2 Properly rollover the schools, allow 'lastlogin' to be NULL 2006-07-26 14:51:30 +00:00
james
2778faf4c9 Fix the broken sql script, looks like the 'questions' inserts were pasted in the middle of another query! 2006-07-24 16:07:54 +00:00
james
c934d3a9f7 switch year unsigned int (10) to year int (11) so year's of -1 (defaults) will work. 2006-07-12 14:45:53 +00:00
james
66efd08ee3 remove DEFAULT CHARSET (doesnt work on mysql 4.x) and switch ENGINE to TYPE for consistency 2006-07-12 14:41:42 +00:00
james
f117fb3dae Remove auto incremement values from FULL script too 2006-07-12 14:36:29 +00:00
james
ba38372fb5 Remove auto incremement values from table creation 2006-07-12 14:35:41 +00:00
dave
8665e4a487 Missing files 2006-07-12 14:28:52 +00:00
dave
228a1a0583 Implementation of configurable judges questions. 2006-07-11 20:22:42 +00:00
james
2ad2b58233 Bug #0000056 - Change variable wording of filterdivisionbycategory 2006-03-09 13:15:34 +00:00
james
5aca0a8ac9 Add full 16 and 17 and update for 17 2006-03-08 21:21:20 +00:00
james
e5d03b07a9 switch the new database stuff to DB16 instead of 15, and bump the required db number 2006-02-24 17:52:04 +00:00
james
5518a2272f Add the signature page editor 
And insert the defaults to the database
 2006-02-24 17:42:11 +00:00
james
45b4f7b220 Fix a bug where the school id was not being set when participant registration type was set to invite or singlepassword 2006-02-23 20:40:48 +00:00
james
46c92e0f01 Wrap the db update script in <pre> tags so the output looks better for anyone that runs it through the webserver 2006-02-07 20:59:58 +00:00
james
b72c778ea1 Add the db 15 update 2006-02-07 20:51:42 +00:00
james
b807381418 bump db version to 15 2006-02-05 21:52:40 +00:00
james
1771c83da4 Add a configuration option to specify whether to collect 'personal' information about the students, such as address, phone number, date of birth, etc. 2006-02-05 21:39:32 +00:00
james
99af4b4f4a Bump development branch to 1.0.1 and db 14 2006-02-02 03:23:48 +00:00
james
588d994d41 Add full db.13 file, and bump version number to 1.0.0 2006-02-02 02:59:12 +00:00
james
a20dfdbd7a Merge Jamie's changes from Peterborough, allowing different divisions to be available to the different age categories. -- default is 'no' 2006-02-01 16:29:08 +00:00
james
a9ffdf7ee4 Oops fix the misspelled "Divison"s 2006-02-01 15:31:09 +00:00
james
2784262d6d Database update for the 'exclude from awards ceremony' new feature 2006-02-01 05:09:59 +00:00
james
c5e55fad37 Remove the unneeded configuration params for timeslots from the scheduler 
Separate the 'requirement check' into a separate file and run it on both the config  page, and as a double check on the actual annealer page incase they decide to manually type in the address or bookmark or somkething.
 2006-01-31 22:34:04 +00:00
james
cf22c24c78 Add school district and school board fields to the schools database 2006-01-27 18:36:53 +00:00
james
7b5d56ce60 Update the judges timeslot editor to have a new field for 'allow divisional'. This specifies whether the automatic judges scheduler can use this timeslot to scheduler the divisional awards judging. 
Add a new feature to the timeslot editor to add multiple timeslots at once, by specifying the start time, duration, and break time.
 2006-01-26 21:42:04 +00:00
james
36bee33066 Add a configuration option to specify the maximum number of words in the project summary (Default=100) 
Add some fancy-smansy javascript/dhtml word-counter code to the project summary.
Make project status be incomplete if word count is too high
 2006-01-24 15:44:08 +00:00
james
1585fdb3e6 bump version number to 0.9.9 and db version 13 2006-01-20 20:19:47 +00:00
james
1aec62aa4b Oops, 0.9.8 only requires version 12 2006-01-20 20:04:49 +00:00
james
1a04556319 add full version 12 database 
bump version number
 2006-01-20 19:58:06 +00:00
james
2135a5aa5b bump database version number 2006-01-19 19:24:36 +00:00
james
4d54bdbb1c Update translation manager to work with unlimited number of languages as defined in the languages table 
Update i18n function to accept a third parameter, which is an array that describes the arguments in the string to make translation much easier
Update some of the config/admin pages to make sure i18n is properly used, and that argument descriptions are set
 2006-01-19 17:15:07 +00:00
james
69b4b943ac Make the T-Shirt size question to students able to be disabled via a configuration variable for fairs that dont give out tshirts 2006-01-18 05:33:13 +00:00
james
321a245670 Split school access and school participant invitations into separate files 
Update invitation system to keep track of the number that have been invited and not allow the school to invite more than they are allowed
Update the schools editor, to allow specifying the max number of projects and whether the max is total for the school, or per age category
Add required fields to the schools table
Update the config variable for special awards registration to allow turning special awards registration off
 2006-01-18 05:22:58 +00:00
james
0043071501 Bump version to 0.9.7 so development can continue, also bump DB version to 12 2006-01-16 06:03:50 +00:00
james
60074d3caa Bump version number to 0.9.6 
Add the full database file for DBVERSION 11
 2006-01-16 05:21:52 +00:00
james
5748382c97 Whoops, fix the bugs in the db update file, it should import properly now. 2006-01-03 02:17:30 +00:00
james
56a16916e2 New database code for new stuff 2006-01-03 02:00:11 +00:00
james
d8321449f9 Bug and Typo fixes are per John Meskes 2005-12-15 22:28:04 +00:00
james
5b35723e8a Bump version to 0.9.5 and db to 10 for the FINAL TIME :) 2005-12-15 16:24:57 +00:00
james
f12bdfec09 THIS IS THE FINAL REVISION FOR 0.9.4 2005-12-15 16:10:09 +00:00
james
d461952fa4 re-bump version to 0.9.5 and database to 10 2005-12-15 15:59:05 +00:00
james
f2c08f472d Whoops! Rollback to 0.9.4 and fix the bug in the full.9.sql so the installer will work again! I'll need to repackage... 2005-12-15 15:53:37 +00:00
james
39627cd2f5 Update version to 0.9.5 and DB version to 10 in preparation for new stuff 2005-12-14 21:26:58 +00:00
james
1ccaeac8eb Add the FULL v9 DB 2005-12-14 20:14:22 +00:00
james
e8353f011f Add the judge inviter to the judge administration section 
Add the new judge invite email
 2005-11-25 21:15:29 +00:00
james
6eb1a39d0b add the ability for schools to invite participants IF participant_registration_type=="invite" 
also switch the new participant email to read from the emails table instead of hardcoded from the file
 2005-11-25 19:37:10 +00:00
james
860175ae79 NEW FEATURE: Participant Registration Type 
Open - Anyone can register.

	Single password - Same password for all schools, they tell the 
		students that will register what the password is.

	School password - One password per school, they tell the students
		that will register what the password is.  School is 
		pre-selected based on their school password.  This will allow
		eventually the ability to restrict participation numbers on
		a per school basis

	Invite - The teachers at the schools must 'invite' the students 
		to register by logging in as the school and creating
		accounts for each student.  The student then logs in and
		finishes entering all of their information.  This will allow
		eventually the ability to restrict participation numbers on
		a per school basis

Bump version number (0.9.3-svn)
 2005-11-24 20:21:55 +00:00
james
2c859da295 Add the full 8 database version for installations to use 2005-11-22 14:21:53 +00:00
james
35761a542b wow i scrwered this one up :) this should work now 2005-11-21 21:00:31 +00:00
james
d6256d7c11 whoops wrong filename! 2005-11-21 20:39:59 +00:00
james
b639308993 Add page text functionality, to define arbritary page text to be displayed on pages without having to edit the actual files. 
Also shrunk the padding on summarytable, 4px seemed just way too big of a waste of space :)
 2005-11-21 20:33:18 +00:00
james
343c70f633 Added the fair year rollover code to go from one year to the next 2005-11-21 19:36:48 +00:00
james
bd4f8b6739 whoops, the code for the fairmanager was messed up - should be fixed now 
also set the fair manager to the superuser on installation
 2005-06-07 21:36:07 +00:00
james
6a9b470698 Switch the database versioning code from a flat textfile (db/db.db.version.txt) to a record in the config table (var=DBVERSION, year=0) 
This gives us a much more robust database versioning system
 2005-06-07 21:03:55 +00:00
james
7509f5f7c1 hmm there was a duplicate of all the config options for some reason in the full.7 - remove those dups! 
also add the provinces to full/update 7
 2005-06-07 20:30:38 +00:00
james
5ef9051c0a Nearly finished install3 - I think the installer is almost ready to be used. 
also updated DB version 7 to include the language entries
also update common.inc.php to make sure install3 is installed (make sure there's entries in the config table!)
 2005-06-07 01:23:15 +00:00
james
0f4616c2da remove the ID's from the dates INSERT in the FULL 7 file as well 2005-06-06 19:01:06 +00:00
james
047175d4df whoops, remove the ID's from the dates INSERT lines 2005-06-06 18:58:32 +00:00
james
abf46c9e7c Setup defaults in config and dates table to be year=-1 
The config and dates pages now need to be updated to read defaults, and insert new config parameters as FAIRYEAR if they dont exist already
Bumped version to 7
 2005-06-06 18:56:19 +00:00
james
85e2569446 Add the full database structure for db version 6 2005-05-26 20:32:42 +00:00
james
9604c35f4b Add the installer script - currently it only creates the data/config.inc.php database settings - it still needs to create the actual tables. 
Add some extra sanity checking to the db updater

Add more sanity checking to the common.inc.php
 2005-05-25 21:58:03 +00:00
james
9ea5843646 whoops last messgae should hav ebeen : add schools management 
this one fixes the db to use province_code instead of province
 2005-05-13 17:36:29 +00:00
james
ed663e77eb Wow I dont even know what all is in this commit: few things i do know: 
1) add (preliminary) special awards nominations for students
2) add css right-margin to summarytable class
3) add new table for projets-specialawards-link
4) move projects.inc.php from admin/ to / (so particpant registration can use it)
 2005-05-11 04:13:27 +00:00
james
a947ff8e85 Whew! Add a new interface to link judging teams with the awards that they are 
judging for.  Can now auto-create judging teams based on awards list (one team per award).

db bumped to v6

moved judges_teams to judges_teams_members
judges_teams is now the new interface
 2005-05-06 16:13:37 +00:00
james
c171fe752d enter winning projects 
new database files
update PDF addText to go to next page when necessary
awards ceremony script
 2005-05-04 21:23:00 +00:00
james
098649c8a3 Add Presenter to awards 2005-04-26 18:59:38 +00:00
james
1f21e06d00 lots more db changes 2005-04-19 19:22:38 +00:00
james
9b385a10fd whoops add the sql update file too 2005-04-15 20:33:49 +00:00
james
3f471bde41 Add judge team captains, bump db version 2005-04-15 14:27:18 +00:00
james
79e166dde7 hmm this didnt get committeed 2005-03-29 19:56:42 +00:00
james
7ba1196957 whoops named it wrong 2005-03-29 19:21:35 +00:00
james
d059f34835 Implement date checking for both participant and judge registration 2005-03-29 19:21:14 +00:00
james
e049de4562 add message at the end 2005-03-10 17:33:30 +00:00
james
9d60276f89 readfile the script so we know whats happening 2005-03-10 17:31:23 +00:00
james
81e1559b8d add the database updater code, and always ensure that the code and db are running the same version 2005-03-10 17:28:15 +00:00