SHARE
TWEET

Untitled

a guest Jun 19th, 2017 46 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- --------------------------------------------------------
  2. -- Hôte :                        127.0.0.1
  3. -- Version du serveur:           10.2.6-MariaDB - mariadb.org binary distribution
  4. -- SE du serveur:                Win64
  5. -- HeidiSQL Version:             9.4.0.5125
  6. -- --------------------------------------------------------
  7.  
  8. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  9. /*!40101 SET NAMES utf8 */;
  10. /*!50503 SET NAMES utf8mb4 */;
  11. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  12. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  13.  
  14.  
  15. -- Export de la structure de la base pour altislife
  16. CREATE DATABASE IF NOT EXISTS `altislife` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
  17. USE `altislife`;
  18.  
  19. -- Export de la structure de la table altislife. containers
  20. CREATE TABLE IF NOT EXISTS `containers` (
  21.   `id` int(11) NOT NULL AUTO_INCREMENT,
  22.   `pid` varchar(32) NOT NULL,
  23.   `classname` varchar(32) NOT NULL,
  24.   `pos` varchar(64) DEFAULT NULL,
  25.   `inventory` text NOT NULL,
  26.   `gear` text NOT NULL,
  27.   `dir` varchar(128) DEFAULT NULL,
  28.   `active` tinyint(1) NOT NULL DEFAULT 0,
  29.   `owned` tinyint(1) DEFAULT 0,
  30.   `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
  31.   PRIMARY KEY (`id`,`pid`)
  32. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
  33.  
  34. -- Export de données de la table altislife.containers : ~0 rows (environ)
  35. /*!40000 ALTER TABLE `containers` DISABLE KEYS */;
  36. /*!40000 ALTER TABLE `containers` ENABLE KEYS */;
  37.  
  38. -- Export de la structure de la procédure altislife. deleteDeadVehicles
  39. DELIMITER //
  40. CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteDeadVehicles`()
  41. BEGIN
  42.   DELETE FROM `vehicles` WHERE `alive` = 0;
  43. END//
  44. DELIMITER ;
  45.  
  46. -- Export de la structure de la procédure altislife. deleteOldContainers
  47. DELIMITER //
  48. CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldContainers`()
  49. BEGIN
  50.   DELETE FROM `containers` WHERE `owned` = 0;
  51. END//
  52. DELIMITER ;
  53.  
  54. -- Export de la structure de la procédure altislife. deleteOldGangs
  55. DELIMITER //
  56. CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldGangs`()
  57. BEGIN
  58.   DELETE FROM `gangs` WHERE `active` = 0;
  59. END//
  60. DELIMITER ;
  61.  
  62. -- Export de la structure de la procédure altislife. deleteOldHouses
  63. DELIMITER //
  64. CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldHouses`()
  65. BEGIN
  66.   DELETE FROM `houses` WHERE `owned` = 0;
  67. END//
  68. DELIMITER ;
  69.  
  70. -- Export de la structure de la table altislife. gangs
  71. CREATE TABLE IF NOT EXISTS `gangs` (
  72.   `id` int(11) NOT NULL AUTO_INCREMENT,
  73.   `owner` varchar(32) DEFAULT NULL,
  74.   `name` varchar(32) DEFAULT NULL,
  75.   `members` text DEFAULT NULL,
  76.   `maxmembers` int(3) DEFAULT 8,
  77.   `bank` int(100) DEFAULT 0,
  78.   `active` tinyint(1) DEFAULT 1,
  79.   `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
  80.   PRIMARY KEY (`id`),
  81.   UNIQUE KEY `name_UNIQUE` (`name`)
  82. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
  83.  
  84. -- Export de données de la table altislife.gangs : ~3 rows (environ)
  85. /*!40000 ALTER TABLE `gangs` DISABLE KEYS */;
  86. INSERT INTO `gangs` (`id`, `owner`, `name`, `members`, `maxmembers`, `bank`, `active`, `insert_time`) VALUES
  87.     (1, '76561198142330851', 'les chevals', '"[`76561198142330851`,`76561198123343789`]"', 8, 0, 1, '2017-06-12 17:59:24'),
  88.     (2, '76561198049856908', '100000', '"[`76561198049856908`]"', 8, 37999984, 1, '2017-06-14 23:33:22'),
  89.     (3, '76561198020911772', 'bbbbb', '"[`76561198020911772`]"', 8, 0, 1, '2017-06-17 19:13:32');
  90. /*!40000 ALTER TABLE `gangs` ENABLE KEYS */;
  91.  
  92. -- Export de la structure de la table altislife. houses
  93. CREATE TABLE IF NOT EXISTS `houses` (
  94.   `id` int(11) NOT NULL AUTO_INCREMENT,
  95.   `pid` varchar(32) NOT NULL,
  96.   `pos` varchar(64) DEFAULT NULL,
  97.   `owned` tinyint(1) DEFAULT 0,
  98.   `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
  99.   PRIMARY KEY (`id`,`pid`)
  100. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
  101.  
  102. -- Export de données de la table altislife.houses : ~0 rows (environ)
  103. /*!40000 ALTER TABLE `houses` DISABLE KEYS */;
  104. /*!40000 ALTER TABLE `houses` ENABLE KEYS */;
  105.  
  106. -- Export de la structure de la table altislife. players
  107. CREATE TABLE IF NOT EXISTS `players` (
  108.   `uid` int(12) NOT NULL AUTO_INCREMENT,
  109.   `name` varchar(32) NOT NULL,
  110.   `aliases` text NOT NULL,
  111.   `playerid` varchar(64) NOT NULL,
  112.   `cash` int(100) NOT NULL DEFAULT 0,
  113.   `bankacc` int(100) NOT NULL DEFAULT 0,
  114.   `coplevel` enum('0','1','2','3','4','5','6','7','8','9','10','11') NOT NULL DEFAULT '0',
  115.   `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
  116.   `civ_licenses` text NOT NULL,
  117.   `cop_licenses` text NOT NULL,
  118.   `med_licenses` text NOT NULL,
  119.   `civ_gear` text NOT NULL,
  120.   `cop_gear` text NOT NULL,
  121.   `med_gear` text NOT NULL,
  122.   `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
  123.   `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
  124.   `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
  125.   `arrested` tinyint(1) NOT NULL DEFAULT 0,
  126.   `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
  127.   `donorlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
  128.   `blacklist` tinyint(1) NOT NULL DEFAULT 0,
  129.   `civ_alive` tinyint(1) NOT NULL DEFAULT 0,
  130.   `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
  131.   `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
  132.   `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
  133.   `last_seen` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  134.   PRIMARY KEY (`uid`),
  135.   UNIQUE KEY `playerid` (`playerid`),
  136.   KEY `name` (`name`),
  137.   KEY `blacklist` (`blacklist`)
  138. ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4;
  139.  
  140. -- Export de données de la table altislife.players : ~12 rows (environ)
  141. /*!40000 ALTER TABLE `players` DISABLE KEYS */;
  142. INSERT INTO `players` (`uid`, `name`, `aliases`, `playerid`, `cash`, `bankacc`, `coplevel`, `mediclevel`, `civ_licenses`, `cop_licenses`, `med_licenses`, `civ_gear`, `cop_gear`, `med_gear`, `civ_stats`, `cop_stats`, `med_stats`, `arrested`, `adminlevel`, `donorlevel`, `blacklist`, `civ_alive`, `civ_position`, `playtime`, `insert_time`, `last_seen`) VALUES
  143.     (12, 'DoDo La Saumure', '"[`DoDo La Saumure`]"', '76561198001932507', 959819, 943999, '11', '0', '"[[`license_civ_driver`,1],[`license_civ_boat`,1],[`license_civ_pilot`,1],[`license_civ_trucking`,1],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,1],[`license_civ_tabac`,0],[`license_civ_oil`,0],[`license_civ_uranium`,1],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_patates`,1],[`license_civ_raisin`,1],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,1],[`license_civ_meth`,1]]"', '"[[`license_cop_cAir`,1],[`license_cop_cg`,1]]"', '"[[`license_med_mAir`,1]]"', '"[`U_IG_Guerilla2_3`,``,`B_Carryall_oli`,`G_Aviator`,`H_Cap_grn_BI`,[`ItemMap`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[[`pickaxe`,1]]]"', '"[`U_Rangemaster`,`V_Rangemaster_belt`,``,`G_Aviator`,`H_Cap_headphones`,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemRadio`],``,``,[`FirstAidKit`],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[`U_Rangemaster`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],[],[],[`FirstAidKit`,`FirstAidKit`],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[100,100,0]"', '"[100,100,0]"', '"[100,100,0]"', 0, '5', '0', 0, 0, '"[22154.5,14445.9,0.349533]"', '"[220,2,100]"', '2017-06-12 14:09:18', '2017-06-18 21:52:45'),
  144.     (13, 'Patrick Sampson', '"[`Patrick Sampson`]"', '76561198142330851', 985449, 998998976, '9', '0', '"[[`license_civ_driver`,1],[`license_civ_boat`,1],[`license_civ_pilot`,1],[`license_civ_trucking`,1],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,1],[`license_civ_tabac`,1],[`license_civ_oil`,0],[`license_civ_uranium`,0],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_patates`,0],[`license_civ_raisin`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,1],[`license_civ_meth`,0]]"', '"[[`license_cop_cAir`,1],[`license_cop_cg`,1]]"', '"[]"', '"[`U_C_Commoner1_1`,``,``,``,`H_Beret_gen_F`,[`ItemMap`,`ItemCompass`,`ItemWatch`],`srifle_EBR_DMS_F`,``,[],[`20Rnd_762x51_Mag`],[],[],[],[],[``,``,`optic_DMS`,``],[``,``,``,``],[[`waterBottle`,1],[`tbacon`,2]]]"', '"[`U_B_CombatUniform_mcam`,`V_TacVest_blk_POLICE`,``,`G_Aviator`,`H_Beret_blk_POLICE`,[`ItemMap`,`ItemCompass`,`ItemWatch`,`Rangefinder`],`arifle_SPAR_03_blk_F`,`hgun_P07_snds_F`,[],[`20Rnd_762x51_Mag`,`20Rnd_762x51_Mag`,`20Rnd_762x51_Mag`],[],[],[],[`20Rnd_762x51_Mag`,`20Rnd_762x51_Mag`,`20Rnd_762x51_Mag`,`20Rnd_762x51_Mag`,`20Rnd_762x51_Mag`,`20Rnd_762x51_Mag`,`20Rnd_762x51_Mag`,`20Rnd_762x51_Mag`,`16Rnd_9x21_Mag`],[`muzzle_snds_B`,``,`optic_Hamr`,`bipod_01_F_blk`],[`muzzle_snds_L`,``,``,``],[]]"', '"[]"', '"[100,100,0]"', '"[100,100,0]"', '"[100,100,0]"', 0, '5', '0', 0, 0, '"[14706.2,16437.2,0.0341187]"', '"[39,0,155]"', '2017-06-12 14:11:17', '2017-06-18 15:25:16'),
  145.     (14, 'Tyler Wolf', '"[`Tyler Wolf`]"', '76561198020911772', 406249, 939876480, '11', '0', '"[[`license_civ_driver`,1],[`license_civ_boat`,0],[`license_civ_pilot`,1],[`license_civ_trucking`,1],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_tabac`,0],[`license_civ_oil`,1],[`license_civ_uranium`,0],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_patates`,0],[`license_civ_raisin`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,0],[`license_civ_meth`,1]]"', '"[[`license_cop_cAir`,1],[`license_cop_cg`,0]]"', '"[[`license_med_mAir`,0]]"', '"[`U_C_Poloshirt_tricolour`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[`U_I_CombatUniform`,`V_PlateCarrier2_rgr_noflag_F`,``,``,`H_Beret_Colonel`,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[`16Rnd_9x21_Mag`],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[`U_Rangemaster`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],[],[],[`FirstAidKit`,`FirstAidKit`],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[100,90,0]"', '"[75,75,0.49232]"', '"[90,80,0]"', 0, '5', '0', 0, 0, '"[8580.7,25156.8,0.24868]"', '"[199,23,174]"', '2017-06-12 14:49:07', '2017-06-17 20:13:58'),
  146.     (15, 'James hary', '"[`James hary`]"', '76561198150518880', 0, 999945024, '9', '0', '"[[`license_civ_driver`,1],[`license_civ_boat`,1],[`license_civ_pilot`,1],[`license_civ_trucking`,1],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_tabac`,0],[`license_civ_oil`,0],[`license_civ_uranium`,0],[`license_civ_diamond`,0],[`license_civ_salt`,1],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_patates`,0],[`license_civ_raisin`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,0],[`license_civ_meth`,0]]"', '"[[`license_cop_cAir`,1],[`license_cop_cg`,1]]"', '"[]"', '"[`U_C_Poloshirt_stripped`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[`U_Rangemaster`,`V_Rangemaster_belt`,``,``,`H_Cap_headphones`,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemRadio`],``,``,[`FirstAidKit`],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[100,100,0]"', '"[100,100,0]"', '"[100,100,0]"', 0, '0', '0', 0, 0, '"[8578,25146.8,0.965248]"', '"[113,0,120]"', '2017-06-12 15:43:13', '2017-06-18 21:52:27'),
  147.     (16, 'Marc Dorcel', '"[`Marc Dorcel`]"', '76561198123343789', 0, 999000000, '9', '0', '"[[`license_civ_driver`,0],[`license_civ_boat`,0],[`license_civ_pilot`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_tabac`,0],[`license_civ_oil`,0],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,1]]"', '"[[`license_cop_cAir`,0],[`license_cop_cg`,0]]"', '"[]"', '"[`U_C_Poloshirt_stripped`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[`U_B_CombatUniform_mcam`,`V_TacVest_blk_POLICE`,``,`G_Balaclava_blk`,``,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemRadio`],``,``,[`FirstAidKit`],[`30Rnd_65x39_caseless_mag_Tracer`],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[100,100,0]"', '"[100,100,0]"', '"[100,100,0]"', 0, '5', '0', 0, 0, '"[3199.48,12893.4,0.118016]"', '"[27,0,18]"', '2017-06-12 17:46:25', '2017-06-18 22:00:50'),
  148.     (17, 'Brad Pitt', '"[`Brad Pitt`]"', '76561198049856908', 0, 1160497152, '5', '5', '"[[`license_civ_driver`,1],[`license_civ_boat`,1],[`license_civ_pilot`,1],[`license_civ_trucking`,1],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,1],[`license_civ_tabac`,0],[`license_civ_oil`,0],[`license_civ_uranium`,1],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_patates`,0],[`license_civ_raisin`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,0],[`license_civ_meth`,1]]"', '"[[`license_cop_cAir`,1],[`license_cop_cg`,1]]"', '"[[`license_med_mAir`,1]]"', '"[`U_C_HunterBody_grn`,``,`B_Carryall_cbr`,`G_Lady_Dark`,`H_Cap_grn_BI`,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemGPS`,`Binocular`],``,``,[`ItemMap`],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[[`pickaxe`,1],[`waterBottle`,4],[`rabbit`,4],[`toolkit`,1]]]"', '"[`U_Rangemaster`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,`hgun_P07_snds_F`,[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[],[],[],[],[``,``,``,``],[`muzzle_snds_L`,``,``,``],[]]"', '"[`U_Rangemaster`,``,`B_FieldPack_oli`,`G_Shades_Blue`,`H_Cap_blu`,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemRadio`],[],[],[`FirstAidKit`],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[[`waterBottle`,5],[`peach`,1],[`rabbit`,6],[`defibrillator`,1],[`toolkit`,1]]]"', '"[100,80,0]"', '"[100,100,0]"', '"[90,90,0]"', 0, '5', '0', 0, 0, '"[8578.13,25147.2,1.11986]"', '"[14,86,48]"', '2017-06-12 17:52:20', '2017-06-17 17:54:59'),
  149.     (18, 'Jules', '"[`Jules`]"', '76561198155030236', 999999999, 999999999, '0', '0', '"[]"', '"[[`license_cop_cAir`,0],[`license_cop_cg`,0]]"', '"[]"', '"[]"', '"[`U_Rangemaster`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,`hgun_P07_snds_F`,[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[],[],[],[],[``,``,``,``],[`muzzle_snds_L`,``,``,``],[]]"', '"[]"', '"[100,100,0]"', '"[100,100,0]"', '"[100,100,0]"', 0, '0', '0', 0, 0, '"[]"', '"[0,0,0]"', '2017-06-12 22:15:44', '2017-06-15 21:56:17'),
  150.     (19, 'Bernard Dupont', '"[`Bernard Dupont`]"', '76561198057871088', 999999999, 999999999, '0', '0', '"[]"', '"[]"', '"[]"', '"[`U_IG_Guerilla3_1`,``,`B_Carryall_oli`,``,`H_Cap_oli`,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemGPS`,`NVGoggles`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[[`pickaxe`,1],[`fuelFull`,1],[`waterBottle`,3],[`tbacon`,3],[`toolkit`,1]]]"', '"[]"', '"[]"', '"[100,100,0]"', '"[100,100,0]"', '"[100,100,0]"', 0, '0', '0', 0, 0, '"[3740.46,13268.1,0.00141525]"', '"[0,0,0]"', '2017-06-14 23:14:09', '2017-06-15 21:56:17'),
  151.     (20, 'Florian Philippot', '"[`Florian Philippot`]"', '76561198134884178', 0, 999997504, '0', '0', '"[[`license_civ_driver`,0],[`license_civ_boat`,0],[`license_civ_pilot`,0],[`license_civ_trucking`,1],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_tabac`,0],[`license_civ_oil`,0],[`license_civ_uranium`,0],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,1],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_patates`,0],[`license_civ_raisin`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,0],[`license_civ_meth`,0]]"', '"[]"', '"[]"', '"[`U_C_Poloshirt_redwhite`,``,`B_Carryall_cbr`,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[]"', '"[100,100,0]"', '"[100,100,0]"', '"[100,100,0]"', 0, '0', '0', 0, 0, '"[14717.3,16318.3,4.43621]"', '"[0,0,89]"', '2017-06-14 23:17:07', '2017-06-18 18:02:01'),
  152.     (21, 'Mickael Strange', '"[`Mickael Strange`]"', '76561198330137486', 0, 63054348, '0', '0', '"[[`license_civ_driver`,1],[`license_civ_boat`,1],[`license_civ_pilot`,1],[`license_civ_trucking`,1],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_tabac`,0],[`license_civ_oil`,0],[`license_civ_uranium`,1],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,1],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_patates`,0],[`license_civ_raisin`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,0],[`license_civ_meth`,0]]"', '"[]"', '"[]"', '"[`U_C_Driver_1_blue`,``,`B_Carryall_cbr`,`G_Shades_Black`,`H_Hat_brown`,[`ItemMap`,`ItemCompass`,`ItemWatch`,`NVGoggles`],``,``,[`ItemWatch`],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[]"', '"[100,100,1]"', '"[100,100,0]"', '"[100,100,0]"', 0, '5', '0', 0, 0, '"[0,0,185.97]"', '"[0,0,303]"', '2017-06-17 19:19:14', '2017-06-18 21:57:09'),
  153.     (22, '[ICA] Clément Over', '"[`[ICA] Clément Over`]"', '76561198256866491', 0, 13500, '0', '0', '"[[`license_civ_driver`,0],[`license_civ_boat`,0],[`license_civ_pilot`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_tabac`,0],[`license_civ_oil`,0],[`license_civ_uranium`,0],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_patates`,0],[`license_civ_raisin`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,0],[`license_civ_meth`,0]]"', '"[]"', '"[]"', '"[`U_C_Poloshirt_burgundy`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[]"', '"[100,90,0.723919]"', '"[100,100,0]"', '"[100,100,0]"', 0, '0', '0', 0, 0, '"[14617,16645.5,1.82023]"', '"[0,0,79]"', '2017-06-18 16:35:41', '2017-06-18 21:41:39'),
  154.     (23, 'Billy Mamene', '"[`Billy Mamene`]"', '76561198243640404', 0, 26500, '0', '0', '"[[`license_civ_driver`,0],[`license_civ_boat`,0],[`license_civ_pilot`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_tabac`,0],[`license_civ_oil`,0],[`license_civ_uranium`,0],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_patates`,0],[`license_civ_raisin`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,0],[`license_civ_meth`,0]]"', '"[]"', '"[]"', '"[`U_C_Poloshirt_burgundy`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[]"', '"[100,100,0]"', '"[100,100,0]"', '"[100,100,0]"', 0, '0', '0', 0, 0, '"[14634,16631.4,0.0222282]"', '"[0,0,42]"', '2017-06-18 17:44:59', '2017-06-18 18:32:07');
  155. /*!40000 ALTER TABLE `players` ENABLE KEYS */;
  156.  
  157. -- Export de la structure de la procédure altislife. resetLifeVehicles
  158. DELIMITER //
  159. CREATE DEFINER=`root`@`localhost` PROCEDURE `resetLifeVehicles`()
  160. BEGIN
  161.   UPDATE `vehicles` SET `active`= 0;
  162. END//
  163. DELIMITER ;
  164.  
  165. -- Export de la structure de la table altislife. vehicles
  166. CREATE TABLE IF NOT EXISTS `vehicles` (
  167.   `id` int(12) NOT NULL AUTO_INCREMENT,
  168.   `side` varchar(16) NOT NULL,
  169.   `classname` varchar(64) NOT NULL,
  170.   `type` varchar(16) NOT NULL,
  171.   `pid` varchar(32) NOT NULL,
  172.   `alive` tinyint(1) NOT NULL DEFAULT 1,
  173.   `blacklist` tinyint(1) NOT NULL DEFAULT 0,
  174.   `active` tinyint(1) NOT NULL DEFAULT 0,
  175.   `plate` int(20) NOT NULL,
  176.   `color` int(20) NOT NULL,
  177.   `inventory` text NOT NULL,
  178.   `gear` text NOT NULL,
  179.   `fuel` double NOT NULL DEFAULT 1,
  180.   `damage` varchar(256) NOT NULL,
  181.   `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
  182.   `insure` int(1) NOT NULL DEFAULT 0,
  183.   PRIMARY KEY (`id`),
  184.   KEY `side` (`side`),
  185.   KEY `pid` (`pid`),
  186.   KEY `type` (`type`)
  187. ) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8mb4;
  188.  
  189. -- Export de données de la table altislife.vehicles : ~83 rows (environ)
  190. /*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
  191. INSERT INTO `vehicles` (`id`, `side`, `classname`, `type`, `pid`, `alive`, `blacklist`, `active`, `plate`, `color`, `inventory`, `gear`, `fuel`, `damage`, `insert_time`, `insure`) VALUES
  192.     (2, 'cop', 'I_Heli_Transport_02_F', 'Air', '76561198001932507', 1, 0, 0, 944860, 1, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-12 14:43:06', 0),
  193.     (4, 'cop', 'I_MRAP_03_F', 'Car', '76561198001932507', 1, 0, 0, 851970, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-12 14:47:17', 0),
  194.     (6, 'cop', 'I_Heli_light_03_unarmed_F', 'Air', '76561198001932507', 1, 0, 0, 307718, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-12 14:51:47', 0),
  195.     (7, 'cop', 'C_Offroad_02_unarmed_F', 'Car', '76561198001932507', 1, 0, 0, 910512, 1, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-12 17:22:24', 0),
  196.     (9, 'cop', 'I_MRAP_03_hmg_F', 'Car', '76561198001932507', 1, 0, 0, 650463, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-12 17:29:26', 0),
  197.     (10, 'cop', 'C_Offroad_02_unarmed_F', 'Car', '76561198020911772', 1, 0, 0, 713080, 1, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-12 17:37:13', 0),
  198.     (11, 'cop', 'I_MRAP_03_F', 'Car', '76561198020911772', 1, 0, 0, 478924, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-12 17:38:37', 0),
  199.     (13, 'civ', 'O_LSV_02_unarmed_F', 'Car', '76561198142330851', 1, 0, 0, 287668, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-12 17:40:56', 0),
  200.     (14, 'civ', 'B_G_Offroad_01_F', 'Car', '76561198142330851', 1, 0, 0, 574991, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-12 17:41:15', 0),
  201.     (15, 'civ', 'O_Heli_Transport_04_covered_F', 'Air', '76561198142330851', 1, 0, 0, 331237, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-12 17:42:19', 1),
  202.     (16, 'med', 'C_Van_01_box_F', 'Car', '76561198049856908', 1, 0, 0, 775886, 2, '"[[],0]"', '"[]"', 0.996092, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-12 19:09:25', 0),
  203.     (20, 'med', 'C_Van_01_box_F', 'Car', '76561198049856908', 1, 0, 0, 833442, 2, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-12 22:05:02', 0),
  204.     (21, 'civ', 'B_G_Offroad_01_F', 'Car', '76561198142330851', 1, 0, 0, 2554, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-12 22:05:24', 0),
  205.     (22, 'civ', 'B_G_Offroad_01_F', 'Car', '76561198142330851', 1, 0, 0, 358217, 0, '"[[],0]"', '"[]"', 0.988748, '"[]"', '2017-06-12 22:05:42', 1),
  206.     (24, 'med', 'C_Van_01_box_F', 'Car', '76561198049856908', 1, 0, 0, 444289, 2, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-12 22:42:26', 0),
  207.     (30, 'civ', 'B_Quadbike_01_F', 'Car', '76561198001932507', 1, 0, 0, 143350, 3, '"[[],0]"', '"[]"', 0.9994, '"[]"', '2017-06-13 19:36:54', 1),
  208.     (31, 'civ', 'C_Offroad_02_unarmed_F', 'Car', '76561198001932507', 1, 0, 0, 335313, 7, '"[[],0]"', '"[]"', 0.999853, '"[]"', '2017-06-13 19:40:29', 0),
  209.     (32, 'med', 'C_Heli_Light_01_civil_F', 'Air', '76561198001932507', 1, 0, 0, 945321, 14, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-13 23:17:16', 0),
  210.     (33, 'med', 'C_Heli_Light_01_civil_F', 'Air', '76561198049856908', 1, 0, 0, 946623, 14, '"[[],0]"', '"[]"', 0.999937, '"[]"', '2017-06-14 23:15:28', 0),
  211.     (34, 'med', 'C_Heli_Light_01_civil_F', 'Air', '76561198049856908', 1, 0, 0, 773645, 14, '"[[],0]"', '"[]"', 0.999943, '"[]"', '2017-06-14 23:18:28', 0),
  212.     (35, 'med', 'C_Van_01_box_F', 'Car', '76561198049856908', 1, 0, 0, 240706, 2, '"[[],0]"', '"[]"', 0.999796, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-14 23:19:06', 0),
  213.     (36, 'civ', 'B_Truck_01_box_F', 'Car', '76561198001932507', 1, 0, 0, 85453, 0, '"[[],0]"', '"[]"', 0.951856, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-14 23:21:55', 0),
  214.     (37, 'civ', 'B_Truck_01_box_F', 'Car', '76561198150518880', 1, 0, 0, 871895, 0, '"[[],0]"', '"[]"', 0.786302, '"[]"', '2017-06-14 23:22:31', 0),
  215.     (38, 'civ', 'B_Truck_01_box_F', 'Car', '76561198134884178', 1, 0, 0, 592286, 0, '"[[],0]"', '"[]"', 0.985278, '"[]"', '2017-06-14 23:22:51', 0),
  216.     (39, 'civ', 'B_Truck_01_box_F', 'Car', '76561198057871088', 1, 0, 0, 743761, 0, '"[[],0]"', '"[]"', 0.976178, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-14 23:23:18', 0),
  217.     (40, 'med', 'C_Heli_Light_01_civil_F', 'Air', '76561198049856908', 1, 0, 0, 479334, 14, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-14 23:23:25', 0),
  218.     (41, 'med', 'O_Heli_Light_02_unarmed_F', 'Air', '76561198049856908', 1, 0, 0, 999953, 4, '"[[],0]"', '"[]"', 1, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-14 23:24:41', 0),
  219.     (42, 'med', 'C_Van_01_box_F', 'Car', '76561198049856908', 1, 0, 0, 253314, 2, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-14 23:24:56', 0),
  220.     (43, 'civ', 'B_Truck_01_box_F', 'Car', '76561198020911772', 1, 0, 0, 370775, 0, '"[[],0]"', '"[]"', 0.999645, '"[]"', '2017-06-14 23:25:57', 0),
  221.     (44, 'civ', 'B_Truck_01_box_F', 'Car', '76561198020911772', 1, 0, 0, 692141, 0, '"[[],0]"', '"[]"', 0.90135, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-14 23:37:52', 1),
  222.     (45, 'civ', 'B_G_Offroad_01_F', 'Car', '76561198142330851', 1, 0, 0, 524089, 0, '"[[],0]"', '"[]"', 0.997414, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-15 00:00:41', 0),
  223.     (46, 'civ', 'B_Heli_Light_01_F', 'Air', '76561198001932507', 1, 0, 0, 509226, 9, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-15 00:03:45', 0),
  224.     (47, 'civ', 'C_Plane_Civil_01_racing_F', 'Air', '76561198001932507', 1, 0, 0, 118691, 0, '"[[],0]"', '"[]"', 0.865952, '"[]"', '2017-06-15 00:03:49', 0),
  225.     (48, 'civ', 'C_Plane_Civil_01_racing_F', 'Air', '76561198001932507', 1, 0, 0, 390962, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-15 00:05:40', 0),
  226.     (49, 'civ', 'C_Plane_Civil_01_racing_F', 'Air', '76561198142330851', 1, 0, 0, 828803, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-15 00:06:03', 0),
  227.     (50, 'civ', 'B_Heli_Light_01_F', 'Air', '76561198020911772', 1, 0, 0, 749392, 1, '"[[],0]"', '"[]"', 0, '"[]"', '2017-06-15 02:29:49', 0),
  228.     (51, 'med', 'C_Heli_Light_01_civil_F', 'Air', '76561198049856908', 1, 0, 0, 847833, 14, '"[[],0]"', '"[]"', 0.999936, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-15 23:53:28', 0),
  229.     (52, 'med', 'C_Heli_Light_01_civil_F', 'Air', '76561198049856908', 1, 0, 0, 389841, 14, '"[[],0]"', '"[]"', 1, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-15 23:55:55', 0),
  230.     (53, 'civ', 'C_SUV_01_F', 'Car', '76561198049856908', 1, 0, 0, 672165, 2, '"[[],0]"', '"[]"', 1, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-15 23:58:09', 0),
  231.     (54, 'civ', 'C_Rubberboat', 'Ship', '76561198142330851', 1, 0, 0, 994645, 0, '"[[],0]"', '"[]"', 0.970406, '"[]"', '2017-06-17 13:32:10', 0),
  232.     (55, 'civ', 'C_Van_01_transport_F', 'Car', '76561198049856908', 1, 0, 0, 677908, 0, '"[[],0]"', '"[]"', 0.996796, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-17 14:07:39', 0),
  233.     (56, 'civ', 'C_Boat_Civil_01_F', 'Ship', '76561198049856908', 1, 0, 0, 197201, 0, '"[[],0]"', '"[]"', 1, '"[0,0,0,0]"', '2017-06-17 14:14:20', 0),
  234.     (57, 'civ', 'B_SDV_01_F', 'Ship', '76561198049856908', 1, 0, 0, 638634, 0, '"[[],0]"', '"[]"', 0.959549, '"[]"', '2017-06-17 14:14:29', 0),
  235.     (58, 'med', 'C_Van_01_box_F', 'Car', '76561198020911772', 1, 0, 0, 944967, 2, '"[[],0]"', '"[]"', 1, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-17 17:27:42', 0),
  236.     (59, 'med', 'C_Heli_Light_01_civil_F', 'Air', '76561198049856908', 1, 0, 0, 760527, 14, '"[[],0]"', '"[]"', 0.902935, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-17 17:29:27', 0),
  237.     (60, 'cop', 'C_Plane_Civil_01_racing_F', 'Air', '76561198001932507', 1, 0, 0, 403105, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-17 19:14:06', 0),
  238.     (61, 'cop', 'C_Offroad_02_unarmed_F', 'Car', '76561198020911772', 1, 0, 0, 45843, 1, '"[[],0]"', '"[]"', 0.999478, '"[]"', '2017-06-17 19:46:00', 0),
  239.     (62, 'cop', 'C_Hatchback_01_sport_F', 'Car', '76561198020911772', 1, 0, 0, 213395, 6, '"[[],0]"', '"[]"', 0.999185, '"[]"', '2017-06-17 19:47:12', 0),
  240.     (63, 'cop', 'I_MRAP_03_F', 'Car', '76561198020911772', 1, 0, 0, 135793, 0, '"[[],0]"', '"[]"', 0.999874, '"[]"', '2017-06-17 19:47:48', 0),
  241.     (64, 'cop', 'B_T_LSV_01_unarmed_F', 'Car', '76561198020911772', 1, 0, 0, 543435, 1, '"[[],0]"', '"[]"', 0.99508, '"[]"', '2017-06-17 19:48:16', 0),
  242.     (65, 'cop', 'B_T_LSV_01_unarmed_F', 'Car', '76561198020911772', 1, 0, 0, 541954, 0, '"[[],0]"', '"[]"', 1, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-17 19:49:09', 0),
  243.     (66, 'cop', 'C_Offroad_02_unarmed_F', 'Car', '76561198020911772', 1, 0, 0, 65107, 0, '"[[],0]"', '"[]"', 1, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-17 19:49:54', 0),
  244.     (67, 'cop', 'C_Offroad_01_F', 'Car', '76561198020911772', 1, 0, 0, 529546, 7, '"[[],0]"', '"[]"', 1, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-17 19:52:42', 0),
  245.     (68, 'cop', 'C_SUV_01_F', 'Car', '76561198020911772', 1, 0, 0, 826379, 3, '"[[],0]"', '"[]"', 1, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-17 19:53:02', 0),
  246.     (69, 'cop', 'B_MRAP_01_F', 'Car', '76561198020911772', 1, 0, 0, 504926, 0, '"[[],0]"', '"[]"', 1, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-17 19:53:42', 0),
  247.     (70, 'cop', 'B_Heli_Light_01_F', 'Air', '76561198020911772', 1, 0, 0, 921221, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-17 19:54:52', 0),
  248.     (71, 'cop', 'B_Heli_Light_01_F', 'Air', '76561198020911772', 1, 0, 0, 911434, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-17 19:55:59', 0),
  249.     (72, 'cop', 'I_Heli_light_03_unarmed_F', 'Air', '76561198020911772', 1, 0, 0, 863978, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-17 19:56:12', 0),
  250.     (73, 'cop', 'B_Heli_Light_01_F', 'Air', '76561198020911772', 1, 0, 0, 392604, 0, '"[[],0]"', '"[]"', 0.992929, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-17 19:57:21', 0),
  251.     (74, 'cop', 'I_Heli_light_03_unarmed_F', 'Air', '76561198020911772', 1, 0, 0, 813281, 1, '"[[],0]"', '"[]"', 0.992074, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.279528,0,0]"', '2017-06-17 19:59:24', 0),
  252.     (75, 'cop', 'I_Heli_Transport_02_F', 'Air', '76561198020911772', 1, 0, 0, 212806, 1, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-17 20:03:39', 0),
  253.     (76, 'civ', 'C_SUV_01_F', 'Car', '76561198330137486', 1, 0, 0, 964342, 0, '"[[],0]"', '"[]"', 0.926185, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-17 20:55:29', 1),
  254.     (77, 'civ', 'C_Boat_Civil_01_F', 'Ship', '76561198330137486', 1, 0, 0, 352804, 0, '"[[],0]"', '"[]"', 0.994882, '"[]"', '2017-06-17 20:58:42', 0),
  255.     (78, 'civ', 'I_Truck_02_transport_F', 'Car', '76561198330137486', 1, 0, 0, 900980, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-17 21:20:03', 1),
  256.     (79, 'civ', 'C_SUV_01_F', 'Car', '76561198330137486', 1, 0, 0, 731046, 2, '"[[],0]"', '"[]"', 0.967313, '"[0.374016,0,0.374016,0.011811,0,0,0.019685,0,0.011811,0,0,0,0,0,0.0354331,0,0,0,0,0,0.177165,0.177165]"', '2017-06-17 22:58:35', 1),
  257.     (80, 'civ', 'C_Rubberboat', 'Ship', '76561198330137486', 1, 0, 0, 207272, 0, '"[[],0]"', '"[]"', 1, '"[0,0,0,0,0,0,0,0,0,0]"', '2017-06-17 23:12:01', 0),
  258.     (81, 'civ', 'C_Hatchback_01_sport_F', 'Car', '76561198330137486', 1, 0, 0, 370453, 5, '"[[],0]"', '"[]"', 0.972284, '"[]"', '2017-06-18 11:59:36', 1),
  259.     (82, 'civ', 'C_Kart_01_Blu_F', 'Car', '76561198330137486', 1, 0, 0, 349565, 0, '"[[],0]"', '"[]"', 0.995218, '"[]"', '2017-06-18 12:11:12', 0),
  260.     (83, 'civ', 'C_Heli_Light_01_civil_F', 'Air', '76561198330137486', 1, 0, 0, 38816, 11, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-18 12:28:35', 0),
  261.     (84, 'civ', 'I_C_Boat_Transport_02_F', 'Ship', '76561198001932507', 1, 0, 0, 46452, 0, '"[[],0]"', '"[]"', 0.997918, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-18 12:29:53', 0),
  262.     (85, 'civ', 'C_Rubberboat', 'Ship', '76561198001932507', 1, 0, 0, 592340, 0, '"[[],0]"', '"[]"', 1, '"[0,0,0,0,0,0,0,0,0,0]"', '2017-06-18 12:34:27', 0),
  263.     (86, 'civ', 'C_Boat_Civil_01_F', 'Ship', '76561198001932507', 1, 0, 0, 849383, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-18 12:34:44', 0),
  264.     (87, 'civ', 'C_Rubberboat', 'Ship', '76561198001932507', 1, 0, 0, 833224, 0, '"[[],0]"', '"[]"', 1, '"[0,0,0,0,0,0,0,0,0,0]"', '2017-06-18 12:42:18', 0),
  265.     (88, 'civ', 'C_SUV_01_F', 'Car', '76561198330137486', 1, 0, 0, 269780, 1, '"[[],0]"', '"[]"', 0.930607, '"[0.574803,0.011811,0.574803,0.011811,0,0.011811,0.019685,0,0.011811,0,0,0,0,0,0.0551181,0,0,0,0,0,0.267717,0.267717]"', '2017-06-18 19:03:33', 0),
  266.     (89, 'civ', 'C_Van_01_fuel_F', 'Car', '76561198330137486', 1, 0, 0, 666181, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-18 19:14:53', 0),
  267.     (91, 'civ', 'O_Heli_Light_02_unarmed_F', 'Air', '76561198330137486', 1, 0, 0, 129836, 2, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-18 19:32:59', 0),
  268.     (92, 'cop', 'B_T_VTOL_01_vehicle_F', 'Air', '76561198001932507', 1, 0, 0, 547572, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-18 20:06:18', 0),
  269.     (93, 'cop', 'C_Offroad_01_F', 'Car', '76561198123343789', 1, 0, 0, 910290, 7, '"[[],0]"', '"[]"', 1, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2017-06-18 21:51:59', 0),
  270.     (94, 'cop', 'C_SUV_01_F', 'Car', '76561198123343789', 1, 0, 0, 279709, 3, '"[[],0]"', '"[]"', 1, '"[0,1,0,1,0.645669,0.0669291,0,0,0,0,0,0,0,0,1,0,0,0,0,0.480315,0,0.023622]"', '2017-06-18 21:52:24', 0),
  271.     (95, 'cop', 'C_SUV_01_F', 'Car', '76561198001932507', 1, 0, 0, 347960, 3, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-18 21:52:45', 0),
  272.     (96, 'cop', 'C_Hatchback_01_sport_F', 'Car', '76561198123343789', 1, 0, 0, 382905, 6, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-18 21:53:13', 0),
  273.     (97, 'cop', 'B_MRAP_01_F', 'Car', '76561198123343789', 1, 0, 0, 63376, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-18 21:55:11', 0),
  274.     (98, 'cop', 'B_T_LSV_01_unarmed_F', 'Car', '76561198123343789', 1, 0, 0, 202767, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2017-06-18 22:00:18', 0);
  275. /*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
  276.  
  277. -- Export de la structure de la table altislife. wanted
  278. CREATE TABLE IF NOT EXISTS `wanted` (
  279.   `wantedID` varchar(64) NOT NULL,
  280.   `wantedName` varchar(32) NOT NULL,
  281.   `wantedCrimes` text NOT NULL,
  282.   `wantedBounty` int(100) NOT NULL,
  283.   `active` tinyint(1) NOT NULL DEFAULT 0,
  284.   `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
  285.   PRIMARY KEY (`wantedID`)
  286. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  287.  
  288. -- Export de données de la table altislife.wanted : ~4 rows (environ)
  289. /*!40000 ALTER TABLE `wanted` DISABLE KEYS */;
  290. INSERT INTO `wanted` (`wantedID`, `wantedName`, `wantedCrimes`, `wantedBounty`, `active`, `insert_time`) VALUES
  291.     ('76561198001932507', 'DoDo La Saumure', '"[`187`]"', 2000, 1, '2017-06-15 00:49:52'),
  292.     ('76561198123343789', 'Marc Dorcel', '"[`187`,`187`,`187`,`187`,`187`]"', 10000, 1, '2017-06-12 18:11:54'),
  293.     ('76561198142330851', 'Patrick Sampson', '"[`187`,`187`,`187`,`187`,`187`]"', 10000, 1, '2017-06-12 14:54:38'),
  294.     ('76561198256866491', '[ICA] Clément Over', '"[`187`,`187`,`187`]"', 6000, 1, '2017-06-18 17:55:24');
  295. /*!40000 ALTER TABLE `wanted` ENABLE KEYS */;
  296.  
  297. /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  298. /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  299. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
RAW Paste Data
Pastebin PRO Autumn Special!
Get 40% OFF on Pastebin PRO accounts!
Top