Git commits in Moodle 1.7.0 by stronk7

commit ef02670d0941b72ab5323a2b2745b0f8a63e9d33
Author: stronk7 <stronk7>
Date:   Tue, 07 Nov 2006 01:43:28 +0800
Tag:    v1.7.0

Simple bump

commit 7764e1afe0a00a28a0bdf47976e63f476135c73c
Author: stronk7 <stronk7>
Date:   Tue, 07 Nov 2006 01:20:11 +0800
Tag:    v1.7.0

And, finally, IE is able to display IMS packages properly! cool One of the worst to solve bugs in my life! MDL-6417

commit 7ca5f47dcb22dbd6dd137222894a99ef7bc218fb
Author: stronk7 <stronk7>
Date:   Sun, 05 Nov 2006 17:44:05 +0800
Tag:    v1.7.0

modify_database() will show the deprecated debugging after 2006101007 (Moodle 1.7 release version) MDL-5919

commit b215544c31adc124277787bc12fe356a455e1d1b
Author: stronk7 <stronk7>
Date:   Sun, 05 Nov 2006 07:28:51 +0800
Tag:    v1.7.0

Now GD is checked before displaying course overview graphs. MDL-7204

commit 1ede3a671279e38b71e23e5667dd7526645f9e46
Author: stronk7 <stronk7>
Date:   Sun, 05 Nov 2006 00:59:52 +0800
Tag:    v1.7.0

Now all the get_records() functions support only one field to be specified in the SELECT clause. Not needed anymore to write double "SELECT id, id..." queries. Results returned follow exactly the same structure than normal recordsets (first field = key) MDL-5877

commit 8558e34ed507f301af571a24a2fbcf9b3cead5d2
Author: stronk7 <stronk7>
Date:   Sun, 05 Nov 2006 00:21:30 +0800
Tag:    v1.7.0

Deprecating modify_database(). It shows debugging info if release > 2006101004 (Beta2 +01) MDL-5919

commit 98ed0ea1af59cbed29d940da823bc6fe8ba61271
Author: stronk7 <stronk7>
Date:   Fri, 03 Nov 2006 07:07:44 +0800
Tag:    v1.7.0

Ending fied/key/index PHP generators.

commit 6abfa47012d8aa94e8e4e1201a2fb57825b6d403
Author: stronk7 <stronk7>
Date:   Fri, 03 Nov 2006 06:43:16 +0800
Tag:    v1.7.0

Enablig rename_table() PHP generator

commit 4241549aed6ff6f9aae1ac7800c38e96f58264e5
Author: stronk7 <stronk7>
Date:   Wed, 01 Nov 2006 19:51:13 +0800
Tag:    v1.7.0

in/on/at too many ways to say "en" in Spanish. tongueout

commit d416d809a1ee7329a1361de3e301ba3fa6775a12
Author: stronk7 <stronk7>
Date:   Wed, 01 Nov 2006 04:33:25 +0800
Tag:    v1.7.0

Prevent +/- operators (REGEXP) on glossary searches for MSSQL and Oracle. MDL-7312

commit 9338d432f981c2068522986d1c7e8efce76f8623
Author: stronk7 <stronk7>
Date:   Wed, 01 Nov 2006 04:21:13 +0800
Tag:    v1.7.0

Prevent +/- operators (REGEXP) on messages search. MDL-7312

commit b2ef8fc07e97b94d7f40937151ad63811be2d691
Author: stronk7 <stronk7>
Date:   Wed, 01 Nov 2006 04:15:23 +0800
Tag:    v1.7.0

transform TOKEN searches into STRING searches and trim +- chars. MDL-7312

commit 53ff8d79ee186499853e849363b71b7f79b86ff7
Author: stronk7 <stronk7>
Date:   Wed, 01 Nov 2006 03:53:25 +0800
Tag:    v1.7.0

Prevent +/- operators (REGEXP) on course searches for MSSQL and Oracle. MDL-7312

commit 5cc8148eb8ecf36dc4632ce667499322916b548e
Author: stronk7 <stronk7>
Date:   Wed, 01 Nov 2006 03:15:30 +0800
Tag:    v1.7.0

Fixed searches, list of results and simplified SQL logic. All those while trying to fix one LCASE() use. MDL-7310

commit ec27637e082566802a5e74a8d035ef62c91a8da6
Author: stronk7 <stronk7>
Date:   Wed, 01 Nov 2006 01:47:52 +0800
Tag:    v1.7.0

Now wiki supports Unicode searches

commit 088f9942ef5535efea51e9866d57378cebc0dca8
Author: stronk7 <stronk7>
Date:   Tue, 31 Oct 2006 07:12:41 +0800
Tag:    v1.7.0

Oracle optimization. Texts under 4000cc can be handled directly as varchar2, so they don't need the 2-phase (insert/update) handling of LOBs

commit 6befbe805001358de3bb6595ed5e57ebe9856149
Author: stronk7 <stronk7>
Date:   Tue, 31 Oct 2006 06:58:04 +0800
Tag:    v1.7.0

Fixed one bug on Oracle produced when we were inserting records with returnid disabled and containing LOBs

commit f5303bd518ff973f4def55462b11ec934fda6767
Author: stronk7 <stronk7>
Date:   Tue, 31 Oct 2006 03:51:44 +0800
Tag:    v1.7.0

Prevent Oracle to fail when inserting records with log->info empty (will be solved once we got all those NOT NULL fields fixed)

commit d040f940a2b490ed7d106f009adc263644916713
Author: stronk7 <stronk7>
Date:   Tue, 31 Oct 2006 03:31:33 +0800
Tag:    v1.7.0

Fixing display of pivots when they are author names

commit c97ab4b00ae8e6a46063def4646a3a513a653a18
Author: stronk7 <stronk7>
Date:   Tue, 31 Oct 2006 03:01:02 +0800
Tag:    v1.7.0

Fixing some queries with duplicate column names. MDL-7294

commit 5e8720e3a349cf7f6b35b500b134cfe33198c89e
Author: stronk7 <stronk7>
Date:   Tue, 31 Oct 2006 02:33:04 +0800
Tag:    v1.7.0

Now glossary is using the proper sql_substr() function

commit 3cef39f10a567163d6d1671b247cf1df8aa4b46c
Author: stronk7 <stronk7>
Date:   Tue, 31 Oct 2006 02:28:47 +0800
Tag:    v1.7.0

New function sql_substr() returns the proper substr() function for each DB

commit 0e938d8e6c8d90e7c37a0f53018a629398f56cab
Author: stronk7 <stronk7>
Date:   Tue, 31 Oct 2006 01:58:56 +0800
Tag:    v1.7.0

Now lcase() and ucase() are out from glossary

commit 6a9781ab1f4372cfb21fe172ef063010e9279e9b
Author: stronk7 <stronk7>
Date:   Tue, 31 Oct 2006 01:43:40 +0800
Tag:    v1.7.0

sql_as() is deprecated. Column aliases ALWAYS must use the AS keyword.

commit 18ecdd56aa8bd278b89c05cf3a802368cb03bc4f
Author: stronk7 <stronk7>
Date:   Tue, 31 Oct 2006 01:39:55 +0800
Tag:    v1.7.0

Deprecating sql_as (now the AS keyword os required in COLUMN aliases)

commit f9452850dd86224ded1c7b58cebc394b25d56f96
Author: stronk7 <stronk7>
Date:   Tue, 31 Oct 2006 00:51:34 +0800
Tag:    v1.7.0

Updating wood to show the nav-bar properly.

commit 8319d93b4558b55e13e6e9701d89374c9c1c1aa5
Author: stronk7 <stronk7>
Date:   Mon, 30 Oct 2006 23:55:48 +0800
Tag:    v1.7.0

Added enablerecordcache setting to control the get_record() cache. Note that some parts of Moodle can enable/disable it selectively.

commit 41a96d7c4df8119db56147e12ef484fbacfc02b6
Author: stronk7 <stronk7>
Date:   Mon, 30 Oct 2006 23:52:04 +0800
Tag:    v1.7.0

Added some strings for the enablerecordcache setting.

commit e8e5f866570dc88bf3ceac0f45166a2acc85032d
Author: stronk7 <stronk7>
Date:   Sun, 29 Oct 2006 07:11:57 +0800
Tag:    v1.7.0

Adding PIVOT as MSSQL reserved word

commit be310ffda835ca52315d448f52e95e5999c3a17d
Author: stronk7 <stronk7>
Date:   Sun, 29 Oct 2006 03:51:57 +0800
Tag:    v1.7.0

Now record_cache is controlled by $CFG->enablerecordcache

commit cacc23f04162171bed1e66b4b77a9276c2062f58
Author: stronk7 <stronk7>
Date:   Sun, 29 Oct 2006 01:51:43 +0800
Tag:    v1.7.0

Moved cache cleaning code near the begin of functions. Sometimes it wasnt' executed due to function ending. MDL-7196

commit 72a4c9a290341aa9165f5bfbf37267dce173cca4
Author: stronk7 <stronk7>
Date:   Sat, 28 Oct 2006 19:02:09 +0800
Tag:    v1.7.0

Updating backup release to 1.7 final (to avoid forgetting it)

commit 5d68b50a62426529bf17e29fef3aed289edf6546
Author: stronk7 <stronk7>
Date:   Sat, 28 Oct 2006 18:36:04 +0800
Tag:    v1.7.0

Improve error output of install_from_xmldb_file(). Part of MDL-7262

commit df313f0e9402952dfc5da78d90cf1395e0a6daec
Author: stronk7 <stronk7>
Date:   Sat, 28 Oct 2006 01:48:41 +0800
Tag:    v1.7.0

Counting extra updates performed by Oracle & MSSQL in PERF

commit 9717970b605c7b3ad75fcacfe22d0a3a085af785
Author: stronk7 <stronk7>
Date:   Sat, 28 Oct 2006 01:13:36 +0800
Tag:    v1.7.0

I forgot to globalize $record_cache in delete_record_XXX() functions.

commit 4f2ae57c31b9e6df29727e6ad282698c074a963a
Author: stronk7 <stronk7>
Date:   Sat, 28 Oct 2006 00:51:35 +0800
Tag:    v1.7.0

Minor improvements to the get_record() cache. Part of MDL-7196

commit 3c5f492e9dee0c407204e78efc62c368dcec861a
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 06:25:21 +0800
Tag:    v1.7.0

Deprecating old "upgrade" files. MDL-7214

commit 1301de5879bae3d9b208c3429f4d5958a4e2d749
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 02:18:35 +0800
Tag:    v1.7.0

New upgrade.php file added for this module. MDL-7214

commit 87698fefb6222a818456bd2a66747beef2c45a76
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 02:12:43 +0800
Tag:    v1.7.0

file upgrade.php was added on branch MOODLE_17_STABLE on 2006-10-26 18:18:36 +0000

commit 7fd096aa140dddf011694c25ea99cf2271d54033
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 02:12:42 +0800
Tag:    v1.7.0

file upgrade.php was added on branch MOODLE_17_STABLE on 2006-10-26 18:18:35 +0000

commit 78dea37dbca76a614cd968fc66f22aad2c44efce
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 01:43:05 +0800
Tag:    v1.7.0

New upgrade.php file added for this module. MDL-7214

commit 8117a6dc8ac8c1632408b9e7707a7d9b7121f4ae
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 01:33:45 +0800
Tag:    v1.7.0

file upgrade.php was added on branch MOODLE_17_STABLE on 2006-10-26 17:43:11 +0000

commit 866002a1efd9bea883d3228d50a4ea3e5957278f
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 01:33:44 +0800
Tag:    v1.7.0

file upgrade.php was added on branch MOODLE_17_STABLE on 2006-10-26 17:43:09 +0000

commit c4a0e8dab6f69101d94df3abdf29745945ed7ed1
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 01:33:43 +0800
Tag:    v1.7.0

file upgrade.php was added on branch MOODLE_17_STABLE on 2006-10-26 17:43:08 +0000

commit b3f66a5f13f5915816b5fcd89652221763bb1bfa
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 01:33:42 +0800
Tag:    v1.7.0

file upgrade.php was added on branch MOODLE_17_STABLE on 2006-10-26 17:43:07 +0000

commit 78fb084d0248f7c2e51daffa9058f081d279933a
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 01:33:41 +0800
Tag:    v1.7.0

file upgrade.php was added on branch MOODLE_17_STABLE on 2006-10-26 17:43:06 +0000

commit 08f1de55d02a8c51ee3685128fbd5a77fff6d60d
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 01:33:40 +0800
Tag:    v1.7.0

file upgrade.php was added on branch MOODLE_17_STABLE on 2006-10-26 17:43:05 +0000

commit 29949f00318a5203ad15f3939a425bd64e4c0526
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 01:04:36 +0800
Tag:    v1.7.0

New upgrade.php file added for this module. MDL-7214

commit 24dea5f76b601e668240f60e26e9001b93c4bf4b
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 01:02:31 +0800
Tag:    v1.7.0

file upgrade.php was added on branch MOODLE_17_STABLE on 2006-10-26 17:04:36 +0000

commit f5f53ceb7ad1a86fe2cfb0dbbe368969703b12a7
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 00:53:08 +0800
Tag:    v1.7.0

New upgrade.php file added for this module. MDL-7214

commit 3638683cddd06ff74a09dc88455e21f86bc5b598
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 00:33:59 +0800
Tag:    v1.7.0

file upgrade.php was added on branch MOODLE_17_STABLE on 2006-10-26 16:53:11 +0000

commit ed1061fd1536f09c032a7619976a6c61c90f8b95
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 00:33:51 +0800
Tag:    v1.7.0

file upgrade.php was added on branch MOODLE_17_STABLE on 2006-10-26 16:53:10 +0000

commit fab77ea872e67083552b44546fd0dcf22ed95089
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 00:33:50 +0800
Tag:    v1.7.0

file upgrade.php was added on branch MOODLE_17_STABLE on 2006-10-26 16:53:09 +0000

commit ebb351fa659556fba28d6ba588713c7e3e0cfeef
Author: stronk7 <stronk7>
Date:   Fri, 27 Oct 2006 00:33:49 +0800
Tag:    v1.7.0

file upgrade.php was added on branch MOODLE_17_STABLE on 2006-10-26 16:53:08 +0000

commit c8bf751abf95a18aaf79529b2a33af87f2e03cfe
Author: stronk7 <stronk7>
Date:   Thu, 26 Oct 2006 23:44:50 +0800
Tag:    v1.7.0

New upgrade.php file added for this module. MDL-7214

commit fc10786ff12044b757885c518b047a0001514054
Author: stronk7 <stronk7>
Date:   Thu, 26 Oct 2006 23:38:18 +0800
Tag:    v1.7.0

file upgrade.php was added on branch MOODLE_17_STABLE on 2006-10-26 15:44:50 +0000

commit 0c64299b013db6f88cf729849ded3083dc9e20cc
Author: stronk7 <stronk7>
Date:   Thu, 26 Oct 2006 07:26:54 +0800
Tag:    v1.7.0

First model of new upgrade.php scripts and comments in old ones. Need validation before extending them everywhere across core. MDL-7214

commit eb2d09c49c1464e4f440c102f432ef656e9e0780
Author: stronk7 <stronk7>
Date:   Wed, 25 Oct 2006 05:55:54 +0800
Tag:    v1.7.0

DeLIMITing Moodle core. Now the new $limitfrom, $limitnum parameters are used instead. MDL-7168

commit a31fec1556d9ca54bd9a64373bd9f451c754440e
Author: stronk7 <stronk7>
Date:   Wed, 25 Oct 2006 02:27:31 +0800
Tag:    v1.7.0

Dropping some hardocded "mdl" prefixes. MDL-7202

commit f0cb717a7e198853bbc0cdde2cea6e38171b9f88
Author: stronk7 <stronk7>
Date:   Tue, 24 Oct 2006 06:56:41 +0800
Tag:    v1.7.0

Moving deprecated uses of sql_paging_limit() to the new $limitfrom, $limitnum parameters in all the get_recordXXX() functions. MDL-7167

commit 1fda1af9d2485574437aed34c2110adc17a79970
Author: stronk7 <stronk7>
Date:   Tue, 24 Oct 2006 01:38:47 +0800
Tag:    v1.7.0

Now insert_record() is using $db->GenID() to retrieve sequence numbers for Oracle. Just wondering if the same function should be used by PostgreSQL too.

commit 6d338ba5f93bde2300224df34e04c35e8990f984
Author: stronk7 <stronk7>
Date:   Mon, 23 Oct 2006 23:55:22 +0800
Tag:    v1.7.0

Suppress all the uses of LIMIT in the get_field_sql() calls. MDL-7173

commit cba3313110cc3bb97c429d1c7771d110b168aae1
Author: stronk7 <stronk7>
Date:   Mon, 23 Oct 2006 15:09:51 +0800
Tag:    v1.7.0

strip "old" harcoded "limit" clauses from the sql passed and debug about them. MDL-7173

commit f9baa9c1ccfcc94a6c45ddc4b6cc04f7fee3a509
Author: stronk7 <stronk7>
Date:   Mon, 23 Oct 2006 08:00:46 +0800
Tag:    v1.7.0

Prevent MSSQL to return from insert_record() before trying to execute the updating of LOBs.

commit 564f9b03e6ba7a9260bb4c191b84bb54653582b0
Author: stronk7 <stronk7>
Date:   Mon, 23 Oct 2006 07:20:14 +0800
Tag:    v1.7.0

Debugging sql_paging_limit() as deprecated and enforcing get_field_sql() to return 1 record max

commit a270bb477a7b9f4d85680d5c90d632d0e1715fe7
Author: stronk7 <stronk7>
Date:   Mon, 23 Oct 2006 06:57:27 +0800
Tag:    v1.7.0

Killing all sql_paging_limit() uses

commit 23f4b83ec6a81b472ae89743a65ed09205ab62ae
Author: stronk7 <stronk7>
Date:   Mon, 23 Oct 2006 06:47:58 +0800
Tag:    v1.7.0

Killing all sql_paging_limit() uses

commit 28c5a47afc70719abbb69419766bb7417e4caf88
Author: stronk7 <stronk7>
Date:   Mon, 23 Oct 2006 06:35:26 +0800
Tag:    v1.7.0

Adding limitfrom and limitnum parameters to a bunch of rarely executed functions...

commit 01cd9573899bd084a9a56cc1f7861693da9e55ff
Author: stronk7 <stronk7>
Date:   Sun, 22 Oct 2006 02:31:00 +0800
Tag:    v1.7.0

Deleting some old oci8po files from CVS.

commit d0d30cb9a0a3a175ab4e3462284aafeb262b9e65
Author: stronk7 <stronk7>
Date:   Sun, 22 Oct 2006 02:18:24 +0800
Tag:    v1.7.0

Prevent add_field() to work if we are adding one not null field to one non-empty table without specifying its default value.

commit 3bbc55a65042163f4f973445e6dc71e84c3bc071
Author: stronk7 <stronk7>
Date:   Sun, 22 Oct 2006 01:22:31 +0800
Tag:    v1.7.0

Added two more tests:

commit 0f1d2d8c9473aef575686ec1e2473096654812ac
Author: stronk7 <stronk7>
Date:   Sun, 22 Oct 2006 01:17:44 +0800
Tag:    v1.7.0

Minor typo fixed.

commit d490ba1476af6ba829307ab3e23fb71ac5658f77
Author: stronk7 <stronk7>
Date:   Sun, 22 Oct 2006 00:31:44 +0800
Tag:    v1.7.0

One typo (!==) was preventing defaults to be properly calculated for integers. Thanks to Nigel McNie for being on that!

commit 1dd6d5a8a26ede11b77db209c089292e1e3afb7e
Author: stronk7 <stronk7>
Date:   Fri, 20 Oct 2006 06:12:55 +0800
Tag:    v1.7.0

Adding support for the new mssql_n driver

commit c4020445c424d53de681d3c631ad1bf8a87f8f1b
Author: stronk7 <stronk7>
Date:   Fri, 20 Oct 2006 06:01:56 +0800
Tag:    v1.7.0

Adding support for the new mssql_n driver

commit 3b455ec7d20191970c2772e0375e125be892d718
Author: stronk7 <stronk7>
Date:   Fri, 20 Oct 2006 05:58:54 +0800
Tag:    v1.7.0

New ADOdb driver that extends the standard mssql one. All it does is to prepend the 'N' char before any SQL literal sent to DB, mainly because nobody (ODBTP, FreeTDS, ODBC, SQL*Server) seems to be doing this task, and it prevents, in an high degree true cross-db compatibility.

commit 760f271b076a15857e1c73a9e103eaead9a3c0fb
Author: stronk7 <stronk7>
Date:   Fri, 20 Oct 2006 05:57:23 +0800
Tag:    v1.7.0

file adodb-mssql_n.inc.php was added on branch MOODLE_17_STABLE on 2006-10-19 21:58:54 +0000

commit bf28e6d08a282437c0a6c2f1880f22028ff19700
Author: stronk7 <stronk7>
Date:   Fri, 20 Oct 2006 02:55:39 +0800
Tag:    v1.7.0

Adding support for the new mssql_n driver Two new strings added: mssql_n, databasesettingssub_mssql_n One string modified: databasesettingssub_mssql

commit 13f366f87b0fc8d4a02de72b80c417fbd1d28756
Author: stronk7 <stronk7>
Date:   Fri, 20 Oct 2006 02:44:07 +0800
Tag:    v1.7.0

Adding support for the new mssql_n driver

commit c9c2c6df007add9e98e618d6c002433acdbd4be4
Author: stronk7 <stronk7>
Date:   Fri, 20 Oct 2006 02:28:05 +0800
Tag:    v1.7.0

Adding support for the new mssql_n driver

commit ba1fa71220e97b2546a756c9721a4ac89418c71c
Author: stronk7 <stronk7>
Date:   Fri, 20 Oct 2006 01:26:09 +0800
Tag:    v1.7.0

Addding support for the new mssql_n ADOdb driver that, transparently, prepends the N char for all the string literals being set to MSSQL (until MS Unicode - standard- support will arrive).

commit 325bbaaa17bed592f9a32fe4a4e88ba10a277cb1
Author: stronk7 <stronk7>
Date:   Wed, 18 Oct 2006 07:34:52 +0800
Tag:    v1.7.0

Now insert/update/set of BINATY fields is supported by MSSQL (and easier to add new DB in the furure) MDL-7062

commit 12961dfd4d73a2f11f420d9606db73faca7ef082
Author: stronk7 <stronk7>
Date:   Wed, 18 Oct 2006 07:28:08 +0800
Tag:    v1.7.0

Added 4 more tests to check CLOB/BLOB handling across all DBs. MDL-7062

commit 4d78c38a372e9df6f9d4e9a235fe9c1bf40ac08c
Author: stronk7 <stronk7>
Date:   Wed, 18 Oct 2006 02:29:35 +0800
Tag:    v1.7.0

Fixed typo that was preventing correct BLOB storage under Oracle.

commit 7873f331eabe197f80520cc63f8966fcbde9ac41
Author: stronk7 <stronk7>
Date:   Tue, 17 Oct 2006 01:56:30 +0800
Tag:    v1.7.0

Added one more XMLDB test for find_sequence_name()

commit f8961f9bc09c77da812a6509e0bfead74110cfc6
Author: stronk7 <stronk7>
Date:   Tue, 17 Oct 2006 01:33:24 +0800
Tag:    v1.7.0

Added support for getSequenceFromDB() to PG.

commit 670eea76db470360a9d9e92c3f1fb71c55ccec0a
Author: stronk7 <stronk7>
Date:   Mon, 16 Oct 2006 07:02:07 +0800
Tag:    v1.7.0

New block upgrade functions must be called:

commit 59359cde798ec0d30e69ca00f4983a2363db16d0
Author: stronk7 <stronk7>
Date:   Mon, 16 Oct 2006 04:11:14 +0800
Tag:    v1.7.0

Now set_field() supports Oracle LOBs. Better error handling of oracle_update_lobs()

commit 2794229c55e10707ec133cfd926f9262041b1fca
Author: stronk7 <stronk7>
Date:   Mon, 16 Oct 2006 03:37:58 +0800
Tag:    v1.7.0

Now update_record() supports LOBs under Oracle. Plus prevent empty objects to be updated.

commit 626caefd894b4ce2eeb59edc9ef4cf91fc8296b4
Author: stronk7 <stronk7>
Date:   Mon, 16 Oct 2006 02:34:38 +0800
Tag:    v1.7.0

Minor changes + debug info in UpdateXlob()

commit 6880e3bb16c87ed9ae7d74a10f77bf3cf2ed640f
Author: stronk7 <stronk7>
Date:   Mon, 16 Oct 2006 00:38:22 +0800
Tag:    v1.7.0

- Introducing the first version of the new mssql_n adodb driver (not finished, just for experimenting). - Now insert_record() is handling Oracle CLOBS and BLOBS properly (really annoying the number of hacks needed). - Creating one new global object to cache $db->MetaColumns() calls per request, because it's being used in a lot of places inside dmllib. TODO: hack update_record() and set_field() to allow Oracle LOBs       enclose all the Oracle function calls into one db transaction

commit 43efbf3debd6a0f2044a4944bec147aeec815eeb
Author: stronk7 <stronk7>
Date:   Sat, 14 Oct 2006 07:47:19 +0800
Tag:    v1.7.0

Now admin/index.php checks for proper prefixes (MDL-6230)

commit b0c015e1567a42f2096151f560aec84422428494
Author: stronk7 <stronk7>
Date:   Sat, 14 Oct 2006 02:18:44 +0800
Tag:    v1.7.0

Now installersadMDL-6823) - performs Oracle charset checks (both client and server) - prefix checks - shows differnt information foreach DB flavour - provide one link to Moodle Docs for MSSQL and Oracle - the ODBC connector has been marked as experimental due   to confirmed problems by MS

commit b47138f834288607affe306c64580ba06a6134c9
Author: stronk7 <stronk7>
Date:   Sat, 14 Oct 2006 01:22:14 +0800
Tag:    v1.7.0

Some more strings added to the installer to make it more resposible.

commit 40652b156b9f3581c8f32a9bfa4f60468622b502
Author: stronk7 <stronk7>
Date:   Fri, 13 Oct 2006 19:32:42 +0800
Tag:    v1.7.0

Added new strings for DB select/configure.

commit ddc35e5bd50ae47d4360a0eaad48bc92dd5392a5
Author: stronk7 <stronk7>
Date:   Fri, 13 Oct 2006 01:42:42 +0800
Tag:    v1.7.0

First cut of the modified installer. TODO:

commit 5d7850d42e6d807452fdee9d158bbc5989c39e9b
Author: stronk7 <stronk7>
Date:   Thu, 12 Oct 2006 20:25:03 +0800
Tag:    v1.7.0

Small change in rename_field() so objects won't become modified at all in the process.

commit a08a6988950840d04f4e281c191ec3d52690e988
Author: stronk7 <stronk7>
Date:   Tue, 10 Oct 2006 07:39:32 +0800
Tag:    v1.7.0

Updated moodle notes to reflect latest change to odbc_mssql driver.

commit d5d50c2d547b2a89cda22d243fcf8389dfa07833
Author: stronk7 <stronk7>
Date:   Tue, 10 Oct 2006 07:36:27 +0800
Tag:    v1.7.0

Fixed ServerInfo() behaviour for odbc_mssql. We need this working properly NOW! (will be back once ADOdb code supports it properly)

commit 97ab73aad4ce7d7913b1642233eb3eb5261e2496
Author: stronk7 <stronk7>
Date:   Tue, 10 Oct 2006 06:55:55 +0800
Tag:    v1.7.0

Add odbc_msql dbtype to a bunch of places.

commit 354bb6035aaf1e8fbc3c0e1c3d2bbdadb9be651c
Author: stronk7 <stronk7>
Date:   Tue, 10 Oct 2006 06:29:52 +0800
Tag:    v1.7.0

And now, Moodle is able to work with the odbc_mssql driver. Simple! cool

commit 1c460b0bc99d2f33321e77ecc68dc584bcdeb24a
Author: stronk7 <stronk7>
Date:   Tue, 10 Oct 2006 06:28:22 +0800
Tag:    v1.7.0

Show error if the dbtype specified isn't supported by XMLDB

commit cd2acc4aa19942fb137b1a92bccb6edf93f56897
Author: stronk7 <stronk7>
Date:   Tue, 10 Oct 2006 06:26:21 +0800
Tag:    v1.7.0

Added MetaIndexes() support to the odbc_mssql driver. We need it NOW! I've posted one comment about this in ADOdb forums:

commit a3f3ff1b698d638730dbfb2469ae99b1eb62c67c
Author: stronk7 <stronk7>
Date:   Tue, 10 Oct 2006 06:21:01 +0800
Tag:    v1.7.0

Added MetaIndexes() support to the odbc_mssql driver. We need it NOW! I've posted one comment about this in ADOdb forums:

commit 2d31c3939734bb6343ca5b0beed910978ec1d6f9
Author: stronk7 <stronk7>
Date:   Tue, 10 Oct 2006 00:33:31 +0800
Tag:    v1.7.0

Not necessary to set unicodedb for each admin/index.php invocation because setup.php saves it if needed.

commit 9b3bacf07717db782d6bb6c8dce81f03b0f0ea01
Author: stronk7 <stronk7>
Date:   Tue, 10 Oct 2006 00:19:29 +0800
Tag:    v1.7.0

Raising MSSQL min req. to 2005 (9.0)

commit 5fbab6173ac934b460920771399d4f6d8fe21e29
Author: stronk7 <stronk7>
Date:   Sun, 08 Oct 2006 17:58:11 +0800
Tag:    v1.7.0

Now Oracle uses the new find_sequence_name() function to find the correct sequence name for each table on insert.

commit c5ac44c69e9692c7c504bb2822bc145b78c1b149
Author: stronk7 <stronk7>
Date:   Sun, 08 Oct 2006 17:38:09 +0800
Tag:    v1.7.0

Added find_sequence_name() to be used by insert_record() to get the correct sequence

commit abbd460ff991bc403ed82dfee3a363991c154e01
Author: stronk7 <stronk7>
Date:   Sun, 08 Oct 2006 17:36:33 +0800
Tag:    v1.7.0

Adding getSequenceFromDB() for Oracle in order to detect the correct sequence name in the insert_record() function.

commit dd00dbd7990e7a21066c8fc91076180ac711d0b4
Author: stronk7 <stronk7>
Date:   Sat, 07 Oct 2006 18:33:58 +0800
Tag:    v1.7.0

Allow load average to be displayed in servers using the comma as decimal separator.

commit b7e58d8f8c9795c345dec011e481191c36fd7381
Author: stronk7 <stronk7>
Date:   Sat, 07 Oct 2006 06:25:49 +0800
Tag:    v1.7.0

Wood-ising the adminsettings fieldset

commit 29bbfb339ac9fc8928e38831958ff8b51a64474d
Author: stronk7 <stronk7>
Date:   Fri, 06 Oct 2006 23:26:13 +0800
Tag:    v1.7.0

One malformed XML was preventing wiki_logs to be properly UTF8-ised. MDL-6854

commit b695b9106bbf8f2eb310f6f1b4a282eef2e3717e
Author: stronk7 <stronk7>
Date:   Fri, 06 Oct 2006 23:03:46 +0800
Tag:    v1.7.0

Typo recently introduced. MDL-6336 (merged from MOODLE_16_STABLE)

commit 1db1336bd4c56e5530724051243f7045815c10cc
Author: stronk7 <stronk7>
Date:   Fri, 06 Oct 2006 03:51:47 +0800
Tag:    v1.7.0

Avoid some notices. Part of MDL-6854

commit 10f36d68e80a683a478762df9c00a0b1492e440e
Author: stronk7 <stronk7>
Date:   Fri, 06 Oct 2006 03:29:39 +0800
Tag:    v1.7.0

Avoid some notices. Part of MDL-6854

commit 2ddec1f4ac9c7a24867bd65a125060e2d2c50ffa
Author: stronk7 <stronk7>
Date:   Tue, 03 Oct 2006 23:00:55 +0800
Tag:    v1.7.0

Changed PG rename_index() to use the old ALTER TABLE ... RENAME TO syntax (pretty strange syntax, but seems to work)

commit cc0bf616762e6f2da5b7c39c06aaf139785a46fc
Author: stronk7 <stronk7>
Date:   Tue, 03 Oct 2006 07:06:36 +0800
Tag:    v1.7.0

Now blocks deletion looks both for tables without and with the "block_" part in table names. This is an interim situation until "block_" will be required. See: http://docs.moodle.org/en/Development:Coding#Database_structures http://tracker.moodle.org/browse/MDL-6786

commit f8ca40505221a1152342a7bec7df4c1ced36a117
Author: stronk7 <stronk7>
Date:   Tue, 03 Oct 2006 01:42:31 +0800
Tag:    v1.7.0

re-enabling the rename_field() test

commit ae5a83e6fd441b59caa0535c356dacb2e4769636
Author: stronk7 <stronk7>
Date:   Tue, 03 Oct 2006 01:42:14 +0800
Tag:    v1.7.0

rename_field() under mssql completed

commit c562997ff85587a5ea9d11f6fd46b184162dd7ad
Author: stronk7 <stronk7>
Date:   Tue, 03 Oct 2006 01:06:37 +0800
Tag:    v1.7.0

rename_field() under oracle completed

commit 86bb076fc4a158db8d617f36f61c4d9daec9da05
Author: stronk7 <stronk7>
Date:   Tue, 03 Oct 2006 01:02:35 +0800
Tag:    v1.7.0

rename_field() under postgresql completed.

commit dc7c388280bf7e53a20b7d954e80d9cdf30d9e92
Author: stronk7 <stronk7>
Date:   Tue, 03 Oct 2006 01:02:07 +0800
Tag:    v1.7.0

MySQL doesn't have check constraints. We use enums instead.

commit f14080b0add855b6728e620ca1d27e8f0f12a916
Author: stronk7 <stronk7>
Date:   Tue, 03 Oct 2006 00:47:02 +0800
Tag:    v1.7.0

Prevent "id" fields to be renamed in generators

commit 6fdea1a0bdb797228453700da30a99205ee7c9ce
Author: stronk7 <stronk7>
Date:   Tue, 03 Oct 2006 00:46:12 +0800
Tag:    v1.7.0

In my previous commit, "I" was "It" big grin Plus one typo fixed.

commit af72e372373ae4c1f05e964f8b65a81f2eb53be9
Author: stronk7 <stronk7>
Date:   Tue, 03 Oct 2006 00:37:41 +0800
Tag:    v1.7.0

Prevent "id" fields to be renamed. I can cause lots of problems.

commit 0e204a10120d5da145c6e78e43f479af68068525
Author: stronk7 <stronk7>
Date:   Tue, 03 Oct 2006 00:28:51 +0800
Tag:    v1.7.0

Some adjustments to be able to get names without prefix

commit 6c02f04b5a9db48fd033b29b1b07f23bbccb09f3
Author: stronk7 <stronk7>
Date:   Tue, 03 Oct 2006 00:27:18 +0800
Tag:    v1.7.0

rename_table() under postgresql completed

commit 303399118494ba5dc6b5b25664ac8e93ae3e72bd
Author: stronk7 <stronk7>
Date:   Tue, 03 Oct 2006 00:26:34 +0800
Tag:    v1.7.0

Set debug off on tests

commit bb7e5c472cad3e60cbd26b20fdea7abe9b9f9387
Author: stronk7 <stronk7>
Date:   Tue, 03 Oct 2006 00:19:48 +0800
Tag:    v1.7.0

rename_table() under oracle completed

commit 2f217542617c7d5380f20d48410b7e8f1e64a065
Author: stronk7 <stronk7>
Date:   Mon, 02 Oct 2006 23:57:59 +0800
Tag:    v1.7.0

With the emotion, I forgot to delete some debug lines... tongueout

commit 8aaf86642c7435bc6770998a3fe54c49e78b41ae
Author: stronk7 <stronk7>
Date:   Mon, 02 Oct 2006 23:56:34 +0800
Tag:    v1.7.0

rename_table() under mssql completed! cool

commit cba6b7049a30d498924b11eaeef66a343b0dbb89
Author: stronk7 <stronk7>
Date:   Mon, 02 Oct 2006 07:06:35 +0800
Tag:    v1.7.0

Enabling rename_field() test

commit a2851e5f55b456d71f865092b510661e761086eb
Author: stronk7 <stronk7>
Date:   Mon, 02 Oct 2006 07:02:39 +0800
Tag:    v1.7.0

Basic rename_field() function added. TODO: Automatic sequence/trigger/check constraint recreation       under PG, MSSQL & Oracle

commit 7c07a932236079a82b11d23b9eb8ecc582d796dc
Author: stronk7 <stronk7>
Date:   Mon, 02 Oct 2006 06:54:51 +0800
Tag:    v1.7.0

Added rename_field() support. TODO: Sync sequences, triggers and check constraints

commit 4de0723f3133d6e2cd77aaf5e9a3d5811641c551
Author: stronk7 <stronk7>
Date:   Mon, 02 Oct 2006 06:52:30 +0800
Tag:    v1.7.0

Added rename_field() support for mssql

commit b5d61bfd9d7f924acc5dec9ddbe1fcaad08e85a9
Author: stronk7 <stronk7>
Date:   Mon, 02 Oct 2006 06:44:39 +0800
Tag:    v1.7.0

Added rename_field() support for MySQL

commit 38326822290e0c4afe12f7b96f5b0406ff718686
Author: stronk7 <stronk7>
Date:   Mon, 02 Oct 2006 00:08:25 +0800
Tag:    v1.7.0

Fixed two bugs in the tests...

commit 51517ddc6d4933a5ca406d924afad7dfc57720ee
Author: stronk7 <stronk7>
Date:   Mon, 02 Oct 2006 00:02:09 +0800
Tag:    v1.7.0

Avoid some double updates under PG

commit 1f0c7fae156092fc26bd77069182a7c98ba40f47
Author: stronk7 <stronk7>
Date:   Sun, 01 Oct 2006 23:48:29 +0800
Tag:    v1.7.0

Now PG adds fields in various steps is order to fulfill 7.4 min req

commit 2cfea485a6ac98ec56b298870c74051031a949df
Author: stronk7 <stronk7>
Date:   Sun, 01 Oct 2006 23:47:48 +0800
Tag:    v1.7.0

Added getDefaultValue() for better handling of default values

commit f6ebc341003c2844df72d95e5849ffb34d11fc86
Author: stronk7 <stronk7>
Date:   Sun, 01 Oct 2006 22:39:50 +0800
Tag:    v1.7.0

Fixed one wrong "return false" plus minor code reorder...

commit abf980a58706c54b0daa4ae119ab26b3d70756c3
Author: stronk7 <stronk7>
Date:   Sun, 01 Oct 2006 16:44:55 +0800
Tag:    v1.7.0

Now table renaming is working properly on PostgreSQL (only renaming of check constraints are pending)

commit 20c559dd8de8a279efbcd2d555592ae44b667a77
Author: stronk7 <stronk7>
Date:   Sun, 01 Oct 2006 07:48:34 +0800
Tag:    v1.7.0

Now Oracle supports table renaming (both sequence and triggers are kept on sync with the new table name)

commit f086dd7da1a1f0a14d2c6cfeaa351b5b5f80c985
Author: stronk7 <stronk7>
Date:   Sun, 01 Oct 2006 07:09:41 +0800
Tag:    v1.7.0

Drop one more table if present

commit 4702d62e3295646b994b35f6da0fcb226b56e4e7
Author: stronk7 <stronk7>
Date:   Sun, 01 Oct 2006 06:59:10 +0800
Tag:    v1.7.0

Change slighty the style of RenameKey and RenameIndex functions.

commit a59f3a34f36805005fef9fda14ed02657f8f2a36
Author: stronk7 <stronk7>
Date:   Sun, 01 Oct 2006 06:40:15 +0800
Tag:    v1.7.0

Initial commit of rename_table(). Not ended!

commit 142d7fb842a7e6e01245e1a0cdb99a59b41f3eec
Author: stronk7 <stronk7>
Date:   Sun, 01 Oct 2006 03:45:51 +0800
Tag:    v1.7.0

Added one more test to check the EXPERIMENTAL rename_key() function

commit 9c4ee55b6c845749da52e2090c15c726ecf3f3cc
Author: stronk7 <stronk7>
Date:   Sun, 01 Oct 2006 03:44:49 +0800
Tag:    v1.7.0

Added rename_key() Note that this is one EXPERIMENTAL function and shouldn't be used by you in production code EVER!

commit 57770f7a50b66fc3e38904bec2c8706ce1147637
Author: stronk7 <stronk7>
Date:   Sun, 01 Oct 2006 03:44:16 +0800
Tag:    v1.7.0

Adding support to rename_key() Note that this is one EXPERIMENTAL function and shouldn't be used by you in production code EVER!

commit e77fd021e6258a86aea193d676d2b268b2cb2531
Author: stronk7 <stronk7>
Date:   Sun, 01 Oct 2006 03:43:16 +0800
Tag:    v1.7.0

Implemented rename_key() Note that this is one EXPERIMENTAL function and shouldn't be used by you in production code EVER!

commit 6c89dc5514917d1e37c23088206c8f56ab6e05f1
Author: stronk7 <stronk7>
Date:   Sun, 01 Oct 2006 02:24:14 +0800
Tag:    v1.7.0

Added rename_index() Adding support for index renaming. Note that MySQL doesn't support this but this shouldn't be important at all, mainly because, under xmldb, accesses to index-names are always done with find_index_name() and never explicity. Anyway, this function could be useful in the future to normalize index names in some Health center or another similar place.

commit 1c86ef5b1ceaea3411015b5033cd7b316b737dbc
Author: stronk7 <stronk7>
Date:   Sun, 01 Oct 2006 02:23:00 +0800
Tag:    v1.7.0

Adding support for index renaming. Note that MySQL doesn't support this but this shouldn't be important at all, mainly because, under xmldb, accesses to index-names are always done with find_index_name() and never explicity. Anyway, this function could be useful in the future to normalize index names in some Health center or another similar place.

commit aa8503fdd092c448f7cb2ea17bd159ba424caef6
Author: stronk7 <stronk7>
Date:   Sun, 01 Oct 2006 01:06:59 +0800
Tag:    v1.7.0

Added 3 more tests to check change_field_enum()

commit 61af97e76b11b1a43d120182677a202b085a44cf
Author: stronk7 <stronk7>
Date:   Sun, 01 Oct 2006 01:06:20 +0800
Tag:    v1.7.0

Added new function change_field_enum()

commit b899d9bf1d529b5310db0cb938f450014d80817b
Author: stronk7 <stronk7>
Date:   Sun, 01 Oct 2006 01:03:17 +0800
Tag:    v1.7.0

Added support to change_field_enum() across all RDBMS

commit 3650ba6f5862c6f518980480cdb8737633433ad4
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 23:51:41 +0800
Tag:    v1.7.0

Using the new table_exists() to initialize tests properly.

commit 3e1861cc87814a00dc2c194675a196474f799c11
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 23:48:23 +0800
Tag:    v1.7.0

Applying the field_exists() check to add and drop fields.

commit 342da808c59db45df0cbe37452006a6778020418
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 23:35:32 +0800
Tag:    v1.7.0

New function field_exists() to detect if one field exists

commit 73d111a820dd164be7e78fe8c66c04acff263b79
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 23:19:56 +0800
Tag:    v1.7.0

Add some checks to detect if one table exists before creating or dropping it. Part of MDL-6614

commit 7471f3f0dd0ebf1ffd9c337f055a4b14ae906ac1
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 23:15:34 +0800
Tag:    v1.7.0

Adding some debugging() for some controlled actions.

commit ed37b15464de2e3943f2a8aca15edccaabc64761
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 23:00:46 +0800
Tag:    v1.7.0

Moving some uses of find_index_name() to index_exists()

commit cf9a1a40f1626ee9ddfa2dd5e5995dbfc05df632
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 22:59:03 +0800
Tag:    v1.7.0

Fixed typo

commit 4103c3545ccc76cf2e8723f65fd3f013a2450c67
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 22:36:52 +0800
Tag:    v1.7.0

Prevent tables without prefix to be duplicated at install time. MDL-6614

commit 2719f3e2c9f1f91abf3b4a6bead11e6505d8e4b0
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 21:04:17 +0800
Tag:    v1.7.0

Inside ddllib, for consistency we call parameters table, field... (without the xmldb_ prefix)

commit a504ba021327b1da291c86cd4756b53f3629b4e4
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 20:56:39 +0800
Tag:    v1.7.0

Added index_exists(). One wrapper over find_index_name()

commit 512a237ff6dc8da37b4e5a3b5c5a1ee71b003556
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 20:34:17 +0800
Tag:    v1.7.0

One more use of getTableName() added.

commit 9af19c728df09dc463177f6b090e0294c78d186e
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 20:13:07 +0800
Tag:    v1.7.0

Extendig use of new getTableName() over all generators

commit 97b917845905f811864364927692b95e11194196
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 20:03:19 +0800
Tag:    v1.7.0

New getTableName() function to get normalised table names everywhere

commit 68bc165bedd154e1c72b5e57f6da6319f37d09f1
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 20:01:33 +0800
Tag:    v1.7.0

Added new function table_exists() to be used later...

commit 87c6baf4a1fab69a621e6661799f4077911c18d2
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 19:09:44 +0800
Tag:    v1.7.0

Ah! forgot to interchange keys and values!

commit ef18962b0044cbf345b467bebe31ac37bf64dfc0
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 18:54:37 +0800
Tag:    v1.7.0

Execute the index_get_name() silently to avoid a lot of output in the install/upgrade process. Original db->debug is re-set to their original status once executed.

commit 4fae686bc245d68d4e8ec26002e370fb85d52670
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 07:12:40 +0800
Tag:    v1.7.0

Enablig PHP generation of code for change_field_type()

commit cec4b7c621ab07e84da1665300cca6beb89c405e
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 07:10:31 +0800
Tag:    v1.7.0

Added to more tests to check float <---> char conversion

commit 6e152cc621e765d307e561bb562a82f1d630e875
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 01:49:04 +0800
Tag:    v1.7.0

Now basic types of conversion (int2char, char2int, number2char, char2number) are working properly under all RDBMS.

commit b0cd86786b47b5096ca930c9878e048115f6ee53
Author: stronk7 <stronk7>
Date:   Sat, 30 Sep 2006 01:29:08 +0800
Tag:    v1.7.0

Change one test a bit...

commit 72fa54494737d382c3983fd7e92cd1d44a35e51a
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 07:16:29 +0800
Tag:    v1.7.0

Moving some tests up and down and introducing some more tests about changing column types. Not working yet unded mssql

commit f020b357052481493cb94ac3a0ff30e5e3d853a9
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 07:14:52 +0800
Tag:    v1.7.0

Moving some change_field_XXX() functions and introducing change_field_type(). Seems to work everywere but under mssql (due to some problems with default constraints). Will see it tomorrow.

commit 599caff8c569fff5fe57d4a06471d65e989fc982
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 07:06:04 +0800
Tag:    v1.7.0

prevent nulls to become nulls (oracle error) and defaults null to become defaults null when temporary columns are used

commit 531bf2648919624bee62335efc67964be8c65362
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 06:11:06 +0800
Tag:    v1.7.0

Adding two more tests (create and drop foreign keys)

commit 5adc951c4f0969576cd7e88f474ba8c4dab1c21b
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 06:05:11 +0800
Tag:    v1.7.0

Don't rely on index names to decide if we have to drop one key

commit d54f85efa6f038c487b11d2b2f49e57e1b3f4f05
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 05:47:36 +0800
Tag:    v1.7.0

minor adjust. keytype to drop keys is not needed anymore. now it's defined in mysql generator (the only one needing it)

commit ac5ff0e787c11332cc346caf61a6812bee877d99
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 04:12:00 +0800
Tag:    v1.7.0

fixed one wrong constant

commit 9c46a7e6f91400705d1935338898da7ea759ff1f
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 04:11:30 +0800
Tag:    v1.7.0

changed mysql drop index syntax. Nothing relevant.

commit 71ea93e02358df74e4604d3fccd52e0ea64c5226
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 04:06:08 +0800
Tag:    v1.7.0

Argh! More than 3 hours searching for this error! I was calling one constructor with wrong number of parameters and PHP said nothing at all (with DEVELOPER level of debugging). Horrible OOP !

commit 53d3b80798dd1a56d369052357b9ec15c8aab54c
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 03:43:17 +0800
Tag:    v1.7.0

prevent some warnings on tables without indexes

commit 4690f076caaa302d173001182020628b2fe2e4fe
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 02:56:21 +0800
Tag:    v1.7.0

Now keys and indexes are PERFECT (argh, Oracle, once more was causing problems)

commit 4df8b6cdfc4629cd6bf6a13f1e9fc52feee1855a
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 02:39:33 +0800
Tag:    v1.7.0

some more settings go to XMLDBGenerator (as they are default)

commit 1a275daaafc7358d616821abcf74e47b3bada606
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 02:31:28 +0800
Tag:    v1.7.0

some more settings go to XMLDBGenerator (as they are default)

commit a8b7de48fe6b369e02bffc2f3baa085cf4dc9470
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 01:35:52 +0800
Tag:    v1.7.0

Adding some more tests about adding and dropping keys

commit 55c4b9435d4659a5063c5a8f68cc3b6467ac4428
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 01:30:14 +0800
Tag:    v1.7.0

add_key() and drop_key() are working (with sync of undelying indexes automated)

commit fac17f427fee79f71ab83d80c63ea650753eeba5
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 01:25:00 +0800
Tag:    v1.7.0

add_key() and drop_key() are working (with sync of undelying indexes automated)

commit 0852990f9b6d4409c9f00c5c43e70bb88e6767fd
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 01:20:21 +0800
Tag:    v1.7.0

Deleting some parameters that aren't needed anymore. Code will decide if creating underlying indexes for keys automatically now.

commit 662244cb77d3b9b2d9ad0f4f0ecabcb5fa49ab27
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 01:02:49 +0800
Tag:    v1.7.0

Deleting some parameters that aren't needed anymore. Code will decide if creating underlying indexes for keys automatically now.

commit b399c397bfef8ca7f7eb4e40aaad7ebde4ed10ae
Author: stronk7 <stronk7>
Date:   Fri, 29 Sep 2006 00:46:52 +0800
Tag:    v1.7.0

Added PHP 5.0.x restriction to Moodle 1.7. MDL-5653

commit 97bd35b2849b89fb5df16ea9461911dce2463f20
Author: stronk7 <stronk7>
Date:   Thu, 28 Sep 2006 02:47:24 +0800
Tag:    v1.7.0

Fixed bug in PHP generation of indexes.

commit 13e9de1c6753c1528f8bac44c55755489df52a7d
Author: stronk7 <stronk7>
Date:   Thu, 28 Sep 2006 01:48:45 +0800
Tag:    v1.7.0

Fixed Bug MDL-6647 - PG version not being fetched properly. (http://tracker.moodle.org/browse/MDL-6647)

commit d335bebc06e3e5015386f84da913f6d6010c99a6
Author: stronk7 <stronk7>
Date:   Wed, 27 Sep 2006 07:17:24 +0800
Tag:    v1.7.0

Added support for add_index() and drop_index()

commit 42d1fc2f3fe6cd367342997f04c53cd2080531db
Author: stronk7 <stronk7>
Date:   Wed, 27 Sep 2006 07:16:09 +0800
Tag:    v1.7.0

XMLDBTable wrappers to create and drop indexes

commit 618a982eed437637ec27e0c7526d63a52320f879
Author: stronk7 <stronk7>
Date:   Wed, 27 Sep 2006 07:15:20 +0800
Tag:    v1.7.0

Now all the generators support creating and dropping indexes

commit 0c31ba281368d0d9ebe42eec75799e634a6c2216
Author: stronk7 <stronk7>
Date:   Wed, 27 Sep 2006 07:08:44 +0800
Tag:    v1.7.0

Adding test for create index and drop index.

commit b0d84443496d895ec08dd968cc2c9b0799a6592c
Author: stronk7 <stronk7>
Date:   Wed, 27 Sep 2006 06:46:05 +0800
Tag:    v1.7.0

Fix one place where index->type was being used instead of index->unique

commit ceac2552efd0d1adec8c71f9aa21a948b9244515
Author: stronk7 <stronk7>
Date:   Wed, 27 Sep 2006 03:05:55 +0800
Tag:    v1.7.0

Added support for PHP generation on create/drop/rename indexes and keys

commit 48eac3132879c25da998b8fe78f5804589ec0642
Author: stronk7 <stronk7>
Date:   Wed, 27 Sep 2006 02:34:48 +0800
Tag:    v1.7.0

Replaced XMLDB own implementation of the concat function to use the new, ultra-cool, ADOdb based, concat_sql(). Thanks, Martin Langhoff!

commit 66841aed2962b2690f4140bb367dcfa0a3c26307
Author: stronk7 <stronk7>
Date:   Wed, 27 Sep 2006 02:27:44 +0800
Tag:    v1.7.0

One wrong use of onespace2empty() - an strange function - mixed in the DIRTY HACK was causing not info to be returned under Oracle by the get_field_sql() function, so sequence numbers were broken.

commit 1d5071a57e8dd1df5c0fdc2e7f8f9b1ad1a451a1
Author: stronk7 <stronk7>
Date:   Wed, 27 Sep 2006 02:10:27 +0800
Tag:    v1.7.0

Don't CREATE OR REPLACE TRIGGER but just CREATE it (so we'll be able to detect duplicate name with an error instead of getting false success)

commit 2efd67bf5f5d0a3703c2238ca187f77b8c44490e
Author: stronk7 <stronk7>
Date:   Wed, 27 Sep 2006 01:43:37 +0800
Tag:    v1.7.0

Increasing log_display->field because sql_concat() (one wrapper over ADOdb Concat() generates really long expressions for MSSQL.

commit 7bd1b4f5ba70f19a87c974a36e3f5ed9a0fa5aaa
Author: stronk7 <stronk7>
Date:   Wed, 27 Sep 2006 00:58:49 +0800
Tag:    v1.7.0

Ops, scorm->skipview default must be 1

commit 59e3e9627713907770aebbf682c1065341d7b396
Author: stronk7 <stronk7>
Date:   Wed, 27 Sep 2006 00:27:39 +0800
Tag:    v1.7.0

copy/paste typo

commit d5a28fdae9d20439a21c0491f2b3246e816f2b08
Author: stronk7 <stronk7>
Date:   Tue, 26 Sep 2006 23:56:18 +0800
Tag:    v1.7.0

Adding scorm->skipview to PostgreSQL

commit d107d190579062ed42faf6b07b3a0f27341d631c
Author: stronk7 <stronk7>
Date:   Tue, 26 Sep 2006 23:25:29 +0800
Tag:    v1.7.0

Adding scorm->skipview to XMLDB file!

commit ef47a3eb5b07ec2d29df1b73ca69d7176f8264c6
Author: stronk7 <stronk7>
Date:   Tue, 26 Sep 2006 07:09:16 +0800
Tag:    v1.7.0

Fixed display of files

commit 8e81509277e5c2838b174403f55e69ba16ea5cdb
Author: stronk7 <stronk7>
Date:   Tue, 26 Sep 2006 06:57:20 +0800
Tag:    v1.7.0

Added one woody style for all the admin fieldsets

commit 313b5a35508a8238f4ba4bb016415bbef62a4e42
Author: stronk7 <stronk7>
Date:   Tue, 26 Sep 2006 06:53:39 +0800
Tag:    v1.7.0

Minor changes to improve behaviour of selections.

commit b017120ce0e8afeaf521605731b813c756fb637a
Author: stronk7 <stronk7>
Date:   Tue, 26 Sep 2006 06:48:43 +0800
Tag:    v1.7.0

Ops! I forgot to commit this 2 days ago! Now a lot of data fields will be null!

commit 0db2d6bb98e5243415f9ad9d7fc01ed1e94506a1
Author: stronk7 <stronk7>
Date:   Tue, 26 Sep 2006 05:44:21 +0800
Tag:    v1.7.0

Prevent NOT NULL fields to have one DEFAULT NULL clause

commit a653016d94e6cc2b351cbcc2b796eda31c668145
Author: stronk7 <stronk7>
Date:   Tue, 26 Sep 2006 05:37:29 +0800
Tag:    v1.7.0

Some notes:

commit 6caa705dad83152250963e5b76df9711c8bf8976
Author: stronk7 <stronk7>
Date:   Tue, 26 Sep 2006 03:26:16 +0800
Tag:    v1.7.0

Some more strings added...related with the View PHP utility

commit 812e363a39e9f92016170df157cb90312b82b7f0
Author: stronk7 <stronk7>
Date:   Tue, 26 Sep 2006 02:22:06 +0800
Tag:    v1.7.0

Now generators support to add/drop column defaults

commit aa134ecf17266c1c8ac44a811e343c79270d7dfd
Author: stronk7 <stronk7>
Date:   Tue, 26 Sep 2006 02:20:08 +0800
Tag:    v1.7.0

Now the tests are performed with real data (2 records). Added 4 more tests to check compatibility of set/drop defaults...

commit e920529bf893d1b2577d1f4e6ec672d526d47b92
Author: stronk7 <stronk7>
Date:   Mon, 25 Sep 2006 06:15:57 +0800
Tag:    v1.7.0

Quick Fix. It should be 24!

commit 26b82be252bab3775f00365ae09f97149236e736
Author: stronk7 <stronk7>
Date:   Mon, 25 Sep 2006 06:14:23 +0800
Tag:    v1.7.0

Drop all the unique keys inside PostgreSQL DB and convert them to their equivalest unique indexes. We aren't going to allow unique keys from 1.7 and upwards (until we decide to enforce referential intregrity and until ADOdb support it)

commit 7253d30810e94d30e3c5e78e765534220b5fc0e8
Author: stronk7 <stronk7>
Date:   Mon, 25 Sep 2006 03:39:53 +0800
Tag:    v1.7.0

Added one new function find_key_name() to retrieve the name og any key in the DB. This hasn't too much sense for now (until we start to use referencial integrity) and it is far from perfect, because it doesn't seach for the key really in DB (due to the lack of support for this of ADOdb).

commit 11b75afe8ba18934cd6e650f90d6d53ae58b04a5
Author: stronk7 <stronk7>
Date:   Mon, 25 Sep 2006 01:39:20 +0800
Tag:    v1.7.0

Now Oracle generator is able to change the precision and decimals of one column by using one temp column. This prevents ORA-1440 errors.

commit cc3779694a0b74e42a809065ec6eca4bbb4704ca
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 23:54:46 +0800
Tag:    v1.7.0

MSSQL alter field is exactly the standard one but with alter_column_skip_default enabled

commit c1761c4292d0fb8d32ce0cd932cb8cf9c8befda1
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 23:34:18 +0800
Tag:    v1.7.0

XMLDB generators can return empty arrays if there is nothing to do.

commit c02a561f973ad489818b0c453a786d756d42f0e2
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 23:28:32 +0800
Tag:    v1.7.0

Minor change to test to exclusively test the change of nullability

commit d3b93bd26a101cec6cb3e0b0155ea454ac73db9c
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 23:26:49 +0800
Tag:    v1.7.0

Add skip parameters to one getFieldSQL call requiring them

commit ff936e2c2df266c3d4a5f51bd8295d9b25433966
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 23:25:49 +0800
Tag:    v1.7.0

Finally PostgreSQL seems to be working now.... I've tried to do it as clever as possible detecting when column specs change in order to reduce the number of temp-update-drop-rename operations

commit f46e2c8cbcb1161960b21674a5aca6662adb08a9
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 17:59:25 +0800
Tag:    v1.7.0

Changed one LIMIT to a cross-db WHERE clause

commit b0ec41af8aa042709480837d9f4d9f4abf199f63
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 17:38:56 +0800
Tag:    v1.7.0

Prevent Unique Keys generation. Instead use unique indexes at DB level. With this, all we'll have are PRIMARY KEYS + INDEXES, that are pretty well supported by ADODB MetaXXX functions. Both Unique and Foreign Keys will be used once ADODB support them and the relational mode was enforced.

commit 70a8ac6666729101a0012bbfbdb0d3bfff8d0e91
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 16:26:24 +0800
Tag:    v1.7.0

Given one xmldb_field, finds its name in DB

commit dcf9c14c2b687befe2f9af0a5c2899002b1d54fd
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 08:13:22 +0800
Tag:    v1.7.0

Typo

commit 3fb145e061455a9183a646d2dbbbc7ebcd989364
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 08:11:53 +0800
Tag:    v1.7.0

Change slighty the tests...

commit 19c8321e07ef478504f8f5ffc5154d4ae23c13c9
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 08:02:34 +0800
Tag:    v1.7.0

Now Oracle supports the first part of alter table alter column statements

commit 27bb1be29d79a24e1f2f0ab5f21553bfaa1245b6
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 08:01:02 +0800
Tag:    v1.7.0

Inserted two more test

commit 05002031d52a54857e4d4b1b3ffefb8a6ec42c1c
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 05:30:36 +0800
Tag:    v1.7.0

adding some more tests

commit 1934b522360e9824c49266fd5dfba13f11d96ae5
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 05:29:31 +0800
Tag:    v1.7.0

adding support for some more options

commit 8e895ae5c73a7bb4c6844b6518c7c568fc6fcb27
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 05:28:16 +0800
Tag:    v1.7.0

mark rename table as not implemented

commit 0e9e0b3bb3e0aef2010f810fa688a1644c315cc9
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 05:24:51 +0800
Tag:    v1.7.0

adding support for alter columns (not finished yet)

commit f8c485b071d0e91da1497cb1dadf8ecb0f9c121b
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 05:23:05 +0800
Tag:    v1.7.0

mysql alter table alter column is "modify column"

commit c282203d84f1c0b38c07ef39e409428f8e3177d1
Author: stronk7 <stronk7>
Date:   Sun, 24 Sep 2006 05:22:02 +0800
Tag:    v1.7.0

mssql doesn't support default clause in alter table alter column

commit b8547480b7c7158bbc50f29ab665a2b5c3090523
Author: stronk7 <stronk7>
Date:   Sat, 23 Sep 2006 17:37:53 +0800
Tag:    v1.7.0

Moving a bunch of database module fields to NULLable (http://docs.moodle.org/en/XMLDB_Problems#NOT_NULL_fields_using_a_DEFAULT_.27.27_clause)

commit 2a2905fb6f3f05048cf09472c59dae9b1e021083
Author: stronk7 <stronk7>
Date:   Sat, 23 Sep 2006 04:05:44 +0800
Tag:    v1.7.0

Now using ADOdb standard transactions. Some day, we should switch to Smart Transactions (http://phplens.com/adodb/tutorial.smart.transactions.html) as they autodetect errors and are nestable and easier to write

commit 0700134df5885fa704c710be1b9f79d5c83e346b
Author: stronk7 <stronk7>
Date:   Sat, 23 Sep 2006 01:23:09 +0800
Tag:    v1.7.0

Detect Oracle Database Encoding in order to set CFG->unicodedb properly

commit 4feeadeb59daf3f69657af33e7a01a0a681aae79
Author: stronk7 <stronk7>
Date:   Sat, 23 Sep 2006 00:16:48 +0800
Tag:    v1.7.0

Minor fix to be able to drop tables without prefix properly (adodb_log)

commit 37a785985569fc3cd374f638212c9b034b116d0c
Author: stronk7 <stronk7>
Date:   Fri, 22 Sep 2006 23:46:40 +0800
Tag:    v1.7.0

mini-bump

commit 0e1412cea5430bc63da70d33e65d7efc62d6f244
Author: stronk7 <stronk7>
Date:   Fri, 22 Sep 2006 23:43:42 +0800
Tag:    v1.7.0

Now cache_text->formattedtext is a longtext again. (both PG and the UTF8 migration script were working with it as text, so impact should be minimal)

commit d4b86c90dc8b37bc23d4e06737873b91efa27edd
Author: stronk7 <stronk7>
Date:   Fri, 22 Sep 2006 18:15:51 +0800
Tag:    v1.7.0

Fixed bug about all chars being created with length 255. Penny found this!

commit 373dc4406b19b067f028a3366864194291208dc7
Author: stronk7 <stronk7>
Date:   Fri, 22 Sep 2006 17:54:02 +0800
Tag:    v1.7.0

Killing some not needed references

commit cac97946d6b00bc9572140836e34cab2f7190156
Author: stronk7 <stronk7>
Date:   Fri, 22 Sep 2006 07:00:45 +0800
Tag:    v1.7.0

adjusting breadcrumb separator...

commit 94e65cc36caed787c2f118c2f856c3e22813e51a
Author: stronk7 <stronk7>
Date:   Fri, 22 Sep 2006 02:30:50 +0800
Tag:    v1.7.0

Now all the insert_record() and update_record() calls under Oracle DB use the oracle_dirty_hack() function to transform empty strings into something different ' ' in order to avoid the problems with the empty=NULL stupid norm of Oracle.

commit 85f101fa269ba93c324afd6ec738c2a5330dd8bb
Author: stronk7 <stronk7>
Date:   Fri, 22 Sep 2006 01:18:56 +0800
Tag:    v1.7.0

SQL ANDs mus be, always, "AND" tongueout

commit d7d05cf2f33f2aaf7e560327dd5608095bec6735
Author: stronk7 <stronk7>
Date:   Fri, 22 Sep 2006 01:09:28 +0800
Tag:    v1.7.0

SQL ORs must be, always, "OR"

commit 7f5f956cf50a5fd6c9f008ba74793989c660de6f
Author: stronk7 <stronk7>
Date:   Fri, 22 Sep 2006 01:04:28 +0800
Tag:    v1.7.0

Allow to specify NULL clauses for some generators, mainly because some mssql drivers use to create everything as NOT NULL by default.

commit db33348f53bd9048409c85b2c580e30ab487c827
Author: stronk7 <stronk7>
Date:   Thu, 21 Sep 2006 18:04:49 +0800
Tag:    v1.7.0

When journal to assignment migration is performed, journal upgrade hasn't been upgraded yet so the journal_entries->comment field is still called "comment"

commit 0bc94c999017afbad47935f09c5afcf3d5627c16
Author: stronk7 <stronk7>
Date:   Thu, 21 Sep 2006 17:54:00 +0800
Tag:    v1.7.0

Last reserved word is out now! journal_entries->comment to entrycomment

commit ea6432fede9f28e177cb9234a3faac5b5cc61329
Author: stronk7 <stronk7>
Date:   Thu, 21 Sep 2006 17:35:20 +0800
Tag:    v1.7.0

Moved assignment_submission->comment to submissioncomment (because comment is DB reserved word)

commit 0ce61c841fc33fccf74ff32b83183eb1cdc7dff8
Author: stronk7 <stronk7>
Date:   Thu, 21 Sep 2006 15:44:56 +0800
Tag:    v1.7.0

Force ANSI NULLs under mssql. It's not critical to work but it avoids some problems when changing nullability of fields in the future.

commit db8bd7a66f94fb1a5a3a18004fc504e16d2b3719
Author: stronk7 <stronk7>
Date:   Thu, 21 Sep 2006 06:36:21 +0800
Tag:    v1.7.0

Now XMLDB installation is enabled! Old mysql.php and postgres7.php can continue being used as previously until we finish all the required DDL functions.

commit 8e6a09bd2bb7b5ed17952c2afd9b7afd06691b11
Author: stronk7 <stronk7>
Date:   Thu, 21 Sep 2006 06:03:45 +0800
Tag:    v1.7.0

Updated comment... mixed

commit 1b25502133ac4574084a220ac7baa49b4f546248
Author: stronk7 <stronk7>
Date:   Thu, 21 Sep 2006 06:00:49 +0800
Tag:    v1.7.0

Forcing ADODB_FETCH_ASSOC explicity now for any DB.

commit a6e017286926c069f56679f51f6eee9d75d42c9c
Author: stronk7 <stronk7>
Date:   Thu, 21 Sep 2006 00:22:19 +0800
Tag:    v1.7.0

renaming question_dataset_items->number to itemnumber (reserved word) and question->commentarytext to question->generalfeedback

commit f0b50bbe89e168f1681fdf40bf78db6801ccd0be
Author: stronk7 <stronk7>
Date:   Wed, 13 Sep 2006 06:58:04 +0800
Tag:    v1.7.0

Now the "AFTER" clause is supported by add_field()

commit 48c2be79bede1f51f3ce46febd8ee92994c888b5
Author: stronk7 <stronk7>
Date:   Wed, 13 Sep 2006 06:56:52 +0800
Tag:    v1.7.0

Now we support to use the previous attribute in fields declaration

commit f521d32b716cb212f872174d8de805aeb8a60e0c
Author: stronk7 <stronk7>
Date:   Wed, 13 Sep 2006 06:23:00 +0800
Tag:    v1.7.0

Two new functions added: add_field() and drop_field()

commit 12bda5832f9bf28de1ac824fcf057c92676112c4
Author: stronk7 <stronk7>
Date:   Wed, 13 Sep 2006 06:21:51 +0800
Tag:    v1.7.0

Two more tests added: add_field() and drop_field()

commit 0bd921db9e40fbfa05366b2db8c5d416861df6e5
Author: stronk7 <stronk7>
Date:   Wed, 13 Sep 2006 06:20:50 +0800
Tag:    v1.7.0

Added support for add_field and drop_field

commit 0dd87cfa7a35fa71e39de7c54ded962e2ffd14bc
Author: stronk7 <stronk7>
Date:   Wed, 13 Sep 2006 06:15:44 +0800
Tag:    v1.7.0

Delete one trailing comma

commit 3ab2610037e11da73eab9e0175709e05f1bfde0d
Author: stronk7 <stronk7>
Date:   Wed, 13 Sep 2006 06:15:00 +0800
Tag:    v1.7.0

Added functions to retrieve the proper add and drop field SQL.

commit d256743c5bba946a0e7974d349b8566297df72e1
Author: stronk7 <stronk7>
Date:   Wed, 13 Sep 2006 06:13:45 +0800
Tag:    v1.7.0

When dropping columns, look for check constraints and drop them too.

commit ec68af222e1581b0cef47f49280b4cb6b31b78b4
Author: stronk7 <stronk7>
Date:   Wed, 13 Sep 2006 05:30:13 +0800
Tag:    v1.7.0

Ops, forgot to delete some debug... mixed

commit 2a0284176284d86a2b6584deb4f455be15ad28e1
Author: stronk7 <stronk7>
Date:   Wed, 13 Sep 2006 05:24:03 +0800
Tag:    v1.7.0

MSSQL needs to drop the default constraint before being able to drop the column

commit 3be91b01b69ad5d27996f6beaef35efa3586acf4
Author: stronk7 <stronk7>
Date:   Wed, 13 Sep 2006 01:45:25 +0800
Tag:    v1.7.0

Added support for add_field, drop_field and rename_field PHP code generation.

commit cb78437d6442fb5c59b1cadfb59997c8bae28281
Author: stronk7 <stronk7>
Date:   Wed, 13 Sep 2006 01:41:22 +0800
Tag:    v1.7.0

Changed some PHP comments.

commit 88bf02130812584e548d38f0c8467c14555a24df
Author: stronk7 <stronk7>
Date:   Wed, 13 Sep 2006 00:45:46 +0800
Tag:    v1.7.0

Fixed buggy condition. Now defaults are properly calculated by getPHP()

commit 9a96282f2cb6f4579d3330af0d8f57cdd1b01b39
Author: stronk7 <stronk7>
Date:   Tue, 12 Sep 2006 23:24:41 +0800
Tag:    v1.7.0

Added rss_client->shared

commit 8b9b510961d589c6f561ad80da63ddfb8852eda5
Author: stronk7 <stronk7>
Date:   Tue, 12 Sep 2006 23:19:10 +0800
Tag:    v1.7.0

adding the user_lastaccess table

commit 05483f73674cece9b552e66c41836f0674b5cee4
Author: stronk7 <stronk7>
Date:   Tue, 12 Sep 2006 06:08:26 +0800
Tag:    v1.7.0

And one more string...

commit eafc2b70e876a64561013c226c1166f45f6cafa7
Author: stronk7 <stronk7>
Date:   Tue, 12 Sep 2006 06:06:35 +0800
Tag:    v1.7.0

Some more improvements. Not finished yet.

commit 5f7053955ae224b13c05ab4520a5b8bb077bc30e
Author: stronk7 <stronk7>
Date:   Mon, 11 Sep 2006 23:51:13 +0800
Tag:    v1.7.0

Some new strings to display PHP code.

commit a05452e9423363a7515b050ab1defaeafe29fa45
Author: stronk7 <stronk7>
Date:   Mon, 11 Sep 2006 23:38:51 +0800
Tag:    v1.7.0

teachergraded belongs to workshop_assessments, not to workshop. wink

commit c8e4134bc9d55588a964203285f2e6b6533921a2
Author: stronk7 <stronk7>
Date:   Mon, 11 Sep 2006 23:33:51 +0800
Tag:    v1.7.0

teachergraded belongs to workshop_assessments, not to workshop_submissions wink

commit c5a6ae177aad25711fed0e27f8058da7ab15abe7
Author: stronk7 <stronk7>
Date:   Mon, 11 Sep 2006 21:15:36 +0800
Tag:    v1.7.0

Initial verion. Not working yep but I needed to send it now.

commit 2ebd5967646b577bf8830cbc90b5fdb964709906
Author: stronk7 <stronk7>
Date:   Mon, 11 Sep 2006 05:05:55 +0800
Tag:    v1.7.0

Avoid one minor error when tables hasn't comments to be defined.

commit a84634a1d48f82268ce497a5351f755ad55a2537
Author: stronk7 <stronk7>
Date:   Mon, 11 Sep 2006 02:53:47 +0800
Tag:    v1.7.0

improved display of errors...

commit 7ac75a8f617535c7d633cd97d801e378e5ca9056
Author: stronk7 <stronk7>
Date:   Mon, 11 Sep 2006 02:43:51 +0800
Tag:    v1.7.0

tests are tests

commit 091789788fa1131d9603fa9619d0c978fcb6bde3
Author: stronk7 <stronk7>
Date:   Mon, 11 Sep 2006 02:42:23 +0800
Tag:    v1.7.0

Linking to the tests from the main page.

commit f4bb0ad8f7e952add1c1aa2e592979aab84c1bb4
Author: stronk7 <stronk7>
Date:   Mon, 11 Sep 2006 02:41:34 +0800
Tag:    v1.7.0

Adding support for tests of DDL statements within the XMLDBEditor

commit 83a78d9d170696316da8e5c4c611ec8c790d75d1
Author: stronk7 <stronk7>
Date:   Mon, 11 Sep 2006 02:37:57 +0800
Tag:    v1.7.0

PHPDoc update.

commit b8359f7965bcec30a1b41d4badb91fe45aeaf645
Author: stronk7 <stronk7>
Date:   Mon, 11 Sep 2006 02:36:50 +0800
Tag:    v1.7.0

Adding options for continue and feedback to all the DDL functions.

commit d6745c7087ad4d0d5cb97b1b4e2b1458ce95f2f1
Author: stronk7 <stronk7>
Date:   Sat, 09 Sep 2006 21:53:52 +0800
Tag:    v1.7.0

Now we are using the new sql_order_by_text() function when we need to be able to order by TEXT columns in a cross-db behaviour. More info: http://docs.moodle.org/en/XMLDB_Problems#ORDER_BY_text_columns

commit 5f45d2ae803911712b11f1219dba7a29ace4d8f2
Author: stronk7 <stronk7>
Date:   Sat, 09 Sep 2006 21:51:40 +0800
Tag:    v1.7.0

New function sql_order_by_text() to automatically build custom expresions to being used in ORDER BY clauses with TEXT columns.

commit ccfc5ecca17542e4e6bc0e577a35d07f34410f29
Author: stronk7 <stronk7>
Date:   Sat, 09 Sep 2006 03:28:03 +0800
Tag:    v1.7.0

Only send contexts to cache if the aren't empty. At initial installations some empty contexts were being cached and used later, causing insertion of null values to every DB but MySQL.

commit 3a27bb05758c2ec7f232ee7b09aa7a742f800011
Author: stronk7 <stronk7>
Date:   Fri, 08 Sep 2006 07:50:47 +0800
Tag:    v1.7.0

Modify a bunch of INSERTs to avoid using empty fields to allow Oracle to avoid the NULLs = empty problem.

commit e20d180c11534a2ae0e8652774078f2c130834e6
Author: stronk7 <stronk7>
Date:   Fri, 08 Sep 2006 07:48:48 +0800
Tag:    v1.7.0

DIRTY HACK to convert back all the ' ' (1 space) field contents back to '' (empty string) in order to allow Oracle to work, more or less until all the not real NOT NULL DEFAULT '' fields were out!

commit 42ac3ecffcf2d236a8a51affd8a9353c9313c79f
Author: stronk7 <stronk7>
Date:   Fri, 08 Sep 2006 04:17:46 +0800
Tag:    v1.7.0

Solving one string concatenation typo (please, test it's ok) and stripping the AS keyword from table aliases. You cand find more at: http://docs.moodle.org/en/XMLDB_Problems#Table_and_column_aliases_-_the_AS_keyword

commit 3a8c55c3fb339a4c6e744feca009402410a63aac
Author: stronk7 <stronk7>
Date:   Fri, 08 Sep 2006 02:39:43 +0800
Tag:    v1.7.0

Typos + drop table fully supported.

commit 8830218f532b0ddc5a040f12d3b7c5bd82febd64
Author: stronk7 <stronk7>
Date:   Fri, 08 Sep 2006 01:28:46 +0800
Tag:    v1.7.0

Initial support for DROP TABLE adedd.

commit 8bb7147620c21f88573303b268558d1ce52e0359
Author: stronk7 <stronk7>
Date:   Fri, 08 Sep 2006 01:25:06 +0800
Tag:    v1.7.0

If one course, hasn't teaches, both under roles and no-roles installations, default to admin language.

commit 05a43ba36ce0103ae4f5c6f24f1c97c55b42f2c8
Author: stronk7 <stronk7>
Date:   Thu, 07 Sep 2006 07:05:12 +0800
Tag:    v1.7.0

Initial RenameTable caller to generators. Not ended by I needed it in CVS now.

commit d05babe9139eef808593fe6451fa4ec06646cbc4
Author: stronk7 <stronk7>
Date:   Thu, 07 Sep 2006 07:04:13 +0800
Tag:    v1.7.0

Initial, unfinished, not working, simple version of rename_table generator. More coming soon, but I needed it in CVS now!

commit 386c23c9dade711dffaabfbb3627280d2e5c83ca
Author: stronk7 <stronk7>
Date:   Thu, 07 Sep 2006 06:34:09 +0800
Tag:    v1.7.0

PHP code for dropping and renaming tables added. Note that the DDL functions doesn't exist yet. wink

commit 3ab430fbc50bff06f02c3817a54930bbe2192d1f
Author: stronk7 <stronk7>
Date:   Thu, 07 Sep 2006 03:49:13 +0800
Tag:    v1.7.0

The XMLDBEditor is generating automatic PHP code for create_table

commit aed4e5271340863c364acdba02c26839161c26f2
Author: stronk7 <stronk7>
Date:   Thu, 07 Sep 2006 03:47:50 +0800
Tag:    v1.7.0

Now indexes are able to return their PHP specs.

commit 989a41af6f3cf33963ce6e83704139c06163c0a7
Author: stronk7 <stronk7>
Date:   Thu, 07 Sep 2006 03:43:38 +0800
Tag:    v1.7.0

Now keys are able to return their PHP specs.

commit 7b31a94e08f818a4eed4e90a6b195929951bc5ce
Author: stronk7 <stronk7>
Date:   Thu, 07 Sep 2006 03:31:03 +0800
Tag:    v1.7.0

Now fields are able to return their PHP specs.

commit 428aa337b8b53086d2f9671d6b7a9b5d1806d8fc
Author: stronk7 <stronk7>
Date:   Wed, 06 Sep 2006 23:30:11 +0800
Tag:    v1.7.0

Disable regexp searches for MSSQL and Oracle

commit 8289a52ff08969675082f16609ba28ed956a0993
Author: stronk7 <stronk7>
Date:   Wed, 06 Sep 2006 23:29:26 +0800
Tag:    v1.7.0

Now forum searches are working both under MSSQL and Oracle (in a case-sensitive behaviour for Oracle, see code comments and http://docs.moodle.org/en/XMLDB_Problems#Case-insensitive_searches)

commit 9eabd190c1a635fe0726116c3c18ad6f5bfbb7a0
Author: stronk7 <stronk7>
Date:   Wed, 06 Sep 2006 06:37:56 +0800
Tag:    v1.7.0

Now forum_get_discussions() is using $limitfrom and $limitnum

commit b66458257d8abccb671509f98e64e4cf0b0fe417
Author: stronk7 <stronk7>
Date:   Wed, 06 Sep 2006 06:31:13 +0800
Tag:    v1.7.0

Adding support for MSSQL and Oracle in this select. Not really sure why we need one OUTER join there, if every discussion has one usermodified but.....not time now.

commit 3c4f35e6451319251cbee1873d2ed2f0a53aa44e
Author: stronk7 <stronk7>
Date:   Wed, 06 Sep 2006 05:42:20 +0800
Tag:    v1.7.0

Mark as deprecated the sql_paging_limit_function()

commit 93a89227fd169cdf314bbfbe49e2c8aa04a20a86
Author: stronk7 <stronk7>
Date:   Wed, 06 Sep 2006 05:40:17 +0800
Tag:    v1.7.0

One less use of old LIMIT clause. Now logs are working properly.

commit 5de6e614d42c23bf47312ba962bc9b48493cca33
Author: stronk7 <stronk7>
Date:   Wed, 06 Sep 2006 03:04:33 +0800
Tag:    v1.7.0

No need to specify DISTINCT because u.* guarantees unique ids. Also, DISTINCT clauses cannot be used with TEXT/BINARY columns on MSSQL and Oracle.

commit 405bc45cf6899d9320d2156ee188896cea918159
Author: stronk7 <stronk7>
Date:   Wed, 06 Sep 2006 03:01:41 +0800
Tag:    v1.7.0

No need to specify DISTINCT because u.* guaranties distinct by id.

commit 270643ca7286cd8a3eef512d1f561622578d209a
Author: stronk7 <stronk7>
Date:   Wed, 06 Sep 2006 02:57:37 +0800
Tag:    v1.7.0

Modified get_users_by_capability() call to use the new limit parameters and cleanup a bit of code.

commit 0441764040ea7ceb2ae20edb1357cc80616b42a2
Author: stronk7 <stronk7>
Date:   Wed, 06 Sep 2006 02:55:16 +0800
Tag:    v1.7.0

Changed the get_users_by_capability() function to work with 1.7 DB compatible limit sentences.

commit 3c242a66f5a5f86bebf361db277d9b02148f4c95
Author: stronk7 <stronk7>
Date:   Wed, 06 Sep 2006 02:53:08 +0800
Tag:    v1.7.0

Now get_records_sql() supports limitfrom and limitnum. Required to kill all those hardcoded LIMIT x,y clauses.

commit e4697bf7dcea8b86c81ce2b740c6d000281fe21d
Author: stronk7 <stronk7>
Date:   Wed, 06 Sep 2006 02:06:53 +0800
Tag:    v1.7.0

Both Oracle and MSSQL don't like double quotes for literals.

commit bc942ab58ab2bc0fc9aba408fa1ca53079f73ee4
Author: stronk7 <stronk7>
Date:   Wed, 06 Sep 2006 01:55:59 +0800
Tag:    v1.7.0

Added support to retrofit tables without prefix

commit 415280bfc36e7686802d989451f8e7246926f90e
Author: stronk7 <stronk7>
Date:   Wed, 06 Sep 2006 01:20:24 +0800
Tag:    v1.7.0

Added the adodb_logsql table to the XMLDB schema. It's a bit exceptional because it hasn't prefix and originaly it hasn't any PK, although we have added it here to be more Moodle-like. Tested and seems to work properly with the new field.

commit 2e2a396ca364a4c0c3aee046c2182d15d5974893
Author: stronk7 <stronk7>
Date:   Wed, 06 Sep 2006 01:17:49 +0800
Tag:    v1.7.0

Added to the generators the ability of prevent adding prefix for some tables. (needed by adodb_logsql)

commit 88ab6ab46bc2a8ab71825457f4881b225498519b
Author: stronk7 <stronk7>
Date:   Wed, 06 Sep 2006 00:09:15 +0800
Tag:    v1.7.0

Deleted duplicate table label2 from XMLDB schema

commit ea7f147ef58a22cd1c5470b7f394fae504ae89da
Author: stronk7 <stronk7>
Date:   Wed, 06 Sep 2006 00:04:50 +0800
Tag:    v1.7.0

Now the sessions2 table is UTF8 migrated ok.

commit ccda38e5210584996977318d6c36bf5888d7479c
Author: stronk7 <stronk7>
Date:   Tue, 05 Sep 2006 06:45:12 +0800
Tag:    v1.7.0

Don't use db_lowercase() anymore.

commit 6b4b356f826c1d101878be2718c2ef7032d96ef1
Author: stronk7 <stronk7>
Date:   Tue, 05 Sep 2006 06:42:56 +0800
Tag:    v1.7.0

Using the standard sql_as() function, although it could be not used.

commit 95f610334e0c7727f4740de52281244404c2d341
Author: stronk7 <stronk7>
Date:   Tue, 05 Sep 2006 06:40:42 +0800
Tag:    v1.7.0

Mark two functions as deprecated because that's standard now.

commit fda5418401d7c98f36711aeda2f07f3fc58cefbe
Author: stronk7 <stronk7>
Date:   Tue, 05 Sep 2006 06:30:56 +0800
Tag:    v1.7.0

$CFG required.

commit 010f2a3977ddc369dd57e4519c5fedefd3381121
Author: stronk7 <stronk7>
Date:   Tue, 05 Sep 2006 06:17:28 +0800
Tag:    v1.7.0

Typo! sad

commit bf05229983409a2b2b22994a117b30406b85dc69
Author: stronk7 <stronk7>
Date:   Tue, 05 Sep 2006 06:16:30 +0800
Tag:    v1.7.0

MSSQL only runs under UTF8 (with the correct ODBTP driver, of course)

commit 94ef00f3bbdc4f246aec52854bd8900df7961248
Author: stronk7 <stronk7>
Date:   Tue, 05 Sep 2006 06:05:58 +0800
Tag:    v1.7.0

MSSQL and Oracle don't want DISTINCT clauses over TEXT/BINARY fields. In this case, we simply delete it because SELECT g.* guarantees unique records to be retrieved by the first field.

commit fea43a7f5185226ef7df49e2f6e0e8349787f969
Author: stronk7 <stronk7>
Date:   Tue, 05 Sep 2006 05:12:37 +0800
Tag:    v1.7.0

Casting $course->modinfo to string prevents one notice to be showed when it's null, returning false as desired.

commit 0703d22ede550c163cd303168b0252e7cd3b301b
Author: stronk7 <stronk7>
Date:   Tue, 05 Sep 2006 04:37:27 +0800
Tag:    v1.7.0

One less reserved word. glossary->comment is out!

commit d0d5525d93895ecafbe3253b7acf84b4f56f28db
Author: stronk7 <stronk7>
Date:   Tue, 05 Sep 2006 03:33:27 +0800
Tag:    v1.7.0

Included course/lib.php to be able to rebuild_course_cache() It was working until some time ago, but now it's required.

commit 71db9136fb4e690ce1c154a59eaffdb08b8b537f
Author: stronk7 <stronk7>
Date:   Tue, 05 Sep 2006 03:27:53 +0800
Tag:    v1.7.0

Now the temp backup directory is properly created/cleaned and indexes info are properly stored there.

commit dcb8916f2d26985a0e254a94bba6455782542310
Author: stronk7 <stronk7>
Date:   Mon, 04 Sep 2006 06:32:14 +0800
Tag:    v1.7.0

notice() should be allowed at install/upgrade. It stops the whole process without need to do it. Changed to notify().

commit 446a78cd4a279b63389f008c18fbc479604c375b
Author: stronk7 <stronk7>
Date:   Mon, 04 Sep 2006 06:30:13 +0800
Tag:    v1.7.0

notice() should be allowed at install/upgrade. It stops the whole process without need to do it. Changed to notify()

commit 56b4d70d586f5c77446cff27107dcec689274943
Author: stronk7 <stronk7>
Date:   Mon, 04 Sep 2006 05:43:37 +0800
Tag:    v1.7.0

typo wink

commit afc36fdf2ee2bc3be7215d2f3cb9c58f10550740
Author: stronk7 <stronk7>
Date:   Mon, 04 Sep 2006 04:16:24 +0800
Tag:    v1.7.0

Patch submitted by Ethem:

commit 71c143f41e3e58bfb8571c770200ac74a395b5b6
Author: stronk7 <stronk7>
Date:   Mon, 04 Sep 2006 03:20:01 +0800
Tag:    v1.7.0

The custom function to convert the user table hasn't to drop/create indexes anymore. It's handled automatically by the main utf8 script.

commit 763989c0d64159bdad0fe7406c69221fec13b533
Author: stronk7 <stronk7>
Date:   Mon, 04 Sep 2006 03:18:00 +0800
Tag:    v1.7.0

Now, the UTF8 migration doesn't rely one indexes specified in the .xml files. Instead, for each table, it fetches all the existing indexes from db, drop them all and, after utf-8 conversion, rebuilds them.

commit 4762bff7a38cc39fdae32ddbc2f218c4b3bce214
Author: stronk7 <stronk7>
Date:   Mon, 04 Sep 2006 01:56:34 +0800
Tag:    v1.7.0

Added the feedback attribute to the execute_sql_arr() function.

commit de48394039666f78993c348c7beafbc54a9457f2
Author: stronk7 <stronk7>
Date:   Sun, 03 Sep 2006 23:33:42 +0800
Tag:    v1.7.0

Prevent NULL fields in 1.7 to become NOT NULL after the UTF-8 migration process.

commit 623942afff68d7862d9dd9a3160480558634a279
Author: stronk7 <stronk7>
Date:   Sun, 03 Sep 2006 07:52:55 +0800
Tag:    v1.7.0

Allowinng tables to create fields/keys/indexes using the one-pass-setters

commit 76fd4736238f5e55f4af04e04dc90775c6a637a8
Author: stronk7 <stronk7>
Date:   Sun, 03 Sep 2006 07:51:39 +0800
Tag:    v1.7.0

Added one-pass-setters for fields/keys/indexes.

commit cb62712c6d92c8d85cf49e21c0a186ad95102b7a
Author: stronk7 <stronk7>
Date:   Sun, 03 Sep 2006 07:49:02 +0800
Tag:    v1.7.0

Added some used strings

commit 4dc4dde9e22506c5f2fed3762cb4cd9c31cad38c
Author: stronk7 <stronk7>
Date:   Sun, 03 Sep 2006 07:48:02 +0800
Tag:    v1.7.0

First implementation of the create_table() function. Simple.

commit 228d8c20d71f17642113967c4e7f5fc69bb828fc
Author: stronk7 <stronk7>
Date:   Sun, 03 Sep 2006 07:46:43 +0800
Tag:    v1.7.0

New function execute_sql_arr() to execute arrays of statements, Used by ddllib.php mainly.

commit b0c7d558931aa52adf9a314dc03a623d173c1dce
Author: stronk7 <stronk7>
Date:   Sun, 03 Sep 2006 07:44:06 +0800
Tag:    v1.7.0

Skeleton of the view_php helper.

commit 3430fb299378b3f0ff9322c8e69bb0c9ec12d06d
Author: stronk7 <stronk7>
Date:   Sun, 03 Sep 2006 07:40:13 +0800
Tag:    v1.7.0

Only launch the old upgrade if it exists. It doesn'texist for new DB flavours and modules.

commit ec87d0474f8b9add32f8b7861cf81e51e93c3632
Author: stronk7 <stronk7>
Date:   Sun, 03 Sep 2006 07:38:16 +0800
Tag:    v1.7.0

Don't asume that table and column exist in the migration process. Just to avoid some warnings.

commit 1331745826732b0ded9b467e9c362bdaba63638a
Author: stronk7 <stronk7>
Date:   Sun, 03 Sep 2006 06:37:38 +0800
Tag:    v1.7.0

course_sections->summary and course_sections->sequence can be NULLable (experimenting....)

commit 803b4eeffeaea3da29bc42695e09f1903c6bbd7c
Author: stronk7 <stronk7>
Date:   Sat, 02 Sep 2006 18:04:22 +0800
Tag:    v1.7.0

Now, not null fields are respected by the UTF-8 migration process. Also, for those NULLable fields, if the default was '', convert it to null (i.e. disable de default).

commit 681ba47a59b8cdccd41032b661d5d338449dda84
Author: stronk7 <stronk7>
Date:   Sat, 02 Sep 2006 02:41:30 +0800
Tag:    v1.7.0

Only mysql and postgresql show the UTF-8 migration message.

commit d32d63b6e00a82e8560efc618ddd974d29ba05d2
Author: stronk7 <stronk7>
Date:   Sat, 02 Sep 2006 02:33:19 +0800
Tag:    v1.7.0

Now record_exists_sql() uses the cross-db limit implementation.

commit 0be16c1d8c74fcf46e5bc2447bf4082448a8d3db
Author: stronk7 <stronk7>
Date:   Sat, 02 Sep 2006 02:24:09 +0800
Tag:    v1.7.0

mssql doesn't support aliases nor position numbers in the GROUP BY clause. Just columns and expressions.

commit 8351e29517541858a914a518322dac0f4040c3e4
Author: stronk7 <stronk7>
Date:   Sat, 02 Sep 2006 01:45:02 +0800
Tag:    v1.7.0

Introduced one function to calculate the proper "AS" keyword for columns. All DB seems to support it but PostgreSQL require it!

commit e9f02dafcaf7ecf3d558cb594eb50e97dde413ed
Author: stronk7 <stronk7>
Date:   Fri, 01 Sep 2006 23:36:49 +0800
Tag:    v1.7.0

New md5key fields and associated indexes. Now hotpot should be 100% cross-db. Thanks Gordon!

commit 5f941d12abffca672942dd87e9b4cd0122fde9ee
Author: stronk7 <stronk7>
Date:   Fri, 01 Sep 2006 07:31:36 +0800
Tag:    v1.7.0

user->description can be NULLable (experimenting....)

commit 9b99c05f106c757db27c2a8d4329448f332418da
Author: stronk7 <stronk7>
Date:   Fri, 01 Sep 2006 07:20:47 +0800
Tag:    v1.7.0

user->description can be NULLable (experimenting....)

commit 6c76032bc17f30dcd53fbc3955050585d19c6cb5
Author: stronk7 <stronk7>
Date:   Fri, 01 Sep 2006 07:17:23 +0800
Tag:    v1.7.0

course_categories->description can be NULLable (experimenting....)

commit 1d39207fae2e99830ed3417db6200cc78d27c0f7
Author: stronk7 <stronk7>
Date:   Fri, 01 Sep 2006 07:04:15 +0800
Tag:    v1.7.0

course_categories->description can be NULLable (experimenting....)

commit 17c911375254522df64deaf84132096969e59f75
Author: stronk7 <stronk7>
Date:   Fri, 01 Sep 2006 06:42:04 +0800
Tag:    v1.7.0

This condition was preventing new installs sometimes

commit a0abf36ddda28359b3fa4abdcac40fe05b1d8d9e
Author: stronk7 <stronk7>
Date:   Fri, 01 Sep 2006 06:33:18 +0800
Tag:    v1.7.0

This condition was preventing new installs sometimes.

commit 545196c55f7b54dc0ca9ffaca6398020c0dcf610
Author: stronk7 <stronk7>
Date:   Fri, 01 Sep 2006 03:42:22 +0800
Tag:    v1.7.0

course->modinfo nullable and no default

commit 99215f2c6fac6e5f266830de3d212ee7568ab5e5
Author: stronk7 <stronk7>
Date:   Fri, 01 Sep 2006 03:39:18 +0800
Tag:    v1.7.0

modinfo nullable and without default.

commit a974b5a4d89e79d315a9510434e20539649ddfd3
Author: stronk7 <stronk7>
Date:   Fri, 01 Sep 2006 00:59:29 +0800
Tag:    v1.7.0

course->modinfo can be NULLable (experimenting....)

commit 4782a1f8bc54a25962d0af07e16b93fd8923bbec
Author: stronk7 <stronk7>
Date:   Thu, 31 Aug 2006 08:19:57 +0800
Tag:    v1.7.0

Minor modifications to oci8po generator (max 38 for number)

commit 790647b9500fbb470200cbf02ad3f0f3e55d3878
Author: stronk7 <stronk7>
Date:   Thu, 31 Aug 2006 08:02:06 +0800
Tag:    v1.7.0

Block plugin tables can use the XMLDB install & upgrade

commit 1164af7cf512e76fe5da37b83c858efbaa0cc650
Author: stronk7 <stronk7>
Date:   Thu, 31 Aug 2006 07:18:29 +0800
Tag:    v1.7.0

Block core blocks tables can use the XMLDB install & upgrade

commit 015e946d980a449c3ca6c3468b616da23763812c
Author: stronk7 <stronk7>
Date:   Thu, 31 Aug 2006 07:13:43 +0800
Tag:    v1.7.0

Small rework of the main install/upgrade script. Everything should continue working as before.

commit 94ab72f8b014a81c8b40df707d3dfaf1400e249c
Author: stronk7 <stronk7>
Date:   Thu, 31 Aug 2006 04:41:37 +0800
Tag:    v1.7.0

Now backup tables can use the XMLDB install & upgrade

commit 450cf307ea31a3c0fcb8e60292b5ba18a24c77cf
Author: stronk7 <stronk7>
Date:   Thu, 31 Aug 2006 04:27:29 +0800
Tag:    v1.7.0

Triple "l" were preventing new installations to be executed for plugins.

commit 7c006e345a0eaf168bd54a864e9c828158054fc9
Author: stronk7 <stronk7>
Date:   Thu, 31 Aug 2006 04:13:46 +0800
Tag:    v1.7.0

Minor separations...

commit e79a09a259f153c5fef5b316a9e3e50714af3a6a
Author: stronk7 <stronk7>
Date:   Thu, 31 Aug 2006 03:52:16 +0800
Tag:    v1.7.0

Now plugins (qtypes and enrols) can use the XMLDB install & upgrade

commit 81465066c22011c482f68cddc3a73b78589cc93d
Author: stronk7 <stronk7>
Date:   Thu, 31 Aug 2006 01:17:39 +0800
Tag:    v1.7.0

Just "normalizing" index names inside the XMLDBEditor. Not critical but... Following rule 1.3 from: http://docs.moodle.org/en/XMLDB_Defining_one_XML_structure#Conventions

commit 2813c04ba995d7ede2275b798c870135d1022bb3
Author: stronk7 <stronk7>
Date:   Thu, 31 Aug 2006 01:14:57 +0800
Tag:    v1.7.0

One new error string added.

commit b4f3a93b01af73f01e3d1617edd069c4970da0f8
Author: stronk7 <stronk7>
Date:   Thu, 31 Aug 2006 01:12:00 +0800
Tag:    v1.7.0

Improve save file, showing the proper error if not writeable.

commit 393e7cc373827bb7cb96603c7f9f6531f6582ec8
Author: stronk7 <stronk7>
Date:   Thu, 31 Aug 2006 00:14:44 +0800
Tag:    v1.7.0

where BIG should be LONG...

commit 914597ee9f992a7c96290666347eb34830cbcb81
Author: stronk7 <stronk7>
Date:   Thu, 31 Aug 2006 00:06:16 +0800
Tag:    v1.7.0

...where = should be == ...

commit 13c2ed64101b235443586bc6046851b20b03561d
Author: stronk7 <stronk7>
Date:   Wed, 30 Aug 2006 08:11:36 +0800
Tag:    v1.7.0

Removing DTD and XMLSchema. It's under lib/xmldb

commit 758537ef2a920a0dbff7410c46791d253b53fd45
Author: stronk7 <stronk7>
Date:   Wed, 30 Aug 2006 08:10:08 +0800
Tag:    v1.7.0

relative+cleaned paths

commit ee7de32ea3b2674c02940f410ad91cddaa6efa02
Author: stronk7 <stronk7>
Date:   Wed, 30 Aug 2006 07:53:46 +0800
Tag:    v1.7.0

relative+cleaned paths

commit fc3221015d321f0c6140dbb21dd78b2f18847b58
Author: stronk7 <stronk7>
Date:   Wed, 30 Aug 2006 07:45:08 +0800
Tag:    v1.7.0

relative+cleaned paths

commit 2a05e8257155db7f6db79ef2a2d15c426f8a4b9b
Author: stronk7 <stronk7>
Date:   Wed, 30 Aug 2006 07:33:55 +0800
Tag:    v1.7.0

relative+cleaned paths

commit 68905e201b676d5cddde4377ee06b9c8aed80167
Author: stronk7 <stronk7>
Date:   Wed, 30 Aug 2006 07:29:28 +0800
Tag:    v1.7.0

relative+cleaned paths

commit 8f5b5e4f685e9d11f1d67ad214b5ece50add2172
Author: stronk7 <stronk7>
Date:   Wed, 30 Aug 2006 07:20:03 +0800
Tag:    v1.7.0

relative+cleaned paths

commit 2af2711f796a2e531dc83dd239e672635a3ece4d
Author: stronk7 <stronk7>
Date:   Wed, 30 Aug 2006 06:45:46 +0800
Tag:    v1.7.0

relative+cleaned paths

commit d81f3415cadf1852de1e961cacd12d57afc94657
Author: stronk7 <stronk7>
Date:   Wed, 30 Aug 2006 06:26:57 +0800
Tag:    v1.7.0

relative+cleaned paths

commit 077505db10c2d107809433e07fdcdb7c24542ac9
Author: stronk7 <stronk7>
Date:   Wed, 30 Aug 2006 06:21:13 +0800
Tag:    v1.7.0

cleaned paths

commit 115a73653a60cdd21ff64e00bf05b5002805c21b
Author: stronk7 <stronk7>
Date:   Wed, 30 Aug 2006 06:17:25 +0800
Tag:    v1.7.0

relative+cleaned paths

commit a0da32e935a298641a8ec7619e598128f3da118b
Author: stronk7 <stronk7>
Date:   Wed, 30 Aug 2006 05:57:40 +0800
Tag:    v1.7.0

Moving getEndedStatements() to the propef function.

commit fd6a294ff6928a83c29945ee064d7c0c6d843400
Author: stronk7 <stronk7>
Date:   Wed, 30 Aug 2006 05:26:46 +0800
Tag:    v1.7.0

relative+cleaned paths

commit 4317fe985e964f3f7aed7f45bfd086888653ad02
Author: stronk7 <stronk7>
Date:   Wed, 30 Aug 2006 05:07:59 +0800
Tag:    v1.7.0

relative+cleaned paths

commit c080aa88d7c06dcf5d77eb3144223a4d010b1260
Author: stronk7 <stronk7>
Date:   Wed, 30 Aug 2006 04:50:44 +0800
Tag:    v1.7.0

relative+cleaned paths

commit a19903681069d6f317f890613bfdff6779999e32
Author: stronk7 <stronk7>
Date:   Wed, 30 Aug 2006 03:27:34 +0800
Tag:    v1.7.0

Now the "created" field is refreshed always in the main list.

commit 840391757edcb7d052106562f59ff60d48693054
Author: stronk7 <stronk7>
Date:   Tue, 29 Aug 2006 05:33:03 +0800
Tag:    v1.7.0

Initial commit of XMLEditor langpack.

commit 8c15ae995867862aadc140ac07df1a3307493c6d
Author: stronk7 <stronk7>
Date:   Tue, 29 Aug 2006 03:50:57 +0800
Tag:    v1.7.0

Moving all the XMLDB stuff from contrib to head. Go, go, go...

commit 683ff5d4f3f4ea07af3d01ab62d037e12f565d2c
Author: stronk7 <stronk7>
Date:   Tue, 29 Aug 2006 00:20:52 +0800
Tag:    v1.7.0

Dropping forum.open and forum.assesspublic (mimic from .sql files)

commit ba05965e5c886010f2278c6c569db32548ab73a2
Author: stronk7 <stronk7>
Date:   Mon, 28 Aug 2006 23:47:45 +0800
Tag:    v1.7.0

Messages about missing functions in old and new upgrade are showed only if the corresponding file exists.

commit b477a2f1665c9aef2763e7304fed0475958bf17d
Author: stronk7 <stronk7>
Date:   Mon, 28 Aug 2006 23:21:41 +0800
Tag:    v1.7.0

Changing one wrong previous value.

commit 716332e68b5976ef58b8116ea5ea8b89258be4f1
Author: stronk7 <stronk7>
Date:   Mon, 28 Aug 2006 06:31:02 +0800
Tag:    v1.7.0

Added support to SQL generation of statements

commit 9dbc13db9a3f0d28f5bdabefb8d548598a927c25
Author: stronk7 <stronk7>
Date:   Mon, 28 Aug 2006 06:25:41 +0800
Tag:    v1.7.0

Concat operator for mysql added

commit b96aaad1251d6dc34165ddb4fd8742b2778dfdf3
Author: stronk7 <stronk7>
Date:   Mon, 28 Aug 2006 06:24:09 +0800
Tag:    v1.7.0

Concat operator for mssql added

commit a75636b7eded43ee5e51d07171d0ad63f3281b63
Author: stronk7 <stronk7>
Date:   Mon, 28 Aug 2006 06:22:23 +0800
Tag:    v1.7.0

Added support to SQL generation of statements

commit efd1e2032d67849b448a99b309b9a2f65f6dc315
Author: stronk7 <stronk7>
Date:   Mon, 28 Aug 2006 05:59:04 +0800
Tag:    v1.7.0

Added support to SQL generation of install INSERTs

commit 3655a6b39f8b0faa3f21ff6d08ba357912c92d8e
Author: stronk7 <stronk7>
Date:   Mon, 28 Aug 2006 05:57:33 +0800
Tag:    v1.7.0

Set magic_quotes_sybase for both mssql and oci8po. Anyway, this isn't enough and if must be defined in php.ini or .htaccess, because GPC are added BEFORE this setting has effect so they are slashed with the default char.

commit de64b6c69e67d3607c4b826283fe02848a65da8e
Author: stronk7 <stronk7>
Date:   Mon, 28 Aug 2006 05:52:22 +0800
Tag:    v1.7.0

modify stripslashes_safe() to work properly under magic_quotes_sybase (both addslashes and stripslashes do it properly based on the setting)

commit d1c21c8f31ca55c71a6bdad8ba60c26b16143213
Author: stronk7 <stronk7>
Date:   Sun, 27 Aug 2006 17:02:41 +0800
Tag:    v1.7.0

Very, very, very, very initial support of insert_record for oracle. I shouldn't interfere with the rest at all. I needed it in CVS now.

commit d6eb06b60ba9e998ad8a96937319e9a263829a54
Author: stronk7 <stronk7>
Date:   Sun, 27 Aug 2006 17:00:23 +0800
Tag:    v1.7.0

Initial commit supporting install/upgrade inder XMLDB.

commit f2e0049dec61be0a265f5623e1111b3c05324ff3
Author: stronk7 <stronk7>
Date:   Sun, 27 Aug 2006 16:58:09 +0800
Tag:    v1.7.0

Just remove one condition previously checked.

commit b8851b80ebc52e562208bf432d54ec3f0e044c9d
Author: stronk7 <stronk7>
Date:   Sun, 27 Aug 2006 16:52:51 +0800
Tag:    v1.7.0

Cache names for improved speed in long iterations requesting the same name thousands of times. Prepare Oracle Sequnces for the insert_record function.

commit c8a418b8d607891f6590413565f5e90b92d8b1b0
Author: stronk7 <stronk7>
Date:   Sat, 26 Aug 2006 08:50:09 +0800
Tag:    v1.7.0

Max for decimal type in MSSQL is 38 cc.

commit 7e8f922047e5c8b8615b815dd7ac947b539bc3e5
Author: stronk7 <stronk7>
Date:   Sat, 26 Aug 2006 08:08:11 +0800
Tag:    v1.7.0

Adding back the first column in the recordset, that is out after GetAssoc(), in order to:

commit 09942a5ec2fb81dc394a11de00e86508023fee23
Author: stronk7 <stronk7>
Date:   Sat, 26 Aug 2006 01:11:43 +0800
Tag:    v1.7.0

PGs doubles are caller DOUBLE PRECISION

commit c049e98881c57470ad761cbee408476e3aa91295
Author: stronk7 <stronk7>
Date:   Sat, 26 Aug 2006 01:02:49 +0800
Tag:    v1.7.0

Indexes on text fields are not allowed

commit a5ea2dc334d01df7e3928df6be99b8df00411642
Author: stronk7 <stronk7>
Date:   Sat, 26 Aug 2006 01:02:04 +0800
Tag:    v1.7.0

Solved one wrong field declaration in lesson_grades

commit c779eb1a159fcbb709bf606747970cddb1bd7d61
Author: stronk7 <stronk7>
Date:   Fri, 25 Aug 2006 06:27:11 +0800
Tag:    v1.7.0

Added support for the new upgrade system for main tables.

commit 2acf462dd965c8f7aeb61e096777c144efe14f7a
Author: stronk7 <stronk7>
Date:   Fri, 25 Aug 2006 00:57:39 +0800
Tag:    v1.7.0

Renamed column question_sessions->comment at Eloy's request since comment is a DB reserved word. (mimic from sql files) Thanks Tim! cool

commit 81abf109717616d5b9318c1eba7e08b8ad267643
Author: stronk7 <stronk7>
Date:   Fri, 25 Aug 2006 00:54:02 +0800
Tag:    v1.7.0

MDL-5969 Let multiple choice questions have feedback that does not depend on the chosen answer (mimic from old sql files)

commit 454adccfa906b54de547fa2d5fb9b6c18d5a74e5
Author: stronk7 <stronk7>
Date:   Wed, 23 Aug 2006 23:23:53 +0800
Tag:    v1.7.0

Adding one PHP close tag that has been missing (but working) since years!

commit 860b55463fd106f3c0f51ffb9d8537e0c83175e7
Author: stronk7 <stronk7>
Date:   Wed, 23 Aug 2006 06:10:09 +0800
Tag:    v1.7.0

Normalizing a bit all the float/double generators.

commit 962f8a9b4e5c92265d1c779aee985ec861d67394
Author: stronk7 <stronk7>
Date:   Wed, 23 Aug 2006 05:55:20 +0800
Tag:    v1.7.0

quiz_feedback added to XMLDB

commit 8792c165897c3933e848e4e9a8fa14c1741134e0
Author: stronk7 <stronk7>
Date:   Wed, 23 Aug 2006 05:44:07 +0800
Tag:    v1.7.0

Small typo. wink

commit 598dc3a99cff725ea3aee8ec69cfd42c8ce3dfaa
Author: stronk7 <stronk7>
Date:   Wed, 23 Aug 2006 05:19:52 +0800
Tag:    v1.7.0

Change rule to tzrule (reserved word)

commit 7970cce9f41355cf3bbd3495fe85e96f8ff56cd2
Author: stronk7 <stronk7>
Date:   Wed, 23 Aug 2006 04:11:33 +0800
Tag:    v1.7.0

Updated using tzdata2006j

commit c0fe3453ef4029ea9e1c141ded7634896eeafe5e
Author: stronk7 <stronk7>
Date:   Wed, 23 Aug 2006 04:10:54 +0800
Tag:    v1.7.0

Change rule to tzrule (reserved word)

commit 2efaf3f8ab97d8986be3dce4467a2aab687d836c
Author: stronk7 <stronk7>
Date:   Wed, 23 Aug 2006 00:39:14 +0800
Tag:    v1.7.0

One trick to allow pseudo-null Oracle insertions. Let's see what happen.

commit 93d2c55ffc83be8d1668ea27cf6bc1efe061cacc
Author: stronk7 <stronk7>
Date:   Wed, 23 Aug 2006 00:15:44 +0800
Tag:    v1.7.0

Standard naming now user FOUR char for tables (to avoid avoid some potential duplicates)

commit 5cf36b39b1d69d8ffdfcbdc4c7953ec9a8a441d5
Author: stronk7 <stronk7>
Date:   Tue, 22 Aug 2006 03:10:21 +0800
Tag:    v1.7.0

Solved hh (horrible-hidden) bug in backup_scheduled code. Credits go to Thirot Jean-Luc. http://moodle.org/mod/forum/discuss.php?d=52156

commit 28f6c41d450e5f3728944894e2b4f747e5b16620
Author: stronk7 <stronk7>
Date:   Mon, 21 Aug 2006 22:59:48 +0800
Tag:    v1.7.0

Changed level (reserved word) to aggregatelevel.

commit 88534572c3c602449a485fc6aaecdd2281113b27
Author: stronk7 <stronk7>
Date:   Mon, 21 Aug 2006 20:28:46 +0800
Tag:    v1.7.0

Reducing the list of MSSQL reserved words to the efectively reserved words (the previous list included a lot of words reserved by SQLXX standars but not by MSSQL)

commit c8f85eeebaf6c6f9dd921db16b1b812082d6cf9c
Author: stronk7 <stronk7>
Date:   Mon, 21 Aug 2006 20:04:48 +0800
Tag:    v1.7.0

Reducing the list of PG reserved words to the efectively reserved words (the previous list included a lot of words reserved by SQLXX standars but not by PG)

commit 0513f3bfa526dec212d95ff0a55d6b25b665d66b
Author: stronk7 <stronk7>
Date:   Mon, 21 Aug 2006 05:56:54 +0800
Tag:    v1.7.0

$statement_end for Oracle changed to "/" because standard ; causes problems with trigger generation

commit 73bb7f8db077366cb69f5ee009a81760dbc898c5
Author: stronk7 <stronk7>
Date:   Mon, 21 Aug 2006 02:22:48 +0800
Tag:    v1.7.0

Setting some ADOdb variables properly and calling to the new configure_dbconnection() function to set DB encoding and other preliminar settings.

commit d086d854a8efd4917ede576ec2abd01d19df7248
Author: stronk7 <stronk7>
Date:   Mon, 21 Aug 2006 02:21:33 +0800
Tag:    v1.7.0

Added the configure_dbconnection() function to be executed after DB conection. Responsible to set a lot of things (charsets, dbsession variables...)

commit f9543de627b93964dd8c4ef3a864e0e08ad64425
Author: stronk7 <stronk7>
Date:   Mon, 21 Aug 2006 02:19:50 +0800
Tag:    v1.7.0

Since PostgreSQL 7.4 the precision given for float columsn is the number of bits to use, and not the number of decimals. So, based on the number of decimals from the XMLDB schema, we are going to create REAL (<6 decimals) or DOUBLE PRECISION (>=6) columns.

commit 16f07ff2b0ea8fa3ee55f1c4c65824cbab465ae5
Author: stronk7 <stronk7>
Date:   Mon, 21 Aug 2006 02:03:55 +0800
Tag:    v1.7.0

MySQL doesn't like any name on its primary keys (neither "primary")

commit c412278140dd20f5549ecd8778fa5733b716a33f
Author: stronk7 <stronk7>
Date:   Mon, 21 Aug 2006 02:01:50 +0800
Tag:    v1.7.0

Although difficult, now all the key/index/sequence/trigger names are quoted if they are reserved words

commit 134e3128bb66be1ca91adac43a8b4c644325ac90
Author: stronk7 <stronk7>
Date:   Sun, 20 Aug 2006 23:50:27 +0800
Tag:    v1.7.0

Added the install_from_xmldb_file() function that loads, transform and execute one entire XMLDB file into the correct SQL sentences.

commit 420f683619b58cc930d02d70dc3bc9da265358e9
Author: stronk7 <stronk7>
Date:   Sun, 20 Aug 2006 19:20:40 +0800
Tag:    v1.7.0

Core tables XMLDB installation is now working. Disabled by default until fully working.

commit 293bccd539ad2908378453edf2ef23a038aff3a4
Author: stronk7 <stronk7>
Date:   Sun, 20 Aug 2006 17:37:56 +0800
Tag:    v1.7.0

First commit for the progressive adoption of ADODB's SelectLimit() function in order to support LIMIT clauses in a cross-db compatible way. Changes don't affect old sentences at all (all them would be changed soon too).

commit 465a8029378e8bd5fc7b7b15d2864db2cb169019
Author: stronk7 <stronk7>
Date:   Sat, 19 Aug 2006 08:58:30 +0800
Tag:    v1.7.0

Thought this was commited. Solve one bug in trigger generation

commit 7e13be0887e32c64aa165c051483f09676975273
Author: stronk7 <stronk7>
Date:   Sat, 19 Aug 2006 06:56:08 +0800
Tag:    v1.7.0

Splitting datalib.php in three libraries:   - ddllib.php: Where all the DDL (install/upgrade) functions will be.   - dmllib.php: Where all the DML (select...) functions will be.   - datalib.php: Legacy lib. Its contents should go to other libraries soon. For more info see: http://docs.moodle.org/en/XMLDB_Roadmap (point 1)

commit 1bf63d33c875b8c14174407f46ea9be4e6c9f8b5
Author: stronk7 <stronk7>
Date:   Fri, 18 Aug 2006 03:40:49 +0800
Tag:    v1.7.0

Oracle automatically builds UIXs for UKs

commit 9dcc6300a7b13b363f3625e6703b3aad81f63e2f
Author: stronk7 <stronk7>
Date:   Fri, 18 Aug 2006 03:20:45 +0800
Tag:    v1.7.0

Now all the XMLDBxxx->geSQL functions return an array of statements to be executed (easily to handle them in the installation/upgrade process individually. Also, it's possible to specify one statement end.

commit de16da7293def017d074974bd1ce6872d9798eee
Author: stronk7 <stronk7>
Date:   Fri, 18 Aug 2006 03:16:07 +0800
Tag:    v1.7.0

adding role_allow_assign , role_allow_override table and dropping role_deny_grant

commit 4d00e5e4ecf4af4de80333992b46bbb4a605491e
Author: stronk7 <stronk7>
Date:   Fri, 18 Aug 2006 00:59:39 +0800
Tag:    v1.7.0

Now admin includes all the required ddllib stuff

commit 46d42a3cc522d2116f519a5225b6414c30ed8de1
Author: stronk7 <stronk7>
Date:   Fri, 18 Aug 2006 00:59:14 +0800
Tag:    v1.7.0

Now ddllib includes all the required xmldb stuff

commit b7bc9446a993aa326ee15fe7b487b3fbef81383e
Author: stronk7 <stronk7>
Date:   Fri, 18 Aug 2006 00:40:46 +0800
Tag:    v1.7.0

Added JS template field for JavaScript if needed.

commit 6c11ad54d8e9f40789168020c9581cc835a2b974
Author: stronk7 <stronk7>
Date:   Thu, 17 Aug 2006 08:31:23 +0800
Tag:    v1.7.0

UNIQUE KEY is UNIQUE

commit 848caec8c2560c2b3aac6fd7e09efb7d9c920d76
Author: stronk7 <stronk7>
Date:   Thu, 17 Aug 2006 08:16:34 +0800
Tag:    v1.7.0

Now we are able to generate all the module SQL (any RDBMS) with one simple function call (final inserts are missing yet)

commit f075bac4f70d44c9220f65ff080984509076f7fd
Author: stronk7 <stronk7>
Date:   Thu, 17 Aug 2006 07:45:18 +0800
Tag:    v1.7.0

Bah, Oracle requires the default clause BEFORE the not null clause.

commit 6aa7885eb554b8ae095909e8c2383a91f078c980
Author: stronk7 <stronk7>
Date:   Thu, 17 Aug 2006 07:17:28 +0800
Tag:    v1.7.0

Minor adjustments to some comments.

commit ada5648103e591e471c9ae4524f425c805666f8d
Author: stronk7 <stronk7>
Date:   Thu, 17 Aug 2006 07:01:46 +0800
Tag:    v1.7.0

Fixing some potential problems with prefixes and object names.

commit d7444bfce3cf2b4c0eec67228d07cfdef452fd28
Author: stronk7 <stronk7>
Date:   Thu, 17 Aug 2006 06:58:51 +0800
Tag:    v1.7.0

Initial commit of oci8po generator

commit 866c0747e8ac08c482a6ffc794e75c39d52589dc
Author: stronk7 <stronk7>
Date:   Thu, 17 Aug 2006 06:23:39 +0800
Tag:    v1.7.0

Line feed added + small bug

commit d7bf5f991722f3109d0d274ee9a07d2b773f2fc0
Author: stronk7 <stronk7>
Date:   Thu, 17 Aug 2006 05:46:08 +0800
Tag:    v1.7.0

Initial version of the mssql generator

commit 2ad7da9beccb7bf19375afff19ea7f191c869cac
Author: stronk7 <stronk7>
Date:   Thu, 17 Aug 2006 02:41:47 +0800
Tag:    v1.7.0

Initial version of the postgres7 generator

commit 0c82f279c6b5821d987eac7fbbd51db89322219f
Author: stronk7 <stronk7>
Date:   Thu, 17 Aug 2006 02:37:33 +0800
Tag:    v1.7.0

Added one more configuration parameter to disable inline SQL to be added in enum column lines

commit aacf02c55b2f1c979ae0b22b85e083b9612ed058
Author: stronk7 <stronk7>
Date:   Thu, 17 Aug 2006 01:53:24 +0800
Tag:    v1.7.0

Proper parent init and comment close

commit 6caad5177da686b3028b8c2ec8b443741a2f2133
Author: stronk7 <stronk7>
Date:   Thu, 17 Aug 2006 01:51:49 +0800
Tag:    v1.7.0

Minor change to do proper create table close

commit e54ae5264b04e2a2e52a7f2e18806a0706f5ec1b
Author: stronk7 <stronk7>
Date:   Thu, 17 Aug 2006 01:43:55 +0800
Tag:    v1.7.0

Partial rework of the mysql generator. Working now.

commit 1f0872e8ba93289317e026ec78f3892eefb173df
Author: stronk7 <stronk7>
Date:   Thu, 17 Aug 2006 01:34:46 +0800
Tag:    v1.7.0

Changed one default

commit 91496d15bc4e28a07c012b2e903a58d8a7b60a75
Author: stronk7 <stronk7>
Date:   Thu, 17 Aug 2006 01:28:41 +0800
Tag:    v1.7.0

Initial commit of the base generator class.

commit 54121a7921afcd11a30d2419b36dda1ebc5e7011
Author: stronk7 <stronk7>
Date:   Thu, 17 Aug 2006 00:06:37 +0800
Tag:    v1.7.0

permission has to be signed integer in mysql. Mimic from sql files

commit edc8779b92ed89b1cfecc15e04c71018a3c5ee2b
Author: stronk7 <stronk7>
Date:   Tue, 15 Aug 2006 19:30:32 +0800
Tag:    v1.7.0

Latest changes, nothing important.

commit 82b7ceb568f23fd0543beeb6b9861371a1e892fe
Author: stronk7 <stronk7>
Date:   Tue, 15 Aug 2006 18:15:52 +0800
Tag:    v1.7.0

Just adding support for reserved words....

commit 8165877a1729d798b9fbc1288890bbe4ae3caffb
Author: stronk7 <stronk7>
Date:   Tue, 15 Aug 2006 17:14:31 +0800
Tag:    v1.7.0

Initial commit on HEAD of all the XMLDB stuff.

commit f11bf817010e67e057e77461402e96227f2aaec2
Author: stronk7 <stronk7>
Date:   Tue, 15 Aug 2006 17:08:17 +0800
Tag:    v1.7.0

Initial commit of the ddllib (to perform DDL operations)

commit 6750328ba042b891ed768ab7dbb7865a570ed499
Author: stronk7 <stronk7>
Date:   Sun, 13 Aug 2006 07:03:59 +0800
Tag:    v1.7.0

Latest changes added + some polish in keys.

commit d236d4f577937613311c7d47c8834c89d54acc78
Author: stronk7 <stronk7>
Date:   Sun, 13 Aug 2006 06:26:05 +0800
Tag:    v1.7.0

Initial version of the XMLDB file for this plugin

commit 9bd4d98bc2223883b99cb541e3172880386e8b30
Author: stronk7 <stronk7>
Date:   Sun, 13 Aug 2006 06:19:10 +0800
Tag:    v1.7.0

Initial version of the XMLDB file for this plugin

commit 42173f51216a530cab387d54522b6089a3eff550
Author: stronk7 <stronk7>
Date:   Sun, 13 Aug 2006 05:41:46 +0800
Tag:    v1.7.0

Initial version of the XMLDB file for this plugin

commit 6f398232e6184897aaefe88c17c3f36b57cb5fd9
Author: stronk7 <stronk7>
Date:   Sun, 13 Aug 2006 05:40:30 +0800
Tag:    v1.7.0

Added une foreign+unique key

commit 615b4a13914e4623b9ec8e9b9d20ce222684d3d3
Author: stronk7 <stronk7>
Date:   Sat, 12 Aug 2006 17:14:40 +0800
Tag:    v1.7.0

An example of how one unitialized variable can generate really dificult-to-trace bugs. Thanks to Jens Gammelgaard and support  cool (http://moodle.org/bugs/bug.php?op=show&bugid=6233)

commit 613f306d1d68aaf826d8b6ccf26cced0dc2fa928
Author: stronk7 <stronk7>
Date:   Sat, 12 Aug 2006 03:29:47 +0800
Tag:    v1.7.0

XMLDB schema initial commit for the quiz module. Some doubts are pending to finish it properly.

commit b08eda731b8778beed6e058550e019bb1586017e
Author: stronk7 <stronk7>
Date:   Sat, 12 Aug 2006 02:41:39 +0800
Tag:    v1.7.0

Added one FK (recursive) to course_categories

commit 49025df359896598da9e48790e096bcb16c3e8e7
Author: stronk7 <stronk7>
Date:   Sat, 12 Aug 2006 02:36:47 +0800
Tag:    v1.7.0

Added one comment about recursive FK for the future.

commit 401846cca779bfe6f9331aa75a48482998ee9ee2
Author: stronk7 <stronk7>
Date:   Sat, 12 Aug 2006 01:56:18 +0800
Tag:    v1.7.0

XMLDB schema initial commit for the lesson module

commit a2a4bfc5674fc11a0634cb723f3757524438677d
Author: stronk7 <stronk7>
Date:   Sat, 12 Aug 2006 01:39:38 +0800
Tag:    v1.7.0

XMLDB schema initial commit for the lams module

commit e0996851dac5cc60c0b50971851dcc37fc1d344e
Author: stronk7 <stronk7>
Date:   Sat, 12 Aug 2006 01:37:17 +0800
Tag:    v1.7.0

XMLDB schema initial commit for the label module

commit 01c3c5596046ec8221b07f95ea9d0eb8d8175f91
Author: stronk7 <stronk7>
Date:   Sat, 12 Aug 2006 01:31:11 +0800
Tag:    v1.7.0

Oops, filled now. I forgot to save changes before commit.

commit 4121848035b596e2cbd846b3a50d8d9e98457579
Author: stronk7 <stronk7>
Date:   Sat, 12 Aug 2006 01:29:47 +0800
Tag:    v1.7.0

XMLDB schema initial commit for the journal module

commit 540c65ba43702c5bc0f8bd0739e314712e219be6
Author: stronk7 <stronk7>
Date:   Sat, 12 Aug 2006 01:24:55 +0800
Tag:    v1.7.0

XMLDB schema initial commit for the hotpot module

commit 2bf10cbf7b3bba996de0d3a830cbf4ff9a491a9f
Author: stronk7 <stronk7>
Date:   Sat, 12 Aug 2006 01:11:46 +0800
Tag:    v1.7.0

XMLDB schema initial commit for the glossary module

commit b72bed89da7a853f7df1cf8f14e004145294195e
Author: stronk7 <stronk7>
Date:   Sat, 12 Aug 2006 00:45:45 +0800
Tag:    v1.7.0

Give some more chars to enum fields.

commit d7a4f74ede4a31141ed8c41b668bf006bb62784f
Author: stronk7 <stronk7>
Date:   Sat, 12 Aug 2006 00:35:11 +0800
Tag:    v1.7.0

XMLDB schema initial commit for forum module

commit f1b20469128eeeb148f89e06498f34a134970016
Author: stronk7 <stronk7>
Date:   Fri, 11 Aug 2006 17:48:35 +0800
Tag:    v1.7.0

Changing //TRANSLIT to //IGNORE because some weird bug in the OS iconv libraries was breaking some texts.

commit c7b39f473704d5e42d3bd1cb4c78f66ae7f62abb
Author: stronk7 <stronk7>
Date:   Fri, 11 Aug 2006 01:12:00 +0800
Tag:    v1.7.0

XMLDB schema initial commit for exercise module

commit a1bdf659addda8d23ea31f7bad38a459536fd1b3
Author: stronk7 <stronk7>
Date:   Thu, 10 Aug 2006 17:25:52 +0800
Tag:    v1.7.0

Adding latest changes, FKs and indexes.

commit 433a13bc22300ed6d528659c78ace8c3b0abe701
Author: stronk7 <stronk7>
Date:   Wed, 09 Aug 2006 23:45:27 +0800
Tag:    v1.7.0

index2fk performed

commit 388e9ab212468166c4ce9e8c2d0fdf4464e81c57
Author: stronk7 <stronk7>
Date:   Wed, 09 Aug 2006 19:56:02 +0800
Tag:    v1.7.0

One more FK in blocks system.

commit 9c642ecacb8f19bcafc29d24e6498bab254cc2ff
Author: stronk7 <stronk7>
Date:   Wed, 09 Aug 2006 01:00:44 +0800
Tag:    v1.7.0

Initial XMLDB schema for data tables. Using FKs where they are obvious.

commit 305ebf6849eb6ef8ba968f1a5c356f79d51f4bfc
Author: stronk7 <stronk7>
Date:   Wed, 09 Aug 2006 01:00:03 +0800
Tag:    v1.7.0

Initial XMLDB schema for choice tables. Using FKs where they are obvious.

commit 14e1b02e684ed9e340e5a0627d4452f4b2e64418
Author: stronk7 <stronk7>
Date:   Wed, 09 Aug 2006 00:59:35 +0800
Tag:    v1.7.0

Initial XMLDB schema for chat tables. Using FKs where they are obvious.

commit 5a1d835487558bf9d76eb14c17a8516fb6143ee8
Author: stronk7 <stronk7>
Date:   Tue, 08 Aug 2006 17:04:55 +0800
Tag:    v1.7.0

Adding some unsigned keywords here and there and implementing role tables

commit 2bcd1697757640e972ae32b16d4951c468acba3c
Author: stronk7 <stronk7>
Date:   Tue, 08 Aug 2006 03:47:03 +0800
Tag:    v1.7.0

Hack to link from the admin interface to the XMLDB editor.

commit ab8bfc7eee7f9fe83b3b7414ea9eca092dd29e2e
Author: stronk7 <stronk7>
Date:   Tue, 08 Aug 2006 03:45:02 +0800
Tag:    v1.7.0

Two new strings to display the XMLDB editor under the admin page.

commit cbd645bf96db7f77e511fc1c0888d1c3d0915bcf
Author: stronk7 <stronk7>
Date:   Tue, 08 Aug 2006 03:02:46 +0800
Tag:    v1.7.0

Initial commit of assignment XMLDB file. Stopping now from now. Going to document things...

commit e80d52526d520a106b7bce77ed3789012db7710e
Author: stronk7 <stronk7>
Date:   Tue, 08 Aug 2006 02:52:27 +0800
Tag:    v1.7.0

Initial commit for enrol tables XMLDB

commit 08b6ce833d60291868e1be1d1892c8fd1b38fa5e
Author: stronk7 <stronk7>
Date:   Tue, 08 Aug 2006 02:40:37 +0800
Tag:    v1.7.0

Initial commit for rss block tables

commit 158c1b303530f8562a6e5c158f2e2fe47ae69ec7
Author: stronk7 <stronk7>
Date:   Tue, 08 Aug 2006 02:30:46 +0800
Tag:    v1.7.0

Initial commit of blocks XMLDB schema

commit a689637d0f83b2839762298438b0eaf1eb33269d
Author: stronk7 <stronk7>
Date:   Tue, 08 Aug 2006 02:02:15 +0800
Tag:    v1.7.0

Polishing a bit key and indexes names...

commit dff83d0bdcf8b540f8fcb1f5192df4857d8e0609
Author: stronk7 <stronk7>
Date:   Tue, 08 Aug 2006 01:58:19 +0800
Tag:    v1.7.0

Initial XMLDB implementation of Moodle backup tables

commit 67d7d694947ed0bec1f39f5989cc3ce4de98c1a6
Author: stronk7 <stronk7>
Date:   Tue, 08 Aug 2006 01:38:06 +0800
Tag:    v1.7.0

Initial XMLDB implementation of Moodle Core.

commit 3f5adc4af1e11e79771f16d059758f3468ee87d4
Author: stronk7 <stronk7>
Date:   Fri, 21 Jul 2006 15:56:27 +0800
Tag:    v1.7.0

Keeping this in sync with 16_STABLE

commit 8f7211fc2c5a73c48c74ba295f5af2b26b95c665
Author: stronk7 <stronk7>
Date:   Wed, 19 Jul 2006 00:35:52 +0800
Tag:    v1.7.0

minor bump to perform some changes on grade_letter

commit d272c2feb83abbc493525645b03d7382d6512626
Author: stronk7 <stronk7>
Date:   Wed, 19 Jul 2006 00:35:15 +0800
Tag:    v1.7.0

Fixing one recently added DB upgrade. Please be careful on STABLE!

commit cd58557ae00e0154fc66f77a8f02c6bef1cbd1bb
Author: stronk7 <stronk7>
Date:   Sun, 16 Jul 2006 17:01:03 +0800
Tag:    v1.7.0

Close properly the showentry page. Bug 5986. (http://moodle.org/bugs/bug.php?op=show&bugid=5986)

commit c67303bd97ba57992e17bbf93f7e52e01462535d
Author: stronk7 <stronk7>
Date:   Sat, 15 Jul 2006 16:39:50 +0800
Tag:    v1.7.0

Soled bug 6089 plus some minor iteration savings... (http://moodle.org/bugs/bug.php?op=show&bugid=6089)

commit 1a9b9a0143d0536149e5b543bbf033ed2f82e087
Author: stronk7 <stronk7>
Date:   Wed, 12 Jul 2006 01:42:21 +0800
Tag:    v1.7.0

Emulate file_put_contents() under PHP 4.3.x

commit 1cd1252752c3036d1a93600aee6e40206f70f394
Author: stronk7 <stronk7>
Date:   Sun, 25 Jun 2006 18:16:45 +0800
Tag:    v1.7.0

Some minor changes in order to avoid some notices...

commit 83c020ba20ceca9b7037c88533c72ddb036feb23
Author: stronk7 <stronk7>
Date:   Fri, 23 Jun 2006 07:39:42 +0800
Tag:    v1.7.0

Sending Yu's change to support custom langs to HEAD.

commit c17d7ead6aa487f187e1b644d18c7aa67436cb9a
Author: stronk7 <stronk7>
Date:   Tue, 20 Jun 2006 22:23:58 +0800
Tag:    v1.7.0

helper string to explain $CFG->doctonewwindow added.

commit 7038fe44bf7dbe655a0aec8174058e8f89854ab2
Author: stronk7 <stronk7>
Date:   Tue, 20 Jun 2006 21:53:09 +0800
Tag:    v1.7.0

Now docs are showed in a new window based on $CFG->doctonewwindow

commit d3b9dbad78ac44526e256e6243ef5182102d407e
Author: stronk7 <stronk7>
Date:   Tue, 20 Jun 2006 21:41:56 +0800
Tag:    v1.7.0

Added new option to decide if docs will be showed in a new window.

commit 5dd95d35e58d5edace8bc7130a35d3109415416d
Author: stronk7 <stronk7>
Date:   Sun, 11 Jun 2006 07:33:49 +0800
Tag:    v1.7.0

Due to one potential bug in PHP under Win32 (http://bugs.php.net/37775) the cntrl pcre class was breaking some chars. Changed to a safer alternative. Bug 5777. (http://moodle.org/bugs/bug.php?op=show&bugid=5777)

commit c0bd060a58c159a1d64287317dbde13229a99d81
Author: stronk7 <stronk7>
Date:   Sat, 10 Jun 2006 18:40:16 +0800
Tag:    v1.7.0

Change the moodle_strtolower() function to use textlib services. Also, mark it as deprecated, code should use text services directly. Partially, bug 5777. It continues under investigation. (http://moodle.org/bugs/bug.php?op=show&bugid=5777)

commit b944917b2e8cedb9e3a03f3b289df176ddc19bfd
Author: stronk7 <stronk7>
Date:   Fri, 09 Jun 2006 23:52:58 +0800
Tag:    v1.7.0

Automatic installer.php lang files by installer_builder (20060609)

commit 407e95edbdeb23f08d80902da9787b4dde0c58fb
Author: stronk7 <stronk7>
Date:   Fri, 09 Jun 2006 23:29:45 +0800
Tag:    v1.7.0

Automatic installer.php lang files by installer_builder (20060609)

commit f6c08703b68a858128f0463c9f772eeff59400e0
Author: stronk7 <stronk7>
Date:   Fri, 09 Jun 2006 23:11:03 +0800
Tag:    v1.7.0

Automatic installer.php lang files by installer_builder (20060609)

commit 9fd0678fddb493a3cc403e56f04b726f64b29361
Author: stronk7 <stronk7>
Date:   Fri, 09 Jun 2006 22:23:55 +0800
Tag:    v1.7.0

The absolutely incredible bug! It was working being wrong! Bug 5775. (http://moodle.org/bugs/bug.php?op=show&bugid=5775)

commit daec7cda9bb35a9e92ff0521d49c3edcb26f38ef
Author: stronk7 <stronk7>
Date:   Fri, 09 Jun 2006 18:15:03 +0800
Tag:    v1.7.0

One notice() was preventing the upgrade to 1.7dev to continue. Bug 5773. (http://moodle.org/bugs/bug.php?op=show&bugid=5773)

commit d96466d29f07365e947cf8f407e0239392de8d10
Author: stronk7 <stronk7>
Date:   Fri, 09 Jun 2006 18:04:43 +0800
Tag:    v1.7.0

Moving from lastIP to lastip everywhere. Bug 5763. (http://moodle.org/bugs/bug.php?op=show&bugid=5763)

commit d836482a34e0dd330fa5ed6bfc841bf89d6d9072
Author: stronk7 <stronk7>
Date:   Fri, 09 Jun 2006 17:47:01 +0800
Tag:    v1.7.0

Moving from lastIP to lastip everywhere. Bug 5763. (http://moodle.org/bugs/bug.php?op=show&bugid=5763)

commit c766b9dfaab3a388bfa215722b5efb0eff255567
Author: stronk7 <stronk7>
Date:   Fri, 09 Jun 2006 17:16:09 +0800
Tag:    v1.7.0

Avoid empty processing both for PLAIN_SQL_UPDATE and PHP_FUNCTION

commit cb27c4e823e0d6650d869af326780a4f7d722fe5
Author: stronk7 <stronk7>
Date:   Thu, 08 Jun 2006 06:22:21 +0800
Tag:    v1.7.0

Solve one issue with skipped courses and email to admin being set every xx minutes. Bug 5621. (http://moodle.org/bugs/bug.php?op=show&bugid=5621)

commit 8326d5afa30eae1be3d04fe39f367d7a5cc5a9fb
Author: stronk7 <stronk7>
Date:   Thu, 08 Jun 2006 01:56:47 +0800
Tag:    v1.7.0

Now the question_attempts creation and dotation will be only executed if it hasn't been done in MOODLE_16_STABLE. Bug 5717. (http://moodle.org/bugs/bug.php?op=show&bugid=5717)

commit 93e779c23690879b581f86e27dfae46cd7361db7
Author: stronk7 <stronk7>
Date:   Wed, 07 Jun 2006 01:02:19 +0800
Tag:    v1.7.0

Adding two new strings for RESTRICTED tests in environmenlib.

commit 95a39282bf7000b06f21187e143a7ae44e79056b
Author: stronk7 <stronk7>
Date:   Wed, 07 Jun 2006 00:19:17 +0800
Tag:    v1.7.0

Now environmentlib supports RESTRICT sections (to be able to deny any general test with more detail (the opposite to the BYPASS section) (http://moodle.org/bugs/bug.php?op=show&bugid=5653)

commit ee6e91d4af8bbba43da2cc65094f7ab34a2b4e86
Author: stronk7 <stronk7>
Date:   Sun, 04 Jun 2006 23:19:05 +0800
Tag:    v1.7.0

make_default_scale() now searches properly under both dataroot and dirroot, defaulting to en_utf8. Bug 5719. (http://moodle.org/bugs/bug.php?op=show&bugid=5719)

commit ae57b07c06a651ccc0460a67a289a93c67a9eb62
Author: stronk7 <stronk7>
Date:   Sun, 04 Jun 2006 08:54:34 +0800
Tag:    v1.7.0

report XXXX actions added. Bug 5714. (http://moodle.org/bugs/bug.php?op=show&bugid=5714)

commit 2efeb14832fcfe3094b0dc5c77315122cbc8e846
Author: stronk7 <stronk7>
Date:   Sun, 04 Jun 2006 08:03:12 +0800
Tag:    v1.7.0

course report xxxx actions now are supported on restore. Bug 5714. (http://moodle.org/bugs/bug.php?op=show&bugid=5714)

commit b8417225736fabd6765e8170a9abcaff7507da56
Author: stronk7 <stronk7>
Date:   Sun, 04 Jun 2006 04:37:55 +0800
Tag:    v1.7.0

icourse report xxxx actions must send courseid in the info field. Bug 5714. (http://moodle.org/bugs/bug.php?op=show&bugid=5714)

commit 410c459db0e5fc19a8e8933ea65828759b8ea79a
Author: stronk7 <stronk7>
Date:   Sun, 04 Jun 2006 04:18:02 +0800
Tag:    v1.7.0

And some more (the last) notices out! Bug 5713. (http://moodle.org/bugs/bug.php?op=show&bugid=5713)

commit 5f8556bcd51be801a2eb8dc9e217568778e3a841
Author: stronk7 <stronk7>
Date:   Sun, 04 Jun 2006 04:01:24 +0800
Tag:    v1.7.0

And one more collection of innocent notices avoided. Bug 5712. (http://moodle.org/bugs/bug.php?op=show&bugid=5712)

commit 8812e31233c38d00ca8ba41ac094aaa11e5d4af3
Author: stronk7 <stronk7>
Date:   Sun, 04 Jun 2006 03:51:28 +0800
Tag:    v1.7.0

And another notice in restore out. Bug 5711. (http://moodle.org/bugs/bug.php?op=show&bugid=5711)

commit 0f4de002a26600d2c6f509fda3c413c141eda952
Author: stronk7 <stronk7>
Date:   Sun, 04 Jun 2006 03:45:19 +0800
Tag:    v1.7.0

One less notice. Bug 5710. (http://moodle.org/bugs/bug.php?op=show&bugid=5710)

commit c1543b80e920948de7661f5b10e16699ce5433b1
Author: stronk7 <stronk7>
Date:   Sun, 04 Jun 2006 03:01:07 +0800
Tag:    v1.7.0

Avoid one notice in backup. Bug 5709. (http://moodle.org/bugs/bug.php?op=show&bugid=5709&;)

commit 1fa6d4606943b696fe6fb3b5e9f6ad4d1499fe57
Author: stronk7 <stronk7>
Date:   Sun, 04 Jun 2006 01:51:20 +0800
Tag:    v1.7.0

Adding support to the forum user report action in restore. Bug 3854. (http://moodle.org/bugs/bug.php?op=show&bugid=3854)

commit 2dbd7916e02f671435cd0d8d185aaae60d816d8f
Author: stronk7 <stronk7>
Date:   Fri, 02 Jun 2006 07:16:08 +0800
Tag:    v1.7.0

Adding propper support for the forum->user report log action. It was a bit wrong. Code credits go to Petr!

commit 9914f09319991a1a20daef892f6df7687d807bf5
Author: stronk7 <stronk7>
Date:   Thu, 01 Jun 2006 01:54:58 +0800
Tag:    v1.7.0

Prevent doubleslashes once and again in paths. Also prevent them when writing config.php

commit ae34cad5fd3349f8f60b4a1fe09ad9e6a23196b7
Author: stronk7 <stronk7>
Date:   Wed, 31 May 2006 00:58:50 +0800
Tag:    v1.7.0

Users with messages (and messages) are only included in SITEID backup. Bug 5658. (http://moodle.org/bugs/bug.php?op=show&bugid=5658)

commit aca116d84eaea9f3cdc7991e0b55cbad997c5d23
Author: stronk7 <stronk7>
Date:   Tue, 30 May 2006 06:50:44 +0800
Tag:    v1.7.0

Bump equivalent to 1.6

commit cfba5440c0a310be05170994d7a5c42dbdcbfe37
Author: stronk7 <stronk7>
Date:   Tue, 30 May 2006 01:42:01 +0800
Tag:    v1.7.0

Normalize oracle driver name.

commit 2d2f440b6ee329b269352d58c66cfa97c43c0000
Author: stronk7 <stronk7>
Date:   Tue, 30 May 2006 01:35:19 +0800
Tag:    v1.7.0

Adding environmental checks for 1.7 (mssql and oracle added)

commit cf0403002e28c008487cd098aa44ef9a0249acd3
Author: stronk7 <stronk7>
Date:   Wed, 24 May 2006 06:33:01 +0800
Tag:    v1.7.0

Solving one SQL error in data_get_participants() plus some improved readability.

commit e8b8ab9f7bf28b0397296ba03587808150b814a6
Author: stronk7 <stronk7>
Date:   Wed, 24 May 2006 06:06:58 +0800
Tag:    v1.7.0

course_modules->deleted and user->guid are now out. (they disappeared from DB ages ago)

commit b6725eba9ae398068406c54dcd764718f2a98be4
Author: stronk7 <stronk7>
Date:   Tue, 23 May 2006 01:55:38 +0800
Tag:    v1.7.0

Allowing also numbers and underscores in sessioncookie

commit 76046108e966ff220e211fbe2630c14549890196
Author: stronk7 <stronk7>
Date:   Sat, 20 May 2006 08:11:30 +0800
Tag:    v1.7.0

Ready to new functionalities...wink

commit 4a428b5f5ce05b65e088630fe9b3141cc7823a28
Author: stronk7 <stronk7>
Date:   Tue, 16 May 2006 07:31:50 +0800
Tag:    v1.7.0

Updated to latest version (1.56). Bug 5165. (http://moodle.org/bugs/bug.php?op=show&bugid=5165)

commit 0ec7502bad4fa3d8d0e0cb94fcc038646c0898f4
Author: stronk7 <stronk7>
Date:   Tue, 16 May 2006 01:54:29 +0800
Tag:    v1.7.0

Avoid namesite to appear when ADDING site activities.

commit 356183b5bdc2e1b8edccbe9efb21df2d7f15d6f5
Author: stronk7 <stronk7>
Date:   Tue, 16 May 2006 01:33:38 +0800
Tag:    v1.7.0

Changing session->data to medium text. Bug 5406. (http://moodle.org/bugs/bug.php?op=show&bugid=5406)

commit 297bb00dfe130c402f4f711b45374c306c4963a6
Author: stronk7 <stronk7>
Date:   Tue, 09 May 2006 00:40:44 +0800
Tag:    v1.7.0

Changing session->data to medium text. Bug 5406. (http://moodle.org/bugs/bug.php?op=show&bugid=5406)

commit ef668fcf99d3c50ca753fd05f3879fba5de38693
Author: stronk7 <stronk7>
Date:   Tue, 09 May 2006 00:39:34 +0800
Tag:    v1.7.0

Changing session->data to medium text. Bug 5406. (http://moodle.org/bugs/bug.php?op=show&bugid=5406)

commit 0abbbe296dcc19afeec70d5356df5e8a0440532f
Author: stronk7 <stronk7>
Date:   Mon, 08 May 2006 07:31:32 +0800
Tag:    v1.7.0

Initial revision

commit fbaea8f354bdbb5ce03bf228344708fd4e3b5203
Author: stronk7 <stronk7>
Date:   Sun, 07 May 2006 18:49:28 +0800
Tag:    v1.7.0

glossary print view is now valid XHTML.

commit 0f5f8363d728d33c4542e4575920c1c789bc41c7
Author: stronk7 <stronk7>
Date:   Sun, 07 May 2006 00:58:36 +0800
Tag:    v1.7.0

Now, when a single forum is restored and no user data was created, the initial discussion/post is automatically generated. Bug 5418. (http://moodle.org/bugs/bug.php?op=show&bugid=5418)

commit 0045d58c69993bea7dfc5aad344b0b8dd3f147cf
Author: stronk7 <stronk7>
Date:   Sat, 06 May 2006 01:56:56 +0800
Tag:    v1.7.0

Now the help link in the admin block points to Docs. Bug 4803. (http://moodle.org/bugs/bug.php?op=show&bugid=4803)

commit 4bd5bb599c39a6df8a6f62e3ecedb31407d759e8
Author: stronk7 <stronk7>
Date:   Thu, 04 May 2006 18:40:24 +0800
Tag:    v1.7.0

Anything against the ISO-8859-1 word?

commit bdeed966f6bedfdc89f8aef5f807391e28cb5dde
Author: stronk7 <stronk7>
Date:   Thu, 04 May 2006 07:48:28 +0800
Tag:    v1.7.0

Now more quiz actions are restored properly:  -preview  -start attempt  -close attempt  -continue attempt (too long. See Bug 5419) Bug 5122 (http://moodle.org/bugs/bug.php?op=show&bugid=5122)

commit 543cd3e01d3de57ffe33c03daaa2ce22bed71a3d
Author: stronk7 <stronk7>
Date:   Thu, 04 May 2006 06:05:59 +0800
Tag:    v1.7.0

Fixing some non-production values I left after testing. Thanks James!

commit ca3a9e5443edd259e697b309caaac1263fa14396
Author: stronk7 <stronk7>
Date:   Thu, 04 May 2006 03:21:10 +0800
Tag:    v1.7.0

Changing ASCII to ISO-8859-1. Also I've updated Backup FAQ Docs to show the workaround. Bug 5276. (http://moodle.org/bugs/bug.php?op=show&bugid=5276)

commit 6985c78c6b4b9d88191afa9b7daf1fa1128b4b4c
Author: stronk7 <stronk7>
Date:   Thu, 04 May 2006 02:22:21 +0800
Tag:    v1.7.0

XHTML validation. Bug 5332. (http://moodle.org/bugs/bug.php?op=show&bugid=5332)

commit 02436153e07f37ef1ff549f78973a4eae6093f32
Author: stronk7 <stronk7>
Date:   Thu, 04 May 2006 01:49:52 +0800
Tag:    v1.7.0

Solving some changes in course-view and sections...