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(

//-----------------Update assets version-------------------//
		"UPDATE `tbl_gf_email_settings` SET `assets_version` = `assets_version` + 1;",

//-----------------Disable Two step verification-------------------//
		"UPDATE `tbl_gf_admin` SET `GoogleAuth` = '3' WHERE `GoogleAuth` = '0';",
		"UPDATE `tbl_gf_admin` SET `GoogleAuth` = '0' WHERE `GoogleAuth` = '1';",
		"UPDATE `tbl_gf_users` SET `TwoStepVerification` = '3' WHERE `TwoStepVerification` = '0';",
		"UPDATE `tbl_gf_users` SET `TwoStepVerification` = '0' WHERE `TwoStepVerification` = '1';",

//---------------AddFieldsin tbl_gf_email_settings----------------\\
		"ALTER TABLE `tbl_gf_email_settings` ADD `SendNewRemoteOrderEmail` TINYINT(1) NULL DEFAULT '0';",
		"ALTER TABLE `tbl_gf_email_settings` ADD `SendSuccessRemoteOrderEmail` TINYINT(1) NULL DEFAULT '1';",
		"ALTER TABLE `tbl_gf_email_settings` ADD `SendFailureRemoteOrderEmail` TINYINT(1) NULL DEFAULT '1';",
		"ALTER TABLE `tbl_gf_email_settings` ADD `SendNewRetailOrderEmail` TINYINT(1) NULL DEFAULT '0';",
		"ALTER TABLE `tbl_gf_email_settings` ADD `SendSuccessRetailOrderEmail` TINYINT(1) NULL DEFAULT '1';",
		"ALTER TABLE `tbl_gf_email_settings` ADD `SendFailureRetailOrderEmail` TINYINT(1) NULL DEFAULT '1';",
		"ALTER TABLE `tbl_gf_email_settings` ADD `AllowAPI` TINYINT(4) NULL DEFAULT '0';",
		"ALTER TABLE `tbl_gf_email_settings` ADD `AllowPageRestrictions` TINYINT(4) NULL DEFAULT '1';",
		"ALTER TABLE `tbl_gf_email_settings` ADD `PagePopup` TINYINT NOT NULL DEFAULT '0'",

//---------------------AddFieldsin tbl_gf_users------------------------\\
		"ALTER TABLE `tbl_gf_admin` ADD `QRPath` LONGTEXT NOT NULL;",
		"ALTER TABLE `tbl_gf_admin` ADD `adminEmail` VARCHAR(100) DEFAULT NULL;",
		"ALTER TABLE `tbl_gf_admin` ADD `DAactiveQR` VARCHAR(255) NULL;",
		
		//---------------------AddFieldsin tbl_gf_users------------------------\\
		"ALTER TABLE `tbl_gf_users` ADD `AllowIMEI_Order` TINYINT(4) NULL DEFAULT '1', ADD `AllowIMEI_OrderHistory` TINYINT(4) NULL DEFAULT '1';",
		"ALTER TABLE `tbl_gf_users` ADD `QRPath` LONGTEXT NOT NULL;",
		"ALTER TABLE `tbl_gf_users` ADD `DAactiveQR` VARCHAR(255) NULL;",

//---------------------CreateTable tbl_gf_docs------------------------------\\
		"CREATE TABLE `tbl_gf_docs` ( `id` int(11) NOT NULL, `userId` int(11) DEFAULT NULL, `fLabel` varchar(255) DEFAULT NULL, `docsFile` varchar(255) DEFAULT NULL, `docsStatus` tinyint(4) DEFAULT 1, `created_at` timestamp(6) NOT NULL DEFAULT current_timestamp(6), `updated_at` timestamp(6) NULL DEFAULT NULL);",
		"ALTER TABLE `tbl_gf_docs` ADD PRIMARY KEY (`id`);",
		"ALTER TABLE `tbl_gf_docs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;",
);

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']]);
	}
}