Beiträge von BrandsPickled

[Main]
Version = 1

Randomize Config File = false
;; Randomizes Config File after loading.
;;   Recommend to turn on, if you have enabled filepatching on arma.

Allow Reset = false
;; Allows 9:RESET, usefull for development work

Thread = 0;
;; Option to force number of worker threads for extDB3.
;;   Auto = 0, Min = 2, Max = 6

[Log]
Flush = true;
;; Flush logfile after each update.
;;    Option really only usefull if running DEBUG BUILD


[Database]
IP = 127.0.0.1
Port = 3306
Username = *************
Password = *************
Database = *************

[Err] 1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
[Err] SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Compatible with newer MySQL versions. (After MySQL-5.5)
-- This SQL uses utf8mb4 and has CURRENT_TIMESTAMP function.
--



/*!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: `altislife`
-- Default Schema
--
CREATE DATABASE IF NOT EXISTS `altislife` DEFAULT CHARACTER SET utf8mb4;
USE `altislife`;


--
-- Drop procedures to ensure no conflicts
--
DROP PROCEDURE IF EXISTS `resetLifeVehicles`;
DROP PROCEDURE IF EXISTS `deleteDeadVehicles`;
DROP PROCEDURE IF EXISTS `deleteOldHouses`;
DROP PROCEDURE IF EXISTS `deleteOldGangs`;
DROP PROCEDURE IF EXISTS `deleteOldContainers`;


--
-- Procedures
-- Edit altislife to match a user in MySQL
-- For external databases: Edit localhost to match arma3server IP
--


CREATE DEFINER=`altislife`@`localhost` PROCEDURE `resetLifeVehicles`()
BEGIN
UPDATE `vehicles` SET `active`= 0;
END;


CREATE DEFINER=`altislife`@`localhost` PROCEDURE `deleteDeadVehicles`()
BEGIN
DELETE FROM `vehicles` WHERE `alive` = 0;
END;


CREATE DEFINER=`altislife`@`localhost` PROCEDURE `deleteOldHouses`()
BEGIN
DELETE FROM `houses` WHERE `owned` = 0;
END;


CREATE DEFINER=`altislife`@`localhost` PROCEDURE `deleteOldGangs`()
BEGIN
DELETE FROM `gangs` WHERE `active` = 0;
END;


CREATE DEFINER=`altislife`@`localhost` PROCEDURE `deleteOldContainers`()
BEGIN
DELETE FROM `containers` WHERE `owned` = 0;
END;



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


--
-- Table structure for table `players`
--


CREATE TABLE IF NOT EXISTS `players` (
`uid` int(12) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`aliases` text NOT NULL,
`playerid` varchar(64) NOT NULL,
`cash` int(100) NOT NULL DEFAULT '0',
`bankacc` int(100) NOT NULL DEFAULT '0',
`coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
`mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
`civ_licenses` text NOT NULL,
`cop_licenses` text NOT NULL,
`med_licenses` text NOT NULL,
`civ_gear` text NOT NULL,
`cop_gear` text NOT NULL,
`med_gear` text NOT NULL,
`civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
`cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
`med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
`arrested` tinyint(1) NOT NULL DEFAULT '0',
`adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
`donorlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
`blacklist` tinyint(1) NOT NULL DEFAULT '0',
`civ_alive` tinyint(1) NOT NULL DEFAULT '0',
`civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
`playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
`insert_time` timestamp DEFAULT CURRENT_TIMESTAMP,
`last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`uid`),
UNIQUE KEY `playerid` (`playerid`),
KEY `name` (`name`),
KEY `blacklist` (`blacklist`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=12 ;


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


--
-- Table structure for table `vehicles`
--


CREATE TABLE IF NOT EXISTS `vehicles` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`side` varchar(16) NOT NULL,
`classname` varchar(64) NOT NULL,
`type` varchar(16) NOT NULL,
`pid` varchar(32) NOT NULL,
`alive` tinyint(1) NOT NULL DEFAULT '1',
`blacklist` tinyint(1) NOT NULL DEFAULT '0',
`active` tinyint(1) NOT NULL DEFAULT '0',
`plate` int(20) NOT NULL,
`color` int(20) NOT NULL,
`inventory` text NOT NULL,
`gear` text NOT NULL,
`fuel` double NOT NULL DEFAULT '1',
`damage` varchar(256) NOT NULL,
`insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `side` (`side`),
KEY `pid` (`pid`),
KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2 ;


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


--
-- Table structure for 
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[SQL] SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
Affected rows: 0
Time: 0.022s

[SQL]
SET time_zone = "+00: 00";
Affected rows: 0
Time: 0.023s

[SQL]
-
- Compatible with newer MySQL versions. (After MySQL 5.5)
- This SQL uses utf8mb4 and has CURRENT_TIMESTAMP function.
-


/ *! 40101 SET @OLD_CHARACTER_SET_CLIENT = @@ CHARACTER_SET_CLIENT * /;
Affected rows: 0
Time: 0.023s

[SQL]
/ *! 40101 SET @OLD_CHARACTER_SET_RESULTS = @@ CHARACTER_SET_RESULTS * /;
Affected rows: 0
Time: 0.049s

[SQL]
/ *! 40101 SET @OLD_COLLATION_CONNECTION = @@ COLLATION_CONNECTION * /;
Affected rows: 0
Time: 0.048s

[SQL]
/ *! 40101 SET NAMES utf8mb4 * /;
Affected rows: 0
Time: 0.025s

[SQL]

-
- Database: `altislife`
- Default scheme
-
CREATE DATABASE IF NOT EXISTS `altislife` DEFAULT CHARACTER SET utf8mb4;
Affected rows: 1
Time: 0.024s

[SQL]
USE `altislife`;
Affected rows: 0
Time: 0.024s

[SQL]

-
- Drop procedures to ensure no conflicts
-
DROP PROCEDURE IF EXISTS `resetLifeVehicles`;
Affected rows: 0
Time: 0.021s

[SQL]
DROP PROCEDURE IF EXISTS `deleteDeadVehicles`;
Affected rows: 0
Time: 0.022s

[SQL]
DROP PROCEDURE IF EXISTS `deleteOldHouses`;
Affected rows: 0
Time: 0.023s

[SQL]
DROP PROCEDURE IF EXISTS `deleteOldGangs`;
Affected rows: 0
Time: 0.024s

[SQL]
DROP PROCEDURE IF EXISTS `deleteOldContainers`;
Affected rows: 0
Time: 0.024s

[SQL]


-
- Procedures
- Edit arma3 to match a user in MySQL
- For external databases: Edit localhost to match arma3server IP
-

CREATE DEFINER = `altislife` @` localhost` PROCEDURE `resetLifeVehicles` ()
BEGIN
  UPDATE `vehicles` SET` active` = 0;
END;
Affected rows: 0
Time: 0.022s

[SQL]

CREATE DEFINER = `altislife` @` localhost` PROCEDURE `deleteDeadVehicles` ()
BEGIN
  DELETE FROM `vehicles` WHERE` alive` = 0;
END;
Affected rows: 0
Time: 0.025s

[SQL]

CREATE DEFINER = `altislife` @` localhost` PROCEDURE `deleteOldHouses` ()
BEGIN
  DELETE FROM `houses` WHERE` owned` = 0;
END;
Affected rows: 0
Time: 0.025s

[SQL]

CREATE DEFINER = `altislife` @` localhost` PROCEDURE `deleteOldGangs` ()
BEGIN
  DELETE FROM `begin 'WHERE` active` = 0;
END;
Affected rows: 0
Time: 0.023s

[SQL]

CREATE DEFINER = `altislife` @` localhost` PROCEDURE `deleteOldContainers` ()
BEGIN
  DELETE FROM `containers` WHERE` owned` = 0;
END;
Affected rows: 0
Time: 0.025s

[SQL]



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

-
- Table structure for table `players`
-

CREATE TABLE IF NOT EXISTS `players` (
  `Uid` int (12) NOT NULL AUTO_INCREMENT,
  `Name` varchar (32) NOT NULL,
  `Aliases` text NOT NULL,
  `Playerid` varchar (64) NOT NULL,
  `Cash` int (100) NOT NULL DEFAULT '0',
  `Bankacc` int (100) NOT NULL DEFAULT '0',
  `Coplevel` enum ('0', '1', '2', '3', '4', '5', '6', '7') NOT NULL DEFAULT '0'
  `MEDICLEVEL` ENUM ('0', '1', '2', '3', '4', '5') NOT NULL DEFAULT '0'
  `Civ_licenses` text NOT NULL,
  `Cop_licenses` text NOT NULL,
  `Med_licenses` text NOT NULL,
  `Civ_gear` text NOT NULL,
  `Cop_gear` text NOT NULL,
  `Med_gear` text NOT NULL,
  `Civ_stats` varchar (32) NOT NULL DEFAULT '" [100,100,0] "',
  `Cop_stats` varchar (32) NOT NULL DEFAULT '" [100,100,0] "',
  `Med_stats` varchar (32) NOT NULL DEFAULT '" [100,100,0] "',
  `Arrested` tinyint (1) NOT NULL DEFAULT '0',
  `Adminlevel` enum ('0', '1', '2', '3', '4', '5') NOT NULL DEFAULT '0'
  `Donorlevel` enum ('0', '1', '2', '3', '4', '5') NOT NULL DEFAULT '0'
  `Blacklist` tinyint (1) NOT NULL DEFAULT '0',
  `Civ_alive` tinyint (1) NOT NULL DEFAULT '0',
  `Civ_position` varchar (64) NOT NULL DEFAULT '" [] "',
  `Playtime` varchar (32) NOT NULL DEFAULT '" [0,0,0] "',
  `Insert_time` timestamp DEFAULT CURRENT_TIMESTAMP,
  `Last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`uid`),
  UNIQUE KEY `playerid` (` playerid`),
  KEY `name` (` name`),
  KEY `blacklist` (` blacklist`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 AUT_INCREMENT = 12;
[Err] 1293 - Incorrect table definition; There can only be one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

This is the place to stay! SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00: 00";
-
- Compatible with newer MySQL versions. (After MySQL 5.5)
- This SQL uses utf8mb4 and has CURRENT_TIMESTAMP function.
-


/ *! 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: `altislife`
- Default scheme
-
CREATE DATABASE IF NOT EXISTS `altislife` DEFAULT CHARACTER SET utf8mb4;
USE `altislife`;

-
- Drop procedures to ensure no conflicts
-
DROP PROCEDURE IF EXISTS `resetLifeVehicles`;
DROP PROCEDURE IF EXISTS `deleteDeadVehicles`;
DROP PROCEDURE IF EXISTS `deleteOldHouses`;
DROP PROCEDURE IF EXISTS `deleteOldGangs`;
DROP PROCEDURE IF EXISTS `deleteOldContainers`;

DELIMITER $$
-
- Procedures
- Edit arma3 to match a user in MySQL
- For external databases: Edit localhost to match arma3server IP
-

CREATE DEFINER = `altislife` @` localhost` PROCEDURE `resetLifeVehicles` ()
BEGIN
  UPDATE `vehicles` SET` active` = 0;
END $$

CREATE DEFINER = `altislife` @` localhost` PROCEDURE `deleteDeadVehicles` ()
BEGIN
  DELETE FROM `vehicles` WHERE` alive` = 0;
END $$

CREATE DEFINER = `altislife` @` localhost` PROCEDURE `deleteOldHouses` ()
BEGIN
  DELETE FROM `houses` WHERE` owned` = 0;
END $$

CREATE DEFINER = `altislife` @` localhost` PROCEDURE `deleteOldGangs` ()
BEGIN
  DELETE FROM `begin 'WHERE` active` = 0;
END $$

CREATE DEFINER = `altislife` @` localhost` PROCEDURE `deleteOldContainers` ()
BEGIN
  DELETE FROM `containers` WHERE` owned` = 0;
END $$

DELIMITER;

------------------------------------------------ - As shown in Fig.

-
- Table structure for table `players`
-

CREATE TABLE IF NOT EXISTS `players` (
  `Uid` int (12) NOT NULL AUTO_INCREMENT,
  `Name` varchar (32) NOT NULL,
  `Aliases` text NOT NULL,
  `Playerid` varchar (64) NOT NULL,
  `Cash` int (100) NOT NULL DEFAULT '0',
  `Bankacc` int (100) NOT NULL DEFAULT '0',
  `Coplevel` enum ('0', '1', '2', '3', '4', '5', '6', '7') NOT NULL DEFAULT '0'
  `MEDICLEVEL` ENUM ('0', '1', '2', '3', '4', '5') NOT NULL DEFAULT '0'
  `Civ_licenses` text NOT NULL,
  `Cop_licenses` text NOT NULL,
  `Med_licenses` text NOT NULL,
  `Civ_gear` text NOT NULL,
  `Cop_gear` text NOT NULL,
  `Med_gear` text NOT NULL,
  `Civ_stats` varchar (32) NOT NULL DEFAULT '" [100,100,0] "',
  `Cop_stats` varchar (32) NOT NULL DEFAULT '" [100,100,0] "',
  `Med_stats` varchar (32) NOT NULL DEFAULT '" [100,100,0] "',
  `Arrested` tinyint (1) NOT NULL DEFAULT '0',
  `Adminlevel` enum ('0', '1', '2', '3', '4', '5') NOT NULL DEFAULT '0'
  (0 ',' 1 ',' 2 ',' 3 ',' 4 ',' 5 ') NOT NULL DEFAULT' 0 '
  `Blacklist` tinyint (1) NOT NULL DEFAULT '0',
  `Civ_alive` tinyint (1) NOT NULL DEFAULT '0',
  `Civ_position` varchar (64) NOT NULL DEFAULT '" [] "',
  `Playtime` varchar (32) NOT NULL DEFAULT '" [0,0,0] "',
  `Insert_time` timestamp DEFAULT CURRENT_TIMESTAMP,
  `Last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`uid`),
  UNIQUE KEY `playerid` (` playerid`),
  KEY `name` (` name`),
  KEY `blacklist` (` blacklist`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 AUTO_INCREMENT = 12;

------------------------------------------------ - As shown in Fig.

-
- Table structure for table `vehicles`
-

CREATE TABLE IF NOT EXISTS `vehicles` (
  `Id` int (12) NOT NULL AUTO_INCREMENT,
  `Side` varchar (16) NOT NULL,
  `Classname` varchar (64) NOT NULL,
  `Type` varchar (16) NOT NULL,
  `Pid` varchar (32) NOT NULL,
  `Alive` tinyint (1) NOT NULL DEFAULT '1',
  `Blacklist` tinyint (1) NOT NULL DEFAULT '0',
  `Active` tinyint (1) NOT NULL DEFAULT '0',
  `Plate` int (20) NOT NULL,
  `Color` int (20) NOT NULL,
  `Inventory` text NOT NULL,
  `Gear` text NOT NULL,
  `Fuel` double NOT NULL DEFAULT '1',
  `Damage` varchar (256) NOT NULL,
  `Insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `side` (` side`),
  KEY `pid` (` pid`),
  KEY `type` (` type`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 AUTO_INCREMENT = 2;

------------------------------------------------ - As shown in Fig.

-
- Table structure for table `houses`
- Needed for extDB latest update on git
-

CREATE TABLE IF NOT EXISTS `houses` (
  `Id` int (11) NOT NULL AUTO_INCREMENT,
  `Pid` varchar (32) NOT NULL,
  `Pos` varchar (64) DEFAULT NULL,
  `Owned` tinyint (1) DEFAULT '0',
  `Insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`,` pid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 AUTO_INCREMENT = 4;

------------------------------------------------ - As shown in Fig.

-
- Table structure for table `gangs`
- Needed for extDB latest update on git
-

CREATE TABLE IF NOT EXISTS `gangs` (
  `Id` int (11) NOT NULL AUTO_INCREMENT,
  `Owner` varchar (32) DEFAULT NULL,
  `Name` varchar (32) DEFAULT NULL,
  `Members` text,
  `Maxmembers` int (3) DEFAULT '8',
  `Bank` int (100) DEFAULT '0',
  `Active` tinyint (1) DEFAULT '1',
  `Insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_UNIQUE` (` name`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;

------------------------------------------------ - As shown in Fig.

-
- Table structure for table `containers`
- Needed for extDB latest update on git
-

CREATE TABLE IF NOT EXISTS `containers` (
  `Id` int (11) NOT NULL AUTO_INCREMENT,
  `Pid` varchar (32) NOT NULL,
  `Classname` varchar (32) NOT NULL,
  `Pos` varchar (64) DEFAULT NULL,
  `Inventory` text NOT NULL,
  `Gear` text NOT NULL,
  `Dir` varchar (128) DEFAULT NULL,
  `Active` tinyint (1) NOT NULL DEFAULT '0',
  `Owned` tinyint (1) DEFAULT '0',
  `Insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`,` pid`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 AUTO_INCREMENT = 4;

------------------------------------------------ - As shown in Fig.

-
- Table structure for table `wanted`
- Needed for extDB latest update on git
-

CREATE TABLE IF NOT EXISTS `wanted` (
  `WantedID` varchar (64) NOT NULL,
  `WantedName` varchar (32) NOT NULL,
  `WantedCrimes` text NOT NULL,
  `WantedBounty` int (100) NOT NULL,
  `Active` tinyint (1) NOT NULL DEFAULT '0',
  `Insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`wantedID`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;

------------------------------------------------ - As shown in Fig.

/ *! 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 * /;