Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $this->DB->getAssoc("SELECT
- p.code AS code,
- p.url AS url,
- p.name AS name,
- p.intern AS intern
- FROM :t1 AS ni JOIN :t2 AS p ON ni.code = p.code
- WHERE ni.nc = :snc AND ni.active = :snia AND p.active = :spa ORDER BY ni.sort ",
- array(
- ':t1' => Config::DB_PREFIX . 'acpnavitem',
- ':t2' => Config::DB_PREFIX . 'acppages',
- ':snc' => 'mainNavSidebar',
- ':snia' => 1,
- ':spa' => 1
- ));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement