File Source for install

<?php
/**
* @version $Header$
* @package install
* @subpackage functions
*/
// assign next step in installation process
$gBitSmarty->assign( 'next_step', $step );
$schema = $gBitInstaller->mPackages;
ksort( $schema );
$gBitSmarty->assign_by_ref( 'schema', $schema );
// ===================== Post install table check =====================
// $dbTables is the output of BitSystem::verifyInstalledPackages() in
// install_inc.php and contains all tables that are not present in the database
// - even tables of packages that are not installed
$dbIntegrity = install_check_database_integrity( $dbTables );
// ===================== Permissions =====================
// check all permissions, compare them to each other and see if there are old
// permissions and ones that need to be inserted
$query = "SELECT * FROM `".BIT_DB_PREFIX."users_permissions` ORDER BY `package` ASC";
$result = $gBitInstaller->mDb->query( $query );
while( !$result->EOF ) {
foreach( $result->fields as $r ) {
$bitPerms[$result->fields['perm_name']][] = $r;
}
if ( defined( 'ROLE_MODEL' ) ) {
$bitPerms[$result->fields['perm_name']]['sql'][] = "DELETE FROM `".BIT_DB_PREFIX."users_role_permissions` WHERE `perm_name`='".$result->fields['perm_name']."'";
} else {
$bitPerms[$result->fields['perm_name']]['sql'][] = "DELETE FROM `".BIT_DB_PREFIX."users_group_permissions` WHERE `perm_name`='".$result->fields['perm_name']."'";
}
$bitPerms[$result->fields['perm_name']]['sql'][] = "DELETE FROM `".BIT_DB_PREFIX."users_permissions` WHERE `perm_name`='".$result->fields['perm_name']."'";
$result->MoveNext();
}
// we will make sure all the permission levels are what they should be. we will
// update these without consulting the user. this is purely backend stuff, has
// no outcome on the site itself but determines what the default permission
// level is. the user can never modify these settings.
foreach( array_keys( $gBitInstaller->mPermHash ) as $perm ) {
// permission level is stored in [2]
$bindVars = array();
if( !empty( $bitPerms[$perm] ) && $gBitInstaller->mPermHash[$perm][2] != $bitPerms[$perm][2] ) {
$query = "UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_level` = ? WHERE `perm_name` = ?";
$bindVars[] = $gBitInstaller->mPermHash[$perm][2];
$bindVars[] = $perm;
$gBitInstaller->mDb->query( $query, $bindVars );
}
}
// compare both perm arrays with each other and work out what permissions need
// to be added and which ones removed
$insPerms = $delPerms = array();
foreach( array_keys( $gBitInstaller->mPermHash ) as $perm ) {
if( !in_array( $perm, array_keys( $bitPerms ))) {
if( $gBitInstaller->isInstalled( $gBitInstaller->mPermHash[$perm][3] )) {
$insPerms[$perm] = $gBitInstaller->mPermHash[$perm];
}
}
}
foreach( array_keys( $bitPerms ) as $perm ) {
if( !in_array( $perm, array_keys( $gBitInstaller->mPermHash ) ) ) {
$delPerms[$perm] = $bitPerms[$perm];
}
}
$gBitSmarty->assign( 'delPerms', $delPerms );
$gBitSmarty->assign( 'insPerms', $insPerms );
// ===================== Services =====================
// check if we have installed more than one service of any given type
// DEPRECATED - this check never really made sense. The original purpose
// of the services was to have multiple under the same identifier to
// be able to invoke them all in one shot. Recent updates to the services
// flattens the array so that there is one and only one service set per
// service type. This could revert back with time. For now this is commented
// out.
/*
$serviceList = array();
if( !empty( $gLibertySystem->mServices ) ) {
foreach( $gLibertySystem->mServices as $service_name => $service ) {
if( count( $service ) > 1 ) {
$serviceList[$service_name] = $service;
}
}
}
*/
// ===================== Process Form =====================
// create missing tables if possible
if( !empty( $_REQUEST['create_tables'] ) && !empty( $dbIntegrity )) {
$gBitInstallDb = &ADONewConnection( $gBitDbType );
if( $gBitInstallDb->Connect( $gBitDbHost, $gBitDbUser, $gBitDbPassword, $gBitDbName )) {
$dict = NewDataDictionary( $gBitInstallDb );
if( !$gBitInstaller->mDb->getCaseSensitivity() ) {
$dict->connection->nameQuote = '';
}
if( !empty( $gDebug ) || !empty( $_REQUEST['debug'] )) {
$gBitInstaller->debug();
$gBitInstallDb->debug = 99;
}
// If we use MySql check which storage engine to use
if( isset( $_SESSION['use_innodb'] ) ){
if( $_SESSION['use_innodb'] == TRUE ) {
$build = array('NEW', 'MYSQL' => 'ENGINE=INNODB');
} else {
$build = array('NEW', 'MYSQL' => 'ENGINE=MYISAM');
}
} else {
$build = 'NEW';
}
$tablePrefix = $gBitInstaller->getTablePrefix();
foreach( $dbIntegrity as $package => $info ) {
foreach( $info['tables'] as $table ) {
$completeTableName = $tablePrefix.$table['name'];
$sql = $dict->CreateTableSQL( $completeTableName, $gBitInstaller->mPackages[$package]['tables'][$table['name']], $build );
// Uncomment this line to see the create sql
//vd( $sql );
if( $sql ) {
$dict->ExecuteSQLArray( $sql );
}
}
}
}
}
// if any of the serviceList items have been unchecked, disable the appropriate packages
if( !empty( $_REQUEST['resolve_conflicts'] ) ) {
if( !empty( $gDebug ) || !empty( $_REQUEST['debug'] ) ) {
$gBitInstaller->debug();
$gBitInstallDb->debug = 99;
}
// === Permissions
$fixedPermissions = array();
$permMap = array();
$permMap['basic'] = ANONYMOUS_TEAM_ID;
$permMap['registered'] = 3;
$permMap['editors'] = 2;
$permMap['admin'] = 1;
if( !empty( $_REQUEST['perms'] ) ) {
foreach( $_REQUEST['perms'] as $perm ) {
if( !empty( $delPerms[$perm] )) {
foreach( $delPerms[$perm]['sql'] as $sql ) {
$gBitInstaller->mDb->query( $sql );
}
$fixedPermissions[] = $delPerms[$perm];
}
if( !empty( $insPerms[$perm] )) {
$gBitInstaller->mDb->query( $insPerms[$perm]['sql'] );
$fixedPermissions[] = $insPerms[$perm];
if( !empty( $roleMap[$insPerms[$perm][2]] )) {
if ( defined( 'ROLE_MODEL' ) ) {
$gBitUser->assignPermissionToRole( $perm, $permMap[$insPerms[$perm][2]] );
} else {
$gBitUser->assignPermissionToGroup( $perm, $permMap[$insPerms[$perm][2]] );
}
}
}
}
}
$gBitSmarty->assign( 'fixedPermissions', $fixedPermissions );
// === Services
$deActivated = array();
foreach( $serviceList as $service ) {
foreach( array_keys( $service ) as $package ) {
$packages = !empty( $_REQUEST['packages'] ) ? $_REQUEST['packages'] : array();
if( !in_array( $package, $packages )) {
$gBitSystem->storeConfig( 'package_'.$package, 'n', KERNEL_PKG_NAME );
$deActivated[] = $package;
}
}
}
$gBitSmarty->assign( 'next_step', $step + 1 );
$gBitSmarty->assign( 'deActivated', $deActivated );
// display the confirmation page
$app = '_done';
} elseif( !empty( $_REQUEST['skip'] ) ) {
// if there were no conflicts, we move on to the next page
header( "Location: ".$_SERVER['SCRIPT_NAME']."?step=".++$step );
die;
}
// make sure everything is up to date after the above changes
$dbTables = $gBitInstaller->verifyInstalledPackages( 'all' );
$dbIntegrity = install_check_database_integrity( $dbTables );
$gBitSmarty->assign( 'dbIntegrity', $dbIntegrity );
// $gBitSmarty->assign( 'serviceList', $serviceList );
/**
* function - install_check_database_integrity
*/
function install_check_database_integrity( $pDbTables ) {
global $gBitInstaller;
$ret = array();
if( !empty( $pDbTables['missing'] ) && is_array( $pDbTables['missing'] )) {
foreach( array_keys( $pDbTables['missing'] ) as $package ) {
// we can't use the 'installed' flag in $gBitInstaller->mPackages[$package] because that is set to 'not installed' as soon as a table is missing
if( count( $gBitInstaller->mPackages[$package]['tables'] ) > count( $pDbTables['missing'][$package] )) {
// at least one table is missing
$ret[$package] = array(
'name' => ucfirst( $gBitInstaller->mPackages[$package]['name'] ),
'required' => $gBitInstaller->mPackages[$package]['required'],
);
foreach( $pDbTables['missing'][$package] as $table ) {
$ret[$package]['tables'][$table] = array(
'name' => $table,
'sql' => $gBitInstaller->mPackages[$package]['tables'][$table],
);
}
}
}
}
return $ret;
}
?>

Source for file install_cleanup.php