Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `apartments` (
- `id` INT(11) NOT NULL,
- `name` VARCHAR(255) DEFAULT NULL,
- `type` VARCHAR(255) DEFAULT NULL,
- `label` VARCHAR(255) DEFAULT NULL,
- `citizenid` VARCHAR(11) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- --
- -- Dumping data for table `apartments`
- --
- INSERT INTO `apartments` (`id`, `name`, `type`, `label`, `citizenid`) VALUES
- (1, 'apartment43212', 'apartment4', 'South Rockford Drive 8123', 'BYV87342'),
- (2, 'apartment18123', 'apartment1', 'South Rockford Drive 8123', 'UFQ88534'),
- (4, 'apartment14670', 'apartment1', 'South Rockford Drive 4670', 'UGE35348'),
- (5, 'apartment1707', 'apartment1', 'South Rockford Drive', 'SSL19978');
- -- --------------------------------------------------------
- --
- -- Table structure for table `bank_accounts`
- --
- CREATE TABLE `bank_accounts` (
- `id` INT(11) NOT NULL,
- `citizenid` VARCHAR(11) DEFAULT NULL,
- `account_name` VARCHAR(50) DEFAULT NULL,
- `account_balance` INT(11) NOT NULL DEFAULT 0,
- `account_type` enum('shared','job','gang') NOT NULL,
- `users` longtext DEFAULT '[]'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- --
- -- Dumping data for table `bank_accounts`
- --
- INSERT INTO `bank_accounts` (`id`, `citizenid`, `account_name`, `account_balance`, `account_type`, `users`) VALUES
- (1, NULL, 'blackhand', 0, 'gang', '[]');
- -- --------------------------------------------------------
- --
- -- Table structure for table `bank_statements`
- --
- CREATE TABLE `bank_statements` (
- `id` INT(11) NOT NULL,
- `citizenid` VARCHAR(11) DEFAULT NULL,
- `account_name` VARCHAR(50) DEFAULT 'checking',
- `amount` INT(11) DEFAULT NULL,
- `reason` VARCHAR(50) DEFAULT NULL,
- `statement_type` enum('deposit','withdraw') DEFAULT NULL,
- `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() ON UPDATE CURRENT_TIMESTAMP()
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- --
- -- Dumping data for table `bank_statements`
- --
- INSERT INTO `bank_statements` (`id`, `citizenid`, `account_name`, `amount`, `reason`, `statement_type`, `date`) VALUES
- (1, 'UFQ88534', 'checking', 400, 'For a car', 'deposit', '2024-04-08 16:04:19'),
- (2, 'BYV87342', 'checking', 5000, 'For a Car', 'withdraw', '2024-04-08 21:45:47');
- -- --------------------------------------------------------
- --
- -- Table structure for table `bans`
- --
- CREATE TABLE `bans` (
- `id` INT(11) NOT NULL,
- `name` VARCHAR(50) DEFAULT NULL,
- `license` VARCHAR(50) DEFAULT NULL,
- `discord` VARCHAR(50) DEFAULT NULL,
- `ip` VARCHAR(50) DEFAULT NULL,
- `reason` text DEFAULT NULL,
- `expire` INT(11) DEFAULT NULL,
- `bannedby` VARCHAR(255) NOT NULL DEFAULT 'LeBanhammer'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `computers_mail_accounts`
- --
- CREATE TABLE `computers_mail_accounts` (
- `id` INT(11) NOT NULL,
- `identifier` VARCHAR(40) NOT NULL,
- `username` VARCHAR(16) NOT NULL,
- `password` VARCHAR(32) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
- --
- -- Dumping data for table `computers_mail_accounts`
- --
- INSERT INTO `computers_mail_accounts` (`id`, `identifier`, `username`, `password`) VALUES
- (1, '3478ecef433d5217ca21145b2bfb0e728b8724b0', 'Test', 'test'),
- (2, '3478ecef433d5217ca21145b2bfb0e728b8724b0', 'Sparky King', 'random1');
- -- --------------------------------------------------------
- --
- -- Table structure for table `computers_mail_mails`
- --
- CREATE TABLE `computers_mail_mails` (
- `id` INT(11) NOT NULL,
- `from` VARCHAR(16) NOT NULL,
- `to` VARCHAR(16) NOT NULL,
- `object` VARCHAR(32) DEFAULT NULL,
- `text` VARCHAR(4096) DEFAULT NULL,
- `answer_to` INT(11) DEFAULT NULL,
- `timestamp` INT(11) DEFAULT unix_timestamp(),
- `read` tinyint(1) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `computers_market`
- --
- CREATE TABLE `computers_market` (
- `id` INT(11) NOT NULL,
- `seller` VARCHAR(40) NOT NULL,
- `title` VARCHAR(16) NOT NULL,
- `description` VARCHAR(512) DEFAULT NULL,
- `timestamp` INT(11) DEFAULT unix_timestamp()
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `crypto`
- --
- CREATE TABLE `crypto` (
- `crypto` VARCHAR(50) NOT NULL DEFAULT 'qbit',
- `worth` INT(11) NOT NULL DEFAULT 0,
- `history` text DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
- --
- -- Dumping data for table `crypto`
- --
- INSERT INTO `crypto` (`crypto`, `worth`, `history`) VALUES
- ('qbit', 990, '[{\"NewWorth\":998,\"PreviousWorth\":1004},{\"NewWorth\":998,\"PreviousWorth\":1004},{\"NewWorth\":998,\"PreviousWorth\":1004},{\"NewWorth\":990,\"PreviousWorth\":998}]');
- -- --------------------------------------------------------
- --
- -- Table structure for table `crypto_transactions`
- --
- CREATE TABLE `crypto_transactions` (
- `id` INT(11) NOT NULL,
- `citizenid` VARCHAR(11) DEFAULT NULL,
- `title` VARCHAR(50) DEFAULT NULL,
- `message` VARCHAR(50) DEFAULT NULL,
- `date` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP()
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- --
- -- Dumping data for table `crypto_transactions`
- --
- INSERT INTO `crypto_transactions` (`id`, `citizenid`, `title`, `message`, `date`) VALUES
- (1, 'BYV87342', 'Credit', 'You have purchased 1 Qbit(s)!', '2024-04-12 05:13:07'),
- (2, 'BYV87342', 'Debit', 'You have sold 1 Qbit(s)!', '2024-04-12 05:13:13');
- -- --------------------------------------------------------
- --
- -- Table structure for table `dealers`
- --
- CREATE TABLE `dealers` (
- `id` INT(11) NOT NULL,
- `name` VARCHAR(50) NOT NULL DEFAULT '0',
- `coords` longtext DEFAULT NULL,
- `time` longtext DEFAULT NULL,
- `createdby` VARCHAR(50) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `dpkeybinds`
- --
- CREATE TABLE `dpkeybinds` (
- `id` VARCHAR(50) DEFAULT NULL,
- `keybind1` VARCHAR(50) DEFAULT 'num4',
- `emote1` VARCHAR(255) DEFAULT '',
- `keybind2` VARCHAR(50) DEFAULT 'num5',
- `emote2` VARCHAR(255) DEFAULT '',
- `keybind3` VARCHAR(50) DEFAULT 'num6',
- `emote3` VARCHAR(255) DEFAULT '',
- `keybind4` VARCHAR(50) DEFAULT 'num7',
- `emote4` VARCHAR(255) DEFAULT '',
- `keybind5` VARCHAR(50) DEFAULT 'num8',
- `emote5` VARCHAR(255) DEFAULT '',
- `keybind6` VARCHAR(50) DEFAULT 'num9',
- `emote6` VARCHAR(255) DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `gloveboxitems`
- --
- CREATE TABLE `gloveboxitems` (
- `id` INT(11) NOT NULL,
- `plate` VARCHAR(8) NOT NULL DEFAULT '[]',
- `items` longtext DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- --
- -- Dumping data for table `gloveboxitems`
- --
- INSERT INTO `gloveboxitems` (`id`, `plate`, `items`) VALUES
- (1, '3PM529YQ', '[]'),
- (2, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"}]'),
- (3, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"}]'),
- (4, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"},{\"amount\":1,\"slot\":2,\"useable\":false,\"unique\":false,\"weight\":2000,\"info\":[],\"label\":\"Tablet\",\"type\":\"item\",\"name\":\"tablet\",\"image\":\"tablet.png\"}]'),
- (5, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"},{\"amount\":1,\"slot\":2,\"useable\":false,\"unique\":false,\"weight\":2000,\"info\":[],\"label\":\"Tablet\",\"type\":\"item\",\"name\":\"tablet\",\"image\":\"tablet.png\"}]'),
- (6, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"},{\"amount\":1,\"slot\":2,\"useable\":false,\"unique\":false,\"weight\":2000,\"info\":[],\"label\":\"Tablet\",\"type\":\"item\",\"name\":\"tablet\",\"image\":\"tablet.png\"}]'),
- (7, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"},{\"amount\":1,\"slot\":2,\"useable\":false,\"unique\":false,\"weight\":2000,\"info\":[],\"label\":\"Tablet\",\"type\":\"item\",\"name\":\"tablet\",\"image\":\"tablet.png\"}]'),
- (8, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"},{\"amount\":1,\"slot\":2,\"useable\":false,\"unique\":false,\"weight\":2000,\"info\":[],\"label\":\"Tablet\",\"type\":\"item\",\"name\":\"tablet\",\"image\":\"tablet.png\"}]'),
- (9, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"},{\"amount\":1,\"slot\":2,\"useable\":false,\"unique\":false,\"weight\":2000,\"info\":[],\"label\":\"Tablet\",\"type\":\"item\",\"name\":\"tablet\",\"image\":\"tablet.png\"}]'),
- (10, '3PM529YQ', '[{\"amount\":1,\"slot\":1,\"useable\":false,\"unique\":false,\"weight\":4000,\"info\":[],\"label\":\"Laptop\",\"type\":\"item\",\"name\":\"laptop\",\"image\":\"laptop.png\"},{\"amount\":1,\"slot\":2,\"useable\":false,\"unique\":false,\"weight\":2000,\"info\":[],\"label\":\"Tablet\",\"type\":\"item\",\"name\":\"tablet\",\"image\":\"tablet.png\"}]'),
- (11, '4UK308JV', '[]');
- -- --------------------------------------------------------
- --
- -- Table structure for table `houselocations`
- --
- CREATE TABLE `houselocations` (
- `id` INT(11) NOT NULL,
- `name` VARCHAR(255) DEFAULT NULL,
- `label` VARCHAR(255) DEFAULT NULL,
- `coords` text DEFAULT NULL,
- `owned` tinyint(1) DEFAULT NULL,
- `price` INT(11) DEFAULT NULL,
- `tier` tinyint(4) DEFAULT NULL,
- `garage` text DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `house_plants`
- --
- CREATE TABLE `house_plants` (
- `id` INT(11) NOT NULL,
- `building` VARCHAR(50) DEFAULT NULL,
- `stage` INT(11) DEFAULT 1,
- `sort` VARCHAR(50) DEFAULT NULL,
- `gender` VARCHAR(50) DEFAULT NULL,
- `food` INT(11) DEFAULT 100,
- `health` INT(11) DEFAULT 100,
- `progress` INT(11) DEFAULT 0,
- `coords` text DEFAULT NULL,
- `plantid` VARCHAR(50) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `lapraces`
- --
- CREATE TABLE `lapraces` (
- `id` INT(11) NOT NULL,
- `name` VARCHAR(50) DEFAULT NULL,
- `checkpoints` text DEFAULT NULL,
- `records` text DEFAULT NULL,
- `creator` VARCHAR(50) DEFAULT NULL,
- `distance` INT(11) DEFAULT NULL,
- `raceid` VARCHAR(50) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `mdt_bolos`
- --
- CREATE TABLE `mdt_bolos` (
- `id` INT(11) NOT NULL,
- `author` VARCHAR(50) DEFAULT NULL,
- `title` VARCHAR(50) DEFAULT NULL,
- `plate` VARCHAR(50) DEFAULT NULL,
- `owner` VARCHAR(50) DEFAULT NULL,
- `individual` VARCHAR(50) DEFAULT NULL,
- `detail` text DEFAULT NULL,
- `tags` text DEFAULT NULL,
- `gallery` text DEFAULT NULL,
- `officersinvolved` text DEFAULT NULL,
- `time` VARCHAR(20) DEFAULT NULL,
- `jobtype` VARCHAR(25) NOT NULL DEFAULT 'police'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- --
- -- Dumping data for table `mdt_bolos`
- --
- INSERT INTO `mdt_bolos` (`id`, `author`, `title`, `plate`, `owner`, `individual`, `detail`, `tags`, `gallery`, `officersinvolved`, `time`, `jobtype`) VALUES
- (1, 'Server Admin', 'Bolo #1', 'None', 'None', 'Devin King', '<p>Keep An Eye Out For Devin King</p>', '[\"The Crimson Blades\"]', '[]', '[\"(K10) Sparky King\"]', '1714156679804', 'police');
- -- --------------------------------------------------------
- --
- -- Table structure for table `mdt_bulletin`
- --
- CREATE TABLE `mdt_bulletin` (
- `id` INT(11) NOT NULL,
- `title` text NOT NULL,
- `desc` text NOT NULL,
- `author` VARCHAR(50) NOT NULL,
- `time` VARCHAR(20) NOT NULL,
- `jobtype` VARCHAR(25) DEFAULT 'police'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `mdt_clocking`
- --
- CREATE TABLE `mdt_clocking` (
- `id` INT(10) NOT NULL,
- `user_id` VARCHAR(50) NOT NULL DEFAULT '',
- `firstname` VARCHAR(255) NOT NULL DEFAULT '',
- `lastname` VARCHAR(255) NOT NULL DEFAULT '',
- `clock_in_time` VARCHAR(255) NOT NULL DEFAULT '',
- `clock_out_time` VARCHAR(50) DEFAULT NULL,
- `total_time` INT(10) NOT NULL DEFAULT 0
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- --
- -- Dumping data for table `mdt_clocking`
- --
- INSERT INTO `mdt_clocking` (`id`, `user_id`, `firstname`, `lastname`, `clock_in_time`, `clock_out_time`, `total_time`) VALUES
- (7, 'SSL19978', 'Server', 'Admin', '2024-04-26 14:38:29', '2024-04-26 16:22:39', 6250);
- -- --------------------------------------------------------
- --
- -- Table structure for table `mdt_convictions`
- --
- CREATE TABLE `mdt_convictions` (
- `id` INT(11) NOT NULL,
- `cid` VARCHAR(50) DEFAULT NULL,
- `linkedincident` INT(11) NOT NULL DEFAULT 0,
- `warrant` VARCHAR(50) DEFAULT NULL,
- `guilty` VARCHAR(50) DEFAULT NULL,
- `processed` VARCHAR(50) DEFAULT NULL,
- `associated` VARCHAR(50) DEFAULT '0',
- `charges` text DEFAULT NULL,
- `fine` INT(11) DEFAULT 0,
- `sentence` INT(11) DEFAULT 0,
- `recfine` INT(11) DEFAULT 0,
- `recsentence` INT(11) DEFAULT 0,
- `time` VARCHAR(20) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `mdt_data`
- --
- CREATE TABLE `mdt_data` (
- `id` INT(11) NOT NULL,
- `cid` VARCHAR(20) NOT NULL,
- `information` mediumtext DEFAULT NULL,
- `tags` text NOT NULL,
- `gallery` text NOT NULL,
- `jobtype` VARCHAR(25) DEFAULT 'police',
- `pfp` text DEFAULT NULL,
- `fingerprint` VARCHAR(50) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `mdt_impound`
- --
- CREATE TABLE `mdt_impound` (
- `id` INT(11) NOT NULL,
- `vehicleid` INT(11) NOT NULL,
- `linkedreport` INT(11) NOT NULL,
- `fee` INT(11) DEFAULT NULL,
- `time` VARCHAR(255) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `mdt_incidents`
- --
- CREATE TABLE `mdt_incidents` (
- `id` INT(11) NOT NULL,
- `author` VARCHAR(50) NOT NULL DEFAULT '',
- `title` VARCHAR(50) NOT NULL DEFAULT '0',
- `details` longtext NOT NULL,
- `tags` text NOT NULL,
- `officersinvolved` text NOT NULL,
- `civsinvolved` text NOT NULL,
- `evidence` text NOT NULL,
- `time` VARCHAR(20) DEFAULT NULL,
- `jobtype` VARCHAR(25) NOT NULL DEFAULT 'police'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `mdt_logs`
- --
- CREATE TABLE `mdt_logs` (
- `id` INT(11) NOT NULL,
- `text` text NOT NULL,
- `time` VARCHAR(20) DEFAULT NULL,
- `jobtype` VARCHAR(25) DEFAULT 'police'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- --
- -- Dumping data for table `mdt_logs`
- --
- INSERT INTO `mdt_logs` (`id`, `text`, `time`, `jobtype`) VALUES
- (1, 'A new BOLO was created by Server Admin with the title (Bolo #1) and ID (0)', '1714156679000', 'police');
- -- --------------------------------------------------------
- --
- -- Table structure for table `mdt_reports`
- --
- CREATE TABLE `mdt_reports` (
- `id` INT(11) NOT NULL,
- `author` VARCHAR(50) DEFAULT NULL,
- `title` VARCHAR(255) DEFAULT NULL,
- `type` VARCHAR(50) DEFAULT NULL,
- `details` longtext DEFAULT NULL,
- `tags` text DEFAULT NULL,
- `officersinvolved` text DEFAULT NULL,
- `civsinvolved` text DEFAULT NULL,
- `gallery` text DEFAULT NULL,
- `time` VARCHAR(20) DEFAULT NULL,
- `jobtype` VARCHAR(25) DEFAULT 'police'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `mdt_vehicleinfo`
- --
- CREATE TABLE `mdt_vehicleinfo` (
- `id` INT(11) NOT NULL,
- `plate` VARCHAR(50) DEFAULT NULL,
- `information` text NOT NULL DEFAULT '',
- `stolen` tinyint(1) NOT NULL DEFAULT 0,
- `code5` tinyint(1) NOT NULL DEFAULT 0,
- `image` text NOT NULL DEFAULT '',
- `points` INT(11) DEFAULT 0
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `mdt_weaponinfo`
- --
- CREATE TABLE `mdt_weaponinfo` (
- `id` INT(11) NOT NULL,
- `serial` VARCHAR(50) DEFAULT NULL,
- `owner` VARCHAR(50) DEFAULT NULL,
- `information` text NOT NULL DEFAULT '',
- `weapClass` VARCHAR(50) DEFAULT NULL,
- `weapModel` VARCHAR(50) DEFAULT NULL,
- `image` VARCHAR(255) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- --
- -- Dumping data for table `mdt_weaponinfo`
- --
- INSERT INTO `mdt_weaponinfo` (`id`, `serial`, `owner`, `information`, `weapClass`, `weapModel`, `image`) VALUES
- (1, '73Xzy1Gr331QiTS', 'Server Admin', 'Self Registered', 'Class 1', 'Petrol Can', 'https://cfx-nui-qb-inventory/html/images/weapon_petrolcan.png'),
- (2, '96Yfm7ax619aTzB', 'Server Admin', 'Self Registered', 'Class 1', 'Petrol Can', 'https://cfx-nui-qb-inventory/html/images/weapon_petrolcan.png'),
- (3, '48YUG2yT672dkka', 'Server Admin', 'Self Registered', 'Class 1', 'Petrol Can', 'https://cfx-nui-qb-inventory/html/images/weapon_petrolcan.png'),
- (4, '94dNP3bx658grQR', 'Server Admin', 'Self Registered', 'Class 1', 'Petrol Can', 'https://cfx-nui-qb-inventory/html/images/weapon_petrolcan.png'),
- (5, '61mwR3eG335vnyr', 'Server Admin', 'Self Registered', 'Class 1', 'Petrol Can', 'https://cfx-nui-qb-inventory/html/images/weapon_petrolcan.png'),
- (6, '32Zym4KO659Bhyd', 'Server Admin', 'Self Registered', 'Class 1', 'Petrol Can', 'https://cfx-nui-qb-inventory/html/images/weapon_petrolcan.png'),
- (7, '47Szs8IM182gOZq', 'Server Admin', 'Purchased at Ammunation', '1', 'Knife', 'https://cfx-nui-qb-inventory/html/images/weapon_knife.png'),
- (8, '77bOu7dN572XvAT', 'Server Admin', 'Purchased at Ammunation', '1', 'Bat', 'https://cfx-nui-qb-inventory/html/images/weapon_bat.png'),
- (9, '21fAS9NG825mfei', 'Server Admin', 'Purchased at Ammunation', '1', 'Hatchet', 'https://cfx-nui-qb-inventory/html/images/weapon_hatchet.png');
- -- --------------------------------------------------------
- --
- -- Table structure for table `multijobs`
- --
- CREATE TABLE `multijobs` (
- `citizenid` VARCHAR(100) NOT NULL,
- `jobdata` text DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
- --
- -- Dumping data for table `multijobs`
- --
- INSERT INTO `multijobs` (`citizenid`, `jobdata`) VALUES
- ('SSL19978', '{\"mechanic\":4,\"police\":4,\"tow\":0,\"realestate\":1}');
- -- --------------------------------------------------------
- --
- -- Table structure for table `occasion_vehicles`
- --
- CREATE TABLE `occasion_vehicles` (
- `id` INT(11) NOT NULL,
- `seller` VARCHAR(50) DEFAULT NULL,
- `price` INT(11) DEFAULT NULL,
- `description` longtext DEFAULT NULL,
- `plate` VARCHAR(50) DEFAULT NULL,
- `model` VARCHAR(50) DEFAULT NULL,
- `mods` text DEFAULT NULL,
- `occasionid` VARCHAR(50) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `pefcl_accounts`
- --
- CREATE TABLE `pefcl_accounts` (
- `id` INT(11) NOT NULL,
- `number` VARCHAR(255) DEFAULT NULL,
- `accountName` VARCHAR(255) DEFAULT NULL,
- `isDefault` tinyint(1) DEFAULT 0,
- `ownerIdentifier` VARCHAR(255) DEFAULT NULL,
- `role` VARCHAR(255) DEFAULT 'owner',
- `balance` INT(11) DEFAULT 25000,
- `type` VARCHAR(255) DEFAULT 'personal',
- `createdAt` datetime NOT NULL,
- `updatedAt` datetime NOT NULL,
- `deletedAt` datetime DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `pefcl_cash`
- --
- CREATE TABLE `pefcl_cash` (
- `id` INT(11) NOT NULL,
- `amount` INT(11) DEFAULT 2000,
- `ownerIdentifier` VARCHAR(255) DEFAULT NULL,
- `createdAt` datetime NOT NULL,
- `updatedAt` datetime NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `pefcl_external_accounts`
- --
- CREATE TABLE `pefcl_external_accounts` (
- `id` INT(11) NOT NULL,
- `number` VARCHAR(255) DEFAULT NULL,
- `name` VARCHAR(255) DEFAULT NULL,
- `userId` VARCHAR(255) DEFAULT NULL,
- `createdAt` datetime NOT NULL,
- `updatedAt` datetime NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `pefcl_invoices`
- --
- CREATE TABLE `pefcl_invoices` (
- `id` INT(11) NOT NULL,
- `message` VARCHAR(255) NOT NULL,
- `from` VARCHAR(255) NOT NULL,
- `to` VARCHAR(255) NOT NULL,
- `fromIdentifier` VARCHAR(255) NOT NULL,
- `toIdentifier` VARCHAR(255) NOT NULL,
- `receiverAccountIdentifier` VARCHAR(255) DEFAULT NULL,
- `amount` INT(11) DEFAULT 0,
- `status` VARCHAR(255) DEFAULT 'PENDING',
- `expiresAt` datetime NOT NULL,
- `createdAt` datetime NOT NULL,
- `updatedAt` datetime NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `pefcl_shared_accounts`
- --
- CREATE TABLE `pefcl_shared_accounts` (
- `id` INT(11) NOT NULL,
- `userIdentifier` VARCHAR(255) DEFAULT NULL,
- `name` VARCHAR(255) DEFAULT NULL,
- `role` VARCHAR(255) DEFAULT 'contributor',
- `createdAt` datetime NOT NULL,
- `updatedAt` datetime NOT NULL,
- `deletedAt` datetime DEFAULT NULL,
- `accountId` INT(11) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `pefcl_transactions`
- --
- CREATE TABLE `pefcl_transactions` (
- `id` INT(11) NOT NULL,
- `message` VARCHAR(255) DEFAULT NULL,
- `amount` INT(11) DEFAULT 0,
- `type` VARCHAR(255) DEFAULT 'Outgoing',
- `createdAt` datetime NOT NULL,
- `updatedAt` datetime NOT NULL,
- `toAccountId` INT(11) DEFAULT NULL,
- `fromAccountId` INT(11) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phone_gallery`
- --
- CREATE TABLE `phone_gallery` (
- `citizenid` VARCHAR(11) NOT NULL,
- `image` VARCHAR(255) NOT NULL,
- `date` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP()
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phone_invoices`
- --
- CREATE TABLE `phone_invoices` (
- `id` INT(10) NOT NULL,
- `citizenid` VARCHAR(11) DEFAULT NULL,
- `amount` INT(11) NOT NULL DEFAULT 0,
- `society` tinytext DEFAULT NULL,
- `sender` VARCHAR(50) DEFAULT NULL,
- `sendercitizenid` VARCHAR(50) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phone_messages`
- --
- CREATE TABLE `phone_messages` (
- `id` INT(11) NOT NULL,
- `citizenid` VARCHAR(11) DEFAULT NULL,
- `number` VARCHAR(50) DEFAULT NULL,
- `messages` text DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phone_tweets`
- --
- CREATE TABLE `phone_tweets` (
- `id` INT(11) NOT NULL,
- `citizenid` VARCHAR(11) DEFAULT NULL,
- `firstName` VARCHAR(25) DEFAULT NULL,
- `lastName` VARCHAR(25) DEFAULT NULL,
- `message` text DEFAULT NULL,
- `date` datetime DEFAULT CURRENT_TIMESTAMP(),
- `url` text DEFAULT NULL,
- `picture` VARCHAR(512) DEFAULT './img/default.png',
- `tweetId` VARCHAR(25) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- --
- -- Dumping data for table `phone_tweets`
- --
- INSERT INTO `phone_tweets` (`id`, `citizenid`, `firstName`, `lastName`, `message`, `date`, `url`, `picture`, `tweetId`) VALUES
- (1, 'BYV87342', 'Sparky', 'King', 'hello', '2024-04-08 01:21:29', '', 'default', 'TWEET-96019152'),
- (2, 'UFQ88534', 'Devin', 'King', 'Hey', '2024-04-11 13:22:07', '', 'default', 'TWEET-19905322'),
- (3, 'SSL19978', 'Server', 'Admin', 'hello', '2024-04-21 03:20:43', '', 'https://kappa.lol/Ss3-t.2024-04-20-1713656574.png', 'post-30944245'),
- (4, 'SSL19978', 'Server', 'Admin', 'hey', '2024-04-21 22:08:09', '', 'https://kappa.lol/Ss3-t.2024-04-20-1713656574.png', 'post-30848675'),
- (5, 'SSL19978', 'Server', 'Admin', 'Hello #losSantos', '2024-04-26 18:41:33', '', 'https://kappa.lol/Ss3-t.2024-04-20-1713656574.png', 'post-11214906');
- -- --------------------------------------------------------
- --
- -- Table structure for table `players`
- --
- CREATE TABLE `players` (
- `id` INT(11) NOT NULL,
- `citizenid` VARCHAR(50) NOT NULL,
- `cid` INT(11) DEFAULT NULL,
- `license` VARCHAR(255) NOT NULL,
- `name` VARCHAR(255) NOT NULL,
- `money` text NOT NULL,
- `charinfo` text DEFAULT NULL,
- `job` text NOT NULL,
- `gang` text DEFAULT NULL,
- `position` text NOT NULL,
- `metadata` text NOT NULL,
- `inventory` longtext DEFAULT NULL,
- `last_updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() ON UPDATE CURRENT_TIMESTAMP()
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- --
- -- Dumping data for table `players`
- --
- INSERT INTO `players` (`id`, `citizenid`, `cid`, `license`, `name`, `money`, `charinfo`, `job`, `gang`, `position`, `metadata`, `inventory`, `last_updated`) VALUES
- (1, 'BYV87342', 1, 'license:3478ecef433d5217ca21145b2bfb0e728b8724b0', 'Bacon_Space', '{\"crypto\":0,\"cash\":5447,\"bank\":2445}', '{\"nationality\":\"Canada\",\"cid\":1,\"firstname\":\"Sparky\",\"phone\":\"1628475836\",\"account\":\"US07QBCore3715874485\",\"birthdate\":\"1994-06-08\",\"lastname\":\"King\",\"gender\":0,\"backstory\":\"placeholder backstory\"}', '{\"type\":\"lawyer\",\"grade\":{\"name\":\"Surgeon\",\"level\":3},\"isboss\":false,\"name\":\"lawyer\",\"payment\":125,\"onduty\":true,\"label\":\"Law Firm\"}', '{\"name\":\"none\",\"label\":\"No Gang Affiliaton\",\"grade\":{\"name\":\"none\",\"level\":0},\"isboss\":false}', '{\"x\":2383.489990234375,\"y\":3079.74072265625,\"z\":48.151611328125}', '{\"isdead\":false,\"thirst\":35.40000000000005,\"fitbit\":[],\"tracker\":false,\"walletid\":\"QB-39171774\",\"injail\":0,\"cardeliveryxp\":0,\"phonedata\":{\"InstalledApps\":[],\"SerialNumber\":23617045},\"status\":[],\"licences\":{\"driver\":true,\"weapon\":false,\"business\":false},\"callsign\":\"K10\",\"hunger\":28.59999999999994,\"fingerprint\":\"sU530E20PgQ1216\",\"bloodtype\":\"A-\",\"inlaststand\":false,\"criminalrecord\":{\"hasRecord\":false},\"ishandcuffed\":false,\"craftingrep\":0,\"armor\":0,\"phone\":[],\"attachmentcraftingrep\":0,\"jobrep\":{\"hotdog\":0,\"taxi\":0,\"trucker\":0,\"tow\":0},\"jailitems\":[],\"dealerrep\":0,\"inside\":{\"apartment\":[]},\"stress\":21}', '[{\"info\":{\"gender\":0,\"citizenid\":\"BYV87342\",\"birthdate\":\"1994-06-08\",\"firstname\":\"Sparky\",\"lastname\":\"King\",\"nationality\":\"Canada\"},\"type\":\"item\",\"name\":\"id_card\",\"slot\":1,\"amount\":1},{\"info\":{\"birthdate\":\"1994-06-08\",\"firstname\":\"Sparky\",\"lastname\":\"King\",\"type\":\"Class C Driver License\"},\"type\":\"item\",\"name\":\"driver_license\",\"slot\":2,\"amount\":1},{\"info\":[],\"type\":\"item\",\"name\":\"phone\",\"slot\":3,\"amount\":1},{\"info\":[],\"type\":\"item\",\"name\":\"lockpick\",\"slot\":4,\"amount\":79},{\"info\":[],\"type\":\"item\",\"name\":\"casino_member\",\"slot\":5,\"amount\":1},{\"info\":{\"quality\":100,\"ammo\":0,\"serie\":\"73EsD6OC139ABGP\"},\"type\":\"weapon\",\"name\":\"weapon_bullpupshotgun\",\"slot\":6,\"amount\":1},{\"info\":[],\"type\":\"item\",\"name\":\"casino_vip\",\"slot\":7,\"amount\":1}]', '2024-04-22 20:42:56'),
- (488, 'SSL19978', 3, 'license:3478ecef433d5217ca21145b2bfb0e728b8724b0', 'Bacon_Space', '{\"crypto\":0,\"cash\":2039,\"bank\":40155}', '{\"birthdate\":\"1994-06-08\",\"phone\":\"2421790572\",\"gender\":0,\"account\":\"US01QBCore4598166048\",\"isNew\":true,\"lastname\":\"Admin\",\"firstname\":\"Server\",\"backstory\":\"placeholder backstory\",\"cid\":\"3\",\"nationality\":\"Canada\"}', '{\"label\":\"Law Enforcement\",\"grade\":{\"name\":\"Chief\",\"level\":4},\"payment\":150,\"name\":\"police\",\"isboss\":true,\"type\":\"leo\",\"onduty\":true}', '{\"name\":\"none\",\"label\":\"No Gang Affiliaton\",\"grade\":{\"name\":\"none\",\"level\":0},\"isboss\":false}', '{\"x\":1153.74072265625,\"y\":-326.80877685546877,\"z\":69.197021484375}', '{\"hunger\":94.59999999999997,\"inlaststand\":false,\"phone\":{\"profilepicture\":\"https://kappa.lol/Ss3-t.2024-04-20-1713656574.png\"},\"licences\":{\"business\":false,\"driver\":true,\"weapon\":false},\"isdead\":false,\"injail\":0,\"bloodtype\":\"AB-\",\"callsign\":\"K-11\",\"jobrep\":{\"tow\":0,\"hotdog\":0,\"trucker\":0,\"taxi\":0},\"dealerrep\":0,\"phonedata\":{\"SerialNumber\":63889063,\"InstalledApps\":[]},\"fitbit\":[],\"criminalrecord\":{\"hasRecord\":false},\"tracker\":false,\"craftingrep\":0,\"jailitems\":[],\"stress\":0,\"ishandcuffed\":false,\"walletid\":\"QB-71842115\",\"armor\":0,\"inside\":{\"apartment\":[]},\"thirst\":54.40000000000003,\"attachmentcraftingrep\":0,\"status\":[],\"fingerprint\":\"PC245c42lmN9759\"}', '[{\"amount\":1,\"type\":\"item\",\"slot\":1,\"name\":\"phone\",\"info\":[]},{\"amount\":1,\"type\":\"item\",\"slot\":2,\"name\":\"id_card\",\"info\":{\"citizenid\":\"SSL19978\",\"firstname\":\"Server\",\"nationality\":\"Canada\",\"lastname\":\"Admin\",\"gender\":0,\"birthdate\":\"1994-06-08\"}},{\"amount\":1,\"created\":1713736717,\"type\":\"item\",\"slot\":3,\"name\":\"driver_license\",\"info\":{\"firstname\":\"Server\",\"quality\":100,\"lastname\":\"Admin\",\"birthdate\":\"1994-06-08\",\"type\":\"Class C Driver License\"}},{\"amount\":2,\"created\":1714155290,\"type\":\"item\",\"slot\":4,\"name\":\"lockpick\",\"info\":{\"quality\":100}},{\"amount\":1,\"created\":1713995356,\"type\":\"weapon\",\"slot\":6,\"name\":\"weapon_knife\",\"info\":{\"serie\":\"47Szs8IM182gOZq\",\"quality\":100}},{\"amount\":1,\"created\":1713995360,\"type\":\"weapon\",\"slot\":7,\"name\":\"weapon_bat\",\"info\":{\"serie\":\"77bOu7dN572XvAT\",\"quality\":100}},{\"amount\":1,\"created\":1713995362,\"type\":\"weapon\",\"slot\":8,\"name\":\"weapon_hatchet\",\"info\":{\"serie\":\"21fAS9NG825mfei\",\"quality\":100}}]', '2024-04-26 20:22:39'),
- (33, 'UFQ88534', 2, 'license:3478ecef433d5217ca21145b2bfb0e728b8724b0', 'Bacon_Space', '{\"cash\":0,\"crypto\":0,\"bank\":5706}', '{\"gender\":0,\"nationality\":\"Canada\",\"phone\":\"7196594927\",\"account\":\"US07QBCore8090813475\",\"backstory\":\"placeholder backstory\",\"cid\":2,\"birthdate\":\"1994-06-08\",\"firstname\":\"Devin\",\"lastname\":\"King\"}', '{\"onduty\":true,\"isboss\":false,\"grade\":{\"name\":\"Journalist\",\"level\":0},\"name\":\"reporter\",\"payment\":50,\"label\":\"Reporter\",\"type\":\"none\"}', '{\"name\":\"blackhand\",\"grade\":{\"name\":\"Grandmaster\",\"level\":3},\"label\":\"The Black Hand\",\"isboss\":true}', '{\"x\":1299.6263427734376,\"y\":-1708.0087890625,\"z\":55.076904296875}', '{\"ishandcuffed\":false,\"thirst\":92.4,\"phone\":[],\"craftingrep\":0,\"injail\":0,\"callsign\":\"NO CALLSIGN\",\"criminalrecord\":{\"hasRecord\":false},\"status\":[],\"cardeliveryxp\":0,\"inside\":{\"apartment\":[]},\"jailitems\":[],\"fitbit\":[],\"dealerrep\":0,\"tracker\":false,\"stress\":4,\"hunger\":91.6,\"isdead\":false,\"licences\":{\"business\":false,\"driver\":true,\"weapon\":false},\"walletid\":\"QB-85515212\",\"armor\":0,\"inlaststand\":false,\"fingerprint\":\"nH614F83OKz6032\",\"bloodtype\":\"B-\",\"phonedata\":{\"InstalledApps\":[],\"SerialNumber\":55262045},\"jobrep\":{\"hotdog\":0,\"taxi\":0,\"tow\":0,\"trucker\":0},\"attachmentcraftingrep\":0}', '[{\"info\":[],\"type\":\"item\",\"amount\":1,\"slot\":1,\"name\":\"phone\"},{\"info\":{\"firstname\":\"Devin\",\"type\":\"Class C Driver License\",\"lastname\":\"King\",\"birthdate\":\"1994-06-08\"},\"type\":\"item\",\"amount\":1,\"slot\":2,\"name\":\"driver_license\"},{\"info\":{\"nationality\":\"Canada\",\"gender\":0,\"firstname\":\"Devin\",\"lastname\":\"King\",\"citizenid\":\"UFQ88534\",\"birthdate\":\"1994-06-08\"},\"type\":\"item\",\"amount\":1,\"slot\":3,\"name\":\"id_card\"},{\"info\":[],\"type\":\"item\",\"amount\":1,\"slot\":4,\"name\":\"tunerlaptop\"}]', '2024-04-11 13:31:34'),
- (429, 'UGE35348', 1, 'license:7c6d790889bab7b0a0b8f4e4c1d81dbfe9516f90', 'TFEARZONE', '{\"cash\":500,\"bank\":4660,\"crypto\":0}', '{\"firstname\":\"Michael\",\"birthdate\":\"1989-09-25\",\"gender\":0,\"lastname\":\"Anderson\",\"backstory\":\"placeholder backstory\",\"nationality\":\"British\",\"cid\":\"1\",\"account\":\"US09QBCore8214428943\",\"isNew\":true,\"phone\":\"9875848111\"}', '{\"onduty\":true,\"isboss\":false,\"label\":\"Towing\",\"payment\":50,\"name\":\"tow\",\"grade\":{\"level\":0,\"name\":\"Driver\"},\"type\":\"none\"}', '{\"isboss\":false,\"name\":\"none\",\"label\":\"No Gang Affiliaton\",\"grade\":{\"level\":0,\"name\":\"none\"}}', '{\"x\":-40.36483383178711,\"y\":-1097.116455078125,\"z\":26.4154052734375}', '{\"armor\":0,\"inlaststand\":false,\"fitbit\":[],\"isdead\":false,\"walletid\":\"QB-95796597\",\"callsign\":\"NO CALLSIGN\",\"jailitems\":[],\"stress\":0,\"jobrep\":{\"trucker\":0,\"tow\":0,\"hotdog\":0,\"taxi\":0},\"phone\":[],\"status\":[],\"licences\":{\"driver\":true,\"weapon\":false,\"business\":false},\"craftingrep\":0,\"attachmentcraftingrep\":0,\"hunger\":36.99999999999996,\"injail\":0,\"criminalrecord\":{\"hasRecord\":false},\"bloodtype\":\"A-\",\"thirst\":43.00000000000004,\"ishandcuffed\":false,\"tracker\":false,\"fingerprint\":\"Hi897Q67ZXd0403\",\"inside\":{\"apartment\":[]},\"dealerrep\":0,\"phonedata\":{\"SerialNumber\":16899837,\"InstalledApps\":[]}}', '[{\"slot\":39,\"name\":\"id_card\",\"info\":{\"lastname\":\"Anderson\",\"birthdate\":\"1989-09-25\",\"nationality\":\"British\",\"citizenid\":\"UGE35348\",\"gender\":0,\"firstname\":\"Michael\"},\"type\":\"item\",\"amount\":1},{\"slot\":40,\"name\":\"phone\",\"info\":[],\"type\":\"item\",\"amount\":1},{\"slot\":38,\"name\":\"driver_license\",\"info\":{\"type\":\"Class C Driver License\",\"birthdate\":\"1989-09-25\",\"lastname\":\"Anderson\",\"firstname\":\"Michael\"},\"type\":\"item\",\"amount\":1}]', '2024-04-20 19:41:59');
- -- --------------------------------------------------------
- --
- -- Table structure for table `playerskins`
- --
- CREATE TABLE `playerskins` (
- `id` INT(11) NOT NULL,
- `citizenid` VARCHAR(11) NOT NULL,
- `model` VARCHAR(255) NOT NULL,
- `skin` text NOT NULL,
- `active` tinyint(4) NOT NULL DEFAULT 1
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- --
- -- Dumping data for table `playerskins`
- --
- INSERT INTO `playerskins` (`id`, `citizenid`, `model`, `skin`, `active`) VALUES
- (4, 'UFQ88534', '1885233650', '{\"eyebrown_forward\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"nose_2\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"vest\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"eye_color\":{\"defaultItem\":-1,\"texture\":0,\"item\":7,\"defaultTexture\":0},\"mask\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"cheek_2\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"eyebrows\":{\"defaultItem\":-1,\"texture\":1,\"item\":-1,\"defaultTexture\":1},\"pants\":{\"defaultItem\":0,\"texture\":0,\"item\":1,\"defaultTexture\":0},\"facemix\":{\"skinMix\":0,\"shapeMix\":0,\"defaultSkinMix\":0.0,\"defaultShapeMix\":0.0},\"nose_3\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"jaw_bone_back_lenght\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"eyebrown_high\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"neck_thikness\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"hair\":{\"defaultItem\":0,\"texture\":7,\"item\":20,\"defaultTexture\":0},\"torso2\":{\"defaultItem\":0,\"texture\":0,\"item\":86,\"defaultTexture\":0},\"cheek_3\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"cheek_1\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"face2\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"arms\":{\"defaultItem\":0,\"texture\":0,\"item\":4,\"defaultTexture\":0},\"chimp_hole\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"chimp_bone_width\":{\"defaultItem\":0,\"texture\":0,\"item\":7,\"defaultTexture\":0},\"makeup\":{\"defaultItem\":-1,\"texture\":1,\"item\":-1,\"defaultTexture\":1},\"chimp_bone_lenght\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"nose_0\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"blush\":{\"defaultItem\":-1,\"texture\":1,\"item\":-1,\"defaultTexture\":1},\"hat\":{\"defaultItem\":-1,\"texture\":0,\"item\":-1,\"defaultTexture\":0},\"ageing\":{\"defaultItem\":-1,\"texture\":0,\"item\":-1,\"defaultTexture\":0},\"chimp_bone_lowering\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"shoes\":{\"defaultItem\":1,\"texture\":0,\"item\":25,\"defaultTexture\":0},\"lipstick\":{\"defaultItem\":-1,\"texture\":1,\"item\":-1,\"defaultTexture\":1},\"accessory\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"bag\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"beard\":{\"defaultItem\":-1,\"texture\":1,\"item\":-1,\"defaultTexture\":1},\"nose_4\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"ear\":{\"defaultItem\":-1,\"texture\":0,\"item\":-1,\"defaultTexture\":0},\"eye_opening\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"decals\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"lips_thickness\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"moles\":{\"defaultItem\":-1,\"texture\":0,\"item\":-1,\"defaultTexture\":0},\"glass\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"nose_1\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"bracelet\":{\"defaultItem\":-1,\"texture\":0,\"item\":1,\"defaultTexture\":0},\"face\":{\"defaultItem\":0,\"texture\":0,\"item\":7,\"defaultTexture\":0},\"watch\":{\"defaultItem\":-1,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"jaw_bone_width\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0},\"t-shirt\":{\"defaultItem\":1,\"texture\":0,\"item\":-1,\"defaultTexture\":0},\"nose_5\":{\"defaultItem\":0,\"texture\":0,\"item\":0,\"defaultTexture\":0}}', 1),
- (5, 'BYV87342', '1885233650', '{\"nose_2\":{\"texture\":0,\"defaultItem\":0,\"item\":1,\"defaultTexture\":0},\"ageing\":{\"texture\":0,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":0},\"vest\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"hat\":{\"texture\":0,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":0},\"blush\":{\"texture\":1,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":1},\"nose_1\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"nose_5\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"jaw_bone_back_lenght\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"shoes\":{\"texture\":0,\"defaultItem\":1,\"item\":81,\"defaultTexture\":0},\"cheek_3\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"torso2\":{\"texture\":0,\"defaultItem\":0,\"item\":413,\"defaultTexture\":0},\"face\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"mask\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"nose_3\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"eye_opening\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"makeup\":{\"texture\":1,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":1},\"watch\":{\"texture\":0,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":0},\"bag\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"cheek_1\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"facemix\":{\"skinMix\":0,\"defaultShapeMix\":0.0,\"defaultSkinMix\":0.0,\"shapeMix\":0},\"face2\":{\"texture\":0,\"defaultItem\":0,\"item\":1,\"defaultTexture\":0},\"bracelet\":{\"texture\":0,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":0},\"beard\":{\"texture\":1,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":1},\"nose_0\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"decals\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"chimp_bone_width\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"nose_4\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"eyebrown_forward\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"lips_thickness\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"accessory\":{\"texture\":0,\"defaultItem\":0,\"item\":50,\"defaultTexture\":0},\"moles\":{\"texture\":0,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":0},\"eyebrows\":{\"texture\":4,\"defaultItem\":-1,\"item\":9,\"defaultTexture\":1},\"chimp_hole\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"ear\":{\"texture\":0,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":0},\"arms\":{\"texture\":0,\"defaultItem\":0,\"item\":6,\"defaultTexture\":0},\"jaw_bone_width\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"hair\":{\"texture\":6,\"defaultItem\":0,\"item\":18,\"defaultTexture\":0},\"eyebrown_high\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"neck_thikness\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"eye_color\":{\"texture\":0,\"defaultItem\":-1,\"item\":8,\"defaultTexture\":0},\"t-shirt\":{\"texture\":0,\"defaultItem\":1,\"item\":15,\"defaultTexture\":0},\"pants\":{\"texture\":0,\"defaultItem\":0,\"item\":7,\"defaultTexture\":0},\"glass\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"chimp_bone_lenght\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"lipstick\":{\"texture\":1,\"defaultItem\":-1,\"item\":-1,\"defaultTexture\":1},\"cheek_2\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0},\"chimp_bone_lowering\":{\"texture\":0,\"defaultItem\":0,\"item\":0,\"defaultTexture\":0}}', 1),
- (8, 'UGE35348', '1885233650', '{\"accessory\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"t-shirt\":{\"defaultTexture\":0,\"item\":72,\"defaultItem\":1,\"texture\":4},\"nose_5\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"cheek_1\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"hair\":{\"defaultTexture\":0,\"item\":19,\"defaultItem\":0,\"texture\":20},\"torso2\":{\"defaultTexture\":0,\"item\":6,\"defaultItem\":0,\"texture\":11},\"face\":{\"defaultTexture\":0,\"item\":43,\"defaultItem\":0,\"texture\":0},\"arms\":{\"defaultTexture\":0,\"item\":179,\"defaultItem\":0,\"texture\":5},\"nose_1\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"nose_2\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"cheek_2\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"neck_thikness\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"eye_color\":{\"defaultTexture\":0,\"item\":-1,\"defaultItem\":-1,\"texture\":0},\"chimp_bone_width\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"lipstick\":{\"defaultTexture\":1,\"item\":-1,\"defaultItem\":-1,\"texture\":0},\"bracelet\":{\"defaultTexture\":0,\"item\":-1,\"defaultItem\":-1,\"texture\":0},\"pants\":{\"defaultTexture\":0,\"item\":76,\"defaultItem\":0,\"texture\":5},\"decals\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"chimp_bone_lenght\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"ageing\":{\"defaultTexture\":0,\"item\":-1,\"defaultItem\":-1,\"texture\":0},\"eye_opening\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"lips_thickness\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"moles\":{\"defaultTexture\":0,\"item\":-1,\"defaultItem\":-1,\"texture\":0},\"eyebrown_high\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"jaw_bone_width\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"eyebrown_forward\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"cheek_3\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"hat\":{\"defaultTexture\":0,\"item\":-1,\"defaultItem\":-1,\"texture\":0},\"eyebrows\":{\"defaultTexture\":1,\"item\":-1,\"defaultItem\":-1,\"texture\":1},\"nose_3\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"nose_0\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"chimp_hole\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"beard\":{\"defaultTexture\":1,\"item\":10,\"defaultItem\":-1,\"texture\":2},\"mask\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"chimp_bone_lowering\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"shoes\":{\"defaultTexture\":0,\"item\":71,\"defaultItem\":1,\"texture\":1},\"watch\":{\"defaultTexture\":0,\"item\":-1,\"defaultItem\":-1,\"texture\":0},\"bag\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"makeup\":{\"defaultTexture\":1,\"item\":-1,\"defaultItem\":-1,\"texture\":1},\"glass\":{\"defaultTexture\":0,\"item\":15,\"defaultItem\":0,\"texture\":9},\"face2\":{\"defaultTexture\":0,\"item\":42,\"defaultItem\":0,\"texture\":0},\"nose_4\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"facemix\":{\"shapeMix\":0.68,\"skinMix\":0.48,\"defaultShapeMix\":0.0,\"defaultSkinMix\":0.0},\"ear\":{\"defaultTexture\":0,\"item\":-1,\"defaultItem\":-1,\"texture\":0},\"blush\":{\"defaultTexture\":1,\"item\":-1,\"defaultItem\":-1,\"texture\":1},\"jaw_bone_back_lenght\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0},\"vest\":{\"defaultTexture\":0,\"item\":0,\"defaultItem\":0,\"texture\":0}}', 1),
- (12, 'SSL19978', '1885233650', '{\"neck_thikness\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"nose_0\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"face2\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"nose_2\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"arms\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":20},\"accessory\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"chimp_hole\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"cheek_3\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"jaw_bone_width\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"nose_1\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"eyebrown_forward\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"hat\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":58},\"bracelet\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":1},\"nose_4\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"beard\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1},\"shoes\":{\"defaultItem\":1,\"defaultTexture\":0,\"texture\":0,\"item\":51},\"lipstick\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1},\"nose_5\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"facemix\":{\"defaultSkinMix\":0.0,\"shapeMix\":0,\"skinMix\":0,\"defaultShapeMix\":0.0},\"moles\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"eyebrown_high\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"vest\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"cheek_2\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"lips_thickness\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"eye_color\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"ageing\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"chimp_bone_width\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"watch\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"makeup\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1},\"cheek_1\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"glass\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"bag\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"decals\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"t-shirt\":{\"defaultItem\":1,\"defaultTexture\":0,\"texture\":0,\"item\":58},\"face\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"hair\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":9,\"item\":10},\"pants\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":24},\"chimp_bone_lowering\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"ear\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"eye_opening\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"blush\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1},\"nose_3\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"torso2\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":3,\"item\":317},\"mask\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"jaw_bone_back_lenght\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"chimp_bone_lenght\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"eyebrows\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1}}', 1);
- -- --------------------------------------------------------
- --
- -- Table structure for table `player_contacts`
- --
- CREATE TABLE `player_contacts` (
- `id` INT(11) NOT NULL,
- `citizenid` VARCHAR(11) DEFAULT NULL,
- `name` VARCHAR(50) DEFAULT NULL,
- `number` VARCHAR(50) DEFAULT NULL,
- `iban` VARCHAR(50) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `player_houses`
- --
- CREATE TABLE `player_houses` (
- `id` INT(255) NOT NULL,
- `house` VARCHAR(50) NOT NULL,
- `identifier` VARCHAR(50) DEFAULT NULL,
- `citizenid` VARCHAR(11) DEFAULT NULL,
- `keyholders` text DEFAULT NULL,
- `decorations` text DEFAULT NULL,
- `stash` text DEFAULT NULL,
- `outfit` text DEFAULT NULL,
- `logout` text DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `player_mails`
- --
- CREATE TABLE `player_mails` (
- `id` INT(11) NOT NULL,
- `citizenid` VARCHAR(11) DEFAULT NULL,
- `sender` VARCHAR(50) DEFAULT NULL,
- `subject` VARCHAR(50) DEFAULT NULL,
- `message` text DEFAULT NULL,
- `read` tinyint(4) DEFAULT 0,
- `mailid` INT(11) DEFAULT NULL,
- `date` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP(),
- `button` text DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- --
- -- Dumping data for table `player_mails`
- --
- INSERT INTO `player_mails` (`id`, `citizenid`, `sender`, `subject`, `message`, `read`, `mailid`, `date`, `button`) VALUES
- (1, 'DJD56142', 'Township', 'Driving lessons request', 'Hello,<br><br>We have just received a message that someone wants to take driving lessons.<br>If you are willing to teach, please contact them:<br>Name: <strong>Sparky King<br />Phone Number: <strong>1628475836</strong><br><br>Kind regards,<br>Township Los Santos', 0, 756400, '2024-04-08 03:29:34', '[]'),
- (2, 'DXT09752', 'Township', 'Driving lessons request', 'Hello,<br><br>We have just received a message that someone wants to take driving lessons.<br>If you are willing to teach, please contact them:<br>Name: <strong>Sparky King<br />Phone Number: <strong>1628475836</strong><br><br>Kind regards,<br>Township Los Santos', 0, 760214, '2024-04-08 03:29:34', '[]'),
- (3, 'SRI85140', 'Township', 'Driving lessons request', 'Hello,<br><br>We have just received a message that someone wants to take driving lessons.<br>If you are willing to teach, please contact them:<br>Name: <strong>Sparky King<br />Phone Number: <strong>1628475836</strong><br><br>Kind regards,<br>Township Los Santos', 0, 311054, '2024-04-08 03:29:34', '[]'),
- (9, 'DJD56142', 'Township', 'Driving lessons request', 'Hello,<br><br>We have just received a message that someone wants to take driving lessons.<br>If you are willing to teach, please contact them:<br>Name: <strong>Server Admin<br />Phone Number: <strong>2421790572</strong><br><br>Kind regards,<br>Township Los Santos', 0, 752068, '2024-04-24 21:51:09', '[]'),
- (10, 'DXT09752', 'Township', 'Driving lessons request', 'Hello,<br><br>We have just received a message that someone wants to take driving lessons.<br>If you are willing to teach, please contact them:<br>Name: <strong>Server Admin<br />Phone Number: <strong>2421790572</strong><br><br>Kind regards,<br>Township Los Santos', 0, 731652, '2024-04-24 21:51:09', '[]'),
- (11, 'SRI85140', 'Township', 'Driving lessons request', 'Hello,<br><br>We have just received a message that someone wants to take driving lessons.<br>If you are willing to teach, please contact them:<br>Name: <strong>Server Admin<br />Phone Number: <strong>2421790572</strong><br><br>Kind regards,<br>Township Los Santos', 0, 713018, '2024-04-24 21:51:09', '[]');
- -- --------------------------------------------------------
- --
- -- Table structure for table `player_outfits`
- --
- CREATE TABLE `player_outfits` (
- `id` INT(11) NOT NULL,
- `citizenid` VARCHAR(11) DEFAULT NULL,
- `outfitname` VARCHAR(50) NOT NULL,
- `model` VARCHAR(50) DEFAULT NULL,
- `skin` text DEFAULT NULL,
- `outfitId` VARCHAR(50) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- --
- -- Dumping data for table `player_outfits`
- --
- INSERT INTO `player_outfits` (`id`, `citizenid`, `outfitname`, `model`, `skin`, `outfitId`) VALUES
- (1, 'BYV87342', 'Sparky', '1885233650', '{\"t-shirt\":{\"defaultTexture\":0,\"item\":15,\"texture\":0,\"defaultItem\":1},\"moles\":{\"defaultTexture\":0,\"item\":-1,\"texture\":0,\"defaultItem\":-1},\"cheek_3\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"eyebrows\":{\"defaultTexture\":1,\"item\":9,\"texture\":4,\"defaultItem\":-1},\"watch\":{\"defaultTexture\":0,\"item\":-1,\"texture\":0,\"defaultItem\":-1},\"ageing\":{\"defaultTexture\":0,\"item\":-1,\"texture\":0,\"defaultItem\":-1},\"nose_3\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"nose_1\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"cheek_1\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"eyebrown_high\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"chimp_bone_lenght\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"makeup\":{\"defaultTexture\":1,\"item\":-1,\"texture\":1,\"defaultItem\":-1},\"eyebrown_forward\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"bracelet\":{\"defaultTexture\":0,\"item\":-1,\"texture\":0,\"defaultItem\":-1},\"chimp_bone_width\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"nose_0\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"torso2\":{\"defaultTexture\":0,\"item\":413,\"texture\":0,\"defaultItem\":0},\"face2\":{\"defaultTexture\":0,\"item\":1,\"texture\":0,\"defaultItem\":0},\"shoes\":{\"defaultTexture\":0,\"item\":81,\"texture\":0,\"defaultItem\":1},\"nose_2\":{\"defaultTexture\":0,\"item\":1,\"texture\":0,\"defaultItem\":0},\"vest\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"jaw_bone_width\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"facemix\":{\"shapeMix\":0,\"skinMix\":0,\"defaultShapeMix\":0.0,\"defaultSkinMix\":0.0},\"beard\":{\"defaultTexture\":1,\"item\":-1,\"texture\":1,\"defaultItem\":-1},\"accessory\":{\"defaultTexture\":0,\"item\":50,\"texture\":0,\"defaultItem\":0},\"hat\":{\"defaultTexture\":0,\"item\":-1,\"texture\":0,\"defaultItem\":-1},\"nose_4\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"pants\":{\"defaultTexture\":0,\"item\":7,\"texture\":0,\"defaultItem\":0},\"jaw_bone_back_lenght\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"decals\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"nose_5\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"chimp_hole\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"neck_thikness\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"chimp_bone_lowering\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"bag\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"eye_opening\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"lips_thickness\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"hair\":{\"defaultTexture\":0,\"item\":18,\"texture\":6,\"defaultItem\":0},\"mask\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"face\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"ear\":{\"defaultTexture\":0,\"item\":-1,\"texture\":0,\"defaultItem\":-1},\"lipstick\":{\"defaultTexture\":1,\"item\":-1,\"texture\":1,\"defaultItem\":-1},\"glass\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"arms\":{\"defaultTexture\":0,\"item\":6,\"texture\":0,\"defaultItem\":0},\"eye_color\":{\"defaultTexture\":0,\"item\":8,\"texture\":0,\"defaultItem\":-1},\"cheek_2\":{\"defaultTexture\":0,\"item\":0,\"texture\":0,\"defaultItem\":0},\"blush\":{\"defaultTexture\":1,\"item\":-1,\"texture\":1,\"defaultItem\":-1}}', 'outfit-6-6238'),
- (2, 'UFQ88534', 'Daven King', '1885233650', '{\"nose_3\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"chimp_hole\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"blush\":{\"item\":-1,\"defaultTexture\":1,\"texture\":1,\"defaultItem\":-1},\"shoes\":{\"item\":25,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":1},\"cheek_1\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"t-shirt\":{\"item\":-1,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":1},\"decals\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"lipstick\":{\"item\":-1,\"defaultTexture\":1,\"texture\":1,\"defaultItem\":-1},\"beard\":{\"item\":-1,\"defaultTexture\":1,\"texture\":1,\"defaultItem\":-1},\"moles\":{\"item\":-1,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":-1},\"nose_1\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"chimp_bone_lowering\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"ear\":{\"item\":-1,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":-1},\"cheek_2\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"eyebrows\":{\"item\":-1,\"defaultTexture\":1,\"texture\":1,\"defaultItem\":-1},\"vest\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"eye_color\":{\"item\":7,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":-1},\"mask\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"ageing\":{\"item\":-1,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":-1},\"neck_thikness\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"nose_4\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"eyebrown_forward\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"arms\":{\"item\":4,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"bag\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"pants\":{\"item\":1,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"jaw_bone_width\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"glass\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"eyebrown_high\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"hat\":{\"item\":-1,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":-1},\"eye_opening\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"hair\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"makeup\":{\"item\":-1,\"defaultTexture\":1,\"texture\":1,\"defaultItem\":-1},\"nose_2\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"facemix\":{\"defaultShapeMix\":0.0,\"skinMix\":0,\"shapeMix\":0,\"defaultSkinMix\":0.0},\"nose_5\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"chimp_bone_width\":{\"item\":7,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"nose_0\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"bracelet\":{\"item\":1,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":-1},\"face2\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"watch\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":-1},\"jaw_bone_back_lenght\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"chimp_bone_lenght\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"torso2\":{\"item\":86,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"cheek_3\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"accessory\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"lips_thickness\":{\"item\":0,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0},\"face\":{\"item\":7,\"defaultTexture\":0,\"texture\":0,\"defaultItem\":0}}', 'outfit-10-9340'),
- (3, 'UFQ88534', 'Devin King', '1885233650', '{\"hair\":{\"defaultItem\":0,\"texture\":7,\"defaultTexture\":0,\"item\":20},\"chimp_bone_width\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":7},\"cheek_1\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"eyebrown_high\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"nose_2\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"nose_3\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"nose_4\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"face2\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"moles\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"hat\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"eyebrown_forward\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"facemix\":{\"skinMix\":0,\"defaultShapeMix\":0.0,\"defaultSkinMix\":0.0,\"shapeMix\":0},\"arms\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":4},\"nose_0\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"blush\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"decals\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"chimp_hole\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"mask\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"makeup\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"t-shirt\":{\"defaultItem\":1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"bag\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"torso2\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":86},\"jaw_bone_back_lenght\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"accessory\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"eyebrows\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"eye_color\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":7},\"beard\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"lips_thickness\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"cheek_3\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"face\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":7},\"watch\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"jaw_bone_width\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"chimp_bone_lenght\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"bracelet\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":1},\"ear\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"nose_1\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"glass\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"lipstick\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"cheek_2\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"vest\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"shoes\":{\"defaultItem\":1,\"texture\":0,\"defaultTexture\":0,\"item\":25},\"nose_5\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"neck_thikness\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"eye_opening\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"pants\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":1},\"chimp_bone_lowering\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"ageing\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1}}', 'outfit-9-6712'),
- (4, 'BYV87342', 'Sparky', '1885233650', '{\"hair\":{\"defaultItem\":0,\"texture\":6,\"defaultTexture\":0,\"item\":18},\"chimp_bone_width\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"cheek_1\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"eyebrown_high\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"nose_2\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":1},\"nose_3\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"lips_thickness\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"face2\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":1},\"moles\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"hat\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"eyebrown_forward\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"facemix\":{\"skinMix\":0,\"shapeMix\":0,\"defaultSkinMix\":0.0,\"defaultShapeMix\":0.0},\"arms\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":6},\"nose_0\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"blush\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"decals\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"bracelet\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"mask\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"makeup\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"t-shirt\":{\"defaultItem\":1,\"texture\":0,\"defaultTexture\":0,\"item\":15},\"bag\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"torso2\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":413},\"jaw_bone_back_lenght\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"accessory\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":50},\"eyebrows\":{\"defaultItem\":-1,\"texture\":4,\"defaultTexture\":1,\"item\":9},\"eye_color\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":8},\"beard\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"chimp_bone_lowering\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"cheek_3\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"face\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"chimp_hole\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"jaw_bone_width\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"chimp_bone_lenght\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"glass\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"ear\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"watch\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"neck_thikness\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"lipstick\":{\"defaultItem\":-1,\"texture\":1,\"defaultTexture\":1,\"item\":-1},\"cheek_2\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"vest\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"shoes\":{\"defaultItem\":1,\"texture\":0,\"defaultTexture\":0,\"item\":81},\"nose_5\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"nose_1\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"ageing\":{\"defaultItem\":-1,\"texture\":0,\"defaultTexture\":0,\"item\":-1},\"pants\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":7},\"nose_4\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0},\"eye_opening\":{\"defaultItem\":0,\"texture\":0,\"defaultTexture\":0,\"item\":0}}', 'outfit-2-6982'),
- (5, 'SSL19978', 'Server Admin', '1885233650', '{\"eye_opening\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"pants\":{\"defaultItem\":0,\"item\":71,\"texture\":0,\"defaultTexture\":0},\"arms\":{\"defaultItem\":0,\"item\":18,\"texture\":0,\"defaultTexture\":0},\"jaw_bone_width\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"cheek_3\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"lipstick\":{\"defaultItem\":-1,\"item\":-1,\"texture\":1,\"defaultTexture\":1},\"beard\":{\"defaultItem\":-1,\"item\":-1,\"texture\":1,\"defaultTexture\":1},\"glass\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"bag\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"mask\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"watch\":{\"defaultItem\":-1,\"item\":-1,\"texture\":0,\"defaultTexture\":0},\"hair\":{\"defaultItem\":0,\"item\":10,\"texture\":9,\"defaultTexture\":0},\"eyebrows\":{\"defaultItem\":-1,\"item\":-1,\"texture\":1,\"defaultTexture\":1},\"eye_color\":{\"defaultItem\":-1,\"item\":-1,\"texture\":0,\"defaultTexture\":0},\"nose_1\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"face\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"bracelet\":{\"defaultItem\":-1,\"item\":1,\"texture\":0,\"defaultTexture\":0},\"chimp_bone_lenght\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"cheek_2\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"facemix\":{\"defaultSkinMix\":0.0,\"shapeMix\":0,\"defaultShapeMix\":0.0,\"skinMix\":0},\"hat\":{\"defaultItem\":-1,\"item\":-1,\"texture\":0,\"defaultTexture\":0},\"moles\":{\"defaultItem\":-1,\"item\":-1,\"texture\":0,\"defaultTexture\":0},\"eyebrown_high\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"chimp_hole\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"nose_5\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"ageing\":{\"defaultItem\":-1,\"item\":-1,\"texture\":0,\"defaultTexture\":0},\"nose_4\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"neck_thikness\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"ear\":{\"defaultItem\":-1,\"item\":-1,\"texture\":0,\"defaultTexture\":0},\"decals\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"nose_0\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"lips_thickness\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"t-shirt\":{\"defaultItem\":1,\"item\":10,\"texture\":2,\"defaultTexture\":0},\"shoes\":{\"defaultItem\":1,\"item\":1,\"texture\":0,\"defaultTexture\":0},\"eyebrown_forward\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"cheek_1\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"vest\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"makeup\":{\"defaultItem\":-1,\"item\":-1,\"texture\":1,\"defaultTexture\":1},\"jaw_bone_back_lenght\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"accessory\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"blush\":{\"defaultItem\":-1,\"item\":-1,\"texture\":1,\"defaultTexture\":1},\"torso2\":{\"defaultItem\":0,\"item\":118,\"texture\":0,\"defaultTexture\":0},\"nose_2\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"chimp_bone_width\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"face2\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"chimp_bone_lowering\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0},\"nose_3\":{\"defaultItem\":0,\"item\":0,\"texture\":0,\"defaultTexture\":0}}', 'outfit-10-6454'),
- (6, 'SSL19978', 'Cop', '1885233650', '{\"decals\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"eye_opening\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"makeup\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1},\"eyebrown_forward\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"neck_thikness\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"nose_2\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"nose_0\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"hair\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":9,\"item\":10},\"cheek_3\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"ear\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"eyebrown_high\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"vest\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"jaw_bone_width\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"watch\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"face2\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"beard\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1},\"jaw_bone_back_lenght\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"arms\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":20},\"torso2\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":8,\"item\":317},\"face\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"cheek_1\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"facemix\":{\"defaultShapeMix\":0.0,\"shapeMix\":0,\"defaultSkinMix\":0.0,\"skinMix\":0},\"hat\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":3,\"item\":58},\"bracelet\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":1},\"chimp_bone_lenght\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"chimp_bone_width\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"cheek_2\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"nose_3\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"moles\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"nose_4\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"ageing\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"glass\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"t-shirt\":{\"defaultItem\":1,\"defaultTexture\":0,\"texture\":0,\"item\":58},\"chimp_bone_lowering\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"nose_1\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"shoes\":{\"defaultItem\":1,\"defaultTexture\":0,\"texture\":0,\"item\":51},\"eye_color\":{\"defaultItem\":-1,\"defaultTexture\":0,\"texture\":0,\"item\":-1},\"bag\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"mask\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"pants\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":24},\"lipstick\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1},\"lips_thickness\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"accessory\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"chimp_hole\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"nose_5\":{\"defaultItem\":0,\"defaultTexture\":0,\"texture\":0,\"item\":0},\"blush\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1},\"eyebrows\":{\"defaultItem\":-1,\"defaultTexture\":1,\"texture\":1,\"item\":-1}}', 'outfit-7-5491'),
- (7, 'SSL19978', 'Server Admin', '1885233650', '{\"eyebrown_high\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"nose_2\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"cheek_1\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"chimp_hole\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"bracelet\":{\"texture\":0,\"item\":1,\"defaultItem\":-1,\"defaultTexture\":0},\"moles\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"jaw_bone_width\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"facemix\":{\"shapeMix\":0,\"skinMix\":0,\"defaultShapeMix\":0.0,\"defaultSkinMix\":0.0},\"mask\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"nose_5\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"ear\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"accessory\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"beard\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"torso2\":{\"texture\":0,\"item\":118,\"defaultItem\":0,\"defaultTexture\":0},\"nose_3\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"glass\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"vest\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"chimp_bone_width\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"neck_thikness\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"nose_4\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"decals\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"blush\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"bag\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"ageing\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"t-shirt\":{\"texture\":2,\"item\":10,\"defaultItem\":1,\"defaultTexture\":0},\"face\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"lipstick\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"nose_0\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"watch\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"lips_thickness\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"pants\":{\"texture\":0,\"item\":71,\"defaultItem\":0,\"defaultTexture\":0},\"eyebrows\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"face2\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"eye_opening\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"chimp_bone_lowering\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"cheek_2\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"eyebrown_forward\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"jaw_bone_back_lenght\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"chimp_bone_lenght\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"nose_1\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"hat\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"makeup\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"arms\":{\"texture\":0,\"item\":18,\"defaultItem\":0,\"defaultTexture\":0},\"cheek_3\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"shoes\":{\"texture\":0,\"item\":1,\"defaultItem\":1,\"defaultTexture\":0},\"hair\":{\"texture\":9,\"item\":10,\"defaultItem\":0,\"defaultTexture\":0},\"eye_color\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0}}', 'outfit-6-4127'),
- (8, 'SSL19978', 'Server Cop', '1885233650', '{\"eyebrown_high\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"arms\":{\"texture\":0,\"item\":20,\"defaultItem\":0,\"defaultTexture\":0},\"cheek_1\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"chimp_hole\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"bracelet\":{\"texture\":0,\"item\":1,\"defaultItem\":-1,\"defaultTexture\":0},\"moles\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"jaw_bone_width\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"facemix\":{\"shapeMix\":0,\"skinMix\":0,\"defaultShapeMix\":0.0,\"defaultSkinMix\":0.0},\"shoes\":{\"texture\":0,\"item\":51,\"defaultItem\":1,\"defaultTexture\":0},\"nose_5\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"ear\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"accessory\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"beard\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"torso2\":{\"texture\":3,\"item\":317,\"defaultItem\":0,\"defaultTexture\":0},\"nose_3\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"glass\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"vest\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"chimp_bone_width\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"neck_thikness\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"decals\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"eye_color\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"blush\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"bag\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"ageing\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"t-shirt\":{\"texture\":0,\"item\":58,\"defaultItem\":1,\"defaultTexture\":0},\"face\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"lipstick\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"watch\":{\"texture\":0,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":0},\"nose_2\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"lips_thickness\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"pants\":{\"texture\":0,\"item\":24,\"defaultItem\":0,\"defaultTexture\":0},\"eyebrows\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"face2\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"chimp_bone_lowering\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"eye_opening\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"cheek_2\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"eyebrown_forward\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"jaw_bone_back_lenght\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"nose_1\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"nose_0\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"hat\":{\"texture\":0,\"item\":58,\"defaultItem\":-1,\"defaultTexture\":0},\"makeup\":{\"texture\":1,\"item\":-1,\"defaultItem\":-1,\"defaultTexture\":1},\"mask\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"cheek_3\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"chimp_bone_lenght\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0},\"hair\":{\"texture\":9,\"item\":10,\"defaultItem\":0,\"defaultTexture\":0},\"nose_4\":{\"texture\":0,\"item\":0,\"defaultItem\":0,\"defaultTexture\":0}}', 'outfit-9-8508');
- -- --------------------------------------------------------
- --
- -- Table structure for table `player_vehicles`
- --
- CREATE TABLE `player_vehicles` (
- `id` INT(11) NOT NULL,
- `license` VARCHAR(50) DEFAULT NULL,
- `citizenid` VARCHAR(50) DEFAULT NULL,
- `vehicle` VARCHAR(50) DEFAULT NULL,
- `hash` VARCHAR(50) DEFAULT NULL,
- `mods` longtext DEFAULT NULL,
- `plate` VARCHAR(50) NOT NULL,
- `fakeplate` VARCHAR(50) DEFAULT NULL,
- `garage` VARCHAR(50) DEFAULT NULL,
- `fuel` INT(11) DEFAULT 100,
- `engine` FLOAT DEFAULT 1000,
- `body` FLOAT DEFAULT 1000,
- `state` INT(11) DEFAULT 1,
- `depotprice` INT(11) NOT NULL DEFAULT 0,
- `drivingdistance` INT(50) DEFAULT NULL,
- `status` text DEFAULT NULL,
- `balance` INT(11) NOT NULL DEFAULT 0,
- `paymentamount` INT(11) NOT NULL DEFAULT 0,
- `paymentsleft` INT(11) NOT NULL DEFAULT 0,
- `financetime` INT(11) NOT NULL DEFAULT 0
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- --
- -- Dumping data for table `player_vehicles`
- --
- INSERT INTO `player_vehicles` (`id`, `license`, `citizenid`, `vehicle`, `hash`, `mods`, `plate`, `fakeplate`, `garage`, `fuel`, `engine`, `body`, `state`, `depotprice`, `drivingdistance`, `status`, `balance`, `paymentamount`, `paymentsleft`, `financetime`) VALUES
- (8, 'license:3478ecef433d5217ca21145b2bfb0e728b8724b0', 'UFQ88534', 'tampa', '972671128', '{\"color2\":0,\"modSmokeEnabled\":false,\"dirtLevel\":0.0,\"modArmor\":-1,\"modSpeakers\":-1,\"modWindows\":-1,\"windowStatus\":{\"1\":true,\"2\":true,\"3\":true,\"4\":false,\"5\":false,\"6\":true,\"7\":true,\"0\":true},\"modPlateHolder\":-1,\"neonEnabled\":[false,false,false,false],\"modFender\":-1,\"modCustomTiresF\":false,\"plate\":\"3PM529YQ\",\"modBrakes\":-1,\"modAPlate\":-1,\"modBackWheels\":-1,\"modTransmission\":-1,\"modHydrolic\":-1,\"modTurbo\":false,\"windowTint\":-1,\"pearlescentColor\":0,\"modKit21\":-1,\"modDial\":-1,\"modShifterLeavers\":-1,\"plateIndex\":0,\"modTrimA\":-1,\"wheelColor\":0,\"modCustomTiresR\":false,\"modTrunk\":-1,\"modHood\":-1,\"modTrimB\":-1,\"modKit19\":-1,\"modDoorSpeaker\":-1,\"doorStatus\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"modSpoilers\":-1,\"modVanityPlate\":-1,\"modSteeringWheel\":-1,\"modSuspension\":-1,\"modSideSkirt\":-1,\"modExhaust\":-1,\"modOrnaments\":-1,\"liveryRoof\":-1,\"modRightFender\":-1,\"modLivery\":-1,\"modAirFilter\":-1,\"wheels\":1,\"tireBurstCompletely\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"modKit17\":-1,\"neonColor\":[255,255,255],\"model\":972671128,\"wheelSize\":1.0,\"modDashboard\":-1,\"tireBurstState\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"dashboardColor\":0,\"extras\":[],\"modKit49\":-1,\"modStruts\":-1,\"modTank\":-1,\"modAerials\":-1,\"engineHealth\":992.1159651706275,\"tireHealth\":{\"1\":1000.0,\"2\":1000.0,\"3\":1000.0,\"0\":1000.0},\"modEngine\":-1,\"bodyHealth\":995.2932781095246,\"wheelWidth\":1.0,\"modGrille\":-1,\"oilLevel\":4.76596940834568,\"tyreSmokeColor\":[255,255,255],\"color1\":17,\"modFrontWheels\":-1,\"modFrontBumper\":-1,\"fuelLevel\":84.19879288077384,\"modFrame\":-1,\"modRearBumper\":-1,\"modSeats\":-1,\"modHorns\":-1,\"modXenon\":false,\"modEngineBlock\":-1,\"modRoof\":-1,\"tankHealth\":999.2649192831461,\"xenonColor\":255,\"interiorColor\":0,\"modKit47\":-1,\"modArchCover\":-1}', '3PM529YQ', NULL, 'bennys', 84, 993, 996, 1, 0, NULL, '{\"axle\":100,\"fuel\":100,\"clutch\":100,\"radiator\":100,\"brakes\":100}', 0, 0, 0, 0),
- (13, 'license:7c6d790889bab7b0a0b8f4e4c1d81dbfe9516f90', 'UGE35348', 'tribike3', '-400295096', '{\"modExhaust\":-1,\"modDashboard\":-1,\"modStruts\":-1,\"modHorns\":-1,\"interiorColor\":0,\"plateIndex\":4,\"modAerials\":-1,\"modTransmission\":-1,\"modTrunk\":-1,\"modSmokeEnabled\":false,\"oilLevel\":0.0,\"wheelWidth\":0.0,\"modSpoilers\":-1,\"modFrontBumper\":-1,\"modOrnaments\":-1,\"color1\":132,\"fuelLevel\":100.08535757525947,\"xenonColor\":255,\"modSpeakers\":-1,\"modDial\":-1,\"modKit19\":-1,\"tireBurstCompletely\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"wheelColor\":156,\"modBrakes\":-1,\"extras\":[],\"modCustomTiresF\":false,\"modXenon\":false,\"engineHealth\":1000.0592475178704,\"modCustomTiresR\":false,\"modKit21\":-1,\"modWindows\":-1,\"model\":-400295096,\"tireHealth\":{\"1\":1000.0,\"2\":0.0,\"3\":0.0,\"0\":1000.0},\"windowStatus\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"6\":false,\"7\":false,\"0\":false},\"modAPlate\":-1,\"modFrame\":-1,\"liveryRoof\":-1,\"modVanityPlate\":-1,\"modRightFender\":-1,\"modTrimA\":-1,\"modKit47\":-1,\"modEngine\":-1,\"modHood\":-1,\"dirtLevel\":6.35462587779425,\"modFender\":-1,\"modSuspension\":-1,\"doorStatus\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"modKit49\":-1,\"neonColor\":[255,0,255],\"neonEnabled\":[false,false,false,false],\"modArmor\":-1,\"modLivery\":-1,\"tireBurstState\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"color2\":132,\"modBackWheels\":-1,\"plate\":\"4UK308JV\",\"modTank\":-1,\"modTurbo\":false,\"wheelSize\":0.0,\"modHydrolic\":-1,\"modEngineBlock\":-1,\"pearlescentColor\":132,\"modSteeringWheel\":-1,\"bodyHealth\":1000.0592475178704,\"dashboardColor\":0,\"modTrimB\":-1,\"modGrille\":-1,\"tyreSmokeColor\":[255,255,255],\"modArchCover\":-1,\"modSideSkirt\":-1,\"modDoorSpeaker\":-1,\"tankHealth\":1000.0592475178704,\"modAirFilter\":-1,\"modKit17\":-1,\"wheels\":6,\"modRearBumper\":-1,\"modSeats\":-1,\"modPlateHolder\":-1,\"modFrontWheels\":-1,\"windowTint\":-1,\"modRoof\":-1,\"modShifterLeavers\":-1}', '4UK308JV', NULL, 'pillboxgarage', 100, 1000, 1000, 1, 0, NULL, NULL, 0, 0, 0, 0),
- (14, 'license:3478ecef433d5217ca21145b2bfb0e728b8724b0', 'SSL19978', 'polgauntlet', '-1233767450', '{\"neonEnabled\":[false,false,false,false],\"liveryRoof\":-1,\"modSuspension\":-1,\"modPlateHolder\":-1,\"modSeats\":-1,\"windowStatus\":{\"1\":true,\"2\":true,\"3\":true,\"4\":false,\"5\":false,\"6\":true,\"7\":true,\"0\":true},\"modKit49\":-1,\"modCustomTiresF\":false,\"modTrimB\":-1,\"wheelSize\":0.0,\"modWindows\":-1,\"modFrame\":-1,\"modKit21\":-1,\"modStruts\":-1,\"modBrakes\":-1,\"modFender\":-1,\"engineHealth\":1000.0592475178704,\"modRoof\":-1,\"wheels\":0,\"modAPlate\":-1,\"modSteeringWheel\":-1,\"modAirFilter\":-1,\"modSpoilers\":-1,\"modVanityPlate\":-1,\"interiorColor\":2,\"modHood\":-1,\"xenonColor\":255,\"modCustomTiresR\":false,\"modShifterLeavers\":-1,\"modTrimA\":-1,\"tankHealth\":1000.0592475178704,\"modHydrolic\":-1,\"modEngineBlock\":-1,\"doorStatus\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"modBackWheels\":-1,\"color1\":0,\"modExhaust\":-1,\"plateIndex\":4,\"modSideSkirt\":-1,\"modDashboard\":-1,\"modEngine\":-1,\"modKit47\":-1,\"modOrnaments\":-1,\"oilLevel\":4.76596940834568,\"modSmokeEnabled\":false,\"tyreSmokeColor\":[255,255,255],\"modTurbo\":false,\"modLivery\":-1,\"fuelLevel\":65.13491524739108,\"tireHealth\":{\"1\":1000.0,\"2\":1000.0,\"3\":1000.0,\"0\":1000.0},\"pearlescentColor\":0,\"modFrontWheels\":-1,\"dashboardColor\":0,\"modRightFender\":-1,\"modRearBumper\":-1,\"neonColor\":[255,0,255],\"extras\":{\"2\":false,\"3\":false,\"4\":true,\"1\":false},\"modKit19\":-1,\"plate\":\"69DDL280\",\"modGrille\":-1,\"dirtLevel\":8.73761058196709,\"wheelColor\":0,\"modHorns\":-1,\"modArmor\":-1,\"model\":-1233767450,\"windowTint\":-1,\"modSpeakers\":-1,\"modFrontBumper\":-1,\"bodyHealth\":1000.0592475178704,\"color2\":111,\"modAerials\":-1,\"modTrunk\":-1,\"tireBurstCompletely\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"modDial\":-1,\"modKit17\":-1,\"tireBurstState\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"modArchCover\":-1,\"modXenon\":false,\"wheelWidth\":0.0,\"modDoorSpeaker\":-1,\"modTransmission\":-1,\"modTank\":-1}', '69DDL280', NULL, 'Alta Garage', 100, 1000, 1000, 1, 0, NULL, '{\"axle\":98,\"radiator\":100,\"fuel\":100,\"clutch\":100,\"brakes\":100}', 0, 0, 0, 0),
- (15, 'license:3478ecef433d5217ca21145b2bfb0e728b8724b0', 'SSL19978', 'landstalker2', '-838099166', '{\"modFrame\":-1,\"dashboardColor\":0,\"modSmokeEnabled\":false,\"tireHealth\":{\"1\":1000.0,\"2\":1000.0,\"3\":1000.0,\"0\":1000.0},\"color1\":1,\"modAerials\":-1,\"engineHealth\":1000.0592475178704,\"tireBurstCompletely\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"modFrontBumper\":-1,\"windowTint\":-1,\"tankHealth\":999.2649192831461,\"wheelSize\":1.0,\"oilLevel\":4.76596940834568,\"modAirFilter\":-1,\"wheels\":3,\"modSpeakers\":-1,\"color2\":120,\"neonColor\":[255,0,255],\"modDashboard\":-1,\"modTransmission\":-1,\"tireBurstState\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"xenonColor\":255,\"modTank\":-1,\"modArchCover\":-1,\"modRearBumper\":-1,\"modHood\":-1,\"wheelWidth\":1.0,\"modPlateHolder\":-1,\"wheelColor\":156,\"modShifterLeavers\":-1,\"modRoof\":-1,\"modKit17\":-1,\"modXenon\":false,\"modEngineBlock\":-1,\"modArmor\":-1,\"modLivery\":-1,\"modFender\":-1,\"interiorColor\":0,\"modTrimA\":-1,\"modTurbo\":false,\"model\":-838099166,\"neonEnabled\":[false,false,false,false],\"modStruts\":-1,\"modOrnaments\":-1,\"extras\":[],\"modEngine\":-1,\"modGrille\":-1,\"modFrontWheels\":-1,\"modSuspension\":-1,\"liveryRoof\":-1,\"fuelLevel\":97.70237287108663,\"modSeats\":-1,\"modSpoilers\":-1,\"modDial\":-1,\"modHydrolic\":-1,\"modExhaust\":-1,\"modKit19\":-1,\"plateIndex\":0,\"pearlescentColor\":4,\"modVanityPlate\":-1,\"modCustomTiresF\":false,\"modKit21\":-1,\"tyreSmokeColor\":[255,255,255],\"modKit49\":-1,\"windowStatus\":{\"1\":true,\"2\":true,\"3\":true,\"4\":true,\"5\":true,\"6\":true,\"7\":true,\"0\":true},\"modDoorSpeaker\":-1,\"modCustomTiresR\":false,\"modWindows\":-1,\"dirtLevel\":2.38298470417284,\"doorStatus\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"plate\":\"83LMP166\",\"modSteeringWheel\":-1,\"bodyHealth\":992.9102934053518,\"modTrimB\":-1,\"modSideSkirt\":-1,\"modHorns\":-1,\"modTrunk\":-1,\"modAPlate\":-1,\"modBrakes\":-1,\"modRightFender\":-1,\"modKit47\":-1,\"modBackWheels\":-1}', '83LMP166', NULL, 'bennys', 98, 1001, 993, 1, 0, NULL, '{\"axle\":100,\"radiator\":100,\"fuel\":100,\"clutch\":100,\"brakes\":100}', 0, 0, 0, 0),
- (16, 'license:3478ecef433d5217ca21145b2bfb0e728b8724b0', 'SSL19978', 'rancherxl', '1645267888', '{\"modFrame\":-1,\"dashboardColor\":0,\"modSmokeEnabled\":false,\"tireHealth\":{\"1\":987.7645263671875,\"2\":999.75,\"3\":999.25,\"0\":998.75},\"color1\":82,\"modAerials\":-1,\"engineHealth\":921.4207522801665,\"tireBurstCompletely\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"modFrontBumper\":-1,\"windowTint\":-1,\"tankHealth\":3993.088035958963,\"wheelSize\":1.0,\"oilLevel\":4.76596940834568,\"modAirFilter\":-1,\"wheels\":4,\"modSpeakers\":-1,\"color2\":0,\"neonColor\":[255,0,255],\"modDashboard\":-1,\"modTransmission\":2,\"tireBurstState\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"xenonColor\":255,\"modTank\":-1,\"modArchCover\":-1,\"modRearBumper\":-1,\"modHood\":-1,\"wheelWidth\":1.0,\"modPlateHolder\":-1,\"wheelColor\":156,\"modShifterLeavers\":-1,\"modRoof\":-1,\"modKit17\":-1,\"modXenon\":false,\"modEngineBlock\":-1,\"modArmor\":-1,\"modLivery\":-1,\"modFender\":-1,\"interiorColor\":119,\"modTrimA\":-1,\"modTurbo\":1,\"model\":1645267888,\"neonEnabled\":[false,false,false,false],\"modStruts\":-1,\"modOrnaments\":-1,\"extras\":{\"12\":true,\"11\":true,\"10\":false},\"modEngine\":3,\"modGrille\":-1,\"modFrontWheels\":-1,\"modSuspension\":3,\"liveryRoof\":-1,\"fuelLevel\":72.28386935990962,\"modSeats\":-1,\"modSpoilers\":-1,\"modDial\":-1,\"modHydrolic\":-1,\"modExhaust\":-1,\"modKit19\":-1,\"plateIndex\":3,\"pearlescentColor\":19,\"modVanityPlate\":-1,\"modCustomTiresF\":false,\"modKit21\":-1,\"tyreSmokeColor\":[255,255,255],\"modKit49\":-1,\"windowStatus\":{\"1\":true,\"2\":true,\"3\":true,\"4\":false,\"5\":false,\"6\":true,\"7\":true,\"0\":true},\"modDoorSpeaker\":-1,\"modCustomTiresR\":false,\"modWindows\":-1,\"dirtLevel\":0.0,\"doorStatus\":{\"1\":false,\"2\":false,\"3\":false,\"4\":false,\"5\":false,\"0\":false},\"plate\":\"02TUX087\",\"modSteeringWheel\":-1,\"bodyHealth\":933.3356758010307,\"modTrimB\":-1,\"modSideSkirt\":-1,\"modHorns\":57,\"modTrunk\":-1,\"modAPlate\":-1,\"modBrakes\":2,\"modRightFender\":-1,\"modKit47\":-1,\"modBackWheels\":-1}', '02TUX087', NULL, 'pillboxgarage', 73, 922, 934, 1, 0, NULL, '{\"axle\":98,\"radiator\":100,\"fuel\":94,\"clutch\":100,\"brakes\":100}', 0, 0, 0, 0);
- -- --------------------------------------------------------
- --
- -- Table structure for table `player_warns`
- --
- CREATE TABLE `player_warns` (
- `id` INT(11) NOT NULL,
- `senderIdentifier` VARCHAR(50) DEFAULT NULL,
- `targetIdentifier` VARCHAR(50) DEFAULT NULL,
- `reason` text DEFAULT NULL,
- `warnId` VARCHAR(50) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `properties`
- --
- CREATE TABLE `properties` (
- `property_id` INT(11) NOT NULL,
- `owner_citizenid` VARCHAR(50) DEFAULT NULL,
- `street` VARCHAR(100) DEFAULT NULL,
- `region` VARCHAR(100) DEFAULT NULL,
- `description` longtext DEFAULT NULL,
- `has_access` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT json_array() CHECK (json_valid(`has_access`)),
- `extra_imgs` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT json_array() CHECK (json_valid(`extra_imgs`)),
- `furnitures` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT json_array() CHECK (json_valid(`furnitures`)),
- `for_sale` tinyint(1) NOT NULL DEFAULT 1,
- `price` INT(11) NOT NULL DEFAULT 0,
- `shell` VARCHAR(50) NOT NULL,
- `apartment` VARCHAR(50) DEFAULT NULL,
- `door_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`door_data`)),
- `garage_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`garage_data`))
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `renzu_tuner`
- --
- CREATE TABLE `renzu_tuner` (
- `id` INT(11) NOT NULL,
- `plate` VARCHAR(60) DEFAULT NULL,
- `mileages` INT(11) DEFAULT 0,
- `vehiclestats` longtext DEFAULT NULL,
- `defaulthandling` longtext DEFAULT NULL,
- `vehicleupgrades` longtext DEFAULT NULL,
- `vehicletires` longtext DEFAULT NULL,
- `drivetrain` VARCHAR(60) DEFAULT NULL,
- `advancedflags` longtext DEFAULT NULL,
- `ecu` longtext DEFAULT NULL,
- `nodegrade` INT(11) DEFAULT 0,
- `currentengine` VARCHAR(60) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- --
- -- Dumping data for table `renzu_tuner`
- --
- INSERT INTO `renzu_tuner` (`id`, `plate`, `mileages`, `vehiclestats`, `defaulthandling`, `vehicleupgrades`, `vehicletires`, `drivetrain`, `advancedflags`, `ecu`, `nodegrade`, `currentengine`) VALUES
- (1, '3PM529YQ', 167, '{\"engine_fuelinjector\":100.01614089772107,\"engine_camshaft\":100.02625000000004,\"engine_connectingrods\":100.0088061255962,\"engine_pistons\":99.98870994210248,\"oem_suspension\":99.59332098431888,\"oem_brakes\":99.3925514698029,\"engine_flywheel\":100.0125114565343,\"transmition_clutch\":99.6335562860966,\"engine_sparkplug\":99.63629229016606,\"engine_airfilter\":100.06000000000003,\"oem_gearbox\":99.65500000000003,\"engine_valves\":98.83859622463587,\"engine_gasket\":99.63703539818528,\"engine_block\":100.06000000000003,\"engine_crankshaft\":100.03093024015429,\"engine_oil\":100.02625000000004}', '{\"fSuspensionRaise\":0,\"fTractionCurveMin\":1.79999995231628,\"fDriveInertia\":1,\"fHandBrakeForce\":0.80000001192092,\"fSuspensionLowerLimit\":-0.14000000059604,\"fTractionCurveMax\":2.25,\"fRollCentreHeightFront\":0.20000000298023,\"fSuspensionReboundDamp\":1.29999995231628,\"fTractionCurveLateral\":22.5,\"fSuspensionBiasFront\":0.47999998927116,\"fClutchChangeRateScaleUpShift\":1.89999997615814,\"fAntiRollBarBiasFront\":0.57499998807907,\"fSuspensionUpperLimit\":0.11999999731779,\"fAntiRollBarForce\":0.40000000596046,\"nInitialDriveGears\":4,\"fRollCentreHeightRear\":0.20000000298023,\"fInitialDriveMaxFlatVel\":140,\"fClutchChangeRateScaleDownShift\":1.89999997615814,\"fTractionLossMult\":1,\"fSuspensionForce\":2.20000004768371,\"fInitialDriveForce\":0.27000001072883,\"fLowSpeedTractionLossMult\":1.29999995231628,\"fBrakeForce\":0.80000001192092,\"fSuspensionCompDamp\":0.80000007152557}', '[]', NULL, NULL, NULL, NULL, 0, NULL),
- (2, '9DK850PC', 11, '{\"oem_brakes\":100.01,\"engine_connectingrods\":100.01,\"oem_suspension\":100.01,\"engine_valves\":100.01,\"engine_fuelinjector\":100.01,\"engine_block\":100.01,\"transmition_clutch\":100.01,\"engine_camshaft\":99.98535887233914,\"oem_gearbox\":100.01,\"engine_gasket\":100.01,\"engine_oil\":100.01,\"engine_sparkplug\":100.01,\"engine_pistons\":100.01,\"engine_flywheel\":100.01,\"engine_crankshaft\":100.01,\"engine_airfilter\":99.98402610749007}', '{\"fSuspensionForce\":2.29999995231628,\"fSuspensionBiasFront\":0.5,\"fLowSpeedTractionLossMult\":1,\"fHandBrakeForce\":0.60000002384185,\"fTractionCurveMin\":2.34999990463256,\"fTractionCurveLateral\":22.5,\"fDriveInertia\":1,\"fRollCentreHeightFront\":0.31999999284744,\"fAntiRollBarBiasFront\":0.44999998807907,\"fInitialDriveForce\":0.30000001192092,\"fSuspensionLowerLimit\":-0.10000000149011,\"fSuspensionUpperLimit\":0.05000000074505,\"fClutchChangeRateScaleDownShift\":1.89999997615814,\"fClutchChangeRateScaleUpShift\":1.89999997615814,\"fInitialDriveMaxFlatVel\":145,\"fTractionCurveMax\":2.5,\"fSuspensionRaise\":0,\"fAntiRollBarForce\":0.69999998807907,\"fBrakeForce\":0.89999997615814,\"fSuspensionCompDamp\":1.79999995231628,\"fRollCentreHeightRear\":0.33000001311302,\"nInitialDriveGears\":5,\"fTractionLossMult\":1,\"fSuspensionReboundDamp\":2.09999990463256}', '[]', NULL, NULL, NULL, NULL, 0, NULL),
- (3, '86AHL419', 0, '[]', '{\"fRollCentreHeightRear\":0.18250000476837,\"fSuspensionBiasFront\":0.49000000953674,\"fInitialDriveMaxFlatVel\":220.95001220703126,\"fClutchChangeRateScaleDownShift\":8.89999961853027,\"fBrakeForce\":1.54999995231628,\"fTractionCurveLateral\":22.5,\"fAntiRollBarForce\":0.92500001192092,\"fInitialDriveForce\":0.38449999690055,\"fTractionCurveMin\":2.41000008583068,\"fLowSpeedTractionLossMult\":1.14999997615814,\"fTractionCurveMax\":2.58500003814697,\"fTractionLossMult\":1,\"fSuspensionForce\":2.20000004768371,\"fSuspensionReboundDamp\":1.89999997615814,\"fSuspensionUpperLimit\":0.15000000596046,\"fRollCentreHeightFront\":0.21899999678134,\"fSuspensionRaise\":0.07500000298023,\"fDriveInertia\":1,\"fSuspensionCompDamp\":2.29999995231628,\"fSuspensionLowerLimit\":-0.10000000149011,\"fClutchChangeRateScaleUpShift\":10.89999961853027,\"fHandBrakeForce\":0.625,\"nInitialDriveGears\":6,\"fAntiRollBarBiasFront\":0.37999999523162}', '[]', NULL, NULL, NULL, NULL, 0, NULL),
- (4, '80PIP283', 11, '{\"transmition_clutch\":100.01,\"engine_oil\":100.01,\"engine_flywheel\":100.01,\"engine_pistons\":100.01,\"engine_camshaft\":100.01,\"engine_fuelinjector\":100.01,\"engine_crankshaft\":100.01,\"oem_gearbox\":100.01,\"oem_brakes\":100.01,\"engine_valves\":100.01,\"engine_connectingrods\":100.01,\"engine_block\":100.01,\"engine_airfilter\":100.01,\"engine_sparkplug\":100.01,\"oem_suspension\":100.01,\"engine_gasket\":100.01}', '{\"fRollCentreHeightRear\":0.60000002384185,\"fSuspensionBiasFront\":0.44999998807907,\"fInitialDriveMaxFlatVel\":235,\"fClutchChangeRateScaleDownShift\":4.80000019073486,\"fBrakeForce\":0.60000002384185,\"fTractionCurveLateral\":19,\"fAntiRollBarForce\":0.89999997615814,\"fInitialDriveForce\":0.20000000298023,\"fTractionCurveMin\":1.64999997615814,\"fLowSpeedTractionLossMult\":1.5,\"fTractionCurveMax\":2,\"fTractionLossMult\":0.20000000298023,\"fSuspensionForce\":1.20000004768371,\"fSuspensionReboundDamp\":1.20000004768371,\"fSuspensionUpperLimit\":0.15999999642372,\"fRollCentreHeightFront\":0.6700000166893,\"fSuspensionRaise\":0,\"fDriveInertia\":0.5,\"fSuspensionCompDamp\":1.20000004768371,\"fSuspensionLowerLimit\":-0.15999999642372,\"fClutchChangeRateScaleUpShift\":4.80000019073486,\"fHandBrakeForce\":0.31999999284744,\"nInitialDriveGears\":7,\"fAntiRollBarBiasFront\":0.56000000238418}', '[]', NULL, NULL, NULL, NULL, 0, NULL),
- (5, '69DDL280', 0, '[]', '{\"fInitialDriveMaxFlatVel\":155,\"fClutchChangeRateScaleDownShift\":1.89999997615814,\"fSuspensionLowerLimit\":-0.10000000149011,\"fTractionLossMult\":1,\"fSuspensionRaise\":0,\"fRollCentreHeightFront\":0.14000000059604,\"fSuspensionUpperLimit\":0.05000000074505,\"fSuspensionForce\":2.29999995231628,\"fTractionCurveMax\":2.34999990463256,\"fRollCentreHeightRear\":0.15999999642372,\"fBrakeForce\":0.89999997615814,\"nInitialDriveGears\":5,\"fClutchChangeRateScaleUpShift\":1.89999997615814,\"fTractionCurveMin\":2.09999990463256,\"fInitialDriveForce\":0.36000001430511,\"fAntiRollBarBiasFront\":0.44999998807907,\"fSuspensionReboundDamp\":2.09999990463256,\"fSuspensionCompDamp\":1.79999995231628,\"fLowSpeedTractionLossMult\":0.40000000596046,\"fTractionCurveLateral\":22.5,\"fHandBrakeForce\":0.60000002384185,\"fAntiRollBarForce\":0.69999998807907,\"fSuspensionBiasFront\":0.5,\"fDriveInertia\":1}', '[]', NULL, NULL, NULL, NULL, 0, NULL);
- -- --------------------------------------------------------
- --
- -- Table structure for table `stashitems`
- --
- CREATE TABLE `stashitems` (
- `id` INT(11) NOT NULL,
- `stash` VARCHAR(255) NOT NULL DEFAULT '[]',
- `items` longtext DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- --
- -- Dumping data for table `stashitems`
- --
- INSERT INTO `stashitems` (`id`, `stash`, `items`) VALUES
- (1, 'apartment18123', '[]'),
- (2, 'tray', '[]'),
- (3, 'tray', '[]'),
- (4, 'tray', '[]'),
- (5, 'tray', '[]'),
- (6, 'tray2', '[]'),
- (7, 'storge2', '[{\"name\":\"burgershot_bread\",\"slot\":1,\"weight\":100,\"label\":\"Bread\",\"useable\":true,\"image\":\"burgershot_bread.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_sauce\",\"slot\":2,\"weight\":100,\"label\":\"Sauce\",\"useable\":true,\"image\":\"burgershot_sauce.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_tomato\",\"slot\":3,\"weight\":100,\"label\":\"Tomato\",\"useable\":true,\"image\":\"burgershot_tomato.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_cheddar\",\"slot\":4,\"weight\":100,\"label\":\"Cheddar\",\"useable\":true,\"image\":\"burgershot_cheddar.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_curly\",\"slot\":5,\"weight\":100,\"label\":\"Curly\",\"useable\":true,\"image\":\"burgershot_curly.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_icecreamcone\",\"slot\":6,\"weight\":100,\"label\":\"Empty Cone\",\"useable\":true,\"image\":\"burgershot_icecreamcone.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_lavash\",\"slot\":7,\"weight\":100,\"label\":\"Lavash\",\"useable\":true,\"image\":\"burgershot_lavash.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_bigcardboard\",\"slot\":8,\"weight\":100,\"label\":\"Big Size Cardboard\",\"useable\":true,\"image\":\"burgershot_bigcardboard.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_icecreamcone\",\"slot\":9,\"weight\":100,\"label\":\"Empty Cone\",\"useable\":true,\"image\":\"burgershot_icecreamcone.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"},{\"name\":\"burgershot_icecreamcone\",\"slot\":10,\"weight\":100,\"label\":\"Empty Cone\",\"useable\":true,\"image\":\"burgershot_icecreamcone.png\",\"amount\":1,\"unique\":true,\"info\":[],\"type\":\"item\"}]'),
- (8, 'apartment14670', '[]'),
- (9, 'apartment14670', '[]'),
- (10, 'boss_taxi', '[]'),
- (13, 'apartment1707', '[]'),
- (14, 'apartment1707', '[{\"amount\":1,\"created\":1714155191,\"info\":{\"quality\":100},\"useable\":true,\"weight\":1,\"type\":\"item\",\"name\":\"lspdbadge\",\"image\":\"lspdbadge.png\",\"slot\":1,\"label\":\"Police Badge\",\"unique\":false},{\"amount\":1,\"created\":1714155818,\"info\":{\"quality\":100},\"useable\":true,\"weight\":0,\"type\":\"item\",\"name\":\"lawyerpass\",\"image\":\"lawyerpass.png\",\"slot\":2,\"label\":\"Lawyer Pass\",\"unique\":true}]'),
- (15, 'apartment1707', '[]'),
- (16, 'apartment1707', '[]'),
- (17, '1', '[]');
- -- --------------------------------------------------------
- --
- -- Table structure for table `trunkitems`
- --
- CREATE TABLE `trunkitems` (
- `id` INT(11) NOT NULL,
- `plate` VARCHAR(8) NOT NULL DEFAULT '[]',
- `items` longtext DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement