NL-Comserv - Community Service Script

🎯 Overview

NL-Comserv is a standalone FiveM resource for enforcing RolePlay through community service. Staff can assign players cleaning tasks on a remote boat island. Persistent across restarts via MySQL. Includes webhooks, notifications, anti-exploit.

Author: Northline Solutions
Version: 2.0.0
Framework: Standalone (Works on all frameworks)
Dependencies: oxmysql

✨ Features

• Commands: /comserv [id] [amount] [reason], /endcomserv [id], /addcomms [id] [amount] [reason], /changecomms [id] [amount] [reason].
• Tasks: Random cleaning spots (broom prop + animation, 10s each).
• Anti-Cheat: Teleport back if escape (>50 units), disable vehicles/weapons/friendly fire.
• UI: On-screen actions left, sender, reason + Tebex promo.
• Persistence: MySQL tracking by license identifier.
• Logging: Discord webhooks for assignments/changes.
• Auto-Resume: On player spawn/respawn.
• Release: To configurable coords after completion.
• Limits: Max 100 actions per assignment.
• Notifications: Supports mxo-notify (configurable).

📦 Installation & Setup

1. Download oxmysql:

   • Add oxmysql to resources/ and ensure oxmysql in server.cfg (before this resource).

2. Import Database:

   - Open HeidiSQL/phpMyAdmin (connect to your DB).
   - Run `communityservice.sql` (creates `communityservice` table).
   

3. Install Resource:

   - Copy folder to `resources/[NL-Solutions]/NL-Comserv`.
   - Add `ensure NL-Comserv` to `server.cfg` (after oxmysql).
   - Restart server or `refresh` + `start NL-Comserv`.
   

4. Permissions (server.cfg):

   add_ace group.admin pdcomserv allow  # All perms
   # Or separate:
   add_ace group.admin pdcomserv.comserv allow
   add_ace group.admin pdcomserv.endcomserv allow
   add_ace group.admin pdcomserv.addcomms allow
   add_ace group.admin pdcomserv.changecomms allow
   

5. Test:

   • Join as staff, /comserv [yourid] 5 Test.
   • Verify teleport to boat, tasks, DB entry.

⚙️ Configuration

Edit ClientConfig.lua / ServerConfig.lua.

ClientConfig.lua:

ClientConfig.DrawText = { ... }  -- UI text/color
ClientConfig.TextCoordinates...  -- Positions
ClientConfig.releaseCoords = vector3(...)  -- Release location

ServerConfig.lua:

ServerConfig.Permission = { Comserv = 'pdcomserv' }  -- ACE perms
ServerConfig.Webhook = { Comserv = 'your_url' }  -- 4 webhooks
ServerConfig.ComservMaxAmount = 100
ServerConfig.NotificationType = 'mxo-notify:alert'  -- Change if needed
ServerConfig.NotificationTemplate = '...'  -- Chat HTML
ServerConfig.Commands = { Comserv = 'comserv' }  -- Custom commands

Escrow Ignore: Configs/SQL editable.

📋 Commands

Broadcast: Server chat + webhook on actions.

🌊 Locations

• Service Zone: Boat island (~3056.79, -4685.35, 15.26). 8 cleaning spots.
• Release: ClientConfig.releaseCoords (default 2047.1377, 3447.9441, 43.8631).

🗄️ Database

Table: communityservice
Fields: id, identifier (license), actions_remaining, sender_name, comserv_reason.

🔧 Troubleshooting

• 'Permission denied': Restart server after ACE, check perms.
• No teleport/DB: Ensure oxmysql running, DB imported.
• No notifications: Check NotificationType.
• Errors: Check F8/console, ensure Lua54.

💬 Support

• Discord: discord
• Issues: Create ticket or check docs.

Enjoy clean servers! 🧹

Credits

percz.dev Coding Script