Marown
/
swad-core
mirror of https://github.com/acanas/swad-core.git
1
0
Fork 0
Code Issues Packages Projects Releases Wiki Activity
swad-core/swad_changelog.h

14709 lines
1.2 MiB
Raw Permalink Blame History

This file contains invisible Unicode characters!

This file contains invisible Unicode characters that may be processed differently from what appears below. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to reveal hidden characters.

// swad_changelog.h: changelog
#ifndef _SWAD_CHG
#define _SWAD_CHG
/*
SWAD (Shared Workspace At a Distance),
is a web platform developed at the University of Granada (Spain),
and used to support university teaching.
This file is part of SWAD core.
Copyright (C) 1999-2023 Antonio Cañas Vargas
This program is free software: you can redistribute it and/or modify
it under the terms of the GNU Affero General Public License as
published by the Free Software Foundation, either version 3 of the
License, or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU Affero General Public License for more details.
You should have received a copy of the GNU Affero General Public License
along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
/*
Sabies que pots utilitzar SWAD en català? https://swad.ugr.es/ca
Wussten Sie, dass Sie verwenden können, SWAD auf Deutsch? https://swad.ugr.es/de
Did you know that you can use SWAD in English? https://swad.ugr.es/en
Saviez-vous que vous pouvez utiliser SWAD en français? https://swad.ugr.es/fr
Lo sapevate che è possibile utilizzare SWAD in italiano? https://swad.ugr.es/it
Czy wiesz, ze mozesz uzywac SWAD po polsku? https://swad.ugr.es/pl
Sabia que você pode usar SWAD em portugués? https://swad.ugr.es/pt
*/
/*****************************************************************************/
/****************************** Debug example ********************************/
/*****************************************************************************/
/*
struct timeval tv1,tv2;
long tv_usecs;
gettimeofday (&tv1,NULL);
function ();
gettimeofday (&tv2,NULL);
tv_usecs = (tv2.tv_sec - tv1.tv_sec ) * 1E6 +
(tv2.tv_usec - tv1.tv_usec);
*/
/*
DB_QueryINSERT ("can not debug", // TODO: Remove
"INSERT INTO dbg_debug"
" (DebugTime,Txt)"
" VALUES"
" (NOW(),'ActCod = %ld')",
Act_GetActCod (Gbl.Action.Act));
*/
/*****************************************************************************/
/*********************************** TODO ************************************/
/*****************************************************************************/
// TODO: Is it necessary FileType in table "files"?
// TODO: When notifications are marked as seen, do it in a priori function
// TODO: Use the library http://fukuchi.org/works/qrencode/index.html.en instead Google QR
// TODO: [Ceferino Bustos Valdivia]:
// Enhorabuena por esta nueva aplicación. La he utilizado con los códigos QR y va muy bien.
// Me genera las listas de alumnos y es bastante rápida la lectura del código QR.
// Sería completa esta aplicación, si la asistencia se incluyera, automáticamente, en el apartado de evaluación de cada alumno. De esta forma podríamos ver sus trabajos y asistencias de forma personalizada.
// TODO: OpenSWAD.org: ¿Qué debería tener una buena gestión de grupos? Es para tomar ideas ;)
// José Raúl Canay @raulcanay: por ejemplo, que puedas sacar un listado exportable de en qué grupos está una persona de quienes están en un grupo.
/* Propuestas de Fidel Rodríguez López:
==========================================================
1 @@ TUTORIAS GRUPALES/INDIVIDUALES "VIRTUALES"
==========================================================
# Permite realizar grupos de chat, de uno o varios profesores con sus alumnos.
Útil para la resolución de ejercicios y dudas sencillas.
# Notificación, citas y aviso de tutorias virtuales.
# Permitir el envío de imágenes y fotos a través de la sala de Chat.s
==========================================================
2 @@ MEJORA DEL SISTEMA DE ANOTACIÓN DE ASISTENCIA
==========================================================
# Sistema dinámico que permita la anotación de asistencia de los alumnos a las
clases prácticas y que facilite la administración de los mismos (notificación al
profesor cuando todos los alumnos sean registrados, por ejemplo). Implementación
vía AJAX para ser más agradable.
==========================================================
3 @@ GENERADOR DE CALIFICACIONES EN PDF
==========================================================
# El servidor es capaz de generar un PDF para cualquier tarea (por ejemplo, con
las calificaciones de los alumnos para publicar en el tablón, con las convocatorias
de examen...). Para esto se puede usar alguna libreria libre tipo FPDF.
# Algunos profesores prefieren tener en papel anotadas las calificaciones.
==========================================================
4 @@ TUTORIAL INICIACIÓN
==========================================================
# Es importante indicar tanto al profesor, Administrador y alumno de qué es capaz
SWAD, para poder así explotar todas sus posibilidades. Un tutorial amigable e inicial
a base de Tooltips o imágenes, puede ser bastante útil.
==========================================================
5 @@ MEJORA DE LA INTERFAZ
==========================================================
# Botones, colores e iconos más modernos. Los iconos se pueden suprimir por iconos en
fuentes (como font-awesome, open-source). Los botones en CSS3 le darían un aire más
moderno y renovado (se podría basar en algún framework open-source).
==========================================================
6 @@ INCORPORACIÓN DE UN TABLÓN DE PROGRAMACIÓN DE ASIGNATURA
==========================================================
# Hacer pequeñas modificaciones para ver la zona de Actividades de otra forma. Por ejemplo,
una estructura de árbol (como la zona de Documentos) pero con las tareas programadas para la
semana proporcionaría una visión más global (como una "agenda") de lo que hay que realizar.
# El tablón incorporaría solo los títulos de los ejercicios. Por ejemplo:
==>Semana 16 Febr. -> 22 Marzo
----------Prácticas
----------------Entrega Práctica 2 [Fecha Límite] (Color verde o rojo, si ha pasado la fecha, como actualmente en Actividades)
----------Teoría
----------------Tema 2
----------Otros
----------------Entregar Relación de Ejercicios
==>Semana 23 Febr.-> 1 Marzo
----------Prácticas
----------Teoría
----------------Examen Tema 2
----------Otros
....Etc.....
*/
// TODO: A teacher should may confirm a student ID? In what conditions? (Necessary in order to a student can view his/her marks)
// TODO: Put headers Content-type and Content-disposition when redirecting with Location:
// TODO: When a new assignment/attendance/survey is incorrect, the second time the form is shown, it should be filled with partial data, now is always empty
// TODO: Show message indicating that mail could be in SPAM folder?
// TODO: Show nicknames of users in lists?
// TODO: Form to register and remove system admins
// TODO: FIX BUG: when an admin clicks on "Use this email" in the email of another user the email was confirmed, the email becomes unconfirmed
// TODO: When error ("Ya existía un evento con el título") creating a new event, the data of the event is empty
// TODO: When teacher clicks in attendance of a student (button in her/his record),
// only (the groups he/she should have attend) union (the groups he/she really attended)
// should be shown.
// TODO: When page is refreshed in course works, prevent users to be duplicated
// TODO: Reply to all
// TODO: Hour in exam announcement should start at six a.m.
// TODO: Forum SWAD should be always named "SWAD"?
// TODO: Enable chat for guests?
// TODO: Go to forum post (or at least to forum thread) from social timeline and notifications?
// TODO: Width of column for data in notifications is too short
// TODO: Change size of DegTypName in table deg_types from VARCHAR(32) TO VARCHAR(255)
// TODO: Insert "http://" to WWW when WWW does not start with "*://"
// TODO: To avoid wrong email addresses, when a user fills his/her email address, check if the domain is in the white list of allowed domains. If not, ask for confirmation.
// TODO: Filtering email addresses --> an email address can not finish in "."
// TODO: Change PhotoAttribution in table centres from TEXT to VARCHAR(255) (check maximum length first)
// TODO: In social refreshing via AJAX, an error occurs when session expirates
// TODO: Messages in msg_content_deleted older than a certain time should be deleted to ensure the protection of personal data
// TODO: FIX BUG: A teacher uploads a document in course documents zone, then he/she unregister from course, then he/she search for his/her documents, a document is shown in results but he/she can not view it
// TODO: Add Stack Exchange to webs/networks
// TODO: Optimize slow query searching messages received
// TODO: FIX BUG: Searching messages received gives unordered list
// TODO: In search of users and findUsers banned users should not appear in listing!!!!!
// TODO: Send attached photos via SOAP?
// TODO: Upload photos/files from SWADroid using MIME attachments
// TODO: If a user creates a request for inscription, and the user is removed ==> mark possible notifications as removed
// TODO: When SWAD prompts the user to confirm elimination of a group, list the groups below the button
// TODO: Send a message to the user when rejecting a request for enrolment. Suggested by Javier Fernández Baldomero.
// TODO: Create a table with IPs to block temporarily multiple access to the action used to check ID for empty accounts
// TODO: Every action should have a minimum time between two clicks on it (for example "Generate a report" should have 60 s)
// TODO: Generar informe -> ¿Realmente desea generar un informe... (puede tardar varios segundos...)? -> Generar informe.
// TODO: Writing a message to several recipients: include message to indicate that list of nicknames must be comma separated
// TODO: When requesting inscription, I can not click in the photo of my record. Change the form?
// TODO: Import ID, email, Surname1, Surname2, Name from CSV, suggested by Javier Melero
// TODO: Remove columns DegCod,CrsCod from database table surveys
// TODO: STATS > Figures > Folders and files --> statistics about documents and shared in institutions, centres and degrees
// TODO: When an assignment has the same name or the same folder as another existing assignment, after error the fields are empty!
// TODO: Remove all files inside the root folder (except the root folder itself) just as made with copy-paste?
// TODO: Cuando se seleccionan varios alumnos para sus trabajos y después se vuelve atrás y se vuelven a ver, salen los estudiantes duplicados ==> comprobar cada uno de los que se muestra si ya se ha mostrado para no hacerlo de nuevo
// TODO: Comprobar que cuando se da de baja un estudiante y luego se vuelve a dar de alta se han eliminado sus trabajos (Javier dice que no se eliminan)
// TODO: Hay un problema cuando se eliminan usuarios de una asignatura: quedan sus trabajos sin eliminar para siempre, ocupando espacio
// TODO: Se elimina un único estudiante de la asignatura. ¿Se eliminan sus trabajos? Si no, habría que cambiar el mensaje "eliminando sus trabajos...".
// TODO: Los administradores deberían ver el DNI de los usuarios no confirmados?
// TODO: Default type of degree should be "Other" or empty by default
// TODO: Change forms to change my webs / social networks to one unique form with a "Save changes" button
// TODO: In USERS > Attendance > Select event, if the list of users is big, the user should be requested to see big list in the same way that it is made in other options
// TODO: List only confirmed emails to send a message with MESSAGES > Email ?
// TODO: Add SWAD API to https://www.programmableweb.com/add/api
// TODO: When activating folders in groups, go to section for that type of group
// TODO: I can not remove a folder inside assignments (see swad.ugr.es -> EC -> assignment acanas)
// TODO: Fix bug in notification content about files sent to plugins like SWADroid: do not write internal name (for example "comun"). Call instead Brw_GetFileNameToShow or similar.
// TODO: Draw future dates in attendance, surveys, assignments in blue?
// TODO: Fix bug in generate a test: after entering a number of questions with empty tags and type of answers, number of questions is not remembered
// TODO: Fix bug when editing a test question with images: when "Change image" is selected but no image is uploades, other images (for example in answers) are lost
// TODO: Fix bug when creating a new attendance event: if title is repeated, form is cleared
// TODO: Fix bug: When registering an administrator, the user's name changes are ignored
// TODO: In list of indicators, alternate background colors also when not all the number of indicators are selected
// TODO: Ver solución de Guillermo Gómez Trenado cuando se pulsa con el botón derecho para abrir una descarga en otra ventana
// TODO: En los detalles de asistencia debería salir la fecha de cada sesión
// TODO: System admin should view link "Visits to course"
// TODO: Un administrador de institución, ¿debería poder cambiar la contraseña de un usuario de esa institución? No lo tengo claro.
// TODO: Subject in forum_post should be VARCHAR(255) in order to be copied directly to SummaryStr
// TODO: Add a Subject (VARCHAR(255)) to notices to be used as SummaryStr
// TODO: Subject in msg_content and msg_content_deleted should be VARCHAR(255) in order to be copied directly to SummaryStr
// TODO: Check how to get a summary of a social post or comments
// TODO: Check default values for ImageName, ImageTitle and ImageURL in database tables
// TODO: Cuando hay un fallo al rellenar el formulario de nuevo evento en la agenda se borran los datos
// TODO: Comprobar cabecera de una orla cuando el ámbito actual es un centro
// TODO: Include type of degree in form of degree configuration
// TODO: Cuando un admin. pulsa en "Inscribir profesor/a" y el usuario es invitado, debería salir en el rol por defecto "profesor" y no "estudiante"
// TODO: Tras inscribir a un profesor en una asignatura, nos vamos a otra pestaña, luego regresamos a USUARIOS y la opción por defecto es Otros, cuando debería ser Profesores.
// TODO: Comprobar que, para detectar el número de filas de cabecera y pie automáticamente en los archivos de calificaciones, SWAD mira no sólo que parezcan un ID, sino que coincida con alguno de los DNI de la asignatura (por ejemplo en el caso de los DNI alemanes formados por varias letras)
// TODO: En información de un centro, poner icono que enlace a edición de lugares, y posibilidad de editar lugar del centro en un menú desplegable. Lugar debería ir encima de Acceso directo.
// TODO: Fix bug: En Compartidos, si se borra la posibilidad de carpetas en un grupo ==> sale mensaje "The group has no file zones."
// TODO: Change numbers of notifications in program and database to match order in tabs
// TODO: Sugerencias pendientes de Sandra Daniela Tazzioli Barroso realizadas en mayo de 2017:
// - Mejor ayuda sobre cómo pasar de Excel al formato HTML necesario para las calificaciones.
// - Puede ser interesante que un administrador pueda cambiar el DNI de un usuario.
// - Comprobar que las direcciones de correo de cada uno de los estudiantes aparecen en Bcc: (copia oculta) en cualquier gestor de correo.
// - Informar a otros usuarios de que es el cumpleaños de otros usuarios para que los feliciten (habría que añadir una categoría de privacidad nueva para la visibilidad de la fecha de cumpleaños).
// - La información sobre nuevas notificaciones debería aparecer también en pantallas pequeñas (móviles). Tal vez podría aparecer también en el icono de notificaciones de la pestaña MENSAJES.
// - Hay alumnos que han generado el usuario en forma incompleta entre ellos no cargaron el DNI y no asisten a clase para rectificarlo. Hay forma de mi posicion con profesora o adminsitradora del centro ingresar, completar los datos aun conocer su clave?
// TODO: Fix bug: When a centre is associated with a place and it is moved to another institution, what happens with the place?
// TODO: Check what happens with places when a centre is removed
// TODO: Green lock in documents is not shown when name is shortened (see OpenSWAD -> Creative Commons -> Files -> Documents)
// TODO: Limit length of very big institution name in record card
// TODO: Link names are too short ==> add more length, for example: "A guide to building and understanding the physics of Water Rockets"
// TODO: Fix bug: Error when a link end in a dot. Example: "A guide to building..." --> "A guide to building._..url" (two dots)
// TODO: Cuando sólo se cambian los grupos y no el rol de un profesor ya existente, no sale ningún mensaje. se haga lo que se haga en la edición debería salir un mensaje del tipo "Cambios realizados"
// TODO: Debería haber un modo "ver" en las actividades, como en los documentos, para que el profesor tenga la visión del estudiante.
// TODO: "Solicitar inscripción" como superusuario: "Usted no tiene permiso para realizar esta acción"
// TODO: Poner icono con enlace a días festivos en calendario de centro, titulación y asignatura, además del actual calendario de institución
// TODO: Cuando vamos a inscribir a un nuevo usuario en la asignatura,
// debe salir por defecto estudiante en la opción Estudiantes y profesor en la opción Profesores,
// pero si el usuario ya existe en la asignatura, debe salir siempre el rol actual
// (para no cambiarlo sin querer si lo único que queremos hacer es cambiar la inscripción a grupos)
// TODO: Fix bug: Un superusuario se apunta a grupos, cuando pulsa "Cambiar de grupos" no ocurre nada.
// TODO: "Administrar varios profesores no editores" -> debería poder hacerlo un profesor (Perico)
// TODO: Sugerencia del profesor Cristóbal Lozano por correo del 3/11/2017:
// He detectado este año que, al mostrar la lista de los alumnos (p.ej., en varias columnas) en una hoja A4,
// en muchos casos no aparece el nombre/apellido completo del alumno si éste excede un nº determinado de caracteres.
// Por ejemplo, tengo una alumna llamada 'María Maldonado', pero sólo me aparece 'Maldon...'.
// Al tener varios alumnos extranjeros, cuando no me aparece el apellido completo, me es complicado averiguarlo.
// Me gusta tener una lista con sus fotos para ir haciendo anotaciones manuales.
// ¿Sería posible permitir que apareciesen más caracteres en sus nombres debajo de la foto?
// TODO: A superuser can not see records of teachers? Why?
// TODO: Non-editing teachers should can control assistance of students in their groups
// TODO: Enviar correo a todos los profesores de una asignatura, sugerido por Pedro Villar Castro
// TODO: Sugerencias de Pilar Ossorio Castellanos:
/*
Hola Antonio, estoy redactando preguntas en los test tipo: "rellenar hueco con la respuesta exacta". Se puede hacer seleccionando la modalidad "texto". El problema es cuando hay varios huecos en una frase, ya que no consigo que en los tests se respete el orden de mis preguntas, sino que salen aleatoriamente. ¿Hay alguna manera de fijar el orden de las preguntas? porque en ese caso ya no tendría problema con utilizar varios huecos en la misma frase, ya que cada pregunta sería una continuación de la primera. No se si me explico.
Otra cosa ¿Cómo hago para bloquear la entrada de los alumnos que han terminado un curso sin cancelar sus fichas y todo lo que se ha realizado. SImplemente quiero que no entren ya a ese curso. (pero no eliminar los datos del curso ni los alumnos que han participado)
*/
/*
En realidad no son cursos online sino la modalidad "plataforma" que se combina la parte online con tutorías virtuales (que tenemos que hacer externamente porque creo que no tenéis una herramienta tipo videoconferencia, webinar o skype) o con sesiones presenciales. Piden siempre un 75% de asistencia en la parte online, esto es: si un curso presencial tiene 10 h, por teleformación el alumno debe estar 7,5 usando la plataforma.
En swad he visto algo más importante que el tiempo conectado, que son los clics, y eso es lo que de verdad demuestra que el alumno está participando y no solo tiene el programa abierto.
Si sería útil poder tener los resultados de todos en bloque, porque sino tengo que entrar uno por uno y no puedo comparar, que es otra cosa que me gusta comprobar.
Por cierto, los test realizados por los alumnos solo se visualizan para los profesores si el alumno ha señalado la opción "dejar ver al profesor", ¿verdad? porque no me sale ninguno.
----- Mensaje original -----
Hola, Pilar:
Con control de asistencia en horas y minutos supongo que te refieres a asistencia online. La herramienta de control de asistencia actual sirve para pasar lista en clase presencial. Para controlar lo que ha hecho cada alumno lo que podrías usar los las estadísticas de acceso, que están en Estadísticas > Accesos > Accesos asignatura. Luego puedes seleccionar los usuarios y ver diversas estadísticas, como el listado detallado de cada estudiante, o unas gráficas de acceso por fechas. Si quieres el detalle de cada alumno, efectivamente debes ir sacando un informe de uno por uno.
Esto no está programado de otra forma porque eres la primera persona que lo solicita. Ten en cuenta que la herramienta se usa principalmente para apoyo a la docencia presencial. De todas formas, apunto en la lista de sugerencia por hacer, la posibilidad de sacar un informe de accesos individualizado para cada alumno, pero sin tener que ir uno por uno.
----- Mensaje original -----
Hola Antonio, ya hemos terminado un curso y me piden un control de la asistencia por parte de cada alumno en horas y minutos. ¿Sabes si los puedo visualizar todos sin tener que ir entrando uno por uno?
Gracias
---
Una pregunta: hay un calendario que me vendría muy bien poder colorear o remarcar las fechas que dura cada asignatura, ya que son módulos que se van autoevaluando a lo largo del curso, ¿es posible? porque he visto que el calendario no es editable,
*/
// TODO: Check actions table. All actions must be present in table.
// TODO: Urgente: Un profesor no puede eliminar archivos de estudiantes de la zona de actividades, ni subir nuevos, mientras está abierta la actividad, pero sí cuando está cerrada. ¿Qué sentido tiene?
// TODO: Suggested by Pablo Merino Ávila: statistics on test exams grouped by tags
// TODO: Suggested by Jesús García Miranda: copiar un fichero syllabus.xml de una asignatura a otra (bajar el fichero y poder importarlo desde otra).
// ---
// TODO: Sugerencia de David Cabrera Hidalgo: en la descarga de archivos, pulsando el botón del centro del ratón equivale a "abrir en pestaña nueva". Si se usara el método GET se podrían ir abriendo enlaces en otras pestañas para visitarlos posteriormente.
/*
Pilar Ossorio Castellanos en OpenSWAD
Pues tendría que hacer cambios en el programa. Lo anoto como urgente...
¡Gracias!
Antonio
----- Mensaje original -----
Hola Antonio, he ampliado el evento y nos deja comentar. El problema es que el profesor que es tutor del evento es no-editor, y no puede comentar el evento como yo, que si lo soy pero no he participado en el evento.¿cómo podríamos hacer para que ese profesor pudiera comentar, siendo el tutor, pero no siendo editor?
*/
// TODO: En el maletín cualquiera debería poder hacer un zip de una carpeta, no solo el superusuario
// TODO: Al buscar un profesor deberían salir también las asignaturas en las que es profesor no editor
// TODO: En el pefil público de un usuario deberían contabilizarse como profesor las asignaturas en las que sea profesor no editor
/* TODO:
@CarlosEObertoM En respuesta a @acanasvargas
Buenos días Profesor Cañas, sé que no es nada fácil, pero pudiera hacer más versátil las hojas de calificaciones que en pocos pasos se pudiera configurar para dar promedios, parciales y definitivas. Perdone la solicitud. Soy usuario agradecido de OpenSwad.
*/
/* TODO: Mensaje del profesor Joaquín Manuel Durán Álvarez
* Estimado Antonio:
Como todos los años te voy a preguntar si vais a implementar una opción, en donde yo pueda bloquear a un alumno sin necesidad de borrarlo de la asignatura. Si lo borro, pierdo todos sus datos sobre trabajos entregados y las notas que le haya puesto. Y algunas veces cuando la gente aprueba, prefiero bloquearlo pero que siga dado de alta para consultar cosas.
O incluso para gente que pierde el derecho de examen por curso y puede recuperarlo. Son múltiples situaciones distintas en las que vendría muy bien esa opción.
Gracias por todo. Seguimos en contacto
---
Respuesta:
Hola, Joaquín, ¿qué tal?
He estado discutiendo tu mensaje un buen rato con Javier Fernández @jfernand y más o menos entendemos que podrían ser interesantes distintos tipos de roles, cada uno con diferentes permisos:
- estudiante bloqueado
Sería parecido a un usuario que visita otra asignatura, en el sentido de que no podría ver nada que no sea público, ni podría editar nada, pero aparecería como estudiante bloqueado en la lista de estudiantes de la asignatura.
- estudiante antiguo / estudiante invitado
Podría acceder a (leer) los materiales de la asignatura, pero no recibiría notificaciones ni podría editar. Aparecería en las listas como estudiante invitado.
En cualquier caso el estudiante siempre podría borrarse de la asignatura, como ya ocurre con cualquiera de los roles existentes.
Anoto tu comentario y mi respuesta en la lista de mejoras por estudiar e implementar, aunque ahora mismo no puedo ponerla como la primera de la lista por haber otras con mayor prioridad y por la dificultad que supone crear un nuevo rol. Hace un tiempo creé el nuevo rol de profesor no editor y llevó meses dejarlo más o menos fino, ya que, aunque está bastante sistematizado, en la práctica supone cambiar miles de líneas de código por todo el programa (que ya va por las 240 000 líneas) donde se hacen comprobaciones sobre lo que puede hacer o no cada rol.
Hablando con @jfernand se nos ocurre que para el primer caso (estudiante bloqueado) sólo hay dos opciones ahora:
- Borrarlo de la asignatura (es lo que hace Javier) por ejemplo si desaparece de las actas. En este caso te sugiero que antes de borrarlo hagas dos copias de seguridad:
1. En Archivos > Trabajos, crea un zip de todo y guárdalo en tu ordenador.
2. En Usuarios > Estudiantes > Ver como lista > Botón superior izquierdo "Mostrar todos los datos en una tabla" > Guardar esa tabla como página web o (copiarla en una hoja de cálculo) en tu ordenador.
- Dejarlo tal cual, como si fuera un alumno más
Para el segundo caso (estudiantes antiguos o invitados) tienes dos opciones:
- Crear una asignatura cada año y dejar más o menos congeladas las asignaturas de años anteriores. Tiene la desventaja de tener que subir todo el material cada año.
- Crear grupos dentro de la asignatura con los estudiantes de cada curso. Seguirían recibiendo notificaciones de los cambios en la asignatura.
He guardado tu correo y esta respuesta en mi lista de "TO DO" (por hacer).
Saludos,
Antonio
*/
/* Sugerencias de Atanasio José Rubio Gil (marzo de 2019):
Te escribo por aquí porque no hay notificaciones para los comentarios o posibilidad de seguir hilo. Ahí van dos mejoras chulas. Las otras que se me ocurren son ver sólo posts de estudiantes o mutear anuncios oficiales y hostear las imágenes en un servicio externo (como imgur, que permite subida y enlazado automático) para que no pierdan calidad.
¡Muchas gracias por esta pedazo de plataforma!
Respuesta:
Pues la verdad es que notificaciones de comentarios sí hay (lo puedes comprobar en Perfil > Ajustes), lo que pasa es que desde que he puesto el timeline nada más entrar, la notificación se marca como vista por el hecho de ver el timeline. Quiero decir, que si estás en otra opción verás la notificación, pero si te acabas de identificar, como lo primero que se hace es ir al timeline, se elimina la notificación. Pensaré a ver si hay alguna solución.
Lo de la calidad de las imágenes es cuestión de aumentarla un poco al comprimirlas, aunque ocuparán más. Lo veré.
Lo de mutear anuncios, en principio prefiero hacer una opción para seguir masivamente a usuarios de asignaturas y que la gente use preferiblemente la opción de ver sólo los mensajes de los que sigues.
*/
// TODO: Eliminar todas las preguntas de test de un golpe
// TODO: URGENTE: Cuando se cree un descriptor nuevo TIENE QUE ESTAR INHABILITADO porque si no los alumnos pueden ver el examen (Miguel Damas)
// TODO: Que la opción por defecto en "Permitir que los profesores vean este examen" la configuren los profesores en cada asignatura"
// TODO: URGENTE: Bego del Pino, una columna en resultados de test que indique los descriptores de ese examen
// TODO: Cuando se muestre un usuario duplicado, que SWAD calcule automáticamente sus cifras no calculadas sin tener que pulsar en Calcular
// TODO: Miguel Damas Hermoso sugiere poder editar texto enriquecido (Markdown) en las preguntas de tipo test
// TODO: No se puede pulsar sobre la foto de un remitente de un mensaje recibido.
// TODO: Un administrador de centro ahora no tiene permisos para editar horario asignatura, pero le sale el icono de editar
// O le damos permisos o quitamos el icono de editar. Comprobar para admin. de titulaciones.
// TODO: Mensajes > Anuncios cuando no estás identificado, deberían salir algunos, ¿por qué no indicar que se muestren para todos?
// TODO: Fix bug: Al mostrar una orla con todos los profesores de SWAD, se muestran primeros los profesores y luego los no editores (repetidos algunos)
// TODO: Chequear todos los iconos .gif y .png que restan, concretamente los de file_browser
// TODO: Check if Feedback is set to "(null)" when importing test questions. Change columns Feedback "(null)" to "" in test questions
// TODO: Allow timeline posting only for users belonging to courses or admins to avoid user who create accounts only to post
// TODO: Ver cómo recibir un fichero desde el cliente (SWADroid) en gsoap
// TODO: En Actividades, en Juegos, en Encuestas, en Asistencia poner filtros de Pasados (rojo), Actuales (verde), Futuros (azul).
// Pensar si en Agenda se puede poner igual.
// TODO: Cambiar QstInd al rango 1,2,3... (código especial 0 en lugar de -1) en swad_survey
// TODO: Probar qué ocurre si se está jugando una partida en una pestaña y se reanuda la misma en otra pestaña (da igual otra pestaña que otro navegador u ordenador)
// TODO: ¿Puede un profesor reanudar una partida comenzada por otro profesor?
// TODO: Perico: bloquear la subida de archivos por parte de estudiantes (no tiene que ver con el bloqueo de la edición de proyectos)
// TODO: Al confirmar una inscripción, mostrar ficha de retroalimentación similar a la que se muestra cuando se crea un administrador. Tal y como está ahora crea confusión al usuario.
// TODO: Suggested by Jose Luis Bernier Villamor: "Compartidos" debería inhabilitarse si el profesor lo quiere, porque algunos alumnos suben por error los trabajos
// Alternativa. Llamarle "Públicos" o algo así y poner la opción más alejada de Trabajos.
// TODO: Suggested by Jose Luis Bernier Villamor: Posibilidad de que los profesores decidan en la configuración
// de la asignatura si desean o no que se pueda solicitar
// inscripción en la asignatura
// TODO: Reported by Francisco José Pelayo Valle: un estudiante sube 50 ficheros de golpe ==> el firewall le banea. No debería, ¿o sí?
// TODO: En Eventos de asistencia, poner un icono de enlace a horario de la asignatura ¿y otro a grupos?
// TODO: Non-editing teacher should create attendance events and control attendance
// TODO: URGENTE: Reportado por Javier Fernández Baldomero. Al pasar lista con SWADroid, los estudiantes sin foto no salen en la lista de alumnos de SWADroid.
// TODO: Sugerencia de Pedro A. García Sánchez: poner un enlace a horario externo, igual que con otras partes de la información
/*
Ya voy a empezar a darte la lata... Aunque esto es algo que tengo apuntado desde hace tiempo. En los másteres es complicado hacer una plantilla de horarios como la que tienes en swad, pero nos obligan a meter el horario, con aula y profesor, por cada sesión. Por ejemplo,
https://oficinavirtual.ugr.es/awc/horario/ve_horario/visor.jsp?programa=M37156&siglas=15
contiene una de las que yo imparto. Así que me imagino que te esperarás la sugerencia (petición con café o cerveza como recompensa): ¿sería posible que en la pestaña de horario se pudiese embeber esa página? (Creo que los grados usan algo parecido también.)
*/
// TODO: Mostrar cifras sobre partidas (matches) en el apartado Figures > Games.
// TODO: En resultados de test y de juegos, en preguntas modificadas se podría mostrar la puntuación obtenida en la pregunta (ahora no sale)
// TODO: Al crear un nuevo juego, debería irse a la pantalla de añadir preguntas (la misma opción que sale cuando pulsas en editar un juego existente)
// TODO: Code refactoring in HTML h1, title, meta, video, p, iframe, input hidden, area
// TODO: ¿Añadir dos columnas a resultados de juegos entre "Preguntas contestadas" y "Puntuación total": Preguntas "Correctas" y Preguntas "Erróneas"?
// Problema: sólo es aplicable a tipo test
// TODO: En los avisos amarillos aparecen enlaces, pero en las copias de ellos en el timeline
// no se insertan los hipervínculos de los avisos.
// No los añadí en su momento porque se copian los primeros caracteres del mensaje,
// pudiendo cortarse en mitad de un enlace.
// Es decir, porque es complicadillo de hacer.
// Lo mejor sería limitar la longitud máximoa de los avisos a N caracteres,
// igual que los posts del timeline, y así ponerlos completos siempre, con enlaces y todo.
// De camino evitaría los avisos kilométricos.
// TODO: Si hay accesos a un centro y el centro se elimina, al clicar en el acceso sale un mensaje de "Usted no tiene permiso para realizar esta acción." en lugar de "No existe el centro"
// TODO: Poner en swad.cfg varias líneas de swad_config.h para que sea más configurable
// TODO: Al exportar tests, los & hay que exportarlos como &amp; o &#numero;, ya que un & no es correcto en XML.
// TODO: Junto al enlace test.xml hay que indicar que se descarga con "Guardar enlace como..." porque si se abre, se copia y se pega, son incorrectos los <
/* TODO: Geolocalización:
La tabla room_check_in contiene todas las ubicaciones de todos los usuarios en las últimas 12/24 horas como mucho.
Se eliminaría periódicamante en Lay_RefreshNotifsAndConnected().
Haría falta una función API que envíe el histórico reciente de ubicaciones de un usuario
Poblar base de datos:
En Usuarios > Ubicación aparecería un botón pequeño de "Añadir ubicación".
Se preguntaría a SWAD a través de una función de la API getAvailableRoles si el usuario tiene permiso para añadir ubicaciones.
Si es así, se llamaría a la función:
Función API newLocation...
Paramétros: MAC, string con ubicación (ej. "Aula 0.1")
Función de la API para ver dónde se encuentra un usuario:
getUserLocation
Un usuario sólo podrá consultar la ubicación de otro usuario
si la intersección de los centros de sus asignaturas no es vacía,
es decir, no tienen por qué compartir asignaturas,
pero sí al menos alguna asignatura de cada uno tiene que compartir el centro
(Por ej. Eva y Antonio comparten ETSIIT, pero no titulación ni asignatura)
Se puede mostrar las últimas dos o tres ubicaciones (y dentro de ellas sólo el último instante de cada ubicación)
dentro siempre de lo que haya guardado en la tabla de ubicaciones limitada a 12/24 h.
-------------------------------------------------------------------------------
*/
// TODO: Sugerencia de Jesús García Miranda. En las preguntas de tipo test de elección única (o un nuevo tipo con un nuevo nombre),
// poner por ejemplo 10 o 20 opciones, con 3 o 4 verdaderas y las demás falsas,
// y que swad saque una pregunta de 4 cogiendo una verdadera y 3 falsas al azar.
// TODO: Laura García: "Ahora estoy utilizando la plataforma SWAD más que nunca, evidentemente, debido a las circunstancias, e incluso les he hecho un examencillo a los alumnos utilizando los test de autoevaluación.
// Pero quería preguntarte un par de cosas:
// - lo primero es si se pueden borrar los test realizados por cualquier usuario, incluido profesores. Yo misma he hecho un montón para simular el examen, y ya me están sobrando.
// - por otra parte, he buscado pero no he encontrado, la posibilidad de cambiar la manera de corregir los tes, quitar la penalización por respuesta negativa,, o cambiarla, etc.. La verdad es que si se puede hacer me facilitaría un montón el trabajo próximo que nos espera con los alumnos."
// TODO: Hacer un nuevo rol en los TFG: tutor externo (profesor de áreas no vinculadas con el centro, profesionales de empresas, etc.)
// TODO: Impedir la creación y edición de proyectos si no son editables.
// TODO: No se puede entrar con DNI '1' suponiendo que no tenga password ¿por qué?
// TODO: En la lista de conectados central, poner el logo de la institución a la que pertenece el usuario
// TODO: Miguel Damas: al principio de los exámenes tendría que poner cuánto resta cada pregunta
// TODO: Oresti Baños: cambiar ojos por candados en descriptores para prohibir/permitir y dejar los ojos para poder elegir descriptores
// TODO: Integrar pull requests con traducciones del alemán del usuario eruedin en GitHub
// TODO: Cambiar icono notificaciones nuevas con "bell-on.svg"
// TODO: Ahmed El Moukhtari Koubaa: Cuando le damos a la opción de mostrar solo los mensajes no leídos, se muestran estos mensajes, pero cuando los intentamos leer, es decir, hacemos clic sobre ellos se recarga toda la página por así decirlo y vuelve a dar una lista con los mensajes, pero descartando aquel que clicamos porque, entiendo yo al menos, que ya lo ha marcado como leído.
/*****************************************************************************/
/****************************** Public constants *****************************/
/*****************************************************************************/
// Size of photos:
// find -iname '*.jpg' -exec du -cb {} + | grep total$ | cut -f1 | paste -sd+ - | bc
// find -iname '*original.jpg' -exec du -cb {} + | grep total$ | cut -f1 | paste -sd+ - | bc
// Number of lines (includes comments but not blank lines) has been got with the following command:
// nl swad*.c swad*.h css/swad*.css py/swad*.py js/swad*.js soap/swad*?.h sql/swad*.sql | tail -1
/* Printing:
En local:
enscript -1 --file-align=2 --highlight --line-numbers -o - * > swad17.26.7_bn_1_columna.ps
enscript -1 --color --file-align=2 --highlight --line-numbers -o - * > swad17.26.7_color_1_columna.ps
enscript -2 --landscape --file-align=2 --highlight --line-numbers -o - * > swad17.26.7_bn_2_columnas.ps
enscript -2 --landscape --color --file-align=2 --highlight --line-numbers -o - * > swad17.26.7_color_2_columnas.ps
En OpenSWAD:
ps2pdf source.ps destination.pdf
TODO: Juan Miguel Boyero Corral: Este verano ha habido varias personas que han solicitado incluir la funcionalidad del apartado de Actividades en SWADroid. Si lo ves viable podríamos estudiarlo.
TODO: José Martínez Aroza: Si estoy viendo la lista de trabajos de un grupo de estudiantes y pulso F5 (reenviando datos) entonces sale el listado duplicado, y la siguiente vez triplicado, etc.
TODO: Raymon Moreno Colina: ¿sera posible colocarle a las preguntas distinta ponderación (puntuación)?; porque como docente a veces uno formula en un examen cuestiones que tienen mayor profundidad que otras y considero que no debería ser la misma puntuación para toda las preguntas.
TODO: Encarnación Hidalgo Tenorio: Antonio, ¿podría @swad_ugr mandar una notificación cuando el alumnado ha mandado su tarea?
Se trataría de añadir un par de líneas "Nuevos archivos en actividades", "Nuevos archivos en otros trabajos".
TODO: Fix bug: Un estudiante recibe una notificación de un archivo de calificaciones. Luego el archivo es ocultado por el profesor. Pero desde la notificación sigue estando accesible, cuando no debería ser así. Reported by Adrián José Martínez Navarro.
TODO: Fix bug: Cuando se pulsa en ver fichas, y luego en una ficha en "Ver trabajos" o "Ver exámenes", o lo que sea, sale dos veces ese estudiante.
TODO: No limitar el número de preguntas en un examen a ExaPrn_MAX_QUESTIONS_PER_EXAM_PRINT, sino asignar PrintedQuestions dinámicamente con malloc
TODO: Que al generar un examen sólo se cojan preguntas válidas. Y si ya está generado, al entrar de nuevo, que se vean en rojo.
TODO: Create module swad_test_result
"sudo apt install webp" en Ubuntu, y "yum install libwebp libwebp-tools" en CentOS, para decodificar imágenes Web/ug reportado por Javier Fernández Baldomero.
TODO: JJ: Hoy me ha saltado una "alarma" en swad cuando había asignado un proyecto a un estudiante, pero no había puesto que estaba asignado. ¿No sería conveniente que si se asigna a un estudiante se ponga automáticamente que está asignado?
Respuesta: Tienes razón. La explicación de por qué no lo hice así seguramente es que antes, en vez de "Asignado" se indicaba "Preasignado", y no cambiando automáticamente a "Sí", los ofertados quedaban marcados como no preasignados incluso después de que se añadiera al estudiante al que se le "postasigna". Pero ahora "Asignado" se usa tanto para los preasignados como para los "postasignados", con lo cual sí sería conveniente que se activara el "Sí" automáticamente para evitar el aviso de error (triángulo amarillo). Lo anoto y lo corrijo en cuanto pueda.
TODO: En los resultados de una partida, cuando la pregunta ha sido modificada, no calcular ni mostrar la puntuación de esa pregunta.
Por ejemplo una pregunta podria haber sido bien contestada con 1 punto, y se muestra en esa pregunta modificada aparece 0 en rojo.
TODO: Al pulsar en una notificación de un mensaje nos lleva a la página 1, aunque el mensaje esté en otra página.
TODO: Partidas en SWADroid:
Hola Antonio:
Dado que Sergio sigue sin dar señales de vida lo he dado por perdido y estoy continuando yo el desarrollo del módulo de Kahoot. Durante las pruebas he detectado dos problemas:
1. Al recuperar el número de preguntas de un juego se devuelve un valor incorrecto. Por ejemplo, en la asignatura Prueba el juego "Prueba" tiene 37 preguntas pero el servicio web devuelve un número muy alto:
<numQuestions>1701605202</numQuestions>
2. Desde anoche cuando creo una partida dentro de un juego y la inicio no se cargan las opciones de respuesta en la pantalla de la partida. Sale permanentemente la animación de "Cargando". Esto ocurre en la asignatura Prueba, el juego "Prueba" y la partida "Prueba". Esta incidencia es bloqueante, ya que me impide continuar con las pruebas.
¿Podrías revisar estas dos incidencias para poder completar el desarrollo, por favor?
Muchas gracias,.
Juan Miguel.
TODO: DNI de un estudiante sale erróneamente como ******* en lugar de mostrarse al ver los accesos de un estudiante a la asignatura.
TODO: BUG: Cuando un tipo de grupo sólo tiene un grupo, inscribirse es voluntario, el estudiante sólo puede pertenecer a un grupo, y se inscribe en él, debería poder desapuntarse. Ahora no puede.
TODO: Salvador Romero Cortés: @acanas opción para editar posts
TODO: FIX BUG, URGENT! En las fechas como parámetro Dat_WriteParamsIniEndDates(), por ejemplo al cambiar el color de la gráfica de accesos por día y hora, no se respeta la zona horaria.
TODO: En las encuestas, que los estudiantes no puedan ver los resultados hasta que no finalice el plazo.
TODO: Fix bug: error al enviar un mensaje a dos recipientes, error on duplicate key... Reportado por Salvador Romero Cortés.
TODO: Attach pdf files in multimedia.
TODO: BUG al intentar crear un fichero ZIP con los trabajos de una asignatura si un estudiante con nombre cirílico está entre los alumnos que seleccionas para ver los trabajos. Reported by Víctor Vázquez Rodríguez el 22 de enero de 2023.
Sugerencia de J.L Bernier. Al eliminar los estudiantes, que se eliminen los trabajos opcionalmente marcando una casilla.
En Actividades, no permitir acceso a documentos mientras dura la actividad, también opcionalmente.
Que no haya dos sesiones del mismo usuario abiertas al entregar actividades, o hacer algo como en los exámenes, log.
Que al subir un fichero por defecto esté oculto, aunque sea opcional.
Al subir cosas para los grupos, en documentos, resltar más los grupos porque no son conscientes...
Exportar listas en CSV.
Sugerencia de Raymon Moreno:
Saludos cordiales estimado, tengo un planteamiento que hacerle con respecto a la actualización de las asignaturas que están aperturadas en las distintas titulaciones que administramos en la Universidad, el escenario es el siguiente, tenemos asignaturas que en este momento no tendrán alumnos inscritos porque no hay secciones abiertas pero que en próximos lapsos si tendrán participantes inscritos, por lo que quiero consultar si hay manera de que se puedan como INHABILITAR TEMPORALMENTE, y cuando se requiera nuevamente la inscripción de los estudiantes se puedan ACTIVAR o HABILITAR, creo que esa función de ACTIVAR la hacemos los administradores de Titulaciones cuando algún profesor crea una asignatura....... entonces algo como eso........ todo esto con el fin, de que no se pierda lo estructurado que posee cada asignatura........
El otro escenario esta orientado en lo siguiente, Si no es Factible lo de la INACTIVACIÓN de asignaturas quisiera intentar borrarlas y guardar el Contenido en MALETÍN, pero no me permite guardar los elementos que se disponen en los apartados iniciales de cada asignatura y que tienen la opción de ser de LECTURA OBLIGATORIA por el estudiante, entonces mi consulta es, como podría almacenar estos elementos en Maletin, de manera que cuando se vaya a aperturar la asignatura nuevamente se pueda cargar tanto el contenido, como los aspectos de Guía, Información, Programa o Temario, Bibliografía.......
son planteamientos que facilitarían la organización del entorno para cada titulación y no tener secciones inactivas que signifiquen una data no ajustada a la realidad el uso de la misma..............
siempre atento a sus comentarios y agradecido de antemano por la ayuda que siempre nos ha brindado.........Saludos Caribeños desde Venezuela
TODO: Emilce Barrera Mesa: Calificación integrada de las actividades. No olvides por favor la opción de calificar y asignar nota en cada actividad o trabajo. Eso agregaría un toque de supereficiencia a tu plataforma.
TODO: Emilce Barrera Mesa: Para futuras mejoras podrías incluir por favor la opción de duplicar una pregunta al momento de crearlas. Esto en razón a que si tengo dos preguntas con las mismas opciones de respuesta, pero diferente enunciado me ahorrarías tiempo si me permites duplicar la pregunta y solo cambiar el enunciado.
TODO: Emilce Barrera Mesa: Quiero preguntarte si es posible que me habilites la opción de que en el examen solo tenga en cuenta las respuestas correctas para asignar la nota. Es decir que no reste puntaje por las preguntas incorrectas, que tanto incorrectas como sin contestar tengan el valor de cero.
TODO: Emilce Barrera Mesa: Podrías agregar por favor una opción que me permita exportar en excel, cvs o pdf el listado de estudiantes y la nota optenida en el examen. Eso me ayudaría mucho a la hora de pegarlas en mi planilla de excel.
TODO: Emilce Barrera Mesa: Mis estudiantes presentan muchas dificultades a la hora de poner la foto porque la plataforma es muy exigente respecto al fondo de la imagen.
*/
#define Log_PLATFORM_VERSION "SWAD 22.120.2 (2023-06-07)"
#define CSS_FILE "swad22.120.css"
#define JS_FILE "swad22.49.js"
/*
Version 22.120.2: Jun 07, 2023 Code refactoring related to cookies and hidden-visible. (337646 lines)
Version 22.120.1: Jun 06, 2023 Translation of messages about cookies. (337620 lines)
Version 22.120: Jun 06, 2023 Code refactoring related to hidden-visible. (337561 lines)
Version 22.119: Jun 06, 2023 Code refactoring related to hidden-visible. (337588 lines)
Version 22.118.13:May 31, 2023 Code refactoring in forums. (337417 lines)
Version 22.118.12:May 30, 2023 Code refactoring in forums and messages. (337408 lines)
Version 22.118.11:May 30, 2023 Code refactoring in strings. (337391 lines)
Version 22.118.10:May 30, 2023 Draw logo in head even if it does not exist. (337359 lines)
Version 22.118.9: May 30, 2023 Code refactoring in user account. (337363 lines)
Version 22.118.8: May 30, 2023 Fixed bugs in users. (337361 lines)
Version 22.118.7: May 30, 2023 Fixed bug in photo processing. Reported by Emilio Alemán Carmona. (337364 lines)
Version 22.118.6: May 24, 2023 Fixed bug in rubrics. (337363 lines)
Version 22.118.5: May 23, 2023 Changes in comments in surveys. (337360 lines)
Version 22.118.4: May 23, 2023 Fix CSS related to frequent actions. (337351 lines)
Version 22.118.3: May 23, 2023 Fix CSS related to left and right columns. (337351 lines)
Version 22.118.2: May 23, 2023 Changes in survey comments. (337339 lines)
Version 22.118.1: May 22, 2023 Remove survey comments from database. (337334 lines)
Version 22.118: May 22, 2023 Survey comments are stored in database. (337285 lines)
1 change necessary in database:
CREATE TABLE IF NOT EXISTS svy_comments (ComCod INT NOT NULL AUTO_INCREMENT,QstCod INT NOT NULL,Comments TEXT NOT NULL,UNIQUE INDEX(ComCod),INDEX(QstCod,ComCod));
If you want to use MyISAM:
ALTER TABLE svy_comments ENGINE=MyISAM;
Version 22.117: May 22, 2023 Teachers can allow comments in a survey question. (337196 lines)
1 change necessary in database:
ALTER TABLE svy_questions ADD COLUMN CommentsAllowed ENUM('N','Y') NOT NULL DEFAULT 'N' AFTER AnsType;
Version 22.116.1: May 21, 2023 Rubrics only availables for superusers. (337098 lines)
Version 22.116: May 20, 2023 Changes in rubric scores. (337093 lines)
Version 22.115: May 19, 2023 Generalization of rubric scores. (337010 lines)
1 change necessary in database:
CREATE TABLE IF NOT EXISTS rub_scores (Type ENUM('non','asg','prj','cfe','exa','gam','rub','doc','mrk','att','for','svy') NOT NULL DEFAULT 'non',Cod INT NOT NULL,UsrCod INT NOT NULL DEFAULT -1,CriCod INT NOT NULL,EvlCod INT NOT NULL DEFAULT -1,Score DOUBLE PRECISION NOT NULL DEFAULT 0,UNIQUE INDEX(Type,Cod,UsrCod,CriCod));
If you want to use MyISAM:
ALTER TABLE rub_scores ENGINE=MyISAM;
2 changes necessary in database:
INSERT INTO rub_scores SELECT 'prj',PrjCod,-1,CriCod,-1,Score FROM prj_scores ORDER BY PrjCod,CriCod;
DROP TABLE prj_scores;
Version 22.114: May 19, 2023 Check if a rubric is recursive. (336984 lines)
Version 22.113: May 19, 2023 Check if a rubric is recursive. (336936 lines)
Version 22.112: May 18, 2023 Code refactoring in options of selectors. (336794 lines)
Version 22.111: May 17, 2023 A project can have more than one rubric in each category. (336691 lines)
Version 22.110.3: May 15, 2023 Changes in rubrics. (336550 lines)
Version 22.110.2: May 15, 2023 Changes in rubrics. (336507 lines)
Version 22.110.1: May 14, 2023 Changes in project rubrics. (336462 lines)
Version 22.110: May 12, 2023 Code refactoring confirming removal. (336445 lines)
Version 22.109: May 11, 2023 Code refactoring confirming removal. (336647 lines)
Version 22.108: May 11, 2023 Code refactoring in forms. (337145 lines)
Version 22.107.40:May 10, 2023 Changes in creation of test questions and survey questions. (337447 lines)
Version 22.107.39:May 10, 2023 Changes in creation of user account. (337435 lines)
Version 22.107.38:May 10, 2023 Changes in edition of mail domains. (337455 lines)
Version 22.107.37:May 10, 2023 Changes in edition of attendance events and agenda events. (337484 lines)
Version 22.107.36:May 10, 2023 Changes in style of fieldset and legend. (337505 lines)
Version 22.107.35:May 10, 2023 Changes in edition of course program. (337504 lines)
Version 22.107.34:May 10, 2023 Changes in edition of groups. (337543 lines)
Version 22.107.33:May 09, 2023 Changes in edition of degree types. (337591 lines)
Version 22.107.32:May 09, 2023 Changes in edition of rooms. (337639 lines)
Version 22.107.31:May 09, 2023 Changes in edition of record fields. (337655 lines)
Version 22.107.30:May 09, 2023 Changes in edition of plugins. (337694 lines)
Version 22.107.29:May 09, 2023 Changes in edition of places. (337713 lines)
Version 22.107.28:May 09, 2023 Changes in edition of notices. (337707 lines)
Version 22.107.27:May 09, 2023 Changes in edition of links. (337750 lines)
Version 22.107.26:May 09, 2023 Changes in edition of holidays. (337740 lines)
Version 22.107.25:May 09, 2023 Changes in edition of games. (337760 lines)
Version 22.107.24:May 09, 2023 Changes in edition of exams. (337781 lines)
Version 22.107.23:May 09, 2023 Changes in edition of departments. (337802 lines)
Version 22.107.22:May 09, 2023 Changes in edition of courses. (337817 lines)
Version 22.107.21:May 09, 2023 Changes in edition of degrees. (337829 lines)
Version 22.107.20:May 09, 2023 Changes in edition of countries. (337842 lines)
Version 22.107.19:May 09, 2023 Changes in edition of institutions. (337858 lines)
Version 22.107.18:May 09, 2023 Changes in edition of centers. (337871 lines)
Version 22.107.17:May 09, 2023 Changes in edition of buildings. (337884 lines)
Version 22.107.16:May 08, 2023 Changes in edition of banners. (337899 lines)
Version 22.107.15:May 08, 2023 Changes in edition of assignments. (337915 lines)
Version 22.107.14:May 07, 2023 Changes in edition of announcements. (337936 lines)
Version 22.107.13:May 07, 2023 Changes in edition of exam sessions. (337957 lines)
Version 22.107.12:May 07, 2023 Changes in edition of rubrics. (337930 lines)
Version 22.107.11:May 07, 2023 Changes in edition of surveys. (337952 lines)
Version 22.107.10:May 07, 2023 Changes in edition of projects. (337973 lines)
Version 22.107.9: May 07, 2023 Changes in edition of rubric criterions. (338015 lines)
Version 22.107.8: May 07, 2023 Changes in edition of exam sets. (338031 lines)
Version 22.107.7: May 06, 2023 Changes in edition of games. (338025 lines)
Version 22.107.6: May 06, 2023 Code refactoring in edition of exams. (338023 lines)
Version 22.107.5: May 06, 2023 Changes in edition of rubrisc. (338027 lines)
Version 22.107.4: May 06, 2023 Changes in edition of exams. (338040 lines)
Version 22.107.3: May 06, 2023 Changes in edition of exams. (338045 lines)
Version 22.107.2: May 05, 2023 Removed unused action in exam sets. (338044 lines)
Version 22.107.1: May 05, 2023 Changes in list of users to follow. (338105 lines)
Version 22.107: May 05, 2023 Changes in layout institutional links and connected users. (338108 lines)
Version 22.106: May 05, 2023 Changes in layout of frequent actions. (338126 lines)
Version 22.105: May 05, 2023 Changes in CSS. (338102 lines)
Version 22.104.6: May 04, 2023 Changes in projects. (338079 lines)
Version 22.104.5: May 04, 2023 Fixed issue in indicators. (338079 lines)
Version 22.104.4: May 04, 2023 Changes in lists. Changes in project edition. (338079 lines)
Version 22.104.3: May 04, 2023 Changes in project configuration. (338043 lines)
Version 22.104.2: May 04, 2023 Rubrics in project. Changes in input numbers. (338022 lines)
Version 22.104.1: May 04, 2023 Rubrics in project. Code refactoring in file browsers. (338014 lines)
Version 22.104: May 03, 2023 Rubrics in project. Not finished. (338000 lines)
3 changes necessary in database:
CREATE TABLE IF NOT EXISTS prj_rubrics (CrsCod INT NOT NULL,Type ENUM('tut','evl','gbl') NOT NULL,RubCod INT NOT NULL,UNIQUE INDEX(CrsCod,Type,RubCod));
CREATE TABLE IF NOT EXISTS prj_scores (PrjCod INT NOT NULL,CriCod INT NOT NULL,Score DOUBLE PRECISION NOT NULL DEFAULT 0,UNIQUE INDEX(PrjCod,CriCod));
ALTER TABLE prj_config DROP COLUMN RubTutCod,DROP COLUMN RubEvlCod,DROP COLUMN RubGblCod;
If you want to use MyISAM:
ALTER TABLE prj_rubrics ENGINE=MyISAM;
ALTER TABLE prj_scores ENGINE=MyISAM;
Version 22.103: Apr 25, 2023 Fixed issue in list of rubric criteria. (337537 lines)
Version 22.102.3: Apr 21, 2023 Changes in exams. (337538 lines)
Version 22.102.2: Apr 21, 2023 Changes in games. (337454 lines)
Version 22.102.1: Apr 21, 2023 Changes in rubrics. (337378 lines)
Version 22.102: Apr 21, 2023 Rubrics in project. Not finished. (337360 lines)
Version 22.101.12:Apr 21, 2023 Code refactoring in attendance and match results. (337275 lines)
Version 22.101.11:Apr 21, 2023 Changes in edition of centers and places. (337289 lines)
Version 22.101.10:Apr 21, 2023 Changes in course information. (337302 lines)
Version 22.101.9: Apr 21, 2023 Changes in edition of countries, links, banners, institutions, centers, places, degrees, degree types, buildings, rooms and courses. (337313 lines)
Version 22.101.8: Apr 20, 2023 Changes in edition of rubrics, degree types and departments. (337350 lines)
Version 22.101.7: Apr 20, 2023 Changes in edition of exams and games. (337342 lines)
Version 22.101.6: Apr 20, 2023 Changes in edition of program items. (337370 lines)
Version 22.101.5: Apr 20, 2023 Changes in edition of buildings and rooms. (337392 lines)
Version 22.101.4: Apr 20, 2023 Changes in edition of plugins. (337393 lines)
Version 22.101.3: Apr 20, 2023 Changes in edition of countries, institutions, centers, degrees and courses. (337338 lines)
Version 22.101.2: Apr 20, 2023 Changes in edition of places, holidays, links and banners. (337342 lines)
Version 22.101.1: Apr 20, 2023 Changes in edition of holidays. (337338 lines)
Version 22.101: Apr 20, 2023 Removed buttons to create new elements: a new place, new holiday, new link, new banner, new plugin, new building, new room, new program item, new assignment, new project, new call for exam, new question, new exam, new set of questions, new exam session, new game, new match, new rubric, new criterion, new group, new type of group, new attendance event, new record field, new announcement, new notice, new message, new forum thread, new forum post, new survey, new survey question, new agenda event, new email domain. (337332 lines)
Version 22.100.4: Apr 19, 2023 Removed buttons to create a new institution, new center, new degree and new course. (338756 lines)
Version 22.100.3: Apr 19, 2023 Institution admins can edit places. (338891 lines)
Version 22.100.2: Apr 19, 2023 Institution admins can edit departments. (338889 lines)
Version 22.100.1: Apr 19, 2023 Changes in projects. (338897 lines)
Version 22.100: Apr 18, 2023 Changes in resources, assignments, exams, games, attendance events and surveys. (338875 lines)
Version 22.99: Apr 18, 2023 Code refactoring in rubrics. (339025 lines)
Version 22.98: Apr 17, 2023 Code refactoring in rubrics. (339062 lines)
Version 22.97: Apr 14, 2023 Changes in listing of rubrics. (339029 lines)
Version 22.96.1: Apr 14, 2023 Code refactoring in selectors. (338991 lines)
Version 22.96: Apr 12, 2023 Changes in configuration of projects.
Code refactoring in selectors. (338977 lines)
4 changes necessary in database:
ALTER TABLE prj_config CHANGE COLUMN Editable NETCanCreate ENUM('N','Y') NOT NULL DEFAULT 'Y';
ALTER TABLE prj_config ADD COLUMN RubTutCod INT NOT NULL DEFAULT -1 AFTER CrsCod;
ALTER TABLE prj_config ADD COLUMN RubEvlCod INT NOT NULL DEFAULT -1 AFTER RubTutCod;
ALTER TABLE prj_config ADD COLUMN RubGblCod INT NOT NULL DEFAULT -1 AFTER RubEvlCod;
Version 22.95: Apr 12, 2023 Changes in configuration of projects. (338602 lines)
Version 22.94: Apr 12, 2023 Code refactoring in rubrics.
Changes in configuration of projects. (338537 lines)
Version 22.93: Apr 10, 2023 Changes in configuration of projects. (338417 lines)
Version 22.92.3: Apr 06, 2023 Code refactoring in resources. (338493 lines)
Version 22.92.2: Apr 06, 2023 Code refactoring in resources. (338500 lines)
Version 22.92.1: Apr 06, 2023 Removed unused code in resources. (338514 lines)
Version 22.92: Apr 06, 2023 Code refactoring in resources. (339106 lines)
Version 22.91.1: Apr 06, 2023 SQL script used to create database updated. (338984 lines)
Version 22.91: Apr 06, 2023 Code refactoring in forums. (338928 lines)
3 changes necessary in database:
ALTER TABLE for_threads CHANGE COLUMN Location HieCod INT NOT NULL DEFAULT -1;
ALTER TABLE for_threads DROP INDEX Location;
ALTER TABLE for_threads ADD INDEX (HieCod);
Version 22.90.1: Apr 04, 2023 Code refactoring in resources. (338881 lines)
Version 22.90: Apr 04, 2023 Code refactoring checking user. (338807 lines)
Version 22.89.1: Apr 04, 2023 Code refactoring in projects configuration. (338622 lines)
Version 22.89: Apr 01, 2023 New module swad_project_config for projects configuration. (338613 lines)
Version 22.88: Mar 31, 2023 Code refactoring in resources. (338538 lines)
Version 22.87.1: Mar 31, 2023 Some messages translated. (338610 lines)
Version 22.87: Mar 30, 2023 Code refactoring in select forms. (338607 lines)
Version 22.86.3: Mar 30, 2023 Code refactoring in forms. (338710 lines)
Version 22.86.2: Mar 30, 2023 New links to manual about resource clipboard.
Fixed bugs in links to resources. (338655 lines)
Version 22.86.1: Mar 29, 2023 Icon to remove resource clipboard only if there are resources. (338596 lines)
Version 22.86: Mar 29, 2023 New actions to see and remove the resource clipboard in rubrics. (338578 lines)
Version 22.85.1: Mar 29, 2023 Code refactoring in links to update sections. (338447 lines)
Version 22.85: Mar 29, 2023 New action to remove the resource clipboard in program. (338449 lines)
Version 22.84: Mar 29, 2023 New action to see the resource clipboard in program. (338356 lines)
Copy the following icons to icon public directory:
sudo cp -a icon/clipboard-user.svg /var/www/html/swad/icon/
sudo cp -a icon/clipboard.svg /var/www/html/swad/icon/
sudo cp -a icon/clipboard-check.svg /var/www/html/swad/icon/
sudo cp -a icon/clipboard-question.svg /var/www/html/swad/icon/
sudo cp -a icon/clipboard-list.svg /var/www/html/swad/icon/
sudo cp -a icon/paste.svg /var/www/html/swad/icon/
sudo cp -a icon/iconset/awesome/clipboard-list.svg /var/www/html/swad/icon/iconset/awesome/
Version 22.83.5: Mar 28, 2023 Fixed bugs in rubrics and exams. (338235 lines)
Version 22.83.4: Mar 28, 2023 Code refactoring in rubrics and exams. (338221 lines)
Version 22.83.3: Mar 27, 2023 Changes in rubric criteria. (338218 lines)
Version 22.83.2: Mar 27, 2023 Changes in rubric criteria. (338189 lines)
Version 22.83.1: Mar 27, 2023 Changes in rubric criteria. (338297 lines)
Version 22.83: Mar 27, 2023 New module swad_resource_database. (338208 lines)
1 change necessary in database:
RENAME TABLE prg_clipboards TO rsc_clipboards;
Version 22.82: Mar 27, 2023 New module swad_rubric_resource. (338149 lines)
Version 22.81.2: Mar 27, 2023 Changes in resources. (337974 lines)
Version 22.81.1: Mar 26, 2023 Changes in resources. (338012 lines)
5 changes necessary in database:
ALTER TABLE prg_clipboards CHANGE COLUMN Type Type ENUM('non','asg','prj','cfe','exa','gam','rub','doc','mrk','att','for','svy') NOT NULL DEFAULT 'non';
ALTER TABLE prg_resources CHANGE COLUMN Type Type ENUM('non','asg','prj','cfe','exa','gam','rub','doc','mrk','att','for','svy') NOT NULL DEFAULT 'non';
ALTER TABLE rub_criteria ADD COLUMN Type ENUM('non','asg','prj','cfe','exa','gam','rub','doc','mrk','att','for','svy') NOT NULL DEFAULT 'non' AFTER CriInd;
ALTER TABLE rub_criteria DROP INDEX Source;
ALTER TABLE rub_criteria DROP COLUMN Source;
Version 22.81: Mar 26, 2023 New module swad_resource. (337946 lines)
Version 22.80: Mar 25, 2023 Resources in rubric criteria. Not finished. (338110 lines)
Version 22.79.3: Mar 24, 2023 Translation of some actions. (337938 lines)
Version 22.79.2: Mar 24, 2023 Code refactoring in rubrics. (337937 lines)
Version 22.79.1: Mar 24, 2023 Translation of some actions. (337889 lines)
Version 22.79: Mar 24, 2023 New action to change source of rubric criterion. (337888 lines)
Version 22.78.15: Mar 23, 2023 Changes in rubric criteria. (337686 lines)
Version 22.78.14: Mar 23, 2023 Code refactoring in timeline. (337634 lines)
Version 22.78.13: Mar 23, 2023 Code refactoring in rooms. (337641 lines)
Version 22.78.12: Mar 23, 2023 Code refactoring in plugins. (337651 lines)
Version 22.78.11: Mar 23, 2023 Code refactoring in places. (337652 lines)
Version 22.78.10: Mar 23, 2023 Code refactoring in notices. (337650 lines)
Version 22.78.9: Mar 23, 2023 Code refactoring in mail domains. (337657 lines)
Version 22.78.8: Mar 23, 2023 Code refactoring in holidays. (337648 lines)
Version 22.78.7: Mar 23, 2023 Code refactoring in exam sets. (337671 lines)
Version 22.78.6: Mar 23, 2023 Code refactoring in departments. (337691 lines)
Version 22.78.5: Mar 23, 2023 Code refactoring in buildings. (337696 lines)
Version 22.78.4: Mar 22, 2023 Code refactoring in file browser. (337693 lines)
Version 22.78.3: Mar 22, 2023 Code refactoring. (337767 lines)
Version 22.78.2: Mar 22, 2023 Code refactoring in attendance. (337779 lines)
Version 22.78.1: Mar 22, 2023 Code refactoring in exam sets and announcements. (337781 lines)
Version 22.78: Mar 22, 2023 New fields Source and Cod in rubric criteria. (337770 lines)
3 changes necessary in database:
ALTER TABLE rub_criteria ADD COLUMN Source ENUM('teacher','rubric','exam','game') NOT NULL DEFAULT 'teacher' AFTER CriInd;
ALTER TABLE rub_criteria ADD COLUMN Cod INT NOT NULL DEFAULT -1 AFTER Source;
ALTER TABLE rub_criteria ADD INDEX (Source,Cod);
Version 22.77: Mar 18, 2023 New field Weight in rubric criteria. (337735 lines)
1 change necessary in database:
ALTER TABLE rub_criteria ADD COLUMN Weight DOUBLE PRECISION NOT NULL DEFAULT 1 AFTER MaxVal;
Version 22.76: Mar 17, 2023 Fixed moving rubric criteria up and down. (337585 lines)
Version 22.75: Mar 17, 2023 New module swad_rubric_criteria. (337631 lines)
Code refactoring in exams.
2 changes necessary in database:
DROP TABLE IF EXISTS rub_criteria;
CREATE TABLE IF NOT EXISTS rub_criteria (CriCod INT NOT NULL AUTO_INCREMENT,RubCod INT NOT NULL,CriInd INT NOT NULL,MinVal DOUBLE PRECISION NOT NULL DEFAULT 0,MaxVal DOUBLE PRECISION NOT NULL DEFAULT 1,Title VARCHAR(2047) NOT NULL,UNIQUE INDEX(CriCod),UNIQUE INDEX(RubCod,CriInd));
If you want to use MyISAM:
ALTER TABLE rub_criteria ENGINE=MyISAM;
Version 22.74.2: Mar 10, 2023 Fixed bugs in exam sets. (336744 lines)
Version 22.74.1: Mar 10, 2023 Fixed links to help. (336741 lines)
Version 22.74: Mar 10, 2023 New module swad_parameter_code. (336740 lines)
Version 22.73.1: Mar 10, 2023 Code refactoring in parameters. (336657 lines)
Version 22.73: Mar 10, 2023 Code refactoring in parameters. (336668 lines)
Version 22.72: Mar 09, 2023 Code refactoring in parameters. Not finished. (336749 lines)
Version 22.71: Mar 08, 2023 Code refactoring in parameters. Not finished. (336806 lines)
Version 22.70: Mar 07, 2023 Code refactoring in parameters. Not finished. (336824 lines)
Version 22.69: Mar 07, 2023 Code refactoring in parameters. Not finished. (336866 lines)
Version 22.68: Mar 06, 2023 Code refactoring in parameters. Not finished. (336887 lines)
Version 22.67.1: Mar 06, 2023 Code refactoring in dates. (337124 lines)
Version 22.67: Mar 04, 2023 Code refactoring in parameters. Not finished. (337118 lines)
Version 22.66.4: Mar 04, 2023 Fixed issues in exams. (337245 lines)
Version 22.66.3: Mar 04, 2023 New action to edit a new rubric criterion. Not finished. (337198 lines)
Version 22.66.2: Mar 03, 2023 Fixed bugs in figures. (337128 lines)
Version 22.66.1: Mar 02, 2023 Rubric removal. (337126 lines)
Version 22.66: Mar 02, 2023 New module swad_rubric_criteria for rubric criteria. (337125 lines)
Version 22.65.1: Mar 02, 2023 Changes in rubrics. Not finished. (337012 lines)
Version 22.65: Mar 01, 2023 New module swad_rubric for rubrics. Not finished. (336989 lines)
2 changes necessary in database:
CREATE TABLE IF NOT EXISTS rub_rubrics (RubCod INT NOT NULL AUTO_INCREMENT,CrsCod INT NOT NULL DEFAULT -1,UsrCod INT NOT NULL,Title VARCHAR(2047) NOT NULL,Txt TEXT NOT NULL,UNIQUE INDEX(RubCod),INDEX(CrsCod));
CREATE TABLE IF NOT EXISTS rub_criteria (RubCod INT NOT NULL,CriInd INT NOT NULL,CriCod INT NOT NULL,UNIQUE INDEX(RubCod,CriInd),UNIQUE INDEX(RubCod,CriCod));
If you want to use MyISAM:
ALTER TABLE rub_rubrics ENGINE=MyISAM;
ALTER TABLE rub_criteria ENGINE=MyISAM;
Version 22.64: Feb 23, 2023 Surveys moved to analytics tab. (334217 lines)
Version 22.63: Feb 22, 2023 Assessment information moved to course tab. (334216 lines)
Version 22.62.2: Feb 22, 2023 Changed icon for question bank. (334165 lines)
Copy the following icons to icon public directory:
sudo cp icon/iconset/awesome/clipboard-question.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/nuvola/clipboard-question.png /var/www/html/swad/icon/iconset/nuvola/
Version 22.62.1: Feb 13, 2023 Fixed alignment in layout of messages. (334160 lines)
Version 22.62: Feb 10, 2023 User's code stored in fir_log table in order to avoid banning users who share the same IP. (334157 lines)
2 changes necessary in database:
ALTER TABLE fir_log ADD COLUMN UsrCod INT NOT NULL DEFAULT -1 AFTER IP,ADD INDEX (UsrCod);
DELETE FROM fir_log;
Version 22.61: Feb 08, 2023 Fixed bug in figures about hierarchy. (334142 lines)
Version 22.60: Nov 29, 2022 Fixed bug sending notification emails. Reported by Manuel Rodríguez Álvarez and Eva Martínez Ortigosa. (334114 lines)
Version 22.59.1: Nov 23, 2022 Fixed bug in file browser. Reported by Javier Fernández Baldomero. (334070 lines)
Version 22.59: Nov 06, 2022 New module swad_browser_size. (334067 lines)
Version 22.58: Nov 06, 2022 New module swad_action_list for list of actions. (333958 lines)
Version 22.57.1: Oct 29, 2022 Change in layout of heading title. (333789 lines)
Version 22.57: Oct 29, 2022 Code refactoring in search. (333762 lines)
Version 22.56: Oct 29, 2022 Code refactoring in user record. (333696 lines)
Version 22.55: Oct 28, 2022 Code refactoring in degree types. (333694 lines)
Version 22.54: Oct 28, 2022 Code refactoring and bug fixing in institutional links. (333614 lines)
Version 22.53: Oct 28, 2022 Code refactoring in mail domains. (333607 lines)
Version 22.52: Oct 28, 2022 Code refactoring in plugins. (333589 lines)
Version 22.51: Oct 27, 2022 New module swad_process. (333586 lines)
Version 22.50.8: Oct 20, 2022 Code refactoring in files. (333498 lines)
Version 22.50.7: Oct 20, 2022 Code refactoring in files. (333496 lines)
Version 22.50.6: Oct 20, 2022 Code refactoring in syllabus. (333492 lines)
Version 22.50.5: Oct 20, 2022 Code refactoring in configuration. (333447 lines)
Version 22.50.4: Oct 20, 2022 Code refactoring in email sending. (333438 lines)
Version 22.50.3: Oct 19, 2022 Fixed bug in keys when playing matches. (333456 lines)
Version 22.50.2: Oct 19, 2022 Code refactoring related to dates. (333456 lines)
Version 22.50.1: Oct 19, 2022 Code refactoring related to dates. (333332 lines)
Version 22.50: Oct 19, 2022 Code refactoring related to dates. (333318 lines)
Version 22.49.9: Oct 18, 2022 Code refactoring related to XML. (333257 lines)
Version 22.49.8: Oct 18, 2022 Code refactoring related to parameters. (333253 lines)
Version 22.49.7: Oct 18, 2022 Code refactoring related to database. (333218 lines)
Version 22.49.6: Oct 18, 2022 Code refactoring related to alerts. (333197 lines)
Version 22.49.5: Oct 18, 2022 Code refactoring related to boxes. (333190 lines)
Version 22.49.4: Oct 18, 2022 Lighter background colors in tables.
Changes in responsive layout. (333187 lines)
Version 22.49.3: Oct 18, 2022 Code refactoring related to parameters. (333213 lines)
Version 22.49.2: Oct 18, 2022 Code refactoring related to forms. (333189 lines)
Version 22.49.1: Oct 17, 2022 Fixed bug filtering projects. (333176 lines)
Version 22.49: Oct 16, 2022 Changes in project review form. (333161 lines)
Version 22.48: Oct 15, 2022 Code optimization related to nick links. (333157 lines)
Version 22.47.2: Oct 15, 2022 Code optimization related to forms. (333124 lines)
Version 22.47.1: Oct 15, 2022 Removed unused code. (333126 lines)
Version 22.47: Oct 15, 2022 Code optimization related to forms. (333227 lines)
Version 22.46.3: Oct 15, 2022 Code refactoring submiting forms. (333211 lines)
Version 22.46.2: Oct 14, 2022 Changes in anchors behavior in project listing. (333228 lines)
Version 22.46.1: Oct 14, 2022 Fixed bug filtering projects by department. (333227 lines)
Version 22.46: Oct 13, 2022 Review of projects. (333219 lines)
Version 22.45: Oct 13, 2022 Review of projects (not finished). (333137 lines)
Version 22.44.3: Oct 12, 2022 Code refactoring in projects. (333015 lines)
Version 22.44.2: Oct 12, 2022 Code refactoring in projects. (333001 lines)
Version 22.44.1: Oct 12, 2022 Code refactoring in projects. (332985 lines)
Version 22.44: Oct 12, 2022 Code refactoring in projects. (332980 lines)
Version 22.43.2: Oct 12, 2022 Code refactoring in projects. (332984 lines)
Version 22.43.1: Oct 12, 2022 Code refactoring in projects. (332952 lines)
Version 22.43: Oct 11, 2022 Review of projects (not finished). (332930 lines)
Version 22.42: Oct 11, 2022 Review of projects (not finished). (332738 lines)
3 changes necessary in database:
ALTER TABLE prj_projects ADD COLUMN ReviewStatus ENUM('unreviewed','unapproved','approved') NOT NULL DEFAULT 'unreviewed' AFTER URL,ADD INDEX (CrsCod,ReviewStatus);
ALTER TABLE prj_projects ADD COLUMN ReviewTime DATETIME NOT NULL DEFAULT '1970-01-01 01:00:00' AFTER ReviewStatus;
ALTER TABLE prj_projects ADD COLUMN ReviewTxt TEXT NOT NULL AFTER ReviewTime;
Copy the following icons to icon public directory:
sudo cp icon/comment-slash.svg /var/www/html/swad/icon/
sudo cp icon/file-circle-check.svg /var/www/html/swad/icon/
sudo cp icon/file-circle-exclamation.svg /var/www/html/swad/icon/
sudo cp icon/file-circle-question.svg /var/www/html/swad/icon/
sudo cp icon/filter-circle-xmark.svg /var/www/html/swad/icon/
sudo cp icon/thumbs-down.svg /var/www/html/swad/icon/
sudo cp icon/thumbs-up.svg /var/www/html/swad/icon/
Version 22.41.1: Oct 07, 2022 Fixed issue in main title. (332512 lines)
Version 22.41: Oct 06, 2022 Changes in the behavior of the expansion/contraction of program items. (332511 lines)
Version 22.40: Oct 04, 2022 Link in main title. (332514 lines)
Version 22.39.5: Oct 03, 2022 Fixed bug in edition of course program. (332513 lines)
Version 22.39.4: Oct 03, 2022 Fixed layout issues in projects. (332515 lines)
Version 22.39.3: Oct 03, 2022 Code refactoring in attendance events. (332519 lines)
Version 22.39.2: Oct 03, 2022 Changes in dialog to reset an attendance event. (332520 lines)
Version 22.39.1: Oct 03, 2022 Changes in dialog to reset a survey. (332527 lines)
Version 22.39: Oct 02, 2022 Code refactoring and changes in layout of attendance events. (332537 lines)
Version 22.38: Oct 02, 2022 Code refactoring and changes in layout of surveys. (332518 lines)
Version 22.37.2: Oct 01, 2022 Fixed minor issues in layout. (332526 lines)
Version 22.37.1: Oct 01, 2022 Fixed issues in exams and games. (332525 lines)
Version 22.37: Oct 01, 2022 Code refactoring and changes in layout of games. (? lines)
Version 22.36.1: Sep 30, 2022 Changes in layout of exams. (332596 lines)
Version 22.36: Sep 30, 2022 Code refactoring in exams. (332589 lines)
Version 22.35: Sep 30, 2022 Changes in layout of projects. (332690 lines)
Version 22.34: Sep 29, 2022 Changes in layout of assignments. (332721 lines)
Version 22.33.4: Sep 29, 2022 Code refactoring in program resources. (332711 lines)
Version 22.33.3: Sep 29, 2022 Fixed layout of marks file metadata. (332709 lines)
Version 22.33.2: Sep 29, 2022 Changes in program resources and course forums. (332708 lines)
Version 22.33.1: Sep 29, 2022 Changes in program resources and attendance events. (332687 lines)
Version 22.33: Sep 29, 2022 Changes in program resources, documents and mark files. (332683 lines)
Version 22.32.4: Sep 29, 2022 Changes in program resources and surveys. (332650 lines)
Version 22.32.3: Sep 29, 2022 Changes in program resources and games. (332642 lines)
Version 22.32.2: Sep 29, 2022 Changes in program resources and exams. (332637 lines)
Version 22.32.1: Sep 29, 2022 Changes in program resources and calls for exams. (332635 lines)
Version 22.32: Sep 29, 2022 Changes in program resources, assignments and projects. (332628 lines)
Version 22.31: Sep 28, 2022 New action to view one project.
Code refactoring in program resources. (332570 lines)
Version 22.30: Sep 28, 2022 New module swad_project_resource. (332490 lines)
2 changes necessary in database:
ALTER TABLE prg_clipboards CHANGE COLUMN Type Type ENUM('non','asg','prj','cfe','exa','gam','svy','doc','mrk','att','for') NOT NULL DEFAULT 'non';
ALTER TABLE prg_resources CHANGE COLUMN Type Type ENUM('non','asg','prj','cfe','exa','gam','svy','doc','mrk','att','for') NOT NULL DEFAULT 'non';
Copy the following icon to icon public directory:
sudo cp icon/file-invoice.svg /var/www/html/swad/icon/
Version 22.29: Sep 24, 2022 New module swad_forum_resource. (332274 lines)
Version 22.28: Sep 24, 2022 New module swad_attendance_resource. (332236 lines)
Version 22.27: Sep 24, 2022 New module swad_browser_resource. (332157 lines)
Version 22.26: Sep 23, 2022 New module swad_survey_resource. (332095 lines)
Version 22.25: Sep 23, 2022 New module swad_game_resource. (332037 lines)
Version 22.24: Sep 23, 2022 New module swad_exam_resource. (331980 lines)
Version 22.23: Sep 23, 2022 New module swad_call_for_exam_resource. (331924 lines)
Version 22.22.1: Sep 23, 2022 Changes in layout of course program. (331875 lines)
Version 22.22: Sep 23, 2022 Course program open to teachers and students. (331856 lines)
Version 22.21: Sep 22, 2022 Changes in layout of course program. (331855 lines)
Version 22.20: Sep 22, 2022 Hidden items are not shown in program. (331838 lines)
Copy the following icon to icon public directory:
sudo cp icon/check-circle.svg /var/www/html/swad/icon/
Version 22.19: Sep 22, 2022 Fixed bugs in program. (331843 lines)
Version 22.18: Sep 22, 2022 Expand/contract program items. (331877 lines)
1 change necessary in database:
CREATE TABLE IF NOT EXISTS prg_expanded (UsrCod INT NOT NULL,ItmCod INT NOT NULL,ClickTime DATETIME NOT NULL,UNIQUE INDEX(UsrCod,ItmCod),INDEX(ItmCod),INDEX(ClickTime));
If you want to use MyISAM:
ALTER TABLE prg_expanded ENGINE=MyISAM;
Version 22.17: Sep 21, 2022 New module swad_assignment_resource. (331524 lines)
Version 22.16.1: Sep 21, 2022 Changes in program layout. (331462 lines)
Version 22.16: Sep 21, 2022 Changes in program layout. (331455 lines)
Version 22.15: Sep 21, 2022 Links to assignments in program. (331442 lines)
Version 22.14: Sep 21, 2022 An assignment is shown when clicking on its title. (331300 lines)
Version 22.13: Sep 20, 2022 Links to course forum threads in program. (331234 lines)
Version 22.12.3: Sep 20, 2022 Fixed bug in JavaScript related to dates. (331098 lines)
Version 22.12.2: Sep 20, 2022 Changes in behaviour of program items. (331097 lines)
Version 22.12.1: Sep 20, 2022 Changes in behaviour of program items. (331015 lines)
Version 22.12: Sep 20, 2022 Links to marks file in program. (330985 lines)
Copy the following icon to icon public directory:
sudo cp icon/list-alt.svg /var/www/html/swad/icon/
Version 22.11: Sep 20, 2022 Links to attendance events in program. (330907 lines)
Version 22.10.1: Sep 19, 2022 Code refactoring in program. (330789 lines)
Version 22.10: Sep 19, 2022 Links to surveys in program. (330822 lines)
Version 22.9.1: Sep 19, 2022 Text for icons in program. (330725 lines)
Version 22.9: Sep 19, 2022 Links to exams in program. (330491 lines)
Version 22.8: Sep 18, 2022 Links to games in program. (330355 lines)
Version 22.7: Sep 18, 2022 Links to calls for exams in program.
Notification of a call for exam now links to the call. (330230 lines)
Version 22.6: Sep 17, 2022 Changes in edition of program items. (330065 lines)
Version 22.5: Sep 16, 2022 Links to download documents in program. (330018 lines)
Version 22.4.2: Sep 16, 2022 Changes in edition of program items. (329982 lines)
Version 22.4.1: Sep 15, 2022 Changes in edition of program items. (329955 lines)
Copy the following icon to icon public directory:
sudo cp icon/link.svg /var/www/html/swad/icon/
Version 22.4: Sep 15, 2022 Changes in edition of program items. (329940 lines)
Version 22.3: Sep 14, 2022 Listing program resource clipboard. (329918 lines)
4 changes necessary in database:
ALTER TABLE prg_clipboards CHANGE COLUMN Type Type ENUM('non','asg','cfe','exa','gam','svy','doc','mrk','att','for') NOT NULL DEFAULT 'non';
ALTER TABLE prg_resources DROP COLUMN Type;
ALTER TABLE prg_resources ADD COLUMN Type ENUM('non','asg','cfe','exa','gam','svy','doc','mrk','att','for') NOT NULL DEFAULT 'non' AFTER Hidden;
ALTER TABLE prg_resources ADD COLUMN Cod INT NOT NULL DEFAULT -1 AFTER Type;
Copy the following icon to icon public directory:
sudo cp icon/link-slash.svg /var/www/html/swad/icon/
Version 22.2: Sep 13, 2022 Code refactoring in program resources. (329795 lines)
Version 22.1: Sep 13, 2022 Code refactoring in program resources. (329693 lines)
Version 22.0: Sep 12, 2022 New action to change resource link. Not implemented. (329606 lines)
Version 21.117.1: Sep 12, 2022 Copy link to file into resource clipboard. (329561 lines)
Version 21.117: Sep 12, 2022 New database table with clipboards for program resources.
New actions to get link to file in course document area. (329514 lines)
2 changes necessary in database:
ALTER TABLE prg_resources ADD COLUMN Type ENUM('none','asg','cfe','exa','gam','svy','doc','mrk','att','for') NOT NULL DEFAULT 'none' AFTER Hidden;
CREATE TABLE IF NOT EXISTS prg_clipboards (UsrCod INT NOT NULL,CrsCod INT NOT NULL,Type ENUM('none','asg','cfe','exa','gam','svy','doc','mrk','att','for') NOT NULL DEFAULT 'none',Cod INT NOT NULL DEFAULT -1,CopyTime TIMESTAMP,UNIQUE INDEX(UsrCod,CrsCod,Type,Cod),INDEX(CrsCod,Type,Cod),INDEX(CopyTime));
If you want to use MyISAM:
ALTER TABLE prg_clipboards ENGINE=MyISAM;
Version 21.116.3: Sep 10, 2022 Changed icon for external link. (329241 lines)
Copy the following icons to icon public directory:
sudo cp icon/up-right-from-square.svg /var/www/html/swad/icon/
sudo cp icon/iconset/awesome/up-right-from-square.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/nuvola/up-right-from-square.svg /var/www/html/swad/icon/iconset/nuvola/
sudo cp icon/iconset/nuvola/globe-americas.svg /var/www/html/swad/icon/iconset/nuvola/
Version 21.116.2: Sep 09, 2022 Fixed bug in timetable. Reported by Javier Fernández Baldomero and José Luis Bernier Villamor. (329208 lines)
If you want to use MyISAM:
ALTER TABLE prg_resources ENGINE=MyISAM;
Version 21.116.1: Sep 08, 2022 Fixed bug updating institution status. (329215 lines)
Version 21.116: Sep 02, 2022 Code refactoring in edition of program items. (329214 lines)
Version 21.115: Sep 01, 2022 Code refactoring in edition of program items. (329212 lines)
Version 21.114.1: Jul 25, 2022 Fixed bug removing an item resource. (329264 lines)
Version 21.114: Jul 25, 2022 New form and action to create item resource. (329258 lines)
Version 21.113: Jul 22, 2022 New form and action to rename item resource. (329151 lines)
Version 21.112.1: Jul 22, 2022 Changes in edition of program items. (329058 lines)
Version 21.112: Jul 21, 2022 Code refactoring in hide/unhide icons.
Fixed bugs in edition of banners.
Fixed bug hidding/unhiding exam sessions.
Fixed bug in notices.
Code refactoring in surveys. (329064 lines)
Version 21.111: Jul 21, 2022 Changes in edition of program items. (329115 lines)
Version 21.110: Jul 19, 2022 Changes in edition of program items. (329031 lines)
Version 21.109: Jul 19, 2022 Changes in edition of program items. (328975 lines)
Version 21.108: Jul 18, 2022 Changes in edition of program items. (328908 lines)
Version 21.107.1: Jul 17, 2022 Changes in layout of resources of program item. (? lines)
Version 21.107: Jul 15, 2022 Move up/down resource of program item. (328953 lines)
Version 21.106: Jul 14, 2022 Hide/unhide resource of program item. (328816 lines)
Version 21.105: Jul 14, 2022 Removing resource from program item. (328617 lines)
Version 21.104.1: Jul 13, 2022 Adding resources to program items. (328504 lines)
Version 21.104: Jul 12, 2022 Adding resources to program items. (328263 lines)
1 change necessary in database:
CREATE TABLE IF NOT EXISTS prg_resources (RscCod INT NOT NULL AUTO_INCREMENT,ItmCod INT NOT NULL DEFAULT -1,RscInd INT NOT NULL DEFAULT 0,Hidden ENUM('N','Y') NOT NULL DEFAULT 'N',Title VARCHAR(2047) NOT NULL,UNIQUE INDEX(RscCod),UNIQUE INDEX(ItmCod,RscInd));
Version 21.103.6: Jul 01, 2022 Fixed issues in matches. (327737 lines)
Version 21.103.5: Jun 30, 2022 Code refactoring in icons. (327727 lines)
Version 21.103.4: Jun 30, 2022 Code refactoring in icons. (327968 lines)
Version 21.103.3: Jun 30, 2022 Code refactoring in icons. (328131 lines)
Version 21.103.2: Jun 30, 2022 Preparation for Turkish translation. (328306 lines)
Version 21.103.1: Jun 29, 2022 Code refactoring in icons. (328305 lines)
Version 21.103: Jun 29, 2022 Text in buttons got from text of actions.
Preparation for Turkish translation. (328476 lines)
Version 21.102.1: Jun 28, 2022 Text in buttons got from text of actions.
Preparation for Turkish translation. (329296 lines)
Version 21.102: Jun 28, 2022 Subtitles in menus is got from text of actions. (329462 lines)
Version 21.101: Jun 28, 2022 Preparation for Turkish translation. (331564 lines)
Version 21.100.1: Jun 24, 2022 Some messages translated to Turkish. (331273 lines)
Version 21.100: Jun 23, 2022 Changes in calendar.
Some messages translated. (331107 lines)
Version 21.99.1: Jun 23, 2022 Some messages translated. (331260 lines)
Version 21.99: Jun 22, 2022 New language: Turkish. (331259 lines)
2 changes necessary in database:
ALTER TABLE cty_countrs ADD COLUMN Name_tr VARCHAR(767) NOT NULL AFTER Name_pt,ADD INDEX (Name_tr);
ALTER TABLE cty_countrs ADD COLUMN WWW_tr VARCHAR(255) NOT NULL AFTER WWW_pt;
Add Turkish language to Apache config files
Add Turkish language to swad_copy.sh
Version 21.98.6: Jun 21, 2022 Some messages translated. (322554 lines)
Version 21.98.5: Jun 21, 2022 Some messages translated. (322554 lines)
Version 21.98.4: Jun 21, 2022 Some messages translated. (322555 lines)
Version 21.98.3: Jun 20, 2022 Some messages translated. (322537 lines)
Version 21.98.2: Jun 19, 2022 Some messages translated. (322482 lines)
Version 21.98.1: Jun 18, 2022 Some messages translated. (322481 lines)
Version 21.98: Jun 18, 2022 Some messages translated. (322489 lines)
Version 21.97.6: Jun 15, 2022 Some messages translated. (323162 lines)
Version 21.97.5: Jun 15, 2022 Some messages translated. (323161 lines)
Version 21.97.4: Jun 08, 2022 Fixed bug in JavaScript when getting new timeline. (? lines)
Version 21.97.3: Jun 07, 2022 Fixed bug in JavaScript when getting old timeline. (323163 lines)
Version 21.97.2: Jun 02, 2022 Fixed bug in surveys. (323168 lines)
Version 21.97.1: May 30, 2022 Fixing design of dark theme. (323166 lines)
Version 21.97: May 25, 2022 Code refactoring in timeline. (? lines)
Version 21.96.7: May 19, 2022 Fixed bug in places. (323157 lines)
Version 21.96.6: May 18, 2022 Some messages translated. (323156 lines)
Version 21.96.5: May 17, 2022 Some messages translated. (323160 lines)
Version 21.96.4: May 16, 2022 Some messages translated. (323159 lines)
Version 21.96.3: May 16, 2022 Some messages translated. (323158 lines)
Version 21.96.2: May 14, 2022 Some messages translated. (323169 lines)
Version 21.96.1: May 14, 2022 Some messages translated. (323168 lines)
Version 21.96: May 13, 2022 Lot of messages translated. (323165 lines)
Version 21.95.8: May 12, 2022 Some messages translated. (323155 lines)
Version 21.95.7: May 12, 2022 Changes in translation. (323154 lines)
Version 21.95.6: May 12, 2022 Fixing design of dark theme. (323509 lines)
Version 21.95.5: May 12, 2022 Some messages translated.
Fixing design of dark theme. (323506 lines)
Copy the following icons to icon public directory:
sudo cp icon/y30x1.png /var/www/html/swad/icon/
sudo cp icon/y30x30.png /var/www/html/swad/icon/
sudo cp icon/y30x60.png /var/www/html/swad/icon/
Version 21.95.4: May 12, 2022 SWADroid image updated. (323445 lines)
Copy the following icon to icon public directory:
sudo cp icon/SWADroid300x650.png /var/www/html/swad/icon/
Version 21.95.3: May 09, 2022 Fixed bug inserting automatic links. Reported by Javier Fernández Baldomero and others. (323439 lines)
Version 21.95.2: Apr 30, 2022 Fixed issue in most frequent actions. Reported by Pablo Millán Cubero. (323423 lines)
Version 21.95.1: Apr 27, 2022 Fixing design of dark theme. (323406 lines)
Version 21.95: Apr 27, 2022 Fixing design of dark theme. (323404 lines)
Version 21.94.3: Apr 25, 2022 Fixing design of dark theme. (323402 lines)
Version 21.94.2: Apr 25, 2022 Fixed bug in pagination. Reported by Javier Fernández Baldomero. (323400 lines)
Version 21.94.1: Apr 25, 2022 Bugs related to dark theme fixed. (323399 lines)
Version 21.94: Apr 25, 2022 Working on design of dark theme.
Dark theme in production. (323458 lines)
Version 21.93.8: Apr 25, 2022 Added m.youtube.com. Suggested by Javier Fernández Baldomero. (323455 lines)
Version 21.93.7: Apr 25, 2022 Working on design of dark theme. (323432 lines)
Version 21.93.6: Apr 25, 2022 Working on design of dark theme. (323358 lines)
Copy the following icons to icon public directory:
sudo cp icon/info-circle-blue.svg /var/www/html/swad/icon/
sudo cp icon/check-circle-green.svg /var/www/html/swad/icon/
Version 21.93.5: Apr 23, 2022 Working on design of dark theme. (323346 lines)
Version 21.93.4: Apr 22, 2022 Working on design of dark theme. (323313 lines)
Version 21.93.3: Apr 22, 2022 Working on design of dark theme. (323259 lines)
Version 21.93.2: Apr 22, 2022 Working on design of dark theme. (323277 lines)
Version 21.93.1: Apr 21, 2022 Working on design of dark theme. (323269 lines)
Version 21.93: Apr 21, 2022 Homogenization of lists in forums, chat and my courses. (323245 lines)
Version 21.92: Apr 20, 2022 Default theme is white when printing. (323246 lines)
Version 21.91.6: Apr 07, 2022 Working on design of dark theme. (323347 lines)
Version 21.91.5: Apr 07, 2022 Working on design of dark theme. (323314 lines)
Version 21.91.4: Apr 05, 2022 Working on design of dark theme. (323247 lines)
Version 21.91.3: Apr 05, 2022 Changes in syllabus. (323227 lines)
Version 21.91.2: Apr 05, 2022 Working on design of dark theme. (323232 lines)
Version 21.91.1: Apr 05, 2022 Working on design of dark theme. (323232 lines)
Version 21.91: Apr 05, 2022 Working on design of dark theme. (323235 lines)
Version 21.90: Apr 01, 2022 Working on design of dark theme. (323707 lines)
Version 21.89: Mar 31, 2022 Working on design of dark theme. (323736 lines)
Version 21.88: Mar 31, 2022 Working on design of dark theme. (323802 lines)
Version 21.87.1: Mar 30, 2022 Working on design of dark theme. (323786 lines)
Version 21.87: Mar 30, 2022 Working on design of dark theme. (323833 lines)
Version 21.86.8: Mar 29, 2022 Working on design of dark theme. (323834 lines)
Version 21.86.7: Mar 28, 2022 Working on design of dark theme. (323823 lines)
Version 21.86.6: Mar 26, 2022 Working on design of dark theme. (323751 lines)
Version 21.86.5: Mar 26, 2022 Working on design of dark theme. (323750 lines)
Version 21.86.4: Mar 26, 2022 Working on design of dark theme. (323737 lines)
Version 21.86.3: Mar 25, 2022 Working on design of dark theme. (323709 lines)
Version 21.86.2: Mar 25, 2022 Working on design of dark theme. (323687 lines)
Version 21.86.1: Mar 25, 2022 Working on design of dark theme. (323687 lines)
Version 21.86: Mar 25, 2022 Working on design of dark theme. (323663 lines)
Version 21.85.1: Mar 24, 2022 Working on design of dark theme. (323724 lines)
Version 21.85: Mar 24, 2022 Working on design of dark theme. (323634 lines)
Version 21.84: Mar 19, 2022 Code refactoring on row colors. (323626 lines)
Version 21.83.8: Mar 16, 2022 Working on design of dark theme. (323610 lines)
Version 21.83.7: Mar 16, 2022 Code refactoring in forms (input image). (323585 lines)
Version 21.83.6: Mar 15, 2022 Working on design of dark theme. (323581 lines)
Version 21.83.5: Mar 15, 2022 Working on design of dark theme. (323559 lines)
Version 21.83.4: Mar 11, 2022 Code refactoring in timetable. (323543 lines)
Version 21.83.3: Mar 10, 2022 Code refactoring in timetable. (323527 lines)
Version 21.83.2: Mar 10, 2022 Working on design of dark theme. (323488 lines)
Copy the following icon to icon public directory:
sudo cp icon/theme/dark/theme_32x20.gif /var/www/html/swad/icon/theme/dark/
Version 21.83.1: Jan 10, 2022 Working on design of dark theme. (322887 lines)
Version 21.83: Jan 09, 2022 Working on design of dark theme. (322857 lines)
Version 21.82: Jan 03, 2022 Functions moved from swad_figure to other modules. (322550 lines)
Version 21.81.2: Jan 02, 2022 Functions moved from swad_figure to other modules. (322523 lines)
Version 21.81.1: Jan 02, 2022 Fixed bug in projects. (322460 lines)
Version 21.81: Jan 02, 2022 Code refactoring on table heads. (322457 lines)
Version 21.80: Jan 01, 2022 Working on design of dark theme. (322456 lines)
Version 21.79: Dec 31, 2021 Working on design of dark theme. (322466 lines)
Version 21.78.3: Dec 30, 2021 Working on design of dark theme. (322440 lines)
Version 21.78.2: Dec 30, 2021 Working on design of dark theme. (322393 lines)
Version 21.78.1: Dec 30, 2021 Working on design of dark theme. (322358 lines)
Version 21.78: Dec 30, 2021 Changing Str_BuildString for asprintf. (322358 lines)
Version 21.77.3: Dec 29, 2021 Changing Str_BuildString for asprintf. (322287 lines)
Version 21.77.2: Dec 29, 2021 Changing Str_BuildString for asprintf. (322199 lines)
Version 21.77.1: Dec 29, 2021 Working on design of dark theme. (322161 lines)
Version 21.77: Dec 29, 2021 Animated recycle icon is changed by static icon. (322250 lines)
Version 21.76.5: Dec 29, 2021 Working on design of dark theme. (322313 lines)
Version 21.76.4: Dec 28, 2021 Working on design of dark theme. (322306 lines)
Version 21.76.3: Dec 28, 2021 Working on design of dark theme. (322293 lines)
Version 21.76.2: Dec 27, 2021 Working on design of dark theme. (322282 lines)
Copy the following icons to icon public directory:
sudo cp icon/first-day-of-week-0.png /var/www/html/swad/icon/
sudo cp icon/first-day-of-week-6.png /var/www/html/swad/icon/
Version 21.76.1: Dec 27, 2021 Working on design of dark theme. (322283 lines)
Version 21.76: Dec 27, 2021 Code refactoring related to themes. (322302 lines)
Version 21.75.1: Dec 26, 2021 Fixed bug in icons. (322479 lines)
Version 21.75: Dec 26, 2021 Code refactoring related to links. (322477 lines)
Version 21.74: Dec 26, 2021 Working on design of dark theme.
Code refactoring related to links. (322483 lines)
Version 21.73.1: Dec 23, 2021 Changes in notice/announcement colors. (322516 lines)
Version 21.73: Dec 23, 2021 Working on design of dark theme. (322591 lines)
Copy the following icons to icon public directory:
sudo cp icon/first-day-of-week-0.png /var/www/html/swad/icon/
sudo cp icon/first-day-of-week-6.png /var/www/html/swad/icon/
sudo cp icon/edmodo64x64.png /var/www/html/swad/icon/
sudo cp icon/gnusocial64x64.png /var/www/html/swad/icon/
sudo cp icon/identica64x64.png /var/www/html/swad/icon/
sudo cp icon/orcid64x64.png /var/www/html/swad/icon/
sudo cp icon/paperli64x64.png /var/www/html/swad/icon/
sudo cp icon/researcherid64x64.png /var/www/html/swad/icon/
sudo cp icon/scoopit64x64.png /var/www/html/swad/icon/
sudo cp icon/storify64x64.png /var/www/html/swad/icon/
Version 21.72.1: Dec 22, 2021 Working on design of dark theme. (322622 lines)
Version 21.72: Dec 21, 2021 Working on design of dark theme. (322560 lines)
Copy the following icons to icon public directory:
sudo cp icon/500px-brands.svg /var/www/html/swad/icon/
sudo cp icon/address-card.svg /var/www/html/swad/icon/
sudo cp icon/angle-down.svg /var/www/html/swad/icon/
sudo cp icon/angle-up.svg /var/www/html/swad/icon/
sudo cp icon/arrow-down.svg /var/www/html/swad/icon/
sudo cp icon/arrow-left.svg /var/www/html/swad/icon/
sudo cp icon/arrow-right.svg /var/www/html/swad/icon/
sudo cp icon/arrow-up.svg /var/www/html/swad/icon/
sudo cp icon/at.svg /var/www/html/swad/icon/
sudo cp icon/bell.svg /var/www/html/swad/icon/
sudo cp icon/bolt.svg /var/www/html/swad/icon/
sudo cp icon/book.svg /var/www/html/swad/icon/
sudo cp icon/building.svg /var/www/html/swad/icon/
sudo cp icon/bullhorn.svg /var/www/html/swad/icon/
sudo cp icon/calendar.svg /var/www/html/swad/icon/
sudo cp icon/calendar-check.svg /var/www/html/swad/icon/
sudo cp icon/calendar-day.svg /var/www/html/swad/icon/
sudo cp icon/calendar-minus.svg /var/www/html/swad/icon/
sudo cp icon/calendar-plus.svg /var/www/html/swad/icon/
sudo cp icon/camera.svg /var/www/html/swad/icon/
sudo cp icon/car.svg /var/www/html/swad/icon/
sudo cp icon/caret-down.svg /var/www/html/swad/icon/
sudo cp icon/caret-right.svg /var/www/html/swad/icon/
sudo cp icon/chalkboard.svg /var/www/html/swad/icon/
sudo cp icon/chalkboard-teacher.svg /var/www/html/swad/icon/
sudo cp icon/chart-line.svg /var/www/html/swad/icon/
sudo cp icon/chart-pie.svg /var/www/html/swad/icon/
sudo cp icon/check.svg /var/www/html/swad/icon/
sudo cp icon/check-circle.svg /var/www/html/swad/icon/
sudo cp icon/check-circle-regular.svg /var/www/html/swad/icon/
sudo cp icon/child.svg /var/www/html/swad/icon/
sudo cp icon/clipboard.svg /var/www/html/swad/icon/
sudo cp icon/clipboard-list.svg /var/www/html/swad/icon/
sudo cp icon/clock.svg /var/www/html/swad/icon/
sudo cp icon/cloud-sun.svg /var/www/html/swad/icon/
sudo cp icon/code.svg /var/www/html/swad/icon/
sudo cp icon/coffee.svg /var/www/html/swad/icon/
sudo cp icon/cog.svg /var/www/html/swad/icon/
sudo cp icon/comment-dots.svg /var/www/html/swad/icon/
sudo cp icon/comment-regular.svg /var/www/html/swad/icon/
sudo cp icon/comments.svg /var/www/html/swad/icon/
sudo cp icon/concierge-bell.svg /var/www/html/swad/icon/
sudo cp icon/copy.svg /var/www/html/swad/icon/
sudo cp icon/cut.svg /var/www/html/swad/icon/
sudo cp icon/delicious-brands.svg /var/www/html/swad/icon/
sudo cp icon/deviantart-brands.svg /var/www/html/swad/icon/
sudo cp icon/diaspora-brands.svg /var/www/html/swad/icon/
sudo cp icon/dolly.svg /var/www/html/swad/icon/
sudo cp icon/door-closed.svg /var/www/html/swad/icon/
sudo cp icon/door-open.svg /var/www/html/swad/icon/
sudo cp icon/download.svg /var/www/html/swad/icon/
sudo cp icon/dumbbell.svg /var/www/html/swad/icon/
sudo cp icon/edit.svg /var/www/html/swad/icon/
sudo cp icon/ellipsis-h.svg /var/www/html/swad/icon/
sudo cp icon/ellipsis-v.svg /var/www/html/swad/icon/
sudo cp icon/envelope.svg /var/www/html/swad/icon/
sudo cp icon/envelope-open-text.svg /var/www/html/swad/icon/
sudo cp icon/exclamation-triangle.svg /var/www/html/swad/icon/
sudo cp icon/expand-arrows-alt.svg /var/www/html/swad/icon/
sudo cp icon/eye.svg /var/www/html/swad/icon/
sudo cp icon/eye-slash.svg /var/www/html/swad/icon/
sudo cp icon/facebook-brands.svg /var/www/html/swad/icon/
sudo cp icon/file.svg /var/www/html/swad/icon/
sudo cp icon/file-alt.svg /var/www/html/swad/icon/
sudo cp icon/file-export.svg /var/www/html/swad/icon/
sudo cp icon/file-import.svg /var/www/html/swad/icon/
sudo cp icon/file-signature.svg /var/www/html/swad/icon/
sudo cp icon/flag.svg /var/www/html/swad/icon/
sudo cp icon/flag-checkered.svg /var/www/html/swad/icon/
sudo cp icon/flask.svg /var/www/html/swad/icon/
sudo cp icon/flickr-brands.svg /var/www/html/swad/icon/
sudo cp icon/folder.svg /var/www/html/swad/icon/
sudo cp icon/folder-open.svg /var/www/html/swad/icon/
sudo cp icon/foursquare-brands.svg /var/www/html/swad/icon/
sudo cp icon/gamepad.svg /var/www/html/swad/icon/
sudo cp icon/github-brands.svg /var/www/html/swad/icon/
sudo cp icon/globe-americas.svg /var/www/html/swad/icon/
sudo cp icon/google-plus-brands.svg /var/www/html/swad/icon/
sudo cp icon/googlescholar-brands.svg /var/www/html/swad/icon/
sudo cp icon/graduation-cap.svg /var/www/html/swad/icon/
sudo cp icon/hand-point-up.svg /var/www/html/swad/icon/
sudo cp icon/heart.svg /var/www/html/swad/icon/
sudo cp icon/house-user.svg /var/www/html/swad/icon/
sudo cp icon/inbox.svg /var/www/html/swad/icon/
sudo cp icon/info-circle.svg /var/www/html/swad/icon/
sudo cp icon/instagram-brands.svg /var/www/html/swad/icon/
sudo cp icon/key.svg /var/www/html/swad/icon/
sudo cp icon/landmark.svg /var/www/html/swad/icon/
sudo cp icon/laptop-house.svg /var/www/html/swad/icon/
sudo cp icon/link.svg /var/www/html/swad/icon/
sudo cp icon/linkedin-brands.svg /var/www/html/swad/icon/
sudo cp icon/list.svg /var/www/html/swad/icon/
sudo cp icon/list-ol.svg /var/www/html/swad/icon/
sudo cp icon/lock.svg /var/www/html/swad/icon/
sudo cp icon/map-marker-alt.svg /var/www/html/swad/icon/
sudo cp icon/map-signs.svg /var/www/html/swad/icon/
sudo cp icon/marker.svg /var/www/html/swad/icon/
sudo cp icon/mouse-pointer.svg /var/www/html/swad/icon/
sudo cp icon/paperclip.svg /var/www/html/swad/icon/
sudo cp icon/paste.svg /var/www/html/swad/icon/
sudo cp icon/pen.svg /var/www/html/swad/icon/
sudo cp icon/photo-video.svg /var/www/html/swad/icon/
sudo cp icon/pinterest-brands.svg /var/www/html/swad/icon/
sudo cp icon/play.svg /var/www/html/swad/icon/
sudo cp icon/plus.svg /var/www/html/swad/icon/
sudo cp icon/poll.svg /var/www/html/swad/icon/
sudo cp icon/print.svg /var/www/html/swad/icon/
sudo cp icon/qrcode.svg /var/www/html/swad/icon/
sudo cp icon/question.svg /var/www/html/swad/icon/
sudo cp icon/recycle.svg /var/www/html/swad/icon/
sudo cp icon/reply.svg /var/www/html/swad/icon/
sudo cp icon/researchgate-brands.svg /var/www/html/swad/icon/
sudo cp icon/rss-square.svg /var/www/html/swad/icon/
sudo cp icon/search.svg /var/www/html/swad/icon/
sudo cp icon/share.svg /var/www/html/swad/icon/
sudo cp icon/share-alt.svg /var/www/html/swad/icon/
sudo cp icon/shield-alt.svg /var/www/html/swad/icon/
sudo cp icon/shopping-basket.svg /var/www/html/swad/icon/
sudo cp icon/shopping-cart.svg /var/www/html/swad/icon/
sudo cp icon/sign-in-alt.svg /var/www/html/swad/icon/
sudo cp icon/sign-out-alt.svg /var/www/html/swad/icon/
sudo cp icon/sitemap.svg /var/www/html/swad/icon/
sudo cp icon/slideshare-brands.svg /var/www/html/swad/icon/
sudo cp icon/spell-check.svg /var/www/html/swad/icon/
sudo cp icon/stack-overflow-brands.svg /var/www/html/swad/icon/
sudo cp icon/stamp.svg /var/www/html/swad/icon/
sudo cp icon/star.svg /var/www/html/swad/icon/
sudo cp icon/sticky-note.svg /var/www/html/swad/icon/
sudo cp icon/table.svg /var/www/html/swad/icon/
sudo cp icon/tag.svg /var/www/html/swad/icon/
sudo cp icon/tasks.svg /var/www/html/swad/icon/
sudo cp icon/th.svg /var/www/html/swad/icon/
sudo cp icon/times.svg /var/www/html/swad/icon/
sudo cp icon/toilet.svg /var/www/html/swad/icon/
sudo cp icon/trash.svg /var/www/html/swad/icon/
sudo cp icon/tree.svg /var/www/html/swad/icon/
sudo cp icon/trophy.svg /var/www/html/swad/icon/
sudo cp icon/tumblr-brands.svg /var/www/html/swad/icon/
sudo cp icon/twitch-brands.svg /var/www/html/swad/icon/
sudo cp icon/twitter-brands.svg /var/www/html/swad/icon/
sudo cp icon/university.svg /var/www/html/swad/icon/
sudo cp icon/unlock.svg /var/www/html/swad/icon/
sudo cp icon/user.svg /var/www/html/swad/icon/
sudo cp icon/user-check.svg /var/www/html/swad/icon/
sudo cp icon/user-circle.svg /var/www/html/swad/icon/
sudo cp icon/user-cog.svg /var/www/html/swad/icon/
sudo cp icon/user-friends.svg /var/www/html/swad/icon/
sudo cp icon/user-plus.svg /var/www/html/swad/icon/
sudo cp icon/user-slash.svg /var/www/html/swad/icon/
sudo cp icon/user-tie.svg /var/www/html/swad/icon/
sudo cp icon/users.svg /var/www/html/swad/icon/
sudo cp icon/users-cog.svg /var/www/html/swad/icon/
sudo cp icon/utensils.svg /var/www/html/swad/icon/
sudo cp icon/volleyball-ball.svg /var/www/html/swad/icon/
sudo cp icon/walking.svg /var/www/html/swad/icon/
sudo cp icon/wikipedia-w-brands.svg /var/www/html/swad/icon/
sudo cp icon/youtube-brands.svg /var/www/html/swad/icon/
sudo cp icon/iconset/awesome/address-card.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/at.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/bell.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/book.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/book-open.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/briefcase.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/building.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/bullhorn.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/calendar.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/calendar-check.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/calendar-day.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/chalkboard-teacher.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/chart-bar.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/chart-line.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/chart-pie.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/check.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/clipboard-list.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/clock.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/cog.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/comment.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/comment-dots.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/comments.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/edit.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/envelope.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/file-alt.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/file-invoice.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/file-signature.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/folder-open.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/gamepad.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/globe-americas.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/graduation-cap.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/hand-point-up.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/heart.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/house-user.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/info.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/link.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/list-alt.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/list-ol.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/map-marker-alt.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/poll.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/power-off.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/puzzle-piece.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/question.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/search.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/sitemap.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/sticky-note.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/tasks.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/tools.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/university.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/user.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/user-circle.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/user-clock.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/user-friends.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/user-tie.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/users.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/nuvola/chalkboard-teacher.svg /var/www/html/swad/icon/iconset/nuvola/
Version 21.71: Dec 20, 2021 Working on design of dark theme. (322132 lines)
Version 21.70.9: Dec 20, 2021 Fixed bug in user's IDs when listing match results. (321929 lines)
Version 21.70.8: Dec 20, 2021 Fixed bug showing calendar. (321927 lines)
Version 21.70.7: Dec 20, 2021 Working on design of dark theme. (321926 lines)
Version 21.70.7: Dec 20, 2021 Working on design of dark theme. (321926 lines)
Version 21.70.6: Dec 20, 2021 Working on design of dark theme. (321886 lines)
Version 21.70.5: Dec 19, 2021 Working on design of dark theme. (321748 lines)
Version 21.70.4: Dec 18, 2021 Working on design of dark theme. (321634 lines)
Version 21.70.3: Dec 17, 2021 Working on design of dark theme. (321559 lines)
Version 21.70.2: Dec 15, 2021 Working on design of dark theme. (321449 lines)
Version 21.70.1: Dec 15, 2021 Working on design of dark theme. (321305 lines)
Version 21.70: Dec 15, 2021 Working on design of dark theme. (321252 lines)
Version 21.69: Dec 15, 2021 Working on design of dark theme. (321089 lines)
Version 21.68: Dec 08, 2021 Beginning design of dark theme. (320444 lines)
Copy the following icons to icon public directory:
sudo mkdir /var/www/html/swad/icon/theme/dark
sudo cp -a icon/theme/dark/theme_32x20.gif /var/www/html/swad/icon/theme/dark
sudo cp -a icon/theme/dark/sitemap.svg /var/www/html/swad/icon/theme/dark
Version 21.67.4: Dec 07, 2021 Fixed bug in CSS for photos. Reported by Cristina Sánchez Justicia. (320339 lines)
Version 21.67.3: Dec 04, 2021 Help about user photo shapes. (320337 lines)
Version 21.67.2: Dec 04, 2021 Renamed exam announcements to calls for exams in help wiki. (320316 lines)
Version 21.67.1: Dec 04, 2021 Renamed CENTRE to CENTER in help wiki. (320316 lines)
Version 21.67: Dec 04, 2021 Removed title of action associated to vertical menu. (320316 lines)
Version 21.66.4: Dec 02, 2021 Removed code used to fix problem on tests and matches. (320379 lines)
Version 21.66.3: Dec 02, 2021 Fixed issue in CSS for background. (320874 lines)
Version 21.66: Dec 02, 2021 New module swad_photo_shape for user photo shapes. (320876 lines)
Version 21.65.1: Dec 01, 2021 New shape of user photos. (320833 lines)
2 changes necessary in database:
ALTER TABLE set_ip_settings CHANGE COLUMN UsrPhotos PhotoShape TINYINT NOT NULL DEFAULT 0;
ALTER TABLE usr_data CHANGE COLUMN UsrPhotos PhotoShape TINYINT NOT NULL DEFAULT 0;
Version 21.65.1: Dec 01, 2021 New shape of user photos. (320833 lines)
2 changes necessary in database:
UPDATE set_ip_settings SET UsrPhotos=3 WHERE UsrPhotos=2;
UPDATE usr_data SET UsrPhotos=3 WHERE UsrPhotos=2;
Version 21.65: Dec 01, 2021 Selection of shape of user photos. (320755 lines)
4 changes necessary in database:
ALTER TABLE set_ip_settings ADD COLUMN UsrPhotos TINYINT NOT NULL DEFAULT 0 AFTER SideCols;
UPDATE set_ip_settings SET UsrPhotos=2;
ALTER TABLE usr_data ADD COLUMN UsrPhotos TINYINT NOT NULL DEFAULT 0 AFTER SideCols,ADD INDEX (UsrPhotos);
UPDATE usr_data SET UsrPhotos=2;
Version 21.64.1: Nov 28, 2021 Code refactoring in link insertion. (320070 lines)
Version 21.64: Nov 28, 2021 New module swad_autolink to insert links in texts. (320076 lines)
Version 21.63: Nov 26, 2021 Fixing of corruption in test prints and match prints. (320010 lines)
Version 21.62.3: Nov 25, 2021 Fixed bug in test questions. Reported by Javier Fernández Baldomero and Jesús González Peñalver. (319438 lines)
Version 21.62.2: Nov 24, 2021 Fixed bug in forums. Reported by Javier Fernández Baldomero. (319422 lines)
Version 21.62.1: Nov 24, 2021 Added some header files. (319422 lines)
Version 21.62: Nov 24, 2021 Code refactoring in photos. (319415 lines)
Version 21.61: Nov 24, 2021 User's photo is shown near a mention. (319454 lines)
Version 21.60.1: Nov 24, 2021 Code optimization in insertion of links in a string. (319233 lines)
Version 21.60: Nov 24, 2021 Code refactoring inserting links in a string. (319208 lines)
Version 21.59: Nov 22, 2021 Code refactoring in timeline. (319149 lines)
Version 21.58.2: Nov 21, 2021 Code refactoring in timeline. (319135 lines)
Version 21.58.1: Nov 21, 2021 Code refactoring in timeline. (319131 lines)
Version 21.58: Nov 21, 2021 Code refactoring in timeline. (319140 lines)
Version 21.57.5: Nov 18, 2021 Code refactoring related to check if user logged is me. (319174 lines)
Version 21.57.4: Nov 17, 2021 Code refactoring in timeline. (319235 lines)
Version 21.57.3: Nov 17, 2021 Code refactoring in timeline. (319225 lines)
Version 21.57.2: Nov 14, 2021 Code refactoring in timeline. (319257 lines)
Version 21.57.1: Nov 12, 2021 Code refactoring in multimedia. (319241 lines)
Version 21.57: Nov 11, 2021 Code refactoring in timeline. (319208 lines)
Version 21.56.5: Nov 10, 2021 Code refactoring in switch statements. (319181 lines)
Version 21.56.4: Nov 10, 2021 Code refactoring in switch statements (until swad_network_database.c). (319362 lines)
Version 21.56.3: Nov 10, 2021 Code refactoring in switch statements (until swad_logo.c). (319403 lines)
Version 21.56.2: Nov 10, 2021 Code refactoring in pointers to text. (319501 lines)
Version 21.56.1: Nov 10, 2021 Code refactoring in switch statements (until swad_enrolment.c). (319490 lines)
Version 21.56: Nov 10, 2021 Code refactoring in hierarchy. (319618 lines)
Version 21.55.2: Nov 10, 2021 Code refactoring in switch statements (until swad_button.c). (319875 lines)
Version 21.55.1: Nov 09, 2021 Removed unused comments. (319893 lines)
Version 21.55: Nov 09, 2021 New module swad_template. Removed unused comments. (320885 lines)
Version 21.54.8: Nov 09, 2021 Queries moved from API module to database modules. (322179 lines)
Version 21.54.7: Nov 09, 2021 Queries moved from API module to database modules. (322175 lines)
Version 21.54.6: Nov 09, 2021 Code refactoring in notifications. (322164 lines)
Version 21.54.5: Nov 09, 2021 Queries moved from API module to database modules. (322185 lines)
Version 21.54.4: Nov 09, 2021 Queries moved from API module to database modules. (322222 lines)
Version 21.54.3: Nov 08, 2021 Queries moved from API module to database modules. (322095 lines)
Version 21.54.2: Nov 08, 2021 Queries moved to module swad_user_database and other modules. (322054 lines)
Version 21.54.1: Nov 08, 2021 Queries moved to module swad_user_database. (322060 lines)
Version 21.54: Nov 07, 2021 New module swad_API_database for database queries related to API. (322001 lines)
Version 21.53.1: Nov 07, 2021 Queries moved to module swad_room_database. (321879 lines)
Version 21.53: Nov 06, 2021 Queries moved to module swad_user_database and other modules. (321926 lines)
Version 21.52.3: Nov 06, 2021 Queries moved to module swad_user_database. (321894 lines)
Version 21.52.2: Nov 06, 2021 Query refactoring related to SELECT DISTINCT and UNION. (321899 lines)
Version 21.52.1: Nov 06, 2021 Fixed database query in departments. (321828 lines)
Version 21.52: Nov 05, 2021 Changed SELECT COUNT to SELECT EXISTS in some queries. (321833 lines)
Version 21.51: Nov 04, 2021 Eliminated the limit of origin courses in messages. (321735 lines)
Version 21.50.1: Nov 03, 2021 Queries moved to module swad_user_database and other modules. (321759 lines)
Version 21.50: Nov 03, 2021 Queries moved to module swad_user_database and other modules. (321696 lines)
Version 21.49: Nov 03, 2021 New module swad_user_database for database queries related to users. (321615 lines)
Version 21.48: Nov 03, 2021 New module swad_timetable_database for database queries related to timetables. (321438 lines)
Version 21.47.5: Oct 30, 2021 Queries moved to module swad_questions_database. (321308 lines)
Version 21.47.4: Oct 30, 2021 Review of comments. (321253 lines)
Version 21.47.3: Oct 29, 2021 Queries moved to module swad_questions_database. (321299 lines)
Version 21.47.2: Oct 29, 2021 Queries moved to module swad_questions_database. (321259 lines)
Version 21.47.1: Oct 28, 2021 Queries moved to module swad_questions_database. (321231 lines)
Version 21.47: Oct 27, 2021 New module swad_questions_database for database queries related to test/exam/game questions. (321236 lines)
Version 21.46.5: Oct 27, 2021 Queries moved to module swad_test_database. (321140 lines)
Version 21.46.4: Oct 27, 2021 Code refactoring in test prints. (321059 lines)
Version 21.46.3: Oct 27, 2021 Queries moved to module swad_test_database. (321054 lines)
Version 21.46.2: Oct 26, 2021 Queries moved to module swad_test_database. (321062 lines)
Version 21.46.1: Oct 26, 2021 Queries moved to module swad_test_database. (321058 lines)
Version 21.46: Oct 26, 2021 New module swad_test_database for database queries related to self-assessment tests. (321036 lines)
Version 21.45.1: Oct 25, 2021 Code refactoring in test questions. (320932 lines)
Version 21.45: Oct 25, 2021 Functions moved to module swad_question. (320930 lines)
Version 21.44: Oct 25, 2021 Functions moved to module swad_question. (320928 lines)
Version 21.43: Oct 25, 2021 New module swad_question for test/exam/game questions. (320919 lines)
Version 21.42.2: Oct 25, 2021 Code refactoring in test questions. (320795 lines)
Version 21.42.1: Oct 25, 2021 Code refactoring in test questions. (320784 lines)
Version 21.42: Oct 24, 2021 Code refactoring in test questions. (320782 lines)
Version 21.41.2: Oct 24, 2021 Query moved to module swad_setting_database. (320777 lines)
Version 21.41.1: Oct 24, 2021 Queries moved to module swad_tag_database. (320767 lines)
Version 21.41: Oct 24, 2021 New module swad_tag_database for database queries related to question tags. (320721 lines)
Version 21.40.1: Oct 24, 2021 Queries moved to module swad_center_database. (320621 lines)
Version 21.40: Oct 24, 2021 Queries moved to module swad_survey_database. (320673 lines)
Version 21.39.2: Oct 22, 2021 Fixed bug in settings. (320544 lines)
Version 21.39.1: Oct 21, 2021 Queries moved to module swad_survey_database. (320540 lines)
Version 21.39: Oct 21, 2021 Fixed bug in nicknames. Reported by Ana Ollarves Reyes. (320487 lines)
Version 21.38.1: Oct 20, 2021 Queries moved to module swad_survey_database. (320522 lines)
Version 21.38: Oct 20, 2021 New module swad_survey_database for database queries related to surveys. (320457 lines)
Version 21.37.1: Oct 20, 2021 Code refactoring in attendance. (320361 lines)
Version 21.37: Oct 19, 2021 New module swad_statistic_database for database queries related to statistics of accesses to platform. (320363 lines)
Version 21.36: Oct 18, 2021 New module swad_setting_database for database queries related to user's settings / preferences. (320253 lines)
Version 21.35.1: Oct 18, 2021 Queries moved to module swad_file_database. (320175 lines)
Version 21.35: Oct 18, 2021 New module swad_file_database for database queries related to files. (320171 lines)
Version 21.34: Oct 15, 2021 New module swad_session_database for database queries related to sessions. (320081 lines)
Version 21.33.2: Oct 15, 2021 Fixed bug getting name of degree. (319950 lines)
Version 21.33.1: Oct 15, 2021 Number of users/courses to show big-list warning increased from 500 to 1000. (319944 lines)
Version 21.33: Oct 15, 2021 Queries moved from search to other modules. (319942 lines)
Version 21.32.3: Oct 14, 2021 Fixed bug in institutional links. (319792 lines)
Version 21.32.2: Oct 13, 2021 Queries moved from RSS to other modules. (319785 lines)
Version 21.32.1: Oct 13, 2021 Queries moved to module swad_role_database. (319787 lines)
Version 21.32: Oct 13, 2021 New module swad_role_database for database queries related to user roles. (319611 lines)
Version 21.31.2: Oct 13, 2021 Queries moved to module swad_log_database. (319542 lines)
Version 21.31.1: Oct 13, 2021 Queries moved to module swad_log_database. (319520 lines)
Version 21.31: Oct 13, 2021 New module swad_report_database for database queries related to user reports. (319475 lines)
Version 21.30.1: Oct 13, 2021 Queries moved to module swad_record_database. (319411 lines)
Version 21.30: Oct 12, 2021 New module swad_record_database for database queries related to records. (319400 lines)
Version 21.29: Oct 11, 2021 New module swad_project_database for database queries related to projects. (319208 lines)
Version 21.28.1: Oct 10, 2021 Code refactoring in projects. (318975 lines)
Version 21.28: Oct 09, 2021 New module swad_program_database for database queries related to course program. (319013 lines)
Version 21.27.1: Oct 07, 2021 Queries moved to module swad_profile_database. (318855 lines)
Version 21.27: Oct 07, 2021 New module swad_profile_database for database queries related to user's public profile. (318846 lines)
Version 21.26: Oct 06, 2021 New module swad_plugin_database for database queries related to plugins. (318680 lines)
Version 21.25: Oct 05, 2021 New module swad_place_database for database queries related to places. (318514 lines)
Version 21.24.1: Oct 05, 2021 Queries moved to module swad_photo_database. (318406 lines)
Version 21.24: Oct 05, 2021 New module swad_photo_database for database queries related to users' photos. (318352 lines)
Version 21.23: Oct 04, 2021 New module swad_password_database for database queries related to passwords. (318197 lines)
Version 21.22: Oct 04, 2021 Queries related to notifications moved to other modules. (318066 lines)
Version 21.21.2: Oct 01, 2021 Queries moved to module swad_notification_database. (317963 lines)
Version 21.21.1: Oct 01, 2021 Queries moved to module swad_notification_database. (317938 lines)
Version 21.21: Sep 30, 2021 New module swad_notice_database for database queries related to notices. (317901 lines)
Version 21.20.1: Sep 30, 2021 Code refactoring related to nicknames. (317756 lines)
Version 21.20: Sep 30, 2021 New module swad_nickname_database for database queries related to nicknames. (317751 lines)
Version 21.19: Sep 29, 2021 New module swad_network_database for database queries related to webs/social networks. (317644 lines)
Version 21.18: Sep 29, 2021 New module swad_MFU_database for database queries related to most frequently used actions. (317529 lines)
Version 21.17.4: Sep 29, 2021 Queries moved to module swad_message_database. (317408 lines)
Version 21.17.3: Sep 29, 2021 Queries moved to module swad_message_database. (317431 lines)
Version 21.17.2: Sep 27, 2021 Queries moved to module swad_message_database. (317358 lines)
Version 21.17.1: Sep 27, 2021 Queries moved to module swad_message_database. (317325 lines)
Version 21.17: Sep 27, 2021 New module swad_message_database for database queries related to messages. (317295 lines)
Version 21.16.6: Sep 27, 2021 Queries moved to module swad_match_database. (317186 lines)
Version 21.16.5: Sep 26, 2021 Queries moved to module swad_match_database. (317134 lines)
Version 21.16.4: Sep 25, 2021 Queries moved to module swad_match_database. (317091 lines)
Version 21.16.3: Sep 25, 2021 Queries moved to module swad_match_database. (317085 lines)
Version 21.16.2: Sep 25, 2021 Code refactoring related to error alerts. (317087 lines)
Version 21.16.1: Sep 24, 2021 Queries moved to module swad_match_database. (317054 lines)
Version 21.16: Sep 24, 2021 New module swad_match_database for database queries related to game matches. (316995 lines)
Version 21.15: Sep 24, 2021 New module swad_mark_database for database queries related to files of marks. (316792 lines)
Version 21.14.1: Sep 23, 2021 Queries moved to module swad_mail_database. (316687 lines)
Version 21.14: Sep 22, 2021 New module swad_mail_database for database queries related to mail domains. (316594 lines)
Version 21.13: Sep 22, 2021 New module swad_log_database for database queries related to access logs. (316510 lines)
Version 21.12: Sep 22, 2021 New module swad_link_database for database queries related to institutional links. (316361 lines)
Version 21.11.1: Sep 22, 2021 Queries moved to module swad_info_database. (316237 lines)
Version 21.11: Sep 22, 2021 New module swad_info_database for database queries related to course information. (316228 lines)
Version 21.10.1: Sep 21, 2021 Fixed bugs in roles. Reported by Javier Fernández Baldomero and Mª Carmen García Miranda. (316111 lines)
Version 21.10: Sep 20, 2021 New module swad_indicator_database for database queries related to course indicators. (316112 lines)
Version 21.9.1: Sep 20, 2021 Queries moved to module swad_browser_database. (316023 lines)
Version 21.9: Sep 20, 2021 New module swad_ID_database for database queries related to user's IDs. (316021 lines)
Version 21.8.1: Sep 20, 2021 Queries moved to module swad_holiday_database. (315927 lines)
Version 21.8: Sep 20, 2021 New module swad_holiday_database for database queries related to holidays. (315883 lines)
Version 21.7: Sep 20, 2021 New module swad_hierarchy_database for database queries related to hierarchy. (315774 lines)
Version 21.6.3: Sep 20, 2021 Queries moved to module swad_game_database. (315708 lines)
Version 21.6.2: Sep 18, 2021 Queries moved to module swad_game_database. (315679 lines)
Version 21.6.1: Sep 18, 2021 Queries moved to module swad_game_database. (315571 lines)
Version 21.6: Sep 18, 2021 New module swad_game_database for database queries related to games. (315565 lines)
Version 21.5.3: Sep 16, 2021 Queries moved to module swad_forum_database. (315431 lines)
Version 21.5.2: Sep 16, 2021 Queries moved to module swad_forum_database. (315403 lines)
Version 21.5.1: Sep 15, 2021 Queries moved to module swad_forum_database. (315348 lines)
Version 21.5: Sep 15, 2021 New module swad_forum_database for database queries related to forums. (315354 lines)
Version 21.4: Sep 15, 2021 New module swad_firewall_database for database queries related to firewall. (315286 lines)
Version 21.3.1: Sep 15, 2021 Queries moved to module swad_browser_database. (315201 lines)
Version 21.3: Sep 15, 2021 New module swad_notification_database for database queries related to notifications. (315211 lines)
Version 21.2.2: Sep 14, 2021 Queries moved to module swad_browser_database. (315051 lines)
Version 21.2.1: Sep 14, 2021 Queries moved to module swad_browser_database. (315003 lines)
Version 21.2: Sep 14, 2021 Code refactoring related to file browsers. (314983 lines)
Version 21.1.1: Sep 14, 2021 Queries moved to module swad_enrolment_database. (315050 lines)
Version 21.1: Sep 13, 2021 New module swad_browser_database for database queries related to file browsers. (315050 lines)
Version 21.0.2: Sep 13, 2021 Queries moved to module swad_notification. (314927 lines)
Version 21.0.1: Sep 13, 2021 Queries moved to module swad_follow_database. (314910 lines)
Version 21.0: Sep 13, 2021 Fixed bug in degrees photo. (314914 lines)
Version 20.100.5: Sep 12, 2021 Fixed bug removing all students in a course. Reported by José Luis Bernier Villamor and Francisco J. Pelayo Valle. (314909 lines)
Version 20.100.4: Sep 11, 2021 Queries moved to module swad_timeline_database. (314934 lines)
Version 20.100.3: Sep 11, 2021 Queries moved to module swad_file_browser. (314923 lines)
Version 20.100.2: Sep 11, 2021 Queries moved to module swad_institution_database. (314919 lines)
Version 20.100.1: Sep 10, 2021 Queries moved to module swad_institution_database. (314941 lines)
Version 20.100: Sep 10, 2021 New module swad_figure_database for database queries related to figures. (314940 lines)
Version 20.99: Sep 10, 2021 Queries moved to module swad_institution_database. (314758 lines)
Version 20.98: Sep 10, 2021 New module swad_institution_database for database queries related to institutions. (314663 lines)
Version 20.97: Sep 10, 2021 Code refactoring related to scope. (314566 lines)
Version 20.96.7: Sep 09, 2021 Queries moved to module swad_exam_database. (314527 lines)
Version 20.96.6: Sep 09, 2021 Queries moved to module swad_exam_database. (314471 lines)
Version 20.96.5: Sep 09, 2021 Queries moved to module swad_exam_database. (314448 lines)
Version 20.96.4: Sep 08, 2021 Queries moved to module swad_exam_database. (314414 lines)
Version 20.96.3: Sep 08, 2021 Queries moved to module swad_exam_database. (314384 lines)
Version 20.96.2: Sep 08, 2021 Queries moved to module swad_exam_database. (314362 lines)
Version 20.96.1: Jul 30, 2021 Fix bugs removing exams. (314373 lines)
Version 20.96: Jul 27, 2021 Queries moved to module swad_exam_database. (314247 lines)
Version 20.95.3: Jul 20, 2021 Queries moved to module swad_exam_database. (314210 lines)
Version 20.95.2: Jul 16, 2021 Queries moved to module swad_exam_database. (314137 lines)
Version 20.95.1: Jul 15, 2021 Queries moved to module swad_exam_database. (314082 lines)
Version 20.95: Jul 08, 2021 New module swad_exam_database for database queries related to exams. (313981 lines)
Version 20.94.10: Jun 29, 2021 Code refactoring related to HTML output. (313860 lines)
Version 20.94.9: Jun 29, 2021 Query moved from module swad_menu to module swad_setting. (313848 lines)
Version 20.94.8: Jun 29, 2021 Queries moved to module swad_group_database. (313834 lines)
Version 20.94.7: Jun 28, 2021 Queries moved to module swad_group_database. (313782 lines)
Version 20.94.6: Jun 28, 2021 Fixed bug in removal of project. (313688 lines)
Version 20.94.5: Jun 25, 2021 Queries moved to module swad_group_database. (313686 lines)
Version 20.94.4: Jun 24, 2021 Queries moved to module swad_group_database. (313637 lines)
Version 20.94.3: Jun 18, 2021 Queries moved to module swad_group_database. (313602 lines)
Version 20.94.2: Jun 18, 2021 Queries moved to module swad_group_database. (313557 lines)
Version 20.94.1: Jun 17, 2021 Queries moved to module swad_group_database. (313511 lines)
Version 20.94: Jun 17, 2021 New module swad_group_database for database queries related to groups. (313489 lines)
Version 20.93: Jun 17, 2021 Code refactoring. (313382 lines)
Version 20.92: Jun 11, 2021 New modules swad_admin and swad_admin_database for administrators. (313381 lines)
Version 20.91.3: Jun 11, 2021 Queries moved to module swad_enrolment_database. (313173 lines)
Version 20.91.2: Jun 11, 2021 Queries moved to module swad_enrolment_database. (313143 lines)
Version 20.91.1: Jun 10, 2021 Queries moved to module swad_enrolment_database. (313145 lines)
Version 20.91: Jun 09, 2021 New module swad_enrolment_database for database queries related to user's enrolment. (313063 lines)
Version 20.90.1: Jun 09, 2021 Queries moved to module swad_duplicate_database. (312962 lines)
Version 20.90: Jun 05, 2021 New module swad_duplicate_database for database queries related to duplicate users. (? lines)
Version 20.89.1: Jun 05, 2021 Queries moved to module swad_department_database. (312869 lines)
Version 20.89: Jun 02, 2021 New module swad_department_database for database queries related to departments. (312824 lines)
Version 20.88.3: Jun 02, 2021 Queries moved to module swad_center_database. (312755 lines)
Version 20.88.2: Jun 02, 2021 Queries moved to module swad_center_database.
Fixed bug in visibility of exam results. Reported by Mancia Anguita López. (312738 lines)
Version 20.88.1: Jun 02, 2021 Queries moved to module swad_center_database. (312668 lines)
Version 20.88: Jun 02, 2021 New module swad_center_database for database queries related to centers. (312638 lines)
Version 20.87.1: Jun 01, 2021 Database function moved from swad_calendar to swad_setting. (312549 lines)
Version 20.87: Jun 01, 2021 New module swad_building_database for database queries related to buildings. (312538 lines)
Version 20.86.1: May 31, 2021 Queries moved to module swad_call_for_exam_database. (312420 lines)
Version 20.86: May 31, 2021 New module swad_call_for_exam_database for database queries related to calls for exams. (312415 lines)
Version 20.85: May 28, 2021 Queries moved to module swad_degree_database. (312319 lines)
Version 20.84: May 27, 2021 New module swad_degree_database for database queries related to degrees. (312216 lines)
Version 20.83.1: May 27, 2021 Database function moved from swad_date to swad_setting. (311993 lines)
Version 20.83: May 27, 2021 New module swad_course_database for database queries related to courses. (311982 lines)
Version 20.82: May 23, 2021 Queries moved to module swad_country_database. (311702 lines)
Version 20.81: May 22, 2021 New module swad_country_database for database queries related to countries. (311632 lines)
Version 20.80: May 20, 2021 New module swad_cookie_database for database queries related to cookies. (311497 lines)
Version 20.79: May 20, 2021 New module swad_connected_database for database queries related to connected users. (311415 lines)
Version 20.78.2: May 20, 2021 Code formatting in games and matches. (311326 lines)
Version 20.78.1: May 20, 2021 Fixed bug in matches. Reported by Jesús Garrido Alcázar. (311317 lines)
Version 20.78: May 19, 2021 New module swad_chat_database for database queries related to chat. (311327 lines)
Version 20.77: May 18, 2021 New module swad_banner_database for database queries related to banners. (311249 lines)
Version 20.76: May 11, 2021 New module swad_atendance_database for database queries related to attendance events. (311109 lines)
Version 20.75: May 11, 2021 New module swad_assignment_database for database queries related to assignments. (310858 lines)
Version 20.74: May 11, 2021 New module swad_announcement_database for database queries related to announcements. (310629 lines)
Version 20.73: May 10, 2021 New module swad_agenda_database for database queries related to agenda. (310474 lines)
Version 20.72: May 10, 2021 New module swad_account_database for database queries related to user's account. (310328 lines)
Version 20.71: May 10, 2021 New module swad_media_database for database queries related to media. (310080 lines)
Version 20.70: May 07, 2021 New module swad_follow_database for database queries related to following/followers. (309943 lines)
Version 20.69.2: May 04, 2021 Fixed bug in removal of timeline favs. (309778 lines)
Version 20.69.1: Apr 30, 2021 Code refactoring in JavaScript (firstChild instead of childNodes[0]). (309775 lines)
Version 20.69: Apr 30, 2021 Changes in timeline to not repeat notes in new activity. (309773 lines)
Version 20.68.8: Apr 30, 2021 Code refactoring in timeline. (309751 lines)
Version 20.68.7: Apr 29, 2021 Code refactoring in timeline. (309749 lines)
Version 20.68.6: Apr 29, 2021 Code refactoring in timeline. (309738 lines)
Version 20.68.5: Apr 29, 2021 Fixed bug in matches. Reported by Jesús Garrido Alcázar. (309746 lines)
Version 20.68.4: Apr 27, 2021 Fixed bug in question tags. Reported by Julio Ortega Lopera. (309802 lines)
Version 20.68.3: Apr 27, 2021 Maximum file size increased from 1.5 GiB to 2000 MiB. (309809 lines)
Version 20.68.2: Apr 26, 2021 Code optimization in games and exams. (309807 lines)
Version 20.68.1: Apr 26, 2021 Code refactoring in exams and tests. (309862 lines)
Version 20.68: Apr 26, 2021 New module swad_error. (309853 lines)
Version 20.67.11: Apr 26, 2021 Fixed bug in departments. (309677 lines)
Version 20.67.10: Apr 25, 2021 Fixed bug in notification about new assignment, reported by Eva Martínez Ortigosa. (? lines)
Version 20.67.9: Apr 25, 2021 Fixed bug in users' works, reported by Eva Martínez Ortigosa. (309675 lines)
Version 20.67.8: Apr 25, 2021 Fixed bug in groups. (309674 lines)
Version 20.67.7: Apr 25, 2021 Fixed bug in search of files. (309673 lines)
Version 20.67.6: Apr 25, 2021 Fixed bug in surveys. (309672 lines)
Version 20.67.5: Apr 25, 2021 Fixed bug in search of courses. (309671 lines)
Version 20.67.4: Apr 25, 2021 New file extensions for LogicWorks, reported by Eva Martínez Ortigosa. (309670 lines)
Copy the following icons to icon public directory:
sudo cp icon/filext32x32/cct32x32.gif /var/www/html/swad/icon/filext32x32/
sudo cp icon/filext32x32/clf32x32.gif /var/www/html/swad/icon/filext32x32/
sudo cp icon/filext32x32/tim32x32.gif /var/www/html/swad/icon/filext32x32/
Version 20.67.3: Apr 25, 2021 Code refactoring in error messages. (309662 lines)
Version 20.67.2: Apr 25, 2021 Code refactoring in error messages. (309482 lines)
Version 20.67.1: Apr 24, 2021 Code refactoring in error messages. (309415 lines)
Version 20.67: Apr 24, 2021 Bug fixing and code optimizations related to user's roles. (309356 lines)
Version 20.66.5: Apr 23, 2021 Including missing head files.
Fixed bug getting my courses. (309123 lines)
Version 20.66.4: Apr 23, 2021 Fixed bug in pagination of messages. (309110 lines)
Version 20.66.3: Apr 23, 2021 Fixed bug in course information. (309108 lines)
Version 20.66.2: Apr 22, 2021 Clicks-without-photo database table renamed. (309126 lines)
1 change necessary in database:
RENAME TABLE pho_clicks_without_photo TO usr_clicks_without_photo;
Version 20.66.1: Apr 17, 2021 Code refactoring in database deletes. (309123 lines)
Version 20.66: Apr 17, 2021 Code refactoring in database updates. (308972 lines)
Version 20.65.1: Apr 17, 2021 Code refactoring in database replaces. (308677 lines)
Version 20.65: Apr 17, 2021 Code refactoring in database inserts. (308629 lines)
Version 20.64.1: Apr 17, 2021 Optimizations in database selects. (308523 lines)
Version 20.64: Apr 17, 2021 Optimizations in database selects. (308518 lines)
Version 20.63: Apr 16, 2021 Optimizations in database selects. (308487 lines)
Version 20.62: Apr 15, 2021 Optimizations in database selects related to roles. (308574 lines)
Version 20.61: Apr 13, 2021 Optimizations in database selects. (308567 lines)
Version 20.60: Apr 07, 2021 Optimizations in database selects. (308790 lines)
Version 20.59: Apr 06, 2021 Optimizations in database selects. (308903 lines)
Version 20.58: Apr 06, 2021 Optimizations in database selects. (308989 lines)
Version 20.57: Apr 05, 2021 Optimizations in database selects. (309041 lines)
Version 20.56.1: Apr 04, 2021 Optimizations in database selects. (309252 lines)
Version 20.56: Apr 04, 2021 Optimizations in database selects. (309296 lines)
Version 20.55: Apr 04, 2021 Optimizations in database selects. (309500 lines)
Version 20.54: Mar 30, 2021 Statistics about agendas. (309539 lines)
Version 20.53.1: Mar 30, 2021 Optimizations in database selects. (309459 lines)
Version 20.53: Mar 29, 2021 Code refactoring in database selects. (309473 lines)
Version 20.52: Mar 28, 2021 Code refactoring in database selects. (309103 lines)
Version 20.51.49: Mar 26, 2021 User IDs database table renamed. (308816 lines)
1 change necessary in database:
RENAME TABLE usr_IDs TO usr_ids;
Version 20.51.48: Mar 26, 2021 Room MAC addresses database table renamed. (308782 lines)
1 change necessary in database:
RENAME TABLE roo_MACs TO roo_macs;
Version 20.51.47: Mar 26, 2021 Most frequent actions database table renamed. (308779 lines)
1 change necessary in database:
RENAME TABLE act_MFU TO act_frequent;
Version 20.51.46: Mar 26, 2021 User reports database table renamed. (308775 lines)
1 change necessary in database:
RENAME TABLE usr_report TO usr_reports;
Version 20.51.45: Mar 25, 2021 Statistics about notifications database table renamed. (308767 lines)
1 change necessary in database:
RENAME TABLE sta_notif TO sta_notifications;
Version 20.51.44: Mar 25, 2021 Project users database table renamed. (308756 lines)
1 change necessary in database:
RENAME TABLE prj_usr TO prj_users;
Version 20.51.43: Mar 24, 2021 Log API database table renamed. (308751 lines)
1 change necessary in database:
RENAME TABLE log_ws TO log_api;
Version 20.51.42: Mar 24, 2021 Exam logs database tables renamed. (308703 lines)
2 changes necessary in database:
RENAME TABLE exa_log_session TO exa_log_sessions;
RENAME TABLE exa_log_user_agent TO exa_log_user_agents;
Version 20.51.41: Mar 24, 2021 Course user settings database table renamed. (308698 lines)
1 change necessary in database:
RENAME TABLE crs_usr_last TO crs_user_settings;
Version 20.51.40: Mar 24, 2021 Course requests database table renamed. (308671 lines)
1 change necessary in database:
RENAME TABLE crs_usr_requests TO crs_requests;
Version 20.51.39: Mar 24, 2021 Calls for exams database table renamed. (308655 lines)
1 change necessary in database:
RENAME TABLE cfe_calls_for_exams TO cfe_exams;
Version 20.51.38: Mar 24, 2021 API keys database table renamed. (308651 lines)
1 change necessary in database:
RENAME TABLE API_keys TO api_keys;
Version 20.51.37: Mar 24, 2021 Settings for IPs database table renamed. (308647 lines)
1 change necessary in database:
RENAME TABLE IP_prefs TO set_ip_settings;
Version 20.51.36: Mar 24, 2021 Files database tables renamed. (308634 lines)
2 changes necessary in database:
RENAME TABLE brw_file_caches TO brw_caches;
RENAME TABLE brw_file_views TO brw_views;
Version 20.51.35: Mar 24, 2021 Expanded folders database table renamed. (308630 lines)
1 change necessary in database:
RENAME TABLE brw_expanded_folders TO brw_expanded;
Version 20.51.34: Mar 23, 2021 Groups database tables renamed. (308624 lines)
2 changes necessary in database:
RENAME TABLE crs_grp_types TO grp_types;
RENAME TABLE crs_grp_usr TO grp_users;
Version 20.51.33: Mar 23, 2021 Groups database table renamed. (308594 lines)
1 change necessary in database:
RENAME TABLE crs_grp TO grp_groups;
Version 20.51.32: Mar 23, 2021 Course users database table renamed. (308512 lines)
1 change necessary in database:
RENAME TABLE crs_usr TO crs_users;
DROP TABLE IF EXISTS crs_usr_copy;
Version 20.51.31: Mar 23, 2021 Attendance users database table renamed. (308312 lines)
1 change necessary in database:
RENAME TABLE att_usr TO att_users;
Version 20.51.30: Mar 20, 2021 Survey groups database table renamed. (308287 lines)
1 change necessary in database:
RENAME TABLE svy_grp TO svy_groups;
Version 20.51.29: Mar 20, 2021 Attendance groups database table renamed. (308259 lines)
1 change necessary in database:
RENAME TABLE att_grp TO att_groups;
Version 20.51.28: Mar 20, 2021 Assignment groups database table renamed. (308234 lines)
1 change necessary in database:
RENAME TABLE asg_grp TO asg_groups;
Version 20.51.27: Mar 20, 2021 Debug database table renamed. (308219 lines)
1 change necessary in database:
RENAME TABLE debug TO dbg_debug;
Version 20.51.27: Mar 20, 2021 API database table renamed. (308212 lines)
1 change necessary in database:
RENAME TABLE ws_keys TO API_keys;
Version 20.51.26: Mar 20, 2021 Marks database table renamed. (308209 lines)
1 change necessary in database:
RENAME TABLE marks_properties TO mrk_marks;
Version 20.51.25: Mar 20, 2021 Plugins database table renamed. (308202 lines)
1 change necessary in database:
RENAME TABLE plugins TO plg_plugins;
Version 20.51.24: Mar 19, 2021 Places database table renamed. (308164 lines)
1 change necessary in database:
RENAME TABLE places TO plc_places;
Version 20.51.23: Mar 19, 2021 Timetable database tables renamed. (308151 lines)
2 changes necessary in database:
RENAME TABLE timetable_crs TO tmt_courses;
RENAME TABLE timetable_tut TO tmt_tutoring;
Version 20.51.22: Mar 19, 2021 Pending database tables renamed. (308117 lines)
2 changes necessary in database:
RENAME TABLE pending_emails TO usr_pending_emails;
RENAME TABLE pending_passwd TO usr_pending_passwd;
Version 20.51.21: Mar 19, 2021 Notices database tables renamed. (308101 lines)
3 changes necessary in database:
RENAME TABLE notices TO not_notices;
RENAME TABLE notices_deleted TO not_deleted;
RENAME TABLE links TO lnk_links;
Version 20.51.20: Mar 19, 2021 Rooms database tables renamed. (308069 lines)
2 changes necessary in database:
RENAME TABLE room_MAC TO roo_MACs;
RENAME TABLE room_check_in TO roo_check_in;
Version 20.51.19: Mar 19, 2021 Rooms database table renamed. (308059 lines)
1 change necessary in database:
RENAME TABLE rooms TO roo_rooms;
Version 20.51.19: Mar 19, 2021 Media database table renamed. (308033 lines)
1 change necessary in database:
RENAME TABLE media TO med_media;
Version 20.51.18: Mar 19, 2021 Projects database table renamed. (308022 lines)
1 change necessary in database:
RENAME TABLE projects TO prj_projects;
Version 20.51.17: Mar 19, 2021 Mail domains database table renamed. (307992 lines)
1 change necessary in database:
RENAME TABLE mail_domains TO ntf_mail_domains;
Version 20.51.16: Mar 19, 2021 Notifications database table renamed. (307980 lines)
1 change necessary in database:
RENAME TABLE notif TO ntf_notifications;
Version 20.51.15: Mar 19, 2021 Holidays database table renamed. (307911 lines)
1 change necessary in database:
RENAME TABLE holidays TO hld_holidays;
Version 20.51.14: Mar 18, 2021 Session database table renamed. (307892 lines)
1 change necessary in database:
RENAME TABLE sessions TO ses_sessions;
Version 20.51.13: Mar 18, 2021 Session parameters database table renamed. (307862 lines)
1 change necessary in database:
RENAME TABLE hidden_params TO ses_params;
Version 20.51.12: Mar 18, 2021 Forum threads database tables renamed. (307859 lines)
3 changes necessary in database:
RENAME TABLE forum_thr_clip TO for_clipboards;
RENAME TABLE forum_thr_read TO for_read;
RENAME TABLE for_disabled_posts TO for_disabled;
Version 20.51.11: Mar 18, 2021 Forum theads database table renamed. (307844 lines)
1 change necessary in database:
RENAME TABLE forum_thread TO for_threads;
Version 20.51.10: Mar 18, 2021 Forum posts database tables renamed. (307775 lines)
1 change necessary in database:
RENAME TABLE forum_disabled_post TO for_disabled_posts;
RENAME TABLE forum_post TO for_posts;
Version 20.51.9: Mar 18, 2021 Firewall database tables renamed. (307724 lines)
2 changes necessary in database:
RENAME TABLE firewall_banned TO fir_banned;
RENAME TABLE firewall_log TO fir_log;
Version 20.51.8: Mar 18, 2021 File views database table renamed. (307717 lines)
1 change necessary in database:
RENAME TABLE file_view TO brw_file_views;
Version 20.51.7: Mar 18, 2021 File caches database table renamed. (307704 lines)
1 change necessary in database:
RENAME TABLE file_cache TO brw_file_caches;
Version 20.51.6: Mar 18, 2021 Files database table renamed. (307697 lines)
1 change necessary in database:
RENAME TABLE files TO brw_files;
Version 20.51.5: Mar 18, 2021 File-browser-size database table renamed. (307594 lines)
1 change necessary in database:
RENAME TABLE file_browser_size TO brw_sizes;
Version 20.51.4: Mar 18, 2021 File-browser-last database table renamed. (307563 lines)
1 change necessary in database:
RENAME TABLE file_browser_last TO brw_last;
Version 20.51.3: Mar 18, 2021 Figures database table renamed. (307558 lines)
1 change necessary in database:
RENAME TABLE figures TO fig_figures;
Version 20.51.2: Mar 18, 2021 Expanded folders database table renamed. (307539 lines)
1 change necessary in database:
RENAME TABLE expanded_folders TO brw_expanded_folders;
Version 20.51.1: Mar 18, 2021 Calls for exams database table renamed. (? lines)
1 change necessary in database:
RENAME TABLE exam_announcements TO cfe_calls_for_exams;
Version 20.51: Mar 18, 2021 Calls for exams module renamed. (307459 lines)
Version 20.50.11: Mar 17, 2021 Departments database table renamed. (307450 lines)
1 change necessary in database:
RENAME TABLE departments TO dpt_departments;
Version 20.50.10: Mar 17, 2021 Connected database table renamed. (307415 lines)
1 change necessary in database:
RENAME TABLE connected TO usr_connected;
Version 20.50.9: Mar 17, 2021 Clipboard database table renamed. (307404 lines)
1 change necessary in database:
RENAME TABLE clipboard TO brw_clipboards;
Version 20.50.8: Mar 17, 2021 Clicks-without-photo database table renamed. (307324 lines)
1 change necessary in database:
RENAME TABLE clicks_without_photo TO pho_clicks_without_photo;
Version 20.50.7: Mar 17, 2021 Chat database table renamed. (307318 lines)
1 change necessary in database:
RENAME TABLE chat TO cht_rooms;
Version 20.50.6: Mar 17, 2021 Buildings database table renamed. (307310 lines)
1 change necessary in database:
RENAME TABLE buildings TO bld_buildings;
Version 20.50.5: Mar 17, 2021 Birthdays-today database table renamed. (307288 lines)
1 change necessary in database:
RENAME TABLE birthdays_today TO usr_birthdays_today;
Version 20.50.4: Mar 17, 2021 Banners database table renamed. (307280 lines)
1 change necessary in database:
RENAME TABLE banners TO ban_banners;
Version 20.50.3: Mar 16, 2021 Assignments database table renamed. (307241 lines)
1 change necessary in database:
RENAME TABLE assignments TO asg_assignments;
Version 20.50.2: Mar 15, 2021 Global announcements database table renamed. (307166 lines)
1 change necessary in database:
RENAME TABLE announcements TO ann_announcements;
Version 20.50.1: Mar 15, 2021 Agendas database table renamed. (307166 lines)
1 change necessary in database:
RENAME TABLE agendas TO agd_agendas;
Version 20.50: Mar 14, 2021 Text of remaining actions copied from English to other languages. (307133 lines)
Version 20.49: Mar 13, 2021 Text of some actions copied from English to other languages. (307132 lines)
Version 20.48.3: Mar 13, 2021 Text of some actions copied from English to other languages. (307131 lines)
Version 20.48.2: Mar 12, 2021 Text of some actions copied from English to other languages. (307130 lines)
Version 20.48.1: Mar 12, 2021 Text of some actions copied from English to other languages. (307129 lines)
Version 20.48: Mar 12, 2021 Text of some actions copied from English to other languages. (307128 lines)
Version 20.47.2: Mar 11, 2021 Text of rest of actions copied from Spanish to Guarani. (307127 lines)
Version 20.47.1: Mar 11, 2021 Text of some actions copied from Spanish to Guarani. (307126 lines)
Version 20.47: Mar 11, 2021 Database table with action texts removed. (307125 lines)
1 change necessary in database:
DROP TABLE IF EXISTS act_actions;
Version 20.46: Mar 11, 2021 All actions translated to English and Spanish. (307184 lines)
Version 20.45.14: Mar 11, 2021 Some actions translated. (307183 lines)
Version 20.45.13: Mar 11, 2021 Some actions translated. (307182 lines)
Version 20.45.12: Mar 10, 2021 Some actions translated. (307181 lines)
Version 20.45.11: Mar 10, 2021 Some actions translated. (307180 lines)
Version 20.45.10: Mar 09, 2021 Some actions translated. (307179 lines)
Version 20.45.9: Mar 09, 2021 Some actions translated. (307178 lines)
Version 20.45.8: Mar 09, 2021 Some actions translated. (307177 lines)
Version 20.45.7: Mar 09, 2021 Some actions translated. (307176 lines)
Version 20.45.6: Mar 08, 2021 Some actions translated. (307175 lines)
Version 20.45.5: Mar 08, 2021 Some actions translated. (307174 lines)
Version 20.45.4: Mar 08, 2021 Some actions translated. (307173 lines)
Version 20.45.3: Mar 08, 2021 Actions database tables renamed. (307170 lines)
2 changes necessary in database:
RENAME TABLE actions TO act_actions;
RENAME TABLE actions_MFU TO act_MFU;
Version 20.45.2: Mar 08, 2021 Countries database table renamed. (307156 lines)
1 change necessary in database:
RENAME TABLE countries TO cty_countrs;
Version 20.45.1: Mar 07, 2021 Institutions database table renamed. (307120 lines)
1 change necessary in database:
RENAME TABLE institutions TO ins_instits;
Version 20.45: Mar 07, 2021 Centers database table renamed.
All variables and files related to centers renamed. (307106 lines)
1 change necessary in database:
RENAME TABLE centres TO ctr_centers;
Version 20.44.4: Mar 06, 2021 Degrees database table renamed. (307021 lines)
1 change necessary in database:
RENAME TABLE courses TO crs_courses;
Version 20.44.3: Mar 06, 2021 Degrees database table renamed. (306004 lines)
1 change necessary in database:
RENAME TABLE degrees TO deg_degrees;
Version 20.44.2: Mar 05, 2021 Admins database table renamed. (305639 lines)
1 change necessary in database:
RENAME TABLE admin TO usr_admins;
Version 20.44.1: Mar 05, 2021 Surveys database table renamed. (305623 lines)
1 change necessary in database:
RENAME TABLE surveys TO svy_surveys;
Version 20.44: Mar 04, 2021 Timeline database tables renamed. (305618 lines)
7 change necessary in database:
RENAME TABLE tl_comments TO tml_comments;
RENAME TABLE tl_comments_fav TO tml_comments_fav;
RENAME TABLE tl_notes TO tml_notes;
RENAME TABLE tl_notes_fav TO tml_notes_fav;
RENAME TABLE tl_posts TO tml_posts;
RENAME TABLE tl_pubs TO tml_pubs;
RENAME TABLE tl_timelines TO tml_timelines;
Version 20.43: Mar 04, 2021 Code refactoring in timeline. (305609 lines)
Version 20.42: Mar 04, 2021 Fixed bugs in GROUP BY, caused by upgrading MySQL 5 (order by default) to MySQL 8 (no order by default). (305624 lines)
3 change necessary in database:
DROP TABLE IF EXISTS crs_usr_backup_delete_me;
DROP TABLE IF EXISTS crs_usr_old_backup_delete_me;
DROP TABLE IF EXISTS log_full;
Version 20.41.5: Mar 03, 2021 Code refactoring in timeline. (305569 lines)
Version 20.41.4: Mar 03, 2021 Code refactoring in timeline publications. (305577 lines)
Version 20.41.3: Mar 03, 2021 Code refactoring in timeline publications. (305580 lines)
Version 20.41.2: Mar 03, 2021 Code refactoring in timeline. (305569 lines)
Version 20.41.1: Mar 03, 2021 Code refactoring in timeline posts. (305563 lines)
Version 20.41: Mar 03, 2021 Code refactoring in timeline comments. (305542 lines)
Version 20.40.3: Mar 03, 2021 Code refactoring in timeline. (305528 lines)
Version 20.40.2: Mar 03, 2021 Code refactoring in fav/share timeline. (305519 lines)
Version 20.40.1: Mar 03, 2021 Code refactoring in fav/share timeline. (305532 lines)
Version 20.40: Mar 03, 2021 Code refactoring in fav/share timeline. (305532 lines)
Version 20.39.11: Mar 02, 2021 Code refactoring in fav/share timeline. (305525 lines)
Version 20.39.10: Mar 02, 2021 Code refactoring in timeline. (305576 lines)
Version 20.39.9: Mar 02, 2021 Code refactoring in timeline. (305580 lines)
Version 20.39.8: Mar 02, 2021 Code refactoring in timeline. (305573 lines)
Version 20.39.7: Mar 02, 2021 Code refactoring in fav/share timeline comments. (305566 lines)
Version 20.39.6: Mar 02, 2021 Code refactoring in fav/share timeline notes. (305570 lines)
Version 20.39.5: Mar 02, 2021 Code refactoring in timeline notes and posts. (305620 lines)
Version 20.39.4: Mar 02, 2021 Code refactoring in timeline notes. (305614 lines)
Version 20.39.3: Mar 02, 2021 Code refactoring in timeline favourites. (305601 lines)
Version 20.39.2: Mar 02, 2021 Code refactoring in timeline database. (305612 lines)
Version 20.39.1: Mar 02, 2021 Code refactoring in timeline comments. (305618 lines)
Version 20.39: Mar 02, 2021 Code refactoring in user's photo. (305610 lines)
Version 20.38.1: Mar 02, 2021 Code refactoring in timeline comments. (305768 lines)
Version 20.38: Mar 02, 2021 Code refactoring in timeline. (305756 lines)
Version 20.37: Mar 01, 2021 Code refactoring and more error messages in timeline. (305681 lines)
Version 20.36.49: Mar 01, 2021 Cleaning unused header files in timeline modules. (305544 lines)
Version 20.36.48: Mar 01, 2021 Query moved to module swad_timeline_database. (305553 lines)
Version 20.36.47: Mar 01, 2021 Query moved to module swad_timeline_database. (305543 lines)
Version 20.36.46: Mar 01, 2021 Fixed bugs in timeline. (305529 lines)
Version 20.36.45: Mar 01, 2021 Queries moved to module swad_timeline_database. (305528 lines)
Version 20.36.44: Mar 01, 2021 Query moved to module swad_timeline_database. (305516 lines)
Version 20.36.43: Mar 01, 2021 Query moved to module swad_timeline_database. (305489 lines)
Version 20.36.42: Mar 01, 2021 Query moved to module swad_timeline_database. (305476 lines)
Version 20.36.41: Mar 01, 2021 Query moved to module swad_timeline_database. (305466 lines)
Version 20.36.40: Mar 01, 2021 Query moved to module swad_timeline_database. (305457 lines)
Version 20.36.39: Mar 01, 2021 Queries moved to module swad_timeline_database. (305448 lines)
Version 20.36.38: Mar 01, 2021 Code refactoring in timeline notifications. (305441 lines)
Version 20.36.37: Mar 01, 2021 Query moved to module swad_timeline_database. (305449 lines)
Version 20.36.36: Mar 01, 2021 Query moved to module swad_timeline_database. (305429 lines)
Version 20.36.35: Mar 01, 2021 Code refactoring in timeline favourites. (305411 lines)
Version 20.36.34: Mar 01, 2021 Function moved to module swad_timeline_database. (305446 lines)
Version 20.36.33: Mar 01, 2021 Function moved to module swad_timeline_database. (305446 lines)
Version 20.36.32: Mar 01, 2021 Query moved to module swad_timeline_database. (305444 lines)
Version 20.36.31: Mar 01, 2021 Code refactoring in timeline favourites. (305432 lines)
Version 20.36.30: Feb 28, 2021 Code refactoring in timeline favourites. (305411 lines)
Version 20.36.29: Feb 28, 2021 Code refactoring in module swad_timeline_database. (305457 lines)
Version 20.36.28: Feb 28, 2021 Functions moved to module swad_timeline_database. (305426 lines)
Version 20.36.27: Feb 28, 2021 Functions moved to module swad_timeline_database. (305424 lines)
Version 20.36.26: Feb 28, 2021 Queries moved to module swad_timeline_database. (305423 lines)
Version 20.36.25: Feb 28, 2021 Queries moved to module swad_timeline_database. (305405 lines)
Version 20.36.24: Feb 28, 2021 Functions moved to module swad_timeline_database. (305385 lines)
Version 20.36.23: Feb 28, 2021 Function moved to module swad_timeline_database. (305387 lines)
Version 20.36.22: Feb 28, 2021 Query moved to module swad_timeline_database. (305387 lines)
Version 20.36.21: Feb 27, 2021 Function moved to module swad_timeline_database. (305376 lines)
Version 20.36.20: Feb 27, 2021 Query moved to module swad_timeline_database. (305374 lines)
Version 20.36.19: Feb 27, 2021 Queries moved to module swad_timeline_database. (305363 lines)
Version 20.36.18: Feb 27, 2021 Function moved to module swad_timeline_database. (305334 lines)
Version 20.36.17: Feb 27, 2021 Query moved to module swad_timeline_database. (305328 lines)
Version 20.36.16: Feb 27, 2021 Query moved to module swad_timeline_database. (305317 lines)
Version 20.36.15: Feb 27, 2021 Functions moved to module swad_timeline_database. (305305 lines)
Version 20.36.14: Feb 27, 2021 Query moved to module swad_timeline_database. (305300 lines)
Version 20.36.13: Feb 27, 2021 Functions moved to module swad_timeline_database. (305285 lines)
Version 20.36.12: Feb 27, 2021 Queries moved to module swad_timeline_database. (305282 lines)
Version 20.36.11: Feb 27, 2021 Query moved to module swad_timeline_database. (305246 lines)
Version 20.36.10: Feb 27, 2021 Query moved to module swad_timeline_database. (305243 lines)
Version 20.36.9: Feb 27, 2021 Query moved to module swad_timeline_database. (305233 lines)
Version 20.36.8: Feb 27, 2021 Function moved to module swad_timeline_database. (305215 lines)
Version 20.36.7: Feb 27, 2021 Query moved to module swad_timeline_database. (305212 lines)
Version 20.36.6: Feb 27, 2021 Queries moved to module swad_timeline_database. (305195 lines)
Version 20.36.5: Feb 26, 2021 Queries moved to module swad_timeline_database. (305179 lines)
Version 20.36.4: Feb 26, 2021 Query moved to module swad_timeline_database. (305156 lines)
Version 20.36.3: Feb 26, 2021 Query moved to module swad_timeline_database. (305140 lines)
Version 20.36.2: Feb 26, 2021 Query moved to module swad_timeline_database. (305126 lines)
Version 20.36.1: Feb 26, 2021 Function moved to module swad_timeline_database. (305113 lines)
Version 20.36: Feb 26, 2021 New module swad_timeline_database. (305133 lines)
Version 20.35.1: Feb 23, 2021 Code refactoring in timeline related to sharing and faving. (305021 lines)
Version 20.35: Feb 23, 2021 Code refactoring in timeline related to sharing and faving. (304986 lines)
Version 20.34.1: Feb 23, 2021 Code refactoring in timeline related to sharing and faving. (305009 lines)
Version 20.34: Feb 23, 2021 Code refactoring in timeline related to sharing and faving. (305011 lines)
Version 20.33.11: Feb 23, 2021 Code refactoring in timeline. (305001 lines)
Version 20.33.10: Feb 23, 2021 Code refactoring related to writing a timeline notes and comments. (305038 lines)
Version 20.33.9: Feb 22, 2021 Code refactoring related to writing a timeline comment. (304949 lines)
Version 20.33.8: Feb 22, 2021 Code refactoring related to writing a timeline note. (304971 lines)
Version 20.33.7: Feb 22, 2021 Code refactoring related to writing a timeline note. (304923 lines)
Version 20.33.6: Feb 22, 2021 Code refactoring related to writing a timeline note. (304898 lines)
Version 20.33.5: Feb 22, 2021 Code refactoring related to writing a timeline note. (304889 lines)
Version 20.33.4: Feb 22, 2021 Some actions renamed. (304883 lines)
Version 20.33.3: Feb 22, 2021 Code refactoring in timeline related to forms. (304882 lines)
Version 20.33.2: Feb 22, 2021 Code refactoring in timeline related to forms. (304880 lines)
Version 20.33.1: Feb 22, 2021 Code refactoring in timeline related to forms. (304888 lines)
Version 20.33: Feb 21, 2021 New module swad_timeline_form. (304866 lines)
Version 20.32.2: Feb 21, 2021 Code refactoring in timeline related to forms. (304771 lines)
Version 20.32.1: Feb 15, 2021 Fixed bug in forums. (304756 lines)
Version 20.32: Feb 15, 2021 Fixed bugs in copy of strings.
Code refactoring in copy of strings. (304755 lines)
Version 20.31: Feb 15, 2021 Code refactoring in copy, concat and sprintf. (304811 lines)
Version 20.30.1: Feb 14, 2021 Code refactoring in timeline related to temporary tables. (305883 lines)
Version 20.30: Feb 11, 2021 Code refactoring in hierarchy. (305853 lines)
Version 20.29.3: Feb 11, 2021 Code refactoring in timeline. (305826 lines)
Version 20.29.2: Feb 11, 2021 Code refactoring in timeline. (305806 lines)
Version 20.29.1: Feb 11, 2021 Code refactoring in timeline. (305780 lines)
Version 20.29: Feb 11, 2021 New module swad_timeline_notification. (305767 lines)
Version 20.28: Feb 11, 2021 New module swad_timeline_user. (305675 lines)
Version 20.27: Feb 11, 2021 New module swad_timeline_post. (305593 lines)
Version 20.26.1: Feb 11, 2021 Code refactoring in timeline. (305504 lines)
Version 20.26: Feb 11, 2021 New module swad_timeline_who. (305540 lines)
Version 20.25: Feb 11, 2021 New module swad_timeline_publication. (305440 lines)
Version 20.24: Feb 11, 2021 Code refactoring in timeline. New linked list to hold publications. (305354 lines)
Version 20.23: Feb 11, 2021 New modules swad_timeline_comment and swad_timeline_note. (305319 lines)
Version 20.22: Feb 10, 2021 Code refactoring in timeline. (305137 lines)
Version 20.21.4: Feb 10, 2021 Code refactoring in timeline. (305136 lines)
Version 20.21.3: Feb 10, 2021 Code refactoring in timeline. (305122 lines)
Version 20.21.2: Feb 10, 2021 Fixed bug in timeline. (305128 lines)
Version 20.21.1: Feb 10, 2021 Code refactoring in timeline. (305128 lines)
Version 20.21: Feb 10, 2021 Code refactoring in timeline. (305094 lines)
Version 20.20.1: Feb 09, 2021 Code refactoring in timeline. (305157 lines)
Version 20.20: Feb 09, 2021 Fixed bug in timeline (a temporary table was removed and now is used again). (305156 lines)
Version 20.19: Feb 09, 2021 Changes in temporary tables used to get timeline. (305122 lines)
Version 20.18.3: Feb 09, 2021 Code refactoring in timeline. (305119 lines)
Version 20.18.2: Feb 09, 2021 Code refactoring in timeline. (305104 lines)
Version 20.18.1: Feb 09, 2021 Code refactoring in timeline. (305100 lines)
Version 20.18: Feb 09, 2021 Removed temporary table not used in timeline. (305096 lines)
Version 20.17: Feb 09, 2021 Code refactoring in timeline. (305110 lines)
Version 20.16.3: Feb 09, 2021 Time is not get from database in timeline publications. (305211 lines)
Version 20.16.2: Feb 09, 2021 Code refactoring in timeline. (305168 lines)
Version 20.16.1: Feb 08, 2021 Code refactoring in timeline. (305167 lines)
Version 20.16: Feb 08, 2021 Code refactoring in timeline. (305169 lines)
Version 20.15.2: Feb 08, 2021 Code refactoring in timeline. (305151 lines)
Version 20.15.1: Feb 08, 2021 Code refactoring in timeline. (305128 lines)
Version 20.15: Feb 08, 2021 Code refactoring in timeline. (305118 lines)
Version 20.14.4: Feb 08, 2021 Code refactoring in timeline. (305096 lines)
Version 20.14.3: Feb 08, 2021 Code refactoring related to parameter who (which users). (305057 lines)
Version 20.14.2: Feb 08, 2021 Code refactoring in timeline. (305044 lines)
Version 20.14.1: Feb 08, 2021 Code refactoring in timeline. (305072 lines)
Version 20.14: Feb 08, 2021 New module timeline_shared. (305048 lines)
Version 20.13: Feb 08, 2021 New module timeline_favourite. (304971 lines)
Version 20.12.1: Feb 08, 2021 Code refactoring in timeline. (304900 lines)
Version 20.12: Feb 08, 2021 Code refactoring in timeline. (304882 lines)
Version 20.11.1: Feb 07, 2021 Fixed bugs in assigments pagination. (304880 lines)
Version 20.11: Feb 07, 2021 An editing teacher can access and modify all files in all projects in course. (304875 lines)
Version 20.10.3: Feb 07, 2021 Fixed bug when a teacher changes a student's photo. Reported by Javier Fernández Baldomero. (304871 lines)
Version 20.10.2: Feb 02, 2021 Pending password is deleted when used for the first time. (304870 lines)
Version 20.10.1: Jan 28, 2021 Exam print returns to the main tab to avoid bug when the student changes the course. (304864 lines)
Version 20.10: Jan 27, 2021 Exam print is visible just after answering it. (304863 lines)
Version 20.9.1: Jan 27, 2021 Code refactoring in exam results. (304865 lines)
Version 20.9: Jan 20, 2021 Exam print ready to be answered is displayed in a new tab.
Code refactoring in exam results. (304829 lines)
Version 20.8: Dec 15, 2020 Fixed bug in file browser. Reported by Javier Fernández Baldomero. (304711 lines)
Version 20.7.4: Dec 01, 2020 Fixed bug in pagination of forums of a thread. Reported by Javier Fernández Baldomero. (304705 lines)
Version 20.7.3: Nov 26, 2020 Fixed bugs in pagination when editing assignments. (304706 lines)
Version 20.7.2: Nov 25, 2020 Changes in edition of matches. (304690 lines)
Version 20.7.1: Nov 25, 2020 New file extension .ipynb, suggested by Pedro A. García Sánchez. (304688 lines)
Copy the following icon to icon public directory:
sudo cp icon/filext32x32/ipynb32x32.gif /var/www/html/swad/icon/filext32x32/
Version 20.7: Nov 25, 2020 Editing match title and groups. (304680 lines)
Version 20.6.2: Nov 24, 2020 Fixed JavaScript bug contracting folders. Reported by Christian Agustín Morillas Gutiérrez. (? lines)
Version 20.6.1: Nov 23, 2020 Fix bug while removing messages. Reported by Christian Agustín Morillas Gutiérrez. (304522 lines)
Version 20.6: Nov 11, 2020 Fixed bug and code refactoring in forums. (304516 lines)
Version 20.5.1: Nov 10, 2020 Fixed bug in file browser, reportedby Luis Javier Herrera Maldonado. (? lines)
Version 20.5: Oct 14, 2020 Code refactoring in remove icon. (304491 lines)
Version 20.4: Oct 13, 2020 Code refactoring in remove icon.
New action to edit a match. Not finished. (304517 lines)
Version 20.3.1: Oct 13, 2020 Code refactoring in file browser. (? lines)
Version 20.3: Sep 30, 2020 Non-editing teachers can list questions in a game. (304528 lines)
Version 20.2.2: Sep 27, 2020 Fixed bug in exam. (304448 lines)
Version 20.2.1: Sep 27, 2020 Fixed bug in exam, reported by Nuria Torres Rosell. (304442 lines)
Version 20.2: Sep 26, 2020 Removed unused action.
Contextual menu in box used to write a new message.
Changes in help links. (304440 lines)
Version 20.1.1: Sep 25, 2020 Old options related to messages removed from menu. (304394 lines)
Copy the following icon to icon public directory:
sudo cp icon/iconset/awesome/comment.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/awesome/comment-alt.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/nuvola/comment.svg /var/www/html/swad/icon/iconset/nuvola/
Version 20.1: Sep 25, 2020 Options related to messages are grouped into one. (304520 lines)
Copy the following 2 icons to icon public directory:
sudo cp icon/inbox.svg /var/www/html/swad/icon/
sudo cp icon/marker.svg /var/www/html/swad/icon/
Version 20.0: Sep 22, 2020 Changes in API function getAvailableRoles.
Fixed bug when listing teachers' records. (304400 lines)
Version 19.263.1: Sep 02, 2020 MAC address in form to create a new room. (304389 lines)
Version 19.263: Sep 02, 2020 New module swad_MAC for MAC addresses. (304364 lines)
Version 19.262: Sep 01, 2020 Edition of MAC addresses in listing of rooms. (304239 lines)
Version 19.261: Sep 01, 2020 MAC addresses are printed in listing of rooms. (304103 lines)
Version 19.260.3: Aug 30, 2020 Fixed bug in API function answerMatchQuestion. Reported by Sergio Díaz Rueda. (304010 lines)
Version 19.260.2: Aug 28, 2020 Fixed bugs in API functions related to games and matches. Reported by Sergio Díaz Rueda. (304010 lines)
Version 19.260.1: Aug 26, 2020 Fixed bugs in API functions related to games and matches. Reported by Sergio Díaz Rueda. (304027 lines)
Version 19.260: Aug 23, 2020 New API function getAvailableRoles. (304009 lines)
Version 19.259: Aug 22, 2020 Changes in API function answerMatchQuestion. (303969 lines)
Version 19.258: Aug 11, 2020 Changes in API functions related to games and matches. (303951 lines)
Version 19.257: Jun 24, 2020 New module swad_match_print. (303887 lines)
Version 19.256: Jun 24, 2020 Code refactoring in tests, exams and matches results. (303841 lines)
Version 19.255.2: Jun 24, 2020 Changes in listing of tests and exams results. (303701 lines)
Version 19.255.1: Jun 23, 2020 Changes in listing of tests results. (303655 lines)
Version 19.255: Jun 23, 2020 Code refactoring in test results. (303625 lines)
Version 19.254.2: Jun 23, 2020 Matches results can only be changed to visible when match is at the end.
If teacher goes back in match, the results change antumatically to hidden. (303667 lines)
Version 19.254.1: Jun 23, 2020 Code refactoring in matches results. (303646 lines)
Version 19.254: Jun 22, 2020 Fixed bug in Javascript related to quotes. Reported by Laura García Rejón. (303653 lines)
Version 19.253: Jun 22, 2020 More details in listing of exams. (303643 lines)
Version 19.252.1: Jun 19, 2020 Changes in listing of exams and matches results. (303245 lines)
Version 19.252: Jun 19, 2020 Fixed bug in exam results, reported by Francisco Ligero Ligero. (303243 lines)
Version 19.251: Jun 18, 2020 Changes in test, exam and match results. (303263 lines)
Version 19.250.3: Jun 18, 2020 Show valid score and valid grade in listing of exam results. (303113 lines)
Version 19.250.2: Jun 17, 2020 Show valid score and valid grade in one exam result. (303069 lines)
Version 19.250.1: Jun 17, 2020 Fixed bug in attendance events, reported by Carlos A. Pozzo. (302977 lines)
Version 19.250: Jun 17, 2020 Exam questions can be invalidated. Not finished. (302974 lines)
1 change necessary in database:
ALTER TABLE exa_set_questions ADD COLUMN Invalid ENUM('N','Y') NOT NULL DEFAULT 'N' AFTER SetCod;
Copy the following 3 icons to icon public directory:
sudo cp icon/times.svg /var/www/html/swad/icon/
sudo cp icon/times-red.svg /var/www/html/swad/icon/
sudo cp icon/check-green.svg /var/www/html/swad/icon/
Version 19.249.1: Jun 17, 2020 Fixed bug removing a course. Reported by Raymon Moreno Colina. (302789 lines)
Version 19.249: Jun 17, 2020 Fixed bug in exams and matches.
Code refactoring in test questions. (302786 lines)
Version 19.248.4: May 30, 2020 Code refactoring in selection of questions. (302867 lines)
Version 19.248.3: May 30, 2020 Selection of all questions to add to a game. (302863 lines)
Version 19.248.2: May 30, 2020 Selection of all questions to add to a set. Suggested by Nuria Torres Rosell. (302854 lines)
Version 19.248.1: May 30, 2020 Exam session results can not be marked as visible if end of time is not in the past. (302825 lines)
Version 19.248: May 30, 2020 New API function getLastLocation. (302787 lines)
Version 19.247.1: May 29, 2020 Do not show exam results in hidden exams or hidden exam sessions. (302646 lines)
Version 19.247: May 25, 2020 New API function sendMyCurrentLocation. (302622 lines)
1 change necessary in database:
CREATE TABLE IF NOT EXISTS room_check_in (ChkCod INT NOT NULL AUTO_INCREMENT,UsrCod INT NOT NULL,RooCod INT NOT NULL,CheckInTime DATETIME NOT NULL,UNIQUE INDEX(ChkCod),INDEX(UsrCod,CheckInTime),INDEX(CheckInTime));
If you want to use MyISAM:
ALTER TABLE room_check_in ENGINE=MyISAM;
Version 19.246.3: May 25, 2020 Fixed bug in notices. (302529 lines)
Version 19.246.2: May 25, 2020 Links to edition of tags in test and test configuration. (302518 lines)
Version 19.246.1: May 25, 2020 Removed unused JavaScript code. (302515 lines)
Version 19.246: May 24, 2020 Fixed issue answering exam prints: when answer is been sent, button to send exam is disabled. (302527 lines)
Version 19.245: May 24, 2020 Session id is stored in a separated table. (302439 lines)
2 changes necessary in database:
ALTER TABLE exa_log DROP COLUMN SessionId;
CREATE TABLE IF NOT EXISTS exa_log_session (LogCod INT NOT NULL,PrnCod INT NOT NULL,SessionId CHAR(43) NOT NULL,UNIQUE INDEX(LogCod),UNIQUE INDEX(PrnCod,LogCod));
If you want to use MyISAM:
ALTER TABLE exa_log_session ENGINE=MyISAM;
Version 19.244.1: May 24, 2020 Prepare to remove exam prints when removed sessions and exams.
Fixed bug writing exam log. (302365 lines)
Version 19.244: May 24, 2020 User agent stored in exam log. (302329 lines)
2 changes necessary in database:
ALTER TABLE exa_log DROP INDEX PrnCod,ADD UNIQUE INDEX(PrnCod,LogCod);
CREATE TABLE IF NOT EXISTS exa_log_user_agent (LogCod INT NOT NULL,PrnCod INT NOT NULL,UserAgent TEXT NOT NULL,UNIQUE INDEX(LogCod),UNIQUE INDEX(PrnCod,LogCod));
If you want to use MyISAM:
ALTER TABLE exa_log_user_agent ENGINE=MyISAM;
Version 19.243: May 23, 2020 List exam log. (302180 lines)
Version 19.242.1: May 23, 2020 Bug fixing and code refactoring in exam log. (301932 lines)
1 change necessary in database:
ALTER TABLE exa_log CHANGE COLUMN Open CanAnswer ENUM('N','Y') NOT NULL DEFAULT 'N';
Version 19.242: May 23, 2020 Changes in exam log. (301911 lines)
1 change necessary in database:
ALTER TABLE exa_log CHANGE COLUMN Saved Open ENUM('N','Y') NOT NULL DEFAULT 'N';
Version 19.241.1: May 23, 2020 Question index added to exam log. (301756 lines)
2 changes necessary in database:
ALTER TABLE exa_log ADD COLUMN QstInd INT NOT NULL DEFAULT -1 AFTER ActCod;
ALTER TABLE exa_log ADD COLUMN Saved ENUM('N','Y') NOT NULL DEFAULT 'N' AFTER QstInd;
If you want to use MyISAM:
ALTER TABLE exa_log ENGINE=MyISAM;
Version 19.241: May 22, 2020 Log in exams.
Bug fixing and code refactoring in tests and exams. (301712 lines)
1 change necessary in database:
CREATE TABLE IF NOT EXISTS exa_log (LogCod INT NOT NULL,PrnCod INT NOT NULL,ActCod INT NOT NULL,ClickTime DATETIME NOT NULL,IP CHAR(15) NOT NULL,SessionId CHAR(43) NOT NULL,UNIQUE INDEX(LogCod),INDEX(PrnCod,ClickTime),INDEX(ClickTime));
Version 19.240: May 21, 2020 Code refactoring in tests and exams. (301428 lines)
Version 19.239.9: May 21, 2020 Fixed issue in exam sessions: exam prints in sessions of hidden exams are no accesible. (301441 lines)
Version 19.239.8: May 21, 2020 Fixed issue in exam sessions: a student can not see hidden sessions. (301433 lines)
Version 19.239.7: May 21, 2020 Fixed bug in permissions to see exam results. Reported by Eduardo Ros Vidal. (301412 lines)
Version 19.239.6: May 21, 2020 Code refactoring in JS function to escape chars. (301411 lines)
Version 19.239.5: May 21, 2020 Fixed bug in charset in answer forms in exam prints. (301405 lines)
Version 19.239.4: May 20, 2020 Fixed bug listing user's exam prints. (301332 lines)
Version 19.239.3: May 20, 2020 Fixed bugs removing exam prints in a course.
Don't remove user's production in a course when removing the user individually. (301316 lines)
Version 19.239.2: May 20, 2020 Fixed bug removing media. (301301 lines)
Version 19.239.1: May 19, 2020 Changes in timeout message. (301300 lines)
Version 19.239: May 19, 2020 Fixed issue due to network timeout while answering exams. Reported by Nuria Torres Rosell. (301316 lines)
Version 19.238.2: May 19, 2020 Exam description is written in exam heading. Suggested by Eva Martínez Ortigosa. (301254 lines)
Version 19.238.1: May 19, 2020 Fixed bug: clicks on answers of exam prints are logged. (301566 lines)
Version 19.238: May 18, 2020 Fix exam-related details.
Removal of exams. (301565 lines)
Copy the following 2 icons to icon public directory:
sudo cp icon/file-signature.svg /var/www/html/swad/icon/
sudo cp icon/gamepad.svg /var/www/html/swad/icon/
Version 19.237: May 18, 2020 Figures about exams. (301325 lines)
Version 19.236.4: May 18, 2020 Fixed minor bug in dates. (301244 lines)
Version 19.236.3: May 18, 2020 Number of players in a match now is calculated as number of users who have result, even in blank. (301243 lines)
Version 19.236.2: May 18, 2020 Fixed bug in matches, reported by Javier Fernández Baldomero. (301241 lines)
Version 19.236.1: May 18, 2020 Fixed bugs in exam results. (301205 lines)
Version 19.236: May 18, 2020 Code refactoring in exams.
Fixed bugs in exams. (301200 lines)
Version 19.235.3: May 17, 2020 Check if temporary public directory exists when got from cache. (301239 lines)
Version 19.235.2: May 17, 2020 Changes in exam prints. (301216 lines)
Version 19.235.1: May 17, 2020 Changes in edition of bank of questions. (301193 lines)
Version 19.235: May 17, 2020 New module swad_tag for question tags. (301147 lines)
Version 19.234: May 17, 2020 Option to edit tags in bank of questions. (301061 lines)
Copy the following 3 icons to icon public directory:
sudo cp icon/tag.svg /var/www/html/swad/icon/
sudo cp icon/tags.svg /var/www/html/swad/icon/
sudo cp icon/hashtag.svg /var/www/html/swad/icon/
Version 19.233: May 17, 2020 Exam event is renamed as exam session. (301028 lines)
7 changes necessary in database:
RENAME TABLE exa_events TO exa_sessions;
ALTER TABLE exa_groups CHANGE COLUMN EvtCod SesCod INT NOT NULL;
ALTER TABLE exa_prints CHANGE COLUMN EvtCod SesCod INT NOT NULL;
ALTER TABLE exa_sessions CHANGE COLUMN EvtCod SesCod INT NOT NULL AUTO_INCREMENT;
ALTER TABLE exa_groups DROP INDEX EvtCod,ADD UNIQUE INDEX(SesCod,GrpCod);
ALTER TABLE exa_prints DROP INDEX EvtCod,ADD UNIQUE INDEX(SesCod,UsrCod);
ALTER TABLE exa_sessions DROP INDEX EvtCod,ADD UNIQUE INDEX(SesCod);
Version 19.232.2: May 16, 2020 When a new tag is created, it is marked as hidden. (301007 lines)
Version 19.232.1: May 16, 2020 Changes in contextual icons in bank of questions and test. (301006 lines)
Copy the following 2 icons to icon public directory:
sudo cp icon/iconset/nuvola/house-user.svg /var/www/html/swad/icon/iconset/nuvola/
sudo cp icon/iconset/nuvola/tasks.png /var/www/html/swad/icon/iconset/nuvola/
Version 19.232: May 16, 2020 New option to edit questions separated from tests. (301000 lines)
Version 19.231: May 16, 2020 Fixed bugs and code refactoring in exam results. (300956 lines)
Version 19.230.3: May 15, 2020 Update maths in exam prints when user answers. (301037 lines)
Version 19.230.2: May 15, 2020 Changes in layout of exam prints.
Changes in edition of sets of questions. (301026 lines)
Version 19.230.1: May 15, 2020 Media in exams are shown occupying 50% instead of 100%. (300985 lines)
Version 19.230: May 15, 2020 Code refactoring and bug fixing in exams. (300984 lines)
Version 19.229.2: May 14, 2020 Some messages translated in exam results. (301070 lines)
Version 19.229.1: May 14, 2020 Removed unused database tables in exams.
Fixed bugs in exam prints. (301009 lines)
6 changes necessary in database:
DROP TABLE exa_answers;
DROP TABLE exa_happening;
DROP TABLE exa_indexes;
DROP TABLE exa_participants;
DROP TABLE exa_results;
DROP TABLE exa_times;
If you want to use MyISAM:
ALTER TABLE exa_prints ENGINE=MyISAM;
ALTER TABLE exa_print_questions ENGINE=MyISAM;
Version 19.229: May 13, 2020 Removed unused code in exam events. (301163 lines)
1 change necessary in database:
ALTER TABLE exa_events DROP COLUMN QstInd,DROP COLUMN QstCod,DROP COLUMN Showing,DROP COLUMN Countdown,DROP COLUMN NumCols,DROP COLUMN ShowQstResults;
Version 19.228.2: May 13, 2020 Code refactoring in exam prints. (303829 lines)
Version 19.228.1: May 13, 2020 Code refactoring in exam prints. (303828 lines)
Version 19.228: May 13, 2020 Code refactoring and bug fixing in exam prints. (303837 lines)
Version 19.227.1: May 13, 2020 Cache of linked GIFs and videos. (303612 lines)
Version 19.227: May 13, 2020 Cache of linked images. (303586 lines)
1 change necessary in database:
CREATE TABLE IF NOT EXISTS file_cache (SessionId CHAR(43) NOT NULL,PrivPath TEXT COLLATE latin1_bin NOT NULL,TmpPubDir TEXT COLLATE latin1_bin NOT NULL,INDEX(SessionId));
If you want to use MyISAM:
ALTER TABLE exa_set_answers ENGINE=MyISAM;
ALTER TABLE exa_set_questions ENGINE=MyISAM;
ALTER TABLE file_cache ENGINE=MyISAM;
Version 19.226: May 12, 2020 Questions and answer are cloned from test bank to exams. (303468 lines)
18 changes necessary in database:
CREATE TABLE IF NOT EXISTS exa_set_answers (QstCod INT NOT NULL,AnsInd TINYINT NOT NULL,Answer TEXT NOT NULL,Feedback TEXT NOT NULL,MedCod INT NOT NULL DEFAULT -1,Correct ENUM('N','Y') NOT NULL,UNIQUE INDEX(QstCod,AnsInd),INDEX(MedCod));
CREATE TABLE IF NOT EXISTS exa_set_questions (QstCod INT NOT NULL AUTO_INCREMENT,SetCod INT NOT NULL,AnsType ENUM ('int','float','true_false','unique_choice','multiple_choice','text') NOT NULL,Shuffle ENUM('N','Y') NOT NULL,Stem TEXT NOT NULL,Feedback TEXT NOT NULL,MedCod INT NOT NULL DEFAULT -1,UNIQUE INDEX(QstCod),UNIQUE INDEX(SetCod,QstCod),INDEX(MedCod));
DELETE FROM exa_answers;
DELETE FROM exa_events;
DELETE FROM exa_exams;
DELETE FROM exa_groups;
DELETE FROM exa_happening;
DELETE FROM exa_indexes;
DELETE FROM exa_participants;
DELETE FROM exa_print_questions;
DELETE FROM exa_prints;
DELETE FROM exa_questions;
DELETE FROM exa_results;
DELETE FROM exa_set_answers;
DELETE FROM exa_set_questions;
DELETE FROM exa_sets;
DELETE FROM exa_times;
DROP TABLE exa_questions;
Version 19.225.1: May 12, 2020 Code refactoring in exam prints.
Unckeck radio button in exam prints. (303057 lines)
Version 19.225: May 12, 2020 Stored unique/multiple choice questions in exam print.
Code refactoring in tests, exams and games. (303037 lines)
Version 19.224: May 11, 2020 API function getLocations returns only one room. (303048 lines)
Version 19.223.3: May 11, 2020 Fixed bug in test exam print, reported by Julio Ortega Lopera. (303050 lines)
Version 19.223.2: May 11, 2020 Stored T/F answers in exam print. (303034 lines)
Version 19.223.1: May 11, 2020 Code refactoring in exam print. Stored float and text answers. (303023 lines)
Version 19.223: May 11, 2020 Store int answer and refresh exam print. (303024 lines)
Version 19.222.2: May 10, 2020 Fixed bugs in exams. (302852 lines)
Version 19.222.1: May 10, 2020 Code refactoring in exam prints. (302794 lines)
Version 19.222: May 10, 2020 Changes in exam prints. (302787 lines)
Version 19.221: May 09, 2020 Changes in exam prints. (302686 lines)
Version 19.220: May 09, 2020 Changes in exam prints. (302480 lines)
1 change necessary in database:
ALTER TABLE exa_print_questions ADD COLUMN SetCod INT NOT NULL AFTER QstInd;
Version 19.219.3: May 09, 2020 Code refactoring in projects. (302366 lines)
Version 19.219.2: May 09, 2020 Fixed bug in roles. Reported by Francisco Ocaña Lara. (302354 lines)
1 change necessary in database:
DELETE FROM figures;
Version 19.219.1: May 09, 2020 By default, only one column is displayed in the layout, for the sake of speed. (302348 lines)
If you want to hide right column for current students and guests, do the following query in database:
UPDATE usr_data SET SideCols=0 WHERE (SideCols & 1)<>0 AND UsrCod NOT IN (SELECT UsrCod FROM crs_usr WHERE Role>3);
Version 19.219: May 09, 2020 Create exam print. (302347 lines)
2 changes necessary in database:
CREATE TABLE IF NOT EXISTS exa_prints (PrnCod INT NOT NULL AUTO_INCREMENT,EvtCod INT NOT NULL,UsrCod INT NOT NULL,StartTime DATETIME NOT NULL,EndTime DATETIME NOT NULL,NumQsts INT NOT NULL DEFAULT 0,NumQstsNotBlank INT NOT NULL DEFAULT 0,Sent ENUM('N','Y') NOT NULL DEFAULT 'N',Score DOUBLE PRECISION NOT NULL DEFAULT 0,UNIQUE INDEX(PrnCod),UNIQUE INDEX(EvtCod,UsrCod));
CREATE TABLE IF NOT EXISTS exa_print_questions (PrnCod INT NOT NULL,QstCod INT NOT NULL,QstInd INT NOT NULL,Score DOUBLE PRECISION NOT NULL DEFAULT 0,Indexes TEXT NOT NULL,Answers TEXT NOT NULL,UNIQUE INDEX(PrnCod,QstCod));
Version 19.218.1: May 07, 2020 Fixed minor bug in test results and match results. (302171 lines)
Version 19.218: May 07, 2020 Fixed bug in creation of new exam announcements, reported by Francisco Gómez Mula.
Changes in exam announcementes. (302170 lines)
Version 19.217: May 07, 2020 Generate and show questions of each set in an exam print. Not finished. (302124 lines)
Version 19.216.1: May 07, 2020 Fixed bug in edition of exam questions. Reported by Antonio Cañas Martínez.
Changes in some texts. (301957 lines)
Version 19.216: May 07, 2020 New module exam_print to generate new exam prints. (301949 lines)
1 change necessary in database:
ALTER TABLE exa_sets CHANGE COLUMN NumQstsToExam NumQstsToPrint INT NOT NULL DEFAULT 0;
Version 19.215: May 07, 2020 New module exam_set for set of questions. (301695 lines)
Version 19.214.1: May 07, 2020 Change color of dates on current exam event. (301597 lines)
Version 19.214: May 06, 2020 New API function getLocations. (301568 lines)
1 change necessary in database:
CREATE TABLE IF NOT EXISTS room_MAC (RooCod INT NOT NULL AUTO_INCREMENT,MAC BIGINT NOT NULL,UNIQUE INDEX(RooCod,MAC),UNIQUE INDEX(MAC,RooCod));
If you want to use MyISAM:
ALTER TABLE room_MAC ENGINE=MyISAM;
Version 19.213.2: May 06, 2020 Changed settings of firewall. (301361 lines)
Version 19.213.1: May 06, 2020 Fixed bug in edition of set of questions. (301357 lines)
Version 19.213: May 06, 2020 Edition of exam event.
Code refactoring in groups. (301327 lines)
Version 19.212: May 05, 2020 Icon to edit exam event. (301319 lines)
Version 19.211: May 05, 2020 Exam events can be hidden/unhidden. (301215 lines)
1 change necessary in database:
ALTER TABLE exa_events ADD COLUMN Hidden ENUM('N','Y') NOT NULL DEFAULT 'N' AFTER ExaCod;
Version 19.210.4: May 05, 2020 Fixed bug searching courses. (301103 lines)
Version 19.210.3: May 03, 2020 All figures cacheable are cached everytime they are calculated. (301089 lines)
Version 19.210.2: May 03, 2020 More figures cached. (301125 lines)
Version 19.210.1: May 03, 2020 More figures cached. (301129 lines)
Version 19.210: May 03, 2020 More figures cached. (301124 lines)
1 change necessary in database:
DELETE FROM figures;
Version 19.209.6: May 02, 2020 More figures cached. (300815 lines)
Version 19.209.5: May 02, 2020 More figures cached. (300756 lines)
Version 19.209.4: May 02, 2020 More figures cached.
Code refactoring in hierarchy configuration. (300637 lines)
Version 19.209.3: May 01, 2020 More figures cached. (300750 lines)
1 change necessary in database:
DELETE FROM figures;
Version 19.209.2: May 01, 2020 Fixed bug in figures cached. (300737 lines)
Version 19.209.1: May 01, 2020 Fixed bug in figures cached. (? lines)
Version 19.209: May 01, 2020 More figures cached. (300734 lines)
3 changes necessary in database:
ALTER TABLE figures CHANGE COLUMN Value ValueInt INT NOT NULL DEFAULT 0;
ALTER TABLE figures ADD COLUMN ValueDouble DOUBLE PRECISION NOT NULL DEFAULT 0 AFTER ValueInt;
DELETE FROM figures;
Version 19.208.1: May 01, 2020 Fixed bug in cache of figures. (300599 lines)
Version 19.208: May 01, 2020 New module for cache of figures. (300598 lines)
1 change necessary in database:
CREATE TABLE IF NOT EXISTS figures (Figure INT NOT NULL,Scope ENUM('Sys','Cty','Ins','Ctr','Deg','Crs') NOT NULL DEFAULT 'Sys',Cod INT NOT NULL DEFAULT -1,Value INT NOT NULL,LastUpdate TIMESTAMP,UNIQUE INDEX(Figure,Scope,Cod));
If you want to use MyISAM:
ALTER TABLE figures ENGINE=MyISAM;
Version 19.207.4: Apr 30, 2020 Fixed bug in test result, reported by Mancia Anguita López. (300363 lines)
Version 19.207.3: Apr 30, 2020 Fixed bug removing account. (300335 lines)
Version 19.207.2: Apr 30, 2020 Fixed bug creating account, reported by Antonio Becerra. (300334 lines)
Version 19.207.1: Apr 30, 2020 Optimization in table of last prefs on user-course. (300323 lines)
5 changes necessary in database:
ALTER TABLE crs_usr CHANGE COLUMN CrsCod CrsCod INT NOT NULL;
ALTER TABLE crs_usr_last CHANGE COLUMN CrsCod CrsCod INT NOT NULL AFTER UsrCod;
ALTER TABLE crs_usr_last DROP INDEX CrsCod;
OPTIMIZE TABLE crs_usr;
OPTIMIZE TABLE crs_usr_last;
Version 19.207: Apr 30, 2020 Table with inscriptions of users in courses is splitted into two tables for speed. (300323 lines)
8 changes necessary in database:
RENAME TABLE crs_usr_old TO crs_usr_old_backup_delete_me;
CREATE TABLE crs_usr_backup_delete_me AS SELECT * FROM crs_usr;
CREATE TABLE crs_usr_last AS SELECT * FROM crs_usr;
ALTER TABLE crs_usr_last DROP COLUMN Role;
ALTER TABLE crs_usr_last DROP COLUMN Accepted;
ALTER TABLE crs_usr_last ADD UNIQUE INDEX(CrsCod,UsrCod);
ALTER TABLE crs_usr_last ADD UNIQUE INDEX(UsrCod,CrsCod);
ALTER TABLE crs_usr DROP COLUMN LastDowGrpCod, DROP COLUMN LastComGrpCod, DROP COLUMN LastAssGrpCod, DROP COLUMN NumAccTst, DROP COLUMN LastAccTst, DROP COLUMN NumQstsLastTst, DROP COLUMN UsrListType, DROP COLUMN ColsClassPhoto, DROP COLUMN ListWithPhotos;
If you want to use MyISAM:
ALTER TABLE crs_usr_last ENGINE=MyISAM;
OPTIMIZE TABLE crs_usr_last;
OPTIMIZE TABLE crs_usr;
Version 19.206.3: Apr 30, 2020 Added indexes on database table. (300244 lines)
10 changes necessary in database:
RENAME TABLE crs_usr TO crs_usr_old;
CREATE TABLE crs_usr AS SELECT * FROM crs_usr_old;
ALTER TABLE crs_usr ADD UNIQUE INDEX(CrsCod,UsrCod);
ALTER TABLE crs_usr ADD UNIQUE INDEX(CrsCod,UsrCod,Role);
ALTER TABLE crs_usr ADD UNIQUE INDEX(UsrCod,CrsCod);
ALTER TABLE crs_usr ADD UNIQUE INDEX(UsrCod,CrsCod,Role);
ALTER TABLE crs_usr ADD UNIQUE INDEX(Role,CrsCod,UsrCod);
ALTER TABLE crs_usr ADD UNIQUE INDEX(Role,UsrCod,CrsCod);
ALTER TABLE crs_usr ADD INDEX(CrsCod,Role);
ALTER TABLE crs_usr ADD INDEX(UsrCod,Role);
If you want to use MyISAM:
ALTER TABLE crs_usr ENGINE=MyISAM;
OPTIMIZE TABLE crs_usr;
Version 19.206.2: Apr 29, 2020 Teachers and administrators can not be seen by non logged users. (300244 lines)
Version 19.206.1: Apr 29, 2020 Changes in phones. (300243 lines)
Version 19.206: Apr 29, 2020 Removed addresses in user's data. (300259 lines)
Version 19.205: Apr 29, 2020 Removed origin place in user's data. (300399 lines)
Version 19.204.5: Apr 28, 2020 Save start and end dates on creation of exam event. (300471 lines)
Version 19.204.4: Apr 28, 2020 Fixed bug in creation of new exam. (300470 lines)
Version 19.204.3: Apr 28, 2020 List updated exam events after creation. (300521 lines)
Version 19.204.2: Apr 28, 2020 Changes in creation of exam events. (300503 lines)
Version 19.204.1: Apr 28, 2020 Fixed problem in listing of set questions when questions have been removed. (300480 lines)
Version 19.204: Apr 27, 2020 Remove question from set of questions. (300466 lines)
Version 19.203: Apr 27, 2020 List questions in every set of questions. (300606 lines)
3 changes necessary in database:
ALTER TABLE exa_questions DROP INDEX SetCod,DROP INDEX SetCod_2;
ALTER TABLE exa_questions DROP COLUMN QstInd;
ALTER TABLE exa_questions ADD UNIQUE INDEX(SetCod,QstCod);
Version 19.202: Apr 27, 2020 Form to add questions to set of questions. (300558 lines)
5 changes necessary in database:
ALTER TABLE exa_questions CHANGE COLUMN QstInd QstInd INT NOT NULL AFTER SetCod;
ALTER TABLE exa_questions DROP INDEX SetCod;
ALTER TABLE exa_questions DROP INDEX QstCod;
ALTER TABLE exa_questions ADD UNIQUE INDEX(SetCod,QstInd);
ALTER TABLE exa_questions ADD UNIQUE INDEX(SetCod,QstCod);
Version 19.201: Apr 27, 2020 Form to change number of questions in exam.
Code refactoring in HTML forms. (300755 lines)
Version 19.200: Apr 27, 2020 Text of actions related to exams.
Form to change title of set of questions. (300526 lines)
Version 19.199.3: Apr 27, 2020 Changes moving sets of questions in an exam up and down. (299361 lines)
2 changes necessary in database:
ALTER TABLE gam_questions CHANGE COLUMN QstInd QstInd INT NOT NULL;
ALTER TABLE exa_sets CHANGE COLUMN SetInd SetInd INT NOT NULL;
ALTER TABLE exa_sets DROP INDEX ExaCod;
ALTER TABLE exa_sets ADD UNIQUE INDEX(ExaCod,SetInd);
Version 19.199.2: Apr 27, 2020 Changes moving questions in a game up and down. (299345 lines)
5 changes necessary in database:
ALTER TABLE gam_questions CHANGE COLUMN QstInd QstInd INT NOT NULL DEFAULT 0 AFTER GamCod;
ALTER TABLE gam_questions DROP INDEX GamCod;
ALTER TABLE gam_questions DROP INDEX QstCod;
ALTER TABLE gam_questions ADD UNIQUE INDEX(GamCod,QstInd);
ALTER TABLE gam_questions ADD UNIQUE INDEX(GamCod,QstCod);
Version 19.199.1: Apr 26, 2020 Changes moving set of questions up and down. (299308 lines)
Version 19.199: Apr 26, 2020 Move set of questions up and down. (299344 lines)
Version 19.198: Apr 26, 2020 Remove set of questions. (299054 lines)
3 changes necessary in database:
ALTER TABLE exa_questions DROP INDEX ExaCod;
ALTER TABLE exa_questions CHANGE COLUMN ExaCod SetCod INT NOT NULL;
ALTER TABLE exa_questions ADD INDEX(SetCod);
Version 19.197: Apr 26, 2020 Ask user to remove set of questions. (298954 lines)
Version 19.196.1: Apr 25, 2020 Changes in edition of exams. (298857 lines)
Version 19.196: Apr 25, 2020 Changes in edition of sets of questions. (298866 lines)
Version 19.195.1: Apr 25, 2020 Translation of messages related to sets of questions. (298840 lines)
Version 19.195: Apr 25, 2020 Changes in sets of questions. (298699 lines)
2 changes necessary in database:
ALTER TABLE exa_sets ADD COLUMN NumQstsToExam INT NOT NULL DEFAULT 0 AFTER SetInd;
ALTER TABLE exa_sets ADD COLUMN Title VARCHAR(2047) NOT NULL AFTER NumQstsToExam;
Version 19.194.1: Apr 24, 2020 Translation of messages related to sets of questions. (? lines)
Version 19.194: Apr 24, 2020 New database table for set of questions in exams. (298257 lines)
1 change necessary in database:
CREATE TABLE IF NOT EXISTS exa_sets (SetCod INT NOT NULL AUTO_INCREMENT,ExaCod INT NOT NULL,SetInd INT NOT NULL DEFAULT 0,UNIQUE INDEX(SetCod),INDEX(ExaCod,SetInd));
Version 19.193.5: Apr 23, 2020 Fixed bug in exam events. (297871 lines)
Version 19.193.4: Apr 23, 2020 Fixed bugs in exams, exam events, games and matches. (297860 lines)
Version 19.193.3: Apr 23, 2020 Added new MIME type, reported by Jesús Garrido Manrique.
Changed text in test configuration. (297640 lines)
1 change necessary in database:
UPDATE tst_config SET Pluggable='unknown' WHERE Pluggable='Y';
Version 19.193.2: Apr 23, 2020 Buttons translated in tests. (297626 lines)
Version 19.193.1: Apr 23, 2020 Changes in CSS for exams.
Changes in JavaScript for exams. (297623 lines)
Version 19.193: Apr 22, 2020 Created database tables related to exams. (297127 lines)
2 changes necessary in database:
CREATE TABLE IF NOT EXISTS exa_answers (EvtCod INT NOT NULL,UsrCod INT NOT NULL,QstInd INT NOT NULL,NumOpt TINYINT NOT NULL,AnsInd TINYINT NOT NULL,UNIQUE INDEX(EvtCod,UsrCod,QstInd));
CREATE TABLE IF NOT EXISTS exa_groups (EvtCod INT NOT NULL,GrpCod INT NOT NULL,UNIQUE INDEX(EvtCod,GrpCod));
CREATE TABLE IF NOT EXISTS exa_events (EvtCod INT NOT NULL AUTO_INCREMENT,ExaCod INT NOT NULL,UsrCod INT NOT NULL,StartTime DATETIME NOT NULL,EndTime DATETIME NOT NULL,Title VARCHAR(2047) NOT NULL,QstInd INT NOT NULL DEFAULT 0,QstCod INT NOT NULL DEFAULT -1,Showing ENUM('start','stem','answers','results','end') NOT NULL DEFAULT 'start',Countdown INT NOT NULL DEFAULT -1,NumCols INT NOT NULL DEFAULT 1,ShowQstResults ENUM('N','Y') NOT NULL DEFAULT 'N',ShowUsrResults ENUM('N','Y') NOT NULL DEFAULT 'N',UNIQUE INDEX(EvtCod),INDEX(ExaCod));
CREATE TABLE IF NOT EXISTS exa_exams (ExaCod INT NOT NULL AUTO_INCREMENT,CrsCod INT NOT NULL DEFAULT -1,Hidden ENUM('N','Y') NOT NULL DEFAULT 'N',UsrCod INT NOT NULL,MaxGrade DOUBLE PRECISION NOT NULL DEFAULT 1,Visibility INT NOT NULL DEFAULT 0x1f,Title VARCHAR(2047) NOT NULL,Txt TEXT NOT NULL,UNIQUE INDEX(ExaCod),INDEX(CrsCod));
CREATE TABLE IF NOT EXISTS exa_happening (EvtCod INT NOT NULL,TS TIMESTAMP,UNIQUE INDEX(EvtCod));
CREATE TABLE IF NOT EXISTS exa_indexes (EvtCod INT NOT NULL,QstInd INT NOT NULL,Indexes TEXT NOT NULL,UNIQUE INDEX(EvtCod,QstInd));
CREATE TABLE IF NOT EXISTS exa_participants (EvtCod INT NOT NULL,UsrCod INT NOT NULL,TS TIMESTAMP,UNIQUE INDEX(EvtCod,UsrCod));
CREATE TABLE IF NOT EXISTS exa_questions (ExaCod INT NOT NULL,QstCod INT NOT NULL,QstInd INT NOT NULL DEFAULT 0,INDEX(ExaCod),INDEX(QstCod));
CREATE TABLE IF NOT EXISTS exa_results (EvtCod INT NOT NULL,UsrCod INT NOT NULL,StartTime DATETIME NOT NULL,EndTime DATETIME NOT NULL,NumQsts INT NOT NULL DEFAULT 0,NumQstsNotBlank INT NOT NULL DEFAULT 0,Score DOUBLE PRECISION NOT NULL DEFAULT 0,UNIQUE INDEX(EvtCod,UsrCod));
CREATE TABLE IF NOT EXISTS exa_times (EvtCod INT NOT NULL,QstInd INT NOT NULL,ElapsedTime TIME NOT NULL DEFAULT 0,UNIQUE INDEX(EvtCod,QstInd));
Version 19.192.1: Apr 22, 2020 Changed icon for exams. (296807 lines)
Copy the following 2 icons to icon public directory:
sudo cp icon/iconset/awesome/file-signature.svg /var/www/html/swad/icon/iconset/awesome
sudo cp icon/iconset/nuvola/file-signature.png /var/www/html/swad/icon/iconset/nuvola
Version 19.192: Apr 22, 2020 Changes in exams. (296803 lines)
Copy the following 4 icons to icon public directory:
sudo cp icon/iconset/awesome/file-contract.svg /var/www/html/swad/icon/iconset/awesome
sudo cp icon/iconset/awesome/file-invoice.svg /var/www/html/swad/icon/iconset/awesome
sudo cp icon/iconset/nuvola/file-contract.png /var/www/html/swad/icon/iconset/nuvola
sudo cp icon/iconset/nuvola/file-invoice.png /var/www/html/swad/icon/iconset/nuvola
Version 19.191: Apr 20, 2020 Module swad_exam for exam announcements is renamed as swad_exam_announcement.
New modules swad_exam, swad_exam_event and swad_exam_result to make exams. (295885 lines)
Version 19.190.5: Apr 19, 2020 Anchors in forms to edit buildings and rooms. (288527 lines)
Version 19.190.4: Apr 19, 2020 Icons for room types. (288516 lines)
Copy the following 23 icons to icon public directory:
sudo cp icon/book.svg /var/www/html/swad/icon/
sudo cp icon/car.svg /var/www/html/swad/icon/
sudo cp icon/chalkboard.svg /var/www/html/swad/icon/
sudo cp icon/child.svg /var/www/html/swad/icon/
sudo cp icon/cloud-sun.svg /var/www/html/swad/icon/
sudo cp icon/coffee.svg /var/www/html/swad/icon/
sudo cp icon/concierge-bell.svg /var/www/html/swad/icon/
sudo cp icon/dolly.svg /var/www/html/swad/icon/
sudo cp icon/door-closed.svg /var/www/html/swad/icon/
sudo cp icon/door-open.svg /var/www/html/swad/icon/
sudo cp icon/dumbbell.svg /var/www/html/swad/icon/
sudo cp icon/flask.svg /var/www/html/swad/icon/
sudo cp icon/landmark.svg /var/www/html/swad/icon/
sudo cp icon/laptop-house.svg /var/www/html/swad/icon/
sudo cp icon/map-signs.svg /var/www/html/swad/icon/
sudo cp icon/shopping-basket.svg /var/www/html/swad/icon/
sudo cp icon/shopping-cart.svg /var/www/html/swad/icon/
sudo cp icon/stamp.svg /var/www/html/swad/icon/
sudo cp icon/toilet.svg /var/www/html/swad/icon/
sudo cp icon/tree.svg /var/www/html/swad/icon/
sudo cp icon/utensils.svg /var/www/html/swad/icon/
sudo cp icon/volleyball-ball.svg /var/www/html/swad/icon/
sudo cp icon/walking.svg /var/www/html/swad/icon/
Version 19.190.3: Apr 18, 2020 Fixed bug in creation of a new room. (288489 lines)
Version 19.190.2: Apr 18, 2020 Fixed bugs in degree photo. (288485 lines)
Version 19.190.1: Apr 18, 2020 Fixed bugs in degree photo, reported by Adrián José Martínez Navarro. (288491 lines)
Version 19.190: Apr 18, 2020 Changes in rooms. (288488 lines)
2 changes necessary in database:
ALTER TABLE rooms ADD COLUMN Type ENUM('no_type','administration','auditorium','cafeteria','canteen','classroom','concierge','corridor','gym','hall','kindergarten','laboratory','library','office','outdoors','parking','pavilion','room','secretariat','seminar','shop','store','toilets','virtual','yard') NOT NULL DEFAULT 'no_type' AFTER Floor;
DROP TABLE IF EXISTS log_old;
Version 19.189: Apr 16, 2020 Fixed security issue in test exams.
Removed table with test status. (287719 lines)
3/4 changes necessary in database:
ALTER TABLE tst_exams ADD COLUMN Sent ENUM('N','Y') NOT NULL DEFAULT 'N' AFTER NumQstsNotBlank;
UPDATE tst_exams SET Sent='Y';
DROP TABLE IF EXISTS tst_status;
Only if you use MyISAM:
ALTER TABLE buildings ENGINE=MyISAM;
Version 19.188.2: Apr 16, 2020 Changed some icons. (287754 lines)
Copy the following icons to icon public directory:
sudo cp icon/house-user.svg /var/www/html/swad/icon/
sudo cp icon/iconset/awesome/house-user.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/nuvola/house-user.svg /var/www/html/swad/icon/iconset/nuvola/
sudo cp icon/user-circle.svg /var/www/html/swad/icon/
sudo cp icon/iconset/awesome/user-circle.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/nuvola/user-circle.svg /var/www/html/swad/icon/iconset/nuvola/
Version 19.188.1: Apr 16, 2020 Changed some icons. (287746 lines)
Copy the following icons to icon public directory:
sudo cp icon/address-card.svg /var/www/html/swad/icon/
sudo cp icon/iconset/awesome/address-card.svg /var/www/html/swad/icon/iconset/awesome/
sudo cp icon/iconset/nuvola/address-card.svg /var/www/html/swad/icon/iconset/nuvola/
Version 19.188: Apr 15, 2020 Changes in listing and edition of rooms. (287713 lines)
1 change necessary in database:
ALTER TABLE rooms DROP COLUMN Location;
Version 19.187: Apr 15, 2020 New columns in rooms for building and floor. Not finished. (287671 lines)
3 changes necessary in database:
ALTER TABLE rooms ADD COLUMN BldCod INT NOT NULL DEFAULT -1 AFTER CtrCod;
ALTER TABLE rooms ADD COLUMN Floor INT NOT NULL DEFAULT 0 AFTER BldCod;
ALTER TABLE rooms DROP INDEX CtrCod,ADD INDEX(CtrCod,BldCod,Floor);
Version 19.186.1: Apr 14, 2020 Fixed bug in edition of test questions. (287379 lines)
Version 19.186: Apr 14, 2020 New module swad_building for buildings in a centre. (287372 lines)
1 change necessary in database:
CREATE TABLE IF NOT EXISTS buildings (BldCod INT NOT NULL AUTO_INCREMENT,CtrCod INT NOT NULL,ShortName VARCHAR(511) NOT NULL,FullName VARCHAR(2047) NOT NULL,Location VARCHAR(2047) NOT NULL,UNIQUE INDEX(BldCod),INDEX(CtrCod));
Version 19.185: Apr 14, 2020 Module swad_classroom is renamed as swad_room.
Improvement in querying the database in the usage report. (285813 lines)
5 changes necessary in database:
RENAME TABLE classrooms TO rooms;
ALTER TABLE rooms CHANGE COLUMN ClaCod RooCod INT NOT NULL AUTO_INCREMENT;
ALTER TABLE rooms DROP INDEX ClaCod,ADD UNIQUE INDEX(RooCod);
ALTER TABLE crs_grp CHANGE COLUMN ClaCod RooCod INT NOT NULL DEFAULT -1;
ALTER TABLE crs_grp DROP INDEX ClaCod,ADD INDEX(RooCod);
Version 19.184: Apr 14, 2020 Code refactoring in classrooms. (285706 lines)
Version 19.183.2: Apr 14, 2020 Fixed bug in test exams. (285684 lines)
Version 19.183.1: Apr 14, 2020 Fixed bug in forums, reported by Javier Fernández Baldomero. (285677 lines)
Version 19.183: Apr 13, 2020 Code refactoring in holidays. (285689 lines)
Version 19.182: Apr 13, 2020 Code refactoring in places. (285685 lines)
Version 19.181: Apr 13, 2020 Code refactoring in departments. (285667 lines)
Version 19.180.5: Apr 13, 2020 Fixed bug in statistics. (285637 lines)
Version 19.180.4: Apr 13, 2020 Fixed bug in attendance.
Fixed bug in lists of users.
Fixed bug in dates (assignments, agenda). (285622 lines)
Version 19.180.3: Apr 13, 2020 Fixed bug in course info. (285614 lines)
Version 19.180.2: Apr 13, 2020 Fixed bugs in syllabus. (285613 lines)
Version 19.180.1: Apr 12, 2020 Changes in stats of clicks. (285599 lines)
Version 19.180: Apr 12, 2020 Code refactoring in photo of degree. (285603 lines)
Version 19.179: Apr 12, 2020 Code refactoring in indicators. (285582 lines)
Version 19.178: Apr 12, 2020 Code refactoring in statistics. (285569 lines)
Version 19.177: Apr 12, 2020 Code refactoring in exam announcements. (285509 lines)
Version 19.176: Apr 12, 2020 Code refactoring in agenda. (285419 lines)
Version 19.175: Apr 12, 2020 Code refactoring in syllabus. (285345 lines)
Version 19.174: Apr 11, 2020 Code refactoring in messages. (285250 lines)
Version 19.173: Apr 11, 2020 Code refactoring in timetables. (285165 lines)
Version 19.172.1: Apr 11, 2020 Fix bug in MathJax. (285144 lines)
Version 19.172: Apr 11, 2020 Code refactoring in timeline. (285139 lines)
Version 19.171: Apr 10, 2020 Code refactoring in surveys. (285010 lines)
Version 19.170: Apr 09, 2020 Code refactoring in projects. (284941 lines)
Version 19.169.6: Apr 08, 2020 Mark some parameters as unused (functions from S to Z). (284836 lines)
Version 19.169.5: Apr 08, 2020 Mark some parameters as unused (functions from O to R). (284854 lines)
Version 19.169.4: Apr 08, 2020 Mark some parameters as unused (functions from I to N). (284903 lines)
Version 19.169.3: Apr 08, 2020 Mark some parameters as unused (functions from D to I). (284929 lines)
Version 19.169.2: Apr 08, 2020 Mark some parameters as unused (functions from A to C). (284969 lines)
Version 19.169.1: Apr 08, 2020 Mark some parameters as unused. (284999 lines)
Version 19.169: Apr 08, 2020 Code refactoring in games and matches. (285024 lines)
Version 19.168: Apr 07, 2020 Code refactoring in forums. (284866 lines)
Version 19.167: Apr 06, 2020 Code refactoring in figures. (284772 lines)
Version 19.166.1: Apr 06, 2020 Fixed bug in API function loginByUserPasswordKey, reported by Javier Bueno López. (? lines)
Version 19.166: Apr 06, 2020 Code refactoring in banners. (284805 lines)
Version 19.165: Apr 06, 2020 Code refactoring in attendance events. (284743 lines)
Version 19.164: Apr 05, 2020 Code refactoring in assignments and pagination. (284644 lines)
Version 19.163: Apr 05, 2020 Log table is now partitioned by years. (284617 lines)
20 changes necessary in database:
CREATE TABLE IF NOT EXISTS log (LogCod INT NOT NULL AUTO_INCREMENT,ActCod INT NOT NULL DEFAULT -1,CtyCod INT NOT NULL DEFAULT -1,InsCod INT NOT NULL DEFAULT -1,CtrCod INT NOT NULL DEFAULT -1,DegCod INT NOT NULL DEFAULT -1,CrsCod INT NOT NULL DEFAULT -1,UsrCod INT NOT NULL DEFAULT -1,Role TINYINT NOT NULL,ClickTime DATETIME NOT NULL,TimeToGenerate INT NOT NULL,TimeToSend INT NOT NULL,IP CHAR(15) NOT NULL,PRIMARY KEY(LogCod,ClickTime),INDEX(ActCod),INDEX(CtyCod),INDEX(InsCod),INDEX(CtrCod),INDEX(DegCod),INDEX(CrsCod),INDEX(UsrCod),INDEX(ClickTime,Role)) ENGINE=InnoDB PARTITION BY RANGE (YEAR(ClickTime)) (PARTITION p2004 VALUES LESS THAN (2005),PARTITION p2005 VALUES LESS THAN (2006),PARTITION p2006 VALUES LESS THAN (2007),PARTITION p2007 VALUES LESS THAN (2008),PARTITION p2008 VALUES LESS THAN (2009),PARTITION p2009 VALUES LESS THAN (2010),PARTITION p2010 VALUES LESS THAN (2011),PARTITION p2011 VALUES LESS THAN (2012),PARTITION p2012 VALUES LESS THAN (2013),PARTITION p2013 VALUES LESS THAN (2014),PARTITION p2014 VALUES LESS THAN (2015),PARTITION p2015 VALUES LESS THAN (2016),PARTITION p2016 VALUES LESS THAN (2017),PARTITION p2017 VALUES LESS THAN (2018),PARTITION p2018 VALUES LESS THAN (2019),PARTITION p2019 VALUES LESS THAN (2020),PARTITION p2020 VALUES LESS THAN (2021),PARTITION p2021 VALUES LESS THAN (2022),PARTITION p2022 VALUES LESS THAN (2023),PARTITION p2023 VALUES LESS THAN (2024),PARTITION p2024 VALUES LESS THAN (2025),PARTITION p2025 VALUES LESS THAN (2026),PARTITION p2026 VALUES LESS THAN (2027),PARTITION p2027 VALUES LESS THAN (2028),PARTITION p2028 VALUES LESS THAN (2029),PARTITION p2029 VALUES LESS THAN (2030),PARTITION p2030 VALUES LESS THAN (2031),PARTITION p2031 VALUES LESS THAN (2032),PARTITION p2032 VALUES LESS THAN (2033),PARTITION p2033 VALUES LESS THAN (2034),PARTITION p2034 VALUES LESS THAN (2035),PARTITION p2035 VALUES LESS THAN (2036),PARTITION p2036 VALUES LESS THAN (2037),PARTITION p2037 VALUES LESS THAN (2038),PARTITION p2038 VALUES LESS THAN (2039),PARTITION p2039 VALUES LESS THAN (2040),PARTITION p2040 VALUES LESS THAN (2041),PARTITION p2041 VALUES LESS THAN (2042),PARTITION p2042 VALUES LESS THAN (2043),PARTITION p2043 VALUES LESS THAN (2044),PARTITION p2044 VALUES LESS THAN (2045),PARTITION p2045 VALUES LESS THAN (2046),PARTITION p2046 VALUES LESS THAN (2047),PARTITION p2047 VALUES LESS THAN (2048),PARTITION p2048 VALUES LESS THAN (2049),PARTITION p2049 VALUES LESS THAN (2050),PARTITION p2050 VALUES LESS THAN MAXVALUE);
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) < 2005;
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) = 2005;
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) = 2006;
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) = 2007;
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) = 2008;
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) = 2009;
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) = 2010;
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) = 2011;
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) = 2012;
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) = 2013;
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) = 2014;
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) = 2015;
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) = 2016;
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) = 2017;
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) = 2018;
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) = 2019;
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) = 2020;
INSERT INTO log SELECT * FROM log_full WHERE YEAR(ClickTime) > 2020;
RENAME TABLE log_full TO log_old;
Version 19.162: Apr 04, 2020 Code refactoring in tests. (284492 lines)
Version 19.161: Apr 04, 2020 Code refactoring in tests. (284529 lines)
Version 19.160.1: Apr 03, 2020 Score calculated is removed from each test question. (284817 lines)
Version 19.160: Apr 03, 2020 The score for each test question displayed in an exam is the one stored in the database instead of being calculated.
New file extension, suggested by Rosa Medina Doménech. (284933 lines)
Copy the following icon to icon public directory:
sudo cp icon/filext32x32/m4a32x32.gif /var/www/html/swad/icon/filext32x32/
Version 19.159: Apr 03, 2020 Code refactoring and bug fixing in tests. (285052 lines)
Version 19.158: Apr 02, 2020 Lot of code refactoring in tests. (285031 lines)
5 changes necessary in database:
ALTER TABLE tst_exams CHANGE COLUMN TstCod ExaCod INT NOT NULL AUTO_INCREMENT;
ALTER TABLE tst_exams DROP INDEX TstCod,ADD UNIQUE INDEX(ExaCod);
DROP INDEX TstCod ON tst_exam_questions;
ALTER TABLE tst_exam_questions CHANGE COLUMN TstCod ExaCod INT NOT NULL;
ALTER TABLE tst_exam_questions ADD UNIQUE INDEX(ExaCod,QstCod);
Version 19.157: Apr 01, 2020 Code refactoring in tests.
Test exam is stored in database when it's generated. Not tested. (285023 lines)
Version 19.156.4: Mar 29, 2020 Code refactoring in tests. (284657 lines)
Version 19.156.3: Mar 29, 2020 Code refactoring in tests. (284585 lines)
Version 19.156.2: Mar 29, 2020 Test exam with start date and end date. (284568 lines)
Version 19.156.1: Mar 29, 2020 List of test exams with start date and end date. (284557 lines)
Version 19.156: Mar 28, 2020 New action to confirm assessment of test exam.
Code refactoring in test and matches. (284544 lines)
5 changes necessary in database:
ALTER TABLE tst_exams CHANGE COLUMN AllowTeachers AllowTeachers ENUM('N','Y') NOT NULL DEFAULT 'N' AFTER NumQstsNotBlank;
ALTER TABLE tst_exams CHANGE COLUMN TstTime StartTime DATETIME NOT NULL;
ALTER TABLE tst_exams ADD COLUMN EndTime DATETIME NOT NULL DEFAULT '1970-01-01 01:00:00' AFTER StartTime;
UPDATE tst_exams SET EndTime=StartTime;
ALTER TABLE tst_exams CHANGE COLUMN EndTime EndTime DATETIME NOT NULL;
Version 19.155.6: Mar 26, 2020 Code refactoring in matches. (284479 lines)
Version 19.155.5: Mar 26, 2020 Code refactoring in tests. (284480 lines)
Version 19.155.4: Mar 26, 2020 Code refactoring in tests. (284476 lines)
Version 19.155.3: Mar 26, 2020 Code refactoring in pass to parameters of functions. (284476 lines)
Version 19.155.2: Mar 26, 2020 Code refactoring in tests. (284414 lines)