Tables linpha config

From LinphaWiki

User are able to have their own config settings

Table Layout

CREATE TABLE `linpha_config` (
  `ID` int NOT NULL auto_increment,
  `option_name` varchar(100) NOT NULL default '',
  `option_value` varchar(100) NOT NULL default '',
  `userid` int default '0',
  `user_override` int default '0'
 )

userid:
 if userid = 0 => system setting


override:
 0: no possible (paths etc.)
 1: admin may choose (not changeable by user)
 2: admin may choose (changeable by user)

Config Structure

 
 sys_db_*		Database settings
 sys_path_*		Folder path settings
 sys_im_*		Imagemagick and GDlib settings
 sys_style_*	Layout, style, etc. (should be change...)
 sys_lang_*		Language settings
 sys_import_*	Import/add new folders/files
 
 Plugins:
 wm_*			Plugin watermark
 gb_*			Plugin Guestbook
 log_*			Plugin Logger
 ...

Description of config entries

sys_session_cookiepath

Possible values: 'unchanged', 'auto', 'root' (same as "/") or "path"
Default value: unchanged
Limit cookie to a specific path. This is useful when you are running multiple installations on the same server and you want different sessions for each installation. Pay attention when including LinPHA from another page. Lets say LinPHA is installed in
http://www.somewhere.org/linpha/
and you include LinPHA from
http://www.somewhere.org/include/
you cannot limit the cookie path to include/ because LinPHA would start a new session when loading the photos from linpha/
It is safe to set the cookie path to website/ when LinPHA is installed to a subdirectory like:
http://www.somewhere.org/website/
http://www.somewhere.org/website/linpha/

sys_session_name

Possible values: a-zA-Z
Default value: linpha2
This is another possibility to differentiate between sessions if you have multiple LinPHA installations on the same server. Just use a different name for each installation. The value may not contain special characters.