def mail_list(request):
'''邮件列表
'''
server_id = int(request.REQUEST.get('server_id', '') or 0)
query_name = '审核待发送邮件'
return query_view(request, query_name=query_name)
def white_user(request):
channels = Channel.objects.all()
_channels = []
for channel in channels:
_channels.append({
'channel_key': channel.channel_key,
'name': channel.name
})
request.channel_agent = _channels
request.POST.setlist('agent', [_channels])
return query_view(request, query_name='白名单列表')
def banip_list(request):
request.control = control = int(BanIpList.objects.filter(id=1)[0].f1) or 0
request.limit_count = limit_count = int(
BanIpList.objects.filter(id=1)[0].f2) or 0
return query_view(request, query_name='自动封禁IP管理')
def player_list(request):
'''玩家列表
'''
server_id = int(request.REQUEST.get('server_id', '') or 0)
player_id = int(request.REQUEST.get('player_id', '') or 0)
single = request.REQUEST.get("type", "")
query_name = '玩家角色管理'
charge_map = DictDefine.get_dict_for_key("recharge_type")
request.POST.setlist("charge_map", charge_map.values())
print '玩家角色管理', request.POST.getlist('server_id', '')
request.has_shutup = True
if server_id:
shutup_player_list = {}
gmp = GMProtocol(server_id)
result = gmp.player_shutup_list(0)
resutl = json.dumps(result)
for l in result[0]:
try:
timestamp_to_datetime_str(l[2])
except Exception as e:
l[2] = l[1] + max_time
shutup_player_list[l[0]] = [
timestamp_to_datetime_str(l[1]),
timestamp_to_datetime_str(l[2])
]
player_ids = shutup_player_list.keys()
if server_id and player_id and single == 'single':
conn = Server.get_conn(server_id)
cur = conn.cursor(cursorclass=MySQLdb.cursors.DictCursor)
sql = """select '',p.player_id,%s,p.player_name,CONVERT(IFNULL(pp.log_level,'1'),SIGNED) level,p.channel_id,p.other,p.user_type,p.link_key,p.login_num,p.mobile_key,p.last_time,p.last_ip,p.create_time,p.status ,
'' as action
from player_%s p
LEFT JOIN ( select log_user,MAX(log_level) as log_level from log_player_level group by log_user ) pp
ON p.player_id=pp.log_user where player_id = %s""" % (
server_id, server_id, player_id)
cur.execute(sql)
player = cur.fetchone()[0]
conn.close()
if player:
last_time = player["last_time"].strftime('%Y-%m-%d %H:%M:%S')
create_time = player["create_time"].strftime('%Y-%m-%d %H:%M:%S')
for t in Player.TYPE_CHOICES:
if player["user_type"] == t[0]:
user_type = t[1]
for s in Player.STATUS_CHOICES:
if player["status"] == s[0]:
status = s[1]
request.playerData = [[
"", player["player_id"], server_id, player["player_name"],
player["level"], player["channel_id"], player["other"],
user_type, player["link_key"], player["login_num"],
player["mobile_key"], last_time, player["last_ip"],
create_time, status, ""
]]
def list_data_handle(list_data):
new_list_data = []
for p in request.playerData:
if p[1] in player_ids:
new_list_data.append(
list(p) +
shutup_player_list.get(player_id, [0, 0]))
if new_list_data:
return new_list_data
return request.playerData
return query_view(request,
query_name=query_name,
list_data_handle=list_data_handle)
if request.REQUEST.get('is_shutup', ''):
try:
player_ids = player_ids or [1]
request.POST.setlist('player_id', player_ids)
print shutup_player_list
def list_data_handle(list_data):
new_list_data = []
for row in list_data:
player_id = row[1]
new_list_data.append(
list(row) + shutup_player_list.get(player_id, [0, 0]))
return new_list_data
return query_view(request,
query_name=query_name,
list_data_handle=list_data_handle)
except:
err_msg = trace_msg()
return HttpResponse('{"code":-1,"msg":"%s"}' % err_msg)
else:
try:
def list_data_handle(list_data):
new_list_data = []
for row in list_data:
player_id = row[1]
if player_id in player_ids:
new_list_data.append(
list(row) + shutup_player_list.get(player_id))
else:
new_list_data.append(list(row))
return new_list_data
return query_view(request,
query_name=query_name,
list_data_handle=list_data_handle)
except:
err_msg = trace_msg()
return HttpResponse('{"code":-1,"msg":"%s"}' % err_msg)
return query_view(request, query_name)
def activity_list(request, template="game/activity_list.html"):
'''活动列表
'''
return query_view(request, query_name='游戏活动列表')