Index: unix_installer/upgrader-package/readme =================================================================== RCS file: /usr/local/cvsroot/unix_installer/upgrader-package/readme,v diff -u -r1.7 -r1.7.2.1 Binary files differ Index: unix_installer/upgrader-package/update-lams.sh =================================================================== RCS file: /usr/local/cvsroot/unix_installer/upgrader-package/update-lams.sh,v diff -u -r1.8 -r1.8.2.1 Binary files differ Index: unix_installer/upgrader-package/ant-scripts/update-core-database.xml =================================================================== RCS file: /usr/local/cvsroot/unix_installer/upgrader-package/ant-scripts/update-core-database.xml,v diff -u -r1.4 -r1.4.2.1 --- unix_installer/upgrader-package/ant-scripts/update-core-database.xml 13 Jun 2008 07:11:08 -0000 1.4 +++ unix_installer/upgrader-package/ant-scripts/update-core-database.xml 15 Jul 2008 05:37:34 -0000 1.4.2.1 @@ -14,6 +14,7 @@ encoding="utf8" onerror="abort" > + Fisheye: Tag 1.1 refers to a dead (removed) revision in file `unix_installer/upgrader-package/sql-scripts/removeLDAPConfigsRows.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: unix_installer/upgrader-package/tools/lamc11/build/deploy/lams-tool-lamc11.jar =================================================================== RCS file: /usr/local/cvsroot/unix_installer/upgrader-package/tools/lamc11/build/deploy/Attic/lams-tool-lamc11.jar,v diff -u -r1.2 -r1.2.2.1 Binary files differ Index: unix_installer/upgrader-package/tools/lamc11/build/deploy/lams-tool-lamc11.war =================================================================== RCS file: /usr/local/cvsroot/unix_installer/upgrader-package/tools/lamc11/build/deploy/Attic/lams-tool-lamc11.war,v diff -u -r1.2 -r1.2.2.1 Binary files differ Index: unix_installer/upgrader-package/tools/lamc11/build/deploy/language/ApplicationResources_el_GR.properties =================================================================== RCS file: /usr/local/cvsroot/unix_installer/upgrader-package/tools/lamc11/build/deploy/language/Attic/ApplicationResources_el_GR.properties,v diff -u -r1.2 -r1.2.2.1 --- unix_installer/upgrader-package/tools/lamc11/build/deploy/language/ApplicationResources_el_GR.properties 18 Jun 2008 05:51:04 -0000 1.2 +++ unix_installer/upgrader-package/tools/lamc11/build/deploy/language/ApplicationResources_el_GR.properties 15 Jul 2008 05:37:30 -0000 1.2.2.1 @@ -2,7 +2,7 @@ #language code: el #locale code: GR - # CVS ID: $Id$ Exported from the LAMS Community by Ernie Ghiglione on Mon Jun 16 07:09:53 BST 2008 + # CVS ID: $Id$ Exported from the LAMS Community by Ernie Ghiglione on Thu Jun 19 00:14:57 BST 2008 #=================== labels for Multiple Choice Questions =================# @@ -75,9 +75,13 @@ label.cancel =\u0391\u03ba\u03cd\u03c1\u03c9\u03c3\u03b7 feedback =\u03c0\u03b1\u03c1\u03b1\u03ba\u03b1\u03bb\u03ce \u03b5\u03bd\u03c4\u03bf\u03c0\u03af\u03c3\u03c4\u03b5 \u03c4\u03b1 \u03b1\u03ba\u03cc\u03bb\u03bf\u03c5\u03b8\u03b1 \u03c0\u03c1\u03b9\u03bd \u03c4\u03b7\u03bd \u03c5\u03c0\u03bf\u03b2\u03bf\u03bb\u03ae error.weights.notInteger =\u03a0\u03b1\u03c1\u03b1\u03ba\u03b1\u03bb\u03ce \u03b4\u03b9\u03bf\u03c1\u03b8\u03ce\u03c3\u03c4\u03b5 \u03c4\u03bf \u03b5\u03be\u03ae\u03c2: \u03a4\u03bf \u03b2\u03ac\u03c1\u03bf\u03c2 \u03b5\u03c1\u03ce\u03c4\u03b7\u03c3\u03b7\u03c2 \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03b5\u03af\u03bd\u03b1\u03b9 \u03b1\u03ba\u03ad\u03c1\u03b1\u03b9\u03bf\u03c2 +label.exportPortfolio.simple =\u0395\u03be\u03b1\u03b3\u03c9\u03b3\u03ae \u03c6\u03b1\u03ba\u03ad\u03bb\u03bf\u03c5 \u03b5\u03c1\u03b3\u03b1\u03c3\u03b9\u03ce\u03bd output.desc.learner.all.correct.true =\u038c\u03bb\u03b1 \u03a3\u03c9\u03c3\u03c4\u03ac +label.export.learner =\u0395\u03be\u03b1\u03b3\u03c9\u03b3\u03ae \u03c6\u03b1\u03ba\u03ad\u03bb\u03bf\u03c5 \u03b5\u03c1\u03b3\u03b1\u03c3\u03b9\u03ce\u03bd \u03b3\u03b9\u03b1 \u03c4\u03bf\u03bd \u03bc\u03b1\u03b8\u03b7\u03c4\u03b5\u03c5\u03cc\u03bc\u03b5\u03bd\u03bf +label.export.teacher =\u0395\u03be\u03b1\u03b3\u03c9\u03b3\u03ae \u03c6\u03b1\u03ba\u03ad\u03bb\u03bf\u03c5 \u03b5\u03c1\u03b3\u03b1\u03c3\u03b9\u03ce\u03bd \u03b3\u03b9\u03b1 \u03c4\u03bf\u03bd \u03ba\u03b1\u03b8\u03b7\u03b3\u03b7\u03c4\u03ae-\u03c3\u03cd\u03bc\u03b2\u03bf\u03c5\u03bb\u03bf label.authoring.mc.basic =\u03a0\u03b1\u03c1\u03b1\u03ba\u03b1\u03bb\u03ce \u03bf\u03c1\u03af\u03c3\u03c4\u03b5 \u03c4\u03b9\u03c2 \u03b5\u03c1\u03c9\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2. error.singleOption =\u03a0\u03b1\u03c1\u03b1\u03ba\u03b1\u03bb\u03ce \u03b4\u03b9\u03bf\u03c1\u03b8\u03ce\u03c3\u03c4\u03b5 \u03c4\u03bf \u03b5\u03be\u03ae\u03c2: \u03a0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03c5\u03c0\u03ac\u03c1\u03c7\u03bf\u03c5\u03bd \u03c4\u03bf\u03c5\u03bb\u03ac\u03c7\u03b9\u03c3\u03c4\u03bf\u03bd 2 \u03b5\u03c1\u03c9\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 +label.exportPortfolio =\u0395\u03be\u03b1\u03b3\u03c9\u03b3\u03ae \u03c6\u03b1\u03ba\u03ad\u03bb\u03bf\u03c5 \u03b5\u03c1\u03b3\u03b1\u03c3\u03b9\u03ce\u03bd \u0395\u03a0\u0395 output.desc.learner.all.correct.false =\u038c\u03c7\u03b9 \u038c\u03bb\u03b1 \u03a3\u03c9\u03c3\u03c4\u03ac label.onlineInstructions =\u039f\u03b4\u03b7\u03b3\u03af\u03b5\u03c2 \u03ba\u03b1\u03c4\u03ac \u03c4\u03b7 \u03c3\u03cd\u03bd\u03b4\u03b5\u03c3\u03b7 \u03c3\u03c4\u03bf \u03b4\u03b9\u03b1\u03b4\u03af\u03ba\u03c4\u03c5\u03bf group.label =\u039f\u03bc\u03ac\u03b4\u03b1 @@ -219,10 +223,7 @@ message.no.reflection.available =\u039c\u03b7 \u03b4\u03b9\u03b1\u03b8\u03ad\u03c3\u03b9\u03bc\u03bf \u03c3\u03b7\u03bc\u03b5\u03b9\u03c9\u03bc\u03b1\u03c4\u03ac\u03c1\u03b9\u03bf button.advanced =\u03a0\u03c1\u03bf\u03c7\u03c9\u03c1\u03b7\u03bc\u03ad\u03bd\u03b1 label.tip.removeQuestion =\u0391\u03c0\u03bf\u03bc\u03b1\u03ba\u03c1\u03cd\u03bd\u03b5\u03b9 \u03c4\u03b7\u03bd \u03b5\u03c1\u03ce\u03c4\u03b7\u03c3\u03b7 -label.export.learner =\u0395\u03be\u03b1\u03b3\u03c9\u03b3\u03ae \u03c6\u03b1\u03ba\u03ad\u03bb\u03bf\u03c5 \u03b5\u03c1\u03b3\u03b1\u03c3\u03b9\u03ce\u03bd \u03b3\u03b9\u03b1 \u03c4\u03bf\u03bd \u03bc\u03b1\u03b8\u03b7\u03c4\u03b5\u03c5\u03cc\u03bc\u03b5\u03bd\u03bf -label.update.list =\u0395\u03bd\u03b7\u03bc\u03ad\u03c1\u03c9\u03c3\u03b7 \u03ba\u03b1\u03c4\u03b1\u03bb\u03cc\u03b3\u03bf\u03c5 label.learning.attemptTime =\u0397\u03bc\u03b5\u03c1\u03bf\u03bc\u03b7\u03bd\u03af\u03b1/ \u038f\u03c1\u03b1 \u03c0\u03c1\u03bf\u03c3\u03c0\u03ac\u03b8\u03b5\u03b9\u03b1\u03c2 -label.export.teacher =\u0395\u03be\u03b1\u03b3\u03c9\u03b3\u03ae \u03c6\u03b1\u03ba\u03ad\u03bb\u03bf\u03c5 \u03b5\u03c1\u03b3\u03b1\u03c3\u03b9\u03ce\u03bd \u03b3\u03b9\u03b1 \u03c4\u03bf\u03bd \u03ba\u03b1\u03b8\u03b7\u03b3\u03b7\u03c4\u03ae-\u03c3\u03cd\u03bc\u03b2\u03bf\u03c5\u03bb\u03bf label.learner.bestMark =O \u03ba\u03b1\u03bb\u03cd\u03c4\u03b5\u03c1\u03bf\u03c2 \u03b2\u03b1\u03b8\u03bc\u03cc\u03c2 \u03c0\u03bf\u03c5 \u03ad\u03c7\u03b5\u03c4\u03b5 \u03c9\u03c2 \u03c4\u03ce\u03c1\u03b1 \u03b5\u03af\u03bd\u03b1\u03b9 label.attemptTime =\u0397\u03bc\u03b5\u03c1\u03bf\u03bc\u03b7\u03bd\u03af\u03b1/ \u038f\u03c1\u03b1 \u03c0\u03c1\u03bf\u03c3\u03c0\u03ac\u03b8\u03b5\u03b9\u03b1\u03c2 error.questions.withNoOptions =\u03a0\u03b1\u03c1\u03b1\u03ba\u03b1\u03bb\u03ce \u03c3\u03b7\u03bc\u03b5\u03b9\u03ce\u03c3\u03c4\u03b5: \u039f\u03b9 \u03b5\u03c1\u03c9\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c7\u03c9\u03c1\u03af\u03c2 \u03c4\u03b9\u03c2 \u03c5\u03c0\u03bf\u03c8\u03ae\u03c6\u03b9\u03b5\u03c2 \u03b1\u03c0\u03b1\u03bd\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03ad\u03c7\u03bf\u03c5\u03bd \u03b1\u03c6\u03b1\u03b9\u03c1\u03b5\u03b8\u03b5\u03af \u03b1\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b1 \u03b3\u03b9\u03b1 \u03c3\u03b1\u03c2. \u03a0\u03b1\u03c1\u03b1\u03ba\u03b1\u03bb\u03ce \u03b5\u03bb\u03ad\u03b3\u03be\u03c4\u03b5 \u03c4\u03bf \u03c3\u03c5\u03bd\u03bf\u03bb\u03b9\u03ba\u03cc \u03b2\u03ac\u03c1\u03bf\u03c2 \u03b5\u03c1\u03ce\u03c4\u03b7\u03c3\u03b7\u03c2. @@ -244,8 +245,7 @@ question.duplicate =\u03a0\u03b1\u03c1\u03b1\u03ba\u03b1\u03bb\u03ce \u03c0\u03c1\u03bf\u03c3\u03ad\u03be\u03c4\u03b5: \u03a4 label.tip.editQuestion =\u0395\u03bd\u03b5\u03c1\u03b3\u03bf\u03c0\u03bf\u03b9\u03b5\u03af \u03c4\u03b7\u03bd \u03b5\u03c0\u03b5\u03be\u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03c4\u03b7\u03c2 \u03b5\u03c1\u03ce\u03c4\u03b7\u03c3\u03b7\u03c2 label.tip.editCandidate =\u0395\u03bd\u03b5\u03c1\u03b3\u03bf\u03c0\u03bf\u03b5\u03af \u03c4\u03b7\u03bd \u03b5\u03c0\u03b5\u03be\u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03c4\u03c9\u03bd \u03c5\u03c0\u03bf\u03c8\u03b7\u03c6\u03af\u03c9\u03bd \u03b1\u03c0\u03b1\u03bd\u03c4\u03ae\u03c3\u03b5\u03c9\u03bd -label.exportPortfolio.simple =\u0395\u03be\u03b1\u03b3\u03c9\u03b3\u03ae \u03c6\u03b1\u03ba\u03ad\u03bb\u03bf\u03c5 \u03b5\u03c1\u03b3\u03b1\u03c3\u03b9\u03ce\u03bd -label.exportPortfolio =\u0395\u03be\u03b1\u03b3\u03c9\u03b3\u03ae \u03c6\u03b1\u03ba\u03ad\u03bb\u03bf\u03c5 \u03b5\u03c1\u03b3\u03b1\u03c3\u03b9\u03ce\u03bd \u0395\u03a0\u0395 +label.update.list =\u0395\u03bd\u03b7\u03bc\u03ad\u03c1\u03c9\u03c3\u03b7 \u039b\u03af\u03c3\u03c4\u03b1\u03c2 button.monitoring.noDisplayAnswers =\u039d\u03b1\u03af label.view.answers =\u03a0\u03c1\u03bf\u03b2\u03bf\u03bb\u03ae \u0391\u03c0\u03b1\u03bd\u03c4\u03ae\u03c3\u03b5\u03c9\u03bd label.view =\u03a0\u03c1\u03bf\u03b2\u03bf\u03bb\u03ae Index: unix_installer/upgrader-package/tools/lamc11/build/deploy/sql/updatescripts/updateTo20070820.sql =================================================================== RCS file: /usr/local/cvsroot/unix_installer/upgrader-package/tools/lamc11/build/deploy/sql/updatescripts/Attic/updateTo20070820.sql,v diff -u -r1.1 -r1.1.2.1 --- unix_installer/upgrader-package/tools/lamc11/build/deploy/sql/updatescripts/updateTo20070820.sql 18 Jun 2008 05:51:12 -0000 1.1 +++ unix_installer/upgrader-package/tools/lamc11/build/deploy/sql/updatescripts/updateTo20070820.sql 15 Jul 2008 05:37:34 -0000 1.1.2.1 @@ -1,25 +1,3 @@ --- Update the Multiple Choice tables from version 20070214 to 20070820 --- This is for the LAMS 2.0.1 release. - -ALTER TABLE tl_lamc11_que_usr ADD COLUMN last_attempt_order INTEGER, ADD COLUMN last_attempt_total_mark INTEGER; - -ALTER TABLE tl_lamc11_content ADD COLUMN displayAnswers TINYINT(1) NOT NULL DEFAULT 1 AFTER randomize; - --- Fix problems with the marks in the attempt table. It was recording the number of questions answered correctly for the activity. --- Now it records the mark for each question. The overall mark is put in the que_usr table. -update tl_lamc11_usr_attempt a set a.mark = (select c.mark from tl_lamc11_que_content c where c.uid = a.mc_que_content_id) where a.isAttemptCorrect = 1; - -update tl_lamc11_usr_attempt a set a.mark = 0 where a.isAttemptCorrect = 0; - --- Now that the individual marks are right, we can recalculate the overall mark for an attempt. We need to find just the --- final attempt for each user. At present, there can only be one option selected for a question, so we don't --- need to worry about repeated data. -update tl_lamc11_que_usr qu1 set qu1.last_attempt_order = ( select max(attemptOrder) from tl_lamc11_usr_attempt att where att.que_usr_id = qu1.uid ); - -update tl_lamc11_que_usr qu1 set qu1.last_attempt_total_mark = ( select sum(mark) from tl_lamc11_usr_attempt att where att.que_usr_id = qu1.uid and att.attemptOrder = qu1.last_attempt_order); - +-- Modified version of the mcq update script for servers that already have the +-- mcq performance fix applied. update lams_tool set supports_outputs = 1 where tool_signature = "lamc11"; - --- update the tool version - special code that should only be executed if the upgrade is being done manually. --- if it is being done via the tool deployer then it will update the version automatically. --- update lams_tool set tool_version = "20070820" where tool_signature = "lamc11"; \ No newline at end of file