def addFriend(self, uid, fid): sql = "insert into friend (uid, fid) values ('%d', '%d') " % (uid, fid) sql2 = "insert into friend (uid, fid) values ('%d', '%d') " % (fid, uid) DbServiceBase.getDB().query(sql) DbServiceBase.getDB().query(sql2) return True
def addGuild(self, guildid, guildname, guildchiefname): now = ffext.datetime_to_str(ffext.datetime_from_time(ffext.getTime())) sql = "insert into guildinfo (guildid, guildname, guildimage, guildnotice, guildlevel, guildexp, guildchiefname, lastdatecontribution, lastdate) \ values ('%d', '%s', '', '', 1, 0, '%s', 0, '%s') " % ( guildid, guildname, guildchiefname, now) DbServiceBase.getDB().query(sql) return True
def delBrother(self, brotherCtrl): sql = "delete from brother where bid=%d" % (brotherCtrl.bid) DbServiceBase.getDB().query(sql) for key, val in brotherCtrl.getBrotherMember().iteritems(): sql = 'update player set brotherid =%d where uid = %d' % (0, val.uid) DbServiceBase.getDB().query(sql) return True
def updateGuildRankWarInvitedOverTime(self, memberUid, overTime, callback=None): sql = "update guildmemberinfo set rankWarInvitedOverTime = %d where uid = %d " % ( overTime, memberUid) ffext.dump("sql", sql) DbServiceBase.getDB().query(sql, callback) return True
def addBrother(self, bid, uid1, uid2, uid3): sql = "insert into brother (bid, uid1, uid2, uid3, extra) values (%d, %d, %d, %d, '') " % ( bid, uid1, uid2, uid3) ffext.dump(sql) DbServiceBase.getDB().query(sql) sql = 'update player set brotherid =%d where uid in (%d,%d,%d)' % ( bid, uid1, uid2, uid3) DbServiceBase.getDB().query(sql) ffext.dump(sql) return True
def loadPlayerDetail(self, idList, cb): sql = 'select uid,name,job,gender,,level from player where uid in (' for k in range(len(idList)): if k == 0: sql += str(k) else: sql += ',' + str(k) sql += ')' DbServiceBase.getDB().query(sql, cb) return True
def contributionGuild(self, uid, guildID, tm, userContribution, userDateContribution, guildExp, lastDateContribution): now = ffext.datetime_to_str(ffext.datetime_from_time(tm)) sql1 = "update guildinfo set guildexp = %d, lastdatecontribution = %d, lastdate = '%s' where guildid = %d limit 1" % ( guildExp, lastDateContribution, now, guildID) sql2 = "update guildmemberinfo set contribute = %d, daycontribute = %d, lastdate = '%s' where uid = %d limit 1" % ( userContribution, userDateContribution, now, uid) print(sql1) print(sql2) DbServiceBase.getDB().query(sql1) DbServiceBase.getDB().query(sql2) return True
def syncGetGuildMemberInfoList(self, callback): sql = "select guildinfo.guildid as guildid, guildmemberinfo.uid as uid, name, memberpost, contribute, guildname, guildimage, guildnotice, guildlevel, guildexp, guildchiefname, \ lastdatecontribution, guildinfo.lastdate as guildinfolastdate from guildmemberinfo, player, guildinfo where player.uid = guildmemberinfo.uid and guildinfo.guildid = guildmemberinfo.guildid" ret = DbServiceBase.getDB().queryResult(sql) callback(ret) return
def syncGetBrotherMemberInfoList(self, callback): sql = "select bid, brother.extra, uid, name, job, gender, level from player, brother where brother.uid1 = player.uid or brother.uid2 = player.uid or brother.uid3 = player.uid order by bid" ret = DbServiceBase.getDB().queryResult(sql) callback(ret) return
def addEnemy(self, uid, eid, typeId): sql = "insert into enemy (uid, eid, typeId) values ('%d', '%d', '%d') " % ( uid, eid, typeId) DbServiceBase.getDB().query(sql) return True
def getGoldInfoList(self, callback): sql = "select uid, name, job, gold from player order by gold desc limit 20" DbServiceBase.getDB().query(sql, callback) return
def getRankInfoList(self, callback, job): sql = "select uid, name, job, level from player where job = %d order by level desc limit 20" % ( job) DbServiceBase.getDB().query(sql, callback) return
def queryGuildApply(self, guildStatus, callback=None): sql = "select guildid from guildinfo where rankWarApplied = %d " % ( guildStatus) ffext.dump("sql", sql) DbServiceBase.getDB().query(sql, callback) return True
def queryRankWarMember(self, memberUid, callback=None): sql = "select rankWarInvitedOverTime from guildmemberinfo where uid = %d " % ( memberUid) ffext.dump("sql", sql) DbServiceBase.getDB().query(sql, callback) return True
def queryGuildRankWarInvitedMember(self, guildId, nowTime, callback=None): sql = "select uid from guildmemberinfo where guildid = %d and rankWarInvitedTime >= %d and rankWarAgreed < 2 " % ( guildId, nowTime) ffext.dump("sql", sql) DbServiceBase.getDB().query(sql, callback) return True
def updateBrotherExtra(self, bid, extra): sql = "update brother set extra = '%s' where bid = %d" % (extra, bid) DbServiceBase.getDB().query(sql) return True
def getGuildContributeInfoList(self, guildid, callback): sql = "select guildid, guildcontributeinfo.uid as uid, name, thiscontribute, contributedate from guildcontributeinfo, player where player.uid = guildcontributeinfo.uid and guildid = %d" % ( guildid) DbServiceBase.getDB().query(sql, callback) return
def updateGuildRankWarApply(self, guildStatus, guildId, callback=None): sql = "update guildinfo set rankWarApplied = %d where guildid = %d " % ( guildStatus, guildId) ffext.dump("sql", sql) DbServiceBase.getDB().query(sql, callback) return True
def delGuild(self, guildid): sql = "delete from guildmemberinfo where guildid = %d" % (guildid) sql2 = "delete from guildinfo where guildid = %d limit 1" % (guildid) DbServiceBase.getDB().query(sql) DbServiceBase.getDB().query(sql2) return True
def syncGetAllGuildInfo(self, callback): sql = "select guildid, guildname, guildimage, guildnotice, guildlevel, guildExp, guildchiefname, lastdatecontribution, lastdate from guildinfo order by guildlevel desc, guildExp desc" ret = DbServiceBase.getDB().queryResult(sql) callback(ret) return
def updateGuild(self, guildid, guildExp, guildlevel): sql1 = "update guildinfo set guildexp = %d, guildlevel = %d where guildid = %d limit 1" % ( guildExp, guildlevel, guildid) DbServiceBase.getDB().query(sql1) return True
def queryRankWarAllFightPower(self, guildId, status, callback=None): sql = "select fightpower from player, guildmemberinfo where guildmemberinfo.guildid = %d and guildmemberinfo.rankWarInvited = %d " \ "and player.uid = guildmemberinfo.uid " %(guildId, status) ffext.dump("sql", sql) DbServiceBase.getDB().query(sql, callback) return True
def getLevelInfoList(self, callback): sql = "select uid, name, job, level from player order by level desc limit 20" DbServiceBase.getDB().query(sql, callback) return
def queryRankWarWinTeam(self, status, callback=None): sql = "select guildId from player where rankWarApplied = 1 and rankWarWin = %d" % ( status) ffext.dump("sql", sql) DbServiceBase.getDB().query(sql, callback) return True
def getRankInfoList(self, callback): sql = "select guildid, name, createrName,empiric from guildinfo" DbServiceBase.getDB().query(sql, callback) return
def queryRankWarTeamMember(self, status, team1, team2, callback=None): sql = "select uid, guildid from guildmemberinfo where rankWarInvited = %d and guildid = %d or guildid = %d " % ( status, team1, team2) ffext.dump("sql", sql) DbServiceBase.getDB().query(sql, callback) return True
def delFriend(self, uid, fid): sql = "delete from friend where uid = %d and fid = %d" % (uid, fid) sql2 = "delete from friend where uid = %d and fid = %d" % (fid, uid) DbServiceBase.getDB().query(sql) DbServiceBase.getDB().query(sql2) return True
def updateRankWarWin(self, status, guildId1, guildId2=0, callback=None): sql = "update guildinfo set rankWarWin = %d where guildid = %d or guildid = %d" % ( status, guildId1, guildId2) ffext.dump("sql", sql) DbServiceBase.getDB().query(sql, callback) return True
def delEnemy(self, uid, eid, typeId): sql = "delete from enemy where uid = %d and eid = %d and typeId = %d" % ( uid, eid, typeId) DbServiceBase.getDB().query(sql) return True
def syncGetAllGuildMember(self, callback): sql = "select guildid, guildmemberinfo.uid as uid, name,memberpost, contribute, daycontribute, lastdate,level, job from guildmemberinfo, player where player.uid = guildmemberinfo.uid and player.delflag = 0" ret = DbServiceBase.getDB().queryResult(sql) #ffext.dump('syncGetAllGuildMember', sql) callback(ret) return