def get_channel_id(self, player_id): channel_id = 0 conn = getConn() try: query_sql = "select channel_id from player_all where player_id=%d" % ( player_id) print(query_sql) cursor = conn.cursor() cursor.execute(query_sql) pay_user_record = cursor.fetchone() if pay_user_record != None: channel_id = int(pay_user_record[0]) except Exception, e: print('get player_channel_id has error', e)
def get_player_name(server_id, player_id): player_id = int(player_id) server_id = player_id >> 20 try: conn = getConn(server_id) sql = 'select player_name FROM player_%d where player_id=%d' % ( server_id, player_id) cur = conn.cursor() cur.execute(sql) result = cur.fetchone() if result: return result[0] except: traceback.print_exc() return ''
def getVipLevel(server_id, player_id): conn = getConn(server_id) sql = """select max(f2+0) from log_player_vip where log_user=%s""" % ( player_id) try: cursor = conn.cursor() cursor.execute(sql) data = cursor.fetchone() print "vip level:", data[0] conn.close() if data: return int(data[0]) if data[0] else 0 except BaseException as e: print 'get vip level error:', e return 0
def getOpen_id(server_id, player_id): conn = getConn(server_id) sql = """select p.link_key from player_%s p where player_id=%s""" % ( server_id, player_id) try: cursor = conn.cursor() cursor.execute(sql) open_id = cursor.fetchone() print "link_key :", open_id[0] conn.close() if open_id: return open_id[0] if open_id[0] else "" except Exception as e: print 'get open_id error:', e return ""
def get_mobile_key(server_id, player_id): conn = getConn(server_id) try: sql = """select p.mobile_key,p.other from player_%s p where player_id=%s""" % ( server_id, player_id) cursor = conn.cursor() cursor.execute(sql) player_info = cursor.fetchone() if player_info and player_info[0]: print 'mobile_key:', player_info[0] if player_info[1]: print 'channel_sub_key:', player_info[1] conn.close() return player_info[0], player_info[1] if player_info[1] else "" except BaseException as e: print 'get_mobile_key Error:%s' % e return "", "" return "", ""
def getPlayer(server_id, user_type, open_id): conn = getConn(server_id) pay_user = 0 channel_id = 0 try: query_sql = "select player_id,channel_id from player_%d where user_type=%d and link_key='%s'" % ( server_id, user_type, open_id) cursor = conn.cursor() cursor.execute(query_sql) pay_user_record = cursor.fetchone() if pay_user_record != None: pay_user = int(pay_user_record[0]) channel_id = int(pay_user_record[1]) else: print 'get player not find...' except Exception, e: print('get player has error', e)