def updateItemNumber(self, itemid, itemnumber): try: if itemid == '': VirusManager.VirusManager().addError('30002') else: if itemnumber == '': VirusManager.VirusManager().addError('30003') else: cur = dba.dba().excutecur = dba.dba().excute( 'update item set itemNumber="' + str(itemnumber) + '"where itemID=' + "'" + itemid + "'") except Exception as e: VirusManager.VirusManager().addError('33333') VirusManager.VirusManager().addError(e)
def getmaxID(self): try: cur=dba.dba().excute('select Max(id) as id FROM combatmatch') for row in cur.fetchall(): return row[0] except Exception as e: VirusManager.VirusManager().addError(e)
def getPreskill(self, a, b, c, heroid, userid): try: if a == '': VirusManager.VirusManager().addError('') else: if b == '': VirusManager.VirusManager().addError('') else: if c == '': VirusManager.VirusManager().addError('') else: if heroid == '': VirusManager.VirusManager().addError('') else: if userid == '': VirusManager.VirusManager().addError('') else: talent = DBI.DBI().hero.getTalent( heroid, userid) tal = talent.split('|') num1 = int(a) + int(tal[0]) num2 = int(b) + int(tal[1]) num3 = int(c) + int(tal[2]) rows = '' cur = dba.dba().excute( 'select skillID from skillconfig where preSkill1<=' + "'" + str(num1) + "'" 'and preSkill2<=' + "'" + str(num2) + "'" 'and preSkill3<=' + "'" + str(num3) + "'") for row in cur.fetchall(): rows = rows + str(row[0]) + ',' return rows except Exception as e: VirusManager.VirusManager().addError('66666') VirusManager.VirusManager().addError(e)
def getMaxVersion(self): try: cur = dba.dba().excute('select Max(id) as id FROM filetable') for row in cur.fetchall(): return row[0] except Exception as e: VirusManager.VirusManager().addError('101111') VirusManager.VirusManager().addError(e)
def showHero(self): try: cur = dba.dba().excute('select * from hero') for row in cur.fetchall(): return str(row) except Exception as e: VirusManager.VirusManager().addError('22222') VirusManager.VirusManager().addError(e)
def deleteMatcher(self,randomID): try: if randomID=='': VirusManager.VirusManager().addError('80002') else: cur=dba.dba().excute('delete FROM combatmatch WHERE userRandom='+"'"+randomID+"'") except Exception as e: VirusManager.VirusManager().addError('88888') VirusManager.VirusManager().addError(e)
def deleteUserMap(self,random): try: if random=='': VirusManager.VirusManager().addError('70001') else: cur=dba.dba().excute('delete from usermap where random='+"'"+random+"'") except Exception as e: VirusManager.VirusManager().addError('77777') VirusManager.VirusManager().addError(e)
def deleteHero(self, heroid): try: if heroid == '': VirusManager.VirusManager().addError('50001') else: cur = dba.dba().excute('delete FROM heroconfig WHERE heroID=' + "'" + heroid + "'") except Exception as e: VirusManager.VirusManager().addError('55555') VirusManager.VirusManager().addError(e)
def deleteHero(self, id): try: if id == '': VirusManager.VirusManager().addError('20002') else: cur = dba.dba().excute('delete FROM hero WHERE id=' + "'" + id + "'") except Exception as e: #print('s8') VirusManager.VirusManager().addError('22222') VirusManager.VirusManager().addError(e)
def deleteItem(self, id): try: if id == '': VirusManager.VirusManager().addError('30001') else: #print(userid) cur = dba.dba().excute('delete from item where id=' + "'" + id + "'") except Exception as e: VirusManager.VirusManager().addError('33333') VirusManager.VirusManager().addError(e)
def getUserID(self,random): try: if random=='': VirusManager.VirusManager().addError('70001') else: cur=dba.dba().excute('select userID from usermap where random= '+"'"+random+"'") for row in cur.fetchall(): return row[0] except Exception as e: VirusManager.VirusManager().addError('77777') VirusManager.VirusManager().addError(e)
def getUserID(self,userrandom): try: if userrandom=='': VirusManager.VirusManager().addError('80001') else: cur=dba.dba().excute('select userID from combatmatch WHERE userRandom='+"'"+userrandom+"'") for row in cur.fetchall(): return row[0] except Exception as e: VirusManager.VirusManager().addError('88888') VirusManager.VirusManager().addError(e)
def deleteSkill(self, skillid): try: if skillid == '': VirusManager.VirusManager().addError('60001') else: cur = dba.dba().excute( 'delete from skillconfig where skillID=' + "'" + skillid + "'") except Exception as e: VirusManager.VirusManager().addError('66666') VirusManager.VirusManager().addError(e)
def deleteNews(self, houseid): try: if houseid == '': VirusManager.VirusManager().addError('90001') else: cur = dba.dba().excute( 'delete FROM combatnews WHERE houseID=' + "'" + houseid + "'") except Exception as e: VirusManager.VirusManager().addError('99999') VirusManager.VirusManager().addError(e)
def getMatcher(self,id): try: if id=='': VirusManager.VirusManager().addError('80001') else: cur=dba.dba().excute('select * from combatmatch where id='+"'"+id+"'") for row in cur.fetchall(): return row[0]+','+row[1]+','+row[2]+','+row[3] except Exception as e: VirusManager.VirusManager().addError('88888') VirusManager.VirusManager().addError(e)
def addHouse(self, houseid): try: if houseid == '': VirusManager.VirusManager().addError('90001') else: cur = dba.dba().excute( "insert into combatnews(houseid,news) VALUE ('" + str(houseid) + "','')") except Exception as e: VirusManager.VirusManager().addError('99999') VirusManager.VirusManager().addError(e)
def getItemID(self, id): try: if id == '': VirusManager.VirusManager().addError('30001') else: cur = dba.dba().excute('select itemID from item where id=' + "'" + id + "'") for row in cur.fetchall(): return row[0] except Exception as e: VirusManager.VirusManager().addError('33333') VirusManager.VirusManager().addError(e)
def getHerolevel(self, heroID, userID): try: if heroID == '': VirusManager.VirusManager().addError('20002') else: if userID == '': VirusManager.VirusManager.addError('20006') else: cur = dba.dba().excute( 'select userID from hero where heroID=' + "'" + heroID + "'") for row in cur.fetchall(): if str(row[0]) == userID: curs = dba.dba().excute( 'select heroLevel from hero where userID=' + "'" + str(row[0]) + "'") for row in curs.fetchall(): return row[0] except Exception as e: VirusManager.VirusManager().addError('22222') VirusManager.VirusManager().addError(e)
def getFile(self, id): try: if id == '': VirusManager.VirusManager().addError('100000') else: cur = dba.dba().excute('select * from filetable where id=' + "'" + str(id) + "'") for row in cur.fetchall(): return row[1] + '|' + row[2] + '|' + row[3] except Exception as e: VirusManager.VirusManager().addError('101111') VirusManager.VirusManager().addError(e)
def getUserHero(self, heroid): try: if heroid == '': VirusManager.VirusManager().addError('50001') else: cur = dba.dba().excute( 'select * from heroconfig where heroID=' + "'" + heroid + "'") for row in cur.fetchall(self): return row[0] + ',' + row[1] + ',' + row[2] except Exception as e: VirusManager.VirusManager().addError(e)
def addUserMap(self,random,userid): try: if random=='': VirusManager.VirusManager().addError('70001') else: if userid=='': VirusManager.VirusManager().addError('70002') else: cur=dba.dba().excute("insert into usermap(random,userID) VALUE ('"+str(random)+"','"+str(userid)+"')") except Exception as e: VirusManager.VirusManager().addError('77777') VirusManager.VirusManager().addError(e)
def getSkill(self, heroid, userid): try: if heroid == '': VirusManager.VirusManager().addError('20002') #print('s2') else: if userid == '': VirusManager.VirusManager().addError('20006') else: cur = dba.dba().excute( 'select userID from hero where heroID=' + "'" + str(heroid) + "'") for row in cur.fetchall(): if str(row[0]) == str(userid): curs = dba.dba().excute( 'select * from hero where userID=' + "'" + str(row[0]) + "'") for row in curs.fetchall(): return row[5] + ',' + row[6] + ',' + row[ 7] + ',' + row[8] + ',' + row[9] except Exception as e: VirusManager.VirusManager().addError('22222') VirusManager.VirusManager().addError(e)
def getSkill(self, skillid): try: if skillid == '': VirusManager.VirusManager().addError('60001') else: cur = dba.dba().excute( 'select * from skillconfig where skillID=' + "'" + skillid + "'") for row in cur.fetchall(): return row[1] except Exception as e: VirusManager.VirusManager().addError('66666') VirusManager.VirusManager().addError(e)
def getUserHero(self, userid): try: if userid == '': VirusManager.VirusManager().addError('20006') else: cur = dba.dba().excute( 'select heroID from hero where userID=' + "'" + userid + "'") for row in cur.fetchall(): return row[0] except Exception as e: VirusManager.VirusManager().addError('22222') VirusManager.VirusManager().addError(e)
def getNews(self, houseid): try: if houseid == '': VirusManager.VirusManager().addError('90001') else: cur = dba.dba().excute( 'select * from combatnews where houseID=' + "'" + houseid + "'") for row in cur.fetchall(): return str(row[1]) except Exception as e: VirusManager.VirusManager().addError('99999') VirusManager.VirusManager().addError(e)
def getMatchRandom(self,num): try: if num=='': VirusManager.VirusManager().addError('') else: cur=dba.dba().excute('select userRandom from combatmatch where playerNumber='+"'"+num+"'") randoms='' i=0 for row in cur.fetchall(): randoms=randoms+row[0]+',' i=i+1 return randoms+'.'+i except Exception as e: VirusManager.VirusManager().addError('88888') VirusManager.VirusManager().addError(e)
def updateTalent(self, heroid, userid, talent): try: if userid == '': VirusManager.VirusManager().addError('20006') else: if heroid == '': VirusManager.VirusManager().addError('') else: if talent == '': VirusManager.VirusManager().addError('20005') else: cur = dba.dba().excute( 'select userID from hero where heroID=' + "'" + heroid + "'") for row in cur.fetchall(): if str(row[0]) == userid: curs = dba.dba().excute( 'update hero set talent=+"' + talent + '"where userID=' + "'" + userid + "'") print('执行成功') except Exception as e: VirusManager.VirusManager().addError('22222') VirusManager.VirusManager().addError(e) print(e)
def updateHero(self, heroid, heroatt): try: if heroid == '': VirusManager.VirusManager().addError('50001') else: if heroatt == '': VirusManager.VirusManager().addError('50002') else: cur = dba.dba().excute("update heroconfig set heroAtt=" '+str(heroatt)+' " where heroID=" + "'" + heroid + "'") except Exception as e: VirusManager.VirusManager().addError('55555') VirusManager.VirusManager().addError(e)
def addNews(self, houseid, news): houseid = houseid oldNews = self.getNews(houseid) try: if houseid == '': VirusManager.VirusManager().addError('90001') else: if news == '': VirusManager.VirusManager().addError('90002') else: cur = dba.dba().excute('update combatnews set news="' + oldNews + '|' + news + '"where houseID=' + "'" + houseid + "'") except Exception as e: VirusManager.VirusManager().addError('99999') VirusManager.VirusManager().addError(e)
def addMatcher(self,id,userRandom,userid,num): try: if id=='': VirusManager.VirusManager().addError('80001') else: if userRandom=='': VirusManager.VirusManager().addError('80002') else: if userid=='': VirusManager.VirusManager().addError('80003') else: if num=='': VirusManager.VirusManager().addError('') else: print('111') cur=dba.dba().excute("insert into combatmatch(id,userRandom,userID,userNumber) VALUE ('"+str(id)+"','"+str(userRandom)+"','"+str(userid)+"','"+str(num)+"')") print('212') except Exception as e: VirusManager.VirusManager().addError('88888') print(e) VirusManager.VirusManager().addError(e)