Skip to content

An open-source tool to manage debating events, track winners, and generate customizable certificates. Perfect for schools and debating societies to organize debates and recognize achievements. Fully open-source and customizable.

License

Notifications You must be signed in to change notification settings

silverhadch/Debating-Opensource

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Debating Contest Software

Project Description

The "Debating Contest Software" is an application designed for managing and organizing debating competitions. It includes features for participant management, room assignments, certificates, and more.

Project Contributors

  • Hadi Chokr: Maintainer, Current Lead Developer, Backend Development, Bug Fixes, Database Management, and the main point of contact for the project.

  • Henrik Staschen: Frontend Development, UI Design, Integration of Backend and Frontend & Former Lead Developer

License

This project is licensed under the GNU General Public License Version 3 (GPL-3.0). You are free to use, modify, and distribute the software, provided you comply with the terms of the license.

Terms of the GPL-3.0:

  • You may modify and redistribute the source code as long as you keep the same license.
  • When distributing the software or modifications, the license information and the complete license document must be included.
  • If you modify and release the project, you must ensure the source code remains accessible.

The full license is available in the project directory under LICENSE.

Installation and Setup Guide

Install

1. Git clone this repository.

2. Database-Credentials

Open the config/config_pdo.php file and update the database credentials (host, username, password, database name) to match your setup.

3. Create the Database.

Use the debating.sql file to set up the database structure. You can do this with a tool like phpMyAdmin or using the command line:

mysql -u username -p database_name < path/to/debating.sql

Setup

1. Logging in with the Root Account

Please perform these steps locally until the guide specifies otherwise. Using a universal root account in a production environment is a bad practice.

Username: root
Password: root

  • Open your browser and navigate to index.php.
  • Click on the Login button.

index

index

  • You will see two buttons: one for starting a marksheet and another for accessing the Admin area.
  • Click the Admin button and log in with the temporary root credentials like earlier.

index

2. Admin Panel Overview

Once logged into the Admin panel, you will have multiple options. The most important features are available in the navigation/top bar.

index

3. Setting Up the Admin Tool

  • Click on Admintool.

index

  • Set the School Name for the start page and certificates. This should be the name of the school hosting the contest.
  • Set the date, too.
  • Add the rooms for the contest.

4. Creating an Admin User

  • Click Home in the downbar to return to the main menu.
  • In the navigation bar, click Signup to create a new Admin user.

index

  • Make an Admin account (and additional accounts if needed).
  • Important: Once you have at least one other Admin account, remove the root user from the users and users_admin tables. If you have done that, you can go online.

5. Adding Teams and Players

  • To add teams, click Home and select New Team from the Admin Navbar. Then, return to the Admin Navbar and press New Speaker to add players. You can always add more teams or players later, but for now, your setup is complete.

index

index


Using the Marksheet

  • Regular users should click the Marksheet button on the home page.

index

  • Fill out the initial information on the marksheet.

index

  • Then, fill in the results. Note that the winner team and best speaker fields only matter if there is a tie but still enter them for a reminder.

index

6. Confirming the Results

  • You will be taken to a confirmation screen displaying the results. If everything is correct, submit it.
  • Note: Remember to write down the verification number, including the slashes, so admins can check and edit the result if needed.

index

  • After submitting, you can either return to the Home page or create another marksheet.

index


7. Generating Certificates

  • At the end of the contest, go to the Admin panel and click on Certificates.
  • Certificates will be generated for the top 3 teams (per player per league) and the top 3 best speakers (per league). Simply click the download link.

index

Disclaimer

THE SOFTWARE IS PROVIDED "AS IS," WITHOUT ANY WARRANTY, WHETHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. REFER TO THE GPL-3.0 LICENSE FOR MORE DETAILS.

About

An open-source tool to manage debating events, track winners, and generate customizable certificates. Perfect for schools and debating societies to organize debates and recognize achievements. Fully open-source and customizable.

Resources

License

Stars

Watchers

Forks

Sponsor this project