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
