sys_options kateg explanation?

I am trying to make a 'simple' admin module page to provide settings for a script.

I am working with the bloggie example to experiment.

Can someone explain how the sys_options work? Especially kateg.

~

As an example, I found these two 'settings':

INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES

('me_blgg_permalinks', 'on', 26, 'Enable friendly permalinks in Bloggie', 'checkbox', '', '', '0', ''),

('me_blgg_max_posts_to_show', '10', @iCategId, 'Max number of posts to show', 'digit', '', '', '1', '');

INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES

('me_blgg_permalinks', 'on', 26, 'Enable friendly permalinks in Bloggie', 'checkbox', '', '', '0', ''),

('me_blgg_max_posts_to_show', '10', @iCategId, 'Max number of posts to show', 'digit', '', '', '1', ''),

('me_blgg_checkbox', 'on', @iCategId, 'Max number of posts to show', 'checkbox', '', '', '2', '');

Thanks for any help.

Hi,

kateg is just a category id.

You don't see the first one as it's kind of hidden field but for the rest you will see them as you keep adding them e.g.

SET @iCategId = (SELECT LAST_INSERT_ID());

INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES

('me_blgg_permalinks', 'on', 26, 'Enable friendly permalinks in Bloggie', 'checkbox', '', '', '0', ''),

('me_blgg_max_posts_to_show', '10', @iCategId, 'Max number of posts to show', 'digit', '', '', '1', ''),

('me_blgg_checkbox', 'on', @iCategId, 'Max number of posts to show', 'checkbox', '', '', '2', ''),

('me_blgg_max_logs', 'on', @iCategId, 'Max number of logs', 'checkbox', '', '', '3', ''),

('me_blgg_max_views', 'on', @iCategId, 'Max number of views', 'checkbox', '', '', '4', '');

And then to read the value in your code, just do this:

$max_views = getParam('me_blgg_max_views');

HTH

Mods4Dolphin