OpenClinic / News: Recent posts

Changes over previous version (0.8), are these:

• New italian translation thanks to Francesco Assisi
• Fixed deletion of staff (second surname issue)
• Fixed installation wizard problems in Chrome browsers

Also, source code repository has been published on GitHub.

Although more versions have not been published since the end of 2004, OpenClinic development has not been standing all this time. The application has been completely rewritten and has a new graphical look. Changes in MySQL (the default storage is InnoDB now), have led me to publish a new version.

More important changes since 0.7 version (for more details see Changelog):

• Code compatibility with PHP5 (incompatible with PHP4) and MySQL 5.5
• The storage engine used in MySQL is MyISAM although the default is InnoDB
• Removed all CSS themes and only includes one by default (new page structure)
• Reorganization of directories and files in the project (very extensive and deep..., the code does not look anything like the previous version)
• CSRF and Session Fixation Protection
• Unobtrusive JavaScript in all pages
• Changed the structure of XML database dumps (based on Propel)
• The second surname is not required to fill in forms

OpenClinic 0.7 Released!

Changes since 0.6

• Improvements in accessibility to open new windows
• Suppression of javascript protocol in href attributes
• New file lib/misc_lib.php: new global constant OPEN_FIELD_PREVIEW_LIMIT
• Addition of bread crumb in all pages than need it
• DTD XHTML 1.1 in all project pages
• Fixed logout link in timeout session
• If items per page equal to zero, searchs return all results without pagination
• Better i18n of dates
• Fixed problem with NULL closing_date in medical problems
• Fixed XSS attacks with JavaScript event handlers in input fields and GET and POST vars
• New option CREATE DATABASE dbname in MySQL dumps and table summary
• Fixed MSIE bugs relationship with table less design
• All application constants have OPEN_ or DLIB_ prefix to avoid interferences with PHP constants
• Redirections to avoid reload problem in insertions, updates or deletions processes
• Fixed problems with dumps as files (urldecode of data is unnecessary)
• Custom error handler for log to screen or/and to a file (new constants in read_settings.php file: OPEN_SCREEN_ERRORS, OPEN_LOG_ERRORS, OPEN_LOG_FILE)
• Record log process improvements: now is saved entire record data
• CSS2 table less based themes
• Changes in current user are made immediately
• New constant OPEN_BUFFER in read_settings.php file to use ob_*() functions (but by default, value is false) (experimental support)
• Field collegiate_number has been replaced with id_member in patient_tbl and problem_tbl tables. Field id_member has been added in deleted_patient_tbl, deleted_problem_tbl tables too. After upgrade OpenClinic from 0.6 version is recommended check all patients and problems information (doctor you are assigned to, doctor who treated you)... read more

OpenClinic 0.6 Released!

Changes since 0.5

• Added new themes to the project: LibXML, SerialZ, Closer, GG Interactive
• Added exec() method to Query class (this implicates changes in all *_Query.php files)
• classes/Install_Query.php file (Install_Query class) has been removed from project (this implicates changes in parse_sql_file.php and install.php files)
• Changed passwords coded method in MySQL fields (it is MD5 now)
• $HTTP_VARS now are $ superglobals arrays
• Now current password is needed to change the password
• Added new options in dumps: DELETE * FROM table, USE dbname
• Added new files to the project: lib/lang_lib.php, lib/nls.php
• Translation method has been changed. Now it is made with GNU gettext and PO (and binary MO) files (classes/Localize.php file has been deleted from project)
• Now OpenClinic installation is also translated (to the browser language if it is available)
• Added showInputButton(), showInputFile(), showRadioButton() functions in lib/input_lib.php file
• Created a directory to store medical problem tests
• It is possible making a remote installation of a SQL file
• OpenClinic CSS changed. New design does not use tables for layout purposes. Layout is made with div and span tags. It looks fine in last generation browsers
• All visible pages have a title page
• Various database fields have changed: subjetive -> subjective (problem_tbl, deleted_problem_tbl), objetive -> objective (problem_tbl, deleted_problem_tbl), wife_childs_status_health -> spouse_childs_status_health (deleted_patient_tbl, history_tbl), sur_name1 -> surname1 (staff_tbl, patient_tbl, deleted_patient_tbl), sur_name2 -> surname2 (staff_tbl, patient_tbl, deleted_patient_tbl)
• In login_form.php direct connections, it redirects to home/index.php now... read more

Changes since 0.4

• Added install/wizard.php file to the project
• Added css/wizard.css file to the project
• Added DLIB_MYSQL_VERSION constant to the admin/dump_defines.php file
• Added new themes to the project: Thai Appserv, OpenClinic Wizard, Izhal, Invision
• Tables array is now in parse_sql_file.php file
• The file openclinic/index.php has been modified (checks if database connection is good)
• Error in new user process (classes/User.php file, $value => $pwd)
• The files openclinic/medical/test_new.php and openclinic/medical/test_new_form.php have been modified
• Error in new/edit medical test process (in Opera and Mozilla browsers)
• Error in patient deletion process (medical problems)
• The file openclinic/medical/problem_search.php has been modified (more secure)
• Error in restore backup process when there is a semicolon in data (parse_sql_file.php)
• The file openclinic/scripts/.htaccess has been removed
• Doctor can not edit or delete medical tests of a medical problem
• OpenClinic Logos changed thanks to Coresis (project OpenGraphics)
• Added scripts/wizard.js file to the project
• Added nl2br() function to medical/*_view.php files... read more

To resolve this, just do it the following:
1.- Edit openclinic/classes/User.php file
2.- Search "function setPwd($pwd)"
3.- Change $pwd argument to $value
4.- Search "function setPwd2($pwd)"
5.- Change $pwd argument to $value
6.- Save the changes and fixed

Thanks to Ramiro Vergara for reporting this bug.
jact

Changes since 0.3:

• Added bulgarian language (pazoff)
• Added showNavLinks() function (navigation_links.php file)
• Improvements in search engine (patient_fields.php, patient_search.php, Patient_Query.php)
• Added getCurrentRow, getRowCount, getPageCount, search methods to Problem_Query class
• Added problem_search.php, problem_search_fields.php files to the project
• Added freeResult method to DbConnection and Query classes
• Fixed print_medical_record.php errors ($staff)
• Fixed problem_view.php errors ($staff, new != reset)
• Fixed patient_view.php errors ($staff)
• Added numRows method to Query class
• Fixed problem_new.php and problem_edit.php errors (key=)
• Fixed connection_new.php errors (key=)
• Added visited_list.php file to the project
• Added new themes to the project: XP Style (jact), Autumn Violets (pazoff)
• New patient list (3 last visited patients) in normal version
• More visual improvements (CSS and images)
• Fixed more XHTML 1.0 errors (nested lists)
• Fixed stranger characters introduction in login_form.php (urlencode in login.php)
• Added validator_lib.php file to the project
• Added fetchAll method to DbConnection class
• Added fetchRow and fetchAll methods to Query class (changes in all *_Query.php files)
• New feature in Admin tab: Log Statistics
• Added fetchAccess and select methods to Access_Query class
• Added fetchRecord and select methods to Record_Query class
• Added log_stats.php, log_access_list.php and log_record_list.php files to the project
• Added htmlspecialchars(), intval() functions to classes files
• Use of showInputHidden() function in the web forms
• Added showCheckBox() function (input_lib.php file)
• Checking of magic_quotes_gpc in setter methods
• Added emulation of transactions in critical operations (ignore_user_abort function)
• Added coding_guidelines.html file to the project... read more

Thanks to pazoff, we can enjoy OpenClinic 0.3 in bulgarian language. You can download this extension in http://sourceforge.net/projects/showfiles.php?group_id=70742

Now, PHP >= 4.2 is necessary to run OpenClinic. It is due to session variable changes in PHP 4.2. The application has been tested with versions 4.2.1, 4.2.2 and 4.2.3.