engelsystem/engelsystem

Shift planning system for chaos events.

Engelsystem

Please visit engelsystem.de for a feature list.

To report bugs use engelsystem/issues.

Since the Engelsystem is open source, you can help improving it. We really love to get pull requests containing fixes or improvements. Please read the CONTRIBUTING.md and DEVELOPMENT.md before you start.

Installation

The Engelsystem may be installed manually or by using the provided docker setup.

Requirements

• PHP >= 8.1
  • Required modules:
    • dom
    • json
    • mbstring
    • PDO
      • mysql
    • tokenizer
    • xml/libxml/SimpleXML
    • xmlwriter
• MySQL-Server >= 5.7.8 or MariaDB-Server >= 10.2.2
• Webserver, i.e. lighttpd, nginx, or Apache

From previous experience, 2 cores and 2GB ram are roughly enough for up to 1000 Angels (~700 arrived + 500 arrived but not working) during an event.

Download

• Go to the Releases page and download the latest stable release file.
• Extract the files to your webroot and continue with the directions for configurations and setup.

Configuration and Setup

• The webserver must have write access to the storage directory and read access for all other directories

• The webserver must point to the public directory.

• The webserver must read the .htaccess file and mod_rewrite must be enabled

• Recommended: Directory Listing should be disabled.

• There must be a MySQL database set up with a user who has full rights to that database.

• If necessary, create a config/config.php to override values from config/config.default.php.

  • To disable/remove values from the following lists, set the value of the entry to null:
    • themes
    • tshirt_sizes
    • headers
    • header_items
    • footer_items
    • locales
    • contact_options

• To import the database, the bin/migrate script has to be run. If you can't execute scripts, you can use the initial-install.sql file from the release zip.

• In the browser, login with credentials admin : asdfasdf and change the password.

The Engelsystem can now be used.

Session Settings

• Make sure the config allows for sessions.
• Both Apache and Nginx allow for different VirtualHost configurations.

Docker

Build

To build the es_server container:

cd docker
docker compose build

or to build the container by its own:

docker build -f docker/Dockerfile . -t es_server

Run

Start the Engelsystem

cd docker
docker compose up -d

Set Up / Migrate Database

Create the Database Schema (on a fresh install) or import database changes to migrate it to the newest version

cd docker
docker compose exec es_server bin/migrate

Scripts

bin/deploy.sh

The bin/deploy.sh script can be used to deploy the Engelsystem. It uses rsync to deploy the application to a server over ssh.

For usage see ./bin/deploy.sh -h

bin/migrate

The bin/migrate script can be used to import and update the database of the Engelsystem.

For more information on how to use it call ./bin/migrate help

Documentation

More documentation can be found at: https://engelsystem.de/doc/

engelsystem's Issues

secure password hashing needed

Reported by phusler on 19 Jan 41444702 04:26 UTC
we don't want MD5 but sha-2 and salts.

and please ensure secure passwords on registration and user-admin

test

Reported by [email protected] on 24 Jan 41446836 01:20 UTC

test

Kilometres per hour introe

Reported by phusler on 9 Mar 41444687 22:40 UTC
the infodesk-people want to set "arrived" to angels which arrive and get their badges.

(maybe this year angels dont have special badges...)

angle got shirt?

Reported by phusler on 11 May 41444688 04:26 UTC
archangels want to mark if an angel got a tshirt

admin: db-import

Reported by phusler on 23 Apr 41548935 20:26 UTC
we have to switch a productive engelsystem to the new version

there will be an import php-script which connects to two databases and imports data from the old scheme to the new one.

bugreport engelsystem

Reported by [email protected] on 19 Mar 42379127 14:13 UTC

beim editieren von einzelnen schichten ist es nicht mglich, eine zu bearbeiten wenn sich schon min 1 engel eingetragen hat.

zb: 
alt -> cashdesk ist mit 3 cashdrohnen zu besetzten und eine drohne hat sich schon eingetragen.

neu -> es sollen nur 2 cashdrohnen sein und eine egaldrohne zum krimpen

fehlermeldung:
Du kannst nur Schichten bearbeiten, bei denen niemand eingetragen ist. 

ich bitte um dieses feature wieder zu entfernen, da dadurch keine nachtrglichen nderungen von seiten der dispatcher oder erzengel mehr vorgenommen werden knnen

mfg 
lexy

[attachment:"signature.asc"]

Engelsystem 2.0

Reported by [email protected] on 27 Aug 41633106 05:46 UTC

Hy,
Hier Darkwake,
leider war ich beim Camp unerwartet zum Engelsystem 2.0 Meeting nicht
anwesend.

Schickt mir daher mal bitte die entsprechenden Infos, Links, Gruppenkontakte
usw.

Thx
Darkwake

Morgens registriert, abends funktioniert der Login nicht mehr?

Reported by [email protected] on 4 Mar 41891414 12:00 UTC

Hallo,

ich habe mich im Engelsystem heute morgen fr den 28c3 mit dem Pseudonym
"Freak" registriert und konnte mich danach auch sofort einloggen (mehrmals
probiert). Heute abend sagt mir das System, dass mein Passwort nicht
korrekt sei.

Da ich jedoch mein Passwort mehrmals berprft habe, kann dies eigentlich
nicht sein.

Habt ihr eine Lsung?

Gru,
Thomas

test

Reported by [email protected] on 18 Jan 42280011 09:46 UTC

test

add pagination

Reported by phusler on 11 Apr 41444700 00:53 UTC
some tables and lists will become very very long.

please make them paginated

what about the services directory?

Reported by phusler on 20 Mar 41444696 13:20 UTC
there are some special php-files doing jabber and dect things.

we just don't know yet what to do with it.

Lode introe

Reported by [email protected] on 11 Nov 41527180 16:53 UTC

Priority: High

Hello,

can you disable the t-shirt size question in the system, since we  
don't need it for camp. Also disable the ability for users to edit  
their size.

Kind regards,

Mendel Mobach aka BugBlue

add backlinks

Reported by phusler on 25 Mar 41444699 02:13 UTC
users want to go back after saving something or to return to the complete list of anything.

there are no static backlinks (as before).

test

Reported by [email protected] on 5 Oct 41446827 15:33 UTC

test

Text beim Login

Reported by mrudert on 29 Sep 42355856 04:00 UTC
PM helios: wie schwer is das eigtl die fehlermeldung im engelsystem bein einloggen ueber den text "Resistance is futile! Your biological and physical parameters will be added to our collectiv! Assimilating drone:" zu bekommen?

shifts: angels want to see their own shifts and to sign up for new shifts

Reported by phusler on 26 Nov 41444693 15:33 UTC
None

angel active/inactive

Reported by phusler on 20 Apr 41444684 16:53 UTC
archangels want to know if an angel had some shifts and was helpful.

if active is set, an angels gets a t-shirt and only then the tshirt-option is available

admin: free angels

Reported by phusler on 15 Oct 41549082 14:13 UTC
archangels want to see currently unemployed angels

languages: cleanup language table

Reported by phusler on 27 Sep 41444724 05:20 UTC
there are many unused entries in table Sprache...

5-stellige DECT Nummer (GSM) werden in den Benutzereinstellungen nicht dauerhaft gespeichert

Reported by [email protected] on 12 Aug 41986232 00:53 UTC

Hallo zusammen,

ich habe meine 5-stellige DECT-Nummer (GSM) unter "Options" eingetragen.
Solange ich angemeldet war wurde die Nummer auch immer wieder komplett 
angezeigt.
Einige Zeit spter nach einer erneuten Anmeldung war die letzte Stelle weg.
Ich habe es ein paar Mal probiert und hatte immer wieder das gleiche 
Ergebnis.

Gru
Simon 'aerolife'

languages: make translation complete

Reported by phusler on 28 Jun 41444722 11:06 UTC
every user-function has to be translated into english!

Vein introe

Reported by phaeusler on 17 Sep 41745554 10:13 UTC
in preview you can't get back to the edit form to change things.
you have to fill the form again.

Groups: no groups result in immutable user

Reported by jplitza on 6 Sep 41709610 09:20 UTC
A user being assigned to no group is not editable by the admins, not even deletable.

Stripe introe

Reported by phusler on 2 Jan 41444692 04:53 UTC
None

admin: Übersicht, welche Engel wie viele Schichten haben

Reported by phaeusler on 6 Mar 41850489 04:53 UTC
need feature frs engelsystem
bersicht fr orgas. welche helfer wieviele schichten haben

von timhaga

Fwd: Morgens registriert, abends funktioniert der Login nicht mehr?

Reported by [email protected] on 12 Jan 41891632 06:13 UTC

Hallo,

habe das Problem inzwischen selbst gelst. Beim ndern von Optionen heute
morgen ging wohl das Passwort verloren, ich konnte mich abends mit leerem
Passwort einloggen und danach das Passwort normal ndern.

Vielleicht solltet ihr in den Optionen das Passwortfeld nicht vorbelegen,
sondern lieber leer lassen, damit nicht bei jedem ndern der Optionen auch
das Passwort gendert wird.

Hoffe das hilft.
Gru und bis zum 28c3!
Thomas

---------- Weitergeleitete Nachricht ----------
Von: Thomas Tahsin-Bey <[email protected]>
Datum: 21. November 2011 20:21
Betreff: Morgens registriert, abends funktioniert der Login nicht mehr?
An: [email protected]


Hallo,

ich habe mich im Engelsystem heute morgen fr den 28c3 mit dem Pseudonym
"Freak" registriert und konnte mich danach auch sofort einloggen (mehrmals
probiert). Heute abend sagt mir das System, dass mein Passwort nicht
korrekt sei.

Da ich jedoch mein Passwort mehrmals berprft habe, kann dies eigentlich
nicht sein.

Habt ihr eine Lsung?

Gru,
Thomas

Switch für NocHelpdeskEngel

Reported by phaeusler on 11 Oct 41916215 00:53 UTC
downhill: Hey :) Koennen wir einen Switch fuer NocHelpDesk-Engel haben? Also wie fuer Info, Herald und so? :)

shifts: pentabarf-import

Reported by phusler on 23 Nov 41444690 02:40 UTC
the pentabarf-system generates xcs output files, containing any event.

this is used to import rooms and shifts into the engelsystem

sample xcs-files can be found at import/

Minor Bug (Display / darstellung)

Reported by [email protected] on 15 Jul 41976205 05:20 UTC

Hi,
folgender Bug wenn ich auf der seite zum eintragen in schichten bin. (siehe
screenshot)
mfg,
chip

on engelsystem.png"

€-Zeichen wird verschluckt

Reported by [email protected] on 30 Mar 42312509 15:06 UTC

Das Frage einen Erzengel-Formular verschluckt mein Eurozeichen.

lg

Nicolai

Mother-lode introe

Reported by [email protected] on 6 Aug 41573357 17:20 UTC

Hello Angel Team,

I keep on having problems with the registration for the angel system and the
link to the ticket presale. Could it be possible that the university system
blocks in a way the access? I registered already in the engelsystem butwanted
to register now for angels shifts and also buy a ticket but I can somehow not
login anymore. Thank you for your advice.

Best
Maria

Änderung von Raum defaults geht nicht [Ticket#2012051510000145]

Reported by [email protected] on 22 Nov 42373501 02:40 UTC

Hallo!

https://engelsystem.de/sigint2012/?p=admin_rooms&show=edit&id=3
Herold  = 1 geht nicht

gre
wingfire

test

Reported by [email protected] on 6 Feb 41951312 00:26 UTC

test

langugages: restructure FAQs to multiple language support

Reported by phusler on 18 Sep 41444720 07:33 UTC
at this time, there are 2 columns per language (question and answer).

this has to be changed to something like:
id|language|question|answer

and then the admin_faq.php has to be rewritten for editing this.

messages: make user_messages useable

Reported by phusler on 13 Oct 41444709 06:13 UTC
please rewrite user_messages to a dialog-based view.

and kick

please!

Lode introe

Reported by [email protected] on 11 Mar 41839017 08:00 UTC

Hallo,

laut meinem Passwortmanager msste ich als "handverbrennung" im
Engelsystem sein, aber dort heisst es es gbe den user nicht. Hilfe"

Gru, Enno

angel: ical-export

Reported by phusler on 19 Oct 41549051 03:33 UTC
there will be an ical-export so that angels can subscribe it into their calendar software.

Unearth introe

Reported by phaeusler on 30 May 41850562 21:20 UTC
None

Kilometres per hour introe

Reported by [email protected] on 2 Jul 41446831 09:20 UTC

test

Bug im Registration form

Reported by [email protected] on 15 Aug 42378637 03:33 UTC

Y U No accept e-mail-adressen, die ein + (Plus-Zeichen) enthalten? zB "[email protected]", damit das bei mir gleich im richtigen IMAP-Ordner landet.

Gre,
-- rohieb

Fehler: Array bei Zurück in Schichtvorschau

Reported by phaeusler on 16 Jul 42321529 12:53 UTC
noch ein kleiner bug: wenn man die schichtwechselstunden nutzt, und dann auf der vorschau zurck klickt, steht in dem feld nur Array

html: don't use <table> anywhere

Reported by phusler on 4 Jul 41444712 15:06 UTC
every form (and much more) is done by tables. this sucks.

please rewrite this to semantic-html.

admin: edit users groups/permission

Reported by phaeusler on 3 Dec 41699441 21:20 UTC
this has been forgotten by rewriting:
change users rights/groups

enable user-avatar function

Reported by phusler on 1 Dec 41444705 05:20 UTC
ex-code for this is in

user_settings.php

admin: prepare old privileges for db-import

Reported by phusler on 27 Oct 41444714 12:53 UTC
the cvs-table still consists. it contains the old permissions to any action. they have to be ported to the new privilege/group permission system.

then export the GroupPermissions table to DB/

README rewrite

Reported by phusler on 17 Jul 41444780 04:00 UTC
well, the README-file is not up-to-date.

Zugaenge fuer neu-Entwickler schaffen

Reported by [email protected] on 27 Mar 41644619 12:00 UTC

Alexsander Paravac  [email protected]              PHP-Krams, Bugfixes (auch in v1)
Guido Klingschat    [email protected]             
Nico Osinski        [email protected]            Doku
Bastian Blank       [email protected]   LDAP, RT
Sascha Kaupp        [email protected]                Frontend
Philip Husler       [email protected]              Grober Zusammenhang, GUI
mortzu       [email protected]                Admin-Kontakt
Angelo Cuccato      [email protected]                  Tests, v1-Support
Jan-Philipp Litza   [email protected]             

make log entries

Reported by phusler on 20 Jun 41549057 21:46 UTC
if anything is changed, there should be a log entry for this.

model: on every sql-delete - ensure that all depending data is managed

Reported by phusler on 6 Oct 41529414 01:20 UTC
None

Extended AngelType system

Reported by phaeusler on 22 Jun 41962166 04:26 UTC
Users want to specify more than one angeltype for themselves.

This kills "EgalEngel".

AngelTypes have to be able for a double-opt-in mechanism for types like "Kasse". User can specify, that he is able to do "Kasse" shifts. Then an archangel can verify this.

Angels only see shifts for the types they selected.