private function installExtension()

in 2.0.x-2.2.x/upload/catalog/model/module/facebook_business.php [218:252]
26 lines of code
3 McCabe index (conditional complexity)

    private function installExtension($user_group_id = 0) {
        // Install extension
        $extension_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "extension` WHERE `type` = 'module' AND `code` = 'facebook_business'");

        if (!$extension_query->num_rows) {
            $this->db->query("INSERT INTO `" . DB_PREFIX . "extension` SET `type` = 'module', `code` = 'facebook_business'");
        }
        
        // Add custom table
        $this->db->query("
            CREATE TABLE IF NOT EXISTS `" . DB_PREFIX . "product_to_facebook` (
              `product_to_facebook_id` INT(11) NOT NULL AUTO_INCREMENT,
              `product_id` INT(11) NOT NULL,
              `google_product_category` int(16) NOT NULL DEFAULT 0,
              `condition` varchar(20) NOT NULL,
              `age_group` varchar(50) NOT NULL,
              `color` varchar(255) NOT NULL,
              `gender` varchar(20) NOT NULL,
              `material` varchar(255) NOT NULL,
              `pattern` varchar(255) NOT NULL,
              PRIMARY KEY (`product_to_facebook_id`)
            ) ENGINE=MyISAM DEFAULT COLLATE=utf8_general_ci;");

        // Add permissions for user group
        $user_group_query = $this->db->query("SELECT DISTINCT * FROM " . DB_PREFIX . "user_group WHERE user_group_id = '" . (int)$user_group_id . "'");

        if ($user_group_query->num_rows) {
            $data = json_decode($user_group_query->row['permission'], true);

            $data['access'][] = 'module/facebook_business';
            $data['modify'][] = 'module/facebook_business';

            $this->db->query("UPDATE " . DB_PREFIX . "user_group SET permission = '" . $this->db->escape(json_encode($data)) . "' WHERE user_group_id = '" . (int)$user_group_id . "'");
        }
    }