def set_server_state(): channels = request.form.get("channels") state = int(request.form.get("state")) if state not in [SERVER_STATE_STOP, SERVER_STATE_PRE_PUBLIC, SERVER_STATE_PUBLIC]: return jsonify({}) for channel in channels.split(","): if channel: payload = { "channels": channel, "state": state } channel_id = int(redis_conn.hget(CHANNEL_CONFIG_TABLE + channel, "id")) sql = 'select other_msg from channel where id = %d' % channel_id cfg = SqlOperate().select(sql)[0][0] conf = json.loads(cfg) conf["server_state"] = state sql = "update channel set other_msg = '%s' where id = %d" % (json.dumps(conf), channel_id) SqlOperate().update(sql) redis_conn.hset(CHANNEL_CONFIG_TABLE + channel, "server_state", state) redis_conn.hset(CHANNEL_CONFIG_TABLE + str(channel_id), "server_state", state) return jsonify({})
def add_annouce_game(): title = request.form.get('title') content_image_url = request.form.get('content_image_url') push_times = request.form.get('push_times') priority = request.form.get('priority') date1 = request.form.get('date1') date2 = request.form.get('date2') channel_id = session['select_channel'] # 校验并处理参数参数 if not all([title, content_image_url, push_times, priority, date1, date2]): return jsonify(result=0, msg=u'请填入所有内容!') try: int(push_times) int(priority) except ValueError: return jsonify(result=0, msg=u'每日展示次数与优先级为整数纯数字!') date1 = time_util.formatTimestamp(date1) date2 = time_util.formatTimestamp(date2) if date1 > date2: return jsonify(result=0, msg=u'开始日期不能大于结束日期!') sql = "select ifnull(max(id), 1) + 1 from admin_announcement" notice_id = int(LogQry(channel_id).qry(sql)[0][0]) channel = redis_conn.hget(CHANNEL_CONFIG_TABLE + str(channel_id), "name") payload = { "start_time": date1, "end_time": date2, "channel": channel, "notice_id": notice_id, "push_times": push_times, "priority": priority, "content_img": content_image_url } redis_conn.hset(NOTICE_TABLE + channel, notice_id, payload) create_sql = """ INSERT INTO admin_announcement (id,channel,title,priority,content_image_url, push_times,start_date,end_date) VALUES (%d,%s,'%s',%s,'%s', %s,%s,%s) """ % (notice_id, channel_id, title, priority, content_image_url, push_times, date1, date2) LogQry(channel_id).execute(create_sql) return jsonify(result=1, msg=u'新建公告成功!')
def sdk_bgp_conn(): data = request.args if data.get("clear"): ## 删除链接 return clear_bgp_conn() size = data.get("size") country = data.get("country") val = "%s_%s" % (size, country) for channel, key in data.items(): if len(key.split("_")) == 2: redis_conn.hset(BGP_TABLE + channel, key, val) return jsonify()
def get_channel_data(): rr = httpc_util.post(Config.ADMIN_WEB_SITE + "/api/channel_data", {}) rr = rr.json() for dd in rr["data"]: channel = dd["name"] channel_id = dd["id"] redis_conn.hmset(CHANNEL_CONFIG_TABLE + channel, dd) redis_conn.hmset(CHANNEL_CONFIG_TABLE + str(channel_id), dd) try: redis_conn.hset(WX_CONFIG_TABLE, dd["wx_appid"], dd["wx_token"]) except: pass try: redis_conn.hset(WX_CONFIG_TABLE, dd["h5_wx_appid"], dd["h5_wx_token"]) except: pass return jsonify()
def game_parameter_update(): """游戏参数新建""" # 获取参数 type_id = request.form.get('type') config = request.form.get('config') # 校验参数 try: eval(config) redis_conn.hset(GAME_PARAMTER_TABLE, type_id, config) except ValueError: return jsonify(result='fail', msg=u'内容不合法') # 存进数据库 update_sql = """replace into game_parameter (type, config) values (%s, '%s')""" % ( type_id, config) SqlOperate().update(update_sql) # 返回应答 return jsonify(result='ok', msg=u'新建成功!')
def sdk_reset_click_tj(): if request.method == 'POST': data = request.form else: data = request.args channel = data.get("channel") ios = redis_conn.hget("download_count", "%s_ios" % channel) redis_conn.hset("download_count", "%s_ios" % channel, 0) android = redis_conn.hget("download_count", "%s_android" % channel) redis_conn.hset("download_count", "%s_android" % channel, 0) try: ios = int(ios) except: ios = 0 try: android = int(android) except: android = 0 return jsonify({"ios": ios, "android": android})
def load_game_paramter(): sql = 'SELECT type, config FROM game_parameter' for stype, config in SqlOperate().select(sql): redis_conn.hset(GAME_PARAMTER_TABLE, stype, config)