Code Duplication    Length = 6-7 lines in 4 locations

entry.php 1 location

@@ 104-110 (lines=7) @@
101
        redirect_header('javascript:history.go(-1)' , 3, _MD_LEXIKON_ENTRYISOFF ) ;
102
        exit();
103
    }
104
    if ($xoopsModuleConfig['multicats'] == 1) {
105
        $thisterm['categoryID'] = intval($categoryID);
106
        $catname = $xoopsDB -> query ( "SELECT name FROM " . $xoopsDB -> prefix ( "lxcategories" ) . " WHERE categoryID = $categoryID ");
107
        while (list ($name) = $xoopsDB -> fetchRow ( $catname )) {
108
            $thisterm['catname'] = $myts -> htmlSpecialChars( $name );
109
        }
110
    }
111
112
    $glossaryterm = $myts -> htmlSpecialChars( $term );
113
    $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'] = intval($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'] = intval($entryID);
86
        $eachentry['term'] = ucfirst($myts -> htmlSpecialChars( $term ));
@@ 152-158 (lines=7) @@
149
        $xoopsModule = XoopsModule::getByDirname("lexikon");
150
        $eachentry['dir'] = $xoopsModule->dirname();
151
152
        if ($xoopsModuleConfig['multicats'] == 1) {
153
            $eachentry['catid'] = intval($categoryID);
154
            $resultF = $xoopsDB -> query ( "SELECT name FROM " . $xoopsDB -> prefix ( "lxcategories") . " WHERE categoryID = $categoryID ORDER BY name ASC" );
155
            while (list( $name) = $xoopsDB->fetchRow($resultF)) {
156
                $eachentry['catname'] = $myts -> htmlSpecialChars( $name );
157
            }
158
        }
159
            $eachentry['id'] = intval($entryID);
160
        $eachentry['term'] = ucfirst($myts -> htmlSpecialChars( $term ));
161
        //$eachentry['init'] = $init;

popup.php 1 location

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