[Nexicon]

I would like something that too.

[B3none]

Can someone please give me a mysql dump from their calladmin database please.

[Nexicon]

Originally Posted by b3none Can someone please give me a mysql dump from their calladmin database please.

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `csgo`
--

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `CallAdmin`
--

CREATE TABLE `CallAdmin` (
  `callID` int(10) UNSIGNED NOT NULL,
  `serverIP` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `serverPort` smallint(5) UNSIGNED NOT NULL,
  `serverName` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `serverKey` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `targetName` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `targetID` varchar(21) COLLATE utf8_unicode_ci NOT NULL,
  `targetReason` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `clientName` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `clientID` varchar(21) COLLATE utf8_unicode_ci NOT NULL,
  `callHandled` tinyint(3) UNSIGNED NOT NULL,
  `reportedAt` int(10) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `CallAdmin_Access`
--

CREATE TABLE `CallAdmin_Access` (
  `serverKey` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `accessBit` bigint(20) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `CallAdmin_Settings`
--

CREATE TABLE `CallAdmin_Settings` (
  `version` varchar(12) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Data dump for tabellen `CallAdmin_Settings`
--

INSERT INTO `CallAdmin_Settings` (`version`) VALUES
('0.1.5');

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `CallAdmin_Trackers`
--

CREATE TABLE `CallAdmin_Trackers` (
  `trackerIP` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `trackerID` varchar(21) COLLATE utf8_unicode_ci NOT NULL,
  `lastView` int(10) UNSIGNED NOT NULL,
  `accessID` bigint(20) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Begrænsninger for dumpede tabeller
--

--
-- Indeks for tabel `CallAdmin`
--
ALTER TABLE `CallAdmin`
  ADD PRIMARY KEY (`callID`),
  ADD KEY `serverIP_serverPort` (`serverIP`,`serverPort`),
  ADD KEY `reportedAt` (`reportedAt`),
  ADD KEY `callHandled` (`callHandled`),
  ADD KEY `serverKey` (`serverKey`);

--
-- Indeks for tabel `CallAdmin_Access`
--
ALTER TABLE `CallAdmin_Access`
  ADD UNIQUE KEY `serverKey` (`serverKey`);

--
-- Indeks for tabel `CallAdmin_Trackers`
--
ALTER TABLE `CallAdmin_Trackers`
  ADD UNIQUE KEY `trackerIP` (`trackerIP`),
  ADD KEY `lastView` (`lastView`);

--
-- Brug ikke AUTO_INCREMENT for slettede tabeller
--

--
-- Tilføj AUTO_INCREMENT i tabel `CallAdmin`
--
ALTER TABLE `CallAdmin`
  MODIFY `callID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;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 */;

[B3none]

Hey, thanks, but that is the table. I need some actual results as well to use as test data.

It'd be a tremendous help

[Nexicon]

Sorry i cannot help with this due to i'm not running servers atm.... Hope someone else run this plugin at the moment so you can get it