+ <default_enable/>

+

+/**

+* ownCloud - gallery application

+*

+* @author Bartek Przybylski

+* @copyright 2012 Bartek Przybylski bart.p.pl@gmail.com

+*

+* This library is free software; you can redistribute it and/or

+* modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+* License as published by the Free Software Foundation; either

+* version 3 of the License, or any later version.

+*

+* This library is distributed in the hope that it will be useful,

+* but WITHOUT ANY WARRANTY; without even the implied warranty of

+* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+* GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+*

+* You should have received a copy of the GNU Lesser General Public

+* License along with this library. If not, see <http://www.gnu.org/licenses/>.

+*

+*/

+

+

+/**

+* ownCloud - gallery application

+*

+* @author Bartek Przybylski

+* @copyright 2012 Bartek Przybylski bart.p.pl@gmail.com

+*

+* This library is free software; you can redistribute it and/or

+* modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+* License as published by the Free Software Foundation; either

+* version 3 of the License, or any later version.

+*

+* This library is distributed in the hope that it will be useful,

+* but WITHOUT ANY WARRANTY; without even the implied warranty of

+* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+* GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+*

+* You should have received a copy of the GNU Lesser General Public

+* License along with this library. If not, see <http://www.gnu.org/licenses/>.

+*

+*/

+

+

+/**

+* ownCloud - gallery application

+*

+* @author Bartek Przybylski

+* @copyright 2012 Bartek Przybylski bart.p.pl@gmail.com

+*

+* This library is free software; you can redistribute it and/or

+* modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+* License as published by the Free Software Foundation; either

+* version 3 of the License, or any later version.

+*

+* This library is distributed in the hope that it will be useful,

+* but WITHOUT ANY WARRANTY; without even the implied warranty of

+* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+* GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+*

+* You should have received a copy of the GNU Lesser General Public

+* License along with this library. If not, see <http://www.gnu.org/licenses/>.

+*

+*/

+

+require_once(OC::$CLASSPATH['OC_Gallery_Album']);

+?>

+

+/**

+* ownCloud - gallery application

+*

+* @author Bartek Przybylski

+* @copyright 2012 Bartek Przybylski bart.p.pl@gmail.com

+*

+* This library is free software; you can redistribute it and/or

+* modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+* License as published by the Free Software Foundation; either

+* version 3 of the License, or any later version.

+*

+* This library is distributed in the hope that it will be useful,

+* but WITHOUT ANY WARRANTY; without even the implied warranty of

+* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+* GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+*

+* You should have received a copy of the GNU Lesser General Public

+* License along with this library. If not, see <http://www.gnu.org/licenses/>.

+*

+*/

+

+

+/**

+* ownCloud - gallery application

+*

+* @author Bartek Przybylski

+* @copyright 2012 Bartek Przybylski bart.p.pl@gmail.com

+*

+* This library is free software; you can redistribute it and/or

+* modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+* License as published by the Free Software Foundation; either

+* version 3 of the License, or any later version.

+*

+* This library is distributed in the hope that it will be useful,

+* but WITHOUT ANY WARRANTY; without even the implied warranty of

+* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+* GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+*

+* You should have received a copy of the GNU Lesser General Public

+* License along with this library. If not, see <http://www.gnu.org/licenses/>.

+*

+*/

+

+/**

+* ownCloud - gallery application

+*

+* @author Bartek Przybylski

+* @copyright 2012 Bartek Przybylski bart.p.pl@gmail.com

+*

+* This library is free software; you can redistribute it and/or

+* modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+* License as published by the Free Software Foundation; either

+* version 3 of the License, or any later version.

+*

+* This library is distributed in the hope that it will be useful,

+* but WITHOUT ANY WARRANTY; without even the implied warranty of

+* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+* GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+*

+* You should have received a copy of the GNU Lesser General Public

+* License along with this library. If not, see <http://www.gnu.org/licenses/>.

+*

+*/

+

+OC_JSON::success(array('albums' => OC_Gallery_Scanner::scan('/')));

+

+/**

+* ownCloud - gallery application

+*

+* @author Bartek Przybylski

+* @copyright 2012 Bartek Przybylski bart.p.pl@gmail.com

+*

+* This library is free software; you can redistribute it and/or

+* modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+* License as published by the Free Software Foundation; either

+* version 3 of the License, or any later version.

+*

+* This library is distributed in the hope that it will be useful,

+* but WITHOUT ANY WARRANTY; without even the implied warranty of

+* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+* GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+*

+* You should have received a copy of the GNU Lesser General Public

+* License along with this library. If not, see <http://www.gnu.org/licenses/>.

+*

+*/

+

+

+/**

+* ownCloud - gallery application

+*

+* @author Bartek Przybylski

+* @copyright 2012 Bartek Przybylski bart.p.pl@gmail.com

+*

+* This library is free software; you can redistribute it and/or

+* modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+* License as published by the Free Software Foundation; either

+* version 3 of the License, or any later version.

+*

+* This library is distributed in the hope that it will be useful,

+* but WITHOUT ANY WARRANTY; without even the implied warranty of

+* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+* GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+*

+* You should have received a copy of the GNU Lesser General Public

+* License along with this library. If not, see <http://www.gnu.org/licenses/>.

+*

+*/

+

+OC::$CLASSPATH['OC_Gallery_Hooks_Handlers'] = 'apps/gallery/lib/hooks_handlers.php';

+

+require_once('apps/gallery/lib/hooks_handlers.php');

+ <field>

+ <name>album_path</name>

+ <type>text</type>

+ <notnull>true</notnull>

+ <length>100</length>

+ </field>

+ <version>0.2</version>

+ <author>Bartek Przybylski</author>

+ <description>Gallery application for ownCloud</description>

+ <default_enable/>

+</info>

+div#gallery_list { margin: 90pt 20pt; }

+div#gallery_list.leftcontent { padding-top: 15px; margin: 0; text-align: center; }

+div#gallery_album_box { width: 200px; text-align: center; border: 0; display: inline-block; margin: 5pt; vertical-align: top; padding: 10px; border: solid 1px black; position: relative; overflow: hidden; color: #999; }

+div#gallery_album_box:hover { color: black; }

+.leftcontent div#gallery_album_box { margin: 5px; }

+div#gallery_album_box h1 { font-size: 12pt; font-family: Verdana; }

+div#gallery_album_cover { width: 199px; height: 199px; border: solid 1pt #999; padding: 0; }

+div#gallery_control_overlay { border: 0; position:absolute; right: 10pt; background-color: #333; opacity: 0.5; visibility:hidden; padding: 0 5pt; }

+div#gallery_control_overlay a { color:white; }

+#gallery_images { padding:10px 5px; }

+

+/**

+* ownCloud - gallery application

+*

+* @author Bartek Przybylski

+* @copyright 2012 Bartek Przybylski bart.p.pl@gmail.com

+*

+* This library is free software; you can redistribute it and/or

+* modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+* License as published by the Free Software Foundation; either

+* version 3 of the License, or any later version.

+*

+* This library is distributed in the hope that it will be useful,

+* but WITHOUT ANY WARRANTY; without even the implied warranty of

+* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+* GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+*

+* You should have received a copy of the GNU Lesser General Public

+* License along with this library. If not, see <http://www.gnu.org/licenses/>.

+*

+*/

+

+ $("#notification").fadeIn();

+ $("#notification").slideDown();

+ $("#notification").fadeOut();

+ $("#notification").slideUp();

+/**

+* ownCloud - gallery application

+*

+* @author Bartek Przybylski

+* @copyright 2012 Bartek Przybylski bart.p.pl@gmail.com

+*

+* This library is free software; you can redistribute it and/or

+* modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+* License as published by the Free Software Foundation; either

+* version 3 of the License, or any later version.

+*

+* This library is distributed in the hope that it will be useful,

+* but WITHOUT ANY WARRANTY; without even the implied warranty of

+* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+* GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+*

+* You should have received a copy of the GNU Lesser General Public

+* License along with this library. If not, see <http://www.gnu.org/licenses/>.

+*

+*/

+

+ public static function create($owner, $name, $path){

+ $stmt = OC_DB::prepare('INSERT INTO *PREFIX*gallery_albums (uid_owner, album_name, album_path) VALUES (?, ?, ?)');

+ $stmt->execute(array($owner, $name, $path));

+ public static function find($owner, $name=null, $path=null){

+ }

+ if (!is_null($path)){

+ $sql .= ' AND album_path = ?';

+ $args[] = $path;

+ }

+

+

+?>

+<?php

+

+/**

+* ownCloud - gallery application

+*

+* @author Bartek Przybylski

+* @copyright 2012 Bartek Przybylski bart.p.pl@gmail.com

+*

+* This library is free software; you can redistribute it and/or

+* modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+* License as published by the Free Software Foundation; either

+* version 3 of the License, or any later version.

+*

+* This library is distributed in the hope that it will be useful,

+* but WITHOUT ANY WARRANTY; without even the implied warranty of

+* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+* GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+*

+* You should have received a copy of the GNU Lesser General Public

+* License along with this library. If not, see <http://www.gnu.org/licenses/>.

+*

+*/

+

+OC_Hook::connect("OC_Filesystem", "post_write", "OC_Gallery_Hooks_Handlers", "addPhotoFromPath");

+OC_Hook::connect("OC_Filesystem", "delete", "OC_Gallery_Hooks_Handlers", "removePhoto");

+OC_Hook::connect("OC_Filesystem", "post_rename", "OC_Gallery_Hooks_Handlers", "renamePhoto");

+

+require_once(OC::$CLASSPATH['OC_Gallery_Album']);

+require_once(OC::$CLASSPATH['OC_Gallery_Photo']);

+

+class OC_Gallery_Hooks_Handlers {

+ private static $APP_TAG = "Gallery";

+

+ private static function isPhoto($filename) {

+ OC_Log::write(self::$APP_TAG, "Checking file ".$filename." with mimetype ".OC_Filesystem::getMimeType($filename), OC_Log::DEBUG);

+ if (substr(OC_Filesystem::getMimeType($filename), 0, 6) == "image/")

+ return 1;

+ return 0;

+ }

+

+ private static function createAlbum($path) {

+ $new_album_name = trim(str_replace('/', '.', $path), '.');

+ if ($new_album_name == '')

+ $new_album_name = 'main';

+

+ OC_Log::write(self::$APP_TAG, 'Creating new album '.$new_album_name, OC_Log::DEBUG);

+ OC_Gallery_Album::create(OC_User::getUser(), $new_album_name, $path);

+

+ return OC_Gallery_Album::find(OC_User::getUser(), null, $path);

+ }

+

+ public static function addPhotoFromPath($params) {

+ if (!self::isPhoto($params['path'])) return;

+ $fullpath = $params['path'];

+ OC_Log::write(self::$APP_TAG, 'Adding file with path '. $fullpath, OC_Log::DEBUG);

+ $path = substr($fullpath, 0, strrpos($fullpath, '/'));

+ if ($path == '') $path = '/';

+ $album = OC_Gallery_Album::find(OC_User::getUser(), null, $path);

+

+ if ($album->numRows() == 0) {

+ $album = self::createAlbum($path);

+ }

+ $album = $album->fetchRow();

+ $albumId = $album['album_id'];

+ $photo = OC_Gallery_Photo::find($albumId, $fullpath);

+ if ($photo->numRows() == 0) { // don't duplicate photo entries

+ OC_Log::write(self::$APP_TAG, 'Adding new photo to album', OC_Log::DEBUG);

+ OC_Gallery_Photo::create($albumId, $fullpath);

+ }

+

+ }

+

+ public static function removePhoto($params) {

+ $path = $params['path'];

+ if (!self::isPhoto($path)) return;

+ OC_Gallery_Photo::removeByPath($path);

+ }

+

+ public static function renamePhoto($params) {

+ $olddir = substr($params['oldpath'], 0, strrpos($params['oldpath'], '/'));

+ $newdir = substr($params['newpath'], 0, strrpos($params['newpath'], '/'));

+ if ($olddir == '') $olddir = '/';

+ if ($newdir == '') $newdir = '/';

+ if (!self::isPhoto($params['newpath'])) return;

+ OC_Log::write(self::$APP_TAG, 'Moving photo from '.$params['oldpath'].' to '.$params['newpath'], OC_Log::DEBUG);

+ $album;

+ $newAlbumId;

+ $oldAlbumId;

+ if ($olddir == $newdir) {

+ // album changing is not needed

+ $album = OC_Gallery_Album::find(OC_User::getUser(), null, $olddir);

+ if ($album->numRows() == 0) {

+ $album = self::createAlbum($newdir);

+ }

+ $album = $album->fetchRow();

+ $newAlbumId = $oldAlbumId = $album['album_id'];

+ } else {

+ $newalbum = OC_Gallery_Album::find(OC_User::getUser(), null, $newdir);

+ $oldalbum = OC_Gallery_Album::find(OC_User::getUser(), null, $olddir);

+

+ if ($newalbum->numRows() == 0) {

+ $newalbum = self::createAlbum($newdir);

+ }

+ $newalbum = $newalbum->fetchRow();

+ if ($oldalbum->numRows() == 0) {

+ OC_Gallery_Photo::create($newalbum['album_id'], $params['newpath']);

+ return;

+ }

+ $oldalbum = $oldalbum->fetchRow();

+ $newAlbumId = $newalbum['album_id'];

+ $oldAlbumId = $oldalbum['album_id'];

+

+ }

+ OC_Gallery_Photo::changePath($oldAlbumId, $newAlbumId, $params['oldpath'], $params['newpath']);

+ }

+}

+

+?>

+

+/**

+* ownCloud - gallery application

+*

+* @author Bartek Przybylski

+* @copyright 2012 Bartek Przybylski bart.p.pl@gmail.com

+*

+* This library is free software; you can redistribute it and/or

+* modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+* License as published by the Free Software Foundation; either

+* version 3 of the License, or any later version.

+*

+* This library is distributed in the hope that it will be useful,

+* but WITHOUT ANY WARRANTY; without even the implied warranty of

+* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+* GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+*

+* You should have received a copy of the GNU Lesser General Public

+* License along with this library. If not, see <http://www.gnu.org/licenses/>.

+*

+*/

+

+/**

+* ownCloud - gallery application

+*

+* @author Bartek Przybylski

+* @copyright 2012 Bartek Przybylski bart.p.pl@gmail.com

+*

+* This library is free software; you can redistribute it and/or

+* modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+* License as published by the Free Software Foundation; either

+* version 3 of the License, or any later version.

+*

+* This library is distributed in the hope that it will be useful,

+* but WITHOUT ANY WARRANTY; without even the implied warranty of

+* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+* GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+*

+* You should have received a copy of the GNU Lesser General Public

+* License along with this library. If not, see <http://www.gnu.org/licenses/>.

+*

+*/

+

+

+ public static function removeByPath($path) {

+ $stmt = OC_DB::prepare('DELETE FROM *PREFIX*gallery_photos WHERE file_path = ?');

+ $stmt->execute(array($path));

+ }

+

+ public static function removeById($id) {

+ $stmt = OC_DB::prepare('DELETE FROM *PREFIX*gallery_photos WHERE photo_id = ?');

+ $stmt->execute(array($id));

+ }

+

+ public static function changePath($oldAlbumId, $newAlbumId, $oldpath, $newpath) {

+ $stmt = OC_DB::prepare("UPDATE *PREFIX*gallery_photos SET file_path = ?, album_id = ? WHERE album_id = ? and file_path = ?");

+ $stmt->execute(array($newpath, $newAlbumId, $oldAlbumId, $oldpath));

+ }

+

+/**

+* ownCloud - gallery application

+*

+* @author Bartek Przybylski

+* @copyright 2012 Bartek Przybylski bart.p.pl@gmail.com

+*

+* This library is free software; you can redistribute it and/or

+* modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE

+* License as published by the Free Software Foundation; either

+* version 3 of the License, or any later version.

+*

+* This library is distributed in the hope that it will be useful,

+* but WITHOUT ANY WARRANTY; without even the implied warranty of

+* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

+* GNU AFFERO GENERAL PUBLIC LICENSE for more details.

+*

+* You should have received a copy of the GNU Lesser General Public

+* License along with this library. If not, see <http://www.gnu.org/licenses/>.

+*

+*/

+

+ $current_album['name'] = ($current_album['name']==='.') ?

+ $filepath = ($path[strlen($path)-1]=='/'?$path:$path.'/').$filename;

+ OC_Gallery_Album::create(OC_User::getUser(), $current_album['name'], $path);

+<div id="notification"><div id="gallery_notification_text">Creating thumbnails</div></div>

+ <input type="button" value="Rescan" onclick="javascript:scanForAlbums();" />

+ <br/>

+#leftcontent li div.label { float: left; width: 200px; overflow: hidden; text-overflow: ellipsis; }

+.collection_playing { background:#eee; font-weight: bold; }

+

+ /*

+ * We should not empty() PlayList.parent() but thorougly manage its

+ * elements instead because some code might be attached to those.

+ * JQuery tipsies are one of them. The following line make sure they

+ * are all removed before we delete the associated <li/>.

+ */

+ $(".tipsy").remove();

+

+ li.attr('class', 'jp-playlist-' + i);

+ li.attr('title', item.artist + ' - ' + item.name + '<br/>(' + item.album + ')');

+ var div = $('<div class="label">' + item.name + '</div>');

+ li.append(div);

+ $('.jp-playlist-' + i).tipsy({gravity:'w', fade:true, live:true, html:true});

+ INNER JOIN *PREFIX*media_songs ON *PREFIX*media_artists.artist_id=*PREFIX*media_songs.song_artist WHERE artist_name LIKE ? AND *PREFIX*media_songs.song_user=? ORDER BY artist_name");

+ FROM *PREFIX*media_albums INNER JOIN *PREFIX*media_songs ON *PREFIX*media_albums.album_id=*PREFIX*media_songs.song_album WHERE *PREFIX*media_songs.song_user=? ORDER BY album_name";

+ $query=OC_DB::prepare("SELECT * FROM *PREFIX*media_songs WHERE song_user=? $artistString $albumString $searchString ORDER BY song_track, song_name");

+?>

+ if (isset($data['comments']['track']))

+ {

+ $track = $data['comments']['track'][0];

+ }

+ else if (isset($data['comments']['track_number']))

+ {

+ $track = $data['comments']['track_number'][0];

+ $track = explode('/',$track);

+ $track = $track[0];

+ }

+ else

+ {

+ $track = 0;

+ }

+ if (empty($changes['remove']) and empty($changes['rename']) and empty($changes['change']) ){//if only rename or add changes are required, we can use ALTER TABLE

+ $query = '';

+ if (!empty($changes['name'])) {

+ $change_name = $db->quoteIdentifier($changes['name'], true);

+ $query = 'RENAME TO ' . $change_name;

+ $db->exec("ALTER TABLE $name $query");

+ }

+

+ if (!empty($changes['add']) && is_array($changes['add'])) {

+ foreach ($changes['add'] as $field_name => $field) {

+ $query= 'ADD ' . $db->getDeclaration($field['type'], $field_name, $field);

+ $db->exec("ALTER TABLE $name $query");

+ }

+ }

+ return MDB2_OK;

+ }

+

+ // for other operations we need to emulate them with sqlite3

+ //rename the old table so we can create the new one

+ $db->exec("ALTER TABLE $name RENAME TO __$name");

+ //these seem to only give errors

+// foreach ($indexes as $index => $definition) {

+// $this->createIndex($name_new, $index, $definition);

+// }

+// foreach ($constraints as $constraint => $definition) {

+// $this->createConstraint($name_new, $constraint, $definition);

+// }

+

+ //fill the new table with data from the old one

+ if (!empty($select_fields)) {

+ $query = 'INSERT INTO '.$db->quoteIdentifier($name_new, true);

+ $query.= '('.implode(', ', array_slice(array_keys($fields), 0, count($select_fields))).')';

+ $query .= ' SELECT '.implode(', ', $select_fields).' FROM '.$db->quoteIdentifier('__'.$name, true);

+ $db->exec($query);

+ }

+

+// if (!empty($select_fields) && !empty($data)) {

+// $query = 'INSERT INTO '.$db->quoteIdentifier($name_new, true);

+// $query.= '('.implode(', ', array_slice(array_keys($fields), 0, count($select_fields))).')';

+// $query.=' VALUES (?'.str_repeat(', ?', (count($select_fields) - 1)).')';

+// $stmt =$db->prepare($query, null, MDB2_PREPARE_MANIP);

+// if (PEAR::isError($stmt)) {

+// return $stmt;

+// }

+// foreach ($data as $row) {

+// $result = $stmt->execute($row);

+// if (PEAR::isError($result)) {

+// return $result;

+// }

+// }

+// }

+

+ //remove the old table

+ $result = $this->dropTable('__'.$name);

+ if (PEAR::isError($result)) {

+ return $result;

+ $query = "SELECT name FROM sqlite_master WHERE type='table' AND sql NOT NULL AND name!='sqlite_sequence' ORDER BY name";

+ $regexp = '/^\s*([^\s]+) +(CHAR|VARCHAR|VARCHAR2|TEXT|BOOLEAN|SMALLINT|INT|INTEGER|DECIMAL|BIGINT|DOUBLE|FLOAT|DATETIME|DATE|TIME|LONGTEXT|LONGBLOB)( ?\(([1-9][0-9]*)(:([1-9][0-9]*))?\))?( NULL| NOT NULL)?( UNSIGNED)?( NULL| NOT NULL)?( PRIMARY KEY)?( AUTOINCREMENT)?( DEFAULT (\'[^\']*\'|[^ ]+))?( NULL| NOT NULL)?( PRIMARY KEY)?(\s*\-\-.*)?$/i';

+ if (isset($matches[10]) && strlen($matches[10])) {

+ $columns[$j]['notnull']=true;

+ if (isset($matches[10]) && strlen($matches[10])) {

+ $columns[$j]['autoincrement'] = true;

+ $columns[$j]['notnull']=true;

+ }

+ if (isset($matches[13]) && strlen($matches[13])) {

+ $default = $matches[13];

+ } else if (isset($matches[14]) && strlen($matches[14])) {

+ $columns[$j]['notnull'] = ($matches[14] === ' NOT NULL');

+

+ /**

+ * check if any apps need updating and update those

+ */

+ public static function updateApps(){

+ // The rest comes here

+ $apps = OC_Appconfig::getApps();

+ foreach( $apps as $app ){

+ $installedVersion=OC_Appconfig::getValue($app,'installed_version');

+ $appInfo=OC_App::getAppInfo($app);

+ if (isset($appInfo['version'])) {

+ $currentVersion=$appInfo['version'];

+ if (version_compare($currentVersion, $installedVersion, '>')) {

+ OC_App::updateApp($app);

+ }

+ }

+ }

+ }

+

+ /**

+ * update the database for the app and call the update script

+ * @param string appid

+ */

+ public static function updateApp($appid){

+ if(file_exists(OC::$SERVERROOT.'/apps/'.$appid.'/appinfo/database.xml')){

+ OC_DB::updateDbFromStructure(OC::$SERVERROOT.'/apps/'.$appid.'/appinfo/database.xml');

+ }

+ if(file_exists(OC::$SERVERROOT.'/apps/'.$appid.'/appinfo/update.php')){

+ include OC::$SERVERROOT.'/apps/'.$appid.'/appinfo/update.php';

+ }

+ }

+ if(OC_Config::getValue('installed', false)){

+ $installedVersion=OC_Config::getValue('version','0.0.0');

+ $currentVersion=implode('.',OC_Util::getVersion());

+ if (version_compare($currentVersion, $installedVersion, '>')) {

+ OC_DB::updateDbFromStructure('../db_structure.xml');

+ OC_Config::setValue('version',implode('.',OC_Util::getVersion()));

+ }

+

+ OC_App::updateApps();

+ }

+

+OC::init();

+

+ public static function connectPDO(){

+ if(self::$connection){

+ if(self::$backend==self::BACKEND_MDB2){

+ self::disconnect();

+ }else{

+ return;

+ }

+ }

+ public static function connectMDB2(){

+ if(self::$connection){

+ if(self::$backend==self::BACKEND_PDO){

+ self::disconnect();

+ }else{

+ return;

+ }

+ }

+ self::$MDB2=false;

+ self::$PDO=false;

+ $previousSchema = self::$schema->getDefinitionFromDatabase();

+

+ $content = str_replace( '*dbname*', $previousSchema['name'], $content );

+ $op = self::$schema->updateDatabase($file2, $previousSchema, array(), false);

+ self::$MDB2->loadModule('Manager');

+ self::$MDB2->loadModule('Reverse');

+ $oldUser=OC_Config::getValue('dbuser', false);

+ $oldPassword=OC_Config::getValue('dbpassword', false);

+

+ $dbusername=substr('oc_'.$username,0,16);

+ if($dbusername!=$oldUser){

+ //hash the password so we don't need to store the admin config in the config file

+ $dbpassword=md5(time().$password);

+

+ self::createDBUser($dbusername, $dbpassword, $connection);

+

+ OC_Config::setValue('dbuser', $dbusername);

+ OC_Config::setValue('dbpassword', $dbpassword);

+ }

+ if($dbuser!=$oldUser){

+ OC_Config::setValue('dbuser', $dbuser);

+ OC_Config::setValue('dbpassword', $dbpass);

+ }

+ $query="select count(*) from information_schema.tables where table_schema='$dbname' AND table_name = '{$dbtableprefix}users';";

+ if($result){

+ $row=mysql_fetch_row($result);

+ }

+ if(!$result or $row[0]==0) {

+ //create a new password so we don't need to store the admin config in the config file

+ $dbpassword=md5(time());

+ //we cant use OC_BD functions here because we need to connect as the administrative user.

+ //we cant use OC_BD functions here because we need to connect as the administrative user.