arman/science-ation
1
1
Fork 0
forked from science-ation/science-ation
Code Pull Requests Activity
1,316 Commits 9 Branches 6 Tags 30 MiB
sfiab-users-makeover
Commit Graph

243 Commits

Author SHA1 Message Date
dave
daf3314c03 - Fix the sql database for hte last commit 
- move code around in curl for less indentation
 2009-09-08 17:39:57 +00:00
dave
d91ac62015 - Convert award sources to fair users 2009-09-06 00:07:26 +00:00
dave
dbff1e0bbc - Move the curl query to its own file, and modify the two spots that it's used 
to just call the function
- Rework the fair editor for user friendliness.
- Beginnings of sfiab->sfiab award download (and winner upload)
 2009-09-05 23:04:14 +00:00
dave
4eea632521 - Sneak in a database update. We can use the fairs table to enable stats, awards, and winners. 
For a feeder fair specifying the upstream fair, this means the feeder
	fair will request to download stats, download awards, and upload winners. 
	For the upstream fair specifying feeder fairs, this means the feeder
	fair is allowed to upload stats, download awards, and upload winners.

--This line, and those	below, will be ignored--

M    db/db.update.128.sql
 2009-05-04 06:32:36 +00:00
dave
f58fd10749 - Serverside for the stats gathering. 2009-05-04 06:13:44 +00:00
dave
2aab58b28d - Fix a typo in the last db file 2009-04-23 03:53:41 +00:00
dave
cfdcfb7c9d - More data, more stats 2009-04-20 05:27:06 +00:00
dave
d2e9a4e64e - Partial DB updates, and an xml transport script for feeder fairs to communicate 2009-04-20 04:34:37 +00:00
dave
255adde40a - Update the designate field, make it editable by everyone 
- Add an "at risk" field, to flag schools.  This is purely for stats gathering.
- Add a fairs_stats page to gather stats from sub-fairs.  This will be used
  when linking SFIABs together so the feeder fairs can upload statistics to,
  say, a provincial body (both runnign SFIAB).
 2009-04-12 21:38:51 +00:00
dave
6bd52d6ff2 - Add the basics for a science fair "user". 2009-04-12 03:13:09 +00:00
dave
c158b9aad1 - Judge timeslot selection page, default: disabled. The scheduler doesn't use 
it yet, but here it is.
 2009-02-09 07:09:09 +00:00
dave
799c014b6c - Use name, not round_name. Name will never confict 2009-02-06 06:55:32 +00:00
dave
9b828b15d4 I used 'special' not 'specialawards' in the code 2009-02-06 06:52:28 +00:00
dave
0f763de1ac - Add a 'language' input type to the config editor 
- Change config[default_language] type to langauge, no more people messing it
  up by typing in "English" or "American".
 2009-02-05 09:14:41 +00:00
dave
b39072f098 - Add an update php script to properly convert the old timeslots into rounds 
with sub-timeslots.
 2009-02-05 07:57:15 +00:00
dave
b7da5c59a5 - Convert old timeslots to the new rounds+timeslots format 
- New timeslot editor (still needs icons)
 2009-02-04 08:03:37 +00:00
dave
ad27a96874 - Use the unique user id (users_uid) instead of the user id (that changes every year) when linking users to committees. 
- Also use the uid when displaying committees and contact info.
 2009-02-03 22:45:11 +00:00
dave
cd1de0ddfd - This update was missed, it's kinda needed so we dont' have everyone on the committee with a unique user id of 0. 2009-01-22 01:27:10 +00:00
dave
c2309c0174 - Fix a typo to let the .119 update apply 2009-01-21 08:10:55 +00:00
dave
d00086aea5 - speaking of errors 2009-01-21 08:02:45 +00:00
dave
af6eb12985 - Handle the case where a user is a volunteer and a committee member, tested. works. 
- Add the UNIQUE username,year condition to the 117 update.
- Bump the version to 119.  I won't commit anything else to the existing
  updates, unless I find an error in a script.
 2009-01-21 07:42:15 +00:00
dave
dd5eae506f - save the file before trying to commit it :) 2008-11-08 08:36:11 +00:00
dave
bfb2b63a68 - the rest of the user invite system, should all be working now. Can be used 
to invite Volunteers and Judges, or add the volunteer/judge role to an
  account, or send a reminder email to a specific volutneer/judge that
  registration is now open and they should login.
 2008-11-08 08:35:08 +00:00
james
3ab46da3d5 Add defaults and descriptions to fundraising types and sponsorship levels 
Start working on the sponsors main page for when a sponsor logs in
 2008-11-06 21:07:40 +00:00
james
c41be1a17e Add more fields to the sponsor table 2008-10-25 05:01:29 +00:00
james
c100baef89 Add more fundraising module stuff, the SFIABDialog code will be refactored out into a separate library class eventually 2008-10-23 21:32:31 +00:00
james
2d8c3a72ef Add more ISEF form handling database, keep as 999 cuz we're not ready for it yet 2008-10-22 20:48:22 +00:00
james
bce2cef92e Add some user sponsor stubs 
Fix some multi-year user stuff
Add sponsor main page
 2008-10-22 20:35:35 +00:00
james
3c1a4d29cc Merge judge records into existing user records 
Start to cleanup users table to be able to add UNIQUE(username,year)
 2008-10-22 16:44:03 +00:00
james
f981858df9 Change sex field in 116 so judges also default to NULL 
Add start of sponsor contacts conversion to user system for fundraising module
 2008-10-20 21:04:19 +00:00
james
35d3211391 Fix parse error 2008-10-20 16:56:31 +00:00
dave
81c211c913 - add judge special awards selection 
- fixup the judge_complete detection
- rename judges_id to users_id in the 117 db update, so it's done after the 116
  update converts everything
 2008-10-18 03:30:58 +00:00
dave
ca81fc2273 - delete the year too, and do the users_id conversion in one spot only 2008-10-17 20:40:11 +00:00
dave
87c845c048 - convert the registrations_id in the question answers to the new users_id (it's really the users id anyway) 
- add a 117 script to cleanup all the post 116 stuff, deleting unneeded tables and whatnot
- these are NOT THE FINAL scripts, more will be added to these.
 2008-10-17 20:38:01 +00:00
dave
b021805246 - conversion of judges to new user system. Mostly works. 2008-10-17 19:34:11 +00:00
james
f569ed3e13 Fix Quebec province translation so its country code is properly set. 2008-10-06 18:50:18 +00:00
james
91bc77d640 Add the start of the isef form collection page for participant registration and the database setup in db.999 until its ready to go live 2008-09-28 18:36:56 +00:00
dave
54aa1b7658 - One more quick fix, make it "special award only", instead of "awards", 
because a judge that wishes to judge a specific special award is only allowed
  to choose one.
 2008-09-15 15:46:22 +00:00
dave
15f9d0cb89 - Remove my testing database name from the CREATEs 2008-09-15 03:59:53 +00:00
dave
f8f9964fba - Non-invasive commit, ground work for moving judges to the user backend. 2008-09-15 03:51:52 +00:00
james
9995867f1d Add countries table and populate 
Add countries_code field to provinces table and fix canadian provinces
Populate US States into provinces table
Add config option to Localization tab to enter a 2 letter country code (how to lookuup from countries table?!)
Update emit_province_selector to use country config entry
 2008-08-28 21:41:31 +00:00
james
d5ff3be6b9 Use page text description instead of the database page text name on the page text editor list. (BUG 198) 2008-08-26 21:06:05 +00:00
james
15cb1f9782 If there's no entry for the current fairyear, insert the default entry 
Delete all instances of index from the pagetexts, not just the current year
 2008-08-22 17:11:20 +00:00
james
7e84ab0222 Add cms table, and move the 'index' pagetext to cms 
Add .htaccess rules for the cms
Add cms page display code and convert index.php to pull from the cms
If no page title is passed to send_header(), output the fair name in the <title> tag
 2008-08-19 21:13:29 +00:00
james
3d33d976c3 Create a Localization Category for config variables, and move the Province/State, Postal/Zip there 
Add new config variables for dateformat and timeformat
 2008-08-18 21:33:30 +00:00
james
fca09d86c0 Update the database to store the page texts in multiple languages 2008-08-18 21:09:12 +00:00
james
517455ee13 Migrate css to a theme and setup to allow multiple themes 
Begin adding icons to the default theme and reorganizing the admin index
 2008-07-24 16:20:16 +00:00
james
40bc5f93ef Oops and add the db update for the new config options 2008-07-16 17:24:19 +00:00
james
651d6235a4 Add config options for Province/State and Postal Code/Zip Code 2008-07-16 17:23:53 +00:00
james
0dc2862fa0 VERY important update to reports_items that dave must have missed.. took me THREE HOURS to track down why alignment wasnt being saved from the report editor! 2008-03-27 06:22:11 +00:00