| Server IP : 103.161.17.216 / Your IP : 216.73.216.1 Web Server : nginx/1.18.0 System : Linux tipsysaigoncharming 5.4.0-216-generic #236-Ubuntu SMP Fri Apr 11 19:53:21 UTC 2025 x86_64 User : www-data ( 33) PHP Version : 7.4.3-4ubuntu2.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/app.houseland.info/application/migrations/ |
Upload File : |
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Migration_Version_119 extends CI_Migration
{
function __construct()
{
parent::__construct();
}
public function up()
{
add_option('use_recaptcha_customers_area',0);
add_option('remove_decimals_on_zero',0);
add_option('remove_tax_name_from_item_table',0);
$tallowed = get_option('ticket_attachments_file_extensions');
$tallowed = explode('|',$tallowed);
$tallowed_new = '';
if(is_array($tallowed)){
foreach($tallowed as $ext){
$tallowed_new .= '.'.$ext.',';
}
}
if($tallowed_new != ''){
$tallowed_new = substr($tallowed_new,0,-1);
}
update_option('ticket_attachments_file_extensions',$tallowed_new);
$this->db->query("ALTER TABLE `tblestimates` CHANGE `discount_percent` `discount_percent` DECIMAL( 11, 2 ) NOT NULL DEFAULT '0.00' ;");
$this->db->query("ALTER TABLE `tblinvoices` CHANGE `discount_percent` `discount_percent` DECIMAL( 11, 2 ) NOT NULL DEFAULT '0.00' ;");
$this->db->query("ALTER TABLE `tblestimates` CHANGE `discount_total` `discount_total` DECIMAL( 11, 2 ) NOT NULL DEFAULT '0.00' ;");
$this->db->query("ALTER TABLE `tblinvoices` CHANGE `discount_total` `discount_total` DECIMAL( 11, 2 ) NOT NULL DEFAULT '0.00' ;");
$this->db->query("ALTER TABLE `tblstafftasks` CHANGE `priority` `priority` INT(11) NULL DEFAULT NULL;");
update_option('update_info_message', '<script>window.location.reload();</script>');
}
}