c-SPOT was designed to help churches organize their Sunday and Midweek services as well as other events.

As an online tool, it provides event information to every person involved and allows them to add or modify information accordingly.

However, the ability to contribute to the plan details is based on distinct roles given to each user, so that only authorized people can make modifications or even see certain details.

c-SPOT is designed to allow for 'self-registration'. That means, once you've signed up, either by using your email address or a service provider (see below), you can immediately access most of the data. However, only very basic access rights are given to a self-registered user, so any further rights must be assigned to by a user with an "Administrator" role.

To sign up, just provide your name, email address and create a new password. An email containing a verification link will be sent to that email address. Be sure to click on that link - once you've received the email - in order to 'release' your account!

Easy Sign-Up option: Without the need for an additional password, you can allow your existing registration with one of the "big" service providers (like Google, Facebook, Twitter etc.) to be used for this verification process. Just click on the symbol of the service provider you want to use. You will be forwarded once to a special page of your service provider for confirmation.

If you agree to use this "provider verification", c-SPOT will be "authorized" to access your basic account information with those providers (usually name and email address). From then on, no further login is required anymore as long as you are logged in to those providers in the same browser program.

So with that, no need to remember another password!

Verified users can see and/or modify all or various parts of the information depending on their roles they have been given by an administrator.

Based on those roles, users can be assigned as 'leader' or 'teacher' of a plan and as such are able to modify, add and delete plan items on those respective plans.

Copyrighted material like lyrics can only be viewed by users with the role of 'leader' or higher since they are assumed to be part of the local church and therefore covered by the church's MRL license from SongSelect. (http://uk.ccli.com/songselect/)

(User details and all information is stored in a (mySQL) database called 'cspot' in various tables. The major data tables are for users, songs, service plans and service plan items. Auxilliary information is stored in tables for user roles, service plan types and standard items for service plans.)

This is a 'hobby project' of Matthias Kuhs, intially designed to replace a paper- (later email)-based system used to organize with the running of our church services to provide the relevant information for musicians and leaders involved in the service.

As an open source project, everyone can download the sources and modify the code according to their specific needs.

The project is currently hosted on Github under https://github.com/matthiku/cSpot from where people can 'clone' (download) it to their own web server.

Installation instructions can be found in the readme file hosted on Github.

Note: After the installation of this tool, the first user to register will be be getting non-revokable Administrator rights! (In technical terms, this is the user with id number 1. Of course, like everything else, this can be manipulated in the 'users' table of the database.)