Advertisement
Guest User

Untitled

a guest
Apr 20th, 2018
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. $this->DB->getAssoc("SELECT
  2. p.code AS code,
  3. p.url AS url,
  4. p.name AS name,
  5. p.intern AS intern
  6. FROM :t1 AS ni JOIN :t2 AS p ON ni.code = p.code
  7. WHERE ni.nc = :snc AND ni.active = :snia AND p.active = :spa ORDER BY ni.sort ",
  8. array(
  9. ':t1' => Config::DB_PREFIX . 'acpnavitem',
  10. ':t2' => Config::DB_PREFIX . 'acppages',
  11. ':snc' => 'mainNavSidebar',
  12. ':snia' => 1,
  13. ':spa' => 1
  14. ));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement