includes/pageutils.php
changeset 690 aeac05b5b7ca
parent 685 17ebe24cdf85
child 696 bd5069e1f19a
equal deleted inserted replaced
689:13f8383a7538 690:aeac05b5b7ca
  1868                   . "    ON ( (a.target_type = " . ACL_TYPE_USER . " AND a.target_id = u.user_id) OR (u.user_id IS NULL) )\n"
  1868                   . "    ON ( (a.target_type = " . ACL_TYPE_USER . " AND a.target_id = u.user_id) OR (u.user_id IS NULL) )\n"
  1869                   . "  LEFT JOIN " . table_prefix . "groups AS g\n"
  1869                   . "  LEFT JOIN " . table_prefix . "groups AS g\n"
  1870                   . "    ON ( (a.target_type = " . ACL_TYPE_GROUP . " AND a.target_id = g.group_id) OR (g.group_id IS NULL) )\n"
  1870                   . "    ON ( (a.target_type = " . ACL_TYPE_GROUP . " AND a.target_id = g.group_id) OR (g.group_id IS NULL) )\n"
  1871                   . "  LEFT JOIN " . table_prefix . "page_groups as p\n"
  1871                   . "  LEFT JOIN " . table_prefix . "page_groups as p\n"
  1872                   . "    ON ( (a.namespace = '__PageGroup' AND a.page_id = p.pg_id) OR (p.pg_id IS NULL) )\n"
  1872                   . "    ON ( (a.namespace = '__PageGroup' AND a.page_id = p.pg_id) OR (p.pg_id IS NULL) )\n"
       
  1873                   . "  WHERE ( a.target_type = " . ACL_TYPE_USER . " OR a.target_type = " . ACL_TYPE_GROUP . " )\n"
  1873                   . "  GROUP BY a.rule_id\n"
  1874                   . "  GROUP BY a.rule_id\n"
  1874                   . "  ORDER BY a.target_type ASC, a.rule_id ASC;"
  1875                   . "  ORDER BY a.target_type ASC, a.rule_id ASC;"
  1875                 );
  1876                 );
  1876           
  1877           
  1877           if ( !$q )
  1878           if ( !$q )