12345678910111213141516171819202122232425262728 |
- import xbmcaddon
- import xbmcgui
- import mysql.connector
- addon = xbmcaddon.Addon()
- addonname = addon.getAddonInfo('name')
- ssid = addon.getSetting('ssid')
- bdd_host = addon.getSetting('host')
- bdd_user = addon.getSetting('username')
- bdd_pass = addon.getSetting('password')
- bdd_base = addon.getSetting('database')
- cnx = mysql.connector.connect(user=bdd_user, password=bdd_pass,
- host=bdd_host, database=bdd_base)
- cursor = cnx.cursor()
- query = ("SELECT password FROM alt_guest_wifi "
- "WHERE ssid LIKE \"%s\" LIMIT 1") % ssid
- cursor.execute(query)
- row = cursor.fetchone()
- cursor.close()
- cnx.close()
- line = "This week's password for %s is:\n\n%s" % (ssid, row[0])
- xbmcgui.Dialog().ok(addonname, line)
|