chamilo / chamilo-lms

    public static function getStudentBoss($userId)

    {

        $userId = intval($userId);

        if ($userId > 0) {

            $userRelTable = Database::get_main_table(TABLE_MAIN_USER_REL_USER);

            $row = Database::select(

                'DISTINCT friend_user_id AS boss_id',

                $userRelTable,

                array(

                    'where' => array(

                        'user_id = ? AND relation_type = ? LIMIT 1' => array(

                            $userId,

                            USER_RELATION_TYPE_BOSS,

                        )

                    )

                )

            );

            if (!empty($row)) {

                return $row[0]['boss_id'];

            }

        }

        return false;

    }

    {

        $studentUserId = intval($studentUserId);

        $sessionId = intval($sessionId);

        if (!empty($sessionId) && !empty($studentUserId)) {

            $row = Database::select(

                'last_message_id',

                Database::get_main_table(TABLE_ADVANCED_SUBSCRIPTION_QUEUE),

                array(

                    'where' => array(

                        'user_id = ? AND session_id = ?' => array($studentUserId, $sessionId),

                    )

                )

            );

            if (count($row) > 0) {

                return $row[0]['last_message_id'];

            }

        }

        return false;

    }