db->Execute($query);} public function Conn($query) {return $this->db;} public static function PrevVersion() { $v = SettingsServices::getMetadata(0,0,metadataTypeObj::SYS_VERSION); if (is_array($v) && sizeof($v)==1) {return $v[0]->getMetadataValue();} else {return null;} } } ?> VCD-db Installer
Welcome to VCD-db Upgrade (v.) VCD-db

Upgrade complete.
You can now delete the setup folder.

"; } catch (Exception $ex) { print "Upgrade Failed!
Message: {$ex->getMessage()}"; } } ?>

Press the continue button to upgrade from VCD-db 0.984, 0.985, 0.986, 0.990 or 0.991.
Older versions are not supported by the web based upgrader.

The installer has detected that you are running Apache webserver.
Since VCD-db 0.990 there is support for friendly urls using mod_rewrite.
If you wish to activate this option in the "admin panel" after upgrade, you will have to add these lines to your apache configuration file for this host. 

<Directory "">
        AllowOverride Options FileInfo AuthConfig
</Directory>
If you wish to enable "friendly urls" after the upgrade you must follow these steps:
  1. Make sure that you have the mod_rewrite apache module loaded.
  2. Insert the above lines to your apache config file and restart/reload apache.
  3. In the admin panel, select Tools/Create .htaccess file.
  4. In the admin panel, select Web settings and set the "friendly url" option to true.

VCD-db 0.990 has new webservice interface for other programs and/or other instances of VCD-db to interop. Below are the config settings for the WebServices. You must add the following lines at the end of your config.php file weither you are gonna use that feature or not.
You can also change the password below if you do not like the generated one. 

/**
   These constants are used if you are using the VCD-db SOAP interface, meaning that
   you can either provide another VCD-db instance with data or consume data from another
   VCD-db website via webservices.
  
  These constants consist of the following keys ...
  -----------------------------------------------------------------
  VCDDB_USEPROXY	Use remote VCD-db website as a data provider
  VCDDB_SOAPPROXY	The Url to the remote VCD-db website (must end with /)
  VCDDB_SOAPSECRET	The shared secret key used to verify permission to use the SOAP interface
  CACHE_MANAGER		Cache data if cache modules are installed, can be XCACHE or MEMCACHE
 
**/
define("VCDDB_USEPROXY", "0");
define("VCDDB_SOAPPROXY", "http://domain.com/vcddb/");
define("VCDDB_SOAPSECRET", "");
define("CACHE_MANAGER", "");

If you want to keep your VCD-db installation tidy, after the upgrade you can delete the following obsolete files that are no longer used nor required. 

/authenticate.php
/error.php
/exec_form.php
/exec_query.php
/graph.php
/screens.php	
/search.php
/vcd_image.php
/classes/VCDScreenshot.php
/functions/XMLFunctions.php
/pages/*.php (yes, all php files in folder /pages)
/modules (yes the folder and all it's contents)

Conn()->getOne($query) == 0) { $Queries[] = "INSERT INTO vcd_SourceSites (site_name,site_alias,site_homepage,site_getCommand,site_isFetchable,site_classname,site_image) VALUES ('Film.Tv.It','filmtv','http://www.film.tv.it','http://www.film.tv.it/scheda.php?film=#','1','VCDFetch_filmtv', 'filmtvit.gif')"; } $query = "SELECT count(*) FROM vcd_SourceSites WHERE site_alias = 'ofdb'"; if ($upgrader->Conn()->getOne($query) == 0) { $Queries[] = "INSERT INTO vcd_SourceSites (site_name,site_alias,site_homepage,site_getCommand,site_isFetchable,site_classname,site_image) VALUES ('Online Filmdatenbank','ofdb','http://www.ofdb.de','http://www.ofdb.de/view.php?page=film&fid=#&full=1','1','VCDFetch_ofdb', 'ofdb.jpg')"; } $query = "SELECT count(*) FROM vcd_SourceSites WHERE site_alias = 'cdon'"; if ($upgrader->Conn()->getOne($query) == 0) { $Queries[] = "INSERT INTO vcd_SourceSites (site_name,site_alias,site_homepage,site_getCommand,site_isFetchable,site_classname,site_image) VALUES ('CDOn.com','cdon','http://www.cdon.com','http://www.hyrfilm.cdon.com/movie/detail.asp?MovieId=#','1','VCDFetch_cdon', 'cdon.png')"; } $query = "SELECT count(*) FROM vcd_SourceSites WHERE site_alias = 'amazon'"; if ($upgrader->Conn()->getOne($query) == 0) { $Queries[] = "INSERT INTO vcd_SourceSites (site_name,site_alias,site_homepage,site_getCommand,site_isFetchable,site_classname,site_image) VALUES ('Amazon.com','amazon','http://www.amazon.com','http://www.amazon.com/dp/#','1','VCDFetch_amazon', 'amazon.gif')"; } // Check user properties $query = "SELECT count(*) FROM vcd_UserProperties WHERE property_name = 'NFO_IMAGE'"; if ($upgrader->Conn()->getOne($query) == 0) { $Queries[] = "INSERT INTO vcd_UserProperties (property_name,property_description) VALUES ('NFO_IMAGE','View NFO files as images?')"; } // Add the rewrite $Queries[] = "INSERT INTO vcd_Settings (settings_key, settings_value, settings_description, isProtected, settings_type) VALUES ('MOD_REWRITE','0','Use friendly urls? This requires mod_rewrite installed.','1','bool')"; // Update the metadata types $Queries[] = 'DELETE FROM vcd_MetaData WHERE type_id = 6 or type_id = 7'; $Queries[] = "UPDATE vcd_MetaDataTypes SET type_name = 'dvdlang', type_description='DVD Spoken languages' WHERE type_id = 6"; $Queries[] = "UPDATE vcd_MetaDataTypes SET type_name = 'version', type_description='The current VCD-db version' WHERE type_id = 7"; $Queries[] = "INSERT INTO vcd_MetaData (record_id,mediatype_id, user_id, type_id, metadata_value) VALUES (0,0,0,7,'{$version}')"; break; } $upgrader = new upgrader(); foreach ($Queries as $query) { $upgrader->Execute($query); } $v = SettingsServices::getMetadata(0,0,metadataTypeObj::SYS_VERSION); $metaObj = $v[0]; $metaObj->setMetadataValue(CURR_VERSION); SettingsServices::updateMetadata($metaObj); clearCache(); } catch (Exception $ex) { throw $ex; } } function clearCache() { $cacheFolder = VCDDB_BASE.DIRECTORY_SEPARATOR.CACHE_FOLDER; $it = new DirectoryIterator($cacheFolder); $filesToKeep = array('vcddb.db', 'index.html'); foreach ($it as $file) { if (!$file->isDir()) { if (!in_array($file->getFileName(), $filesToKeep)) { $fileToDel = $cacheFolder.$file->getFileName(); unlink($fileToDel); } } } } ?>