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));

letter.php 2 locations

@@ 77-83 (lines=7) @@
74
        $xoopsModule      = XoopsModule::getByDirname('lexikon');
75
        $eachentry['dir'] = $xoopsModule->dirname();
76
77
        if ($xoopsModuleConfig['multicats'] == 1) {
78
            $eachentry['catid'] = (int)$categoryID;
79
            $resultF            = $xoopsDB->query('SELECT name FROM ' . $xoopsDB->prefix('lxcategories') . " WHERE categoryID = $categoryID ORDER BY name ASC");
80
            while (list($name) = $xoopsDB->fetchRow($resultF)) {
81
                $eachentry['catname'] = $myts->htmlSpecialChars($name);
82
            }
83
        }
84
85
        $eachentry['id']   = (int)$entryID;
86
        $eachentry['term'] = ucfirst($myts->htmlSpecialChars($term));
@@ 162-168 (lines=7) @@
159
        $xoopsModule      = XoopsModule::getByDirname('lexikon');
160
        $eachentry['dir'] = $xoopsModule->dirname();
161
162
        if ($xoopsModuleConfig['multicats'] == 1) {
163
            $eachentry['catid'] = (int)$categoryID;
164
            $resultF            = $xoopsDB->query('SELECT name FROM ' . $xoopsDB->prefix('lxcategories') . " WHERE categoryID = $categoryID ORDER BY name ASC");
165
            while (list($name) = $xoopsDB->fetchRow($resultF)) {
166
                $eachentry['catname'] = $myts->htmlSpecialChars($name);
167
            }
168
        }
169
        $eachentry['id']   = (int)$entryID;
170
        $eachentry['term'] = ucfirst($myts->htmlSpecialChars($term));
171
        //$eachentry['init'] = $init;

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