root.filename = filedialog.asksaveasfilename(initialdir="/", title="Select backup file", filetypes=(("gzip", "*.gz"), ))

if not root.filename == "":

if not root.filename.endswith(".tar.gz"):

root.filename = root.filename+".tar.gz"

der_files = glob.glob("*.der")

tar = tarfile.open(root.filename, "w:gz")

for der_file in der_files:

tar.add(der_file, arcname=der_file)

top12 = Toplevel()

top12.title("Your aliases")

aliases_box = Text(top12, width=100)

aliases_box.grid(row=0, pady=0)

for row in c.execute("SELECT openfield FROM transactions WHERE address = ? AND openfield LIKE ?;", (address,) + ("alias=" + '%',)):

aliases_box.insert(INSERT, row[0].lstrip("alias="))

aliases_box.insert(INSERT,"\n")

close = Button(top12, text="Close", command=top12.destroy)

# secure execute for slow nodes

passed = 0

while passed == 0:

try:

# print cursor

# print what

cursor.execute(what)

passed = 1

except Exception as e:

app_log.warning("Retrying database execute due to {}".format(e))

time.sleep(random.random())

pass

# secure execute for slow nodes

# secure execute for slow nodes

passed = 0

while passed == 0:

try:

# print cursor

# print what

cursor.execute(what, param)

passed = 1

except Exception as e:

app_log.warning("Retrying database execute due to " + str(e))

time.sleep(0.1)

pass

# secure execute for slow nodes

execute(c, "SELECT * FROM transactions ORDER BY block_height DESC LIMIT 1")

result = c.fetchall()[0]

timestamp_last = float(result[1])

block_height = int(result[0])

execute_param(c, ("SELECT block_height FROM transactions WHERE CAST(timestamp AS INTEGER) > ? AND reward != 0"), (timestamp_last - 86400,)) # 86400=24h

blocks_per_1440 = len(c.fetchall())

app_log.warning("Blocks per day: {}".format(blocks_per_1440))

execute(c, ("SELECT difficulty FROM misc ORDER BY block_height DESC LIMIT 1"))

diff_block_previous = float(c.fetchone()[0])

try:

log = math.log2(blocks_per_1440 / 1440)

except:

log = math.log2(0.5 / 1440)

app_log.info("Difficulty retargeting: {}".format(log))

difficulty = float('%.13f' % (diff_block_previous + log)) # increase/decrease diff by a little

# difficulty = float('%.3f' % (diff_block_previous + float(log))) # increase/decrease diff by a little

time_now = time.time()

if time_now > timestamp_last + 120: # if 2 minutes passed

execute(c, ("SELECT difficulty FROM misc ORDER BY block_height DESC LIMIT 5"))

diff_5 = c.fetchall()[0]

diff_lowest_5 = float(min(diff_5))

if diff_lowest_5 < difficulty:

candidate = diff_lowest_5 #if lowest of last 5 is lower than calculated diff

else:

candidate = difficulty

difficulty2 = float('%.13f' % percentage(99, candidate)) #candidate -1%

else:

difficulty2 = difficulty

if difficulty < 70:

difficulty = 70

if difficulty2 < 70:

difficulty2 = 70

app_log.warning("Difficulty: {} {}".format(difficulty, difficulty2))

# return (float(50), float(50)) #TEST ONLY

alias_var = StringVar()

# enter password

top8 = Toplevel()

top8.title("Enter Desired Name")

alias_label = Label(top8, text="Input name")

alias_label.grid(row=0, column=0, sticky=N + W, padx=15, pady=(5, 0))

input_alias = Entry(top8, textvariable=alias_var)

input_alias.grid(row=1, column=0, sticky=N + E, padx=15, pady=(0, 5))

dismiss = Button(top8, text="Register", command=lambda: alias_register(alias_var.get().strip()))

dismiss.grid(row=2, column=0, sticky=W + E, padx=15, pady=(15, 0))

dismiss = Button(top8, text="Dismiss", command=top8.destroy)

reg_string = "alias=" + alias_desired

if full_ledger == 1:

conn = sqlite3.connect('static/ledger.db')

else:

conn = sqlite3.connect('static/hyper.db')

conn.text_factory = str

c = conn.cursor()

m.execute("SELECT timestamp FROM transactions WHERE openfield = ?;", (reg_string,))

registered_pending = m.fetchone()

c.execute("SELECT timestamp FROM transactions WHERE openfield = ?;", (reg_string,))

registered_already = c.fetchone()

if registered_already == None and registered_pending == None:

alias_cb_var.set(0)

send_confirm("0", address, "1", reg_string)

else:

top9 = Toplevel()

top9.title("Name already registered")

registered_label = Label(top9, text="Name already registered")

registered_label.grid(row=0, column=0, sticky=N + W, padx=15, pady=(5, 0))

dismiss = Button(top9, text="Dismiss", command=top9.destroy)

# enter password

top3 = Toplevel()

top3.title("Enter Password")

password_label = Label(top3, text="Input password")

password_label.grid(row=0, column=0, sticky=N + W, padx=15, pady=(5, 0))

input_password = Entry(top3, textvariable=password_var_enc, show='*')

input_password.grid(row=1, column=0, sticky=N + E, padx=15, pady=(0, 5))

confirm_label = Label(top3, text="Confirm password")

confirm_label.grid(row=2, column=0, sticky=N + W, padx=15, pady=(5, 0))

input_password_con = Entry(top3, textvariable=password_var_con, show='*')

input_password_con.grid(row=3, column=0, sticky=N + E, padx=15, pady=(0, 5))

enter = Button(top3, text="Encrypt", command=lambda: encrypt_fn(top3))

enter.grid(row=4, column=0, sticky=W + E, padx=15, pady=(5, 5))

cancel = Button(top3, text="Cancel", command=top3.destroy)

cancel.grid(row=5, column=0, sticky=W + E, padx=15, pady=(5, 5))

global key

del key

decrypt_b.configure(text="Unlock", state=NORMAL)

lock_b.configure(text="Locked", state=DISABLED)

password = password_var_enc.get()

password_conf = password_var_con.get()

if password == password_conf:

ciphertext = encrypt(password, private_key_readable)

pem_file = open("privkey_encrypted.der", 'wb')

pem_file.write(base64.b64encode(ciphertext))

pem_file.close()

encrypt_b.configure(text="Encrypted", state=DISABLED)

destroy_this.destroy()

os.remove("privkey.der")

lock_b.configure(text="Lock", state=NORMAL)

else:

mismatch = Toplevel()

mismatch.title("Bismuth")

mismatch_msg = Message(mismatch, text="Password mismatch", width=100)

mismatch_msg.pack()

mismatch_button = Button(mismatch, text="Continue", command=mismatch.destroy)

# enter password

top4 = Toplevel()

top4.title("Enter Password")

input_password = Entry(top4, textvariable=password_var_dec, show='*')

input_password.grid(row=0, column=0, sticky=N + E, padx=15, pady=(5, 5))

enter = Button(top4, text="Unlock", command=lambda: decrypt_fn(top4))

enter.grid(row=1, column=0, sticky=W + E, padx=15, pady=(5, 5))

cancel = Button(top4, text="Cancel", command=top4.destroy)

cancel.grid(row=2, column=0, sticky=W + E, padx=15, pady=(5, 5))

global key

try:

password = password_var_dec.get()

encrypted_privkey = open('privkey_encrypted.der', 'rb').read()

decrypted_privkey = decrypt(password, base64.b64decode(encrypted_privkey))

key = RSA.importKey(decrypted_privkey) # be able to sign

# print key

decrypt_b.configure(text="Unlocked", state=DISABLED)

lock_b.configure(text="Lock", state=NORMAL)

destroy_this.destroy()

except:

top6 = Toplevel()

top6.title("Locked")

Label(top6, text="Wrong password", width=20).grid(row=0, pady=0)

cancel = Button(top6, text="Cancel", command=top6.destroy)

cancel.grid(row=1, column=0, sticky=W + E, padx=15, pady=(5, 5))

top10 = Toplevel()

top10.title("Confirm")

# encr check

if encrypt_var.get() == 1:

#get recipient's public key

c.execute("SELECT public_key FROM transactions WHERE address = ? and reward = 0",(recipient_input,))

target_public_key_hashed = c.fetchone()[0]

recipient_key = RSA.importKey(base64.b64decode(target_public_key_hashed).decode("utf-8"))

#openfield_input = str(target_public_key.encrypt(openfield_input.encode("utf-8"), 32))

data = openfield_input.encode("utf-8")

# print (open("pubkey.der").read())

session_key = get_random_bytes(16)

cipher_aes = AES.new(session_key, AES.MODE_EAX)

# Encrypt the session key with the public RSA key

cipher_rsa = PKCS1_OAEP.new(recipient_key)

# Encrypt the data with the AES session key

ciphertext, tag = cipher_aes.encrypt_and_digest(data)

enc_session_key = (cipher_rsa.encrypt(session_key))

openfield_input = str([x for x in (cipher_aes.nonce, tag, ciphertext, enc_session_key)])

# encr check

# msg check

if encode_var.get() == 1:

openfield_input = base64.b64encode(openfield_input.encode("utf-8")).decode("utf-8")

# msg check

if msg_var.get() == 1 and encode_var.get() == 1:

openfield_input = "bmsg=" + openfield_input

if msg_var.get() == 1 and encode_var.get() == 0:

openfield_input = "msg=" + openfield_input

if encrypt_var.get() == 1:

openfield_input = "enc=" + str(openfield_input)

fee = '%.8f' % float(0.01 + (float(len(openfield_input)) / 100000) + int(operation_var.get())) # 0.01 dust

confirmation_dialog = Text(top10, width=100)

confirmation_dialog.insert(INSERT, ("Amount: {}\nTo: {}\nFee: {}\noperation Entry: {}\nOpenField:\n\n{}".format(amount_input, recipient_input, fee, operation_input, openfield_input)))

confirmation_dialog.grid(row=0, pady=0)

enter = Button(top10, text="Confirm", command=lambda: send(amount_input, recipient_input, operation_input, openfield_input, top10, fee))

enter.grid(row=1, column=0, sticky=W + E, padx=15, pady=(5, 5))

done = Button(top10, text="Cancel", command=top10.destroy)

try:

key

except:

top5 = Toplevel()

top5.title("Locked")

Label(top5, text="Wallet is locked", width=20).grid(row=0, pady=0)

done = Button(top5, text="Cancel", command=top5.destroy)

done.grid(row=1, column=0, sticky=W + E, padx=15, pady=(5, 5))

app_log.warning("Received tx command")

try:

float(amount_input)

except:

top7 = Toplevel()

top7.title("Invalid amount")

Label(top7, text="Amount must be a number", width=20).grid(row=0, pady=0)

done = Button(top7, text="Cancel", command=top7.destroy)

done.grid(row=1, column=0, sticky=W + E, padx=15, pady=(5, 5))

# alias check

if alias_cb_var.get() == 1:

c.execute("SELECT address FROM transactions WHERE openfield = ? ORDER BY block_height ASC, timestamp ASC LIMIT 1;", ("alias=" + recipient_input,)) # asc for first entry

recipient_input = c.fetchone()[0]

app_log.warning("Fetched the following alias recipient: {}".format(recipient_input))

# alias check

if len(recipient_input) != 56:

top6 = Toplevel()

top6.title("Invalid address")

Label(top6, text="Wrong address length", width=20).grid(row=0, pady=0)

done = Button(top6, text="Cancel", command=top6.destroy)

done.grid(row=1, column=0, sticky=W + E, padx=15, pady=(5, 5))

else:

app_log.warning("Amount: {}".format(amount_input))

app_log.warning("Recipient: {}".format(recipient_input))

app_log.warning("Operation: {}".format(operation_input))

app_log.warning("OpenField Data: {}".format(openfield_input))

timestamp = '%.2f' % time.time()

transaction = (str(timestamp), str(address), str(recipient_input), '%.8f' % float(amount_input), str(operation_input), str(openfield_input)) # this is signed

h = SHA.new(str(transaction).encode("utf-8"))

signer = PKCS1_v1_5.new(key)

signature = signer.sign(h)

signature_enc = base64.b64encode(signature)

app_log.warning("Client: Encoded Signature: {}".format(signature_enc.decode("utf-8")))

verifier = PKCS1_v1_5.new(key)

if verifier.verify(h, signature):

if float(amount_input) < 0:

app_log.warning("Client: Signature OK, but cannot use negative amounts")

elif (float(amount_input) + float(fee) > float(balance)):

app_log.warning("Mempool: Sending more than owned")

else:

app_log.warning("Client: The signature is valid, proceeding to save transaction, signature, new txhash and the public key to mempool")

# print(str(timestamp), str(address), str(recipient_input), '%.8f' % float(amount_input),str(signature_enc), str(public_key_hashed), str(operation_input), str(openfield_input))

m.execute("INSERT INTO transactions VALUES (?,?,?,?,?,?,?,?)", (str(timestamp), str(address), str(recipient_input), '%.8f' % float(amount_input), str(signature_enc.decode("utf-8")), str(public_key_hashed.decode("utf-8")), str(operation_input), str(openfield_input)))

mempool.commit() # Save (commit) the changes

app_log.warning("Client: Mempool updated with a received transaction")

# refresh() experimentally disabled

else:

app_log.warning("Client: Invalid signature")

# enter transaction end

top10.destroy()

if conn:

conn.close()

if mempool:

mempool.close()

app_log.warning("Received quit command")

address_qr = pyqrcode.create(address)

address_qr.png('address_qr.png')

# popup

top = Toplevel()

top.wm_iconbitmap(tempFile)

top.title("Address QR Code")

im = PIL.Image.open("address_qr.png")

photo = PIL.ImageTk.PhotoImage(im.resize((320, 320)))

label = Label(top, image=photo)

label.image = photo # operation a reference!

label.pack()

# msg = Message(top, text="hi")

# msg.pack()

button = Button(top, text="Dismiss", command=top.destroy)

button.pack()

def msg_received_get():

for row in c.execute("SELECT address,openfield,timestamp FROM transactions WHERE recipient = ? AND (openfield LIKE ? OR openfield LIKE ? OR openfield LIKE ? OR openfield LIKE ?) ORDER BY timestamp DESC;", (address,) + ("msg=" + '%',) + ("bmsg=" + '%',) + ("enc=msg=" + '%',) + ("enc=bmsg=" + '%',)):

# get alias

try:

c2.execute("SELECT openfield FROM transactions WHERE openfield LIKE ? AND address = ? ORDER BY block_height ASC, timestamp ASC LIMIT 1;", ("alias=" + '%', row[0],)) # asc for first entry

msg_address = c2.fetchone()[0]

# get alias

except:

msg_address = row[0]

if row[1].startswith("enc=msg="):

msg_received_digest = row[1].lstrip("enc=msg=")

try:

#msg_received_digest = key.decrypt(ast.literal_eval(msg_received_digest)).decode("utf-8")

(cipher_aes_nonce, tag, ciphertext, enc_session_key) = ast.literal_eval(msg_received_digest)

private_key = RSA.import_key(open("privkey.der").read())

# Decrypt the session key with the public RSA key

cipher_rsa = PKCS1_OAEP.new(private_key)

session_key = cipher_rsa.decrypt(enc_session_key)

# Decrypt the data with the AES session key

cipher_aes = AES.new(session_key, AES.MODE_EAX, cipher_aes_nonce)

msg_received_digest = cipher_aes.decrypt_and_verify(ciphertext, tag).decode("utf-8")

except:

msg_received_digest = "Could not decrypt message"

elif row[1].startswith("enc=bmsg="):

msg_received_digest = row[1].lstrip("enc=bmsg=")

try:

msg_received_digest = base64.b64decode(msg_received_digest).decode("utf-8")

#msg_received_digest = key.decrypt(ast.literal_eval(msg_received_digest)).decode("utf-8")

(cipher_aes_nonce, tag, ciphertext, enc_session_key) = ast.literal_eval(msg_received_digest)

private_key = RSA.import_key(open("privkey.der").read())

# Decrypt the session key with the public RSA key

cipher_rsa = PKCS1_OAEP.new(private_key)

session_key = cipher_rsa.decrypt(enc_session_key)

# Decrypt the data with the AES session key

cipher_aes = AES.new(session_key, AES.MODE_EAX, cipher_aes_nonce)

msg_received_digest = cipher_aes.decrypt_and_verify(ciphertext, tag).decode("utf-8")

except:

msg_received_digest = "Could not decrypt message"

elif row[1].startswith("bmsg="):

msg_received_digest = row[1].lstrip("bmsg=")

try:

msg_received_digest = base64.b64decode(msg_received_digest).decode("utf-8")

except:

msg_received_digest = "Could not decode message"

elif row[1].startswith("msg="):

msg_received_digest = row[1].lstrip("msg=")

msg_received.insert(INSERT, ((time.strftime("%Y/%m/%d,%H:%M:%S", time.gmtime(float(row[2])))) + " From " + msg_address.replace("alias=", "") + ": " + msg_received_digest) + "\n")

def msg_sent_get():

for row in c.execute("SELECT recipient,openfield,timestamp FROM transactions WHERE address = ? AND (openfield LIKE ? OR openfield LIKE ? OR openfield LIKE ? OR openfield LIKE ?) ORDER BY timestamp DESC;", (address,) + ("msg=" + '%',) + ("bmsg=" + '%',) + ("enc=msg=" + '%',) + ("enc=bmsg=" + '%',)):

try:

# get alias

c2.execute("SELECT openfield FROM transactions WHERE openfield LIKE ? AND address = ? ORDER BY block_height ASC, timestamp ASC LIMIT 1;", ("alias=" + '%', row[0],)) # asc for first entry

msg_recipient = c2.fetchone()[0]

# get alias

except:

msg_recipient = row[0]

if row[1].startswith("enc=msg="):

msg_sent_digest = row[1].lstrip("enc=msg=")

try:

#msg_sent_digest = key.decrypt(ast.literal_eval(msg_sent_digest)).decode("utf-8")

(cipher_aes_nonce, tag, ciphertext, enc_session_key) = ast.literal_eval(msg_sent_digest)

private_key = RSA.import_key(open("privkey.der").read())

# Decrypt the session key with the public RSA key

cipher_rsa = PKCS1_OAEP.new(private_key)

session_key = cipher_rsa.decrypt(enc_session_key)

# Decrypt the data with the AES session key

cipher_aes = AES.new(session_key, AES.MODE_EAX, cipher_aes_nonce)

msg_sent_digest = cipher_aes.decrypt_and_verify(ciphertext, tag).decode("utf-8")

except:

msg_sent_digest = "Could not decrypt message"

elif row[1].startswith("enc=bmsg="):

msg_sent_digest = row[1].lstrip("enc=bmsg=")

try:

msg_sent_digest = base64.b64decode(msg_sent_digest).decode("utf-8")

#msg_sent_digest = key.decrypt(ast.literal_eval(msg_sent_digest)).decode("utf-8")

(cipher_aes_nonce, tag, ciphertext, enc_session_key) = ast.literal_eval(msg_sent_digest)

private_key = RSA.import_key(open("privkey.der").read())

# Decrypt the session key with the public RSA key

cipher_rsa = PKCS1_OAEP.new(private_key)

session_key = cipher_rsa.decrypt(enc_session_key)

# Decrypt the data with the AES session key

cipher_aes = AES.new(session_key, AES.MODE_EAX, cipher_aes_nonce)

msg_sent_digest = cipher_aes.decrypt_and_verify(ciphertext, tag).decode("utf-8")

except:

msg_sent_digest = "Could not decrypt message"

elif row[1].startswith("bmsg="):

msg_sent_digest = row[1].lstrip("bmsg=")

try:

msg_sent_digest = base64.b64decode(msg_sent_digest).decode("utf-8")

except:

msg_received_digest = "Could not decode message"

elif row[1].startswith("msg="):

msg_sent_digest = row[1].lstrip("msg=")

msg_sent.insert(INSERT, ((time.strftime("%Y/%m/%d,%H:%M:%S", time.gmtime(float(row[2])))) + " To " + msg_recipient.replace("alias=", "") + ": " + msg_sent_digest) + "\n")

# popup

top11 = Toplevel()

top11.title("Messaging")

Label(top11, text="Received:", width=20).grid(row=0)

msg_received = Text(top11, width=100, height=20, font=("Tahoma", 8))

msg_received.grid(row=1, column=0, sticky=W, padx=5, pady=(5, 5))

msg_received_get()

Label(top11, text="Sent:", width=20).grid(row=2)

msg_sent = Text(top11, width=100, height=20, font=("Tahoma", 8))

msg_sent.grid(row=3, column=0, sticky=W, padx=5, pady=(5, 5))

msg_sent_get()

dismiss = Button(top11, text="Dismiss", command=top11.destroy)

dismiss.grid(row=5, column=0, sticky=W + E, padx=15, pady=(5, 5))

def verify_this():

try:

received_public_key = RSA.importKey(public_key_gui.get("1.0", END))

verifier = PKCS1_v1_5.new(received_public_key)

h = SHA.new(input_text.get("1.0", END).encode("utf-8"))

received_signature_dec = base64.b64decode(output_signature.get("1.0", END))

if verifier.verify(h, received_signature_dec):

top2 = Toplevel()

top2.title("Validation results")

msg = Message(top2, text="Signature Valid", width=50)

msg.pack()

button = Button(top2, text="Dismiss", command=top2.destroy)

button.pack()

else:

raise

except:

top2 = Toplevel()

top2.title("Validation results")

msg = Message(top2, text="Signature Invalid", width=50)

msg.pack()

button = Button(top2, text="Dismiss", command=top2.destroy)

button.pack()

def sign_this():

h = SHA.new(input_text.get("1.0", END).encode("utf-8"))

signer = PKCS1_v1_5.new(key)

signature = signer.sign(h)

signature_enc = base64.b64encode(signature)

output_signature.delete('1.0', END) # remove previous

output_signature.insert(INSERT, signature_enc)

# popup

top = Toplevel()

top.title("Sign message")

# top.geometry("%dx%d%+d%+d" % (800, 600, 0, 0))

# top.grid_propagate(False)

Label(top, text="Message:", width=20).grid(row=0, pady=0)

input_text = Text(top, height=10)

# label.image = photo # operation a reference!

input_text.grid(row=1, column=0, sticky=N + E, padx=15, pady=(0, 0))

Label(top, text="Public Key:", width=20).grid(row=2, pady=0)

public_key_gui = Text(top, height=10)

public_key_gui.insert(INSERT, public_key_readable)

public_key_gui.grid(row=3, column=0, sticky=N + E, padx=15, pady=(0, 0))

Label(top, text="Signature:", width=20).grid(row=4, pady=0)

output_signature = Text(top, height=10)

output_signature.grid(row=5, column=0, sticky=N + E, padx=15, pady=(0, 0))

# msg = Message(top, text="hi")

# msg.pack()

sign_message = Button(top, text="Sign Message", command=sign_this)

sign_message.grid(row=6, column=0, sticky=W + E, padx=15, pady=(5, 0))

sign_message = Button(top, text="Verify Message", command=verify_this)

sign_message.grid(row=7, column=0, sticky=W + E, padx=15, pady=(15, 0))

dismiss = Button(top, text="Dismiss", command=top.destroy)

dismiss.grid(row=8, column=0, sticky=W + E, padx=15, pady=(15, 5))

# transaction table

# data

datasheet = ["Time", "From", "To", "Amount", "Type"]

rows_total = 19

for row in m.execute("SELECT * FROM transactions WHERE address = ? OR recipient = ? ORDER BY timestamp DESC LIMIT 19;", (address,) + (address,)):

rows_total = rows_total - 1

# mempool_timestamp = row[1]

# datasheet.append(datetime.fromtimestamp(float(mempool_timestamp)).strftime('%Y-%m-%d %H:%M:%S'))

datasheet.append("Unconfirmed")

mempool_address = row[1]

datasheet.append(mempool_address)

mempool_recipient = row[2]

datasheet.append(mempool_recipient)

mempool_amount = row[3]

datasheet.append(mempool_amount)

symbol = " Transaction"

datasheet.append(symbol)

for row in c.execute("SELECT * FROM transactions WHERE address = ? OR recipient = ? ORDER BY block_height DESC LIMIT ?;", (address,) + (address,) + (rows_total,)):

db_timestamp = row[1]

datasheet.append(datetime.fromtimestamp(float(db_timestamp)).strftime('%Y-%m-%d %H:%M:%S'))

db_address = row[2]

datasheet.append(db_address)

db_recipient = row[3]

datasheet.append(db_recipient)

db_amount = row[4]

db_reward = row[9]

db_openfield = row[11]

datasheet.append('%.8f' % (float(db_amount) + float(db_reward)))

if float(db_reward) > 0:

symbol = "Mined"

elif db_openfield.startswith("bmsg"):

symbol = "b64 Message"

elif db_openfield.startswith("msg"):

symbol = "Message"

else:

symbol = "Transaction"

datasheet.append(symbol)

# data

app_log.warning(datasheet)

app_log.warning(len(datasheet))

if len(datasheet) == 5:

app_log.warning("Looks like a new address")

elif len(datasheet) < 20 * 5:

app_log.warning(len(datasheet))

table_limit = len(datasheet) / 5

else:

table_limit = 20

if len(datasheet) > 5:

k = 0

for child in f4.winfo_children(): # prevent hangup

child.destroy()

for i in range(int(table_limit)):

for j in range(5):

datasheet_compare = [datasheet[k], datasheet[k - 1], datasheet[k - 2], datasheet[k - 3], datasheet[k - 4]]

if "Time" in datasheet_compare: #header

e = Entry(f4, width=0)

e.configure(readonlybackground='linen')

elif j == 0: #first row

e = Entry(f4, width=0)

e.configure(readonlybackground='linen')

elif "Unconfirmed" in datasheet_compare: #unconfirmed txs

e = Entry(f4, width=0)

e.configure(readonlybackground='linen')

elif datasheet[k - 2] == address and j == 3: #sent

e = Entry(f4, width=0)

e.configure(readonlybackground='indianred')

elif datasheet[k - 1] == address and j == 3: #received

e = Entry(f4, width=0)

e.configure(readonlybackground='green4')

elif j == 4: #last row

e = Entry(f4, width=0)

e.configure(readonlybackground='bisque')

else:

e = Entry(f4, width=0)

e.configure(readonlybackground='bisque')

e.grid(row=i + 1, column=j, sticky=EW)

e.insert(END, datasheet[k])

e.configure(state="readonly")

k = k + 1

# transaction table

global balance

# print "refresh triggered"

try:

s = socks.socksocket()

s.connect((node_ip_conf, int(port)))

connections.send(s, "balanceget", 10)

connections.send(s, address, 10) # change address here to view other people's transactions

stats_account = connections.receive(s, 10)

balance = stats_account[0]

credit = stats_account[1]

debit = stats_account[2]

fees = stats_account[3]

rewards = stats_account[4]

app_log.warning("Transaction address balance: {}".format(balance))

connections.send(s, "blocklast", 10)

block_get = connections.receive(s, 10)

bl_height = block_get[0]

db_timestamp_last = block_get[1]

s.close()

except: # get locally

app_log.warning("Unable to start in light mode, using local db for balance calculation")

# global balance

# print "refresh triggered"

m.execute("SELECT count(amount), sum(amount) FROM transactions WHERE address = ?;", (address,))

result = m.fetchall()[0]

if result[1] != None:

debit_mempool = float(result[1]) + float(result[1]) * 0.001 + int(result[0]) * 0.01

else:

debit_mempool = 0

c.execute("SELECT sum(amount) FROM transactions WHERE recipient = ?;", (address,))

credit = c.fetchone()[0]

c.execute("SELECT sum(amount) FROM transactions WHERE address = ?;", (address,))

debit = c.fetchone()[0]

c.execute("SELECT sum(fee) FROM transactions WHERE address = ?;", (address,))

fees = c.fetchone()[0]

c.execute("SELECT sum(reward) FROM transactions WHERE address = ?;", (address,))

rewards = c.fetchone()[0]

c.execute("SELECT MAX(block_height) FROM transactions")

bl_height = c.fetchone()[0]

debit = 0 if debit is None else float('%.8f' % debit)

fees = 0 if fees is None else float('%.8f' % fees)

rewards = 0 if rewards is None else float('%.8f' % rewards)

credit = 0 if credit is None else float('%.8f' % credit)

balance = '%.8f' % (credit - debit - fees + rewards - debit_mempool)

app_log.warning("Node: Transction address balance: {}".format(balance))

# calculate diff

c.execute("SELECT * FROM transactions WHERE reward != 0 ORDER BY block_height DESC LIMIT 1;") # or it takes the first

result = c.fetchall()

db_timestamp_last = float(result[0][1])

# print db_timestamp_last

db_block_height = result[0][0]

# print timestamp_avg

try:

if encode_var.get() == 1:

openfield_input = base64.b64encode(str(openfield.get("1.0", END).strip()))

else:

openfield_input = str(openfield.get("1.0", END)).strip()

fee = '%.8f' % float(0.01 + (float(len(openfield_input)) / 100000) + int(operation_var.get())) # 0.01 dust

app_log.warning("Fee: {}".format(fee))

except Exception as e:

fee = 0.01

app_log.warning("Fee error: {}".format(e))

# calculate fee

# check difficulty

try:

s = socks.socksocket()

s.connect((node_ip_conf, int(port)))

connections.send(s, "diffget", 10)

diff = connections.receive(s, 10)

s.close()

except: # get locally

app_log.warning("Unable to start in light mode, using local db for difficulty calculation")

diff = difficulty(c)

# check difficulty

diff_msg = diff[1]

# network status

time_now = str(time.time())

last_block_ago = float(time_now) - float(db_timestamp_last)

if last_block_ago > 300:

sync_msg = "{}m behind".format((int(last_block_ago / 60)))

sync_msg_label.config(fg='red')

else:

sync_msg = "Up to date\nLast block: {}s ago".format((int(last_block_ago)))

sync_msg_label.config(fg='green')

# network status

# aliases

# c.execute("SELECT openfield FROM transactions WHERE address = ? AND openfield LIKE ?;",(address,)+("alias="+'%',))

# aliases = c.fetchall()

# app_log.warning("Aliases: "+str(aliases))

# aliases

# fees_current_var.set("Current Fee: {}".format('%.8f' % float(fee)))

balance_var.set("Balance: {}".format('%.8f' % float(balance)))

debit_var.set("Spent Total: {}".format('%.8f' % float(debit)))

credit_var.set("Received Total: {}".format('%.8f' % float(credit)))

fees_var.set("Fees Paid: {}".format('%.8f' % float(fees)))

rewards_var.set("Rewards: {}".format('%.8f' % float(rewards)))

bl_height_var.set("Block Height: {}".format(bl_height))

diff_msg_var.set("Mining Difficulty: {}".format('%.2f' % float(diff_msg)))

sync_msg_var.set("Network: {}".format(sync_msg))

table()