Beiträge von Raptor772000

ALTER TABLE `players` ADD (
`adaclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0'
);




ALTER TABLE `players` ADD (
`adac_licenses` text NOT NULL
);




ALTER TABLE `players` ADD (
`adac_gear` text NOT NULL
);




ALTER TABLE `players` ADD (
`adac_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"'
);

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;




--
-- Database: `AltisLife`
-- Default Schema
--
CREATE DATABASE IF NOT EXISTS `AltisLife` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `AltisLife`;




DELIMITER $$
--
-- Procedures
-- Edit arma3 to match a user in MySQ
-- 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 `gangs` WHERE `active` = 0;
END$$




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




DELIMITER ;




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




--
-- 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(50) 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',
  `adaclevel` 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,
  `adac_licenses` text NOT NULL,
  `civ_gear` text NOT NULL,
  `cop_gear` text NOT NULL,
  `med_gear` text NOT NULL,
  `adac_gear` text NOT NULL,
  `civ_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
  `cop_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
  `med_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
  `adac_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
  `arrested` tinyint(1) NOT NULL DEFAULT '0',
  `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
  `donatorlvl` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
  `blacklist` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`),
  UNIQUE KEY `playerid` (`playerid`),
  KEY `name` (`name`),
  KEY `blacklist` (`blacklist`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;




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




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




CREATE TABLE IF NOT EXISTS `vehicles` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `side` varchar(15) NOT NULL,
  `classname` varchar(32) NOT NULL,
  `type` varchar(12) NOT NULL,
  `pid` varchar(32) NOT NULL,
  `alive` tinyint(1) NOT NULL DEFAULT '1',
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `plate` int(20) NOT NULL,
  `color` int(20) NOT NULL,
  `inventory` varchar(500) NOT NULL,
  `gear` text NOT NULL,
  `fuel` double NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `side` (`side`),
  KEY `pid` (`pid`),
  KEY `type` (`type`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;




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




--
-- 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(4) DEFAULT '0',
  PRIMARY KEY (`id`,`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;




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




--
-- 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(2) DEFAULT '8',
  `bank` int(100) DEFAULT '0',
  `active` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_UNIQUE` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




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




--
-- 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` varchar(500) NOT NULL,
  `gear` text NOT NULL,
  `dir` varchar(64) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `owned` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`,`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;




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




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




CREATE TABLE `wanted` (
  `wantedID` varchar(50) NOT NULL,
  `wantedName` varchar(52) NOT NULL,
  `wantedCrimes` text NOT NULL,
  `wantedBounty` int(100) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`wantedID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




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




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

//Zum ADAC
TON_fnc_cell_adacrequest =
compileFinal "
private[""_msg"",""_to""];
    ctrlShow[3023,false];
    _msg = ctrlText 3003;
    _to = ""The ADAC"";
    if(_msg == """") exitWith {hint ""Du must eine Nachricht erst eine Nachricht schreiben!"";ctrlShow[3023,true];};
    [_msg,name player,6,mapGridPosition player,player] remoteExecCall [""TON_fnc_clientMessage"",east];
    [] call life_fnc_cellphone;
    hint format[""Notruf abgesendet"",_to,_msg];
    ctrlShow[3023,true];
";

case 6: {
    if(side player != east) exitWith {};
    private[""_message"",""_loc"",""_unit""];
    _loc = _this select 3;
    _unit = _this select 4;
    _message = format[""!!! ADAC NOTRUF: %1"",_msg];
    hint parseText format [""<t color='#FFCC00'><t size='2'><t align='center'>Eingehender Notruf<br/><br/><t color='#33CC33'><t align='left'><t size='1'>Von: <t color='#ffffff'>%1<br/><t color='#33CC33'>Koordinaten: <t color='#ffffff'>%2<br/><br/><t color='#33CC33'>Nachricht:<br/><t color='#ffffff'>%3"",_from,_loc,_msg];




    [""AdacMessage"",[format[""Notruf von %1"",_from]]] call bis_fnc_showNotification;
};

class adac_clothing {
    title = "STR_MAR_Adac_Clothing_Shop";
    license = "";
    side = "adac";
    uniforms[] = {
        { "NONE", "Uniform entfernen", 0, { "", "", -1 } },
        { "U_B_HeliPilotCoveralls", "ADAC Uniform", 50, { "", "", -1 } }
    };
    headgear[] = {
        { "NONE", "Kopfbedeckung entfernen", 0, { "", "", -1 } },
        { "H_Cap_marshal", "", 10, { "", "", -1 } }
    };
    goggles[] = {
        { "NONE", "Brille etfernen", 0, { "", "", -1 } },
        { "G_Shades_Black", "", 10, { "", "", -1 } },
        { "G_Shades_Blue", "", 10, { "", "", -1 } },
	{ "G_Sport_Blackred", "", 10, { "", "", -1 } },
        { "G_Sport_Checkered", "", 10, { "", "", -1 } },
        { "G_Sport_Blackyellow", "", 10, { "", "", -1 } },
        { "G_Sport_BlackWhite", "", 10, { "", "", -1 } },
        { "G_Aviator", "", 10, { "", "", -1 } },
        { "G_Squares", "", 10, { "", "", -1 } },
        { "G_Lowprofile", "", 10, { "", "", -1 } }
    };
    vests[] = {
       { "NONE", "Weste entfernen", 0, { "", "", -1 } }
    };
    backpacks[] = {
        { "NONE", "Rucksack entfernen", 0, { "", "", -1 } },
        { "B_Kitbag_cbr", "ADAC Rucksack", 3000, { "", "", -1 } }
    };
};

//Adac Shops
class adac_basic {
    name = "ADAC Fundgrube";
    side = "adac";
    license = "";
    level[] = { "", "", -1, "" };
    items[] = {
        { "ItemGPS", "", 100, 45 },
        { "Binocular", "", 150, -1 },
        { "ToolKit", "", 250, 75 },
        { "FirstAidKit", "", 150, 65 },
        { "NVGoggles", "", 1200, 980 }
    };
    mags[] = {};
};

//ADAC Licenses
class adacAir {
    variable = "adacAir";
    displayName = "STR_License_Pilot";
    price = 15000;
    illegal = false;
    side = "adac";
};
class adacCar {
    variable = "adacCar";
    displayName = "STR_License_Abschleppen";
    price = 10000;
    illegal = false;
    side = "adac";
};

class adac_air_hs {
    side = "adac";
    vehicles[] = {
        { "B_Heli_Transport_03_unarmed_F", 75000, { "adacAir" }, { "", "", -1 } },
        { "I_Heli_light_03_unarmed_F", 60000, { "adacAir" }, { "", "", -1 } },
        { "O_Heli_Light_02_unarmed_F", 60000, { "adacAir" }, { "", "", -1 } }
    };
};
class adac_shop {
    side = "adac";
    vehicles[] = {
        { "C_Offroad_01_repair_F", 1500, { "" }, { "", "", -1 } },
        { "C_SUV_01_F", 2000, { "" }, { "", "", -1 } },
        { "B_Truck_01_mover_F", 25000, { "adacCar" }, { "", "", -1 } }
    };
};

class C_Offroad_01_repair_F {
    vItemSpace = 65;
    storageFee[] = { 0, 0, 0, 200 };
    garageSell[] = { 0, 0, 0, 500 };
    insurance = 2500;
    chopShop = 6250;
    textures[] = {
        { "ADAC", "adac", {
            "textures\adac_offroad.jpg"
        } }
    };
};
class B_Truck_01_mover_F {
    vItemSpace = 1000;
    storageFee[] = { 0, 0, 0, 2000 };
    garageSell[] = { 0, 0, 0, 5000 };
    insurance = 2500;
    chopShop = 50000;
    textures[] = {
        { "ADAC", "adac", {
            "textures\adac_hemtt.jpg"
        } }
    };
};
class I_Heli_light_03_unarmed_F {
    vItemSpace = 210;
    storageFee[] = { 55000, 0, 22000, 3000 };
    garageSell[] = { 72500, 0, 35000, 20000 };
    insurance = 2500;
    chopShop = 375000;
    textures[] = {
	{ "ADAC", "adac", {
            "textures\hellcat_adac.jpg"
        } }
    };
};
class B_Heli_Transport_03_unarmed_F {
    vItemSpace = 1000;
    storageFee[] = { 55000, 0, 22000, 3500 };
    garageSell[] = { 72500, 0, 35000, 25000 };
    insurance = 2500;
    chopShop = 400000;
    textures[] = {
        { "ADAC", "adac", {
            "textures\huron_pd1.jpg",
            "textures\huron_pd2.jpg"
        } }
    };
};

class O_Heli_Light_02_unarmed_F {
    vItemSpace = 210;
    storageFee[] = { 55000, 0, 22000, 3000 };
    garageSell[] = { 72500, 0, 35000, 20000 };
    insurance = 2500;
    chopShop = 375000;
    textures[] = {
        { "Black", "cop", {
            "\a3\air_f\Heli_Light_02\Data\heli_light_02_ext_co.paa"
        } },
        { "White / Blue", "civ", {
            "\a3\air_f\Heli_Light_02\Data\heli_light_02_ext_civilian_co.paa"
        } },
        { "Digi Green", "civ", {
          "\a3\air_f\Heli_Light_02\Data\heli_light_02_ext_indp_co.paa"
        } },
        { "Desert Digi", "reb", {
           "\a3\air_f\Heli_Light_02\Data\heli_light_02_ext_opfor_co.paa"
        } },
        { "EMS White", "med", {
            "#(argb,8,8,3)color(1,1,1,0.8)"
        } },
        { "ADAC", "adac", {
            "textures\adac_orca.jpg"
        } }
    };
};

class C_SUV_01_F {
    vItemSpace = 50;
    storageFee[] = { 1000, 0, 0, 500 };
    garageSell[] = { 15000, 7500, 0, 1000 };
    insurance = 2500;
    chopShop = 15000;
    textures[] = {
        { "Dark Red", "civ", {
            "\a3\soft_f_gamma\SUV_01\Data\suv_01_ext_co.paa"
        } },
        { "Silver", "civ", {
            "\a3\soft_f_gamma\SUV_01\Data\suv_01_ext_03_co.paa"
        } },
        { "Orange", "civ", {
            "\a3\soft_f_gamma\SUV_01\Data\suv_01_ext_04_co.paa"
        } },
        { "Police", "cop", {
            "\a3\soft_f_gamma\SUV_01\Data\suv_01_ext_02_co.paa"
        } },
        { "ADAC", "adac", {
            "textures\adac_suv.paa"
        } }
    };
};