rubenvanassche / Programming-Project-Databases

A World championship statistics website
coachcenter.be
GNU General Public License v3.0
1 stars 1 forks source link

CoachCenter

Awesome web-service for (soccer) football stats, (safe) betting with your friends and such.

This was a project for the course Programming Project Databases at the University of Antwerp. As this was a group project, the following developers have built the basics of CoachCenter:

This project uses Laravel PHP Framework.

Basic features

non-logged users

logged-in users

Extended features

Of course, there's more!

Installation

Automatic

First, you'll need to load some data in the database:

  1. Create database coachcenter
  2. Run the installation script install/install.sh (Only if you're on linux, also run from inside the install folder, read install/readme.txt first)
  3. Load the data as given in sql/coachcenter.sql file into this database.

Then you can deploy the site locally using artisan:

$ php artisan serve

Now, a local version of the CoachCenter is running in your localhost (usually http://localhost:8000).

Manual

First, you'll need to load some data in the database:

  1. Create database coachcenter
  2. Load the data as given in sql/coachcenter.sql file into this database.

Second, you should update the system to connect to the database:

  1. Open App/Config/database.php
  2. Change the mysql configuration
  3. Save the file

Now let's start the server:

$ php artisan serve

Now you have a running coachcenter server! There are also some commands which can be run using artisan:

$ php artisan remindUsers %

reminds users to bet for matches they haven't bet on yet(replace % by the amount of days coachcenter should look for future matches)

$ php artisan updateDB

get new information about matches from our sources and update the bet scores of users

This only works for PHP >= 5.5.x

These commands will run automatically through cron jobs if you use the automatic installation. If the cron jobs don't work for some reason, you will have to update manually by running php artisan updateDB while in the project root.