/**
* ajax_blog_install
* This ajax action handles blog installation
*
* @param $post_data
* @return string
*/
public function ajax_blog_install($post_data)
{
if ($this->installed) {
return 'Blog is already installed!';
}
if (!empty($post_data['db_type'])) {
$db_type = ucfirst($post_data['db_type']);
$adapter = 'Solar_Sql_Adapter_' . $db_type;
} else {
return 'DB Type cannot be blank!';
}
Solar_Config::set('Solar_Sql', 'adapter', $adapter);
Solar_Config::set($adapter, 'host', $post_data['db_host']);
Solar_Config::set($adapter, 'user', $post_data['db_username']);
Solar_Config::set($adapter, 'pass', $post_data['db_password']);
Solar_Config::set($adapter, 'name', $post_data['db_name']);
Solar_Config::set($adapter, 'prefix', $post_data['db_prefix']);
$adapter = Solar::factory($adapter);
try {
$adapter->connect();
} catch (Exception $e) {
return 'Cannot connect to database! Please ensure valid DB info.';
}
$this->random_str = Foresmo::randomString(18);
$config_file = Solar::$system . '/config/Solar.config.php';
$config_content = $this->_getConfigContent($post_data);
if (($handle = @fopen($config_file, 'w')) !== false) {
if (@fwrite($handle, $config_content) === false) {
fclose($handle);
return "Cannot write to: {$config_file}. Please set the permissions to 777 for this file.";
} else {
fclose($handle);
}
} else {
return "Could not open {$config_file}, please ensure that this file exists and is writable.";
}
$schema = Solar::$system . '/source/foresmo/Foresmo/Schemas/' . $db_type . '.php';
$schema_sql = Solar_File::load($schema);
$schema_sql = str_replace('[prefix]', $post_data['db_prefix'], $schema_sql);
try {
$adapter->query($schema_sql);
} catch (Exception $e) {
// tables already exist?
}
$errors = array();
$matches = array();
$ret_str = '';
$post_data['blog_user'] = trim($post_data['blog_user']);
if (empty($post_data['blog_password']) == true || empty($post_data['blog_password2']) == true || empty($post_data['blog_user']) == true || empty($post_data['blog_title']) == true || empty($post_data['blog_email']) == true) {
$errors[] = 'No fields should be left blank!';
}
preg_match('/^([.0-9a-z_-]+)@(([0-9a-z-]+\\.)+[0-9a-z]{2,4})$/i', $post_data['blog_email'], $matches);
if (count($matches) == 0) {
$errors[] = 'Not a valid email address.';
}
if (strlen($post_data['blog_password']) < 7) {
$errors[] = 'The user password must be seven characters or more';
}
if ($post_data['blog_password'] !== $post_data['blog_password2']) {
$errors[] = 'The user password fields did not match!';
}
if (count($errors) > 0) {
$ret_str .= '<p class="error"><b>Validation Errors:</b></p>';
foreach ($errors as $error) {
$ret_str .= '<span class="error">' . $error . '</span><br />';
}
return $ret_str;
}
$username = $post_data['blog_user'];
$password = $post_data['blog_password'];
$password = md5($this->random_str . $password);
$email = trim($post_data['blog_email']);
$table = $post_data['db_prefix'] . 'groups';
$data = array('name' => 'Admin');
$adapter->insert($table, $data);
$last_insert_id = $adapter->lastInsertId($table, 'id');
$permissions = array();
$table = $post_data['db_prefix'] . 'permissions';
$data = array('name' => 'create_post');
$adapter->insert($table, $data);
$permissions[] = $adapter->lastInsertId($table, 'id');
$data = array('name' => 'edit_post');
$adapter->insert($table, $data);
$permissions[] = $adapter->lastInsertId($table, 'id');
$data = array('name' => 'delete_post');
$adapter->insert($table, $data);
$permissions[] = $adapter->lastInsertId($table, 'id');
$data = array('name' => 'create_page');
$adapter->insert($table, $data);
$permissions[] = $adapter->lastInsertId($table, 'id');
$data = array('name' => 'edit_page');
$adapter->insert($table, $data);
$permissions[] = $adapter->lastInsertId($table, 'id');
$data = array('name' => 'delete_page');
$adapter->insert($table, $data);
$permissions[] = $adapter->lastInsertId($table, 'id');
$table = $post_data['db_prefix'] . 'groups_permissions';
foreach ($permissions as $permission) {
$data = array('group_id' => $last_insert_id, 'permission_id' => (int) $permission);
$adapter->insert($table, $data);
}
$table = $post_data['db_prefix'] . 'users';
$data = array('group_id' => $last_insert_id, 'username' => $username, 'password' => $password, 'email' => strtolower($email));
$adapter->insert($table, $data);
$table = $post_data['db_prefix'] . 'options';
$data = array('name' => 'blog_installed', 'type' => 1, 'value' => time());
$adapter->insert($table, $data);
$data = array('name' => 'blog_theme', 'type' => 0, 'value' => 'default');
$adapter->insert($table, $data);
$data = array('name' => 'blog_title', 'type' => 0, 'value' => $post_data['blog_title']);
$adapter->insert($table, $data);
$data = array('name' => 'blog_date_format', 'type' => 0, 'value' => 'F j, Y, g:ia');
$adapter->insert($table, $data);
$data = array('name' => 'blog_timezone', 'type' => 0, 'value' => '-4:00');
$adapter->insert($table, $data);
$data = array('name' => 'blog_posts_per_page', 'type' => 0, 'value' => 10);
$adapter->insert($table, $data);
$data = array('name' => 'blog_comment_link_limit', 'type' => 0, 'value' => 3);
$adapter->insert($table, $data);
$table = $post_data['db_prefix'] . 'posts';
$data = array('slug' => 'my-first-post', 'content_type' => 1, 'title' => 'My first post!', 'content' => "Welcome to {$post_data['blog_title']}. Look forward to new blog posts soon!", 'user_id' => 1, 'status' => 1, 'pubdate' => time(), 'modified' => time());
$adapter->insert($table, $data);
$table = $post_data['db_prefix'] . 'comments';
$data = array('post_id' => 1, 'name' => 'Foresmo', 'email' => '*****@*****.**', 'url' => 'http://foresmo.com', 'ip' => sprintf("%u", ip2long('192.168.0.1')), 'content' => 'Congratulations!', 'status' => 1, 'date' => time(), 'type' => 0);
$adapter->insert($table, $data);
$table = $post_data['db_prefix'] . 'tags';
$data = array('tag' => 'Foresmo', 'tag_slug' => 'foresmo');
$adapter->insert($table, $data);
$table = $post_data['db_prefix'] . 'posts_tags';
$data = array('post_id' => 1, 'tag_id' => 1);
$adapter->insert($table, $data);
$table = $post_data['db_prefix'] . 'modules';
$data = array('name' => 'Pages', 'enabled' => 1);
$adapter->insert($table, $data);
$data = array('name' => 'Search', 'enabled' => 1);
$adapter->insert($table, $data);
$data = array('name' => 'Calendar', 'enabled' => 1);
$adapter->insert($table, $data);
$data = array('name' => 'Tags', 'enabled' => 1);
$adapter->insert($table, $data);
$data = array('name' => 'Links', 'enabled' => 1);
$adapter->insert($table, $data);
$data = array('name' => 'Archives', 'enabled' => 1);
$adapter->insert($table, $data);
$data = array('name' => 'Flickr', 'enabled' => 0);
$adapter->insert($table, $data);
$data = array('name' => 'Twitter', 'enabled' => 0);
$adapter->insert($table, $data);
$data = array('name' => 'Sections', 'enabled' => 0);
$adapter->insert($table, $data);
$table = $post_data['db_prefix'] . 'module_info';
$data = array('module_id' => 3, 'name' => 'start_of_week', 'type' => 0, 'value' => 0);
$adapter->insert($table, $data);
if ($db_type == 'Mysql') {
$data = array('module_id' => 2, 'name' => 'search_adapter', 'type' => 0, 'value' => 'mysql');
} else {
$data = array('module_id' => 2, 'name' => 'search_adapter', 'type' => 0, 'value' => 'default');
}
$adapter->insert($table, $data);
$data = array('module_id' => 2, 'name' => 'search_adapter_settings', 'type' => 0, 'value' => 'a:5:{s:7:"Default";a:0:{}s:6:"Google";a:0:{}s:5:"Mysql";a:0:{}s:6:"Lucene";a:0:{}s:5:"Sphinx";a:0:{}}');
$adapter->insert($table, $data);
return 'Foresmo installed! Click <a href="/">here</a> to check it out! Also, don\'t forget to change the permissions of the config back to read only.';
}
