def getSearchTeamDetail(playerId): searchInfo = getSearchTeamById(playerId) returnVal = {} if searchInfo: searchTypeId = searchInfo["type"] areaId = searchInfo["area"] searchStartTime = searchInfo["last_start_time"] blueBox = searchInfo["blue_box"] number = searchInfo["number"] needTime = SEARCH_TYPE[searchTypeId]["time"] * 3600 time_now = int(time.time()) returnVal["index"] = searchTypeId returnVal["areaID"] = areaId returnVal["startTime"] = searchStartTime returnVal["blue_box"] = blueBox returnVal["number"] = number if searchInfo["friends"]: returnVal["friends"] = db_tool.__auctionStringToDict(searchInfo["friends"]) else: returnVal["friends"] = {} if (searchStartTime + needTime) <= time_now: if blueBox == 0: blueBox = 1 updateInfo = {} updateInfo["blue_box"] = blueBox updateSearchTeamInfo(playerId, updateInfo) returnVal["blue_box"] = blueBox return returnVal
def getGiftEventLog(db,conn,playerId): db.execute("SELECT * FROM gift_event_log WHERE player_id = %s order by create_time desc limit 30",(playerId,)) info = [] try: logs = db.fetchall() except: return info for log in logs: temp = db_tool.__auctionStringToDict(log['info']) temp['time'] = log['create_time'] temp['status'] = log['status'] info.append(temp) return info
def getExploreEventLog(db,conn,leaderId): db.execute("SELECT * FROM explore_event_log WHERE leader_id = %s order by create_time desc limit 30",(leaderId,)) eventInfo = [] try: logs = db.fetchall() except: return eventInfo for log in logs: info = db_tool.__auctionStringToDict(log['info']) temp = {} temp['time'] = log['create_time'] temp['type'] = log['type'] temp['info'] = info temp['status'] = log['status'] eventInfo.append(temp) return eventInfo