def do_neprectene(self,line): # NEPRECTENE cols,rows=conyxDBQuery('select * from klub_cache where unread != "0"') if len(rows) > 0: for r in (rows): print(r[1]+"|"+r[2]+"|"+r[3]+"|"+r[4]); else: print("Nemas zadne neprectene prispevky v klubech")
def do_reakce(self,line): # REAKCE - PRISPEVKY PRO REAKCI cols,rows=conyxDBQuery('select * from klub_cache where unread != "0" and replies != "0"') if len(rows) > 0: for r in (rows): print(r[1]+"|"+r[2]+"|"+r[3]+"|"+r[4]); else: print("Nikdo vam v klubech nepise")
def getLastVisitedClub(): klub_id = 1 cols, rows = conyxDBQuery( 'select * from last where rowid = (select max(rowid) from last)') if (rows): klub_id = rows[0][0] return (klub_id)
def odhadniKomuJePrispevekUrcen(id_prisp): cols, rows = conyxDBQuery( 'select prisp_from, prisp_text from prispevek_cache where id_prispevek = ' + id_prisp) if len(rows) > 0: for r in (rows): print(cleanHtml(r[1])) return (r[0])
def do_dalsiReakce(self,line): # DALSI KLUB URCENY K REAKCI cols,rows=conyxDBQuery('select id_klub from klub_cache where cast(unread as decimal) > 0 and cast(replies as decimal) > 0 limit 1') if len(rows) > 0: for r in (rows): print(r[0]); zmenKlub(r[0]) else: print("Nemas zadny neprecteny diskuzni klub s reakci")
def do_dalsiNeprecteny(self,line): # NEPRECTENE cols,rows=conyxDBQuery('select id_klub from klub_cache where cast(unread as decimal) > 0 limit 1') if len(rows) > 0: for r in (rows): print(r[0]); zmenKlub(r[0]) else: print("Nemas zadny neprecteny diskuzni klub")
def nactiNazevKlubu(p_klub_id): p_klub_name = "?" cols, rows = conyxDBQuery( 'select jmeno from klub_cache where id_klub = "' + str(p_klub_id) + '"') if len(rows) > 0: p_klub_name = rows[0][0].encode("utf-8") return (p_klub_name)
def getMailContent(msg_id): buffer = [] cols, rows = conyxDBQuery( "select other_nick, content, time, direction from mail where id = %s" % (msg_id)) for i in rows: buffer.append((str(i[0]), str(i[1]), str(i[2]), str(i[3]))) return (buffer)
def cacheVypisPrispevky(): cols, rows = conyxDBQuery( 'select id_prispevek, prisp_from, prisp_text, prisp_hodnoceni wu_rating from prispevek_cache' ) if len(rows) > 0: for r in (rows): print( str(r[0]) + "|" + str(r[1]) + "|" + cleanHtml(r[2]) + "|" + str(r[3]))
def do_ctiPostu(self,line): # HISTORIE try: print("Dorucena posta") cols,rows=conyxDBQuery("select case when direction = 'from' then 'od' else 'komu' end || ' ' || other_nick || '|' || content from mail order by rowid desc") if len(rows)>0: for r in rows: print(r[0]) except Exception: traceback.print_exc(file=sys.stdout) print("Nemuzu zobrazit stazenou postu")
def do_historie(self,line): # HISTORIE try: print("Historie navstivenych klubu") cols,rows=conyxDBQuery('select id_klub || " " || klub_cache.jmeno line from last, klub_cache where last.forum_id = id_klub order by last.rowid desc limit 10') if len(rows)>0: for r in rows: print(r[0]) except Exception: traceback.print_exc(file=sys.stdout) print("Nemuzu zobrazit posledni navstivene podle docasne pameti")
def nactiNazevKlubu(p_klub_id): p_klub_name = "?" cols, rows = conyxDBQuery( 'select jmeno from klub_cache where id_klub = "' + str(p_klub_id) + '"') if len(rows) > 0: p_klub_name = rows[0][0] else: p_klub_name = nyx_disc_header(p_klub_id) return (p_klub_name)
def do_ctiKlubOd(self,line): print("Nacitam klub do databaze " + str(i_klub_id)) try: res=conyxDBQuery('select min(id_prispevek) prid from prispevek_cache') #buf=nyx_show_disc_msgs_from(str(i_klub_id),line) buf=nyx_show_disc_msgs_from(str(i_klub_id),res[1][0][0]) #print(buf) #print(res) conyxDBGenDML('update klub_cache set unread = "0" where id_klub="'+str(i_klub_id)+'"') except Exception: traceback.print_exc(file=sys.stdout) print("Nepodarilo se ulozit prispevky z aktualni diskuze do databaze")
def getMail(): buffer = [] cols, rows = conyxDBQuery( """select id, direction, other_nick, time from mail""") for i in rows: msg_date = time.strftime("%d.%m.%Y %H:%M", time.localtime(int(i[3]))) msg_dir = 'komu' if (i[1] == 'from'): msg_dir = 'od ' buffer.append( str(i[0]) + '|' + msg_dir + '|' + str(i[2][:14]).ljust(14) + '|' + msg_date) return (buffer)
def zobrazDiskuzi(klub_id, screen, onTerm=0, id_wu=None, dir="older", filter_user=None, filter_keyword=None): #print("Nacitam klub do databaze " + str(i_klub_id)) try: if not (filter_user is None): buf = nyx_show_disc_msgs_filter(str(klub_id), filter_user, None) elif not (filter_keyword is None): buf = nyx_show_disc_msgs_filter(str(klub_id), None, filter_keyword) elif not (id_wu is None): buf = nyx_show_disc_msgs_from(str(klub_id), id_wu, dir) else: buf = nyx_show_disc_msgs(str(klub_id)) #print("posledni prispevek: " + str(int(res[1][0][0]))) conyxDBGenDML('update klub_cache set unread = "0" where id_klub="' + str(klub_id) + '"') except Exception: eraceback.print_exc(file=sys.stdout) print("Nepodarilo se ulozit prispevky z aktualni diskuze do databaze") input("PROBLEM") # #buf=nyx_show_disc_msgs(str(klub_id)) cols, rows = conyxDBQuery( 'select prisp_from || "|" || prisp_text || "|" || prisp_hodnoceni wu_rating from prispevek_cache' ) buffer = [] for i in rows: buffer.append(i[0]) if rows: if onTerm == 0: print(rows) print(len(rows)) if len(rows[0]) > 0: #klub_name=getKlubNameFromID(klub_id)[:width-10] klub_name = "" try: klub_name = getKlubNameFromID(klub_id)[:-10] except Exception: 1 == 1 conyxOpsTuiBuffer(klub_name, buffer) else: screen.clear() screen.refresh() screen.addstr(1, 3, "Nic nenalezeno...") screen.getch() screen.clear() screen.refresh()
def conyx_main(): global i_klub_id p_nickname = get_auth_nickname() if p_nickname == "": p_nickname=input("Zadej ID: ") # v0.1.9 raw_input -> input conyxDBUpdNickname(p_nickname) if (nyx_auth(p_nickname)==0): cols, rows = conyxDBQuery('select * from last where rowid = (select max(rowid) from last)') if len(rows)>0: i_klub_id = rows[0][0] else: i_klub_id = 1 #print (str(rows[0][0])) cli().cmdloop()
def zmenKlub(p_klub_id): try: if p_klub_id != "": global i_klub_id global i_klub_name i_klub_id=int(p_klub_id) conyxDBLast(i_klub_id) try: cols,rows=conyxDBQuery('select jmeno from klub_cache where id_klub = "' + str(i_klub_id) + '"') if len(rows)>0: i_klub_name=rows[0][0].encode("utf-8") else: i_klub_name='?' except Exception: traceback.print_exc(file=sys.stdout) print("Tento klub nemam v cache.") print("Zvolen klub: " + str(i_klub_id)) else: print("Musis zadat cislo klubu (napr. k 532)") except Exception: traceback.print_exc(file=sys.stdout) print("Nepodarilo se zvolit klub.")
def nyx_auth(p_nickname): ret=-1 cols , rows = conyxDBQuery('select auth_key from auth') params = urllib.urlencode({ 'auth_nick':get_auth_nickname(), 'auth_token':get_auth_token(), 'l':'help', 'l2':'test' }) try: resp = urllib.urlopen(url, params).read() except Exception: print("Chyba pri pripojeni na server") exit() #print(resp) try: res=json.loads(resp) except Exception: print("Chyba pri zpracovani odpovedi serveru") exit() if not res.has_key("system"): if res["code"]=="401" and res["error"]!='Not Authorized': print("Nejdrive zruste stavajici registraci") elif res["code"]=="401" and res["auth_state"]=='AUTH_EXISTING': print('Nejprve zruste stavajici registraci') elif res["code"]=="401" and res["auth_state"]=='AUTH_INVALID_USERNAME': print('Nespravny uzivatel') conyxDBUpdNickname('') else: print("AUTH CODE: " + res["auth_code"]) #print ("Storing Auth Code to DB") conyxDBStoreAuth(res["auth_token"]) #print("AUTH TOKEN: " + res["auth_token"]) else: print("Pripojen na server ...") ret=0 return(ret)
def cacheVypisPrispevky(): cols, rows = conyxDBQuery( "select id_prispevek, prisp_from ||'|'||prisp_text||'|'||prisp_hodnoceni from prispevek_cache" ) return (cols, rows)
def draw_menu(stdscr): global tui_klub_id k = 0 cursor_x = 0 cursor_y = 0 encoding = locale.getpreferredencoding() locale.setlocale(locale.LC_ALL, '') stdscr = curses.initscr() # Clear and refresh the screen for a blank canvas stdscr.clear() stdscr.refresh() # Start colors in curses curses.start_color() curses.init_pair(1, curses.COLOR_CYAN, curses.COLOR_BLACK) curses.init_pair(2, curses.COLOR_RED, curses.COLOR_BLACK) curses.init_pair(3, curses.COLOR_BLACK, curses.COLOR_WHITE) klub_strana = 1 # Loop where k is the last character pressed while (k != ord('q')): # RODICOVSKY ZAMEK rodzam = getParentalLockStatus() #print(str(rodzam)) if (rodzam == 1): rodzamkl = getParentalLockClub() conyxDBLast(rodzamkl) tui_klub_id = rodzamkl # Initialization stdscr.clear() height, width = stdscr.getmaxyx() tui_klub_id = getLastVisitedClub() club_changed = 0 if rodzam == 1: if k == ord("0"): # k - konfigurace tuiConfig() elif k == ord("c") or k == ord("\n"): # C - cti prispevky zobrazDiskuzi(str(tui_klub_id), stdscr, 1) stdscr.clear() elif k == ord("p"): # P - pis try: stdscr.refresh() curses.cbreak() stdscr.addstr( 0, 3, "Tvuj novy prispevek: [ ctrl+g nebo zaplneni okenka pro odeslani ]" ) height, width = stdscr.getmaxyx() x = 2 y = 2 h = height - y w = width - x rectangle(stdscr, x - 1, y - 1, h + 1, w) editwin = curses.newwin(h - 1, w - 2, x, y) stdscr.refresh() #box=Textbox(editwin) box = inputBox(editwin) box.edit() text = box.gather() try: if (text != ""): text = text[:-1] curses.nocbreak() orig_text = text tmp = orig_text.strip().split('\n') text = "" for i in tmp: text += i if (len(i) != width - 4): text += '\n' nazev_klubu = nactiNazevKlubu(tui_klub_id)[:width - 1] if (nyx_send_message(tui_klub_id, text) == 0): stdscr.addstr(0, 0, " " * width) stdscr.addstr( 0, 0, "*** Prispevek odeslan do klubu: " + sutf8(str(tui_klub_id)) + " " + nazev_klubu) else: stdscr.addstr(0, 0, " " * width) stdscr.addstr( 0, 0, "! Chyba pri odesilani prispevku do klubu" + nazev_klubu) #stdscr.getch() x = ugetch(stdscr) curses.cbreak() except Exception: stdscr.addstr(0, 0, "Nepodarilo se odeslat prispevek") #traceback.print_exc(file=sys.stdout) #stdscr.getch() x = ugetch(stdscr) stdscr.refresh() stdscr.clear() except Exception: traceback.print_exc(file=sys.stdout) input("Zmackni Enter ...") print("Problem pri ziskani cisla klubu.") else: if k == curses.KEY_DOWN: cursor_y = cursor_y + 1 elif k == ord("0"): # k - konfigurace tuiConfig() elif k == ord("1"): # 1 - napoveda tuiFile("napoveda.txt") elif k == ord("m"): # m - ozna(m)eni curses.endwin() nyx_feed_notices() stdscr.clear() elif k == curses.KEY_UP: cursor_y = cursor_y - 1 elif k == curses.KEY_RIGHT: cursor_x = cursor_x + 1 elif k == curses.KEY_LEFT: cursor_x = cursor_x - 1 elif k == ord("z"): # Z - zmeny try: tuiFile("CHANGELOG") except Exception: print("Nemuzu zobrazit seznam zmen.") elif k == ord("n"): # N - neprectene kluby retVal = tuiMainMenu(1) if (retVal): tui_klub_id = retVal conyxDBLast(tui_klub_id) club_changed = 1 klub_strana = 1 stdscr.clear() elif k == ord("r"): # R - kluby s reakci retVal = tuiMainMenu(2) if (retVal): tui_klub_id = retVal conyxDBLast(tui_klub_id) club_changed = 1 klub_strana = 1 stdscr.clear() elif k == ord("h"): # H - historie retVal = tuiMainMenu(4) #retVal=nyx_bookmarks_history() if (retVal): tui_klub_id = retVal conyxDBLast(tui_klub_id) club_changed = 1 klub_strana = 1 stdscr.clear() elif k == ord("s"): # S - sledovane retVal = tuiMainMenu(0) if (retVal): tui_klub_id = retVal conyxDBLast(tui_klub_id) club_changed = 1 stdscr.clear() elif k == ord("c") or k == ord("\n"): # C - cti prispevky zobrazDiskuzi(str(tui_klub_id), stdscr, 1) stdscr.clear() elif k == ord("o"): # O - cti predchozi od nejstarsiho prispevku res = conyxDBQuery( 'select min(id_prispevek) prid from prispevek_cache') ret = zobrazDiskuzi(str(tui_klub_id), stdscr, 1, res[1][0][0], "older") res_aft = conyxDBQuery( 'select min(id_prispevek) prid from prispevek_cache') if (res != res_aft): klub_strana += 1 stdscr.clear() elif k == ord("w"): # W - vyhledej writeup na celem Nyxu stdscr.addstr(0, 1, "Hledej na celem Nyxu:") footer = "-=[ klavesy: CTRL+G odeslat, CTRL+X zrusit ]=-" if (len(footer) >= height - 1): footer = "-=[ ^G, ^X ]=-" stdscr.addstr(height - 1, 0, footer) x = 1 y = 1 h = height - 3 w = width - 3 rectangle(stdscr, y, x, y + h, x + w) editwin = curses.newwin(h - 1, w - 1, y + 1, x + 1) stdscr.refresh() #box=Textbox(editwin) box = inputBox(editwin) box.edit() text = box.gather() if text != "": #print("TEXT: "+text) #stdscr.getch() rx, res = nyx_search_writeups(None, text, None) buffer = [] for i in res["data"]: buffer.append(i["klub_jmeno"] + "|" + i["nick"] + "|" + cleanhtml(i["content"])) tuiBuffer("Vysledek hledani", buffer) else: stdscr.clear() elif k == ord("v"): # V - vyhledat klicove slovo stdscr.addstr(0, 1, "Hledej v diskuzi:") footer = "-=[ klavesy: CTRL+G odeslat, CTRL+X zrusit ]=-" if (len(footer) >= height - 1): footer = "-=[ ^G, ^X ]=-" stdscr.addstr(height - 1, 0, footer) x = 1 y = 1 h = height - 3 w = width - 3 rectangle(stdscr, y, x, y + h, x + w) editwin = curses.newwin(h - 1, w - 1, y + 1, x + 1) stdscr.refresh() box = inputBox(editwin) box.edit() text = box.gather() if text is not None and text != "": ret = zobrazDiskuzi(str(tui_klub_id), stdscr, 1, None, None, None, text) stdscr.clear() elif k == ord("l"): # B - vyhledat prispevky uzivatele stdscr.addstr(0, 1, "Hledej prispevky uzivatele:") footer = "-=[ klavesy: CTRL+G odeslat, CTRL+X zrusit ]=-" if (len(footer) >= height - 1): footer = "-=[ ^G, ^X ]=-" stdscr.addstr(height - 1, 0, footer) x = 1 y = 1 h = height - 3 w = width - 3 rectangle(stdscr, y, x, y + h, x + w) editwin = curses.newwin(h - 1, w - 1, y + 1, x + 1) stdscr.refresh() #box=Textbox(editwin) box = inputBox(editwin) box.edit() text = box.gather() if text != "": ret = zobrazDiskuzi(str(tui_klub_id), stdscr, 1, None, None, text) stdscr.clear() elif k == ord( "e"): # U - cti nasledujici od nejnovejsiho prispevku res = conyxDBQuery( 'select max(id_prispevek) prid from prispevek_cache') ret = zobrazDiskuzi(str(tui_klub_id), stdscr, 1, res[1][0][0], "newer") if (klub_strana > 1): klub_strana -= 1 stdscr.clear() elif k == ord("p"): # P - pis tuiWritePost(stdscr, width, height, tui_klub_id) elif k == ord("i"): # I - informace ze zahlavi klubu retVal = nyx_disc_header_desc(str(tui_klub_id)) if (retVal): linelen = width - 1 stdscr.addstr( 0, 0, sutf8(cleanHtml( nactiNazevKlubu(tui_klub_id)))[:linelen], curses.color_pair(1)) lineno = 0 for i in range(0, len(retVal[0]), linelen): stdscr.addstr( lineno + 1, 0, sutf8(cleanHtml(retVal[0]))[i:(i + linelen)]) lineno += 1 if lineno > height - 2: break stdscr.addstr(height - 1, 0, "-=[ q - zpatky ]=-") else: stdscr.addstr(0, 0, sutf8("Bez zahlavi")) stdscr.refresh() #stdscr.getch() ugetch(stdscr) stdscr.clear() elif k == ord("f"): # F - odesli soubor dir = str(getConfig('soubory')[0][0]) strings = ls(dir, '') sel = fBrowser(strings, 0, 0) if (not (sel is None)): stdscr.refresh() curses.cbreak() header = "Text k souboru:" height, width = stdscr.getmaxyx() footer = "-=[ klavesy: CTRL+G odeslat, CTRL+X zrusit ]=-" if len(footer) >= width - 1: footer = "-=[ ^G, ^X, ALT+1 ]=-" stdscr.addstr(0, 2, header) stdscr.addstr(height - 1, 0, footer) x = 2 y = 2 h = height - y w = width - x rectangle(stdscr, y - 1, x - 1, h, w) editwin = curses.newwin(h - 1 - 1, w - 2, y, x) stdscr.refresh() box = inputBox(editwin) text = box.edit() stdscr.clear() nazev_klubu = nactiNazevKlubu(tui_klub_id)[:width - 1] if (nyx_send_message(tui_klub_id, text, sel) == 0): stdscr.addstr(0, 0, " " * width) stdscr.addstr( 0, 0, "*** Prispevek se souborem odeslan do klubu: " + sutf8(str(tui_klub_id)) + " " + nazev_klubu) else: stdscr.addstr(0, 0, " " * width) stdscr.addstr( 0, 0, "! Chyba pri odesilani prispevku se souborem do klubu " + nazev_klubu) stdscr.refresh() x = ugetch(stdscr) elif k == ord("d"): # D - dopisy tuiMail() elif k == ord("k"): # K - klub try: stdscr.refresh() curses.cbreak() stdscr.addstr(1, 3, "Vyber klub (cislo):") stdscr.addstr(height - 1, 0, "-=[ klavesy: CTRL+G, CTRL+X ]=-") x = 4 y = 4 h = 1 w = 12 rectangle(stdscr, x - 1, y - 1, h + x + 1, w + y + 1) editwin = curses.newwin(h, w, x, y) stdscr.refresh() #box=Textbox(editwin) box = inputBox(editwin) box.edit() text = box.gather() try: if (text != ""): tui_klub_id = int(text) conyxDBLast(tui_klub_id) conyxDBSetForumLast(tui_klub_id) except Exception: stdscr.addstr(0, 0, "Neplatny vyber klubu") traceback.print_exc(file=sys.stdout) #stdscr.getch() ugetch(stdscr) klub_strana = 1 stdscr.refresh() stdscr.clear() except Exception: traceback.print_exc(file=sys.stdout) input("Zmackni Enter ...") print("Problem pri ziskani cisla klubu.") rodzam = getParentalLockStatus() stdscr.refresh() stdscr.clear() cursor_x = max(0, cursor_x) cursor_x = min(width - 1, cursor_x) cursor_y = max(0, cursor_y) cursor_y = min(height - 1, cursor_y) # Declaration of strings start_y = int((height // 2) - 8) if (rodzam == 1): title = "klávesa c - čti" start_x_title = int((width // 2) - (len(title) // 2) - len(title) % 2) stdscr.addstr(start_y, start_x_title, sutf8(title)) subtitle = "klávesa p - piš" stdscr.addstr(start_y + 2, start_x_title, sutf8(subtitle)) else: title = "C O N Y X"[:width - 1] subtitle = "CONSOLE NYX CLIENT"[:width - 1] #keystr = "Posledni klavesa: {}".format(k)[:width-1] + " KLUB: " + str(tui_klub_id) + " str.: " + str(klub_strana) keystr = " KLUB [" + str(klub_strana) + "] : " + str(tui_klub_id) nazev_klubu = nactiNazevKlubu(tui_klub_id)[:width - 1] pre_sbar = "(q)uit |" post_sbar = "| (1) napoveda" fill_len = width - 1 - len(pre_sbar) - len(post_sbar) statusbarstr = pre_sbar + ("_" * fill_len) + post_sbar sun = "Slunce: " + str(sunrise().strftime("%H.%M")) + "-" + str( sunset().strftime("%H.%M")) moon = "Měsíc: " + str(moon_phase()) zodnow = datetime.datetime.now().strftime("%Y-%m-%d") name_zodiac = "Zvěrokruh: " + str(zodiac(zodnow)) today = datetime.datetime.now().strftime("%d.%m.") day = hlp_day(datetime.datetime.now().strftime("%w")) name_date = datetime.datetime.now().strftime("%m-%d") name_day_name = hlp_nday_qry( "select name from jmeniny where date = '%s'" % name_date) name_day = "Dnes je " + day + " " + today + " a svátek má " + name_day_name[ 0][0] credits = "MMXVIII-MMXX" if k == 0: credits = "MMXVIII-MMXX" keystr = " KLUB [" + str(klub_strana) + "] : " + str( tui_klub_id) # Centering calculations start_x_title = int((width // 2) - (len(title) // 2) - len(title) % 2) start_x_subtitle = int((width // 2) - (len(subtitle) // 2) - len(subtitle) % 2) start_x_keystr = int((width // 2) - (len(keystr) // 2) - len(keystr) % 2) start_x_credits = int((width // 2) - (len(credits) // 2) - len(credits) % 2) start_x_nazev_klubu = int((width // 2) - (len(nazev_klubu) // 2) - len(nazev_klubu) % 2) start_x_sun = int((width // 2) - (len(sun) // 2) - len(sun) % 2) start_x_moon = int((width // 2) - (len(moon) // 2) - len(moon) % 2) start_x_zodiac = int((width // 2) - (len(name_zodiac) // 2) - len(name_zodiac) % 2) start_x_name_day = int((width // 2) - (len(name_day) // 2) - len(name_day) % 2) # Render status bar stdscr.attron(curses.color_pair(3)) stdscr.addstr(height - 1, 0, sutf8(statusbarstr)) stdscr.addstr(height - 1, len(statusbarstr), " " * (width - len(statusbarstr) - 1)) stdscr.attroff(curses.color_pair(3)) # Turning on attributes for title stdscr.attron(curses.color_pair(2)) stdscr.attron(curses.A_BOLD) # Rendering title #stdscr.addstr(start_y, start_x_title, sutf8(title)) # Print rest of text stdscr.addstr( start_y, start_x_title, sutf8(title), ) # Turning off attributes for the rest stdscr.attroff(curses.color_pair(2)) stdscr.attroff(curses.A_BOLD) stdscr.addstr(start_y + 2, start_x_keystr, sutf8(keystr)) stdscr.addstr(start_y + 4, start_x_nazev_klubu, sutf8(nazev_klubu)) stdscr.addstr(start_y + 6, start_x_sun, sutf8(sun)) stdscr.addstr(start_y + 8, start_x_moon, sutf8(moon)) stdscr.addstr(start_y + 10, start_x_name_day, sutf8(name_day)) stdscr.addstr(start_y + 12, start_x_zodiac, sutf8(name_zodiac)) stdscr.move(cursor_y, cursor_x) # Refresh the screen stdscr.refresh() # Wait for next input #k = stdscr.getch() k = ugetch(stdscr)
def get_auth_nickname(): cols , rows = conyxDBQuery('select nickname from nick') return(str(rows[0][0]))
def getConfig(key): cols, rows = conyxDBQuery('select value from config where key = "%s"' % key) return (rows)
def get_auth_token(): cols , rows = conyxDBQuery('select auth_key from auth') return(str(rows[0][0]))
from conyxDBUpdNickname import conyxDBUpdNickname from tuiFile import * from tuiMainScreen import * import sys, os, traceback global i_klub_id def do_tui(): try: tuiMainScreen() except Exception: print("Chyba pri inicializaci textoveho grafickeho rozhrani.") traceback.print_exc(file=sys.stdout) if __name__ == '__main__': #def main(): global i_klub_id p_nickname = get_auth_nickname() if p_nickname == "": p_nickname=input("Zadej ID: ") # v0.1.9 raw_input -> input conyxDBUpdNickname(p_nickname) if (nyx_auth(p_nickname)==0): cols, rows = conyxDBQuery('select * from last where rowid = (select max(rowid) from last)') if len(rows)>0: i_klub_id = rows[0][0] else: i_klub_id = 1 do_tui()
def getParentalLockClub(): cols, rows = conyxDBQuery( 'select value from config where key = "rodicovsky_zamek_klub"') rodzamkl = int(rows[0][0]) return (rodzamkl)
def do_cache(self, line): # CACHE cols, rows = conyxDBQuery('select * from klub_cache where ') if len(rows) > 0: for r in (rows): print(str(r[0]) + "|" + str(r[2]))
def conyxDBGetForumLast(): cols , rows = conyxDBQuery('select id from current') return(str(rows[0][0]))
def getKlubNameFromID(id_klub): cols, rows = conyxDBQuery( "select jmeno from klub_cache where id_klub = '" + str(id_klub) + "'") return (rows[0][0])
actual_char='>' import sys, os, traceback #reload(sys) #sys.setdefaultencoding('utf8') import locale import sys import re if ('CONYX') in os.environ: sys.path.insert(0, (os.environ['CONYX']+'/lib')) from conyxDBQuery import conyxDBQuery from conyxOps import * buffer=[] cols, rows = conyxDBQuery('select id_klub,jmeno from klub_cache') for i in rows: buffer.append(i[1]) def tuiMenu(refs,strings,last_pos,last_page): row_num = len(strings) screen = curses.initscr() height,width=screen.getmaxyx() tmp=[] for i in strings: tmp.append(i[:width-4]) strings=tmp curses.noecho() curses.cbreak() curses.start_color() screen.keypad(1)
def getParentalLockStatus(): cols, rows = conyxDBQuery( 'select value from config where key = "rodicovsky_zamek"') rodzam = int(rows[0][0]) return (rodzam)