⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.1
Server IP:
185.238.29.86
Server:
Linux server2 6.8.12-6-pve #1 SMP PREEMPT_DYNAMIC PMX 6.8.12-6 (2024-12-19T19:05Z) x86_64
Server Software:
nginx/1.18.0
PHP Version:
8.1.31
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
home
/
python
/
yeni
/
Edit File: newcoin.sql
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Anamakine: localhost -- Üretim Zamanı: 07 Eyl 2023, 23:38:40 -- Sunucu sürümü: 8.0.33-0ubuntu0.20.04.2 -- PHP Sürümü: 8.1.17 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Veritabanı: `newcoin` -- -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `coinlist` -- CREATE TABLE `coinlist` ( `id` int NOT NULL, `symbol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci DEFAULT NULL, `side` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci DEFAULT NULL, `deeproi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci DEFAULT '0', `highroi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci DEFAULT '0', `isActive` tinyint DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci; -- -- Tablo döküm verisi `coinlist` -- INSERT INTO `coinlist` (`id`, `symbol`, `side`, `deeproi`, `highroi`, `isActive`) VALUES (1, 'EDUUSDT', 'SHORT', '0.8', '0', 0), (2, 'CVXUSDT', 'SHORT', '0', '2.71', 0), (3, 'HIGHUSDT', 'SHORT', '3.51', '0', 0), (4, 'HOOKUSDT', 'SHORT', '0', '0.59', 0), (5, 'SUIUSDT', 'SHORT', '0', '0', 1), (6, 'HFTUSDT', 'LONG', '0', '10.07', 0), (7, 'LEVERUSDT', 'LONG', '0', '6.56', 0), (8, 'BNXUSDT', 'SHORT', '0', '0', 0), (9, 'RNDRUSDT', 'SHORT', '2.58', '0', 0), (10, 'XVSUSDT', 'LONG', '0', '0', 0), (11, 'IDEXUSDT', 'LONG', '0', '0.65', 0), (12, 'SSVUSDT', 'SHORT', '0.81', '0', 0), (13, 'PHBUSDT', 'SHORT', '2.05', '0', 0), (14, 'QNTUSDT', 'LONG', '2.65', '0', 0), (15, 'RDNTUSDT', 'SHORT', '6.37', '0', 0), (16, 'MAGICUSDT', 'SHORT', '0.02', '0', 0), (17, 'FXSUSDT', 'LONG', '0', '0', 0), (18, 'IDUSDT', 'LONG', '2.63', '0', 0), (19, 'ARBUSDT', 'LONG', '0', '0', 0), (20, 'AMBUSDT', 'SHORT', '4.74', '0', 0), (21, 'JOEUSDT', 'LONG', '5.54', '0', 0), (22, 'TLMUSDT', 'LONG', '0', '2.89', 0), (23, 'PERPUSDT', 'LONG', '1.97', '0', 0), (24, 'TRUUSDT', 'SHORT', '5.47', '0', 0), (25, 'LQTYUSDT', 'LONG', '6.24', '0', 0), (26, 'CKBUSDT', 'LONG', '2.17', '0', 0), (27, 'ACHUSDT', 'LONG', '0', '3.56', 0), (28, 'STXUSDT', 'LONG', '4.78', '0', 0), (29, 'CFXUSDT', 'LONG', '0', '0', 0), (30, 'GMXUSDT', 'LONG', '0', '2.85', 0), (31, 'AGIXUSDT', 'LONG', '4.8', '0', 0), (32, 'ASTRUSDT', 'LONG', '4.78', '0', 0), (33, 'MINAUSDT', 'LONG', '0', '4.72', 0), (34, 'TUSDT', 'LONG', '1.69', '0', 0), (35, 'FETUSDT', 'LONG', '0', '4.38', 0), (36, 'APTUSDT', 'LONG', '4.73', '0', 0), (37, 'ICPUSDT', 'LONG', '4.07', '0', 0), (38, 'C98USDT', 'LONG', '1.31', '0', 0), (39, 'AVAXUSDT', 'LONG', '0.79', '0', 0), (40, 'DOTUSDT', 'LONG', '2.39', '0', 0); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `settings` -- CREATE TABLE `settings` ( `id` int NOT NULL, `binanceapikey` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `binancesecretkey` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `isTest` varchar(10) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Tablo döküm verisi `settings` -- INSERT INTO `settings` (`id`, `binanceapikey`, `binancesecretkey`, `isTest`) VALUES (1, 'oS2rflug1D5OIjXgJ7uwjba3yxBKZZJlGNMAegFkzaEyp95jio4G6EzToUEimoTm', '5QmpkUJyHvfcVOnq4SqmePn8HDIaPmHBxBG2Kr1yyo3lDglRy3HYhTN17e6kskE4', '0'); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `symbols` -- CREATE TABLE `symbols` ( `id` int NOT NULL, `symbol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `leverage` varchar(20) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '20', `margin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'DOLAR', `aralikyuzde` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'YÜZDE', `aralikmargin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'DOLAR', `hedef` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'DOLAR', `tp` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT 'ZARAR İŞLEMİ KAPATIR TEK KALAN İŞLEMDEN % DÜŞERSE KAPATIR YÜZDE', `isActive` tinyint NOT NULL DEFAULT '0' COMMENT 'YENİ İŞLEM ACMA TEKRARLAMA YAPMA', `isFollow` tinyint NOT NULL DEFAULT '0' COMMENT 'MANUEL KAPATMA İÇİN', `isReset` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT 'MANUEL KAPAMANINCA SIFIRLA SAYMA İPTAL OLUYOR 1 YAPCAN KENDİ SIFIR OLUCAK', `waitTime` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0', `closedDateTime` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Tablo döküm verisi `symbols` -- INSERT INTO `symbols` (`id`, `symbol`, `leverage`, `margin`, `aralikyuzde`, `aralikmargin`, `hedef`, `tp`, `isActive`, `isFollow`, `isReset`, `waitTime`, `closedDateTime`) VALUES (1, 'HBARUSDT', '20', '1', '2', '10', '0.1', '2', 0, 1, '0', '10', '2023-08-26 20:59:17'), (2, 'XVSUSDT', '20', '1', '2', '10', '0.1', '2', 0, 1, '0', '10', '2023-09-07 23:34:13'), (3, 'BNXUSDT', '20', '20', '3', '1', '1', '50', 0, 1, '0', '10', '2023-08-17 14:48:10'), (4, 'NMRUSDT', '20', '20', '20', '1', '2', '1', 0, 1, '0', '10', '2023-08-17 14:48:10'), (5, 'SUIUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (6, 'HFTUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (7, 'LEVERUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (8, 'BNXUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (9, 'RNDRUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (10, 'XVSUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-09-07 23:34:13'), (11, 'IDEXUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (12, 'SSVUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (13, 'PHBUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (14, 'QNTUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (15, 'RDNTUSDT', '20', '10', '2', '1', '1', '10', 0, 1, '0', '10', '2023-08-17 14:48:10'), (16, 'MAGICUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (17, 'FXSUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (19, 'ARBUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (20, 'AMBUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (21, 'JOEUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (22, 'TLMUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (23, 'PERPUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (24, 'TRUUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (25, 'LQTYUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (26, 'CKBUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (27, 'ACHUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (28, 'STXUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (29, 'CFXUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (30, 'GMXUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (31, 'AGIXUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (32, 'ASTRUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (33, 'MINAUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (34, 'TUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (35, 'FETUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (36, 'APTUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (37, 'ICPUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (38, 'C98USDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (39, 'AVAXUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (40, 'DOTUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (41, 'EDUUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-26 20:59:17'), (42, 'CVXUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (43, 'HIGHUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'), (44, 'HOOKUSDT', '20', '10', '2', '0.5', '0.5', '0', 0, 1, '0', '10', '2023-08-17 14:48:10'); -- -- Dökümü yapılmış tablolar için indeksler -- -- -- Tablo için indeksler `coinlist` -- ALTER TABLE `coinlist` ADD PRIMARY KEY (`id`); -- -- Tablo için indeksler `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`); -- -- Tablo için indeksler `symbols` -- ALTER TABLE `symbols` ADD PRIMARY KEY (`id`); -- -- Dökümü yapılmış tablolar için AUTO_INCREMENT değeri -- -- -- Tablo için AUTO_INCREMENT değeri `coinlist` -- ALTER TABLE `coinlist` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41; -- -- Tablo için AUTO_INCREMENT değeri `settings` -- ALTER TABLE `settings` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- Tablo için AUTO_INCREMENT değeri `symbols` -- ALTER TABLE `symbols` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=441; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Simpan