def create(self): tableName = "table_account_cdkey" query = 'insert into %s (`cdkey`) values(\'%s\')' %(tableName, self.cdkey) try: db_Manager.excuteQuery(query) return True except: return False
def initData(self): self.tableData.clear() cmd ="select fromNum,toNum,step from table_pick_player ORDER BY fromNum DESC" data = db_Manager.excuteQuery(cmd) for oneData in data: item = PickUpInfo(oneData) self.tableData.append(item)
def post(self): bodyData = self.request.body dictData = MessageTools.decode(bodyData) token = dictData.get('token') player = playerDataManager.getPlayerByToken(token) returnData = MessData() if player == None: returnData = MessData(ErrorCode.tokenOutData) elif player.getSkillInfo(7).skillLevel == 0 and player.getSkillInfo(0).skillLevel < static.pvp_level_limit: returnData = MessData(ErrorCode.pvpNOTUnlockNow) else: # Íæ¼Òconnect id¼ì²â connect_id = dictData.get('connect_id', '') # Íæ¼ÒÁ¬½Óid ck_connectid = playerDataManager.check_connect_id(obj=player, post_connect_id=connect_id) if ck_connectid[0] is False: returnData = MessData(ck_connectid[1]) self.write(MessageTools.encode(returnData)) self.finish() return player_id = player.player_id cmd ="SELECT\ result.id,\ result.attacker_id,\ result.target_id,\ result.result,\ result.attacker_num,\ result.target_num ,\ result.fight_low,\ player1.`name`,\ player2.`name`\ FROM\ player_fight_result as result ,player_base_info as player1,player_base_info as player2\ WHERE (result.attacker_id = %s or result.target_id = %s )and result.attacker_id = player1.playerid and result.target_id = player2.playerid\ ORDER BY result.id\ DESC\ LIMIT 5" %(player_id,player_id) data = db_Manager.excuteQuery(cmd) returnData.data = [] for resultData in data: fightResult = FightResult(resultData) returnData.data.append(fightResult) str = MessageTools.encode(returnData) self.write(str) self.finish()
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)
#coding=utf-8 from managers.database_manager import db_Manager db_Manager.openDB() print ("===================================") sql = "UPDATE `id_info` SET `player_max_id`='0', `rank_max_id`='0'" db_Manager.excuteQuery(sql) print ('id_info clear success') sql = "UPDATE `table_account_cdkey` SET `is_use`='0', `usedtime`=NULL, `use_udid`=''" db_Manager.excuteQuery(sql) print ('table_account_cdkey clear success') sql = "TRUNCATE TABLE `player_equip`" db_Manager.excuteQuery(sql) print ('player_equip clear success') sql = "TRUNCATE TABLE `player_fight_result`" db_Manager.excuteQuery(sql) print ('player_fight_result clear success') sql = "TRUNCATE TABLE `player_messages`" db_Manager.excuteQuery(sql) print ('player_messages clear success') sql = "TRUNCATE TABLE `player_partner`" db_Manager.excuteQuery(sql) print ('player_partner clear success') sql = "TRUNCATE TABLE `player_pvp_buffs`"