florinp / phpbb-messenger

    }

    public function check_friend($data)

    {

        $sql = "

			SELECT COUNT(*) AS `count`

			FROM " . $this->user_friends_table . "

			WHERE `user_id` = " . (int)$data['user_id'] . "

			 		AND `friend_id` = " . (int)$data['friend_id'] . "

		";

        $this->db->sql_query($sql);

        $count = $this->db->sql_fetchfield('count');

        if ($count > 0) {

            return true;

        } else {

            return false;

        }

    }

    public function check_request($data)

    {

        $sql = "

			SELECT COUNT(*) AS `count`

			FROM " . $this->friends_request_table . "

        }

    }

    public function check_request($data)

    {

        $sql = "

			SELECT COUNT(*) AS `count`

			FROM " . $this->friends_request_table . "

			WHERE `user_id` = " . (int)$data['user_id'] . "

					AND `sender_id` = " . (int)$data['sender_id'] . "

					AND `status` = 0

			LIMIT 1

		";

        $this->db->sql_query($sql);

        $count = $this->db->sql_fetchfield('count');

        if ($count > 0) {

            return true;

        } else {

            return false;

        }

    }

    public function remove_friend($user_id)

    {

        $sql = "DELETE FROM " . $this->user_friends_table . " WHERE `user_id` = " . (int)$user_id . "";

        $this->db->sql_query($sql);