Conditions | 3 |
Paths | 4 |
Total Lines | 29 |
Code Lines | 19 |
Lines | 0 |
Ratio | 0 % |
Changes | 0 |
1 | <?php |
||
12 | function b_sitemap_lexikon() |
||
13 | { |
||
14 | $db = \XoopsDatabaseFactory::getDatabaseConnection(); |
||
15 | $myts = \MyTextSanitizer::getInstance(); |
||
|
|||
16 | |||
17 | // Permission |
||
18 | global $xoopsUser; |
||
19 | /** @var \XoopsGroupPermHandler $grouppermHandler */ |
||
20 | $grouppermHandler = xoops_getHandler('groupperm'); |
||
21 | $groups = is_object($xoopsUser) ? $xoopsUser->getGroups() : XOOPS_GROUP_ANONYMOUS; |
||
22 | /** @var \XoopsModuleHandler $moduleHandler */ |
||
23 | $moduleHandler = xoops_getHandler('module'); |
||
24 | $module = $moduleHandler->getByDirname('lexikon'); |
||
25 | $module_id = $module->getVar('mid'); |
||
26 | $allowed_cats = $grouppermHandler->getItemIds('lexikon_view', $groups, $module_id); |
||
27 | $catids = implode(',', $allowed_cats); |
||
28 | $catperms = " WHERE categoryID IN ($catids) "; |
||
29 | $result = $db->query('SELECT categoryID, name FROM ' . $db->prefix('lxcategories') . ' ' . $catperms . ' ORDER BY weight'); |
||
30 | |||
31 | $ret = []; |
||
32 | while (list($id, $name) = $db->fetchRow($result)) { |
||
33 | $ret['parent'][] = [ |
||
34 | 'id' => $id, |
||
35 | 'title' => htmlspecialchars($name, ENT_QUOTES | ENT_HTML5), |
||
36 | 'url' => "category.php?categoryID=$id", |
||
37 | ]; |
||
38 | } |
||
39 | |||
40 | return $ret; |
||
41 | } |
||
42 |