def loadEqument(self):
tableName = "player_equip"
fields = "pos,equipmentid,equipment_quality,equipment_level,id,game_level,upgrade_cost," \
"buftype1,bufvalue1,buftype2,bufvalue2,buftype3,bufvalue3,buftype4,bufvalue4,buftype5,bufvalue5," \
"bufbasetype1,bufbasevalue1,bufbasetype2,bufbasevalue2,bufbasetype3,bufbasevalue3,bufbasetype4,bufbasevalue4,bufbasetype5,bufbasevalue5"
conditon = "player_id = %s" % self.player_id
data = db_Manager.selectDataFromTable(tableName,fields,conditon)
posList = []
for pos in range(12):
# for pos in range(6):
posList.append(pos)
posList
# posList.append(10)
for equipmentData in data:
posList.remove(equipmentData[0])
if equipmentData[1] == -1:
continue
equipment = EquipMent(data = equipmentData)
equipPos = int(equipmentData[0])
self.equipments[equipPos] = equipment
for pos in posList:
fields = []
fields.append('player_id')
fields.append('pos')
values = []
values.append(self.player_id)
values.append(pos)
db_Manager.insertIntoTable(tableName,fields,values)
def loadSceneInfo(self):
tableName = "player_scene"
fields = "scene_id,big_luck_num,small_luck_num"
conditon = "player_id = %s" % self.player_id
data = db_Manager.selectDataFromTable(tableName,fields,conditon)
sceneids = []
for aData in data:
sceneInfo = PlayerSceneInfo(aData)
sceneID = sceneInfo.sceneid
sceneids.append(sceneID)
self.scenesInfo[sceneID] = sceneInfo
for index in range(ConstValue.scenesCount):
if index not in sceneids:
sceneInfo = sceneLootEquipTable.getSceneConstInfo(index)
aData = []
aData.append(index)
aData.append(sceneInfo.big_luck_num)
aData.append(sceneInfo.small_luck_num)
sceneInfoc = PlayerSceneInfo(aData)
sceneID = sceneInfoc.sceneid
self.scenesInfo[sceneID] = sceneInfoc
fields = []
fields.append("player_id")
fields.append("scene_id")
fields.append("big_luck_num")
fields.append("small_luck_num")
values = []
values.append(self.player_id)
values.append(index)
values.append(sceneInfo.big_luck_num)
values.append(sceneInfo.small_luck_num)
db_Manager.insertIntoTable(tableName,fields,values)
def insertPlayerInOrder(playerid, ranknum):
tableName = "player_ranking"
fields = []
fields.append('rank_num')
fields.append('playerid')
value = []
value.append(ranknum)
value.append(playerid)
db_Manager.insertIntoTable(tableName, fields, value)
def addRank(self, playerid):
self.rank_max_num += 1
self.rank[self.rank_max_num] = playerid
tableName = "player_ranking"
fields = []
values = []
fields.append('rank_num')
fields.append('playerid')
values.append(self.rank_max_num)
values.append(playerid)
db_Manager.insertIntoTable(tableName,fields,values)
self.updateRankMaxNum()
def initNewPlayerPartner(self,player_id):
tableName = "player_partner"
fields = []
fields.append('player_id')
fields.append('partner_id')
fields.append('level')
for partnerid in range(30):
values = []
values.append(player_id)
values.append(partnerid)
values.append(0)
db_Manager.insertIntoTable(tableName,fields,values,None)
def initNewPlayerSkill(self,player_id):
tableName = "player_skill"
for skillid in range(6):
fields = []
fields.append('player_id')
fields.append('skill_id')
fields.append('level')
values = []
values.append(player_id)
values.append(skillid)
values.append(0)
db_Manager.insertIntoTable(tableName,fields,values,None)
def saveResult(self,attackerid,targetid,result,attackerNum,targetNum,lowRank):
tableNmae = "player_fight_result"
fields = []
fields.append('attacker_id')
fields.append('target_id')
fields.append('result')
fields.append('attacker_num')
fields.append('target_num')
fields.append('fight_low')
values = []
values.append(attackerid)
values.append(targetid)
values.append(result)
values.append(attackerNum)
values.append(targetNum)
values.append(lowRank)
db_Manager.insertIntoTable(tableNmae,fields,values)
def createAccount(self,udid,name):
tableName = 'player_base_info'
fields = []
values = []
fields.append('playerid')
fields.append('udid')
fields.append('name')
fields.append('last_cmd_time')
self.player_max_id += 1
playerid = self.server_id + self.player_max_id
values.append(playerid)
values.append(udid)
values.append(name)
timeNowStr = GameTools.datetime2string(datetime.datetime.now())
values.append(timeNowStr)
db_Manager.insertIntoTable(tableName,fields,values)
self.updatePlayerMaxID(self.player_max_id)
def insertPvpBuffs(self):
buffs = self.pvpBuffs
saveStr = ''
for index in range(len(buffs)):
buff = buffs[index]
if index == 0:
saveStr = "%s" % buff
else:
saveStr = "%s,%s"%(saveStr,buff)
tableName = 'player_pvp_buffs'
fields = []
fields.append('buffstr')
fields.append('playerid')
values = []
values.append(saveStr)
values.append(self.player_id)
db_Manager.insertIntoTable(tableName,fields,values)
def loadSkills(self):
tableName = "player_skill"
fields = "skill_id,level,last_use_time"
conditon = "player_id = %s" % self.player_id
data = db_Manager.selectDataFromTable(tableName,fields,conditon)
skillids = []
for skillData in data:
heroSkill = HeroSkillData(skillData)
if heroSkill.skillID == 0 and heroSkill.skillLevel < 1:
heroSkill.skillLevel = 1
skillids.append(heroSkill.skillID)
self.skills.append(heroSkill)
for skillidInTable in range(8):
if not skillidInTable in skillids:
fields = []
fields.append('player_id')
fields.append('skill_id')
fields.append('level')
fields.append('last_use_time')
values = []
values.append(self.player_id)
values.append(skillidInTable)
if skillidInTable == 0:
values.append(1)
else:
values.append(0)
t_now = GameTools.getDatetimeNow()
t_ok = t_now- datetime.timedelta(days = 1)
t_now_string = GameTools.datetime2string(t_ok)
values.append(t_now_string)
db_Manager.insertIntoTable(tableName,fields,values)
skillData = []
skillData.append(skillidInTable)
if skillidInTable == 0:
skillData.append(1)
else:
skillData.append(0)
skillData.append(t_now_string)
heroSkill = HeroSkillData(skillData)
self.skills.append(heroSkill)
def loadPartners(self):
tableName = "player_partner"
fields = "partner_id,level,hadBeenUnlocked,hp,sleep,order_num"
conditon = "player_id = %s" % self.player_id
data = db_Manager.selectDataFromTable(tableName,fields,conditon)
partners = []
for partnerData in data:
partner = Partner(partnerData)
self.partners.append(partner)
partners.append(partner.partner_id)
partnersCount = heroTable.getPartnersCount()
for index in range(partnersCount):
partnerxx = index + 1
if not partnerxx in partners:
fields = []
fields.append('player_id')
fields.append('partner_id')
fields.append('level')
fields.append('hp')
fields.append('sleep')
values = []
values.append(self.player_id)
values.append(partnerxx)
values.append(0) #level
heroInfo = heroTable.GetHeroInfoByid(partnerxx)
max_hp = heroInfo.max_hp
values.append(max_hp)#hp
values.append(0)#sleep
db_Manager.insertIntoTable(tableName,fields,values)
partnerData = []
partnerData.append(partnerxx)
partnerData.append(0)
partnerData.append(0)
partnerData.append(max_hp)
partnerData.append(0)
partnerData.append(0)
partnerData.append(1)
partner = Partner(partnerData)
self.partners.append(partner)
def loadSelectPartners(self):
tableName = "player_selected_partner"
fields = "`0`,`1`,`2`,`3`,`4`,`5`,`6`,`7`,`8`,`9`"
conditon = "player_id = %s" % self.player_id
data = db_Manager.selectDataFromTable(tableName,fields,conditon)
for seletedData in data:
for id in seletedData:
self.selected_partners.append(id)
if len(data) == 0:
fields = []
fields.append('player_id')
values = []
values.append(self.player_id)
for index in range(10):
fields.append("%s" %index)
values.append(-1)
self.selected_partners.append(-1)
db_Manager.insertIntoTable(tableName, fields,values ,None)
def insertNonrankID():
global max_rankNum
cmd = "SELECT\
playerid\
FROM\
player_base_info \
WHERE player_base_info.playerid not in (SELECT player_ranking.playerid from player_ranking)\
"
data = db_Manager.excuteQuery(cmd)
for oneData in data:
player_id = oneData[0]
rankTable = "player_ranking"
fields = []
values = []
fields.append('playerid')
fields.append('rank_num')
values.append(player_id)
max_rankNum += 1
values.append(max_rankNum)
db_Manager.insertIntoTable(rankTable, fields, values)
