function get_roles($pid = null) { if ($pid == null) { $query = "SELECT role.rname, role.rid\n FROM " . PREFIX . "codo_roles AS role"; } else { $pid = (int) $pid; $query = "SELECT role.rname, role.rid, page_role.pid " . "FROM codo_roles AS role " . "LEFT JOIN codo_page_roles AS page_role ON role.rid = page_role.rid " . "AND page_role.pid ={$pid}"; } $res = $this->db->query($query); return $res->fetchAll(); } function add_block() { } } $B = new A_Block(); /* * action * --add block * -- delete block * -- save blockS * * * add * - new * * */ if (isset($_GET['action'])) { if ($_GET['action'] == 'add') { if (isset($_POST['mode']) && CODOF\Access\CSRF::valid($_POST['CSRF_token'])) {
function get_roles($bid = null) { if ($bid == null) { $query = "SELECT role.rname, role.rid\n FROM " . PREFIX . "codo_roles AS role"; } else { $bid = (int) $bid; $query = "SELECT role.rname, role.rid, block_role.bid " . "FROM codo_roles AS role " . "LEFT JOIN codo_block_roles AS block_role ON role.rid = block_role.rid " . "AND block_role.bid ={$bid}"; } $res = $this->db->query($query); return $res->fetchAll(); } function add_block() { } } $B = new A_Block(); /* * action * --add block * -- delete block * -- save blockS * * * add * - new * * */ if (isset($_GET['action'])) { if ($_GET['action'] == 'add') { if (isset($_POST['mode']) && CODOF\Access\CSRF::valid($_POST['CSRF_token'])) {