chamilo / chamilo-lms

                $group_table = Database::get_course_table(TABLE_GROUP);

                $sql = "SELECT * FROM $group_table WHERE c_id = " . $_course['real_id'] . " AND id = '$group_id'";

                $result = Database::query($sql);

                if (Database::num_rows($result) > 0) { // This group has recorded status related to this course

                    $gpData = Database::fetch_array($result);

                    $_gid = $gpData ['id'];

                    Session::write('_gid', $_gid);

                } else {

                    Session::erase('_gid');

                }

            } elseif (isset($_SESSION['_gid']) or isset($_gid)) { // Keys missing => not anymore in the group - course relation

                Session::erase('_gid');

            }

                WHERE login_user_id = '".$_user['user_id']."'

                ORDER BY login_date DESC LIMIT 1";

        $result_last_login = Database::query($sql);

        if (!$result_last_login) {

            if (Database::num_rows($result_last_login) > 0) {

                $user_last_login_datetime = Database::fetch_array($result_last_login);

                $user_last_login_datetime = $user_last_login_datetime[0];

                Session::write('user_last_login_datetime', $user_last_login_datetime);

            }

        }

    }

} else {

    // Only if login form was not sent because if the form is sent the user was already on the page.

 */

function get_config_param_from_db($param = '')

{

    if (($res = Database::query("SELECT * FROM settings_current WHERE variable = '$param'")) !== false) {

        if (Database::num_rows($res) > 0) {

            $row = Database::fetch_array($res);

            return $row['selected_value'];

        }

    }

    return null;

}