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`"
