Hi,
I have few things that I want to discuss.
I see some of the settings do not have their own user interface to edit them such as “PropertiesIconic”. I might have to change plans about implementing separate user interfaces for each settings, as they virtually do not exist for some of them. I am beginning to feel like this project is not just about having a feature to store settings permanently, but also providing users an interface to change those settings that they were not able to do so before because of not having access to config files on the server.
I see all of the settings (currently under consideration) also have configuration options in ./libraries/config.default.php. Are these configs only there for initial installation purpose? What would happen if sysadmins change value for these options? Will these new settings override those stored in DB?
Would it not be a decent idea to simply apply user settings to relative vars in ./libraries/config.default.php by extracting them from db? May be also have a mechanism to allow sysadmins to override DB stored settings?
I see there are several settings in ./libraries/config.default.php that can easily be imported to permanent settings user interface. Is there a limit on the number of settings that can have a place in the central admin interface due to performance, or some other issues?
*Now, some coding questions:*
Following UPDATE query does not happen to perform any change to the table:
PMA_DBI_try_query("UPDATE pma_perm_usr_pref SET maxRows = 20 WHERE username = root")
And following SELECT query actually gives me a rather weird result:
PMA_DBI_try_query("SELECT maxRows FROM pma_perm_usr_pref WHERE username = root")
results in: *Resource Id #61
*Of course, changeable values are not hard-coded in the actual script. :) Is there something wrong with the sql query?
For the later, I tried adding $link ( = PMA_DBI_select_db($cfg['Servers'][1]['pmadb']) ) parameter just to test if not having it was the problem. But, no luck.
Well, this brings me to my last question. For now, I am manually setting $i equal to 1. Is there a way to extract this server parameter from some automatically generated script?
Thank so much! Your help is much appreciated!
-------------------------------------------------- Best regards, Zeeshan Mughal Email: zeeshanmughal@ieee.org Web: http://www.zixan.info