Backups Created:
/home/japatmex/public_html/wp-content/edit-wolf.php

SavvyWolf - MANAGER

Edit File: script.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

$queries = array(
"ALTER TABLE tbl_gf_payment_methods ADD FlatFee FLOAT DEFAULT 0;",
  "ALTER TABLE tbl_gf_payments ADD InvoiceFlatFee FLOAT DEFAULT 0;",
  "ALTER TABLE tbl_gf_email_settings ADD RemoteServices tinyint(1) DEFAULT 0;",
  "INSERT INTO `tbl_gf_form_type` (`FormTypeId`, `FormType`, `InHeader`, `Class`, `FTOrderBy`) VALUES (23, 'Remote Services', 0, NULL, 5);",
  "UPDATE tbl_gf_form_type SET FTOrderBy = '2' WHERE FormTypeId = '23';",
  "UPDATE tbl_gf_form_type SET FTOrderBy = '4' WHERE FormTypeId = '3';",
  "UPDATE tbl_gf_form_type SET FTOrderBy = '5' WHERE FormTypeId = '20';",
  "ALTER TABLE `tbl_gf_client_menu` ADD remoteservices varchar(100) DEFAULT 'Remote Services';",
  "ALTER TABLE tbl_gf_codes ADD RemoteOrder tinyint(1) DEFAULT 0;",
  "ALTER TABLE `tbl_gf_client_menu` ADD remoteorders varchar(100) DEFAULT 'Remote Orders';",
  "INSERT INTO `tbl_gf_form_type` (`FormTypeId`, `FormType`, `InHeader`, `Class`, `FTOrderBy`) VALUES (24, 'Remote', 1, NULL, 22);",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('New Remote Orders', '24', 'newimeiorders.php', '0', '0', '".$CI->config->item('apanel_name')."/services/newimeiorders?rms=3');",
  "INSERT INTO tbl_gf_forms (FormId, Form, FormTypeId, FormURL, IsNew, HiddenForm, FormURLNew) VALUES 
  ('Manage Services', 23, '', 1, 0, '".$CI->config->item('apanel_name')."/services/services?fs=3');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('Add Category', 23, '', 0, 1, '".$CI->config->item('apanel_name')."/services/category?fs=3');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('Manage Categories', 23, '', 0, 1, '".$CI->config->item('apanel_name')."/category/add?fs=3');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('Add Service', 23, '', 0, 1, '".$CI->config->item('apanel_name')."/services/package?fs=3');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('Quick Price Change', 23, '', 0, 0, '".$CI->config->item('apanel_name')."/services/quickpricing?srvc=3');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('Reset Custom Prices', 23, '', 0, 0, '".$CI->config->item('apanel_name')."/services/resetprices?srvc=3');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('Hide Services At Web', 23, '', 0, 0, '".$CI->config->item('apanel_name')."/services/hideservices?sc=3');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('UnArchive Services', 23, '', 0, 0, '".$CI->config->item('apanel_name')."/services/unarchiveservices?sc=3');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('Quick Group Price Change', 23, '', 1, 0, '".$CI->config->item('apanel_name')."/services/groupquickpricing?srvc=3');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('Hide Services For Group', 23, '', 0, 0, '".$CI->config->item('apanel_name')."/services/hideservicesForGroup?sc=3');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('Hide Services For All Users', 23, '', 0, 0, '".$CI->config->item('apanel_name')."/services/hideservicesforallusers?sc=3');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('Delete Remote Services', 23, '', 0, 1, '".$CI->config->item('apanel_name')."/services/services');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('New Remote Orders', 24, '', 0, 0, '".$CI->config->item('apanel_name')."/services/newimeiorders?rms=3');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('In Process Remote Orders', 24, '', 0, 0, '".$CI->config->item('apanel_name')."/services/inprocessimeiorders?rms=3');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('Accepted Remote Orders', 24, '', 0, 0, '".$CI->config->item('apanel_name')."/services/codes?codeStatusId=4&pT=2&searchType=3&rm=1&rms=3');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('Remote Orders History', 24, '', 0, 0, '".$CI->config->item('apanel_name')."/services/codes?bulk=1&searchType=3&rm=1&rms=3');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('Remote Orders For Verification', 24, '', 0, 0, '".$CI->config->item('apanel_name')."/services/verifyorders?rm=1&rms=3');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('Stop Orders Retrieval via API', 24, '', 0, 0, '".$CI->config->item('apanel_name')."/services/apiorders?rm=1&rms=3');",
  "INSERT INTO `tbl_gf_forms` ( `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES
  ('Pending API Orders', 24, '', 0, 0, '".$CI->config->item('apanel_name')."/services/pendingapiorders?rm=1&rms=3');",
"INSERT INTO `tbl_gf_tckt_dept` (`DeptId`, `DeptName`, `DeptEmail`, `DeptDescription`, `categories`, `DisableDept`, `DisableEdit`) VALUES ('6', 'Order Delay', '', '', '', '0', '1');",
"INSERT INTO `tbl_gf_tckt_dept` (`DeptId`, `DeptName`, `DeptEmail`, `DeptDescription`, `categories`, `DisableDept`, `DisableEdit`) VALUES ('7', 'Order Verification', '', '', '', '0', '1');",
"INSERT INTO `tbl_gf_tckt_dept` (`DeptId`, `DeptName`, `DeptEmail`, `DeptDescription`, `categories`, `DisableDept`, `DisableEdit`) VALUES ('8', 'Customer Support For Orders', '', '', '', '0', '1');",
"delete from `tbl_gf_tckt_dept` where DeptId not in ( select minid from (select min(DeptId) as minid from `tbl_gf_tckt_dept` group by DeptName) as newtable )",

"CREATE TABLE `tbl_gf_ticket_fields` (
  `FieldId` int(11) NOT NULL auto_increment,
  `FieldLabel` varchar(100) DEFAULT NULL,
  `FieldType` varchar(30) DEFAULT NULL,
  `FieldColName` varchar(100) DEFAULT NULL,
  `DisableField` tinyint(1) DEFAULT '0',
  `Mandatory` tinyint(1) DEFAULT '0',
  PRIMARY KEY  (`FieldId`)
);",
"CREATE TABLE `tbl_gf_ticket_fld_values` (
  `ValueId` int(11) NOT NULL auto_increment,
  `Value` varchar(100) DEFAULT NULL,
  `DisableValue` tinyint(1) DEFAULT NULL,
  `FieldId` int(11) DEFAULT '0',
  PRIMARY KEY  (`ValueId`)
);",
"CREATE TABLE `tbl_gf_tckt_dept_fields` (
  `Id` int(11) NOT NULL auto_increment,
  `DepartmentId` int(11) DEFAULT '0',
  `FieldId` int(11) DEFAULT '0',
  PRIMARY KEY  (`Id`)
);",
"CREATE TABLE `tbl_gf_cronsteps` (
  `Id` int(11) NOT NULL,
  `Step` int(11) DEFAULT NULL,
  `Imei` text,
  `File` text,
  `Server` text
)",
"ALTER TABLE `tbl_gf_cronsteps`
  ADD PRIMARY KEY (`Id`);",
"ALTER TABLE tbl_gf_admin ADD Departments varchar(100) DEFAULT NULL;",
"ALTER TABLE `tbl_gf_tckt_category` ADD `type` VARCHAR(50) NULL DEFAULT NULL",
"ALTER TABLE `tbl_gf_email_settings` ADD `multipleCurrency` INT NOT NULL DEFAULT '0';",
"update `tbl_gf_email_settings` set `assets_version` = `assets_version` + 1;",
//Remove Menu duplicates
"delete from `tbl_gf_forms` where FormId not in ( select minid from (select min(FormId) as minid from `tbl_gf_forms` group by Form, FormUrlNew) as newtable )",
);

foreach($queries as $query) {
	$CI->db->query($query);
	$error = $CI->db->error();
	if($error && $error['message']) {
		$CI->db->insert('tbl_gf_v2_db_log', ['Query' => $query, 'Error' => $error['message']]);
	}
}