alllogoname[each[0]] = each[1].encode('utf-8')
#select catagory id
cur.execute("""select sort_id,sort_name from live_sort """)
catagorydic = cur.fetchall()
allcatagory = {}
for each in catagorydic:
allcatagory[each[0]] = each[1].encode('utf-8')
print(yate.start_response())
print(yate.render_publish())
print(yate.start_form("edit.py"))
print(yate.select('cid'))
print(yate.select_list_n(allchannel))
print(yate.end_select())
print(yate.select('catagory'))
print(yate.select_list_n(allcatagory))
print(yate.end_select())
"""
print(yate.select('serverip'))
print(yate.select_list_n(allserver))
print(yate.end_select())
print(yate.select('storagepath'))
print(yate.select_list_n(allstor_path))
print(yate.end_select())
print(yate.select('logo'))
res = cur.fetchall()
conn.close()
for eachi in res:
allstor_path[eachi[0]] = eachi[1]
#print(yate.start_response())
print(yate.render_addrpublish(urls="addrpublish.py"))
#print(yate.start_form("addrpublish.py"))
print(yate.select_addr('cid'))
print(yate.select_list_new(allchannel))
print(yate.end_select())
print(yate.select('serverip'))
print(yate.select_list_n(allserver))
print(yate.end_select())
#print(yate.select('storagepath'))
#print(yate.select_list_new(allstor_path))
#print(yate.end_select())
print(' <td align="center" class="td_bg" width="25%" height="15" id="obj"><input type=text name="storagepath" id="txtHint"></td>')
"""
print(yate.select('logo'))
print(yate.select_list_n(alllogoname))
print(yate.end_select())
"""
#print(yate.end_form("add"))