sermn_wiki:userpages:marta:reserves_automatiques_rutina
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
sermn_wiki:userpages:marta:reserves_automatiques_rutina [2013/10/19 20:29] miquel [Seguretat] |
sermn_wiki:userpages:marta:reserves_automatiques_rutina [2016/07/25 00:56] miquel |
||
|---|---|---|---|
| Line 5: | Line 5: | ||
| ===== 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 23: | ||
| # 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 59: | ||
| # 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 190: | ||
| 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 200: | ||
| # run every Sunday at 02:00. | # run every Sunday at 02:00. | ||
| # | # | ||
| - | 0 | + | 0 |
| </ | </ | ||
| Line 222: | Line 223: | ||
| <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 |
| </ | </ | ||
| + | |||
sermn_wiki/userpages/marta/reserves_automatiques_rutina.txt · Last modified: 2019/07/19 15:43 by miquel
