Tag Archives: option

How to hide option in admin for specific user?

View file is application\views\admin\estate\edit.php, you should detect lines based on option type. For example if you changing for TEXTAREA (long input) then line 162…

You can for example add class hide  into:

<div class=”form-group”>

So replace it with omething like that:

<?php if($this->session->userdata('username') != 'sandi' && $val_option->id == 73): ?>
<div class="form-group hide">
<?php else: ?>
<div class="form-group">
<?php endif; ?>

In this case only user with username sandi will see option 74 field when edit property in administration…

Add field / option manually via phpmyadmin

For WP themes or plugin version:

If you accidentally remove red locked option from the database and now you need it… Now can be added via phpMyAdmin only, SQL queries:

wp_ is database prefix, may be different based on your wp configuration.

80 is field id in such example for badge

INSERT INTO `wp_sw_field` (`idfield`, `parent_id`, `order`, `type`, `is_locked`, `is_table_visible`, `is_preview_visible`, `is_submission_visible`, `is_hardlocked`, `is_required`, `is_translatable`, `is_quickvisible`, `max_length`, `repository_id`, `image_filename`, `image_gallery`, `image_id`, `columns_number`) VALUES (80, NULL, NULL, 'DROPDOWN', '1', NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

and then:

INSERT INTO `wp_cp_4`.`wp_sw_field_lang` (`idfield_lang`, `field_id`, `lang_id`, `field_name`, `values`, `prefix`, `suffix`, `hint`, `placeholder`) VALUES (NULL, '80', '1', 'Badge', 'b1,b2,b3', NULL, NULL, NULL, NULL);

Then will appear like this:

Screenshot_3

For PHP scripts:

If you accidentally remove red locked option from the database and now you need it… Now can be added via phpMyAdmin only, SQL queries:

To add option:

INSERT INTO `option` (`id` ,`parent_id` ,`order` ,`type` ,`visible` ,`is_locked` ,`is_frontend` ,`is_hardlocked`
) VALUES ('4', '0', NULL , 'DROPDOWN', '1', '1', '1', '1')

To add translations for option:

INSERT INTO `option_lang` (`option_id`, `language_id`, `option`, `values`, `prefix`, `suffix`) VALUES
(4, 1, 'Purpose', 'Sale,Rent,Sale and Rent', NULL, ''),
(4, 2, 'Namjena', 'Prodaja,Najam,Prodaja i najam', NULL, '');

In this example we adding ID #4,  and 1,2 was languages ID.

Another example for translation with just one language:

INSERT INTO `option_lang` (`option_id`, `language_id`, `option`, `values`, `prefix`, `suffix`) VALUES
(8, 1, 'Short description', '', NULL, '');

In this example we adding ID #8,  and 1 was languages ID because now we have only one language.

By ID of course we mean original field ID which you need to restore.

example query for listing category in classified script:

Category have ID field 79, so based on guide add field with id 79 manually, type is TREE
example query:
INSERT INTO `option` (`id` ,`parent_id` ,`order` ,`type` ,`visible` ,`is_locked` ,`is_frontend` ,`is_hardlocked`
) VALUES ('79', '0', NULL , 'TREE', '1', '1', '1', '1')

To add translations for option:

INSERT INTO `option_lang` (`option_id`, `language_id`, `option`, `values`, `prefix`, `suffix`) VALUES
(79, 1, 'Listing Category', '', NULL, '');