Etape 3

Ajout du SQL

Voici les tables SQL à ajouter dans votre base de données.


Insert tables SQL

ahero_classement_reports.sql
CREATE TABLE `ahero_classement_reports` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `license` varchar(50) NOT NULL,
  `points` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

ALTER TABLE `ahero_classement_reports`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `ahero_classement_reports`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;
ahero_ranks.sql
CREATE TABLE `ahero_ranks` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL COMMENT 'Nom du grade',
  `label` varchar(255) NOT NULL COMMENT 'Nom d''affichage du grade',
  `color` varchar(150) NOT NULL COMMENT 'Couleur d''affichage du grade',
  `indexColor` text NOT NULL COMMENT 'index color tenue staff',
  `permissions` longtext NOT NULL COMMENT 'permissions du grade'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `ahero_ranks` (`id`, `name`, `label`, `color`, `indexColor`, `permissions`) VALUES
(1, 'user', 'Utilisateurs', '~m~', '8', '[]'),
(2, 'fonda', 'Fondateur', '~r~', '5', '[\"admin.remove_warns\",\"admin.afficher_blips\",\"admin.spectate_player\",\"admin.rename_warns\",\"admin.menu_change_color_rank\",\"admin.acces_jails\",\"admin.gestion_bans\",\"admin.super_sprint\",\"admin.acces_staffs\",\"admin.bans_staffs\",\"admin.teleportation_player\",\"admin.menu_create_rank\",\"admin.inventory_add_ammo\",\"admin.gestion_ranks\",\"admin.menu_delete_rank\",\"admin.afficher_noms\",\"admin.acces_reports\",\"admin.menu_dv_radius\",\"admin.setgroup\",\"admin.acces_moi_meme\",\"admin.bans_remove\",\"admin.bans_rename\",\"admin.action_player\",\"admin.bans_player\",\"admin.inventory_remove_items\",\"admin.remboursement_player\",\"admin.acces_players\",\"admin.envoie_message\",\"admin.menu_modifie_permissions_rank\",\"admin.super_jump\",\"admin.invincible_anti_carkill\",\"admin.inventory_remove_ammo\",\"admin.inventory_remove_weapon\",\"admin.passe_annonce\",\"admin.no_clips\",\"admin.bans\",\"admin.setjob_player\",\"admin.send_warns\",\"admin.freeze_player\",\"admin._menu_gestion_deban\",\"admin.open\",\"admin.menu_clear_pnj_props\",\"admin.repair_vehicule\",\"admin.warns\",\"admin.teleport_marker\",\"admin.look_inventory\",\"admin.jail_player\",\"admin.jail_send_player\",\"admin.gestion_classement\",\"admin.gestion_classement_remove\",\"admin.jail_remove_player\"]'),
(3, 'mod', 'Modérateur', '~b~', '6', '[\"admin.acces_moi_meme\",\"admin.action_player\",\"admin.menu_clear_pnj_props\",\"admin.teleportation_player\",\"admin.menu_dv_radius\",\"admin.acces_players\",\"admin.envoie_message\",\"admin.open\",\"admin.spectate_player\",\"admin.freeze_player\",\"admin.passe_annonce\",\"admin.gestion_bans\",\"admin.acces_reports\",\"admin.setjob_player\",\"admin.teleport_marker\",\"admin.bans\",\"admin.send_warns\",\"admin.warns\",\"admin.no_clips\",\"admin.look_inventory\",\"admin.repair_vehicule\",\"admin.invincible_anti_carkill\",\"admin.afficher_noms\"]'),
(4, 'admin', 'Administrateurs', '~o~', '2', '[\"admin.acces_staffs\",\"admin.remboursement_player\",\"admin.setjob_player\",\"admin.bans\",\"admin.inventory_remove_items\",\"admin.acces_players\",\"admin.invincible_anti_carkill\",\"admin.acces_moi_meme\",\"admin.menu_dv_radius\",\"admin.no_clips\",\"admin.open\",\"admin.super_jump\",\"admin.repair_vehicule\",\"admin.bans_rename\",\"admin.afficher_blips\",\"admin.bans_player\",\"admin.bans_remove\",\"admin.freeze_player\",\"admin.remove_warns\",\"admin.rename_warns\",\"admin.warns\",\"admin.afficher_noms\",\"admin.envoie_message\",\"admin.spectate_player\",\"admin.gestion_bans\",\"admin.gestion_ranks\",\"admin.send_warns\",\"admin.look_inventory\",\"admin.super_sprint\",\"admin.inventory_remove_weapon\",\"admin.inventory_add_ammo\",\"admin.teleportation_player\",\"admin.action_player\",\"admin.menu_delete_rank\",\"admin.acces_jails\",\"admin.inventory_remove_ammo\",\"admin.acces_reports\",\"admin.passe_annonce\",\"admin._menu_gestion_deban\",\"admin.teleport_marker\",\"admin.menu_clear_pnj_props\"]'),
(5, 'helpers', 'Helpers', '~w~', '9', '[\"admin.afficher_noms\",\"admin.open\",\"admin.acces_moi_meme\",\"admin.acces_reports\"]'),
(6, 'ahero', 'Team Ahero', '~p~', '4', '[\"admin.jail_remove_player\",\"admin.jail_send_player\",\"admin.jail_player\",\"admin.teleportation_player\",\"admin.acces_staffs\",\"admin.no_clips\",\"admin.menu_dv_radius\",\"admin.passe_annonce\",\"admin.menu_modifie_permissions_rank\",\"admin.menu_clear_pnj_props\",\"admin.menu_change_color_rank\",\"admin.inventory_add_ammo\",\"admin.freeze_player\",\"admin.inventory_remove_weapon\",\"admin.gestion_ranks\",\"admin.super_sprint\",\"admin.acces_players\",\"admin._menu_gestion_deban\",\"admin.envoie_message\",\"admin.acces_moi_meme\",\"admin.bans_player\",\"admin.super_jump\",\"admin.look_inventory\",\"admin.open\",\"admin.menu_delete_rank\",\"admin.warns\",\"admin.bans_remove\",\"admin.inventory_remove_items\",\"admin.bans_rename\",\"admin.acces_reports\",\"admin.bans_staffs\",\"admin.afficher_blips\",\"admin.remove_warns\",\"admin.rename_warns\",\"admin.send_warns\",\"admin.inventory_remove_ammo\",\"admin.remboursement_player\",\"admin.setjob_player\",\"admin.action_player\",\"admin.gestion_bans\",\"admin.repair_vehicule\",\"admin.menu_create_rank\",\"admin.acces_jails\",\"admin.setgroup\",\"admin.teleport_marker\",\"admin.invincible_anti_carkill\",\"admin.bans\",\"admin.afficher_noms\",\"admin.spectate_player\",\"admin.gestion_classement\",\"admin.gestion_classement_remove\"]');

ALTER TABLE `ahero_ranks`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `ahero_ranks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
banlist.sql
CREATE TABLE `banlist` (
  `licenseid` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `playerip` varchar(25) COLLATE utf8mb4_bin DEFAULT NULL,
  `targetName` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL,
  `sourceName` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL,
  `reason` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `timeat` int(11) NOT NULL,
  `expiration` int(11) NOT NULL,
  `permanent` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

ALTER TABLE `banlist`
  ADD PRIMARY KEY (`licenseid`);
COMMIT;
banlisthistory.sql
CREATE TABLE `banlisthistory` (
  `id` int(11) NOT NULL,
  `licenseid` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `playerip` varchar(25) COLLATE utf8mb4_bin DEFAULT NULL,
  `targetName` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `sourceName` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `reason` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `timeat` int(11) NOT NULL,
  `expiration` int(11) NOT NULL,
  `permanent` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

ALTER TABLE `banlisthistory`
  ADD PRIMARY KEY (`id`) USING BTREE;

ALTER TABLE `banlisthistory`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;
COMMIT;
users_info.sql
CREATE TABLE `users_info` (
  `account_id` int(11) NOT NULL,
  `license` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `steam` varchar(22) COLLATE utf8mb4_bin DEFAULT NULL,
  `xbl` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `discord` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `live` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `fivem` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `ip` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
  `guid` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
  `first_connection` timestamp NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

ALTER TABLE `users_info`
  ADD PRIMARY KEY (`account_id`),
  ADD UNIQUE KEY `license` (`license`);

ALTER TABLE `users_info`
  MODIFY `account_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
COMMIT;
users_jails.sql
CREATE TABLE `users_jails` (
  `jail_id` int(11) NOT NULL COMMENT 'Numéro du prisonnier',
  `license` varchar(255) NOT NULL COMMENT 'License du joueur',
  `joueurName` varchar(255) NOT NULL COMMENT 'Nom du joueur',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Status du joueur',
  `time` text NOT NULL COMMENT 'Temps restant en secondes'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

ALTER TABLE `users_jails`
  ADD PRIMARY KEY (`jail_id`);

ALTER TABLE `users_jails`
  MODIFY `jail_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Numéro du prisonnier', AUTO_INCREMENT=1;
users_warns.sql
CREATE TABLE `users_warns` (
  `id` int(11) NOT NULL,
  `identifier` varchar(60) NOT NULL,
  `date` varchar(255) NOT NULL,
  `raison` varchar(255) NOT NULL,
  `playername` varchar(255) NOT NULL,
  `staffname` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `users_warns`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `users_warns`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
COMMIT;

Dernière mise à jour