public function index()
{
$this->template->content = new View('admin/stats_hits');
$this->template->content->title = Kohana::lang('ui_admin.statistics');
// Retrieve Current Settings
$settings = ORM::factory('settings', 1);
if ($settings->stat_id === null || $settings->stat_id == 0) {
$sitename = $settings->site_name;
$url = url::base();
$this->template->content->stat_id = Stats_Model::create_site($sitename, $url);
}
// Show the hits page since stats are already set up
$this->hits();
}
public function index()
{
$this->template->content = new View('admin/stats/hits');
$this->template->content->title = Kohana::lang('ui_admin.statistics');
// Retrieve Current Settings
$stat_id = Settings_Model::get_setting('stat_id');
if ($stat_id === NULL or $stat_id == 0) {
$sitename = Settings_Model::get_setting('site_name');
$url = url::base();
$this->template->content->stat_id = Stats_Model::create_site($sitename, $url);
}
// Show the hits page since stats are already set up
$this->hits();
}
public static function populate_db($db_name, $user, $settings)
{
$mhi_db = Kohana::config('database.default');
$table_prefix = $mhi_db['table_prefix'];
$mhi_db_name = $mhi_db['connection']['database'];
// Switch to new DB for a moment
mysql_query('USE ' . $db_name);
$db_schema = file_get_contents('sql/ushahidi.sql');
// If a table prefix is specified, add it to sql
if ($table_prefix) {
$find = array('CREATE TABLE IF NOT EXISTS `', 'INSERT INTO `', 'ALTER TABLE `', 'UPDATE `');
$replace = array('CREATE TABLE IF NOT EXISTS `' . $table_prefix . '_', 'INSERT INTO `' . $table_prefix . '_', 'ALTER TABLE `' . $table_prefix . '_', 'UPDATE `' . $table_prefix . '_');
$db_schema = str_replace($find, $replace, $db_schema);
}
// Split by ; to get the sql statement for creating individual tables.
$tables = explode(';', $db_schema);
foreach ($tables as $query) {
$result = mysql_query($query);
}
// Set up admin user on new site
$usr = ORM::factory('user', '1');
$usr->username = $user['username'];
$usr->name = $user['name'];
$usr->password = $user['password'];
$usr->email = $user['email'];
$usr->save();
// Save site settings (name, tagline, etc)
$setgs = new Settings_Model(1);
$setgs->site_name = $settings['site_name'];
$setgs->site_tagline = $settings['site_tagline'];
$setgs->api_google = Kohana::config('settings.api_google');
$setgs->date_modify = date("Y-m-d H:i:s", time());
$setgs->save();
// Set up stats
$domain = str_ireplace(array('http://', 'https://'), '', url::base());
Stats_Model::create_site($settings['site_name'], 'http://' . $settings['site_domain'] . '.' . $domain);
// Switch back to the appropriate DB
mysql_query('USE ' . $mhi_db_name);
return true;
}
