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 
		"update `tbl_gf_email_settings` set `assets_version` = `assets_version` + 1;",

// CREATE 
		"CREATE TABLE `tbl_gf_clients_pr_position` (
		  `id` int(11) NOT NULL,
		  `position` varchar(255) DEFAULT NULL
		)",
		
		"CREATE TABLE `tbl_gf_home_news_popup` (
		  `id` int(11) NOT NULL,
		  `title` varchar(255) DEFAULT NULL,
		  `description` longtext DEFAULT NULL,
		  `status` tinyint(4) DEFAULT 0
		)",

// INSERT
		"INSERT INTO `tbl_gf_forms` (`FormId`, `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES (NULL, 'Auto API Pricing', '13', '', '0', '0', '".$CI->config->item('apanel_name')."/settings/dcposition');",
		
		"INSERT INTO `tbl_gf_forms` (`FormId`, `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES (NULL, 'Website Popup', '5', '', '0', '0', '".$CI->config->item('apanel_name')."/clients/newspopuphome');",
		"UPDATE `tbl_gf_forms` SET FormUrlNew = '".$CI->config->item('apanel_name')."/clients/clientgroups' where FormUrlNew = 'clientgroups.php';",
		// DELETE
		"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 )",
		// ALTER

"ALTER TABLE `tbl_gf_client_prices_notice` CHANGE `updatedAt` `updatedAt` DATETIME NULL DEFAULT CURRENT_TIMESTAMP;", 
		"ALTER TABLE `tbl_gf_client_prices_notice` ADD INDEX(`updatedAt`);",
		"ALTER TABLE `tbl_gf_client_prices_notice` ADD INDEX(`PackageId`);",
		
		"ALTER TABLE `tbl_gf_group_prices_notice` CHANGE `updatedAt` `updatedAt` DATETIME NULL DEFAULT CURRENT_TIMESTAMP;",
		"ALTER TABLE `tbl_gf_group_prices_notice` ADD INDEX(`updatedAt`);",
		"ALTER TABLE `tbl_gf_group_prices_notice` ADD INDEX(`PackageId`);",

"ALTER TABLE `tbl_gf_default_prices_notice` CHANGE `updatedAt` `updatedAt` DATETIME NULL DEFAULT CURRENT_TIMESTAMP;",
		"ALTER TABLE `tbl_gf_default_prices_notice` ADD INDEX(`updatedAt`);",
		"ALTER TABLE `tbl_gf_default_prices_notice` ADD INDEX(`PackageId`);",
		"delete from `tbl_gf_group_prices_notice` where Id not in ( select minid from (select min(Id) as minid from `tbl_gf_group_prices_notice` group by PackageId, PackTitle, PlanId, UserId, CurrencyId,ServiceType) as newtable );",

"ALTER TABLE `tbl_gf_home_news_popup` ADD PRIMARY KEY (`id`);",
		"ALTER TABLE `tbl_gf_home_news_popup` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;",
		"ALTER TABLE `tbl_gf_clients_pr_position` ADD PRIMARY KEY (`id`);",
		"ALTER TABLE `tbl_gf_clients_pr_position` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;",
		"ALTER TABLE `tbl_gf_users`  ADD `verifiedUser` TINYINT NULL DEFAULT '1';",
		"ALTER TABLE `tbl_gf_users` CHANGE `verifiedUser` `verifiedUser` TINYINT(4) NULL DEFAULT '0';",

);

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