altislife.sql Issue

BrandsPickled

Im currently having a small issue with the altislife.sql

My altislife.sql:

Code

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

Alles anzeigen

ExoTic

Code

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 = `root` @` localhost` PROCEDURE `resetLifeVehicles` ()
BEGIN
 UPDATE `vehicles` SET` active` = 0;
END $$
CREATE DEFINER = `root` @` localhost` PROCEDURE `deleteDeadVehicles` ()
BEGIN
 DELETE FROM `vehicles` WHERE` alive` = 0;
END $$
CREATE DEFINER = `root` @` localhost` PROCEDURE `deleteOldHouses` ()
BEGIN
 DELETE FROM `houses` WHERE` owned` = 0;
END $$
CREATE DEFINER = `root` @` localhost` PROCEDURE `deleteOldGangs` ()
BEGIN
 DELETE FROM `begin 'WHERE` active` = 0;
END $$
CREATE DEFINER = `root` @` 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 * /;

Alles anzeigen

Try this

BrandsPickled

Zitat von ExoTic

Code

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 = `root` @` localhost` PROCEDURE `resetLifeVehicles` ()
BEGIN
 UPDATE `vehicles` SET` active` = 0;
END $$
CREATE DEFINER = `root` @` localhost` PROCEDURE `deleteDeadVehicles` ()
BEGIN
 DELETE FROM `vehicles` WHERE` alive` = 0;
END $$
CREATE DEFINER = `root` @` localhost` PROCEDURE `deleteOldHouses` ()
BEGIN
 DELETE FROM `houses` WHERE` owned` = 0;
END $$
CREATE DEFINER = `root` @` localhost` PROCEDURE `deleteOldGangs` ()
BEGIN
 DELETE FROM `begin 'WHERE` active` = 0;
END $$
CREATE DEFINER = `root` @` localhost` PROCEDURE `deleteOldContainers` ()
BEGIN
 DELETE FROM `containers` WHERE` owned` = 0;
END $$
DELIMITER;
------------------------------------------------ - As 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 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 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 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 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 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 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 * /;

Alles anzeigen

Try this

This code looks wrong

And I press run and still dont work

ExoTic

Which Life version do you use ?

BrandsPickled

Zitat von ExoTic

Which life version do you use?

V4.4r4

https://github.com/AsYetUntitled/Framework/releases

ExoTic

When you use the .sql from Github it should work. Do you edited something in it ?

I'm sorry for speaking English not very well.

BrandsPickled

Zitat von ExoTic

When you use the .sql from Github it should work. Do you have something in it?

I'm sorry for speaking.

It doesnt work, like the first two images are shown

BrandsPickled

Zitat von ExoTic
Code
When you use the .sql from Github it should work. Do you have something in it?
I'm sorry for speaking.

On MySql Workbench the error says:

Code

`Last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (` uid`), UNIQUE KEY `playerid`, KEY` name`, KEY `blacklist` (` blacklist`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 AUTO_INCREMENT = 12 Error Code: 1293. Incorrect table definition; There can only be one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause 0.016 sec

ExoTic

How old is youre MySQL installation ?

BrandsPickled

Zitat von ExoTic

How old is youre MySQL installation?

mysql Ver 14.14 Distrib 5.5.54, for debian-linux-gnu (x86_64) using readline 6.3

ExoTic

I am not sure. Try Update youre MySQL Server. Because "CURRENT_TIMESTAMP" is not implemented on older version of MySQL.

BrandsPickled

Zitat von ExoTic

I am not sure. Try Update youre MySQL Server. Because "CURRENT_TIMESTAMP" is not implemented on older version of MySQL.

What do I need verison Because it 5.5 atm

BrandsPickled

Zitat von ExoTic

I am not sure. Try Update youre MySQL Server. Because "CURRENT_TIMESTAMP" is not implemented on older version of MySQL.

Sorry this is the action / error:

------------------------------------------------ -> 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 ',' 2 ',' 3 ',' 4 ',' 5 ',' 6 ',' 7 ') NOT NULL DEFAULT' 0 ', `mediclevel` enum 1 NOTICE NOT NULL, `` cop_licenses` text NOT NULL, `med_licenses` text NOT NULL,` civ_gear`. NOT NULL DEFAULT '0', `civ_licenses` 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`, KEY` name`, KEY `blacklist` (` blacklist`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 AUTO_INCREMENT = 12

ExoTic

Datei

Navicat Lite (Datenbankverwaltung)

Hier findet ihr Navicat in der Lite-Version welches ihr zum verwalten und bearbeiten eurer Datenbanken verwenden könnt. Mehr Informationen zu Navicat findet ihr hier: http://www.navicat.com/de/

nox

28. Februar 2017 um 18:22

Try this to import the sql file.

BrandsPickled

Zitat von ExoTic

[File = '24 '] [/ file]

Try this to import the sql file.

Still dont work and get this:

Code

[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

Alles anzeigen

BrandsPickled

Zitat von ExoTic

Code

[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
--------------------------------------------------

Alles anzeigen

Code

This hotel is located in the city center.

ExoTic

Zitat von BrandsPickled

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

You need a newer Version of MySQL Server.

BrandsPickled

Whats the latest version?

BrandsPickled

Im having some difficulty to upgrade the MySql to 5.7

BrandsPickled

All fixed thank you! ExoTic