chamilo / chamilo-lms

                $duration = intval($duration);

                if (!empty($duration)) {

                    $sql = "UPDATE $tbl_session SET

                        access_start_date = NULL,

                        access_end_date = NULL,

                        display_start_date = NULL,

                        display_end_date = NULL,

                        coach_access_start_date = NULL,

                        coach_access_end_date = NULL,

                        duration = $duration

                    WHERE id = $session_id";

                    Database::query($sql);

                } else {

                    $sql = "UPDATE $tbl_session

                        SET duration = 0

                        WHERE id = $session_id";

                    Database::query($sql);

                }

                if (!empty($session_id)) {

                    $extraFields['item_id'] = $session_id;

                $count = $row['count'];

            }

            if (empty($count)) {

                // If user is not registered to a session then add it.

                $sql = "INSERT IGNORE INTO $tbl_session_rel_user (session_id, user_id, registered_at)

                        VALUES ($session_id, $enreg_user, '" . api_get_utc_datetime() . "')";

                Database::query($sql);

                $sql = "UPDATE $tbl_session SET nbr_users = nbr_users + 1

                        WHERE id = $session_id ";

                Database::query($sql);

            }

        }

        // count users in this session-course relation