芝麻web文件管理V1.00

编辑当前文件:/home/p/r/i/prismawe/clients/canaldegap.fr/modules/parcelles/method.upgrade.php

<?php
if (!isset($gCms)) exit;

$db =& $this->GetDb();
$dict = NewDataDictionary($db);
$tabopt = array("mysql" => "TYPE=MyISAM");

// PART 1: This does the upgrade for the CTLModuleMaker part
// Unfortunately, this is only backward compatible to CTLModuleMaker 1.6.3. I couldn't go any further behind because at that time the maker version wasn't saved anywhere

$oldmaker = $this->GetPreference("makerversion", "veryold");

switch($oldmaker){
	// BEGIN SWITCH($oldmaker)

case "veryold":
		// the module was created with version 1.6.3 or prior.
		$this->CreateEvent("parcelles_added");
		$this->CreateEvent("parcelles_modified");
		$this->CreateEvent("parcelles_deleted");
		break;
	case "1.6.4":
	case "1.7":
	case "1.7.1":
	case "1.7.2":
	case "1.7.3":
	case "1.7.4":
		;
	case "1.8.1":
	case "1.8.2":
	case "1.8.2.2":
	case "1.8.3":
	case "1.8.3.1":
		// Creates the queries table
		$flds = "
			id I,
			name C(64),
			what C(32),
			whereclause C(255),
			wherevalues C(255),
			queryorder C(32)
			";
		$sqlarray = $dict->CreateTableSQL(cms_db_prefix()."module_parcelles_saved_queries", $flds, $tabopt);
		$dict->ExecuteSQLArray($sqlarray);
		$db->CreateSequence(cms_db_prefix()."module_parcelles_saved_queries_seq");
		$this->CreatePermission("parcelles_advanced", "parcelles: Advanced");
	case "1.8.4":
	case "1.8.4.1":
	case "1.8.5":
	case "1.8.5.1":
		$this->CreatePermission("parcelles_normaluser", "parcelles: Normal user");
		// activating default preferences
		$defprefs = array("tabdisplay_canal","searchmodule_index_canal","tabdisplay_commune","searchmodule_index_commune","tabdisplay_parcelle","searchmodule_index_parcelle","restrict_permissions","display_filter","display_instantsearch");
		foreach($defprefs as $onepref)	$this->SetPreference($onepref,true);
	case "1.8.6":
	case "1.8.6.1":
	case "1.8.7":
	case "1.8.7.1":
		if($db->dbtype == "mysql" || $db->dbtype == "mysqli"){
			// msyql
			$queries = array();
			$queries[] = "ALTER TABLE ".cms_db_prefix()."module_parcelles_canal ADD COLUMN date_created DATETIME";
			$queries[] = "UPDATE ".cms_db_prefix()."module_parcelles_canal SET date_created=date_modified";
			$queries[] = "ALTER TABLE ".cms_db_prefix()."module_parcelles_commune ADD COLUMN date_created DATETIME";
			$queries[] = "UPDATE ".cms_db_prefix()."module_parcelles_commune SET date_created=date_modified";
			$queries[] = "ALTER TABLE ".cms_db_prefix()."module_parcelles_parcelle ADD COLUMN date_created DATETIME";
			$queries[] = "UPDATE ".cms_db_prefix()."module_parcelles_parcelle SET date_created=date_modified";
			foreach($queries as $query)		mysql_query($query);

}else{
			// non-mysql
			$dict->AddColumnSQL(cms_db_prefix()."module_parcelles_canal", "date_created ".CMS_ADODB_DT);
			$dict->AddColumnSQL(cms_db_prefix()."module_parcelles_commune", "date_created ".CMS_ADODB_DT);
			$dict->AddColumnSQL(cms_db_prefix()."module_parcelles_parcelle", "date_created ".CMS_ADODB_DT);
			
		}
	case "1.8.7.2":
	case "1.8.8":
	case "1.8.8.1":
	case "1.8.8.2":
	case "1.8.8.3":
	case "1.8.8.4":
		$this->SetPreference("adminpages",0);
		$this->SetPreference("load_nbchildren",true);
		$this->SetPreference("load_nextprevious",false);
	case "1.8.9":
		$this->SetPreference("use_session",true);
		$this->SetPreference("defemptytemplate","**");
		
	// END SWITCH($oldmaker)
}

$this->SetPreference("makerversion", "1.8.9.3");
?>