Etape 3
Ajout du SQL
Veuillez ajouter le code SQL pour assurer le bon fonctionnement de la ressource.
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