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)