Adding a file to the includes > classes > db > mysql folder.

[ultimate_zc]

I'm trying to add a define_queries_XXX.php file to the mysql folder. The define I'm adding is:

DEFINE('SQL_SHOW_PRODUCT_PAGE_TABS',"select configuration_key, configuration_value from " . TABLE_CONFIGURATION . " where configuration_key RLIKE 'SHOW_PRODUCT_PAGE_TABS' and configuration_value > 0 order by configuration_value");

Adding the line to define_queries.php works but I don't want to modify that file. I would rather add an additional file to that folder but doing so does not work.

The code for my file is:

if (!defined('IS_ADMIN_FLAG')) {
    die('Illegal Access');
}
DEFINE('SQL_SHOW_PRODUCT_PAGE_TABS',"select configuration_key, configuration_value from " . TABLE_CONFIGURATION . " where configuration_key RLIKE 'SHOW_PRODUCT_PAGE_TABS' and configuration_value > 0 order by configuration_value");

Is this something that can be done with an additional file?

[mc12345678]

You could just place it in includes/extra_configures

Otherwise may have to modify other core code in order to use additional files within that directory. :/

[ultimate_zc]

You could just place it in includes/extra_configures

Thanks. That didn't work but includes/extra_datafiles did.
You pointed me in the right direction.

[mc12345678]

Thanks. That didn't work but includes/extra_datafiles did.
You pointed me in the right direction.

Not sure why that was so: In a default ZC store, in includes/application_top.php the folder includes/extra_configures is loaded just after the includes/configure.php file and before getting into the includes/auto_loaders/config.core.php file where eventually the includes/extra_datafiles folder is loaded.

I mean sure, if it is not defined before loading the extra_datafiles file/folder it could go in that folder, it is even possible to put it in the includes/functions/extra_functions folder, though that doesn't make much sense as its neither a function nor an extra function. :) but files with a php extension in that folder do get loaded.

[lat9]

Thanks. That didn't work but includes/extra_datafiles did.
You pointed me in the right direction.

Not sure why that was so: In a default ZC store, in includes/application_top.php the folder includes/extra_configures is loaded just after the includes/configure.php file and before getting into the includes/auto_loaders/config.core.php file where eventually the includes/extra_datafiles folder is loaded.

I mean sure, if it is not defined before loading the extra_datafiles file/folder it could go in that folder, it is even possible to put it in the includes/functions/extra_functions folder, though that doesn't make much sense as its neither a function nor an extra function. :) but files with a php extension in that folder do get loaded.

The reason that the file worked when placed in the /extra_datafiles subdirectory and didn't when in /extra_configures is the nature of the definition being made.

if (!defined('IS_ADMIN_FLAG')) {     die('Illegal Access'); } 
DEFINE('SQL_SHOW_PRODUCT_PAGE_TABS',"select configuration_key, configuration_value from " . TABLE_CONFIGURATION . " where configuration_key RLIKE 'SHOW_PRODUCT_PAGE_TABS' and configuration_value > 0 order by configuration_value");

The database-related names (like the table names) are initialized during the auto-load process, so are available when the /extra_datafiles directory's files are loaded. Files in the /extra_configures directory are loaded prior to the auto-load process, so don't have access to the file/database name definitions.

[mc12345678]

Ah yes, and then the TABLE_CONFIGURATION "segment" being assumed as literally the text 'TABLE_CONFIGURATION' when the file is placed in extra_configures. Details!