This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
sermn_wiki:userpages:marta:reserves_automatiques_rutina [2013/10/19 20:29] miquel [Seguretat] |
sermn_wiki:userpages:marta:reserves_automatiques_rutina [2019/07/19 15:43] (current) miquel [Reserves automàtiques per la Cua de Rutina] |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Reserves automàtiques per la Cua de Rutina ====== | ====== Reserves automàtiques per la Cua de Rutina ====== | ||
+ | |||
+ | <WRAP important> | ||
+ | Les reserves automàtiques per la Cua de Rutina s'han **desactivat amb data de 2019-07-19.** | ||
+ | </ | ||
+ | |||
FIXME explicar el programet per fer les reserves automàtiques per la cua de rutina i les condicions de funcionament de l' | FIXME explicar el programet per fer les reserves automàtiques per la cua de rutina i les condicions de funcionament de l' | ||
Line 5: | Line 10: | ||
===== routine_nmr_bookings.sh ===== | ===== routine_nmr_bookings.sh ===== | ||
- | Aquest es el programet que crea les reserves per la cua de rutina. S' | + | Aquest es el programet que crea les reserves per la cua de rutina. S' |
<code bash routine_nmr_bookings.sh> | <code bash routine_nmr_bookings.sh> | ||
Line 23: | Line 28: | ||
# To run this script every Sunday 2am append an entry like, | # To run this script every Sunday 2am append an entry like, | ||
# | # | ||
- | # FIXME 0 2 * * 1 / | + | # FIXME 0 2 * * Sun / |
# | # | ||
# to crontab. This entry means, at minute 0, hour 2, on every (*) day of | # to crontab. This entry means, at minute 0, hour 2, on every (*) day of | ||
Line 59: | Line 64: | ||
# Bumblebee booking system database where everything gets stored | # Bumblebee booking system database where everything gets stored | ||
- | myuser=' | + | myuser=' |
- | mypass=' | + | mypass=' |
- | mydb='bmbdb114' | + | mydb='*****' |
Line 190: | Line 195: | ||
Please, report this issue to the system administrator. | Please, report this issue to the system administrator. | ||
</ | </ | ||
+ | |||
===== Entrada al registre crontab ===== | ===== Entrada al registre crontab ===== | ||
Line 199: | Line 205: | ||
# run every Sunday at 02:00. | # run every Sunday at 02:00. | ||
# | # | ||
- | 0 | + | 0 |
</ | </ | ||
Line 222: | Line 228: | ||
<code sql> | <code sql> | ||
- | SELECT | + | INSERT INTO permissions (userid, instrid, isadmin, |
- | FROM users, | + | announce, unbook, haspriority, |
+ | SELECT | ||
+ | FROM permissions, users | ||
WHERE permissions.userid = users.id | WHERE permissions.userid = users.id | ||
AND permissions.instrid = 12 | AND permissions.instrid = 12 | ||
- | AND users.deleted = 0 ORDER BY `users`.`suspended` | + | AND users.deleted = 0 |
</ | </ | ||
+ | |||