View GitHub Repository smallworld

Schedule Inspection
Subscribe

Code Duplication    Length = 4-13 lines in 2 locations

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 {