API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 6th, 2024
29
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.08 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.9.5
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Hôte : localhost
  6. -- Généré le : sam. 06 avr. 2024 à 20:17
  7. -- Version du serveur : 10.3.39-MariaDB
  8. -- Version de PHP : 7.2.24
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET AUTOCOMMIT = 0;
  12. START TRANSACTION;
  13. SET time_zone = "+00:00";
  14.  
  15.  
  16. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  17. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  18. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  19. /*!40101 SET NAMES utf8mb4 */;
  20.  
  21. --
  22. -- Base de données : `db174693`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Structure de la table `players`
  29. --
  30.  
  31. CREATE TABLE `players` (
  32. `uid` int(11) NOT NULL,
  33. `pid` varchar(17) NOT NULL,
  34. `name` varchar(32) NOT NULL,
  35. `aliases` text NOT NULL,
  36. `cash` int(11) NOT NULL DEFAULT 0,
  37. `bankacc` int(11) NOT NULL DEFAULT 0,
  38. `coplevel` enum('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14') NOT NULL DEFAULT '0',
  39. `mediclevel` enum('0','1','2','3','4','5','6','7','8','9','10','11','12','13') NOT NULL DEFAULT '0',
  40. `civ_licenses` text NOT NULL,
  41. `cop_licenses` text NOT NULL,
  42. `med_licenses` text NOT NULL,
  43. `civ_gear` text NOT NULL,
  44. `cop_gear` text NOT NULL,
  45. `med_gear` text NOT NULL,
  46. `civ_stats` varchar(25) NOT NULL DEFAULT '"[100,100,0]"',
  47. `cop_stats` varchar(25) NOT NULL DEFAULT '"[100,100,0]"',
  48. `med_stats` varchar(25) NOT NULL DEFAULT '"[100,100,0]"',
  49. `arrested` tinyint(4) NOT NULL DEFAULT 0,
  50. `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
  51. `donorlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
  52. `blacklist` tinyint(4) NOT NULL DEFAULT 0,
  53. `civ_alive` tinyint(4) NOT NULL DEFAULT 0,
  54. `civ_position` varchar(32) NOT NULL DEFAULT '"[]"',
  55. `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
  56. `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
  57. `last_seen` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  58. `phone_number` varchar(10) NOT NULL DEFAULT '0',
  59. `contact_list` text DEFAULT NULL,
  60. `sms_value` int(10) NOT NULL DEFAULT 0,
  61. `call_value` int(10) NOT NULL DEFAULT 0
  62. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  63.  
  64. --
  65. -- Déchargement des données de la table `players`
  66. --
  67.  
  68. INSERT INTO `players` (`uid`, `pid`, `name`, `aliases`, `cash`, `bankacc`, `coplevel`, `mediclevel`, `civ_licenses`, `cop_licenses`, `med_licenses`, `civ_gear`, `cop_gear`, `med_gear`, `civ_stats`, `cop_stats`, `med_stats`, `arrested`, `adminlevel`, `donorlevel`, `blacklist`, `civ_alive`, `civ_position`, `playtime`, `insert_time`, `last_seen`, `phone_number`, `contact_list`, `sms_value`, `call_value`) VALUES
  69. (4, '76561198101720341', 'Jay Turner', '\"[`Jay Turner`]\"', 0, 56400, '0', '0', '\"[[`license_civ_driver`,1],[`license_civ_boat`,0],[`license_civ_pilot`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_Moto`,1],[`license_civ_home`,0],[`license_civ_DIR`,0],[`license_civ_PointCocaine`,0],[`license_civ_PointHeroine`,0],[`license_civ_Entreprise1`,0],[`license_civ_Journaliste`,0],[`license_civ_rebel`,0],[`license_civ_bandit`,0]]\"', '\"[]\"', '\"[]\"', '\"[`PULLOVERFF`,``,`V12_BANANE`,`G_Aviator`,`AL_Baseball_Cap_Offwhite`,[`ItemMap`,`ItemCompass`,`tf_microdagr`,`tf_anprc152_1`,`ItemGPS`,`Binocular`],``,``,[],[`16Rnd_9x21_Mag`,`murshun_cigs_matches`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[`H_RacingHelmet_1_white_F`],[],[],[],[``,``,``,``],[``,``,``,``],[[`waterBottle`,3],[`rabbit`,3],[`toolkit`,1]]]\"', '\"[]\"', '\"[]\"', '\"[100,90,0]\"', '\"[100,100,0]\"', '\"[100,100,0]\"', 0, '0', '0', 0, 1, '\"[11618.2,4462.92,0.00143909]\"', '\"[0,0,91]\"', '2024-04-06 17:51:37', '2024-04-06 19:26:39', '0662227174', '\"[[`Police`,`17`],[`Medics`,`18`],[`Emergency`,`112`],[`Repair Man`,`60`],[`Adacs`,`80`]]\"', 50, 3600),
  70. (9, '76561198117419139', 'Mike Brando', '\"[`Mike Brando`]\"', 0, 7000, '0', '0', '\"[]\"', '\"[]\"', '\"[]\"', '\"[]\"', '\"[]\"', '\"[]\"', '\"[100,100,0]\"', '\"[100,100,0]\"', '\"[100,100,0]\"', 0, '0', '0', 0, 1, '\"[10105.8,2137.63,0.00149298]\"', '\"[0,0,0]\"', '2024-04-06 20:08:20', '2024-04-06 20:15:32', '0', '\"[[`Police`,`17`],[`Medics`,`18`],[`Emergency`,`112`],[`Repair Man`,`60`],[`Adacs`,`80`]]\"', 0, 0),
  71. (2, '76561198147871753', 'Mason Zakhaev', '\"[`Mason Zakhaev`]\"', 0, 78971432, '9', '5', '\"[[`license_civ_driver`,0],[`license_civ_boat`,0],[`license_civ_pilot`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_Moto`,1],[`license_civ_home`,1],[`license_civ_DIR`,1],[`license_civ_PointCocaine`,0],[`license_civ_PointHeroine`,0],[`license_civ_Entreprise1`,0],[`license_civ_Journaliste`,0],[`license_civ_rebel`,0],[`license_civ_bandit`,0]]\"', '\"[[`license_cop_cAir`,1],[`license_cop_cg`,1],[`license_cop_Banalise`,1],[`license_cop_EDSR`,1],[`license_cop_PSIG`,1]]\"', '\"[[`license_med_mAir`,0]]\"', '\"[`FLORIDAFF6`,`HOLSTER`,`V12_BANANE`,`G_Aviator`,`PLP_IH_Beard04_black`,[`ItemMap`,`ItemCompass`,`tf_microdagr`,`tf_anprc152_1`,`ItemGPS`,`Binocular`],``,`Max_M9`,[`tf_microdagr`],[`murshun_cigs_lighter`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[`H_RacingHelmet_4_F`],[],[],[],[``,``,``,``],[``,``,``,``],[[`waterBottle`,4],[`rabbit`,3],[`toolkit`,9]]]\"', '\"[`gn_polaire_PSIG_2`,`aka_gn_gilet_70_2cl`,`aka_ceinturon_22`,`avon_fm12`,`Aka_Casque_GN_casque_baisse`,[`ItemMap`,`tf_microdagr`,`tf_anprc152_1`,`ItemGPS`,`Binocular`],`arifle_SPAR_01_blk_F`,``,[`TRYK_kio_balaclava_BLK`],[`SmokeShellBlue`,`SmokeShellBlue`],[],[],[],[`training_pmag_30rnd_rubber_blue`],[`training_attachment_suppressor_alt_blue`,`acc_flashlight`,`optic_Hamr`,``],[``,``,``,``],[[`coffee`,4],[`donuts`,4],[`toolkit`,1]]]\"', '\"[``,``,``,``,``,[`ItemMap`,`ItemCompass`,`Itemwatch`],[],[],[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]\"', '\"[65,55,0.159751]\"', '\"[90,100,0]\"', '\"[100,100,0.0359479]\"', 0, '5', '0', 0, 1, '\"[11615,4462.65,0.00143909]\"', '\"[29,11,202]\"', '2024-03-19 20:15:40', '2024-04-06 19:26:39', '0612514399', '\"[]\"', 550, 17933),
  72. (3, '76561198167931116', 'Roxane LeBonnet', '\"[`Roxane LeBonnet`]\"', 0, 17040716, '6', '13', '\"[[`license_civ_driver`,1],[`license_civ_boat`,1],[`license_civ_pilot`,1],[`license_civ_trucking`,1],[`license_civ_gun`,1],[`license_civ_Moto`,1],[`license_civ_home`,1],[`license_civ_DIR`,1],[`license_civ_PointCocaine`,1],[`license_civ_Entreprise1`,1],[`license_civ_Journaliste`,1],[`license_civ_rebel`,0],[`license_civ_bandit`,1]]\"', '\"[[`license_cop_cAir`,0],[`license_cop_cg`,0],[`license_cop_Banalise`,0],[`license_cop_EDSR`,0],[`license_cop_PSIG`,0]]\"', '\"[[`license_med_mAir`,0]]\"', '\"[`U_I_L_Uniform_01_tshirt_skull_F`,`VESTE_CUIR`,``,``,`H_RacingHelmet_1_black_F`,[`ItemMap`,`ItemCompass`,`tf_microdagr`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[[`pickaxe`,1],[`menottes`,4],[`rabbit`,1],[`toolkit`,2]]]\"', '\"[`U_B_CombatUniform_mcam`,``,``,``,``,[`tf_microdagr`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[[`menottes`,1],[`toolkit`,2]]]\"', '\"[`U_I_CombatUniform`,``,``,``,``,[`tf_microdagr`],[],[],[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]\"', '\"[100,90,0]\"', '\"[100,100,0]\"', '\"[100,100,0]\"', 0, '4', '0', 0, 1, '\"[7462.51,9136.08,0]\"', '\"[66,14,187]\"', '2024-03-28 14:02:52', '2024-03-31 19:56:28', '0636297867', '\"[[`Police`,`17`],[`Medics`,`18`],[`Emergency`,`112`],[`Repair Man`,`60`],[`Adacs`,`80`]]\"', 150, 7200),
  73. (5, '76561198225709644', 'Alexei Zakhaev', '\"[`Alexei Zakhaev`]\"', 0, 5644065, '0', '0', '\"[[`license_civ_driver`,0],[`license_civ_boat`,0],[`license_civ_pilot`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_Moto`,1],[`license_civ_home`,0],[`license_civ_DIR`,0],[`license_civ_PointCocaine`,0],[`license_civ_PointHeroine`,0],[`license_civ_Entreprise1`,0],[`license_civ_Journaliste`,0],[`license_civ_rebel`,0],[`license_civ_bandit`,0]]\"', '\"[]\"', '\"[]\"', '\"[`AL_blue_jacket_supregrey_jumper_grey_jeans_timbs`,``,`V12_BANANE`,`G_Aviator`,``,[`ItemMap`,`ItemCompass`,`Itemwatch`,`tf_anprc152_1`,`ItemGPS`],``,``,[],[`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`,`16Rnd_9x21_Mag`],[`H_RacingHelmet_4_F`],[],[],[],[``,``,``,``],[``,``,``,``],[[`waterBottle`,3],[`rabbit`,3],[`toolkit`,1]]]\"', '\"[]\"', '\"[]\"', '\"[100,100,0]\"', '\"[100,100,0]\"', '\"[100,100,0]\"', 0, '0', '0', 0, 1, '\"[11613.3,4464.36,0.00143909]\"', '\"[0,0,87]\"', '2024-04-06 17:53:22', '2024-04-06 19:26:45', '0', '\"[[`Police`,`17`],[`Medics`,`18`],[`Emergency`,`112`],[`Repair Man`,`60`],[`Adacs`,`80`]]\"', 0, 0),
  74. (6, '76561199519383757', 'Valentin Viper', '\"[`Valentin Viper`]\"', 50505, 540, '2', '0', '\"[[`license_civ_driver`,1],[`license_civ_boat`,0],[`license_civ_pilot`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_Moto`,0],[`license_civ_home`,0],[`license_civ_DIR`,0],[`license_civ_PointCocaine`,0],[`license_civ_PointHeroine`,0],[`license_civ_Entreprise1`,0],[`license_civ_Journaliste`,0],[`license_civ_rebel`,0],[`license_civ_bandit`,0]]\"', '\"[[`license_cop_cAir`,0],[`license_cop_cg`,0],[`license_cop_Banalise`,0],[`license_cop_EDSR`,0],[`license_cop_PSIG`,0]]\"', '\"[]\"', '\"[`U_O_R_Gorka_01_black_F`,``,`B_Carryall_khk`,`G_Aviator`,`H_Booniehat_khk`,[`ItemMap`,`ItemCompass`,`Itemwatch`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]\"', '\"[`gn_polaire_1`,`aka_gn_gilet_67_mdl`,`aka_ceinturon_18`,`G_Aviator`,`Aka_Casque_GN_calot`,[`ItemMap`,`ItemCompass`,`Itemwatch`,`tf_anprc152_1`,`ItemGPS`,`Binocular`],`arifle_SPAR_01_blk_F`,`crow_x26_yellow`,[],[],[`avon_fm12`,`SAN_Headlamp_v1`,`ItemGPS`],[`X26_Cartridge_Blank`,`X26_Cartridge_Blank`,`X26_Cartridge_Blank`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`SmokeShellBlue`,`SmokeShellBlue`,`SmokeShellBlue`,`JCA_HandFlare_Green`,`JCA_HandFlare_Green`],[],[`30Rnd_556x45_Stanag`,`X26_Cartridge_Blank`],[``,`acc_flashlight`,`optic_Hamr`,`bipod_02_F_blk`],[``,``,``,``],[[`spikeStrip`,2],[`menottes`,1],[`redgull`,2],[`coffee`,20],[`donuts`,20],[`toolkit`,2]]]\"', '\"[]\"', '\"[75,65,0]\"', '\"[100,100,0]\"', '\"[100,100,0]\"', 0, '0', '0', 0, 1, '\"[7249.79,7999.08,0.00143433]\"', '\"[10,0,38]\"', '2024-04-06 18:07:49', '2024-04-06 18:57:47', '0654127546', '\"[[`Police`,`17`],[`Medics`,`18`],[`Emergency`,`112`],[`Repair Man`,`60`],[`Adacs`,`80`]]\"', 1100, 36000);
  75.  
  76. --
  77. -- Index pour les tables déchargées
  78. --
  79.  
  80. --
  81. -- Index pour la table `players`
  82. --
  83. ALTER TABLE `players`
  84. ADD PRIMARY KEY (`pid`),
  85. ADD UNIQUE KEY `unique_uid` (`uid`),
  86. ADD KEY `index_name` (`name`),
  87. ADD KEY `index_blacklist` (`blacklist`);
  88.  
  89. --
  90. -- AUTO_INCREMENT pour les tables déchargées
  91. --
  92.  
  93. --
  94. -- AUTO_INCREMENT pour la table `players`
  95. --
  96. ALTER TABLE `players`
  97. MODIFY `uid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
  98. COMMIT;
  99.  
  100. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  101. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  102. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  103.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!