View GitHub Repository smallworld

Schedule Inspection
Subscribe

Code Duplication    Length = 4-13 lines in 3 locations

class/publicWall.php 1 location

@@ 89-101 (lines=13) @@
86 
                     . ') AND M.uid_fk NOT IN ('
87 
                     . $inspected
88 
                     . ") AND M.priv = '0'";
89 
        } elseif ($last > 0) {
90 
            $query = 'SELECT M.msg_id, M.uid_fk, M.priv, M.message, M.created, U.username FROM '
91 
                     . $xoopsDB->prefix('smallworld_messages')
92 
                     . ' M, '
93 
                     . $xoopsDB->prefix('smallworld_user')
94 
                     . ' U  WHERE M.uid_fk=U.userid AND M.uid_fk IN ('
95 
                     . $mods
96 
                     . ') AND M.uid_fk NOT IN ('
97 
                     . $inspected
98 
                     . ") AND M.priv = '0' AND M.msg_id < '"
99 
                     . $last
100 
                     . "'";
101 
        } elseif ('a' === $last) {
102 
            $query = 'SELECT M.msg_id, M.uid_fk, M.priv, M.message, M.created, U.username FROM '
103 
                     . $xoopsDB->prefix('smallworld_messages')
104 
                     . ' M, '

class/PublicWallUpdates.php 1 location

@@ 105-117 (lines=13) @@
102 
                     . ') AND M.uid_fk NOT IN ('
103 
                     . $inspected
104 
                     . ") AND M.priv = '0'";
105 
        } elseif ($last > 0) {
106 
            $query = 'SELECT M.msg_id, M.uid_fk, M.priv, M.message, M.created, U.username FROM '
107 
                     . $GLOBALS['xoopsDB']->prefix('smallworld_messages')
108 
                     . ' M, '
109 
                     . $GLOBALS['xoopsDB']->prefix('smallworld_user')
110 
                     . ' U  WHERE M.uid_fk=U.userid AND M.uid_fk IN ('
111 
                     . $mods
112 
                     . ') AND M.uid_fk NOT IN ('
113 
                     . $inspected
114 
                     . ") AND M.priv = '0' AND M.msg_id < '"
115 
                     . $last
116 
                     . "' ORDER BY created DESC LIMIT {$hm}";
117 
        } elseif ('a' == $last) {
118 
            $query = 'SELECT M.msg_id, M.uid_fk, M.priv, M.message, M.created, U.username FROM '
119 
                     . $GLOBALS['xoopsDB']->prefix('smallworld_messages')
120 
                     . ' M, '

class/WallUpdates.php 1 location

@@ 90-93 (lines=4) @@
87 
        if (0 == $last) {
88 
            $query = 'SELECT M.msg_id, M.uid_fk, M.priv, M.message, M.created, U.username FROM ' . $GLOBALS['xoopsDB']->prefix('smallworld_messages') . ' M, ' . $GLOBALS['xoopsDB']->prefix('smallworld_user') . " U  WHERE M.uid_fk=U.userid AND M.uid_fk='" . $uid . "'"
89 
                   . $fQuery . ' ORDER BY created DESC LIMIT ' . $hm;
90 
        } elseif ($last > 0) {
91 
            $query = 'SELECT M.msg_id, M.uid_fk, M.priv, M.message, M.created, U.username FROM ' . $GLOBALS['xoopsDB']->prefix('smallworld_messages') . ' M, ' . $GLOBALS['xoopsDB']->prefix('smallworld_user') . " U  WHERE M.uid_fk=U.userid AND M.uid_fk='" . $uid . "' AND M.msg_id < '" . $last . "'"
92 
                   . $fQuery . ' ORDER BY created DESC LIMIT ' . $hm;
93 
        } elseif ('a' === $last) {
94 
            $query = 'SELECT M.msg_id, M.uid_fk, M.priv, M.message, M.created, U.username FROM ' . $GLOBALS['xoopsDB']->prefix('smallworld_messages') . ' M, ' . $GLOBALS['xoopsDB']->prefix('smallworld_user') . " U  WHERE M.uid_fk=U.userid AND M.uid_fk='" . $uid . "'"
95 
                   . $fQuery . ' ORDER BY M.msg_id DESC LIMIT ' . $hm;
96 
        } else {