def dt(conn, msg):
if len(msg.text.split()) > 2:
naam = msg.text.split()[1]
error = ' '.join(msg.text.split()[2:])
rowid = sqlite.set('INSERT INTO irc_dt (name, error) VALUES (?, ?)', (naam, error,))
conn.send('PRIVMSG %s :DT-fout %i added!\r\n' % (msg.channel, rowid))
else:
parts = msg.text.split()
if len(parts) == 1:
rows, count = sqlite.get('SELECT * FROM irc_dt ORDER BY RANDOM()', ())
if count != 0:
conn.send('PRIVMSG %s :DT-fout %i: [%s] %s\r\n' % (msg.channel, rows[0][0], rows[0][1], rows[0][2]))
elif parts[1].isdigit():
rows, count = sqlite.get('SELECT * FROM irc_dt WHERE id=?', (parts[1],))
if count != 0:
conn.send('PRIVMSG %s :DT-fout %i: [%s] %s\r\n' % (msg.channel, rows[0][0], rows[0][1], rows[0][2]))
else:
rows, count = sqlite.get('SELECT * FROM irc_dt WHERE name=? ORDER BY RANDOM()', (parts[1],))
if count != 0:
conn.send('PRIVMSG %s :DT-fout: %s heeft in totaal al %i DT-fouten gemaakt\r\n' % (msg.channel, rows[0][1], count))
else:
conn.send('PRIVMSG %s :DT-fout: %s heeft nog geen DT-fouten gemaakt\r\n' % (msg.channel, parts[1]))
def addquote(conn, msg):
if len(msg.text.split()) > 1:
quote = ' '.join(msg.text.split()[1:])
rowid = sqlite.set('INSERT INTO irc_quote (quote) VALUES (?)', (quote,))
conn.send('PRIVMSG %s :Quote %i added!\r\n' % (msg.channel, rowid))
else:
usage = 'Gebruik: !addquote quote'
conn.send('PRIVMSG %s :%s\r\n' % (msg.user, usage))
def delquote(conn, msg):
if msg.user == settings.irc_OWNER or utils.isadmin(conn, msg):
if len(msg.text.split()) > 1 and msg.text.split()[1].isdigit():
rowid = sqlite.set('DELETE FROM irc_quote WHERE id=?', (msg.text.split()[1],))
conn.send('PRIVMSG %s :Quote %i deleted!\r\n' % (msg.channel, int(msg.text.split()[1])))
else:
usage = 'Gebruik: !delquote id'
conn.send('PRIVMSG %s :%s\r\n' % (msg.user, usage))
else:
usage = 'Je moet een operator zijn om dit commando te kunnen gebruiken.'
conn.send('PRIVMSG %s :%s\r\n' % (msg.user, usage))
def tell(conn, msg):
if len(msg.text.split()) > 2:
message = ' '.join(msg.text.split()[2:])
to = msg.text.split()[1]
frm = msg.user
rowid = sqlite.set("INSERT INTO irc_tell (`user`, `to`, `message`) VALUES (?, ?, ?)", (frm, to, message))
conn.send('PRIVMSG %s :I will tell %s that when %s is here.\r\n' % (msg.channel, to, to))
else:
usage = 'Gebruik: !tell naam tekst'
conn.send('PRIVMSG %s :%s\r\n' % (msg.user, usage))
def unassign(conn, msg):
if msg.user == settings.irc_OWNER or utils.isadmin(conn, msg):
if len(msg.text.split()) > 1:
word = msg.text.split()[1]
rowid = sqlite.set('DELETE FROM irc_assign WHERE word=?', (word,))
conn.send('PRIVMSG %s :%s unassigned.\r\n' % (msg.channel, word))
else:
usage = 'Gebruik: !unassign woord'
conn.send('PRIVMSG %s :%s\r\n' % (msg.user, usage))
else:
usage = 'Je moet een operator zijn om dit commando te kunnen gebruiken.'
conn.send('PRIVMSG %s :%s\r\n' % (msg.user, usage))
def assign(conn, msg):
if msg.user == settings.irc_OWNER or utils.isadmin(conn, msg):
if len(msg.text.split()) > 2:
word = msg.text.split()[1]
defin = ' '.join(msg.text.split()[2:])
rows, count = sqlite.get('SELECT * FROM irc_assign WHERE word=?', (word,))
if count > 0:
conn.send('PRIVMSG %s :%s is already defined: %s\r\n' % (msg.channel, rows[0][1], rows[0][2]))
else:
rowid = sqlite.set('INSERT INTO irc_assign (word, def) VALUES (?, ?)', (word, defin,))
conn.send('PRIVMSG %s :%s added to assign list.\r\n' % (msg.channel, word))
else:
usage = 'Gebruik: !assign woord definitie'
conn.send('PRIVMSG %s :%s\r\n' % (msg.user, usage))
else:
usage = 'Je moet een administrator zijn om dit commando te kunnen uitvoeren.'
conn.send('PRIVMSG %s :%s\r\n' % (msg.user, usage))
def reassign(conn, msg):
if msg.user == settings.irc_OWNER or utils.isadmin(conn, msg):
if len(msg.text.split()) > 2:
word = msg.text.split()[1]
defin = ' '.join(msg.text.split()[2:])
rows, count = sqlite.get('SELECT * FROM irc_assign WHERE word=?', (word,))
if count == 0:
conn.send('PRIVMSG %s :%s is not defined yet. Use !assign word def to assign it.\r\n' % (msg.channel, word))
else:
rowid = sqlite.set('UPDATE irc_assign SET def=? WHERE word=?', (defin, word,))
conn.send('PRIVMSG %s :%s reassigned to: %s\r\n' % (msg.channel, word, defin))
else:
usage = 'Gebruik: !reassign woord definitie'
conn.send('PRIVMSG %s :%s\r\n' % (msg.user, usage))
else:
usage = 'Je moet een administrator zijn om dit commando te kunnen uitvoeren.'
conn.send('PRIVMSG %s :%s\r\n' % (msg.user, usage))
def active(conn, msg):
rows, count = sqlite.get('SELECT * FROM irc_tell WHERE `to`=?', (msg.user,))
for row in rows:
conn.send('PRIVMSG %s :%s: [%s] %s: %s\r\n' % (msg.channel, row[3], row[1], row[2], row[4]))
count = sqlite.set('DELETE FROM irc_tell WHERE `id`=?', (row[0],))
