public function action_update()
{
$name = $this->request->param('id');
$field = new Model_UserField();
$field_data = $field->get($name);
Breadcrumbs::add(Breadcrumb::factory()->set_title(__('Edit') . ' ' . $name));
$this->template->title = __('Edit Custom Field for Advertisement');
if ($_POST) {
try {
$options = array('label' => Core::post('label'), 'tooltip' => Core::post('tooltip'), 'required' => Core::post('required') == 'on' ? TRUE : FALSE, 'searchable' => Core::post('searchable') == 'on' ? TRUE : FALSE, 'show_profile' => Core::post('show_profile') == 'on' ? TRUE : FALSE, 'show_register' => Core::post('show_register') == 'on' ? TRUE : FALSE, 'admin_privilege' => Core::post('admin_privilege') == 'on' ? TRUE : FALSE);
if ($field->update($name, Core::post('values'), $options)) {
Core::delete_cache();
Alert::set(Alert::SUCCESS, sprintf(__('Field %s edited'), $name));
} else {
Alert::set(Alert::ERROR, sprintf(__('Field %s cannot be edited'), $name));
}
} catch (Exception $e) {
throw HTTP_Exception::factory(500, $e->getMessage());
}
HTTP::redirect(Route::url('oc-panel', array('controller' => 'userfields', 'action' => 'index')));
}
$this->template->content = View::factory('oc-panel/pages/userfields/update', array('field_data' => $field_data, 'name' => $name));
}
/**
* This function will upgrade DB that didn't existed in versions prior to 2.5.1
*/
public function action_251()
{
//CF users searchable admin privilege option to false if didnt exists
$cf_users = Model_UserField::get_all();
foreach ($cf_users as $name => $options) {
$modified = FALSE;
if (!isset($options['searchable'])) {
$options['searchable'] = FALSE;
$modified = TRUE;
}
if (!isset($options['admin_privilege'])) {
$options['admin_privilege'] = FALSE;
$modified = TRUE;
}
if ($modified === TRUE) {
$field = new Model_UserField();
$field->update($name, $options['values'] ? implode(',', $options['values']) : null, $options);
}
}
//change latitude/longitude data type length
try {
DB::query(Database::UPDATE, "ALTER TABLE `" . self::$db_prefix . "ads` CHANGE `latitude` `latitude` FLOAT(10, 6) NULL DEFAULT NULL")->execute();
} catch (exception $e) {
}
try {
DB::query(Database::UPDATE, "ALTER TABLE `" . self::$db_prefix . "ads` CHANGE `longitude` `longitude` FLOAT(10, 6) NULL DEFAULT NULL")->execute();
} catch (exception $e) {
}
try {
DB::query(Database::UPDATE, "ALTER TABLE `" . self::$db_prefix . "locations` CHANGE `latitude` `latitude` FLOAT(10, 6) NULL DEFAULT NULL")->execute();
} catch (exception $e) {
}
try {
DB::query(Database::UPDATE, "ALTER TABLE `" . self::$db_prefix . "locations` CHANGE `longitude` `longitude` FLOAT(10, 6) NULL DEFAULT NULL")->execute();
} catch (exception $e) {
}
// set to NULL latitude and longitude ads with longitude and longitude equal to 0
try {
DB::query(Database::UPDATE, "UPDATE " . self::$db_prefix . "ads SET latitude=NULL, longitude=NULL WHERE latitude='0' AND longitude='0'")->execute();
} catch (exception $e) {
}
//messages status
try {
DB::query(Database::UPDATE, "ALTER TABLE `" . self::$db_prefix . "messages` ADD `status_to` tinyint(1) NOT NULL DEFAULT '0'")->execute();
} catch (exception $e) {
}
try {
DB::query(Database::UPDATE, "ALTER TABLE `" . self::$db_prefix . "messages` ADD `status_from` tinyint(1) NOT NULL DEFAULT '0'")->execute();
} catch (exception $e) {
}
//do something with status to migrate to status_from
try {
DB::query(Database::UPDATE, "UPDATE `" . self::$db_prefix . "messages` SET `status_from`=`status` , `status_to`=`status`")->execute();
} catch (exception $e) {
}
try {
DB::query(Database::UPDATE, "ALTER TABLE `" . self::$db_prefix . "messages` DROP `status`")->execute();
} catch (exception $e) {
}
//new configs
$configs = array(array('config_key' => 'measurement', 'group_name' => 'general', 'config_value' => 'metric'), array('config_key' => 'leave_alert', 'group_name' => 'advertisement', 'config_value' => '1'));
Model_Config::config_array($configs);
}
