#21 LinPHA CVS + OracleDB support

[bzrudi]

Hello,

Attach file contains update Linpha to work with oracle
database, bug fix version 1.0RC1 and others includes:

1. update from CVS from 17.07.2004.
2. NOW() sql function changed to
$GLOBALS['db']->sysTimeStamp for any databases.
3. update adodb to version 4.50.
4. string like:

if (is_array($album_info))
$album_info=array_change_key_case( $album_info);

needed to change database field names to lower case
(oracle return in UPPER case).
5. in search part added upload 'Author' nickname field to
search.
6. database fields 'date', 'comment', 'size', 'level'
they are reserved in many databases (include
oracle, mssql) renamed to 'adate', 'acomment', 'asize',
'alevel' for correct work.
7. field 'author varchar(20)' added to 'photos' table.
8. script for create oracle tables in install\oracle
directory.

PS
1. this update not included scripts for rename existing
databases fields.
2. only English lang modules updated.

Sergey.

[bzrudi]

Logged In: YES
user_id=184593

Hi all,

please download from here: (exeeds SF max patch size limit)
http://217.172.179.153/~bzrudi/downloads/linpha_oracle.zip

and say thanks to Sergey :-)

cheers bzrudi

[bzrudi]

Logged In: YES
user_id=184593
Originator: YES

LinPHA2 fixes this...