|
// +---------------------------------------------------------------------------+
function canCreateDb()
{
$aFormValues = array_merge($_SESSION['_installationWizard_container']['values']['page4'],
$_SESSION['_installationWizard_container']['values']['page5']);
$skipDbCreation = (bool)@$aFormValues['skipDbCreation'];
// if we're not creating a DB, presumably a DB exists so supply DB name to dsn
$dbName = ($skipDbCreation) ? "/{$aFormValues['name']}" : '';
// postgres however does not support logins with no db name
if ($dbName == '' && ($aFormValues['dbType']['type'] == 'pgsql')) {
$dbName = '/template1';
$dbQuote = '"';
} else {
$dbQuote = '`';
}
$socket = (isset($aFormValues['dbProtocol']['protocol'])
&& $aFormValues['dbProtocol']['protocol'] == 'unix'
&& !empty($aFormValues['socket']))
? '(' . $aFormValues['socket'] . ')'
: '';
$protocol = isset($aFormValues['dbProtocol']['protocol'])
? $aFormValues['dbProtocol']['protocol'] . $socket
: '';
$host = empty($aFormValues['socket']) ? '+' . $aFormValues['host'] : '';
$port = (!empty($aFormValues['dbPort']['port'])
&& isset($aFormValues['dbProtocol']['protocol'])
&& ($aFormValues['dbProtocol']['protocol'] == 'tcp'))
? ':' . $aFormValues['dbPort']['port']
: '';
$dsn = $aFormValues['dbType']['type'] . '://' .
$aFormValues['databaseUser'] . ':' .
$aFormValues['databaseUserPass'] . '@' .
$protocol .
$host . $port . $dbName;
// attempt to get db connection
$dbh = & SGL_DB::singleton($dsn);
if ($skipDbCreation && PEAR::isError($dbh)) {
SGL_Install_Common::errorPush($dbh);
return false;
} elseif ($skipDbCreation) {
if (isset($aFormValues['useExistingData']) && $aFormValues['useExistingData'] == 1) {
// if DB exists, detect if tables exist
$tables = $dbh->getListOf('tables');
if (!count($tables)) {
$_SESSION['_installationWizard_container']['values']['page5']['createTables'] = 1;
} else {
$_SESSION['_installationWizard_container']['values']['page5']['createTables'] = 0;
}
} else {
$_SESSION['_installationWizard_container']['values']['page5']['createTables'] = 1;
}
return true;
} elseif (PEAR::isError($dbh)) {
return false;
}
// attempt to create database
$ok = $dbh->query('CREATE DATABASE '. $dbQuote . $aFormValues['name'] . $dbQuote);
if (PEAR::isError($ok)) {
SGL_Install_Common::errorPush($ok);
return false;
} else {
// if new db, set flag to create tables
$_SESSION['_installationWizard_container']['values']['page5']['createTables'] = 1;
return true;
}
}
/**
* @package Install
*/
class WizardCreateDb extends HTML_QuickForm_Page
{
function buildForm()
{
$this->_formBuilt = true;
$this->setDefaults(array(
'name' => 'seagull',
'prefix' => '',
'insertSampleData' => false,
));
$this->setDefaults(SGL_Install_Common::overrideDefaultInstallSettings());
$this->addElement('header', null, 'Database Setup: page 5 of 6');
// skip db creation
$this->addElement('checkbox', 'skipDbCreation', 'Use existing Db?',
'Yes (If box is not ticked, a new Db will be created)',
array('onClick' => 'javascript:toggleExistingData()',
'id' => 'skipDbCreation'));
// use existing data
$this->addElement('checkbox', 'useExistingData', 'Use existing Data?',
'Yes (Select this option to preserve your existing data)',
array('onClick' => 'javascript:toggleOptionsWhenUsingExistingDb()',
'id' => 'useExistingData'));
// db name
$this->addElement('text', 'name', 'Database name: ');
$this->addElement('text', 'postConnect', 'Post Connect string: ');
$this->addRule('name', 'Please specify the name of the database', 'required');
// db prefix
$this->addElement('text', 'prefix', 'Table prefix: ');
$this->addRule('prefix', 'Only letters and digits are allowed, first ' .
'symbol must be a letter, last symbol can be an underscore',
'regex', '/^[a-zA-Z]([a-zA-Z0-9]+)?_?$/');
// sample data
$this->addElement('checkbox', 'insertSampleData', 'Include Sample Data?', 'Yes', 'id=insertSampleData');
if (SGL_MINIMAL_INSTALL == false) {
$moreOptionsLinkName = 'Show';
$this->addElement('link', null, 'Advanced options', '#', $moreOptionsLinkName,
array(
'onclick' => 'toggleMoreOptions(\'moreOptionsContainer\', this)',
'id' => 'moreOptionsLink'
));
// deprecated method - open container
$this->addElement('html', '
');
$this->addElement('header', null, 'Translation Setup');
// store translation in db
$this->addElement('checkbox', 'storeTranslationsInDB', 'Store Translations in Database?',
'Yes (This option allows for multi-lingual articles in addition to interface translations)',
array('id' => 'storeTranslationsInDB', 'onClick' => 'javascript:toggleLangList()'));
// load available languages
$this->addElement('select', 'installLangs', 'If yes, which language(s): ',
SGL_Util::getLangsDescriptionMap(), array('multiple' => 'multiple', 'id' => 'installLangs'));
// store translation in db
$this->addElement('checkbox', 'addMissingTranslationsToDB', 'Add missing Translations to Database?',
'Yes (EXPERIMENTAL - use at your own risk)', "id = addMissingTranslationsToDB");
// deprecated method - close container
$this->addElement('html', '
');
} else {
$this->addElement('hidden', 'a', 'aa', "id = storeTranslationsInDB");
$this->addElement('hidden', 'b', 'bb', "id = installLangs");
$this->addElement('hidden', 'c', 'cc', "id = addMissingTranslationsToDB");
}
// test db creation
$this->registerRule('canCreateDb','function','canCreateDb');
$this->addRule('name', 'there was an error creating the database', 'canCreateDb');
// submit
$prevnext[] =& $this->createElement('submit', $this->getButtonName('back'), '<< Back');
$prevnext[] =& $this->createElement('submit', $this->getButtonName('next'), 'Next >>');
$this->addGroup($prevnext, null, '', ' ', false);
$this->setDefaultAction('next');
}
}
?>