def pb_reply (nick, data, oc): if oc: vh.pm (pb_nmdc (data), nick, vh.opchatname, vh.botname) else: vh.usermc (pb_nmdc (data), nick)
def OnOperatorCommand(nick,data):
if data=="+schedule":
schedule=read()
vh.usermc("\nSchedule sent via pm.")
vh.pm(schedule,nick)
return 0
def OnOperatorCommand (nick, data):
#vh.pm(data,nick)
#print data
i= data.find(' ')
#print type(data)
#print data[1:i]
if data[1:i] == "notice":
stri=data[i+1:]
cmd=stri.split(' ')[0]
if cmd == "add":
i=stri.find(' ')
val=stri[i+1:]
con = mdb.connect('localhost', 'root', 'happyinbit', 'verlihub')
with con:
cur=con.cursor()
print 'inserting val'
cur.execute("insert into notice values(0,\'"+val+"\',123456)")
content=''
with open(motd_intro_path, 'r') as content_file:
content = content_file.read()
content_file=open(motd_path,'w')
content_file.write(content+'\n')
content_file.close()
cur.execute("select msg from notice")
rows=cur.fetchall()
motd_file=open(motd_path,'a')
for row in rows:
#print "writing"
motd_file.write("##########\n")
motd_file.write(row[0]+'\n')
motd_file.close()
return 1
if cmd== 'list':
con = mdb.connect('localhost', 'root', 'happyinbit', 'verlihub')
with con:
cur=con.cursor()
cur.execute("select id, utcvalid, msg from notice")
rows=cur.fetchall()
sendtxt='\nid\tutc valid\tmsg\n#############################################################\n\n'
for row in rows:
sendtxt=sendtxt+str(row[0])+'\t'+str(row[1])+'\t'+str(row[2])+'\n'
print sendtxt
vh.pm(sendtxt, nick)
return 1
if cmd =='del':
i=stri.find(' ')
val=stri[i+1:]
con = mdb.connect('localhost', 'root', 'happyinbit', 'verlihub')
with con:
cur=con.cursor()
cur.execute("delete from notice where id ="+val)
content=''
with open(motd_intro_path, 'r') as content_file:
content = content_file.read()
content_file=open(motd_path,'w')
content_file.write(content+'\n')
content_file.close()
cur.execute("select msg from notice")
rows=cur.fetchall()
motd_file=open(motd_path,'a')
for row in rows:
#print "writing"
motd_file.write("##########\n")
motd_file.write(row[0]+'\n')
motd_file.close()
return 1
def OnOperatorCommand(nick, data):
if data == "+schedule":
schedule = read()
vh.usermc("\nSchedule sent via pm.")
vh.pm(schedule, nick)
return 0
