def sendMsg(self):
result=sql.GetData("select * from Message where desnum='"+self.student[1]+"'")
if not len(result)==0:
for item in result:
if item[3]=="2":
self.sendFriends()
stu=sql.GetData("select * from User where UserNumber='"+item[1]+"'")
for one in stu:
self.sendLine("friends|||add|||"+str(item[3])+"|||" +str(one[1])+"|||"+str(one[2])+"|||"+str(one[4])+"|||"+str(one[5]))
sql.Delete("Message", "desnum", self.student[1])
else:
print self.student[1]+"\tNo new message."
def deleteFriend(self,number,hostnum):
id=sql.GetDataByMore("Friend", ["UserNumber","FriendNumber"], [str(hostnum),str(number)])[0][0]
sql.Delete("Friend", "id", str(id))
