def tx_notification():
print("asdasndas,na")
mycursor.execute(
'SELECT address,type_id FROM sws_address WHERE tx_notification_preferred = "1"'
)
sws_addresses = mycursor.fetchall()
print(sws_addresses)
for addres in sws_addresses:
address = addres[0]
type_id = addres[1]
if type_id == 1:
symbol = 'ETH'
currency = eth_notification(address, symbol, type_id)
if type_id == 2:
symbol = 'BTC'
currency = btc_notification(address, symbol, type_id)
'''
if type_id == 75:
symbol = 'XRP'
currency = xrp_notification(address,symbol,type_id)
if type_id == 12:
symbol = 'BCH'
currency = bch_notification(address,symbol,type_id)
if type_id == 53:
symbol = 'LTC'
currency = ltc_notification(address,symbol,type_id)
if type_id == 35:
symbol = 'EOS'
currency = eos_notification(address,symbol,type_id)
if type_id == 11:
symbol = 'BNB'
currency = bnb_notification(address,symbol,type_id)
if type_id == 15:
symbol = 'BSV'
currency = bsv_notification(address,symbol,type_id)
'''
'''
def Top_user_percentage():
print("runnnnnn")
mycursor.execute('SELECT address,address_risk_score FROM sws_address')
check = mycursor.fetchall()
all_records_count = len(check)
data = []
for record in check:
risk_score = record[1]
data.append(risk_score)
for score in check:
r_address = score[0]
r_score = score[1]
count = 1
for scr in data:
if r_score < scr:
count = count + 1
calculating = all_records_count * count / all_records_count
print(r_address)
print(calculating)
mycursor.execute('UPDATE sws_address SET address_top_rate ="' +
str(calculating) + '" WHERE address = "' +
str(r_address) + '"')
mydb.commit()
'''
def profile_risk_score():
print("asdasndas,na")
mycursor.execute('SELECT username FROM sws_user')
sws_users = mycursor.fetchall()
for user in sws_users:
user_name=user[0]
mycursor.execute('SELECT address_risk_score FROM sws_address WHERE cms_login_name="'+str(user_name)+'"')
risk_scores = mycursor.fetchall()
list_of_scores=[]
for risk_score in risk_scores:
score = risk_score[0]
list_of_scores.append(score)
if list_of_scores:
avrage = np.mean(list_of_scores)
mycursor.execute('SELECT profile_risk_score_by_kyc_options FROM sws_user WHERE username="******"')
risk_scores = mycursor.fetchone()
risk_score_kyc = risk_scores[0]
final_profile_riskscore=risk_score_kyc+avrage
mycursor.execute('UPDATE sws_user SET profile_risk_score="'+str(final_profile_riskscore)+'" WHERE username = "******"')
def auto_fetch():
print("runing")
response_user_token = requests.get(url=ETH_SCAM_URL)
mycursor.execute("""CREATE TABLE IF NOT EXISTS `sws_heist_address` ( id INT,coin varchar(100),tag_name varchar(100),status varchar(100),address varchar(100),source varchar(1000),subcategory varchar(100),description varchar(1500),also_known_as varchar(1000))""")
response = response_user_token.json()
result = response['result']
if result:
for record in result:
if "addresses" in record:
coin = record['coin']
category = record['category']
status = record['status']
url = record['url']
if "subcategory" in record:
subcate = record['subcategory']
else:
subcate = ""
subcategory = subcate
if "description" in record:
description = record['description']
else:
description = ""
addr = record['addresses']
for add in addr:
addresses = add
mycursor.execute('SELECT * FROM sws_heist_address WHERE address="'+str(addresses)+'"')
check = mycursor.fetchall()
if not check:
print("added")
mycursor.execute('''SELECT MAX(id) FROM sws_heist_address''')
maxid = mycursor.fetchone()
check=maxid[0]
if check is None:
ids = 1
else:
ids=(maxid[0]+1)
print(ids)
conversion =description.replace('"','')
mycursor.execute('INSERT INTO sws_heist_address (id,coin,tag_name,status,address,source,subcategory,description,also_known_as) VALUES ("'+str(ids)+'","'+str(coin)+'","'+str(category)+'","'+str(status)+'","'+str(addresses)+'","https://etherscamdb.info/api/scams","'+str(subcategory)+'","'+str(conversion)+'","'+str(url)+'")')
mydb.commit()
else:
print("already_exist")
def btc_notification(address, symbol, type_id):
print("ashgajhghgggggggggggggggggggggggggggggggggggggggggggggggggggggggg")
ret = BTC_balance.replace("{{address}}", '' + address + '')
ret1 = ret.replace("{{symbol}}", '' + symbol + '')
print(ret1)
response_user_token = requests.get(url=ret1)
transaction = response_user_token.json()
total_current_tx = transaction['transaction_count']
print('25')
mycursor.execute(
'SELECT total_tx_calculated FROM sws_address WHERE address="' +
str(address) + '"')
current_tx = mycursor.fetchone()
tx_count = current_tx[0]
print('29')
print("tx_count")
print(tx_count)
print("total_current_tx")
print(total_current_tx)
if tx_count is None or total_current_tx > tx_count:
mycursor.execute('UPDATE sws_address SET total_tx_calculated ="' +
str(total_current_tx) + '" WHERE address = "' +
str(address) + '"')
mycursor.execute(
'SELECT u.email FROM db_safename.sws_address as a left join db_safename.sws_user as u on a.cms_login_name = u.username where a.address="'
+ str(address) + '"')
email = mycursor.fetchone()
email_id = email[0]
print('35')
if email_id is not None:
message = Mail(
from_email=Sendgrid_default_mail,
to_emails=email_id,
subject=
'SafeName - New Transaction Notification In Your Account',
html_content=
'<h3> You got a new transaction on your BTC address</h3>')
sg = SendGridAPIClient(SendGridAPIClient_key)
response = sg.send(message)
print(response.status_code, response.body, response.headers)
else:
print("email is none")
else:
print("no new transaction")
'''
transactions = transaction['txs']
array=[]
total_current_tx=len(transactions)s
'''
'''
def risk_score():
mycursor.execute('SELECT address FROM sws_risk_score')
check = mycursor.fetchall()
for addr in check:
address=addr[0]
mycursor.execute('SELECT risk_score_by_tx,riskscore_by_safename,riskscore_by_knownheist FROM sws_risk_score WHERE address="'+str(address)+'"')
check = mycursor.fetchall()
for record in check:
print(record)
score = 0
for lst in record:
if lst is not None:
score = lst+score
risk_score = 50+score
mycursor.execute('UPDATE sws_address SET address_risk_score="'+str(risk_score)+'" WHERE address = "'+str(address)+'"')
print("updated")
mydb.commit()
def block_winner():
print("running block")
recor = mongo.db.hashrate_calculation.remove()
mycursor.execute('SELECT username FROM sws_user')
check = mycursor.fetchall()
count = 1
for user in check:
username = user[0]
mycursor.execute(
'SELECT address from sws_address WHERE cms_login_name="' +
str(username) + '" ')
chek = mycursor.fetchall()
contracts = []
for addr in chek:
address = addr[0]
print("addressssssssssssssssssssssssssss")
print(address)
heroes_records = mongo.db.participate_heroes.find_one(
{"address": address})
chain = heroes_records['chainbreakers']
crypto = heroes_records['cryptoskulls']
ethere = heroes_records['etheremon']
mycrypto = heroes_records['mycryptoheroes']
mycryptoheroes_records = mongo.db.mycryptoheroes.find(
{"owner_addresses": address})
mycryptoheroes_records = [
serialize_doc(mycryptoheroes_record)
for mycryptoheroes_record in mycryptoheroes_records
]
mycryptoheroes_rec = mycryptoheroes_records[0:1]
etheremon_records = mongo.db.etheremon.find(
{"owner_addresses": address})
etheremon_records = [
serialize_doc(etheremon_record)
for etheremon_record in etheremon_records
]
etheremon_rec = etheremon_records[0:1]
cryptoskulls_records = mongo.db.cryptoskulls.find(
{"owner_addresses": address})
cryptoskulls_records = [
serialize_doc(cryptoskulls_record)
for cryptoskulls_record in cryptoskulls_records
]
cryptoskulls_rec = cryptoskulls_records[0:1]
chainbreakers_records = mongo.db.chainbreakers.find(
{"owner_addresses": address})
chainbreakers_records = [
serialize_doc(chainbreakers_record)
for chainbreakers_record in chainbreakers_records
]
chainbreakers_rec = chainbreakers_records[0:1]
all_mons = mycryptoheroes_rec + etheremon_rec + cryptoskulls_rec + chainbreakers_rec #+ cryptokitties_records
for mons in all_mons:
contracts.append(mons)
print("4")
user_hashrate_sum = []
for all_contracts in contracts:
if 'hashrate' in all_contracts:
hashrate = all_contracts['hashrate']
user_hashrate_sum.append(hashrate)
print("4777777")
sum_of_hashrate = sum(user_hashrate_sum)
print(len(user_hashrate_sum))
print("499999999")
print(sum_of_hashrate)
if count == 1:
print("5111111111111111111111111")
starting_number = 1
ending_number = starting_number + sum_of_hashrate
else:
print("55555555555555555555555555555555")
highest = mongo.db.hashrate_calculation.find_one(
sort=[("ending_number", -1)])
print("6000000000000000")
print(highest)
print("6222222222222222")
if highest is not None:
starting_number = highest['ending_number']
ending_number = sum_of_hashrate + starting_number
print(starting_number)
print(ending_number)
else:
starting_number = None
ending_number = None
count = count + 1
print("71111111111111")
ret = mongo.db.hashrate_calculation.update({"username": username}, {
"$set": {
"username": username,
"sum_of_hashrate": sum_of_hashrate,
"starting_number": starting_number,
"ending_number": ending_number
}
},
upsert=True)
print("doneeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee")
def risk_score_by_safename():
print("runnnnnn")
mycursor.execute("""CREATE TABLE IF NOT EXISTS `sws_risk_score` ( id INT NOT NULL AUTO_INCREMENT,address varchar(100),risk_score_by_tx float(3) NULL,type_id int(3) NULL,riskscore_by_safename float(3) NULL,riskscore_by_knownheist float(3) NULL,PRIMARY KEY (id))""")
mycursor.execute('SELECT address,type_id FROM sws_address')
check = mycursor.fetchall()
print("line 150")
for a in check:
address=a[0]
type_id=a[1]
print("line 153")
mycursor.execute('SELECT * FROM sws_risk_score WHERE address="'+str(address)+'"')
check = mycursor.fetchall()
if not check:
mycursor.execute('INSERT INTO `sws_risk_score`(address,type_id) VALUES ("'+str(address)+'","'+str(type_id)+'")')
mydb.commit()
print("line 155")
kyc_and_secure_addresses=[]
mycursor.execute('SELECT u.address FROM db_safename.sws_user as a left join db_safename.sws_address as u on a.username = u.cms_login_name where (kyc_verified = 1 AND profile_status = "secure")')
che = mycursor.fetchall()
for addr in che:
cms_name=addr[0]
kyc_and_secure_addresses.append(cms_name)
print("300")
print("308")
secure_addresses=[]
mycursor.execute('SELECT u.address FROM db_safename.sws_user as a left join db_safename.sws_address as u on a.username = u.cms_login_name where profile_status = "secure" AND (kyc_verified <> 1 OR kyc_verified is null )')
chek = mycursor.fetchall()
for addr in chek:
cms_name=addr[0]
secure_addresses.append(cms_name)
print("315")
print("323")
mycursor.execute('SELECT address FROM sws_risk_score')
check = mycursor.fetchall()
for addr in check:
address=addr[0]
print(address)
records = mongo.db.sws_history.find_one({"address":address})
if records is not None:
print("488888888888888888888")
transactions=records['transactions']
if transactions:
print("asdasdasdffdasfdasfdfa51")
addresses=[]
for transaction in transactions:
fro=transaction['from']
for fromm in fro:
fr = fromm['send_amount']
addresses.append(fr)
for checkk in addresses:
print("asdasdadd59")
if checkk in kyc_and_secure_addresses:
print("adasda")
tx_safe_name_formula = (50*10)/100
mycursor.execute('UPDATE sws_risk_score SET riskscore_by_safename ="'+str(tx_safe_name_formula)+'" WHERE address = "'+str(address)+'"')
print(checkk)
print("updated_10%")
mydb.commit()
if checkk in secure_addresses:
tx_safe_name_formula = (50*5)/100
mycursor.execute('UPDATE sws_risk_score SET riskscore_by_safename ="'+str(tx_safe_name_formula)+'" WHERE address = "'+str(address)+'"')
print(checkk)
print("updated_5%")
mydb.commit()
else:
pass
def risk_score_by_heist():
print("runnnnnn")
mycursor.execute("""CREATE TABLE IF NOT EXISTS `sws_risk_score` ( id INT NOT NULL AUTO_INCREMENT,address varchar(100),risk_score_by_tx float(3) NULL,type_id int(3) NULL,riskscore_by_safename float(3) NULL,riskscore_by_knownheist float(3) NULL,PRIMARY KEY (id))""")
mycursor.execute('SELECT address,type_id FROM sws_address')
check = mycursor.fetchall()
print("line 150")
for check in check:
address=check[0]
type_id=check[1]
print("line 153")
mycursor.execute('SELECT * FROM sws_risk_score WHERE address="'+str(address)+'"')
check = mycursor.fetchall()
if not check:
mycursor.execute('INSERT INTO `sws_risk_score`(address,type_id) VALUES ("'+str(address)+'","'+str(type_id)+'")')
mydb.commit()
print("line 155")
heist_addresses=[]
mycursor.execute('SELECT address FROM sws_heist_address WHERE (tag_name <> "heist_associated")')
ret = mycursor.fetchall()
for addres in ret:
address=addres[0]
heist_addresses.append(address)
print(len(heist_addresses))
print("170")
heist_associated_addresses=[]
mycursor.execute('SELECT address FROM sws_heist_address WHERE (tag_name = "heist_associated")')
ret = mycursor.fetchall()
for add in ret:
addres=add[0]
heist_associated_addresses.append(addres)
print("177")
mycursor.execute('SELECT address FROM sws_risk_score')
check = mycursor.fetchall()
for addr in check:
address=addr[0]
records = mongo.db.sws_history.find_one({"address":address})
if records is not None:
transactions=records['transactions']
addresses=[]
for transaction in transactions:
fro =transaction['from']
for frmm in fro:
fr = frmm['send_amount']
addresses.append(fr)
for checkk in addresses:
print("checkkkk")
if checkk in heist_addresses:
tx_knownheist_formula =-((50*50)/100)
mycursor.execute('UPDATE sws_risk_score SET riskscore_by_knownheist ="'+str(tx_knownheist_formula)+'" WHERE address = "'+str(address)+'"')
print("updated_50%")
mydb.commit()
if checkk in heist_associated_addresses:
tx_heistassosiated_formula = -((50*30)/100)
mycursor.execute('UPDATE sws_risk_score SET riskscore_by_knownheist ="'+str(tx_heistassosiated_formula)+'" WHERE address = "'+str(address)+'"')
print("updated_30%")
mydb.commit()
else:
pass
def eth_notification(address, symbol, type_id):
doc = ETH_transactions.replace("{{address}}", '' + address + '')
response_user = requests.get(url=doc)
res = response_user.json()
transactions = res['result']
if transactions:
total_current_tx = len(transactions)
transaction = transactions[-1]
timestamp = transaction['timeStamp']
first_date = int(timestamp)
dt_object = datetime.fromtimestamp(first_date)
fro = transaction['from']
too = transaction['to']
send_amount = (int(transaction['value']) / 1000000000000000000)
tx_id = transaction['hash']
print("87")
mycursor.execute(
'SELECT total_tx_calculated FROM sws_address WHERE address="' +
str(address) + '"')
current_tx = mycursor.fetchall()
transactions_count = current_tx[0]
tx_count = transactions_count[0]
print("tx_count")
print(tx_count)
print("total_current_tx")
print(total_current_tx)
print("send_amount")
print(send_amount)
if tx_count is None or total_current_tx > tx_count:
print("93")
if send_amount != 0:
print("105")
mycursor.execute(
'UPDATE sws_address SET total_tx_calculated ="' +
str(total_current_tx) + '" WHERE address = "' +
str(address) + '"')
print(address)
mycursor.execute(
'SELECT u.email FROM db_safename.sws_address as a left join db_safename.sws_user as u on a.cms_login_name = u.username where a.address="'
+ str(address) + '"')
email = mycursor.fetchone()
email_id = email[0]
print(email_id)
if email_id is not None:
'''
print("sendinnnnnngggggggg")
mycursor.execute('SELECT address_safename FROM sws_address WHERE address="'+str(fro)+'"')
from_safename_tx = mycursor.fetchall()
if from_safename_tx:
frm_safenames=from_safename_tx[0]
frm = frm_safenames[0]
frm_safename=fro+'(safename:'+frm+')'
else:
frm_safename=fro
mycursor.execute('SELECT address_safename FROM sws_address WHERE address="'+str(too)+'"')
too_safenames_tx = mycursor.fetchall()
if too_safenames_tx:
too_safenames=too_safenames_tx[0]
to = too_safenames[0]
to_safename=too+'(safename:'+to+')'
else:
to_safename=too
'''
frm_safename = fro
to_safename = too
message = Mail(
from_email=Sendgrid_default_mail,
to_emails=email_id,
subject=
'SafeName - New Transaction Notification In Your Account',
html_content=
'<h3> You got a new transaction </h3><strong>Date:</strong> '
+ str(dt_object) + ' <div><strong>From:</strong> ' +
str(frm_safename) + ' </div><strong>To:</strong> ' +
str(to_safename) +
' </div><div><strong>Amount:</strong> ' +
str(send_amount) +
' </div><div><strong>Tx_id:</strong> ' + str(tx_id) +
' </div><div><strong>Coin Type:</strong> '
'ETH'
' </div>')
sg = SendGridAPIClient(SendGridAPIClient_key)
response = sg.send(message)
print(response.status_code, response.body,
response.headers)
else:
print("email is not none")
else:
print("amount is 0")
else:
print("no new transaction")
else:
print("no transcations")
def invoice_notification():
print("asdasndas,na")
dab = mongo.db.sws_pending_txs_from_app.find({"type": "invoice"})
dab = [serialize_doc(doc) for doc in dab]
for data in dab:
frm = data['from']
to = data['to']
symbol = data['symbol']
amount = data['amt']
notes = data['from_notes']
to_username = data['to_username']
print("from")
print(frm)
print("to")
print(to)
print(amount)
dabb = mongo.db.sws_history.find(
{
"transactions": {
'$elemMatch': {
"from": {
'$elemMatch': {
"from": to,
"send_amount": amount
}
},
"to": {
'$elemMatch': {
"to": frm
}
}
}
}
}, {"transactions.$": 1})
dabb = [serialize_doc(doc) for doc in dabb]
print(dabb)
if dabb:
for data in dabb:
trans = data['transactions']
for tx_id in trans:
transaction_id = tx_id['Tx_id']
docs = mongo.db.sws_pending_txs_from_app.remove({
"from": frm,
"to": to,
"amt": amount,
"type": "invoice"
})
report = mongo.db.sws_notes.insert_one({
"tx_id":
transaction_id,
"notes":
notes,
"from":
frm,
"to":
to,
"type":
"invoice",
"username":
to_username,
"update_at":
datetime.datetime.now(),
"created_at":
datetime.datetime.now()
}).inserted_id
else:
mycursor.execute(
'SELECT u.email FROM db_safename.sws_address as a left join db_safename.sws_user as u on a.cms_login_name = u.username where a.address="'
+ str(to) + '"')
email = mycursor.fetchone()
print(email)
if email is not None:
email_id = email[0]
print(email_id)
message = Mail(
from_email=Sendgrid_default_mail,
to_emails='*****@*****.**',
subject='SafeName - Invoice Notification In Your Account',
html_content=
'<h3> Your invoice is not clear please accept the request</h3>'
)
sg = SendGridAPIClient(SendGridAPIClient_key)
response = sg.send(message)
print(response.status_code, response.body, response.headers)
def unknown_riskscore():
if not request.json:
abort(500)
address = request.json.get("address", None)
symbol = request.json.get("symbol", None)
type_id = request.json.get("type_id", "")
if type_id == "2":
currency = btc_data(address, symbol, type_id)
if type_id == "1":
currency = eth_data(address, symbol, type_id)
if type_id == "27":
currency = dash_data(address, symbol, type_id)
if type_id == "98":
currency = zcash_data(address, symbol, type_id)
if type_id == "55":
currency = mkr_data(address, symbol, type_id)
if type_id == "21":
currency = link_data(address, symbol, type_id)
#-------ERC20 coin-----------
if type_id == "3":
currency = zrx_data(address, symbol, type_id)
if type_id == "5":
currency = elf_data(address, symbol, type_id)
if type_id == "8":
currency = rep_data(address, symbol, type_id)
if type_id == "9":
currency = aoa_data(address, symbol, type_id)
if type_id == "10":
currency = bat_data(address, symbol, type_id)
if type_id == "22":
currency = cccx_data(address, symbol, type_id)
if type_id == "24":
currency = mco_data(address, symbol, type_id)
if type_id == "25":
currency = cro_data(address, symbol, type_id)
if type_id == "26":
currency = dai_data(address, symbol, type_id)
if type_id == "31":
currency = ekt_data(address, symbol, type_id)
records = mongo.db.sws_history.find_one({"address": address})
if records is not None:
print("record is not none")
transactions = records['transactions']
if transactions:
print("transactionnssss")
count = 0
for transaction in transactions:
first_date = transaction['date']
date_time = dateutil.parser.parse(str(first_date))
month = date_time.strftime("%m/%d/%Y")
two_year_back = datetime.datetime.today() + relativedelta(
months=-24)
back = two_year_back.strftime("%m/%d/%Y")
if month < back:
count = count + 1
if count >= 4:
print("count 4")
formula = (50 * 10) / 100
else:
formula = 0
else:
pass
else:
formula = -((50 * 5) / 100)
kyc_and_secure_addresses = []
mycursor.execute(
'SELECT u.address FROM db_safename.sws_user as a left join db_safename.sws_address as u on a.username = u.cms_login_name where (kyc_verified = 1 AND profile_status = "secure")'
)
che = mycursor.fetchall()
for addr in che:
cms_name = addr[0]
kyc_and_secure_addresses.append(cms_name)
secure_addresses = []
mycursor.execute(
'SELECT u.address FROM db_safename.sws_user as a left join db_safename.sws_address as u on a.username = u.cms_login_name where profile_status = "secure" AND (kyc_verified <> 1 OR kyc_verified is null )'
)
chek = mycursor.fetchall()
for addr in chek:
cms_name = addr[0]
secure_addresses.append(cms_name)
records = mongo.db.sws_history.find_one({"address": address})
if records is not None:
print("record is not none")
transactions = records['transactions']
if transactions:
print("transactions is not none")
addresses = []
for transaction in transactions:
fro = transaction['from']
for fromm in fro:
fr = fromm['from']
addresses.append(fr)
print(addresses)
tx_safe_name_formula = 0
for checkk in addresses:
if checkk in kyc_and_secure_addresses:
print("addresss in kyc_and_secure_address")
tx_safe_name_formula = (50 * 10) / 100
if checkk in secure_addresses:
print("addresss in secure_addresses")
tx_safe_name_formula = (50 * 5) / 100
else:
tx_safe_name_formula = 0
heist_addresses = []
mycursor.execute(
'SELECT address FROM sws_heist_address WHERE (tag_name <> "heist_associated")'
)
ret = mycursor.fetchall()
for addres in ret:
address = addres[0]
heist_addresses.append(address)
heist_associated_addresses = []
mycursor.execute(
'SELECT address FROM sws_heist_address WHERE (tag_name = "heist_associated")'
)
ret = mycursor.fetchall()
for add in ret:
addres = add[0]
heist_associated_addresses.append(addres)
records = mongo.db.sws_history.find_one({"address": address})
if records is not None:
transactions = records['transactions']
addresses = []
for transaction in transactions:
fro = transaction['from']
for frmm in fro:
fr = frmm['send_amount']
addresses.append(fr)
tx_knownheist_formula = 0
for checkk in addresses:
if checkk in heist_addresses:
tx_knownheist_formula = -((50 * 50) / 100)
if checkk in heist_associated_addresses:
tx_knownheist_formula = -((50 * 30) / 100)
else:
tx_knownheist_formula = 0
print("409")
print("formula")
print(formula)
print("tx_safe_name_formula")
print(tx_safe_name_formula)
print("tx_knownheist_formula")
print(tx_knownheist_formula)
riskscore = 50 + formula + tx_safe_name_formula + tx_knownheist_formula
return jsonify({"riskscore": riskscore})
def tx_two_yearold():
print("runnnnnn")
mycursor.execute(
"""CREATE TABLE IF NOT EXISTS `sws_risk_score` ( id INT NOT NULL AUTO_INCREMENT,address varchar(100),risk_score_by_tx float(3) NULL,type_id int(3) NULL,riskscore_by_safename float(3) NULL,riskscore_by_knownheist float(3) NULL,PRIMARY KEY (id))"""
)
mycursor.execute('SELECT address,type_id FROM sws_address')
check = mycursor.fetchall()
print("line 150")
for details in check:
address = details[0]
type_id = details[1]
print("line 153")
mycursor.execute('SELECT * FROM sws_risk_score WHERE address="' +
str(address) + '"')
check = mycursor.fetchall()
if not check:
mycursor.execute(
'INSERT INTO `sws_risk_score`(address,type_id) VALUES ("' +
str(address) + '","' + str(type_id) + '")')
mydb.commit()
print("line 155")
#mycursor.execute('SELECT address,type_id FROM sws_risk_score WHERE (tx_calculated <> 1 OR tx_calculated is null)')
mycursor.execute('SELECT address FROM sws_risk_score')
check = mycursor.fetchall()
for addrr in check:
address = addrr[0]
records = mongo.db.sws_history.find_one({"address": address})
if records is not None:
transactions = records['transactions']
if transactions:
count = 0
for transaction in transactions:
first_date = transaction['date']
date_time = dateutil.parser.parse(str(first_date))
month = date_time.strftime("%m/%d/%Y")
two_year_back = datetime.datetime.today() + relativedelta(
months=-24)
back = two_year_back.strftime("%m/%d/%Y")
if month < back:
count = count + 1
if count == 4:
formula = (50 * 10) / 100
#mycursor.execute('UPDATE sws_risk_score SET risk_score_by_tx ="'+str(formula)+'",tx_calculated =1 WHERE address = "'+str(address)+'"')
mycursor.execute(
'UPDATE sws_risk_score SET risk_score_by_tx ="'
+ str(formula) + '" WHERE address = "' +
str(address) + '"')
print("updated_plus")
mydb.commit()
else:
pass
else:
pass
else:
tx_formula = ((50 * 5) / 100)
mycursor.execute(
'UPDATE sws_risk_score SET risk_score_by_tx ="' +
str(tx_formula) + '" WHERE address = "' + str(address) +
'"')
print("updated_minus")
mydb.commit()
def heist_associated_fetch():
print("runningggggg")
mycursor.execute('select coin, address from `sws_heist_address`')
result = mycursor.fetchall()
for res in result:
coin = res[0]
address= res[1]
if coin == 'ETH':
print("eth")
url1=ETH_TRANSACTION_URL
doc=url1.replace("{{address}}",''+address+'')
response_user = requests.get(url=doc)
res = response_user.json()
if 'status' in res:
status_code = res['status']
else:
status_code = "1"
if status_code != "0":
transactions=res['result']
frm=[]
to=[]
for transaction in transactions:
fro =transaction['from']
too=transaction['to']
to.append({"to":too})
frm.append({"from":fro})
for fund_trans in frm:
address=fund_trans['from']
mycursor.execute('SELECT * FROM sws_heist_address WHERE address="'+str(address)+'"')
check = mycursor.fetchall()
if not check:
print("added")
mycursor.execute('''SELECT MAX(id) FROM sws_heist_address''')
maxid = mycursor.fetchone()
check=maxid[0]
if check is None:
ids = 1
else:
ids=(maxid[0]+1)
print(ids)
category = "heist_associated"
status = "Active"
url = ""
subcategory = ""
conversion = ""
mycursor.execute('INSERT INTO sws_heist_address (id,coin,tag_name,status,address,source,subcategory,description,also_known_as) VALUES ("'+str(ids)+'","'+str(coin)+'","'+str(category)+'","'+str(status)+'","'+str(address)+'","'+str(url)+'","'+str(subcategory)+'","'+str(conversion)+'","related to heist_address")')
mydb.commit()
else:
print("already_exist")
for fund_reci in to:
address=fund_reci['to']
mycursor.execute('SELECT * FROM sws_heist_address WHERE address="'+str(address)+'"')
check = mycursor.fetchall()
if not check:
print("to_added")
mycursor.execute('''SELECT MAX(id) FROM sws_heist_address''')
maxid = mycursor.fetchone()
check=maxid[0]
if check is None:
ids = 1
else:
ids=(maxid[0]+1)
print(ids)
name = ""
category = "heist_associated"
status = "Active"
url = ""
subcategory = ""
conversion = ""
mycursor.execute('INSERT INTO sws_heist_address (id,coin,tag_name,status,address,source,subcategory,description,also_known_as) VALUES ("'+str(ids)+'","'+str(coin)+'","'+str(category)+'","'+str(status)+'","'+str(address)+'","'+str(url)+'","'+str(subcategory)+'","'+str(conversion)+'","related to heist_address")')
mydb.commit()
else:
print("already_exist")
if coin == 'BTC':
print("btc")
url1=BTC_TRANSACTION
doc=url1.replace("{{address}}",''+address+'')
response_user = requests.get(url=doc)
res = response_user.json()
transactions = res['txs']
frm=[]
for transaction in transactions:
frmm=transaction['inputs']
for trans in frmm:
fro=trans['address']
frm.append({"from":fro})
for fund_trans in frm:
address=fund_trans['from']
mycursor.execute('SELECT * FROM sws_heist_address WHERE address="'+str(address)+'"')
check = mycursor.fetchall()
if not check:
print("added")
mycursor.execute('''SELECT MAX(id) FROM sws_heist_address''')
maxid = mycursor.fetchone()
check=maxid[0]
if check is None:
ids = 1
else:
ids=(maxid[0]+1)
print(ids)
category = "heist_associated"
status = "Active"
url = ""
subcategory = ""
conversion = ""
mycursor.execute('INSERT INTO sws_heist_address (id,coin,tag_name,status,address,source,subcategory,description,also_known_as) VALUES ("'+str(ids)+'","'+str(coin)+'","'+str(category)+'","'+str(status)+'","'+str(address)+'","'+str(url)+'","'+str(subcategory)+'","'+str(conversion)+'","related to heist_address")')
mydb.commit()
else:
print("already_exist")
def pgp_verification():
mycursor.execute('SELECT username FROM sws_user')
usernames = mycursor.fetchall()
for username in usernames:
user = username[0]
mycursor.execute(
'SELECT public_profile_safename,keybase_string FROM sws_user where username='******'"' + str(user) + '"'
'')
check = mycursor.fetchall()
details = check[0]
public_safename = details[0]
keybase = details[1]
if not None in (public_safename, keybase):
changes = template.replace('{{safename}}',
'' + public_safename + '')
keybase_changes = changes.replace('{{PGP_sign_key}}',
'' + keybase + '')
mycursor.execute(
'SELECT address,type_id FROM sws_address where cms_login_name='
'"' + str(user) + '"'
'')
check = mycursor.fetchall()
no_of_addresses = len(check)
print(no_of_addresses)
template_array = []
for addr in range(0, no_of_addresses):
address_details = check[addr]
addres = address_details[0]
type_id = address_details[1]
if type_id == 1:
typee = 'Ethereum'
if type_id == 2:
typee = 'Bitcoin'
if no_of_addresses != 1:
if addr == 0:
print("if")
change = keybase_changes.replace(
'{{cointype}}', '' + typee + '')
final_template = change.replace(
'{{addresses}}', '' + addres + '\n' +
'{{cointype}}' + '\n' + '{{addresses}}')
template_array.append(final_template)
elif addr == no_of_addresses - 1:
print("elif")
tempp = template_array[0]
del template_array[0]
chan = tempp.replace('{{cointype}}', '' + typee + '')
template_used = chan.replace('{{addresses}}',
'' + addres + '')
template_array.append(template_used)
else:
print("else")
temp = template_array[0]
del template_array[0]
changed = temp.replace('{{cointype}}', '' + typee + '')
final_template = changed.replace(
'{{addresses}}', '' + addres + '\n' +
'{{cointype}}' + '\n' + '{{addresses}}')
template_array.append(final_template)
else:
change = keybase_changes.replace('{{cointype}}',
'' + typee + '')
final_template = change.replace('{{addresses}}',
'' + addres + '')
template_array.append(final_template)
template_for_used = template_array[0]
text = open(r'C:\Users\etech\Desktop\guru99.txt', 'r+')
text.write(template_for_used)
text.truncate()
erification_cammand = os.system(
r'''keybase pgp verify -i C:\Users\etech\Desktop\guru99.txt '''
)
print(erification_cammand)
split_string = str(erification_cammand).split()
checking_response = str(split_string)
if "['0']" in checking_response:
print("success")
else:
message = Mail(
from_email=Sendgrid_default_mail,
to_emails='*****@*****.**',
subject='SafeName - Invoice Notification In Your Account',
html_content=
'<h3> Your invoice is not clear please accept the request</h3>'
)
sg = SendGridAPIClient(SendGridAPIClient_key)
response = sg.send(message)
print(response.status_code, response.body, response.headers)
