prefs_id field in Txp database

jsoo · 2009-09-02 15:46:05

Does it serve any purpose? It’s part of the txp_prefs table’s UNIQUE KEY, but it seems to always be set to “1”. Just wondering if I can ignore it and let it default to “0”.

ruud · 2009-09-02 16:40:59

Use common sense. If it’s set to 1 everywhere, don’t set it to 0 yourself ;)

Bloke · 2009-09-02 16:48:19

fwiw, I have no idea what it’s for. I do know that I consistently used to assume it was some kind of auto-increment ID and forgot to inlcude it in my SQL statements only to be told off! I never learned, for some reason…

Lucikly, set_pref() and get_pref() save the day now: I use those functions almost exclusively as it does all the drudgery for me, as well as allowing per-user prefs to be created/read in a uniform manner.

Last edited by Bloke (2009-09-02 16:48:56)

jsoo · 2009-09-02 17:27:55

ruud wrote:

Use common sense. If it’s set to 1 everywhere, don’t set it to 0 yourself ;)

Common sense? Is that a Txp function?

Bloke wrote:

set_pref() and get_pref() save the day now: I use those functions almost exclusively as it does all the drudgery for me, as well as allowing per-user prefs to be created/read in a uniform manner.

Ta!

Themroc · 2011-01-09 20:48:47

After a 10-minute-investigation, i’d say:

If u want prefs_list(), advanced_prefs() and get_prefs() to not see your data, set prefs_id to anything but 1.

Thus, it seems pretty useless…

Themroc · 2011-01-14 15:15:58

Sry, that last sentence was totally wrong. Setting prefs_id != 1 seems to be the only way to not pollute the global namespace with all the stuff from txp_prefs.

Textpattern CMS

Textpattern CMS support forum

#1 2009-09-02 15:46:05

prefs_id field in Txp database

#2 2009-09-02 16:40:59

Re: prefs_id field in Txp database

#3 2009-09-02 16:48:19

Re: prefs_id field in Txp database

#4 2009-09-02 17:27:55

Re: prefs_id field in Txp database

#5 2011-01-09 20:48:47

Re: prefs_id field in Txp database

#6 2011-01-14 15:15:58

Re: prefs_id field in Txp database

Board footer