Advanced addon installer Ocmod OpenCart

This module extends the standard OpenCart extension installer and adds support for additional installation steps: install.sql and install.php. Simply put, the extension can now not only copy files but also automatically execute the required SQL queries and run a PHP script during installation—without manual database edits or unnecessary work.

Purpose of the module

This module is useful for developers and store administrators who install add-ons that require creating tables, adding settings, filling in data, or performing one-time actions via PHP.

Main functions

• Adds an install.sql execution step to the installation process.
• Adds a step to run install.php from the temporary installation folder.
• Automatically inserts the DB prefix: replaces `oc_ with the current DB_PREFIX.
• Ignores comments in SQL ( -- and # ) and executes queries by separator ;.
• Checks access rights ( modify ) and the correctness of the temporary installation directory.
• Displays clear statuses of installation steps.

What data and operations does it work with?

1. Temporary folder: DIR_UPLOAD/tmp-*
2. Installation files: install.sql, install.php
3. Request data: extension_install_id, user_token
4. Operations: reading a file, executing SQL via $this->db->query(), running PHP via include()

Important: install.php runs on a server with OpenCart permissions. Use it only from trusted sources, and be sure to verify the contents of extensions before installing.

Recommendations and application examples

If your extension needs to create tables, add fields, or configure initial settings, do so in install.sql. For more complex logic (such as data migration, settings generation, event logging), use install.php. This makes installation a breeze: click a button, and you're done, no manual steps required.