Maintain list of static data as key-value pairs
This plugin adds a new administration control panel that can be used to manage constants (key/value pairs) stored in the database. These can then be used in report queries.
If you have any issues, create a new ticket.
0 / 1
Download the zipped source from here.
Install the plugin as normal, and add a table like this to the database:
CREATE TABLE `constants` ( `constant` VARCHAR(255) NOT NULL, `stringval` VARCHAR(255) DEFAULT NULL, `intval` INT(11) DEFAULT NULL, `floatval` FLOAT DEFAULT NULL, PRIMARY KEY (`constant`) );
You can then use this in report queries. The stringval column will always be stored. Also, intval and floatval will contain the int/float equivalent if possible, ie the input could be cast to an INT.
Visit the administration panel to update constants.