-
Notifications
You must be signed in to change notification settings - Fork 0
Home
This is a R/Shiny Application with a powerful Postgresql backend. This software is suitable for betting in groups of less than 100 people. A R/Shiny server (community version) and a Postgresql Database server is required. If you have an LDAP Server, all users can create their own account in the DB backend. Just log in with your LDAP account and register via the GUI afterwards.
If you don't have an LDAP server there are 2 options:
- Use storedprocedureNoLDAP.sql and login with any username and the same string as a password. Users can register on their own.
- Use storedproceduresPassword_plpgsql.sql and preregister every user in the database. Use the md5 hash to encrypt the password.
insert into player values ('franz', 'Schubert', 'Franz', 'Austria', NULL)); insert into gameuser values ('franz', md5('Winterreise');
When the game starts, users cannot enter bets anymore. There is a trigger (checkTip) that checks, if everything is entered properly and in time. After the soccer game you can update the database. Points are automatically calculated. Use the update.sh shell script and modify it dependent on your settings.