CHANGES.md

CHANGES

RosarioSIS Student Information System

Changes in 12.1.1

• Fix SQL error when single quote inside relation in Registration.fnc.php & RegistrationAdmin.fnc.php
• Allow creating historical marking periods up to 10 years in the past in EditHistoryMarkingPeriods.php & EditReportCardGrades.php
• Fix PHP < 8.0 warning Wrong parameter count for number_format() in Transcripts.fnc.php
• Fix PHP warning undefined variable $percent in FinalGrades.inc.php

Changes in 12.1

• MySQL set CREATED_AT on INSERT in rosariosis_mysql.sql
• Add Admin Delete Permission in functions.inc.php, Expenses.php, Incomes.php, Salaries.php, StaffPayments.php, Exceptions.php & Profiles.php
• SQL Add Admin Delete Permission to profile_exceptions & staff_exceptions tables in Update.fnc.php, rosariosis.sql & rosariosis_mysql.sql
• Add "Show only my courses" checkbox in Courses.php
• Add Breakdown by Grade Level in DailyTotals.php
• Remove "only 1 MP & 1 grading period open at any given time" check for Progress Periods in MarkingPeriods.php
• Add help "limitation does not apply to progress periods" in Help_en.php & help.po
• Update SimpleXLSXGen to version 1.4.12 in classes/SimpleXLSXGen/
• Add help about Permissions (tooltip) on Add a user screen in Users/includes/General_Info.inc.php
• Add-on SQL translation file can be under locale/[locale_code]/ folder in Modules.inc.php & Plugins.inc.php
• Fix tooltip display at bottom in School_Setup/Configuration.php
• Add AddonUpsellPremium() function in Addon.fnc.php
• JS If inside colorBox, close it on Cancel in Prompts.php
• Fix regression since 7.1 short month name, eg.: "Sep" in Date.php
• Warning instead of error for PHP extensions in diagnostic.php
• CSS Display tooltip at bottom, add .tooltip.bottom class in stylesheet.css & School_Setup/Configuration.php
• CSS improve styling of blockquote, datalist, fieldset, colorBox in stylesheet.css & colors.css
• CSS Upsell Premium, add .button-upsell-premium class in stylesheet.css & colors.css
• CSS Prevent body from scrolling when colorBox open in stylesheet.css
• CSS Hide File input "Browse" button in stylesheet.css
• JS Lazy loading for images inside inline colorBox in warehouse.js
• JS use MDConverter() instead of GetMDConverter() in warehouse.js
• JS fix maxHeight on resize patch in jquery.colorbox.js
• Add SECURITY.md file
• Update French & Spanish translations in rosariosis.po

Changes in 12.0.2

• Format Credit, display 0.33 instead of 0.333333333333333 in Transcripts.fnc.php
• PostgreSQL fix set_class_rank_mp() call in ClassRank.inc.php
• JS Fix regression since 11.4 allow HTML inside MarkDown in warehouse.js
• Convert back to MarkDown: use link in paragraph option in MarkDownHTML.fnc.php
• Revert open link in new tab, we don't want this in SanitizeMarkDown() in Parsedown.php
• Fix do not use URL in brackets when converting to MarkDown in Markdownify/Converter.php
• JS fix isMobileMenu() detection in warehouse.js

Changes in 12.0.1

• Fix no REMOVE column (add button) if no periods in the list in Periods.php
• Fix SQL error when no Periods, make Period select required in Courses.php
• Security fix #352 selected theme does not exist in Preferences.php, thanks to @rudranshsinghrajpurohit
• Security fix selected page size does not exist in Preferences.php
• Remove "-main" suffix from manually uploaded add-ons in Modules.inc.php & Plugins.inc.php
• Fix PHP error when Recreate Calendar & From or To date is N/A in Calendar.php
• Add checkout latest release tag to installation instrcutions in INSTALL.md, INSTALL_es.md & INSTALL_fr.md
• Fix PHP warning undefined array key "PROFILE_ID" in GetTeacher.fnc.php

Changes in 12.0

• SQL update User password for all school years in PasswordReset.php, Preferences.php & User.php
• SQL escape dynamic column names in GetStaffList.fnc.php & GetStuList.fnc.php
• Check $_REQUEST after modfunc in case it is empty (no form inputs have changed), program wide
• SQL Use DBInsert() function instead of DBInsertSQL() in AddActivity.php, Calendar.php, MarkingPeriods.php, MassAssignFees.php & MassAssignPayments.php
• Fix SQL syntax error at or near ")" when selected MP not in current School Year in PrintSchedules.php
• Unset $_REQUEST data (values, student, ...) array once modfunc done, program wide
• Remove "Grade Scale" column from the Grades list in ReportCardGrades.php
• HTML Omit value attribute when empty in Inputs.php
• ChosenSelectInput() use Select2Input() function & raise deprecation notice in Inputs.php
• JS Remove jQuery Chosen plugin in assets/js/jquery-chosen/
• GetInputID() remove non-alpha, non-digit characters (keep underscores) in Inputs.php
• Breaking change: GetInputID() dots . are now removed from ID in Inputs.php
• Breaking change: Update PHPMailer from v5.2.8 to v6.9.1 in classes/PHPMailer/ & SendEmail.fnc.php
• Breaking change: Remove SaveData() function in SaveData.fnc.php
• Preferences() remove deprecated 'MONTH', 'DAY' & 'YEAR' items in User.fnc.php
• Use DBUpdate() function in Accounts.php & MassDrops.php
• JS Show BottomButtonBack & update its URL & text: add BottomButtonBackUpdate() function in Bottom.fnc.php
• Remove need to make an AJAX call to Bottom.php in Bottom.php, Bottom.fnc.php, MyReport.php, ClassSearchWidget.fnc.php, Search.inc.php & Export.php
• Use colorBox instead of popup window (CSS use .colorbox class) in warehouse.js, Widget.php, Buttons.php, GetStuList.fnc.php, ListOutput.fnc.php, Courses.php, MassDrops.php, MassRequests.php, MassSchedule.php, Schedule.php, Scheduling/function.inc.php, Calendar.php, CalendarDay.inc.php, ChooseCourse.php & ChooseRequest.php
• JS Move form submit handler from ajaxPrepare() to onload in warehouse.js
• JS ajaxPostForm() deprecate submit param in warehouse.js & program wide
• Update jQuery from v2.2.4 to v3.7.1 in jquery.js & Warehouse.php
• Remove jQuery Form Plugin in jquery.form.js & Gruntfile.js
• Fix maintain Enrollment Date in Course Period link (Add a Course popup) in Courses.php
• JS fix form date & checkbox inside colorBox (Add a Course popup) in Courses.php
• JS Add target param to JSCalendarSetup() & MarkDownToHTML() functions in warehouse.js
• JS Use FormData instead of jQuery Form Plugin in warehouse.js
• JS Exclude file input with no files selected: disable before creating FormData in warehouse.js
• JS Remove empty GET params from URL (new method using regex) in warehouse.js
• CSS Add modname class to body, ie .modname-grades-reportcards-php for modname=Grades/ReportCards.php in warehouse.js
• JS Add inputAddHTML() function wrapper for addHTML() used by InputDivOnclick() in warehouse.js
• JS use inputAddHTML(): reduce HTML size by up to 26%; declare only 1 global var iHtml in Inputs.php
• JS rework ajaxPrepare() for colorBox & Make onclick div focusable when accessed by tab key in warehouse.js
• JS add getURLParam() function in warehouse.js
• JS AJAX update #body with URL GET params removed or replaced in warehouse.js & Side.php
• Add FileDelete() function in FileUpload.fnc.php
• Security: use FileDelete() instead of unlink(), program wide
• Students Search: remove unused code for $extra['array_function'] in Search.inc.php
• Add AddonUnzip() & AddOnZipCanUnzip() functions in Addon.fnc.php
• Add AddonInstallationStatisticsPost() function in Addon.fnc.php
• Post add-on installation (first activation) statistics in Modules.inc.php & Plugins.inc.php
• CalendarDayClassesDefault() Remove "inner" mode. Move .hover CSS class to table.calendar-day in Calendar.php & Calendar.inc.php
• CSS add .calendar-event-poptable, .calendar-minutes, .calendar-newevent classes in stylesheet.css, zresponsive.css & Calendar.php
• SVG menu icon (#BottomButtonMenu) in Bottom.php, colors.css & stylesheet.css
• CSS Add .uld class, alias of .underline-dots in colors.css, stylesheet.css & Inputs.php
• CSS add .poll-votes-outer class in zresponsive.css & PortalPolls.php
• CSS themes vertical alignment fixes for button, select2 & others in colors.css, rtl.css, stylesheet.css, zresponsive.css
• Breaking change: Rename CalendarDayNewAssignmentHTML() function to CalendarDayNewEventHTML() in Calendar.php & CalendarDay.inc.php
• Rename CalendarDayNewAssignmentHTMLDefault() function to CalendarDayNewEventHTMLDefault() in CalendarDay.inc.php
• Deprecate _getAttendanceDayRET() & _getAttendanceRET() functions in ReportCards.fnc.php
• Add & use _getDailyAbsencesMP() & _getOtherAttendanceMP() functions instead in ReportCards.fnc.php
• SQL rewrite "ORDER BY COL IS NOT NULL DESC" to its equivalent "ORDER BY COL IS NULL", program wide
• Close #348 Add School Year & Principal to Substitutions in Letters.php
• Give full responsibility to & improve AllowEdit() & AllowUse() in AllowEdit.fnc.php
• Add smart cache: up to 8ms faster in AllowEdit.fnc.php
• Rely solely on AllowUse() in Menu.php, Modules.php & Bottom.php
• Breaking change: Remove use of $_SESSION['_REQUEST_vars'] in Bottom.php, Modules.php, ErrorMessage.fnc.php & PreparePHP_SELF.fnc.php
• Only load module's Menu.php file in ProgramTitle.fnc.php
• No need to call RedirectURL() & unset $_REQUEST params as we die just after in ClassRank.inc.php & FinalGrades.inc.php
• Add Greek & Turkish translations (99% completed) in locale/el_GR.utf8, locale/tr_TR.utf8 & REFERENCE.md, thanks to Georgios Katakalos
• Deprecate isPopup() function & remove use in Warehouse() function in Warehouse.php
• Fix do not use ProgramTitle() (loads Menu.php in English only) in Help.php
• Update instructions, add pdo extension, remove deprecated config options in INSTALL.md, INSTALL_es.md & INSTALL_fr.md
• Deprecate Portal Notes Files upload path $PortalNotesFilesPath global var in PortalPollsNotes.fnc.php
• Use $FileUploadsPath . 'PortalNotes/' instead of $PortalNotesFilesPath in PortalNotes.php
• Remove Portal Notes Attached Files Folder in assets/PortalNotesFiles/
• Deprecate Assignments Files upload path $AssignmentsFilesPath global var in StudentAssignments.fnc.php
• Use $FileUploadsPath . 'Assignments/' instead of $AssignmentsFilesPath in StudentAssignments.fnc.php
• Remove Student Assignments Files Folder in assets/AssignmentsFiles/ & .gitignore
• Deprecate Food Service Icons upload path $FS_IconsPath global var in FS_Icons.inc.php
• Use $FileUploadsPath . 'FS_icons/' instead of $FS_IconsPath in MenuItems.php & FS_Icons.inc.php
• Move Food Service Icons from assets/FS_icons/ to assets/FileUploads/FS_icons/ in Update.fnc.php
• Remove assets/AssignmentsFiles/ if only contains README in Update.fnc.php
• Remove assets/PortalNotesFiles/ if only contains README in Update.fnc.php
• Remove Cookie vars from URL, may be included in $_REQUEST in PreparePHP_SELF.fnc.php
• Deprecate _ReindexResults() function in ListOutput.fnc.php
• Search List: Remove Relevance column, do not sort results in ListOutput.fnc.php
• Search List: Only return results matching (containing) all terms (AND) in ListOutput.fnc.php
• Fix "Create Student Account" URL, do not use RedirectURL() in index.php
• Add support, authors, suggest & extra in composer.json
• rename() Remove warning for directories across filesystems or devices. Workaround: exec mv (move on Windows) in Modules.inc.php & Plugins.inc.php
• Fix JS use inputAddHTML(): declare iHtml global var first in Inputs.php
• JS Fix ID collision when date inputs inside & outside target in warehouse.js

Changes in 11.8.6

• Fix Weight when "Group by Assignment Category" is checked in ProgressReports.php
• Automatic Class Rank calculation when automatically calculating final grades in FinalGrades.inc.php
• SQL INSERT INTO grades_completed so "These grades are complete." is displayed on the Input Final Grades program in FinalGrades.inc.php

Changes in 11.8.5

• Fix regression since 10.0 allow User Field type & category edit in Fields.fnc.php
• Fix #350 Final Grade calculation when both "Weight Assignments" & "Weight Assignment Categories" checked in Grades.php, FinalGrades.fnc.php & ProgressReports.php
• Fix Final Grade calculation when "Weight Assignments" checked & excused in Grades.php, FinalGrades.fnc.php
• Fix #351 Automatically calculate Final Grades on Assignment "Assigned"/"Due" date update in Assignments.php

Changes in 11.8.4

• CSS fix #349 set color for code select (was white on white background) in colors.css

Changes in 11.8.3

• Fix SQL error escape course title & save course, not course period title in FinalGrades.inc.php
• Fix performance: avoid silencing PHP error with @, use isset() instead in DBGet.fnc.php

Changes in 11.8.2

• CSS fix input div onclick & .underline-dots line height in stylesheet.css
• Fix .thu-fri-sat class for Calendar day on Public Pages in CalendarDay.inc.php
• Rollback Fix IE not propagating focus event to parent on click in Inputs.php

Changes in 11.8.1

• Fix IE not propagating focus event to parent on click in Inputs.php
• Fix regression since 8.6 add missing Request Widget to Advanced Student Search in Widgets.php
• HTML input set width to 100% in PasswordReset.php & Courses.php
• Use 'search' type for Search input in Courses.php
• Rollback JS set ghost div height to 4000px in jquery-fixedmenu.js
• Fix automatically calculate Final Grades for Progress Periods in FinalGrades.inc.php
• CSS fix Grade points line height in stylesheet.css
• Fix SQL error Cannot delete: foreign key constraint fails (marking_period_id + course_periods) in Rollover.php
• Remove Update default school year warning right after Rollover in Rollover.php
• Check user exists in the next school year in Rollover.fnc.php
• Rephrase the update school year warning & button in Rollover.fnc.php
• Add reset default school year note in Rollover.php
• Update French & Spanish translations in rosariosis.po

Changes in 11.8

• SQL performance: reduce staff table row size (was 3.8KB) & remove HOMEROOM column in Rollover.php, rosariosis.sql & rosariosis_mysql.sql
• Fix rare DB error "null value in column "last_name" violates not-null constraint" in Student.php & User.php
• Fix SQL error null value in column "student_id" violates not-null constraint in Requests.php
• HTML lower max Display Columns to 6 (was 10) in StudentFields.php & UserFields.php
• Check is admin before saving Template in ReportCards.php & Transcripts.php
• CSS remove forced large font size for Transcripts PDF in Transcripts.php
• Add & get PROFILE_ID column in GetTeacher.fnc.php & User.fnc.php
• Add "Course Periods - Short Name" field in Export.php
• Add Final Grades functions & AJAX modfunc in FinalGrades.inc.php
• Use FinalGradesQtrOrProCalculate() & FinalGradesSemOrFYCalculate() functions in InputFinalGrades.php
• Use FinalGradesAllMPSaveAJAX() function in Assignments.php, Grades.php & MassCreateAssignments.php
• Add "Automatically calculate and save Final Grades using Gradebook Grades" option in Configuration.php
• Add pagination for list > 1000 results in DailyTransactions.php
• Prevent hacking & fix SQL error: MPs & Students list must be a comma separated list of integers in ReportCards.fnc.php
• Fix authenticated SQL injection (administrator) via Grading Scales, escape string in InputFinalGrades.php
• Fix always get scale title for "Use the "%s" Grade Scale Comments" in InputFinalGrades.php
• Performance: avoid silencing PHP error with @, use isset() instead in DBGet.fnc.php
• Remove "Number of Days for the Rotation" option from School Information in Schools.php
• Use DBUpdate() function in Schools.php
• Move "Number of Days for the Rotation" option to School Configuration in Configuration.php
• Add help text for "Number of Days for the Rotation" option in Help_en.php
• Translate help text for "Number of Days for the Rotation" option to Spanish & French in help.po
• JS set ghost div height to 4000px in jquery-fixedmenu.js
• JS add navigator.browser property & add .browser-[name] CSS class to html in warehouse.js & plugins.min.js
• CSS various vertical alignment & height adjustments for both themes in colors.css, stylesheet.css & zresponsive.css
• CSS fix JSCalendar z-index when inside colorBox + fix checkbox label height in calendar-blue.css & stylesheet.css

Changes in 11.7.4

• Fix regression since 11.7 no results if more than 1000 fees but 0 payments for timeframe in DailyTransactions.php
• Fix result count < results (wrong SQL query to COUNT total results) in ListOutput.fnc.php
• Fix regression since 11.7 wrong pagination info when in combination with SQLLimitForList() in ListOutput.fnc.php

Changes in 11.7.3

• Fix regression since 11.7.1 typo generating SQL error in CreateParents.php

Changes in 11.7.2

• Fix Security issue #345 SQL injection in RemoveAccess.php, thanks to @fishinspace
• Fix Security issue #346 SQL injection in AttendanceSummary.php & Configuration.php, thanks to @fishinspace
• Fix Security issue #347 SQL injection in index.php & Configuration.php, thanks to @fishinspace
• Fix potential authenticated SQL injection (administrator), cast to float in Reminders.php
• Fix authenticated SQL injection (administrator) via Configuration, escape string in RegistrationSave.fnc.php
• Fix SQL error when Search All Schools in GetTeacher.fnc.php

Changes in 11.7.1

• Fix Security issue #344 SQL injection in CreateParents.php, thanks to @fishinspace

Changes in 11.7

• Fix SQL error invalid input syntax for type integer: cast to integer, program wide
• MySQL mode: disable ONLY_FULL_GROUP_BY in Warehouse.php
• Performance: Run all SQL SET (NAMES, SQL_MODE, DATESTYLE, TIMEZONE) queries at once in Warehouse.php
• HTML add label to Class Search widget in ClassSearchWidget.fnc.php & Widget.php
• Add SQLLimitForList() function in database.in.php & ListOutput.fnc.php
• Use SQLLimitForList() function in GetStuList.fnc.php, GetStaffList.fnc.php, ReportCardGrades.php & AccessLog.php
• Add 'LIMIT' to $extra param (default to 1000) in GetStuList.fnc.php & GetStaffList.fnc.php
• Add 'GROUP' to $extra param in GetStaffList.fnc.php
• CSS FlatSIS theme: add box-shadow to colorBox in colors.css, stylesheet.css & zresponsive.css
• Allow display of $link['add'] (or remove) on PDF or if not allowed to edit in ListOutput.fnc.php
• Force display of $link['add'] on PDF or if not allowed to edit in DailyTransactions.php, Percent.php, InputFinalGrades.php & ProgressReports.php
• Remove useless center option in ListOutput() & program wide
• Fix SQL when "Search All Schools" checked in GetTeacher.fnc.php
• Add _makeHonorRollGPAMinInputs() function, group Honor Roll GPA Min inputs in same column in ReportCardGrades.php
• Add "No Grades found for Percent" error in InputFinalGrades.php
• Add RolloverDeleteCoursesSQL(), RolloverDoWarning(), RolloverUpdateDefaultSyearWarning() & RolloverUpdateDefaultSyear() functions in Rollover.fnc.php
• Use RolloverDeleteCoursesSQL(), RolloverDoWarning(), RolloverUpdateDefaultSyearWarning() & RolloverUpdateDefaultSyear() functions in Rollover.php & Portal.php
• Add & use RolloverAllSchoolsDoneWarning() function in Rollover.fnc.php & Rollover.php
• Update Slovenian translation (76% complete), thanks to AT group in locale/sl_SI.utf8/
• Update French & Spanish translations in rosariosis.po
• CSS adjust vertical alignment of buttons inside note/error message in stylesheet.css
• Update default school year to 2024 in config.inc.sample.php, rosariosis.sql & rosariosis_mysql.sql

Changes in 11.6

• JS FixedMenu Round menu height as 100vh is sometimes not exactly equal to window height in jquery-fixedmenu.js
• SubstitutionsInput() use Select2Input if more than 30 substitution codes in Substitutions.fnc.php
• CSS add .valign-middle class in stylesheet.css
• Use .valign-middle class for tables in Address.inc.php, Exceptions.php & Profiles.php
• CSS increase input horizontal padding in stylesheet.css
• CSS Vertical align button inside first td, use when row has input (list with fields) in stylesheet.css
• CSS WPadmin theme use OpenSans Semibold font instead of OpenSans Bold in font.css
• Add vertically align list data option (defaults to false) in ListOutput.fnc.php
• Use vertically align list data option 'valign-middle', program wide
• CSS add .has-input class to list having input (input or select fields) in ListOutput.fnc.php
• CSS add .list-save class to Export list link in ListOutput.fnc.php
• CSS add .list-add-row class (see $link['add'] parameter) in ListOutput.fnc.php
• HTML add data-list-id attribute to list in ListOutput.fnc.php
• Sort list numerically or as strings case-insensitively in ListOutput.fnc.php
• Sort list using cell's HTML if no inner text in ListOutput.fnc.php
• ExplodeDate() use strtotime() in Date.php
• Remove MonthNWSwitch(), __mnwswitch_num2char() & __mnwswitch_char2num() functions in Date.php
• Send wkhtmltopdf error by email in PDF.php
• Log error if not sending email ($RosarioErrorsAddress not set) in ErrorMessage.fnc.php
• Remove $link['add']['html']['remove'] = button( 'add' ); (button added by default), program wide
• HTML add #BottomButtonBack id in Bottom.php
• Fix check no assignment_id requested before deleting assignment type in Assignments.php
• Fix PHP notice undefined array key "TITLE" on Assignment update in plugins/Moodle/Grades/Assignments.php
• Add MailingLabelPositioned() function in MailingLabel.fnc.php
• CSS add .mailing-label-left, .mailing-label-right & .mailing-label-top-margin classes in stylesheet.css
• CSS Adjust Mailing Labels top margin for Report Cards in wkhtmltopdf.css
• Use MailingLabelPositioned() function in ReportCards.fnc.php, ProgressReports.php, PrintRequests.php, PrintSchedules.php, Statements.php, Letters.php & PrintStudentInfo.php
• Add Mailing Label Position option (left or right) in User.fnc.php & Preferences.php
• CSS fix Select2 min-width when hidden in stylesheet.css
• Update French & Spanish translations in rosariosis.po
• CSS responsive tables: Prevent overscroll/bounce in iOS 16+ MobileSafari and Chrome in zresponsive.css
• CSS select: Normalize color on iOS 15+ in colors.css
• MariaDB $DatabaseDumpPath allow 'mariadb-dump' binary in diagnostic.php & config.inc.sample.php

Changes in 11.5.3

• Fix MySQL 5.7.5+ error due to ONLY_FULL_GROUP_BY mode: use MIN() in Address.inc.php

Changes in 11.5.2

• Fix get Student Info when Parent associated to various students in ReportCards.fnc.php

Changes in 11.5.1

• Fix PHP warning undefined array key "" when $days_array is empty in PrintSchedules.php & Schedule.inc.php
• Fix Calculate GPA for all Marking Periods when Year not checked in Transcripts.fnc.php
• Fix HTML display Transcript footer when Credits unchecked in Transcripts.fnc.php
• Format Credit Earned, display 0.33 instead of 0.333333333333333 in Transcripts.fnc.php
• Fix PHP8.3 fatal error Duplicate declaration of static variable in classes/Markdownify/Converter.php

Changes in 11.5

• Moodle plugin: Add REST API protocol in plugins/Moodle/, rosariosis.sql & rosariosis_mysql.sql
• Add MoodleAPICall() & MoodleRESTCall() functions in plugins/Moodle/client.php
• Remove check for xmlrpc extension in diagnostic.php
• Send Course description HTML to Moodle in plugins/Moodle/Scheduling/Courses.php
• Copy $_REQUEST to $_SESSION['_REQUEST_vars'] last in Modules.php, ErrorMessage.fnc.php & PreparePHP_SELF.fnc.php
• No error message if error code 4 (no file was attached) in FileUpload.fnc.php
• DBInsertSQL() & DBUpdateSQL() better check empty values ('', false, null) in DBUpsert.php
• Breaking change: Use $_ROSARIO global var instead of $_SESSION in School.php
• Slovenian translation (71% complete), thanks to AT group in locale/sl_SI.utf8/ & locale/REFERENCE.md
• Use DBUpdate() & DBInsert() functions in ReportCardGrades.php, Student.php & User.php
• Fix PHP Fatal error maximum execution time of 120 seconds exceeded in InstallDatabase.php
• Update French & Spanish translations in rosariosis.po
• MakeChooseCheckbox() Add 'required' option to $value param. Prevent submitting form if no checkboxes are checked in Inputs.php
• Use MakeChooseCheckbox()'s new 'required' option, program wide
• Fix RedirectURL() when GET params also contained in POST form in PreparePHP_SELF.fnc.php
• JS Compatibility with Use FormData instead of jQuery Form Plugin in FirstLogin.fnc.php
• Add "Final Grading Percentages are not configured." warning in InputFinalGrades.php
• Add ProperTime() function in Date.php
• License change from GNU/GPLv2 to GNU/GPLv2 or later so it is compatible with GNU/GPLv3 in COPYRIGHT, composer.json & package.json
• Unescape DB strings ($_REQUEST only, $_GET is not escaped) in PreparePHP_SELF.fnc.php
• Use DBUpsert() function & simplify logic in SaveEnrollment.fnc.php
• SQL exclude current record when checking dates for existing enrollment in SaveEnrollment.fnc.php
• SQL include records without dropped dates when checking for existing enrollment in SaveEnrollment.fnc.php
• Deprecate SaveData() function in SaveData.fnc.php
• Add Hide Headers option in Letters.php
• Show date inputs even if admin profile cannot edit in AccessLog.php
• CSS FlatSIS theme fix left menu logo below top menu bar when fixed in stylesheet.css

Changes in 11.4.4

• Fix SQL transcript_grades view for History Marking Periods of existing school years in rosariosis.sql, rosariosis_mysql.sql & Update.fnc.php
• Fix regression since 11.4 check MP exists before trying to get GPA: include History Marking Periods in Grades.fnc.php
• Fix PHP Fatal error call to undefined function pg_fetch_array() in database.inc.php & AccessLog.php

Changes in 11.4.3

• Fix SQL update gradebook_assignment_types only for old teacher's assignments in Courses.fnc.php
• Fix SQL Get all assignment types having assignments for this course period in GradebookBreakdown.php, Assignments.php, Grades.php & Courses.fnc.php
• Fix only requested modname logic in AccessLog.php

Changes in 11.4.2

• Course Teacher change: Update teacher's assignments in Courses.fnc.php

Changes in 11.4.1

• Fix SQL error invalid input syntax for type integer: "" in Courses.php
• InputDivOnclick() Do not not convert single quotes to gain a few bytes in Inputs.php
• Add functions/PDF.php|pdf_stop_html & functions/PDF.php|pdf_stop_pdf action hooks in Actions.php & PDF.php
• Fix PHP warning use reset() instead of guessing if $errors[1] is set in ErrorMessage.fnc.php & diagnostic.php
• Add arguments to Action tags PHPDoc in Actions.php
• Add Students/Letters.php|header action hook in Actions.php & Letters.php
• Add Grades/HonorRoll.php|header action hook in Actions.php & HonorRoll.php
• Add ProgramFunctions/Template.fnc.php|before_get & ProgramFunctions/Template.fnc.php|before_save action hooks in Actions.php & Template.fnc.php

Changes in 11.4

• Add XRedirectUrl JS global var for soft redirection when not an AJAX request in PreparePHP_SELF.fnc.php & warehouse.js
• JS Fix double HTML character encoding, use jQuery text instead of jQuery html in warehouse.js
• PostgreSQL fix limit set_updated_at_triggers() to current schema in rosariosis.sql
• SQL add Comment to every grade of the Main scale in rosariosis.sql & rosariosis_mysql.sql
• Add Chrome OS to GetUserAgentOS() in UserAgent.fnc.php
• Add 'SELECT_ONLY' to $extra param in GetStaffList.fnc.php
• SQL performance: limit main query to teacher profile in GetTeacher.fnc.php
• Smart cache: do not get ALL users database twice if Teacher not found in GetTeacher.fnc.php
• 'ParseMLField' can be used as a DBGet() callback function to parse column in ParseML.php
• Breaking change: remove use of 'next_modname' request param in Search.fnc.php, Search.inc.php & various programs
• Remove use of $_SESSION['_REQUEST_vars'] in MyReport.php, Schedule.php, ClassSearchWidget.fnc.php, Calendar.php, CopySchool.php, Search.inc.php & Export.php
• Simplify use of $_SESSION['Back_PHP_SELF'] in MyReport.php, ClassSearchWidget.fnc.php, Search.inc.php & Export.php
• Do NOT rely on SubmitButton() name param, use modfunc instead in DailyMenus.php, EditReportCardGrades.php, StudentAssignments.php, Calendar.php & Schools.php
• Fix isPopup() for Calendar Events new modfunc detail_save & detail_delete in Warehouse.js
• Use 'delete_ok' URL param instead of submit button name in Prompts.php
• DeletePrompt() Go back in browser history on Cancel (unless $remove_modfunc_on_cancel = false) in Prompts.php
• Rename student checkbox from 'student' to 'st' to gain space in URL in MassDrops.php
• User is not logged in, redirect to login screen in Help.php
• Fix SQL error when USERNAME length > 100 in index.php
• Automatically clear Access Log entries older than one year in AccessLog.php
• Only list events for selected month by default in Calendar.php
• Use DBUpsert() in Comments.inc.php
• Set Moodle course end date (enddate parameter) in plugins/Moodle/Scheduling/Course.php
• PHP error reporting: use php.ini configuration if debug mode not set in Warehouse.php
• Add --single-transaction flag to mysqldump so database remains in a consistent state throughout the backup in DatabaseBackup.php
• Reassign Course Subject (unless Moodle plugin is active) in Courses.php & Courses.fnc.php
• GetGpaOrTotalRow() Deprecate $courses_number param in Grades.fnc.php, ReportCards.fnc.php & Transcripts.fnc.php
• GetGpaOrTotalRow() Fix check MP exists before trying to get GPA in Grades.fnc.php
• Add Group courses by subject (only for Report Cards) in ReportCards.fnc.php
• Add "Use Grade Scale Comments" option in InputFinalGrades.php
• Update French & Spanish translations in rosariosis.po
• Remove Social Security field from Substitutions, already added by SubstitutionsCustomFields() in Transcripts.fnc.php
• Fix SQL error Field 'gp_passing_value' doesn't have a default value in ReportCardGrades.php
• Make functions: simplify setting $id var, program wide
• Prepare jQuery Form to FormData transition: check for $_FILES[ $input ]['name'] in FileUpload.fnc.php, Accounting/functions.inc.php, Assignments.php, PortalNotes.php, Student_Billing/functions.inc.php, Student.php & User.php
• Attach multiple files in StudentAssignments.fnc.php
• Fix file upload for new Contact/Address in Student.php & Address.inc.php
• Add "Student Info tab fields after" action hook: Add your own fields in Actions.php & Other_Info.inc.php
• Add "User Info tab fields after" action hook: Add your own fields in Actions.php & Other_Info.inc.php
• Fix NoInput() display '-' when $value is false in Inputs.php
• Add "Report a bug" link to Resources in rosariosis.sql, rosariosis_mysql.sql, rosariosis_es.sql & rosariosis_fr.sql
• Fix SQL error Data too long for column 'title' in Menus.php
• Remove trailing '-main' from add-on directory in Modules.inc.php & Plugins.inc.php
• Add "Filter Grade Level" action hook in Actions.php & GetGrade.fnc.php
• Replace _makeReadMe, _makeActivated & _delTree functions with AddonMakeReadMe, AddonMakeActivated & AddonDelTree in Addon.fnc.php, Modules.inc.php & Plugins.inc.php

Changes in 11.3.3

• Fix PHP 8.1 fatal error: array_key_exists() arg 2 ($array) must be of type array in ListOutput.fnc.php

Changes in 11.3.2

• Fix PHP fatal error checkdate(): arg must be of type int, string given in Date.php
• Fix SQL error when amount has exponent, ie "10e-2" in Expenses.php, Incomes.php, Salaries.php, StaffPayments.php, MassAssignFees.php, MassAssignPayments.php, StudentFees.php & StudentPayments.php
• Set "Parent" as default Profile option (least compromising option) in Users/includes/General_Info.inc.php
• Simplify code for requested 'type' & remove use of $_SESSION['_REQUEST_vars'] in Accounts.php, ActivityReport.php, BalanceReport.php, Reminders.php, ServeMenus.php, Statements.php & Transactions.php
• Fix maintain current student ID when multiple tabs are open in Eligibility/Student.php, Accounts.php, ServeMenus.php, Transactions.php, Student_Billing/functions.inc.php, StudentFees.php & StudentPayments.php
• Fix maintain current user ID when multiple tabs are open in Accounting/functions.inc.php, Salaries.php, StaffPayments.php, Transactions.php, Accounts.php, ServeMenus.php & Exceptions.php

Changes in 11.3.1

• HTML use number input for "Base Grading Scale" in Schools.php
• Always add raw Datetime inside HTML comment in Date.php
• JS fix for IE 11 remove function param default value in jquery-passwordstrength.js & warehouse.js
• Fix regression since 4.7 SQL set_class_rank_mp() Class Rank calculation when various school years in rosariosis.sql, rosariosis_mysql.sql & Update.fnc.php

Changes in 11.3

• Immunization or Physical (select): No N/A value for existing entries in StudentsUsersInfo.fnc.php
• Nurse Visit (date): No N/A value for existing entries in StudentsUsersInfo.fnc.php
• Medical Alert: Required TITLE value for existing entries in StudentsUsersInfo.fnc.php
• SQL add NOT NULL for student_medical type, student_medical_alerts title & student_medical_visits school_date columns in rosariosis.sql & rosariosis_mysql.sql
• Replace ExcelXML class with SimpleXLSXGen in classes/ExcelXML.php & classes/SimpleXLSXGen/
• Export list to Excel using SimpleXLSXGen (more reliable) in ListOutput.fnc.php
• Fix list sort, search, page, save when multiple lists on same page in ListOutput.fnc.php
• Remove null values from URL in PreparePHP_SELF.fnc.php
• We are inside a sentence, convert nouns to lowercase (except for German) in ListOutput.fnc.php & Prompts.php
• No "Default for Teacher" checkbox if Type is "Office Only" in AttendanceCodes.php
• Fix incoherence with AllowEdit() when category_id present or not in URL in Student.php & User.php
• Refuse to enroll student twice in the same course period in Schedule.php & MassSchedule.php
• Update French & Spanish translations in rosariosis.po & help.po
• Add Percent grade inside HTML comment so we can accurately sort by Grade column in InputFinalGrades.php
• No new days inputs if Edit not allowed in DailyMenus.php
• Allow non admin users & students to Generate Menu (no AllowEdit() required) in DailyMenus.php
• Simplify logic to save Menu ID to session in Kiosk.php & MenuReports.php
• Fail if Marking Periods are not in current School Year in FinalGrades.php & ReportCards.fnc.php
• Fix "Daily Absences" / "Other Attendance" strings in ReportCards.fnc.php
• Moodle plugin: only roll Users & Courses once in Rollover.php & plugins/Moodle/README.md
• Contact not found, remove person_id & redirect URL in Address.inc.php
• Rename $grades_RET[$i] var to $grade_i inside foreach loop in ReportCards.fnc.php
• MySQL dump: export procedures, functions and triggers in DatabaseBackup.php
• Rename _makeCheckBoxInput() to _makeCheckboxInput() & CheckBoxInput() to CheckboxInput() in AttendanceCodes.php, EditReportCardGrades.php & EnrollmentCodes.php
• CSS responsive fix Stackable tables: columns always align left in zresponsive.css
• Update Installation Directions for Ubuntu 22.04 in INSTALL.md, INSTALL_es.md & INSTALL_fr.md
• Move MySQL step which accidentally was under PostgreSQL instructions in INSTALL_fr.md & INSTALL_fr.pdf
• SQL do not round GPA average in Grades/includes/Dashboard.inc.php
• CSS add .rseparator class responsive separator: hide text separator & break line in zresponsive.css & InputFinalGrades.php
• CSS add .addon-readme class Add-on module/plugin README inside colorBox in stylesheet.css
• Use DBUpsert() & check for required columns on INSERT in Medical.inc.php
• Fix use DBUnescapeString() to unescape string for both PostgreSQL & MySQL in Config.fnc.php
• Fix sorting list when first value is null in ListOutput.fnc.php
• JS fix rt2colorBox children height calculation in warehouse.js
• CSS fix tooltip text wrapping inside responsive list in stylesheet.css
• JS Do NOT scroll to top onload in warehouse.js
• To disable responsive list layout, add &LO_disable_responsive=Y to the URL in ListOutput.fnc.php

Changes in 11.2.4

• Fix DisplayName() for "Last Name First Name" & "Last Name, First Name" options in GetStuList.fnc.php
• Fix Mailing Label skip if No Contact tied to address in MailingLabel.fnc.php
• MySQL 8+ fix infinite loop due to cached AUTO_INCREMENT in database.inc.php

Changes in 11.2.3

• Security fix #341 update phpwkhtmltopdf, php-shellcommand & php-tmpfile in classes/phpwkhtmltopdf
• Fix PHP warnings, force search_modfunc to list in Bottom.php
• Move Updates for version 6, 8 and 9 in UpdateV6_8_9.fnc.php
• Fix HasFirstLoginForm() when admin did not complete steps on first login in FirstLogin.fnc.php
• SQL fix duplicate key value violates unique constraint "attendance_completed_pkey" in Courses.fnc.php
• Use return instead of exit. Allows Warehouse( 'footer' ) to run in TakeAttendance.php & Grades/Configuration.php
• Fix column name is empty, use Period Title if no Short Name in StudentSummary.php

Changes in 11.2.2

• Hide list count in ReportCards.fnc.php, Transcripts.fnc.php & Preferences.php
• Security: SQL prevent INSERT or UPDATE on any table in MassCreateAssignments.php, SchoolFields.php, AddressFields.php, PeopleFields.php, StudentFields.php & UserFields.php
• Adapt missing config table SQL error for MySQL in diagnostic.php
• Fix PHP warnings when course_period_id GET param does not exist in Courses.php
• Fix SQL error foreign keys: force roll Schools in Rollover.php

Changes in 11.2.1

• ProgramUserConfig(): SQL can use negative $staff_id for Students in Config.fnc.php
• Excel & CSV: replace line breaks (br) with "\n" instead of space in ListOutput.fnc.php
• Only show header if more than 1 school in Users/includes/Schedule.inc.php
• Remove start & end date params from GET form URL in Expenses.php, Incomes.php & StudentSummary.php
• Fix SQL syntax error at or near "ND" in DeleteTransactionItem.fnc.php
• SQL add FOREIGN KEY to transaction_id column in rosariosis.sql & rosariosis_mysql.sql
• SQL Add MENU_ITEM_ID column to food_service_transaction_items & food_service_staff_transaction_items tables in Update.fnc.php, rosariosis.sql & rosariosis_mysql.sql
• Fix regression since 11.2 SQL error duplicate key value violates unique constraint in ServeMenus.php
• FS transaction menu item ID references food_service_menu_items(menu_item_id) in ServeMenus.php

Changes in 11.2

• Add $add_post argument, POST parameters to add to the URL (optional) in Prepare_PHP_SELF.fnc.php
• Fix Apache 414 Request-URI Too Long, move st from $_REQUEST to $_SESSION in FinalGrades.php
• Add $_POST elements, ytd_tardies_code, mp_tardies_code & mp_arr to URL in FinalGrades.php
• CSS WPadmin theme remove bold from MD preview tabs in stylesheet.css
• SQL Add CREATED_BY column to billing_fees & billing_payments tables in Update.fnc.php, rosariosis.sql & rosariosis_mysql.sql
• Expanded View: Add Created by & Created at columns in MassAssignFees.php, MassAssignPayments.php, StudentFees.php, StudentPayments.php & DailyTransactions.php
• Do NOT create Assignment Type if already exists for Course & Teacher in MassCreateAssignments.php
• Add RosarioURL() function in Prepare_PHP_SELF.fnc.php
• Use RosarioURL() instead of local function in PasswordReset.php, MarkDownHTML.fnc.php & SendNotification.fnc.php
• Security remove $wkhtmltopdfAssetsPath & --enable-local-file-access, use base URL instead in INSTALL.md, INSTALL_es.md, INSTALL_fr.md & PDF.php
• HTML increase Username input size (suitable for email address) in General_Info.inc.php
• Fix Attendance State Code: rename "Half Day" to "Half" in AttendanceCodes.php, AttendanceCodes.fnc.php & AttendanceSummary.php
• CSS themes adjust tooltip height to fit inside PopTable in stylesheet.css & zresponsive.css
• Fix SQL error when school has no MPs in Rollover.php
• HTML add arrow to indicate sub-option in Configuration.php
• Rename "Registration" fieldset to "Public Registration" in Configuration.php
• Add AttendanceDailyTotalMinutesSQL() & AttendanceDailyTotalMinutesPresent() functions in UpdateAttendanceDaily.fnc.php
• Breaking Change: use AttendanceDailyTotalMinutesPresent() instead of AttendanceDailyTotalMinutes() in UpdateAttendanceDaily.fnc.php
• Add Action hook, filter Total Minutes Present in UpdateAttendanceDaily.fnc.php & Actions.php
• Dynamic Daily Attendance calculation based on total course period minutes in UpdateAttendanceDaily.fnc.php, AttendanceSummary.php & Configuration.php
• Add help text for Dynamic Daily Attendance calculation in Help_en.php
• SQL new default is 0 for ATTENDANCE_FULL_DAY_MINUTES Config option in rosariosis.sql & rosariosis_mysql.sql
• MarkDown: remove two spaces before line break in Markdownify/Converter.php
• Only allow column names of string type (not empty) in DBUpsert.php
• Fix SQL error when $columns is false in DBUpsert.php
• Update French & Spanish translations in rosariosis.po & help.po
• CSS themes apply list margin/padding outside widefat tables + fix .size-1 in stylesheet.css
• HTML Fix Menu description overflow hidden + allow MarkDown in DailyMenus.php
• Add Action hook Filter each menu item in the loop in Kiosk.php & Actions.php
• FS transaction item ID references food_service_menu_items(menu_item_id) in ServeMenus.php, rosariosis.sql & rosariosis_mysql.sql
• CSS WPadmin theme style fieldset legend like FlatSIS theme in stylesheet.css
• Fix Select Multiple from Options answer count when none selected in PortalPollsNotes.fnc.php
• Fix regression since 11.0 Reporter not saved when logged in as a Teacher in MakeReferral.php
• Fix SQL error when no MP array is empty in Grades.fnc.php
• Add Student Account fields table after action hook in Actions.php & Food_Service/Students/Accounts.php
• Add Food Service tab fields table after action hook in Actions.php & Food_Service/Student.inc.php

Changes in 11.1.2

• Maintain list preferences as GET params in form URL (save) in Schedule.php
• Use basename() to extract file name from path in StudentsUsersInfo.fnc.php, Accounting/functions.inc.php, StudentAssignments.fnc.php & Student_Billing/functions.inc.php
• Fix PHP warning undefined array index in RegistrationAdmin.fnc.php
• CSS WPadmin theme style button text like FlatSIS theme in stylesheet.css

Changes in 11.1.1

• Fix PostgreSQL error column "ac" of relation "attendance_completed" does not exist in Courses.fnc.php

Changes in 11.1

• Fix SQL error when no MPs in calcSeats0.fnc.php
• Choose Checkbox uncheck by default to prevent accidental creations in MassCreateAssignments.php
• HTML display Courses list next to Assignment Types list in MassCreateAssignments.php
• Set email for default admin user so he can reset his password in InstallDatabase.php
• Prevent using App name, username, or email in the password in PasswordReset.php, FirstLogin.fnc.php, Inputs.php & Preferences.php
• JS Add userInputs param to prevent using App name, username, or email in the password in jquery-passwordstrength.js
• Return EMAIL column for students too (empty if "Student email field" not set) in User.fnc.php
• Fix SQL error if delete Student email field, reset in StudentFields.php
• Add SideMarkingPeriodSelect() function in Side.php
• SQL Use GetFullYearMP() & GetChildrenMP() functions to limit Marking Periods in Grades/Configuration.php, ReportCards.fnc.php, Courses.php, MassDrops.php, MassSchedule.php & PrintSchedules.php
• Allow override GetFullYearMP(), GetAllMP(), GetParentMP(), GetChildrenMP() & GetCurrentMP() functions in GetMP.php
• SQL set min Credits to 0 & fix division by zero error in Courses.fnc.php, rosariosis.sql & rosariosis_mysql.sql
• SQL Update to version 11.1 in Update.fnc.php
• Add timestamp (including microseconds) to filename to make it harder to predict in FileUpload.fnc.php, Accounting/functions.inc.php, StudentAssignments.fnc.php, PortalNotes.php, Student_Billing/functions.inc.php
• Copy $DefaultSyear global var to session (once) to prevent errors when edited in Warehouse.php & Config.fnc.php
• Add "Probably a module. Move it to the modules/ folder." error in Plugins.inc.php
• Make Course Periods number link in Periods.php
• Move _updateSchedulesCPMP() to includes/Courses.fnc.php & rename CoursePeriodUpdateMP() in Courses.php & Courses.fnc.php
• Automatically update teacher: attendance_completed + grades_completed in Courses.php & Courses.fnc.php
• Automatically update credits (attempted and earned); will also recalculate GPA in Courses.php & Courses.fnc.php
• Update French & Spanish translations in rosariosis.po
• Update Recommended PHP configuration in INSTALL.md, INSTALL_es.md & INSTALL_fr.md
• CSS WPadmin: remove opensans EOT font files in font.css & themes/WPadmin/fonts/opensans/*.eot
• CSS themes: reduce list margin & padding when inside .widefat table in stylesheet.css
• CSS themes: force .tooltip styles when inside .widefat table head in stylesheet.css
• Fix SQL error null value in column "student_id" in Eligibility/Student.php
• Fix SQL error Unknown column 'a.ADDRESS' in 'where clause' in Percent.php
• CSS Fix PDF Frame background when multiple pages in HonorRoll.fnc.php
• Fix SQL error invalid input syntax for type integer: "" in Registration.fnc.php & RegistrationSave.fnc.php

Changes in 11.0.2

• Fix SQL error escape Menu title in MenuReports.php & TakeMenuCounts.php
• MySQL fix specify COUNT column name in MenuReports.php
• Remove "-master" suffix from manually uploaded add-ons in Modules.inc.php & Plugins.inc.php
• Fix SQL error, Check if Account ID already exists in Student.php & Food_Service/Students/Accounts.php

Changes in 11.0.1

• Fix PHP deprecated passing null to parameter #1 ($datetime) of type string in Warehouse.php
• MySQL fix infinite loop, emulate PostgreSQL's nextval() in database.inc.php
• Fix Apache 414 Request-URI Too Long, use POST method instead of GET in Administration.php
• Fix display result count when no singular/plural set in ListOutput.fnc.php
• Fix SQL drop order by School Period, allow Course Periods with no Periods in ReportCards.fnc.php

Changes in 11.0

• Add Weight Assignments option in Grades/Configuration.php, Assignments.php & MassCreateAssignments.php
• Add Weight field in Assignments.php & MassCreateAssignments.php
• Calculate Weighted Grade in Grades.php, InputFinalGrades.php & ProgressReports.php
• Add Assignment Weight in StudentGrades.php & StudentAssignments.fnc.php
• Translate "Zip" & "Zipcode" to "Zip Code" in GetStuList.fnc.php, MyReport.php, Registration.fnc.php, Schools.php & Address.inc.php
• HTML Text input min size is 2 in Inputs.php
• Skip School Period column if has no students scheduled for selected date in Administration.php
• Add microseconds to filename format to make it harder to predict in FileUpload.fnc.php, Accounting/functions.php, PortalNotes.php & Student_Billing/functions.php
• Remove UserCoursePeriodSchoolPeriod() & UserPeriod() functions in Current.php
• SQL access_log: deprecate LOGIN_TIME column, use CREATED_AT instead in index.php, AccessLog.php, Dashboard.inc.php, rosariosis.sql & rosariosis_mysql.sql
• SQL portal_notes & portal_polls: deprecate PUBLISHED_DATE column, use CREATED_AT instead in PortalNotes.php, PortalPolls.php, Portal.php, rosariosis.sql & rosariosis_mysql.sql
• Truncate column title to 36 chars if > 36 chars in MyReport.php & Grades.php
• Handle Points decimal with comma instead of point, ie "10,5" in Grades.php
• Increase default Password Strength from 1 to 2 in rosariosis.sql & rosariosis_mysql.sql
• PostgreSQL rename "rank" to "class_rank" in set_class_rank_mp() for consistency with MySQL in rosariosis.sql
• HTML put "" around the link href if no spaces in $link & no other attributes in Buttons.php & program wide
• HTML5 CSS use details + summary instead of .toggle hack in index.php, stylesheet.css & colors.css
• SQL add TITLE column in GetTeacher.fnc.php
• Cache Class average percent in Grades.fnc.php
• Add GetClassRank() function (for Course Period) in Grades.fnc.php
• Add Class Average & Class Rank (Course Period) in ReportCards.fnc.php
• Move "Progress Reports" from Teacher Programs to Grades menu (admin) in Grades/Menu.php, ProgressReports.php, rosariosis.sql & rosariosis_mysql.sql
• CSS FlatSIS enlarge left menu width by 6px for German in stylesheet.css
• SQL add ORDER BY to GetChildrenMP() in GetMP.php
• SQL select Grading Scales by Teacher, only the ones having student grades in GradeBreakdown.php
• Add Insert into or Update DB functions in DBUpsert.php
• Use DBUpsert() function in Template.fnc.php, Config.fnc.php & StudentAssignments.fnc.php
• Use DBInsertSQL() function in AddActivity.php, Scheduler.php, Calendar.php, MarkingPeriods.php, MassAssignFees.php & MassAssignPayments.php
• Use DBUpdateSQL() function in MarkingPeriods.php
• Use DBUpdate() & DBInsert() functions, program wide
• Create missing Food Service Student Account in Accounts.php
• Fix SQL display Students with no Food Service account in the list in Accounts.php
• Fix PHP warning if Food Service Student Account missing in Student.inc.php, Accounts.php, ServeMenus.php, Statements.php & Transactions.php
• Let user edit inputs on Food Service User Account creation in Accounts.php
• Fix Contact file path (delete) in Student.php
• Upload Address & Contact files in RegistrationSave.fnc.php
• Security: use URLEscape() for PHP redirection in index.php & Portal.php
• Use $_REQUEST['search_terms'] to allow GET param in URL in Courses.php
• Move from serialize() to json_encode() in StudentAssignments.fnc.php & Comments.inc.php
• SQL calculate Class Rank for Progress Periods in ReportCards.php
• SQL Fix replacement in case the "username" contains the prefix in Removeaccess.php, thanks to @0xD0M1M0
• SQL add accounting_categories table in rosariosis.sql & rosariosis_mysql.sql
• Add Categories program to Accounting module in Categories.php, Menu.php, rosariosis.sql & rosariosis_mysql.sql
• Add _makePaymentsCategory() & _makeIncomesCategory() functions in Accounting/functions.inc.php
• Reuse _makeIncomesTextInput() function in _makePaymentsTextInput() in Accounting/functions.inc.php
• Use button only for File Attached input & download in Accounting/functions.inc.php & Student_Billing/functions.inc.php
• Add Timeframe start / end date filters in Expenses.php & Incomes.php
• Add Category column in Expenses.php & Incomes.php
• Add Title column in Expenses.php
• Fix display Go button for all users (no AllowEdit() required) in DailyTotals.php & DailyTransactions.php
• Add Category filter in DailyTransactions.php
• SQL Update v11.0: Move "Progress Reports" from Teacher Programs to Grades menu (admin) in Update.fnc.php
• SQL Update v11.0: Add accounting_categories table in Update.fnc.php
• SQL Update v11.0: Add TITLE column to accounting_payments table in Update.fnc.php
• SQL Update v11.0: Add CATEGORY_ID column to accounting_incomes & accounting_payments tables in Update.fnc.php
• SQL Update v11.0: Give admin profile access to Accounting > Categories program in Update.fnc.php
• Add & translate help texts for Weight Assignments option in Help_en.php, help.pot & help.po
• Translate Weight Assignments option to French & Spanish in rosariosis.pot & rosariosis.po
• CSS Add .rbr class, responsive <br> does not break line, use inside responsive table in zresponsive.css, DisciplineForm.php & Student_Billing/functions.inc.php
• Enable Test Mode by default in case of accidental run in Scheduler.php
• Fix PHP fatal error if openssl PHP extension is missing in Warehouse.php, index.php, Student.php & User.php
• MySQL fix not single MP check in MarkingPeriods.php
• Fix exception strtotime() returns false for year >= 2038 (PHP 32-bit) in Date.php

Old versions CHANGES

• CHANGES for versions 9 and 10.
• CHANGES for versions 7 and 8.
• CHANGES for versions 5 and 6.
• CHANGES for versions 3 and 4.
• CHANGES for versions 1 and 2.