def send_usr_premission_lst(param): py_db.checkAccessCookie() py_db.checkuser(5,py_db.username) sqlstr = """ SELECT t1.m_id, t1.m_page_title , CASE (SELECT t2.m_type_of_view FROM tbl_module_premission t2 WHERE t2.m_user_link = {0} AND t2.m_module_link= t1.`m_id`) WHEN 1 THEN "true" ELSE "false" END AS sss FROM tbl_modules t1 """.format( py_db.get_userID_from_uname(param) ) rows = py_db.executeAndReturnRows(sqlstr) str = "" for row in rows: str = str+"::"+row[0].__str__()+"pp"+row[1].__str__()+"pp"+row[2].__str__() print 'Content-Type: text/html; charset=utf-8' print '' print str
def updateusrprm(param,uid): py_db.checkAccessCookie() py_db.checkuser(5,py_db.username) __form = cgi.FieldStorage() sel_uid = py_db.get_userID_from_uname(uid) sd=param.split("bbb") py_db.executesql("delete from tbl_module_premission where m_user_link = "+sel_uid) for row in sd: s="3" if (row.split("=~")[1].__str__())== "true":s="1" py_db.executesql(""" insert into tbl_module_premission (`m_module_link`,`m_user_link`,`m_type_of_view`) values ({0},{1},{2}) """.format(row.split("=~")[0].__str__(), sel_uid,s)) print 'Content-Type: text/html; charset=utf-8' print '' print "1"