-- proxy2.webshare.io

INSERT INTO proxy_ips (id, ip_address, port, country_id, protocol, ping_time, api_hit, success_rate) VALUES (NULL, '2.56.119.93', '5074', 32, 'HTTP', 0, 0, 0);
INSERT INTO proxy_ips (id, ip_address, port, country_id, protocol, ping_time, api_hit, success_rate) VALUES (NULL, '185.199.229.156', '7492', 18, 'HTTP', 0, 0, 0);
INSERT INTO proxy_ips (id, ip_address, port, country_id, protocol, ping_time, api_hit, success_rate) VALUES (NULL, '185.199.228.220', '7300', 18, 'HTTP', 0, 0, 0);
INSERT INTO proxy_ips (id, ip_address, port, country_id, protocol, ping_time, api_hit, success_rate) VALUES (NULL, '185.199.231.45', '8382', 18, 'HTTP', 0, 0, 0);
INSERT INTO proxy_ips (id, ip_address, port, country_id, protocol, ping_time, api_hit, success_rate) VALUES (NULL, '188.74.210.207', '6286', 73, 'HTTP', 0, 0, 0);
INSERT INTO proxy_ips (id, ip_address, port, country_id, protocol, ping_time, api_hit, success_rate) VALUES (NULL, '188.74.183.10', '8279', 73, 'HTTP', 0, 0, 0);
INSERT INTO proxy_ips (id, ip_address, port, country_id, protocol, ping_time, api_hit, success_rate) VALUES (NULL, '188.74.210.21', '6100', 73, 'HTTP', 0, 0, 0);
INSERT INTO proxy_ips (id, ip_address, port, country_id, protocol, ping_time, api_hit, success_rate) VALUES (NULL, '45.155.68.129', '8133', 2, 'HTTP', 0, 0, 0);
INSERT INTO proxy_ips (id, ip_address, port, country_id, protocol, ping_time, api_hit, success_rate) VALUES (NULL, '154.95.36.199', '6893', 18, 'HTTP', 0, 0, 0);
INSERT INTO proxy_ips (id, ip_address, port, country_id, protocol, ping_time, api_hit, success_rate) VALUES (NULL, '45.94.47.66', '8110', 2, 'HTTP', 0, 0, 0);

UPDATE `proxy_ips` SET `status` = 'Inactive' WHERE 1;

INSERT INTO proxy_ips (id, ip_address, port, country_id, protocol, ping_time, api_hit, success_rate) VALUES (NULL, '34.216.20.154', '8888', 32, 'HTTP', 0, 0, 0);

-- UPDATE `proxy_ips` SET `username` = 'ftlihemo' WHERE 1;
-- UPDATE `proxy_ips` SET `password` = 'z4rsgzqmco17' WHERE 1;

UPDATE `proxy_ips` SET `status` = 'Inactive' WHERE `proxy_ips`.`ip_address` = '34.216.20.154';

INSERT INTO proxy_ips (id, ip_address, port, country_id, protocol, ping_time, api_hit, success_rate) VALUES (NULL, '54.146.30.177', '3128', 32, 'HTTP', 0, 0, 0);
UPDATE `proxy_ips` SET `country_id` = '32' WHERE `proxy_ips`.`ip_address` = '154.95.36.199';
UPDATE `proxy_ips` SET `status` = 'Inactive' WHERE `proxy_ips`.`ip_address` = '2.56.119.93';


UPDATE `proxy_ips` SET `username` = 'qgpZHUKvDT' WHERE 1;
UPDATE `proxy_ips` SET `password` = 'PhkxIzTcqPtz' WHERE 1;

-- 27/09/2023
UPDATE `proxy_ips` SET `status` = 'Inactive' WHERE 1;

INSERT INTO `proxy_ips` (`id`, `ip_address`, `port`, `country_id`, `protocol`, `ping_time`, `api_hit`, `success_rate`, `status`, `is_blocked`, `updated_at`, `created_at`, `username`, `password`) VALUES
(23, '192.177.86.26', '6581', 32, 'HTTP', 0, 0, 0, 'Active', 'N', '2023-09-27 14:53:45', '2023-09-27 14:53:45', 'qgpZHUKvDT', 'PhkxIzTcqPtz'),
(24, '64.137.90.219', '5839', 77, 'HTTP', 0, 0, 0, 'Active', 'N', '2023-09-27 14:53:45', '2023-09-27 14:53:45', 'qgpZHUKvDT', 'PhkxIzTcqPtz'),
(25, '45.157.126.249', '6205', 37, 'HTTP', 0, 0, 0, 'Active', 'N', '2023-09-27 14:53:46', '2023-09-27 14:53:46', 'qgpZHUKvDT', 'PhkxIzTcqPtz'),
(26, '103.53.216.84', '5168', 12, 'HTTP', 0, 0, 0, 'Active', 'N', '2023-09-27 14:53:46', '2023-09-27 14:53:46', 'qgpZHUKvDT', 'PhkxIzTcqPtz'),
(27, '206.41.168.80', '6745', 19, 'HTTP', 0, 0, 0, 'Active', 'N', '2023-09-27 14:53:47', '2023-09-27 14:53:47', 'qgpZHUKvDT', 'PhkxIzTcqPtz');
INSERT INTO `countries` (`id`, `country_name`, `country_code`, `country_flag`, `updated_at`, `created_at`) VALUES (NULL, 'Japan', 'JP', 'jp.png', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

-- 02/10/2023
INSERT INTO `countries` (`id`, `country_name`, `country_code`, `country_flag`, `updated_at`, `created_at`) VALUES (NULL, 'Argentina', 'AR', 'ar.png', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), (NULL, 'Seychelles', 'SC', 'sc.png', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `countries` (`id`, `country_name`, `country_code`, `country_flag`, `updated_at`, `created_at`) VALUES (NULL, 'Malaysia', 'MY', 'my.png', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

-- 30/10/2023
INSERT INTO `proxy_ips` (`id`, `ip_address`, `port`, `country_id`, `protocol`, `ping_time`, `api_hit`, `success_rate`, `status`, `is_blocked`, `updated_at`, `created_at`, `username`, `password`) VALUES (NULL, 'us-streaming-east.keenvpn.me', '3129', '32', 'HTTP', '0', '0', '0', 'Active', 'N', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'vmst_tgpeidkqn', 'lKwCNU5VY');

-- 31/10/2023
CREATE EVENT `set_is_expired_flag_if_expired` ON SCHEDULE EVERY 1 MINUTE ON COMPLETION NOT PRESERVE ENABLE DO UPDATE vpn_wholesaler_users set is_expired = 1 WHERE expired_at <= NOW() AND is_expired = 0;
