Code Duplication    Length = 6-7 lines in 4 locations

entry.php 1 location

@@ 103-109 (lines=7) @@
100
    if ($thisterm['offline'] == 1 && !$xoopsUserIsAdmin) {
101
        redirect_header('javascript:history.go(-1)', 3, _MD_LEXIKON_ENTRYISOFF);
102
    }
103
    if ($xoopsModuleConfig['multicats'] == 1) {
104
        $thisterm['categoryID'] = (int)$categoryID;
105
        $catname                = $xoopsDB->query('SELECT name FROM ' . $xoopsDB->prefix('lxcategories') . " WHERE categoryID = $categoryID ");
106
        while (list($name) = $xoopsDB->fetchRow($catname)) {
107
            $thisterm['catname'] = $myts->htmlSpecialChars($name);
108
        }
109
    }
110
111
    $glossaryterm     = $myts->htmlSpecialChars($term);
112
    $thisterm['term'] = ucfirst($myts->htmlSpecialChars($term));

popup.php 1 location

@@ 25-30 (lines=6) @@
22
23
$sqlQuery = $xoopsDB->query('SELECT * FROM ' . $xoopsDB->prefix('lxentries') . " WHERE entryID=$entryID");
24
$sqlfetch = $xoopsDB->fetchArray($sqlQuery);
25
if ($xoopsModuleConfig['multicats'] == 1) {
26
    $cID       = $sqlfetch['categoryID'];
27
    $sqlquery2 = $xoopsDB->query('SELECT name FROM ' . $xoopsDB->prefix('lxcategories') . " WHERE categoryID = $cID");
28
    $sqlfetch2 = $xoopsDB->fetchArray($sqlquery2);
29
    $catname   = $myts->htmlSpecialChars($sqlfetch2['name']);
30
}
31
$term       = $myts->htmlSpecialChars($sqlfetch['term']);
32
$definition = $myts->displayTarea($sqlfetch['definition'], $sqlfetch['html'], $sqlfetch['smiley'], 1, 1, 1);
33

letter.php 2 locations

@@ 86-92 (lines=7) @@
83
        $xoopsModule      = XoopsModule::getByDirname('lexikon');
84
        $eachentry['dir'] = $xoopsModule->dirname();
85
86
        if ($xoopsModuleConfig['multicats'] == 1) {
87
            $eachentry['catid'] = (int)$categoryID;
88
            $resultF            = $xoopsDB->query('SELECT name FROM ' . $xoopsDB->prefix('lxcategories') . " WHERE categoryID = $categoryID ORDER BY name ASC");
89
            while (list($name) = $xoopsDB->fetchRow($resultF)) {
90
                $eachentry['catname'] = $myts->htmlSpecialChars($name);
91
            }
92
        }
93
94
        $eachentry['id']   = (int)$entryID;
95
        $eachentry['term'] = mb_ucfirst($myts->htmlSpecialChars($term));
@@ 171-177 (lines=7) @@
168
        $xoopsModule      = XoopsModule::getByDirname('lexikon');
169
        $eachentry['dir'] = $xoopsModule->dirname();
170
171
        if ($xoopsModuleConfig['multicats'] == 1) {
172
            $eachentry['catid'] = (int)$categoryID;
173
            $resultF            = $xoopsDB->query('SELECT name FROM ' . $xoopsDB->prefix('lxcategories') . " WHERE categoryID = $categoryID ORDER BY name ASC");
174
            while (list($name) = $xoopsDB->fetchRow($resultF)) {
175
                $eachentry['catname'] = $myts->htmlSpecialChars($name);
176
            }
177
        }
178
        $eachentry['id']   = (int)$entryID;
179
        $eachentry['term'] = mb_ucfirst($myts->htmlSpecialChars($term));
180
        //$eachentry['init'] = $init;