[Mydynaweb-devel] DB Settings Layer

[Benoit d. L. <ben...@ph...>]

Hello,

A new layer is avalaible (from CVS only) for the admin section.

Almost all the settings that were precedently in the 
mydynaweb/htdocs/include/mydynaweb.init.php
can now be configured directly from the admin section !

All the variables are stored in the database and so we can now modify them
easily ! As a consequence, all the options are documented in english and
french, a choice is given when there is a multiple choice and some examples if
it's a form.

In order to use this feature, here is the procedure :

1) cvs 'update -d' your mydynaweb tree.

2) Create the relevant table with some default value with the
   SQL script ::
   mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6/create_fill_dynasettings.sql

   For mysql, the syntax is the following :
   cd in this directorty and then, remplace _login_ and _database_ by you
   login name and database name for the MySQL server.

mysql -u _login_ -p _database_ < create_fill_dynasettings.sql

3) Go to your admin section and enter the values you use in your config file

4) Comment all the values you just define in the database in your config file
(basically, only very few variable will remain : identification for the SQL
server)

5) That's it !

You can now configure all the settings and change them online from everywhere !

Please note that for the moment, the file has precedence over the database ! It
means that if you _don't_ comment the variable definition in the file, all
the database values will be ignored...

[ 
It's a feature in case something went wrong : you can easoly come back to
your working version by commenting out the variables definition in your config
file...
]

-- 
 Si tu commences à compter et à nommer,
  tu ne t'arrèteras jamais.
                                Tchouang-tseu

Benoit des Ligneris                                   ICQ : 12052994
http://www.physique.usherb.ca/~bligneri/ 

Président du GULUS
http://www.gulus.org/

Key Fingerprint : 3A58 11D1 686A B4D4 5220  BB34 7D98 BF45 B57B 85B8
 12:36am  up 15 days, 15:11,  3 users,  load average: 0.03, 0.02, 0.00