· 8 years ago · Jun 29, 2018, 02:40 PM
1-- phpMyAdmin SQL Dump
2-- version 4.2.1
3-- http://www.phpmyadmin.net
4--
5-- Anamakine: localhost
6-- Üretim Zamanı: 09 Nis 2016, 21:53:27
7-- Sunucu sürümü: 5.6.29
8-- PHP Sürümü: 5.4.16
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Veritabanı: `altislife`
21--
22
23DELIMITER $$
24--
25-- Yordamlar
26--
27CREATE DEFINER=`altislife`@`localhost` PROCEDURE `deleteDeadVehicles`()
28BEGIN
29 DELETE FROM `vehicles` WHERE `alive` = 0;
30END$$
31
32CREATE DEFINER=`altislife`@`localhost` PROCEDURE `deleteOldGangs`()
33BEGIN
34 DELETE FROM `gangs` WHERE `active` = 0;
35END$$
36
37CREATE DEFINER=`altislife`@`localhost` PROCEDURE `deleteOldHouses`()
38BEGIN
39 DELETE FROM `houses` WHERE `owned` = 0;
40END$$
41
42CREATE DEFINER=`altislife`@`localhost` PROCEDURE `resetLifeVehicles`()
43BEGIN
44 UPDATE `vehicles` SET `active`= 0;
45END$$
46
47DELIMITER ;
48
49-- --------------------------------------------------------
50
51--
52-- Tablo için tablo yapısı `ah`
53--
54
55CREATE TABLE IF NOT EXISTS `ah` (
56`id` int(11) NOT NULL,
57 `type` int(5) NOT NULL DEFAULT '0',
58 `amount` int(5) NOT NULL DEFAULT '0',
59 `item` text NOT NULL,
60 `price` int(100) NOT NULL DEFAULT '0',
61 `seller` varchar(50) NOT NULL,
62 `sellername` varchar(32) NOT NULL,
63 `status` int(5) NOT NULL DEFAULT '0',
64 `time` int(11) NOT NULL DEFAULT '0'
65) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
66
67-- --------------------------------------------------------
68
69--
70-- Tablo için tablo yapısı `containers`
71--
72
73CREATE TABLE IF NOT EXISTS `containers` (
74`id` int(11) NOT NULL,
75 `pid` varchar(32) NOT NULL,
76 `classname` varchar(32) NOT NULL,
77 `pos` varchar(64) DEFAULT NULL,
78 `inventory` varchar(500) NOT NULL,
79 `gear` text NOT NULL,
80 `dir` varchar(64) DEFAULT NULL,
81 `active` tinyint(1) NOT NULL DEFAULT '0',
82 `owned` tinyint(4) DEFAULT '0'
83) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
84
85-- --------------------------------------------------------
86
87--
88-- Tablo için tablo yapısı `dynmarket`
89--
90
91CREATE TABLE IF NOT EXISTS `dynmarket` (
92 `id` int(11) NOT NULL DEFAULT '1',
93 `prices` text NOT NULL
94) ENGINE=InnoDB DEFAULT CHARSET=latin1;
95
96--
97-- Tablo döküm verisi `dynmarket`
98--
99
100INSERT INTO `dynmarket` (`id`, `prices`) VALUES
101(1, '[]');
102
103-- --------------------------------------------------------
104
105--
106-- Tablo için tablo yapısı `gangs`
107--
108
109CREATE TABLE IF NOT EXISTS `gangs` (
110`id` int(11) NOT NULL,
111 `owner` varchar(32) DEFAULT NULL,
112 `name` varchar(32) DEFAULT NULL,
113 `members` text,
114 `maxmembers` int(2) DEFAULT '8',
115 `bank` int(100) DEFAULT '0',
116 `active` tinyint(4) DEFAULT '1'
117) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
118
119--
120-- Tablo döküm verisi `gangs`
121--
122
123INSERT INTO `gangs` (`id`, `owner`, `name`, `members`, `maxmembers`, `bank`, `active`) VALUES
124(1, '76561198092166375', 'Nerf Rebels', '"[`76561198092166375`,`76561198136057409`,`76561198114150840`,`76561198117736514`]"', 8, 0, 1),
125(2, '76561198082425178', 'NR', '"[`76561198082425178`,`76561198110762458`,`76561198129540403`,`76561198256076697`,`76561198018396241`]"', 8, 0, 1);
126
127-- --------------------------------------------------------
128
129--
130-- Tablo için tablo yapısı `houses`
131--
132
133CREATE TABLE IF NOT EXISTS `houses` (
134`id` int(11) NOT NULL,
135 `pid` varchar(32) NOT NULL,
136 `pos` varchar(64) DEFAULT NULL,
137 `owned` tinyint(4) DEFAULT '0'
138) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
139
140-- --------------------------------------------------------
141
142--
143-- Tablo için tablo yapısı `players`
144--
145
146CREATE TABLE IF NOT EXISTS `players` (
147`uid` int(12) NOT NULL,
148 `name` varchar(32) NOT NULL,
149 `aliases` text NOT NULL,
150 `playerid` varchar(50) NOT NULL,
151 `cash` int(100) NOT NULL DEFAULT '0',
152 `bankacc` int(100) NOT NULL DEFAULT '0',
153 `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
154 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
155 `civ_licenses` text NOT NULL,
156 `cop_licenses` text NOT NULL,
157 `med_licenses` text NOT NULL,
158 `civ_gear` text NOT NULL,
159 `cop_gear` text NOT NULL,
160 `med_gear` text NOT NULL,
161 `civ_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
162 `cop_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
163 `med_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
164 `arrested` tinyint(1) NOT NULL DEFAULT '0',
165 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
166 `donatorlvl` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
167 `blacklist` tinyint(1) NOT NULL DEFAULT '0'
168) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=115 ;
169
170--
171-- Tablo döküm verisi `players`
172--
173
174INSERT 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`, `donatorlvl`, `blacklist`) VALUES
175(87, 'ByWolkaN', '"[`ByWolkaN`]"', '76561198066077165', 1499997, 2550003, '6', '0', '"[[`license_civ_driver`,1],[`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_bagisci`,1],[`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`,0]]"', '"[[`license_cop_cAir`,0],[`license_cop_cg`,0]]"', '"[]"', '"[`U_C_Poloshirt_stripped`,``,``,`G_Aviator`,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[`U_Rangemaster`,`V_Rangemaster_belt`,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemGPS`],``,`hgun_P07_snds_F`,[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[],[],[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[``,``,``,``],[`muzzle_snds_L`,``,``,``],[]]"', '"[]"', '"[100,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
176(88, '[E.Amiri]O?uz G.', '"[`O?uz Kalix G.`]"', '76561198092166375', 0, 7854943, '6', '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_bagisci`,1],[`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`,0]]"', '"[[`license_cop_cAir`,1],[`license_cop_cg`,0]]"', '"[]"', '"[`U_C_Poloshirt_tricolour`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[`U_Rangemaster`,`V_Rangemaster_belt`,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemGPS`],``,`hgun_P07_snds_F`,[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[],[],[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[``,``,``,``],[`muzzle_snds_L`,``,``,``],[]]"', '"[]"', '"[90,90]"', '"[100,90]"', '"[100,100]"', 0, '0', '0', 0),
177(89, 'LAISERG', '"[`LAISERG`]"', '76561198136057409', 0, 468200, '3', '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_bagisci`,1],[`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`,0]]"', '"[[`license_cop_cAir`,0],[`license_cop_cg`,0]]"', '"[]"', '"[`U_C_Poloshirt_burgundy`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[`U_Rangemaster`,`V_Rangemaster_belt`,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemGPS`],``,`hgun_P07_snds_F`,[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[],[],[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[``,``,``,``],[`muzzle_snds_L`,``,``,``],[]]"', '"[]"', '"[90,90]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
178(90, '[Komiser] Efe', '"[`[Komiser] Efe`]"', '76561198145364070', 0, 375875, '4', '0', '"[[`license_civ_driver`,1],[`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_bagisci`,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`,0]]"', '"[[`license_cop_cAir`,0],[`license_cop_cg`,0]]"', '"[]"', '"[`U_C_Poloshirt_salmon`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[`U_Rangemaster`,`V_Rangemaster_belt`,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemGPS`],``,`hgun_P07_snds_F`,[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[],[],[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[``,``,``,``],[`muzzle_snds_L`,``,``,``],[]]"', '"[]"', '"[100,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
179(91, '[K?d.Polis] ZeroKnight', '"[`[AM] ZeroKnight`]"', '76561198085218272', 0, 292782, '3', '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_bagisci`,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`,0]]"', '"[[`license_cop_cAir`,1],[`license_cop_cg`,1]]"', '"[]"', '"[`U_C_Poloshirt_stripped`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[`U_Rangemaster`,`V_Rangemaster_belt`,``,`G_Squares`,``,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemGPS`],``,`hgun_P07_snds_F`,[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[],[],[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[``,``,``,``],[`muzzle_snds_L`,``,``,``],[]]"', '"[]"', '"[100,100]"', '"[90,90]"', '"[100,100]"', 0, '0', '0', 0),
180(92, 'DADAS', '"[`DADAS`]"', '76561198073435815', 19940, 550000, '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_bagisci`,1],[`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`,0]]"', '"[]"', '"[]"', '"[`U_I_CombatUniform_tshirt`,`V_TacVest_camo`,`B_Carryall_oli`,`G_Balaclava_oli`,`H_Bandanna_khk`,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemGPS`,`NVGoggles_OPFOR`],`arifle_MX_F`,``,[],[`30Rnd_65x39_caseless_mag`,`30Rnd_65x39_caseless_mag`,`30Rnd_65x39_caseless_mag`],[`ToolKit`],[],[`FirstAidKit`,`FirstAidKit`,`FirstAidKit`],[`30Rnd_65x39_caseless_mag`,`30Rnd_65x39_caseless_mag`,`30Rnd_65x39_caseless_mag`,`30Rnd_65x39_caseless_mag`,`30Rnd_65x39_caseless_mag`],[`muzzle_snds_H`,``,`optic_Arco`,`bipod_01_F_snd`],[``,``,``,``],[]]"', '"[]"', '"[]"', '"[100,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
181(93, 'Avienox', '"[`[Komiser Yrd.]Berker`]"', '76561198129540403', 0, 1224497, '4', '0', '"[[`license_civ_driver`,1],[`license_civ_boat`,0],[`license_civ_pilot`,1],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_bagisci`,1],[`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`,0]]"', '"[[`license_cop_cAir`,1],[`license_cop_cg`,1]]"', '"[]"', '"[`U_C_Poloshirt_blue`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[`U_Rangemaster`,`V_Rangemaster_belt`,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemGPS`],``,`hgun_P07_snds_F`,[],[],[],[],[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[``,``,``,``],[`muzzle_snds_L`,``,``,``],[]]"', '"[]"', '"[40,10]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
182(94, '[DM]FBS', '"[`[DM]FBS`]"', '76561198194350967', 0, 750000, '0', '0', '"[]"', '"[]"', '"[]"', '"[]"', '"[]"', '"[]"', '"[100,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
183(95, 'smok', '"[`[Komiser]Murat`]"', '76561198018396241', 0, 39979476, '4', '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_bagisci`,1],[`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`,0]]"', '"[[`license_cop_cAir`,0],[`license_cop_cg`,0]]"', '"[]"', '"[`U_C_Commoner1_1`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[`U_Rangemaster`,`V_Rangemaster_belt`,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemGPS`],``,`hgun_P07_snds_F`,[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[],[],[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[``,``,``,``],[`muzzle_snds_L`,``,``,``],[]]"', '"[]"', '"[100,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
184(96, '[NR] Izzetul Mubarak', '"[`[NR] Izzetul Mubarak`]"', '76561198082425178', 113980, 1409000, '5', '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_bagisci`,1],[`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`,0]]"', '"[[`license_cop_cAir`,0],[`license_cop_cg`,0]]"', '"[]"', '"[`U_B_CombatUniform_mcam_vest`,`V_PlateCarrier1_rgr`,`B_Kitbag_mcamo`,`G_Bandanna_beast`,`H_Booniehat_khk_hs`,[`ItemMap`,`ItemCompass`,`ItemWatch`,`NVGoggles_OPFOR`,`Rangefinder`],`srifle_DMR_03_multicam_F`,``,[`optic_LRPS`],[`20Rnd_762x51_Mag`],[`ToolKit`],[`20Rnd_762x51_Mag`,`20Rnd_762x51_Mag`,`20Rnd_762x51_Mag`],[`FirstAidKit`],[`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`],[`muzzle_snds_B`,`acc_flashlight`,`optic_MRCO`,`bipod_01_F_blk`],[``,``,``,``],[[`lockpick`,5],[`redgull`,17],[`rabbit`,5]]]"', '"[`U_Rangemaster`,`V_Rangemaster_belt`,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemGPS`],`SMG_01_Holo_pointer_snds_F`,`hgun_P07_snds_F`,[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[],[],[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`30Rnd_45ACP_Mag_SMG_01`],[`muzzle_snds_acp`,``,`optic_Holosight_smg`,``],[`muzzle_snds_L`,``,``,``],[]]"', '"[]"', '"[100,100]"', '"[90,100]"', '"[100,100]"', 0, '0', '0', 0),
185(97, '[WA] Ahmet', '"[`[WA] Ahmet`]"', '76561198162010964', 0, 750000, '0', '0', '"[]"', '"[]"', '"[]"', '"[]"', '"[]"', '"[]"', '"[100,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
186(98, '[K?d.Pol]Müge Banl?', '"[`[K?d.Pol]Cisco`]"', '76561198097560681', 0, 2508799, '3', '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_bagisci`,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`,0]]"', '"[[`license_cop_cAir`,1],[`license_cop_cg`,1]]"', '"[]"', '"[`U_C_Poloshirt_tricolour`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[`U_B_CombatUniform_mcam`,`V_TacVest_blk_POLICE`,`B_Carryall_cbr`,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemGPS`,`NVGoggles_OPFOR`,`Rangefinder`],`arifle_MXM_Black_F`,`hgun_P07_snds_F`,[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[`Medikit`,`ToolKit`],[],[`bipod_01_F_blk`],[`30Rnd_65x39_caseless_mag`,`30Rnd_65x39_caseless_mag`,`30Rnd_65x39_caseless_mag`,`30Rnd_65x39_caseless_mag`,`30Rnd_65x39_caseless_mag`,`30Rnd_65x39_caseless_mag`,`16Rnd_9x21_Mag`,`30Rnd_65x39_caseless_mag`,`16Rnd_9x21_Mag`],[`muzzle_snds_H`,`acc_flashlight`,`optic_Hamr`,``],[`muzzle_snds_L`,``,``,``],[[`lockpick`,10],[`redgull`,20],[`coffee`,10],[`donuts`,10],[`rabbit`,5]]]"', '"[]"', '"[100,100]"', '"[90,100]"', '"[100,100]"', 0, '0', '0', 0),
187(99, 'Demirci', '"[`Demirci`]"', '76561198114150840', 45500, 210000, '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_bagisci`,1],[`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`,0]]"', '"[]"', '"[]"', '"[``,`V_Rangemaster_belt`,`B_Kitbag_mcamo`,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`,`NVGoggles_OPFOR`],`SMG_01_Holo_pointer_snds_F`,``,[],[],[],[],[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`30Rnd_45ACP_Mag_SMG_01`,`30Rnd_45ACP_Mag_SMG_01`],[`muzzle_snds_acp`,``,`optic_Holosight_smg`,``],[``,``,``,``],[]]"', '"[]"', '"[]"', '"[80,80]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
188(100, 'AlperZalim', '"[`AlperZalim`]"', '76561198271860967', 0, 665500, '0', '0', '"[[`license_civ_driver`,1],[`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_bagisci`,1],[`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`,0]]"', '"[]"', '"[]"', '"[`U_C_Poloshirt_salmon`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[]"', '"[100,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
189(101, '[Ba? Komiser]Berkcan K.', '"[`[YPG] Abdurrahman Kele?`]"', '76561198117736514', 1500, 1561593, '5', '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_bagisci`,1],[`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`,0]]"', '"[[`license_cop_cAir`,1],[`license_cop_cg`,0]]"', '"[]"', '"[`U_C_Commoner1_1`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[`U_Rangemaster`,`V_Rangemaster_belt`,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`,`ItemGPS`],`srifle_EBR_F`,`hgun_P07_snds_F`,[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[],[],[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`20Rnd_762x51_Mag`,`16Rnd_9x21_Mag`],[``,``,``,``],[`muzzle_snds_L`,``,``,``],[]]"', '"[]"', '"[90,90]"', '"[100,90]"', '"[100,100]"', 0, '0', '0', 0),
190(102, 'Patrick', '"[`Patrick`]"', '76561198157656236', 10870, 486000, '0', '0', '"[[`license_civ_driver`,1],[`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_bagisci`,1],[`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`,0]]"', '"[]"', '"[]"', '"[`U_C_Poloshirt_burgundy`,`V_TacVest_camo`,`B_Kitbag_cbr`,`G_Balaclava_oli`,``,[`ItemMap`,`ItemCompass`,`ItemWatch`,`NVGoggles_OPFOR`,`Rangefinder`],`arifle_Katiba_F`,``,[`FirstAidKit`,`FirstAidKit`],[],[`ToolKit`],[`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`],[`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`],[`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`,`30Rnd_65x39_caseless_green_mag_Tracer`],[`muzzle_snds_H`,`acc_flashlight`,`optic_MRCO`,``],[``,``,``,``],[[`lockpick`,19],[`redgull`,27],[`waterBottle`,30]]]"', '"[]"', '"[]"', '"[90,80]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
191(103, 'TarzaN', '"[`TarzaN`]"', '76561198131162122', 0, 750000, '0', '0', '"[]"', '"[]"', '"[]"', '"[]"', '"[]"', '"[]"', '"[100,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
192(104, '[N.Ö.K]BiGBOSS', '"[`[N.Ö.K]BiGBOSS`]"', '76561198157618134', 0, 755000, '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_bagisci`,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`,0]]"', '"[]"', '"[]"', '"[`U_C_Poloshirt_tricolour`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[]"', '"[100,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
193(105, 'Hemogra', '"[`Hemogra`]"', '76561198110762458', 0, 1118000, '5', '0', '"[[`license_civ_driver`,1],[`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_bagisci`,1],[`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`,0]]"', '"[]"', '"[]"', '"[`U_C_Poloshirt_stripped`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[]"', '"[100,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
194(106, 'EkoFrésh', '"[`EkoFrésh`]"', '76561198256076697', 0, 2505089, '0', '0', '"[[`license_civ_driver`,1],[`license_civ_boat`,1],[`license_civ_pilot`,1],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_bagisci`,1],[`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`,0]]"', '"[]"', '"[]"', '"[`U_I_GhillieSuit`,`V_PlateCarrier1_rgr`,`B_Carryall_oucamo`,`G_Balaclava_lowprofile`,`H_HelmetO_ocamo`,[`ItemMap`,`ItemCompass`,`ItemWatch`,`NVGoggles_OPFOR`,`Rangefinder`],``,`hgun_ACPC2_F`,[`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`optic_Yorris`],[],[`ToolKit`],[`100Rnd_65x39_caseless_mag_Tracer`,`100Rnd_65x39_caseless_mag_Tracer`,`100Rnd_65x39_caseless_mag_Tracer`,`100Rnd_65x39_caseless_mag_Tracer`,`100Rnd_65x39_caseless_mag_Tracer`],[`optic_LRPS`,`optic_MRCO`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`],[`100Rnd_65x39_caseless_mag_Tracer`],[``,``,``,``],[`muzzle_snds_acp`,``,``,``],[]]"', '"[]"', '"[]"', '"[75,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
195(107, '[PÖH]Nurettin35', '"[`[PÖH]Nurettin35`]"', '76561198219879212', 0, 750000, '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_bagisci`,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`,0]]"', '"[]"', '"[]"', '"[`U_C_Poloshirt_burgundy`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[]"', '"[100,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
196(108, 'Darx', '"[`Darx`]"', '76561198093453550', 0, 750000, '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_bagisci`,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`,0]]"', '"[]"', '"[]"', '"[`U_C_Poloshirt_redwhite`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[]"', '"[100,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
197(109, '[T.O]Dont CRY', '"[`[T.O]Dont CRY`]"', '76561198282530107', 0, 810000, '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_bagisci`,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`,0]]"', '"[]"', '"[]"', '"[`U_C_Poloshirt_blue`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[]"', '"[60,40]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
198(110, 'PhAyToN', '"[`PhAyToN`]"', '76561198162326019', 0, 755000, '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_bagisci`,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`,0]]"', '"[]"', '"[]"', '"[`U_C_Poloshirt_blue`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[]"', '"[100,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
199(111, '[Ba?hekim]Ömer', '"[`[Ba?hekim]Ömer`]"', '76561198269555938', 0, 750000, '0', '0', '"[]"', '"[]"', '"[]"', '"[]"', '"[]"', '"[]"', '"[100,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
200(112, '[MafyaBabas?]Tabutçu', '"[`[MafyaBabas?]Tabutçu`]"', '76561198161395961', 0, 750000, '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_bagisci`,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`,0]]"', '"[]"', '"[]"', '"[`U_C_Poloshirt_burgundy`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[]"', '"[100,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
201(113, '[E.G.M]TugayBozkurt', '"[`[E.G.M]TugayBozkurt`]"', '76561198144954624', 0, 750000, '0', '0', '"[]"', '"[]"', '"[]"', '"[]"', '"[]"', '"[]"', '"[100,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0),
202(114, 'DeCuddlyBear', '"[`DeCuddlyBear`]"', '76561198229840180', 0, 500000, '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_bagisci`,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`,0]]"', '"[]"', '"[]"', '"[`U_C_Poloshirt_burgundy`,``,``,``,``,[`ItemMap`,`ItemCompass`,`ItemWatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[]"', '"[100,100]"', '"[100,100]"', '"[100,100]"', 0, '0', '0', 0);
203
204-- --------------------------------------------------------
205
206--
207-- Tablo için tablo yapısı `vehicles`
208--
209
210CREATE TABLE IF NOT EXISTS `vehicles` (
211`id` int(12) NOT NULL,
212 `side` varchar(15) NOT NULL,
213 `classname` varchar(32) NOT NULL,
214 `type` varchar(12) NOT NULL,
215 `pid` varchar(32) NOT NULL,
216 `alive` tinyint(1) NOT NULL DEFAULT '1',
217 `active` tinyint(1) NOT NULL DEFAULT '0',
218 `plate` int(20) NOT NULL,
219 `color` int(20) NOT NULL,
220 `inventory` varchar(500) NOT NULL,
221 `gear` text NOT NULL,
222 `fuel` double NOT NULL DEFAULT '1'
223) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=134 ;
224
225--
226-- Tablo döküm verisi `vehicles`
227--
228
229INSERT INTO `vehicles` (`id`, `side`, `classname`, `type`, `pid`, `alive`, `active`, `plate`, `color`, `inventory`, `gear`, `fuel`) VALUES
230(84, 'cop', 'C_Hatchback_01_sport_F', 'Car', '76561198092166375', 1, 0, 276963, 6, '"[[],0]"', '"[]"', 1),
231(89, 'cop', 'C_Hatchback_01_sport_F', 'Car', '76561198129540403', 1, 0, 252316, 6, '"[[],0]"', '"[]"', 1),
232(90, 'cop', 'C_SUV_01_F', 'Car', '76561198136057409', 1, 0, 919198, 5, '"[[],0]"', '"[]"', 1),
233(91, 'cop', 'C_Hatchback_01_sport_F', 'Car', '76561198145364070', 1, 0, 250421, 6, '[[],0]', '[]', 1),
234(92, 'cop', 'C_Offroad_01_F', 'Car', '76561198018396241', 1, 0, 527251, 8, '[[],0]', '[]', 1),
235(93, 'civ', 'B_Heli_Light_01_F', 'Air', '76561198092166375', 1, 0, 200325, 0, '[[],0]', '[]', 1),
236(94, 'cop', 'B_MRAP_01_F', 'Car', '76561198018396241', 1, 0, 138040, 0, '[[],0]', '[]', 1),
237(96, 'civ', 'C_Hatchback_01_sport_F', 'Car', '76561198271860967', 1, 0, 25314, 0, '"[[],0]"', '"[[[],[]],[[`16Rnd_9x21_Mag`],[3]],[[],[]],[[],[]]]"', 0.951528),
238(97, 'cop', 'C_Hatchback_01_sport_F', 'Car', '76561198145364070', 1, 0, 72047, 6, '[[],0]', '[]', 1),
239(98, 'civ', 'B_Heli_Light_01_F', 'Air', '76561198117736514', 1, 0, 625985, 9, '[[],0]', '[]', 1),
240(99, 'cop', 'C_Hatchback_01_sport_F', 'Car', '76561198145364070', 1, 0, 621248, 6, '[[],0]', '[]', 1),
241(100, 'civ', 'B_G_Offroad_01_F', 'Car', '76561198157656236', 1, 0, 834964, 0, '[[],0]', '[]', 1),
242(101, 'civ', 'B_G_Offroad_01_F', 'Car', '76561198157656236', 1, 0, 446954, 0, '[[],0]', '[]', 1),
243(102, 'civ', 'C_Hatchback_01_sport_F', 'Car', '76561198114150840', 1, 0, 230952, 4, '"[[],0]"', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', 0.90098),
244(103, 'civ', 'C_Hatchback_01_sport_F', 'Car', '76561198271860967', 1, 0, 483019, 3, '"[[],0]"', '"[]"', 1),
245(104, 'cop', 'B_MRAP_01_F', 'Car', '76561198145364070', 1, 0, 577899, 0, '"[[],0]"', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', 0.973769),
246(105, 'civ', 'C_Hatchback_01_sport_F', 'Car', '76561198117736514', 1, 0, 985279, 4, '[[],0]', '[]', 1),
247(106, 'civ', 'C_Hatchback_01_sport_F', 'Car', '76561198082425178', 1, 0, 329962, 1, '[[],0]', '[]', 1),
248(107, 'cop', 'C_Hatchback_01_sport_F', 'Car', '76561198085218272', 1, 0, 784306, 6, '[[],0]', '[]', 1),
249(110, 'cop', 'C_Hatchback_01_sport_F', 'Car', '76561198145364070', 1, 0, 993061, 6, '[[],0]', '[]', 1),
250(111, 'civ', 'C_Offroad_01_F', 'Car', '76561198271860967', 1, 0, 28972, 3, '"[[],0]"', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', 0.983011),
251(112, 'cop', 'B_MRAP_01_F', 'Car', '76561198092166375', 1, 0, 820490, 0, '"[[],0]"', '"[]"', 1),
252(113, 'cop', 'C_SUV_01_F', 'Car', '76561198082425178', 1, 0, 849463, 5, '"[[],0]"', '"[]"', 1),
253(114, 'cop', 'C_SUV_01_F', 'Car', '76561198092166375', 1, 0, 848938, 5, '"[[],0]"', '"[]"', 1),
254(115, 'cop', 'C_SUV_01_F', 'Car', '76561198092166375', 1, 0, 112018, 5, '"[[],0]"', '"[]"', 1),
255(116, 'cop', 'C_SUV_01_F', 'Car', '76561198092166375', 1, 0, 973933, 5, '"[[],0]"', '"[]"', 1),
256(117, 'cop', 'C_SUV_01_F', 'Car', '76561198082425178', 1, 0, 354279, 5, '"[[],0]"', '"[]"', 1),
257(118, 'cop', 'C_Hatchback_01_sport_F', 'Car', '76561198117736514', 1, 0, 754705, 6, '"[[],0]"', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', 0.99322),
258(119, 'cop', 'C_SUV_01_F', 'Car', '76561198117736514', 1, 0, 847922, 5, '[[],0]', '[]', 1),
259(121, 'civ', 'C_Hatchback_01_sport_F', 'Car', '76561198256076697', 1, 0, 774929, 0, '[[],0]', '[]', 1),
260(122, 'cop', 'C_Hatchback_01_sport_F', 'Car', '76561198097560681', 1, 0, 49655, 6, '"[[],0]"', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', 0.972707),
261(123, 'cop', 'B_MRAP_01_F', 'Car', '76561198117736514', 1, 0, 409583, 0, '"[[],0]"', '"[[[`optic_MRD`],[1]],[[],[]],[[],[]],[[],[]]]"', 0.984902),
262(128, 'civ', 'C_Hatchback_01_sport_F', 'Car', '76561198129540403', 1, 0, 563575, 4, '[[],0]', '[]', 1),
263(129, 'cop', 'C_Hatchback_01_sport_F', 'Car', '76561198117736514', 1, 0, 841144, 6, '[[],0]', '[]', 1),
264(130, 'civ', 'C_Offroad_01_F', 'Car', '76561198018396241', 1, 0, 132975, 3, '"[[],0]"', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', 0.980833),
265(131, 'civ', 'C_SUV_01_F', 'Car', '76561198256076697', 1, 0, 416490, 0, '[[],0]', '[]', 1),
266(132, 'civ', 'C_SUV_01_F', 'Car', '76561198256076697', 1, 0, 410717, 1, '[[],0]', '[]', 1),
267(133, 'cop', 'B_MRAP_01_F', 'Car', '76561198066077165', 1, 0, 96639, 0, '"[[],0]"', '"[]"', 1);
268
269-- --------------------------------------------------------
270
271--
272-- Tablo için tablo yapısı `wanted`
273--
274
275CREATE TABLE IF NOT EXISTS `wanted` (
276 `wantedID` varchar(50) NOT NULL,
277 `wantedName` varchar(52) NOT NULL,
278 `wantedCrimes` text NOT NULL,
279 `wantedBounty` int(100) NOT NULL,
280 `active` tinyint(1) NOT NULL DEFAULT '0'
281) ENGINE=InnoDB DEFAULT CHARSET=latin1;
282
283--
284-- Tablo döküm verisi `wanted`
285--
286
287INSERT INTO `wanted` (`wantedID`, `wantedName`, `wantedCrimes`, `wantedBounty`, `active`) VALUES
288('76561198082425178', '[NR] Izzet-ul Mubarak', '"[`187`,`187`,`187`,`187`]"', 8000, 1),
289('76561198110762458', 'Hemogra', '[]', 0, 0),
290('76561198114150840', 'Demirci', '[]', 0, 0),
291('76561198129540403', 'Avienox', '"[`187`,`187`]"', 4000, 1),
292('76561198136057409', 'LAISERG', '"[`187`,`187`]"', 4000, 1),
293('76561198157656236', 'Patrick', '"[`487`,`187`]"', 2150, 1),
294('76561198256076697', 'EkoFrésh', '"[`187`,`487`]"', 2150, 1);
295
296--
297-- Dökümü yapılmış tablolar için indeksler
298--
299
300--
301-- Tablo için indeksler `ah`
302--
303ALTER TABLE `ah`
304 ADD PRIMARY KEY (`id`);
305
306--
307-- Tablo için indeksler `containers`
308--
309ALTER TABLE `containers`
310 ADD PRIMARY KEY (`id`,`pid`);
311
312--
313-- Tablo için indeksler `dynmarket`
314--
315ALTER TABLE `dynmarket`
316 ADD PRIMARY KEY (`id`);
317
318--
319-- Tablo için indeksler `gangs`
320--
321ALTER TABLE `gangs`
322 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `name_UNIQUE` (`name`);
323
324--
325-- Tablo için indeksler `houses`
326--
327ALTER TABLE `houses`
328 ADD PRIMARY KEY (`id`,`pid`);
329
330--
331-- Tablo için indeksler `players`
332--
333ALTER TABLE `players`
334 ADD PRIMARY KEY (`uid`), ADD UNIQUE KEY `playerid` (`playerid`), ADD KEY `name` (`name`), ADD KEY `blacklist` (`blacklist`), ADD FULLTEXT KEY `civ_licenses` (`civ_licenses`);
335
336--
337-- Tablo için indeksler `vehicles`
338--
339ALTER TABLE `vehicles`
340 ADD PRIMARY KEY (`id`), ADD KEY `side` (`side`), ADD KEY `pid` (`pid`), ADD KEY `type` (`type`);
341
342--
343-- Tablo için indeksler `wanted`
344--
345ALTER TABLE `wanted`
346 ADD PRIMARY KEY (`wantedID`);
347
348--
349-- Dökümü yapılmış tablolar için AUTO_INCREMENT değeri
350--
351
352--
353-- Tablo için AUTO_INCREMENT değeri `ah`
354--
355ALTER TABLE `ah`
356MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
357--
358-- Tablo için AUTO_INCREMENT değeri `containers`
359--
360ALTER TABLE `containers`
361MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
362--
363-- Tablo için AUTO_INCREMENT değeri `gangs`
364--
365ALTER TABLE `gangs`
366MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
367--
368-- Tablo için AUTO_INCREMENT değeri `houses`
369--
370ALTER TABLE `houses`
371MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
372--
373-- Tablo için AUTO_INCREMENT değeri `players`
374--
375ALTER TABLE `players`
376MODIFY `uid` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=115;
377--
378-- Tablo için AUTO_INCREMENT değeri `vehicles`
379--
380ALTER TABLE `vehicles`
381MODIFY `id` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=134;
382/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
383/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
384/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;