Howdy!
I was wondering if someone is interested in writing the "public display" of background PHP table which stores the Equalizer data, in the form accessible to web crowd, like so
https://www.geeksforgeeks.org/how-to-fetch-data-from-localserver-database-and-display-on-html-table-using-php/
All the relevant help shall be provided!
Do you have the data list ? or a database sample ?
Good question!
Our ol' piggy has the relevant credentials of original database!!
Would you be kind enough to share it, or allow me to do so!!!
Or tonight, when I boot Linux on my system, I could share the database sample.
I'd rather not actually! I'll pm you
Quote from: Piglet on February 04, 2022, 11:26
I'd rather not actually! I'll pm you
just the database structure and few data would be enough
Couldnt wait till night and my build farm is automated for now.
So here we go
(https://i.imgur.com/XPMSGUh.png)
-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Feb 04, 2022 at 01:27 PM
-- Server version: 10.4.20-MariaDB
-- PHP Version: 8.0.8
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `CowboysTestDatabase`
--
-- --------------------------------------------------------
--
-- Table structure for table `EQPlayerInformation`
--
CREATE TABLE `EQPlayerInformation` (
`EQIdentifier` char(80) DEFAULT NULL,
`Captures` float DEFAULT NULL,
`Grabs` float DEFAULT NULL,
`Covers` float DEFAULT NULL,
`Seals` float DEFAULT NULL,
`FlagKills` float DEFAULT NULL,
`TeamKills` float DEFAULT NULL,
`Points` float DEFAULT NULL,
`TimePlayedMinutes` float DEFAULT NULL,
`TimePlayedHours` float DEFAULT NULL,
`Frags` float DEFAULT NULL,
`Suicides` float DEFAULT NULL,
`EQName` char(80) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `EQPlayerInformation`
--
INSERT INTO `EQPlayerInformation` (`EQIdentifier`, `Captures`, `Grabs`, `Covers`, `Seals`, `FlagKills`, `TeamKills`, `Points`, `TimePlayedMinutes`, `TimePlayedHours`, `Frags`, `Suicides`, `EQName`) VALUES
('Little_Johnny', 8, 46, 3, 0, 37, 0, 147, 145, 0, 94, 256, 'Johnny:_Sins_:Re'),
('Tamika', 0, 0, 0, 0, 7, 0, 37, 9, 0, 10, 4, 'Tamika'),
('Rae', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Rae'),
('Skakruk', 0, 7, 0, 0, 10, 0, 78, 27, 0, 17, 2, 'Skakruk'),
('Outlaw', 0, 6, 0, 0, 6, 0, 43, 11, 0, 7, 1, 'Outlaw'),
('Brock', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Brock'),
('Garrett', 0, 4, 0, 0, 2, 0, 16, 6, 0, 5, 1, 'Garrett'),
('Torch', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Torch'),
('Asp', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Asp'),
('Guardian', 0, 3, 2, 0, 0, 0, 7, 11, 0, 5, 2, 'Guardian'),
('Cyclops', 0, 0, 0, 0, 0, 0, -2, 0, 0, 0, 2, 'Cyclops'),
('Kane', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Kane'),
('Dominator', 0, 0, 0, 0, 0, 0, -2, 0, 0, 0, 2, 'Dominator'),
('Zarina', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Zarina'),
('Kraagesh', 4, 13, 0, 0, 2, 0, 78, 20, 0, 8, 2, 'Kraagesh'),
('Enigma', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Enigma'),
('Abaddon', 0, 4, 0, 0, 1, 0, 9, 11, 0, 1, 1, 'Abaddon'),
('Gaargod', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Gaargod'),
('BlackJack', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'BlackJack'),
('Othello', 0, 0, 0, 0, 0, 0, -2, 0, 0, 0, 2, 'Othello'),
('Lauren', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Lauren'),
('Diva', 0, 0, 0, 0, 0, 0, -2, 0, 0, 0, 2, 'Diva'),
('Gorge', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Gorge'),
('Ravage', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Ravage'),
('Aryss', 1, 4, 0, 0, 0, 0, 17, 11, 0, 4, 2, 'Aryss'),
('Mokara', 1, 5, 0, 0, 0, 0, 16, 9, 0, 1, 0, 'Mokara'),
('Satin', 0, 0, 0, 0, 4, 0, 24, 9, 0, 7, 0, 'Satin'),
('Corrosion', 1, 5, 2, 0, 0, 0, 24, 9, 0, 4, 0, 'Corrosion'),
('Baird', 0, 0, 0, 0, 1, 0, 6, 6, 0, 1, 0, 'Baird'),
('Azure', 2, 4, 1, 0, 2, 0, 55, 6, 0, 5, 0, 'Azure'),
('Harlequin', 1, 2, 2, 0, 0, 0, 23, 6, 0, 4, 0, 'Harlequin'),
('Domina', 0, 0, 0, 0, 4, 0, 25, 10, 0, 8, 0, 'Domina'),
('Selig', 0, 0, 0, 0, 6, 0, 30, 11, 0, 10, 1, 'Selig'),
('Syzygy', 1, 8, 1, 0, 0, 0, 22, 11, 0, 5, 0, 'Syzygy'),
('Divisor', 0, 0, 0, 1, 4, 0, 23, 11, 0, 8, 1, 'Divisor'),
('Matrix', 0, 7, 0, 0, 4, 0, 21, 11, 0, 4, 2, 'Matrix'),
('Gkublok', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Gkublok'),
('Riker', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Riker'),
('Scarab', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Scarab'),
('Thorax', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Thorax'),
('Hyena', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Hyena'),
('Rylisa', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Rylisa'),
('Virus', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Virus'),
('Jakob', 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Jakob'),
('Komek', 0, 1, 0, 0, 0, 0, -1, 0, 0, 0, 1, 'Komek'),
('Rapier', 0, 0, 0, 0, 7, 0, 50, 10, 0, 12, 1, 'Rapier'),
('Motig', 2, 6, 0, 0, 0, 0, 30, 11, 0, 0, 0, 'Motig'),
('Remus', 0, 0, 1, 0, 6, 0, 38, 11, 0, 10, 0, 'Remus');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `EQPlayerInformation`
--
ALTER TABLE `EQPlayerInformation`
ADD UNIQUE KEY `EQIdentifier` (`EQIdentifier`);
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Everything above is my PC generated data from my local game sessions.
Here comes the UI
(https://i.imgur.com/rZVXYuC.png)