• Beiträge von Xdarel2011

    • Maverick Tuning Shop

      Zitat

      Hey Liebe Freunde habe dort ein Problem mit dem tuning shop undzwar versuche ich den Tuning shop so hinzukriegen das ich nur mit einer lizenz diesen nutzen kann habe bereits nur dieses gefunden Hier Aber werde aus diesen nicht ganz schlau Die lizenz ist class tuner { variable = "tuner"; displayName = "STR_License_Tuner"; price = 500; illegal = false; side = "civ"; };

      Bereits Probierte Codes im NPC

      if (license_tuner) then { npc_tuning_1 = true; };

      In der Fn_start

      Liegt dies so

      if (!license_tuner) exitWith {hint "Du hast keine Lizens!"};


      hat dort jemand ne idee wie ich das umsetzen kanndashdashdash

    • Maverick Tuning Shop

      Fahrzeuge sind drinne zb C_Offroad_01_F

    • Maverick Tuning Shop

      Heyy freunde der Arma Gemeinde

      Habe dort ein Kleines problem mit dem Tuning shop und zwar steht leider in der Anleitung nicht drinne wie diese zeile eingefügt wird

      [vehicle player] spawn mav_tuning_fnc_start;


      Diese zeile ist im NPC Vorhanden nur er sacht mir immer das das fahrzeug nicht Getunt werden kann habe schon die classnames editiert

      npc_tuning_1 = this;

      Weiß da einer von euch Rat

    • MAX ATM Geld Abheben/Einzahlen

      Habe Bereits die Lösung gefunden

      Spoiler anzeigen

      fn_bankDeposit.sqf

      #include "..\..\script_macros.hpp"

      /*

      File: fn_bankDeposit.sqf

      Author: Bryan "Tonic" Boardwine

      Description:

      Figure it out.

      */

      private ["_value"];

      _value = parseNumber(ctrlText 2702);

      //Series of stupid checks

      if (_value > 999999) exitWith {hint localize "STR_ATM_GreaterThan";};

      if (_value < 0) exitWith {};

      if (!([str(_value)] call TON_fnc_isnumber)) exitWith {hint localize "STR_ATM_notnumeric"};

      if (_value > CASH) exitWith {hint localize "STR_ATM_NotEnoughCash"};

      CASH = CASH - _value;

      BANK = BANK + _value;

      hint format [localize "STR_ATM_DepositSuccess",[_value] call life_fnc_numberText];

      [] call life_fnc_atmMenu;

      [6] call SOCK_fnc_updatePartial;

      if (LIFE_SETTINGS(getNumber,"player_moneyLog") isEqualTo 1) then {

      if (LIFE_SETTINGS(getNumber,"battlEye_friendlyLogging") isEqualTo 1) then {

      money_log = format [localize "STR_DL_ML_depositedBank_BEF",_value,[BANK] call life_fnc_numberText,[CASH] call life_fnc_numberText];

      } else {

      money_log = format [localize "STR_DL_ML_depositedBank",profileName,(getPlayerUID player),_value,[BANK] call life_fnc_numberText,[CASH] call life_fnc_numberText];

      };

      publicVariableServer "money_log";

      };


      in

      #include "..\..\script_macros.hpp"

      /*

      File: fn_bankDeposit.sqf

      Author: Bryan "Tonic" Boardwine

      Description:

      Figure it out.

      */

      private ["_value"];

      _value = parseNumber(ctrlText 2702);

      //Series of stupid checks

      if (_value > 1000000000) exitWith {hint localize "STR_ATM_GreaterThan";};

      if (_value < 0) exitWith {};

      //if (!([str(_value)] call TON_fnc_isnumber)) exitWith {hint localize "STR_ATM_notnumeric"};

      if (_value > CASH) exitWith {hint localize "STR_ATM_NotEnoughCash"};

      CASH = CASH - _value;

      BANK = BANK + _value;

      hint format [localize "STR_ATM_DepositSuccess",[_value] call life_fnc_numberText];

      [] call life_fnc_atmMenu;

      [6] call SOCK_fnc_updatePartial;

      if (LIFE_SETTINGS(getNumber,"player_moneyLog") isEqualTo 1) then {

      if (LIFE_SETTINGS(getNumber,"battlEye_friendlyLogging") isEqualTo 1) then {

      money_log = format [localize "STR_DL_ML_depositedBank_BEF",_value,[BANK] call life_fnc_numberText,[CASH] call life_fnc_numberText];

      } else {

      money_log = format [localize "STR_DL_ML_depositedBank",profileName,(getPlayerUID player),_value,[BANK] call life_fnc_numberText,[CASH] call life_fnc_numberText];

      };

      publicVariableServer "money_log";

      };

      und bei der fn_bankWithdraw.sqf

      #include "..\..\script_macros.hpp"

      /*

      File: fn_bankWithdraw.sqf

      Author: Bryan "Tonic" Boardwine

      Description:

      Withdraws money from the players account

      */

      private ["_value"];

      _value = parseNumber(ctrlText 2702);

      if (_value > 999999) exitWith {hint localize "STR_ATM_WithdrawMax";};

      if (_value < 0) exitWith {};

      if (!([str(_value)] call TON_fnc_isnumber)) exitWith {hint localize "STR_ATM_notnumeric"};

      if (_value > BANK) exitWith {hint localize "STR_ATM_NotEnoughFunds"};

      if (_value < 100 && BANK > 20000000) exitWith {hint localize "STR_ATM_WithdrawMin"}; //Temp fix for something.

      CASH = CASH + _value;

      BANK = BANK - _value;

      hint format [localize "STR_ATM_WithdrawSuccess",[_value] call life_fnc_numberText];

      [] call life_fnc_atmMenu;

      [6] call SOCK_fnc_updatePartial;

      if (LIFE_SETTINGS(getNumber,"player_moneyLog") isEqualTo 1) then {

      if (LIFE_SETTINGS(getNumber,"battlEye_friendlyLogging") isEqualTo 1) then {

      money_log = format [localize "STR_DL_ML_withdrewBank_BEF",_value,[BANK] call life_fnc_numberText,[CASH] call life_fnc_numberText];

      } else {

      money_log = format [localize "STR_DL_ML_withdrewBank",profileName,(getPlayerUID player),_value,[BANK] call life_fnc_numberText,[CASH] call life_fnc_numberText];

      };

      publicVariableServer "money_log";

      };


      In

      #include "..\..\script_macros.hpp"

      /*

      File: fn_bankWithdraw.sqf

      Author: Bryan "Tonic" Boardwine

      Description:

      Withdraws money from the players account

      */

      private ["_value"];

      _value = parseNumber(ctrlText 2702);

      //if (_value > 1000000000) exitWith {hint localize "STR_ATM_WithdrawMax";};

      if (_value < 0) exitWith {};

      //if (!([str(_value)] call TON_fnc_isnumber)) exitWith {hint localize "STR_ATM_notnumeric"};

      if (_value > BANK) exitWith {hint localize "STR_ATM_NotEnoughFunds"};

      if (_value < 100 && BANK > 20000000) exitWith {hint localize "STR_ATM_WithdrawMin"}; //Temp fix for something.

      CASH = CASH + _value;

      BANK = BANK - _value;

      hint format [localize "STR_ATM_WithdrawSuccess",[_value] call life_fnc_numberText];

      [] call life_fnc_atmMenu;

      [6] call SOCK_fnc_updatePartial;

      if (LIFE_SETTINGS(getNumber,"player_moneyLog") isEqualTo 1) then {

      if (LIFE_SETTINGS(getNumber,"battlEye_friendlyLogging") isEqualTo 1) then {

      money_log = format [localize "STR_DL_ML_withdrewBank_BEF",_value,[BANK] call life_fnc_numberText,[CASH] call life_fnc_numberText];

      } else {

      money_log = format [localize "STR_DL_ML_withdrewBank",profileName,(getPlayerUID player),_value,[BANK] call life_fnc_numberText,[CASH] call life_fnc_numberText];

      };

      publicVariableServer "money_log";

      };


    • MAX ATM Geld Abheben/Einzahlen

      Hey Leute habe unter der suchfunktion nichts Gefunden zu Meinem Thema

      Und zwar suche ich eine Möglichkeit das Maximal Abhebare Geld Beim ATM Zu Ändern Sowie Das einzahlen

      Möchte den wert von 999.999 auf 1.000.000.000 Anheben

      Da ich Dieses auf meinem Fun Server Ändern möchte damit die Spieler nicht 5000x Drücken müssen für 5 Milliarden


      Diesen Codes Habe ich Bereits Zum Testen Geändert

      Spoiler anzeigen

      fn_bankWithdraw.sqf


      if (_value > 999999) exitWith {hint localize "STR_ATM_WithdrawMax";};

      fn_bankDeposit.sqf

      if (_value > 999999) exitWith {hint localize "STR_ATM_GreaterThan";};

      Geädert zu

      fn_bankWithdraw.sqf

      if (_value > 1000000000) exitWith {hint localize "STR_ATM_WithdrawMax";};

      fn_bankDeposit.sqf

      if (_value > 1000000000) exitWith {hint localize "STR_ATM_GreaterThan";};

      Nur er Sagt mir den es Sei Keine Richtige Zahl wen ich auf dem server das geld abheben Möchte


      Hoffe ich Könntet mir Helfen

    • Altis Life Datenbank Anderer Name


      Hay Freunde die ist mein erstes Problem mit Altis Life


      Also ich besitze auf dem root bereits einen altis life server mit DB Name altislife & User arma3

      so nun möchte ich dort einen tanoa life server aufsetzen


      Nun mein problem die datenbanken sollen getrennt werden von ein ander


      Schaut es euch mal


      Spoiler anzeigen

      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`;


      DROP PROCEDURE IF EXISTS `deleteOldWanted`;


      DELIMITER $$


      --


      -- Procedures


      -- Edit arma3 to match a user in MySQL


      -- For external databases: Edit localhost to match arma3server IP


      --


      CREATE DEFINER=`arma3`@`localhost` PROCEDURE `resetLifeVehicles`()


      BEGIN


      UPDATE `vehicles` SET `active`= 0;


      END$$


      CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteDeadVehicles`()


      BEGIN


      DELETE FROM `vehicles` WHERE `alive` = 0;


      END$$


      CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldHouses`()


      BEGIN


      DELETE FROM `houses` WHERE `owned` = 0;


      END$$


      CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldGangs`()


      BEGIN


      DELETE FROM `gangs` WHERE `active` = 0;


      END$$


      CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldContainers`()


      BEGIN


      DELETE FROM `containers` WHERE `owned` = 0;


      END$$


      CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldWanted`()


      BEGIN


      DELETE FROM `wanted` WHERE `active` = 0;


      END$$


      DELIMITER ;


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


      --


      -- Table structure for table `players`


      --


      CREATE TABLE IF NOT EXISTS `players` (


      `uid` int(6) NOT NULL AUTO_INCREMENT,


      `name` varchar(32) NOT NULL,


      `aliases` text NOT NULL,


      `pid` varchar(17) 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 `pid` (`pid`),


      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(6) NOT NULL AUTO_INCREMENT,


      `side` varchar(16) NOT NULL,


      `classname` varchar(64) NOT NULL,


      `type` varchar(16) NOT NULL,


      `pid` varchar(17) 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 table `houses`


      -- Needed for extDB latest update on git


      --


      CREATE TABLE IF NOT EXISTS `houses` (


      `id` int(6) NOT NULL AUTO_INCREMENT,


      `pid` varchar(17) NOT NULL,


      `pos` varchar(64) DEFAULT NULL,


      `owned` tinyint(1) DEFAULT '0',


      `garage` tinyint(1) NOT NULL DEFAULT '0',


      `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,


      PRIMARY KEY (`id`,`pid`)


      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=4 ;


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


      --


      -- Table structure for table `gangs`


      -- Needed for extDB latest update on git


      --


      CREATE TABLE IF NOT EXISTS `gangs` (


      `id` int(6) 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;


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


      --


      -- Table structure for table `containers`


      -- Needed for extDB latest update on git


      --


      CREATE TABLE IF NOT EXISTS `containers` (


      `id` int(6) NOT NULL AUTO_INCREMENT,


      `pid` varchar(17) 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;


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


      --


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


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


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


      IN

      Spoiler anzeigen

      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 `altislife2` DEFAULT CHARACTER SET utf8mb4;


      USE `altislife2`;


      --


      -- 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`;


      DROP PROCEDURE IF EXISTS `deleteOldWanted`;


      DELIMITER $$


      --


      -- Procedures


      -- Edit arma4 to match a user in MySQL


      -- For external databases: Edit localhost to match arma4server IP


      --


      CREATE DEFINER=`arma4`@`localhost` PROCEDURE `resetLifeVehicles`()


      BEGIN


      UPDATE `vehicles` SET `active`= 0;


      END$$


      CREATE DEFINER=`arma4`@`localhost` PROCEDURE `deleteDeadVehicles`()


      BEGIN


      DELETE FROM `vehicles` WHERE `alive` = 0;


      END$$


      CREATE DEFINER=`arma4`@`localhost` PROCEDURE `deleteOldHouses`()


      BEGIN


      DELETE FROM `houses` WHERE `owned` = 0;


      END$$


      CREATE DEFINER=`arma4`@`localhost` PROCEDURE `deleteOldGangs`()


      BEGIN


      DELETE FROM `gangs` WHERE `active` = 0;


      END$$


      CREATE DEFINER=`arma4`@`localhost` PROCEDURE `deleteOldContainers`()


      BEGIN


      DELETE FROM `containers` WHERE `owned` = 0;


      END$$


      CREATE DEFINER=`arma4`@`localhost` PROCEDURE `deleteOldWanted`()


      BEGIN


      DELETE FROM `wanted` WHERE `active` = 0;


      END$$


      DELIMITER ;


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


      --


      -- Table structure for table `players`


      --


      CREATE TABLE IF NOT EXISTS `players` (


      `uid` int(6) NOT NULL AUTO_INCREMENT,


      `name` varchar(32) NOT NULL,


      `aliases` text NOT NULL,


      `pid` varchar(17) 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 `pid` (`pid`),


      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(6) NOT NULL AUTO_INCREMENT,


      `side` varchar(16) NOT NULL,


      `classname` varchar(64) NOT NULL,


      `type` varchar(16) NOT NULL,


      `pid` varchar(17) 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 table `houses`


      -- Needed for extDB latest update on git


      --


      CREATE TABLE IF NOT EXISTS `houses` (


      `id` int(6) NOT NULL AUTO_INCREMENT,


      `pid` varchar(17) NOT NULL,


      `pos` varchar(64) DEFAULT NULL,


      `owned` tinyint(1) DEFAULT '0',


      `garage` tinyint(1) NOT NULL DEFAULT '0',


      `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,


      PRIMARY KEY (`id`,`pid`)


      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=4 ;


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


      --


      -- Table structure for table `gangs`


      -- Needed for extDB latest update on git


      --


      CREATE TABLE IF NOT EXISTS `gangs` (


      `id` int(6) 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;


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


      --


      -- Table structure for table `containers`


      -- Needed for extDB latest update on git


      --


      CREATE TABLE IF NOT EXISTS `containers` (


      `id` int(6) NOT NULL AUTO_INCREMENT,


      `pid` varchar(17) 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;


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


      --


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


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


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




      Er sacht mir jedes mal hat diesen einen fehler das


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

      MySQL meldet: Dokumentation

      #1227 - Kein Zugriff. Hierfür wird die Berechtigung SUPER benötigt


      Dabei sind alle Rechte Vorhanden


      Vielleicht habt ihr eine Lösung wäre sehr hilfreich