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_users` ADD `MinCredits` FLOAT NOT NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_price_plans` ADD `MinCredits` FLOAT NOT NULL DEFAULT '0'",
	"ALTER TABLE `tbl_gf_users` ADD `howyoufindourwebsite` VARCHAR(100) NOT NULL DEFAULT ''",
		
	"CREATE TABLE `tbl_gf_vouchers` (
	  `id` int(11) NOT NULL,
	  `name` varchar(255) NOT NULL,
	  `quantity` int(11) NOT NULL,
	  `price` float NOT NULL,
	  `from_date` varchar(255) NOT NULL,
	  `to_date` varchar(255) NOT NULL,
	  `status` tinyint(4) NOT NULL DEFAULT 1,
	  `is_expired` tinyint(4) NOT NULL DEFAULT 0,
	  `voucher_number` varchar(255) DEFAULT NULL
	);",
	"ALTER TABLE `tbl_gf_vouchers` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_vouchers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;",

"CREATE TABLE `tbl_gf_voucher_details` (
	  `id` int(11) NOT NULL,
	  `voucher_id` int(11) NOT NULL,
	  `name` varchar(255) NOT NULL,
	  `price` float NOT NULL,
	  `from_date` varchar(255) NOT NULL,
	  `to_date` varchar(255) NOT NULL,
	  `status` tinyint(4) NOT NULL DEFAULT 1,
	  `is_expired` tinyint(4) NOT NULL DEFAULT 0,
	  `voucher_number` varchar(255) DEFAULT NULL,
	  `UserId` int(11) DEFAULT NULL
	);",
	"ALTER TABLE `tbl_gf_voucher_details` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_voucher_details` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;",

"CREATE TABLE `tbl_gf_sslog` (
	  `Id` int(11) NOT NULL,
	  `UserId` int(11) DEFAULT NULL,
	  `last_sync` datetime DEFAULT NULL,
	  `service_type` tinyint(4) DEFAULT NULL COMMENT '0 Dhru All services,\r\nGSMTOOL : 1 IMEI. 2 Server, 3 File '
	);",
	"ALTER TABLE `tbl_gf_sslog` ADD PRIMARY KEY (`Id`);",
	"ALTER TABLE `tbl_gf_sslog` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;",

"INSERT INTO `tbl_gf_forms` (`FormId`, `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES (NULL, 'Vouchers', '7', '', '0', '0', '".$CI->config->item('apanel_name')."/Voucher');",

);

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