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)