Fix - Owner assignment and Steam Id casting

Merge pull request #157 from human416c6578/main

Fixed a bug where on some systems 'users'.steam_id wasn't cast properly

6.2

Release notes V 6.2

CREATE TABLE `admin_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `admin_id` bigint(20) unsigned DEFAULT NULL,
  `admin_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `admin_steam_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target_id` bigint(20) unsigned DEFAULT NULL,
  `target_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target_steam_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` text COLLATE utf8mb4_unicode_ci,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `admin_logs_admin_id_foreign` (`admin_id`),
  CONSTRAINT `admin_logs_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Added ranks listing by TOP TIME played.

6.1 (admin activity logs and more)

Release notes V 6.1

CSS-BANS Admin Panel Release Notes

🚀 New Features

For exisisting panel, create the below table.

CREATE TABLE `admin_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `admin_id` bigint(20) unsigned DEFAULT NULL,
  `admin_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `admin_steam_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target_id` bigint(20) unsigned DEFAULT NULL,
  `target_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target_steam_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` text COLLATE utf8mb4_unicode_ci,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `admin_logs_admin_id_foreign` (`admin_id`),
  CONSTRAINT `admin_logs_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Admin Activity Logs

• Added comprehensive admin activity logging system to track all admin actions
• Implemented a dedicated admin logs page accessible to SuperAdmins
• Logs show detailed information about bans, unbans, mutes, and other admin activities
• Added timeline view for detailed inspection of multi-server actions
• Custom grouping algorithm to consolidate related actions for cleaner display

UI Enhancements

• Added Admin Logs menu link in the Admin section for SuperAdmins only
• Improved navigation structure with organized menu categories
• Enhanced server details display with better formatting

🔧 Bug Fixes

• Fixed incorrect server information display in admin logs
• Fixed error handling for missing database columns
• Fixed syntax error in vertical menu template
• Improved error handling for missing properties in ban details

💻 Technical Improvements

• Added robust database queries to properly join ban data with server information
• Implemented smart server grouping to show actions across multiple servers
• Added intelligent fallback mechanisms to ensure logs display properly even with partial data
• Extended permission checks to secure admin logs access

This update provides administrators with powerful tools to audit admin actions across the entire system, enabling better oversight and accountability.
Full Changelog: 6.0...6.1

5.4 - New Module Demos, VIP changes and Fixes

What's Changed

• fixed a "big" problem by @originalaidn in #136
• demos by @Yeagorn in #138

In order to use the demos you will have to have the following stuff:

CS2 Demo Recorder plugin
CS2 Demo Web server
In order to set up the demo module, head into settings and enable the module then in .env file as the .env.example is updated please make sure to put your BASE link for example http://localhost:2053/ and setup your DB in .env file

Full Changelog: 5.3...5.4

5.3 - Latest SKIN Fixes and Unban Edit Fixes

What's Changed

• translations, fixing some translation, a message at top-right icon, etc by @originalaidn in #118
• add the ability to edit vips using @web/vip permissions by @Yeagorn in #120
• translations & search for name in ranks by @originalaidn in #121
• WeaponPaints module update & VIP / Appeals / Reports / Token changing method / Rank page sorting by @originalaidn in #125
• Feature skins by @hobsRKM in #132
• fixing M4A4 name & adding "default" agent images by @originalaidn in #131
• Update ko.json with improved translations by @wjdrkfka3 in #133
• Feature skins by @hobsRKM in #134

New Contributors

• @Yeagorn made their first contribution in #120
• @wjdrkfka3 made their first contribution in #133

Full Changelog: 4.8...5.3

5.1

Support for latest weapon paints added(SKINS, Stickers etc)

What's Changed

• translations, fixing some translation, a message at top-right icon, etc by @originalaidn in #118
• add the ability to edit vips using @web/vip permissions by @Yeagorn in #120
• translations & search for name in ranks by @originalaidn in #121
• WeaponPaints module update & VIP / Appeals / Reports / Token changing method / Rank page sorting by @originalaidn in #125

New Contributors

• @Yeagorn made their first contribution in #120

Full Changelog: 4.8...5.1_beta

5.0_beta

Beta release for Latest Weapon Paints

!!WARNING this is only beta version to support SKINS latest version!!

4.8

Release notes V 4.8

New Feature

If you are upgrading, then run the below command on mysql on css bans database where panel tables exists

CREATE TABLE `server_player_stats` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `server_id` bigint(20) unsigned NOT NULL,
  `player_count` int(11) NOT NULL,
  `map` varchar(50) NOT NULL,
  `recorded_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8mb4

How to setup cron?
Setup a cron to run this url every 5 minutes which is supported on VPS/shared hosting already

https://yoursite.com/stats/player_count?token=replacehere with token(can be found in .env _token)

Example:

*/5 * * * * `https://yoursite.com/stats/player_count?token=123r48

• Added dashboard charts - Player stats chart and Map Starts Chart
• Added settings to disable or enable emails for reports/appeals
• Improved visual of select drop downs for being too dull for visiblity.
  

4.7

Release notes V 4.7

Major Fixes

• Added Multiserver select on dashboard for RANKS module ie. TOP PLAYERS
• Fix - Changes on timezone i.e last seen, last action duration to adhere to timezone applied form app settings on bans, mutes and admins list
• Fix - Module settings cached even after delete causing ranks module to break for 2 minutes.
• Added user friendly message if a user enables rank module without add database in module settings
• Fix - Deafault knfie image when no image available on rank stats
• Added custom links
• Re-arranged and grouped links on sidebar

!IMPORTANT##

Always ensure ur app timezone and database timezone are same.

Full Changelog: 4.6...4.7

4.6

Release notes V 4.6

New Stats for RANKS (Requires k4 Zenith)

• Added new profile section to view a player ranks stats
• Added PlayTime Stats for RANKS module
• Added Weapon Stats for RANKS module
• Adedd Maps Stats for RANKS module
• Added "Reason" For live Bans, Kicks and Mutes on dashboard
• Added Rank preview of a logged in user on sidebar to profile section

NOTE: The RANK Stats Update is only for the newer version of Zenith From K4.

What's Changed

• fix undefined (last seen) in ranks list by @originalaidn in #116

Full Changelog: 4.5...4.6