H69UNtblNBNpha2dtB1Odn8qYp1Qk5NK2gi7yfceofo9N

/home/ymswebso/crms/application/migrations/

<?php

defined('BASEPATH') or exit('No direct script access allowed');

class Migration_Version_230 extends CI_Migration
{
    public function __construct()
    {
        parent::__construct();
        app_init_customer_profile_tabs();
    }

public function up()
    {
        update_option('setup_menu_active', '[]');
        update_option('aside_menu_active', '[]');

$this->db->where('name', 'aside_menu_inactive');
        $this->db->or_where('name', 'setup_menu_inactive');
        $this->db->delete('tbloptions');

if (table_exists('tblticketsspamcontrol')) {
            $this->db->query('RENAME TABLE `tblticketsspamcontrol` TO `tblspamfilters`;');
        }

if (!$this->db->field_exists('rel_type', 'tblspamfilters')) {
            $this->db->query('ALTER TABLE `tblspamfilters` ADD `rel_type` VARCHAR(10) NOT NULL AFTER `type`;');
            $this->db->update('tblspamfilters', ['rel_type' => 'tickets']);
        }

if (!table_exists('tblmodules')) {
            $this->db->query('CREATE TABLE `tblmodules` (
                          `id` int(11) NOT NULL,
                          `module_name` varchar(55) NOT NULL,
                          `installed_version` varchar(11) NOT NULL,
                          `active` tinyint(1) NOT NULL
                        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;');

$this->db->query('ALTER TABLE `tblmodules`  ADD PRIMARY KEY (`id`);');
            $this->db->query('ALTER TABLE `tblmodules`  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;');
        }

if (!table_exists('tblcreditnoterefunds')) {
            $this->db->query('CREATE TABLE `tblcreditnoterefunds` (
                          `id` int(11) NOT NULL,
                          `credit_note_id` int(11) NOT NULL,
                          `staff_id` int(11) NOT NULL,
                          `refunded_on` date NOT NULL,
                          `payment_mode` varchar(40) NOT NULL,
                          `note` text,
                          `amount` decimal(15,2) NOT NULL
                        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;');

$this->db->query('ALTER TABLE `tblcreditnoterefunds` ADD PRIMARY KEY (`id`);');
            $this->db->query('ALTER TABLE `tblcreditnoterefunds` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;');
        }

$this->db->query('ALTER TABLE `tblcontacts` CHANGE `lastname` `lastname` VARCHAR(191) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;');
        $this->db->query('ALTER TABLE `tblcontacts` CHANGE `firstname` `firstname` VARCHAR(191) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;');

$this->db->query('ALTER TABLE `tblcontacts` ADD INDEX(`email`);');

$this->db->query('ALTER TABLE `tblcustomfields` CHANGE `fieldto` `fieldto` VARCHAR(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;');
        $this->db->query('ALTER TABLE `tblcustomfieldsvalues` CHANGE `fieldto` `fieldto` VARCHAR(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;');

$this->db->query("ALTER TABLE `tblleads` CHANGE `assigned` `assigned` INT(11) NOT NULL DEFAULT '0';");

$visible_customer_profile_tabs = get_option('visible_customer_profile_tabs');
        if ($visible_customer_profile_tabs != 'all' && get_option('230_cp_tabs_processed') === '') {
            $visible_customer_profile_tabs = unserialize($visible_customer_profile_tabs);

$tabs = get_customer_profile_tabs();
            $opt  = [];

foreach ($tabs as $tabKey => $tab) {
                $opt[$tabKey] = in_array($tabKey, $visible_customer_profile_tabs);
            }

update_option('visible_customer_profile_tabs', serialize($opt));
            add_option('230_cp_tabs_processed', 'true', 0);
        }

@$this->db->query('ALTER TABLE `tblprojects` CHANGE `name` `name` VARCHAR(191) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;');

$databaseName = APP_DB_NAME;
        $myISAMTables = $this->db->query("SELECT TABLE_NAME,
                             ENGINE
                            FROM information_schema.TABLES
                            WHERE TABLE_SCHEMA = '$databaseName' and ENGINE = 'myISAM'")->result_array();

foreach ($myISAMTables as $table) {
            $tableName = $table['TABLE_NAME'];
            $this->db->query("ALTER TABLE $tableName ENGINE=InnoDB;");
        }

if (file_exists(VIEWPATH . 'themes/perfex/scripts.php')) {
            @unlink(VIEWPATH . 'themes/perfex/scripts.php');
        }

$themes = get_all_client_themes();

foreach ($themes as $theme) {
            if ($theme != 'perfex') {
                if (!file_exists(VIEWPATH . 'themes/' . $theme . '/functions.php')) {
                    copy(VIEWPATH . 'themes/perfex/functions.php', VIEWPATH . 'themes/' . $theme . '/functions.php');
                }
            }
        }

$this->db->where('country_id', 130);
        $this->db->update('tblcountries', [
            'short_name' => 'North Macedonia',
            'long_name'  => 'Republic of North Macedonia',
        ]);

// Because the modules won't be loaded
        $this->app_modules->initialize();

foreach (uninstallable_modules() as $module) {
            $this->app_modules->activate($module);
        }

// Maybe is misssed from 201_version_201? Not sure why
 if (total_rows('tblemailtemplates', ['slug' => 'client-registration-confirmed']) == 0) {
 $this->db->query("INSERT INTO `tblemailtemplates` (`type`, `slug`, `language`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`) VALUES
('client', 'client-registration-confirmed', 'english', 'Customer Registration Confirmed', 'Your registration is confirmed', 'Dear {contact_firstname} {contact_lastname} We just wanted to let you know that your registration at&nbsp;{companyname} is successfully confirmed and your account is now active. You can login at&nbsp;<a href=\"{crm_url}\">{crm_url}</a> with the email and password you provided during registration. Please contact us if you need any help. Kind Regards, {email_signature}\r\n (This is an automated email, so please don\'t reply to this email address)', '{companyname} | CRM', '', 0, 1, 0);");
 }

// Moved to third_party
        if (file_exists(APPPATH . 'helpers/simple_html_dom_helper.php')) {
            @unlink(APPPATH . 'helpers/simple_html_dom_helper.php');
        }
    }
}

Nama File / Folder	Size	Action
Wp	--	NONE
101_version_101.php	3.733KB	Hapus Edit Rename
102_version_102.php	6.224KB	Hapus Edit Rename
104_version_104.php	9.096KB	Hapus Edit Rename
105_version_105.php	5.675KB	Hapus Edit Rename
109_version_109.php	14.297KB	Hapus Edit Rename
111_version_111.php	9.57KB	Hapus Edit Rename
112_version_112.php	0.739KB	Hapus Edit Rename
115_version_115.php	0.271KB	Hapus Edit Rename
117_version_117.php	10.891KB	Hapus Edit Rename
118_version_118.php	12.875KB	Hapus Edit Rename
119_version_119.php	1.602KB	Hapus Edit Rename
121_version_121.php	1.712KB	Hapus Edit Rename
122_version_122.php	2.77KB	Hapus Edit Rename
123_version_123.php	0.281KB	Hapus Edit Rename
125_version_125.php	0.281KB	Hapus Edit Rename
130_version_130.php	0.897KB	Hapus Edit Rename
132_version_132.php	0.294KB	Hapus Edit Rename
134_version_134.php	0.294KB	Hapus Edit Rename
136_version_136.php	0.294KB	Hapus Edit Rename
137_version_137.php	0.294KB	Hapus Edit Rename
138_version_138.php	0.294KB	Hapus Edit Rename
141_version_141.php	0.842KB	Hapus Edit Rename
142_version_142.php	0.842KB	Hapus Edit Rename
144_version_144.php	0.291KB	Hapus Edit Rename
148_version_148.php	0.291KB	Hapus Edit Rename
150_version_150.php	1.153KB	Hapus Edit Rename
153_version_153.php	0.291KB	Hapus Edit Rename
155_version_155.php	0.291KB	Hapus Edit Rename
156_version_156.php	0.291KB	Hapus Edit Rename
157_version_157.php	0.291KB	Hapus Edit Rename
160_version_160.php	2.27KB	Hapus Edit Rename
162_version_162.php	2.517KB	Hapus Edit Rename
165_version_165.php	0.282KB	Hapus Edit Rename
166_version_166.php	0.282KB	Hapus Edit Rename
167_version_167.php	0.282KB	Hapus Edit Rename
168_version_168.php	0.282KB	Hapus Edit Rename
172_version_172.php	0.283KB	Hapus Edit Rename
175_version_175.php	0.283KB	Hapus Edit Rename
177_version_177.php	0.283KB	Hapus Edit Rename
180_version_180.php	5.299KB	Hapus Edit Rename
181_version_181.php	0.787KB	Hapus Edit Rename
183_version_183.php	0.264KB	Hapus Edit Rename
184_version_184.php	0.264KB	Hapus Edit Rename
188_version_188.php	0.264KB	Hapus Edit Rename
189_version_189.php	0.264KB	Hapus Edit Rename
191_version_191.php	0.854KB	Hapus Edit Rename
192_version_192.php	3.287KB	Hapus Edit Rename
196_version_196.php	1.526KB	Hapus Edit Rename
198_version_198.php	2.598KB	Hapus Edit Rename
199_version_199.php	0.886KB	Hapus Edit Rename
200_version_200.php	26.133KB	Hapus Edit Rename
202_version_202.php	0.235KB	Hapus Edit Rename
203_version_203.php	0.235KB	Hapus Edit Rename
207_version_207.php	0.235KB	Hapus Edit Rename
210_version_210.php	2.168KB	Hapus Edit Rename
211_version_211.php	0.891KB	Hapus Edit Rename
213_version_213.php	0.291KB	Hapus Edit Rename
214_version_214.php	0.291KB	Hapus Edit Rename
215_version_215.php	0.291KB	Hapus Edit Rename
216_version_216.php	0.291KB	Hapus Edit Rename
218_version_218.php	0.291KB	Hapus Edit Rename
219_version_219.php	0.291KB	Hapus Edit Rename
221_version_221.php	0.94KB	Hapus Edit Rename
222_version_222.php	0.235KB	Hapus Edit Rename
225_version_225.php	0.291KB	Hapus Edit Rename
226_version_226.php	0.291KB	Hapus Edit Rename
229_version_229.php	0.291KB	Hapus Edit Rename
230_version_230.php	6.406KB	Hapus Edit Rename
237_version_237.php	0.235KB	Hapus Edit Rename
238_version_238.php	0.235KB	Hapus Edit Rename
241_version_241.php	1.335KB	Hapus Edit Rename
242_version_242.php	0.234KB	Hapus Edit Rename
248_version_248.php	0.234KB	Hapus Edit Rename
251_version_251.php	0.234KB	Hapus Edit Rename
253_version_253.php	0.234KB	Hapus Edit Rename
254_version_254.php	0.234KB	Hapus Edit Rename
255_version_255.php	0.234KB	Hapus Edit Rename
257_version_257.php	0.234KB	Hapus Edit Rename
259_version_259.php	0.234KB	Hapus Edit Rename
261_version_261.php	0.291KB	Hapus Edit Rename
262_version_262.php	0.291KB	Hapus Edit Rename
263_version_263.php	0.291KB	Hapus Edit Rename
264_version_264.php	0.291KB	Hapus Edit Rename
268_version_268.php	0.291KB	Hapus Edit Rename
269_version_269.php	0.291KB	Hapus Edit Rename
270_version_270.php	1.074KB	Hapus Edit Rename
271_version_271.php	3.423KB	Hapus Edit Rename
272_version_272.php	0.234KB	Hapus Edit Rename
273_version_273.php	1.81KB	Hapus Edit Rename
274_version_274.php	0.158KB	Hapus Edit Rename
276_version_276.php	0.158KB	Hapus Edit Rename
277_version_277.php	0.158KB	Hapus Edit Rename
281_version_281.php	0.158KB	Hapus Edit Rename
283_version_283.php	1.589KB	Hapus Edit Rename
285_version_285.php	0.168KB	Hapus Edit Rename
286_version_286.php	0.168KB	Hapus Edit Rename
287_version_287.php	0.168KB	Hapus Edit Rename
288_version_288.php	0.168KB	Hapus Edit Rename
293_version_293.php	0.168KB	Hapus Edit Rename
296_version_296.php	0.166KB	Hapus Edit Rename
297_version_297.php	0.166KB	Hapus Edit Rename
298_version_298.php	0.166KB	Hapus Edit Rename
299_version_299.php	0.166KB	Hapus Edit Rename
302_version_302.php	0.166KB	Hapus Edit Rename
303_version_303.php	0.166KB	Hapus Edit Rename
304_version_304.php	0.166KB	Hapus Edit Rename
index.html	0.128KB	Hapus Edit Rename