Including Modules in ZC installation

[tommyharding]

Hey all..

I'm attempting to include the Admin Profiles module in the Zen Cart installation process and I'm having some trouble.

As Admin Profiles employs some SQL during installation, I'm having some trouble adding the module tables into the DB.

I include the installation sql into zc_install\sql\mysql_zencart.sql and run the ZC setup but for some reason or other it only creates the tables it doesnt populate them. I don't understand it at all.

My second thought was to put the sql file inside the install\sql\plugins. I decided to do this based on this code in header_php.php:

         for ($i = 0, $n = sizeof($directory_array); $i < $n; $i++) {
           $file = $directory_array[$i];
           if (file_exists($sqlpluginsdir . $file)) {
             echo '<br />Processing Plugin: ' . $sqlpluginsdir . $file . '<br />';
             executeSql($sqlpluginsdir . $file, $_POST['db_name'], $_POST['db_prefix']);
           }
         } 

Again, this didnt work. I even deleted the empty.txt file and tried again.

Has anyone done something like this before? I create a lot of ZC installations using the same few modules and have been asked to see if i can reduce time down more.

Thanks,
Tom

[Merlinpa1969]

I have added custom sql files to /zc_install/sql/plugins and they load just fine, for install, they dont work well for upgrades though

[DrByte]

Try adding "mysql_" as a prefix to your plugin sql files.

Oh, and don't forget to make a donation each time you do one of those Zen Cart installs!! It's real easy ... just click here and choose an option: http://www.zen-cart.com/index.php?ma...es&pages_id=14

[funkey]

Try adding "mysql_" as a prefix to your plugin sql files.

Oh, and don't forget to make a donation each time you do one of those Zen Cart installs!! It's real easy ... just click here and choose an option: http://www.zen-cart.com/index.php?ma...es&pages_id=14

DrByte,

Is there a reason they need to be prefixed with mysql_ ?

I am trying to do a similar thing & had added the SQL files to /zc_install/sql/plugins/XXX_patch_name.sql (where XXX is a number between 000 and 999)

If I name them that way, the installer ignores them completely -- but if I rename them "mysql_XXX_patch_name.sql" it works correctly.

I presume that behaviour is caused by the: " . $_POST['db_type'] . " in the preg_match line (line 157) -- if I remove that, would they work the original way?

(not that I mind either way, just clarifying that I could do it)

Cheers,

Paul

[DrByte]

The "mysql_" prefix is used so that when other database engines are supported they can be differentiated there. You don't want to try running non-MySQL code on a MySQL database, nor vice-versa.

Short solution: Use the prefix.