ClimbU : Dynamic and open source live scoring for comps


ClimbU Livescoring is a multiplatform application that allows anyone to manage/display real-time scores. Originally developed for climbing competition(marathon) but can be easily adapted to other sports, other formats.

Package intrd/climbu-livescoring
Version 3.0
Tags competition, score, display, php, climbing, ranking
Project URL http://github.com/intrd/climbu-livescoring
Author intrd (Danilo Salles) - http://dann.com.br
Copyright (CC-BY-SA-4.0) 2016, intrd
License Creative Commons Attribution-ShareAlike 4.0
Dependencies • php >=5.3.0 • intrd/php-common >=1.0.x-dev • intrd/sqlite-dbintrd >=1.0.x-dev • intrd/php-mcrypt256CBC >=1.0.x-dev

Extremely lightweight and designed to run over Raspberry Pi 3.

  • The RPI3 image is pre-configured to act as ClimbU server, WiFi AP Hotspot and HDMI display output
  • The clients(judges) uses his own smartphones to access ClimbU browsing to local Web Application.

If you don't have an RPI3, don't worry, it works too on any desktop PC following this environment below:

  • A working WiFi network
  • A common PC (windows or linux)
  • TV/Monitor w/ HDMI
  • One or more smartphones (any specs) for the clients.

Downloads (pre-configured)

Raspberry Pi 3 Image

Download SDcard image here: backup.img.gz (I recommend to use a 4gb Class 10 SD Card)

  1. Just burn the image, boot up RPI3 and it will create a new wifi network called "ClimbU", default passwd: climbu123654
  2. Connect and browse to http://10.0.0.1 to access the ClimbU application, default login/pw: intrd/meuovo123
  3. If you need to open a terminal on RPI3, SSH to 10.0.0.1 w/ u: climbu, pw: 11

Windows

  • Portables - latest version of climbu-livescoring portable

running_win

I've packed a portable version of climbu-lvescoring, easy-to-install, just follow this steps below..

  1. Install vc_redist.x86.exe located at climbu/climbu-livescoring/winlibs/vc_redist.x86.exe or download here Visual C++ Redistributable for Visual Studio 2015
  2. Download latest portable version of climbu-livescoring, unzip at c:\climbu\
  3. Double click at win_runwww.bat to run and browse to your local ip, http://localhost/ or network ip, something like http://192.168.0.100/, default login/pw: juiz1/asd123asd

Administration

Not yet created an user-friendly admin interface, you will have to setup directly from the database.

  • To setup your users, and details of competition like categories, sectors and athletes, browse to http://localhost:81, then point Adminer to ../DATA/climbu-livescoring.dat.

Note: On Windows setup, you need double click at win_admindb.bat to launch Adminer first, then browse to http://localhost:91/.

sqliteadmin

Screenshots & features

Score display

Rotating score, you can easily adjust font size to fit at your monitor using ctrl+mouse roll
display_score

Score by team..
display_score

Event log, detailed, you can easily copyn'paste on a spreadsheet.

sectors

Sectors & points

sectors

Mobile responsive layout

Lightweight user interface, works on any smartphone/tablet
smart

Tops

Listing all tops registered by logged referee
sectors

Categories

Customizable categories, adaptable to your own competition format
register_categs

Climbu Livescoring IRL

CTF Bouldering marathon 2016 (by teams) (Vinhedo, São Paulo/Brazil)

Testing day..
ctf001

Climbing, markings on the wall, sectors and boulders by color, athletes by number..
ctf002

Self-organized climbing queue..
ctf003

ClimbU Running on a single RaspberryPi 3 (acting as router/server/display)
ctf004

Climbing ppl, another sector..
ctf005

More climbing..
ctf006

Self-organized climbing queue using physical tags on the wall..
ctf007

Referee w/ smartphone..
ctf008

Ending..
ctf009

Final results (teams and single)..
ctf010

Serra Master 2016 (Espirito Santo/Brazil) managed by ACE and Celina Takemura

Referee w/ smartphone..
ctf001

Climbing, markings on the wall, sectors and boulders by color, athletes by number..
ctf002

Climbing ppl..
ctf003

ClimbU running on a Windows machine..
ctf004

UNICAMP Campeonato Capira 2016 (Campinas, São Paulo/Brazil)

crowd1

ClimbU Running on a single RaspberryPi 3 (acting as router/server/display)
raspberrypi

RaspberryPi 3 test before comp
raspberrypi

Climbing people
climbing

Climbing people (Climbu @ background)
climbing

CTF Bouldering marathon 2016 (Vinhedo, São Paulo/Brazil)

ct

Working display
ct

Podium
ct

Final score
rankreal

Setup a advanced development environment (Linux or Windows w/ Composer)

System requiriments & dependencies

$ sudo apt-get update & apt-get upgrade
$ sudo apt-get install curl php-curl php-cli php-mcrypt php-sqlite3 php-fpm git nginx
$ curl -sS https://getcomposer.org/installer | sudo php -- --install-dir=/usr/local/bin --filename=composer

Now download the package (Composer automatically install all dependencies)  
$ git clone https://github.com/intrd/climbu-livescoring && cd climbu-livescoring

$ composer install -o #to install
$ composer update -o #to update
$ mkdir climbu-livescoring/LOG
$ touch climbu-livescoring/LOG/viewlog.html
$ chown -R climbu:www-data climbu-livescoring/
$ chmod -R 774 climbu-livescoring/

$ ./runwww.sh #to run climbu locally, acess by browsing http://localhost (its a single thread webserver for development only)
$ ./admindb.sh #to launch Adminer on http://localhost:8000

Translation/Locale problems?

Uncomment a line containing pt_BR.UTF-8 on /etc/locale.gen and then..

$ sudo locale-gen

Whitelisted ips to use admindb.sh

The whitelist is disabled by default, if you want to enable it to secure Adminer access check dba/index.php

Translations

The default language is en_US, but you can translate to any language you want, just follow my pt_BR translation file sample.

pedit

  1. At langs directory, clone pt_BR to a new directory w/ your language code
  2. Open default.po w/ poedit (https://poedit.net/download) and start translating
  3. Open www/config.php file and change $language = "en_US.UTF-8"; to your language.
  4. Or, if you want multilanguage users, open database/users and set the individual user language.
If you fork it, please link-me and respect the license.