Code Duplication - florinp/phpbb-messenger - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 19-26 lines in 2 locations

models/friends_model.php 2 locations


        return $requests;
    }

    public function get_friend_request($id)
    {
        $sql = "
			SELECT `request_id`,
					`user_id`,
					`sender_id`,
					`status`,
					`time`
			FROM " . $this->friends_request_table . "
			WHERE `request_id` = " . (int)$id . "
                AND `status` = 0
			ORDER BY `time` DESC
			LIMIT 1
		";
        $result = $this->db->sql_query($sql);
        $row = $this->db->sql_fetchrow($result);

        if ($this->approve_friend_request($id)) {
            return $row;
        } else {
            return false;
        }
    }

    public function get_request_by_sender_id($sender_id)
    {
        $sql = "
            SELECT `request_id`,
					`user_id`,

        }
    }

    public function get_request_by_sender_id($sender_id)
    {
        $sql = "
            SELECT `request_id`,
					`user_id`,
					`sender_id`,
					`status`,
					`time`
			FROM " . $this->friends_request_table . "
			WHERE `sender_id` = " . (int)$sender_id . "
                AND `status` = 0
			ORDER BY `time` DESC
			LIMIT 1 
        ";
        $result = $this->db->sql_query($sql);
        $row = $this->db->sql_fetchrow($result);

        return $row;
    }

    public function insert_friends_request(array $data)
    {

		@@ 90-115 (lines=26) @@
87		return $requests;
88		}
89
90		public function get_friend_request($id)
91		{
92		$sql = "
93		SELECT `request_id`,
94		`user_id`,
95		`sender_id`,
96		`status`,
97		`time`
98		FROM " . $this->friends_request_table . "
99		WHERE `request_id` = " . (int)$id . "
100		AND `status` = 0
101		ORDER BY `time` DESC
102		LIMIT 1
103		";
104		$result = $this->db->sql_query($sql);
105		$row = $this->db->sql_fetchrow($result);
106
107		if ($this->approve_friend_request($id)) {
108		return $row;
109		} else {
110		return false;
111		}
112		}
113
114		public function get_request_by_sender_id($sender_id)
115		{
116		$sql = "
117		SELECT `request_id`,
118		`user_id`,
		@@ 114-132 (lines=19) @@
111		}
112		}
113
114		public function get_request_by_sender_id($sender_id)
115		{
116		$sql = "
117		SELECT `request_id`,
118		`user_id`,
119		`sender_id`,
120		`status`,
121		`time`
122		FROM " . $this->friends_request_table . "
123		WHERE `sender_id` = " . (int)$sender_id . "
124		AND `status` = 0
125		ORDER BY `time` DESC
126		LIMIT 1
127		";
128		$result = $this->db->sql_query($sql);
129		$row = $this->db->sql_fetchrow($result);
130
131		return $row;
132		}
133
134		public function insert_friends_request(array $data)
135		{

florinp / phpbb-messenger

Code Duplication Length = 19-26 lines in 2 locations

models/friends_model.php 2 locations