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
View File Name : ayaryaz.py

import time
import json
import redis
import copy
import pymysql
from datetime import datetime

r = redis.Redis()

def add_from_mysql(symbol):
    islem.execute("select * from symbols where symbol=%s",symbol)
    ayar=islem.fetchone()
    if ayar:
        data = r.hget("symbols", symbol)
        if data:
            data = json.loads(data)
            if ayar['isReset']=="1":
                if "longsay" in data:
                    data.pop("longsay")
                if "shortsay" in data:
                    data.pop("shortsay")
                data['L_roi']="0"
                data['S_roi']="0"
                islem.execute('update `symbols` set `isReset`="0" where `symbol`=%s',symbol)
                baglanti.commit()
            data["margin"] = ayar['margin']
            data["leverage"] = ayar['leverage']
            data["aralikyuzde"]=ayar['aralikyuzde']
            data["aralikmargin"]=ayar['aralikmargin']
            data["hedef"]=ayar['hedef']
            data["tp"]=ayar['tp']
            data["isActive"]=ayar['isActive']
            data["isFollow"]=ayar['isFollow']
            data["waitTime"] = ayar['waitTime']
            closedDateTime=datetime.strptime(str(ayar['closedDateTime']), '%Y-%m-%d %H:%M:%S')
            data["closedDateTime"] = closedDateTime.isoformat()
        else:
            closedDateTime=datetime.strptime(str(ayar['closedDateTime']), '%Y-%m-%d %H:%M:%S')
            data = {
                "margin": ayar['margin'],
                "leverage":ayar['leverage'],
                "aralikyuzde": ayar['aralikyuzde'],
                "aralikmargin": ayar['aralikmargin'],
                "hedef": ayar['hedef'],
                "tp": ayar['tp'],
                "isActive": ayar['isActive'],
                "isFollow": ayar['isFollow'],
                "waitTime": ayar['waitTime'],
                "closedDateTime": closedDateTime.isoformat() 
            }
            if ayar['isReset']=="1":
                if "longsay" in data:
                    data.pop("longsay")
                if "shortsay" in data:
                    data.pop("shortsay")
                data['L_roi']="0"
                data['S_roi']="0"
                islem.execute('update `symbols` set `isReset`="0" where `symbol`=%s',symbol)
                baglanti.commit()
        r.hset("symbols", symbol, json.dumps(data))
      
try:
    baglanti = pymysql.connect(
        host='127.0.0.1',
        db='newcoin',
        user='root',
        password='Ua04420076*',
        port=3306,
        charset='utf8mb4',
        cursorclass=pymysql.cursors.DictCursor
    )
    with baglanti.cursor() as islem:
        while True:
            islem.execute('SELECT * from `settings` where `id`=1')
            ayar = islem.fetchone()
            baglanti.commit()
            if ayar is not None:
                if r.hexists("settings", "binanceapikey"):
                    r_binanceapikey = r.hget("ayarlar", "binanceapikey").decode("utf-8")
                    if r_binanceapikey != ayar['binanceapikey']:
                        r.hset("ayarlar", "binanceapikey", ayar['binanceapikey'])
                else:
                    r_binanceapikey = ayar['binanceapikey']
                    r.hset("ayarlar", "binanceapikey", r_binanceapikey)
                if r.hexists("settings", "binancesecretkey"):
                    r_binancesecretkey = r.hget("ayarlar", "binancesecretkey").decode("utf-8")
                    if r_binancesecretkey != ayar['binancesecretkey']:
                        r.hset("ayarlar", "binancesecretkey", ayar['binancesecretkey'])
                else:
                    r_binancesecretkey = ayar['binancesecretkey']
                    r.hset("ayarlar", "binancesecretkey", r_binancesecretkey)
            else:
                print("Ayarlar veritabanında bulunamadı.")
            islem.execute('SELECT * from `symbols`')
            symbolayar = islem.fetchall()
            baglanti.commit()
            if symbolayar:
                for symbol in symbolayar:
                    if symbol:
                        add_from_mysql(symbol['symbol'])
                    
finally:
    if 'baglanti' in locals():
        baglanti.close()