Module DB insert/updates split onto multi-line

Code: Select all

<file name="admin/controller/catalog/product.php">
       <operation>
           <search position="before"><![CDATA[
           $this->data['entry_meta_keyword'] = $this->language->get('entry_meta_keyword');
           ]]></search>
           <add><![CDATA[
           $this->data['entry_holiday'] = $this->language->get('entry_holiday');
           ]]></add>
       </operation>
       <operation>
           <search position="before"><![CDATA[
           if (isset($this->request->post['status'])) {
           ]]></search>
           <add><![CDATA[
           if (isset($this->request->post['holiday'])) {
			$this->data['holiday'] = $this->request->post['holiday'];
		} elseif (!empty($product_info)) {
			$this->data['holiday'] = $product_info['holiday'];
		} else {
			$this->data['holiday'] = 0;
		}
           ]]></add>
       </operation>
</file>

Code: Select all

<file name="admin/model/catalog/product.php">
    	<operation>
           <search position="replace"><![CDATA[
           $this->db->query("INSERT INTO " . DB_PREFIX . "product SET model = '" . $this->db->escape($data['model']) . "', sku = '" . $this->db->escape($data['sku']) . "', upc = '" . $this->db->escape($data['upc']) . "', location = '" . $this->db->escape($data['location']) . "', quantity = '" . (int)$data['quantity'] . "', minimum = '" . (int)$data['minimum'] . "', subtract = '" . (int)$data['subtract'] . "', stock_status_id = '" . (int)$data['stock_status_id'] . "', date_available = '" . $this->db->escape($data['date_available']) . "', manufacturer_id = '" . (int)$data['manufacturer_id'] . "', shipping = '" . (int)$data['shipping'] . "', price = '" . (float)$data['price'] . "', points = '" . (int)$data['points'] . "', weight = '" . (float)$data['weight'] . "', weight_class_id = '" . (int)$data['weight_class_id'] . "', length = '" . (float)$data['length'] . "', width = '" . (float)$data['width'] . "', height = '" . (float)$data['height'] . "', length_class_id = '" . (int)$data['length_class_id'] . "', status = '" . (int)$data['status'] . "', tax_class_id = '" . $this->db->escape($data['tax_class_id']) . "', sort_order = '" . (int)$data['sort_order'] . "', date_added = NOW()");
           ]]></search>
           <add><![CDATA[
           $this->db->query("INSERT INTO " . DB_PREFIX . "product SET model = '" . $this->db->escape($data['model']) . "', sku = '" . $this->db->escape($data['sku']) . "', upc = '" . $this->db->escape($data['upc']) . "', location = '" . $this->db->escape($data['location']) . "', quantity = '" . (int)$data['quantity'] . "', minimum = '" . (int)$data['minimum'] . "', subtract = '" . (int)$data['subtract'] . "', stock_status_id = '" . (int)$data['stock_status_id'] . "', date_available = '" . $this->db->escape($data['date_available']) . "', manufacturer_id = '" . (int)$data['manufacturer_id'] . "', shipping = '" . (int)$data['shipping'] . "', price = '" . (float)$data['price'] . "', points = '" . (int)$data['points'] . "', weight = '" . (float)$data['weight'] . "', weight_class_id = '" . (int)$data['weight_class_id'] . "', length = '" . (float)$data['length'] . "', width = '" . (float)$data['width'] . "', height = '" . (float)$data['height'] . "', length_class_id = '" . (int)$data['length_class_id'] . "', status = '" . (int)$data['status'] . "', tax_class_id = '" . $this->db->escape($data['tax_class_id']) . "', sort_order = '" . (int)$data['sort_order'] . "', date_added = NOW(), `holiday` = '" . (isset($data['holiday']) ? (int)$data['holiday'] : 0) . "'");
           ]]></add>
       </operation>
    	<operation>
           <search position="replace"><![CDATA[
           $this->db->query("UPDATE " . DB_PREFIX . "product SET model = '" . $this->db->escape($data['model']) . "', sku = '" . $this->db->escape($data['sku']) . "', upc = '" . $this->db->escape($data['upc']) . "', location = '" . $this->db->escape($data['location']) . "', quantity = '" . (int)$data['quantity'] . "', minimum = '" . (int)$data['minimum'] . "', subtract = '" . (int)$data['subtract'] . "', stock_status_id = '" . (int)$data['stock_status_id'] . "', date_available = '" . $this->db->escape($data['date_available']) . "', manufacturer_id = '" . (int)$data['manufacturer_id'] . "', shipping = '" . (int)$data['shipping'] . "', price = '" . (float)$data['price'] . "', points = '" . (int)$data['points'] . "', weight = '" . (float)$data['weight'] . "', weight_class_id = '" . (int)$data['weight_class_id'] . "', length = '" . (float)$data['length'] . "', width = '" . (float)$data['width'] . "', height = '" . (float)$data['height'] . "', length_class_id = '" . (int)$data['length_class_id'] . "', status = '" . (int)$data['status'] . "', tax_class_id = '" . $this->db->escape($data['tax_class_id']) . "', sort_order = '" . (int)$data['sort_order'] . "', date_modified = NOW() WHERE product_id = '" . (int)$product_id . "'");
           ]]></search>
           <add><![CDATA[
           $this->db->query("UPDATE " . DB_PREFIX . "product SET model = '" . $this->db->escape($data['model']) . "', sku = '" . $this->db->escape($data['sku']) . "', upc = '" . $this->db->escape($data['upc']) . "', location = '" . $this->db->escape($data['location']) . "', quantity = '" . (int)$data['quantity'] . "', minimum = '" . (int)$data['minimum'] . "', subtract = '" . (int)$data['subtract'] . "', stock_status_id = '" . (int)$data['stock_status_id'] . "', date_available = '" . $this->db->escape($data['date_available']) . "', manufacturer_id = '" . (int)$data['manufacturer_id'] . "', shipping = '" . (int)$data['shipping'] . "', price = '" . (float)$data['price'] . "', points = '" . (int)$data['points'] . "', weight = '" . (float)$data['weight'] . "', weight_class_id = '" . (int)$data['weight_class_id'] . "', length = '" . (float)$data['length'] . "', width = '" . (float)$data['width'] . "', height = '" . (float)$data['height'] . "', length_class_id = '" . (int)$data['length_class_id'] . "', status = '" . (int)$data['status'] . "', tax_class_id = '" . $this->db->escape($data['tax_class_id']) . "', sort_order = '" . (int)$data['sort_order'] . "', date_modified = NOW(), `holiday` = '" . (isset($data['holiday']) ? (int)$data['holiday'] : 0) . "' WHERE product_id = '" . (int)$product_id . "'");
           ]]></add>
       </operation>
</file>

Code: Select all

<file name="admin/language/english/catalog/product.php">
       <operation>
           <search position="before"><![CDATA[
           ?>
           ]]></search>
           <add><![CDATA[
           $_['entry_holiday'] = 'Available during holiday?';
           ]]></add>
       </operation>
</file>

Code: Select all

<file name="admin/view/template/catalog/product_form.tpl">
       <operation>
           <search position="before"><![CDATA[
           <td><?php echo $entry_status; ?></td>
           ]]></search>
           <add><![CDATA[
	      <td><?php echo $entry_holiday; ?></td>
	      <td><?php if ($holiday) { ?>
               <input type="checkbox" name="holiday" value="1" checked="checked" />
               <?php } else { ?>
               <input type="checkbox" name="holiday" value="1" />
               <?php } ?>
             </td>
	    </tr>
	    <tr>
           ]]></add>
       </operation>
</file>

Code: Select all

<search position="replace">
$this->db->query("INSERT INTO order SET order_id = 'x', customer_id = 'y'");
</search>

<add>
$this->db->query("INSERT INTO order SET order_id = 'x', customer_id = 'y', new_field = 'z'");
</add>

Code: Select all

<search position="replace">
customer_id = 'y'
</search>

<add trim="true">
customer_id = 'y', new_field = 'z'
</add>