System Manual

Step-by-step instructions for every part of the cockfighting queuing system. Version 1.0.0.

1. Overview

Cockfighting Queuing System manages the order in which entries (rooster and handler) may enter the areas of the cockfighting arena.

  • Each entry takes one queue number at the ticket kiosk. They tap Ready, Limber or Heeling on the kiosk to get it. Numbers run in one sequence for the whole day (001, 002, 003…), whatever the area chosen.
  • The counter caller calls numbers into the areas: Ready, Limber and Heeling.
  • The TV display shows the numbers allowed inside each area, plays a chime and announces the number.
  • Everything runs on the local network. No internet is needed.

Parts of the system

  • Ticket kiosk – touch-screen tablet or PC that issues and prints numbers.
  • Calling counter – where the caller calls numbers into the areas.
  • TV display – the screens in the arena and at the area entrances.
  • Administration – areas and counters, users, settings, reports, backups and updates.

2. Getting started & installation

  1. Install XAMPP on the Windows PC that will be the server.
  2. Copy the system folder to C:\xampp\htdocs\que.
  3. Open the XAMPP Control Panel and start Apache and MySQL.
  4. Open http://localhost/que/ in the browser. The setup wizard starts.
  5. The wizard creates the database (default name sabong_queue_db), the areas Ready, Limber and Heeling, Counter 1, and the System Administrator account. You can add demo data to try the system.
  6. Sign in with the System Administrator account. Add the other users in Users & roles.

Using the system

  • Menu – on the left. On tablets and phones tap ☰ to open it.
  • Light / dark – the sun / moon button at the top right.
  • My profile – tap your initials at the top right to change your name, photo or password.
  • Remember me – tick it only on your own device. Never on a shared PC.
  • Sign out – the arrow beside your name.

Tip: in XAMPP, tick the Service boxes for Apache and MySQL so they start with Windows.

3. Network setup

The system runs only on the local network (LAN or a Wi-Fi access point). The server is the Windows PC with XAMPP. Counters, kiosk tablets and TVs open it by its network address, for example http://192.168.1.10/que/.

  • Static IP – give the server a fixed IP address (in Windows or as a reservation in the router). Otherwise the links on the TVs and tablets stop working when the address changes.
  • Access point close to the counter – put the Wi-Fi access point near the calling counter and the kiosk.
  • 5 GHz Wi-Fi – use the 5 GHz band for tablets and counters. It is faster and less crowded than 2.4 GHz.
  • Wired LAN for the TV PC – connect the PC that drives the TVs with a network cable where possible.
  • Light on the network – the screens download only a few bytes when nothing has changed, so the queue stays fast on a busy access point.
  • Windows firewall – allow Apache (port 80) on the private network, or other devices cannot connect.

4. Daily operation

Start of the derby

  1. Turn on the server PC. Check that Apache and MySQL are running.
  2. Turn on the TV PC and the kiosk tablet. The start-up file or app opens each screen full screen.
  3. Tap each TV once (or press OK on the remote) if it asks to enable sound.
  4. The caller signs in and opens the Calling counter.

Kiosk

Each entry taps the kiosk once and takes the ticket. The number goes into the waiting line.

Calling

The caller presses Call next → Ready (or Limber, or Heeling). The lowest waiting number that chose that area is called into it. The TV shows it and announces it.

Areas

Numbers stay in an area until they are moved, marked Done, or released. If the area has a capacity and is full, the oldest number inside is released when a new one is called.

End of the day

  • Numbers restart at 001 every day by themselves.
  • To start again during the day (for example a second derby), open Settings → Tickets → Start numbers again. You can also close the numbers still in the queue.
  • Make a backup in Backups after an important event.

5. Calling counter

Open Calling counter. There is one counter by default. If more counters exist, choose yours; the browser remembers it.

Calling numbers

  • Call next → Ready / Limber / Heeling – one big button per area. It calls the lowest waiting number that chose that area at the kiosk.
  • Call a specific number – pick a number in the waiting list and choose the area to call it into.

Numbers in an area

  • Call again – announces the number again.
  • Move – sends the number to another area, for example Ready → Heeling.
  • Done – the entry has left the area.
  • Skip – the entry did not come. It goes to the Skipped list. Call it back later, or put it back in line.
  • No-show – the entry is gone. The number leaves the queue.
  • Cancel – removes a number given by mistake.
  • Clear area – releases every number in that area.

Give a number

The caller can issue a number by hand, with an optional entry or handler name and a note. The ticket prints. The name and note of a ticket can be edited later, and any ticket can be reprinted. Names and notes are for staff only and never shown on the TV.

Keyboard shortcuts

  • 1–9 – call next into area 1 to 9 (in the order of Areas & counters).
  • R – call again the last number called.

6. TV display

The TV shows each area with the numbers allowed inside. On every call it shows a Now calling pop-up, plays a chime and announces the number, for example “Number 0 1 4. Please proceed to the Ready area.” A ticker of announcements runs along the bottom.

Layouts

  • Layout 1 – Area columns (Ready · Limber · Heeling)
  • Layout 2 – Big “now calling” number and area cards
  • Layout 3 – Video / live feed with the areas at the side
  • Layout 4 – Scoreboard table
  • Layout 5 – Giant numbers only (for far-away screens)

Designs (colour themes)

  • Arena – black, crimson and gold
  • Derby night – deep blue and neon
  • Classic – light, high contrast
  • Gold cup – dark bronze and gold
  • Pit green – dark green and yellow

One area per TV

A TV can show only one area, for example only Heeling at the entrance of the Heeling room. Choose the area in Display & kiosk apps or TV screens setup (the link gets &area= and the area number).

Voice

Set the voice in Settings → TV display & voice:

  • Language: English (United States), English (United Kingdom), English (Australia), English (India), English (Philippines), Filipino.
  • Voice: male or female, or a specific voice by name.
  • Speed and pitch, and repeat the announcement 1 to 3 times.
  • Chime: Ding-dong (two notes), Ring bell (three strikes), Arena horn, Three rising notes, No chime.
  • Wording with the placeholders {number}, {area} and {counter}. Ready-made presets:
    • Number {number}. Please proceed to the {area} area.
    • Calling number {number}. {number}, you may now enter {area}.
    • Numero {number}. Pumunta na po sa {area}.
    • Numero {number}. Tuloy na po kayo sa {area} area.
    • Attention please. Number {number}, to {area}.

Each TV can also pick its own voice with the microphone button at the top right. The same button opens a sound check with a Test button.

Sound and smart TVs

  • Browsers play sound only after one tap. Tap the screen once or press OK on the TV remote. The Windows one-click shortcut and start-up file do not need this.
  • Smart TVs that cannot speak use the computer voice: the server makes a sound file with the Windows voices and the TV plays it. Open the display from the server’s network address. To force it, choose the computer voice in Voice played by, or add &voice=server to the TV link.
  • A TV reloads by itself after a change in Settings or Areas & counters.

7. TV screens setup (6 and more TVs)

One Windows PC can drive at least 6 TVs (up to 8), for example with a multi-output graphics card or USB display adapters.

  1. Connect the TVs to the PC. In Windows press Windows+P and choose Extend (Settings → Display → Extend these displays).
  2. On that PC open TV screens setup in Chrome or Edge.
  3. Press Detect screens and allow the window-management permission. The page shows how many screens are connected.
  4. Press Identify screens. A big number appears on each TV.
  5. For each screen choose TV display or Ticket kiosk, and the area, layout and design. Save.
  6. Press Open on the screens now to open every screen now, or Download start-up file (.cmd). It opens each screen full screen in kiosk mode.
  7. To start the screens with Windows, press Windows+R, type shell:startup and copy the .cmd file into that folder.

Display & kiosk apps

  • Display & kiosk apps gives the link of each screen, with its secret screen key.
  • Install as app – open the link on the device and install it (PWA). One tap on the icon opens it full screen.
  • One-click Windows shortcut – opens the screen full screen with sound and silent printing.
  • Make new links changes the screen key. Every old link stops working.

8. Kiosk tablet setup

  • Place a touch-screen tablet or PC at the entrance. Open the kiosk link from Display & kiosk apps and install it as an app.
  • Android tablet – install the app from Chrome. For a Bluetooth printer, use the RawBT app (below).
  • Windows tablet or PC – use the one-click shortcut. It opens the kiosk full screen and prints without a print window.
  • One tap gives one number. A double tap never gives two numbers.
  • Lost ticket – tap Lost your ticket? Tap here to print it again, type the number and print.
  • Daily limit – with a quota set, the kiosk closes when all numbers for the day are given.

Printing options (Settings → Printing)

  • Network thermal printer – a printer with its own IP address.
  • Printer on the server – a USB printer installed on the XAMPP PC.
  • Bluetooth / serial port (COM) – a printer paired with the server PC.
  • Bluetooth on an Android tablet (RawBT) – install RawBT from Google Play, pair the printer in it and print a test page. In Display & kiosk apps choose RawBT as the way tickets are printed.
  • Browser printing – the default printer of the kiosk device. Make the thermal printer the default printer in Windows.

Without a printer, the number is shown on screen.

9. Ticket editor with live preview

  1. Open Settings → Printing → Ticket layout.
  2. Tick the parts the ticket should show, for example the logo, the queue number, the date and time, and the header and footer texts.
  3. Choose the size of each part.
  4. Type the ticket header and footer texts.
  5. The preview beside the form updates in real time as you change it.
  6. Save the layout. Print a test ticket to check it.

10. Settings

Open Settings (Administrator). It has these tabs:

  • Tickets – number prefix and digits, ticket texts, Start numbers again, Daily limit (quota).
  • Kiosk – the title and texts on the kiosk screen.
  • Printing – how tickets are printed, and the ticket layout with live preview.
  • TV display & voice – layout, design, voice, chime, wording, ticker and video.
  • Appearance – theme colour, menu colour (for example Arena black with gold), light or dark mode, and the logo.

11. Areas & counters

Open Areas & counters (Administrator).

Areas

  • The system starts with Ready, Limber and Heeling.
  • Rename, add, recolour and reorder areas. The order is used on the TV, the counter buttons and the keyboard shortcuts.
  • Set a short name and a location for each area.
  • Capacity – how many numbers may be inside at once. When a new number is called into a full area, the oldest number inside is released automatically. 0 = no limit.

Counters

There is one counter by default (Counter 1). Add more counters when several callers work at the same time. The counter name can be used in the announcement with {counter}.

12. Users & roles

Open Users & roles (Administrator) to add users with a username, password and role. Leave the password empty when editing to keep it.

  • System Administrator – Everything, including backups and system updates.
  • Administrator – Runs the queue: areas and counters, users, settings, TV screens, reports.
  • Supervisor / Pit Manager – Uses any counter, watches every area, sees the reports and the display and kiosk links.
  • Counter Caller – Calls the numbers that may now enter Ready, Limber or Heeling, moves them on, and marks them done.
  • Kiosk / Ticket Issuer – Issues numbers (kiosk or by hand) and reprints tickets. Cannot call numbers.

The Activity log shows who did what and when.

13. Reports & analytics

  • Choose the dates (or Today, Yesterday, Last 7 days…).
  • Numbers issued per day and per hour.
  • Calls per area.
  • Average waiting time, from the ticket until the first call.
  • Export to Excel downloads an .xlsx workbook. Print report (PDF) opens a printable report.

14. Backups

For the System Administrator. Backups work like the WordPress “Duplicator” plugin.

  • A backup package is one zip file with all the files and the database, plus an installer.php.
  • Make a backup at any time. Scheduled backups are made by themselves. Only the newest copies are kept (the number is set by BACKUP_KEEP, 10 by default).
  • Download, restore or delete a package from the list.

Move to another computer

  1. Download the zip and its installer.php.
  2. Install XAMPP on the new PC and start Apache and MySQL.
  3. Put both files in the web folder, for example C:\xampp\htdocs\que.
  4. Open installer.php in the browser and follow the steps. It restores the files and the database.

Keep a copy of the backups on a USB drive or another PC.

15. System Updates

For the System Administrator. System Updates connects two copies of the system (local and online, or two PCs).

  1. On both copies enter the same deploy key and the other copy’s address.
  2. Compare changes lists the files that differ.
  3. Update the other site now sends this site’s files to the other copy.
  4. Get the other site’s changes brings the other copy’s files here.
  • A backup is always made first. Every update can be undone with Roll back in the update history.
  • Never sent: config/config.php, the database contents, uploads/ and backups/.

16. Troubleshooting

  • No sound on the TV – tap the screen once or press OK on the remote. Check the speaker icon and the TV volume. Use the microphone button for a sound check.
  • Smart TV shows numbers but has no voice – use the computer voice (Voice played by, or &voice=server). Open the display from the server’s network address.
  • The TV says “Reconnecting…” – the TV lost the connection. Check the network and that Apache and MySQL are running.
  • “This display link is no longer valid” – someone pressed Make new links. Open the TV again with the new link.
  • The printer does not print – check power, paper and cable or Bluetooth. Check the printing method and printer address in Settings → Printing. For browser printing, make the thermal printer the default printer.
  • Tablets cannot open the system – check that they are on the same Wi-Fi, that the server IP has not changed, and that the Windows firewall allows Apache.
  • Wi-Fi is slow – move the access point closer, use 5 GHz, and connect the TV PC by cable.
  • Detect screens finds no screens – use Chrome or Edge, allow the window-management permission, and set Windows to Extend these displays.
  • Apache or MySQL will not start – another program may use port 80 or 3306. Close it, or change the port in XAMPP.