def setcache(username):
db = MySQLDatabase(app.config['DATABASE'], host = app.config['DATABASEHOST'], user = app.config['USERNAME'], passwd = app.config['PASSWORD'])
cur = db.get_cursor()
#rsslist = db.execute('select name, xmlurl from rsslist where user="******"')
#rsslist = rsslist.fetchall()
cur.execute('select name, xmlurl from rsslist where user="******"')
rsslist = cur.fetchall()
rsslist = formatrss(rsslist)
cache.set('rsslist', rsslist, timeout = 60 * 60 * 24)
return rsslist
def doSQL(n, u, h, a, g):
db = MySQLDatabase("asm_main", host=host, port=3306, user=user, passwd=passwd)
db.connect()
cur = db.get_cursor()
nick = n
user = u
host = h
account = a
gecos = g
escape = db.get_conn().escape_string
sql = "SELECT * FROM actionlog WHERE "
search = []
if nick:
search.append("nick LIKE '{nick}'".format(nick=escape(nick)))
if user:
search.append("user LIKE '{user}'".format(user=escape(user)))
if host:
search.append("host LIKE '{host}'".format(host=escape(host)))
if account:
search.append("account LIKE '{account}'".format(account=escape(account)))
if gecos:
search.append("gecos LIKE '{gecos}'".format(gecos=escape(gecos)))
sql = sql+" OR ".join(search)
l = cur.execute(sql)
output = ""
for row in cur.fetchall():
output+= "<tr>"
output+= "<td>#{}</td>".format(row[0]) # id
output+= "<td>{}</td>".format(row[1]) # date
output+= "<td>{}<span class=\"userhost\">!{}@{}</span></td>".format(row[5],row[6],row[7]) # nick!ident@host
output+= "<td>received {}".format(row[2]) # event
# (11, datetime.datetime(2016, 2, 21, 20, 25, 45), 'quiet', None, '##doge', 'doge', '~doge',
# 'antispammeta/suchmeta/botters.doge', None, 'doge', 'doge', 'falco-devel', '~falco',
# 'botters/doge/bot/falco', "nathan's bot", 'falco')
if row[11]:
output+= " from {}<span class=\"userhost\">{}{}</span></td>".format(
row[11], "!"+row[12] if row[12] else "", "@"+row[13] if row[13] else "") # who it was from
elif not row[11]:
output+= "</td>"
output+= "<td>{}</td>".format(row[4] if row[4] else "") # channel
output+= "<td>{}</td>".format(row[3] if row[3] else "") # reason
output+= "</tr>"
return output
def addrss():
if session.has_key('username'):
username = session['username']
else:
return 'no login'
db = MySQLDatabase(app.config['DATABASE'], host = app.config['DATABASEHOST'], user = app.config['USERNAME'], passwd = app.config['PASSWORD'])
cur = db.get_cursor()
cur.execute('select count(id) from rsslist')
count = cur.fetchall()
count = int(count[0][0])
cmd = 'insert into rsslist (id, name, xmlurl, htmlurl, user) values(' + str(count) + ',' + '"' + request.form['name'] + '"' + ',' + '"'+request.form['rssxml'] +'"'+ ',' + '"'+request.form['rsshtml'] +'"'+ ',' + '"'+username +'"'+ ')'
cur.execute(cmd)
#cur.commit()
db.commit()
setcache(username)
return 'add finish'
