3.6

Application Release Notes

Version 3.6

New Features:

Appeals Management:

1. New Appeals Section: You can now manage your appeals with the new "Appeals" section in the menu. A badge indicates the number of pending appeals that require your attention.
2. Approve or Reject Appeals: Easily approve or reject appeals directly from the "Appeals" section.
3. Email Notifications: Users will receive email notifications about the status of their appeals (approved or denied).

Reports Management:

1. Report Player: A new "Report Player" option has been added to the menu, allowing you to report players directly.
2. Reports Overview: The "Reports" section provides an overview of all pending reports, making it easier to manage and resolve issues. A badge indicates the number of pending reports.

###Run the below schema if your just upgrading!

DROP TABLE IF EXISTS appeals;
CREATE TABLE `appeals` (
`id` int NOT NULL AUTO_INCREMENT,
`ban_type` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
`steamid` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
`ip` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
`name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
`reason` text COLLATE utf8mb4_general_ci NOT NULL,
`email` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
`status` enum('PENDING','APPROVED','REJECTED') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'PENDING',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

DROP TABLE IF EXISTS reports;
CREATE TABLE `reports` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`ban_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`steamid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ip` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`nickname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`comments` text COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`server_id` bigint unsigned NOT NULL,
`media_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Email Settings:

1. SMTP Configuration: Ensure your email settings are properly configured to send notifications.

Email Settings Configuration

To ensure email notifications are sent correctly, please configure your SMTP settings as follows:

General SMTP Configuration

1. Edit the .env File:

   • Open the .env file in the root directory of your application.
   • Add or update the following lines with your SMTP settings:

   MAIL_MAILER=smtp
   MAIL_HOST=smtp.example.com
   MAIL_PORT=587
   MAIL_USERNAME=your_email@example.com
   MAIL_PASSWORD=your_email_password
   MAIL_ENCRYPTION=tls
   MAIL_FROM_ADDRESS=your_email@example.com
   MAIL_FROM_NAME="Your Application Name"
   

   Replace smtp.example.com with your SMTP server, your_email@example.com with your email address, your_email_password with your email password, and "Your Application Name" with the name of your application.

SendGrid Configuration (You can use any email provider! Sendgrid is used only for demonstration purpose)

If you prefer to use SendGrid for sending emails, follow these steps:

1. Create a SendGrid Account:

   • Sign up for a free account at SendGrid.

2. Generate an API Key:

   • After logging in, navigate to the API Keys section.
   • Create a new API Key with "Full Access" and copy the generated key.

3. Update the .env File:

   • Open the .env file in the root directory of your application.
   • Add or update the following lines with your SendGrid settings:

   MAIL_MAILER=smtp
   MAIL_HOST=smtp.sendgrid.net
   MAIL_PORT=587
   MAIL_USERNAME=apikey
   MAIL_PASSWORD=your_sendgrid_api_key
   MAIL_ENCRYPTION=tls
   MAIL_FROM_ADDRESS=your_verified_sendgrid_email@example.com
   MAIL_FROM_NAME="Your Application Name"
   

   Replace your_sendgrid_api_key with the API key you generated, and your_verified_sendgrid_email@example.com with your verified SendGrid email address.

Installation Docs: https://docs.cssbans.online

Upgrade Guide: https://docs.cssbans.online/how-to-update-panel-to-the-latest-version